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_UM_USERTYPE_CREDENTIALS dependencies on FND_RESPONSIBILITY_VL

Line 299: l_def_resp_key FND_RESPONSIBILITY_VL.RESPONSIBILITY_KEY%TYPE;

295: )
296: IS
297: l_def_resp_id NUMBER;
298: l_def_app_id NUMBER;
299: l_def_resp_key FND_RESPONSIBILITY_VL.RESPONSIBILITY_KEY%TYPE;
300: l_def_resp_name FND_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%TYPE;
301:
302: BEGIN
303: IF Fnd_User_Resp_Groups_Api.Assignment_Exists(

Line 300: l_def_resp_name FND_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%TYPE;

296: IS
297: l_def_resp_id NUMBER;
298: l_def_app_id NUMBER;
299: l_def_resp_key FND_RESPONSIBILITY_VL.RESPONSIBILITY_KEY%TYPE;
300: l_def_resp_name FND_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%TYPE;
301:
302: BEGIN
303: IF Fnd_User_Resp_Groups_Api.Assignment_Exists(
304: user_id => X_USER_ID,

Line 382: FROM FND_RESPONSIBILITY_VL

378: IS
379:
380: p_responsibility_id NUMBER;
381: CURSOR RESP_KEY IS SELECT RESPONSIBILITY_ID
382: FROM FND_RESPONSIBILITY_VL
383: WHERE RESPONSIBILITY_KEY = X_RESPONSIBILITY_KEY;
384: BEGIN
385:
386: OPEN RESP_KEY;

Line 413: FROM FND_RESPONSIBILITY_VL

409: IS
410: p_responsibility_id NUMBER;
411: p_assign_def_resp boolean;
412: CURSOR RESP_KEY IS SELECT RESPONSIBILITY_ID
413: FROM FND_RESPONSIBILITY_VL
414: WHERE RESPONSIBILITY_KEY = X_RESPONSIBILITY_KEY;
415:
416: BEGIN
417:

Line 464: FROM FND_RESPONSIBILITY_VL

460: IS
461:
462: p_responsibility_id NUMBER;
463: CURSOR RESP_KEY_ID IS SELECT RESPONSIBILITY_ID
464: FROM FND_RESPONSIBILITY_VL
465: WHERE RESPONSIBILITY_KEY = X_RESPONSIBILITY_KEY;
466: BEGIN
467:
468: OPEN RESP_KEY_ID;

Line 559: l_version FND_RESPONSIBILITY_VL.VERSION%TYPE;

555: l_procedure_name CONSTANT varchar2(30) := 'ASSIGN_USERTYPE_CREDENTIALS';
556: p_usertype_resp_id number;
557: p_usertype_app_id NUMBER;
558: p_principal_name VARCHAR2(255);
559: l_version FND_RESPONSIBILITY_VL.VERSION%TYPE;
560: l_resp_id number;
561: l_app_id number;
562: l_resp_key FND_RESPONSIBILITY_VL.RESPONSIBILITY_KEY%TYPE;
563: l_resp_name FND_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%TYPE;

Line 562: l_resp_key FND_RESPONSIBILITY_VL.RESPONSIBILITY_KEY%TYPE;

558: p_principal_name VARCHAR2(255);
559: l_version FND_RESPONSIBILITY_VL.VERSION%TYPE;
560: l_resp_id number;
561: l_app_id number;
562: l_resp_key FND_RESPONSIBILITY_VL.RESPONSIBILITY_KEY%TYPE;
563: l_resp_name FND_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%TYPE;
564:
565: userStartDate DATE;
566: userEndDate DATE;

Line 563: l_resp_name FND_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%TYPE;

559: l_version FND_RESPONSIBILITY_VL.VERSION%TYPE;
560: l_resp_id number;
561: l_app_id number;
562: l_resp_key FND_RESPONSIBILITY_VL.RESPONSIBILITY_KEY%TYPE;
563: l_resp_name FND_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%TYPE;
564:
565: userStartDate DATE;
566: userEndDate DATE;
567:

Line 579: FROM JTF_UM_USERTYPE_RESP UT, FND_RESPONSIBILITY_VL FR

575: --added variables for 4287135
576: isDefaultRespPresent boolean :=false;
577:
578: CURSOR USERTYPE_RESP is select FR.RESPONSIBILITY_ID, UT.APPLICATION_ID, FR.VERSION
579: FROM JTF_UM_USERTYPE_RESP UT, FND_RESPONSIBILITY_VL FR
580: WHERE UT.USERTYPE_ID = X_USERTYPE_ID
581: AND FR.APPLICATION_ID = UT.APPLICATION_ID
582: AND FR.RESPONSIBILITY_KEY = UT.RESPONSIBILITY_KEY
583: AND (UT.EFFECTIVE_END_DATE IS NULL OR UT.EFFECTIVE_END_DATE > SYSDATE)

Line 1121: FROM JTF_UM_USERTYPE_RESP UTRESP, FND_RESPONSIBILITY_VL FURESP

1117: ) IS
1118:
1119: l_procedure_name CONSTANT varchar2(30) := 'get_usertype_resp';
1120: CURSOR FIND_UT_RESP IS SELECT UTRESP.APPLICATION_ID, FURESP.RESPONSIBILITY_ID
1121: FROM JTF_UM_USERTYPE_RESP UTRESP, FND_RESPONSIBILITY_VL FURESP
1122: WHERE UTRESP.USERTYPE_ID = p_usertype_id
1123: AND NVL(UTRESP.EFFECTIVE_END_DATE,SYSDATE+1) > SYSDATE
1124: AND UTRESP.EFFECTIVE_START_DATE < SYSDATE
1125: AND UTRESP.RESPONSIBILITY_KEY = FURESP.RESPONSIBILITY_KEY;

Line 1449: FROM FND_RESPONSIBILITY_VL

1445: l_procedure_name CONSTANT varchar2(30) := 'get_default_login_resp';
1446: l_app_id_defined boolean;
1447: l_resp_id_defined boolean;
1448: CURSOR FIND_RESP_INFO IS SELECT RESPONSIBILITY_KEY, RESPONSIBILITY_NAME
1449: FROM FND_RESPONSIBILITY_VL
1450: WHERE RESPONSIBILITY_ID = x_resp_id
1451: AND APPLICATION_ID = x_app_id;
1452:
1453: BEGIN