APPS.GMP_BOM_ROUTING_PKG dependencies on MSC_ST_ROUTINGS

Line 627: TYPE routing_sequence_id IS TABLE OF msc_st_routings.routing_sequence_id%TYPE

623: pef_effectivity_date effectivity_date ;
624: bomc_effectivity_date effectivity_date ;
625: opr_effectivity_date effectivity_date ;
626:
627: TYPE routing_sequence_id IS TABLE OF msc_st_routings.routing_sequence_id%TYPE
628: INDEX BY BINARY_INTEGER;
629: rtg_routing_sequence_id routing_sequence_id ;
630: pef_routing_sequence_id routing_sequence_id ;
631: or_routing_sequence_id routing_sequence_id ;

Line 803: TYPE routing_comment IS TABLE OF msc_st_routings.routing_comment%TYPE

799:
800: pef_index INTEGER := 0 ; /* Process Effectivity Global counter */
801:
802: /* ------------------------------- Routng declarations --------------------------- */
803: TYPE routing_comment IS TABLE OF msc_st_routings.routing_comment%TYPE
804: INDEX BY BINARY_INTEGER;
805: rtg_routing_comment routing_comment ;
806: empty_rtg_comment routing_comment ;
807:

Line 808: TYPE alt_routing_designator IS TABLE OF msc_st_routings.alternate_routing_designator%TYPE

804: INDEX BY BINARY_INTEGER;
805: rtg_routing_comment routing_comment ;
806: empty_rtg_comment routing_comment ;
807:
808: TYPE alt_routing_designator IS TABLE OF msc_st_routings.alternate_routing_designator%TYPE
809: INDEX BY BINARY_INTEGER;
810: rtg_alt_routing_designator alt_routing_designator ;
811: l_12137_count number; -- Biogen
812: l_apps_ver number; -- Biogen

Line 813: TYPE routing_quantity IS TABLE OF msc_st_routings.routing_quantity%TYPE

809: INDEX BY BINARY_INTEGER;
810: rtg_alt_routing_designator alt_routing_designator ;
811: l_12137_count number; -- Biogen
812: l_apps_ver number; -- Biogen
813: TYPE routing_quantity IS TABLE OF msc_st_routings.routing_quantity%TYPE
814: INDEX BY BINARY_INTEGER;
815: rtg_routing_quantity routing_quantity ;
816:
817: /* NAMIT_CR For Calculate Step Dependency Flag */

Line 5026: log_message('Error writing to msc_st_routings: '||sqlerrm);

5022: write_step_dependency(p_x_aps_fmeff_id);
5023:
5024: EXCEPTION
5025: WHEN OTHERS THEN
5026: log_message('Error writing to msc_st_routings: '||sqlerrm);
5027: return_status := FALSE;
5028: END write_routing;
5029:
5030: /*

Line 6778: INSERT INTO msc_st_routings (

6774: stmt_no := 904 ;
6775: i := 1 ;
6776: IF rtg_organization_id.FIRST > 0 THEN
6777: FORALL i IN rtg_organization_id.FIRST..rtg_organization_id.LAST
6778: INSERT INTO msc_st_routings (
6779: routing_sequence_id,
6780: sr_instance_id,
6781: routing_type,
6782: routing_comment,