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_LOCKBOX dependencies on IGS_FI_CR_TYPES

Line 349: FUNCTION get_credit_type_name(p_n_credit_type_id igs_fi_cr_types.credit_type_id%TYPE) RETURN VARCHAR2 AS

345: g_v_line_sep);
346: RETURN l_b_val_parm;
347: END validate_parameters;
348:
349: FUNCTION get_credit_type_name(p_n_credit_type_id igs_fi_cr_types.credit_type_id%TYPE) RETURN VARCHAR2 AS
350: /******************************************************************
351: Created By : Amit Gairola
352: Date Created By : 12-Jun-2003
353: Purpose : Function for getting the credit type name

Line 359: CURSOR cur_crt(cp_credit_type_id igs_fi_cr_types.credit_type_id%TYPE) IS

355: Known limitations,enhancements,remarks:
356: Change History
357: Who When What
358: ***************************************************************** */
359: CURSOR cur_crt(cp_credit_type_id igs_fi_cr_types.credit_type_id%TYPE) IS
360: SELECT credit_type_name
361: FROM igs_fi_cr_types
362: WHERE credit_type_id = cp_credit_type_id;
363:

Line 361: FROM igs_fi_cr_types

357: Who When What
358: ***************************************************************** */
359: CURSOR cur_crt(cp_credit_type_id igs_fi_cr_types.credit_type_id%TYPE) IS
360: SELECT credit_type_name
361: FROM igs_fi_cr_types
362: WHERE credit_type_id = cp_credit_type_id;
363:
364: l_v_cr_type_name igs_fi_cr_types.credit_type_name%TYPE;
365: BEGIN

Line 364: l_v_cr_type_name igs_fi_cr_types.credit_type_name%TYPE;

360: SELECT credit_type_name
361: FROM igs_fi_cr_types
362: WHERE credit_type_id = cp_credit_type_id;
363:
364: l_v_cr_type_name igs_fi_cr_types.credit_type_name%TYPE;
365: BEGIN
366: OPEN cur_crt(p_n_credit_type_id);
367: FETCH cur_crt INTO l_v_cr_type_name;
368: CLOSE cur_crt;

Line 2418: l_v_credit_class igs_fi_cr_types.credit_class%TYPE;

2414: l_n_rc_cntr NUMBER(38) := 0;
2415:
2416: l_t_ro_tab lb_receipt_tab;
2417: l_n_ro_cntr NUMBER(38) := 0;
2418: l_v_credit_class igs_fi_cr_types.credit_class%TYPE;
2419: l_b_ret_stat BOOLEAN;
2420: l_b_ro_rec_found BOOLEAN;
2421: l_n_pay_cr_type_id igs_fi_cr_types.credit_type_id%TYPE;
2422: l_v_closing_status VARCHAR2(5);

Line 2421: l_n_pay_cr_type_id igs_fi_cr_types.credit_type_id%TYPE;

2417: l_n_ro_cntr NUMBER(38) := 0;
2418: l_v_credit_class igs_fi_cr_types.credit_class%TYPE;
2419: l_b_ret_stat BOOLEAN;
2420: l_b_ro_rec_found BOOLEAN;
2421: l_n_pay_cr_type_id igs_fi_cr_types.credit_type_id%TYPE;
2422: l_v_closing_status VARCHAR2(5);
2423: l_v_message_name VARCHAR2(2000);
2424: l_v_ld_cal_type igs_ca_inst.cal_type%TYPE;
2425: l_n_ld_seq_num igs_ca_inst.sequence_number%TYPE;

Line 2443: l_n_cr_type_id_api igs_fi_cr_types_all.credit_type_id%TYPE;

2439: l_n_cntr1 NUMBER(38);
2440: l_b_rec_succ BOOLEAN;
2441:
2442: l_n_amount_api igs_fi_credits_all.amount%TYPE;
2443: l_n_cr_type_id_api igs_fi_cr_types_all.credit_type_id%TYPE;
2444: l_n_dflt_cr_type_id igs_fi_cr_types_all.credit_type_id%TYPE;
2445: l_v_act_plan_name igs_fi_pp_std_attrs.payment_plan_name%TYPE;
2446: l_n_act_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE;
2447: l_n_plan_balance igs_fi_pp_instlmnts.due_amt%TYPE;

Line 2444: l_n_dflt_cr_type_id igs_fi_cr_types_all.credit_type_id%TYPE;

2440: l_b_rec_succ BOOLEAN;
2441:
2442: l_n_amount_api igs_fi_credits_all.amount%TYPE;
2443: l_n_cr_type_id_api igs_fi_cr_types_all.credit_type_id%TYPE;
2444: l_n_dflt_cr_type_id igs_fi_cr_types_all.credit_type_id%TYPE;
2445: l_v_act_plan_name igs_fi_pp_std_attrs.payment_plan_name%TYPE;
2446: l_n_act_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE;
2447: l_n_plan_balance igs_fi_pp_instlmnts.due_amt%TYPE;
2448: l_n_diff_amount NUMBER := 0;