APPS.IGS_PE_GOVCITIZEN_CD_PKG dependencies on IGS_PE_GOVCITIZEN_CD

Line 1: package body IGS_PE_GOVCITIZEN_CD_PKG AS

1: package body IGS_PE_GOVCITIZEN_CD_PKG AS
2: /* $Header: IGSNI06B.pls 115.3 2002/11/29 01:15:08 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5:

Line 6: old_references IGS_PE_GOVCITIZEN_CD%RowType;

2: /* $Header: IGSNI06B.pls 115.3 2002/11/29 01:15:08 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5:
6: old_references IGS_PE_GOVCITIZEN_CD%RowType;
7:
8: new_references IGS_PE_GOVCITIZEN_CD%RowType;
9:
10:

Line 8: new_references IGS_PE_GOVCITIZEN_CD%RowType;

4: l_rowid VARCHAR2(25);
5:
6: old_references IGS_PE_GOVCITIZEN_CD%RowType;
7:
8: new_references IGS_PE_GOVCITIZEN_CD%RowType;
9:
10:
11:
12: PROCEDURE Set_Column_Values (

Line 42: FROM IGS_PE_GOVCITIZEN_CD

38: CURSOR cur_old_ref_values IS
39:
40: SELECT *
41:
42: FROM IGS_PE_GOVCITIZEN_CD
43:
44: WHERE rowid = x_rowid;
45:
46:

Line 198: IGS_ST_CITIZENSHP_CD_PKG.GET_FK_IGS_PE_GOVCITIZEN_CD (

194:
195: PROCEDURE Check_Child_Existance AS
196:
197: BEGIN
198: IGS_ST_CITIZENSHP_CD_PKG.GET_FK_IGS_PE_GOVCITIZEN_CD (
199:
200: old_references.govt_citizenship_cd
201:
202: );

Line 216: FROM IGS_PE_GOVCITIZEN_CD

212: CURSOR cur_rowid IS
213:
214: SELECT rowid
215:
216: FROM IGS_PE_GOVCITIZEN_CD
217:
218: WHERE govt_citizenship_cd = x_govt_citizenship_cd
219:
220: FOR UPDATE NOWAIT;

Line 393: cursor C is select ROWID from IGS_PE_GOVCITIZEN_CD

389: X_DESCRIPTION in VARCHAR2,
390: X_CLOSED_IND in VARCHAR2,
391: X_MODE in VARCHAR2 default 'R'
392: ) AS
393: cursor C is select ROWID from IGS_PE_GOVCITIZEN_CD
394: where GOVT_CITIZENSHIP_CD = X_GOVT_CITIZENSHIP_CD;
395: X_LAST_UPDATE_DATE DATE;
396: X_LAST_UPDATED_BY NUMBER;
397: X_LAST_UPDATE_LOGIN NUMBER;

Line 443: insert into IGS_PE_GOVCITIZEN_CD (

439:
440: );
441:
442:
443: insert into IGS_PE_GOVCITIZEN_CD (
444: GOVT_CITIZENSHIP_CD,
445: DESCRIPTION,
446: CLOSED_IND,
447: CREATION_DATE,

Line 489: from IGS_PE_GOVCITIZEN_CD

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

Line 571: update IGS_PE_GOVCITIZEN_CD set

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

Line 601: cursor c1 is select rowid from IGS_PE_GOVCITIZEN_CD

597: X_DESCRIPTION in VARCHAR2,
598: X_CLOSED_IND in VARCHAR2,
599: X_MODE in VARCHAR2 default 'R'
600: ) AS
601: cursor c1 is select rowid from IGS_PE_GOVCITIZEN_CD
602: where GOVT_CITIZENSHIP_CD = X_GOVT_CITIZENSHIP_CD
603: ;
604:
605: begin

Line 640: delete from IGS_PE_GOVCITIZEN_CD

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

Line 659: end IGS_PE_GOVCITIZEN_CD_PKG;

655:
656:
657: end DELETE_ROW;
658:
659: end IGS_PE_GOVCITIZEN_CD_PKG;