APPS.GMD_CONC_REPLACE_PKG dependencies on FM_ROUT_DTL

Line 244: l_routingStep_id FM_ROUT_DTL.RoutingStep_id%TYPE;

240: l_old_oprn GMD_OPERATIONS_B.oprn_no%TYPE;
241: l_new_oprn GMD_OPERATIONS_B.oprn_no%TYPE;
242: l_routing_class GMD_ROUTINGS_B.routing_class%TYPE;
243: l_routing_id GMD_ROUTINGS_B.routing_id%TYPE;
244: l_routingStep_id FM_ROUT_DTL.RoutingStep_id%TYPE;
245:
246: l_old_actv GMD_OPERATION_ACTIVITIES.activity%TYPE;
247: l_new_actv GMD_OPERATION_ACTIVITIES.activity%TYPE;
248: l_oprn_class GMD_OPERATIONS_B.oprn_class%TYPE;

Line 1258: FROM fm_rout_dtl

1254: IF (get_object_rec.replace_type = 'OPRN_ID') THEN
1255: -- Get the routingstep id
1256: SELECT RoutingStep_id
1257: INTO l_routingStep_id
1258: FROM fm_rout_dtl
1259: WHERE routing_id = get_object_rec.object_id
1260: AND oprn_id = get_object_rec.old_name;
1261:
1262: IF (l_debug = 'Y') THEN

Line 2076: FROM FM_ROUT_DTL

2072: fnd_dsql.add_bind(pOld_name);
2073: fnd_dsql.add_text(' ))');
2074: ELSIF ((pObject_type = 'ROUTING') AND (pReplace_type = 'OPRN_ID'))THEN
2075: fnd_dsql.add_text(' SELECT ROUTING_ID
2076: FROM FM_ROUT_DTL
2077: WHERE OPRN_ID = ');
2078: fnd_dsql.add_bind(pOld_name);
2079: fnd_dsql.add_text(' ))');
2080: ELSIF ((pObject_type = 'RECIPE') AND (pReplace_type = 'OWNER_ORGANIZATION_ID'))THEN