1 PACKAGE JA_CN_GL_BANK_EXP_REPORT_PKG AUTHID CURRENT_USER AS
2 --$Header: JACNGBRS.pls 120.0.12020000.2 2013/02/06 08:59:35 chongwan noship $
3 --+=======================================================================+
4 --| Copyright (c) 1998 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| JACNGBRS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Use this package to export report for general ledger |
13 --| |
14 --| PROCEDURE LIST |
15 --| PROCEDURE Submit_Request |
16 --| |
17 --| |
18 --| HISTORY |
19 --| 19-Oct-2012 Jar Wang Created |
20 --+======================================================================*/
21
22 --==========================================================================
23 -- PROCEDURE NAME:
24 --
25 -- Submit_Request Public
26 --
27 -- DESCRIPTION:
28 --
29 -- This procedure is to export report for general ledger
30 --
31 -- PARAMETERS:
32 -- Out: pv_errbuf NOCOPY VARCHAR2
33 -- pv_retcode NOCOPY VARCHAR2
34 -- In: pn_legal_entity_id NUMBER identifier of legal entity
35 -- pn_chart_of_account_id NUMBER identifier of chart of account
36 -- pn_ledger_id NUMBER identifier of ledger
37 -- pv_bsv VARCHAR2 balance segment
38 -- pv_adhoc_prefix VARCHAR2 adhoc prefix
39 -- pv_industry VARCHAR2 industry
40 -- pv_accounting_year VARCHAR2 accounting year
41 -- pv_period_from VARCHAR2 period from
42 -- pv_period_to VARCHAR2 period to
43 -- pn_cfs_report_id NUMBER identifier of cfs report
44 -- pn_ps_report_id NUMBER identifier of profit statment report
45 -- pn_oe_report_id NUMBER identifier of Statement of changes in owners' equity Report
46 -- pv_currency_unit VARCHAR2 currency unit
47 -- pv_source_char_set VARCHAR2 source character set
48 -- pv_dest_char_set VARCHAR2 destination character set
49 -- pv_source_separator VARCHAR2 source separator
50 -- pn_data_access_set_id NUMBER identifier of data access set
51 -- pv_flex_code VARCHAR2 flex code
52 -- pv_default_ledger_short_name VARCHAR2 defualt ledger short name
53 -- pv_output_option VARCHAR2 output option
54 -- pv_exceptions_flag VARCHAR2 exceptions flag
55 -- pn_page_length NUMBER page length
56 -- pn_subrequest_id NUMBER identifier of subrequest
57 -- pv_appl_deflt_name VARCHAR2 application default name
58 -- pv_balance_type VARCHAR2 balance type
59 -- pv_xml_template_language VARCHAR2 xml template language
60 -- pv_xml_template_territory VARCHAR2 xml template territory
61 -- pv_xml_output_format VARCHAR2 xml output format
62 -- pn_csf_report_num NUMBER cfs report number
63 -- pn_balance_sheet_num NUMBER balance sheet number
64 -- pn_profit_statement_num NUMBER profit statement number
65 -- pn_owners_equity_num NUMBER number of Statement of changes in owners' equity Report
66 -- pv_accounting_date VARCHAR2 accounting date
67 --
68 --
69 -- CHANGE HISTORY:
70 -- 19-Oct-2012 Jar Wang created
71 --==========================================================================
72
73 PROCEDURE Submit_Request(pv_errbuf OUT NOCOPY VARCHAR2,
74 pv_retcode OUT NOCOPY VARCHAR2,
75 pn_chart_of_account_id IN NUMBER,
76 pn_ledger_id IN NUMBER,
77 pn_legal_entity_id IN NUMBER,
78 pv_bsv IN VARCHAR2,
79 pv_adhoc_prefix IN VARCHAR2,
80 pv_industry IN VARCHAR2,
81 pv_accounting_year IN VARCHAR2,
82 pv_period_from IN VARCHAR2,
83 pv_period_to IN VARCHAR2,
84 pn_bs_report_id IN NUMBER,
85 pn_ps_report_id IN NUMBER,
86 pn_cfs_report_id IN NUMBER,
87 pn_oe_report_id IN NUMBER,
88 pv_currency_unit IN VARCHAR2,
89 pv_source_char_set IN VARCHAR2,
90 pv_dest_char_set IN VARCHAR2,
91 pv_source_separator IN VARCHAR2,
92 pn_data_access_set_id IN NUMBER,
93 pv_flex_code IN VARCHAR2,
94 pv_default_ledger_short_name IN VARCHAR2,
95 pv_output_option IN VARCHAR2,
96 pv_exceptions_flag IN VARCHAR2,
97 pn_page_length IN NUMBER,
98 pn_subrequest_id IN NUMBER,
99 pv_appl_deflt_name IN VARCHAR2,
100 pv_balance_type IN VARCHAR2,
101 pv_xml_template_language IN VARCHAR2,
102 pv_xml_template_territory IN VARCHAR2,
103 pv_xml_output_format IN VARCHAR2,
104 pn_csf_report_num IN NUMBER,
105 pn_balance_sheet_num IN NUMBER,
106 pn_profit_statement_num IN NUMBER,
107 pn_owners_equity_num IN NUMBER,
108 pv_accounting_date IN VARCHAR2);
109
110 END JA_CN_GL_BANK_EXP_REPORT_PKG;
111