1 PACKAGE INV_ShortStatement_PVT AUTHID CURRENT_USER AS
2 /* $Header: INVSSTMS.pls 115.4 2003/01/20 09:54:01 shchandr ship $*/
3 -- Start OF comments
4 -- API name : BuildDetail
5 -- TYPE : Private
6 -- Pre-reqs : None
7 -- FUNCTION :
8 -- Parameters:
9 -- IN :
10 -- p_api_version IN NUMBER (required)
11 -- API Version of this procedure
12 --
13 -- p_init_msg_list IN VARCHAR2 (optional)
14 -- DEFAULT = FND_API.G_FALSE,
15 --
16 -- OUT :
17 -- x_return_status OUT NUMBER
18 -- Result of all the operations
19 --
20 -- x_msg_count OUT NUMBER,
21 --
22 -- x_msg_data OUT VARCHAR2,
23 --
24 -- x_short_stat_detail OUT LONG
25 -- Detail shortage statement
26 --
27 -- Version: Current Version 1.0
28 -- Changed : Nothing
29 -- No Previous Version 0.0
30 -- Initial version 1.0
31 -- Notes :
32 -- END OF comments
33 PROCEDURE BuildDetail (
34 p_api_version IN NUMBER ,
35 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
36 x_return_status IN OUT NOCOPY VARCHAR2,
37 x_msg_count IN OUT NOCOPY NUMBER,
38 x_msg_data IN OUT NOCOPY VARCHAR2,
39 p_organization_id IN NUMBER,
40 p_check_wip_flag IN NUMBER,
41 p_check_oe_flag IN NUMBER,
42 p_wip_rel_jobs_flag IN NUMBER,
43 p_wip_days_overdue_rel_jobs IN NUMBER,
44 p_wip_unrel_jobs_flag IN NUMBER,
45 p_wip_days_overdue_unrel_jobs IN NUMBER,
46 p_wip_hold_jobs_flag IN NUMBER,
47 p_wip_rel_rep_flag IN NUMBER,
48 p_wip_days_overdue_rel_rep IN NUMBER,
49 p_wip_unrel_rep_flag IN NUMBER,
50 p_wip_days_overdue_unrel_rep IN NUMBER,
51 p_wip_hold_rep_flag IN NUMBER,
52 p_wip_req_date_jobs_flag IN NUMBER,
53 p_wip_curr_op_jobs_flag IN NUMBER,
54 p_wip_prev_op_jobs_flag IN NUMBER,
55 p_wip_req_date_rep_flag IN NUMBER,
56 p_wip_curr_op_rep_flag IN NUMBER,
57 p_wip_prev_op_rep_flag IN NUMBER,
58 p_wip_excl_bulk_comp_flag IN NUMBER,
59 p_wip_excl_supplier_comp_flag IN NUMBER,
60 p_wip_excl_pull_comp_flag IN NUMBER,
61 x_short_stat_detail OUT NOCOPY LONG
62 );
63 -- Start OF comments
64 -- API name : BuildSummary
65 -- TYPE : Private
66 -- Pre-reqs : None
67 -- FUNCTION :
68 -- Parameters:
69 -- IN :
70 -- p_api_version IN NUMBER (required)
71 -- API Version of this procedure
72 --
73 -- p_init_msg_list IN VARCHAR2 (optional)
74 -- DEFAULT = FND_API.G_FALSE,
75 --
76 -- OUT :
77 -- x_return_status OUT NUMBER
78 -- Result of all the operations
79 --
80 -- x_msg_count OUT NUMBER,
81 --
82 -- x_msg_data OUT VARCHAR2,
83 --
84 -- x_short_stat_sum OUT LONG
85 -- Summary shortage statement
86 --
87 -- Version: Current Version 1.0
88 -- Changed : Nothing
89 -- No Previous Version 0.0
90 -- Initial version 1.0
91 -- Notes :
92 -- END OF comments
93 PROCEDURE BuildSummary (
94 p_api_version IN NUMBER ,
95 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
96 x_return_status IN OUT NOCOPY VARCHAR2,
97 x_msg_count IN OUT NOCOPY NUMBER,
98 x_msg_data IN OUT NOCOPY VARCHAR2,
99 p_organization_id IN NUMBER,
100 p_check_wip_flag IN NUMBER,
101 p_check_oe_flag IN NUMBER,
102 p_wip_rel_jobs_flag IN NUMBER,
103 p_wip_days_overdue_rel_jobs IN NUMBER,
104 p_wip_unrel_jobs_flag IN NUMBER,
105 p_wip_days_overdue_unrel_jobs IN NUMBER,
106 p_wip_hold_jobs_flag IN NUMBER,
107 p_wip_rel_rep_flag IN NUMBER,
108 p_wip_days_overdue_rel_rep IN NUMBER,
109 p_wip_unrel_rep_flag IN NUMBER,
110 p_wip_days_overdue_unrel_rep IN NUMBER,
111 p_wip_hold_rep_flag IN NUMBER,
112 p_wip_req_date_jobs_flag IN NUMBER,
113 p_wip_curr_op_jobs_flag IN NUMBER,
114 p_wip_prev_op_jobs_flag IN NUMBER,
115 p_wip_req_date_rep_flag IN NUMBER,
116 p_wip_curr_op_rep_flag IN NUMBER,
117 p_wip_prev_op_rep_flag IN NUMBER,
118 p_wip_excl_bulk_comp_flag IN NUMBER,
119 p_wip_excl_supplier_comp_flag IN NUMBER,
120 p_wip_excl_pull_comp_flag IN NUMBER,
121 x_short_stat_sum OUT NOCOPY LONG
122 );
123 -- Start OF comments
124 -- API name : InsertUpdate
125 -- TYPE : Private
126 -- Pre-reqs : None
127 -- FUNCTION :
128 -- Parameters:
129 -- IN :
130 -- p_api_version IN NUMBER (required)
131 -- API Version of this procedure
132 --
133 -- p_init_msg_list IN VARCHAR2 (optional)
134 -- DEFAULT = FND_API.G_FALSE,
135 --
136 -- OUT :
137 -- x_return_status OUT NUMBER
138 -- Result of all the operations
139 --
140 -- x_msg_count OUT NUMBER,
141 --
142 -- x_msg_data OUT VARCHAR2,
143 --
144 --
145 -- Version: Current Version 1.0
146 -- Changed : Nothing
147 -- No Previous Version 0.0
148 -- Initial version 1.0
149 -- Notes :
150 -- END OF comments
151 PROCEDURE InsertUpdate (
152 p_api_version IN NUMBER ,
153 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
154 x_return_status IN OUT NOCOPY VARCHAR2,
155 x_msg_count IN OUT NOCOPY NUMBER,
156 x_msg_data IN OUT NOCOPY VARCHAR2,
157 p_organization_id IN NUMBER,
158 p_short_stat_sum IN LONG,
159 p_short_stat_detail IN LONG
160 );
161 -- Start OF comments
162 -- API name : StartBuild
163 -- TYPE : Private
164 -- Pre-reqs : None
165 -- FUNCTION :
166 -- Parameters:
167 -- IN :
168 -- p_api_version IN NUMBER (required)
169 -- API Version of this procedure
170 --
171 -- p_init_msg_list IN VARCHAR2 (optional)
172 -- DEFAULT = FND_API.G_FALSE,
173 --
174 -- p_commit IN VARCHAR2 (optional)
175 -- DEFAULT = FND_API.G_FALSE
176 --
177 --
178 -- OUT :
179 -- x_return_status OUT NUMBER
180 -- Result of all the operations
181 --
182 -- x_msg_count OUT NUMBER,
183 --
184 -- x_msg_data OUT VARCHAR2,
185 --
186 -- Version: Current Version 1.0
187 -- Changed : Nothing
188 -- No Previous Version 0.0
189 -- Initial version 1.0
190 -- Notes :
191 -- END OF comments
192 PROCEDURE StartBuild (
193 p_api_version IN NUMBER ,
194 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
195 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
196 x_return_status IN OUT NOCOPY VARCHAR2,
197 x_msg_count IN OUT NOCOPY NUMBER,
198 x_msg_data IN OUT NOCOPY VARCHAR2,
199 p_organization_id IN NUMBER,
200 p_check_wip_flag IN NUMBER,
201 p_check_oe_flag IN NUMBER,
202 p_wip_rel_jobs_flag IN NUMBER,
203 p_wip_days_overdue_rel_jobs IN NUMBER,
204 p_wip_unrel_jobs_flag IN NUMBER,
205 p_wip_days_overdue_unrel_jobs IN NUMBER,
206 p_wip_hold_jobs_flag IN NUMBER,
207 p_wip_rel_rep_flag IN NUMBER,
208 p_wip_days_overdue_rel_rep IN NUMBER,
209 p_wip_unrel_rep_flag IN NUMBER,
210 p_wip_days_overdue_unrel_rep IN NUMBER,
211 p_wip_hold_rep_flag IN NUMBER,
212 p_wip_req_date_jobs_flag IN NUMBER,
213 p_wip_curr_op_jobs_flag IN NUMBER,
214 p_wip_prev_op_jobs_flag IN NUMBER,
215 p_wip_req_date_rep_flag IN NUMBER,
216 p_wip_curr_op_rep_flag IN NUMBER,
217 p_wip_prev_op_rep_flag IN NUMBER,
218 p_wip_excl_bulk_comp_flag IN NUMBER,
219 p_wip_excl_supplier_comp_flag IN NUMBER,
220 p_wip_excl_pull_comp_flag IN NUMBER
221 );
222 END INV_ShortStatement_PVT;