APPS.WMS_POST_ALLOCATION dependencies on WMS_PR_WORKERS

Line 48: -- WMS_PR_WORKERS, one for each sub-batch.

44:
45:
46: --
47: -- This API divides MMTT into sub-batches and inserts records into
48: -- WMS_PR_WORKERS, one for each sub-batch.
49: --
50: PROCEDURE create_sub_batches
51: ( p_organization_id IN NUMBER
52: , p_mo_header_id IN NUMBER

Line 167: INSERT INTO wms_pr_workers( batch_id

163:
164: EXIT WHEN l_crt_ids.COUNT = 0;
165:
166: FORALL ii IN l_crt_ids.FIRST..l_crt_ids.LAST
167: INSERT INTO wms_pr_workers( batch_id
168: , worker_mode
169: , processed_flag
170: , organization_id
171: , mo_header_id

Line 208: INSERT INTO wms_pr_workers( batch_id

204: EXIT WHEN l_tmp_ids.COUNT = 0;
205:
206: l_detail_count := l_tmp_ids.COUNT;
207:
208: INSERT INTO wms_pr_workers( batch_id
209: , worker_mode
210: , processed_flag
211: , organization_id
212: , mo_header_id

Line 263: INSERT INTO wms_pr_workers( batch_id

259:
260: EXIT WHEN l_itm_ids.COUNT = 0;
261:
262: FORALL ii IN l_itm_ids.FIRST..l_itm_ids.LAST
263: INSERT INTO wms_pr_workers( batch_id
264: , worker_mode
265: , processed_flag
266: , organization_id
267: , mo_header_id

Line 1134: DELETE wms_pr_workers

1130: AND parent_line_id IS NOT NULL
1131: );
1132: END IF;
1133:
1134: DELETE wms_pr_workers
1135: WHERE batch_id = p_batch_id
1136: AND organization_id = p_org_id;
1137:
1138: COMMIT;

Line 1807: FROM wms_pr_workers

1803: SELECT 'x' INTO l_dummy
1804: FROM dual
1805: WHERE EXISTS
1806: ( SELECT 'x'
1807: FROM wms_pr_workers
1808: WHERE organization_id = p_organization_id
1809: AND (batch_id = l_batch_id
1810: OR worker_mode = 'WMSBLKPR')
1811: );