APPS.GMD_OPRN_MIGRATION dependencies on GMD_OPERATIONS_B

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)