APPS.IGS_PR_GEN_006 dependencies on IGS_PE_COURSE_EXCL

Line 2620: FROM igs_pe_course_excl pce

2616: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2617: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2618: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
2619: SELECT pce.*, pce.ROWID
2620: FROM igs_pe_course_excl pce
2621: WHERE pce.person_id = p_person_id AND
2622: pce.encumbrance_type = cp_encumbrance_type AND
2623: pce.pen_start_dt = cp_pen_start_dt AND
2624: pce.s_encmb_effect_type = cp_s_encmb_effect_type AND

Line 2631: TYPE t_pce_table IS TABLE OF igs_pe_course_excl.course_cd%TYPE

2627: (pce.expiry_dt IS NULL OR
2628: pce.expiry_dt > gcst_sysdate)
2629: FOR UPDATE NOWAIT;
2630:
2631: TYPE t_pce_table IS TABLE OF igs_pe_course_excl.course_cd%TYPE
2632:
2633: INDEX BY BINARY_INTEGER;
2634:
2635:

Line 2646: cp_course_cd igs_pe_course_excl.course_cd%TYPE,

2642: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2643: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2644: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2645: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,
2646: cp_course_cd igs_pe_course_excl.course_cd%TYPE,
2647: cp_pce_start_dt igs_pe_course_excl.pce_start_dt%TYPE) IS
2648: SELECT pce.*, pce.ROWID
2649: FROM igs_pe_course_excl pce
2650: WHERE pce.person_id = p_person_id AND

Line 2647: cp_pce_start_dt igs_pe_course_excl.pce_start_dt%TYPE) IS

2643: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2644: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2645: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,
2646: cp_course_cd igs_pe_course_excl.course_cd%TYPE,
2647: cp_pce_start_dt igs_pe_course_excl.pce_start_dt%TYPE) IS
2648: SELECT pce.*, pce.ROWID
2649: FROM igs_pe_course_excl pce
2650: WHERE pce.person_id = p_person_id AND
2651: pce.encumbrance_type = cp_encumbrance_type AND

Line 2649: FROM igs_pe_course_excl pce

2645: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,
2646: cp_course_cd igs_pe_course_excl.course_cd%TYPE,
2647: cp_pce_start_dt igs_pe_course_excl.pce_start_dt%TYPE) IS
2648: SELECT pce.*, pce.ROWID
2649: FROM igs_pe_course_excl pce
2650: WHERE pce.person_id = p_person_id AND
2651: pce.encumbrance_type = cp_encumbrance_type AND
2652: pce.pen_start_dt = cp_pen_start_dt AND
2653: pce.s_encmb_effect_type = cp_s_encmb_effect_type AND

Line 3041: FROM igs_pe_course_excl pce

3037: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3038: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3039: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3040: SELECT pce.*,pce.ROWID
3041: FROM igs_pe_course_excl pce
3042: WHERE pce.person_id = p_person_id AND
3043: pce.encumbrance_type = cp_encumbrance_type AND
3044: pce.pen_start_dt = cp_pen_start_dt AND
3045: pce.s_encmb_effect_type = cp_s_encmb_effect_type AND

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 3443: FROM igs_pe_course_excl pce

3439: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3440: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3441: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3442: SELECT pce.*, pce.ROWID
3443: FROM igs_pe_course_excl pce
3444: WHERE pce.person_id = p_person_id AND
3445: pce.encumbrance_type = cp_encumbrance_type AND
3446: pce.pen_start_dt = cp_pen_start_dt AND
3447: pce.s_encmb_effect_type = cp_s_encmb_effect_type AND

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 4022: /*INSERT INTO igs_pe_course_excl (

4018:
4019: CLOSE c_pce_dup;
4020: ELSE
4021: CLOSE c_pce_dup;
4022: /*INSERT INTO igs_pe_course_excl (
4023: person_id,
4024: encumbrance_type,
4025: pen_start_dt,
4026: s_encmb_effect_type,

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