eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PR_GEN_006 dependencies on IGS_PE_PERSENC_EFFCT

Line 1642: FROM IGS_PE_PERSENC_EFFCT pee,

1638: spo.expiry_dt) <> cst_expired;
1639: CURSOR c_pee (
1640: cp_encumbrance_type igs_pr_ou_type.encumbrance_type%TYPE) IS
1641: SELECT 'X'
1642: FROM IGS_PE_PERSENC_EFFCT pee,
1643: IGS_PE_PERS_ENCUMB pen
1644: WHERE pen.person_id = p_person_id AND
1645: pen.spo_course_cd IS NULL AND
1646: (pen.expiry_dt IS NULL OR

Line 1688: IGS_PE_PERSENC_EFFCT pee

1684: cp_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE,
1685: cp_spo_expiry_dt IGS_PR_STDNT_PR_OU.expiry_dt%TYPE) IS
1686: SELECT pee.s_encmb_effect_type
1687: FROM IGS_PE_PERS_ENCUMB pen,
1688: IGS_PE_PERSENC_EFFCT pee
1689: WHERE pen.person_id = p_person_id AND
1690: pen.spo_course_cd = p_course_cd AND
1691: pen.spo_sequence_number = cp_spo_sequence_number AND
1692: pen.person_id = pee.person_id AND

Line 2552: v_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE;

2548: v_course_cd_found BOOLEAN;
2549: v_course_grp_cd_found BOOLEAN;
2550: v_unit_set_found BOOLEAN;
2551: v_unit_cd_found BOOLEAN;
2552: v_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE;
2553: v_dummy VARCHAR2(1);
2554: v_fund_cd_found BOOLEAN;
2555: CURSOR c_spo IS
2556: SELECT spo.decision_status,

Line 2595: IGS_PE_PERSENC_EFFCT pee,

2591: CURSOR c_pee IS
2592: SELECT pee.*,
2593: pee.ROWID
2594: FROM IGS_PE_PERS_ENCUMB pen,
2595: IGS_PE_PERSENC_EFFCT pee,
2596: igs_fi_enc_dflt_eft etde
2597: WHERE pen.person_id = p_person_id AND
2598: pen.spo_course_cd = p_course_cd AND
2599: pen.spo_sequence_number = p_spo_sequence_number AND

Line 2614: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,

