APPS.GMS_OVERRIDE_SCHEDULES_PKG dependencies on GMS_OVERRIDE_SCHEDULES

Line 1: PACKAGE BODY GMS_OVERRIDE_SCHEDULES_PKG as

1: PACKAGE BODY GMS_OVERRIDE_SCHEDULES_PKG as
2: /* $Header: gmsicovb.pls 115.8 2002/11/25 23:41:38 jmuthuku ship $ */
3:
4: PROCEDURE Insert_Row(p_rowid IN OUT NOCOPY VARCHAR2,
5: p_award_id IN NUMBER,

Line 13: FROM GMS_OVERRIDE_SCHEDULES

9: p_cost_ind_sch_fixed_date IN DATE,
10: p_mode IN VARCHAR2 default 'R') IS
11: CURSOR get_rowid IS
12: SELECT rowid
13: FROM GMS_OVERRIDE_SCHEDULES
14: WHERE award_id = p_award_id
15: AND project_id = p_project_id
16: AND (task_id = p_task_id
17: OR (task_id is NULL AND p_task_id is NULL));

Line 41: INSERT into GMS_OVERRIDE_SCHEDULES

37: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
38: app_exception.raise_exception;
39: END IF;
40:
41: INSERT into GMS_OVERRIDE_SCHEDULES
42: (award_id,
43: project_id,
44: task_id,
45: idc_schedule_id,

Line 105: UPDATE GMS_OVERRIDE_SCHEDULES

101: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
102: app_exception.raise_exception;
103: END IF;
104:
105: UPDATE GMS_OVERRIDE_SCHEDULES
106: SET project_id = p_project_id,
107: task_id = p_task_id,
108: idc_schedule_id = p_idc_schedule_id,
109: cost_ind_sch_fixed_date = p_cost_ind_sch_fixed_date,

Line 124: DELETE gms_override_schedules

120:
121:
122: PROCEDURE Delete_Row(p_rowid IN VARCHAR2) IS
123: Begin
124: DELETE gms_override_schedules
125: WHERE rowid = p_rowid;
126:
127: IF (sql%NOTFOUND) THEN
128: raise no_data_found;

Line 141: FROM GMS_OVERRIDE_SCHEDULES

137: p_idc_schedule_id IN NUMBER,
138: p_cost_ind_sch_fixed_date IN DATE) IS
139: CURSOR ovr_sch IS
140: SELECT award_id, project_id, task_id, idc_schedule_id, cost_ind_sch_fixed_date
141: FROM GMS_OVERRIDE_SCHEDULES
142: WHERE rowid = p_rowid
143: for update of idc_schedule_id, cost_ind_sch_fixed_date nowait;
144:
145: recinfo ovr_sch%rowtype;

Line 170: END GMS_OVERRIDE_SCHEDULES_PKG;

166: END IF;
167:
168: End lock_row;
169:
170: END GMS_OVERRIDE_SCHEDULES_PKG;