APPS.FV_DC_ASSIGN_FINANCE_CHRG dependencies on RA_INTERFACE_LINES_ALL

Line 105: fc_dm_rec RA_INTERFACE_LINES_ALL%ROWTYPE;

101: TYPE autoidarray IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
102: v_auto_id autoidarray;
103: */
104:
105: fc_dm_rec RA_INTERFACE_LINES_ALL%ROWTYPE;
106: fc_dm_dist_rec RA_INTERFACE_DISTRIBUTIONS%ROWTYPE;
107: fin_charge_batch_source_id number;
108: invoice_currency_code RA_CUSTOMER_TRX.INVOICE_CURRENCY_CODE%TYPE;
109: bill_to_contact_id RA_CUSTOMER_TRX.BILL_TO_CONTACT_ID%TYPE;

Line 350: from ra_interface_lines_all

346: when no_data_found then
347: -- check interface table, this is specifically for inv w/split terms.
348: select count(*)
349: into v_line_count
350: from ra_interface_lines_all
351: where interface_line_attribute3 = charge_type
352: and related_customer_trx_id = invoice_id;
353:
354: IF v_line_count = 0 THEN

Line 574: from ra_interface_lines_all

570: -- find the attribute1 value for the original debit memo
571: -- bug 3058213, capturing the trx_date
572: select interface_line_attribute1, trx_date
573: into v_autoinv_seq_nbr, v_split_trx_date
574: from ra_interface_lines_all
575: where related_customer_trx_id = invoice_id
576: and interface_line_attribute3 = charge_type
577: and interface_line_attribute2 = '1';
578:

Line 719: INSERT INTO ra_interface_lines_all(

715: 'Creating DM '||fc_dm_rec.TRX_NUMBER);
716: END IF;
717:
718:
719: INSERT INTO ra_interface_lines_all(
720: INTERFACE_LINE_ID ,
721: INTERFACE_LINE_CONTEXT,
722: INTERFACE_LINE_ATTRIBUTE1,
723: INTERFACE_LINE_ATTRIBUTE2 ,

Line 1420: FROM ra_interface_lines_all

1416: CURSOR RA_INTERFACE_ERR_CUR(p_sob number, p_org NUMBER) IS
1417: SELECT 1 FROM ra_interface_errors_all
1418: WHERE INTERFACE_LINE_ID IN
1419: (SELECT INTERFACE_LINE_ID
1420: FROM ra_interface_lines_all
1421: WHERE INTERFACE_LINE_CONTEXT='Accrue Finance Charges' AND
1422: set_of_books_id=p_sob
1423: AND org_id = p_org);
1424: