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 UMX_REG_REQUESTS

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 14: l_user_id UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%TYPE;

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;
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;

Line 17: l_status_code UMX_REG_REQUESTS.STATUS_CODE%TYPE;

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:
21: BEGIN

Line 137: select UMX_REG_REQUESTS_S.nextval into l_item_key from dual;

133: l_event_name := 'oracle.apps.fnd.umx.startaccountrequestwf';
134: end if;
135:
136: if l_item_key is null then
137: select UMX_REG_REQUESTS_S.nextval into l_item_key from dual;
138: l_index_to_add := p_registration_data.last + 1;
139: p_registration_data(l_index_to_add).ATTR_NAME := 'reg_request_id';
140: p_registration_data(l_index_to_add).ATTR_VALUE := l_item_key;
141: end if;

Line 304: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%type,

300: end get_event_name;
301:
302:
303: procedure get_req_data_from_req_id (
304: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%type,
305: p_reg_service_code in UMX_REG_SERVICES_B.REG_SERVICE_CODE%type,
306: x_reg_service_type out nocopy UMX_REG_SERVICES_VL.REG_SERVICE_TYPE%type,
307: x_requested_by_user_id out nocopy UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%type,
308: x_requested_for_user_id out nocopy UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%type,

Line 307: x_requested_by_user_id out nocopy UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%type,

303: procedure get_req_data_from_req_id (
304: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%type,
305: p_reg_service_code in UMX_REG_SERVICES_B.REG_SERVICE_CODE%type,
306: x_reg_service_type out nocopy UMX_REG_SERVICES_VL.REG_SERVICE_TYPE%type,
307: x_requested_by_user_id out nocopy UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%type,
308: x_requested_for_user_id out nocopy UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%type,
309: x_requested_for_party_id out nocopy UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%type,
310: x_requested_username out nocopy UMX_REG_REQUESTS.REQUESTED_USERNAME%type,
311: x_wf_role_name out nocopy UMX_REG_SERVICES_VL.WF_ROLE_NAME%type,

Line 308: x_requested_for_user_id out nocopy UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%type,

304: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%type,
305: p_reg_service_code in UMX_REG_SERVICES_B.REG_SERVICE_CODE%type,
306: x_reg_service_type out nocopy UMX_REG_SERVICES_VL.REG_SERVICE_TYPE%type,
307: x_requested_by_user_id out nocopy UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%type,
308: x_requested_for_user_id out nocopy UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%type,
309: x_requested_for_party_id out nocopy UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%type,
310: x_requested_username out nocopy UMX_REG_REQUESTS.REQUESTED_USERNAME%type,
311: x_wf_role_name out nocopy UMX_REG_SERVICES_VL.WF_ROLE_NAME%type,
312: x_ame_application_id out nocopy UMX_REG_SERVICES_VL.AME_APPLICATION_ID%type,

Line 309: x_requested_for_party_id out nocopy UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%type,

305: p_reg_service_code in UMX_REG_SERVICES_B.REG_SERVICE_CODE%type,
306: x_reg_service_type out nocopy UMX_REG_SERVICES_VL.REG_SERVICE_TYPE%type,
307: x_requested_by_user_id out nocopy UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%type,
308: x_requested_for_user_id out nocopy UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%type,
309: x_requested_for_party_id out nocopy UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%type,
310: x_requested_username out nocopy UMX_REG_REQUESTS.REQUESTED_USERNAME%type,
311: x_wf_role_name out nocopy UMX_REG_SERVICES_VL.WF_ROLE_NAME%type,
312: x_ame_application_id out nocopy UMX_REG_SERVICES_VL.AME_APPLICATION_ID%type,
313: x_ame_transaction_type_id out nocopy UMX_REG_SERVICES_VL.AME_TRANSACTION_TYPE_ID%type,

Line 310: x_requested_username out nocopy UMX_REG_REQUESTS.REQUESTED_USERNAME%type,

306: x_reg_service_type out nocopy UMX_REG_SERVICES_VL.REG_SERVICE_TYPE%type,
307: x_requested_by_user_id out nocopy UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%type,
308: x_requested_for_user_id out nocopy UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%type,
309: x_requested_for_party_id out nocopy UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%type,
310: x_requested_username out nocopy UMX_REG_REQUESTS.REQUESTED_USERNAME%type,
311: x_wf_role_name out nocopy UMX_REG_SERVICES_VL.WF_ROLE_NAME%type,
312: x_ame_application_id out nocopy UMX_REG_SERVICES_VL.AME_APPLICATION_ID%type,
313: x_ame_transaction_type_id out nocopy UMX_REG_SERVICES_VL.AME_TRANSACTION_TYPE_ID%type,
314: x_justification out nocopy UMX_REG_REQUESTS.JUSTIFICATION%type,

Line 314: x_justification out nocopy UMX_REG_REQUESTS.JUSTIFICATION%type,

310: x_requested_username out nocopy UMX_REG_REQUESTS.REQUESTED_USERNAME%type,
311: x_wf_role_name out nocopy UMX_REG_SERVICES_VL.WF_ROLE_NAME%type,
312: x_ame_application_id out nocopy UMX_REG_SERVICES_VL.AME_APPLICATION_ID%type,
313: x_ame_transaction_type_id out nocopy UMX_REG_SERVICES_VL.AME_TRANSACTION_TYPE_ID%type,
314: x_justification out nocopy UMX_REG_REQUESTS.JUSTIFICATION%type,
315: x_wf_notification_event_name out nocopy WF_EVENTS.NAME%type,
316: x_email_verification_flag out nocopy UMX_REG_SERVICES_VL.EMAIL_VERIFICATION_FLAG%type,
317: x_application_id out nocopy UMX_REG_SERVICES_VL.APPLICATION_ID%type,
318: x_reg_function_name out nocopy FND_FORM_FUNCTIONS.FUNCTION_NAME%type,

Line 332: UMX_REG_REQUESTS regreq

328: regreq.REQUESTED_FOR_USER_ID, regreq.REQUESTED_FOR_PARTY_ID,
329: regreq.REQUESTED_USERNAME, regser.wf_notification_event_guid,
330: regser.wf_bus_logic_event_guid
331: FROM UMX_REG_SERVICES_VL regser, fnd_form_functions func,
332: UMX_REG_REQUESTS regreq
333: WHERE regser.reg_function_id = func.function_id (+)
334: AND regreq.REG_SERVICE_CODE = regser.REG_SERVICE_CODE
335: AND regreq.reg_request_id = p_reg_request_id;
336:

Line 514: l_reg_request_id UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE;

510:
511: end get_req_data_from_role_name;
512:
513: procedure POPULATE_REG_DATA (p_registration_data IN OUT NOCOPY UMX_REGISTRATION_DATA_TBL) IS
514: l_reg_request_id UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE;
515: l_reg_service_code UMX_REG_SERVICES_B.REG_SERVICE_CODE%TYPE;
516: j number;
517: l_wf_role_name UMX_REG_SERVICES_VL.WF_ROLE_NAME%TYPE;
518: l_reg_service_type UMX_REG_SERVICES_VL.REG_SERVICE_TYPE%TYPE;

Line 528: l_justification UMX_REG_REQUESTS.JUSTIFICATION%TYPE;

524: l_reg_function_name fnd_form_functions.FUNCTION_NAME%TYPE;
525: l_display_name UMX_REG_SERVICES_VL.DISPLAY_NAME%TYPE;
526: l_description UMX_REG_SERVICES_VL.DESCRIPTION%TYPE;
527: l_wf_bus_logic_event_name wf_events.name%TYPE;
528: l_justification UMX_REG_REQUESTS.JUSTIFICATION%TYPE;
529: l_requested_by_user_id UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%TYPE;
530: l_requested_for_user_id UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%TYPE;
531: l_requested_for_party_id UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%type;
532: l_requested_username UMX_REG_REQUESTS.REQUESTED_USERNAME%TYPE;

Line 529: l_requested_by_user_id UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%TYPE;

525: l_display_name UMX_REG_SERVICES_VL.DISPLAY_NAME%TYPE;
526: l_description UMX_REG_SERVICES_VL.DESCRIPTION%TYPE;
527: l_wf_bus_logic_event_name wf_events.name%TYPE;
528: l_justification UMX_REG_REQUESTS.JUSTIFICATION%TYPE;
529: l_requested_by_user_id UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%TYPE;
530: l_requested_for_user_id UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%TYPE;
531: l_requested_for_party_id UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%type;
532: l_requested_username UMX_REG_REQUESTS.REQUESTED_USERNAME%TYPE;
533:

Line 530: l_requested_for_user_id UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%TYPE;

526: l_description UMX_REG_SERVICES_VL.DESCRIPTION%TYPE;
527: l_wf_bus_logic_event_name wf_events.name%TYPE;
528: l_justification UMX_REG_REQUESTS.JUSTIFICATION%TYPE;
529: l_requested_by_user_id UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%TYPE;
530: l_requested_for_user_id UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%TYPE;
531: l_requested_for_party_id UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%type;
532: l_requested_username UMX_REG_REQUESTS.REQUESTED_USERNAME%TYPE;
533:
534: l_index_to_add number;

Line 531: l_requested_for_party_id UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%type;

527: l_wf_bus_logic_event_name wf_events.name%TYPE;
528: l_justification UMX_REG_REQUESTS.JUSTIFICATION%TYPE;
529: l_requested_by_user_id UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%TYPE;
530: l_requested_for_user_id UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%TYPE;
531: l_requested_for_party_id UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%type;
532: l_requested_username UMX_REG_REQUESTS.REQUESTED_USERNAME%TYPE;
533:
534: l_index_to_add number;
535: l_count number := 0;

Line 532: l_requested_username UMX_REG_REQUESTS.REQUESTED_USERNAME%TYPE;

528: l_justification UMX_REG_REQUESTS.JUSTIFICATION%TYPE;
529: l_requested_by_user_id UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%TYPE;
530: l_requested_for_user_id UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%TYPE;
531: l_requested_for_party_id UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%type;
532: l_requested_username UMX_REG_REQUESTS.REQUESTED_USERNAME%TYPE;
533:
534: l_index_to_add number;
535: l_count number := 0;
536:

Line 834: l_reg_request_id umx_reg_requests.reg_request_id%type;

830: l_reg_function_name_i number;
831: l_display_name_i number;
832: l_description_i number;
833:
834: l_reg_request_id umx_reg_requests.reg_request_id%type;
835: l_reg_service_type umx_reg_requests.reg_service_type%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;

Line 835: l_reg_service_type umx_reg_requests.reg_service_type%type;

831: l_display_name_i number;
832: l_description_i number;
833:
834: l_reg_request_id umx_reg_requests.reg_request_id%type;
835: l_reg_service_type umx_reg_requests.reg_service_type%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;

Line 836: l_status_code umx_reg_requests.status_code%type;

832: l_description_i number;
833:
834: l_reg_request_id umx_reg_requests.reg_request_id%type;
835: l_reg_service_type umx_reg_requests.reg_service_type%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;

Line 837: l_requested_start_date umx_reg_requests.requested_start_date%type;

833:
834: l_reg_request_id umx_reg_requests.reg_request_id%type;
835: l_reg_service_type umx_reg_requests.reg_service_type%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;

Line 838: l_requested_by_user_id umx_reg_requests.requested_by_user_id%type;

834: l_reg_request_id umx_reg_requests.reg_request_id%type;
835: l_reg_service_type umx_reg_requests.reg_service_type%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;

Line 839: l_requested_for_user_id umx_reg_requests.requested_for_user_id%type;

835: l_reg_service_type umx_reg_requests.reg_service_type%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;

Line 841: l_requested_for_party_id umx_reg_requests.requested_for_party_id%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;
845: l_reg_service_code umx_reg_requests.reg_service_code%type;

Line 842: l_requested_username umx_reg_requests.requested_username%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;
845: l_reg_service_code umx_reg_requests.reg_service_code%type;
846: l_ame_application_id umx_reg_requests.ame_application_id%type;

Line 843: l_requested_end_date umx_reg_requests.requested_end_date%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;
845: l_reg_service_code umx_reg_requests.reg_service_code%type;
846: l_ame_application_id umx_reg_requests.ame_application_id%type;
847: l_ame_transaction_type_id umx_reg_requests.ame_transaction_type_id%type;

Line 844: l_wf_role_name umx_reg_requests.wf_role_name%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;
845: l_reg_service_code umx_reg_requests.reg_service_code%type;
846: l_ame_application_id umx_reg_requests.ame_application_id%type;
847: l_ame_transaction_type_id umx_reg_requests.ame_transaction_type_id%type;
848: l_justification umx_reg_requests.justification%type;

Line 845: l_reg_service_code umx_reg_requests.reg_service_code%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;
845: l_reg_service_code umx_reg_requests.reg_service_code%type;
846: l_ame_application_id umx_reg_requests.ame_application_id%type;
847: l_ame_transaction_type_id umx_reg_requests.ame_transaction_type_id%type;
848: l_justification umx_reg_requests.justification%type;
849: l_wf_notification_event_name wf_events.name%TYPE;

Line 846: l_ame_application_id umx_reg_requests.ame_application_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;
845: l_reg_service_code umx_reg_requests.reg_service_code%type;
846: l_ame_application_id umx_reg_requests.ame_application_id%type;
847: l_ame_transaction_type_id umx_reg_requests.ame_transaction_type_id%type;
848: l_justification umx_reg_requests.justification%type;
849: l_wf_notification_event_name wf_events.name%TYPE;
850: l_wf_bus_logic_event_name wf_events.name%TYPE;

Line 847: l_ame_transaction_type_id umx_reg_requests.ame_transaction_type_id%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;
845: l_reg_service_code umx_reg_requests.reg_service_code%type;
846: l_ame_application_id umx_reg_requests.ame_application_id%type;
847: l_ame_transaction_type_id umx_reg_requests.ame_transaction_type_id%type;
848: l_justification umx_reg_requests.justification%type;
849: l_wf_notification_event_name wf_events.name%TYPE;
850: l_wf_bus_logic_event_name wf_events.name%TYPE;
851: l_email_verification_flag UMX_REG_SERVICES_VL.EMAIL_VERIFICATION_FLAG%TYPE;

Line 848: l_justification umx_reg_requests.justification%type;

844: l_wf_role_name umx_reg_requests.wf_role_name%type;
845: l_reg_service_code umx_reg_requests.reg_service_code%type;
846: l_ame_application_id umx_reg_requests.ame_application_id%type;
847: l_ame_transaction_type_id umx_reg_requests.ame_transaction_type_id%type;
848: l_justification umx_reg_requests.justification%type;
849: l_wf_notification_event_name wf_events.name%TYPE;
850: l_wf_bus_logic_event_name wf_events.name%TYPE;
851: l_email_verification_flag UMX_REG_SERVICES_VL.EMAIL_VERIFICATION_FLAG%TYPE;
852: l_application_id UMX_REG_SERVICES_VL.APPLICATION_ID%TYPE;

Line 1250: UMX_REG_REQUESTS_PKG.insert_row (

1246: else
1247: p_registration_data(l_status_code_i).attr_value := l_status_code;
1248: end if;
1249:
1250: UMX_REG_REQUESTS_PKG.insert_row (
1251: x_reg_request_id => l_reg_request_id ,
1252: x_reg_service_type => l_reg_service_type,
1253: x_status_code => l_status_code,
1254: x_requested_by_user_id => l_requested_by_user_id,