APPS.UMX_REGISTRATION_PVT dependencies on UMX_REG_SERVICES_B

Line 88: l_reg_service_type UMX_REG_SERVICES_B.REG_SERVICE_TYPE%type;

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

Line 318: p_reg_service_code in UMX_REG_SERVICES_B.REG_SERVICE_CODE%type,

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

Line 400: p_reg_service_code in UMX_REG_SERVICES_B.REG_SERVICE_CODE%type,

396: end get_req_data_from_req_id;
397:
398:
399: procedure get_req_data_from_req_sv_code (
400: p_reg_service_code in UMX_REG_SERVICES_B.REG_SERVICE_CODE%type,
401: x_reg_service_type out nocopy UMX_REG_SERVICES_VL.REG_SERVICE_TYPE%type,
402: x_wf_role_name out nocopy UMX_REG_SERVICES_VL.WF_ROLE_NAME%type,
403: x_ame_application_id out nocopy UMX_REG_SERVICES_VL.AME_APPLICATION_ID%type,
404: x_ame_transaction_type_id out nocopy UMX_REG_SERVICES_VL.AME_TRANSACTION_TYPE_ID%type,

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

460: end get_req_data_from_req_sv_code;
461:
462: procedure get_req_data_from_role_name (
463: p_wf_role_name in UMX_REG_SERVICES_VL.WF_ROLE_NAME%type,
464: x_reg_service_code out nocopy UMX_REG_SERVICES_B.REG_SERVICE_CODE%type,
465: x_reg_service_type out nocopy UMX_REG_SERVICES_VL.REG_SERVICE_TYPE%type,
466: x_ame_application_id out nocopy UMX_REG_SERVICES_VL.AME_APPLICATION_ID%type,
467: x_ame_transaction_type_id out nocopy UMX_REG_SERVICES_VL.AME_TRANSACTION_TYPE_ID%type,
468: x_wf_notification_event_name out nocopy WF_EVENTS.NAME%type,

Line 478: from UMX_REG_SERVICES_B

474: select REG_SERVICE_TYPE, REG_SERVICE_CODE, AME_APPLICATION_ID,
475: AME_TRANSACTION_TYPE_ID, REG_FUNCTION_ID,
476: wf_notification_event_guid, EMAIL_VERIFICATION_FLAG,
477: wf_bus_logic_event_guid
478: from UMX_REG_SERVICES_B
479: where WF_ROLE_NAME = p_wf_role_name
480: and reg_service_type = p_reg_serivce_type;
481:
482: l_wf_notification_event_guid wf_events.guid%type;

Line 528: l_reg_service_code UMX_REG_SERVICES_B.REG_SERVICE_CODE%TYPE;

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