eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_ROLE_RELATE_PVT dependencies on JTF_RS_ROLE_RELATIONS_S

Line 225: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

221: P_COMMIT IN VARCHAR2,
222: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
223: P_ROLE_RESOURCE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
224: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
225: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
226: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,
227: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,
228: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,
229: P_ATTRIBUTE3 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE3%TYPE,

Line 258: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;

254: l_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE;
255: l_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE;
256: l_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE;
257: -- added truncate on 12 feb 2002
258: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
259: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
260:
261: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;
262: l_return_code VARCHAR2(100);

Line 259: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;

255: l_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE;
256: l_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE;
257: -- added truncate on 12 feb 2002
258: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
259: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
260:
261: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;
262: l_return_code VARCHAR2(100);
263: l_count NUMBER;

Line 295: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

291:
292: --changed the date comparison in the cursor 07/07/00
293: CURSOR res_role_cur(ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
294: ll_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
295: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
296: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
297: IS
298: SELECT 'X'
299: FROM jtf_rs_role_relations

Line 316: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

312: res_role_rec res_role_cur%rowtype;
313:
314: CURSOR grp_role_cur(ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
315: ll_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
316: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
317: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
318: IS
319: SELECT 'X'
320: FROM jtf_rs_role_relations

Line 892: select jtf_rs_role_relations_s.nextval

888:
889: --dbms_output.put_line ('Debug Message 19');
890:
891: --get the primary key sequence value
892: select jtf_rs_role_relations_s.nextval
893: into l_role_relate_id
894: from dual;
895:
896:

Line 1283: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

1279: (P_API_VERSION IN NUMBER,
1280: P_INIT_MSG_LIST IN VARCHAR2,
1281: P_COMMIT IN VARCHAR2,
1282: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
1283: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
1284: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE,
1285: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
1286: P_ATTRIBUTE1 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE1%TYPE,
1287: P_ATTRIBUTE2 IN JTF_RS_ROLE_RELATIONS.ATTRIBUTE2%TYPE,

Line 1369: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;

1365: l_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE ;
1366: l_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE ;
1367: -- added trunc on 12th feb 2002
1368: /* Moved the initial assignment of below variables to inside begin */
1369: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
1370: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
1371: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;
1372: l_object_version_number JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE;
1373: l_delete_flag JTF_RS_ROLE_RELATIONS.DELETE_FLAG%TYPE ;

Line 1370: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;

1366: l_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE ;
1367: -- added trunc on 12th feb 2002
1368: /* Moved the initial assignment of below variables to inside begin */
1369: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
1370: l_end_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE;
1371: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;
1372: l_object_version_number JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE;
1373: l_delete_flag JTF_RS_ROLE_RELATIONS.DELETE_FLAG%TYPE ;
1374:

Line 1413: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

1409:
1410: --changed the date comparison in the cursor 07/07/00
1411: CURSOR res_role_cur(ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
1412: ll_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
1413: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
1414: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
1415: IS
1416: SELECT 'X'
1417: FROM jtf_rs_role_relations

Line 1433: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

1429: res_role_rec res_role_cur%rowtype;
1430:
1431: CURSOR grp_role_cur(ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
1432: ll_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
1433: ll_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
1434: ll_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE )
1435: IS
1436: SELECT 'X'
1437: FROM jtf_rs_role_relations

Line 2665: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

2661: chk_type_rec chk_type_cur%rowtype;
2662:
2663: CURSOR chk_grp_cur(l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
2664: l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
2665: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
2666: l_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE)
2667: IS
2668: SELECT 'x'
2669: FROM jtf_rs_role_relations rlt,

Line 2684: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

2680: chk_grp_rec chk_grp_cur%rowtype;
2681:
2682: CURSOR chk_team_cur(l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
2683: l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
2684: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
2685: l_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE)
2686: IS
2687: SELECT 'x'
2688: FROM jtf_rs_role_relations rlt,