APPS.IGS_AD_GOV_BAS_FR_TY_PKG dependencies on IGS_AD_GOV_BAS_FR_TY

Line 1: package body IGS_AD_GOV_BAS_FR_TY_PKG as

1: package body IGS_AD_GOV_BAS_FR_TY_PKG as
2: /* $Header: IGSAI32B.pls 115.5 2003/10/30 13:12:21 akadam ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_GOV_BAS_FR_TY%RowType;

Line 5: old_references IGS_AD_GOV_BAS_FR_TY%RowType;

1: package body IGS_AD_GOV_BAS_FR_TY_PKG as
2: /* $Header: IGSAI32B.pls 115.5 2003/10/30 13:12:21 akadam ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_GOV_BAS_FR_TY%RowType;
6: new_references IGS_AD_GOV_BAS_FR_TY%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_AD_GOV_BAS_FR_TY%RowType;

2: /* $Header: IGSAI32B.pls 115.5 2003/10/30 13:12:21 akadam ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_GOV_BAS_FR_TY%RowType;
6: new_references IGS_AD_GOV_BAS_FR_TY%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 22: FROM IGS_AD_GOV_BAS_FR_TY

18: x_last_update_login IN NUMBER DEFAULT NULL
19: ) as
20: CURSOR cur_old_ref_values IS
21: SELECT *
22: FROM IGS_AD_GOV_BAS_FR_TY
23: WHERE rowid = x_rowid;
24:
25: BEGIN
26:

Line 127: IGS_AD_BASIS_FOR_AD_PKG.GET_FK_IGS_AD_GOV_BAS_FR_TY (

123:
124: PROCEDURE Check_Child_Existance as
125: BEGIN
126:
127: IGS_AD_BASIS_FOR_AD_PKG.GET_FK_IGS_AD_GOV_BAS_FR_TY (
128: old_references.GOVT_BASIS_FOR_ADM_TYPE
129: );
130:
131: END Check_Child_Existance;

Line 141: FROM IGS_AD_GOV_BAS_FR_TY

137: as
138:
139: CURSOR cur_rowid IS
140: SELECT rowid
141: FROM IGS_AD_GOV_BAS_FR_TY
142: WHERE GOVT_BASIS_FOR_ADM_TYPE = x_govt_basis_for_adm_type AND
143: closed_ind = NVL(x_closed_ind,closed_ind);
144:
145: lv_rowid cur_rowid%RowType;

Line 241: cursor C is select ROWID from IGS_AD_GOV_BAS_FR_TY

237: X_DESCRIPTION in VARCHAR2,
238: X_CLOSED_IND in VARCHAR2,
239: X_MODE in VARCHAR2 default 'R'
240: ) as
241: cursor C is select ROWID from IGS_AD_GOV_BAS_FR_TY
242: where GOVT_BASIS_FOR_ADM_TYPE = X_GOVT_BASIS_FOR_ADM_TYPE;
243: X_LAST_UPDATE_DATE DATE;
244: X_LAST_UPDATED_BY NUMBER;
245: X_LAST_UPDATE_LOGIN NUMBER;

Line 280: insert into IGS_AD_GOV_BAS_FR_TY (

276: x_last_update_login => X_LAST_UPDATE_LOGIN
277: );
278:
279:
280: insert into IGS_AD_GOV_BAS_FR_TY (
281: GOVT_BASIS_FOR_ADM_TYPE,
282: DESCRIPTION,
283: CLOSED_IND,
284: CREATION_DATE,

Line 323: from IGS_AD_GOV_BAS_FR_TY

319: ) as
320: cursor c1 is select
321: DESCRIPTION,
322: CLOSED_IND
323: from IGS_AD_GOV_BAS_FR_TY
324: WHERE ROWID = X_ROWID for update nowait ;
325: tlinfo c1%rowtype;
326:
327: begin

Line 394: update IGS_AD_GOV_BAS_FR_TY set

390: x_last_updated_by => X_LAST_UPDATED_BY,
391: x_last_update_login => X_LAST_UPDATE_LOGIN
392: );
393:
394: update IGS_AD_GOV_BAS_FR_TY set
395: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
396: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
397: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
398: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 417: cursor c1 is select rowid from IGS_AD_GOV_BAS_FR_TY

413: X_DESCRIPTION in VARCHAR2,
414: X_CLOSED_IND in VARCHAR2,
415: X_MODE in VARCHAR2 default 'R'
416: ) as
417: cursor c1 is select rowid from IGS_AD_GOV_BAS_FR_TY
418: where GOVT_BASIS_FOR_ADM_TYPE = X_GOVT_BASIS_FOR_ADM_TYPE
419: ;
420:
421: begin

Line 451: delete from IGS_AD_GOV_BAS_FR_TY

447: Before_DML (
448: p_action => 'DELETE',
449: x_rowid => X_ROWID
450: );
451: delete from IGS_AD_GOV_BAS_FR_TY
452: where ROWID = X_ROWID;
453: if (sql%notfound) then
454: raise no_data_found;
455: end if;

Line 462: end IGS_AD_GOV_BAS_FR_TY_PKG;

458: x_rowid => X_ROWID
459: );
460: end DELETE_ROW;
461:
462: end IGS_AD_GOV_BAS_FR_TY_PKG;