APPS.IGS_PE_GOV_LANG_CD_PKG dependencies on IGS_PE_GOV_LANG_CD

Line 1: package body IGS_PE_GOV_LANG_CD_PKG AS

1: package body IGS_PE_GOV_LANG_CD_PKG AS
2: /* $Header: IGSNI08B.pls 115.3 2002/11/29 01:15:45 nsidana ship $ */
3:
4:
5:

Line 9: old_references IGS_PE_GOV_LANG_CD%RowType;

5:
6:
7: l_rowid VARCHAR2(25);
8:
9: old_references IGS_PE_GOV_LANG_CD%RowType;
10:
11: new_references IGS_PE_GOV_LANG_CD%RowType;
12:
13:

Line 11: new_references IGS_PE_GOV_LANG_CD%RowType;

7: l_rowid VARCHAR2(25);
8:
9: old_references IGS_PE_GOV_LANG_CD%RowType;
10:
11: new_references IGS_PE_GOV_LANG_CD%RowType;
12:
13:
14:
15: PROCEDURE Set_Column_Values (

Line 45: FROM IGS_PE_GOV_LANG_CD

41: CURSOR cur_old_ref_values IS
42:
43: SELECT *
44:
45: FROM IGS_PE_GOV_LANG_CD
46:
47: WHERE rowid = x_rowid;
48:
49:

Line 201: IGS_PE_LANGUAGE_CD_PKG.GET_FK_IGS_PE_GOV_LANG_CD (

197: BEGIN
198:
199:
200:
201: IGS_PE_LANGUAGE_CD_PKG.GET_FK_IGS_PE_GOV_LANG_CD (
202:
203: old_references.govt_language_cd
204:
205: );

Line 225: FROM IGS_PE_GOV_LANG_CD

221: CURSOR cur_rowid IS
222:
223: SELECT rowid
224:
225: FROM IGS_PE_GOV_LANG_CD
226:
227: WHERE govt_language_cd = x_govt_language_cd
228:
229: FOR UPDATE NOWAIT;

Line 396: cursor C is select ROWID from IGS_PE_GOV_LANG_CD

392: X_DESCRIPTION in VARCHAR2,
393: X_CLOSED_IND in VARCHAR2,
394: X_MODE in VARCHAR2 default 'R'
395: ) AS
396: cursor C is select ROWID from IGS_PE_GOV_LANG_CD
397: where GOVT_LANGUAGE_CD = X_GOVT_LANGUAGE_CD;
398: X_LAST_UPDATE_DATE DATE;
399: X_LAST_UPDATED_BY NUMBER;
400: X_LAST_UPDATE_LOGIN NUMBER;

Line 444: insert into IGS_PE_GOV_LANG_CD (

440:
441: x_last_update_login=>X_LAST_UPDATE_LOGIN
442:
443: );
444: insert into IGS_PE_GOV_LANG_CD (
445: GOVT_LANGUAGE_CD,
446: DESCRIPTION,
447: CLOSED_IND,
448: CREATION_DATE,

Line 490: from IGS_PE_GOV_LANG_CD

486: ) AS
487: cursor c1 is select
488: DESCRIPTION,
489: CLOSED_IND
490: from IGS_PE_GOV_LANG_CD
491: where ROWID = X_ROWID
492: for update nowait;
493: tlinfo c1%rowtype;
494:

Line 572: update IGS_PE_GOV_LANG_CD set

568:
569: x_last_update_login=>X_LAST_UPDATE_LOGIN
570:
571: );
572: update IGS_PE_GOV_LANG_CD set
573: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
574: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
575: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
576: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 600: cursor c1 is select rowid from IGS_PE_GOV_LANG_CD

596: X_DESCRIPTION in VARCHAR2,
597: X_CLOSED_IND in VARCHAR2,
598: X_MODE in VARCHAR2 default 'R'
599: ) AS
600: cursor c1 is select rowid from IGS_PE_GOV_LANG_CD
601: where GOVT_LANGUAGE_CD = X_GOVT_LANGUAGE_CD
602: ;
603:
604: begin

Line 639: delete from IGS_PE_GOV_LANG_CD

635:
636: x_rowid => X_ROWID
637:
638: );
639: delete from IGS_PE_GOV_LANG_CD
640: where ROWID = X_ROWID;
641: if (sql%notfound) then
642: raise no_data_found;
643: end if;

Line 656: end IGS_PE_GOV_LANG_CD_PKG;

652:
653:
654: end DELETE_ROW;
655:
656: end IGS_PE_GOV_LANG_CD_PKG;