1 PACKAGE CST_AccrualSummaryReport_PVT AS
2 /* $Header: CSTVASRS.pls 120.2 2005/10/18 04:31:46 nejain noship $ */
3
4 /*===========================================================================*/
5 -- API name : Generate_SummaryReportXml
6 -- Type : Private
7 -- Function : Generate XML Data for Accrual Summary Report.
8 -- Pre-reqs : None.
9 -- Parameters :
10 -- IN : p_title IN VARCHAR2
11 -- : p_bal_segment_from IN VARCHAR2
12 -- : p_bal_segment_to IN VARCHAR2
13 --
14 -- OUT :
15 -- : errcode OUT VARCHAR2
16 -- : errno OUT NUMBER
17 --
18 -- Version : Current version 1.0
19 -- : Initial version 1.0
20 -- Notes : This Procedure is called by the Summary Accrual
21 -- Reconcilition Report. This is the wrapper procedure
22 -- that calls the other procedures to generate XML data
23 -- according to report parameters.
24 -- End of comments
25 /*===========================================================================*/
26
27 PROCEDURE Generate_SummaryReportXml (
28 errcode OUT NOCOPY VARCHAR2,
29 errno OUT NOCOPY NUMBER,
30
31 p_Chart_of_accounts_id IN NUMBER,
32 p_bal_seg_val IN NUMBER,
33 p_title IN VARCHAR2,
34 p_bal_segment_from IN VARCHAR2,
35 p_bal_segment_to IN VARCHAR2 );
36
37 /*===========================================================================*/
38 -- API name : add_parameters
39 -- Type : Private
40 -- Function : Generate XML data for Parameters and append it to
41 -- output
42 -- Pre-reqs : None.
43 -- Parameters :
44 -- IN : p_api_version IN NUMBER
45 -- : p_init_msg_list IN VARCHAR2
46 -- : p_validation_level IN NUMBER
47 -- : i_title IN VARCHAR2
48 -- : i_bal_segment_from IN VARCHAR2
49 -- : i_bal_segment_to IN VARCHAR2
50 --
51 -- IN OUT :
52 -- : x_xml_doc IN OUT NOCOPY CLOB
53 --
54 -- OUT :
55 -- : x_return_status OUT VARCHAR2
56 -- : x_msg_count OUT NUMBER
57 -- : x_msg_data OUT VARCHAR2
58 --
59 -- Version : Current version 1.0
60 -- : Initial version 1.0
61 -- Notes : This Procedure is called by Generate_SummaryReportXml
62 -- procedure. The procedure generates XML data for the
63 -- report parameters and appends it to the report output
64 -- End of comments
65 /*===========================================================================*/
66
67 PROCEDURE Add_Parameters
68 (p_api_version IN NUMBER,
69 p_init_msg_list IN VARCHAR2 ,
70 p_validation_level IN NUMBER,
71
72 x_return_status OUT NOCOPY VARCHAR2,
73 x_msg_count OUT NOCOPY NUMBER,
74 x_msg_data OUT NOCOPY VARCHAR2,
75
76 i_title IN VARCHAR2,
77 i_bal_segment_from IN VARCHAR2,
78 i_bal_segment_to IN VARCHAR2,
79
80 x_xml_doc IN OUT NOCOPY CLOB);
81
82 /*===========================================================================*/
83 -- API name : Add_SummaryData
84 -- Type : Private
85 -- Function : Generate XML data from sql query and append it to
86 -- output
87 -- Pre-reqs : None.
88 -- Parameters :
89 -- IN : p_api_version IN NUMBER
90 -- : p_init_msg_list IN VARCHAR2
91 -- : p_validation_level IN NUMBER
92 -- : i_title IN VARCHAR2
93 -- : i_bal_segment_from IN VARCHAR2
94 -- : i_bal_segment_to IN VARCHAR2
95 --
96 -- IN OUT :
97 -- : x_xml_doc IN OUT NOCOPY CLOB
98 --
99 -- OUT :
100 -- : x_return_status OUT VARCHAR2
101 -- : x_msg_count OUT NUMBER
102 -- : x_msg_data OUT VARCHAR2
103 --
104 -- Version : Current version 1.0
105 -- : Initial version 1.0
106 -- Notes : This Procedure is called by Generate_SummaryReportXml
107 -- procedure. The procedure generates XML data from sql
108 -- query and appends it to the report output
109 -- End of comments
110 /*===========================================================================*/
111
112 PROCEDURE Add_SummaryData
113 (p_api_version IN NUMBER,
114 p_init_msg_list IN VARCHAR2 ,
115 p_validation_level IN NUMBER,
116
117 x_return_status OUT NOCOPY VARCHAR2,
118 x_msg_count OUT NOCOPY NUMBER,
119 x_msg_data OUT NOCOPY VARCHAR2,
120
121 i_title IN VARCHAR2,
122 i_bal_segment_from IN VARCHAR2,
123 i_bal_segment_to IN VARCHAR2,
124
125 x_xml_doc IN OUT NOCOPY CLOB);
126
127 END CST_AccrualSummaryReport_PVT;