APPS.GMD_OPRN_MIGRATION dependencies on GMD_OPERATIONS

Line 4: PROCEDURE INSERT_GMD_OPERATIONS IS

1: PACKAGE BODY GMD_OPRN_MIGRATION AS
2: /* $Header: GMDOMIGB.pls 120.1 2006/07/18 14:17:05 kmotupal noship $ */
3:
4: PROCEDURE INSERT_GMD_OPERATIONS IS
5:
6: CURSOR Cur_Formula_Id(prouting_id NUMBER) IS
7: SELECT formula_Id
8: FROM fm_form_eff_bak

Line 22: FROM gmd_operations_b o

18: /*upgrading from 11.5.9 to 11.5.10 and the deleted activity and resources */
19: /*were getting added */
20: CURSOR Cur_get_oprn_id IS
21: SELECT *
22: FROM gmd_operations_b o
23: WHERE operation_status IS NULL;
24:
25: l_orgn_code VARCHAR2(6);
26: l_oprn_Id NUMBER;

Line 56: /* Update the gmd_operations_b and tl table */

52: IF ((oprn_rout_rec.inactive_ind = 1) OR (oprn_rout_rec.delete_mark = 1)) THEN
53: l_operation_status := '1000';
54: END IF;
55:
56: /* Update the gmd_operations_b and tl table */
57: UPDATE gmd_operations_b
58: SET operation_status = l_operation_status,
59: effective_start_date = oprn_rout_rec.creation_date,
60: owner_orgn_code =

Line 57: UPDATE gmd_operations_b

53: l_operation_status := '1000';
54: END IF;
55:
56: /* Update the gmd_operations_b and tl table */
57: UPDATE gmd_operations_b
58: SET operation_status = l_operation_status,
59: effective_start_date = oprn_rout_rec.creation_date,
60: owner_orgn_code =
61: fnd_profile.value_specific('GEMMS_DEFAULT_ORGN',oprn_rout_rec.created_by)

Line 73: ,p_target_table => 'GMD_OPERATIONS'

69: EXCEPTION
70: WHEN OTHERS THEN
71: error_msg := SQLERRM;
72: GMD_RECIPE_MIGRATION.insert_message (p_source_table => 'FM_OPRN_MST'
73: ,p_target_table => 'GMD_OPERATIONS'
74: ,p_source_id => oprn_rout_rec.oprn_id
75: ,p_target_id => oprn_rout_rec.oprn_id
76: ,p_message => error_msg
77: ,p_error_type => 'U');

Line 79: END LOOP; /* for insert in gmd operations */

75: ,p_target_id => oprn_rout_rec.oprn_id
76: ,p_message => error_msg
77: ,p_error_type => 'U');
78: END;
79: END LOOP; /* for insert in gmd operations */
80: END INSERT_GMD_OPERATIONS;
81:
82: PROCEDURE INSERT_GMD_OPERATION_COMPS (P_Oprn_id IN NUMBER) IS
83: /*Bug#3601848 - Thomas Daniel */

Line 80: END INSERT_GMD_OPERATIONS;

76: ,p_message => error_msg
77: ,p_error_type => 'U');
78: END;
79: END LOOP; /* for insert in gmd operations */
80: END INSERT_GMD_OPERATIONS;
81:
82: PROCEDURE INSERT_GMD_OPERATION_COMPS (P_Oprn_id IN NUMBER) IS
83: /*Bug#3601848 - Thomas Daniel */
84: /*Added oprn_id as parameter to this procedure and restricting the activities */

Line 246: FROM gmd_operations

242: CLOSE get_resource_capacity;
243:
244: SELECT PROCESS_QTY_UM
245: INTO v_process_uom
246: FROM gmd_operations
247: WHERE oprn_id = p_oprn_id;
248:
249: --BEGIN BUG#3316385
250: IF v_activity_rec.process_qty = 0 AND v_activity_rec.resource_usage <> 0