Musings by Dr Aarti

exec FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT(17879,
20420,1,0,trunc(sysdate),null,'Adding in ERPDEV');

CREATE OR REPLACE package APPS.get_test
as
FUNCTION open (KEY IN VARCHAR2, VALUE IN VARCHAR2 ) RETURN VARCHAR2;
end ;
/


CREATE OR REPLACE PACKAGE BODY APPS.get_test
AS
FUNCTION open (
KEY IN VARCHAR2
,VALUE IN VARCHAR2
)
RETURN VARCHAR2
AS
LANGUAGE JAVA
NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String';
END get_test;
/