APPS.IGS_RE_GV_TOA_CLS_CD_PKG dependencies on IGS_RE_GV_TOA_CLS_CD

Line 1: package body IGS_RE_GV_TOA_CLS_CD_PKG as

1: package body IGS_RE_GV_TOA_CLS_CD_PKG as
2: /* $Header: IGSRI09B.pls 115.3 2002/11/29 03:33:31 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_RE_GV_TOA_CLS_CD%RowType;

Line 5: old_references IGS_RE_GV_TOA_CLS_CD%RowType;

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

Line 6: new_references IGS_RE_GV_TOA_CLS_CD%RowType;

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

Line 23: FROM IGS_RE_GV_TOA_CLS_CD

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

Line 93: IGS_RE_CANDIDATURE_PKG.GET_FK_IGS_RE_GV_TOA_CLS_CD (

89:
90: PROCEDURE Check_Child_Existance AS
91: BEGIN
92:
93: IGS_RE_CANDIDATURE_PKG.GET_FK_IGS_RE_GV_TOA_CLS_CD (
94: old_references.govt_toa_class_cd
95: );
96:
97: END Check_Child_Existance;

Line 105: FROM IGS_RE_GV_TOA_CLS_CD

101: ) RETURN BOOLEAN AS
102:
103: CURSOR cur_rowid IS
104: SELECT rowid
105: FROM IGS_RE_GV_TOA_CLS_CD
106: WHERE govt_toa_class_cd = x_govt_toa_class_cd
107: FOR UPDATE NOWAIT;
108:
109: lv_rowid cur_rowid%RowType;

Line 192: cursor C is select ROWID from IGS_RE_GV_TOA_CLS_CD

188: X_DESCRIPTION in VARCHAR2,
189: X_CLOSED_IND in VARCHAR2,
190: X_MODE in VARCHAR2 default 'R'
191: ) as
192: cursor C is select ROWID from IGS_RE_GV_TOA_CLS_CD
193: where GOVT_TOA_CLASS_CD = X_GOVT_TOA_CLASS_CD;
194: X_LAST_UPDATE_DATE DATE;
195: X_LAST_UPDATED_BY NUMBER;
196: X_LAST_UPDATE_LOGIN NUMBER;

Line 230: insert into IGS_RE_GV_TOA_CLS_CD (

226: x_last_update_date => X_LAST_UPDATE_DATE,
227: x_last_update_login => X_LAST_UPDATE_LOGIN
228: );
229:
230: insert into IGS_RE_GV_TOA_CLS_CD (
231: GOVT_TOA_CLASS_CD,
232: DESCRIPTION,
233: CLOSED_IND,
234: CREATION_DATE,

Line 269: from IGS_RE_GV_TOA_CLS_CD

265: ) as
266: cursor c1 is select
267: DESCRIPTION,
268: CLOSED_IND
269: from IGS_RE_GV_TOA_CLS_CD
270: where ROWID = X_ROWID
271: for update nowait;
272: tlinfo c1%rowtype;
273:

Line 339: update IGS_RE_GV_TOA_CLS_CD set

335: x_last_update_date => X_LAST_UPDATE_DATE,
336: x_last_update_login => X_LAST_UPDATE_LOGIN
337: );
338:
339: update IGS_RE_GV_TOA_CLS_CD set
340: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
341: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
342: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
343: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 360: cursor c1 is select rowid from IGS_RE_GV_TOA_CLS_CD

356: X_DESCRIPTION in VARCHAR2,
357: X_CLOSED_IND in VARCHAR2,
358: X_MODE in VARCHAR2 default 'R'
359: ) as
360: cursor c1 is select rowid from IGS_RE_GV_TOA_CLS_CD
361: where GOVT_TOA_CLASS_CD = X_GOVT_TOA_CLASS_CD
362: ;
363: begin
364: open c1;

Line 395: delete from IGS_RE_GV_TOA_CLS_CD

391: p_action => 'DELETE',
392: x_rowid => X_ROWID
393: );
394:
395: delete from IGS_RE_GV_TOA_CLS_CD
396: where ROWID = X_ROWID;
397: if (sql%notfound) then
398: raise no_data_found;
399: end if;

Line 403: end IGS_RE_GV_TOA_CLS_CD_PKG;

399: end if;
400:
401: end DELETE_ROW;
402:
403: end IGS_RE_GV_TOA_CLS_CD_PKG;