[Home] [Help]
PACKAGE: APPS.JA_CN_PS_FSG_XML_SUBMIT_PROG
Source
1 PACKAGE JA_CN_PS_FSG_XML_SUBMIT_PROG AUTHID CURRENT_USER AS
2 --$Header: JACNPFXS.pls 120.0 2010/09/01 09:53:43 wuwu noship $
3 --+=======================================================================+
4 --| Copyright (c) 2006 Oracle Corporation
5 --| Redwood Shores, CA, USA
6 --| All rights reserved.
7 --+=======================================================================
8 --| FILENAME
9 --| JACNPFXS.pls
10 --|
11 --| DESCRIPTION
12 --|
13 --| This package is used to submit FSG report and XML Report publisher.
14 --|
15 --| TYPE LIEST
16 --| None
17 --| PROCEDURE LIST
18 --| PROCEDURE Submit_FSG_Report
19 --|
20 --| HISTORY
21 --| 06-Aug-2010 Chaoqun Wu Created
22 --+======================================================================*/
23
24 g_module_name VARCHAR2(30) := 'JA_CN_PS_FSG_XML_SUBMIT_PROG';
25
26 --==========================================================================
27 -- PROCEDURE NAME:
28 -- Submit_FSG_Report public
29 --
30 -- DESCRIPTION:
31 -- This procedure is used to submit FSG reports, and then invoke the
32 -- 'Report Item Data Convert program' to covert the FSG output.
33 -- PARAMETERS:
34 -- In:
35 -- pn_data_access_set_id Data Acess ID
36 -- pn_coa_id Chart of Accounts ID
37 -- pv_adhoc_prefix ADHOC PREFIX
38 -- pv_industry Industry
39 -- pv_flex_code Flex Code
40 -- pv_default_ledger_short_name Default Ledger short Name
41 -- pv_period_name Period Name
42 -- pv_output_option Out Option
43 -- pv_exceptions_flag Exception
44 -- pv_accounting_date Accounting Date
45 -- pn_page_length Page Lenth
46 -- pn_subrequest_id SubRequest ID
47 -- pv_appl_deflt_name Application Default Name
48 -- pn_csf_report_id Cash Flow Statement Report ID
49 -- pn_csf_report_num Cash Flow Statement Report Number
50 -- pn_balance_sheet_id Balance Sheet Report ID
51 -- pn_balance_sheet_num Balance Sheet Report Number
52 -- pn_profit_statement_id Profit Statement Report ID
53 -- pn_profit_statement_num Profit Statement Report Number
54 -- pn_owners_equity_id Owners Equity Report ID
55 -- pn_owners_equity_num Owners Equity Report Number
56 -- pv_balance_type Balance Type
57 -- pn_legal_entity_id Legal Entity ID
58 -- pn_ledger_id Ledger ID
59 -- pv_currency_unit Currency Unit
60 -- pv_xml_template_language XML template language
61 -- pv_xml_template_territory XML template territory
62 -- pv_xml_output_format XML output format
63 --
64 -- Out:
65 -- pn_convert_reqid Report Item Data Convert program
66 --
67 -- DESIGN REFERENCES:
68 -- None
69 --
70 -- CHANGE HISTORY:
71 -- 06-Aug-2010 Chaoqun Wu Created
72 --===========================================================================
73 PROCEDURE Submit_FSG_Report
74 (pn_data_access_set_id IN NUMBER,
75 pn_coa_id IN NUMBER,
76 pv_adhoc_prefix IN VARCHAR2,
77 pv_industry IN VARCHAR2,
78 pv_flex_code IN VARCHAR2,
79 pv_default_ledger_short_name IN VARCHAR2,
80 pv_period_name IN VARCHAR2,
81 pv_output_option IN VARCHAR2,
82 pv_exceptions_flag IN VARCHAR2,
83 pn_page_length IN NUMBER,
84 pn_subrequest_id IN NUMBER,
85 pv_appl_deflt_name IN VARCHAR2,
86 pn_balance_sheet_id IN NUMBER,
87 pn_balance_sheet_num IN NUMBER,
88 pn_revenue_expenditure_id IN NUMBER,
89 pn_revenue_expenditure_num IN NUMBER,
90 pn_expenditure_detail_id IN NUMBER,
91 pn_expenditure_detail_num IN NUMBER,
92 pv_currency_unit IN VARCHAR2,
93 pn_legal_entity_id IN NUMBER,
94 pn_ledger_id IN NUMBER,
95 pv_accounting_date IN VARCHAR2,
96 pv_xml_template_language IN VARCHAR2,
97 pv_xml_template_territory IN VARCHAR2,
98 pv_xml_output_format IN VARCHAR2,
99 pn_convert_reqid OUT NOCOPY NUMBER
100 );
101
102 END JA_CN_PS_FSG_XML_SUBMIT_PROG;