APPS.IGF_DB_SF_INTEGRATION dependencies on IGS_FI_FEE_TYPE

Line 642: CURSOR c_igs_fi_fee_type (cp_v_fee_type igs_fi_fee_type_all.fee_type%TYPE) IS

638: FROM igs_pe_person_base_v
639: WHERE person_id = cp_person_id;
640: l_cur_api cur_api%ROWTYPE;
641:
642: CURSOR c_igs_fi_fee_type (cp_v_fee_type igs_fi_fee_type_all.fee_type%TYPE) IS
643: SELECT description
644: FROM igs_fi_fee_type
645: WHERE fee_type = cp_v_fee_type;
646:

Line 644: FROM igs_fi_fee_type

640: l_cur_api cur_api%ROWTYPE;
641:
642: CURSOR c_igs_fi_fee_type (cp_v_fee_type igs_fi_fee_type_all.fee_type%TYPE) IS
643: SELECT description
644: FROM igs_fi_fee_type
645: WHERE fee_type = cp_v_fee_type;
646:
647: rec_c_igs_fi_fee_type c_igs_fi_fee_type%ROWTYPE;
648:

Line 647: rec_c_igs_fi_fee_type c_igs_fi_fee_type%ROWTYPE;

643: SELECT description
644: FROM igs_fi_fee_type
645: WHERE fee_type = cp_v_fee_type;
646:
647: rec_c_igs_fi_fee_type c_igs_fi_fee_type%ROWTYPE;
648:
649:
650: l_chg_rec igs_fi_charges_api_pvt.header_rec_type;
651: l_chg_line_tbl igs_fi_charges_api_pvt.line_tbl_type;

Line 701: OPEN c_igs_fi_fee_type(p_cur_disb.fee_type);

697: l_invoice_desc := substr(l_cur_api.person_number||g_separator||l_cur_api.full_name,1,240);
698: END IF;
699: CLOSE cur_api;
700: ELSE
701: OPEN c_igs_fi_fee_type(p_cur_disb.fee_type);
702: FETCH c_igs_fi_fee_type INTO rec_c_igs_fi_fee_type;
703: IF c_igs_fi_fee_type%NOTFOUND THEN
704: l_invoice_desc := NULL;
705: ELSE

Line 702: FETCH c_igs_fi_fee_type INTO rec_c_igs_fi_fee_type;

698: END IF;
699: CLOSE cur_api;
700: ELSE
701: OPEN c_igs_fi_fee_type(p_cur_disb.fee_type);
702: FETCH c_igs_fi_fee_type INTO rec_c_igs_fi_fee_type;
703: IF c_igs_fi_fee_type%NOTFOUND THEN
704: l_invoice_desc := NULL;
705: ELSE
706: -- description will be description of adjustment fee type linked to sponsor : sponsor code

Line 703: IF c_igs_fi_fee_type%NOTFOUND THEN

699: CLOSE cur_api;
700: ELSE
701: OPEN c_igs_fi_fee_type(p_cur_disb.fee_type);
702: FETCH c_igs_fi_fee_type INTO rec_c_igs_fi_fee_type;
703: IF c_igs_fi_fee_type%NOTFOUND THEN
704: l_invoice_desc := NULL;
705: ELSE
706: -- description will be description of adjustment fee type linked to sponsor : sponsor code
707: l_invoice_desc := rec_c_igs_fi_fee_type.description || g_separator || p_cur_disb.fund_code ;

Line 707: l_invoice_desc := rec_c_igs_fi_fee_type.description || g_separator || p_cur_disb.fund_code ;

703: IF c_igs_fi_fee_type%NOTFOUND THEN
704: l_invoice_desc := NULL;
705: ELSE
706: -- description will be description of adjustment fee type linked to sponsor : sponsor code
707: l_invoice_desc := rec_c_igs_fi_fee_type.description || g_separator || p_cur_disb.fund_code ;
708: END IF;
709: l_person_id := p_cur_disb.person_id;
710: l_fee_type := p_cur_disb.fee_type;
711: l_transaction_type := g_aid_adj;