APPS.GMDRTVAL_PUB dependencies on FM_ROUT_DTL

Line 200: FROM fm_rout_dtl

196: CURSOR Cur_dup_routingstep IS
197: SELECT 1
198: FROM SYS.DUAL
199: WHERE EXISTS (SELECT 1
200: FROM fm_rout_dtl
201: WHERE routing_id = prouting_id
202: AND routingstep_no = proutingstep_no);
203: /* Local variables. */
204: /* ================ */

Line 480: FROM fm_rout_dtl

476: /* Cursor Definitions. */
477: /* =================== */
478: CURSOR Cur_get_routing_steps IS
479: SELECT routingstep_no
480: FROM fm_rout_dtl
481: WHERE routing_id = prouting_id
482: ORDER BY routingstep_no desc;
483:
484: X_rout_step_rec Cur_get_routing_steps%ROWTYPE;

Line 488: FROM gmd_operations o, fm_rout_dtl d

484: X_rout_step_rec Cur_get_routing_steps%ROWTYPE;
485:
486: CURSOR Cur_get_oprn_uom (V_step_no NUMBER) IS
487: SELECT process_qty_uom
488: FROM gmd_operations o, fm_rout_dtl d
489: WHERE d.routing_id = prouting_id
490: AND d.routingstep_no = V_step_no
491: AND d.oprn_id = o.oprn_id;
492:

Line 599: FROM fm_rout_dtl

595: /* Cursor Definitions. */
596: /* =================== */
597: CURSOR Cur_get_routing_steps IS
598: SELECT routingstep_no
599: FROM fm_rout_dtl
600: WHERE routing_id = prouting_id
601: ORDER BY routingstep_no desc;
602:
603: X_rout_step_rec Cur_get_routing_steps%ROWTYPE;

Line 607: FROM gmd_operations o, fm_rout_dtl d

603: X_rout_step_rec Cur_get_routing_steps%ROWTYPE;
604:
605: CURSOR Cur_get_oprn_uom (V_step_no NUMBER) IS
606: SELECT process_qty_uom
607: FROM gmd_operations o, fm_rout_dtl d
608: WHERE d.routing_id = prouting_id
609: AND d.routingstep_no = V_step_no
610: AND d.oprn_id = o.oprn_id;
611:

Line 745: WHERE oprn_id IN (select oprn_id from fm_rout_dtl where routing_id = pRouting_id);

741: l_oprn_count NUMBER := 0;
742:
743: CURSOR check_oprn_count IS
744: SELECT count(*) FROM gmd_operations_b
745: WHERE oprn_id IN (select oprn_id from fm_rout_dtl where routing_id = pRouting_id);
746:
747: BEGIN
748: x_return_status := 'S';
749:

Line 873: ,pxRoutingStep_no IN OUT NOCOPY fm_rout_dtl.routingStep_no%TYPE

869: /* This procedure get the routingStep_id when the */
870: /* routingStep_no and routing_id is passed */
871: /* =================================================== */
872: PROCEDURE get_routingstep_info(pRouting_id IN gmd_routings.routing_id%TYPE := NULL
873: ,pxRoutingStep_no IN OUT NOCOPY fm_rout_dtl.routingStep_no%TYPE
874: ,pxRoutingStep_id IN OUT NOCOPY fm_rout_dtl.routingStep_id%TYPE
875: ,x_return_status OUT NOCOPY VARCHAR2 ) IS
876:
877: CURSOR get_routingStep_id(vRouting_id gmd_routings.routing_id%TYPE

Line 874: ,pxRoutingStep_id IN OUT NOCOPY fm_rout_dtl.routingStep_id%TYPE

870: /* routingStep_no and routing_id is passed */
871: /* =================================================== */
872: PROCEDURE get_routingstep_info(pRouting_id IN gmd_routings.routing_id%TYPE := NULL
873: ,pxRoutingStep_no IN OUT NOCOPY fm_rout_dtl.routingStep_no%TYPE
874: ,pxRoutingStep_id IN OUT NOCOPY fm_rout_dtl.routingStep_id%TYPE
875: ,x_return_status OUT NOCOPY VARCHAR2 ) IS
876:
877: CURSOR get_routingStep_id(vRouting_id gmd_routings.routing_id%TYPE
878: ,vRoutingStep_no fm_rout_dtl.routingStep_no%TYPE) IS

Line 878: ,vRoutingStep_no fm_rout_dtl.routingStep_no%TYPE) IS

874: ,pxRoutingStep_id IN OUT NOCOPY fm_rout_dtl.routingStep_id%TYPE
875: ,x_return_status OUT NOCOPY VARCHAR2 ) IS
876:
877: CURSOR get_routingStep_id(vRouting_id gmd_routings.routing_id%TYPE
878: ,vRoutingStep_no fm_rout_dtl.routingStep_no%TYPE) IS
879: Select routingStep_id
880: From fm_rout_dtl
881: Where routingStep_no = vRoutingStep_no AND
882: routing_id = vRouting_id;

Line 880: From fm_rout_dtl

876:
877: CURSOR get_routingStep_id(vRouting_id gmd_routings.routing_id%TYPE
878: ,vRoutingStep_no fm_rout_dtl.routingStep_no%TYPE) IS
879: Select routingStep_id
880: From fm_rout_dtl
881: Where routingStep_no = vRoutingStep_no AND
882: routing_id = vRouting_id;
883:
884: CURSOR get_routingStep_no(vRoutingStep_id fm_rout_dtl.routingStep_id%TYPE) IS

Line 884: CURSOR get_routingStep_no(vRoutingStep_id fm_rout_dtl.routingStep_id%TYPE) IS

880: From fm_rout_dtl
881: Where routingStep_no = vRoutingStep_no AND
882: routing_id = vRouting_id;
883:
884: CURSOR get_routingStep_no(vRoutingStep_id fm_rout_dtl.routingStep_id%TYPE) IS
885: Select routingStep_no
886: From fm_rout_dtl
887: Where routingStep_id = vRoutingStep_id;
888:

Line 886: From fm_rout_dtl

882: routing_id = vRouting_id;
883:
884: CURSOR get_routingStep_no(vRoutingStep_id fm_rout_dtl.routingStep_id%TYPE) IS
885: Select routingStep_no
886: From fm_rout_dtl
887: Where routingStep_id = vRoutingStep_id;
888:
889: BEGIN
890:

Line 1086: ,proutingStep_no IN fm_rout_dtl.routingStep_no%TYPE

1082: /* l_ret := gmdrtval_pub.check_deprouting(pownerorgn_code,proutingStep_no,pdeproutingStep_no); */
1083: /* ==================================================================== */
1084:
1085: PROCEDURE check_deprouting (prouting_id IN gmd_routings.routing_id%TYPE
1086: ,proutingStep_no IN fm_rout_dtl.routingStep_no%TYPE
1087: ,pdeproutingStep_no IN fm_rout_dep.dep_routingStep_no%TYPE
1088: ,x_return_status OUT NOCOPY VARCHAR2) IS
1089:
1090: /* Cursor Definitions. */