DBA Data[Home] [Help]

APPS.WMS_XDOCK_PEGGING_PUB dependencies on WMS_WP_RULES_SIMULATION

Line 6048: print_debug('Updating the wms_wp_rules_simulation table ');

6044:
6045: if p_simulation_mode = 'Y' THEN
6046:
6047: --Do Bulk Update into the global temp table
6048: print_debug('Updating the wms_wp_rules_simulation table ');
6049:
6050: -- ssk autobuild
6051: /* forall m3 in indices of x_wp_crossdock_tbl
6052: update wms_wp_rules_simulation

Line 6052: update wms_wp_rules_simulation

6048: print_debug('Updating the wms_wp_rules_simulation table ');
6049:
6050: -- ssk autobuild
6051: /* forall m3 in indices of x_wp_crossdock_tbl
6052: update wms_wp_rules_simulation
6053: set crossdocked_quantity = x_wp_crossdock_tbl(m3).crossdock_qty
6054: where delivery_detail_id=x_wp_crossdock_tbl(m3).delivery_detail_id
6055: and wave_header_id = l_wave_header_id; */
6056: IF x_wp_crossdock_tbl.Count > 0 THEN

Line 6058: update wms_wp_rules_simulation

6054: where delivery_detail_id=x_wp_crossdock_tbl(m3).delivery_detail_id
6055: and wave_header_id = l_wave_header_id; */
6056: IF x_wp_crossdock_tbl.Count > 0 THEN
6057: FOR m3 IN x_wp_crossdock_tbl.first .. x_wp_crossdock_tbl.last LOOP
6058: update wms_wp_rules_simulation
6059: set crossdocked_quantity = x_wp_crossdock_tbl(m3).crossdock_qty
6060: where delivery_detail_id=x_wp_crossdock_tbl(m3).delivery_detail_id
6061: and wave_header_id = l_wave_header_id;
6062: END LOOP;