APPS.GMD_CONC_REPLACE_PKG dependencies on GMD_ROUTINGS_B

Line 242: l_routing_class GMD_ROUTINGS_B.routing_class%TYPE;

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

Line 243: l_routing_id GMD_ROUTINGS_B.routing_id%TYPE;

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

Line 1122: FROM gmd_routings_b rot

1118: ELSIF (get_object_rec.object_type = 'ROUTING') THEN
1119: -- Get the action flag to decide on update or insert(version control)
1120: SELECT rot.owner_organization_id , rot.effective_end_date
1121: INTO l_orgn_id, l_old_end_date
1122: FROM gmd_routings_b rot
1123: WHERE rot.routing_id = get_object_rec.object_id;
1124:
1125: -- Get the Routing version control for the entity orgn.
1126: GMD_API_GRP.FETCH_PARM_VALUES(P_orgn_id => l_orgn_id,

Line 1210: FROM gmd_routings_b

1206: RAISE No_Update_Exception;
1207: ELSE
1208: SELECT routing_vers
1209: INTO l_object_version
1210: FROM gmd_routings_b
1211: WHERE routing_id = l_routing_id;
1212:
1213: -- Setup message to indicate that a new version
1214: -- has been created

Line 1961: 'ROUTING','GMD_ROUTINGS_B',

1957: SELECT DECODE(pObject_type,
1958: 'FORMULA','FM_FORM_MST_B',
1959: 'RECIPE','GMD_RECIPES_B',
1960: 'OPERATION','GMD_OPERATIONS_B',
1961: 'ROUTING','GMD_ROUTINGS_B',
1962: 'VALIDITY','GMD_RECIPE_VALIDITY_RULES'),
1963: DECODE(pObject_type,
1964: 'FORMULA','FORMULA_ID',
1965: 'RECIPE','RECIPE_ID',