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_CA_INST

Line 373: FUNCTION get_fee_period(p_v_cal_type igs_ca_inst.cal_type%TYPE,

369:
370: RETURN l_v_cr_type_name;
371: END get_credit_type_name;
372:
373: FUNCTION get_fee_period(p_v_cal_type igs_ca_inst.cal_type%TYPE,
374: p_n_cal_seq igs_ca_inst.sequence_number%TYPE) RETURN VARCHAR2 AS
375: /******************************************************************
376: Created By : Amit Gairola
377: Date Created By : 12-Jun-2003

Line 374: p_n_cal_seq igs_ca_inst.sequence_number%TYPE) RETURN VARCHAR2 AS

370: RETURN l_v_cr_type_name;
371: END get_credit_type_name;
372:
373: FUNCTION get_fee_period(p_v_cal_type igs_ca_inst.cal_type%TYPE,
374: p_n_cal_seq igs_ca_inst.sequence_number%TYPE) RETURN VARCHAR2 AS
375: /******************************************************************
376: Created By : Amit Gairola
377: Date Created By : 12-Jun-2003
378: Purpose : Function for getting the fee period

Line 384: CURSOR cur_fee_prd(cp_cal_type igs_ca_inst.cal_type%TYPE,

380: Known limitations,enhancements,remarks:
381: Change History
382: Who When What
383: ***************************************************************** */
384: CURSOR cur_fee_prd(cp_cal_type igs_ca_inst.cal_type%TYPE,
385: cp_cal_seq igs_ca_inst.sequence_number%TYPE) IS
386: SELECT description
387: FROM igs_ca_inst
388: WHERE cal_type = cp_cal_type

Line 385: cp_cal_seq igs_ca_inst.sequence_number%TYPE) IS

381: Change History
382: Who When What
383: ***************************************************************** */
384: CURSOR cur_fee_prd(cp_cal_type igs_ca_inst.cal_type%TYPE,
385: cp_cal_seq igs_ca_inst.sequence_number%TYPE) IS
386: SELECT description
387: FROM igs_ca_inst
388: WHERE cal_type = cp_cal_type
389: AND sequence_number = cp_cal_seq;

Line 387: FROM igs_ca_inst

383: ***************************************************************** */
384: CURSOR cur_fee_prd(cp_cal_type igs_ca_inst.cal_type%TYPE,
385: cp_cal_seq igs_ca_inst.sequence_number%TYPE) IS
386: SELECT description
387: FROM igs_ca_inst
388: WHERE cal_type = cp_cal_type
389: AND sequence_number = cp_cal_seq;
390:
391: l_v_desc igs_ca_inst.description%TYPE;

Line 391: l_v_desc igs_ca_inst.description%TYPE;

387: FROM igs_ca_inst
388: WHERE cal_type = cp_cal_type
389: AND sequence_number = cp_cal_seq;
390:
391: l_v_desc igs_ca_inst.description%TYPE;
392: BEGIN
393: IF p_v_cal_type IS NULL OR p_n_cal_seq IS NULL THEN
394: l_v_desc := NULL;
395: ELSE

Line 2424: l_v_ld_cal_type igs_ca_inst.cal_type%TYPE;

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;
2426: l_v_fee_type igs_fi_fee_type.fee_type%TYPE;
2427: l_n_invoice_id igs_fi_inv_int.invoice_id%TYPE;
2428: l_v_message_text VARCHAR2(2000);

Line 2425: l_n_ld_seq_num igs_ca_inst.sequence_number%TYPE;

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;
2426: l_v_fee_type igs_fi_fee_type.fee_type%TYPE;
2427: l_n_invoice_id igs_fi_inv_int.invoice_id%TYPE;
2428: l_v_message_text VARCHAR2(2000);
2429: l_b_ro_rec_match BOOLEAN;