eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_REVERSE_RECEIPT dependencies on RA_CUSTOMER_TRX

Line 1589: p_dm_doc_sequence_value IN ra_customer_trx.doc_sequence_value%TYPE,

1585: p_attribute13 IN ar_cash_receipts.attribute13%TYPE,
1586: p_attribute14 IN ar_cash_receipts.attribute14%TYPE,
1587: p_attribute15 IN ar_cash_receipts.attribute15%TYPE,
1588: p_dm_number OUT NOCOPY ar_payment_schedules.trx_number%TYPE,
1589: p_dm_doc_sequence_value IN ra_customer_trx.doc_sequence_value%TYPE,
1590: p_dm_doc_sequence_id IN ra_customer_trx.doc_sequence_id%TYPE,
1591: p_status IN OUT NOCOPY VARCHAR2,
1592: p_module_name IN VARCHAR2,
1593: p_module_version IN VARCHAR2 ) IS

Line 1590: p_dm_doc_sequence_id IN ra_customer_trx.doc_sequence_id%TYPE,

1586: p_attribute14 IN ar_cash_receipts.attribute14%TYPE,
1587: p_attribute15 IN ar_cash_receipts.attribute15%TYPE,
1588: p_dm_number OUT NOCOPY ar_payment_schedules.trx_number%TYPE,
1589: p_dm_doc_sequence_value IN ra_customer_trx.doc_sequence_value%TYPE,
1590: p_dm_doc_sequence_id IN ra_customer_trx.doc_sequence_id%TYPE,
1591: p_status IN OUT NOCOPY VARCHAR2,
1592: p_module_name IN VARCHAR2,
1593: p_module_version IN VARCHAR2 ) IS
1594:

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 1613: l_ct_rec ra_customer_trx%ROWTYPE;

1609: l_rev1_amount ar_cash_receipt_history.amount%TYPE;
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;

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 1617: l_trx_number ra_customer_trx.trx_number%TYPE;

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;
1619: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE;
1620:
1621: l_count NUMBER := 0;

Line 1618: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;

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;
1619: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE;
1620:
1621: l_count NUMBER := 0;
1622:

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 1626: l_trx_date_dummy ra_customer_trx.trx_date%type;

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:
1629: l_commit_cust_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
1630: l_rowid rowid;

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 1651: l_legal_entity_id ra_customer_trx.legal_entity_id%TYPE;

1647: /* Document Sequencing Project Changes */
1648: l_copy_doc_number_flag RA_BATCH_SOURCES.copy_doc_number_flag%TYPE;
1649:
1650: /*Legal Entity for DM reversal 5126184*/
1651: l_legal_entity_id ra_customer_trx.legal_entity_id%TYPE;
1652:
1653: /* 08-SEP-1999 J Rautiainen BugFix for bug 976703
1654: * Cursor customer_C was split into two separate cursors for performance
1655: * reasons */

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

Line 1908: ra_customer_trx, ra_cust_trx_types

1904: SELECT decode ( max(dummy), NULL, 'N','Y')
1905: INTO l_does_it_exist
1906: from dual
1907: where exists (select trx_number from
1908: ra_customer_trx, ra_cust_trx_types
1909: where trx_number = l_ct_rec.trx_number
1910: and batch_source_id = l_ct_rec.batch_source_id
1911: and ra_customer_trx.cust_trx_type_id =
1912: ra_cust_trx_types.cust_trx_type_id

Line 1911: and ra_customer_trx.cust_trx_type_id =

1907: where exists (select trx_number from
1908: ra_customer_trx, ra_cust_trx_types
1909: where trx_number = l_ct_rec.trx_number
1910: and batch_source_id = l_ct_rec.batch_source_id
1911: and ra_customer_trx.cust_trx_type_id =
1912: ra_cust_trx_types.cust_trx_type_id
1913: and ra_cust_trx_types.type = 'DM');
1914:
1915: /* if a DM exists with the same number and the same batch source,

Line 2046: /* Bug3328690 To update the reversed cash_receipt id in ra_customer_trx */

2042:
2043: -- update debit memo with document number :
2044: -- Also copy the Document Number into Trx Number if "Copy" Flag set at Batch Source.
2045:
2046: /* Bug3328690 To update the reversed cash_receipt id in ra_customer_trx */
2047: /* Bug3347452 To Type Cast explicit p_dm_sequence_value to character
2048: in NVL as it raises -ORA-01722 invalid number */
2049:
2050: IF l_copy_doc_number_flag = 'Y' THEN

Line 2051: UPDATE ra_customer_trx

2047: /* Bug3347452 To Type Cast explicit p_dm_sequence_value to character
2048: in NVL as it raises -ORA-01722 invalid number */
2049:
2050: IF l_copy_doc_number_flag = 'Y' THEN
2051: UPDATE ra_customer_trx
2052: SET DOC_SEQUENCE_VALUE = p_dm_doc_sequence_value,
2053: DOC_SEQUENCE_ID = p_dm_doc_sequence_id,
2054: /* Bug3347452 */
2055: /*TRX_NUMBER = NVL(p_dm_doc_sequence_value, TRX_NUMBER),*/

Line 2074: UPDATE ra_customer_trx

2070: SET TRX_NUMBER = NVL(TO_CHAR(p_dm_doc_sequence_value), TRX_NUMBER)
2071: WHERE reversed_cash_receipt_id = l_cr_id;
2072:
2073: ELSE
2074: UPDATE ra_customer_trx
2075: SET DOC_SEQUENCE_VALUE = p_dm_doc_sequence_value,
2076: DOC_SEQUENCE_ID = p_dm_doc_sequence_id,
2077: REVERSED_CASH_RECEIPT_ID=l_cr_id /*3328690 */
2078: WHERE customer_trx_id = (

Line 2308: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;

2304: l_invoice_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
2305: l_claim_reason_code_id NUMBER;
2306: l_claim_reason_name VARCHAR2(80);
2307: l_claim_number VARCHAR2(30);
2308: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;
2309: l_claim_amount NUMBER;
2310:
2311: CURSOR c_claims IS
2312: SELECT secondary_application_ref_id,