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 840: l_requested_for_user_name fnd_user.user_name%type;

836: l_status_code umx_reg_requests.status_code%type;
837: l_requested_start_date umx_reg_requests.requested_start_date%type;
838: l_requested_by_user_id umx_reg_requests.requested_by_user_id%type;
839: l_requested_for_user_id umx_reg_requests.requested_for_user_id%type;
840: l_requested_for_user_name fnd_user.user_name%type;
841: l_requested_for_party_id umx_reg_requests.requested_for_party_id%type;
842: l_requested_username umx_reg_requests.requested_username%type;
843: l_requested_end_date umx_reg_requests.requested_end_date%type;
844: l_wf_role_name umx_reg_requests.wf_role_name%type;

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

853: l_reg_function_name fnd_form_functions.FUNCTION_NAME%TYPE;
854: l_display_name UMX_REG_SERVICES_VL.DISPLAY_NAME%TYPE;
855: l_description UMX_REG_SERVICES_VL.DESCRIPTION%TYPE;
856:
857: cursor get_username_from_userid (l_userid in fnd_user.user_id%type) is
858: select user_name
859: from fnd_user
860: where user_id = l_userid;
861:

Line 859: from fnd_user

855: l_description UMX_REG_SERVICES_VL.DESCRIPTION%TYPE;
856:
857: cursor get_username_from_userid (l_userid in fnd_user.user_id%type) is
858: select user_name
859: from fnd_user
860: where user_id = l_userid;
861:
862: cursor get_requested_for_party_id (l_userid in fnd_user.user_id%type) is
863: select person_party_id

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

858: select user_name
859: from fnd_user
860: where user_id = l_userid;
861:
862: cursor get_requested_for_party_id (l_userid in fnd_user.user_id%type) is
863: select person_party_id
864: from fnd_user
865: where user_id = l_userid;
866:

Line 864: from fnd_user

860: where user_id = l_userid;
861:
862: cursor get_requested_for_party_id (l_userid in fnd_user.user_id%type) is
863: select person_party_id
864: from fnd_user
865: where user_id = l_userid;
866:
867: BEGIN
868: