APPS.IEM_RESOURCE_PVT dependencies on JTF_RS_RESOURCE_EXTNS_TL

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

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 :='ORACLE_PREDICTIVE';
18: l_source_name JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE :='ORACLE_PREDICTIVE';
19: l_user_name VARCHAR2(100) :='IEMDUMMYUSER';
20: l_count NUMBER := 0;
21: BEGIN

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

18: l_source_name JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE :='ORACLE_PREDICTIVE';
19: l_user_name VARCHAR2(100) :='IEMDUMMYUSER';
20: l_count NUMBER := 0;
21: BEGIN
22: SELECT count(*) INTO l_count FROM JTF_RS_RESOURCE_EXTNS A,JTF_RS_RESOURCE_EXTNS_TL B
23: WHERE A.source_name = l_source_name and B.resource_name = l_resource_name
24: and A.resource_id = B.resource_id
25: and A.user_name = l_user_name;
26:

Line 61: l_resource_name JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE :='ORACLE_PREDICTIVE';

57: PROCEDURE GET_PRED_RES_ID
58: (X_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE
59: )
60: IS
61: l_resource_name JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE :='ORACLE_PREDICTIVE';
62: l_source_name JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE :='ORACLE_PREDICTIVE';
63: l_user_name VARCHAR2(100) :='IEMDUMMYUSER';
64: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE := -1;
65: BEGIN

Line 67: FROM JTF_RS_RESOURCE_EXTNS A,JTF_RS_RESOURCE_EXTNS_TL B

63: l_user_name VARCHAR2(100) :='IEMDUMMYUSER';
64: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE := -1;
65: BEGIN
66: SELECT A.resource_id INTO l_resource_id
67: FROM JTF_RS_RESOURCE_EXTNS A,JTF_RS_RESOURCE_EXTNS_TL B
68: WHERE A.source_name = l_source_name and B.resource_name = l_resource_name
69: and A.resource_id = B.resource_id and A.user_name = l_user_name
70: and rownum <2;
71: