APPS.MSC_CL_GMP_UTILITY dependencies on MSC_ST_ROUTINGS

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

810:
811: pef_index INTEGER := 0 ; /* Process Effectivity Global counter */
812:
813: /* ------------------------------- Routng declarations --------------------------- */
814: TYPE routing_comment IS TABLE OF msc_st_routings.routing_comment%TYPE
815: INDEX BY BINARY_INTEGER;
816: rtg_routing_comment routing_comment ;
817: empty_rtg_comment routing_comment ;
818:

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

816: rtg_routing_comment routing_comment ;
817: empty_rtg_comment routing_comment ;
818:
819:
820: TYPE alt_routing_designator IS TABLE OF msc_st_routings.alternate_routing_designator%TYPE
821: INDEX BY BINARY_INTEGER;
822: rtg_alt_routing_designator alt_routing_designator ;
823: empty_rtg_designator alt_routing_designator ;
824:

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

821: INDEX BY BINARY_INTEGER;
822: rtg_alt_routing_designator alt_routing_designator ;
823: empty_rtg_designator alt_routing_designator ;
824:
825: TYPE routing_quantity IS TABLE OF msc_st_routings.routing_quantity%TYPE
826: INDEX BY BINARY_INTEGER;
827: rtg_routing_quantity number_idx_tbl ;
828:
829: /* NAMIT_CR For Calculate Step Dependency Flag */

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

4628: write_step_dependency(p_x_aps_fmeff_id);
4629:
4630: EXCEPTION
4631: WHEN OTHERS THEN
4632: log_message('Error writing to msc_st_routings: '||sqlerrm);
4633: return_status := FALSE;
4634: END write_routing;
4635:
4636: /*

Line 6587: INSERT INTO msc_st_routings (

6583: stmt_no := 904 ;
6584: i := 1 ;
6585: IF rtg_organization_id.FIRST > 0 THEN
6586: FORALL i IN rtg_organization_id.FIRST..rtg_organization_id.LAST
6587: INSERT INTO msc_st_routings (
6588: routing_sequence_id,
6589: sr_instance_id,
6590: routing_type,
6591: routing_comment,