APPS.IGS_PE_COUNTRY_CD_PKG dependencies on IGS_PE_COUNTRY_CD

Line 1: package body IGS_PE_COUNTRY_CD_PKG as

1: package body IGS_PE_COUNTRY_CD_PKG as
2: /* $Header: IGSNI04B.pls 115.4 2002/12/05 10:36:06 kpadiyar ship $ */
3:
4:
5: l_rowid VARCHAR2(25);

Line 7: old_references IGS_PE_COUNTRY_CD%RowType;

3:
4:
5: l_rowid VARCHAR2(25);
6:
7: old_references IGS_PE_COUNTRY_CD%RowType;
8:
9: new_references IGS_PE_COUNTRY_CD%RowType;
10:
11:

Line 9: new_references IGS_PE_COUNTRY_CD%RowType;

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

Line 47: FROM IGS_PE_COUNTRY_CD

43: CURSOR cur_old_ref_values IS
44:
45: SELECT *
46:
47: FROM IGS_PE_COUNTRY_CD
48:
49: WHERE rowid = x_rowid;
50:
51:

Line 129: -- ON IGS_PE_COUNTRY_CD

125: -- "OSS_TST".trg_cnc_br_iud
126:
127: -- BEFORE INSERT OR DELETE OR UPDATE
128:
129: -- ON IGS_PE_COUNTRY_CD
130:
131: -- FOR EACH ROW
132:
133:

Line 269: IGS_AD_OS_SEC_EDU_PKG.GET_FK_IGS_PE_COUNTRY_CD (

265: PROCEDURE Check_Child_Existance as
266:
267: BEGIN
268:
269: IGS_AD_OS_SEC_EDU_PKG.GET_FK_IGS_PE_COUNTRY_CD (
270:
271: old_references.COUNTRY_CD
272:
273: );

Line 277: IGS_AD_OS_SEC_EDU_QF_PKG.GET_FK_IGS_PE_COUNTRY_CD (

273: );
274:
275:
276:
277: IGS_AD_OS_SEC_EDU_QF_PKG.GET_FK_IGS_PE_COUNTRY_CD (
278:
279: old_references.COUNTRY_CD
280:
281: );

Line 285: IGS_AD_TER_EDU_PKG.GET_FK_IGS_PE_COUNTRY_CD (

281: );
282:
283:
284:
285: IGS_AD_TER_EDU_PKG.GET_FK_IGS_PE_COUNTRY_CD (
286:
287: old_references.COUNTRY_CD
288:
289: );

Line 310: FROM IGS_PE_COUNTRY_CD

306: CURSOR cur_rowid IS
307:
308: SELECT rowid
309:
310: FROM IGS_PE_COUNTRY_CD
311:
312: WHERE COUNTRY_CD= x_country_cd
313:
314: FOR UPDATE NOWAIT;

Line 346: FROM IGS_PE_COUNTRY_CD

342: CURSOR cur_rowid IS
343:
344: SELECT rowid
345:
346: FROM IGS_PE_COUNTRY_CD
347:
348: WHERE GOVT_COUNTRY_CD= x_govt_country_cd ;
349:
350:

Line 540: cursor C is select ROWID from IGS_PE_COUNTRY_CD

536: X_CLOSED_IND in VARCHAR2,
537: X_NOTES in VARCHAR2,
538: X_MODE in VARCHAR2 default 'R'
539: ) as
540: cursor C is select ROWID from IGS_PE_COUNTRY_CD
541: where COUNTRY_CD = X_COUNTRY_CD;
542: X_LAST_UPDATE_DATE DATE;
543: X_LAST_UPDATED_BY NUMBER;
544: X_LAST_UPDATE_LOGIN NUMBER;

Line 592: insert into IGS_PE_COUNTRY_CD (

588:
589: x_last_update_login=>X_LAST_UPDATE_LOGIN
590:
591: );
592: insert into IGS_PE_COUNTRY_CD (
593: COUNTRY_CD,
594: GOVT_COUNTRY_CD,
595: DESCRIPTION,
596: CLOSED_IND,

Line 648: from IGS_PE_COUNTRY_CD

644: GOVT_COUNTRY_CD,
645: DESCRIPTION,
646: CLOSED_IND,
647: NOTES
648: from IGS_PE_COUNTRY_CD
649: where ROWID = X_ROWID
650: for update nowait;
651: tlinfo c1%rowtype;
652:

Line 742: update IGS_PE_COUNTRY_CD set

738:
739: );
740:
741:
742: update IGS_PE_COUNTRY_CD set
743: GOVT_COUNTRY_CD = NEW_REFERENCES.GOVT_COUNTRY_CD,
744: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
745: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
746: NOTES = NEW_REFERENCES.NOTES,

Line 778: cursor c1 is select rowid from IGS_PE_COUNTRY_CD

774: X_CLOSED_IND in VARCHAR2,
775: X_NOTES in VARCHAR2,
776: X_MODE in VARCHAR2 default 'R'
777: ) as
778: cursor c1 is select rowid from IGS_PE_COUNTRY_CD
779: where COUNTRY_CD = X_COUNTRY_CD
780: ;
781:
782: begin

Line 823: delete from IGS_PE_COUNTRY_CD

819:
820: );
821:
822:
823: delete from IGS_PE_COUNTRY_CD
824: where ROWID = X_ROWID;
825: if (sql%notfound) then
826: raise no_data_found;
827: end if;

Line 843: end IGS_PE_COUNTRY_CD_PKG;

839:
840:
841: end DELETE_ROW;
842:
843: end IGS_PE_COUNTRY_CD_PKG;