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.UMX_REGISTRATION_PVT dependencies on FND_USER

Line 10: FROM FND_USER FU, UMX_REG_REQUESTS REG

6:
7: CURSOR FIND_REG_DATA IS
8: SELECT REG.REQUESTED_FOR_USER_ID, FU.USER_NAME, FU.PERSON_PARTY_ID,
9: REG.STATUS_CODE
10: FROM FND_USER FU, UMX_REG_REQUESTS REG
11: WHERE REG.REG_REQUEST_ID = p_reg_request_id
12: AND REG.REQUESTED_FOR_USER_ID = FU.USER_ID;
13:
14: l_user_id UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%TYPE;

Line 15: l_user_name FND_USER.USER_NAME%TYPE;

11: WHERE REG.REG_REQUEST_ID = p_reg_request_id
12: AND REG.REQUESTED_FOR_USER_ID = FU.USER_ID;
13:
14: l_user_id UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%TYPE;
15: l_user_name FND_USER.USER_NAME%TYPE;
16: l_party_id FND_USER.PERSON_PARTY_ID%TYPE;
17: l_status_code UMX_REG_REQUESTS.STATUS_CODE%TYPE;
18: j NUMBER;
19: l_index_to_add NUMBER;

Line 16: l_party_id FND_USER.PERSON_PARTY_ID%TYPE;

12: AND REG.REQUESTED_FOR_USER_ID = FU.USER_ID;
13:
14: l_user_id UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%TYPE;
15: l_user_name FND_USER.USER_NAME%TYPE;
16: l_party_id FND_USER.PERSON_PARTY_ID%TYPE;
17: l_status_code UMX_REG_REQUESTS.STATUS_CODE%TYPE;
18: j NUMBER;
19: l_index_to_add NUMBER;
20:

Line 855: l_requested_for_user_name fnd_user.user_name%type;

851: l_status_code umx_reg_requests.status_code%type;
852: l_requested_start_date umx_reg_requests.requested_start_date%type;
853: l_requested_by_user_id umx_reg_requests.requested_by_user_id%type;
854: l_requested_for_user_id umx_reg_requests.requested_for_user_id%type;
855: l_requested_for_user_name fnd_user.user_name%type;
856: l_requested_for_party_id umx_reg_requests.requested_for_party_id%type;
857: l_requested_username umx_reg_requests.requested_username%type;
858: l_requested_end_date umx_reg_requests.requested_end_date%type;
859: l_wf_role_name umx_reg_requests.wf_role_name%type;

Line 872: cursor get_username_from_userid (l_userid in fnd_user.user_id%type) is

868: l_reg_function_name fnd_form_functions.FUNCTION_NAME%TYPE;
869: l_display_name UMX_REG_SERVICES_VL.DISPLAY_NAME%TYPE;
870: l_description UMX_REG_SERVICES_VL.DESCRIPTION%TYPE;
871:
872: cursor get_username_from_userid (l_userid in fnd_user.user_id%type) is
873: select user_name
874: from fnd_user
875: where user_id = l_userid;
876:

Line 874: from fnd_user

870: l_description UMX_REG_SERVICES_VL.DESCRIPTION%TYPE;
871:
872: cursor get_username_from_userid (l_userid in fnd_user.user_id%type) is
873: select user_name
874: from fnd_user
875: where user_id = l_userid;
876:
877: cursor get_requested_for_party_id (l_userid in fnd_user.user_id%type) is
878: select person_party_id

Line 877: cursor get_requested_for_party_id (l_userid in fnd_user.user_id%type) is

873: select user_name
874: from fnd_user
875: where user_id = l_userid;
876:
877: cursor get_requested_for_party_id (l_userid in fnd_user.user_id%type) is
878: select person_party_id
879: from fnd_user
880: where user_id = l_userid;
881:

Line 879: from fnd_user

875: where user_id = l_userid;
876:
877: cursor get_requested_for_party_id (l_userid in fnd_user.user_id%type) is
878: select person_party_id
879: from fnd_user
880: where user_id = l_userid;
881:
882: BEGIN
883: