APPS.IGS_PE_GOV_COUNTRYCD_PKG dependencies on IGS_PE_GOV_COUNTRYCD

Line 1: package body IGS_PE_GOV_COUNTRYCD_PKG AS

1: package body IGS_PE_GOV_COUNTRYCD_PKG AS
2: /* $Header: IGSNI07B.pls 115.3 2002/11/29 01:15:29 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PE_GOV_COUNTRYCD%RowType;

Line 5: old_references IGS_PE_GOV_COUNTRYCD%RowType;

1: package body IGS_PE_GOV_COUNTRYCD_PKG AS
2: /* $Header: IGSNI07B.pls 115.3 2002/11/29 01:15:29 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PE_GOV_COUNTRYCD%RowType;
6: new_references IGS_PE_GOV_COUNTRYCD%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PE_GOV_COUNTRYCD%RowType;

2: /* $Header: IGSNI07B.pls 115.3 2002/11/29 01:15:29 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PE_GOV_COUNTRYCD%RowType;
6: new_references IGS_PE_GOV_COUNTRYCD%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_COUNTRYCD

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

Line 122: IGS_PE_COUNTRY_CD_PKG.GET_FK_IGS_PE_GOV_COUNTRYCD (

118:
119: PROCEDURE Check_Child_Existance AS
120: BEGIN
121:
122: IGS_PE_COUNTRY_CD_PKG.GET_FK_IGS_PE_GOV_COUNTRYCD (
123: old_references.govt_country_cd
124: );
125:
126: END Check_Child_Existance;

Line 134: FROM IGS_PE_GOV_COUNTRYCD

130: ) RETURN BOOLEAN AS
131:
132: CURSOR cur_rowid IS
133: SELECT rowid
134: FROM IGS_PE_GOV_COUNTRYCD
135: WHERE govt_country_cd = x_govt_country_cd
136: FOR UPDATE NOWAIT;
137:
138: lv_rowid cur_rowid%RowType;

Line 247: cursor C is select ROWID from IGS_PE_GOV_COUNTRYCD

243: X_DESCRIPTION in VARCHAR2,
244: X_CLOSED_IND in VARCHAR2,
245: X_MODE in VARCHAR2 default 'R'
246: ) AS
247: cursor C is select ROWID from IGS_PE_GOV_COUNTRYCD
248: where GOVT_COUNTRY_CD = X_GOVT_COUNTRY_CD;
249: X_LAST_UPDATE_DATE DATE;
250: X_LAST_UPDATED_BY NUMBER;
251: X_LAST_UPDATE_LOGIN NUMBER;

Line 284: insert into IGS_PE_GOV_COUNTRYCD (

280: x_last_updated_by=>X_LAST_UPDATED_BY,
281: x_last_update_login=>X_LAST_UPDATE_LOGIN
282: );
283:
284: insert into IGS_PE_GOV_COUNTRYCD (
285: GOVT_COUNTRY_CD,
286: DESCRIPTION,
287: CLOSED_IND,
288: CREATION_DATE,

Line 326: from IGS_PE_GOV_COUNTRYCD

322: ) AS
323: cursor c1 is select
324: DESCRIPTION,
325: CLOSED_IND
326: from IGS_PE_GOV_COUNTRYCD
327: where ROWID = X_ROWID
328: for update nowait;
329: tlinfo c1%rowtype;
330:

Line 396: update IGS_PE_GOV_COUNTRYCD set

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

Line 420: cursor c1 is select rowid from IGS_PE_GOV_COUNTRYCD

416: X_DESCRIPTION in VARCHAR2,
417: X_CLOSED_IND in VARCHAR2,
418: X_MODE in VARCHAR2 default 'R'
419: ) AS
420: cursor c1 is select rowid from IGS_PE_GOV_COUNTRYCD
421: where GOVT_COUNTRY_CD = X_GOVT_COUNTRY_CD
422: ;
423:
424: begin

Line 454: delete from IGS_PE_GOV_COUNTRYCD

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

Line 466: end IGS_PE_GOV_COUNTRYCD_PKG;

462: );
463:
464: end DELETE_ROW;
465:
466: end IGS_PE_GOV_COUNTRYCD_PKG;