[Home] [Help]
PACKAGE: APPS.CST_UNINVOICEDRECEIPTS_PVT
Source
1 PACKAGE CST_UninvoicedReceipts_PVT AS
2 /* $Header: CSTVURRS.pls 120.1 2006/02/15 23:38:24 bigoyal noship $ */
3
4 -----------------------------------------------------------------------------
5 -- Start of comments
6 -- API name : Start_Process
7 -- Type : Private
8 -- Function : Starting point for Uninvoiced Receipt Report
9 --
10 -- Pre-reqs : None.
11 -- Parameters :
12 -- IN :
13 -- p_title VARCHAR2 Required
14 -- p_accrued_receipts VARCHAR2 Required
15 -- p_inc_online_accruals VARCHAR2 Required
16 -- p_inc_closed_pos VARCHAR2 Required
17 -- p_struct_num NUMBER Required
18 -- p_category_from VARCHAR2 Required
19 -- p_category_to VARCHAR2 Required
20 -- p_min_extended_value NUMBER Required
21 -- p_period_name VARCHAR2 Required
22 -- p_vendor_from VARCHAR2 Required
23 -- p_vendor_to VARCHAR2 Required
24 -- p_orderby VARCHAR2 Required
25 -- p_qty_precision NUMBER Required
26 --
27 -- OUT :
28 -- errbuf VARCHAR2
29 -- retcode NUMBER
30 --
31 -- Version : Current version 1.0
32 --
33 -- End of comments
34 -----------------------------------------------------------------------------
35 PROCEDURE Start_Process
36 (
37 errbuf OUT NOCOPY VARCHAR2,
38 retcode OUT NOCOPY NUMBER,
39
40 p_title IN VARCHAR2,
41 p_accrued_receipts IN VARCHAR2,
42 p_inc_online_accruals IN VARCHAR2,
43 p_inc_closed_pos IN VARCHAR2,
44 p_struct_num IN NUMBER,
45 p_category_from IN VARCHAR2,
46 p_category_to IN VARCHAR2,
47 p_min_accrual_amount IN NUMBER,
48 p_period_name IN VARCHAR2,
49 p_vendor_from IN VARCHAR2,
50 p_vendor_to IN VARCHAR2,
51 p_orderby IN NUMBER,
52 p_qty_precision IN NUMBER
53 );
54 -----------------------------------------------------------------------------
55 -- Start of comments
56 -- API name : Generate_XML
57 -- Type : Private
58 -- Function : The procedure generates and returns the XML data for
59 -- the reference cursor passed by the calling API.
60 --
61 -- Pre-reqs : None.
62 -- Parameters :
63 -- IN :
64 -- p_api_version NUMBER Required
65 -- p_init_msg_list VARCHAR2 Required
66 -- p_validation_level NUMBER Required
67 -- p_ref_cur SYS_REFCURSOR Required
68 -- p_row_tag VARCHAR2 Required
69 -- p_row_set_tag VARCHAR2 Required
70 --
71 -- OUT :
72 -- x_return_status VARCHAR2
73 -- x_msg_count NUMBER
74 -- x_msg_data VARCHAR2
75 -- x_xml_data CLOB
76 --
77 -- Version : Current version 1.0
78 --
79 -- End of comments
80 -----------------------------------------------------------------------------
81 PROCEDURE Generate_XML
82 (
83 p_api_version IN NUMBER,
84 p_init_msg_list IN VARCHAR2,
85 p_validation_level IN NUMBER,
86
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2,
90
91 p_ref_cur IN SYS_REFCURSOR,
92 p_row_tag IN VARCHAR2,
93 p_row_set_tag IN VARCHAR2,
94
95 x_xml_data OUT NOCOPY CLOB
96 );
97
98 -----------------------------------------------------------------------------
99 -- Start of comments
100 -- API name : Merge_XML
101 -- Type : Private
102 -- Function : The procedure merges data from two XML objects into a
103 -- single XML object and adds a root tag to the resultant
104 -- XML data.
105 --
106 -- Pre-reqs : None.
107 -- Parameters :
108 -- IN :
109 -- p_api_version NUMBER Required
110 -- p_init_msg_list VARCHAR2 Required
111 -- p_validation_level NUMBER Required
112 -- p_xml_src1 CLOB Required
113 -- p_xml_src2 CLOB Required
114 -- p_root_tag VARCHAR2 Required
115 --
116 -- OUT :
117 -- x_return_status VARCHAR2
118 -- x_msg_count NUMBER
119 -- x_msg_data VARCHAR2
120 -- x_xml_doc CLOB
121 --
122 -- Version : Current version 1.0
123 --
124 -- End of comments
125 -----------------------------------------------------------------------------
126 PROCEDURE Merge_XML
127 (
128 p_api_version IN NUMBER,
129 p_init_msg_list IN VARCHAR2,
130 p_validation_level IN NUMBER,
131
132 x_return_status OUT NOCOPY VARCHAR2,
133 x_msg_count OUT NOCOPY NUMBER,
134 x_msg_data OUT NOCOPY VARCHAR2,
135
136 p_xml_src1 IN CLOB,
137 p_xml_src2 IN CLOB,
138 p_root_tag IN VARCHAR2,
139
140 x_xml_doc OUT NOCOPY CLOB
141 );
142
143 -----------------------------------------------------------------------------
144 -- Start of comments
145 -- API name : Print_ClobOutput
146 -- Type : Private
147 -- Function : The procedure writes the XML data to the report output
148 -- file. The XML publisher picks the data from this output
149 -- file to display the data in user specified format.
150 --
151 -- Pre-reqs : None.
152 -- Parameters :
153 -- IN :
154 -- p_api_version NUMBER Required
155 -- p_init_msg_list VARCHAR2 Required
156 -- p_validation_level NUMBER Required
157 -- p_xml_data CLOB
158 --
159 -- OUT :
160 -- x_return_status VARCHAR2
161 -- x_msg_count NUMBER
162 -- x_msg_data VARCHAR2
163 --
164 -- Version : Current version 1.0
165 --
166 -- End of comments
167 -----------------------------------------------------------------------------
168 PROCEDURE Print_ClobOutput
169 (
170 p_api_version IN NUMBER,
171 p_init_msg_list IN VARCHAR2,
172 p_validation_level IN NUMBER,
173
174 x_return_status OUT NOCOPY VARCHAR2,
175 x_msg_count OUT NOCOPY NUMBER,
176 x_msg_data OUT NOCOPY VARCHAR2,
177 p_xml_data IN CLOB
178 ) ;
179
180 END CST_UninvoicedReceipts_PVT;