32: ();
33: l_gme_rsrc_parameters gme_create_step_pvt.gme_process_parameters_tab
34: := gme_create_step_pvt.gme_process_parameters_tab
35: ();
36: l_gme_batch_step_items gme_create_step_pvt.gme_batch_step_items_tab
37: := gme_create_step_pvt.gme_batch_step_items_tab
38: ();
39: l_gme_batch_step_dep gme_create_step_pvt.gme_batch_step_dep_tab
40: := gme_create_step_pvt.gme_batch_step_dep_tab
33: l_gme_rsrc_parameters gme_create_step_pvt.gme_process_parameters_tab
34: := gme_create_step_pvt.gme_process_parameters_tab
35: ();
36: l_gme_batch_step_items gme_create_step_pvt.gme_batch_step_items_tab
37: := gme_create_step_pvt.gme_batch_step_items_tab
38: ();
39: l_gme_batch_step_dep gme_create_step_pvt.gme_batch_step_dep_tab
40: := gme_create_step_pvt.gme_batch_step_dep_tab
41: ();
734: END IF;
735: END LOOP;
736:
737: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
738: gme_debug.put_line ('GME_BATCH_STEP_ITEMS');
739: END IF;
740:
741: -- Create data for GME_BATCH_STEP_ITEMS --> item/step assocations...
742: i := p_recipe_rout_matl_tbl.FIRST;
737: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
738: gme_debug.put_line ('GME_BATCH_STEP_ITEMS');
739: END IF;
740:
741: -- Create data for GME_BATCH_STEP_ITEMS --> item/step assocations...
742: i := p_recipe_rout_matl_tbl.FIRST;
743: j := 0;
744:
745: WHILE i IS NOT NULL LOOP
742: i := p_recipe_rout_matl_tbl.FIRST;
743: j := 0;
744:
745: WHILE i IS NOT NULL LOOP
746: l_gme_batch_step_items.EXTEND;
747:
748: IF (j = 0) THEN
749: j := l_gme_batch_step_items.FIRST;
750: ELSE
745: WHILE i IS NOT NULL LOOP
746: l_gme_batch_step_items.EXTEND;
747:
748: IF (j = 0) THEN
749: j := l_gme_batch_step_items.FIRST;
750: ELSE
751: j := l_gme_batch_step_items.NEXT (j);
752: END IF;
753:
747:
748: IF (j = 0) THEN
749: j := l_gme_batch_step_items.FIRST;
750: ELSE
751: j := l_gme_batch_step_items.NEXT (j);
752: END IF;
753:
754: l_gme_batch_step_items (j).batch_id := l_batch_id;
755:
750: ELSE
751: j := l_gme_batch_step_items.NEXT (j);
752: END IF;
753:
754: l_gme_batch_step_items (j).batch_id := l_batch_id;
755:
756: SELECT material_detail_id
757: INTO l_gme_batch_step_items (j).material_detail_id
758: FROM gme_material_details
753:
754: l_gme_batch_step_items (j).batch_id := l_batch_id;
755:
756: SELECT material_detail_id
757: INTO l_gme_batch_step_items (j).material_detail_id
758: FROM gme_material_details
759: WHERE batch_id = l_batch_id
760: AND formulaline_id = p_recipe_rout_matl_tbl (i).formulaline_id;
761:
760: AND formulaline_id = p_recipe_rout_matl_tbl (i).formulaline_id;
761:
762: IF (p_recipe_rout_matl_tbl (i).routingstep_id IS NOT NULL) THEN
763: SELECT batchstep_id
764: INTO l_gme_batch_step_items (j).batchstep_id
765: FROM gme_batch_steps
766: WHERE batch_id = l_batch_id
767: AND routingstep_id = p_recipe_rout_matl_tbl (i).routingstep_id;
768: ELSE
765: FROM gme_batch_steps
766: WHERE batch_id = l_batch_id
767: AND routingstep_id = p_recipe_rout_matl_tbl (i).routingstep_id;
768: ELSE
769: l_gme_batch_step_items (j).batchstep_id := l_last_batchstep_id;
770: END IF;
771:
772: l_gme_batch_step_items (j).minimum_transfer_qty :=
773: p_recipe_rout_matl_tbl (i).minimum_transfer_qty;
768: ELSE
769: l_gme_batch_step_items (j).batchstep_id := l_last_batchstep_id;
770: END IF;
771:
772: l_gme_batch_step_items (j).minimum_transfer_qty :=
773: p_recipe_rout_matl_tbl (i).minimum_transfer_qty;
774: l_gme_batch_step_items (j).minimum_delay :=
775: p_recipe_rout_matl_tbl (i).minimum_delay;
776: l_gme_batch_step_items (j).maximum_delay :=
770: END IF;
771:
772: l_gme_batch_step_items (j).minimum_transfer_qty :=
773: p_recipe_rout_matl_tbl (i).minimum_transfer_qty;
774: l_gme_batch_step_items (j).minimum_delay :=
775: p_recipe_rout_matl_tbl (i).minimum_delay;
776: l_gme_batch_step_items (j).maximum_delay :=
777: p_recipe_rout_matl_tbl (i).maximum_delay;
778:
772: l_gme_batch_step_items (j).minimum_transfer_qty :=
773: p_recipe_rout_matl_tbl (i).minimum_transfer_qty;
774: l_gme_batch_step_items (j).minimum_delay :=
775: p_recipe_rout_matl_tbl (i).minimum_delay;
776: l_gme_batch_step_items (j).maximum_delay :=
777: p_recipe_rout_matl_tbl (i).maximum_delay;
778:
779: --Rajesh Patangya DFF Enhancement 03Jan2008 Bug# 6195829
780: l_gme_batch_step_items(j).ATTRIBUTE_CATEGORY:= p_recipe_rout_matl_tbl(i).ATTRIBUTE_CATEGORY;
776: l_gme_batch_step_items (j).maximum_delay :=
777: p_recipe_rout_matl_tbl (i).maximum_delay;
778:
779: --Rajesh Patangya DFF Enhancement 03Jan2008 Bug# 6195829
780: l_gme_batch_step_items(j).ATTRIBUTE_CATEGORY:= p_recipe_rout_matl_tbl(i).ATTRIBUTE_CATEGORY;
781: l_gme_batch_step_items(j).ATTRIBUTE1 := p_recipe_rout_matl_tbl(i).ATTRIBUTE1 ;
782: l_gme_batch_step_items(j).ATTRIBUTE2 := p_recipe_rout_matl_tbl(i).ATTRIBUTE2 ;
783: l_gme_batch_step_items(j).ATTRIBUTE3 := p_recipe_rout_matl_tbl(i).ATTRIBUTE3 ;
784: l_gme_batch_step_items(j).ATTRIBUTE4 := p_recipe_rout_matl_tbl(i).ATTRIBUTE4 ;
777: p_recipe_rout_matl_tbl (i).maximum_delay;
778:
779: --Rajesh Patangya DFF Enhancement 03Jan2008 Bug# 6195829
780: l_gme_batch_step_items(j).ATTRIBUTE_CATEGORY:= p_recipe_rout_matl_tbl(i).ATTRIBUTE_CATEGORY;
781: l_gme_batch_step_items(j).ATTRIBUTE1 := p_recipe_rout_matl_tbl(i).ATTRIBUTE1 ;
782: l_gme_batch_step_items(j).ATTRIBUTE2 := p_recipe_rout_matl_tbl(i).ATTRIBUTE2 ;
783: l_gme_batch_step_items(j).ATTRIBUTE3 := p_recipe_rout_matl_tbl(i).ATTRIBUTE3 ;
784: l_gme_batch_step_items(j).ATTRIBUTE4 := p_recipe_rout_matl_tbl(i).ATTRIBUTE4 ;
785: l_gme_batch_step_items(j).ATTRIBUTE5 := p_recipe_rout_matl_tbl(i).ATTRIBUTE5 ;
778:
779: --Rajesh Patangya DFF Enhancement 03Jan2008 Bug# 6195829
780: l_gme_batch_step_items(j).ATTRIBUTE_CATEGORY:= p_recipe_rout_matl_tbl(i).ATTRIBUTE_CATEGORY;
781: l_gme_batch_step_items(j).ATTRIBUTE1 := p_recipe_rout_matl_tbl(i).ATTRIBUTE1 ;
782: l_gme_batch_step_items(j).ATTRIBUTE2 := p_recipe_rout_matl_tbl(i).ATTRIBUTE2 ;
783: l_gme_batch_step_items(j).ATTRIBUTE3 := p_recipe_rout_matl_tbl(i).ATTRIBUTE3 ;
784: l_gme_batch_step_items(j).ATTRIBUTE4 := p_recipe_rout_matl_tbl(i).ATTRIBUTE4 ;
785: l_gme_batch_step_items(j).ATTRIBUTE5 := p_recipe_rout_matl_tbl(i).ATTRIBUTE5 ;
786: l_gme_batch_step_items(j).ATTRIBUTE6 := p_recipe_rout_matl_tbl(i).ATTRIBUTE6 ;
779: --Rajesh Patangya DFF Enhancement 03Jan2008 Bug# 6195829
780: l_gme_batch_step_items(j).ATTRIBUTE_CATEGORY:= p_recipe_rout_matl_tbl(i).ATTRIBUTE_CATEGORY;
781: l_gme_batch_step_items(j).ATTRIBUTE1 := p_recipe_rout_matl_tbl(i).ATTRIBUTE1 ;
782: l_gme_batch_step_items(j).ATTRIBUTE2 := p_recipe_rout_matl_tbl(i).ATTRIBUTE2 ;
783: l_gme_batch_step_items(j).ATTRIBUTE3 := p_recipe_rout_matl_tbl(i).ATTRIBUTE3 ;
784: l_gme_batch_step_items(j).ATTRIBUTE4 := p_recipe_rout_matl_tbl(i).ATTRIBUTE4 ;
785: l_gme_batch_step_items(j).ATTRIBUTE5 := p_recipe_rout_matl_tbl(i).ATTRIBUTE5 ;
786: l_gme_batch_step_items(j).ATTRIBUTE6 := p_recipe_rout_matl_tbl(i).ATTRIBUTE6 ;
787: l_gme_batch_step_items(j).ATTRIBUTE7 := p_recipe_rout_matl_tbl(i).ATTRIBUTE7 ;
780: l_gme_batch_step_items(j).ATTRIBUTE_CATEGORY:= p_recipe_rout_matl_tbl(i).ATTRIBUTE_CATEGORY;
781: l_gme_batch_step_items(j).ATTRIBUTE1 := p_recipe_rout_matl_tbl(i).ATTRIBUTE1 ;
782: l_gme_batch_step_items(j).ATTRIBUTE2 := p_recipe_rout_matl_tbl(i).ATTRIBUTE2 ;
783: l_gme_batch_step_items(j).ATTRIBUTE3 := p_recipe_rout_matl_tbl(i).ATTRIBUTE3 ;
784: l_gme_batch_step_items(j).ATTRIBUTE4 := p_recipe_rout_matl_tbl(i).ATTRIBUTE4 ;
785: l_gme_batch_step_items(j).ATTRIBUTE5 := p_recipe_rout_matl_tbl(i).ATTRIBUTE5 ;
786: l_gme_batch_step_items(j).ATTRIBUTE6 := p_recipe_rout_matl_tbl(i).ATTRIBUTE6 ;
787: l_gme_batch_step_items(j).ATTRIBUTE7 := p_recipe_rout_matl_tbl(i).ATTRIBUTE7 ;
788: l_gme_batch_step_items(j).ATTRIBUTE8 := p_recipe_rout_matl_tbl(i).ATTRIBUTE8 ;
781: l_gme_batch_step_items(j).ATTRIBUTE1 := p_recipe_rout_matl_tbl(i).ATTRIBUTE1 ;
782: l_gme_batch_step_items(j).ATTRIBUTE2 := p_recipe_rout_matl_tbl(i).ATTRIBUTE2 ;
783: l_gme_batch_step_items(j).ATTRIBUTE3 := p_recipe_rout_matl_tbl(i).ATTRIBUTE3 ;
784: l_gme_batch_step_items(j).ATTRIBUTE4 := p_recipe_rout_matl_tbl(i).ATTRIBUTE4 ;
785: l_gme_batch_step_items(j).ATTRIBUTE5 := p_recipe_rout_matl_tbl(i).ATTRIBUTE5 ;
786: l_gme_batch_step_items(j).ATTRIBUTE6 := p_recipe_rout_matl_tbl(i).ATTRIBUTE6 ;
787: l_gme_batch_step_items(j).ATTRIBUTE7 := p_recipe_rout_matl_tbl(i).ATTRIBUTE7 ;
788: l_gme_batch_step_items(j).ATTRIBUTE8 := p_recipe_rout_matl_tbl(i).ATTRIBUTE8 ;
789: l_gme_batch_step_items(j).ATTRIBUTE9 := p_recipe_rout_matl_tbl(i).ATTRIBUTE9 ;
782: l_gme_batch_step_items(j).ATTRIBUTE2 := p_recipe_rout_matl_tbl(i).ATTRIBUTE2 ;
783: l_gme_batch_step_items(j).ATTRIBUTE3 := p_recipe_rout_matl_tbl(i).ATTRIBUTE3 ;
784: l_gme_batch_step_items(j).ATTRIBUTE4 := p_recipe_rout_matl_tbl(i).ATTRIBUTE4 ;
785: l_gme_batch_step_items(j).ATTRIBUTE5 := p_recipe_rout_matl_tbl(i).ATTRIBUTE5 ;
786: l_gme_batch_step_items(j).ATTRIBUTE6 := p_recipe_rout_matl_tbl(i).ATTRIBUTE6 ;
787: l_gme_batch_step_items(j).ATTRIBUTE7 := p_recipe_rout_matl_tbl(i).ATTRIBUTE7 ;
788: l_gme_batch_step_items(j).ATTRIBUTE8 := p_recipe_rout_matl_tbl(i).ATTRIBUTE8 ;
789: l_gme_batch_step_items(j).ATTRIBUTE9 := p_recipe_rout_matl_tbl(i).ATTRIBUTE9 ;
790: l_gme_batch_step_items(j).ATTRIBUTE10 := p_recipe_rout_matl_tbl(i).ATTRIBUTE10 ;
783: l_gme_batch_step_items(j).ATTRIBUTE3 := p_recipe_rout_matl_tbl(i).ATTRIBUTE3 ;
784: l_gme_batch_step_items(j).ATTRIBUTE4 := p_recipe_rout_matl_tbl(i).ATTRIBUTE4 ;
785: l_gme_batch_step_items(j).ATTRIBUTE5 := p_recipe_rout_matl_tbl(i).ATTRIBUTE5 ;
786: l_gme_batch_step_items(j).ATTRIBUTE6 := p_recipe_rout_matl_tbl(i).ATTRIBUTE6 ;
787: l_gme_batch_step_items(j).ATTRIBUTE7 := p_recipe_rout_matl_tbl(i).ATTRIBUTE7 ;
788: l_gme_batch_step_items(j).ATTRIBUTE8 := p_recipe_rout_matl_tbl(i).ATTRIBUTE8 ;
789: l_gme_batch_step_items(j).ATTRIBUTE9 := p_recipe_rout_matl_tbl(i).ATTRIBUTE9 ;
790: l_gme_batch_step_items(j).ATTRIBUTE10 := p_recipe_rout_matl_tbl(i).ATTRIBUTE10 ;
791: l_gme_batch_step_items(j).ATTRIBUTE11 := p_recipe_rout_matl_tbl(i).ATTRIBUTE11 ;
784: l_gme_batch_step_items(j).ATTRIBUTE4 := p_recipe_rout_matl_tbl(i).ATTRIBUTE4 ;
785: l_gme_batch_step_items(j).ATTRIBUTE5 := p_recipe_rout_matl_tbl(i).ATTRIBUTE5 ;
786: l_gme_batch_step_items(j).ATTRIBUTE6 := p_recipe_rout_matl_tbl(i).ATTRIBUTE6 ;
787: l_gme_batch_step_items(j).ATTRIBUTE7 := p_recipe_rout_matl_tbl(i).ATTRIBUTE7 ;
788: l_gme_batch_step_items(j).ATTRIBUTE8 := p_recipe_rout_matl_tbl(i).ATTRIBUTE8 ;
789: l_gme_batch_step_items(j).ATTRIBUTE9 := p_recipe_rout_matl_tbl(i).ATTRIBUTE9 ;
790: l_gme_batch_step_items(j).ATTRIBUTE10 := p_recipe_rout_matl_tbl(i).ATTRIBUTE10 ;
791: l_gme_batch_step_items(j).ATTRIBUTE11 := p_recipe_rout_matl_tbl(i).ATTRIBUTE11 ;
792: l_gme_batch_step_items(j).ATTRIBUTE12 := p_recipe_rout_matl_tbl(i).ATTRIBUTE12 ;
785: l_gme_batch_step_items(j).ATTRIBUTE5 := p_recipe_rout_matl_tbl(i).ATTRIBUTE5 ;
786: l_gme_batch_step_items(j).ATTRIBUTE6 := p_recipe_rout_matl_tbl(i).ATTRIBUTE6 ;
787: l_gme_batch_step_items(j).ATTRIBUTE7 := p_recipe_rout_matl_tbl(i).ATTRIBUTE7 ;
788: l_gme_batch_step_items(j).ATTRIBUTE8 := p_recipe_rout_matl_tbl(i).ATTRIBUTE8 ;
789: l_gme_batch_step_items(j).ATTRIBUTE9 := p_recipe_rout_matl_tbl(i).ATTRIBUTE9 ;
790: l_gme_batch_step_items(j).ATTRIBUTE10 := p_recipe_rout_matl_tbl(i).ATTRIBUTE10 ;
791: l_gme_batch_step_items(j).ATTRIBUTE11 := p_recipe_rout_matl_tbl(i).ATTRIBUTE11 ;
792: l_gme_batch_step_items(j).ATTRIBUTE12 := p_recipe_rout_matl_tbl(i).ATTRIBUTE12 ;
793: l_gme_batch_step_items(j).ATTRIBUTE13 := p_recipe_rout_matl_tbl(i).ATTRIBUTE13 ;
786: l_gme_batch_step_items(j).ATTRIBUTE6 := p_recipe_rout_matl_tbl(i).ATTRIBUTE6 ;
787: l_gme_batch_step_items(j).ATTRIBUTE7 := p_recipe_rout_matl_tbl(i).ATTRIBUTE7 ;
788: l_gme_batch_step_items(j).ATTRIBUTE8 := p_recipe_rout_matl_tbl(i).ATTRIBUTE8 ;
789: l_gme_batch_step_items(j).ATTRIBUTE9 := p_recipe_rout_matl_tbl(i).ATTRIBUTE9 ;
790: l_gme_batch_step_items(j).ATTRIBUTE10 := p_recipe_rout_matl_tbl(i).ATTRIBUTE10 ;
791: l_gme_batch_step_items(j).ATTRIBUTE11 := p_recipe_rout_matl_tbl(i).ATTRIBUTE11 ;
792: l_gme_batch_step_items(j).ATTRIBUTE12 := p_recipe_rout_matl_tbl(i).ATTRIBUTE12 ;
793: l_gme_batch_step_items(j).ATTRIBUTE13 := p_recipe_rout_matl_tbl(i).ATTRIBUTE13 ;
794: l_gme_batch_step_items(j).ATTRIBUTE14 := p_recipe_rout_matl_tbl(i).ATTRIBUTE14 ;
787: l_gme_batch_step_items(j).ATTRIBUTE7 := p_recipe_rout_matl_tbl(i).ATTRIBUTE7 ;
788: l_gme_batch_step_items(j).ATTRIBUTE8 := p_recipe_rout_matl_tbl(i).ATTRIBUTE8 ;
789: l_gme_batch_step_items(j).ATTRIBUTE9 := p_recipe_rout_matl_tbl(i).ATTRIBUTE9 ;
790: l_gme_batch_step_items(j).ATTRIBUTE10 := p_recipe_rout_matl_tbl(i).ATTRIBUTE10 ;
791: l_gme_batch_step_items(j).ATTRIBUTE11 := p_recipe_rout_matl_tbl(i).ATTRIBUTE11 ;
792: l_gme_batch_step_items(j).ATTRIBUTE12 := p_recipe_rout_matl_tbl(i).ATTRIBUTE12 ;
793: l_gme_batch_step_items(j).ATTRIBUTE13 := p_recipe_rout_matl_tbl(i).ATTRIBUTE13 ;
794: l_gme_batch_step_items(j).ATTRIBUTE14 := p_recipe_rout_matl_tbl(i).ATTRIBUTE14 ;
795: l_gme_batch_step_items(j).ATTRIBUTE15 := p_recipe_rout_matl_tbl(i).ATTRIBUTE15 ;
788: l_gme_batch_step_items(j).ATTRIBUTE8 := p_recipe_rout_matl_tbl(i).ATTRIBUTE8 ;
789: l_gme_batch_step_items(j).ATTRIBUTE9 := p_recipe_rout_matl_tbl(i).ATTRIBUTE9 ;
790: l_gme_batch_step_items(j).ATTRIBUTE10 := p_recipe_rout_matl_tbl(i).ATTRIBUTE10 ;
791: l_gme_batch_step_items(j).ATTRIBUTE11 := p_recipe_rout_matl_tbl(i).ATTRIBUTE11 ;
792: l_gme_batch_step_items(j).ATTRIBUTE12 := p_recipe_rout_matl_tbl(i).ATTRIBUTE12 ;
793: l_gme_batch_step_items(j).ATTRIBUTE13 := p_recipe_rout_matl_tbl(i).ATTRIBUTE13 ;
794: l_gme_batch_step_items(j).ATTRIBUTE14 := p_recipe_rout_matl_tbl(i).ATTRIBUTE14 ;
795: l_gme_batch_step_items(j).ATTRIBUTE15 := p_recipe_rout_matl_tbl(i).ATTRIBUTE15 ;
796: l_gme_batch_step_items(j).ATTRIBUTE16 := p_recipe_rout_matl_tbl(i).ATTRIBUTE16 ;
789: l_gme_batch_step_items(j).ATTRIBUTE9 := p_recipe_rout_matl_tbl(i).ATTRIBUTE9 ;
790: l_gme_batch_step_items(j).ATTRIBUTE10 := p_recipe_rout_matl_tbl(i).ATTRIBUTE10 ;
791: l_gme_batch_step_items(j).ATTRIBUTE11 := p_recipe_rout_matl_tbl(i).ATTRIBUTE11 ;
792: l_gme_batch_step_items(j).ATTRIBUTE12 := p_recipe_rout_matl_tbl(i).ATTRIBUTE12 ;
793: l_gme_batch_step_items(j).ATTRIBUTE13 := p_recipe_rout_matl_tbl(i).ATTRIBUTE13 ;
794: l_gme_batch_step_items(j).ATTRIBUTE14 := p_recipe_rout_matl_tbl(i).ATTRIBUTE14 ;
795: l_gme_batch_step_items(j).ATTRIBUTE15 := p_recipe_rout_matl_tbl(i).ATTRIBUTE15 ;
796: l_gme_batch_step_items(j).ATTRIBUTE16 := p_recipe_rout_matl_tbl(i).ATTRIBUTE16 ;
797: l_gme_batch_step_items(j).ATTRIBUTE17 := p_recipe_rout_matl_tbl(i).ATTRIBUTE17 ;
790: l_gme_batch_step_items(j).ATTRIBUTE10 := p_recipe_rout_matl_tbl(i).ATTRIBUTE10 ;
791: l_gme_batch_step_items(j).ATTRIBUTE11 := p_recipe_rout_matl_tbl(i).ATTRIBUTE11 ;
792: l_gme_batch_step_items(j).ATTRIBUTE12 := p_recipe_rout_matl_tbl(i).ATTRIBUTE12 ;
793: l_gme_batch_step_items(j).ATTRIBUTE13 := p_recipe_rout_matl_tbl(i).ATTRIBUTE13 ;
794: l_gme_batch_step_items(j).ATTRIBUTE14 := p_recipe_rout_matl_tbl(i).ATTRIBUTE14 ;
795: l_gme_batch_step_items(j).ATTRIBUTE15 := p_recipe_rout_matl_tbl(i).ATTRIBUTE15 ;
796: l_gme_batch_step_items(j).ATTRIBUTE16 := p_recipe_rout_matl_tbl(i).ATTRIBUTE16 ;
797: l_gme_batch_step_items(j).ATTRIBUTE17 := p_recipe_rout_matl_tbl(i).ATTRIBUTE17 ;
798: l_gme_batch_step_items(j).ATTRIBUTE18 := p_recipe_rout_matl_tbl(i).ATTRIBUTE18 ;
791: l_gme_batch_step_items(j).ATTRIBUTE11 := p_recipe_rout_matl_tbl(i).ATTRIBUTE11 ;
792: l_gme_batch_step_items(j).ATTRIBUTE12 := p_recipe_rout_matl_tbl(i).ATTRIBUTE12 ;
793: l_gme_batch_step_items(j).ATTRIBUTE13 := p_recipe_rout_matl_tbl(i).ATTRIBUTE13 ;
794: l_gme_batch_step_items(j).ATTRIBUTE14 := p_recipe_rout_matl_tbl(i).ATTRIBUTE14 ;
795: l_gme_batch_step_items(j).ATTRIBUTE15 := p_recipe_rout_matl_tbl(i).ATTRIBUTE15 ;
796: l_gme_batch_step_items(j).ATTRIBUTE16 := p_recipe_rout_matl_tbl(i).ATTRIBUTE16 ;
797: l_gme_batch_step_items(j).ATTRIBUTE17 := p_recipe_rout_matl_tbl(i).ATTRIBUTE17 ;
798: l_gme_batch_step_items(j).ATTRIBUTE18 := p_recipe_rout_matl_tbl(i).ATTRIBUTE18 ;
799: l_gme_batch_step_items(j).ATTRIBUTE19 := p_recipe_rout_matl_tbl(i).ATTRIBUTE19 ;
792: l_gme_batch_step_items(j).ATTRIBUTE12 := p_recipe_rout_matl_tbl(i).ATTRIBUTE12 ;
793: l_gme_batch_step_items(j).ATTRIBUTE13 := p_recipe_rout_matl_tbl(i).ATTRIBUTE13 ;
794: l_gme_batch_step_items(j).ATTRIBUTE14 := p_recipe_rout_matl_tbl(i).ATTRIBUTE14 ;
795: l_gme_batch_step_items(j).ATTRIBUTE15 := p_recipe_rout_matl_tbl(i).ATTRIBUTE15 ;
796: l_gme_batch_step_items(j).ATTRIBUTE16 := p_recipe_rout_matl_tbl(i).ATTRIBUTE16 ;
797: l_gme_batch_step_items(j).ATTRIBUTE17 := p_recipe_rout_matl_tbl(i).ATTRIBUTE17 ;
798: l_gme_batch_step_items(j).ATTRIBUTE18 := p_recipe_rout_matl_tbl(i).ATTRIBUTE18 ;
799: l_gme_batch_step_items(j).ATTRIBUTE19 := p_recipe_rout_matl_tbl(i).ATTRIBUTE19 ;
800: l_gme_batch_step_items(j).ATTRIBUTE20 := p_recipe_rout_matl_tbl(i).ATTRIBUTE20 ;
793: l_gme_batch_step_items(j).ATTRIBUTE13 := p_recipe_rout_matl_tbl(i).ATTRIBUTE13 ;
794: l_gme_batch_step_items(j).ATTRIBUTE14 := p_recipe_rout_matl_tbl(i).ATTRIBUTE14 ;
795: l_gme_batch_step_items(j).ATTRIBUTE15 := p_recipe_rout_matl_tbl(i).ATTRIBUTE15 ;
796: l_gme_batch_step_items(j).ATTRIBUTE16 := p_recipe_rout_matl_tbl(i).ATTRIBUTE16 ;
797: l_gme_batch_step_items(j).ATTRIBUTE17 := p_recipe_rout_matl_tbl(i).ATTRIBUTE17 ;
798: l_gme_batch_step_items(j).ATTRIBUTE18 := p_recipe_rout_matl_tbl(i).ATTRIBUTE18 ;
799: l_gme_batch_step_items(j).ATTRIBUTE19 := p_recipe_rout_matl_tbl(i).ATTRIBUTE19 ;
800: l_gme_batch_step_items(j).ATTRIBUTE20 := p_recipe_rout_matl_tbl(i).ATTRIBUTE20 ;
801: l_gme_batch_step_items(j).ATTRIBUTE21 := p_recipe_rout_matl_tbl(i).ATTRIBUTE21 ;
794: l_gme_batch_step_items(j).ATTRIBUTE14 := p_recipe_rout_matl_tbl(i).ATTRIBUTE14 ;
795: l_gme_batch_step_items(j).ATTRIBUTE15 := p_recipe_rout_matl_tbl(i).ATTRIBUTE15 ;
796: l_gme_batch_step_items(j).ATTRIBUTE16 := p_recipe_rout_matl_tbl(i).ATTRIBUTE16 ;
797: l_gme_batch_step_items(j).ATTRIBUTE17 := p_recipe_rout_matl_tbl(i).ATTRIBUTE17 ;
798: l_gme_batch_step_items(j).ATTRIBUTE18 := p_recipe_rout_matl_tbl(i).ATTRIBUTE18 ;
799: l_gme_batch_step_items(j).ATTRIBUTE19 := p_recipe_rout_matl_tbl(i).ATTRIBUTE19 ;
800: l_gme_batch_step_items(j).ATTRIBUTE20 := p_recipe_rout_matl_tbl(i).ATTRIBUTE20 ;
801: l_gme_batch_step_items(j).ATTRIBUTE21 := p_recipe_rout_matl_tbl(i).ATTRIBUTE21 ;
802: l_gme_batch_step_items(j).ATTRIBUTE22 := p_recipe_rout_matl_tbl(i).ATTRIBUTE22 ;
795: l_gme_batch_step_items(j).ATTRIBUTE15 := p_recipe_rout_matl_tbl(i).ATTRIBUTE15 ;
796: l_gme_batch_step_items(j).ATTRIBUTE16 := p_recipe_rout_matl_tbl(i).ATTRIBUTE16 ;
797: l_gme_batch_step_items(j).ATTRIBUTE17 := p_recipe_rout_matl_tbl(i).ATTRIBUTE17 ;
798: l_gme_batch_step_items(j).ATTRIBUTE18 := p_recipe_rout_matl_tbl(i).ATTRIBUTE18 ;
799: l_gme_batch_step_items(j).ATTRIBUTE19 := p_recipe_rout_matl_tbl(i).ATTRIBUTE19 ;
800: l_gme_batch_step_items(j).ATTRIBUTE20 := p_recipe_rout_matl_tbl(i).ATTRIBUTE20 ;
801: l_gme_batch_step_items(j).ATTRIBUTE21 := p_recipe_rout_matl_tbl(i).ATTRIBUTE21 ;
802: l_gme_batch_step_items(j).ATTRIBUTE22 := p_recipe_rout_matl_tbl(i).ATTRIBUTE22 ;
803: l_gme_batch_step_items(j).ATTRIBUTE23 := p_recipe_rout_matl_tbl(i).ATTRIBUTE23 ;
796: l_gme_batch_step_items(j).ATTRIBUTE16 := p_recipe_rout_matl_tbl(i).ATTRIBUTE16 ;
797: l_gme_batch_step_items(j).ATTRIBUTE17 := p_recipe_rout_matl_tbl(i).ATTRIBUTE17 ;
798: l_gme_batch_step_items(j).ATTRIBUTE18 := p_recipe_rout_matl_tbl(i).ATTRIBUTE18 ;
799: l_gme_batch_step_items(j).ATTRIBUTE19 := p_recipe_rout_matl_tbl(i).ATTRIBUTE19 ;
800: l_gme_batch_step_items(j).ATTRIBUTE20 := p_recipe_rout_matl_tbl(i).ATTRIBUTE20 ;
801: l_gme_batch_step_items(j).ATTRIBUTE21 := p_recipe_rout_matl_tbl(i).ATTRIBUTE21 ;
802: l_gme_batch_step_items(j).ATTRIBUTE22 := p_recipe_rout_matl_tbl(i).ATTRIBUTE22 ;
803: l_gme_batch_step_items(j).ATTRIBUTE23 := p_recipe_rout_matl_tbl(i).ATTRIBUTE23 ;
804: l_gme_batch_step_items(j).ATTRIBUTE24 := p_recipe_rout_matl_tbl(i).ATTRIBUTE24 ;
797: l_gme_batch_step_items(j).ATTRIBUTE17 := p_recipe_rout_matl_tbl(i).ATTRIBUTE17 ;
798: l_gme_batch_step_items(j).ATTRIBUTE18 := p_recipe_rout_matl_tbl(i).ATTRIBUTE18 ;
799: l_gme_batch_step_items(j).ATTRIBUTE19 := p_recipe_rout_matl_tbl(i).ATTRIBUTE19 ;
800: l_gme_batch_step_items(j).ATTRIBUTE20 := p_recipe_rout_matl_tbl(i).ATTRIBUTE20 ;
801: l_gme_batch_step_items(j).ATTRIBUTE21 := p_recipe_rout_matl_tbl(i).ATTRIBUTE21 ;
802: l_gme_batch_step_items(j).ATTRIBUTE22 := p_recipe_rout_matl_tbl(i).ATTRIBUTE22 ;
803: l_gme_batch_step_items(j).ATTRIBUTE23 := p_recipe_rout_matl_tbl(i).ATTRIBUTE23 ;
804: l_gme_batch_step_items(j).ATTRIBUTE24 := p_recipe_rout_matl_tbl(i).ATTRIBUTE24 ;
805: l_gme_batch_step_items(j).ATTRIBUTE25 := p_recipe_rout_matl_tbl(i).ATTRIBUTE25 ;
798: l_gme_batch_step_items(j).ATTRIBUTE18 := p_recipe_rout_matl_tbl(i).ATTRIBUTE18 ;
799: l_gme_batch_step_items(j).ATTRIBUTE19 := p_recipe_rout_matl_tbl(i).ATTRIBUTE19 ;
800: l_gme_batch_step_items(j).ATTRIBUTE20 := p_recipe_rout_matl_tbl(i).ATTRIBUTE20 ;
801: l_gme_batch_step_items(j).ATTRIBUTE21 := p_recipe_rout_matl_tbl(i).ATTRIBUTE21 ;
802: l_gme_batch_step_items(j).ATTRIBUTE22 := p_recipe_rout_matl_tbl(i).ATTRIBUTE22 ;
803: l_gme_batch_step_items(j).ATTRIBUTE23 := p_recipe_rout_matl_tbl(i).ATTRIBUTE23 ;
804: l_gme_batch_step_items(j).ATTRIBUTE24 := p_recipe_rout_matl_tbl(i).ATTRIBUTE24 ;
805: l_gme_batch_step_items(j).ATTRIBUTE25 := p_recipe_rout_matl_tbl(i).ATTRIBUTE25 ;
806: l_gme_batch_step_items(j).ATTRIBUTE26 := p_recipe_rout_matl_tbl(i).ATTRIBUTE26 ;
799: l_gme_batch_step_items(j).ATTRIBUTE19 := p_recipe_rout_matl_tbl(i).ATTRIBUTE19 ;
800: l_gme_batch_step_items(j).ATTRIBUTE20 := p_recipe_rout_matl_tbl(i).ATTRIBUTE20 ;
801: l_gme_batch_step_items(j).ATTRIBUTE21 := p_recipe_rout_matl_tbl(i).ATTRIBUTE21 ;
802: l_gme_batch_step_items(j).ATTRIBUTE22 := p_recipe_rout_matl_tbl(i).ATTRIBUTE22 ;
803: l_gme_batch_step_items(j).ATTRIBUTE23 := p_recipe_rout_matl_tbl(i).ATTRIBUTE23 ;
804: l_gme_batch_step_items(j).ATTRIBUTE24 := p_recipe_rout_matl_tbl(i).ATTRIBUTE24 ;
805: l_gme_batch_step_items(j).ATTRIBUTE25 := p_recipe_rout_matl_tbl(i).ATTRIBUTE25 ;
806: l_gme_batch_step_items(j).ATTRIBUTE26 := p_recipe_rout_matl_tbl(i).ATTRIBUTE26 ;
807: l_gme_batch_step_items(j).ATTRIBUTE27 := p_recipe_rout_matl_tbl(i).ATTRIBUTE27 ;
800: l_gme_batch_step_items(j).ATTRIBUTE20 := p_recipe_rout_matl_tbl(i).ATTRIBUTE20 ;
801: l_gme_batch_step_items(j).ATTRIBUTE21 := p_recipe_rout_matl_tbl(i).ATTRIBUTE21 ;
802: l_gme_batch_step_items(j).ATTRIBUTE22 := p_recipe_rout_matl_tbl(i).ATTRIBUTE22 ;
803: l_gme_batch_step_items(j).ATTRIBUTE23 := p_recipe_rout_matl_tbl(i).ATTRIBUTE23 ;
804: l_gme_batch_step_items(j).ATTRIBUTE24 := p_recipe_rout_matl_tbl(i).ATTRIBUTE24 ;
805: l_gme_batch_step_items(j).ATTRIBUTE25 := p_recipe_rout_matl_tbl(i).ATTRIBUTE25 ;
806: l_gme_batch_step_items(j).ATTRIBUTE26 := p_recipe_rout_matl_tbl(i).ATTRIBUTE26 ;
807: l_gme_batch_step_items(j).ATTRIBUTE27 := p_recipe_rout_matl_tbl(i).ATTRIBUTE27 ;
808: l_gme_batch_step_items(j).ATTRIBUTE28 := p_recipe_rout_matl_tbl(i).ATTRIBUTE28 ;
801: l_gme_batch_step_items(j).ATTRIBUTE21 := p_recipe_rout_matl_tbl(i).ATTRIBUTE21 ;
802: l_gme_batch_step_items(j).ATTRIBUTE22 := p_recipe_rout_matl_tbl(i).ATTRIBUTE22 ;
803: l_gme_batch_step_items(j).ATTRIBUTE23 := p_recipe_rout_matl_tbl(i).ATTRIBUTE23 ;
804: l_gme_batch_step_items(j).ATTRIBUTE24 := p_recipe_rout_matl_tbl(i).ATTRIBUTE24 ;
805: l_gme_batch_step_items(j).ATTRIBUTE25 := p_recipe_rout_matl_tbl(i).ATTRIBUTE25 ;
806: l_gme_batch_step_items(j).ATTRIBUTE26 := p_recipe_rout_matl_tbl(i).ATTRIBUTE26 ;
807: l_gme_batch_step_items(j).ATTRIBUTE27 := p_recipe_rout_matl_tbl(i).ATTRIBUTE27 ;
808: l_gme_batch_step_items(j).ATTRIBUTE28 := p_recipe_rout_matl_tbl(i).ATTRIBUTE28 ;
809: l_gme_batch_step_items(j).ATTRIBUTE29 := p_recipe_rout_matl_tbl(i).ATTRIBUTE29 ;
802: l_gme_batch_step_items(j).ATTRIBUTE22 := p_recipe_rout_matl_tbl(i).ATTRIBUTE22 ;
803: l_gme_batch_step_items(j).ATTRIBUTE23 := p_recipe_rout_matl_tbl(i).ATTRIBUTE23 ;
804: l_gme_batch_step_items(j).ATTRIBUTE24 := p_recipe_rout_matl_tbl(i).ATTRIBUTE24 ;
805: l_gme_batch_step_items(j).ATTRIBUTE25 := p_recipe_rout_matl_tbl(i).ATTRIBUTE25 ;
806: l_gme_batch_step_items(j).ATTRIBUTE26 := p_recipe_rout_matl_tbl(i).ATTRIBUTE26 ;
807: l_gme_batch_step_items(j).ATTRIBUTE27 := p_recipe_rout_matl_tbl(i).ATTRIBUTE27 ;
808: l_gme_batch_step_items(j).ATTRIBUTE28 := p_recipe_rout_matl_tbl(i).ATTRIBUTE28 ;
809: l_gme_batch_step_items(j).ATTRIBUTE29 := p_recipe_rout_matl_tbl(i).ATTRIBUTE29 ;
810: l_gme_batch_step_items(j).ATTRIBUTE30 := p_recipe_rout_matl_tbl(i).ATTRIBUTE30 ;
803: l_gme_batch_step_items(j).ATTRIBUTE23 := p_recipe_rout_matl_tbl(i).ATTRIBUTE23 ;
804: l_gme_batch_step_items(j).ATTRIBUTE24 := p_recipe_rout_matl_tbl(i).ATTRIBUTE24 ;
805: l_gme_batch_step_items(j).ATTRIBUTE25 := p_recipe_rout_matl_tbl(i).ATTRIBUTE25 ;
806: l_gme_batch_step_items(j).ATTRIBUTE26 := p_recipe_rout_matl_tbl(i).ATTRIBUTE26 ;
807: l_gme_batch_step_items(j).ATTRIBUTE27 := p_recipe_rout_matl_tbl(i).ATTRIBUTE27 ;
808: l_gme_batch_step_items(j).ATTRIBUTE28 := p_recipe_rout_matl_tbl(i).ATTRIBUTE28 ;
809: l_gme_batch_step_items(j).ATTRIBUTE29 := p_recipe_rout_matl_tbl(i).ATTRIBUTE29 ;
810: l_gme_batch_step_items(j).ATTRIBUTE30 := p_recipe_rout_matl_tbl(i).ATTRIBUTE30 ;
811:
804: l_gme_batch_step_items(j).ATTRIBUTE24 := p_recipe_rout_matl_tbl(i).ATTRIBUTE24 ;
805: l_gme_batch_step_items(j).ATTRIBUTE25 := p_recipe_rout_matl_tbl(i).ATTRIBUTE25 ;
806: l_gme_batch_step_items(j).ATTRIBUTE26 := p_recipe_rout_matl_tbl(i).ATTRIBUTE26 ;
807: l_gme_batch_step_items(j).ATTRIBUTE27 := p_recipe_rout_matl_tbl(i).ATTRIBUTE27 ;
808: l_gme_batch_step_items(j).ATTRIBUTE28 := p_recipe_rout_matl_tbl(i).ATTRIBUTE28 ;
809: l_gme_batch_step_items(j).ATTRIBUTE29 := p_recipe_rout_matl_tbl(i).ATTRIBUTE29 ;
810: l_gme_batch_step_items(j).ATTRIBUTE30 := p_recipe_rout_matl_tbl(i).ATTRIBUTE30 ;
811:
812: IF (gme_batch_step_items_dbl.insert_row
805: l_gme_batch_step_items(j).ATTRIBUTE25 := p_recipe_rout_matl_tbl(i).ATTRIBUTE25 ;
806: l_gme_batch_step_items(j).ATTRIBUTE26 := p_recipe_rout_matl_tbl(i).ATTRIBUTE26 ;
807: l_gme_batch_step_items(j).ATTRIBUTE27 := p_recipe_rout_matl_tbl(i).ATTRIBUTE27 ;
808: l_gme_batch_step_items(j).ATTRIBUTE28 := p_recipe_rout_matl_tbl(i).ATTRIBUTE28 ;
809: l_gme_batch_step_items(j).ATTRIBUTE29 := p_recipe_rout_matl_tbl(i).ATTRIBUTE29 ;
810: l_gme_batch_step_items(j).ATTRIBUTE30 := p_recipe_rout_matl_tbl(i).ATTRIBUTE30 ;
811:
812: IF (gme_batch_step_items_dbl.insert_row
813: (p_batch_step_items => l_gme_batch_step_items
806: l_gme_batch_step_items(j).ATTRIBUTE26 := p_recipe_rout_matl_tbl(i).ATTRIBUTE26 ;
807: l_gme_batch_step_items(j).ATTRIBUTE27 := p_recipe_rout_matl_tbl(i).ATTRIBUTE27 ;
808: l_gme_batch_step_items(j).ATTRIBUTE28 := p_recipe_rout_matl_tbl(i).ATTRIBUTE28 ;
809: l_gme_batch_step_items(j).ATTRIBUTE29 := p_recipe_rout_matl_tbl(i).ATTRIBUTE29 ;
810: l_gme_batch_step_items(j).ATTRIBUTE30 := p_recipe_rout_matl_tbl(i).ATTRIBUTE30 ;
811:
812: IF (gme_batch_step_items_dbl.insert_row
813: (p_batch_step_items => l_gme_batch_step_items
814: (j)
808: l_gme_batch_step_items(j).ATTRIBUTE28 := p_recipe_rout_matl_tbl(i).ATTRIBUTE28 ;
809: l_gme_batch_step_items(j).ATTRIBUTE29 := p_recipe_rout_matl_tbl(i).ATTRIBUTE29 ;
810: l_gme_batch_step_items(j).ATTRIBUTE30 := p_recipe_rout_matl_tbl(i).ATTRIBUTE30 ;
811:
812: IF (gme_batch_step_items_dbl.insert_row
813: (p_batch_step_items => l_gme_batch_step_items
814: (j)
815: ,x_batch_step_items => l_gme_batch_step_items
816: (j) ) ) THEN
809: l_gme_batch_step_items(j).ATTRIBUTE29 := p_recipe_rout_matl_tbl(i).ATTRIBUTE29 ;
810: l_gme_batch_step_items(j).ATTRIBUTE30 := p_recipe_rout_matl_tbl(i).ATTRIBUTE30 ;
811:
812: IF (gme_batch_step_items_dbl.insert_row
813: (p_batch_step_items => l_gme_batch_step_items
814: (j)
815: ,x_batch_step_items => l_gme_batch_step_items
816: (j) ) ) THEN
817: NULL;
811:
812: IF (gme_batch_step_items_dbl.insert_row
813: (p_batch_step_items => l_gme_batch_step_items
814: (j)
815: ,x_batch_step_items => l_gme_batch_step_items
816: (j) ) ) THEN
817: NULL;
818: ELSE
819: RAISE error_insert_b_step_items;
822: i := p_recipe_rout_matl_tbl.NEXT (i);
823: END LOOP; /* WHILE i IS NOT NULL ; STEP ITEM ASSOCIATIONS*/
824:
825: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
826: gme_debug.put_line ('Completed GME_BATCH_STEP_ITEMS');
827: gme_debug.put_line ('GME_BATCH_STEP_DEPENDENCIES');
828: END IF;
829:
830: -- Create data for GME_BATCH_STEP_DEPENDENCIES