APPS.GMP_BOM_ROUTING_PKG dependencies on MSC_ST_PROCESS_EFFECTIVITY

Line 594: TYPE effectivity_date IS TABLE OF msc_st_process_effectivity.effectivity_date%TYPE

590: itm_mtq_creation_date creation_date ; /* 7363807 */
591: rs_creation_date creation_date ;
592: oc_creation_date creation_date ;
593:
594: TYPE effectivity_date IS TABLE OF msc_st_process_effectivity.effectivity_date%TYPE
595: INDEX BY BINARY_INTEGER;
596: pef_effectivity_date effectivity_date ;
597: bomc_effectivity_date effectivity_date ;
598: opr_effectivity_date effectivity_date ;

Line 740: TYPE process_sequence_id IS TABLE OF msc_st_process_effectivity.process_sequence_id%TYPE

736:
737: bomc_index INTEGER := 0 ; /* BOM component Global counter */
738:
739: /* --------------------------- Effectivity declarations ------------------------ */
740: TYPE process_sequence_id IS TABLE OF msc_st_process_effectivity.process_sequence_id%TYPE
741: INDEX BY BINARY_INTEGER;
742: pef_process_sequence_id process_sequence_id ;
743:
744: TYPE item_id IS TABLE OF msc_st_process_effectivity.item_id%TYPE INDEX BY BINARY_INTEGER;

Line 744: TYPE item_id IS TABLE OF msc_st_process_effectivity.item_id%TYPE INDEX BY BINARY_INTEGER;

740: TYPE process_sequence_id IS TABLE OF msc_st_process_effectivity.process_sequence_id%TYPE
741: INDEX BY BINARY_INTEGER;
742: pef_process_sequence_id process_sequence_id ;
743:
744: TYPE item_id IS TABLE OF msc_st_process_effectivity.item_id%TYPE INDEX BY BINARY_INTEGER;
745: pef_item_id item_id ;
746:
747: TYPE disable_date IS TABLE OF msc_st_process_effectivity.disable_date%TYPE
748: INDEX BY BINARY_INTEGER;

Line 747: TYPE disable_date IS TABLE OF msc_st_process_effectivity.disable_date%TYPE

743:
744: TYPE item_id IS TABLE OF msc_st_process_effectivity.item_id%TYPE INDEX BY BINARY_INTEGER;
745: pef_item_id item_id ;
746:
747: TYPE disable_date IS TABLE OF msc_st_process_effectivity.disable_date%TYPE
748: INDEX BY BINARY_INTEGER;
749: pef_disable_date disable_date ;
750:
751: TYPE minimum_quantity IS TABLE OF msc_st_process_effectivity.minimum_quantity%TYPE

Line 751: TYPE minimum_quantity IS TABLE OF msc_st_process_effectivity.minimum_quantity%TYPE

747: TYPE disable_date IS TABLE OF msc_st_process_effectivity.disable_date%TYPE
748: INDEX BY BINARY_INTEGER;
749: pef_disable_date disable_date ;
750:
751: TYPE minimum_quantity IS TABLE OF msc_st_process_effectivity.minimum_quantity%TYPE
752: INDEX BY BINARY_INTEGER;
753: pef_minimum_quantity minimum_quantity ;
754:
755: TYPE maximum_quantity IS TABLE OF msc_st_process_effectivity.maximum_quantity%TYPE

Line 755: TYPE maximum_quantity IS TABLE OF msc_st_process_effectivity.maximum_quantity%TYPE

751: TYPE minimum_quantity IS TABLE OF msc_st_process_effectivity.minimum_quantity%TYPE
752: INDEX BY BINARY_INTEGER;
753: pef_minimum_quantity minimum_quantity ;
754:
755: TYPE maximum_quantity IS TABLE OF msc_st_process_effectivity.maximum_quantity%TYPE
756: INDEX BY BINARY_INTEGER;
757: pef_maximum_quantity maximum_quantity ;
758:
759: TYPE preference IS TABLE OF msc_st_process_effectivity.preference%TYPE

Line 759: TYPE preference IS TABLE OF msc_st_process_effectivity.preference%TYPE

755: TYPE maximum_quantity IS TABLE OF msc_st_process_effectivity.maximum_quantity%TYPE
756: INDEX BY BINARY_INTEGER;
757: pef_maximum_quantity maximum_quantity ;
758:
759: TYPE preference IS TABLE OF msc_st_process_effectivity.preference%TYPE
760: INDEX BY BINARY_INTEGER;
761: pef_preference preference ;
762:
763: --TYPE recipe IS TABLE OF msc_st_process_effectivity.recipe%TYPE

Line 763: --TYPE recipe IS TABLE OF msc_st_process_effectivity.recipe%TYPE

759: TYPE preference IS TABLE OF msc_st_process_effectivity.preference%TYPE
760: INDEX BY BINARY_INTEGER;
761: pef_preference preference ;
762:
763: --TYPE recipe IS TABLE OF msc_st_process_effectivity.recipe%TYPE
764: --INDEX BY BINARY_INTEGER;
765: --pef_recipe recipe ;
766:
767: pef_index INTEGER := 0 ; /* Process Effectivity Global counter */

Line 6053: INSERT INTO msc_st_process_effectivity (

6049: i := 1 ;
6050:
6051: IF pef_organization_id.FIRST > 0 THEN
6052: FORALL i IN pef_organization_id.FIRST..pef_organization_id.LAST
6053: INSERT INTO msc_st_process_effectivity (
6054: process_sequence_id,
6055: item_id,
6056: organization_id,
6057: effectivity_date,