APPS.FV_DC_ASSIGN_FINANCE_CHRG dependencies on RA_INTERFACE_DISTRIBUTIONS

Line 106: fc_dm_dist_rec RA_INTERFACE_DISTRIBUTIONS%ROWTYPE;

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;
110: v_exchange_date RA_CUSTOMER_TRX.EXCHANGE_DATE%TYPE;

Line 901: UPDATE ra_interface_distributions_all rd

897: IS
898: l_module_name VARCHAR2(200);
899: BEGIN
900: l_module_name := g_module_name || 'update_debit_memo_dist';
901: UPDATE ra_interface_distributions_all rd
902: set rd.amount = rd.amount + fc_dm_dist_rec.amount,
903: rd.last_updated_by = fc_dm_dist_rec.last_updated_by,
904: rd.last_update_date = fc_dm_dist_rec.last_update_date
905: WHERE

Line 927: INSERT into ra_interface_distributions_all(

923: IS
924: l_module_name VARCHAR2(200) ;
925: BEGIN
926: l_module_name := g_module_name || 'insert_debit_memo_dist';
927: INSERT into ra_interface_distributions_all(
928: INTERFACE_LINE_CONTEXT,
929: INTERFACE_LINE_ATTRIBUTE1,
930: INTERFACE_LINE_ATTRIBUTE2,
931: INTERFACE_LINE_ATTRIBUTE3,

Line 981: -- setup ra_interface_distributions column values for the Receivable type line

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);
983:
984: -- insert values in ra_interface_distributions;
985: IF v_split_term THEN

Line 984: -- insert values in ra_interface_distributions;

980:
981: -- setup ra_interface_distributions column values for the Receivable type line
982: map_debit_memo_dist('REC', dollars);
983:
984: -- insert values in ra_interface_distributions;
985: IF v_split_term THEN
986: /**
987: This is done split payment schedules. If v_split_term is
988: TRUE that means line for first payment schedule already exist in

Line 997: -- setup ra_interface_distributions column values for the Revenue type line.

993: ELSE
994: insert_debit_memo_dist;
995: END IF;
996:
997: -- setup ra_interface_distributions column values for the Revenue type line.
998: map_debit_memo_dist('REV', dollars);
999:
1000: -- insert values in ra_interface_distributions;
1001: insert_debit_memo_dist;

Line 1000: -- insert values in ra_interface_distributions;

996:
997: -- setup ra_interface_distributions column values for the Revenue type line.
998: map_debit_memo_dist('REV', dollars);
999:
1000: -- insert values in ra_interface_distributions;
1001: insert_debit_memo_dist;
1002:
1003: -- variable used to check if AutoInvoice should be submitted.
1004: -- If the interface table contains no records then

Line 1290: delete from ra_interface_distributions

1286: delete from fv_ar_controls
1287: where payment_schedule_id = error_records_rec.interface_line_attribute4
1288: and created_from = error_records_rec.header_attribute3;
1289:
1290: delete from ra_interface_distributions
1291: where interface_line_id = error_records_rec.interface_line_id;
1292:
1293: end loop;
1294: