APPS.IGS_LOOKUPS_VIEW_PKG dependencies on IGS_LOOKUPS_VIEW

Line 1: package body IGS_LOOKUPS_VIEW_PKG as

1: package body IGS_LOOKUPS_VIEW_PKG as
2: /* $Header: IGSMI14B.pls 115.13 2003/05/30 10:45:27 ptandon ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_LOOKUPS_view%RowType;

Line 5: old_references IGS_LOOKUPS_view%RowType;

1: package body IGS_LOOKUPS_VIEW_PKG as
2: /* $Header: IGSMI14B.pls 115.13 2003/05/30 10:45:27 ptandon ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_LOOKUPS_view%RowType;
6:
7: new_references IGS_LOOKUPS_view%RowType;
8: /* new_references_language IGS_LOOKUPS.LANGUAGE%TYPE;
9:

Line 7: new_references IGS_LOOKUPS_view%RowType;

3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_LOOKUPS_view%RowType;
6:
7: new_references IGS_LOOKUPS_view%RowType;
8: /* new_references_language IGS_LOOKUPS.LANGUAGE%TYPE;
9:
10:
11: PROCEDURE Set_Column_Values (

Line 109: smvk 27-Aug-2002 Removed the calls GET_FK_IGS_LOOKUPS_VIEW_ALLOCA and GET_FK_IGS_LOOKUPS_VIEW_DISBUR

105: PROCEDURE Check_Child_Existance AS
106: /*
107: History
108: who when what
109: smvk 27-Aug-2002 Removed the calls GET_FK_IGS_LOOKUPS_VIEW_ALLOCA and GET_FK_IGS_LOOKUPS_VIEW_DISBUR
110: to the Package IGS_FI_FEE_DSBR_FML_PKG as the package is obsolete.
111: They are associated to lookup_types 'DISBURSEMENT_METHOD' and 'ALLOCATION_METHOD'
112: This is as per SFCR005_Cleanup_Build (Enhancement Bug # 2531390).
113: */

