1 PACKAGE PO_REQ_LINES_SV1 AUTHID CURRENT_USER as
2 /* $Header: POXRQL2S.pls 115.3 2002/11/23 01:56:19 sbull ship $ */
3 /*===========================================================================
4 PACKAGE NAME: po_req_lines_sv1
5
6 DESCRIPTION: Contains all server side procedures that access
7 requisition lines entity.
8
9 CLIENT/SERVER: Server
10
11 LIBRARY NAME None
12
13 OWNER: RMULPURY
14
15 PROCEDURE NAMES: get_vendor_sourcing_info
16 val_src_details
17 get_max_line_num
18 update_modified_by_agent_flag
19 get_cost_price
20 ===========================================================================*/
21
22 /*===========================================================================
23 PROCEDURE NAME: get_cost_price
24
25 DESCRIPTION: Obtain the cost price in the
26 unit of measure passed in to this
27 procedure.
28
29 PARAMETERS: x_item_id IN NUMBER
30 x_organization_id IN NUMBER
31 x_unit_of_measure IN NUMBER
32 x_cost_price OUT NUMBER
33
34
35 DESIGN REFERENCES: ../POXRQERQ.doc
36
37 ALGORITHM:
38
39 NOTES:
40
41 OPEN ISSUES:
42
43 CLOSED ISSUES:
44
45 CHANGE HISTORY: Created 16-APR-96 RMULPURY
46 ===========================================================================*/
47
48 PROCEDURE get_cost_price (x_item_id IN NUMBER,
49 x_organization_id IN NUMBER,
50 x_unit_of_measure IN VARCHAR2,
51 x_cost_price IN OUT NOCOPY NUMBER);
52
53
54
55 /*===========================================================================
56 PROCEDURE NAME: get_vendor_sourcing_info
57
58 DESCRIPTION: Obtain the corresponding information
59 for the values returned by the
60 auto source user-exit when it is called
61 in 'VENDOR' mode. Source document information
62 is obtained as well.
63
64 PARAMETERS: x_vendor_id IN NUMBER
65 x_vendor_site_id IN NUMBER
66 x_vendor_contact_id IN NUMBER
67 x_po_header_id IN NUMBER
68 x_document_type_code IN VARCHAR2
69 x_buyer_id IN NUMBER
70 x_vendor_name IN OUT VARCHAR2
71 x_vendor_location IN OUT VARCHAR2
72 x_vendor_contact IN OUT VARCHAR2
73 x_vendor_phone IN OUT VARCHAR2
74 x_po_num IN OUT VARCHAR2
75 x_doc_type_disp IN OUT VARCHAR2
76 x_buyer IN OUT VARCHAR2
77
78 DESIGN REFERENCES: ../POXRQERQ.doc
79
80 ALGORITHM:
81
82 NOTES:
83
84 OPEN ISSUES:
85
86 CLOSED ISSUES:
87
88 CHANGE HISTORY:
89 ===========================================================================*/
90
91 PROCEDURE get_vendor_sourcing_info (x_vendor_id IN NUMBER,
92 x_vendor_site_id IN NUMBER,
93 x_vendor_contact_id IN NUMBER,
94 x_po_header_id IN NUMBER,
95 x_document_type_code IN VARCHAR2,
96 x_buyer_id IN NUMBER,
97 x_vendor_name IN OUT NOCOPY VARCHAR2,
98 x_vendor_location IN OUT NOCOPY VARCHAR2,
99 x_vendor_contact IN OUT NOCOPY VARCHAR2,
100 x_vendor_phone IN OUT NOCOPY VARCHAR2,
101 x_po_num IN OUT NOCOPY VARCHAR2,
102 x_doc_type_disp IN OUT NOCOPY VARCHAR2,
103 x_buyer IN OUT NOCOPY VARCHAR2);
104
105
106
107
108 /*===========================================================================
109 PROCEDURE NAME: val_src_details
110
111 DESCRIPTION: Cover for the validation of the following
112 destination fields:
113
114 - Source type
115 - Source Organization Id
116 - Source Organization
117 - Source Organization Code
118 - Source Subinventory
119
120
121 This procedure copies null
122 values into the invalid columns.
123
124 PARAMETERS: x_src_org_id IN OUT NUMBER
125 x_src_org IN OUT VARCHAR2
126 x_src_org_code IN OUT VARCHAR2
127 x_item_id IN NUMBER
128 x_item_rev IN VARCHAR2
129 x_inv_org_id IN NUMBER
130 x_outside_op_line_type IN VARCHAR2
131 x_mrp_planned_item IN VARCHAR2
132 x_src_sub IN VARCHAR2
133 x_src_type IN VARCHAR2
134 x_dest_type IN VARCHAR2
135 x_dest_org_id IN NUMBER
136 x_dest_sub IN VARCHAR2
137 x_deliver_to_loc_id IN NUMBER
138 x_val_code IN VARCHAR2
139 x_sob_id IN OUT NUMBER
140
141 Valid codes: 'ALL' - Validate source type and details
142 'ORG' - Validate source org and sub.
143 'SUB' - Validate source sub.
144
145
146 DESIGN REFERENCES: POXRQERQ.doc
147
148 ALGORITHM:
149
150 NOTES:
151
152 OPEN ISSUES:
153
154 CLOSED ISSUES:
155
156 CHANGE HISTORY:
157 ===========================================================================*/
158
159 PROCEDURE val_src_details ( x_src_org_id IN OUT NOCOPY NUMBER,
160 x_src_org IN OUT NOCOPY VARCHAR2,
161 x_src_org_code IN OUT NOCOPY VARCHAR2,
162 x_item_id IN NUMBER,
163 x_item_rev IN VARCHAR2,
164 x_inv_org_id IN NUMBER,
165 x_outside_op_line_type IN VARCHAR2,
166 x_mrp_planned_item IN VARCHAR2,
167 x_src_sub IN OUT NOCOPY VARCHAR2,
168 x_src_type IN OUT NOCOPY VARCHAR2,
169 x_dest_type IN VARCHAR2,
170 x_dest_org_id IN VARCHAR2,
171 x_dest_sub IN VARCHAR2,
172 x_deliver_to_loc_id IN NUMBER,
173 x_val_code IN VARCHAR2,
174 x_sob_id IN OUT NOCOPY NUMBER);
175
176
177
178
179 /*===========================================================================
180 FUNCTION NAME: get_max_line_num
181
182 DESCRIPTION: This function gets the maximum value of
183 of the line number for a requisition.
184
185 PARAMETERS: X_header_id NUMBER
186
187
188 DESIGN REFERENCES:
189
190 ALGORITHM:
191
192 NOTES:
193
194 OPEN ISSUES:
195
196 CLOSED ISSUES:
197
198 CHANGE HISTORY: RMULPURY 06/06 Created
199 ===========================================================================*/
200
201 FUNCTION get_max_line_num (x_header_id IN NUMBER)
202 return number;
203
204 -- pragma restrict_references (get_max_line_num,WNDS);
205
206
207
208 /*===========================================================================
209 PROCEDURE NAME: update_modified_by_agent_flag
210
211 DESCRIPTION: This routine updates the modified_by_agent_flag
212 for requisition lines which have been
213 modified.
214
215 PARAMETERS: x_req_line_id
216 x_agent_id
217
218
219 DESIGN REFERENCES: MODIFY_REQ.doc
220
221 ALGORITHM:
222
223 NOTES:
224
225 OPEN ISSUES:
226
227 CLOSED ISSUES:
228
229 CHANGE HISTORY: RMULPURY 10/14 Created
230 ===========================================================================*/
231
232 PROCEDURE update_modified_by_agent_flag(x_req_line_id IN NUMBER,
233 x_agent_id IN NUMBER);
234
235
236 END po_req_lines_sv1;
237
238