APPS.GMD_CONC_REPLACE_PKG dependencies on GMD_OPERATION_ACTIVITIES

Line 246: l_old_actv GMD_OPERATION_ACTIVITIES.activity%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;
249: l_old_resource GMD_OPERATION_RESOURCES.resources%TYPE;
250: l_new_resource GMD_OPERATION_RESOURCES.resources%TYPE;

Line 247: l_new_actv GMD_OPERATION_ACTIVITIES.activity%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;
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;

Line 252: l_oprn_line_id GMD_OPERATION_ACTIVITIES.oprn_line_id%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;
256: l_organization_id GMD_RECIPES_B.owner_organization_id%TYPE;

Line 281: p_oprn_activity_table GMD_OPERATION_ACTIVITIES_PUB.update_tbl_type;

277:
278: -- Define different table types
279: p_rout_update_table GMD_ROUTINGS_PUB.update_tbl_type;
280: p_oprn_update_table GMD_OPERATIONS_PUB.update_tbl_type;
281: p_oprn_activity_table GMD_OPERATION_ACTIVITIES_PUB.update_tbl_type;
282: p_oprn_resources_table GMD_OPERATION_RESOURCES_PUB.update_tbl_type;
283: p_validity_rules_table GMD_VALIDITY_RULES_PVT.update_tbl_type;
284:
285: CURSOR get_object_info IS

Line 1459: FROM gmd_operation_activities

1455: -- Get the oprn_line_id based on the old oprn_id (object_id)
1456: -- and old activity (old_name).
1457: SELECT oprn_line_id
1458: INTO l_oprn_line_id
1459: FROM gmd_operation_activities
1460: WHERE oprn_id = get_object_rec.object_id
1461: AND activity = get_object_rec.old_name;
1462:
1463: p_oprn_activity_table(1).P_COL_TO_UPDATE := get_object_rec.replace_type;

Line 1466: GMD_OPERATION_ACTIVITIES_PUB.update_operation_activity

1462:
1463: p_oprn_activity_table(1).P_COL_TO_UPDATE := get_object_rec.replace_type;
1464: p_oprn_activity_table(1).P_VALUE := get_object_rec.new_name;
1465:
1466: GMD_OPERATION_ACTIVITIES_PUB.update_operation_activity
1467: ( p_oprn_line_id => l_oprn_line_id
1468: , p_update_table => p_oprn_activity_table
1469: , X_RETURN_STATUS => l_return_status --Return Status
1470: , X_MESSAGE_COUNT => l_mesg_count --Message Count

Line 1484: FROM gmd_operation_resources r, gmd_operation_activities a

1480: END IF;
1481:
1482: SELECT r.oprn_line_id
1483: INTO l_oprn_line_id
1484: FROM gmd_operation_resources r, gmd_operation_activities a
1485: WHERE a.oprn_id = get_object_rec.object_id
1486: AND r.resources = get_object_rec.old_name
1487: AND a.oprn_line_id = r.oprn_line_id;
1488:

Line 2063: fnd_dsql.add_text(' SELECT OPRN_ID FROM GMD_OPERATION_ACTIVITIES

2059: AND INVENTORY_ITEM_ID = ');
2060: fnd_dsql.add_bind(pOld_name);
2061: fnd_dsql.add_text(' ))');
2062: ELSIF (pReplace_type = 'ACTIVITY') THEN
2063: fnd_dsql.add_text(' SELECT OPRN_ID FROM GMD_OPERATION_ACTIVITIES
2064: WHERE ACTIVITY = ');
2065: fnd_dsql.add_bind(pOld_name);
2066: fnd_dsql.add_text(' ))');
2067: ELSIF (pReplace_type = 'RESOURCES') THEN

Line 2069: FROM GMD_OPERATION_ACTIVITIES a, GMD_OPERATION_RESOURCES r

2065: fnd_dsql.add_bind(pOld_name);
2066: fnd_dsql.add_text(' ))');
2067: ELSIF (pReplace_type = 'RESOURCES') THEN
2068: fnd_dsql.add_text(' SELECT OPRN_ID
2069: FROM GMD_OPERATION_ACTIVITIES a, GMD_OPERATION_RESOURCES r
2070: WHERE a.OPRN_LINE_ID = r.OPRN_LINE_ID
2071: AND r.RESOURCES = ');
2072: fnd_dsql.add_bind(pOld_name);
2073: fnd_dsql.add_text(' ))');