APPS.GMD_CONC_REPLACE_PKG dependencies on GMD_OPERATIONS_B

Line 240: l_old_oprn GMD_OPERATIONS_B.oprn_no%TYPE;

236: l_start_date VARCHAR2(32);
237: l_end_date VARCHAR2(32);
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;

Line 241: l_new_oprn GMD_OPERATIONS_B.oprn_no%TYPE;

237: l_end_date VARCHAR2(32);
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:

Line 248: l_oprn_class GMD_OPERATIONS_B.oprn_class%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;
249: l_old_resource GMD_OPERATION_RESOURCES.resources%TYPE;
250: l_new_resource GMD_OPERATION_RESOURCES.resources%TYPE;
251: l_oprn_id GMD_OPERATIONS_B.oprn_id%TYPE;
252: l_oprn_line_id GMD_OPERATION_ACTIVITIES.oprn_line_id%TYPE;

Line 251: l_oprn_id GMD_OPERATIONS_B.oprn_id%TYPE;

247: l_new_actv GMD_OPERATION_ACTIVITIES.activity%TYPE;
248: l_oprn_class GMD_OPERATIONS_B.oprn_class%TYPE;
249: l_old_resource GMD_OPERATION_RESOURCES.resources%TYPE;
250: l_new_resource GMD_OPERATION_RESOURCES.resources%TYPE;
251: l_oprn_id GMD_OPERATIONS_B.oprn_id%TYPE;
252: l_oprn_line_id GMD_OPERATION_ACTIVITIES.oprn_line_id%TYPE;
253:
254:
255: l_owner_org GMD_RECIPES_B.owner_orgn_code%TYPE;

Line 1314: FROM gmd_operations_b opr

1310: ELSIF (get_object_rec.object_type = 'OPERATION') THEN
1311: -- Get the action flag to decide on update or insert(version control)
1312: SELECT opr.owner_organization_id
1313: INTO l_orgn_id
1314: FROM gmd_operations_b opr
1315: WHERE opr.oprn_id = get_object_rec.object_id;
1316:
1317: -- Get the Operation version control for the entity orgn.
1318: GMD_API_GRP.FETCH_PARM_VALUES(P_orgn_id => l_orgn_id,

Line 1419: FROM gmd_operations_b

1415: RAISE No_Update_Exception;
1416: ELSE
1417: SELECT oprn_vers
1418: INTO l_object_version
1419: FROM gmd_operations_b
1420: WHERE oprn_id = l_oprn_id;
1421:
1422: -- Setup message to indicate that a new version
1423: -- has been created

Line 1960: 'OPERATION','GMD_OPERATIONS_B',

1956:
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',