eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_CONC_REPLACE_PKG dependencies on GMD_OPERATION_RESOURCES

Line 249: l_old_resource GMD_OPERATION_RESOURCES.resources%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;
253:

Line 250: l_new_resource GMD_OPERATION_RESOURCES.resources%TYPE;

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;
253:
254:

Line 282: p_oprn_resources_table GMD_OPERATION_RESOURCES_PUB.update_tbl_type;

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
286: SElECT Upper(pObject_type) Object_type -- e.g 'FORMULA', 'RECIPE' etc

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 1497: GMD_OPERATION_RESOURCES_PUB.update_operation_resources

1493:
1494: p_oprn_resources_table(1).P_COL_TO_UPDATE := get_object_rec.replace_type;
1495: p_oprn_resources_table(1).P_VALUE := get_object_rec.new_name;
1496:
1497: GMD_OPERATION_RESOURCES_PUB.update_operation_resources
1498: ( p_oprn_line_id => l_oprn_line_id
1499: , p_resources => get_object_rec.old_name
1500: , p_update_table => p_oprn_resources_table
1501: , X_RETURN_STATUS => l_return_status --Return Status

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(' ))');