1 PACKAGE ARP_RECONCILE AUTHID CURRENT_USER AS
2 /* $Header: ARTRECBS.pls 115.3 2002/11/15 03:58:05 anukumar ship $ */
3
4 /*=======================================================================+
5 | Public Variables and Record Types
6 +=======================================================================*/
7 SUBTYPE ae_doc_rec_type IS ARP_ACCT_MAIN.ae_doc_rec_type;
8 SUBTYPE ae_event_rec_type IS ARP_ACCT_MAIN.ae_event_rec_type;
9 SUBTYPE ae_sys_rec_type IS ARP_ACCT_MAIN.ae_sys_rec_type;
10 SUBTYPE ae_line_rec_type IS ARP_ACCT_MAIN.ae_line_rec_type;
11 SUBTYPE ae_line_tbl_type IS ARP_ACCT_MAIN.ae_line_tbl_type;
12 SUBTYPE ae_rule_rec_type IS ARP_ACCT_MAIN.ae_app_rule_rec_type;
13
14 TYPE get_recon_rec_type IS RECORD
15 (
16 source_type AR_DISTRIBUTIONS.source_type%TYPE,
17 source_id_secondary AR_DISTRIBUTIONS.source_id_secondary%TYPE,
18 source_table_secondary AR_DISTRIBUTIONS.source_table_secondary%TYPE,
19 source_type_secondary AR_DISTRIBUTIONS.source_type_secondary%TYPE,
20 currency_code AR_DISTRIBUTIONS.currency_code%TYPE,
21 currency_conversion_rate AR_DISTRIBUTIONS.currency_conversion_rate%TYPE,
22 currency_conversion_type AR_DISTRIBUTIONS.currency_conversion_type%TYPE,
23 currency_conversion_date AR_DISTRIBUTIONS.currency_conversion_date%TYPE,
24 third_party_id AR_DISTRIBUTIONS.third_party_id%TYPE,
25 third_party_sub_id AR_DISTRIBUTIONS.third_party_sub_id%TYPE,
26 reversed_source_id AR_DISTRIBUTIONS.reversed_source_id%TYPE,
27 amount AR_DISTRIBUTIONS.amount_cr%TYPE,
28 acctd_amount AR_DISTRIBUTIONS.acctd_amount_cr%TYPE,
29 taxable_entered AR_DISTRIBUTIONS.taxable_entered_cr%TYPE,
30 taxable_accounted AR_DISTRIBUTIONS.taxable_accounted_cr%TYPE,
31 location_segment_id AR_DISTRIBUTIONS.location_segment_id%TYPE,
32 tax_group_code_id AR_DISTRIBUTIONS.tax_group_code_id%TYPE,
33 tax_code_id AR_DISTRIBUTIONS.tax_code_id%TYPE,
34 code_combination_id AR_DISTRIBUTIONS.code_combination_id%TYPE);
35
36
37 /*========================================================================
38 | PUBLIC PROCEDURE Reconcile_BR_Tax
39 |
40 | DESCRIPTION
41 | On closure of a Bills Receivable document simulates an application activity
42 | against the shadow adjustments on the Bills line assignment, retrieves the
43 | actual accounting created for the Bill and reconciles the deferred tax.
44 | A difference if any is created in the distributions table.
45 |
46 | PARAMETERS
47 | p_mode IN Document or Accounting Event mode
48 | p_ae_doc_rec IN Document Record
49 | p_ae_event_rec IN Event Record
50 | p_ae_sys_rec IN System parameter details
51 | p_cust_inv_rec IN Contains currency, exchange rate, site
52 | details for the bill
53 | p_ae_ctr IN OUT NOCOPY counter for lines table
54 | p_ae_line_tbl IN OUT NOCOPY lines table containing reconciled entry
55 *=======================================================================*/
56 PROCEDURE Reconcile_trx_br(p_mode IN VARCHAR2 ,
57 p_ae_doc_rec IN ae_doc_rec_type ,
58 p_ae_event_rec IN ae_event_rec_type ,
59 p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,
60 p_activity_cust_trx_id IN NUMBER ,
61 p_activity_amt IN NUMBER ,
62 p_activity_acctd_amt IN NUMBER ,
63 p_call_num IN NUMBER ,
64 p_g_ae_line_tbl IN OUT NOCOPY ae_line_tbl_type ,
65 p_g_ae_ctr IN OUT NOCOPY BINARY_INTEGER );
66 END ARP_RECONCILE;
67