APPS.GMD_CONC_REPLACE_PKG dependencies on FM_ROUT_DTL

Line 379: l_routingStep_id FM_ROUT_DTL.RoutingStep_id%TYPE;

375: l_old_oprn GMD_OPERATIONS_B.oprn_no%TYPE;
376: l_new_oprn GMD_OPERATIONS_B.oprn_no%TYPE;
377: l_routing_class GMD_ROUTINGS_B.routing_class%TYPE;
378: l_routing_id GMD_ROUTINGS_B.routing_id%TYPE;
379: l_routingStep_id FM_ROUT_DTL.RoutingStep_id%TYPE;
380:
381: l_old_actv GMD_OPERATION_ACTIVITIES.activity%TYPE;
382: l_new_actv GMD_OPERATION_ACTIVITIES.activity%TYPE;
383: l_oprn_class GMD_OPERATIONS_B.oprn_class%TYPE;

Line 415: CURSOR c_Routingstep_id (cp_routing_id fm_rout_dtl.routing_id%TYPE,cp_oprn_id fm_rout_dtl.oprn_id%TYPE) is

411: l_status VARCHAR2(10);
412:
413: --bug 10240528 -- adding a new cursor start
414:
415: CURSOR c_Routingstep_id (cp_routing_id fm_rout_dtl.routing_id%TYPE,cp_oprn_id fm_rout_dtl.oprn_id%TYPE) is
416: SELECT RoutingStep_id
417: FROM fm_rout_dtl
418: WHERE routing_id = cp_routing_id
419: AND oprn_id = cp_oprn_id;

Line 417: FROM fm_rout_dtl

413: --bug 10240528 -- adding a new cursor start
414:
415: CURSOR c_Routingstep_id (cp_routing_id fm_rout_dtl.routing_id%TYPE,cp_oprn_id fm_rout_dtl.oprn_id%TYPE) is
416: SELECT RoutingStep_id
417: FROM fm_rout_dtl
418: WHERE routing_id = cp_routing_id
419: AND oprn_id = cp_oprn_id;
420:
421: CURSOR c_Operation_line_id (cp_operation_id

Line 2262: FROM FM_ROUT_DTL

2258: fnd_dsql.add_bind(pOld_name);
2259: fnd_dsql.add_text(' ))');
2260: ELSIF ((pObject_type = 'ROUTING') AND (pReplace_type = 'OPRN_ID'))THEN
2261: fnd_dsql.add_text(' SELECT ROUTING_ID
2262: FROM FM_ROUT_DTL
2263: WHERE OPRN_ID = ');
2264: fnd_dsql.add_bind(pOld_name);
2265: fnd_dsql.add_text(' ))');
2266: ELSIF ((pObject_type = 'RECIPE') AND (pReplace_type = 'OWNER_ORGANIZATION_ID'))THEN