APPS.WSH_ITM_EXPORT_SCREENING dependencies on WSH_ITM_REQUEST_CONTROL

Line 352: | WSH_ITM_REQUEST_CONTROL Table. |

348: | This procedure is called For the deliveries of a |
349: | Specific event. It Logs and Handles Appropriate |
350: | Exceptions which hold the delivery until the export |
351: | screening is done for the delivery ad populates data into |
352: | WSH_ITM_REQUEST_CONTROL Table. |
353: | |
354: +===========================================================================*/
355:
356: PROCEDURE SCREEN_EVENT_DELIVERIES (

Line 416: --BUG 6700736 Fetching master_organization_id to populate into wsh_itm_request_control

412: l_debug_on BOOLEAN;
413: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' ||'SCREEN_EVENT_DELIVERIES';
414:
415: --Addded condition to get deliveries that contains items Bug Number 3411941
416: --BUG 6700736 Fetching master_organization_id to populate into wsh_itm_request_control
417: l_exp_compliance_dlvy_query VARCHAR2(1800) :=
418: ' SELECT '||
419: ' WE.EXCEPTION_ID AS EXCEPTION_ID, '||
420: ' WE.EXCEPTION_LOCATION_ID AS LOCATION_ID, '||

Line 821: SELECT WSH_ITM_REQUEST_CONTROL_S.NEXTVAL

817:
818: -- This Sub Section Does the Bulk Insert to Request Control Table
819: FOR k IN l_num_delivery_id_tab.FIRST .. l_num_delivery_id_tab.LAST
820: LOOP
821: SELECT WSH_ITM_REQUEST_CONTROL_S.NEXTVAL
822: INTO l_request_control_id_s FROM DUAL;
823: --Bug 6700736 Populating master_organization_id
824: INSERT INTO WSH_ITM_REQUEST_CONTROL(
825: REQUEST_CONTROL_ID,

Line 824: INSERT INTO WSH_ITM_REQUEST_CONTROL(

820: LOOP
821: SELECT WSH_ITM_REQUEST_CONTROL_S.NEXTVAL
822: INTO l_request_control_id_s FROM DUAL;
823: --Bug 6700736 Populating master_organization_id
824: INSERT INTO WSH_ITM_REQUEST_CONTROL(
825: REQUEST_CONTROL_ID,
826: APPLICATION_ID,
827: APPLICATION_USER_ID,
828: SERVICE_TYPE_CODE,