APPS.FV_DC_ASSIGN_FINANCE_CHRG dependencies on RA_CUSTOMER_TRX_ALL

Line 25: invoice_id ra_customer_trx_all.customer_trx_id%TYPE,

21: g_lo_date DATE;
22:
23: TYPE out_rec IS RECORD
24: (
25: invoice_id ra_customer_trx_all.customer_trx_id%TYPE,
26: payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE,
27: charge_type fv_finance_charge_controls.charge_type%TYPE,
28: invoice_number ra_customer_trx_all.trx_number%TYPE,
29: amount_due_remaining ar_payment_schedules.amount_due_remaining%TYPE,

Line 28: invoice_number ra_customer_trx_all.trx_number%TYPE,

24: (
25: invoice_id ra_customer_trx_all.customer_trx_id%TYPE,
26: payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE,
27: charge_type fv_finance_charge_controls.charge_type%TYPE,
28: invoice_number ra_customer_trx_all.trx_number%TYPE,
29: amount_due_remaining ar_payment_schedules.amount_due_remaining%TYPE,
30: amount_due_original ar_payment_schedules.amount_due_original%TYPE,
31: due_date ar_payment_schedules.due_date%TYPE,
32: amount_based VARCHAR2(1),

Line 703: l_dm_trx_number ra_customer_trx_all.trx_number%TYPE;

699: l_trx_salescredits_tbl ar_invoice_api_pub.trx_salescredits_tbl_type;
700: l_return_status VARCHAR2(10);
701: l_message_count NUMBER;
702: l_message_data VARCHAR2(1024);
703: l_dm_trx_number ra_customer_trx_all.trx_number%TYPE;
704: l_line_counter NUMBER;
705: l_dist_counter NUMBER;
706: l_prorated_line_amount NUMBER;
707: l_line_amount_due NUMBER;

Line 1150: l_dm_trx_number ra_customer_trx_all.trx_number%TYPE;

1146: l_module_name VARCHAR2(200);
1147: l_location VARCHAR2(200);
1148: l_term_id NUMBER;
1149: l_dm_invoice_id NUMBER;
1150: l_dm_trx_number ra_customer_trx_all.trx_number%TYPE;
1151: l_dm_trx_date ra_customer_trx_all.trx_date%TYPE;
1152: l_root_invoice_id NUMBER;
1153: BEGIN
1154: l_module_name := g_module_name || 'process_and_create_dm';

Line 1151: l_dm_trx_date ra_customer_trx_all.trx_date%TYPE;

1147: l_location VARCHAR2(200);
1148: l_term_id NUMBER;
1149: l_dm_invoice_id NUMBER;
1150: l_dm_trx_number ra_customer_trx_all.trx_number%TYPE;
1151: l_dm_trx_date ra_customer_trx_all.trx_date%TYPE;
1152: l_root_invoice_id NUMBER;
1153: BEGIN
1154: l_module_name := g_module_name || 'process_and_create_dm';
1155: p_retcode := g_SUCCESS;