APPS.IGS_RE_S_RES_CAL_CON_PKG dependencies on IGS_RE_S_RES_CAL_CON

Line 1: package body IGS_RE_S_RES_CAL_CON_PKG as

1: package body IGS_RE_S_RES_CAL_CON_PKG as
2: /* $Header: IGSRI25B.pls 115.3 2002/11/29 03:38:22 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_RE_S_RES_CAL_CON%RowType;

Line 5: old_references IGS_RE_S_RES_CAL_CON%RowType;

1: package body IGS_RE_S_RES_CAL_CON_PKG as
2: /* $Header: IGSRI25B.pls 115.3 2002/11/29 03:38:22 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_RE_S_RES_CAL_CON%RowType;
6: new_references IGS_RE_S_RES_CAL_CON%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_RE_S_RES_CAL_CON%RowType;

2: /* $Header: IGSRI25B.pls 115.3 2002/11/29 03:38:22 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_RE_S_RES_CAL_CON%RowType;
6: new_references IGS_RE_S_RES_CAL_CON%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 23: FROM IGS_RE_S_RES_CAL_CON

19: ) AS
20:
21: CURSOR cur_old_ref_values IS
22: SELECT *
23: FROM IGS_RE_S_RES_CAL_CON
24: WHERE rowid = x_rowid;
25:
26: BEGIN
27:

Line 137: FROM IGS_RE_S_RES_CAL_CON

133: AS
134:
135: CURSOR cur_rowid IS
136: SELECT rowid
137: FROM IGS_RE_S_RES_CAL_CON
138: WHERE s_control_num = x_s_control_num
139: FOR UPDATE NOWAIT;
140:
141: lv_rowid cur_rowid%RowType;

Line 162: FROM IGS_RE_S_RES_CAL_CON

158: ) AS
159:
160: CURSOR cur_rowid IS
161: SELECT rowid
162: FROM IGS_RE_S_RES_CAL_CON
163: WHERE effective_end_dt_alias = x_dt_alias
164: OR effective_strt_dt_alias = x_dt_alias;
165:
166: lv_rowid cur_rowid%RowType;

Line 248: cursor C is select ROWID from IGS_RE_S_RES_CAL_CON

244: X_EFFECTIVE_STRT_DT_ALIAS in VARCHAR2,
245: X_EFFECTIVE_END_DT_ALIAS in VARCHAR2,
246: X_MODE in VARCHAR2 default 'R'
247: ) as
248: cursor C is select ROWID from IGS_RE_S_RES_CAL_CON
249: where S_CONTROL_NUM = NEW_REFERENCES.S_CONTROL_NUM;
250: X_LAST_UPDATE_DATE DATE;
251: X_LAST_UPDATED_BY NUMBER;
252: X_LAST_UPDATE_LOGIN NUMBER;

Line 286: insert into IGS_RE_S_RES_CAL_CON (

282: x_last_updated_by=>X_LAST_UPDATED_BY,
283: x_last_update_login=>X_LAST_UPDATE_LOGIN
284: );
285:
286: insert into IGS_RE_S_RES_CAL_CON (
287: S_CONTROL_NUM,
288: EFFECTIVE_STRT_DT_ALIAS,
289: EFFECTIVE_END_DT_ALIAS,
290: CREATION_DATE,

Line 325: from IGS_RE_S_RES_CAL_CON

321: ) as
322: cursor c1 is select
323: EFFECTIVE_STRT_DT_ALIAS,
324: EFFECTIVE_END_DT_ALIAS
325: from IGS_RE_S_RES_CAL_CON
326: where ROWID = X_ROWID
327: for update nowait;
328: tlinfo c1%rowtype;
329:

Line 399: update IGS_RE_S_RES_CAL_CON set

395: x_last_updated_by=>X_LAST_UPDATED_BY,
396: x_last_update_login=>X_LAST_UPDATE_LOGIN
397: );
398:
399: update IGS_RE_S_RES_CAL_CON set
400: EFFECTIVE_STRT_DT_ALIAS = NEW_REFERENCES.EFFECTIVE_STRT_DT_ALIAS,
401: EFFECTIVE_END_DT_ALIAS = NEW_REFERENCES.EFFECTIVE_END_DT_ALIAS,
402: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
403: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 420: cursor c1 is select rowid from IGS_RE_S_RES_CAL_CON

416: X_EFFECTIVE_STRT_DT_ALIAS in VARCHAR2,
417: X_EFFECTIVE_END_DT_ALIAS in VARCHAR2,
418: X_MODE in VARCHAR2 default 'R'
419: ) as
420: cursor c1 is select rowid from IGS_RE_S_RES_CAL_CON
421: where S_CONTROL_NUM = NVL(X_S_CONTROL_NUM, 1)
422: ;
423: begin
424: open c1;

Line 455: delete from IGS_RE_S_RES_CAL_CON

451: p_action=>'DELETE',
452: x_rowid=>X_ROWID
453: );
454:
455: delete from IGS_RE_S_RES_CAL_CON
456: where ROWID = X_ROWID;
457:
458: if (sql%notfound) then
459: raise no_data_found;

Line 464: end IGS_RE_S_RES_CAL_CON_PKG;

460: end if;
461:
462: end DELETE_ROW;
463:
464: end IGS_RE_S_RES_CAL_CON_PKG;