2610: SELECT IGS_PR_PEE_SEQUEN_S.NEXTVAL
2611: FROM DUAL;
2612:
2613: CURSOR c_pce (
2614: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2615: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
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

Line 2615: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,

2611: FROM DUAL;
2612:
2613: CURSOR c_pce (
2614: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2615: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
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

Line 2616: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,

2612:
2613: CURSOR c_pce (
2614: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2615: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
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

Line 2617: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,

2613: CURSOR c_pce (
2614: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2615: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
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

Line 2618: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

2614: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2615: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
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

Line 2641: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,

2637:
2638: v_pce_index BINARY_INTEGER;
2639:
2640: CURSOR c_pce_dup (
2641: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%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,

Line 2642: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,

2638: v_pce_index BINARY_INTEGER;
2639:
2640: CURSOR c_pce_dup (
2641: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%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,

Line 2643: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,

2639:
2640: CURSOR c_pce_dup (
2641: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%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

Line 2644: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,

2640: CURSOR c_pce_dup (
2641: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%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

Line 2645: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,

2641: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%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

Line 2674: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,

2670: v_spc_table t_spc_type;
2671: v_spc_index BINARY_INTEGER;
2672:
2673: CURSOR c_pcge (
2674: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2675: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2676: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2677: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2678: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

Line 2675: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,

2671: v_spc_index BINARY_INTEGER;
2672:
2673: CURSOR c_pcge (
2674: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2675: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2676: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2677: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2678: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
2679: SELECT pcge.*, pcge.ROWID

Line 2676: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,

2672:
2673: CURSOR c_pcge (
2674: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2675: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2676: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2677: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2678: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
2679: SELECT pcge.*, pcge.ROWID
2680: FROM igs_pe_crs_grp_excl pcge

Line 2677: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,

2673: CURSOR c_pcge (
2674: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2675: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2676: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2677: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2678: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
2679: SELECT pcge.*, pcge.ROWID
2680: FROM igs_pe_crs_grp_excl pcge
2681: WHERE pcge.person_id = p_person_id AND

Line 2678: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

2674: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2675: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2676: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2677: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2678: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
2679: SELECT pcge.*, pcge.ROWID
2680: FROM igs_pe_crs_grp_excl pcge
2681: WHERE pcge.person_id = p_person_id AND
2682: pcge.encumbrance_type = cp_encumbrance_type AND

Line 2697: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,

2693: v_pcge_table t_pcge_table;
2694: v_pcge_index BINARY_INTEGER;
2695:
2696: CURSOR c_pcge_dup (
2697: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2698: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2699: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2700: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2701: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,

Line 2698: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,

2694: v_pcge_index BINARY_INTEGER;
2695:
2696: CURSOR c_pcge_dup (
2697: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2698: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2699: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2700: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2701: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,
2702: cp_course_group_cd igs_pe_crs_grp_excl.course_group_cd%TYPE,

Line 2699: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,

2695:
2696: CURSOR c_pcge_dup (
2697: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2698: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2699: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2700: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2701: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,
2702: cp_course_group_cd igs_pe_crs_grp_excl.course_group_cd%TYPE,
2703: cp_pcge_start_dt igs_pe_crs_grp_excl.pcge_start_dt%TYPE) IS

Line 2700: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,

2696: CURSOR c_pcge_dup (
2697: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2698: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2699: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2700: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2701: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,
2702: cp_course_group_cd igs_pe_crs_grp_excl.course_group_cd%TYPE,
2703: cp_pcge_start_dt igs_pe_crs_grp_excl.pcge_start_dt%TYPE) IS
2704: SELECT pcge.*, pcge.ROWID

Line 2701: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,

2697: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2698: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2699: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2700: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2701: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,
2702: cp_course_group_cd igs_pe_crs_grp_excl.course_group_cd%TYPE,
2703: cp_pcge_start_dt igs_pe_crs_grp_excl.pcge_start_dt%TYPE) IS
2704: SELECT pcge.*, pcge.ROWID
2705: FROM igs_pe_crs_grp_excl pcge

Line 2719: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,

2715:
2716: v_pcge_dup_rec c_pcge_dup%ROWTYPE;
2717:
2718: CURSOR c_puse (
2719: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2720: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2721: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2722: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2723: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

Line 2720: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,

2716: v_pcge_dup_rec c_pcge_dup%ROWTYPE;
2717:
2718: CURSOR c_puse (
2719: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2720: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2721: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2722: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2723: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
2724: SELECT puse.*, puse.ROWID

Line 2721: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,

2717:
2718: CURSOR c_puse (
2719: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2720: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2721: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2722: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2723: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
2724: SELECT puse.*, puse.ROWID
2725: FROM igs_pe_unt_set_excl puse

Line 2722: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,

2718: CURSOR c_puse (
2719: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2720: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2721: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2722: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2723: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
2724: SELECT puse.*, puse.ROWID
2725: FROM igs_pe_unt_set_excl puse
2726: WHERE puse.person_id = p_person_id AND

Line 2723: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

2719: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2720: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2721: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2722: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2723: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
2724: SELECT puse.*, puse.ROWID
2725: FROM igs_pe_unt_set_excl puse
2726: WHERE puse.person_id = p_person_id AND
2727: puse.encumbrance_type = cp_encumbrance_type AND

Line 2748: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,

2744: v_puse_table t_puse_table;
2745: v_puse_index BINARY_INTEGER;
2746:
2747: CURSOR c_puse_dup (
2748: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2749: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2750: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2751: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2752: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,

Line 2749: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,

2745: v_puse_index BINARY_INTEGER;
2746:
2747: CURSOR c_puse_dup (
2748: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2749: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2750: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2751: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2752: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,
2753: cp_unit_set_cd igs_pe_unt_set_excl.unit_set_cd%TYPE,

Line 2750: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,

2746:
2747: CURSOR c_puse_dup (
2748: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2749: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2750: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2751: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2752: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,
2753: cp_unit_set_cd igs_pe_unt_set_excl.unit_set_cd%TYPE,
2754: cp_us_version_number igs_pe_unt_set_excl.us_version_number%TYPE,

Line 2751: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,

2747: CURSOR c_puse_dup (
2748: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2749: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2750: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2751: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2752: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,
2753: cp_unit_set_cd igs_pe_unt_set_excl.unit_set_cd%TYPE,
2754: cp_us_version_number igs_pe_unt_set_excl.us_version_number%TYPE,
2755: cp_puse_start_dt igs_pe_unt_set_excl.puse_start_dt%TYPE) IS

Line 2752: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,

2748: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2749: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2750: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2751: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2752: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,
2753: cp_unit_set_cd igs_pe_unt_set_excl.unit_set_cd%TYPE,
2754: cp_us_version_number igs_pe_unt_set_excl.us_version_number%TYPE,
2755: cp_puse_start_dt igs_pe_unt_set_excl.puse_start_dt%TYPE) IS
2756: SELECT puse.*, puse.ROWID

Line 2791: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,

2787: v_spus_table t_spus_table;
2788: v_spus_index BINARY_INTEGER;
2789:
2790: CURSOR c_pue (
2791: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2792: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2793: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2794: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2795: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

Line 2792: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,

2788: v_spus_index BINARY_INTEGER;
2789:
2790: CURSOR c_pue (
2791: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2792: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2793: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2794: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2795: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
2796: SELECT pue.*, pue.ROWID

Line 2793: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,

2789:
2790: CURSOR c_pue (
2791: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2792: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2793: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2794: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2795: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
2796: SELECT pue.*, pue.ROWID
2797: FROM igs_pe_pers_unt_excl pue

Line 2794: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,

2790: CURSOR c_pue (
2791: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2792: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2793: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2794: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2795: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
2796: SELECT pue.*, pue.ROWID
2797: FROM igs_pe_pers_unt_excl pue
2798: WHERE pue.person_id = p_person_id AND

Line 2795: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

2791: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2792: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2793: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2794: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2795: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
2796: SELECT pue.*, pue.ROWID
2797: FROM igs_pe_pers_unt_excl pue
2798: WHERE pue.person_id = p_person_id AND
2799: pue.encumbrance_type = cp_encumbrance_type AND

Line 2816: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,

2812: v_pue_table t_pue_table;
2813: v_pue_index BINARY_INTEGER;
2814:
2815: CURSOR c_pue_dup (
2816: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2817: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2818: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2819: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2820: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,

Line 2817: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,

2813: v_pue_index BINARY_INTEGER;
2814:
2815: CURSOR c_pue_dup (
2816: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2817: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2818: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2819: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2820: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,
2821: cp_unit_cd igs_pe_pers_unt_excl.unit_cd%TYPE,

Line 2818: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,

2814:
2815: CURSOR c_pue_dup (
2816: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2817: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2818: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2819: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2820: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,
2821: cp_unit_cd igs_pe_pers_unt_excl.unit_cd%TYPE,
2822: cp_pue_start_dt igs_pe_pers_unt_excl.pue_start_dt%TYPE) IS

Line 2819: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,

2815: CURSOR c_pue_dup (
2816: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2817: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2818: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2819: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2820: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,
2821: cp_unit_cd igs_pe_pers_unt_excl.unit_cd%TYPE,
2822: cp_pue_start_dt igs_pe_pers_unt_excl.pue_start_dt%TYPE) IS
2823:

Line 2820: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,

2816: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2817: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2818: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2819: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2820: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,
2821: cp_unit_cd igs_pe_pers_unt_excl.unit_cd%TYPE,
2822: cp_pue_start_dt igs_pe_pers_unt_excl.pue_start_dt%TYPE) IS
2823:
2824: SELECT pue.*, pue.ROWID

Line 2839: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,

2835:
2836: v_pue_dup_rec c_pue_dup%ROWTYPE;
2837:
2838: CURSOR c_pur (
2839: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2840: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2841: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2842: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2843: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

Line 2840: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,

2836: v_pue_dup_rec c_pue_dup%ROWTYPE;
2837:
2838: CURSOR c_pur (
2839: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2840: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2841: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2842: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2843: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
2844: SELECT pur.*, pur.ROWID

Line 2841: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,

2837:
2838: CURSOR c_pur (
2839: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2840: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2841: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2842: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2843: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
2844: SELECT pur.*, pur.ROWID
2845: FROM igs_pe_unt_requirmnt pur

Line 2842: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,

2838: CURSOR c_pur (
2839: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2840: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2841: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2842: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2843: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
2844: SELECT pur.*, pur.ROWID
2845: FROM igs_pe_unt_requirmnt pur
2846: WHERE pur.person_id = p_person_id AND

Line 2843: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

2839: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2840: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2841: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2842: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2843: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
2844: SELECT pur.*, pur.ROWID
2845: FROM igs_pe_unt_requirmnt pur
2846: WHERE pur.person_id = p_person_id AND
2847: pur.encumbrance_type = cp_encumbrance_type AND

Line 2863: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,

2859: v_pur_table t_pur_table;
2860: v_pur_index BINARY_INTEGER;
2861:
2862: CURSOR c_pur_dup (
2863: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2864: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2865: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2866: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2867: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,

Line 2864: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,

2860: v_pur_index BINARY_INTEGER;
2861:
2862: CURSOR c_pur_dup (
2863: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2864: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2865: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2866: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2867: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,
2868: cp_unit_cd igs_pe_unt_requirmnt.unit_cd%TYPE,

Line 2865: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,

2861:
2862: CURSOR c_pur_dup (
2863: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2864: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2865: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2866: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2867: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,
2868: cp_unit_cd igs_pe_unt_requirmnt.unit_cd%TYPE,
2869: cp_pur_start_dt igs_pe_unt_requirmnt.pur_start_dt%TYPE) IS

Line 2866: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,

2862: CURSOR c_pur_dup (
2863: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2864: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2865: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2866: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2867: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,
2868: cp_unit_cd igs_pe_unt_requirmnt.unit_cd%TYPE,
2869: cp_pur_start_dt igs_pe_unt_requirmnt.pur_start_dt%TYPE) IS
2870: SELECT pur.*, pur.ROWID

Line 2867: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,

2863: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
2864: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2865: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2866: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2867: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,
2868: cp_unit_cd igs_pe_unt_requirmnt.unit_cd%TYPE,
2869: cp_pur_start_dt igs_pe_unt_requirmnt.pur_start_dt%TYPE) IS
2870: SELECT pur.*, pur.ROWID
2871: FROM igs_pe_unt_requirmnt pur

Line 2905: v_apply_course_cd IGS_PE_PERSENC_EFFCT.course_cd%TYPE;

2901: FROM igs_en_encmb_efcttyp seet
2902: WHERE seet.s_encmb_effect_type = cp_s_encmb_effect_type;
2903:
2904: v_apply_to_course_ind igs_en_encmb_efcttyp.apply_to_course_ind%TYPE;
2905: v_apply_course_cd IGS_PE_PERSENC_EFFCT.course_cd%TYPE;
2906:
2907: TYPE r_etde_record_type IS RECORD (
2908: s_encmb_effect_type igs_fi_enc_dflt_eft.s_encmb_effect_type%TYPE);
2909: r_etde_record r_etde_record_type;

Line 2923: cp_encumbrance_type igs_pe_persenc_effct.encumbrance_type%TYPE,

2919: --
2920: -- Start of new code added as per the FA110 PR Enh. Bug# 2658550.
2921: --
2922: CURSOR c_pfe (
2923: cp_encumbrance_type igs_pe_persenc_effct.encumbrance_type%TYPE,
2924: cp_pen_start_dt igs_pe_persenc_effct.pen_start_dt%TYPE,
2925: cp_s_encmb_effect_type igs_pe_persenc_effct.s_encmb_effect_type%TYPE,
2926: cp_pee_start_dt igs_pe_persenc_effct.pee_start_dt%TYPE,
2927: cp_pee_sequence_number igs_pe_persenc_effct.sequence_number%TYPE) IS

Line 2924: cp_pen_start_dt igs_pe_persenc_effct.pen_start_dt%TYPE,

2920: -- Start of new code added as per the FA110 PR Enh. Bug# 2658550.
2921: --
2922: CURSOR c_pfe (
2923: cp_encumbrance_type igs_pe_persenc_effct.encumbrance_type%TYPE,
2924: cp_pen_start_dt igs_pe_persenc_effct.pen_start_dt%TYPE,
2925: cp_s_encmb_effect_type igs_pe_persenc_effct.s_encmb_effect_type%TYPE,
2926: cp_pee_start_dt igs_pe_persenc_effct.pee_start_dt%TYPE,
2927: cp_pee_sequence_number igs_pe_persenc_effct.sequence_number%TYPE) IS
2928: SELECT pfe.*, pfe.rowid

Line 2925: cp_s_encmb_effect_type igs_pe_persenc_effct.s_encmb_effect_type%TYPE,

2921: --
2922: CURSOR c_pfe (
2923: cp_encumbrance_type igs_pe_persenc_effct.encumbrance_type%TYPE,
2924: cp_pen_start_dt igs_pe_persenc_effct.pen_start_dt%TYPE,
2925: cp_s_encmb_effect_type igs_pe_persenc_effct.s_encmb_effect_type%TYPE,
2926: cp_pee_start_dt igs_pe_persenc_effct.pee_start_dt%TYPE,
2927: cp_pee_sequence_number igs_pe_persenc_effct.sequence_number%TYPE) IS
2928: SELECT pfe.*, pfe.rowid
2929: FROM igs_pe_fund_excl pfe

Line 2926: cp_pee_start_dt igs_pe_persenc_effct.pee_start_dt%TYPE,

2922: CURSOR c_pfe (
2923: cp_encumbrance_type igs_pe_persenc_effct.encumbrance_type%TYPE,
2924: cp_pen_start_dt igs_pe_persenc_effct.pen_start_dt%TYPE,
2925: cp_s_encmb_effect_type igs_pe_persenc_effct.s_encmb_effect_type%TYPE,
2926: cp_pee_start_dt igs_pe_persenc_effct.pee_start_dt%TYPE,
2927: cp_pee_sequence_number igs_pe_persenc_effct.sequence_number%TYPE) IS
2928: SELECT pfe.*, pfe.rowid
2929: FROM igs_pe_fund_excl pfe
2930: WHERE pfe.person_id = p_person_id AND

Line 2927: cp_pee_sequence_number igs_pe_persenc_effct.sequence_number%TYPE) IS

2923: cp_encumbrance_type igs_pe_persenc_effct.encumbrance_type%TYPE,
2924: cp_pen_start_dt igs_pe_persenc_effct.pen_start_dt%TYPE,
2925: cp_s_encmb_effect_type igs_pe_persenc_effct.s_encmb_effect_type%TYPE,
2926: cp_pee_start_dt igs_pe_persenc_effct.pee_start_dt%TYPE,
2927: cp_pee_sequence_number igs_pe_persenc_effct.sequence_number%TYPE) IS
2928: SELECT pfe.*, pfe.rowid
2929: FROM igs_pe_fund_excl pfe
2930: WHERE pfe.person_id = p_person_id AND
2931: pfe.encumbrance_type = cp_encumbrance_type AND

Line 2946: cp_encumbrance_type igs_pe_persenc_effct.encumbrance_type%TYPE,

2942: v_pfe_table t_pfe_table;
2943: v_pfe_index BINARY_INTEGER;
2944:
2945: CURSOR c_pfe_dup (
2946: cp_encumbrance_type igs_pe_persenc_effct.encumbrance_type%TYPE,
2947: cp_pen_start_dt igs_pe_persenc_effct.pen_start_dt%TYPE,
2948: cp_s_encmb_effect_type igs_pe_persenc_effct.s_encmb_effect_type%TYPE,
2949: cp_pee_start_dt igs_pe_persenc_effct.pee_start_dt%TYPE,
2950: cp_pee_sequence_number igs_pe_persenc_effct.sequence_number%TYPE,

Line 2947: cp_pen_start_dt igs_pe_persenc_effct.pen_start_dt%TYPE,

2943: v_pfe_index BINARY_INTEGER;
2944:
2945: CURSOR c_pfe_dup (
2946: cp_encumbrance_type igs_pe_persenc_effct.encumbrance_type%TYPE,
2947: cp_pen_start_dt igs_pe_persenc_effct.pen_start_dt%TYPE,
2948: cp_s_encmb_effect_type igs_pe_persenc_effct.s_encmb_effect_type%TYPE,
2949: cp_pee_start_dt igs_pe_persenc_effct.pee_start_dt%TYPE,
2950: cp_pee_sequence_number igs_pe_persenc_effct.sequence_number%TYPE,
2951: cp_fund_code igs_pr_ou_fnd.fund_code%TYPE,

Line 2948: cp_s_encmb_effect_type igs_pe_persenc_effct.s_encmb_effect_type%TYPE,

2944:
2945: CURSOR c_pfe_dup (
2946: cp_encumbrance_type igs_pe_persenc_effct.encumbrance_type%TYPE,
2947: cp_pen_start_dt igs_pe_persenc_effct.pen_start_dt%TYPE,
2948: cp_s_encmb_effect_type igs_pe_persenc_effct.s_encmb_effect_type%TYPE,
2949: cp_pee_start_dt igs_pe_persenc_effct.pee_start_dt%TYPE,
2950: cp_pee_sequence_number igs_pe_persenc_effct.sequence_number%TYPE,
2951: cp_fund_code igs_pr_ou_fnd.fund_code%TYPE,
2952: cp_pfe_start_dt igs_pe_fund_excl.pfe_start_dt%TYPE ) IS

Line 2949: cp_pee_start_dt igs_pe_persenc_effct.pee_start_dt%TYPE,

2945: CURSOR c_pfe_dup (
2946: cp_encumbrance_type igs_pe_persenc_effct.encumbrance_type%TYPE,
2947: cp_pen_start_dt igs_pe_persenc_effct.pen_start_dt%TYPE,
2948: cp_s_encmb_effect_type igs_pe_persenc_effct.s_encmb_effect_type%TYPE,
2949: cp_pee_start_dt igs_pe_persenc_effct.pee_start_dt%TYPE,
2950: cp_pee_sequence_number igs_pe_persenc_effct.sequence_number%TYPE,
2951: cp_fund_code igs_pr_ou_fnd.fund_code%TYPE,
2952: cp_pfe_start_dt igs_pe_fund_excl.pfe_start_dt%TYPE ) IS
2953: SELECT pfe.*, pfe.ROWID

Line 2950: cp_pee_sequence_number igs_pe_persenc_effct.sequence_number%TYPE,

2946: cp_encumbrance_type igs_pe_persenc_effct.encumbrance_type%TYPE,
2947: cp_pen_start_dt igs_pe_persenc_effct.pen_start_dt%TYPE,
2948: cp_s_encmb_effect_type igs_pe_persenc_effct.s_encmb_effect_type%TYPE,
2949: cp_pee_start_dt igs_pe_persenc_effct.pee_start_dt%TYPE,
2950: cp_pee_sequence_number igs_pe_persenc_effct.sequence_number%TYPE,
2951: cp_fund_code igs_pr_ou_fnd.fund_code%TYPE,
2952: cp_pfe_start_dt igs_pe_fund_excl.pfe_start_dt%TYPE ) IS
2953: SELECT pfe.*, pfe.ROWID
2954: FROM igs_pe_fund_excl pfe

Line 3021: cp_expiry_dt IGS_PE_PERSENC_EFFCT.expiry_dt%TYPE) IS

3017:
3018: CURSOR c_pee (
3019: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3020: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3021: cp_expiry_dt IGS_PE_PERSENC_EFFCT.expiry_dt%TYPE) IS
3022: SELECT pee.*,
3023: pee.ROWID
3024: FROM IGS_PE_PERSENC_EFFCT pee
3025: WHERE pee.person_id = p_person_id AND

Line 3024: FROM IGS_PE_PERSENC_EFFCT pee

3020: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3021: cp_expiry_dt IGS_PE_PERSENC_EFFCT.expiry_dt%TYPE) IS
3022: SELECT pee.*,
3023: pee.ROWID
3024: FROM IGS_PE_PERSENC_EFFCT pee
3025: WHERE pee.person_id = p_person_id AND
3026: pee.encumbrance_type = cp_encumbrance_type AND
3027: pee.pen_start_dt = cp_pen_start_dt AND
3028: ((cp_expiry_dt IS NULL OR

Line 3037: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,

3033:
3034: CURSOR c_pce (
3035: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3036: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
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

Line 3038: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,

3034: CURSOR c_pce (
3035: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3036: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
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

Line 3039: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

3035: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3036: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
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

Line 3055: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,

3051:
3052: CURSOR c_pcge (
3053: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3054: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3055: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3056: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3057: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3058: SELECT pcge.*, pcge.ROWID
3059: FROM igs_pe_crs_grp_excl pcge

Line 3056: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,

3052: CURSOR c_pcge (
3053: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3054: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3055: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3056: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3057: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3058: SELECT pcge.*, pcge.ROWID
3059: FROM igs_pe_crs_grp_excl pcge
3060: WHERE pcge.person_id = p_person_id AND

Line 3057: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

3053: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3054: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3055: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3056: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3057: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3058: SELECT pcge.*, pcge.ROWID
3059: FROM igs_pe_crs_grp_excl pcge
3060: WHERE pcge.person_id = p_person_id AND
3061: pcge.encumbrance_type = cp_encumbrance_type AND

Line 3073: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,

3069:
3070: CURSOR c_puse (
3071: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3072: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3073: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3074: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3075: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3076: SELECT puse.*,puse.ROWID
3077: FROM igs_pe_unt_set_excl puse

Line 3074: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,

3070: CURSOR c_puse (
3071: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3072: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3073: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3074: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3075: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3076: SELECT puse.*,puse.ROWID
3077: FROM igs_pe_unt_set_excl puse
3078: WHERE puse.person_id = p_person_id AND

Line 3075: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

3071: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3072: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3073: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3074: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3075: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3076: SELECT puse.*,puse.ROWID
3077: FROM igs_pe_unt_set_excl puse
3078: WHERE puse.person_id = p_person_id AND
3079: puse.encumbrance_type = cp_encumbrance_type AND

Line 3091: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,

3087:
3088: CURSOR c_pue (
3089: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3090: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3091: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3092: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3093: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3094: SELECT pue.*, pue.ROWID
3095: FROM igs_pe_pers_unt_excl pue

Line 3092: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,

3088: CURSOR c_pue (
3089: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3090: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3091: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3092: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3093: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3094: SELECT pue.*, pue.ROWID
3095: FROM igs_pe_pers_unt_excl pue
3096: WHERE pue.person_id = p_person_id AND

Line 3093: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

3089: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3090: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3091: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3092: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3093: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3094: SELECT pue.*, pue.ROWID
3095: FROM igs_pe_pers_unt_excl pue
3096: WHERE pue.person_id = p_person_id AND
3097: pue.encumbrance_type = cp_encumbrance_type AND

Line 3109: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,

3105:
3106: CURSOR c_pur (
3107: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3108: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3109: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3110: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3111: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3112: SELECT pur.*, pur.ROWID
3113: FROM igs_pe_unt_requirmnt pur

Line 3110: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,

3106: CURSOR c_pur (
3107: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3108: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3109: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3110: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3111: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3112: SELECT pur.*, pur.ROWID
3113: FROM igs_pe_unt_requirmnt pur
3114: WHERE pur.person_id = p_person_id AND

Line 3111: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

3107: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3108: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3109: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3110: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3111: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3112: SELECT pur.*, pur.ROWID
3113: FROM igs_pe_unt_requirmnt pur
3114: WHERE pur.person_id = p_person_id AND
3115: pur.encumbrance_type = cp_encumbrance_type AND

Line 3130: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,

3126: --
3127: CURSOR c_pfe (
3128: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3129: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3130: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3131: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3132: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3133: SELECT pfe.*, pfe.ROWID
3134: FROM igs_pe_fund_excl pfe

Line 3131: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,

3127: CURSOR c_pfe (
3128: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3129: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3130: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3131: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3132: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3133: SELECT pfe.*, pfe.ROWID
3134: FROM igs_pe_fund_excl pfe
3135: WHERE pfe.person_id = p_person_id AND

Line 3132: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

3128: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3129: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3130: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3131: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3132: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3133: SELECT pfe.*, pfe.ROWID
3134: FROM igs_pe_fund_excl pfe
3135: WHERE pfe.person_id = p_person_id AND
3136: pfe.encumbrance_type = cp_encumbrance_type AND

Line 3307: igs_pe_persenc_effct_pkg.update_row(

3303: p_local_message_text := v_message_text;
3304: p_local_message_level := v_message_level;
3305: END IF;
3306: END IF;
3307: igs_pe_persenc_effct_pkg.update_row(
3308: X_ROWID => v_pee_rec.ROWID,
3309: X_PERSON_ID => v_pee_rec.PERSON_ID,
3310: X_ENCUMBRANCE_TYPE => v_pee_rec.ENCUMBRANCE_TYPE,
3311: X_PEN_START_DT => v_pee_rec.PEN_START_DT,

Line 3422: IGS_PE_PERSENC_EFFCT pee,

3418: CURSOR c_pee IS
3419: SELECT pee.*,
3420: pee.ROWID
3421: FROM IGS_PE_PERS_ENCUMB pen,
3422: IGS_PE_PERSENC_EFFCT pee,
3423: igs_fi_enc_dflt_eft etde
3424: WHERE pen.person_id = p_person_id AND
3425: pen.spo_course_cd = p_course_cd AND
3426: pen.spo_sequence_number = p_spo_sequence_number AND

Line 3439: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,

3435:
3436: CURSOR c_pce (
3437: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3438: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
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

Line 3440: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,

3436: CURSOR c_pce (
3437: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3438: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
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

Line 3441: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

3437: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3438: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
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

Line 3455: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,

3451:
3452: CURSOR c_pcge (
3453: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3454: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3455: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3456: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3457: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3458: SELECT pcge.*, pcge.ROWID
3459: FROM igs_pe_crs_grp_excl pcge

Line 3456: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,

3452: CURSOR c_pcge (
3453: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3454: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3455: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3456: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3457: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3458: SELECT pcge.*, pcge.ROWID
3459: FROM igs_pe_crs_grp_excl pcge
3460: WHERE pcge.person_id = p_person_id AND

Line 3457: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

3453: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3454: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3455: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3456: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3457: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3458: SELECT pcge.*, pcge.ROWID
3459: FROM igs_pe_crs_grp_excl pcge
3460: WHERE pcge.person_id = p_person_id AND
3461: pcge.encumbrance_type = cp_encumbrance_type AND

Line 3471: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,

3467:
3468: CURSOR c_puse (
3469: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3470: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3471: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3472: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3473: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3474: SELECT puse.*, puse.ROWID
3475: FROM igs_pe_unt_set_excl puse

Line 3472: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,

3468: CURSOR c_puse (
3469: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3470: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3471: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3472: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3473: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3474: SELECT puse.*, puse.ROWID
3475: FROM igs_pe_unt_set_excl puse
3476: WHERE puse.person_id = p_person_id AND

Line 3473: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

3469: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3470: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3471: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3472: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3473: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3474: SELECT puse.*, puse.ROWID
3475: FROM igs_pe_unt_set_excl puse
3476: WHERE puse.person_id = p_person_id AND
3477: puse.encumbrance_type = cp_encumbrance_type AND

Line 3487: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,

3483:
3484: CURSOR c_pue (
3485: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3486: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3487: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3488: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3489: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3490: SELECT pue.*, pue.ROWID
3491: FROM igs_pe_pers_unt_excl pue

Line 3488: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,

3484: CURSOR c_pue (
3485: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3486: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3487: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3488: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3489: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3490: SELECT pue.*, pue.ROWID
3491: FROM igs_pe_pers_unt_excl pue
3492: WHERE pue.person_id = p_person_id AND

Line 3489: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

3485: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3486: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3487: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3488: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3489: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3490: SELECT pue.*, pue.ROWID
3491: FROM igs_pe_pers_unt_excl pue
3492: WHERE pue.person_id = p_person_id AND
3493: pue.encumbrance_type = cp_encumbrance_type AND

Line 3503: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,

3499:
3500: CURSOR c_pur (
3501: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3502: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3503: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3504: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3505: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3506: SELECT pur.*, pur.ROWID
3507: FROM igs_pe_unt_requirmnt pur

Line 3504: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,

3500: CURSOR c_pur (
3501: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3502: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3503: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3504: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3505: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3506: SELECT pur.*, pur.ROWID
3507: FROM igs_pe_unt_requirmnt pur
3508: WHERE pur.person_id = p_person_id AND

Line 3505: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

3501: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3502: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3503: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3504: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3505: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3506: SELECT pur.*, pur.ROWID
3507: FROM igs_pe_unt_requirmnt pur
3508: WHERE pur.person_id = p_person_id AND
3509: pur.encumbrance_type = cp_encumbrance_type AND

Line 3522: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,

3518: --
3519: CURSOR c_pfe (
3520: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3521: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3522: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3523: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3524: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3525: SELECT pfe.*, pfe.ROWID
3526: FROM IGS_PE_FUND_EXCL pfe

Line 3523: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,

3519: CURSOR c_pfe (
3520: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3521: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3522: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3523: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3524: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3525: SELECT pfe.*, pfe.ROWID
3526: FROM IGS_PE_FUND_EXCL pfe
3527: WHERE pfe.person_id = p_person_id AND

Line 3524: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

3520: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
3521: cp_pen_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
3522: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3523: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3524: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3525: SELECT pfe.*, pfe.ROWID
3526: FROM IGS_PE_FUND_EXCL pfe
3527: WHERE pfe.person_id = p_person_id AND
3528: pfe.encumbrance_type = cp_encumbrance_type AND

Line 3677: IGS_PE_PERSENC_EFFCT_PKG.UPDATE_ROW(

3673: X_EXPIRY_DT => gcst_sysdatetime,--gjha1
3674: X_MODE => 'R'
3675: );
3676: END LOOP; -- c_pur
3677: IGS_PE_PERSENC_EFFCT_PKG.UPDATE_ROW(
3678: X_ROWID => v_pee_rec.ROWID,
3679: X_PERSON_ID => v_pee_rec.PERSON_ID,
3680: X_ENCUMBRANCE_TYPE => v_pee_rec.ENCUMBRANCE_TYPE,
3681: X_PEN_START_DT => v_pee_rec.PEN_START_DT,

Line 3893: IGS_PE_PERSENC_EFFCT_PKG.UPDATE_ROW(

3889: cst_rstr_le_cp) AND
3890: NVL(v_pee_rec.restricted_enrolment_cp, -1) <>
3891: NVL(v_spo_rec.restricted_enrolment_cp, -1) THEN
3892:
3893: IGS_PE_PERSENC_EFFCT_PKG.UPDATE_ROW(
3894: X_ROWID => v_pee_rec.ROWID,
3895: X_PERSON_ID => v_pee_rec.PERSON_ID,
3896: X_ENCUMBRANCE_TYPE => v_pee_rec.ENCUMBRANCE_TYPE,
3897: X_PEN_START_DT => v_pee_rec.PEN_START_DT,

Line 3914: IGS_PE_PERSENC_EFFCT_PKG.UPDATE_ROW(

3910: NVL(v_pee_rec.restricted_attendance_type,'NULL') <>
3911: NVL(v_spo_rec.restricted_attendance_type,'NULL') AND
3912: v_spo_rec.closed_ind = 'N' THEN
3913:
3914: IGS_PE_PERSENC_EFFCT_PKG.UPDATE_ROW(
3915: X_ROWID => v_pee_rec.ROWID,
3916: X_PERSON_ID => v_pee_rec.PERSON_ID,
3917: X_ENCUMBRANCE_TYPE => v_pee_rec.ENCUMBRANCE_TYPE,
3918: X_PEN_START_DT => v_pee_rec.PEN_START_DT,

Line 4677: IGS_PE_PERSENC_EFFCT_pkg.INSERT_ROW (

4673: OPEN c_decode2;
4674: FETCH c_decode2 INTO v_decode_val2 ;
4675: CLOSE c_decode2;
4676:
4677: IGS_PE_PERSENC_EFFCT_pkg.INSERT_ROW (
4678: X_ROWID =>lv_rowid,
4679: X_PERSON_ID =>p_person_id,
4680: X_ENCUMBRANCE_TYPE =>v_spo_rec.encumbrance_type,
4681: X_PEN_START_DT=> gcst_sysdatetime, --gjha Changed it from gcst_sysdatetime --Modified by Prajeesh to sysdatetime