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_FI_F_CAT_FEE_LBL_ALL

Line 235: p_fee_category igs_fi_f_cat_fee_lbl_all.fee_cat%TYPE,

231: TYPE t_unit_status IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
232: TYPE t_date IS TABLE OF igs_en_su_attempt_all.enrolled_dt%TYPE INDEX BY BINARY_INTEGER;
233:
234: TYPE wav_fcfl_rec_type IS RECORD (
235: p_fee_category igs_fi_f_cat_fee_lbl_all.fee_cat%TYPE,
236: p_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
237: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
238: p_career igs_ps_ver_all.course_type%TYPE);
239:

Line 236: p_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,

232: TYPE t_date IS TABLE OF igs_en_su_attempt_all.enrolled_dt%TYPE INDEX BY BINARY_INTEGER;
233:
234: TYPE wav_fcfl_rec_type IS RECORD (
235: p_fee_category igs_fi_f_cat_fee_lbl_all.fee_cat%TYPE,
236: p_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
237: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
238: p_career igs_ps_ver_all.course_type%TYPE);
239:
240: TYPE wav_fcfl_tbl_type IS TABLE OF wav_fcfl_rec_type INDEX BY BINARY_INTEGER;

Line 351: p_fee_cal_type IN igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,

347:
348: FUNCTION finpl_get_derived_am_at (p_person_id IN hz_parties.party_id%TYPE,
349: p_course_cd IN igs_ps_course.course_cd%TYPE,
350: p_effective_dt IN DATE,
351: p_fee_cal_type IN igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
352: p_fee_ci_sequence_number IN igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
353: p_fee_type IN igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
354: p_s_fee_trigger_cat IN igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
355: p_trace_on IN VARCHAR2,

Line 352: p_fee_ci_sequence_number IN igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,

348: FUNCTION finpl_get_derived_am_at (p_person_id IN hz_parties.party_id%TYPE,
349: p_course_cd IN igs_ps_course.course_cd%TYPE,
350: p_effective_dt IN DATE,
351: p_fee_cal_type IN igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
352: p_fee_ci_sequence_number IN igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
353: p_fee_type IN igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
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,

Line 353: p_fee_type IN igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,

349: p_course_cd IN igs_ps_course.course_cd%TYPE,
350: p_effective_dt IN DATE,
351: p_fee_cal_type IN igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
352: p_fee_ci_sequence_number IN igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
353: p_fee_type IN igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
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,

Line 383: p_fee_type IN igs_fi_f_cat_fee_lbl_all.fee_type%TYPE ,

379: p_person_id IN hz_parties.party_id%TYPE ,
380: p_course_cd IN igs_en_stdnt_ps_att_all.course_cd%TYPE ,
381: p_course_version_number IN igs_en_stdnt_ps_att_all.version_number%TYPE ,
382: p_course_attempt_status IN VARCHAR2 ,
383: p_fee_type IN igs_fi_f_cat_fee_lbl_all.fee_type%TYPE ,
384: p_fee_cal_type IN igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE ,
385: p_fee_ci_sequence_number IN igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE ,
386: p_fee_cat IN IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE ,
387: p_s_fee_type IN igs_fi_fee_type_all.s_fee_type%TYPE ,

Line 384: p_fee_cal_type IN igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE ,

380: p_course_cd IN igs_en_stdnt_ps_att_all.course_cd%TYPE ,
381: p_course_version_number IN igs_en_stdnt_ps_att_all.version_number%TYPE ,
382: p_course_attempt_status IN VARCHAR2 ,
383: p_fee_type IN igs_fi_f_cat_fee_lbl_all.fee_type%TYPE ,
384: p_fee_cal_type IN igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE ,
385: p_fee_ci_sequence_number IN igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE ,
386: p_fee_cat IN IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE ,
387: p_s_fee_type IN igs_fi_fee_type_all.s_fee_type%TYPE ,
388: p_s_fee_trigger_cat IN VARCHAR2 ,

Line 385: p_fee_ci_sequence_number IN igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE ,

381: p_course_version_number IN igs_en_stdnt_ps_att_all.version_number%TYPE ,
382: p_course_attempt_status IN VARCHAR2 ,
383: p_fee_type IN igs_fi_f_cat_fee_lbl_all.fee_type%TYPE ,
384: p_fee_cal_type IN igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE ,
385: p_fee_ci_sequence_number IN igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE ,
386: p_fee_cat IN IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE ,
387: p_s_fee_type IN igs_fi_fee_type_all.s_fee_type%TYPE ,
388: p_s_fee_trigger_cat IN VARCHAR2 ,
389: p_rul_sequence_number IN igs_fi_f_cat_fee_lbl_all.rul_sequence_number%TYPE ,

Line 389: p_rul_sequence_number IN igs_fi_f_cat_fee_lbl_all.rul_sequence_number%TYPE ,

385: p_fee_ci_sequence_number IN igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE ,
386: p_fee_cat IN IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE ,
387: p_s_fee_type IN igs_fi_fee_type_all.s_fee_type%TYPE ,
388: p_s_fee_trigger_cat IN VARCHAR2 ,
389: p_rul_sequence_number IN igs_fi_f_cat_fee_lbl_all.rul_sequence_number%TYPE ,
390: p_charge_method IN igs_fi_f_typ_ca_inst_all.s_chg_method_type%TYPE ,
391: p_location_cd IN VARCHAR2 ,
392: p_attendance_type IN VARCHAR2 ,
393: p_attendance_mode IN VARCHAR2 ,

Line 1074: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,

1070: FUNCTION finpl_get_derived_am_at (
1071: p_person_id hz_parties.party_id%TYPE,
1072: p_course_cd IGS_PS_COURSE.course_cd%TYPE,
1073: p_effective_dt DATE,
1074: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
1075: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
1076: p_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
1077: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
1078: p_trace_on VARCHAR2,

Line 1075: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,

1071: p_person_id hz_parties.party_id%TYPE,
1072: p_course_cd IGS_PS_COURSE.course_cd%TYPE,
1073: p_effective_dt DATE,
1074: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
1075: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
1076: p_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
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,

Line 1076: p_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,

1072: p_course_cd IGS_PS_COURSE.course_cd%TYPE,
1073: p_effective_dt DATE,
1074: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
1075: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
1076: p_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
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,

Line 1451: p_fee_type IN igs_fi_f_cat_fee_lbl_all.fee_type%TYPE ,

1447: p_person_id IN hz_parties.party_id%TYPE ,
1448: p_course_cd IN igs_en_stdnt_ps_att_all.course_cd%TYPE ,
1449: p_course_version_number IN igs_en_stdnt_ps_att_all.version_number%TYPE ,
1450: p_course_attempt_status IN VARCHAR2 ,
1451: p_fee_type IN igs_fi_f_cat_fee_lbl_all.fee_type%TYPE ,
1452: p_fee_cal_type IN igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE ,
1453: p_fee_ci_sequence_number IN igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE ,
1454: p_fee_cat IN IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE ,
1455: p_s_fee_type IN igs_fi_fee_type_all.s_fee_type%TYPE ,

Line 1452: p_fee_cal_type IN igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE ,

1448: p_course_cd IN igs_en_stdnt_ps_att_all.course_cd%TYPE ,
1449: p_course_version_number IN igs_en_stdnt_ps_att_all.version_number%TYPE ,
1450: p_course_attempt_status IN VARCHAR2 ,
1451: p_fee_type IN igs_fi_f_cat_fee_lbl_all.fee_type%TYPE ,
1452: p_fee_cal_type IN igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE ,
1453: p_fee_ci_sequence_number IN igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE ,
1454: p_fee_cat IN IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE ,
1455: p_s_fee_type IN igs_fi_fee_type_all.s_fee_type%TYPE ,
1456: p_s_fee_trigger_cat IN VARCHAR2 ,

Line 1453: p_fee_ci_sequence_number IN igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE ,

1449: p_course_version_number IN igs_en_stdnt_ps_att_all.version_number%TYPE ,
1450: p_course_attempt_status IN VARCHAR2 ,
1451: p_fee_type IN igs_fi_f_cat_fee_lbl_all.fee_type%TYPE ,
1452: p_fee_cal_type IN igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE ,
1453: p_fee_ci_sequence_number IN igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE ,
1454: p_fee_cat IN IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE ,
1455: p_s_fee_type IN igs_fi_fee_type_all.s_fee_type%TYPE ,
1456: p_s_fee_trigger_cat IN VARCHAR2 ,
1457: p_rul_sequence_number IN igs_fi_f_cat_fee_lbl_all.rul_sequence_number%TYPE ,

Line 1457: p_rul_sequence_number IN igs_fi_f_cat_fee_lbl_all.rul_sequence_number%TYPE ,

1453: p_fee_ci_sequence_number IN igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE ,
1454: p_fee_cat IN IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE ,
1455: p_s_fee_type IN igs_fi_fee_type_all.s_fee_type%TYPE ,
1456: p_s_fee_trigger_cat IN VARCHAR2 ,
1457: p_rul_sequence_number IN igs_fi_f_cat_fee_lbl_all.rul_sequence_number%TYPE ,
1458: p_charge_method IN igs_fi_f_typ_ca_inst_all.s_chg_method_type%TYPE ,
1459: p_location_cd IN VARCHAR2 ,
1460: p_attendance_type IN VARCHAR2 ,
1461: p_attendance_mode IN VARCHAR2 ,

Line 1912: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,

1908: FUNCTION finpl_get_derived_values (
1909: p_person_id hz_parties.party_id%TYPE,
1910: p_course_cd IGS_PS_COURSE.course_cd%TYPE,
1911: p_effective_dt DATE,
1912: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
1913: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%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,

Line 1913: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,

1909: p_person_id hz_parties.party_id%TYPE,
1910: p_course_cd IGS_PS_COURSE.course_cd%TYPE,
1911: p_effective_dt DATE,
1912: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
1913: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%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,

Line 1914: p_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,

1910: p_course_cd IGS_PS_COURSE.course_cd%TYPE,
1911: p_effective_dt DATE,
1912: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
1913: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%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,

Line 2376: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,

2372: PROCEDURE finpl_find_far(
2373: p_person_id hz_parties.party_id%TYPE,
2374: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
2375: p_fee_cat IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE,
2376: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
2377: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
2378: p_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
2379: p_location_cd igs_en_stdnt_ps_att_all.location_cd%TYPE,
2380: p_effective_dt DATE,

Line 2377: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,

2373: p_person_id hz_parties.party_id%TYPE,
2374: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
2375: p_fee_cat IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE,
2376: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
2377: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
2378: p_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
2379: p_location_cd igs_en_stdnt_ps_att_all.location_cd%TYPE,
2380: p_effective_dt DATE,
2381: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,

Line 2378: p_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,

2374: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
2375: p_fee_cat IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE,
2376: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
2377: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
2378: p_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
2379: p_location_cd igs_en_stdnt_ps_att_all.location_cd%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,

Line 2459: igs_fi_f_cat_fee_lbl_all fcfl

2455: far.unit_cd,
2456: far.unit_version_number,
2457: far.unit_level
2458: FROM igs_fi_fee_as_rate far,
2459: igs_fi_f_cat_fee_lbl_all fcfl
2460: WHERE far.s_relation_type = cp_v_s_relation_type
2461: AND far.logical_delete_dt is NULL
2462: AND fcfl.fee_cat = far.fee_cat
2463: AND fcfl.fee_cal_type = far.fee_cal_type

Line 2493: igs_fi_f_cat_fee_lbl_all fcfl

2489: far.unit_cd,
2490: far.unit_version_number,
2491: far.unit_level
2492: FROM igs_fi_fee_as_rate far,
2493: igs_fi_f_cat_fee_lbl_all fcfl
2494: WHERE far.s_relation_type = cp_v_s_relation_type
2495: AND far.logical_delete_dt is NULL
2496: AND fcfl.fee_type = far.fee_type
2497: AND fcfl.fee_cal_type = far.fee_cal_type

Line 5647: p_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,

5643:
5644: PROCEDURE finpl_ins_fee_ass(
5645: p_person_id hz_parties.party_id%TYPE,
5646: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
5647: p_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
5648: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
5649: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
5650: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
5651: p_fee_cat igs_en_stdnt_ps_att_all.fee_cat%TYPE,

Line 5648: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,

5644: PROCEDURE finpl_ins_fee_ass(
5645: p_person_id hz_parties.party_id%TYPE,
5646: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
5647: p_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
5648: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
5649: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
5650: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
5651: p_fee_cat igs_en_stdnt_ps_att_all.fee_cat%TYPE,
5652: p_currency igs_fi_control_all.currency_cd%TYPE,

Line 5649: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,

5645: p_person_id hz_parties.party_id%TYPE,
5646: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
5647: p_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
5648: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
5649: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
5650: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
5651: p_fee_cat igs_en_stdnt_ps_att_all.fee_cat%TYPE,
5652: p_currency igs_fi_control_all.currency_cd%TYPE,
5653: p_charge_rate igs_fi_fee_as_rate.chg_rate%TYPE,

Line 5664: p_fcfl_status IN igs_fi_f_cat_fee_lbl_all.fee_liability_status%TYPE,

5660: p_attendance_type igs_fi_fee_as_items.attendance_type%TYPE,
5661: p_charge_elements IN OUT NOCOPY Igs_fi_fee_as_all.chg_elements%TYPE,
5662: p_fee_assessment IN OUT NOCOPY NUMBER,
5663: -- Added to initialize the new pl/sql table for Institution related records
5664: p_fcfl_status IN igs_fi_f_cat_fee_lbl_all.fee_liability_status%TYPE,
5665: p_n_rul_sequence_number IN igs_fi_fee_as_items.rul_sequence_number%TYPE,
5666: p_n_scope_rul_seq_num IN igs_fi_fee_as_items.scope_rul_sequence_num%TYPE,
5667: p_v_chg_method_type IN igs_fi_fee_as_items.s_chg_method_type%TYPE,
5668: p_v_location_cd IN igs_fi_fee_as_items.location_cd%TYPE,

Line 5740: l_v_chg_mthd_typ igs_fi_f_cat_fee_lbl_all.s_chg_method_type%TYPE;

5736: v_rec_found BOOLEAN;
5737: l_v_invoice_number igs_fi_inv_int_all.invoice_number%TYPE;
5738: l_b_charge_declined BOOLEAN;
5739: l_v_elm_rng_ord_name igs_fi_f_typ_ca_inst_all.elm_rng_order_name%TYPE;
5740: l_v_chg_mthd_typ igs_fi_f_cat_fee_lbl_all.s_chg_method_type%TYPE;
5741: l_v_invoice_num igs_fi_inv_int_all.invoice_number%TYPE;
5742: l_n_waiver_amt NUMBER;
5743:
5744: CURSOR c_chg_method ( cp_fee_cat igs_fi_f_cat_fee_lbl_all.fee_cat%TYPE,

Line 5744: CURSOR c_chg_method ( cp_fee_cat igs_fi_f_cat_fee_lbl_all.fee_cat%TYPE,

5740: l_v_chg_mthd_typ igs_fi_f_cat_fee_lbl_all.s_chg_method_type%TYPE;
5741: l_v_invoice_num igs_fi_inv_int_all.invoice_number%TYPE;
5742: l_n_waiver_amt NUMBER;
5743:
5744: CURSOR c_chg_method ( cp_fee_cat igs_fi_f_cat_fee_lbl_all.fee_cat%TYPE,
5745: cp_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
5746: cp_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
5747: cp_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE) IS
5748: SELECT s_chg_method_type, elm_rng_order_name

Line 5745: cp_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,

5741: l_v_invoice_num igs_fi_inv_int_all.invoice_number%TYPE;
5742: l_n_waiver_amt NUMBER;
5743:
5744: CURSOR c_chg_method ( cp_fee_cat igs_fi_f_cat_fee_lbl_all.fee_cat%TYPE,
5745: cp_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
5746: cp_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
5747: cp_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE) IS
5748: SELECT s_chg_method_type, elm_rng_order_name
5749: FROM igs_fi_f_cat_fee_lbl_v

Line 5746: cp_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,

5742: l_n_waiver_amt NUMBER;
5743:
5744: CURSOR c_chg_method ( cp_fee_cat igs_fi_f_cat_fee_lbl_all.fee_cat%TYPE,
5745: cp_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
5746: cp_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
5747: cp_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE) IS
5748: SELECT s_chg_method_type, elm_rng_order_name
5749: FROM igs_fi_f_cat_fee_lbl_v
5750: WHERE fee_cat = cp_fee_cat

Line 5747: cp_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE) IS

5743:
5744: CURSOR c_chg_method ( cp_fee_cat igs_fi_f_cat_fee_lbl_all.fee_cat%TYPE,
5745: cp_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
5746: cp_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
5747: cp_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE) IS
5748: SELECT s_chg_method_type, elm_rng_order_name
5749: FROM igs_fi_f_cat_fee_lbl_v
5750: WHERE fee_cat = cp_fee_cat
5751: AND fee_type = cp_fee_type

Line 6699: p_charge_method igs_fi_f_cat_fee_lbl_all.s_chg_method_type%TYPE,

6695: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
6696: p_course_version_number igs_en_stdnt_ps_att_all.version_number%TYPE,
6697: p_attendance_type igs_en_stdnt_ps_att_all.ATTENDANCE_TYPE%TYPE,
6698: p_course_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
6699: p_charge_method igs_fi_f_cat_fee_lbl_all.s_chg_method_type%TYPE,
6700: p_fee_cat IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE,
6701: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
6702: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
6703: p_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,

Line 6701: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,

6697: p_attendance_type igs_en_stdnt_ps_att_all.ATTENDANCE_TYPE%TYPE,
6698: p_course_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
6699: p_charge_method igs_fi_f_cat_fee_lbl_all.s_chg_method_type%TYPE,
6700: p_fee_cat IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE,
6701: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
6702: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
6703: p_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
6704: p_s_fee_type igs_fi_fee_type_all.s_fee_type%TYPE,
6705: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,

Line 6702: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,

6698: p_course_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
6699: p_charge_method igs_fi_f_cat_fee_lbl_all.s_chg_method_type%TYPE,
6700: p_fee_cat IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE,
6701: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
6702: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
6703: p_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
6704: p_s_fee_type igs_fi_fee_type_all.s_fee_type%TYPE,
6705: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
6706: p_charge_elements IN OUT NOCOPY igs_fi_fee_as_all.chg_elements%TYPE,

Line 6703: p_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,

6699: p_charge_method igs_fi_f_cat_fee_lbl_all.s_chg_method_type%TYPE,
6700: p_fee_cat IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE,
6701: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
6702: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
6703: p_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
6704: p_s_fee_type igs_fi_fee_type_all.s_fee_type%TYPE,
6705: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
6706: p_charge_elements IN OUT NOCOPY igs_fi_fee_as_all.chg_elements%TYPE,
6707: p_message_name OUT NOCOPY VARCHAR2,

Line 7947: ) AND (ast.fee_type,NVL(ast.fee_cat,cp_fee_cat)) NOT IN (SELECT fee_type,fee_cat FROM igs_fi_f_cat_fee_lbl_all

7943: )
7944: ))
7945: OR
7946: (g_c_fee_calc_mthd = g_v_primary_career)
7947: ) AND (ast.fee_type,NVL(ast.fee_cat,cp_fee_cat)) NOT IN (SELECT fee_type,fee_cat FROM igs_fi_f_cat_fee_lbl_all
7948: WHERE fee_cat = cp_fee_cat
7949: AND fee_cal_type = ast.fee_cal_type
7950: AND fee_ci_sequence_number = ast.fee_ci_sequence_number
7951: AND fee_type = ast.fee_type);

Line 7989: CURSOR cur_fcfl (cp_v_fee_cat igs_fi_f_cat_fee_lbl_all.fee_cat%TYPE,

7985: (spt.program_cd <> p_course_cd AND g_c_fee_calc_mthd = g_v_program) OR
7986: (ps.course_type <> p_c_career AND g_c_fee_calc_mthd = g_v_career)
7987: );
7988:
7989: CURSOR cur_fcfl (cp_v_fee_cat igs_fi_f_cat_fee_lbl_all.fee_cat%TYPE,
7990: cp_v_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
7991: cp_n_fee_ci_seq_num igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
7992: cp_v_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE) IS
7993: SELECT fee_cat, fee_type

Line 7990: cp_v_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,

7986: (ps.course_type <> p_c_career AND g_c_fee_calc_mthd = g_v_career)
7987: );
7988:
7989: CURSOR cur_fcfl (cp_v_fee_cat igs_fi_f_cat_fee_lbl_all.fee_cat%TYPE,
7990: cp_v_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
7991: cp_n_fee_ci_seq_num igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
7992: cp_v_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE) IS
7993: SELECT fee_cat, fee_type
7994: FROM igs_fi_f_cat_fee_lbl_all

Line 7991: cp_n_fee_ci_seq_num igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,

7987: );
7988:
7989: CURSOR cur_fcfl (cp_v_fee_cat igs_fi_f_cat_fee_lbl_all.fee_cat%TYPE,
7990: cp_v_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
7991: cp_n_fee_ci_seq_num igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
7992: cp_v_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE) IS
7993: SELECT fee_cat, fee_type
7994: FROM igs_fi_f_cat_fee_lbl_all
7995: WHERE fee_cal_type = cp_v_fee_cal_type

Line 7992: cp_v_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE) IS

7988:
7989: CURSOR cur_fcfl (cp_v_fee_cat igs_fi_f_cat_fee_lbl_all.fee_cat%TYPE,
7990: cp_v_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
7991: cp_n_fee_ci_seq_num igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
7992: cp_v_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE) IS
7993: SELECT fee_cat, fee_type
7994: FROM igs_fi_f_cat_fee_lbl_all
7995: WHERE fee_cal_type = cp_v_fee_cal_type
7996: AND fee_ci_sequence_number = cp_n_fee_ci_seq_num

Line 7994: FROM igs_fi_f_cat_fee_lbl_all

7990: cp_v_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
7991: cp_n_fee_ci_seq_num igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
7992: cp_v_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE) IS
7993: SELECT fee_cat, fee_type
7994: FROM igs_fi_f_cat_fee_lbl_all
7995: WHERE fee_cal_type = cp_v_fee_cal_type
7996: AND fee_ci_sequence_number = cp_n_fee_ci_seq_num
7997: AND fee_type = cp_v_fee_type;
7998: