[Home] [Help]
176: UPDATE gme_batch_header
177: SET batch_no = SUBSTR(batch_no,1,30)||'-M'
178: WHERE batch_id = get_batches.batch_id;
179:
180: UPDATE wip_entities
181: SET wip_entity_name = wip_entity_name||'-M'
182: WHERE entity_type = DECODE(get_batches.batch_type, 10, gme_common_pvt.g_wip_entity_type_fpo, gme_common_pvt.g_wip_entity_type_batch)
183: AND organization_id = get_batches.organization_id
184: AND wip_entity_name = l_prefix||get_batches.batch_no;
190: /* Process batch header record */
191: build_batch_hdr(p_batch_header_mig => get_batches,
192: x_batch_header => l_batch_header);
193:
194: SELECT wip_entities_s.NEXTVAL INTO l_wip_entity_id FROM DUAL;
195: l_batch_header.plant_code := NULL;
196: l_batch_header.batch_status := 1;
197: l_batch_header.enforce_step_dependency := 0;
198: l_batch_header.terminated_ind := 0;
199: l_batch_header.enhanced_pi_ind := 'N';
200: l_batch_header.batch_id := l_wip_entity_id;
201: l_batch_header.wip_whse_code := NULL;
202: IF (g_debug <= gme_debug.g_log_statement) THEN
203: gme_debug.put_line('Before wip entities');
204: END IF;
205:
206: -- Bug 13706812/13839066 - Let's make sure we update primary_item_id.
207: OPEN Cur_get_prim_item(l_batch_header.recipe_validity_rule_id, l_batch_header.organization_id);
222: CLOSE Cur_get_prim_item;
223: END IF;
224:
225: -- update wip entity column primary_item_id with l_primary_item_id.
226: INSERT INTO wip_entities
227: (wip_entity_id, organization_id
228: ,last_update_date, last_updated_by
229: ,creation_date, created_by
230: ,wip_entity_name
241: ,mtl_gen_object_id_s.NEXTVAL
242: ,l_primary_item_id);
243:
244: IF (g_debug <= gme_debug.g_log_statement) THEN
245: gme_debug.put_line('After wip entities');
246: END IF;
247:
248: l_batch_tbl(1) := l_batch_header;
249: FORALL a IN 1..l_batch_tbl.count