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_INV_INT_ALL

Line 197: g_v_retention CONSTANT igs_fi_inv_int_all.transaction_type%TYPE := 'RETENTION';

193:
194: g_v_career CONSTANT igs_fi_control_all.fee_calc_mthd_code%TYPE := 'CAREER';
195: g_v_program CONSTANT igs_fi_control_all.fee_calc_mthd_code%TYPE := 'PROGRAM';
196: g_v_primary_career CONSTANT igs_fi_control_all.fee_calc_mthd_code%TYPE := 'PRIMARY_CAREER';
197: g_v_retention CONSTANT igs_fi_inv_int_all.transaction_type%TYPE := 'RETENTION';
198:
199: g_v_chgmthd_flatrate CONSTANT igs_fi_invln_int_all.s_chg_method_type%TYPE := 'FLATRATE';
200:
201:

Line 364: PROCEDURE create_retention_charge( p_n_person_id IN igs_fi_inv_int_all.person_id%TYPE,

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;
363:
364: PROCEDURE create_retention_charge( p_n_person_id IN igs_fi_inv_int_all.person_id%TYPE,
365: p_v_course_cd IN igs_fi_inv_int_all.course_cd%TYPE,
366: p_v_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
367: p_n_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
368: p_v_fee_type IN igs_fi_inv_int_all.fee_type%TYPE,

Line 365: p_v_course_cd IN igs_fi_inv_int_all.course_cd%TYPE,

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;
363:
364: PROCEDURE create_retention_charge( p_n_person_id IN igs_fi_inv_int_all.person_id%TYPE,
365: p_v_course_cd IN igs_fi_inv_int_all.course_cd%TYPE,
366: p_v_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
367: p_n_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
368: p_v_fee_type IN igs_fi_inv_int_all.fee_type%TYPE,
369: p_v_fee_cat IN igs_fi_inv_int_all.fee_cat%TYPE,

Line 366: p_v_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,

362: p_n_transaction_id igs_fi_fee_as_all.transaction_id%TYPE) RETURN BOOLEAN;
363:
364: PROCEDURE create_retention_charge( p_n_person_id IN igs_fi_inv_int_all.person_id%TYPE,
365: p_v_course_cd IN igs_fi_inv_int_all.course_cd%TYPE,
366: p_v_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
367: p_n_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
368: p_v_fee_type IN igs_fi_inv_int_all.fee_type%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,

Line 367: p_n_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,

363:
364: PROCEDURE create_retention_charge( p_n_person_id IN igs_fi_inv_int_all.person_id%TYPE,
365: p_v_course_cd IN igs_fi_inv_int_all.course_cd%TYPE,
366: p_v_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
367: p_n_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
368: p_v_fee_type IN igs_fi_inv_int_all.fee_type%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,

Line 368: p_v_fee_type IN igs_fi_inv_int_all.fee_type%TYPE,

364: PROCEDURE create_retention_charge( p_n_person_id IN igs_fi_inv_int_all.person_id%TYPE,
365: p_v_course_cd IN igs_fi_inv_int_all.course_cd%TYPE,
366: p_v_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
367: p_n_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
368: p_v_fee_type IN igs_fi_inv_int_all.fee_type%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,

Line 369: p_v_fee_cat IN igs_fi_inv_int_all.fee_cat%TYPE,

365: p_v_course_cd IN igs_fi_inv_int_all.course_cd%TYPE,
366: p_v_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
367: p_n_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
368: p_v_fee_type IN igs_fi_inv_int_all.fee_type%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,

Line 372: p_n_amount IN igs_fi_inv_int_all.invoice_amount%TYPE,

368: p_v_fee_type IN igs_fi_inv_int_all.fee_type%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:

Line 5723: l_source_invoice_id igs_fi_inv_int_all.invoice_id%TYPE;

5719: v_chg_elements NUMBER;
5720: v_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;
5721: v_message_name VARCHAR2(30);
5722:
5723: l_source_invoice_id igs_fi_inv_int_all.invoice_id%TYPE;
5724: l_invoice_id igs_fi_inv_int_all.invoice_id%TYPE;
5725: l_header_rec igs_fi_charges_api_pvt.header_rec_type;
5726: l_line_rec igs_fi_charges_api_pvt.line_tbl_type;
5727: l_line_rec_dummy igs_fi_charges_api_pvt.line_tbl_type;

Line 5724: l_invoice_id igs_fi_inv_int_all.invoice_id%TYPE;

5720: v_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;
5721: v_message_name VARCHAR2(30);
5722:
5723: l_source_invoice_id igs_fi_inv_int_all.invoice_id%TYPE;
5724: l_invoice_id igs_fi_inv_int_all.invoice_id%TYPE;
5725: l_header_rec igs_fi_charges_api_pvt.header_rec_type;
5726: l_line_rec igs_fi_charges_api_pvt.line_tbl_type;
5727: l_line_rec_dummy igs_fi_charges_api_pvt.line_tbl_type;
5728: l_line_id_tbl igs_fi_charges_api_pvt.line_id_tbl_type;

Line 5737: l_v_invoice_number igs_fi_inv_int_all.invoice_number%TYPE;

5733:
5734: l_crs_attempt_status igs_fi_fee_as_items.course_attempt_status%TYPE;
5735:
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;

Line 5741: l_v_invoice_num igs_fi_inv_int_all.invoice_number%TYPE;

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,
5745: cp_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,

Line 11008: PROCEDURE create_retention_charge( p_n_person_id IN igs_fi_inv_int_all.person_id%TYPE,

11004: END IF;
11005:
11006: END finpl_check_header_lines;
11007:
11008: PROCEDURE create_retention_charge( p_n_person_id IN igs_fi_inv_int_all.person_id%TYPE,
11009: p_v_course_cd IN igs_fi_inv_int_all.course_cd%TYPE,
11010: p_v_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
11011: p_n_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
11012: p_v_fee_type IN igs_fi_inv_int_all.fee_type%TYPE,

Line 11009: p_v_course_cd IN igs_fi_inv_int_all.course_cd%TYPE,

11005:
11006: END finpl_check_header_lines;
11007:
11008: PROCEDURE create_retention_charge( p_n_person_id IN igs_fi_inv_int_all.person_id%TYPE,
11009: p_v_course_cd IN igs_fi_inv_int_all.course_cd%TYPE,
11010: p_v_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
11011: p_n_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
11012: p_v_fee_type IN igs_fi_inv_int_all.fee_type%TYPE,
11013: p_v_fee_cat IN igs_fi_inv_int_all.fee_cat%TYPE,

Line 11010: p_v_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,

11006: END finpl_check_header_lines;
11007:
11008: PROCEDURE create_retention_charge( p_n_person_id IN igs_fi_inv_int_all.person_id%TYPE,
11009: p_v_course_cd IN igs_fi_inv_int_all.course_cd%TYPE,
11010: p_v_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
11011: p_n_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
11012: p_v_fee_type IN igs_fi_inv_int_all.fee_type%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,

Line 11011: p_n_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,

11007:
11008: PROCEDURE create_retention_charge( p_n_person_id IN igs_fi_inv_int_all.person_id%TYPE,
11009: p_v_course_cd IN igs_fi_inv_int_all.course_cd%TYPE,
11010: p_v_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
11011: p_n_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
11012: p_v_fee_type IN igs_fi_inv_int_all.fee_type%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,

Line 11012: p_v_fee_type IN igs_fi_inv_int_all.fee_type%TYPE,

11008: PROCEDURE create_retention_charge( p_n_person_id IN igs_fi_inv_int_all.person_id%TYPE,
11009: p_v_course_cd IN igs_fi_inv_int_all.course_cd%TYPE,
11010: p_v_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
11011: p_n_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
11012: p_v_fee_type IN igs_fi_inv_int_all.fee_type%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,

Line 11013: p_v_fee_cat IN igs_fi_inv_int_all.fee_cat%TYPE,

11009: p_v_course_cd IN igs_fi_inv_int_all.course_cd%TYPE,
11010: p_v_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
11011: p_n_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
11012: p_v_fee_type IN igs_fi_inv_int_all.fee_type%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,

Line 11016: p_n_amount IN igs_fi_inv_int_all.invoice_amount%TYPE,

11012: p_v_fee_type IN igs_fi_inv_int_all.fee_type%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: /*************************************************************

Line 11041: l_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE := NULL;

11037: l_rowid ROWID := NULL;
11038: l_n_transaction_id igs_fi_fee_as_all.transaction_id%TYPE := NULL;
11039: l_v_fee_cat igs_fi_fee_as_all.fee_cat%TYPE := NULL;
11040: l_v_course_cd igs_fi_fee_as_all.course_cd%TYPE := NULL;
11041: l_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE := NULL;
11042: l_n_fee_ass_item_id igs_fi_fee_as_items.fee_ass_item_id%TYPE := NULL;
11043:
11044: l_header_rec igs_fi_charges_api_pvt.header_rec_type;
11045: l_line_rec igs_fi_charges_api_pvt.line_tbl_type;

Line 11054: l_v_invoice_num igs_fi_inv_int_all.invoice_number%TYPE;

11050: l_v_status VARCHAR2(1) := NULL;
11051: l_n_msg_count NUMBER := NULL;
11052: l_v_msg_data VARCHAR2(2000) := NULL;
11053: l_n_waiver_amt NUMBER := NULL;
11054: l_v_invoice_num igs_fi_inv_int_all.invoice_number%TYPE;
11055:
11056: BEGIN
11057:
11058: log_to_fnd( p_v_module => 'create_retention_charge',