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 10: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

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

Line 36: p_exchange_rate * ar_cash_receipts.amount

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

Line 43: ar_cash_receipts.amount

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

Line 46: l_cr_rec ar_cash_receipts%ROWTYPE;

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

Line 58: l_convert_receipt_amt ar_cash_receipts.amount%TYPE;

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

Line 63: l_receipt_number ar_cash_receipts.receipt_number%TYPE;

59: --Bug#2750340
60: l_event_rec arp_xla_events.xla_events_type;
61: l_org_id number;
62:
63: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
64: l_payment_trxn_extn_id iby_fndcpt_tx_operations.trxn_extension_id%type;
65: l_status BOOLEAN := FALSE;
66: l_settle_error_message varchar2(2000);
67: settlement_pending_raise exception;

Line 100: from ar_cash_receipts_all

96: -- Bug 7443802
97:
98: begin
99: select org_id into l_org_id
100: from ar_cash_receipts_all
101: where cash_receipt_id = p_cr_id;
102:
103: mo_global.init('AR');
104: mo_global.set_policy_context('S',l_org_id);

Line 128: FROM ar_cash_receipts

124: END IF;
125:
126: SELECT receipt_number, payment_trxn_extension_id
127: into l_receipt_number, l_payment_trxn_extn_id
128: FROM ar_cash_receipts
129: WHERE cash_receipt_id = p_cr_id ;
130:
131: IF PG_DEBUG in ('Y', 'C') THEN
132: arp_standard.debug('l_receipt_number: '|| l_receipt_number);

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

908: END IF;
909:
910: -- If exchange rate has been changed
911: -- Insert a record into ar_rate_adjustments
912: -- Call arplbrad.main() to take care the ar_cash_receipts, ar_payment_schedules
913: -- and ar_receivable_applications/ar_misc_cash_distributions
914: --
915: -- 17-MAY-1999 J Rautiainen truncation exits on exchange rate so the comparison
916: -- was changed from comparing exchange rates to comparing accounted amounts in order

Line 960: UPDATE AR_CASH_RECEIPTS

956:
957:
958: -- Insert value date into CR record
959: --Yao Zhang modified for bug 10124745
960: UPDATE AR_CASH_RECEIPTS
961: SET actual_value_date = p_actual_value_date,
962: rec_version_number = nvl(rec_version_number,1)+1, /* bug 3372585 */
963: last_updated_by = arp_global.last_updated_by,
964: last_update_date = SYSDATE,

Line 1055: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

1051:
1052: END clear;
1053:
1054: PROCEDURE unclear(
1055: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1056: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
1057: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1058: p_actual_value_date IN ar_cash_receipts.actual_value_date%TYPE,
1059: p_module_name IN VARCHAR2,

Line 1058: p_actual_value_date IN ar_cash_receipts.actual_value_date%TYPE,

1054: PROCEDURE unclear(
1055: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1056: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
1057: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1058: p_actual_value_date IN ar_cash_receipts.actual_value_date%TYPE,
1059: p_module_name IN VARCHAR2,
1060: p_module_version IN VARCHAR2,
1061: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
1062: --

Line 1063: l_cr_rec ar_cash_receipts%ROWTYPE;

1059: p_module_name IN VARCHAR2,
1060: p_module_version IN VARCHAR2,
1061: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
1062: --
1063: l_cr_rec ar_cash_receipts%ROWTYPE;
1064: l_crh_rec_prv_stat ar_cash_receipt_history%ROWTYPE;
1065: l_crh_rec_fr_radj ar_cash_receipt_history%ROWTYPE;
1066: l_crh_rec_prv_stat_cash ar_cash_receipt_history%ROWTYPE;
1067: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;

Line 1481: UPDATE AR_CASH_RECEIPTS

1477: END IF;
1478:
1479: -- Insert value date into CR record
1480: --Yao zhang modified for bug 10124745
1481: UPDATE AR_CASH_RECEIPTS
1482: SET actual_value_date = p_actual_value_date,
1483: rec_version_number = nvl(rec_version_number,1)+1, /* bug 3372585 */
1484: last_updated_by = arp_global.last_updated_by,
1485: last_update_date = SYSDATE,

Line 1511: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

1507:
1508: END unclear;
1509:
1510: PROCEDURE risk_eliminate(
1511: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1512: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
1513: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1514: p_module_name IN VARCHAR2,
1515: p_module_version IN VARCHAR2,

Line 1524: l_cr_rec ar_cash_receipts%ROWTYPE;

1520: l_dist_rec ar_distributions%ROWTYPE;
1521: l_receipt_amt ar_cash_receipt_history.amount%TYPE;
1522: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;
1523: NULL_VAR ar_receipt_method_accounts%ROWTYPE;
1524: l_cr_rec ar_cash_receipts%ROWTYPE;
1525: l_risk_event_rec arp_xla_events.xla_events_type;
1526:
1527: /* 9363502 - define tables used by refresh_at_risk_value */
1528: l_customer_id_tab ar_bus_event_sub_pvt.generic_id_type;

Line 1789: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

1785:
1786: END risk_eliminate;
1787:
1788: PROCEDURE undo_risk_eliminate(
1789: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1790: p_trx_date IN ar_cash_receipt_history.trx_date%TYPE,
1791: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1792: p_module_name IN VARCHAR2,
1793: p_module_version IN VARCHAR2,

Line 1802: l_cr_rec ar_cash_receipts%ROWTYPE;

1798: l_dist_rec ar_distributions%ROWTYPE;
1799: l_receipt_amt ar_cash_receipt_history.amount%TYPE;
1800: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;
1801: NULL_VAR ar_receipt_method_accounts%ROWTYPE;
1802: l_cr_rec ar_cash_receipts%ROWTYPE;
1803: BEGIN
1804:
1805: IF PG_DEBUG in ('Y', 'C') THEN
1806: arp_util.debug( '>>>>>>> arp_cashbook.undo_risk_eliminate' );

Line 2047: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,

2043: | policy with check option violation
2044: +===========================================================================*/
2045:
2046: PROCEDURE ins_misc_txn(
2047: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
2048: p_document_number IN ar_cash_receipts.doc_sequence_value%TYPE,
2049: p_doc_sequence_id IN ar_cash_receipts.doc_sequence_id%TYPE,
2050: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
2051: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,

Line 2048: p_document_number IN ar_cash_receipts.doc_sequence_value%TYPE,

2044: +===========================================================================*/
2045:
2046: PROCEDURE ins_misc_txn(
2047: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
2048: p_document_number IN ar_cash_receipts.doc_sequence_value%TYPE,
2049: p_doc_sequence_id IN ar_cash_receipts.doc_sequence_id%TYPE,
2050: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
2051: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
2052: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,

Line 2049: p_doc_sequence_id IN ar_cash_receipts.doc_sequence_id%TYPE,

2045:
2046: PROCEDURE ins_misc_txn(
2047: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
2048: p_document_number IN ar_cash_receipts.doc_sequence_value%TYPE,
2049: p_doc_sequence_id IN ar_cash_receipts.doc_sequence_id%TYPE,
2050: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
2051: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
2052: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
2053: p_receipt_amount IN ar_cash_receipts.amount%TYPE,

Line 2051: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,

2047: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
2048: p_document_number IN ar_cash_receipts.doc_sequence_value%TYPE,
2049: p_doc_sequence_id IN ar_cash_receipts.doc_sequence_id%TYPE,
2050: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
2051: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
2052: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
2053: p_receipt_amount IN ar_cash_receipts.amount%TYPE,
2054: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
2055: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,

Line 2052: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,

2048: p_document_number IN ar_cash_receipts.doc_sequence_value%TYPE,
2049: p_doc_sequence_id IN ar_cash_receipts.doc_sequence_id%TYPE,
2050: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
2051: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
2052: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
2053: p_receipt_amount IN ar_cash_receipts.amount%TYPE,
2054: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
2055: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
2056: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,

Line 2053: p_receipt_amount IN ar_cash_receipts.amount%TYPE,

2049: p_doc_sequence_id IN ar_cash_receipts.doc_sequence_id%TYPE,
2050: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
2051: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
2052: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
2053: p_receipt_amount IN ar_cash_receipts.amount%TYPE,
2054: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
2055: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
2056: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
2057: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,

Line 2054: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

2050: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
2051: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
2052: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
2053: p_receipt_amount IN ar_cash_receipts.amount%TYPE,
2054: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
2055: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
2056: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
2057: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
2058: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,

Line 2058: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,

2054: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
2055: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
2056: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
2057: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
2058: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
2059: p_remit_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
2060: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
2061: p_comments IN ar_cash_receipts.comments%TYPE,
2062: p_vat_tax_id IN ar_cash_receipts.vat_tax_id%TYPE,

Line 2059: p_remit_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,

2055: p_exchange_date IN ar_cash_receipt_history.exchange_date%TYPE,
2056: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
2057: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
2058: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
2059: p_remit_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
2060: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
2061: p_comments IN ar_cash_receipts.comments%TYPE,
2062: p_vat_tax_id IN ar_cash_receipts.vat_tax_id%TYPE,
2063: p_reference_type IN ar_cash_receipts.reference_type%TYPE,

Line 2060: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,

2056: p_exchange_rate_type IN ar_cash_receipt_history.exchange_rate_type%TYPE,
2057: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
2058: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
2059: p_remit_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
2060: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
2061: p_comments IN ar_cash_receipts.comments%TYPE,
2062: p_vat_tax_id IN ar_cash_receipts.vat_tax_id%TYPE,
2063: p_reference_type IN ar_cash_receipts.reference_type%TYPE,
2064: p_reference_id IN ar_cash_receipts.reference_id%TYPE,

Line 2061: p_comments IN ar_cash_receipts.comments%TYPE,

2057: p_exchange_rate IN ar_cash_receipt_history.exchange_rate%TYPE,
2058: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
2059: p_remit_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
2060: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
2061: p_comments IN ar_cash_receipts.comments%TYPE,
2062: p_vat_tax_id IN ar_cash_receipts.vat_tax_id%TYPE,
2063: p_reference_type IN ar_cash_receipts.reference_type%TYPE,
2064: p_reference_id IN ar_cash_receipts.reference_id%TYPE,
2065: p_misc_payment_source IN ar_cash_receipts.misc_payment_source%TYPE,

Line 2062: p_vat_tax_id IN ar_cash_receipts.vat_tax_id%TYPE,

2058: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
2059: p_remit_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
2060: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
2061: p_comments IN ar_cash_receipts.comments%TYPE,
2062: p_vat_tax_id IN ar_cash_receipts.vat_tax_id%TYPE,
2063: p_reference_type IN ar_cash_receipts.reference_type%TYPE,
2064: p_reference_id IN ar_cash_receipts.reference_id%TYPE,
2065: p_misc_payment_source IN ar_cash_receipts.misc_payment_source%TYPE,
2066: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,

Line 2063: p_reference_type IN ar_cash_receipts.reference_type%TYPE,

2059: p_remit_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
2060: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
2061: p_comments IN ar_cash_receipts.comments%TYPE,
2062: p_vat_tax_id IN ar_cash_receipts.vat_tax_id%TYPE,
2063: p_reference_type IN ar_cash_receipts.reference_type%TYPE,
2064: p_reference_id IN ar_cash_receipts.reference_id%TYPE,
2065: p_misc_payment_source IN ar_cash_receipts.misc_payment_source%TYPE,
2066: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
2067: p_module_name IN VARCHAR2,

Line 2064: p_reference_id IN ar_cash_receipts.reference_id%TYPE,

2060: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
2061: p_comments IN ar_cash_receipts.comments%TYPE,
2062: p_vat_tax_id IN ar_cash_receipts.vat_tax_id%TYPE,
2063: p_reference_type IN ar_cash_receipts.reference_type%TYPE,
2064: p_reference_id IN ar_cash_receipts.reference_id%TYPE,
2065: p_misc_payment_source IN ar_cash_receipts.misc_payment_source%TYPE,
2066: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
2067: p_module_name IN VARCHAR2,
2068: p_module_version IN VARCHAR2,

Line 2065: p_misc_payment_source IN ar_cash_receipts.misc_payment_source%TYPE,

2061: p_comments IN ar_cash_receipts.comments%TYPE,
2062: p_vat_tax_id IN ar_cash_receipts.vat_tax_id%TYPE,
2063: p_reference_type IN ar_cash_receipts.reference_type%TYPE,
2064: p_reference_id IN ar_cash_receipts.reference_id%TYPE,
2065: p_misc_payment_source IN ar_cash_receipts.misc_payment_source%TYPE,
2066: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
2067: p_module_name IN VARCHAR2,
2068: p_module_version IN VARCHAR2,
2069: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,

Line 2066: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,

2062: p_vat_tax_id IN ar_cash_receipts.vat_tax_id%TYPE,
2063: p_reference_type IN ar_cash_receipts.reference_type%TYPE,
2064: p_reference_id IN ar_cash_receipts.reference_id%TYPE,
2065: p_misc_payment_source IN ar_cash_receipts.misc_payment_source%TYPE,
2066: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
2067: p_module_name IN VARCHAR2,
2068: p_module_version IN VARCHAR2,
2069: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
2070: p_tax_rate IN NUMBER ) IS

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

2065: p_misc_payment_source IN ar_cash_receipts.misc_payment_source%TYPE,
2066: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
2067: p_module_name IN VARCHAR2,
2068: p_module_version IN VARCHAR2,
2069: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
2070: p_tax_rate IN NUMBER ) IS
2071: --
2072: p_row_id VARCHAR2(30);
2073: l_cr_id ar_cash_Receipts.cash_receipt_id%TYPE;

Line 2073: l_cr_id ar_cash_Receipts.cash_receipt_id%TYPE;

2069: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
2070: p_tax_rate IN NUMBER ) IS
2071: --
2072: p_row_id VARCHAR2(30);
2073: l_cr_id ar_cash_Receipts.cash_receipt_id%TYPE;
2074: l_dis_set_id ar_cash_receipts.distribution_set_id%TYPE;
2075: /* Bug fix 2300268 */
2076: l_tax_account_id ar_distributions.code_combination_id%TYPE;
2077: /* Bug fix 2742388 */

Line 2074: l_dis_set_id ar_cash_receipts.distribution_set_id%TYPE;

2070: p_tax_rate IN NUMBER ) IS
2071: --
2072: p_row_id VARCHAR2(30);
2073: l_cr_id ar_cash_Receipts.cash_receipt_id%TYPE;
2074: l_dis_set_id ar_cash_receipts.distribution_set_id%TYPE;
2075: /* Bug fix 2300268 */
2076: l_tax_account_id ar_distributions.code_combination_id%TYPE;
2077: /* Bug fix 2742388 */
2078: l_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

Line 2224: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,

2220:
2221: END ins_misc_txn;
2222:
2223: PROCEDURE reverse(
2224: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
2225: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
2226: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
2227: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
2228: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,

Line 2226: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,

2222:
2223: PROCEDURE reverse(
2224: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
2225: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
2226: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
2227: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
2228: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
2229: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
2230: p_module_name IN VARCHAR2,

Line 2227: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,

2223: PROCEDURE reverse(
2224: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
2225: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
2226: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
2227: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
2228: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
2229: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
2230: p_module_name IN VARCHAR2,
2231: p_module_version IN VARCHAR2,

Line 2228: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,

2224: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
2225: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
2226: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
2227: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
2228: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
2229: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
2230: p_module_name IN VARCHAR2,
2231: p_module_version IN VARCHAR2,
2232: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE) IS

Line 2229: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,

2225: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
2226: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
2227: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
2228: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
2229: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
2230: p_module_name IN VARCHAR2,
2231: p_module_version IN VARCHAR2,
2232: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE) IS
2233:

Line 2241: l_reversal_category AR_CASH_RECEIPTS.REVERSAL_CATEGORY%TYPE;

2237: WHERE crh.cash_receipt_id = p_cr_id
2238: AND crh.current_record_flag = 'Y'
2239: AND crh.status = 'REVERSED';
2240:
2241: l_reversal_category AR_CASH_RECEIPTS.REVERSAL_CATEGORY%TYPE;
2242: l_reversal_reason_code AR_CASH_RECEIPTS.REVERSAL_REASON_CODE%TYPE;
2243: l_attribute_rec AR_RECEIPT_API_PUB.ATTRIBUTE_REC_TYPE; /* Added for bug 2688370 */
2244: l_return_status VARCHAR2(1);
2245: l_msg_count NUMBER;

Line 2242: l_reversal_reason_code AR_CASH_RECEIPTS.REVERSAL_REASON_CODE%TYPE;

2238: AND crh.current_record_flag = 'Y'
2239: AND crh.status = 'REVERSED';
2240:
2241: l_reversal_category AR_CASH_RECEIPTS.REVERSAL_CATEGORY%TYPE;
2242: l_reversal_reason_code AR_CASH_RECEIPTS.REVERSAL_REASON_CODE%TYPE;
2243: l_attribute_rec AR_RECEIPT_API_PUB.ATTRIBUTE_REC_TYPE; /* Added for bug 2688370 */
2244: l_return_status VARCHAR2(1);
2245: l_msg_count NUMBER;
2246: l_msg_data VARCHAR2(2000);

Line 2293: FROM ar_cash_receipts

2289: l_attribute_rec.attribute9, l_attribute_rec.attribute10,
2290: l_attribute_rec.attribute11, l_attribute_rec.attribute12,
2291: l_attribute_rec.attribute13, l_attribute_rec.attribute14,
2292: l_attribute_rec.attribute15
2293: FROM ar_cash_receipts
2294: WHERE cash_receipt_id = p_cr_id;
2295:
2296: BEGIN
2297:

Line 2416: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,

2412:
2413: END reverse;
2414:
2415: PROCEDURE debit_memo_reversal (
2416: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
2417: p_cc_id IN ra_cust_trx_line_gl_dist.code_combination_id%TYPE,
2418: p_dm_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
2419: p_dm_cust_trx_type IN ra_cust_trx_types.name%TYPE,
2420: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,

Line 2421: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,

2417: p_cc_id IN ra_cust_trx_line_gl_dist.code_combination_id%TYPE,
2418: p_dm_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
2419: p_dm_cust_trx_type IN ra_cust_trx_types.name%TYPE,
2420: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
2421: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
2422: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
2423: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
2424: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
2425: p_dm_number OUT NOCOPY ar_payment_schedules.trx_number%TYPE,

Line 2422: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,

2418: p_dm_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
2419: p_dm_cust_trx_type IN ra_cust_trx_types.name%TYPE,
2420: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
2421: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
2422: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
2423: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
2424: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
2425: p_dm_number OUT NOCOPY ar_payment_schedules.trx_number%TYPE,
2426: p_dm_doc_sequence_value IN ra_customer_trx.doc_sequence_value%TYPE,

Line 2423: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,

2419: p_dm_cust_trx_type IN ra_cust_trx_types.name%TYPE,
2420: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
2421: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
2422: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
2423: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
2424: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
2425: p_dm_number OUT NOCOPY ar_payment_schedules.trx_number%TYPE,
2426: p_dm_doc_sequence_value IN ra_customer_trx.doc_sequence_value%TYPE,
2427: p_dm_doc_sequence_id IN ra_customer_trx.doc_sequence_id%TYPE,

Line 2424: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,

2420: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
2421: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
2422: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
2423: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
2424: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
2425: p_dm_number OUT NOCOPY ar_payment_schedules.trx_number%TYPE,
2426: p_dm_doc_sequence_value IN ra_customer_trx.doc_sequence_value%TYPE,
2427: p_dm_doc_sequence_id IN ra_customer_trx.doc_sequence_id%TYPE,
2428: p_tw_status IN OUT NOCOPY VARCHAR2,

Line 2451: l_cr_rec ar_cash_receipts%ROWTYPE;

2447: WHERE ra.cash_receipt_id = p_cash_receipt_id
2448: AND ra.applied_payment_schedule_id = -2
2449: AND ra.display = 'Y';
2450:
2451: l_cr_rec ar_cash_receipts%ROWTYPE;
2452: l_dm_number ar_payment_schedules.trx_number%TYPE;
2453: applied_to_reserved_br_rec applied_to_reserved_br_cur%ROWTYPE;
2454: applied_to_std_rec applied_to_std_cur%ROWTYPE;
2455:

Line 2580: FROM ar_cash_receipt_history crh, ar_cash_receipts acr

2576: IS
2577:
2578: CURSOR C IS
2579: SELECT crh.cash_receipt_history_id
2580: FROM ar_cash_receipt_history crh, ar_cash_receipts acr
2581: WHERE crh.batch_id = P_BATCH_ID
2582: AND crh.status not in ('REVERSED')
2583: AND crh.cash_receipt_id = acr.cash_receipt_id
2584: FOR UPDATE NOWAIT;

Line 2783: UPDATE AR_CASH_RECEIPTS

2779: p_actual_value_date IN DATE) IS
2780: BEGIN
2781:
2782: --Yao zhang modified for bug 10124745
2783: UPDATE AR_CASH_RECEIPTS
2784: SET actual_value_date = p_actual_value_date,
2785: rec_version_number = nvl(rec_version_number,1)+1, /* bug 3372585 */
2786: last_updated_by = arp_global.last_updated_by,
2787: last_update_date = SYSDATE,