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_FI_PRC_FEE_ASS dependencies on IGS_EN_ATD_MODE_ALL

Line 358: p_derived_att_mode OUT NOCOPY igs_en_atd_mode_all.govt_attendance_mode%TYPE) RETURN BOOLEAN;

354: p_s_fee_trigger_cat IN igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
355: p_trace_on IN VARCHAR2,
356: p_c_career IN igs_ps_ver_all.course_type%TYPE,
357: p_derived_attendance_type OUT NOCOPY igs_fi_fee_as_rate.attendance_type%TYPE,
358: p_derived_att_mode OUT NOCOPY igs_en_atd_mode_all.govt_attendance_mode%TYPE) RETURN BOOLEAN;
359:
360:
361: FUNCTION finpl_check_header_lines(p_n_person_id igs_fi_fee_as_all.person_id%TYPE,
362: p_n_transaction_id igs_fi_fee_as_all.transaction_id%TYPE) RETURN BOOLEAN;

Line 1081: p_derived_att_mode OUT NOCOPY igs_en_atd_mode_all.govt_attendance_mode%TYPE) RETURN BOOLEAN AS

1077: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
1078: p_trace_on VARCHAR2,
1079: p_c_career IN igs_ps_ver_all.course_type%TYPE,
1080: p_derived_attendance_type OUT NOCOPY igs_fi_fee_as_rate.attendance_type%TYPE,
1081: p_derived_att_mode OUT NOCOPY igs_en_atd_mode_all.govt_attendance_mode%TYPE) RETURN BOOLEAN AS
1082: /*************************************************************
1083: Created By : abshriva
1084: Date Created By : 1-Jun-2006
1085: Purpose : Bug 5104329:Getting derived values of attendance mode and type.

Line 1098: v_derived_govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE;

1094: cst_off CONSTANT VARCHAR2(10) := 'OFF';
1095: cst_composite CONSTANT VARCHAR2(10) := 'COMPOSITE';
1096: v_derived_attendance_type igs_en_atd_type_all.attendance_type%TYPE;
1097: v_derived_attendance_mode VARCHAR2(10); -- Used only in case of Derived Profile. Holds values On, Off, and Composite.
1098: v_derived_govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE;
1099: v_derived_prog_att_mode igs_en_atd_mode_all.attendance_mode%TYPE; -- Used in Nominated Profile. Holds value of AM associated at Prog Attempt.
1100: v_on_att_mode BOOLEAN := FALSE;
1101: v_off_att_mode BOOLEAN := FALSE;
1102: v_composite_att_mode BOOLEAN := FALSE;

Line 1099: v_derived_prog_att_mode igs_en_atd_mode_all.attendance_mode%TYPE; -- Used in Nominated Profile. Holds value of AM associated at Prog Attempt.

1095: cst_composite CONSTANT VARCHAR2(10) := 'COMPOSITE';
1096: v_derived_attendance_type igs_en_atd_type_all.attendance_type%TYPE;
1097: v_derived_attendance_mode VARCHAR2(10); -- Used only in case of Derived Profile. Holds values On, Off, and Composite.
1098: v_derived_govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE;
1099: v_derived_prog_att_mode igs_en_atd_mode_all.attendance_mode%TYPE; -- Used in Nominated Profile. Holds value of AM associated at Prog Attempt.
1100: v_on_att_mode BOOLEAN := FALSE;
1101: v_off_att_mode BOOLEAN := FALSE;
1102: v_composite_att_mode BOOLEAN := FALSE;
1103: TYPE derived_values_rec IS RECORD ( course_cd igs_ps_ver_all.course_cd%TYPE,

Line 1112: govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE,

1108:
1109: -- record type variable defined for geeting the attendance type and govt attendance mode when the
1110: -- nominated values are used
1111: TYPE l_der_nom_rec IS RECORD ( attendance_type igs_en_atd_type_all.attendance_type%TYPE,
1112: govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE,
1113: prog_att_mode igs_en_atd_mode_all.attendance_mode%TYPE);
1114: TYPE l_der_nom_ref IS REF CURSOR RETURN l_der_nom_rec;
1115: l_v_prg_liabale VARCHAR2(10);
1116: c_att_md_ty l_der_nom_ref;

Line 1113: prog_att_mode igs_en_atd_mode_all.attendance_mode%TYPE);

1109: -- record type variable defined for geeting the attendance type and govt attendance mode when the
1110: -- nominated values are used
1111: TYPE l_der_nom_rec IS RECORD ( attendance_type igs_en_atd_type_all.attendance_type%TYPE,
1112: govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE,
1113: prog_att_mode igs_en_atd_mode_all.attendance_mode%TYPE);
1114: TYPE l_der_nom_ref IS REF CURSOR RETURN l_der_nom_rec;
1115: l_v_prg_liabale VARCHAR2(10);
1116: c_att_md_ty l_der_nom_ref;
1117: l_c_att_md_ty c_att_md_ty%ROWTYPE;

Line 1184: igs_en_atd_mode_all b

1180: OPEN c_att_md_ty FOR SELECT a.attendance_type,
1181: b.govt_attendance_mode,
1182: a.attendance_mode
1183: FROM igs_en_spa_terms a,
1184: igs_en_atd_mode_all b
1185: WHERE a.person_id = p_person_id
1186: AND a.term_cal_type = g_v_load_cal_type
1187: AND a.term_sequence_number = g_n_load_seq_num
1188: AND b.attendance_mode = a.attendance_mode

Line 1195: igs_en_atd_mode_all b

1191: OPEN c_att_md_ty FOR SELECT a.attendance_type,
1192: b.govt_attendance_mode,
1193: a.attendance_mode
1194: FROM igs_en_spa_terms a,
1195: igs_en_atd_mode_all b
1196: WHERE a.person_id = p_person_id
1197: AND a.program_cd = p_course_cd
1198: AND a.term_cal_type = g_v_load_cal_type
1199: AND a.term_sequence_number = g_n_load_seq_num

Line 1531: v_derived_govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE;

1527: v_class_standing igs_fi_fee_as_rate.class_standing%TYPE;
1528: v_cfar_chg_rate IGS_FI_FEE_AS_RT.chg_rate%TYPE;
1529: v_derived_location_cd igs_fi_fee_as_rate.location_cd%TYPE;
1530: v_derived_attendance_type igs_fi_fee_as_rate.attendance_type%TYPE;
1531: v_derived_govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE;
1532: l_v_derived_prog_att_mode igs_en_atd_mode_all.attendance_mode%TYPE;
1533:
1534: v_derived_residency_status_cd igs_fi_fee_as_rate.residency_status_cd%TYPE;
1535: v_derived_org_unit_cd hz_parties.party_number%TYPE;

Line 1532: l_v_derived_prog_att_mode igs_en_atd_mode_all.attendance_mode%TYPE;

1528: v_cfar_chg_rate IGS_FI_FEE_AS_RT.chg_rate%TYPE;
1529: v_derived_location_cd igs_fi_fee_as_rate.location_cd%TYPE;
1530: v_derived_attendance_type igs_fi_fee_as_rate.attendance_type%TYPE;
1531: v_derived_govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE;
1532: l_v_derived_prog_att_mode igs_en_atd_mode_all.attendance_mode%TYPE;
1533:
1534: v_derived_residency_status_cd igs_fi_fee_as_rate.residency_status_cd%TYPE;
1535: v_derived_org_unit_cd hz_parties.party_number%TYPE;
1536: v_derived_class_standing igs_fi_fee_as_rate.class_standing%TYPE;

Line 1636: cp_govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE) IS

1632: -- Derived, Derived Govt AM is compared against Govt AM mapped to Rate's AM.
1633: CURSOR c_cfar ( cp_location_cd igs_fi_fee_as_rate.location_cd%TYPE,
1634: cp_attendance_type igs_fi_fee_as_rate.attendance_type%TYPE,
1635: cp_prog_att_mode igs_fi_fee_as_rate.attendance_mode%TYPE,
1636: cp_govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE) IS
1637: SELECT cfar.lower_nrml_rate_ovrd_ind,
1638: cfar.chg_rate
1639: FROM igs_fi_fee_as_rt cfar,
1640: igs_en_atd_mode_all am

Line 1640: igs_en_atd_mode_all am

1636: cp_govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE) IS
1637: SELECT cfar.lower_nrml_rate_ovrd_ind,
1638: cfar.chg_rate
1639: FROM igs_fi_fee_as_rt cfar,
1640: igs_en_atd_mode_all am
1641: WHERE cfar.person_id = p_person_id AND
1642: cfar.course_cd = p_course_cd AND
1643: cfar.FEE_TYPE = p_fee_type AND
1644: NVL(cfar.location_cd, cp_location_cd) = cp_location_cd AND

Line 1656: CURSOR c_am (cp_attendance_mode igs_en_atd_mode_all.attendance_mode%TYPE) IS

1652: TRUNC(p_effective_dt) >= TRUNC(cfar.start_dt) AND
1653: (cfar.end_dt IS NULL OR
1654: TRUNC(p_effective_dt) <= TRUNC(cfar.end_dt));
1655:
1656: CURSOR c_am (cp_attendance_mode igs_en_atd_mode_all.attendance_mode%TYPE) IS
1657: SELECT am.GOVT_ATTENDANCE_MODE
1658: FROM igs_en_atd_mode_all am
1659: WHERE am.ATTENDANCE_MODE = cp_attendance_mode;
1660:

Line 1658: FROM igs_en_atd_mode_all am

1654: TRUNC(p_effective_dt) <= TRUNC(cfar.end_dt));
1655:
1656: CURSOR c_am (cp_attendance_mode igs_en_atd_mode_all.attendance_mode%TYPE) IS
1657: SELECT am.GOVT_ATTENDANCE_MODE
1658: FROM igs_en_atd_mode_all am
1659: WHERE am.ATTENDANCE_MODE = cp_attendance_mode;
1660:
1661: -- To find the organization unit code from the Student Attempt Table (For Charge Method of
1662: -- FLATRATE)

Line 1692: p_derived_govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%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,

Line 1693: p_derived_prog_att_mode igs_en_atd_mode_all.attendance_mode%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,

Line 1737: v_rate_govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE;

1733: -- Attempt to match assessment rate attributes with student IGS_PS_COURSE attempt.
1734: -- The order of precedence ensures the first
1735: -- match found is the desired charge rate.
1736: DECLARE
1737: v_rate_govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE;
1738: CURSOR c_am IS
1739: SELECT am.govt_attendance_mode
1740: FROM igs_en_atd_mode_all am
1741: WHERE am.attendance_mode = p_rate_attendance_mode;

Line 1740: FROM igs_en_atd_mode_all am

1736: DECLARE
1737: v_rate_govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE;
1738: CURSOR c_am IS
1739: SELECT am.govt_attendance_mode
1740: FROM igs_en_atd_mode_all am
1741: WHERE am.attendance_mode = p_rate_attendance_mode;
1742:
1743: BEGIN
1744: log_to_fnd( p_v_module => 'finpl_ins_match_chg_rate',

Line 1918: p_derived_govt_att_mode OUT NOCOPY igs_en_atd_mode_all.govt_attendance_mode%TYPE,

1914: p_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
1915: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%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,

Line 1919: p_derived_prog_att_mode OUT NOCOPY igs_en_atd_mode_all.attendance_mode%TYPE, -- Added as part of 3795849

1915: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%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,

Line 1950: v_derived_govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE;

1946: cst_composite CONSTANT VARCHAR2(10) := 'COMPOSITE';
1947: v_total_period_load NUMBER;
1948: v_derived_attendance_type igs_en_atd_type_all.attendance_type%TYPE;
1949: v_derived_attendance_mode VARCHAR2(10); -- Used only in case of Derived Profile. Holds values On, Off, and Composite.
1950: v_derived_govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE;
1951: v_derived_prog_att_mode igs_en_atd_mode_all.attendance_mode%TYPE; -- Used in Nominated Profile. Holds value of AM associated at Prog Attempt.
1952: v_trigger_fired fnd_lookup_values.lookup_code%TYPE;
1953: v_count NUMBER(5);
1954: v_on_att_mode BOOLEAN := FALSE;

Line 1951: v_derived_prog_att_mode igs_en_atd_mode_all.attendance_mode%TYPE; -- Used in Nominated Profile. Holds value of AM associated at Prog Attempt.

1947: v_total_period_load NUMBER;
1948: v_derived_attendance_type igs_en_atd_type_all.attendance_type%TYPE;
1949: v_derived_attendance_mode VARCHAR2(10); -- Used only in case of Derived Profile. Holds values On, Off, and Composite.
1950: v_derived_govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE;
1951: v_derived_prog_att_mode igs_en_atd_mode_all.attendance_mode%TYPE; -- Used in Nominated Profile. Holds value of AM associated at Prog Attempt.
1952: v_trigger_fired fnd_lookup_values.lookup_code%TYPE;
1953: v_count NUMBER(5);
1954: v_on_att_mode BOOLEAN := FALSE;
1955: v_off_att_mode BOOLEAN := FALSE;

Line 1976: govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE,

1972:
1973: -- record type variable defined for geeting the attendance type and govt attendance mode when the
1974: -- nominated values are used
1975: TYPE l_der_nom_rec IS RECORD ( attendance_type igs_en_atd_type_all.attendance_type%TYPE,
1976: govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE,
1977: prog_att_mode igs_en_atd_mode_all.attendance_mode%TYPE);
1978: TYPE l_der_nom_ref IS REF CURSOR RETURN l_der_nom_rec;
1979:
1980: c_att_md_ty l_der_nom_ref;

Line 1977: prog_att_mode igs_en_atd_mode_all.attendance_mode%TYPE);

1973: -- record type variable defined for geeting the attendance type and govt attendance mode when the
1974: -- nominated values are used
1975: TYPE l_der_nom_rec IS RECORD ( attendance_type igs_en_atd_type_all.attendance_type%TYPE,
1976: govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE,
1977: prog_att_mode igs_en_atd_mode_all.attendance_mode%TYPE);
1978: TYPE l_der_nom_ref IS REF CURSOR RETURN l_der_nom_rec;
1979:
1980: c_att_md_ty l_der_nom_ref;
1981: l_c_att_md_ty c_att_md_ty%ROWTYPE;

Line 2026: igs_en_atd_mode_all b

2022: OPEN c_att_md_ty FOR SELECT a.attendance_type,
2023: b.govt_attendance_mode,
2024: a.attendance_mode
2025: FROM igs_en_spa_terms a,
2026: igs_en_atd_mode_all b
2027: WHERE a.person_id = p_person_id
2028: AND a.term_cal_type = g_v_load_cal_type
2029: AND a.term_sequence_number = g_n_load_seq_num
2030: AND b.attendance_mode = a.attendance_mode

Line 2037: igs_en_atd_mode_all b

2033: OPEN c_att_md_ty FOR SELECT a.attendance_type,
2034: b.govt_attendance_mode,
2035: a.attendance_mode
2036: FROM igs_en_spa_terms a,
2037: igs_en_atd_mode_all b
2038: WHERE a.person_id = p_person_id
2039: AND a.program_cd = p_course_cd
2040: AND a.term_cal_type = g_v_load_cal_type
2041: AND a.term_sequence_number = g_n_load_seq_num

Line 2384: p_derived_govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE,

2380: p_effective_dt DATE,
2381: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
2382: p_derived_location_cd igs_fi_fee_as_rate.location_cd%TYPE,
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,

Line 2385: p_derived_prog_att_mode igs_en_atd_mode_all.attendance_mode%TYPE,

2381: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
2382: p_derived_location_cd igs_fi_fee_as_rate.location_cd%TYPE,
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,