APPS.IGS_PR_GEN_006 dependencies on IGS_EN_ENCMB_EFCTTYP

Line 1716: p_old_effect IGS_EN_ENCMB_EFCTTYP_V.s_encmb_effect_type%TYPE,

1712: cp_spo_sequence_number,
1713: cp_spo_expiry_dt) <> cst_expired)
1714: );
1715: FUNCTION prgpl_upd_pen_check_clash (
1716: p_old_effect IGS_EN_ENCMB_EFCTTYP_V.s_encmb_effect_type%TYPE,
1717: p_new_effect IGS_EN_ENCMB_EFCTTYP_V.s_encmb_effect_type%TYPE)
1718: RETURN VARCHAR2
1719: IS
1720: gvl_other_detail VARCHAR2(255);

Line 1717: p_new_effect IGS_EN_ENCMB_EFCTTYP_V.s_encmb_effect_type%TYPE)

1713: cp_spo_expiry_dt) <> cst_expired)
1714: );
1715: FUNCTION prgpl_upd_pen_check_clash (
1716: p_old_effect IGS_EN_ENCMB_EFCTTYP_V.s_encmb_effect_type%TYPE,
1717: p_new_effect IGS_EN_ENCMB_EFCTTYP_V.s_encmb_effect_type%TYPE)
1718: RETURN VARCHAR2
1719: IS
1720: gvl_other_detail VARCHAR2(255);
1721: BEGIN -- prgpl_upd_pen_check_clash

Line 2899: cp_s_encmb_effect_type igs_en_encmb_efcttyp.s_encmb_effect_type%TYPE) IS

2895: v_spu_table t_spu_type;
2896: v_spu_index BINARY_INTEGER;
2897:
2898: CURSOR c_seet (
2899: cp_s_encmb_effect_type igs_en_encmb_efcttyp.s_encmb_effect_type%TYPE) IS
2900: SELECT apply_to_course_ind
2901: FROM igs_en_encmb_efcttyp seet
2902: WHERE seet.s_encmb_effect_type = cp_s_encmb_effect_type;
2903:

Line 2901: FROM igs_en_encmb_efcttyp seet

2897:
2898: CURSOR c_seet (
2899: cp_s_encmb_effect_type igs_en_encmb_efcttyp.s_encmb_effect_type%TYPE) IS
2900: SELECT apply_to_course_ind
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;

Line 2904: v_apply_to_course_ind igs_en_encmb_efcttyp.apply_to_course_ind%TYPE;

2900: SELECT apply_to_course_ind
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);