APPS.UMX_REGISTRATION_UTIL dependencies on UMX_REG_REQUESTS_S

Line 586: l_request_status_code UMX_REG_REQUESTS.STATUS_CODE%TYPE;

582: l_reg_service_code UMX_REG_REQUESTS.REG_SERVICE_CODE%TYPE ;
583: l_reg_service_type UMX_REG_REQUESTS.REG_SERVICE_TYPE%TYPE;
584: l_ame_application_id UMX_REG_REQUESTS.AME_APPLICATION_ID%TYPE ;
585: l_ame_transaction_type_id UMX_REG_REQUESTS.AME_TRANSACTION_TYPE_ID%TYPE ;
586: l_request_status_code UMX_REG_REQUESTS.STATUS_CODE%TYPE;
587: l_justification UMX_REG_REQUESTS.JUSTIFICATION%TYPE ;
588: l_requested_start_date DATE;
589: l_requested_end_date DATE;
590:

Line 1074: select UMX_REG_REQUESTS_S.nextval into l_temp_event_key from dual;

1070:
1071: if (l_event_type = 'GENERIC') then
1072: select UMX_EVENTS_S.nextval into l_temp_event_key from dual;
1073: else
1074: select UMX_REG_REQUESTS_S.nextval into l_temp_event_key from dual;
1075: end if;
1076:
1077: l_event_key := to_char (l_temp_event_key);
1078: wf_engine.setitemattrtext (itemtype => p_item_type,

Line 1268: l_status_code UMX_REG_REQUESTS.status_code%TYPE;

1264: where REG_REQUEST_ID = p_reg_request_id;
1265:
1266: l_reg_request umx_reg_requests_pvt.reg_request_type;
1267: l_reg_request_id UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE;
1268: l_status_code UMX_REG_REQUESTS.status_code%TYPE;
1269:
1270: l_event wf_event_t;
1271:
1272: BEGIN