APPS.GMDRTVAL_PUB dependencies on GMD_ROUTINGS

Line 793: from gmd_recipe_validity_rules v, gmd_recipes_b r, gmd_routings_b rt

789: l_vr_count NUMBER := 0;
790:
791: CURSOR check_VR_Rout_dates IS
792: select count(*)
793: from gmd_recipe_validity_rules v, gmd_recipes_b r, gmd_routings_b rt
794: where v.recipe_id = r.recipe_id
795: and r.routing_id = rt.routing_id
796: and rt.routing_id = pRouting_id
797: and rt.effective_start_date < v.start_date

Line 840: from gmd_recipe_validity_rules v, gmd_recipes_b r, gmd_routings_b rt

836: l_vr_id NUMBER := 0;
837:
838: CURSOR check_VR_Rout_dates IS
839: select v.recipe_validity_rule_id vr_id , rt.effective_start_date start_date, rt.effective_end_date end_date
840: from gmd_recipe_validity_rules v, gmd_recipes_b r, gmd_routings_b rt
841: where v.recipe_id = r.recipe_id
842: and r.routing_id = rt.routing_id
843: and rt.routing_id = pRouting_id
844: and rt.effective_start_date < v.start_date

Line 872: PROCEDURE get_routingstep_info(pRouting_id IN gmd_routings.routing_id%TYPE := NULL

868: /* =================================================== */
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:

Line 877: CURSOR get_routingStep_id(vRouting_id gmd_routings.routing_id%TYPE

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
879: Select routingStep_id
880: From fm_rout_dtl
881: Where routingStep_no = vRoutingStep_no AND

Line 1085: PROCEDURE check_deprouting (prouting_id IN gmd_routings.routing_id%TYPE

1081: /* SYNOPSIS: */
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: