[Home] [Help]
421: replaced the usage of local variable l_v_res_profile
422: by global variable g_v_res_profile
423: ***************************************************************/
424:
425: l_v_res_status igs_pe_res_dtls_all.residency_class_cd%TYPE;
426:
427: BEGIN
428:
429: log_to_fnd( p_v_module => 'get_stdnt_res_status_cd',
1685: p_rate_class_standing IGS_PR_CLASS_STD.CLASS_STANDING%TYPE,
1686: p_rate_course_cd igs_ps_ver_all.course_cd%TYPE,
1687: p_rate_version_number igs_ps_ver_all.version_number%TYPE,
1688: p_rate_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%TYPE,
1689: p_rate_residency_status_cd igs_pe_res_dtls_all.residency_status_cd%TYPE,
1690: p_derived_location_cd igs_fi_fee_as_rate.location_cd%TYPE,
1691: p_derived_attendance_type igs_fi_fee_as_rate.attendance_type%TYPE,
1692: p_derived_govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE,
1693: p_derived_prog_att_mode igs_en_atd_mode_all.attendance_mode%TYPE,
1694: p_derived_class_standing IGS_PR_CLASS_STD.CLASS_STANDING%TYPE,
1695: p_derived_course_cd igs_ps_ver_all.course_cd%TYPE,
1696: p_derived_version_number igs_ps_ver_all.version_number%TYPE,
1697: p_derived_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%TYPE,
1698: p_derived_residency_status_cd igs_pe_res_dtls_all.residency_status_cd%TYPE,
1699: p_rate_unit_set_cd igs_fi_fee_as_rate.unit_set_cd%TYPE,
1700: p_rate_us_version_num igs_fi_fee_as_rate.us_version_number%TYPE,
1701: p_derived_unit_set_cd igs_fi_fee_as_rate.unit_set_cd%TYPE,
1702: p_derived_us_version_num igs_fi_fee_as_rate.us_version_number%TYPE,
1916: p_trace_on VARCHAR2,
1917: p_derived_attendance_type OUT NOCOPY igs_fi_fee_as_rate.attendance_type%TYPE,
1918: p_derived_govt_att_mode OUT NOCOPY igs_en_atd_mode_all.govt_attendance_mode%TYPE,
1919: p_derived_prog_att_mode OUT NOCOPY igs_en_atd_mode_all.attendance_mode%TYPE, -- Added as part of 3795849
1920: p_derived_residency_status_cd OUT NOCOPY igs_pe_res_dtls_all.residency_status_cd%TYPE,
1921: p_derived_class_standing OUT NOCOPY IGS_PR_CLASS_STD.CLASS_STANDING%TYPE,
1922: p_c_career IN igs_ps_ver_all.course_type%TYPE,
1923: p_derived_unit_set_cd OUT NOCOPY igs_en_unit_set_all.unit_set_cd%TYPE,
1924: p_derived_us_version_num OUT NOCOPY igs_en_unit_set_all.version_number%TYPE
1954: v_on_att_mode BOOLEAN := FALSE;
1955: v_off_att_mode BOOLEAN := FALSE;
1956: v_composite_att_mode BOOLEAN := FALSE;
1957:
1958: v_derived_residency_status_cd igs_pe_res_dtls_all.residency_status_cd%TYPE;
1959: v_derived_class_standing IGS_PR_CLASS_STD.CLASS_STANDING%TYPE;
1960:
1961: -- Bug# 2122257, Modified the cursor select statement to include the audit table (IGS_FI_F_CAT_CAL_REL)
1962: -- for selecting Fee Category when it is changed.
2383: p_derived_attendance_type igs_fi_fee_as_rate.attendance_type%TYPE,
2384: p_derived_govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE,
2385: p_derived_prog_att_mode igs_en_atd_mode_all.attendance_mode%TYPE,
2386: p_trace_on VARCHAR2,
2387: p_derived_residency_status_cd igs_pe_res_dtls_all.residency_status_cd%TYPE,
2388: p_derived_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%TYPE,
2389: p_derived_course_cd igs_ps_ver_all.course_cd%TYPE,
2390: p_derived_version_number igs_ps_ver_all.version_number%TYPE,
2391: p_derived_class_standing IGS_PR_CLASS_STD.CLASS_STANDING%TYPE,
2426: v_attendance_mode igs_fi_fee_as_rate.attendance_mode%TYPE;
2427: v_rate_number igs_fi_fee_as_rate.rate_number%TYPE;
2428: v_fee_ass_rate_match BOOLEAN;
2429: l_b_fee_ass_rate_found BOOLEAN;
2430: v_residency_status_cd igs_pe_res_dtls_all.residency_status_cd%TYPE;
2431: v_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%TYPE;
2432: v_course_cd igs_fi_fee_as_rate.course_cd%TYPE;
2433: v_version_number igs_fi_fee_as_rate.version_number%TYPE;
2434: v_class_standing igs_fi_fee_as_rate.class_standing%TYPE;