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: ();
746: END IF;
747: END LOOP;
748:
749: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
750: gme_debug.put_line ('GME_BATCH_STEP_ITEMS');
751: END IF;
752:
753: -- Create data for GME_BATCH_STEP_ITEMS --> item/step assocations...
754: i := p_recipe_rout_matl_tbl.FIRST;
749: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
750: gme_debug.put_line ('GME_BATCH_STEP_ITEMS');
751: END IF;
752:
753: -- Create data for GME_BATCH_STEP_ITEMS --> item/step assocations...
754: i := p_recipe_rout_matl_tbl.FIRST;
755: j := 0;
756: l_skip := 0;
757:
757:
758: WHILE i IS NOT NULL LOOP
759: -- Bug 9694223 - The l_skip variable tells us if the j index was really used or not for the previous item step assoc.
760: IF l_skip = 0 THEN
761: l_gme_batch_step_items.EXTEND;
762:
763: IF (j = 0) THEN
764: j := l_gme_batch_step_items.FIRST;
765: ELSE
760: IF l_skip = 0 THEN
761: l_gme_batch_step_items.EXTEND;
762:
763: IF (j = 0) THEN
764: j := l_gme_batch_step_items.FIRST;
765: ELSE
766: j := l_gme_batch_step_items.NEXT (j);
767: END IF;
768: ELSE
762:
763: IF (j = 0) THEN
764: j := l_gme_batch_step_items.FIRST;
765: ELSE
766: j := l_gme_batch_step_items.NEXT (j);
767: END IF;
768: ELSE
769: l_skip := 0;
770: END IF;
768: ELSE
769: l_skip := 0;
770: END IF;
771:
772: l_gme_batch_step_items (j).batch_id := l_batch_id;
773:
774: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
775: gme_debug.put_line ('batch_id is '||l_batch_id);
776: gme_debug.put_line ('formulaline_id is '||p_recipe_rout_matl_tbl (i).formulaline_id);
789: IF l_count = 0 THEN
790: l_skip := 1;
791: ELSE
792: SELECT material_detail_id
793: INTO l_gme_batch_step_items (j).material_detail_id
794: FROM gme_material_details
795: WHERE batch_id = l_batch_id
796: AND formulaline_id = p_recipe_rout_matl_tbl (i).formulaline_id;
797:
796: AND formulaline_id = p_recipe_rout_matl_tbl (i).formulaline_id;
797:
798: IF (p_recipe_rout_matl_tbl (i).routingstep_id IS NOT NULL) THEN
799: SELECT batchstep_id
800: INTO l_gme_batch_step_items (j).batchstep_id
801: FROM gme_batch_steps
802: WHERE batch_id = l_batch_id
803: AND routingstep_id = p_recipe_rout_matl_tbl (i).routingstep_id;
804: ELSE
801: FROM gme_batch_steps
802: WHERE batch_id = l_batch_id
803: AND routingstep_id = p_recipe_rout_matl_tbl (i).routingstep_id;
804: ELSE
805: l_gme_batch_step_items (j).batchstep_id := l_last_batchstep_id;
806: END IF;
807:
808: l_gme_batch_step_items (j).minimum_transfer_qty :=
809: p_recipe_rout_matl_tbl (i).minimum_transfer_qty;
804: ELSE
805: l_gme_batch_step_items (j).batchstep_id := l_last_batchstep_id;
806: END IF;
807:
808: l_gme_batch_step_items (j).minimum_transfer_qty :=
809: p_recipe_rout_matl_tbl (i).minimum_transfer_qty;
810: l_gme_batch_step_items (j).minimum_delay :=
811: p_recipe_rout_matl_tbl (i).minimum_delay;
812: l_gme_batch_step_items (j).maximum_delay :=
806: END IF;
807:
808: l_gme_batch_step_items (j).minimum_transfer_qty :=
809: p_recipe_rout_matl_tbl (i).minimum_transfer_qty;
810: l_gme_batch_step_items (j).minimum_delay :=
811: p_recipe_rout_matl_tbl (i).minimum_delay;
812: l_gme_batch_step_items (j).maximum_delay :=
813: p_recipe_rout_matl_tbl (i).maximum_delay;
814:
808: l_gme_batch_step_items (j).minimum_transfer_qty :=
809: p_recipe_rout_matl_tbl (i).minimum_transfer_qty;
810: l_gme_batch_step_items (j).minimum_delay :=
811: p_recipe_rout_matl_tbl (i).minimum_delay;
812: l_gme_batch_step_items (j).maximum_delay :=
813: p_recipe_rout_matl_tbl (i).maximum_delay;
814:
815: --Rajesh Patangya DFF Enhancement 03Jan2008 Bug# 6195829
816: l_gme_batch_step_items(j).ATTRIBUTE_CATEGORY:= p_recipe_rout_matl_tbl(i).ATTRIBUTE_CATEGORY;
812: l_gme_batch_step_items (j).maximum_delay :=
813: p_recipe_rout_matl_tbl (i).maximum_delay;
814:
815: --Rajesh Patangya DFF Enhancement 03Jan2008 Bug# 6195829
816: l_gme_batch_step_items(j).ATTRIBUTE_CATEGORY:= p_recipe_rout_matl_tbl(i).ATTRIBUTE_CATEGORY;
817: l_gme_batch_step_items(j).ATTRIBUTE1 := p_recipe_rout_matl_tbl(i).ATTRIBUTE1 ;
818: l_gme_batch_step_items(j).ATTRIBUTE2 := p_recipe_rout_matl_tbl(i).ATTRIBUTE2 ;
819: l_gme_batch_step_items(j).ATTRIBUTE3 := p_recipe_rout_matl_tbl(i).ATTRIBUTE3 ;
820: l_gme_batch_step_items(j).ATTRIBUTE4 := p_recipe_rout_matl_tbl(i).ATTRIBUTE4 ;
813: p_recipe_rout_matl_tbl (i).maximum_delay;
814:
815: --Rajesh Patangya DFF Enhancement 03Jan2008 Bug# 6195829
816: l_gme_batch_step_items(j).ATTRIBUTE_CATEGORY:= p_recipe_rout_matl_tbl(i).ATTRIBUTE_CATEGORY;
817: l_gme_batch_step_items(j).ATTRIBUTE1 := p_recipe_rout_matl_tbl(i).ATTRIBUTE1 ;
818: l_gme_batch_step_items(j).ATTRIBUTE2 := p_recipe_rout_matl_tbl(i).ATTRIBUTE2 ;
819: l_gme_batch_step_items(j).ATTRIBUTE3 := p_recipe_rout_matl_tbl(i).ATTRIBUTE3 ;
820: l_gme_batch_step_items(j).ATTRIBUTE4 := p_recipe_rout_matl_tbl(i).ATTRIBUTE4 ;
821: l_gme_batch_step_items(j).ATTRIBUTE5 := p_recipe_rout_matl_tbl(i).ATTRIBUTE5 ;
814:
815: --Rajesh Patangya DFF Enhancement 03Jan2008 Bug# 6195829
816: l_gme_batch_step_items(j).ATTRIBUTE_CATEGORY:= p_recipe_rout_matl_tbl(i).ATTRIBUTE_CATEGORY;
817: l_gme_batch_step_items(j).ATTRIBUTE1 := p_recipe_rout_matl_tbl(i).ATTRIBUTE1 ;
818: l_gme_batch_step_items(j).ATTRIBUTE2 := p_recipe_rout_matl_tbl(i).ATTRIBUTE2 ;
819: l_gme_batch_step_items(j).ATTRIBUTE3 := p_recipe_rout_matl_tbl(i).ATTRIBUTE3 ;
820: l_gme_batch_step_items(j).ATTRIBUTE4 := p_recipe_rout_matl_tbl(i).ATTRIBUTE4 ;
821: l_gme_batch_step_items(j).ATTRIBUTE5 := p_recipe_rout_matl_tbl(i).ATTRIBUTE5 ;
822: l_gme_batch_step_items(j).ATTRIBUTE6 := p_recipe_rout_matl_tbl(i).ATTRIBUTE6 ;
815: --Rajesh Patangya DFF Enhancement 03Jan2008 Bug# 6195829
816: l_gme_batch_step_items(j).ATTRIBUTE_CATEGORY:= p_recipe_rout_matl_tbl(i).ATTRIBUTE_CATEGORY;
817: l_gme_batch_step_items(j).ATTRIBUTE1 := p_recipe_rout_matl_tbl(i).ATTRIBUTE1 ;
818: l_gme_batch_step_items(j).ATTRIBUTE2 := p_recipe_rout_matl_tbl(i).ATTRIBUTE2 ;
819: l_gme_batch_step_items(j).ATTRIBUTE3 := p_recipe_rout_matl_tbl(i).ATTRIBUTE3 ;
820: l_gme_batch_step_items(j).ATTRIBUTE4 := p_recipe_rout_matl_tbl(i).ATTRIBUTE4 ;
821: l_gme_batch_step_items(j).ATTRIBUTE5 := p_recipe_rout_matl_tbl(i).ATTRIBUTE5 ;
822: l_gme_batch_step_items(j).ATTRIBUTE6 := p_recipe_rout_matl_tbl(i).ATTRIBUTE6 ;
823: l_gme_batch_step_items(j).ATTRIBUTE7 := p_recipe_rout_matl_tbl(i).ATTRIBUTE7 ;
816: l_gme_batch_step_items(j).ATTRIBUTE_CATEGORY:= p_recipe_rout_matl_tbl(i).ATTRIBUTE_CATEGORY;
817: l_gme_batch_step_items(j).ATTRIBUTE1 := p_recipe_rout_matl_tbl(i).ATTRIBUTE1 ;
818: l_gme_batch_step_items(j).ATTRIBUTE2 := p_recipe_rout_matl_tbl(i).ATTRIBUTE2 ;
819: l_gme_batch_step_items(j).ATTRIBUTE3 := p_recipe_rout_matl_tbl(i).ATTRIBUTE3 ;
820: l_gme_batch_step_items(j).ATTRIBUTE4 := p_recipe_rout_matl_tbl(i).ATTRIBUTE4 ;
821: l_gme_batch_step_items(j).ATTRIBUTE5 := p_recipe_rout_matl_tbl(i).ATTRIBUTE5 ;
822: l_gme_batch_step_items(j).ATTRIBUTE6 := p_recipe_rout_matl_tbl(i).ATTRIBUTE6 ;
823: l_gme_batch_step_items(j).ATTRIBUTE7 := p_recipe_rout_matl_tbl(i).ATTRIBUTE7 ;
824: l_gme_batch_step_items(j).ATTRIBUTE8 := p_recipe_rout_matl_tbl(i).ATTRIBUTE8 ;
817: l_gme_batch_step_items(j).ATTRIBUTE1 := p_recipe_rout_matl_tbl(i).ATTRIBUTE1 ;
818: l_gme_batch_step_items(j).ATTRIBUTE2 := p_recipe_rout_matl_tbl(i).ATTRIBUTE2 ;
819: l_gme_batch_step_items(j).ATTRIBUTE3 := p_recipe_rout_matl_tbl(i).ATTRIBUTE3 ;
820: l_gme_batch_step_items(j).ATTRIBUTE4 := p_recipe_rout_matl_tbl(i).ATTRIBUTE4 ;
821: l_gme_batch_step_items(j).ATTRIBUTE5 := p_recipe_rout_matl_tbl(i).ATTRIBUTE5 ;
822: l_gme_batch_step_items(j).ATTRIBUTE6 := p_recipe_rout_matl_tbl(i).ATTRIBUTE6 ;
823: l_gme_batch_step_items(j).ATTRIBUTE7 := p_recipe_rout_matl_tbl(i).ATTRIBUTE7 ;
824: l_gme_batch_step_items(j).ATTRIBUTE8 := p_recipe_rout_matl_tbl(i).ATTRIBUTE8 ;
825: l_gme_batch_step_items(j).ATTRIBUTE9 := p_recipe_rout_matl_tbl(i).ATTRIBUTE9 ;
818: l_gme_batch_step_items(j).ATTRIBUTE2 := p_recipe_rout_matl_tbl(i).ATTRIBUTE2 ;
819: l_gme_batch_step_items(j).ATTRIBUTE3 := p_recipe_rout_matl_tbl(i).ATTRIBUTE3 ;
820: l_gme_batch_step_items(j).ATTRIBUTE4 := p_recipe_rout_matl_tbl(i).ATTRIBUTE4 ;
821: l_gme_batch_step_items(j).ATTRIBUTE5 := p_recipe_rout_matl_tbl(i).ATTRIBUTE5 ;
822: l_gme_batch_step_items(j).ATTRIBUTE6 := p_recipe_rout_matl_tbl(i).ATTRIBUTE6 ;
823: l_gme_batch_step_items(j).ATTRIBUTE7 := p_recipe_rout_matl_tbl(i).ATTRIBUTE7 ;
824: l_gme_batch_step_items(j).ATTRIBUTE8 := p_recipe_rout_matl_tbl(i).ATTRIBUTE8 ;
825: l_gme_batch_step_items(j).ATTRIBUTE9 := p_recipe_rout_matl_tbl(i).ATTRIBUTE9 ;
826: l_gme_batch_step_items(j).ATTRIBUTE10 := p_recipe_rout_matl_tbl(i).ATTRIBUTE10 ;
819: l_gme_batch_step_items(j).ATTRIBUTE3 := p_recipe_rout_matl_tbl(i).ATTRIBUTE3 ;
820: l_gme_batch_step_items(j).ATTRIBUTE4 := p_recipe_rout_matl_tbl(i).ATTRIBUTE4 ;
821: l_gme_batch_step_items(j).ATTRIBUTE5 := p_recipe_rout_matl_tbl(i).ATTRIBUTE5 ;
822: l_gme_batch_step_items(j).ATTRIBUTE6 := p_recipe_rout_matl_tbl(i).ATTRIBUTE6 ;
823: l_gme_batch_step_items(j).ATTRIBUTE7 := p_recipe_rout_matl_tbl(i).ATTRIBUTE7 ;
824: l_gme_batch_step_items(j).ATTRIBUTE8 := p_recipe_rout_matl_tbl(i).ATTRIBUTE8 ;
825: l_gme_batch_step_items(j).ATTRIBUTE9 := p_recipe_rout_matl_tbl(i).ATTRIBUTE9 ;
826: l_gme_batch_step_items(j).ATTRIBUTE10 := p_recipe_rout_matl_tbl(i).ATTRIBUTE10 ;
827: l_gme_batch_step_items(j).ATTRIBUTE11 := p_recipe_rout_matl_tbl(i).ATTRIBUTE11 ;
820: l_gme_batch_step_items(j).ATTRIBUTE4 := p_recipe_rout_matl_tbl(i).ATTRIBUTE4 ;
821: l_gme_batch_step_items(j).ATTRIBUTE5 := p_recipe_rout_matl_tbl(i).ATTRIBUTE5 ;
822: l_gme_batch_step_items(j).ATTRIBUTE6 := p_recipe_rout_matl_tbl(i).ATTRIBUTE6 ;
823: l_gme_batch_step_items(j).ATTRIBUTE7 := p_recipe_rout_matl_tbl(i).ATTRIBUTE7 ;
824: l_gme_batch_step_items(j).ATTRIBUTE8 := p_recipe_rout_matl_tbl(i).ATTRIBUTE8 ;
825: l_gme_batch_step_items(j).ATTRIBUTE9 := p_recipe_rout_matl_tbl(i).ATTRIBUTE9 ;
826: l_gme_batch_step_items(j).ATTRIBUTE10 := p_recipe_rout_matl_tbl(i).ATTRIBUTE10 ;
827: l_gme_batch_step_items(j).ATTRIBUTE11 := p_recipe_rout_matl_tbl(i).ATTRIBUTE11 ;
828: l_gme_batch_step_items(j).ATTRIBUTE12 := p_recipe_rout_matl_tbl(i).ATTRIBUTE12 ;
821: l_gme_batch_step_items(j).ATTRIBUTE5 := p_recipe_rout_matl_tbl(i).ATTRIBUTE5 ;
822: l_gme_batch_step_items(j).ATTRIBUTE6 := p_recipe_rout_matl_tbl(i).ATTRIBUTE6 ;
823: l_gme_batch_step_items(j).ATTRIBUTE7 := p_recipe_rout_matl_tbl(i).ATTRIBUTE7 ;
824: l_gme_batch_step_items(j).ATTRIBUTE8 := p_recipe_rout_matl_tbl(i).ATTRIBUTE8 ;
825: l_gme_batch_step_items(j).ATTRIBUTE9 := p_recipe_rout_matl_tbl(i).ATTRIBUTE9 ;
826: l_gme_batch_step_items(j).ATTRIBUTE10 := p_recipe_rout_matl_tbl(i).ATTRIBUTE10 ;
827: l_gme_batch_step_items(j).ATTRIBUTE11 := p_recipe_rout_matl_tbl(i).ATTRIBUTE11 ;
828: l_gme_batch_step_items(j).ATTRIBUTE12 := p_recipe_rout_matl_tbl(i).ATTRIBUTE12 ;
829: l_gme_batch_step_items(j).ATTRIBUTE13 := p_recipe_rout_matl_tbl(i).ATTRIBUTE13 ;
822: l_gme_batch_step_items(j).ATTRIBUTE6 := p_recipe_rout_matl_tbl(i).ATTRIBUTE6 ;
823: l_gme_batch_step_items(j).ATTRIBUTE7 := p_recipe_rout_matl_tbl(i).ATTRIBUTE7 ;
824: l_gme_batch_step_items(j).ATTRIBUTE8 := p_recipe_rout_matl_tbl(i).ATTRIBUTE8 ;
825: l_gme_batch_step_items(j).ATTRIBUTE9 := p_recipe_rout_matl_tbl(i).ATTRIBUTE9 ;
826: l_gme_batch_step_items(j).ATTRIBUTE10 := p_recipe_rout_matl_tbl(i).ATTRIBUTE10 ;
827: l_gme_batch_step_items(j).ATTRIBUTE11 := p_recipe_rout_matl_tbl(i).ATTRIBUTE11 ;
828: l_gme_batch_step_items(j).ATTRIBUTE12 := p_recipe_rout_matl_tbl(i).ATTRIBUTE12 ;
829: l_gme_batch_step_items(j).ATTRIBUTE13 := p_recipe_rout_matl_tbl(i).ATTRIBUTE13 ;
830: l_gme_batch_step_items(j).ATTRIBUTE14 := p_recipe_rout_matl_tbl(i).ATTRIBUTE14 ;
823: l_gme_batch_step_items(j).ATTRIBUTE7 := p_recipe_rout_matl_tbl(i).ATTRIBUTE7 ;
824: l_gme_batch_step_items(j).ATTRIBUTE8 := p_recipe_rout_matl_tbl(i).ATTRIBUTE8 ;
825: l_gme_batch_step_items(j).ATTRIBUTE9 := p_recipe_rout_matl_tbl(i).ATTRIBUTE9 ;
826: l_gme_batch_step_items(j).ATTRIBUTE10 := p_recipe_rout_matl_tbl(i).ATTRIBUTE10 ;
827: l_gme_batch_step_items(j).ATTRIBUTE11 := p_recipe_rout_matl_tbl(i).ATTRIBUTE11 ;
828: l_gme_batch_step_items(j).ATTRIBUTE12 := p_recipe_rout_matl_tbl(i).ATTRIBUTE12 ;
829: l_gme_batch_step_items(j).ATTRIBUTE13 := p_recipe_rout_matl_tbl(i).ATTRIBUTE13 ;
830: l_gme_batch_step_items(j).ATTRIBUTE14 := p_recipe_rout_matl_tbl(i).ATTRIBUTE14 ;
831: l_gme_batch_step_items(j).ATTRIBUTE15 := p_recipe_rout_matl_tbl(i).ATTRIBUTE15 ;
824: l_gme_batch_step_items(j).ATTRIBUTE8 := p_recipe_rout_matl_tbl(i).ATTRIBUTE8 ;
825: l_gme_batch_step_items(j).ATTRIBUTE9 := p_recipe_rout_matl_tbl(i).ATTRIBUTE9 ;
826: l_gme_batch_step_items(j).ATTRIBUTE10 := p_recipe_rout_matl_tbl(i).ATTRIBUTE10 ;
827: l_gme_batch_step_items(j).ATTRIBUTE11 := p_recipe_rout_matl_tbl(i).ATTRIBUTE11 ;
828: l_gme_batch_step_items(j).ATTRIBUTE12 := p_recipe_rout_matl_tbl(i).ATTRIBUTE12 ;
829: l_gme_batch_step_items(j).ATTRIBUTE13 := p_recipe_rout_matl_tbl(i).ATTRIBUTE13 ;
830: l_gme_batch_step_items(j).ATTRIBUTE14 := p_recipe_rout_matl_tbl(i).ATTRIBUTE14 ;
831: l_gme_batch_step_items(j).ATTRIBUTE15 := p_recipe_rout_matl_tbl(i).ATTRIBUTE15 ;
832: l_gme_batch_step_items(j).ATTRIBUTE16 := p_recipe_rout_matl_tbl(i).ATTRIBUTE16 ;
825: l_gme_batch_step_items(j).ATTRIBUTE9 := p_recipe_rout_matl_tbl(i).ATTRIBUTE9 ;
826: l_gme_batch_step_items(j).ATTRIBUTE10 := p_recipe_rout_matl_tbl(i).ATTRIBUTE10 ;
827: l_gme_batch_step_items(j).ATTRIBUTE11 := p_recipe_rout_matl_tbl(i).ATTRIBUTE11 ;
828: l_gme_batch_step_items(j).ATTRIBUTE12 := p_recipe_rout_matl_tbl(i).ATTRIBUTE12 ;
829: l_gme_batch_step_items(j).ATTRIBUTE13 := p_recipe_rout_matl_tbl(i).ATTRIBUTE13 ;
830: l_gme_batch_step_items(j).ATTRIBUTE14 := p_recipe_rout_matl_tbl(i).ATTRIBUTE14 ;
831: l_gme_batch_step_items(j).ATTRIBUTE15 := p_recipe_rout_matl_tbl(i).ATTRIBUTE15 ;
832: l_gme_batch_step_items(j).ATTRIBUTE16 := p_recipe_rout_matl_tbl(i).ATTRIBUTE16 ;
833: l_gme_batch_step_items(j).ATTRIBUTE17 := p_recipe_rout_matl_tbl(i).ATTRIBUTE17 ;
826: l_gme_batch_step_items(j).ATTRIBUTE10 := p_recipe_rout_matl_tbl(i).ATTRIBUTE10 ;
827: l_gme_batch_step_items(j).ATTRIBUTE11 := p_recipe_rout_matl_tbl(i).ATTRIBUTE11 ;
828: l_gme_batch_step_items(j).ATTRIBUTE12 := p_recipe_rout_matl_tbl(i).ATTRIBUTE12 ;
829: l_gme_batch_step_items(j).ATTRIBUTE13 := p_recipe_rout_matl_tbl(i).ATTRIBUTE13 ;
830: l_gme_batch_step_items(j).ATTRIBUTE14 := p_recipe_rout_matl_tbl(i).ATTRIBUTE14 ;
831: l_gme_batch_step_items(j).ATTRIBUTE15 := p_recipe_rout_matl_tbl(i).ATTRIBUTE15 ;
832: l_gme_batch_step_items(j).ATTRIBUTE16 := p_recipe_rout_matl_tbl(i).ATTRIBUTE16 ;
833: l_gme_batch_step_items(j).ATTRIBUTE17 := p_recipe_rout_matl_tbl(i).ATTRIBUTE17 ;
834: l_gme_batch_step_items(j).ATTRIBUTE18 := p_recipe_rout_matl_tbl(i).ATTRIBUTE18 ;
827: l_gme_batch_step_items(j).ATTRIBUTE11 := p_recipe_rout_matl_tbl(i).ATTRIBUTE11 ;
828: l_gme_batch_step_items(j).ATTRIBUTE12 := p_recipe_rout_matl_tbl(i).ATTRIBUTE12 ;
829: l_gme_batch_step_items(j).ATTRIBUTE13 := p_recipe_rout_matl_tbl(i).ATTRIBUTE13 ;
830: l_gme_batch_step_items(j).ATTRIBUTE14 := p_recipe_rout_matl_tbl(i).ATTRIBUTE14 ;
831: l_gme_batch_step_items(j).ATTRIBUTE15 := p_recipe_rout_matl_tbl(i).ATTRIBUTE15 ;
832: l_gme_batch_step_items(j).ATTRIBUTE16 := p_recipe_rout_matl_tbl(i).ATTRIBUTE16 ;
833: l_gme_batch_step_items(j).ATTRIBUTE17 := p_recipe_rout_matl_tbl(i).ATTRIBUTE17 ;
834: l_gme_batch_step_items(j).ATTRIBUTE18 := p_recipe_rout_matl_tbl(i).ATTRIBUTE18 ;
835: l_gme_batch_step_items(j).ATTRIBUTE19 := p_recipe_rout_matl_tbl(i).ATTRIBUTE19 ;
828: l_gme_batch_step_items(j).ATTRIBUTE12 := p_recipe_rout_matl_tbl(i).ATTRIBUTE12 ;
829: l_gme_batch_step_items(j).ATTRIBUTE13 := p_recipe_rout_matl_tbl(i).ATTRIBUTE13 ;
830: l_gme_batch_step_items(j).ATTRIBUTE14 := p_recipe_rout_matl_tbl(i).ATTRIBUTE14 ;
831: l_gme_batch_step_items(j).ATTRIBUTE15 := p_recipe_rout_matl_tbl(i).ATTRIBUTE15 ;
832: l_gme_batch_step_items(j).ATTRIBUTE16 := p_recipe_rout_matl_tbl(i).ATTRIBUTE16 ;
833: l_gme_batch_step_items(j).ATTRIBUTE17 := p_recipe_rout_matl_tbl(i).ATTRIBUTE17 ;
834: l_gme_batch_step_items(j).ATTRIBUTE18 := p_recipe_rout_matl_tbl(i).ATTRIBUTE18 ;
835: l_gme_batch_step_items(j).ATTRIBUTE19 := p_recipe_rout_matl_tbl(i).ATTRIBUTE19 ;
836: l_gme_batch_step_items(j).ATTRIBUTE20 := p_recipe_rout_matl_tbl(i).ATTRIBUTE20 ;
829: l_gme_batch_step_items(j).ATTRIBUTE13 := p_recipe_rout_matl_tbl(i).ATTRIBUTE13 ;
830: l_gme_batch_step_items(j).ATTRIBUTE14 := p_recipe_rout_matl_tbl(i).ATTRIBUTE14 ;
831: l_gme_batch_step_items(j).ATTRIBUTE15 := p_recipe_rout_matl_tbl(i).ATTRIBUTE15 ;
832: l_gme_batch_step_items(j).ATTRIBUTE16 := p_recipe_rout_matl_tbl(i).ATTRIBUTE16 ;
833: l_gme_batch_step_items(j).ATTRIBUTE17 := p_recipe_rout_matl_tbl(i).ATTRIBUTE17 ;
834: l_gme_batch_step_items(j).ATTRIBUTE18 := p_recipe_rout_matl_tbl(i).ATTRIBUTE18 ;
835: l_gme_batch_step_items(j).ATTRIBUTE19 := p_recipe_rout_matl_tbl(i).ATTRIBUTE19 ;
836: l_gme_batch_step_items(j).ATTRIBUTE20 := p_recipe_rout_matl_tbl(i).ATTRIBUTE20 ;
837: l_gme_batch_step_items(j).ATTRIBUTE21 := p_recipe_rout_matl_tbl(i).ATTRIBUTE21 ;
830: l_gme_batch_step_items(j).ATTRIBUTE14 := p_recipe_rout_matl_tbl(i).ATTRIBUTE14 ;
831: l_gme_batch_step_items(j).ATTRIBUTE15 := p_recipe_rout_matl_tbl(i).ATTRIBUTE15 ;
832: l_gme_batch_step_items(j).ATTRIBUTE16 := p_recipe_rout_matl_tbl(i).ATTRIBUTE16 ;
833: l_gme_batch_step_items(j).ATTRIBUTE17 := p_recipe_rout_matl_tbl(i).ATTRIBUTE17 ;
834: l_gme_batch_step_items(j).ATTRIBUTE18 := p_recipe_rout_matl_tbl(i).ATTRIBUTE18 ;
835: l_gme_batch_step_items(j).ATTRIBUTE19 := p_recipe_rout_matl_tbl(i).ATTRIBUTE19 ;
836: l_gme_batch_step_items(j).ATTRIBUTE20 := p_recipe_rout_matl_tbl(i).ATTRIBUTE20 ;
837: l_gme_batch_step_items(j).ATTRIBUTE21 := p_recipe_rout_matl_tbl(i).ATTRIBUTE21 ;
838: l_gme_batch_step_items(j).ATTRIBUTE22 := p_recipe_rout_matl_tbl(i).ATTRIBUTE22 ;
831: l_gme_batch_step_items(j).ATTRIBUTE15 := p_recipe_rout_matl_tbl(i).ATTRIBUTE15 ;
832: l_gme_batch_step_items(j).ATTRIBUTE16 := p_recipe_rout_matl_tbl(i).ATTRIBUTE16 ;
833: l_gme_batch_step_items(j).ATTRIBUTE17 := p_recipe_rout_matl_tbl(i).ATTRIBUTE17 ;
834: l_gme_batch_step_items(j).ATTRIBUTE18 := p_recipe_rout_matl_tbl(i).ATTRIBUTE18 ;
835: l_gme_batch_step_items(j).ATTRIBUTE19 := p_recipe_rout_matl_tbl(i).ATTRIBUTE19 ;
836: l_gme_batch_step_items(j).ATTRIBUTE20 := p_recipe_rout_matl_tbl(i).ATTRIBUTE20 ;
837: l_gme_batch_step_items(j).ATTRIBUTE21 := p_recipe_rout_matl_tbl(i).ATTRIBUTE21 ;
838: l_gme_batch_step_items(j).ATTRIBUTE22 := p_recipe_rout_matl_tbl(i).ATTRIBUTE22 ;
839: l_gme_batch_step_items(j).ATTRIBUTE23 := p_recipe_rout_matl_tbl(i).ATTRIBUTE23 ;
832: l_gme_batch_step_items(j).ATTRIBUTE16 := p_recipe_rout_matl_tbl(i).ATTRIBUTE16 ;
833: l_gme_batch_step_items(j).ATTRIBUTE17 := p_recipe_rout_matl_tbl(i).ATTRIBUTE17 ;
834: l_gme_batch_step_items(j).ATTRIBUTE18 := p_recipe_rout_matl_tbl(i).ATTRIBUTE18 ;
835: l_gme_batch_step_items(j).ATTRIBUTE19 := p_recipe_rout_matl_tbl(i).ATTRIBUTE19 ;
836: l_gme_batch_step_items(j).ATTRIBUTE20 := p_recipe_rout_matl_tbl(i).ATTRIBUTE20 ;
837: l_gme_batch_step_items(j).ATTRIBUTE21 := p_recipe_rout_matl_tbl(i).ATTRIBUTE21 ;
838: l_gme_batch_step_items(j).ATTRIBUTE22 := p_recipe_rout_matl_tbl(i).ATTRIBUTE22 ;
839: l_gme_batch_step_items(j).ATTRIBUTE23 := p_recipe_rout_matl_tbl(i).ATTRIBUTE23 ;
840: l_gme_batch_step_items(j).ATTRIBUTE24 := p_recipe_rout_matl_tbl(i).ATTRIBUTE24 ;
833: l_gme_batch_step_items(j).ATTRIBUTE17 := p_recipe_rout_matl_tbl(i).ATTRIBUTE17 ;
834: l_gme_batch_step_items(j).ATTRIBUTE18 := p_recipe_rout_matl_tbl(i).ATTRIBUTE18 ;
835: l_gme_batch_step_items(j).ATTRIBUTE19 := p_recipe_rout_matl_tbl(i).ATTRIBUTE19 ;
836: l_gme_batch_step_items(j).ATTRIBUTE20 := p_recipe_rout_matl_tbl(i).ATTRIBUTE20 ;
837: l_gme_batch_step_items(j).ATTRIBUTE21 := p_recipe_rout_matl_tbl(i).ATTRIBUTE21 ;
838: l_gme_batch_step_items(j).ATTRIBUTE22 := p_recipe_rout_matl_tbl(i).ATTRIBUTE22 ;
839: l_gme_batch_step_items(j).ATTRIBUTE23 := p_recipe_rout_matl_tbl(i).ATTRIBUTE23 ;
840: l_gme_batch_step_items(j).ATTRIBUTE24 := p_recipe_rout_matl_tbl(i).ATTRIBUTE24 ;
841: l_gme_batch_step_items(j).ATTRIBUTE25 := p_recipe_rout_matl_tbl(i).ATTRIBUTE25 ;
834: l_gme_batch_step_items(j).ATTRIBUTE18 := p_recipe_rout_matl_tbl(i).ATTRIBUTE18 ;
835: l_gme_batch_step_items(j).ATTRIBUTE19 := p_recipe_rout_matl_tbl(i).ATTRIBUTE19 ;
836: l_gme_batch_step_items(j).ATTRIBUTE20 := p_recipe_rout_matl_tbl(i).ATTRIBUTE20 ;
837: l_gme_batch_step_items(j).ATTRIBUTE21 := p_recipe_rout_matl_tbl(i).ATTRIBUTE21 ;
838: l_gme_batch_step_items(j).ATTRIBUTE22 := p_recipe_rout_matl_tbl(i).ATTRIBUTE22 ;
839: l_gme_batch_step_items(j).ATTRIBUTE23 := p_recipe_rout_matl_tbl(i).ATTRIBUTE23 ;
840: l_gme_batch_step_items(j).ATTRIBUTE24 := p_recipe_rout_matl_tbl(i).ATTRIBUTE24 ;
841: l_gme_batch_step_items(j).ATTRIBUTE25 := p_recipe_rout_matl_tbl(i).ATTRIBUTE25 ;
842: l_gme_batch_step_items(j).ATTRIBUTE26 := p_recipe_rout_matl_tbl(i).ATTRIBUTE26 ;
835: l_gme_batch_step_items(j).ATTRIBUTE19 := p_recipe_rout_matl_tbl(i).ATTRIBUTE19 ;
836: l_gme_batch_step_items(j).ATTRIBUTE20 := p_recipe_rout_matl_tbl(i).ATTRIBUTE20 ;
837: l_gme_batch_step_items(j).ATTRIBUTE21 := p_recipe_rout_matl_tbl(i).ATTRIBUTE21 ;
838: l_gme_batch_step_items(j).ATTRIBUTE22 := p_recipe_rout_matl_tbl(i).ATTRIBUTE22 ;
839: l_gme_batch_step_items(j).ATTRIBUTE23 := p_recipe_rout_matl_tbl(i).ATTRIBUTE23 ;
840: l_gme_batch_step_items(j).ATTRIBUTE24 := p_recipe_rout_matl_tbl(i).ATTRIBUTE24 ;
841: l_gme_batch_step_items(j).ATTRIBUTE25 := p_recipe_rout_matl_tbl(i).ATTRIBUTE25 ;
842: l_gme_batch_step_items(j).ATTRIBUTE26 := p_recipe_rout_matl_tbl(i).ATTRIBUTE26 ;
843: l_gme_batch_step_items(j).ATTRIBUTE27 := p_recipe_rout_matl_tbl(i).ATTRIBUTE27 ;
836: l_gme_batch_step_items(j).ATTRIBUTE20 := p_recipe_rout_matl_tbl(i).ATTRIBUTE20 ;
837: l_gme_batch_step_items(j).ATTRIBUTE21 := p_recipe_rout_matl_tbl(i).ATTRIBUTE21 ;
838: l_gme_batch_step_items(j).ATTRIBUTE22 := p_recipe_rout_matl_tbl(i).ATTRIBUTE22 ;
839: l_gme_batch_step_items(j).ATTRIBUTE23 := p_recipe_rout_matl_tbl(i).ATTRIBUTE23 ;
840: l_gme_batch_step_items(j).ATTRIBUTE24 := p_recipe_rout_matl_tbl(i).ATTRIBUTE24 ;
841: l_gme_batch_step_items(j).ATTRIBUTE25 := p_recipe_rout_matl_tbl(i).ATTRIBUTE25 ;
842: l_gme_batch_step_items(j).ATTRIBUTE26 := p_recipe_rout_matl_tbl(i).ATTRIBUTE26 ;
843: l_gme_batch_step_items(j).ATTRIBUTE27 := p_recipe_rout_matl_tbl(i).ATTRIBUTE27 ;
844: l_gme_batch_step_items(j).ATTRIBUTE28 := p_recipe_rout_matl_tbl(i).ATTRIBUTE28 ;
837: l_gme_batch_step_items(j).ATTRIBUTE21 := p_recipe_rout_matl_tbl(i).ATTRIBUTE21 ;
838: l_gme_batch_step_items(j).ATTRIBUTE22 := p_recipe_rout_matl_tbl(i).ATTRIBUTE22 ;
839: l_gme_batch_step_items(j).ATTRIBUTE23 := p_recipe_rout_matl_tbl(i).ATTRIBUTE23 ;
840: l_gme_batch_step_items(j).ATTRIBUTE24 := p_recipe_rout_matl_tbl(i).ATTRIBUTE24 ;
841: l_gme_batch_step_items(j).ATTRIBUTE25 := p_recipe_rout_matl_tbl(i).ATTRIBUTE25 ;
842: l_gme_batch_step_items(j).ATTRIBUTE26 := p_recipe_rout_matl_tbl(i).ATTRIBUTE26 ;
843: l_gme_batch_step_items(j).ATTRIBUTE27 := p_recipe_rout_matl_tbl(i).ATTRIBUTE27 ;
844: l_gme_batch_step_items(j).ATTRIBUTE28 := p_recipe_rout_matl_tbl(i).ATTRIBUTE28 ;
845: l_gme_batch_step_items(j).ATTRIBUTE29 := p_recipe_rout_matl_tbl(i).ATTRIBUTE29 ;
838: l_gme_batch_step_items(j).ATTRIBUTE22 := p_recipe_rout_matl_tbl(i).ATTRIBUTE22 ;
839: l_gme_batch_step_items(j).ATTRIBUTE23 := p_recipe_rout_matl_tbl(i).ATTRIBUTE23 ;
840: l_gme_batch_step_items(j).ATTRIBUTE24 := p_recipe_rout_matl_tbl(i).ATTRIBUTE24 ;
841: l_gme_batch_step_items(j).ATTRIBUTE25 := p_recipe_rout_matl_tbl(i).ATTRIBUTE25 ;
842: l_gme_batch_step_items(j).ATTRIBUTE26 := p_recipe_rout_matl_tbl(i).ATTRIBUTE26 ;
843: l_gme_batch_step_items(j).ATTRIBUTE27 := p_recipe_rout_matl_tbl(i).ATTRIBUTE27 ;
844: l_gme_batch_step_items(j).ATTRIBUTE28 := p_recipe_rout_matl_tbl(i).ATTRIBUTE28 ;
845: l_gme_batch_step_items(j).ATTRIBUTE29 := p_recipe_rout_matl_tbl(i).ATTRIBUTE29 ;
846: l_gme_batch_step_items(j).ATTRIBUTE30 := p_recipe_rout_matl_tbl(i).ATTRIBUTE30 ;
839: l_gme_batch_step_items(j).ATTRIBUTE23 := p_recipe_rout_matl_tbl(i).ATTRIBUTE23 ;
840: l_gme_batch_step_items(j).ATTRIBUTE24 := p_recipe_rout_matl_tbl(i).ATTRIBUTE24 ;
841: l_gme_batch_step_items(j).ATTRIBUTE25 := p_recipe_rout_matl_tbl(i).ATTRIBUTE25 ;
842: l_gme_batch_step_items(j).ATTRIBUTE26 := p_recipe_rout_matl_tbl(i).ATTRIBUTE26 ;
843: l_gme_batch_step_items(j).ATTRIBUTE27 := p_recipe_rout_matl_tbl(i).ATTRIBUTE27 ;
844: l_gme_batch_step_items(j).ATTRIBUTE28 := p_recipe_rout_matl_tbl(i).ATTRIBUTE28 ;
845: l_gme_batch_step_items(j).ATTRIBUTE29 := p_recipe_rout_matl_tbl(i).ATTRIBUTE29 ;
846: l_gme_batch_step_items(j).ATTRIBUTE30 := p_recipe_rout_matl_tbl(i).ATTRIBUTE30 ;
847:
840: l_gme_batch_step_items(j).ATTRIBUTE24 := p_recipe_rout_matl_tbl(i).ATTRIBUTE24 ;
841: l_gme_batch_step_items(j).ATTRIBUTE25 := p_recipe_rout_matl_tbl(i).ATTRIBUTE25 ;
842: l_gme_batch_step_items(j).ATTRIBUTE26 := p_recipe_rout_matl_tbl(i).ATTRIBUTE26 ;
843: l_gme_batch_step_items(j).ATTRIBUTE27 := p_recipe_rout_matl_tbl(i).ATTRIBUTE27 ;
844: l_gme_batch_step_items(j).ATTRIBUTE28 := p_recipe_rout_matl_tbl(i).ATTRIBUTE28 ;
845: l_gme_batch_step_items(j).ATTRIBUTE29 := p_recipe_rout_matl_tbl(i).ATTRIBUTE29 ;
846: l_gme_batch_step_items(j).ATTRIBUTE30 := p_recipe_rout_matl_tbl(i).ATTRIBUTE30 ;
847:
848:
841: l_gme_batch_step_items(j).ATTRIBUTE25 := p_recipe_rout_matl_tbl(i).ATTRIBUTE25 ;
842: l_gme_batch_step_items(j).ATTRIBUTE26 := p_recipe_rout_matl_tbl(i).ATTRIBUTE26 ;
843: l_gme_batch_step_items(j).ATTRIBUTE27 := p_recipe_rout_matl_tbl(i).ATTRIBUTE27 ;
844: l_gme_batch_step_items(j).ATTRIBUTE28 := p_recipe_rout_matl_tbl(i).ATTRIBUTE28 ;
845: l_gme_batch_step_items(j).ATTRIBUTE29 := p_recipe_rout_matl_tbl(i).ATTRIBUTE29 ;
846: l_gme_batch_step_items(j).ATTRIBUTE30 := p_recipe_rout_matl_tbl(i).ATTRIBUTE30 ;
847:
848:
849: -- Bug: 7715293 vpedarla
842: l_gme_batch_step_items(j).ATTRIBUTE26 := p_recipe_rout_matl_tbl(i).ATTRIBUTE26 ;
843: l_gme_batch_step_items(j).ATTRIBUTE27 := p_recipe_rout_matl_tbl(i).ATTRIBUTE27 ;
844: l_gme_batch_step_items(j).ATTRIBUTE28 := p_recipe_rout_matl_tbl(i).ATTRIBUTE28 ;
845: l_gme_batch_step_items(j).ATTRIBUTE29 := p_recipe_rout_matl_tbl(i).ATTRIBUTE29 ;
846: l_gme_batch_step_items(j).ATTRIBUTE30 := p_recipe_rout_matl_tbl(i).ATTRIBUTE30 ;
847:
848:
849: -- Bug: 7715293 vpedarla
850: IF (p_recipe_rout_matl_tbl (i).text_code IS NOT NULL)
851: AND (gme_common_pvt.g_copy_routing_text_ind = '1') THEN
852:
853: l_gmd_text_code := p_recipe_rout_matl_tbl (i).text_code;
854: l_text_string :=
855: 'gme_batch_step_items' || '|' || TO_CHAR (l_batch_id)
856: || '|';
857: l_text_string :=
858: l_text_string
859: || TO_CHAR (p_recipe_rout_matl_tbl(j).RECIPE_ID)
879:
880: IF (l_return_status <> x_return_status) THEN
881: RAISE error_create_text;
882: ELSE
883: l_gme_batch_step_items(j).text_code := l_gme_text_code;
884: END IF;
885: END IF;
886:
887: IF (gme_batch_step_items_dbl.insert_row
883: l_gme_batch_step_items(j).text_code := l_gme_text_code;
884: END IF;
885: END IF;
886:
887: IF (gme_batch_step_items_dbl.insert_row
888: (p_batch_step_items => l_gme_batch_step_items
889: (j)
890: ,x_batch_step_items => l_gme_batch_step_items
891: (j) ) ) THEN
884: END IF;
885: END IF;
886:
887: IF (gme_batch_step_items_dbl.insert_row
888: (p_batch_step_items => l_gme_batch_step_items
889: (j)
890: ,x_batch_step_items => l_gme_batch_step_items
891: (j) ) ) THEN
892: NULL;
886:
887: IF (gme_batch_step_items_dbl.insert_row
888: (p_batch_step_items => l_gme_batch_step_items
889: (j)
890: ,x_batch_step_items => l_gme_batch_step_items
891: (j) ) ) THEN
892: NULL;
893: ELSE
894: RAISE error_insert_b_step_items;
897: i := p_recipe_rout_matl_tbl.NEXT (i);
898: END LOOP; /* WHILE i IS NOT NULL ; STEP ITEM ASSOCIATIONS*/
899:
900: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
901: gme_debug.put_line ('Completed GME_BATCH_STEP_ITEMS');
902: gme_debug.put_line ('GME_BATCH_STEP_DEPENDENCIES');
903: END IF;
904:
905: -- Create data for GME_BATCH_STEP_DEPENDENCIES