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 139: select UMX_REG_REQUESTS_S.nextval into l_item_key from dual;

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

Line 317: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%type,

313: end get_event_name;
314:
315:
316: procedure get_req_data_from_req_id (
317: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%type,
318: p_reg_service_code in UMX_REG_SERVICES_B.REG_SERVICE_CODE%type,
319: x_reg_service_type out nocopy UMX_REG_SERVICES_VL.REG_SERVICE_TYPE%type,
320: x_requested_by_user_id out nocopy UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%type,
321: x_requested_for_user_id out nocopy UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%type,

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

316: procedure get_req_data_from_req_id (
317: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%type,
318: p_reg_service_code in UMX_REG_SERVICES_B.REG_SERVICE_CODE%type,
319: x_reg_service_type out nocopy UMX_REG_SERVICES_VL.REG_SERVICE_TYPE%type,
320: x_requested_by_user_id out nocopy UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%type,
321: x_requested_for_user_id out nocopy UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%type,
322: x_requested_for_party_id out nocopy UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%type,
323: x_requested_username out nocopy UMX_REG_REQUESTS.REQUESTED_USERNAME%type,
324: x_wf_role_name out nocopy UMX_REG_SERVICES_VL.WF_ROLE_NAME%type,

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

317: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%type,
318: p_reg_service_code in UMX_REG_SERVICES_B.REG_SERVICE_CODE%type,
319: x_reg_service_type out nocopy UMX_REG_SERVICES_VL.REG_SERVICE_TYPE%type,
320: x_requested_by_user_id out nocopy UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%type,
321: x_requested_for_user_id out nocopy UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%type,
322: x_requested_for_party_id out nocopy UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%type,
323: x_requested_username out nocopy UMX_REG_REQUESTS.REQUESTED_USERNAME%type,
324: x_wf_role_name out nocopy UMX_REG_SERVICES_VL.WF_ROLE_NAME%type,
325: x_ame_application_id out nocopy UMX_REG_SERVICES_VL.AME_APPLICATION_ID%type,

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

318: p_reg_service_code in UMX_REG_SERVICES_B.REG_SERVICE_CODE%type,
319: x_reg_service_type out nocopy UMX_REG_SERVICES_VL.REG_SERVICE_TYPE%type,
320: x_requested_by_user_id out nocopy UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%type,
321: x_requested_for_user_id out nocopy UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%type,
322: x_requested_for_party_id out nocopy UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%type,
323: x_requested_username out nocopy UMX_REG_REQUESTS.REQUESTED_USERNAME%type,
324: x_wf_role_name out nocopy UMX_REG_SERVICES_VL.WF_ROLE_NAME%type,
325: x_ame_application_id out nocopy UMX_REG_SERVICES_VL.AME_APPLICATION_ID%type,
326: x_ame_transaction_type_id out nocopy UMX_REG_SERVICES_VL.AME_TRANSACTION_TYPE_ID%type,

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

319: x_reg_service_type out nocopy UMX_REG_SERVICES_VL.REG_SERVICE_TYPE%type,
320: x_requested_by_user_id out nocopy UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%type,
321: x_requested_for_user_id out nocopy UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%type,
322: x_requested_for_party_id out nocopy UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%type,
323: x_requested_username out nocopy UMX_REG_REQUESTS.REQUESTED_USERNAME%type,
324: x_wf_role_name out nocopy UMX_REG_SERVICES_VL.WF_ROLE_NAME%type,
325: x_ame_application_id out nocopy UMX_REG_SERVICES_VL.AME_APPLICATION_ID%type,
326: x_ame_transaction_type_id out nocopy UMX_REG_SERVICES_VL.AME_TRANSACTION_TYPE_ID%type,
327: x_justification out nocopy UMX_REG_REQUESTS.JUSTIFICATION%type,

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

323: x_requested_username out nocopy UMX_REG_REQUESTS.REQUESTED_USERNAME%type,
324: x_wf_role_name out nocopy UMX_REG_SERVICES_VL.WF_ROLE_NAME%type,
325: x_ame_application_id out nocopy UMX_REG_SERVICES_VL.AME_APPLICATION_ID%type,
326: x_ame_transaction_type_id out nocopy UMX_REG_SERVICES_VL.AME_TRANSACTION_TYPE_ID%type,
327: x_justification out nocopy UMX_REG_REQUESTS.JUSTIFICATION%type,
328: x_wf_notification_event_name out nocopy WF_EVENTS.NAME%type,
329: x_email_verification_flag out nocopy UMX_REG_SERVICES_VL.EMAIL_VERIFICATION_FLAG%type,
330: x_application_id out nocopy UMX_REG_SERVICES_VL.APPLICATION_ID%type,
331: x_reg_function_name out nocopy FND_FORM_FUNCTIONS.FUNCTION_NAME%type,

Line 345: UMX_REG_REQUESTS regreq

341: regreq.REQUESTED_FOR_USER_ID, regreq.REQUESTED_FOR_PARTY_ID,
342: regreq.REQUESTED_USERNAME, regser.wf_notification_event_guid,
343: regser.wf_bus_logic_event_guid
344: FROM UMX_REG_SERVICES_VL regser, fnd_form_functions func,
345: UMX_REG_REQUESTS regreq
346: WHERE regser.reg_function_id = func.function_id (+)
347: AND regreq.REG_SERVICE_CODE = regser.REG_SERVICE_CODE
348: AND regreq.reg_request_id = p_reg_request_id;
349:

Line 527: l_reg_request_id UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE;

523:
524: end get_req_data_from_role_name;
525:
526: procedure POPULATE_REG_DATA (p_registration_data IN OUT NOCOPY UMX_REGISTRATION_DATA_TBL) IS
527: l_reg_request_id UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE;
528: l_reg_service_code UMX_REG_SERVICES_B.REG_SERVICE_CODE%TYPE;
529: j number;
530: l_wf_role_name UMX_REG_SERVICES_VL.WF_ROLE_NAME%TYPE;
531: l_reg_service_type UMX_REG_SERVICES_VL.REG_SERVICE_TYPE%TYPE;

Line 541: l_justification UMX_REG_REQUESTS.JUSTIFICATION%TYPE;

537: l_reg_function_name fnd_form_functions.FUNCTION_NAME%TYPE;
538: l_display_name UMX_REG_SERVICES_VL.DISPLAY_NAME%TYPE;
539: l_description UMX_REG_SERVICES_VL.DESCRIPTION%TYPE;
540: l_wf_bus_logic_event_name wf_events.name%TYPE;
541: l_justification UMX_REG_REQUESTS.JUSTIFICATION%TYPE;
542: l_requested_by_user_id UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%TYPE;
543: l_requested_for_user_id UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%TYPE;
544: l_requested_for_party_id UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%type;
545: l_requested_username UMX_REG_REQUESTS.REQUESTED_USERNAME%TYPE;

Line 542: l_requested_by_user_id UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%TYPE;

538: l_display_name UMX_REG_SERVICES_VL.DISPLAY_NAME%TYPE;
539: l_description UMX_REG_SERVICES_VL.DESCRIPTION%TYPE;
540: l_wf_bus_logic_event_name wf_events.name%TYPE;
541: l_justification UMX_REG_REQUESTS.JUSTIFICATION%TYPE;
542: l_requested_by_user_id UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%TYPE;
543: l_requested_for_user_id UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%TYPE;
544: l_requested_for_party_id UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%type;
545: l_requested_username UMX_REG_REQUESTS.REQUESTED_USERNAME%TYPE;
546:

Line 543: l_requested_for_user_id UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%TYPE;

539: l_description UMX_REG_SERVICES_VL.DESCRIPTION%TYPE;
540: l_wf_bus_logic_event_name wf_events.name%TYPE;
541: l_justification UMX_REG_REQUESTS.JUSTIFICATION%TYPE;
542: l_requested_by_user_id UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%TYPE;
543: l_requested_for_user_id UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%TYPE;
544: l_requested_for_party_id UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%type;
545: l_requested_username UMX_REG_REQUESTS.REQUESTED_USERNAME%TYPE;
546:
547: l_index_to_add number;

Line 544: l_requested_for_party_id UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%type;

540: l_wf_bus_logic_event_name wf_events.name%TYPE;
541: l_justification UMX_REG_REQUESTS.JUSTIFICATION%TYPE;
542: l_requested_by_user_id UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%TYPE;
543: l_requested_for_user_id UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%TYPE;
544: l_requested_for_party_id UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%type;
545: l_requested_username UMX_REG_REQUESTS.REQUESTED_USERNAME%TYPE;
546:
547: l_index_to_add number;
548: l_count number := 0;

Line 545: l_requested_username UMX_REG_REQUESTS.REQUESTED_USERNAME%TYPE;

541: l_justification UMX_REG_REQUESTS.JUSTIFICATION%TYPE;
542: l_requested_by_user_id UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%TYPE;
543: l_requested_for_user_id UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%TYPE;
544: l_requested_for_party_id UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%type;
545: l_requested_username UMX_REG_REQUESTS.REQUESTED_USERNAME%TYPE;
546:
547: l_index_to_add number;
548: l_count number := 0;
549:

Line 849: l_reg_request_id umx_reg_requests.reg_request_id%type;

845: l_reg_function_name_i number;
846: l_display_name_i number;
847: l_description_i number;
848:
849: l_reg_request_id umx_reg_requests.reg_request_id%type;
850: l_reg_service_type umx_reg_requests.reg_service_type%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;

Line 850: l_reg_service_type umx_reg_requests.reg_service_type%type;

846: l_display_name_i number;
847: l_description_i number;
848:
849: l_reg_request_id umx_reg_requests.reg_request_id%type;
850: l_reg_service_type umx_reg_requests.reg_service_type%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;

Line 851: l_status_code umx_reg_requests.status_code%type;

847: l_description_i number;
848:
849: l_reg_request_id umx_reg_requests.reg_request_id%type;
850: l_reg_service_type umx_reg_requests.reg_service_type%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;

Line 852: l_requested_start_date umx_reg_requests.requested_start_date%type;

848:
849: l_reg_request_id umx_reg_requests.reg_request_id%type;
850: l_reg_service_type umx_reg_requests.reg_service_type%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;

Line 853: l_requested_by_user_id umx_reg_requests.requested_by_user_id%type;

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

Line 854: l_requested_for_user_id umx_reg_requests.requested_for_user_id%type;

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

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

Line 857: l_requested_username umx_reg_requests.requested_username%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;
860: l_reg_service_code umx_reg_requests.reg_service_code%type;
861: l_ame_application_id umx_reg_requests.ame_application_id%type;

Line 858: l_requested_end_date umx_reg_requests.requested_end_date%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;
860: l_reg_service_code umx_reg_requests.reg_service_code%type;
861: l_ame_application_id umx_reg_requests.ame_application_id%type;
862: l_ame_transaction_type_id umx_reg_requests.ame_transaction_type_id%type;

Line 859: l_wf_role_name umx_reg_requests.wf_role_name%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;
860: l_reg_service_code umx_reg_requests.reg_service_code%type;
861: l_ame_application_id umx_reg_requests.ame_application_id%type;
862: l_ame_transaction_type_id umx_reg_requests.ame_transaction_type_id%type;
863: l_justification umx_reg_requests.justification%type;

Line 860: l_reg_service_code umx_reg_requests.reg_service_code%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;
860: l_reg_service_code umx_reg_requests.reg_service_code%type;
861: l_ame_application_id umx_reg_requests.ame_application_id%type;
862: l_ame_transaction_type_id umx_reg_requests.ame_transaction_type_id%type;
863: l_justification umx_reg_requests.justification%type;
864: l_wf_notification_event_name wf_events.name%TYPE;

Line 861: l_ame_application_id umx_reg_requests.ame_application_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;
860: l_reg_service_code umx_reg_requests.reg_service_code%type;
861: l_ame_application_id umx_reg_requests.ame_application_id%type;
862: l_ame_transaction_type_id umx_reg_requests.ame_transaction_type_id%type;
863: l_justification umx_reg_requests.justification%type;
864: l_wf_notification_event_name wf_events.name%TYPE;
865: l_wf_bus_logic_event_name wf_events.name%TYPE;

Line 862: l_ame_transaction_type_id umx_reg_requests.ame_transaction_type_id%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;
860: l_reg_service_code umx_reg_requests.reg_service_code%type;
861: l_ame_application_id umx_reg_requests.ame_application_id%type;
862: l_ame_transaction_type_id umx_reg_requests.ame_transaction_type_id%type;
863: l_justification umx_reg_requests.justification%type;
864: l_wf_notification_event_name wf_events.name%TYPE;
865: l_wf_bus_logic_event_name wf_events.name%TYPE;
866: l_email_verification_flag UMX_REG_SERVICES_VL.EMAIL_VERIFICATION_FLAG%TYPE;

Line 863: l_justification umx_reg_requests.justification%type;

859: l_wf_role_name umx_reg_requests.wf_role_name%type;
860: l_reg_service_code umx_reg_requests.reg_service_code%type;
861: l_ame_application_id umx_reg_requests.ame_application_id%type;
862: l_ame_transaction_type_id umx_reg_requests.ame_transaction_type_id%type;
863: l_justification umx_reg_requests.justification%type;
864: l_wf_notification_event_name wf_events.name%TYPE;
865: l_wf_bus_logic_event_name wf_events.name%TYPE;
866: l_email_verification_flag UMX_REG_SERVICES_VL.EMAIL_VERIFICATION_FLAG%TYPE;
867: l_application_id UMX_REG_SERVICES_VL.APPLICATION_ID%TYPE;

Line 1265: UMX_REG_REQUESTS_PKG.insert_row (

1261: else
1262: p_registration_data(l_status_code_i).attr_value := l_status_code;
1263: end if;
1264:
1265: UMX_REG_REQUESTS_PKG.insert_row (
1266: x_reg_request_id => l_reg_request_id ,
1267: x_reg_service_type => l_reg_service_type,
1268: x_status_code => l_status_code,
1269: x_requested_by_user_id => l_requested_by_user_id,