APPS.IGS_EN_GEN_012 dependencies on IGS_PE_COURSE_EXCL

Line 122: FROM IGS_PE_COURSE_EXCL PCE,

118: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
119: cp_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
120: cp_expiry_dt IGS_PE_PERS_ENCUMB.expiry_dt%TYPE) IS
121: SELECT PCE.ROWID, PCE.*
122: FROM IGS_PE_COURSE_EXCL PCE,
123: IGS_PE_PERSENC_EFFCT PEE
124: WHERE PCE.person_id = cp_person_id AND
125: PCE.encumbrance_type = cp_encumbrance_type AND
126: PCE.pen_start_dt = cp_start_dt AND

Line 288: -- SELECTING ALL IGS_PE_COURSE_EXCL RECORDS

284:
285:
286: END IF;
287: END LOOP;
288: -- SELECTING ALL IGS_PE_COURSE_EXCL RECORDS
289:
290:
291: FOR v_psn_crs_excl_rec IN c_psn_crs_excl(p_person_id,
292: p_encumbrance_type,

Line 295: -- for each IGS_PE_COURSE_EXCL record returned,

291: FOR v_psn_crs_excl_rec IN c_psn_crs_excl(p_person_id,
292: p_encumbrance_type,
293: p_start_dt,
294: p_expiry_dt) LOOP
295: -- for each IGS_PE_COURSE_EXCL record returned,
296: -- update the expiry_dt
297: IF (v_psn_crs_excl_rec.pce_start_dt > p_expiry_dt) THEN
298: Igs_Pe_Course_Excl_Pkg.UPDATE_ROW(
299: X_ROWID => v_psn_crs_excl_rec.ROWID ,

Line 298: Igs_Pe_Course_Excl_Pkg.UPDATE_ROW(

294: p_expiry_dt) LOOP
295: -- for each IGS_PE_COURSE_EXCL record returned,
296: -- update the expiry_dt
297: IF (v_psn_crs_excl_rec.pce_start_dt > p_expiry_dt) THEN
298: Igs_Pe_Course_Excl_Pkg.UPDATE_ROW(
299: X_ROWID => v_psn_crs_excl_rec.ROWID ,
300: X_PERSON_ID => v_psn_crs_excl_rec.PERSON_ID ,
301: X_ENCUMBRANCE_TYPE => v_psn_crs_excl_rec.ENCUMBRANCE_TYPE ,
302: X_PEN_START_DT => v_psn_crs_excl_rec.PEN_START_DT ,

Line 316: Igs_Pe_Course_Excl_Pkg.UPDATE_ROW(

312:
313:
314: ELSE
315:
316: Igs_Pe_Course_Excl_Pkg.UPDATE_ROW(
317: X_ROWID => v_psn_crs_excl_rec.ROWID ,
318: X_PERSON_ID => v_psn_crs_excl_rec.PERSON_ID ,
319: X_ENCUMBRANCE_TYPE => v_psn_crs_excl_rec.ENCUMBRANCE_TYPE ,
320: X_PEN_START_DT => v_psn_crs_excl_rec.PEN_START_DT ,