APPS.GMD_OPERATION_RESOURCES_PUB dependencies on GMD_OPERATION_ACTIVITIES

Line 43: FROM gmd_operation_activities

39:
40: /* Global Cursors */
41: CURSOR check_oprn_line_id(V_oprn_line_id NUMBER) IS
42: SELECT 1
43: FROM gmd_operation_activities
44: WHERE oprn_line_id = v_oprn_line_id;
45:
46:
47: --Bug#7118558

Line 113: , p_oprn_line_id IN gmd_operation_activities.oprn_line_id%TYPE

109: PROCEDURE insert_operation_resources
110: ( p_api_version IN NUMBER
111: , p_init_msg_list IN BOOLEAN
112: , p_commit IN BOOLEAN
113: , p_oprn_line_id IN gmd_operation_activities.oprn_line_id%TYPE
114: , p_oprn_rsrc_tbl IN gmd_operation_resources_pub.gmd_oprn_resources_tbl_type
115: , x_message_count OUT NOCOPY NUMBER
116: , x_message_list OUT NOCOPY VARCHAR2
117: , x_return_status OUT NOCOPY VARCHAR2) IS

Line 134: FROM gmd_operation_activities

130: inv_resource_ind EXCEPTION;
131:
132: CURSOR get_oprn_id(V_oprn_line_id NUMBER) IS
133: SELECT oprn_id
134: FROM gmd_operation_activities
135: WHERE oprn_line_id = V_oprn_line_id;
136:
137: CURSOR fetch_proc_uom (V_oprn_line_id NUMBER) IS
138: SELECT process_qty_uom

Line 139: FROM gmd_operations a, gmd_operation_activities b

135: WHERE oprn_line_id = V_oprn_line_id;
136:
137: CURSOR fetch_proc_uom (V_oprn_line_id NUMBER) IS
138: SELECT process_qty_uom
139: FROM gmd_operations a, gmd_operation_activities b
140: WHERE a.oprn_id = b.oprn_id
141: AND b.oprn_line_id = V_oprn_line_id;
142:
143: CURSOR get_resource_det (V_resources VARCHAR2) IS

Line 154: FROM fm_actv_mst a, gmd_operation_activities o

150: AND cm.usage_ind = 3;
151:
152: CURSOR get_cost_analysis_code (V_oprn_line_id NUMBER) IS
153: SELECT cost_analysis_code
154: FROM fm_actv_mst a, gmd_operation_activities o
155: WHERE o.activity = a.activity
156: AND o.oprn_line_id = V_oprn_line_id;
157:
158: --Bug#7118558

Line 506: FROM gmd_operation_activities

502: setup_failure EXCEPTION;
503:
504: CURSOR get_oprn_id (p_oprN_line_id gmd_operation_resources.oprn_line_id%TYPE) IS
505: SELECT oprn_id
506: FROM gmd_operation_activities
507: WHERE oprn_line_id = p_oprn_line_id;
508:
509: upd_oprn_rsrc_err EXCEPTION;
510: BEGIN

Line 772: FROM gmd_operation_activities

768: inv_resource_ind EXCEPTION;
769:
770: CURSOR check_oprn_line_id(p_oprn_line_id NUMBER) IS
771: SELECT 1
772: FROM gmd_operation_activities
773: WHERE oprn_line_id = p_oprn_line_id;
774:
775: CURSOR check_Resource(p_oprn_line_id NUMBER, p_resources VARCHAR2) IS
776: SELECT 1

Line 783: FROM gmd_operation_activities

779: AND resources = p_resources;
780:
781: CURSOR get_oprn_id (p_oprN_line_id gmd_operation_resources.oprn_line_id%TYPE) IS
782: SELECT oprn_id
783: FROM gmd_operation_activities
784: WHERE oprn_line_id = p_oprn_line_id;
785:
786: BEGIN
787: SAVEPOINT delete_oprn_rsrc;