APPS.IGS_PR_GEN_006 dependencies on IGS_PE_COURSE_EXCL_PKG

Line 3160: igs_pe_course_excl_pkg.UPDATE_ROW(

3156: v_pen_rec.start_dt,
3157: v_pee_rec.s_encmb_effect_type,
3158: v_pee_rec.pee_start_dt,
3159: v_pee_rec.sequence_number) LOOP
3160: igs_pe_course_excl_pkg.UPDATE_ROW(
3161: X_ROWID => v_pce_rec.ROWID,
3162: X_PERSON_ID => v_pce_rec.PERSON_ID,
3163: X_ENCUMBRANCE_TYPE => v_pce_rec.ENCUMBRANCE_TYPE,
3164: X_PEN_START_DT => v_pce_rec.PEN_START_DT,

Line 3547: igs_pe_course_excl_pkg.UPDATE_ROW(

3543: v_pee_rec.pen_start_dt,
3544: v_pee_rec.s_encmb_effect_type,
3545: v_pee_rec.pee_start_dt,
3546: v_pee_rec.sequence_number) LOOP
3547: igs_pe_course_excl_pkg.UPDATE_ROW(
3548: X_ROWID => v_pce_rec.ROWID,
3549: X_PERSON_ID => v_pce_rec.PERSON_ID,
3550: X_ENCUMBRANCE_TYPE => v_pce_rec.ENCUMBRANCE_TYPE,
3551: X_PEN_START_DT => v_pce_rec.PEN_START_DT,

Line 3963: igs_pe_course_excl_pkg.UPDATE_ROW(

3959:
3960: END LOOP;
3961: IF NOT v_course_cd_found THEN
3962:
3963: igs_pe_course_excl_pkg.UPDATE_ROW(
3964: X_ROWID => v_pce_rec.ROWID,
3965: X_PERSON_ID => v_pce_rec.PERSON_ID,
3966: X_ENCUMBRANCE_TYPE => v_pce_rec.ENCUMBRANCE_TYPE,
3967: X_PEN_START_DT => v_pce_rec.PEN_START_DT,

Line 4004: igs_pe_course_excl_pkg.UPDATE_ROW(

4000: FETCH c_pce_dup INTO v_pce_dup_rec;
4001: IF c_pce_dup%FOUND THEN
4002: -- Re-open closed record.
4003:
4004: igs_pe_course_excl_pkg.UPDATE_ROW(
4005: X_ROWID => v_pce_dup_rec.ROWID,
4006: X_PERSON_ID => v_pce_dup_rec.PERSON_ID,
4007: X_ENCUMBRANCE_TYPE => v_pce_dup_rec.ENCUMBRANCE_TYPE,
4008: X_PEN_START_DT => v_pce_dup_rec.PEN_START_DT,

Line 4046: igs_pe_course_excl_pkg.INSERT_ROW (

4042: DECLARE
4043: lv_rowid VARCHAR2(25);
4044: BEGIN
4045: BEGIN
4046: igs_pe_course_excl_pkg.INSERT_ROW (
4047: X_ROWID =>lv_rowid,
4048: X_PERSON_ID =>p_person_id,
4049: X_ENCUMBRANCE_TYPE =>v_pee_rec.encumbrance_type,
4050: X_PEN_START_DT =>v_pee_rec.pen_start_dt,

Line 4703: igs_pe_course_excl_pkg.INSERT_ROW (

4699: DECLARE
4700: lv_rowid VARCHAR2(25);
4701: BEGIN
4702:
4703: igs_pe_course_excl_pkg.INSERT_ROW (
4704: X_ROWID =>lv_rowid,
4705: X_PERSON_ID =>p_person_id,
4706: X_ENCUMBRANCE_TYPE =>v_spo_rec.encumbrance_type,
4707: X_PEN_START_DT =>gcst_sysdatetime, --gjha Changed it from datetime --Modified by Prajeesh to sysdatetime