DBA Data[Home] [Help]

APPS.ARP_REVERSE_RECEIPT dependencies on RA_CUSTOMER_TRX_LINES

Line 1606: l_description ra_customer_trx_lines.description%TYPE;

1602: l_exchange_date ar_cash_receipts.exchange_date%TYPE;
1603:
1604: l_amount ar_cash_receipts.amount%TYPE;
1605:
1606: l_description ra_customer_trx_lines.description%TYPE;
1607:
1608: l_rev1_cc_id ar_cash_receipt_history.account_code_combination_id%TYPE;
1609: l_rev1_amount ar_cash_receipt_history.amount%TYPE;
1610: l_rev2_cc_id ar_cash_receipt_history.bank_charge_account_ccid%TYPE;

Line 1614: l_ct_lines_rec ra_customer_trx_lines%ROWTYPE;

1610: l_rev2_cc_id ar_cash_receipt_history.bank_charge_account_ccid%TYPE;
1611: l_rev2_amount ar_cash_receipt_history.factor_discount_amount%TYPE;
1612:
1613: l_ct_rec ra_customer_trx%ROWTYPE;
1614: l_ct_lines_rec ra_customer_trx_lines%ROWTYPE;
1615: l_comm_rec arp_process_commitment.commitment_rec_type;
1616:
1617: l_trx_number ra_customer_trx.trx_number%TYPE;
1618: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;

Line 1619: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE;

1615: l_comm_rec arp_process_commitment.commitment_rec_type;
1616:
1617: l_trx_number ra_customer_trx.trx_number%TYPE;
1618: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;
1619: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE;
1620:
1621: l_count NUMBER := 0;
1622:
1623: l_rule_start_date ra_customer_trx_lines.rule_start_date%type;

Line 1623: l_rule_start_date ra_customer_trx_lines.rule_start_date%type;

1619: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE;
1620:
1621: l_count NUMBER := 0;
1622:
1623: l_rule_start_date ra_customer_trx_lines.rule_start_date%type;
1624: l_accounting_rule_duration ra_customer_trx_lines.accounting_rule_duration%type;
1625: l_gl_date_dummy ra_cust_trx_line_gl_dist.gl_date%type;
1626: l_trx_date_dummy ra_customer_trx.trx_date%type;
1627: l_status_dummy varchar2(100);

Line 1624: l_accounting_rule_duration ra_customer_trx_lines.accounting_rule_duration%type;

1620:
1621: l_count NUMBER := 0;
1622:
1623: l_rule_start_date ra_customer_trx_lines.rule_start_date%type;
1624: l_accounting_rule_duration ra_customer_trx_lines.accounting_rule_duration%type;
1625: l_gl_date_dummy ra_cust_trx_line_gl_dist.gl_date%type;
1626: l_trx_date_dummy ra_customer_trx.trx_date%type;
1627: l_status_dummy varchar2(100);
1628:

Line 1629: l_commit_cust_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;

1625: l_gl_date_dummy ra_cust_trx_line_gl_dist.gl_date%type;
1626: l_trx_date_dummy ra_customer_trx.trx_date%type;
1627: l_status_dummy varchar2(100);
1628:
1629: l_commit_cust_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
1630: l_rowid rowid;
1631:
1632: l_dm_number ar_payment_schedules.trx_number%TYPE;
1633: --l_sequence_name VARCHAR2(500);

Line 1750: -- Get description to be used during RA_CUSTOMER_TRX_LINES insertion

1746: , ar_cash_receipts cr
1747: WHERE cr.cash_receipt_id = l_cr_id
1748: AND rm.receipt_method_id = cr.receipt_method_id;
1749: --
1750: -- Get description to be used during RA_CUSTOMER_TRX_LINES insertion
1751: --
1752:
1753: /* Bug 4684829 Changing AR_MEMO_LINES to AR_MEMO_LINES_B and AR_MEMO_LINES_TL
1754: We can directly use ar_memo_lines_vl too but case bug for a bug in