APPS.GMD_CONC_REPLACE_PKG dependencies on GMD_ROUTINGS_B

Line 377: l_routing_class GMD_ROUTINGS_B.routing_class%TYPE;

373: l_old_end_date VARCHAR2(32); -- Kapil
374:
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;

Line 378: l_routing_id GMD_ROUTINGS_B.routing_id%TYPE;

374:
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;

Line 1275: FROM gmd_routings_b rot

1271: ELSIF (get_object_rec.object_type = 'ROUTING') THEN
1272: -- Get the action flag to decide on update or insert(version control)
1273: SELECT rot.owner_organization_id , rot.effective_end_date
1274: INTO l_orgn_id, l_old_end_date
1275: FROM gmd_routings_b rot
1276: WHERE rot.routing_id = get_object_rec.object_id;
1277:
1278: -- Get the Routing version control for the entity orgn.
1279: GMD_API_GRP.FETCH_PARM_VALUES(P_orgn_id => l_orgn_id,

Line 1363: FROM gmd_routings_b

1359: RAISE No_Update_Exception;
1360: ELSE
1361: SELECT routing_vers
1362: INTO l_object_version
1363: FROM gmd_routings_b
1364: WHERE routing_id = l_routing_id;
1365:
1366: -- Setup message to indicate that a new version
1367: -- has been created

Line 2147: 'ROUTING','GMD_ROUTINGS_B',

2143: SELECT DECODE(pObject_type,
2144: 'FORMULA','FM_FORM_MST_B',
2145: 'RECIPE','GMD_RECIPES_B',
2146: 'OPERATION','GMD_OPERATIONS_B',
2147: 'ROUTING','GMD_ROUTINGS_B',
2148: 'VALIDITY','GMD_RECIPE_VALIDITY_RULES'),
2149: DECODE(pObject_type,
2150: 'FORMULA','FORMULA_ID',
2151: 'RECIPE','RECIPE_ID',