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_CASHBOOK dependencies on AR_CASH_RECEIPTS

Line 9: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

5: --
6: -- Public Procedures
7: --
8: PROCEDURE clear(
9: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
10: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
11: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
12: p_actual_value_date IN DATE,
13: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,

Line 35: p_exchange_rate * ar_cash_receipts.amount

31: In this case, it assumes the following has been
32: validated before calling this procedure:
33:
34: p_amount_cleared+p_amount_factored =
35: p_exchange_rate * ar_cash_receipts.amount
36:
37: 3. If p_bank_currency = the currency of the receipt,
38: In this case, it assumes the following has been validated
39: before calling this procedure:

Line 42: ar_cash_receipts.amount

38: In this case, it assumes the following has been validated
39: before calling this procedure:
40:
41: p_amount_cleared+p_amount_factored =
42: ar_cash_receipts.amount
43:
44: ------------------------------------*/
45: l_cr_rec ar_cash_receipts%ROWTYPE;
46: l_rma_rec ar_receipt_method_accounts%ROWTYPE;

Line 45: l_cr_rec ar_cash_receipts%ROWTYPE;

41: p_amount_cleared+p_amount_factored =
42: ar_cash_receipts.amount
43:
44: ------------------------------------*/
45: l_cr_rec ar_cash_receipts%ROWTYPE;
46: l_rma_rec ar_receipt_method_accounts%ROWTYPE;
47: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
48: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
49: l_dist_rec ar_distributions%ROWTYPE;

Line 57: l_convert_receipt_amt ar_cash_receipts.amount%TYPE;

53: l_cash_amt ar_cash_receipt_history.amount%TYPE;
54: l_acctd_cash_amt ar_cash_receipt_history.acctd_amount%TYPE;
55: l_bank_amt ar_cash_receipt_history.factor_discount_amount%TYPE;
56: l_acctd_bank_amt ar_cash_receipt_history.acctd_factor_discount_amount%TYPE;
57: l_convert_receipt_amt ar_cash_receipts.amount%TYPE;
58: --Bug#2750340
59: l_event_rec arp_xla_events.xla_events_type;
60:
61: BEGIN

Line 713: -- Call arplbrad.main() to take care the ar_cash_receipts, ar_payment_schedules

709: END IF;
710:
711: -- If exchange rate has been changed
712: -- Insert a record into ar_rate_adjustments
713: -- Call arplbrad.main() to take care the ar_cash_receipts, ar_payment_schedules
714: -- and ar_receivable_applications/ar_misc_cash_distributions
715: --
716: -- 17-MAY-1999 J Rautiainen truncation exits on exchange rate so the comparison
717: -- was changed from comparing exchange rates to comparing accounted amounts in order

Line 761: UPDATE AR_CASH_RECEIPTS

757:
758:
759: -- Insert value date into CR record
760:
761: UPDATE AR_CASH_RECEIPTS
762: SET actual_value_date = p_actual_value_date,
763: rec_version_number = nvl(rec_version_number,1)+1 /* bug 3372585 */
764: WHERE cash_receipt_id = p_cr_id;
765:

Line 782: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

778:
779: END clear;
780:
781: PROCEDURE unclear(
782: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
783: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
784: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
785: p_actual_value_date IN ar_cash_receipts.actual_value_date%TYPE,
786: p_module_name IN VARCHAR2,

Line 785: p_actual_value_date IN ar_cash_receipts.actual_value_date%TYPE,

781: PROCEDURE unclear(
782: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
783: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
784: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
785: p_actual_value_date IN ar_cash_receipts.actual_value_date%TYPE,
786: p_module_name IN VARCHAR2,
787: p_module_version IN VARCHAR2,
788: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
789: --

Line 790: l_cr_rec ar_cash_receipts%ROWTYPE;

786: p_module_name IN VARCHAR2,
787: p_module_version IN VARCHAR2,
788: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
789: --
790: l_cr_rec ar_cash_receipts%ROWTYPE;
791: l_crh_rec_prv_stat ar_cash_receipt_history%ROWTYPE;
792: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
793: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
794: l_rma_rec ar_receipt_method_accounts%ROWTYPE;

Line 1137: UPDATE AR_CASH_RECEIPTS

1133: END IF;
1134:
1135: -- Insert value date into CR record
1136:
1137: UPDATE AR_CASH_RECEIPTS
1138: SET actual_value_date = p_actual_value_date,
1139: rec_version_number = nvl(rec_version_number,1)+1 /* bug 3372585 */
1140: WHERE cash_receipt_id = p_cr_id;
1141:

Line 1164: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

1160:
1161: END unclear;
1162:
1163: PROCEDURE risk_eliminate(
1164: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1165: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
1166: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1167: p_module_name IN VARCHAR2,
1168: p_module_version IN VARCHAR2,

Line 1177: l_cr_rec ar_cash_receipts%ROWTYPE;

1173: l_dist_rec ar_distributions%ROWTYPE;
1174: l_receipt_amt ar_cash_receipt_history.amount%TYPE;
1175: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;
1176: NULL_VAR ar_receipt_method_accounts%ROWTYPE;
1177: l_cr_rec ar_cash_receipts%ROWTYPE;
1178: l_risk_event_rec arp_xla_events.xla_events_type;
1179: BEGIN
1180:
1181: IF PG_DEBUG in ('Y', 'C') THEN

Line 1380: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

1376:
1377: END risk_eliminate;
1378:
1379: PROCEDURE undo_risk_eliminate(
1380: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1381: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
1382: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1383: p_module_name IN VARCHAR2,
1384: p_module_version IN VARCHAR2,

Line 1393: l_cr_rec ar_cash_receipts%ROWTYPE;

1389: l_dist_rec ar_distributions%ROWTYPE;
1390: l_receipt_amt ar_cash_receipt_history.amount%TYPE;
1391: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;
1392: NULL_VAR ar_receipt_method_accounts%ROWTYPE;
1393: l_cr_rec ar_cash_receipts%ROWTYPE;
1394: BEGIN
1395:
1396: IF PG_DEBUG in ('Y', 'C') THEN
1397: arp_util.debug( '>>>>>>> arp_cashbook.undo_risk_eliminate' );

Line 1635: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,

1631: | insert_misc_receipt()
1632: +===========================================================================*/
1633:
1634: PROCEDURE ins_misc_txn(
1635: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
1636: p_document_number IN ar_cash_receipts.doc_sequence_value%TYPE,
1637: p_doc_sequence_id IN ar_cash_receipts.doc_sequence_id%TYPE,
1638: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1639: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,

Line 1636: p_document_number IN ar_cash_receipts.doc_sequence_value%TYPE,

1632: +===========================================================================*/
1633:
1634: PROCEDURE ins_misc_txn(
1635: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
1636: p_document_number IN ar_cash_receipts.doc_sequence_value%TYPE,
1637: p_doc_sequence_id IN ar_cash_receipts.doc_sequence_id%TYPE,
1638: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1639: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
1640: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,

Line 1637: p_doc_sequence_id IN ar_cash_receipts.doc_sequence_id%TYPE,

1633:
1634: PROCEDURE ins_misc_txn(
1635: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
1636: p_document_number IN ar_cash_receipts.doc_sequence_value%TYPE,
1637: p_doc_sequence_id IN ar_cash_receipts.doc_sequence_id%TYPE,
1638: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1639: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
1640: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
1641: p_receipt_amount IN ar_cash_receipts.amount%TYPE,

Line 1639: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,

1635: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
1636: p_document_number IN ar_cash_receipts.doc_sequence_value%TYPE,
1637: p_doc_sequence_id IN ar_cash_receipts.doc_sequence_id%TYPE,
1638: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1639: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
1640: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
1641: p_receipt_amount IN ar_cash_receipts.amount%TYPE,
1642: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1643: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,

Line 1640: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,

1636: p_document_number IN ar_cash_receipts.doc_sequence_value%TYPE,
1637: p_doc_sequence_id IN ar_cash_receipts.doc_sequence_id%TYPE,
1638: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1639: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
1640: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
1641: p_receipt_amount IN ar_cash_receipts.amount%TYPE,
1642: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1643: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
1644: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,

Line 1641: p_receipt_amount IN ar_cash_receipts.amount%TYPE,

1637: p_doc_sequence_id IN ar_cash_receipts.doc_sequence_id%TYPE,
1638: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1639: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
1640: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
1641: p_receipt_amount IN ar_cash_receipts.amount%TYPE,
1642: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1643: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
1644: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
1645: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,

Line 1642: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

1638: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1639: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
1640: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
1641: p_receipt_amount IN ar_cash_receipts.amount%TYPE,
1642: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1643: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
1644: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
1645: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
1646: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,

Line 1646: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,

1642: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1643: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
1644: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
1645: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
1646: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
1647: p_remit_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
1648: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
1649: p_comments IN ar_cash_receipts.comments%TYPE,
1650: p_vat_tax_id IN ar_cash_receipts.vat_tax_id%TYPE,

Line 1647: p_remit_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,

1643: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
1644: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
1645: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
1646: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
1647: p_remit_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
1648: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
1649: p_comments IN ar_cash_receipts.comments%TYPE,
1650: p_vat_tax_id IN ar_cash_receipts.vat_tax_id%TYPE,
1651: p_reference_type IN ar_cash_receipts.reference_type%TYPE,

Line 1648: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,

1644: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
1645: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
1646: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
1647: p_remit_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
1648: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
1649: p_comments IN ar_cash_receipts.comments%TYPE,
1650: p_vat_tax_id IN ar_cash_receipts.vat_tax_id%TYPE,
1651: p_reference_type IN ar_cash_receipts.reference_type%TYPE,
1652: p_reference_id IN ar_cash_receipts.reference_id%TYPE,

Line 1649: p_comments IN ar_cash_receipts.comments%TYPE,

1645: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
1646: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
1647: p_remit_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
1648: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
1649: p_comments IN ar_cash_receipts.comments%TYPE,
1650: p_vat_tax_id IN ar_cash_receipts.vat_tax_id%TYPE,
1651: p_reference_type IN ar_cash_receipts.reference_type%TYPE,
1652: p_reference_id IN ar_cash_receipts.reference_id%TYPE,
1653: p_misc_payment_source IN ar_cash_receipts.misc_payment_source%TYPE,

Line 1650: p_vat_tax_id IN ar_cash_receipts.vat_tax_id%TYPE,

1646: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
1647: p_remit_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
1648: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
1649: p_comments IN ar_cash_receipts.comments%TYPE,
1650: p_vat_tax_id IN ar_cash_receipts.vat_tax_id%TYPE,
1651: p_reference_type IN ar_cash_receipts.reference_type%TYPE,
1652: p_reference_id IN ar_cash_receipts.reference_id%TYPE,
1653: p_misc_payment_source IN ar_cash_receipts.misc_payment_source%TYPE,
1654: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,

Line 1651: p_reference_type IN ar_cash_receipts.reference_type%TYPE,

1647: p_remit_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
1648: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
1649: p_comments IN ar_cash_receipts.comments%TYPE,
1650: p_vat_tax_id IN ar_cash_receipts.vat_tax_id%TYPE,
1651: p_reference_type IN ar_cash_receipts.reference_type%TYPE,
1652: p_reference_id IN ar_cash_receipts.reference_id%TYPE,
1653: p_misc_payment_source IN ar_cash_receipts.misc_payment_source%TYPE,
1654: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
1655: p_module_name IN VARCHAR2,

Line 1652: p_reference_id IN ar_cash_receipts.reference_id%TYPE,

1648: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
1649: p_comments IN ar_cash_receipts.comments%TYPE,
1650: p_vat_tax_id IN ar_cash_receipts.vat_tax_id%TYPE,
1651: p_reference_type IN ar_cash_receipts.reference_type%TYPE,
1652: p_reference_id IN ar_cash_receipts.reference_id%TYPE,
1653: p_misc_payment_source IN ar_cash_receipts.misc_payment_source%TYPE,
1654: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
1655: p_module_name IN VARCHAR2,
1656: p_module_version IN VARCHAR2,

Line 1653: p_misc_payment_source IN ar_cash_receipts.misc_payment_source%TYPE,

1649: p_comments IN ar_cash_receipts.comments%TYPE,
1650: p_vat_tax_id IN ar_cash_receipts.vat_tax_id%TYPE,
1651: p_reference_type IN ar_cash_receipts.reference_type%TYPE,
1652: p_reference_id IN ar_cash_receipts.reference_id%TYPE,
1653: p_misc_payment_source IN ar_cash_receipts.misc_payment_source%TYPE,
1654: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
1655: p_module_name IN VARCHAR2,
1656: p_module_version IN VARCHAR2,
1657: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,

Line 1654: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,

1650: p_vat_tax_id IN ar_cash_receipts.vat_tax_id%TYPE,
1651: p_reference_type IN ar_cash_receipts.reference_type%TYPE,
1652: p_reference_id IN ar_cash_receipts.reference_id%TYPE,
1653: p_misc_payment_source IN ar_cash_receipts.misc_payment_source%TYPE,
1654: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
1655: p_module_name IN VARCHAR2,
1656: p_module_version IN VARCHAR2,
1657: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
1658: p_tax_rate IN NUMBER ) IS

Line 1657: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,

1653: p_misc_payment_source IN ar_cash_receipts.misc_payment_source%TYPE,
1654: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
1655: p_module_name IN VARCHAR2,
1656: p_module_version IN VARCHAR2,
1657: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
1658: p_tax_rate IN NUMBER ) IS
1659: --
1660: p_row_id VARCHAR2(30);
1661: l_cr_id ar_cash_Receipts.cash_receipt_id%TYPE;

Line 1661: l_cr_id ar_cash_Receipts.cash_receipt_id%TYPE;

1657: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
1658: p_tax_rate IN NUMBER ) IS
1659: --
1660: p_row_id VARCHAR2(30);
1661: l_cr_id ar_cash_Receipts.cash_receipt_id%TYPE;
1662: l_dis_set_id ar_cash_receipts.distribution_set_id%TYPE;
1663: /* Bug fix 2300268 */
1664: l_tax_account_id ar_distributions.code_combination_id%TYPE;
1665: /* Bug fix 2742388 */

Line 1662: l_dis_set_id ar_cash_receipts.distribution_set_id%TYPE;

1658: p_tax_rate IN NUMBER ) IS
1659: --
1660: p_row_id VARCHAR2(30);
1661: l_cr_id ar_cash_Receipts.cash_receipt_id%TYPE;
1662: l_dis_set_id ar_cash_receipts.distribution_set_id%TYPE;
1663: /* Bug fix 2300268 */
1664: l_tax_account_id ar_distributions.code_combination_id%TYPE;
1665: /* Bug fix 2742388 */
1666: l_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

Line 1791: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

1787:
1788: END ins_misc_txn;
1789:
1790: PROCEDURE reverse(
1791: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1792: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
1793: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
1794: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
1795: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,

Line 1793: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,

1789:
1790: PROCEDURE reverse(
1791: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1792: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
1793: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
1794: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
1795: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
1796: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
1797: p_module_name IN VARCHAR2,

Line 1794: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,

1790: PROCEDURE reverse(
1791: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1792: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
1793: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
1794: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
1795: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
1796: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
1797: p_module_name IN VARCHAR2,
1798: p_module_version IN VARCHAR2,

Line 1795: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,

1791: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1792: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
1793: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
1794: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
1795: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
1796: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
1797: p_module_name IN VARCHAR2,
1798: p_module_version IN VARCHAR2,
1799: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE) IS

Line 1796: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,

1792: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
1793: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
1794: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
1795: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
1796: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
1797: p_module_name IN VARCHAR2,
1798: p_module_version IN VARCHAR2,
1799: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE) IS
1800:

Line 1808: l_reversal_category AR_CASH_RECEIPTS.REVERSAL_CATEGORY%TYPE;

1804: WHERE crh.cash_receipt_id = p_cr_id
1805: AND crh.current_record_flag = 'Y'
1806: AND crh.status = 'REVERSED';
1807:
1808: l_reversal_category AR_CASH_RECEIPTS.REVERSAL_CATEGORY%TYPE;
1809: l_reversal_reason_code AR_CASH_RECEIPTS.REVERSAL_REASON_CODE%TYPE;
1810: l_attribute_rec AR_RECEIPT_API_PUB.ATTRIBUTE_REC_TYPE; /* Added for bug 2688370 */
1811: l_return_status VARCHAR2(1);
1812: l_msg_count NUMBER;

Line 1809: l_reversal_reason_code AR_CASH_RECEIPTS.REVERSAL_REASON_CODE%TYPE;

1805: AND crh.current_record_flag = 'Y'
1806: AND crh.status = 'REVERSED';
1807:
1808: l_reversal_category AR_CASH_RECEIPTS.REVERSAL_CATEGORY%TYPE;
1809: l_reversal_reason_code AR_CASH_RECEIPTS.REVERSAL_REASON_CODE%TYPE;
1810: l_attribute_rec AR_RECEIPT_API_PUB.ATTRIBUTE_REC_TYPE; /* Added for bug 2688370 */
1811: l_return_status VARCHAR2(1);
1812: l_msg_count NUMBER;
1813: l_msg_data VARCHAR2(2000);

Line 1860: FROM ar_cash_receipts

1856: l_attribute_rec.attribute9, l_attribute_rec.attribute10,
1857: l_attribute_rec.attribute11, l_attribute_rec.attribute12,
1858: l_attribute_rec.attribute13, l_attribute_rec.attribute14,
1859: l_attribute_rec.attribute15
1860: FROM ar_cash_receipts
1861: WHERE cash_receipt_id = p_cr_id;
1862:
1863: BEGIN
1864:

Line 1983: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,

1979:
1980: END reverse;
1981:
1982: PROCEDURE debit_memo_reversal (
1983: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1984: p_cc_id IN ra_cust_trx_line_gl_dist.code_combination_id%TYPE,
1985: p_dm_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
1986: p_dm_cust_trx_type IN ra_cust_trx_types.name%TYPE,
1987: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,

Line 1988: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,

1984: p_cc_id IN ra_cust_trx_line_gl_dist.code_combination_id%TYPE,
1985: p_dm_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
1986: p_dm_cust_trx_type IN ra_cust_trx_types.name%TYPE,
1987: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
1988: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
1989: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
1990: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
1991: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
1992: p_dm_number OUT NOCOPY ar_payment_schedules.trx_number%TYPE,

Line 1989: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,

1985: p_dm_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
1986: p_dm_cust_trx_type IN ra_cust_trx_types.name%TYPE,
1987: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
1988: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
1989: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
1990: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
1991: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
1992: p_dm_number OUT NOCOPY ar_payment_schedules.trx_number%TYPE,
1993: p_dm_doc_sequence_value IN ra_customer_trx.doc_sequence_value%TYPE,

Line 1990: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,

1986: p_dm_cust_trx_type IN ra_cust_trx_types.name%TYPE,
1987: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
1988: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
1989: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
1990: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
1991: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
1992: p_dm_number OUT NOCOPY ar_payment_schedules.trx_number%TYPE,
1993: p_dm_doc_sequence_value IN ra_customer_trx.doc_sequence_value%TYPE,
1994: p_dm_doc_sequence_id IN ra_customer_trx.doc_sequence_id%TYPE,

Line 1991: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,

1987: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
1988: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
1989: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
1990: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
1991: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
1992: p_dm_number OUT NOCOPY ar_payment_schedules.trx_number%TYPE,
1993: p_dm_doc_sequence_value IN ra_customer_trx.doc_sequence_value%TYPE,
1994: p_dm_doc_sequence_id IN ra_customer_trx.doc_sequence_id%TYPE,
1995: p_tw_status IN OUT NOCOPY VARCHAR2,

Line 2018: l_cr_rec ar_cash_receipts%ROWTYPE;

2014: WHERE ra.cash_receipt_id = p_cash_receipt_id
2015: AND ra.applied_payment_schedule_id = -2
2016: AND ra.display = 'Y';
2017:
2018: l_cr_rec ar_cash_receipts%ROWTYPE;
2019: l_dm_number ar_payment_schedules.trx_number%TYPE;
2020: applied_to_reserved_br_rec applied_to_reserved_br_cur%ROWTYPE;
2021: applied_to_std_rec applied_to_std_cur%ROWTYPE;
2022:

Line 2147: FROM ar_cash_receipt_history crh, ar_cash_receipts acr

2143: IS
2144:
2145: CURSOR C IS
2146: SELECT crh.cash_receipt_history_id
2147: FROM ar_cash_receipt_history crh, ar_cash_receipts acr
2148: WHERE crh.batch_id = P_BATCH_ID
2149: AND crh.status not in ('REVERSED')
2150: AND crh.cash_receipt_id = acr.cash_receipt_id
2151: FOR UPDATE NOWAIT;

Line 2349: UPDATE AR_CASH_RECEIPTS

2345: PROCEDURE update_actual_value_date(p_cash_receipt_id IN NUMBER,
2346: p_actual_value_date IN DATE) IS
2347: BEGIN
2348:
2349: UPDATE AR_CASH_RECEIPTS
2350: SET actual_value_date = p_actual_value_date,
2351: rec_version_number = nvl(rec_version_number,1)+1 /* bug 3372585 */
2352: WHERE cash_receipt_id = p_cash_receipt_id;
2353: