APPS.IGS_AD_UNIT_SETS_PKG dependencies on IGS_EN_UNIT_SET

Line 181: ELSIF NOT Igs_En_Unit_Set_Pkg.Get_PK_For_Validation (

177: (old_references.version_number = new_references.version_number)) OR
178: ((new_references.unit_set_cd IS NULL) OR
179: (new_references.version_number IS NULL))) THEN
180: NULL;
181: ELSIF NOT Igs_En_Unit_Set_Pkg.Get_PK_For_Validation (
182: new_references.unit_set_cd,
183: new_references.version_number
184: ) THEN
185: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');

Line 318: PROCEDURE Get_FK_Igs_En_Unit_Set (

314: Close cur_rowid;
315:
316: END Get_FK_Igs_Ad_Ps_Appl_Inst;
317:
318: PROCEDURE Get_FK_Igs_En_Unit_Set (
319: x_unit_set_cd IN VARCHAR2,
320: x_version_number IN NUMBER
321: ) AS
322: /*************************************************************

Line 352: END Get_FK_Igs_En_Unit_Set;

348: Return;
349: END IF;
350: Close cur_rowid;
351:
352: END Get_FK_Igs_En_Unit_Set;
353: -- begin oxford unit set code bug 5194658
354: PROCEDURE GET_FK_IGS_PS_OFR_UNIT_SET (
355: x_unit_set_cd IN VARCHAR2,
356: x_version_number IN NUMBER,

Line 438: FROM igs_en_unit_set_stat uss

434: AND psus.admission_cat = p_admission_cat
435: )
436: AND psusv.UNIT_SET_STATUS IN
437: (SELECT unit_set_status
438: FROM igs_en_unit_set_stat uss
439: WHERE psusv.unit_set_status = uss.unit_set_status
440: AND uss.s_unit_set_status <> 'INACTIVE'
441: )
442: AND psusv.unit_set_cat IN

Line 444: FROM igs_en_unit_set_cat usc

440: AND uss.s_unit_set_status <> 'INACTIVE'
441: )
442: AND psusv.unit_set_cat IN
443: (SELECT usc.unit_set_cat
444: FROM igs_en_unit_set_cat usc
445: WHERE ((fnd_profile.value ('IGS_PS_PRENRL_YEAR_IND') <> 'Y'
446: OR usc.s_unit_set_cat = 'PRENRL_YR'))
447: )
448: AND psusv.expiry_dt IS NULL

Line 452: igs_en_unit_set us

448: AND psusv.expiry_dt IS NULL
449: UNION
450: SELECT '1'
451: FROM igs_ps_coo_ad_unit_s psus,
452: igs_en_unit_set us
453: WHERE psus.unit_set_cd = p_unit_set_cd -- extra condition, when compared to unit set lov query on IGSAD097.pld, IGSAD046.pld
454: AND psus.us_version_number = p_version_number -- extra condition, when compared to unit set lov query on IGSAD097.pld, IGSAD046.pld
455: AND us.unit_set_cd = psus.unit_set_cd
456: AND us.version_number = psus.us_version_number

Line 466: FROM igs_en_unit_set_stat uss

462: AND psus.attendance_type = nvl(p_attendance_type , psus.attendance_type)
463: AND psus.admission_cat = p_admission_cat
464: AND us.unit_set_status IN
465: (SELECT unit_set_status
466: FROM igs_en_unit_set_stat uss
467: WHERE us.unit_set_status = uss.unit_set_status
468: AND uss.s_unit_set_status <> 'INACTIVE'
469: )
470: AND us.unit_set_cat IN

Line 472: FROM igs_en_unit_set_cat usc

468: AND uss.s_unit_set_status <> 'INACTIVE'
469: )
470: AND us.unit_set_cat IN
471: (SELECT usc.unit_set_cat
472: FROM igs_en_unit_set_cat usc
473: WHERE ((fnd_profile.value ('IGS_PS_PRENRL_YEAR_IND') <> 'Y'
474: OR usc.s_unit_set_cat = 'PRENRL_YR'))
475: )
476: AND us.expiry_dt IS NULL;