APPS.WMS_POSTALLOC_PVT dependencies on WMS_DEVICE_REQUESTS

Line 5718: INSERT INTO wms_device_requests( request_id

5714: EXIT WHEN t_transaction_temp_id.COUNT = 0;
5715:
5716: -- BULK INSERT the records in WDR (for LOAD)
5717: FORALL ii IN t_transaction_temp_id.FIRST .. t_transaction_temp_id.LAST
5718: INSERT INTO wms_device_requests( request_id
5719: , task_id
5720: , task_summary
5721: , task_type_id
5722: , business_event_id

Line 5761: INSERT INTO wms_device_requests( request_id

5757: , t_dev_id(ii) );
5758:
5759: -- BULK INSERT the records in WDR (for DROP)
5760: FORALL jj IN t_transaction_temp_id.FIRST .. t_transaction_temp_id.LAST
5761: INSERT INTO wms_device_requests( request_id
5762: , task_id
5763: , task_summary
5764: , task_type_id
5765: , business_event_id

Line 5804: INSERT INTO wms_device_requests( request_id

5800: , t_dev_id(jj) );
5801:
5802: --BULK INSERT lot/serial WDR record
5803: FORALL kk IN t_transaction_temp_id.FIRST .. t_transaction_temp_id.LAST
5804: INSERT INTO wms_device_requests( request_id
5805: , task_id
5806: , relation_id
5807: , sequence_id
5808: , task_summary

Line 5985: INSERT INTO wms_device_requests( request_id

5981: EXIT WHEN t_transaction_temp_id.COUNT = 0;
5982:
5983: -- BULK INSERT the WDR DROP record for child MMTT records
5984: FORALL ll IN t_transaction_temp_id.FIRST .. t_transaction_temp_id.LAST
5985: INSERT INTO wms_device_requests( request_id
5986: , task_id
5987: , task_summary
5988: , task_type_id
5989: , business_event_id

Line 6087: INSERT INTO wms_device_requests( request_id

6083: END IF;
6084:
6085: --BULK INSERT the LOAD records for parent MMTT records
6086: FORALL mm IN t_transaction_temp_id.FIRST .. t_transaction_temp_id.LAST
6087: INSERT INTO wms_device_requests( request_id
6088: , task_id
6089: , task_summary
6090: , task_type_id
6091: , business_event_id

Line 6134: INSERT INTO wms_device_requests( request_id

6130: END IF;
6131:
6132: -- BULK INSERT the lot/serial record for parent MMTT records
6133: FORALL nn IN t_transaction_temp_id.FIRST .. t_transaction_temp_id.LAST
6134: INSERT INTO wms_device_requests( request_id
6135: , task_id
6136: , relation_id
6137: , sequence_id
6138: , task_summary

Line 6311: DELETE FROM wms_device_requests

6307: IF g_debug = 1 THEN
6308: print_debug (l_msg_data, l_api_name);
6309: END IF;
6310:
6311: DELETE FROM wms_device_requests
6312: WHERE request_id = wms_device_integration_pvt.wms_pkRel_dev_req_id;
6313:
6314: COMMIT;
6315:

Line 6332: DELETE FROM wms_device_requests

6328: IF g_debug = 1 THEN
6329: print_debug ('Other error: ' || SQLERRM, l_api_name);
6330: END IF;
6331:
6332: DELETE FROM wms_device_requests
6333: WHERE request_id = wms_device_integration_pvt.wms_pkRel_dev_req_id;
6334:
6335: COMMIT;
6336: