DBA Data[Home] [Help]

APPS.IGS_FI_REFUNDS_PKG dependencies on IGS_FI_FEE_TYPE

Line 1598: l_description igs_fi_fee_type.description%TYPE;

1594: l_header_rec igs_fi_charges_api_pvt.header_rec_type;
1595: l_line_tbl igs_fi_charges_api_pvt.line_tbl_type;
1596: l_line_id_tbl igs_fi_charges_api_pvt.line_id_tbl_type;
1597: l_invoice_id igs_fi_inv_int.invoice_id%TYPE;
1598: l_description igs_fi_fee_type.description%TYPE;
1599: l_return_status VARCHAR2(1);
1600: l_msg_count NUMBER(3);
1601: l_msg_data VARCHAR2(2000);
1602: l_msg VARCHAR2(2000);

Line 1607: CURSOR cur_ft_desc(cp_fee_type igs_fi_fee_type.fee_type%TYPE) IS

1603: l_currency_cd igs_fi_control_all.currency_cd%TYPE;
1604: l_currency_desc fnd_currencies_tl.name%TYPE;
1605:
1606: -- Cursor for Fetching the description of the Fee Type in context
1607: CURSOR cur_ft_desc(cp_fee_type igs_fi_fee_type.fee_type%TYPE) IS
1608: SELECT description
1609: FROM igs_fi_fee_type
1610: WHERE fee_type = cp_fee_type;
1611:

Line 1609: FROM igs_fi_fee_type

1605:
1606: -- Cursor for Fetching the description of the Fee Type in context
1607: CURSOR cur_ft_desc(cp_fee_type igs_fi_fee_type.fee_type%TYPE) IS
1608: SELECT description
1609: FROM igs_fi_fee_type
1610: WHERE fee_type = cp_fee_type;
1611:
1612: -- Getting the Charge Method and GL Code/ CCID's associated for a fee type
1613: CURSOR cur_chg_mthd(cp_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,