APPS.IGS_PE_GOV_ABRGRESCD_PKG dependencies on IGS_PE_GOV_ABRGRESCD

Line 1: package body IGS_PE_GOV_ABRGRESCD_PKG as

1: package body IGS_PE_GOV_ABRGRESCD_PKG as
2: /* $Header: IGSNI05B.pls 115.3 2002/11/29 01:14:50 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PE_GOV_ABRGRESCD%RowType;

Line 5: old_references IGS_PE_GOV_ABRGRESCD%RowType;

1: package body IGS_PE_GOV_ABRGRESCD_PKG as
2: /* $Header: IGSNI05B.pls 115.3 2002/11/29 01:14:50 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PE_GOV_ABRGRESCD%RowType;
6: new_references IGS_PE_GOV_ABRGRESCD%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PE_GOV_ABRGRESCD%RowType;

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

Line 23: FROM IGS_PE_GOV_ABRGRESCD

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

Line 123: IGS_PE_ABORG_TORESCD_PKG.GET_FK_IGS_PE_GOV_ABRGRESCD (

119:
120: PROCEDURE Check_Child_Existance as
121: BEGIN
122:
123: IGS_PE_ABORG_TORESCD_PKG.GET_FK_IGS_PE_GOV_ABRGRESCD (
124: old_references.govt_aborig_torres_cd
125: );
126:
127: END Check_Child_Existance;

Line 135: FROM IGS_PE_GOV_ABRGRESCD

131: ) RETURN BOOLEAN as
132:
133: CURSOR cur_rowid IS
134: SELECT rowid
135: FROM IGS_PE_GOV_ABRGRESCD
136: WHERE govt_aborig_torres_cd = x_govt_aborig_torres_cd
137: FOR UPDATE NOWAIT;
138:
139: lv_rowid cur_rowid%RowType;

Line 250: cursor C is select ROWID from IGS_PE_GOV_ABRGRESCD

246: X_DESCRIPTION in VARCHAR2,
247: X_CLOSED_IND in VARCHAR2,
248: X_MODE in VARCHAR2 default 'R'
249: ) as
250: cursor C is select ROWID from IGS_PE_GOV_ABRGRESCD
251: where GOVT_ABORIG_TORRES_CD = X_GOVT_ABORIG_TORRES_CD;
252: X_LAST_UPDATE_DATE DATE;
253: X_LAST_UPDATED_BY NUMBER;
254: X_LAST_UPDATE_LOGIN NUMBER;

Line 287: insert into IGS_PE_GOV_ABRGRESCD (

283: x_last_updated_by=>X_LAST_UPDATED_BY,
284: x_last_update_login=>X_LAST_UPDATE_LOGIN
285: );
286:
287: insert into IGS_PE_GOV_ABRGRESCD (
288: GOVT_ABORIG_TORRES_CD,
289: DESCRIPTION,
290: CLOSED_IND,
291: CREATION_DATE,

Line 329: from IGS_PE_GOV_ABRGRESCD

325: ) as
326: cursor c1 is select
327: DESCRIPTION,
328: CLOSED_IND
329: from IGS_PE_GOV_ABRGRESCD
330: where ROWID = X_ROWID
331: for update nowait;
332: tlinfo c1%rowtype;
333:

Line 398: update IGS_PE_GOV_ABRGRESCD set

394: x_last_update_date=>X_LAST_UPDATE_DATE,
395: x_last_updated_by=>X_LAST_UPDATED_BY,
396: x_last_update_login=>X_LAST_UPDATE_LOGIN
397: );
398: update IGS_PE_GOV_ABRGRESCD set
399: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
400: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
401: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
402: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 422: cursor c1 is select rowid from IGS_PE_GOV_ABRGRESCD

418: X_DESCRIPTION in VARCHAR2,
419: X_CLOSED_IND in VARCHAR2,
420: X_MODE in VARCHAR2 default 'R'
421: ) as
422: cursor c1 is select rowid from IGS_PE_GOV_ABRGRESCD
423: where GOVT_ABORIG_TORRES_CD = X_GOVT_ABORIG_TORRES_CD
424: ;
425:
426: begin

Line 456: delete from IGS_PE_GOV_ABRGRESCD

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

Line 467: end IGS_PE_GOV_ABRGRESCD_PKG;

463: x_rowid => X_ROWID
464: );
465: end DELETE_ROW;
466:
467: end IGS_PE_GOV_ABRGRESCD_PKG;