APPS.IGS_OR_INSTITUTION_PKG dependencies on IGS_OR_INSTITUTION

Line 1: PACKAGE BODY Igs_Or_Institution_Pkg AS

1: PACKAGE BODY Igs_Or_Institution_Pkg AS
2: /* $Header: IGSOI02B.pls 115.8 2002/10/28 03:13:46 pkpatel ship $ */
3: /*************************************************************
4: Changed By : smanglm
5: Date : 2000/08/25

Line 27: FROM IGS_OR_INSTITUTION

23: )
24: RETURN BOOLEAN AS
25: CURSOR cur_rowid IS
26: SELECT ROW_ID
27: FROM IGS_OR_INSTITUTION
28: WHERE institution_cd = x_institution_cd;
29: lv_rowid cur_rowid%ROWTYPE;
30: BEGIN
31: OPEN cur_rowid;

Line 47: FROM IGS_OR_INSTITUTION

43: x_govt_institution_cd IN VARCHAR2
44: ) AS
45: CURSOR cur_rowid IS
46: SELECT ROW_ID
47: FROM IGS_OR_INSTITUTION
48: WHERE GOVT_INSTITUTION_CD = x_govt_institution_cd ;
49: lv_rowid cur_rowid%ROWTYPE;
50: BEGIN
51: OPEN cur_rowid;

Line 68: FROM IGS_OR_INSTITUTION

64: x_institution_status IN VARCHAR2
65: ) AS
66: CURSOR cur_rowid IS
67: SELECT ROW_ID
68: FROM IGS_OR_INSTITUTION
69: WHERE institution_status = x_institution_status ;
70: lv_rowid cur_rowid%ROWTYPE;
71: BEGIN
72: OPEN cur_rowid;

Line 104: FROM igs_or_institution

100: ***************************************************************/
101:
102: CURSOR cur_rowid IS
103: SELECT ROW_ID
104: FROM igs_or_institution
105: WHERE institution_type = x_institution_type ;
106:
107: lv_rowid cur_rowid%ROWTYPE;
108:

Line 144: FROM igs_or_institution

140: ***************************************************************/
141:
142: CURSOR cur_rowid IS
143: SELECT ROW_ID
144: FROM igs_or_institution
145: WHERE inst_control_type = x_inst_control_type ;
146:
147: lv_rowid cur_rowid%ROWTYPE;
148:

Line 164: END Igs_Or_Institution_Pkg;

160: CLOSE cur_rowid;
161:
162: END Get_FK_Igs_Or_Org_In_Ctltyp;
163:
164: END Igs_Or_Institution_Pkg;