APPS.IGS_FI_PRC_LOCKBOX dependencies on IGS_FI_FEE_TYPE

Line 1912: p_v_fee_type OUT NOCOPY igs_fi_fee_type.fee_type%TYPE,

1908:
1909: PROCEDURE val_charge_number_for_app(p_v_charge_code igs_fi_inv_int.invoice_number%TYPE,
1910: p_v_party_number hz_parties.party_number%TYPE,
1911: p_n_party_id pls_integer,
1912: p_v_fee_type OUT NOCOPY igs_fi_fee_type.fee_type%TYPE,
1913: p_n_invoice_id OUT NOCOPY igs_fi_inv_int.invoice_id%TYPE,
1914: p_v_message_name OUT NOCOPY VARCHAR2) AS
1915: /******************************************************************
1916: Created By : Amit Gairola

Line 1932: CURSOR cur_ft(cp_fee_type igs_fi_fee_type.fee_type%TYPE) IS

1928: FROM igs_fi_inv_int
1929: WHERE person_id = cp_party_id
1930: AND invoice_number = cp_invoice_number;
1931:
1932: CURSOR cur_ft(cp_fee_type igs_fi_fee_type.fee_type%TYPE) IS
1933: SELECT designated_payment_flag
1934: FROM igs_fi_fee_type
1935: WHERE fee_type = cp_fee_type;
1936:

Line 1934: FROM igs_fi_fee_type

1930: AND invoice_number = cp_invoice_number;
1931:
1932: CURSOR cur_ft(cp_fee_type igs_fi_fee_type.fee_type%TYPE) IS
1933: SELECT designated_payment_flag
1934: FROM igs_fi_fee_type
1935: WHERE fee_type = cp_fee_type;
1936:
1937: l_v_fee_type igs_fi_fee_type.fee_type%TYPE;
1938: l_n_inv_id igs_fi_inv_int.invoice_id%TYPE;

Line 1937: l_v_fee_type igs_fi_fee_type.fee_type%TYPE;

1933: SELECT designated_payment_flag
1934: FROM igs_fi_fee_type
1935: WHERE fee_type = cp_fee_type;
1936:
1937: l_v_fee_type igs_fi_fee_type.fee_type%TYPE;
1938: l_n_inv_id igs_fi_inv_int.invoice_id%TYPE;
1939: l_v_designated_pay_flag igs_fi_fee_type.designated_payment_flag%TYPE;
1940: BEGIN
1941:

Line 1939: l_v_designated_pay_flag igs_fi_fee_type.designated_payment_flag%TYPE;

1935: WHERE fee_type = cp_fee_type;
1936:
1937: l_v_fee_type igs_fi_fee_type.fee_type%TYPE;
1938: l_n_inv_id igs_fi_inv_int.invoice_id%TYPE;
1939: l_v_designated_pay_flag igs_fi_fee_type.designated_payment_flag%TYPE;
1940: BEGIN
1941:
1942: -- Validate if the Party Id and the charge code exist in the Charges table.
1943: -- If not, then it is an error condition

Line 2426: l_v_fee_type igs_fi_fee_type.fee_type%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;
2430: l_n_rec_err_id igs_fi_lb_rect_errs.lockbox_receipt_error_id%TYPE;