596: pef_effectivity_date effectivity_date ;
597: bomc_effectivity_date effectivity_date ;
598: opr_effectivity_date effectivity_date ;
599:
600: TYPE routing_sequence_id IS TABLE OF msc_st_routings.routing_sequence_id%TYPE
601: INDEX BY BINARY_INTEGER;
602: rtg_routing_sequence_id routing_sequence_id ;
603: pef_routing_sequence_id routing_sequence_id ;
604: or_routing_sequence_id routing_sequence_id ;
766:
767: pef_index INTEGER := 0 ; /* Process Effectivity Global counter */
768:
769: /* ------------------------------- Routng declarations --------------------------- */
770: TYPE routing_comment IS TABLE OF msc_st_routings.routing_comment%TYPE
771: INDEX BY BINARY_INTEGER;
772: rtg_routing_comment routing_comment ;
773:
774: TYPE alt_routing_designator IS TABLE OF msc_st_routings.alternate_routing_designator%TYPE
770: TYPE routing_comment IS TABLE OF msc_st_routings.routing_comment%TYPE
771: INDEX BY BINARY_INTEGER;
772: rtg_routing_comment routing_comment ;
773:
774: TYPE alt_routing_designator IS TABLE OF msc_st_routings.alternate_routing_designator%TYPE
775: INDEX BY BINARY_INTEGER;
776: rtg_alt_routing_designator alt_routing_designator ;
777:
778: TYPE routing_quantity IS TABLE OF msc_st_routings.routing_quantity%TYPE
774: TYPE alt_routing_designator IS TABLE OF msc_st_routings.alternate_routing_designator%TYPE
775: INDEX BY BINARY_INTEGER;
776: rtg_alt_routing_designator alt_routing_designator ;
777:
778: TYPE routing_quantity IS TABLE OF msc_st_routings.routing_quantity%TYPE
779: INDEX BY BINARY_INTEGER;
780: rtg_routing_quantity routing_quantity ;
781:
782: /* NAMIT_CR For Calculate Step Dependency Flag */
4552: write_step_dependency(p_x_aps_fmeff_id);
4553:
4554: EXCEPTION
4555: WHEN OTHERS THEN
4556: log_message('Error writing to msc_st_routings: '||sqlerrm);
4557: return_status := FALSE;
4558: END write_routing;
4559:
4560: /*
6230: stmt_no := 904 ;
6231: i := 1 ;
6232: IF rtg_organization_id.FIRST > 0 THEN
6233: FORALL i IN rtg_organization_id.FIRST..rtg_organization_id.LAST
6234: INSERT INTO msc_st_routings (
6235: routing_sequence_id,
6236: sr_instance_id,
6237: routing_type,
6238: routing_comment,