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 384: l_old_resource GMD_OPERATION_RESOURCES.resources%TYPE;

380:
381: l_old_actv GMD_OPERATION_ACTIVITIES.activity%TYPE;
382: l_new_actv GMD_OPERATION_ACTIVITIES.activity%TYPE;
383: l_oprn_class GMD_OPERATIONS_B.oprn_class%TYPE;
384: l_old_resource GMD_OPERATION_RESOURCES.resources%TYPE;
385: l_new_resource GMD_OPERATION_RESOURCES.resources%TYPE;
386: l_oprn_id GMD_OPERATIONS_B.oprn_id%TYPE;
387: l_oprn_line_id GMD_OPERATION_ACTIVITIES.oprn_line_id%TYPE;
388:

Line 385: l_new_resource GMD_OPERATION_RESOURCES.resources%TYPE;

381: l_old_actv GMD_OPERATION_ACTIVITIES.activity%TYPE;
382: l_new_actv GMD_OPERATION_ACTIVITIES.activity%TYPE;
383: l_oprn_class GMD_OPERATIONS_B.oprn_class%TYPE;
384: l_old_resource GMD_OPERATION_RESOURCES.resources%TYPE;
385: l_new_resource GMD_OPERATION_RESOURCES.resources%TYPE;
386: l_oprn_id GMD_OPERATIONS_B.oprn_id%TYPE;
387: l_oprn_line_id GMD_OPERATION_ACTIVITIES.oprn_line_id%TYPE;
388:
389:

Line 422: gmd_operation_activities.oprn_id%TYPE,cp_resource_name gmd_operation_resources.resources%TYPE) is

418: WHERE routing_id = cp_routing_id
419: AND oprn_id = cp_oprn_id;
420:
421: CURSOR c_Operation_line_id (cp_operation_id
422: gmd_operation_activities.oprn_id%TYPE,cp_resource_name gmd_operation_resources.resources%TYPE) is
423: SELECT r.oprn_line_id
424: FROM gmd_operation_resources r, gmd_operation_activities a
425: WHERE a.oprn_id = cp_operation_id
426: AND r.resources = cp_resource_name

Line 424: FROM gmd_operation_resources r, gmd_operation_activities a

420:
421: CURSOR c_Operation_line_id (cp_operation_id
422: gmd_operation_activities.oprn_id%TYPE,cp_resource_name gmd_operation_resources.resources%TYPE) is
423: SELECT r.oprn_line_id
424: FROM gmd_operation_resources r, gmd_operation_activities a
425: WHERE a.oprn_id = cp_operation_id
426: AND r.resources = cp_resource_name
427: AND a.oprn_line_id = r.oprn_line_id;
428:

Line 435: p_oprn_resources_table GMD_OPERATION_RESOURCES_PUB.update_tbl_type;

431: -- Define different table types
432: p_rout_update_table GMD_ROUTINGS_PUB.update_tbl_type;
433: p_oprn_update_table GMD_OPERATIONS_PUB.update_tbl_type;
434: p_oprn_activity_table GMD_OPERATION_ACTIVITIES_PUB.update_tbl_type;
435: p_oprn_resources_table GMD_OPERATION_RESOURCES_PUB.update_tbl_type;
436: p_validity_rules_table GMD_VALIDITY_RULES_PVT.update_tbl_type;
437:
438: CURSOR get_object_info IS
439: SElECT Upper(pObject_type) Object_type -- e.g 'FORMULA', 'RECIPE' etc

Line 1674: GMD_OPERATION_RESOURCES_PUB.update_operation_resources

1670:
1671: p_oprn_resources_table(1).P_COL_TO_UPDATE := get_object_rec.replace_type;
1672: p_oprn_resources_table(1).P_VALUE := get_object_rec.new_name;
1673:
1674: GMD_OPERATION_RESOURCES_PUB.update_operation_resources
1675: ( p_oprn_line_id => l_oprn_line_id
1676: , p_resources => get_object_rec.old_name
1677: , p_update_table => p_oprn_resources_table
1678: , X_RETURN_STATUS => l_return_status --Return Status

Line 2255: FROM GMD_OPERATION_ACTIVITIES a, GMD_OPERATION_RESOURCES r

2251: fnd_dsql.add_bind(pOld_name);
2252: fnd_dsql.add_text(' ))');
2253: ELSIF (pReplace_type = 'RESOURCES') THEN
2254: fnd_dsql.add_text(' SELECT OPRN_ID
2255: FROM GMD_OPERATION_ACTIVITIES a, GMD_OPERATION_RESOURCES r
2256: WHERE a.OPRN_LINE_ID = r.OPRN_LINE_ID
2257: AND r.RESOURCES = ');
2258: fnd_dsql.add_bind(pOld_name);
2259: fnd_dsql.add_text(' ))');