[Home] [Help]
PACKAGE: APPS.JA_CN_APAR_EXPORT_PROG
Source
1 PACKAGE JA_CN_APAR_EXPORT_PROG AUTHID CURRENT_USER AS
2 --$Header: JACNPRES.pls 120.0 2010/05/13 09:19:37 wuwu noship $
3 --+=======================================================================+
4 --| Copyright (c) 1998 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| JACNPRES.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Use this package to export Reports for Receivables and Payables |
13 --| |
14 --| PROCEDURE LIST |
15 --| PROCEDURE Export_APAR |
16 --| PROCEDURE Submit_Request |
17 --| |
18 --| HISTORY |
19 --| 01-APR-2010 Chaoqun Wu Created |
20 --+======================================================================*/
21
22 --==========================================================================
23 -- PROCEDURE NAME:
24 --
25 -- Export_APAR Public
26 --
27 -- DESCRIPTION:
28 --
29 -- This procedure is to export Reports for Receivables and Payables,
30 -- and program will populate 4 reports into one XML file.
31 --
32 -- PARAMETERS:
33 -- Out: pv_errbuf NOCOPY VARCHAR2
34 -- pv_retcode NOCOPY VARCHAR2
35 -- In: pn_legal_entity_id NUMBER identifier of legal entity
36 -- pn_ledger_id NUMBER identifier of ledger
37 -- pn_coa_id NUMBER identifier of chart of account
38 -- pv_accounting_year VARCHAR2 accounting year
39 -- pv_period_from VARCHAR2 period from
40 -- pv_period_to VARCHAR2 period to
41 --
42 -- DESIGN REFERENCES:
43 -- APAR_Chaoqun.doc
44 --
45 -- CHANGE HISTORY:
46 -- 01-Apr-2010 Chaoqun Wu created
47 --==========================================================================
48 PROCEDURE Export_APAR
49 (pv_errbuf OUT NOCOPY VARCHAR2
50 ,pv_retcode OUT NOCOPY VARCHAR2
51 ,pn_legal_entity_id IN NUMBER
52 ,pn_ledger_id IN NUMBER
53 ,pn_coa_id IN NUMBER
54 ,pv_accounting_year IN VARCHAR2
55 ,pv_period_from IN VARCHAR2
56 ,pv_period_to IN VARCHAR2
57 );
58
59 --==========================================================================
60 -- PROCEDURE NAME:
61 --
62 -- Submit_Request Public
63 --
64 -- DESCRIPTION:
65 --
66 -- This procedure is to submit request of export report for Payables and Receivables
67 --
68 -- PARAMETERS:
69 -- Out: pv_errbuf NOCOPY VARCHAR2
70 -- pv_retcode NOCOPY VARCHAR2
71 -- In: pn_legal_entity_id NUMBER identifier of legal entity
72 -- pn_chart_of_account_id NUMBER identifier of chart of account
73 -- pn_ledger_id NUMBER identifier of ledger
74 -- pn_coa_id NUMBER identifier of chart of account
75 -- pv_accounting_year VARCHAR2 accounting year
76 -- pv_period_from VARCHAR2 period from
77 -- pv_period_to VARCHAR2 period to
78 -- pv_source_char_set VARCHAR2 source character set
79 -- pv_dest_char_set VARCHAR2 destination character set
80 -- pv_template_language VARCHAR2 template language
81 -- pv_template_territory VARCHAR2 template territory
82 -- pv_output_format VARCHAR2 output format
83 --
84 -- DESIGN REFERENCES:
85 -- APAR_Chaoqun.doc
86 --
87 -- CHANGE HISTORY:
88 -- 01-Apr-2010 Chaoqun Wu created
89 --==========================================================================
90
91 PROCEDURE Submit_Request
92 (pv_errbuf OUT NOCOPY VARCHAR2
93 ,pv_retcode OUT NOCOPY VARCHAR2
94 ,pn_legal_entity_id IN NUMBER
95 ,pn_ledger_id IN NUMBER
96 ,pn_coa_id IN NUMBER
97 ,pv_accounting_year IN VARCHAR2
98 ,pv_period_from IN VARCHAR2
99 ,pv_period_to IN VARCHAR2
100 ,pv_source_char_set IN VARCHAR2
101 ,pv_dest_char_set IN VARCHAR2
102 ,pv_template_language IN VARCHAR2
103 ,pv_template_territory IN VARCHAR2
104 ,pv_output_format IN VARCHAR2
105 );
106
107 END JA_CN_APAR_EXPORT_PROG;