[Home] [Help]
PACKAGE: APPS.PO_REQS_INQ_SV
Source
1 PACKAGE PO_REQS_INQ_SV AUTHID CURRENT_USER as
2 /* $Header: POXRQVRS.pls 115.7 2003/07/23 17:33:23 dreddy ship $ */
3 /*===========================================================================
4 PACKAGE NAME: PO_REQS_INQ_SV
5
6 DESCRIPTION: This package contains the server side Requisition Inquiry
7 Application Program Interfaces (APIs).
8
9 CLIENT/SERVER: Server
10
11 OWNER: Wilson Lau
12
13 FUNCTION/PROCEDURE:
14 ===========================================================================*/
15
16
17 /*===========================================================================
18 FUNCTION NAME: get_po_number
19
20 DESCRIPTION: This procedure returns PO number
21
22 PARAMETERS: In : PO_header_id of PO_header
23
24 Out: PO_number
25
26
27 DESIGN REFERENCES: ../POXRQVRQ.dd
28
29 ALGORITHM:
30
31 NOTES:
32
33 OPEN ISSUES:
34
35 CLOSED ISSUES:
36
37 CHANGE HISTORY: Created 25-AUG-95 WLAU
38 ===========================================================================*/
39 FUNCTION get_po_number (x_po_header_id IN NUMBER)
40 RETURN VARCHAR2;
41
42 -- pragma restrict_references (get_po_number,WNDS,RNPS,WNPS);
43
44 /*===========================================================================
45 FUNCTION NAME: get_reserved_flag
46
47 DESCRIPTION: This procedure returns funds reserved status flag
48 for the requisition
49
50 PARAMETERS: In : requisition_header_id of requisition_header
51
52 Out: reserved_flag
53
54
55 DESIGN REFERENCES: ../POXRQVRQ.dd
56
57 ALGORITHM:
58
59 NOTES:
60
61 OPEN ISSUES:
62
63 CLOSED ISSUES:
64
65 CHANGE HISTORY: Created 25-AUG-95 WLAU
66 ===========================================================================*/
67 FUNCTION get_reserved_flag (x_requisition_header_id IN NUMBER)
68 RETURN VARCHAR2;
69 -- pragma restrict_references (get_reserved_flag,WNDS);
70
71
72 /*===========================================================================
73 FUNCTION NAME: get_shipped_quantity
74
75 DESCRIPTION: This procedure returns the shipped quantity
76 from sales order for the internal requisition.
77
78 PARAMETERS: In : requisition_number and line_number --obsolete
79 of requisition_line
80
81 requisition_header_id and requisition_line_id
82
83 Out: Sales order shipped quantity
84
85
86 DESIGN REFERENCES: ../POXRQVRQ.dd
87
88 ALGORITHM:
89
90 NOTES:
91
92 OPEN ISSUES:
93
94 CLOSED ISSUES:
95
96 CHANGE HISTORY: Created 12-SEP-95 WLAU
97 ===========================================================================*/
98 --Bug# 1392077
99 --Toju George 08/31/2000
100 --Modified the procedure to replace req_num and line_num with ids.
101 /*FUNCTION get_shipped_quantity (x_requisition_num IN VARCHAR2,
102 x_line_num IN VARCHAR2)
103 RETURN NUMBER;
104 */
105 FUNCTION get_shipped_quantity (x_requisition_header_id IN VARCHAR2,
106 x_requisition_line_id IN VARCHAR2)
107 RETURN NUMBER;
108 /*===========================================================================*/
109
110 /*===========================================================================
111 PROCEDURE NAME: po_req_header_inq_wrapper
112
113 DESCRIPTION: This procedure calls
114 PO_CORE_S.GET_TOTAL
115 PO_REQS_INQ_SV.GET_RESERVER_FLAG
116 PO_INQ_SV.GET_PERSON_NAME.
117 It is called during post-query for requisition summary
118 headers.
119
120 PARAMETERS: In : requisition_number
121 preparer_id
122
123 Out: req_header_amount
124 reserved_flag
125 perparer_name
126
127
128 DESIGN REFERENCES: performance fix bug 414200
129
130 ALGORITHM:
131
132 NOTES:
133
134 OPEN ISSUES:
135
136 CLOSED ISSUES:
137
138 CHANGE HISTORY: Created 29-OCT-96 ecso
139 ===========================================================================*/
140 PROCEDURE po_req_header_inq_wrapper (x_req_num IN NUMBER,
141 x_preparer IN NUMBER,
142 x_req_header_amount OUT NOCOPY NUMBER,
143 x_reserved_flag OUT NOCOPY VARCHAR2,
144 x_preparer_name OUT NOCOPY VARCHAR2);
145
146 /*===========================================================================*/
147 /*===========================================================================
148 PROCEDURE NAME: po_req_line_inq_wrapper
149
150 DESCRIPTION: This procedure calls
151 PO_INQ_SV.GET_PERSON_NAME
152 PO_INQ_SV.GET_ASSEMBLY_QUANTITY
153 PO_INQ_SV.GET_RESOURCE_QUANTITY
154 PO_INQ_SV.GET_WIP_OPERATION_CODE
155 PO_INQ_SV.GET_BOM_DEPARTMENT_CODE
156 PO_REQS_INQ_SV.GET_PO_NUMBER
157 PO_INQ_SV.GET_PO_NUMBER
158 PO_INQ_SV.GET_SO_NUMBER
159 PO_CORE_S.GET_TOTAL
160
161 It is called during post-query for requisition summary
162 lines.
163
164 PARAMETERS: In : x_to_person_id
165 x_suggested_buyer_id
166 x_item_id
167 x_wip_entity_id
168 x_wip_operation_seq_num
169 x_wip_resource_seq_num
170 x_destination_organization_id
171 x_wip_repetitive_schedule_id
172 x_quantity
173 x_purchasing_agent_id
174 x_preparer_id
175 x_blanket_po_header_id
176 x_source_type_code
177 x_line_location_id
178 x_segment1
179 x_line_num
180 x_requsition_line_id
181
182 Out: v_requestor
183 v_suggested_buyer
184 v_assembly_quantity
185 v_resource_quantity
186 v_wip_operation_code
187 v_bom_department_code
188 v_purchasing_agent_name_dsp
189 v_preparer_name
190 v_blanket_po_num_dsp
191 v_order_num
192 v_req_line_amount
193
194
195 DESIGN REFERENCES: performance fix bug 414200
196
197 ALGORITHM:
198
199 NOTES:
200
201 OPEN ISSUES:
202
203 CLOSED ISSUES:
204
205 CHANGE HISTORY: Created 30-OCT-96 ecso
206 ===========================================================================*/
207 PROCEDURE po_req_line_inq_wrapper (x_to_person_id IN NUMBER,
208 x_suggested_buyer_id IN NUMBER,
209 x_item_id IN NUMBER,
210 x_wip_entity_id IN NUMBER,
211 x_wip_operation_seq_num IN NUMBER,
212 x_wip_resource_seq_num IN NUMBER,
213 x_destination_organization_id IN NUMBER,
214 x_wip_repetitive_schedule_id IN NUMBER,
215 x_quantity IN NUMBER,
216 x_purchasing_agent_id IN NUMBER,
217 x_preparer_id IN NUMBER,
218 x_blanket_po_header_id IN NUMBER,
219 x_source_type_code IN VARCHAR2,
220 x_line_location_id IN NUMBER,
221 x_segment1 IN VARCHAR2,
222 x_line_num IN NUMBER,
223 x_requsition_line_id IN NUMBER,
224 v_requestor OUT NOCOPY VARCHAR2,
225 v_suggested_buyer OUT NOCOPY VARCHAR2,
226 v_assembly_quantity OUT NOCOPY NUMBER,
227 v_resource_quantity OUT NOCOPY NUMBER,
228 v_wip_operation_code OUT NOCOPY VARCHAR2,
229 v_bom_department_code OUT NOCOPY VARCHAR2,
230 v_purchasing_agent_name_dsp OUT NOCOPY VARCHAR2,
231 v_preparer_name OUT NOCOPY VARCHAR2,
232 v_blanket_po_num_dsp OUT NOCOPY VARCHAR2,
233 v_order_num OUT NOCOPY VARCHAR2,
234 v_req_line_amount OUT NOCOPY NUMBER,
235 --Bug# 1392077
236 --Toju George 08/31/2000
237 --Modified the procedure to include the requisition header id.
238 x_requisition_header_id IN VARCHAR2
239 );
240
241 /*===========================================================================*/
242 /*===========================================================================
243 PROCEDURE NAME: po_req_dist_inq_wrapper
244
245 DESCRIPTION: This procedure calls
246 PO_INQ_SV.GET_PERSON_NAME
247 PO_CORE_S.GET_TOTAL
248
249 It is called during post-query for requisition summary
250 distributions.
251
252 PARAMETERS: In : x_to_person_id
253 x_suggested_buyer_id
254 x_preparer_id
255 x_distribution_id
256
257 Out: v_requestor
258 v_suggested_buyer
259 v_preparer_name
260 v_req_distribution_amount
261
262
263 DESIGN REFERENCES: performance fix bug 414200
264
265 ALGORITHM:
266
267 NOTES:
268
269 OPEN ISSUES:
270
271 CLOSED ISSUES:
272
273 CHANGE HISTORY: Created 30-OCT-96 ecso
274 ===========================================================================*/
275 PROCEDURE po_req_dist_inq_wrapper (x_to_person_id IN NUMBER,
276 x_suggested_buyer_id IN NUMBER,
277 x_preparer_id IN NUMBER,
278 x_distribution_id IN NUMBER,
279
280 v_requestor OUT NOCOPY VARCHAR2,
281 v_suggested_buyer OUT NOCOPY VARCHAR2,
282 v_preparer_name OUT NOCOPY VARCHAR2,
283 v_req_distribution_amount OUT NOCOPY NUMBER);
284
285 /*===========================================================================*/
286 /*===========================================================================
287
288 PROCEDURE NAME: get_reqln_pq_lookups
289 Bug# 1934593
290 This procedure fetches the lookup values removed from the view
291 po_requisition_lines_inq_v as part of the performance fix
292
293 ===========================================================================*/
294 PROCEDURE get_reqln_pq_lookups( x_auth_status_code in varchar2,
295 x_tran_reason_code in varchar2,
296 x_src_doc_type_code in varchar2,
297 x_dest_type_code in varchar2,
298 x_src_type_code in varchar2,
299 x_auth_status_dsp in out NOCOPY varchar2,
300 x_tran_reason_dsp in out NOCOPY varchar2,
301 x_src_doc_type_dsp in out NOCOPY varchar2,
302 x_dest_type_dsp in out NOCOPY varchar2,
303 x_src_type_dsp in out NOCOPY varchar2);
304
305 /*===========================================================================
306
307 PROCEDURE NAME: get_ga_info
308
309 ===========================================================================*/
310 PROCEDURE get_ga_info (X_po_header_id IN NUMBER,
311 X_ga_flag IN OUT NOCOPY VARCHAR2,
312 X_owning_org_name IN OUT NOCOPY VARCHAR2 ) ;
313
314 /*===========================================================================
315
316 FUNCTION NAME: get_req_amount
317 DESCRIPTION : Gets the amounts on the req line/distribution
318 < SERVICES FPJ >
319
320 ===========================================================================*/
321 FUNCTION get_req_amount (p_mode IN VARCHAR2,
322 p_req_entity_id IN NUMBER)
323 RETURN NUMBER;
324
325 END PO_REQS_INQ_SV;