1 PACKAGE PO_LINE_LOCATIONS_SV7 AS
2 /* $Header: POXPISVS.pls 120.0.12000000.1 2007/01/16 23:04:49 appldev ship $ */
3
4 /*==================================================================
5 PROCEDURE NAME: validate_po_line_coordination()
6
7 DESCRIPTION: This API is used to validate to see if we can
8 find a coordinated releationship between
9 po_lines table and po_line_locations table.
10
11 PARAMETERS: X_interface_header_id IN NUMBER,
12 X_interface_line_id IN NUMBER,
13 X_item_id IN NUMBER,
14 X_item_description IN VARCHAR2,
15 X_item_revision IN VARCHAR2,
16 X_po_line_id IN NUMBER,
17 X_po_header_id IN NUMBER,
18 X_unit_of_measure IN VARCHAR2,
19 X_line_type_id IN NUMBER,
20 X_category_id IN NUMBER,
21 X_type_lookup_code IN VARCHAR2,
22 X_header_processable_flag IN OUT NOCOPY VARCHAR2
23
24 DESIGN
25 REFERENCES: 832valapl.doc
26
27 ALGORITHM:
28
29 NOTES:
30
31 OPEN ISSUES:
32
33 CLOSED ISSUES:
34
35 CHANGE
36 HISTORY: Created 1-MAY-1996 Daisy Yu
37 Bug 2845962. Added a new IN 14-MAR-2003 David Ng
38 parameter p_line_num.
39 =======================================================================*/
40 PROCEDURE validate_po_line_coordination(
41 X_interface_header_id IN NUMBER,
42 X_interface_line_id IN NUMBER,
43 X_item_id IN NUMBER,
44 X_item_description IN VARCHAR2,
45 X_item_revision IN VARCHAR2,
46 X_po_line_id IN NUMBER,
47 X_po_header_id IN NUMBER,
48 X_unit_of_measure IN VARCHAR2,
49 X_line_type_id IN NUMBER,
50 X_category_id IN NUMBER,
51 X_type_lookup_code IN VARCHAR2,
52 X_header_processable_flag IN OUT NOCOPY VARCHAR2,
53 p_line_num IN NUMBER,
54 p_job_id IN NUMBER --<FPJ SERVICES>
55 );
56
57 /*==================================================================
58 PROCEDURE NAME: validate_po_line_locations()
59
60 DESCRIPTION: This API is used to validate columns which will be
61 inserted into po_line_locations table during the
62 purchasing docs open interface load.
63
64 PARAMETERS: all columns in po_line_locations
65
66 DESIGN
67 REFERENCES: 832valapl.doc
68
69 ALGORITHM:
70
71 NOTES:
72
73 OPEN ISSUES:
74
75 CLOSE ISSUES:
76
77 CHANGE
78 HISTORY: Created 21-FEB-1996 DXYU
79 MOdified 22-FEB-1996 DXYU
80 Modified 26-APR-1996 DXYU
81
82 =======================================================================*/
83 PROCEDURE validate_po_line_locations(
84 x_interface_header_id IN NUMBER,
85 x_interface_line_id IN NUMBER,
86 x_line_location_id IN NUMBER,
87 x_last_update_date IN DATE,
88 x_last_updated_by IN NUMBER,
89 x_po_header_id IN NUMBER,
90 x_po_line_id IN NUMBER,
91 x_last_update_login IN NUMBER,
92 x_creation_date IN DATE,
93 x_created_by IN NUMBER,
94 x_quantity IN NUMBER,
95 x_quantity_received IN NUMBER,
96 x_quantity_accepted IN NUMBER,
97 x_quantity_rejected IN NUMBER,
98 x_quantity_billed IN NUMBER,
99 x_quantity_cancelled IN NUMBER,
100 x_unit_meas_lookup_code IN VARCHAR2,
101 x_po_release_id IN NUMBER,
102 x_ship_to_location_id IN NUMBER,
103 x_ship_via_lookup_code IN VARCHAR2,
104 x_need_by_date IN DATE,
105 x_promised_date IN DATE,
106 x_last_accept_date IN DATE,
107 x_price_override IN NUMBER,
108 x_encumbered_flag IN VARCHAR2,
109 x_encumbered_date IN DATE,
110 x_fob_lookup_code IN VARCHAR2,
111 x_freight_terms_lookup_code IN VARCHAR2,
112 x_taxable_flag IN VARCHAR2,
113 x_tax_name IN VARCHAR2,
114 x_estimated_tax_amount IN NUMBER,
115 x_from_header_id IN NUMBER,
116 x_from_line_id IN NUMBER,
117 x_from_line_location_id IN NUMBER,
118 x_start_date IN DATE,
119 x_end_date IN DATE,
120 x_lead_time IN NUMBER,
121 x_lead_time_unit IN VARCHAR2,
122 x_price_discount IN NUMBER,
123 x_terms_id IN NUMBER,
124 x_approved_flag IN VARCHAR2,
125 x_approved_date IN DATE,
126 x_closed_flag IN VARCHAR2,
127 x_cancel_flag IN VARCHAR2,
128 x_cancelled_by IN NUMBER,
129 x_cancel_date IN DATE,
130 x_cancel_reason IN VARCHAR2,
131 x_firm_status_lookup_code IN VARCHAR2,
132 x_firm_date IN DATE,
133 x_attribute_category IN VARCHAR2,
134 x_attribute1 IN VARCHAR2,
135 x_attribute2 IN VARCHAR2,
136 x_attribute3 IN VARCHAR2,
137 x_attribute4 IN VARCHAR2,
138 x_attribute5 IN VARCHAR2,
139 x_attribute6 IN VARCHAR2,
140 x_attribute7 IN VARCHAR2,
141 x_attribute8 IN VARCHAR2,
142 x_attribute9 IN VARCHAR2,
143 x_attribute10 IN VARCHAR2,
144 x_unit_of_measure_class IN VARCHAR2,
145 x_attribute11 IN VARCHAR2,
146 x_attribute12 IN VARCHAR2,
147 x_attribute13 IN VARCHAR2,
148 x_attribute14 IN VARCHAR2,
149 x_attribute15 IN VARCHAR2,
150 x_inspection_required_flag IN VARCHAR2,
151 x_receipt_required_flag IN VARCHAR2,
152 x_qty_rcv_tolerance IN NUMBER,
153 x_qty_rcv_exception_code IN VARCHAR2,
154 x_enforce_ship_to_loc_code IN VARCHAR2,
155 x_allow_sub_receipts_flag IN VARCHAR2,
156 x_days_early_receipt_allowed IN NUMBER,
157 x_days_late_receipt_allowed IN NUMBER,
158 x_receipt_days_exception_code IN VARCHAR2,
159 x_invoice_close_tolerance IN NUMBER,
160 x_receive_close_tolerance IN NUMBER,
161 x_ship_to_organization_id IN NUMBER,
162 x_shipment_num IN NUMBER,
163 x_source_shipment_id IN NUMBER,
164 x_shipment_type IN VARCHAR2,
165 x_closed_code IN VARCHAR2,
166 x_request_id IN NUMBER,
167 x_program_application_id IN NUMBER,
168 x_program_id IN NUMBER,
169 x_program_update_date IN DATE,
170 x_ussgl_transaction_code IN VARCHAR2,
171 x_government_context IN VARCHAR2,
172 x_receiving_routing_id IN NUMBER,
173 x_accrue_on_receipt_flag IN VARCHAR2,
174 x_closed_reason IN VARCHAR2,
175 x_closed_date IN DATE,
176 x_closed_by IN NUMBER,
177 x_org_id IN NUMBER,
178 X_def_inv_org_id IN NUMBER,
179 x_header_processable_flag IN OUT NOCOPY VARCHAR2,
180 x_hd_type_lookup_code IN VARCHAR2,
181 X_item_id IN NUMBER,
182 X_item_revision IN VARCHAR2,
183 p_item_category_id IN NUMBER, --< Shared Proc FPJ >
184 x_transaction_flow_header_id OUT NOCOPY NUMBER, --< Shared Proc FPJ >
185 p_order_type_lookup_code IN VARCHAR2, --<SERVICES FPJ>
186 p_purchase_basis IN VARCHAR2, --<SERVICES FPJ>
187 p_job_id IN NUMBER
188 );
189
190 /*==================================================================
191 PROCEDURE NAME: val_line_location_id_unqiue()
192
193 DESCRIPTION: This API is used to validate the unqiueness of
194 line_location_id in PO_LINE_LOCATIONS. IF will return
195 TRUE if line_location_id is UNIQUE; FALSE otherwise.
196
197 MODULE TYPE: Function
198
199 RETURNS: TRUE if validation succeeds
200 FALSE otherwise
201
202 PARAMETER: X_line_location_id IN VARCHAR2
203
204 DESIGN
205 REFERENCES: 832valapl.doc
206
207 ALGORITHM:
208
209 NOTES:
210
211 OPEN ISSUES:
212
213 CLOSE ISSUES:
214
215 CHANGE
216 HISTORY: Created 1-MAY-1996 Daisy Yu
217
218 =======================================================================*/
219 FUNCTION val_line_location_id_unique(X_line_location_id IN NUMBER)
220 RETURN BOOLEAN;
221
222 END PO_LINE_LOCATIONS_SV7;