APPS.GMP_BOM_ROUTING_PKG dependencies on MSC_ST_PROCESS_EFFECTIVITY

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

617: itm_mtq_creation_date creation_date ; /* 7363807 */
618: rs_creation_date creation_date ;
619: oc_creation_date creation_date ;
620:
621: TYPE effectivity_date IS TABLE OF msc_st_process_effectivity.effectivity_date%TYPE
622: INDEX BY BINARY_INTEGER;
623: pef_effectivity_date effectivity_date ;
624: bomc_effectivity_date effectivity_date ;
625: opr_effectivity_date effectivity_date ;

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

768:
769: bomc_index INTEGER := 0 ; /* BOM component Global counter */
770:
771: /* --------------------------- Effectivity declarations ------------------------ */
772: TYPE process_sequence_id IS TABLE OF msc_st_process_effectivity.process_sequence_id%TYPE
773: INDEX BY BINARY_INTEGER;
774: pef_process_sequence_id process_sequence_id ;
775:
776: TYPE item_id IS TABLE OF msc_st_process_effectivity.item_id%TYPE INDEX BY BINARY_INTEGER;

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

772: TYPE process_sequence_id IS TABLE OF msc_st_process_effectivity.process_sequence_id%TYPE
773: INDEX BY BINARY_INTEGER;
774: pef_process_sequence_id process_sequence_id ;
775:
776: TYPE item_id IS TABLE OF msc_st_process_effectivity.item_id%TYPE INDEX BY BINARY_INTEGER;
777: pef_item_id item_id ;
778:
779: TYPE disable_date IS TABLE OF msc_st_process_effectivity.disable_date%TYPE
780: INDEX BY BINARY_INTEGER;

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

775:
776: TYPE item_id IS TABLE OF msc_st_process_effectivity.item_id%TYPE INDEX BY BINARY_INTEGER;
777: pef_item_id item_id ;
778:
779: TYPE disable_date IS TABLE OF msc_st_process_effectivity.disable_date%TYPE
780: INDEX BY BINARY_INTEGER;
781: pef_disable_date disable_date ;
782:
783: TYPE minimum_quantity IS TABLE OF msc_st_process_effectivity.minimum_quantity%TYPE

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

779: TYPE disable_date IS TABLE OF msc_st_process_effectivity.disable_date%TYPE
780: INDEX BY BINARY_INTEGER;
781: pef_disable_date disable_date ;
782:
783: TYPE minimum_quantity IS TABLE OF msc_st_process_effectivity.minimum_quantity%TYPE
784: INDEX BY BINARY_INTEGER;
785: pef_minimum_quantity minimum_quantity ;
786:
787: TYPE maximum_quantity IS TABLE OF msc_st_process_effectivity.maximum_quantity%TYPE

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

783: TYPE minimum_quantity IS TABLE OF msc_st_process_effectivity.minimum_quantity%TYPE
784: INDEX BY BINARY_INTEGER;
785: pef_minimum_quantity minimum_quantity ;
786:
787: TYPE maximum_quantity IS TABLE OF msc_st_process_effectivity.maximum_quantity%TYPE
788: INDEX BY BINARY_INTEGER;
789: pef_maximum_quantity maximum_quantity ;
790:
791: TYPE preference IS TABLE OF msc_st_process_effectivity.preference%TYPE

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

787: TYPE maximum_quantity IS TABLE OF msc_st_process_effectivity.maximum_quantity%TYPE
788: INDEX BY BINARY_INTEGER;
789: pef_maximum_quantity maximum_quantity ;
790:
791: TYPE preference IS TABLE OF msc_st_process_effectivity.preference%TYPE
792: INDEX BY BINARY_INTEGER;
793: pef_preference preference ;
794:
795: -- Bug: 8715318 Vpedarla uncommented the below line.

Line 796: TYPE recipe IS TABLE OF msc_st_process_effectivity.recipe%TYPE

792: INDEX BY BINARY_INTEGER;
793: pef_preference preference ;
794:
795: -- Bug: 8715318 Vpedarla uncommented the below line.
796: TYPE recipe IS TABLE OF msc_st_process_effectivity.recipe%TYPE
797: INDEX BY BINARY_INTEGER;
798: pef_recipe recipe ;
799:
800: pef_index INTEGER := 0 ; /* Process Effectivity Global counter */

Line 6595: INSERT INTO msc_st_process_effectivity (

6591: i := 1 ;
6592:
6593: IF pef_organization_id.FIRST > 0 THEN
6594: FORALL i IN pef_organization_id.FIRST..pef_organization_id.LAST
6595: INSERT INTO msc_st_process_effectivity (
6596: process_sequence_id,
6597: item_id,
6598: organization_id,
6599: effectivity_date,