1 PACKAGE PO_LINES_SV7 AS
2 /* $Header: POXPIVLS.pls 120.0.12000000.1 2007/01/16 23:05:09 appldev ship $ */
3
4 /*==================================================================
5 PROCEDURE NAME: validate_item_related_info()
6
7 DESCRIPTION: This API is used to validate item related attibutes
8 in po_lines table.
9
10 PARAMETERS: X_interface_header_id IN NUMBER,
11 X_interface_line_id IN NUMBER,
12 X_item_id IN NUMBER,
13 X_unit_of_measure IN VARCHAR2,
14 X_item_revision IN VARCHAR2,
15 X_category_id IN NUMBER,
16 X_def_inv_org_id IN NUMBER,
17 X_outside_operation_flag IN VARCHAR2,
18 X_header_processable_flag IN OUT VARCHAR2 ,
19 X_global_agreement_flag IN VARCHAR2 -- FPI GA
20 X_type_lookup_code IN VARCHAR2 -- Bug 3362369
21 DESIGN
22 REFERENCES: 832valapl.doc
23
24 ALGORITHM:
25
26 NOTES:
27
28 OPEN ISSUES:
29
30 CLOSE ISSUES:
31
32 CHANGE
33 HISTORY: Created 02-MAY-1996 DXYU
34 Modified 13-Jun-1996 KKCHAN
35 * added item_description as one more parameter.
36 Modified 18-Jun-1996 KKCHAN
37 * added create_or_update_item_flag as one more param.
38
39 ===================================================================*/
40 PROCEDURE validate_item_related_info(X_interface_header_id IN NUMBER,
41 X_interface_line_id IN NUMBER,
42 X_item_id IN NUMBER,
43 X_item_description IN VARCHAR2,
44 X_unit_of_measure IN VARCHAR2,
45 X_item_revision IN VARCHAR2,
46 X_category_id IN NUMBER,
47 X_def_inv_org_id IN NUMBER,
48 X_outside_operation_flag IN VARCHAR2,
49 X_create_or_update_item_flag IN VARCHAR2,
50 X_header_processable_flag IN OUT NOCOPY VARCHAR2,
51 X_global_agreement_flag IN VARCHAR2, -- FPI GA
52 X_type_lookup_code IN VARCHAR2);-- Bug 3362369
53
54 /*==================================================================
55 PROCEDURE NAME: validate_item_with_line_type()
56
57 DESCRIPTION: This API is used to validate item related attibutes
58 with the value from po_line_types in po_lines table.
59
60 PARAMETERS: X_interface_header_id IN NUMBER,
61 X_interface_line_id IN NUMBER,
62 X_line_type_id IN NUMBER,
63 X_category_id IN NUMBER,
64 X_unit_of_measure IN VARCHAR2,
65 X_unit_price IN NUMBER,
66 X_item_id IN NUMBER,
67 X_item_description IN VARCHAR2,
68 X_item_revision IN VARCHAR2,
69 X_def_inv_org_id IN NUMBER,
70 X_header_processable_flag IN OUT VARCHAR2,
71 X_global_agreement_flag IN VARCHAR2 -- FPI GA
72 X_type_lookup_code IN VARCHAR2 -- Bug 3362369
73 DESIGN
74 REFERENCES: 832valapl.doc
75
76 ALGORITHM:
77
78 NOTES:
79
80 OPEN ISSUES:
81
82 CLOSE ISSUES:
83
84 CHANGE
85 HISTORY: Created 02-MAY-1996 DXYU
86 Modified 18-Jun-1996 KKCHAN
87
88
89 ===================================================================*/
90 PROCEDURE validate_item_with_line_type(
91 X_interface_header_id IN NUMBER,
92 X_interface_line_id IN NUMBER,
93 X_line_type_id IN NUMBER,
94 X_category_id IN NUMBER,
95 X_unit_of_measure IN VARCHAR2,
96 X_unit_price IN NUMBER,
97 X_item_id IN NUMBER,
98 X_item_description IN VARCHAR2,
99 X_item_revision IN VARCHAR2,
100 X_def_inv_org_id IN NUMBER,
101 X_create_or_update_item_flag IN VARCHAR2,
102 X_header_processable_flag IN OUT NOCOPY VARCHAR2,
103 X_global_agreement_flag IN VARCHAR2 default null, -- FPI GA
104 X_type_lookup_code IN VARCHAR2 default null); -- Bug 3362369
105 /*==================================================================
106 PROCEDURE NAME: validate_po_lines()
107
108 DESCRIPTION: This API is used to validate columns which will be
109 inserted into po_lines table during the purchasing
110 docs open interface load.
111
112 PARAMETERS: all columns in po_lines
113
114 DESIGN
115 REFERENCES: 832valapl.doc
116
117 ALGORITHM:
118
119 NOTES:
120
121 OPEN ISSUES:
122
123 CLOSE ISSUES:
124
125 CHANGE
126 HISTORY: Created 20-FEB-1996 DXYU
127 Modified 06-MAR-1996 DXYU
128 Modified 30-APR-1996 DXYU
129
130 =======================================================================*/
131 PROCEDURE validate_po_lines(x_interface_header_id IN NUMBER,
132 x_interface_line_id IN NUMBER,
133 x_current_po_header_id IN NUMBER,
134 x_po_line_id IN NUMBER,
135 x_last_update_date IN DATE,
136 x_last_updated_by IN NUMBER,
137 x_po_header_id IN NUMBER,
138 x_line_type_id IN NUMBER,
139 x_line_num IN NUMBER,
140 x_last_update_login IN NUMBER,
141 x_creation_date IN DATE,
142 x_created_by IN NUMBER,
143 x_item_id IN NUMBER,
144 x_item_revision IN VARCHAR2,
145 x_category_id IN NUMBER,
146 x_item_description IN VARCHAR2,
147 x_unit_meas_lookup_code IN VARCHAR2,
148 x_quantity_committed IN NUMBER,
149 x_committed_amount IN NUMBER,
150 x_allow_price_override_flag IN VARCHAR2,
151 x_not_to_exceed_price IN NUMBER,
152 x_list_price_per_unit IN NUMBER,
153 X_base_unit_price IN NUMBER, -- <FPJ Advanced Price>
154 x_unit_price IN NUMBER,
155 x_quantity IN NUMBER,
156 x_un_number_id IN NUMBER,
157 x_hazard_class_id IN NUMBER,
158 x_note_to_vendor IN VARCHAR2,
159 x_from_header_id IN NUMBER,
160 x_from_line_id IN NUMBER,
161 x_min_order_quantity IN NUMBER,
162 x_max_order_quantity IN NUMBER,
163 x_qty_rcv_tolerance IN NUMBER,
164 x_over_tolerance_error_flag IN VARCHAR2,
165 x_market_price IN NUMBER,
166 x_unordered_flag IN VARCHAR2,
167 x_closed_flag IN VARCHAR2,
168 x_cancel_flag IN VARCHAR2,
169 x_cancelled_by IN NUMBER,
170 x_cancel_date IN DATE,
171 x_cancel_reason IN VARCHAR2,
172 x_vendor_product_num IN VARCHAR2,
173 x_contract_num IN VARCHAR2,
174 x_taxable_flag IN VARCHAR2,
175 x_tax_name IN VARCHAR2,
176 x_tax_code_id IN NUMBER,
177 x_type_1099 IN VARCHAR2,
178 x_capital_expense_flag IN VARCHAR2,
179 x_negotiated_by_preparer_flag IN VARCHAR2,
180 x_attribute_category IN VARCHAR2,
181 x_attribute1 IN VARCHAR2,
182 x_attribute2 IN VARCHAR2,
183 x_attribute3 IN VARCHAR2,
184 x_attribute4 IN VARCHAR2,
185 x_attribute5 IN VARCHAR2,
186 x_attribute6 IN VARCHAR2,
187 x_attribute7 IN VARCHAR2,
188 x_attribute8 IN VARCHAR2,
189 x_attribute9 IN VARCHAR2,
190 x_attribute10 IN VARCHAR2,
191 x_attribute11 IN VARCHAR2,
192 x_attribute12 IN VARCHAR2,
193 x_attribute13 IN VARCHAR2,
194 x_attribute14 IN VARCHAR2,
195 x_attribute15 IN VARCHAR2,
196 x_min_release_amount IN NUMBER,
200 x_ussgl_transaction_code IN VARCHAR2,
197 x_price_type_lookup_code IN VARCHAR2,
198 x_closed_code IN VARCHAR2,
199 x_price_break_lookup_code IN VARCHAR2,
201 x_government_context IN VARCHAR2,
202 x_request_id IN NUMBER,
203 x_program_application_id IN NUMBER,
204 x_program_id IN NUMBER,
205 x_program_update_date IN DATE,
206 x_closed_date IN DATE,
207 x_closed_reason IN VARCHAR2,
208 x_closed_by IN NUMBER,
209 x_transaction_reason_code IN VARCHAR2,
210 x_org_id IN NUMBER,
211 x_line_reference_num IN VARCHAR2,
212 x_terms_id IN NUMBER,
213 x_qty_rcv_exception_code IN VARCHAR2,
214 x_lead_time_unit IN VARCHAR2,
215 x_freight_carrier IN VARCHAR2,
216 x_fob IN VARCHAR2,
217 x_freight_terms IN VARCHAR2,
218 x_release_num IN NUMBER,
219 x_po_release_id IN NUMBER,
220 x_source_shipment_id IN NUMBER,
221 x_inspection_required_flag IN VARCHAR2,
222 x_receipt_required_flag IN VARCHAR2,
223 x_receipt_days_exception_code IN VARCHAR2,
224 x_need_by_date IN DATE,
225 x_promised_date IN DATE,
226 x_lead_time IN NUMBER,
227 x_invoice_close_tolerance IN NUMBER,
228 x_receive_close_tolerance IN NUMBER,
229 x_firm_flag IN VARCHAR2,
230 x_days_early_receipt_allowed IN NUMBER,
231 x_days_late_receipt_allowed IN NUMBER,
232 x_enforce_ship_to_loc_code IN VARCHAR2,
233 x_allow_sub_receipts_flag IN VARCHAR2,
234 x_receiving_routing IN VARCHAR2,
235 x_receiving_routing_id IN NUMBER,
236 x_header_processable_flag IN OUT NOCOPY VARCHAR2,
237 x_def_inv_org_id IN NUMBER,
238 x_uom_code IN VARCHAR2,
239 x_hd_type_lookup_code IN VARCHAR2,
240 x_create_or_update_item_flag IN VARCHAR2,
241 X_global_agreement_flag IN VARCHAR2 default null, -- FPI GA
245 p_job_id IN NUMBER,
242 p_shipment_num IN NUMBER, /* <TIMEPHASED FPI> */
243 p_contract_id IN NUMBER, -- <GC FPJ>
244 --<SERVICES FPJ START>
246 p_effective_date IN DATE,
247 p_expiration_date IN DATE,
248 p_amount IN NUMBER,
249 p_order_type_lookup_code IN VARCHAR2,
250 p_purchase_basis IN VARCHAR2,
251 p_service_uom_class IN VARCHAR2
252 --<SERVICES FPJ END>
253 -- <bug 3325447 start>
254 , p_contractor_first_name IN VARCHAR2
255 , p_contractor_last_name IN VARCHAR2
256 -- <bug 3325447 end>
257 , p_job_business_group_id IN NUMBER --<BUG 3296145>
258 );
259
260
261 END PO_LINES_SV7;