APPS.WMS_WAVE_PLANNING_PVT dependencies on WMS_PR_WORKERS

Line 3835: UPDATE wms_pr_workers

3831: ,l_debug);
3832:
3833: IF p_mode = 'RBP-SS' THEN
3834: begin
3835: UPDATE wms_pr_workers
3836: SET processed_flag = 'Y'
3837: WHERE organization_id = p_organization_id
3838: AND batch_id = p_wave_id
3839: AND mo_header_id = p_mo_header_id

Line 3859: FROM wms_pr_workers

3855: LOOP --{
3856: EXIT WHEN done;
3857: BEGIN
3858: SELECT rowid INTO l_row_id
3859: FROM wms_pr_workers
3860: WHERE organization_id = p_organization_id
3861: AND batch_id = p_wave_id
3862: AND mo_header_id = p_mo_header_id
3863: AND processed_flag = 'N'

Line 3873: UPDATE wms_pr_workers

3869:
3870:
3871: done := TRUE;
3872:
3873: UPDATE wms_pr_workers
3874: SET processed_flag = 'Y'
3875: WHERE rowid = l_row_id
3876: RETURNING transaction_batch_id -- inventory_item_id
3877: INTO l_inventory_item_id;

Line 4450: INSERT INTO wms_pr_workers

4446:
4447: --
4448: --FORall i IN l_cTbl.first..l_cTbl.last dbchange3
4449: FORALL i IN l_cTblorg.first..l_cTblorg.last
4450: INSERT INTO wms_pr_workers
4451: (batch_id,
4452: worker_mode,
4453: processed_flag,
4454: organization_id,

Line 4472: print_debug(l_tot_worker_records ||' no of rows inserted into wms_pr_workers', l_debug);

4468: -- l_tot_worker_records := l_tot_worker_records + SQL%ROWCOUNT;
4469:
4470:
4471: l_tot_worker_records := SQL%ROWCOUNT;
4472: print_debug(l_tot_worker_records ||' no of rows inserted into wms_pr_workers', l_debug);
4473:
4474: SELECT Count(*) INTO l_tot_smc_records
4475: FROM wms_pr_workers
4476: WHERE organization_id=p_organization_id

Line 4475: FROM wms_pr_workers

4471: l_tot_worker_records := SQL%ROWCOUNT;
4472: print_debug(l_tot_worker_records ||' no of rows inserted into wms_pr_workers', l_debug);
4473:
4474: SELECT Count(*) INTO l_tot_smc_records
4475: FROM wms_pr_workers
4476: WHERE organization_id=p_organization_id
4477: AND batch_id=p_wave_id
4478: and mo_header_id=p_mo_header_id
4479: AND worker_mode='RBP'

Line 4824: DELETE FROM wms_pr_workers

4820: print_debug('Could not update WDD', l_debug);
4821: END;
4822:
4823:
4824: DELETE FROM wms_pr_workers
4825: WHERE batch_id = p_wave_id
4826: AND worker_mode = 'RBP'
4827: AND organization_id = p_organization_id
4828: AND mo_header_id = p_mo_header_id;

Line 4830: print_debug(SQL%ROWCOUNT || ' Rows deleted from wms_pr_workers ',l_debug);

4826: AND worker_mode = 'RBP'
4827: AND organization_id = p_organization_id
4828: AND mo_header_id = p_mo_header_id;
4829:
4830: print_debug(SQL%ROWCOUNT || ' Rows deleted from wms_pr_workers ',l_debug);
4831:
4832:
4833: DELETE FROM wms_wp_reservations_gtmp;
4834: