APPS.UMX_REGISTRATION_PVT dependencies on UMX_REG_SERVICES_B

Line 86: l_reg_service_type UMX_REG_SERVICES_B.REG_SERVICE_TYPE%type;

82: j number;
83: l_item_key varchar2(2000);
84: l_requested_by_user_id varchar2(2000);
85: l_event_name WF_EVENTS_VL.NAME%type;
86: l_reg_service_type UMX_REG_SERVICES_B.REG_SERVICE_TYPE%type;
87: l_index_to_add number;
88:
89: l_status varchar2(8);
90: l_result varchar2(30);

Line 305: p_reg_service_code in UMX_REG_SERVICES_B.REG_SERVICE_CODE%type,

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,
309: x_requested_for_party_id out nocopy UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%type,

Line 387: p_reg_service_code in UMX_REG_SERVICES_B.REG_SERVICE_CODE%type,

383: end get_req_data_from_req_id;
384:
385:
386: procedure get_req_data_from_req_sv_code (
387: p_reg_service_code in UMX_REG_SERVICES_B.REG_SERVICE_CODE%type,
388: x_reg_service_type out nocopy UMX_REG_SERVICES_VL.REG_SERVICE_TYPE%type,
389: x_wf_role_name out nocopy UMX_REG_SERVICES_VL.WF_ROLE_NAME%type,
390: x_ame_application_id out nocopy UMX_REG_SERVICES_VL.AME_APPLICATION_ID%type,
391: x_ame_transaction_type_id out nocopy UMX_REG_SERVICES_VL.AME_TRANSACTION_TYPE_ID%type,

Line 451: x_reg_service_code out nocopy UMX_REG_SERVICES_B.REG_SERVICE_CODE%type,

447: end get_req_data_from_req_sv_code;
448:
449: procedure get_req_data_from_role_name (
450: p_wf_role_name in UMX_REG_SERVICES_VL.WF_ROLE_NAME%type,
451: x_reg_service_code out nocopy UMX_REG_SERVICES_B.REG_SERVICE_CODE%type,
452: x_reg_service_type out nocopy UMX_REG_SERVICES_VL.REG_SERVICE_TYPE%type,
453: x_ame_application_id out nocopy UMX_REG_SERVICES_VL.AME_APPLICATION_ID%type,
454: x_ame_transaction_type_id out nocopy UMX_REG_SERVICES_VL.AME_TRANSACTION_TYPE_ID%type,
455: x_wf_notification_event_name out nocopy WF_EVENTS.NAME%type,

Line 465: from UMX_REG_SERVICES_B

461: select REG_SERVICE_TYPE, REG_SERVICE_CODE, AME_APPLICATION_ID,
462: AME_TRANSACTION_TYPE_ID, REG_FUNCTION_ID,
463: wf_notification_event_guid, EMAIL_VERIFICATION_FLAG,
464: wf_bus_logic_event_guid
465: from UMX_REG_SERVICES_B
466: where WF_ROLE_NAME = p_wf_role_name
467: and reg_service_type = p_reg_serivce_type;
468:
469: l_wf_notification_event_guid wf_events.guid%type;

Line 515: l_reg_service_code UMX_REG_SERVICES_B.REG_SERVICE_CODE%TYPE;

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;
519: l_application_id UMX_REG_SERVICES_VL.APPLICATION_ID%TYPE;