APPS.WSH_ITM_EXPORT_SCREENING dependencies on WSH_ITM_REQUEST_CONTROL

Line 365: | WSH_ITM_REQUEST_CONTROL Table. |

361: | This procedure is called For the deliveries of a |
362: | Specific event. It Logs and Handles Appropriate |
363: | Exceptions which hold the delivery until the export |
364: | screening is done for the delivery ad populates data into |
365: | WSH_ITM_REQUEST_CONTROL Table. |
366: | |
367: +===========================================================================*/
368:
369: PROCEDURE SCREEN_EVENT_DELIVERIES (

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

425: l_debug_on BOOLEAN;
426: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' ||'SCREEN_EVENT_DELIVERIES';
427:
428: --Addded condition to get deliveries that contains items Bug Number 3411941
429: --BUG 6700736 Fetching master_organization_id to populate into wsh_itm_request_control
430: l_exp_compliance_dlvy_query VARCHAR2(1800) :=
431: ' SELECT '||
432: ' WE.EXCEPTION_ID AS EXCEPTION_ID, '||
433: ' WE.EXCEPTION_LOCATION_ID AS LOCATION_ID, '||

Line 834: SELECT WSH_ITM_REQUEST_CONTROL_S.NEXTVAL

830:
831: -- This Sub Section Does the Bulk Insert to Request Control Table
832: FOR k IN l_num_delivery_id_tab.FIRST .. l_num_delivery_id_tab.LAST
833: LOOP
834: SELECT WSH_ITM_REQUEST_CONTROL_S.NEXTVAL
835: INTO l_request_control_id_s FROM DUAL;
836: --Bug 6700736 Populating master_organization_id
837: INSERT INTO WSH_ITM_REQUEST_CONTROL(
838: REQUEST_CONTROL_ID,

Line 837: INSERT INTO WSH_ITM_REQUEST_CONTROL(

833: LOOP
834: SELECT WSH_ITM_REQUEST_CONTROL_S.NEXTVAL
835: INTO l_request_control_id_s FROM DUAL;
836: --Bug 6700736 Populating master_organization_id
837: INSERT INTO WSH_ITM_REQUEST_CONTROL(
838: REQUEST_CONTROL_ID,
839: APPLICATION_ID,
840: APPLICATION_USER_ID,
841: SERVICE_TYPE_CODE,