Line 118: -- IGS_PE_PERSON_PKG.GET_FK_IGS_LOOKUPS_VIEW(

114: BEGIN
115:
116:
117: -- IF old_references.LOOKUP_TYPE = 'SEX' THEN
118: -- IGS_PE_PERSON_PKG.GET_FK_IGS_LOOKUPS_VIEW(
119: -- old_references.LOOKUP_CODE
120: -- );
121: -- END IF;
122:

Line 126: IGS_AD_INTAK_TRG_TYP_PKG.GET_FK_IGS_LOOKUPS_VIEW2(

122:
123:
124: IF old_references.LOOKUP_TYPE = 'AMOUNT_TYPE' THEN
125:
126: IGS_AD_INTAK_TRG_TYP_PKG.GET_FK_IGS_LOOKUPS_VIEW2(
127: old_references.LOOKUP_CODE
128: );
129:
130: IGS_AD_SBMINTAK_TRGT_PKG.GET_FK_IGS_LOOKUPS_VIEW(

Line 130: IGS_AD_SBMINTAK_TRGT_PKG.GET_FK_IGS_LOOKUPS_VIEW(

126: IGS_AD_INTAK_TRG_TYP_PKG.GET_FK_IGS_LOOKUPS_VIEW2(
127: old_references.LOOKUP_CODE
128: );
129:
130: IGS_AD_SBMINTAK_TRGT_PKG.GET_FK_IGS_LOOKUPS_VIEW(
131: old_references.LOOKUP_CODE
132: );
133:
134: IGS_AD_SBMPS_FN_ITTT_PKG.GET_FK_IGS_LOOKUPS_VIEW(

Line 134: IGS_AD_SBMPS_FN_ITTT_PKG.GET_FK_IGS_LOOKUPS_VIEW(

130: IGS_AD_SBMINTAK_TRGT_PKG.GET_FK_IGS_LOOKUPS_VIEW(
131: old_references.LOOKUP_CODE
132: );
133:
134: IGS_AD_SBMPS_FN_ITTT_PKG.GET_FK_IGS_LOOKUPS_VIEW(
135: old_references.LOOKUP_CODE
136: );
137:
138: IGS_AD_SBMAO_FN_UITT_PKG.GET_FK_IGS_LOOKUPS_VIEW(

Line 138: IGS_AD_SBMAO_FN_UITT_PKG.GET_FK_IGS_LOOKUPS_VIEW(

134: IGS_AD_SBMPS_FN_ITTT_PKG.GET_FK_IGS_LOOKUPS_VIEW(
135: old_references.LOOKUP_CODE
136: );
137:
138: IGS_AD_SBMAO_FN_UITT_PKG.GET_FK_IGS_LOOKUPS_VIEW(
139: old_references.LOOKUP_CODE
140: );
141:
142: IGS_AD_SBMAO_FN_CTTT_PKG.GET_FK_IGS_LOOKUPS_VIEW(

Line 142: IGS_AD_SBMAO_FN_CTTT_PKG.GET_FK_IGS_LOOKUPS_VIEW(

138: IGS_AD_SBMAO_FN_UITT_PKG.GET_FK_IGS_LOOKUPS_VIEW(
139: old_references.LOOKUP_CODE
140: );
141:
142: IGS_AD_SBMAO_FN_CTTT_PKG.GET_FK_IGS_LOOKUPS_VIEW(
143: old_references.LOOKUP_CODE
144: );
145:
146: IGS_AD_SBMAO_FN_AMTT_PKG.GET_FK_IGS_LOOKUPS_VIEW(

Line 146: IGS_AD_SBMAO_FN_AMTT_PKG.GET_FK_IGS_LOOKUPS_VIEW(

142: IGS_AD_SBMAO_FN_CTTT_PKG.GET_FK_IGS_LOOKUPS_VIEW(
143: old_references.LOOKUP_CODE
144: );
145:
146: IGS_AD_SBMAO_FN_AMTT_PKG.GET_FK_IGS_LOOKUPS_VIEW(
147: old_references.LOOKUP_CODE
148: );
149:
150: IGS_AD_SBM_AOU_FNDTT_PKG.GET_FK_IGS_LOOKUPS_VIEW(

Line 150: IGS_AD_SBM_AOU_FNDTT_PKG.GET_FK_IGS_LOOKUPS_VIEW(

146: IGS_AD_SBMAO_FN_AMTT_PKG.GET_FK_IGS_LOOKUPS_VIEW(
147: old_references.LOOKUP_CODE
148: );
149:
150: IGS_AD_SBM_AOU_FNDTT_PKG.GET_FK_IGS_LOOKUPS_VIEW(
151: old_references.LOOKUP_CODE
152: );
153:
154: END IF;

Line 157: IGS_AD_PECRS_OFOP_DT_PKG.GET_FK_IGS_LOOKUPS_VIEW(

153:
154: END IF;
155:
156: IF old_references.LOOKUP_TYPE = 'ADMISSION_PROCESS_TYPE' then
157: IGS_AD_PECRS_OFOP_DT_PKG.GET_FK_IGS_LOOKUPS_VIEW(
158: old_references.LOOKUP_CODE
159: );
160: end if;
161:

Line 163: IGS_AD_PRCS_CAT_PKG.GET_FK_IGS_LOOKUPS_VIEW(

159: );
160: end if;
161:
162: IF old_references.LOOKUP_TYPE = 'ADMISSION_PROCESS_TYPE' then
163: IGS_AD_PRCS_CAT_PKG.GET_FK_IGS_LOOKUPS_VIEW(
164: old_references.LOOKUP_CODE
165: );
166: end if;
167: IF old_references.LOOKUP_TYPE = 'ADMISSION_STEP_TYPE' then

Line 168: IGS_AD_PRCS_CAT_STEP_PKG.GET_FK_IGS_LOOKUPS_VIEW(

164: old_references.LOOKUP_CODE
165: );
166: end if;
167: IF old_references.LOOKUP_TYPE = 'ADMISSION_STEP_TYPE' then
168: IGS_AD_PRCS_CAT_STEP_PKG.GET_FK_IGS_LOOKUPS_VIEW(
169: old_references.LOOKUP_CODE
170: );
171: end if;
172: IF old_references.LOOKUP_TYPE = 'ADM_APPL_STATUS' then

Line 173: IGS_AD_APPL_STAT_PKG.GET_FK_IGS_LOOKUPS_VIEW(

169: old_references.LOOKUP_CODE
170: );
171: end if;
172: IF old_references.LOOKUP_TYPE = 'ADM_APPL_STATUS' then
173: IGS_AD_APPL_STAT_PKG.GET_FK_IGS_LOOKUPS_VIEW(
174: old_references.LOOKUP_CODE
175: );
176: end if;
177: IF old_references.LOOKUP_TYPE = 'ADM_CNDTNL_OFFER_STATUS' then

Line 178: IGS_AD_CNDNL_OFRSTAT_PKG.GET_FK_IGS_LOOKUPS_VIEW(

174: old_references.LOOKUP_CODE
175: );
176: end if;
177: IF old_references.LOOKUP_TYPE = 'ADM_CNDTNL_OFFER_STATUS' then
178: IGS_AD_CNDNL_OFRSTAT_PKG.GET_FK_IGS_LOOKUPS_VIEW(
179: old_references.LOOKUP_CODE
180: );
181: end if;
182: IF old_references.LOOKUP_TYPE = 'ADM_DOC_STATUS' then

Line 183: IGS_AD_DOC_STAT_PKG.GET_FK_IGS_LOOKUPS_VIEW(

179: old_references.LOOKUP_CODE
180: );
181: end if;
182: IF old_references.LOOKUP_TYPE = 'ADM_DOC_STATUS' then
183: IGS_AD_DOC_STAT_PKG.GET_FK_IGS_LOOKUPS_VIEW(
184: old_references.LOOKUP_CODE
185: );
186: end if;
187: IF old_references.LOOKUP_TYPE = 'ADM_ENTRY_QUAL_STATUS' then

Line 188: IGS_AD_ENT_QF_STAT_PKG.GET_FK_IGS_LOOKUPS_VIEW(

184: old_references.LOOKUP_CODE
185: );
186: end if;
187: IF old_references.LOOKUP_TYPE = 'ADM_ENTRY_QUAL_STATUS' then
188: IGS_AD_ENT_QF_STAT_PKG.GET_FK_IGS_LOOKUPS_VIEW(
189: old_references.LOOKUP_CODE
190: );
191: end if;
192: IF old_references.LOOKUP_TYPE = 'ADM_FEE_STATUS' then

Line 193: IGS_AD_FEE_STAT_PKG.GET_FK_IGS_LOOKUPS_VIEW(

189: old_references.LOOKUP_CODE
190: );
191: end if;
192: IF old_references.LOOKUP_TYPE = 'ADM_FEE_STATUS' then
193: IGS_AD_FEE_STAT_PKG.GET_FK_IGS_LOOKUPS_VIEW(
194: old_references.LOOKUP_CODE
195: );
196: end if;
197: IF old_references.LOOKUP_TYPE = 'ADM_OFFER_DFRMNT_STATUS' then

Line 198: IGS_AD_OFRDFRMT_STAT_PKG.GET_FK_IGS_LOOKUPS_VIEW(

194: old_references.LOOKUP_CODE
195: );
196: end if;
197: IF old_references.LOOKUP_TYPE = 'ADM_OFFER_DFRMNT_STATUS' then
198: IGS_AD_OFRDFRMT_STAT_PKG.GET_FK_IGS_LOOKUPS_VIEW(
199: old_references.LOOKUP_CODE
200: );
201: end if;
202: IF old_references.LOOKUP_TYPE = 'ADM_OFFER_RESP_STATUS' then

Line 203: IGS_AD_OFR_RESP_STAT_PKG.GET_FK_IGS_LOOKUPS_VIEW(

199: old_references.LOOKUP_CODE
200: );
201: end if;
202: IF old_references.LOOKUP_TYPE = 'ADM_OFFER_RESP_STATUS' then
203: IGS_AD_OFR_RESP_STAT_PKG.GET_FK_IGS_LOOKUPS_VIEW(
204: old_references.LOOKUP_CODE
205: );
206: end if;
207: IF old_references.LOOKUP_TYPE = 'ADM_OUTCOME_STATUS' then

Line 208: IGS_AD_OU_STAT_PKG.GET_FK_IGS_LOOKUPS_VIEW(

204: old_references.LOOKUP_CODE
205: );
206: end if;
207: IF old_references.LOOKUP_TYPE = 'ADM_OUTCOME_STATUS' then
208: IGS_AD_OU_STAT_PKG.GET_FK_IGS_LOOKUPS_VIEW(
209: old_references.LOOKUP_CODE
210: );
211: end if;
212: IF old_references.LOOKUP_TYPE = 'ADM_OUTCOME_STATUS' then

Line 213: IGS_AD_UNIT_OU_STAT_PKG.GET_FK_IGS_LOOKUPS_VIEW(

209: old_references.LOOKUP_CODE
210: );
211: end if;
212: IF old_references.LOOKUP_TYPE = 'ADM_OUTCOME_STATUS' then
213: IGS_AD_UNIT_OU_STAT_PKG.GET_FK_IGS_LOOKUPS_VIEW(
214: old_references.LOOKUP_CODE
215: );
216: end if;
217:

Line 219: IGS_AV_STND_UNIT_LVL_PKG.GET_FK_IGS_LOOKUPS_VIEW(

215: );
216: end if;
217:
218: IF old_references.LOOKUP_TYPE = 'ADV_STND_GRANTING_STATUS' then
219: IGS_AV_STND_UNIT_LVL_PKG.GET_FK_IGS_LOOKUPS_VIEW(
220: old_references.LOOKUP_CODE
221: );
222: end if;
223: IF old_references.LOOKUP_TYPE = 'ADV_STND_GRANTING_STATUS' then

Line 224: IGS_AV_STND_UNIT_PKG.GET_FK_IGS_LOOKUPS_VIEW_1(

220: old_references.LOOKUP_CODE
221: );
222: end if;
223: IF old_references.LOOKUP_TYPE = 'ADV_STND_GRANTING_STATUS' then
224: IGS_AV_STND_UNIT_PKG.GET_FK_IGS_LOOKUPS_VIEW_1(
225: old_references.LOOKUP_CODE
226: );
227: end if;
228: IF old_references.LOOKUP_TYPE = 'ADV_STND_RECOGNITION_TYPE' then

Line 229: IGS_AV_STND_UNIT_PKG.GET_FK_IGS_LOOKUPS_VIEW_2(

225: old_references.LOOKUP_CODE
226: );
227: end if;
228: IF old_references.LOOKUP_TYPE = 'ADV_STND_RECOGNITION_TYPE' then
229: IGS_AV_STND_UNIT_PKG.GET_FK_IGS_LOOKUPS_VIEW_2(
230: old_references.LOOKUP_CODE
231: );
232: end if;
233:

Line 235: IGS_CA_TYPE_PKG.GET_FK_IGS_LOOKUPS_VIEW(

231: );
232: end if;
233:
234: IF old_references.LOOKUP_TYPE = 'CAL_CAT' then
235: IGS_CA_TYPE_PKG.GET_FK_IGS_LOOKUPS_VIEW(
236: old_references.LOOKUP_CODE
237: );
238: end if;
239: IF old_references.LOOKUP_TYPE = 'CAL_CAT' then

Line 240: IGS_CA_DA_PKG.GET_FK_IGS_LOOKUPS_VIEW(

236: old_references.LOOKUP_CODE
237: );
238: end if;
239: IF old_references.LOOKUP_TYPE = 'CAL_CAT' then
240: IGS_CA_DA_PKG.GET_FK_IGS_LOOKUPS_VIEW(
241: old_references.LOOKUP_CODE
242: );
243: end if;
244:

Line 246: IGS_CA_STAT_PKG.GET_FK_IGS_LOOKUPS_VIEW(

242: );
243: end if;
244:
245: IF old_references.LOOKUP_TYPE = 'CALENDAR_STATUS' then
246: IGS_CA_STAT_PKG.GET_FK_IGS_LOOKUPS_VIEW(
247: old_references.LOOKUP_CODE
248: );
249: end if;
250:

Line 252: IGS_FI_EL_RNG_PKG.GET_FK_IGS_LOOKUPS_VIEW(

248: );
249: end if;
250:
251: IF old_references.LOOKUP_TYPE = 'CHG_METHOD' then
252: IGS_FI_EL_RNG_PKG.GET_FK_IGS_LOOKUPS_VIEW(
253: old_references.LOOKUP_CODE
254: );
255: end if;
256: IF old_references.LOOKUP_TYPE = 'CHG_METHOD' then

Line 257: IGS_FI_F_CAT_FEE_LBL_PKG.GET_FK_IGS_LOOKUPS_VIEW(

253: old_references.LOOKUP_CODE
254: );
255: end if;
256: IF old_references.LOOKUP_TYPE = 'CHG_METHOD' then
257: IGS_FI_F_CAT_FEE_LBL_PKG.GET_FK_IGS_LOOKUPS_VIEW(
258: old_references.LOOKUP_CODE
259: );
260: end if;
261: IF old_references.LOOKUP_TYPE = 'CHG_METHOD' then

Line 262: IGS_FI_F_TYP_CA_INST_PKG.GET_FK_IGS_LOOKUPS_VIEW(

258: old_references.LOOKUP_CODE
259: );
260: end if;
261: IF old_references.LOOKUP_TYPE = 'CHG_METHOD' then
262: IGS_FI_F_TYP_CA_INST_PKG.GET_FK_IGS_LOOKUPS_VIEW(
263: old_references.LOOKUP_CODE
264: );
265: end if;
266: IF old_references.LOOKUP_TYPE = 'COURSE_GROUP_TYPE' then

Line 267: IGS_PS_GRP_TYPE_PKG.GET_FK_IGS_LOOKUPS_VIEW(

263: old_references.LOOKUP_CODE
264: );
265: end if;
266: IF old_references.LOOKUP_TYPE = 'COURSE_GROUP_TYPE' then
267: IGS_PS_GRP_TYPE_PKG.GET_FK_IGS_LOOKUPS_VIEW(
268: old_references.LOOKUP_CODE
269: );
270: end if;
271: IF old_references.LOOKUP_TYPE = 'CRS_ATTEMPT_STATUS' then

Line 272: IGS_EN_STDNT_PS_ATT_PKG.GET_FK_IGS_LOOKUPS_VIEW_CAS(

268: old_references.LOOKUP_CODE
269: );
270: end if;
271: IF old_references.LOOKUP_TYPE = 'CRS_ATTEMPT_STATUS' then
272: IGS_EN_STDNT_PS_ATT_PKG.GET_FK_IGS_LOOKUPS_VIEW_CAS(
273: old_references.LOOKUP_CODE
274: );
275: end if;
276: IF old_references.LOOKUP_TYPE = 'DISCONTINUATION_REASON_TYPE' then

Line 277: IGS_EN_DCNT_REASONCD_PKG.GET_FK_IGS_LOOKUPS_VIEW(

273: old_references.LOOKUP_CODE
274: );
275: end if;
276: IF old_references.LOOKUP_TYPE = 'DISCONTINUATION_REASON_TYPE' then
277: IGS_EN_DCNT_REASONCD_PKG.GET_FK_IGS_LOOKUPS_VIEW(
278: old_references.LOOKUP_CODE
279: );
280: end if;
281: IF old_references.LOOKUP_TYPE = 'DT_OFFSET_CONSTRAINT_TYPE' then

Line 282: IGS_CA_DA_INST_OFCNT_PKG.GET_FK_IGS_LOOKUPS_VIEW(

278: old_references.LOOKUP_CODE
279: );
280: end if;
281: IF old_references.LOOKUP_TYPE = 'DT_OFFSET_CONSTRAINT_TYPE' then
282: IGS_CA_DA_INST_OFCNT_PKG.GET_FK_IGS_LOOKUPS_VIEW(
283: old_references.LOOKUP_CODE
284: );
285: end if;
286: IF old_references.LOOKUP_TYPE = 'DT_OFFSET_CONSTRAINT_TYPE' then

Line 287: IGS_CA_DA_OFFCNT_PKG.GET_FK_IGS_LOOKUPS_VIEW(

283: old_references.LOOKUP_CODE
284: );
285: end if;
286: IF old_references.LOOKUP_TYPE = 'DT_OFFSET_CONSTRAINT_TYPE' then
287: IGS_CA_DA_OFFCNT_PKG.GET_FK_IGS_LOOKUPS_VIEW(
288: old_references.LOOKUP_CODE
289: );
290: end if;
291: IF old_references.LOOKUP_TYPE = 'ENROLMENT_STEP_TYPE' then

Line 292: IGS_EN_CAT_PRC_STEP_PKG.GET_FK_IGS_LOOKUPS_VIEW(

288: old_references.LOOKUP_CODE
289: );
290: end if;
291: IF old_references.LOOKUP_TYPE = 'ENROLMENT_STEP_TYPE' then
292: IGS_EN_CAT_PRC_STEP_PKG.GET_FK_IGS_LOOKUPS_VIEW(
293: old_references.LOOKUP_CODE
294: );
295: end if;
296: IF old_references.LOOKUP_TYPE = 'ENR_NOTE_TYPE' then

Line 297: IGS_EN_NOTE_TYPE_PKG.GET_FK_IGS_LOOKUPS_VIEW(

293: old_references.LOOKUP_CODE
294: );
295: end if;
296: IF old_references.LOOKUP_TYPE = 'ENR_NOTE_TYPE' then
297: IGS_EN_NOTE_TYPE_PKG.GET_FK_IGS_LOOKUPS_VIEW(
298: old_references.LOOKUP_CODE
299: );
300: end if;
301: IF old_references.LOOKUP_TYPE = 'GRADE_CREATION_METHOD_TYPE' then

Line 302: IGS_AS_NON_ENR_STDOT_PKG.GET_FK_IGS_LOOKUPS_VIEW(

298: old_references.LOOKUP_CODE
299: );
300: end if;
301: IF old_references.LOOKUP_TYPE = 'GRADE_CREATION_METHOD_TYPE' then
302: IGS_AS_NON_ENR_STDOT_PKG.GET_FK_IGS_LOOKUPS_VIEW(
303: old_references.LOOKUP_CODE
304: );
305: end if;
306: IF old_references.LOOKUP_TYPE = 'GRADE_CREATION_METHOD_TYPE' then

Line 307: IGS_AS_SU_STMPTOUT_PKG.GET_FK_IGS_LOOKUPS_VIEW(

303: old_references.LOOKUP_CODE
304: );
305: end if;
306: IF old_references.LOOKUP_TYPE = 'GRADE_CREATION_METHOD_TYPE' then
307: IGS_AS_SU_STMPTOUT_PKG.GET_FK_IGS_LOOKUPS_VIEW(
308: old_references.LOOKUP_CODE
309: );
310: end if;
311: IF old_references.LOOKUP_TYPE = 'HECS_PAYMENT_TYPE' then

Line 312: IGS_FI_GOV_HEC_PA_OP_PKG.GET_FK_IGS_LOOKUPS_VIEW(

308: old_references.LOOKUP_CODE
309: );
310: end if;
311: IF old_references.LOOKUP_TYPE = 'HECS_PAYMENT_TYPE' then
312: IGS_FI_GOV_HEC_PA_OP_PKG.GET_FK_IGS_LOOKUPS_VIEW(
313: old_references.LOOKUP_CODE
314: );
315: end if;
316: IF old_references.LOOKUP_TYPE = 'INTAKE_TARGET_TYPE' then

Line 317: IGS_AD_INTAK_TRG_TYP_PKG.GET_FK_IGS_LOOKUPS_VIEW(

313: old_references.LOOKUP_CODE
314: );
315: end if;
316: IF old_references.LOOKUP_TYPE = 'INTAKE_TARGET_TYPE' then
317: IGS_AD_INTAK_TRG_TYP_PKG.GET_FK_IGS_LOOKUPS_VIEW(
318: old_references.LOOKUP_CODE
319: );
320: end if;
321: IF old_references.LOOKUP_TYPE = 'LOCATION_TYPE' then

Line 322: IGS_AD_LOCATION_TYPE_PKG.GET_FK_IGS_LOOKUPS_VIEW(

318: old_references.LOOKUP_CODE
319: );
320: end if;
321: IF old_references.LOOKUP_TYPE = 'LOCATION_TYPE' then
322: IGS_AD_LOCATION_TYPE_PKG.GET_FK_IGS_LOOKUPS_VIEW(
323: old_references.LOOKUP_CODE
324: );
325: end if;
326: IF old_references.LOOKUP_TYPE = 'MILESTONE_STATUS' then

Line 327: IGS_PR_MS_STAT_PKG.GET_FK_IGS_LOOKUPS_VIEW(

323: old_references.LOOKUP_CODE
324: );
325: end if;
326: IF old_references.LOOKUP_TYPE = 'MILESTONE_STATUS' then
327: IGS_PR_MS_STAT_PKG.GET_FK_IGS_LOOKUPS_VIEW(
328: old_references.LOOKUP_CODE
329: );
330: end if;
331: IF old_references.LOOKUP_TYPE = 'NOTE_FORMAT_TYPE' then

Line 332: IGS_GE_NOTE_PKG.GET_FK_IGS_LOOKUPS_VIEW(

328: old_references.LOOKUP_CODE
329: );
330: end if;
331: IF old_references.LOOKUP_TYPE = 'NOTE_FORMAT_TYPE' then
332: IGS_GE_NOTE_PKG.GET_FK_IGS_LOOKUPS_VIEW(
333: old_references.LOOKUP_CODE
334: );
335: end if;
336: /*IF old_references.LOOKUP_TYPE = 'LETTER_OBJECT' then

Line 337: IGS_CO_S_LTR_PKG.GET_FK_IGS_LOOKUPS_VIEW_LETOBJ(

333: old_references.LOOKUP_CODE
334: );
335: end if;
336: /*IF old_references.LOOKUP_TYPE = 'LETTER_OBJECT' then
337: IGS_CO_S_LTR_PKG.GET_FK_IGS_LOOKUPS_VIEW_LETOBJ(
338: old_references.LOOKUP_CODE
339: );
340: end if ;
341: IF old_references.LOOKUP_TYPE = 'LETTER_REFERENCE_TYPE' then

Line 342: IGS_CO_S_LTR_PKG.GET_FK_IGS_LOOKUPS_VIEW_LETREF(

338: old_references.LOOKUP_CODE
339: );
340: end if ;
341: IF old_references.LOOKUP_TYPE = 'LETTER_REFERENCE_TYPE' then
342: IGS_CO_S_LTR_PKG.GET_FK_IGS_LOOKUPS_VIEW_LETREF(
343: old_references.LOOKUP_CODE
344: );
345: end if;
346: IF old_references.LOOKUP_TYPE = 'OTHER_REFERENCE_TYPE' then

Line 347: IGS_CO_OU_CO_REF_PKG.GET_FK_IGS_LOOKUPS_VIEW(

343: old_references.LOOKUP_CODE
344: );
345: end if;
346: IF old_references.LOOKUP_TYPE = 'OTHER_REFERENCE_TYPE' then
347: IGS_CO_OU_CO_REF_PKG.GET_FK_IGS_LOOKUPS_VIEW(
348: old_references.LOOKUP_CODE
349: );
350: end if;
351: */

Line 353: IGS_PE_PERSON_ID_TYP_PKG.GET_FK_IGS_LOOKUPS_VIEW(

349: );
350: end if;
351: */
352: IF old_references.LOOKUP_TYPE = 'PERSON_ID_TYPE' then
353: IGS_PE_PERSON_ID_TYP_PKG.GET_FK_IGS_LOOKUPS_VIEW(
354: old_references.LOOKUP_CODE
355: );
356: end if;
357: IF old_references.LOOKUP_TYPE = 'PRG_CHECK_TYPE' then

Line 358: IGS_PR_STDNT_PR_CK_PKG.GET_FK_IGS_LOOKUPS_VIEW(

354: old_references.LOOKUP_CODE
355: );
356: end if;
357: IF old_references.LOOKUP_TYPE = 'PRG_CHECK_TYPE' then
358: IGS_PR_STDNT_PR_CK_PKG.GET_FK_IGS_LOOKUPS_VIEW(
359: old_references.LOOKUP_CODE
360: );
361: end if;
362: IF old_references.LOOKUP_TYPE = 'PRG_MEASURE_TYPE' then

Line 363: IGS_PR_SDT_PS_PR_MSR_PKG.GET_FK_IGS_LOOKUPS_VIEW(

359: old_references.LOOKUP_CODE
360: );
361: end if;
362: IF old_references.LOOKUP_TYPE = 'PRG_MEASURE_TYPE' then
363: IGS_PR_SDT_PS_PR_MSR_PKG.GET_FK_IGS_LOOKUPS_VIEW(
364: old_references.LOOKUP_CODE
365: );
366: end if;
367: IF old_references.LOOKUP_TYPE = 'PRG_RULE_REPEAT_FAIL_TYPE' then

Line 368: IGS_PR_RU_OU_PKG.GET_FK_IGS_LOOKUPS_VIEW(

364: old_references.LOOKUP_CODE
365: );
366: end if;
367: IF old_references.LOOKUP_TYPE = 'PRG_RULE_REPEAT_FAIL_TYPE' then
368: IGS_PR_RU_OU_PKG.GET_FK_IGS_LOOKUPS_VIEW(
369: old_references.LOOKUP_CODE
370: );
371: end if;
372: IF old_references.LOOKUP_TYPE = 'PROGRESSION_OUTCOME_TYPE' then

Line 373: IGS_PR_OU_TYPE_PKG.GET_FK_IGS_LOOKUPS_VIEW(

369: old_references.LOOKUP_CODE
370: );
371: end if;
372: IF old_references.LOOKUP_TYPE = 'PROGRESSION_OUTCOME_TYPE' then
373: IGS_PR_OU_TYPE_PKG.GET_FK_IGS_LOOKUPS_VIEW(
374: old_references.LOOKUP_CODE
375: );
376: end if;
377: IF old_references.LOOKUP_TYPE = 'PROGRESSION_STATUS' then

Line 378: IGS_EN_STDNT_PS_ATT_PKG.GET_FK_IGS_LOOKUPS_VIEW_PROG(

374: old_references.LOOKUP_CODE
375: );
376: end if;
377: IF old_references.LOOKUP_TYPE = 'PROGRESSION_STATUS' then
378: IGS_EN_STDNT_PS_ATT_PKG.GET_FK_IGS_LOOKUPS_VIEW_PROG(
379: old_references.LOOKUP_CODE
380: );
381: end if;
382: IF old_references.LOOKUP_TYPE = 'REFERENCE_CD_TYPE' then

Line 383: IGS_GE_REF_CD_TYPE_PKG.GET_FK_IGS_LOOKUPS_VIEW(

379: old_references.LOOKUP_CODE
380: );
381: end if;
382: IF old_references.LOOKUP_TYPE = 'REFERENCE_CD_TYPE' then
383: IGS_GE_REF_CD_TYPE_PKG.GET_FK_IGS_LOOKUPS_VIEW(
384: old_references.LOOKUP_CODE
385: );
386: end if;
387: IF old_references.LOOKUP_TYPE = 'RESULT_TYPE' then

Line 388: IGS_AS_GRD_SCH_GRADE_PKG.GET_FK_IGS_LOOKUPS_VIEW(

384: old_references.LOOKUP_CODE
385: );
386: end if;
387: IF old_references.LOOKUP_TYPE = 'RESULT_TYPE' then
388: IGS_AS_GRD_SCH_GRADE_PKG.GET_FK_IGS_LOOKUPS_VIEW(
389: old_references.LOOKUP_CODE
390: );
391: end if;
392: IF old_references.LOOKUP_TYPE = 'SCNDRY_SCHOOL_TYPE' then

Line 393: IGS_AD_AUS_SEC_ED_SC_PKG.GET_FK_IGS_LOOKUPS_VIEW(

389: old_references.LOOKUP_CODE
390: );
391: end if;
392: IF old_references.LOOKUP_TYPE = 'SCNDRY_SCHOOL_TYPE' then
393: IGS_AD_AUS_SEC_ED_SC_PKG.GET_FK_IGS_LOOKUPS_VIEW(
394: old_references.LOOKUP_CODE
395: );
396: end if;
397: IF old_references.LOOKUP_TYPE = 'STUDENT_TODO_TYPE' then

Line 398: IGS_PE_STD_TODO_PKG.GET_FK_IGS_LOOKUPS_VIEW(

394: old_references.LOOKUP_CODE
395: );
396: end if;
397: IF old_references.LOOKUP_TYPE = 'STUDENT_TODO_TYPE' then
398: IGS_PE_STD_TODO_PKG.GET_FK_IGS_LOOKUPS_VIEW(
399: old_references.LOOKUP_CODE
400: );
401: end if;
402: IF old_references.LOOKUP_TYPE = 'THESIS_RESULT' then

Line 403: IGS_RE_THESIS_RESULT_PKG.GET_FK_IGS_LOOKUPS_VIEW(

399: old_references.LOOKUP_CODE
400: );
401: end if;
402: IF old_references.LOOKUP_TYPE = 'THESIS_RESULT' then
403: IGS_RE_THESIS_RESULT_PKG.GET_FK_IGS_LOOKUPS_VIEW(
404: old_references.LOOKUP_CODE
405: );
406: end if;
407: IF old_references.LOOKUP_TYPE = 'TRACKING_STEP_TYPE' then

Line 408: IGS_TR_STEP_PKG.GET_FK_IGS_LOOKUPS_VIEW(

404: old_references.LOOKUP_CODE
405: );
406: end if;
407: IF old_references.LOOKUP_TYPE = 'TRACKING_STEP_TYPE' then
408: IGS_TR_STEP_PKG.GET_FK_IGS_LOOKUPS_VIEW(
409: old_references.LOOKUP_CODE
410: );
411: end if;
412: IF old_references.LOOKUP_TYPE = 'TRACKING_STEP_TYPE' then

Line 413: IGS_TR_TYPE_STEP_PKG.GET_FK_IGS_LOOKUPS_VIEW(

409: old_references.LOOKUP_CODE
410: );
411: end if;
412: IF old_references.LOOKUP_TYPE = 'TRACKING_STEP_TYPE' then
413: IGS_TR_TYPE_STEP_PKG.GET_FK_IGS_LOOKUPS_VIEW(
414: old_references.LOOKUP_CODE
415: );
416: end if;
417: IF old_references.LOOKUP_TYPE = 'TRANSACTION_TYPE' then

Line 418: IGS_FI_FEE_AS_PKG.GET_FK_IGS_LOOKUPS_VIEW(

414: old_references.LOOKUP_CODE
415: );
416: end if;
417: IF old_references.LOOKUP_TYPE = 'TRANSACTION_TYPE' then
418: IGS_FI_FEE_AS_PKG.GET_FK_IGS_LOOKUPS_VIEW(
419: old_references.LOOKUP_CODE
420: );
421: end if;
422: IF old_references.LOOKUP_TYPE = 'UNIT_ATTEMPT_STATUS' then

Line 423: IGS_AD_ADM_UNIT_STAT_PKG.GET_FK_IGS_LOOKUPS_VIEW(

419: old_references.LOOKUP_CODE
420: );
421: end if;
422: IF old_references.LOOKUP_TYPE = 'UNIT_ATTEMPT_STATUS' then
423: IGS_AD_ADM_UNIT_STAT_PKG.GET_FK_IGS_LOOKUPS_VIEW(
424: old_references.LOOKUP_CODE
425: );
426: end if;
427: IF old_references.LOOKUP_TYPE = 'UNIT_ATTEMPT_STATUS' then

Line 428: IGS_EN_SU_ATTEMPT_PKG.GET_FK_IGS_LOOKUPS_VIEW(

424: old_references.LOOKUP_CODE
425: );
426: end if;
427: IF old_references.LOOKUP_TYPE = 'UNIT_ATTEMPT_STATUS' then
428: IGS_EN_SU_ATTEMPT_PKG.GET_FK_IGS_LOOKUPS_VIEW(
429: old_references.LOOKUP_CODE
430: );
431: end if;
432:

Line 434: igs_en_cpd_ext_pkg.get_fk_igs_lookups_view_1(

430: );
431: end if;
432:
433: IF old_references.LOOKUP_TYPE = 'VS_EN_COMMENCE' then
434: igs_en_cpd_ext_pkg.get_fk_igs_lookups_view_1(
435: old_references.LOOKUP_CODE
436: );
437: END IF;
438:

Line 440: igs_en_cpd_ext_pkg.get_fk_igs_lookups_view_2(

436: );
437: END IF;
438:
439: IF old_references.LOOKUP_TYPE = 'ENROLMENT_STEP_TYPE_EXT' then
440: igs_en_cpd_ext_pkg.get_fk_igs_lookups_view_2(
441: old_references.LOOKUP_CODE
442: );
443: END IF;
444:

Line 448: IGS_AS_SU_ATMPT_ITM_PKG.GET_FK_IGS_LOOKUPS_VIEW(

444:
445: -- Added by DDEY as a part of Bug # 2162831
446:
447: IF old_references.LOOKUP_TYPE = 'MARKS_GRADE_CHANGE_COMMENT' then
448: IGS_AS_SU_ATMPT_ITM_PKG.GET_FK_IGS_LOOKUPS_VIEW(
449: old_references.LOOKUP_CODE
450: );
451: END IF;
452:

Line 456: IGS_AS_GRD_SCHEMA_PKG.GET_FK_IGS_LOOKUPS_VIEW(

452:
453: -- Added by DDEY as a part of Bug # 2162831
454:
455: IF old_references.LOOKUP_TYPE = 'GRADING_SCHEMA_TYPES' then
456: IGS_AS_GRD_SCHEMA_PKG.GET_FK_IGS_LOOKUPS_VIEW(
457: old_references.LOOKUP_CODE
458: );
459: END IF;
460:

Line 462: igs_en_orun_wlst_pri_pkg.GET_FK_IGS_LOOKUPS_VIEW(

458: );
459: END IF;
460:
461: IF old_references.LOOKUP_TYPE = 'UNIT_WAITLIST' then
462: igs_en_orun_wlst_pri_pkg.GET_FK_IGS_LOOKUPS_VIEW(
463: old_references.LOOKUP_CODE
464: );
465: END IF;
466:

Line 476: FROM IGS_LOOKUPS_VIEW

472: )RETURN BOOLEAN AS
473:
474: CURSOR cur_rowid IS
475: SELECT 1
476: FROM IGS_LOOKUPS_VIEW
477: WHERE LOOKUP_TYPE = x_LOOKUP_TYPE
478: AND LOOKUP_CODE = x_LOOKUP_CODE;
479:
480: lv_rowid cur_rowid%RowType;

Line 641: end IGS_LOOKUPS_VIEW_PKG;

637:
638: END UPDATE_ROW;
639:
640:
641: end IGS_LOOKUPS_VIEW_PKG;