APPS.FV_DC_ASSIGN_FINANCE_CHRG dependencies on RA_INTERFACE_LINES

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 222: from ra_interface_lines

218: cursor c_batch_source_id is
219: select batch_source_id, name
220: from ra_batch_sources
221: where name in (select distinct batch_source_name
222: from ra_interface_lines
223: where interface_line_context = 'Accrue Finance Charges'
224: and interface_line_id not in (select interface_line_id
225: from ra_interface_errors));
226:

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 975: -- call procedure to setup ra_interface_lines column values

971: date_exists fv_ar_controls.last_accrual_date%TYPE;
972: begin
973:
974: l_module_name := g_module_name || 'create_new_dm';
975: -- call procedure to setup ra_interface_lines column values
976: map_debit_memo_line(dollars);
977:
978: -- insert values in ra_interface_lines
979: insert_debit_memo_line;

Line 978: -- insert values in ra_interface_lines

974: l_module_name := g_module_name || 'create_new_dm';
975: -- call procedure to setup ra_interface_lines column values
976: map_debit_memo_line(dollars);
977:
978: -- insert values in ra_interface_lines
979: insert_debit_memo_line;
980:
981: -- setup ra_interface_distributions column values for the Receivable type line
982: map_debit_memo_dist('REC', dollars);

Line 1276: from ra_interface_lines

1272:
1273:
1274: cursor error_records_c(x_batch_source_name varchar2) is
1275: select interface_line_attribute4, header_attribute3, interface_line_id
1276: from ra_interface_lines
1277: where interface_line_context = 'Accrue Finance Charges'
1278: and batch_source_name = x_batch_source_name -- added line
1279: and interface_line_id not in (select interface_line_id
1280: from ra_interface_errors);

Line 1295: delete from ra_interface_lines

1291: where interface_line_id = error_records_rec.interface_line_id;
1292:
1293: end loop;
1294:
1295: delete from ra_interface_lines
1296: where interface_line_context = 'Accrue Finance Charges'
1297: and batch_source_name = var_batch_source_name -- added line
1298: and interface_line_id not in (select interface_line_id
1299: from ra_interface_errors);

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: