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 AR_CASH_RECEIPT_HISTORY

Line 17: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,

13:
14: PROCEDURE validate_args(
15: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
16: p_reversal_category IN VARCHAR2,
17: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
18: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
19: p_reversal_reason_code IN VARCHAR2 );
20: --
21: PROCEDURE update_current_cr_rec(

Line 45: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE,

41: p_attribute14 IN ar_cash_receipts.attribute14%TYPE,
42: p_attribute15 IN ar_cash_receipts.attribute15%TYPE );
43: --
44: PROCEDURE update_current_crh_record(
45: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE,
46: p_reversal_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
47: p_reversal_date IN ar_misc_cash_distributions.apply_date%TYPE,
48: p_crh_id_new IN ar_cash_receipt_history.cash_receipt_history_id%TYPE );
49: --

Line 48: p_crh_id_new IN ar_cash_receipt_history.cash_receipt_history_id%TYPE );

44: PROCEDURE update_current_crh_record(
45: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE,
46: p_reversal_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
47: p_reversal_date IN ar_misc_cash_distributions.apply_date%TYPE,
48: p_crh_id_new IN ar_cash_receipt_history.cash_receipt_history_id%TYPE );
49: --
50: PROCEDURE insert_reversal_crh_record(
51: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE,
52: p_reversal_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,

Line 51: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE,

47: p_reversal_date IN ar_misc_cash_distributions.apply_date%TYPE,
48: p_crh_id_new IN ar_cash_receipt_history.cash_receipt_history_id%TYPE );
49: --
50: PROCEDURE insert_reversal_crh_record(
51: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE,
52: p_reversal_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
53: p_reversal_date IN ar_misc_cash_distributions.apply_date%TYPE,
54: p_clear_batch_id IN VARCHAR2,
55: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE

Line 55: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE

51: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE,
52: p_reversal_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
53: p_reversal_date IN ar_misc_cash_distributions.apply_date%TYPE,
54: p_clear_batch_id IN VARCHAR2,
55: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE
56: );
57: --
58: PROCEDURE insert_reversal_mcd_record(
59: p_mcd_rec IN OUT NOCOPY ar_misc_cash_distributions%ROWTYPE,

Line 65: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE );

61: p_reversal_date IN ar_misc_cash_distributions.apply_date%TYPE );
62: --
63: PROCEDURE insert_reversal_dist_rec(
64: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
65: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE );
66: --
67: FUNCTION check_cb( p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE )
68: RETURN BOOLEAN;
69: --

Line 84: ar_cash_receipt_history.reversal_gl_date%TYPE,

80: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
81: p_cc_id IN ra_cust_trx_line_gl_dist.code_combination_id%TYPE,
82: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
83: p_reversal_gl_date IN
84: ar_cash_receipt_history.reversal_gl_date%TYPE,
85: p_reversal_date IN
86: ar_cash_receipts.reversal_date%TYPE,
87: p_reversal_reason_code IN VARCHAR2);
88: --

Line 131: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,

127: +===========================================================================*/
128: PROCEDURE reverse (
129: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
130: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
131: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
132: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
133: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
134: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
135: p_clear_batch_id IN ar_cash_receipt_history.batch_id%TYPE,

Line 135: p_clear_batch_id IN ar_cash_receipt_history.batch_id%TYPE,

131: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
132: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
133: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE,
134: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE,
135: p_clear_batch_id IN ar_cash_receipt_history.batch_id%TYPE,
136: p_attribute_category IN ar_cash_receipts.attribute_category%TYPE,
137: p_attribute1 IN ar_cash_receipts.attribute1%TYPE,
138: p_attribute2 IN ar_cash_receipts.attribute2%TYPE,
139: p_attribute3 IN ar_cash_receipts.attribute3%TYPE,

Line 154: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE,

150: p_attribute14 IN ar_cash_receipts.attribute14%TYPE,
151: p_attribute15 IN ar_cash_receipts.attribute15%TYPE,
152: p_module_name IN VARCHAR2,
153: p_module_version IN VARCHAR2,
154: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE,
155: p_called_from IN VARCHAR2 DEFAULT NULL) IS /* jrautiai BR implementation */
156: --
157: l_cr_rec ar_cash_receipts%ROWTYPE;
158: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;

Line 158: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;

154: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE,
155: p_called_from IN VARCHAR2 DEFAULT NULL) IS /* jrautiai BR implementation */
156: --
157: l_cr_rec ar_cash_receipts%ROWTYPE;
158: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
159: l_crh_rec ar_cash_receipt_history%ROWTYPE;
160: l_batches_rec ar_batches%ROWTYPE;
161: l_mcd_rec ar_misc_cash_distributions%ROWTYPE;
162: /*CCR-add cursor for receipt method pkt */

Line 159: l_crh_rec ar_cash_receipt_history%ROWTYPE;

155: p_called_from IN VARCHAR2 DEFAULT NULL) IS /* jrautiai BR implementation */
156: --
157: l_cr_rec ar_cash_receipts%ROWTYPE;
158: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
159: l_crh_rec ar_cash_receipt_history%ROWTYPE;
160: l_batches_rec ar_batches%ROWTYPE;
161: l_mcd_rec ar_misc_cash_distributions%ROWTYPE;
162: /*CCR-add cursor for receipt method pkt */
163:

Line 165: l_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

161: l_mcd_rec ar_misc_cash_distributions%ROWTYPE;
162: /*CCR-add cursor for receipt method pkt */
163:
164: --
165: l_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
166: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
167: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
168: l_mcd_id ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;
169: l_rm_code ar_receipt_methods.payment_type_code%TYPE;

Line 669: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,

665: | |
666: +===========================================================================*/
667: PROCEDURE validate_args( p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
668: p_reversal_category IN VARCHAR2,
669: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
670: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
671: p_reversal_reason_code IN VARCHAR2 ) IS
672: BEGIN
673: IF PG_DEBUG in ('Y', 'C') THEN

Line 742: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS

738: | ar_distributions inserts. |
739: +===========================================================================*/
740: PROCEDURE insert_reversal_dist_rec(
741: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
742: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
743: --
744: l_dist_rec ar_distributions%ROWTYPE;
745: l_cr_rec ar_cash_receipts%ROWTYPE; /* added for VAT */
746: l_crh_rec ar_cash_receipt_history%ROWTYPE; /* added for VAT */

Line 746: l_crh_rec ar_cash_receipt_history%ROWTYPE; /* added for VAT */

742: p_crh_id IN ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
743: --
744: l_dist_rec ar_distributions%ROWTYPE;
745: l_cr_rec ar_cash_receipts%ROWTYPE; /* added for VAT */
746: l_crh_rec ar_cash_receipt_history%ROWTYPE; /* added for VAT */
747: --
748: CURSOR ar_dist_C(
749: p_cr_id ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
750: SELECT

Line 749: p_cr_id ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS

745: l_cr_rec ar_cash_receipts%ROWTYPE; /* added for VAT */
746: l_crh_rec ar_cash_receipt_history%ROWTYPE; /* added for VAT */
747: --
748: CURSOR ar_dist_C(
749: p_cr_id ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
750: SELECT
751: dist.source_type,
752: dist.code_combination_id,
753: nvl(SUM( nvl(dist.AMOUNT_DR,0)),0) -

Line 758: ar_cash_receipt_history crh

754: nvl(SUM( nvl(dist.AMOUNT_CR,0) ),0) amount_cr,
755: nvl(SUM( nvl(dist.ACCTD_AMOUNT_DR,0) ),0) -
756: nvl(SUM( nvl(dist.ACCTD_AMOUNT_CR,0) ),0) acctd_amount_cr
757: FROM ar_distributions dist,
758: ar_cash_receipt_history crh
759: WHERE dist.source_id = crh.cash_receipt_history_id
760: AND crh.cash_receipt_id = p_cr_id
761: ANd dist.source_table = 'CRH'
762: GROUP BY dist.source_type,

Line 878: | p_crh_id - Id of inserted ar_cash_receipt_history row |

874: | p_clear_batch_id - Flag to denote if the batch Id |
875: | should be nulled out NOCOPY or not |
876: | this procedure |
877: | OUT: |
878: | p_crh_id - Id of inserted ar_cash_receipt_history row |
879: | |
880: | RETURNS : NONE |
881: | |
882: | NOTES |

Line 892: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE,

888: | created_from variables |
889: | |
890: +===========================================================================*/
891: PROCEDURE insert_reversal_crh_record(
892: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE,
893: p_reversal_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
894: p_reversal_date IN ar_misc_cash_distributions.apply_date%TYPE,
895: p_clear_batch_id IN VARCHAR2,
896: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE

Line 896: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE

892: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE,
893: p_reversal_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
894: p_reversal_date IN ar_misc_cash_distributions.apply_date%TYPE,
895: p_clear_batch_id IN VARCHAR2,
896: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE
897: ) IS
898: --Bug#2750340
899: l_xla_ev_rec arp_xla_events.xla_events_type;
900:

Line 1009: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE,

1005: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
1006: | |
1007: +===========================================================================*/
1008: PROCEDURE update_current_crh_record(
1009: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE,
1010: p_reversal_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
1011: p_reversal_date IN ar_misc_cash_distributions.apply_date%TYPE,
1012: p_crh_id_new IN ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
1013:

Line 1012: p_crh_id_new IN ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS

1008: PROCEDURE update_current_crh_record(
1009: p_crh_rec IN OUT NOCOPY ar_cash_receipt_history%ROWTYPE,
1010: p_reversal_gl_date IN ar_misc_cash_distributions.gl_date%TYPE,
1011: p_reversal_date IN ar_misc_cash_distributions.apply_date%TYPE,
1012: p_crh_id_new IN ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
1013:
1014: --Bug#2750340
1015: l_xla_ev_rec arp_xla_events.xla_events_type;
1016:

Line 1566: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,

1562: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE,
1563: p_cc_id IN ra_cust_trx_line_gl_dist.code_combination_id%TYPE,
1564: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
1565: p_cust_trx_type IN ra_cust_trx_types.name%TYPE,
1566: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
1567: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
1568: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
1569: p_reversal_reason_code IN
1570: ar_cash_receipts.reversal_reason_code%TYPE,

Line 1608: l_rev1_cc_id ar_cash_receipt_history.account_code_combination_id%TYPE;

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;
1611: l_rev2_amount ar_cash_receipt_history.factor_discount_amount%TYPE;
1612:

Line 1609: l_rev1_amount ar_cash_receipt_history.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;
1611: l_rev2_amount ar_cash_receipt_history.factor_discount_amount%TYPE;
1612:
1613: l_ct_rec ra_customer_trx%ROWTYPE;

Line 1610: l_rev2_cc_id ar_cash_receipt_history.bank_charge_account_ccid%TYPE;

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;
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;

Line 1611: l_rev2_amount ar_cash_receipt_history.factor_discount_amount%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;
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;

Line 1787: FROM ar_cash_receipt_history

1783: -- get ccids from, use the highest crh_id whose status <> RISK_ELIMINATED
1784:
1785: SELECT max(cash_receipt_history_id)
1786: INTO l_crhid
1787: FROM ar_cash_receipt_history
1788: WHERE cash_receipt_id = l_cr_id
1789: AND status <> 'RISK_ELIMINATED';
1790:
1791: SELECT account_code_combination_id,

Line 1799: FROM ar_cash_receipt_history

1795: INTO l_rev1_cc_id,
1796: l_rev2_cc_id,
1797: l_rev1_amount,
1798: l_rev2_amount
1799: FROM ar_cash_receipt_history
1800: WHERE cash_receipt_id = l_cr_id
1801: AND cash_receipt_history_id = l_crhid;
1802:
1803: IF PG_DEBUG in ('Y', 'C') THEN

Line 2160: ar_cash_receipt_history.reversal_gl_date%TYPE,

2156: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
2157: p_cc_id IN ra_cust_trx_line_gl_dist.code_combination_id%TYPE,
2158: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
2159: p_reversal_gl_date IN
2160: ar_cash_receipt_history.reversal_gl_date%TYPE,
2161: p_reversal_date IN
2162: ar_cash_receipts.reversal_date%TYPE,
2163: p_reversal_reason_code IN VARCHAR2) IS
2164: BEGIN