[Home] [Help]
PACKAGE: APPS.JA_CN_AR_VALIDATION_PKG
Source
1 PACKAGE JA_CN_AR_VALIDATION_PKG AUTHID CURRENT_USER AS
2 --$Header: JACNARVS.pls 120.0 2010/05/13 05:22:40 weihuang noship $
3 --+=======================================================================+
4 --| Copyright (c) 2010 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| JACNARVS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| |
13 --| This package contains the following PL/SQL tables/procedures |
14 --| to validate the receivable balance and details export. |
15 --| |
16 --| |
17 --| PROCEDURE LIST |
18 --| Validate_Receivables |
19 --| |
20 --| HISTORY |
21 --| 14-Apr-2010 Wei Huang Created |
22 --| |
23 --+======================================================================*/
24
25 --==========================================================================
26 -- PROCEDURE NAME:
27 --
28 -- Validate_Receivables Public
29 --
30 -- DESCRIPTION:
31 --
32 -- This package contains the following PL/SQL tables/procedures
33 -- to validate the receivable balance and details export.
34 -- Validation report includes transaction as below:
35 -- 1) Transaction in which the legal entity is not same with the
36 -- legal entity that the Balance Segment Value in
37 -- payables of the transaction is assigned.
38 -- 2) Transaction which has not been itemized.
39 --
40 -- PARAMETERS:
41 -- In: pn_legal_entity_id LEGAL_ENTITY_ID
42 -- pn_ledger_id Ledger ID
43 -- pv_accounting_year Accounting Year
44 -- pv_period_from Period From
45 -- pv_period_to Period To
46 --
47 -- Out:
48 -- pv_errbuf OUT NOCOPY VARCHAR2
49 -- pv_retcode OUT NOCOPY VARCHAR2
50 -- DESIGN REFERENCES:
51 --
52 --
53 -- CHANGE HISTORY:
54 -- 14-Apr-2010 Wei Huang Created
55 --
56 --===========================================================================
57 PROCEDURE Validate_Receivables
58 (pv_errbuf OUT NOCOPY VARCHAR2
59 ,pv_retcode OUT NOCOPY VARCHAR2
60 ,pn_legal_entity_id IN NUMBER
61 ,pn_ledger_id IN NUMBER
62 ,pv_accounting_year IN VARCHAR2
63 ,pv_period_from IN VARCHAR2
64 ,pv_period_to IN VARCHAR2
65 );
66
67 END JA_CN_AR_VALIDATION_PKG;