APPS.AMS_RESOURCE_PVT dependencies on JTF_RS_RESOURCE_EXTNS_TL

Line 17: l_resource_name JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE :='AMS_WEB_INTERACTION';

13: l_msg_data VARCHAR2(2000);
14: l_catagory JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE := 'OTHER';
15: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
16: l_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;
17: l_resource_name JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE :='AMS_WEB_INTERACTION';
18: l_source_name JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE :='AMS_WEB_INTERACTION';
19: l_user_name VARCHAR2(100) :='AMSWEBUSER';
20: l_count NUMBER := 0;
21:

Line 24: SELECT count(*) INTO l_count FROM JTF_RS_RESOURCE_EXTNS A,JTF_RS_RESOURCE_EXTNS_TL B

20: l_count NUMBER := 0;
21:
22: BEGIN
23:
24: SELECT count(*) INTO l_count FROM JTF_RS_RESOURCE_EXTNS A,JTF_RS_RESOURCE_EXTNS_TL B
25: WHERE A.source_name = l_source_name and B.resource_name = l_resource_name
26: and A.resource_id = B.resource_id
27: and A.user_name = l_user_name;
28: /*

Line 62: l_resource_name JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE :='AMS_WEB_INTERACTION';

58: PROCEDURE GET_WEB_INTERACTION_RES_ID
59: (X_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE
60: )
61: IS
62: l_resource_name JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE :='AMS_WEB_INTERACTION';
63: l_source_name JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE :='AMS_WEB_INTERACTION';
64: l_user_name VARCHAR2(100) :='AMSWEBUSER';
65: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE := -1;
66:

Line 71: FROM JTF_RS_RESOURCE_EXTNS A,JTF_RS_RESOURCE_EXTNS_TL B

67: BEGIN
68: select 'X' into l_user_name from dual;
69: /*
70: SELECT A.resource_id INTO l_resource_id
71: FROM JTF_RS_RESOURCE_EXTNS A,JTF_RS_RESOURCE_EXTNS_TL B
72: WHERE A.source_name = l_source_name and B.resource_name = l_resource_name
73: and A.resource_id = B.resource_id and A.user_name = l_user_name
74: and rownum < 2;
75: