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_FEE_TYPE_ALL

Line 354: p_s_fee_trigger_cat IN igs_fi_fee_type_all.s_fee_trigger_cat%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,
358: p_derived_att_mode OUT NOCOPY igs_en_atd_mode_all.govt_attendance_mode%TYPE) RETURN BOOLEAN;

Line 373: p_v_fee_type_desc IN igs_fi_fee_type_all.description%TYPE,

369: p_v_fee_cat IN igs_fi_inv_int_all.fee_cat%TYPE,
370: p_d_gl_date IN igs_fi_invln_int_all.gl_date%TYPE,
371: p_n_uoo_id IN igs_fi_invln_int_all.uoo_id%TYPE,
372: p_n_amount IN igs_fi_inv_int_all.invoice_amount%TYPE,
373: p_v_fee_type_desc IN igs_fi_fee_type_all.description%TYPE,
374: p_v_fee_trig_cat IN igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
375: p_trace_on IN VARCHAR2);
376:
377: FUNCTION finp_clc_ass_amnt(

Line 374: p_v_fee_trig_cat IN igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,

370: p_d_gl_date IN igs_fi_invln_int_all.gl_date%TYPE,
371: p_n_uoo_id IN igs_fi_invln_int_all.uoo_id%TYPE,
372: p_n_amount IN igs_fi_inv_int_all.invoice_amount%TYPE,
373: p_v_fee_type_desc IN igs_fi_fee_type_all.description%TYPE,
374: p_v_fee_trig_cat IN igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
375: p_trace_on IN VARCHAR2);
376:
377: FUNCTION finp_clc_ass_amnt(
378: p_effective_dt IN DATE ,

Line 387: p_s_fee_type IN igs_fi_fee_type_all.s_fee_type%TYPE ,

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 ,
390: p_charge_method IN igs_fi_f_typ_ca_inst_all.s_chg_method_type%TYPE ,
391: p_location_cd IN VARCHAR2 ,

Line 457: p_v_s_fee_trigger_cat IN igs_fi_fee_type_all.s_fee_trigger_cat%TYPE ) RETURN VARCHAR2 AS

453: END get_stdnt_res_status_cd;
454:
455: FUNCTION get_stdnt_class_standing ( p_n_person_id IN igs_en_stdnt_ps_att_all.person_id%TYPE,
456: p_v_course_cd IN igs_ps_ver_all.course_cd%TYPE,
457: p_v_s_fee_trigger_cat IN igs_fi_fee_type_all.s_fee_trigger_cat%TYPE ) RETURN VARCHAR2 AS
458: /*************************************************************
459: Created By : Shirish Tatikonda
460: Date Created By : 30-DEC-2003
461: Purpose : To derive Student Class Standing

Line 531: p_v_s_fee_trigger_cat IN igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,

527: END get_stdnt_class_standing;
528:
529: PROCEDURE get_stdnt_unit_set_dtls ( p_n_person_id IN igs_en_stdnt_ps_att_all.person_id%TYPE,
530: p_v_course_cd IN igs_ps_ver_all.course_cd%TYPE,
531: p_v_s_fee_trigger_cat IN igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
532: p_v_unit_set_cd OUT NOCOPY igs_as_su_setatmpt.unit_set_cd%TYPE,
533: p_n_unit_set_ver_num OUT NOCOPY igs_as_su_setatmpt.us_version_number%TYPE ) AS
534: /*************************************************************
535: Created By : Shirish Tatikonda

Line 858: p_v_fee_type_desc igs_fi_fee_type_all.description%TYPE,

854: p_d_gl_date igs_fi_invln_int_all.gl_date%TYPE,
855: p_n_diff_amount NUMBER,
856: p_v_retention_level igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE,
857: p_v_cmp_withdr_ret igs_fi_f_typ_ca_inst_all.complete_ret_flag%TYPE,
858: p_v_fee_type_desc igs_fi_fee_type_all.description%TYPE,
859: p_v_fee_trig_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE
860: ) AS
861: /*************************************************************
862: Created By : Bhaskar Annamalai

Line 859: p_v_fee_trig_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE

855: p_n_diff_amount NUMBER,
856: p_v_retention_level igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE,
857: p_v_cmp_withdr_ret igs_fi_f_typ_ca_inst_all.complete_ret_flag%TYPE,
858: p_v_fee_type_desc igs_fi_fee_type_all.description%TYPE,
859: p_v_fee_trig_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE
860: ) AS
861: /*************************************************************
862: Created By : Bhaskar Annamalai
863: Date Created By : 20-JUN-2005

Line 1077: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%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,
1081: p_derived_att_mode OUT NOCOPY igs_en_atd_mode_all.govt_attendance_mode%TYPE) RETURN BOOLEAN AS

Line 1455: p_s_fee_type IN igs_fi_fee_type_all.s_fee_type%TYPE ,

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 ,
1458: p_charge_method IN igs_fi_f_typ_ca_inst_all.s_chg_method_type%TYPE ,
1459: p_location_cd IN VARCHAR2 ,

Line 1578: FROM igs_fi_fee_type_all

1574:
1575: /**Cursor to get fee type description**/
1576: CURSOR c_fee_type( cp_fee_type IGS_FI_FEE_AS_ITEMS.FEE_TYPE%TYPE ) IS
1577: SELECT description
1578: FROM igs_fi_fee_type_all
1579: WHERE fee_type = cp_fee_type;
1580:
1581: v_fee_type_description igs_fi_fee_type_all.description%TYPE;
1582:

Line 1581: v_fee_type_description igs_fi_fee_type_all.description%TYPE;

1577: SELECT description
1578: FROM igs_fi_fee_type_all
1579: WHERE fee_type = cp_fee_type;
1580:
1581: v_fee_type_description igs_fi_fee_type_all.description%TYPE;
1582:
1583: -- Cursor to find all rates defined under element range found in above cursor.
1584: CURSOR c_elm_rng_rates ( cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
1585: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,

Line 1915: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%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,
1919: p_derived_prog_att_mode OUT NOCOPY igs_en_atd_mode_all.attendance_mode%TYPE, -- Added as part of 3795849

Line 1983: CURSOR cur_fee_type(cp_v_fee_type igs_fi_fee_type_all.fee_type%TYPE) IS

1979:
1980: c_att_md_ty l_der_nom_ref;
1981: l_c_att_md_ty c_att_md_ty%ROWTYPE;
1982:
1983: CURSOR cur_fee_type(cp_v_fee_type igs_fi_fee_type_all.fee_type%TYPE) IS
1984: SELECT s_fee_type
1985: FROM igs_fi_fee_type_all
1986: WHERE fee_type = cp_v_fee_type;
1987:

Line 1985: FROM igs_fi_fee_type_all

1981: l_c_att_md_ty c_att_md_ty%ROWTYPE;
1982:
1983: CURSOR cur_fee_type(cp_v_fee_type igs_fi_fee_type_all.fee_type%TYPE) IS
1984: SELECT s_fee_type
1985: FROM igs_fi_fee_type_all
1986: WHERE fee_type = cp_v_fee_type;
1987:
1988: l_v_s_fee_type igs_fi_fee_type_all.s_fee_type%TYPE := NULL;
1989: l_n_cr_points igs_en_su_attempt_all.override_achievable_cp%TYPE;

Line 1988: l_v_s_fee_type igs_fi_fee_type_all.s_fee_type%TYPE := NULL;

1984: SELECT s_fee_type
1985: FROM igs_fi_fee_type_all
1986: WHERE fee_type = cp_v_fee_type;
1987:
1988: l_v_s_fee_type igs_fi_fee_type_all.s_fee_type%TYPE := NULL;
1989: l_n_cr_points igs_en_su_attempt_all.override_achievable_cp%TYPE;
1990: l_n_fte igs_en_su_attempt_all.override_achievable_cp%TYPE;
1991:
1992: BEGIN

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

Line 4517: p_fee_type IN IGS_FI_FEE_TYPE_ALL.FEE_TYPE%TYPE ,

4513: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
4514: p_fee_category IN IGS_EN_STDNT_PS_ATT_ALL.FEE_CAT%TYPE ,
4515: p_fee_cal_type IN IGS_CA_INST_ALL.CAL_TYPE%TYPE ,
4516: p_fee_ci_sequence_num IN IGS_CA_INST_ALL.sequence_number%TYPE ,
4517: p_fee_type IN IGS_FI_FEE_TYPE_ALL.FEE_TYPE%TYPE ,
4518: p_trace_on IN VARCHAR2 ,
4519: p_test_run IN VARCHAR2 ,
4520: p_creation_dt IN OUT NOCOPY DATE ,
4521: p_message_name OUT NOCOPY VARCHAR2,

Line 4766: TYPE t_fee_type_typ IS TABLE OF igs_fi_fee_type_all.fee_type%TYPE INDEX BY BINARY_INTEGER;

4762:
4763: l_v_person_name hz_parties.party_name%TYPE;
4764: l_v_currency_cd igs_fi_fee_cat_all.currency_cd%TYPE;
4765:
4766: TYPE t_fee_type_typ IS TABLE OF igs_fi_fee_type_all.fee_type%TYPE INDEX BY BINARY_INTEGER;
4767: tbl_fee_type t_fee_type_typ;
4768: l_b_found BOOLEAN;
4769: l_n_waiver_amount NUMBER;
4770: l_v_return_status VARCHAR2(10);

Line 4835: FROM igs_fi_fee_type_all

4831: v_message_name VARCHAR2(30);
4832: lv_record_found boolean := FALSE;
4833: CURSOR c_fee_type( cp_fee_type IGS_FI_FEE_AS_ITEMS.FEE_TYPE%TYPE ) IS
4834: SELECT description, s_fee_trigger_cat
4835: FROM igs_fi_fee_type_all
4836: WHERE fee_type = cp_fee_type;
4837:
4838: v_fee_type_description igs_fi_fee_type_all.description%type;
4839: l_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE;

Line 4838: v_fee_type_description igs_fi_fee_type_all.description%type;

4834: SELECT description, s_fee_trigger_cat
4835: FROM igs_fi_fee_type_all
4836: WHERE fee_type = cp_fee_type;
4837:
4838: v_fee_type_description igs_fi_fee_type_all.description%type;
4839: l_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE;
4840: BEGIN
4841: log_to_fnd( p_v_module => 'finpl_sum_fee_ass_item',
4842: p_v_string => 'Entered finpl_sum_fee_ass_item. Parameters are: ' ||

Line 4839: l_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE;

4835: FROM igs_fi_fee_type_all
4836: WHERE fee_type = cp_fee_type;
4837:
4838: v_fee_type_description igs_fi_fee_type_all.description%type;
4839: l_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE;
4840: BEGIN
4841: log_to_fnd( p_v_module => 'finpl_sum_fee_ass_item',
4842: p_v_string => 'Entered finpl_sum_fee_ass_item. Parameters are: ' ||
4843: p_person_id || ', ' || p_status || ', ' || p_fee_type || ', ' || P_fee_cat || ', ' || p_fee_cal_type

Line 4976: p_v_s_fee_type igs_fi_fee_type_all.s_fee_type%TYPE,

4972: p_new_ass_amount igs_fi_fee_as_all.transaction_amount%TYPE,
4973: p_effective_date DATE,
4974: p_trace_on VARCHAR2,
4975: p_d_gl_date igs_fi_invln_int_all.gl_date%TYPE,
4976: p_v_s_fee_type igs_fi_fee_type_all.s_fee_type%TYPE,
4977: p_n_rul_sequence_number igs_fi_fee_as_items.rul_sequence_number%TYPE,
4978: p_n_scope_rul_seq_num igs_fi_fee_as_items.scope_rul_sequence_num%TYPE,
4979: p_v_chg_method_type igs_fi_fee_as_items.s_chg_method_type%TYPE,
4980: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,

Line 4980: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,

4976: p_v_s_fee_type igs_fi_fee_type_all.s_fee_type%TYPE,
4977: p_n_rul_sequence_number igs_fi_fee_as_items.rul_sequence_number%TYPE,
4978: p_n_scope_rul_seq_num igs_fi_fee_as_items.scope_rul_sequence_num%TYPE,
4979: p_v_chg_method_type igs_fi_fee_as_items.s_chg_method_type%TYPE,
4980: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
4981: p_v_location_cd igs_fi_fee_as_items.location_cd%TYPE,
4982: p_v_career igs_ps_ver_all.course_type%TYPE,
4983: p_elm_rng_order_name igs_fi_f_typ_ca_inst_all.elm_rng_order_name%TYPE,
4984: p_attendance_mode igs_fi_fee_as_items.attendance_mode%TYPE,

Line 5014: l_v_fee_type_desc igs_fi_fee_type_all.description%TYPE := NULL;

5010: l_v_retention_level igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE := NULL;
5011: l_v_cmp_withdr_ret igs_fi_f_typ_ca_inst_all.complete_ret_flag%TYPE := NULL;
5012: l_n_diff_amount NUMBER := 0.0;
5013: l_n_retention_amount NUMBER := 0.0;
5014: l_v_fee_type_desc igs_fi_fee_type_all.description%TYPE := NULL;
5015: l_v_fee_trig_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE := NULL;
5016: l_n_sum_amount NUMBER := 0.0;
5017:
5018: tbl_unit_status t_unit_status; -- Table which says whether the corresponding unit record in tbl_fee_as_items_diff table is enrolled unit or discontinued unit

Line 5015: l_v_fee_trig_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE := NULL;

5011: l_v_cmp_withdr_ret igs_fi_f_typ_ca_inst_all.complete_ret_flag%TYPE := NULL;
5012: l_n_diff_amount NUMBER := 0.0;
5013: l_n_retention_amount NUMBER := 0.0;
5014: l_v_fee_type_desc igs_fi_fee_type_all.description%TYPE := NULL;
5015: l_v_fee_trig_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE := NULL;
5016: l_n_sum_amount NUMBER := 0.0;
5017:
5018: tbl_unit_status t_unit_status; -- Table which says whether the corresponding unit record in tbl_fee_as_items_diff table is enrolled unit or discontinued unit
5019: tbl_enr_disc_dt t_date; -- Table which has the discontinued dt/enrolled dt for the corresponding unit record in tbl_fee_as_items_diff table

Line 5025: CURSOR cur_opt_ind(cp_v_fee_type igs_fi_fee_type_all.fee_type%TYPE) IS

5021: -- User-defined exceptions
5022: skip EXCEPTION;
5023:
5024: -- Cursor to determine Optional Indicator of the fee type
5025: CURSOR cur_opt_ind(cp_v_fee_type igs_fi_fee_type_all.fee_type%TYPE) IS
5026: SELECT optional_payment_ind, description, s_fee_trigger_cat
5027: FROM igs_fi_fee_type_all
5028: WHERE fee_type = cp_v_fee_type;
5029:

Line 5027: FROM igs_fi_fee_type_all

5023:
5024: -- Cursor to determine Optional Indicator of the fee type
5025: CURSOR cur_opt_ind(cp_v_fee_type igs_fi_fee_type_all.fee_type%TYPE) IS
5026: SELECT optional_payment_ind, description, s_fee_trigger_cat
5027: FROM igs_fi_fee_type_all
5028: WHERE fee_type = cp_v_fee_type;
5029:
5030: --- Cursor for getting nonzero_billable_cp_flag from ftci
5031:

Line 5096: l_v_optional_ind igs_fi_fee_type_all.optional_payment_ind%TYPE := NULL;

5092: SELECT unit_cd, version_number
5093: FROM igs_ps_unit_ofr_opt_all
5094: WHERE uoo_id = cp_n_uoo_id;
5095:
5096: l_v_optional_ind igs_fi_fee_type_all.optional_payment_ind%TYPE := NULL;
5097: l_v_nz_bill_cp_flag igs_fi_f_typ_ca_inst_all.nonzero_billable_cp_flag%TYPE;
5098: l_v_fee_ass_ind VARCHAR2(1);
5099: l_n_chg_elements igs_fi_fee_as_items.chg_elements%TYPE;
5100: l_n_count NUMBER;

Line 5650: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%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,
5654: p_s_fee_type igs_fi_fee_type_all.s_fee_type%TYPE,

Line 5654: p_s_fee_type igs_fi_fee_type_all.s_fee_type%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,
5654: p_s_fee_type igs_fi_fee_type_all.s_fee_type%TYPE,
5655: p_effective_dt DATE,
5656: p_trace_on VARCHAR2,
5657: p_crs_version_number igs_fi_fee_as_items.crs_version_number%TYPE,
5658: p_course_attempt_status igs_fi_fee_as_items.course_attempt_status%TYPE,

Line 6252: p_s_fee_type igs_fi_fee_type_all.s_fee_type%TYPE,

6248: p_effective_start_dt igs_en_su_attempt_h_all.hist_start_dt%TYPE,
6249: p_effective_end_dt igs_en_su_attempt_h_all.hist_end_dt%TYPE,
6250: p_eftsu igs_fi_fee_as_items.eftsu%TYPE,
6251: p_credit_points igs_fi_fee_as_items.credit_points%TYPE,
6252: p_s_fee_type igs_fi_fee_type_all.s_fee_type%TYPE,
6253: p_charge_method igs_fi_f_typ_ca_inst_all.s_chg_method_type%TYPE,
6254: p_fee_type IGS_FI_FEE_AS_ITEMS.FEE_TYPE%TYPE ,
6255: p_fee_cat IGS_FI_FEE_AS_ITEMS.FEE_CAT%TYPE,
6256: p_fee_cal_type IGS_FI_FEE_AS_ITEMS.FEE_CAL_TYPE%TYPE,

Line 6264: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,

6260: p_ci_sequence_number IGS_FI_FEE_AS_ITEMS.ci_sequence_number%TYPE,
6261: p_charge_elements IN OUT NOCOPY igs_fi_fee_as_all.chg_elements%TYPE,
6262: p_ret_true_flag OUT NOCOPY BOOLEAN,
6263: p_message_name OUT NOCOPY VARCHAR2,
6264: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
6265: p_uoo_id IGS_FI_FEE_AS_ITEMS.UOO_ID%TYPE,
6266: p_unit_course_cd igs_ps_ver_all.course_cd%TYPE,
6267: p_n_unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
6268: p_v_unit_level igs_fi_fee_as_items.unit_level%TYPE,

Line 6704: p_s_fee_type igs_fi_fee_type_all.s_fee_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,
6708: p_location_cd IGS_FI_FEE_AS_ITEMS.LOCATION_CD%TYPE,

Line 6705: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_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,
6708: p_location_cd IGS_FI_FEE_AS_ITEMS.LOCATION_CD%TYPE,
6709: p_c_career igs_ps_ver_all.course_type%TYPE,

Line 7889: igs_fi_fee_type_all ft

7885: fcflv.scope_rul_sequence_num,
7886: fcflv.max_chg_elements
7887: FROM igs_fi_f_cat_fee_lbl_v fcflv,
7888: igs_fi_fee_str_stat fss,
7889: igs_fi_fee_type_all ft
7890: WHERE fcflv.fee_cat = cp_fee_cat AND
7891: fcflv.fee_cal_type = cp_fee_cal_type AND
7892: fcflv.fee_ci_sequence_number = cp_fee_ci_sequence_number AND
7893: (p_fee_type IS NULL OR fcflv.fee_type = p_fee_type) AND

Line 7921: igs_fi_fee_type_all ft,

7917: ast.scope_rul_sequence_num,
7918: ast.max_chg_elements
7919: FROM igs_fi_fee_as_items ast,
7920: igs_fi_fee_as_all fas,
7921: igs_fi_fee_type_all ft,
7922: igs_ps_ver_all ps
7923: WHERE ast.person_id = p_person_id
7924: AND (p_fee_type IS NULL OR (p_fee_type IS NOT NULL AND ast.fee_type = p_fee_type))-- will reverse existing charges only when user has not provided Fee Type as input
7925: AND ps.course_cd (+) = ast.course_cd

Line 8029: lv_fee_trg_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE;

8025: (reverse chronological order - newest change first)
8026: ***************************************************************/
8027: v_message_name VARCHAR2(30);
8028: ln_fee_ass_item_id igs_fi_fee_as_items.fee_ass_item_id%TYPE;
8029: lv_fee_trg_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE;
8030: lv_chg_method IGS_FI_FEE_AS_ITEMS.S_Chg_Method_Type%TYPE;
8031:
8032:
8033: CURSOR c_fee_type( cp_fee_type IGS_FI_FEE_AS_ITEMS.FEE_TYPE%TYPE ) IS

Line 8036: FROM igs_fi_fee_type_all

8032:
8033: CURSOR c_fee_type( cp_fee_type IGS_FI_FEE_AS_ITEMS.FEE_TYPE%TYPE ) IS
8034: SELECT description,
8035: s_fee_trigger_cat
8036: FROM igs_fi_fee_type_all
8037: WHERE fee_type = cp_fee_type;
8038: v_fee_type_description igs_fi_fee_type_all.description%type;
8039: l_n_scope_rul_seq_num igs_fi_f_typ_ca_inst_all.scope_rul_sequence_num%TYPE;
8040:

Line 8038: v_fee_type_description igs_fi_fee_type_all.description%type;

8034: SELECT description,
8035: s_fee_trigger_cat
8036: FROM igs_fi_fee_type_all
8037: WHERE fee_type = cp_fee_type;
8038: v_fee_type_description igs_fi_fee_type_all.description%type;
8039: l_n_scope_rul_seq_num igs_fi_f_typ_ca_inst_all.scope_rul_sequence_num%TYPE;
8040:
8041: CURSOR cur_chg_method1(cp_fee_type igs_fi_fee_as_all.fee_type%TYPE,
8042: cp_fee_cal_type igs_fi_fee_as_all.fee_cal_type%TYPE,

Line 8058: cp_s_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,

8054: cp_fee_cal_type igs_fi_fee_as_items.fee_cal_type%TYPE,
8055: cp_fee_ci_sequence_number igs_fi_fee_as_items.fee_ci_sequence_number%TYPE,
8056: cp_course_cd igs_fi_fee_as_items.course_cd%TYPE,
8057: cp_career igs_ps_ver_all.course_type%TYPE,
8058: cp_s_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
8059: cp_v_s_transaction_type1 igs_fi_fee_as_all.s_transaction_type%TYPE,
8060: cp_v_s_transaction_type2 igs_fi_fee_as_all.s_transaction_type%TYPE
8061: ) IS
8062: SELECT a.course_cd,

Line 11017: p_v_fee_type_desc IN igs_fi_fee_type_all.description%TYPE,

11013: p_v_fee_cat IN igs_fi_inv_int_all.fee_cat%TYPE,
11014: p_d_gl_date IN igs_fi_invln_int_all.gl_date%TYPE,
11015: p_n_uoo_id IN igs_fi_invln_int_all.uoo_id%TYPE,
11016: p_n_amount IN igs_fi_inv_int_all.invoice_amount%TYPE,
11017: p_v_fee_type_desc IN igs_fi_fee_type_all.description%TYPE,
11018: p_v_fee_trig_cat IN igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
11019: p_trace_on IN VARCHAR2) AS
11020: /*************************************************************
11021: Created By : Priya Athipatla

Line 11018: p_v_fee_trig_cat IN igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,

11014: p_d_gl_date IN igs_fi_invln_int_all.gl_date%TYPE,
11015: p_n_uoo_id IN igs_fi_invln_int_all.uoo_id%TYPE,
11016: p_n_amount IN igs_fi_inv_int_all.invoice_amount%TYPE,
11017: p_v_fee_type_desc IN igs_fi_fee_type_all.description%TYPE,
11018: p_v_fee_trig_cat IN igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
11019: p_trace_on IN VARCHAR2) AS
11020: /*************************************************************
11021: Created By : Priya Athipatla
11022: Date Created By : 07-Sep-2004