[Home] [Help]
PACKAGE: APPS.PO_VAL_SHIPMENTS
Source
1 PACKAGE PO_VAL_SHIPMENTS AUTHID CURRENT_USER AS
2 -- $Header: PO_VAL_SHIPMENTS.pls 120.17.12020000.4 2013/04/03 22:31:40 rarajar ship $
3
4 PROCEDURE days_early_gte_zero(
5 p_line_loc_id_tbl IN PO_TBL_NUMBER
6 , p_days_early_rcpt_allowed_tbl IN PO_TBL_NUMBER
7 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
8 , x_result_type OUT NOCOPY VARCHAR2
9 );
10
11 PROCEDURE days_late_gte_zero(
12 p_line_loc_id_tbl IN PO_TBL_NUMBER
13 , p_days_late_rcpt_allowed_tbl IN PO_TBL_NUMBER
14 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
15 , x_result_type OUT NOCOPY VARCHAR2
16 );
17
18 PROCEDURE rcv_close_tol_within_range (
19 p_line_loc_id_tbl IN PO_TBL_NUMBER
20 , p_receive_close_tolerance_tbl IN PO_TBL_NUMBER
21 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
22 , x_result_type OUT NOCOPY VARCHAR2
23 );
24
25 PROCEDURE over_rcpt_tol_within_range (
26 p_line_loc_id_tbl IN PO_TBL_NUMBER
27 , p_qty_rcv_tolerance_tbl IN PO_TBL_NUMBER
28 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
29 , x_result_type OUT NOCOPY VARCHAR2
30 );
31
32 PROCEDURE planned_item_null_date_check (
33 p_line_loc_id_tbl IN PO_TBL_NUMBER
34 , p_need_by_date_tbl IN PO_TBL_DATE
35 , p_promised_date_tbl IN PO_TBL_DATE
36 , p_item_id_tbl IN PO_TBL_NUMBER
37 , x_result_set_id IN OUT NOCOPY NUMBER
38 , x_result_type OUT NOCOPY VARCHAR2
39 );
40
41 PROCEDURE match_4way_check(
42 p_line_loc_id_tbl IN PO_TBL_NUMBER
43 , p_value_basis_tbl IN PO_TBL_VARCHAR30 -- <Complex Work R12>
44 , p_receipt_required_flag_tbl IN PO_TBL_VARCHAR1
45 , p_inspection_required_flag_tbl IN PO_TBL_VARCHAR1
46 , p_payment_type_tbl IN PO_TBL_VARCHAR30 -- <Complex Work R12>
47 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
48 , x_result_type OUT NOCOPY VARCHAR2
49 );
50
51 PROCEDURE inv_close_tol_range_check (
52 p_line_loc_id_tbl IN PO_TBL_NUMBER
53 , p_invoice_close_tolerance_tbl IN PO_TBL_NUMBER
54 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
55 , x_result_type OUT NOCOPY VARCHAR2
56 );
57
58 --PBWC Message Change Impact: Adding a token
59 PROCEDURE need_by_date_open_period_check(
60 p_line_loc_id_tbl IN PO_TBL_NUMBER
61 , p_line_id_tbl IN PO_TBL_NUMBER
62 , p_need_by_date_tbl IN PO_TBL_DATE
63 , p_org_id_tbl IN PO_TBL_NUMBER
64 , x_result_set_id IN OUT NOCOPY NUMBER
65 , x_result_type OUT NOCOPY VARCHAR2
66 );
67
68 --PBWC Message Change Impact: Adding a token
69 PROCEDURE promise_date_open_period_check(
70 p_line_loc_id_tbl IN PO_TBL_NUMBER
71 , p_line_id_tbl IN PO_TBL_NUMBER
72 , p_promised_date_tbl IN PO_TBL_DATE
73 , p_org_id_tbl IN PO_TBL_NUMBER
74 , x_result_set_id IN OUT NOCOPY NUMBER
75 , x_result_type OUT NOCOPY VARCHAR2
76 );
77
78 PROCEDURE ship_to_org_null_check(
79 p_line_loc_id_tbl IN PO_TBL_NUMBER
80 , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
81 , p_shipment_type_tbl IN PO_TBL_VARCHAR30
82 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
83 , x_result_type OUT NOCOPY VARCHAR2
84 );
85
86 PROCEDURE ship_to_loc_null_check(
87 p_line_loc_id_tbl IN PO_TBL_NUMBER
88 , p_ship_to_loc_id_tbl IN PO_TBL_NUMBER
89 , p_shipment_type_tbl IN PO_TBL_VARCHAR30
90 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
91 , x_result_type OUT NOCOPY VARCHAR2
92 );
93
94 PROCEDURE ship_num_gt_zero(
95 p_line_loc_id_tbl IN PO_TBL_NUMBER
96 , p_shipment_num_tbl IN PO_TBL_NUMBER
97 , p_payment_type_tbl IN PO_TBL_VARCHAR30 -- <Complex Work R12>
98 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
99 , x_result_type OUT NOCOPY VARCHAR2
100 );
101
102 PROCEDURE ship_num_unique_check(
103 p_line_loc_id_tbl IN PO_TBL_NUMBER
104 , p_line_id_tbl IN PO_TBL_NUMBER
105 , p_shipment_num_tbl IN PO_TBL_NUMBER
106 , p_shipment_type_tbl IN PO_TBL_VARCHAR30 -- <Complex Work R12>
107 , p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL --<PAR Project>
108 , p_draft_id_tbl IN PO_TBL_NUMBER --<PAR Project>
109 , x_result_set_id IN OUT NOCOPY NUMBER
110 , x_result_type OUT NOCOPY VARCHAR2
111 );
112
113 --PBWC Message Change Impact: Adding a token
114 PROCEDURE is_org_in_current_sob_check (
115 p_line_loc_id_tbl IN PO_TBL_NUMBER
116 , p_line_id_tbl IN PO_TBL_NUMBER
117 , p_org_id_tbl IN PO_TBL_NUMBER
118 , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
119 , p_consigned_flag_tbl IN PO_TBL_VARCHAR1
120 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
121 , x_result_type OUT NOCOPY VARCHAR2
122 );
123
124 PROCEDURE quantity_gt_zero(
125 p_line_loc_id_tbl IN PO_TBL_NUMBER
126 , p_quantity_tbl IN PO_TBL_NUMBER
127 , p_shipment_type_tbl IN PO_TBL_VARCHAR30
128 , p_value_basis_tbl IN PO_TBL_VARCHAR30 -- <Complex Work R12>
129 , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
130 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
131 , x_result_type OUT NOCOPY VARCHAR2
132 , p_header_id_tbl IN PO_TBL_NUMBER --<Bug 15871378>
133 );
134
135 -- <Complex Work R12 Start>: Combine qty rcvd/billed into qty exec
136
137 PROCEDURE quantity_ge_quantity_exec(
138 p_line_loc_id_tbl IN PO_TBL_NUMBER
139 , p_quantity_tbl IN PO_TBL_NUMBER
140 , x_result_set_id IN OUT NOCOPY NUMBER
141 , x_result_type OUT NOCOPY VARCHAR2
142 );
143
144 -- <Complex Work R12 End>
145
146
147 PROCEDURE amount_gt_zero(
148 p_line_loc_id_tbl IN PO_TBL_NUMBER
149 , p_amount_tbl IN PO_TBL_NUMBER
150 , p_shipment_type_tbl IN PO_TBL_VARCHAR30
151 , p_value_basis_tbl IN PO_TBL_VARCHAR30 -- <Complex Work R12>
152 , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
153 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
154 , x_result_type OUT NOCOPY VARCHAR2
155 , p_header_id_tbl IN PO_TBL_NUMBER --<Bug 15871378>
156 );
157
158 -- <Complex Work R12 Start>: Combine amt rcvd/billed into amt exec
159 PROCEDURE amount_ge_amount_exec(
160 p_line_loc_id_tbl IN PO_TBL_NUMBER
161 , p_amount_tbl IN PO_TBL_NUMBER
162 , x_result_set_id IN OUT NOCOPY NUMBER
163 , x_result_type OUT NOCOPY VARCHAR2
164 );
165 -- <Complex Work R12 End>
166
167
168 -- OPM Integration R12 Start
169 PROCEDURE ship_sec_quantity_gt_zero(
170 p_line_loc_id_tbl IN PO_TBL_NUMBER
171 , p_item_id_tbl IN PO_TBL_NUMBER
172 , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
173 , p_sec_quantity_tbl IN PO_TBL_NUMBER
174 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
175 , x_result_type OUT NOCOPY VARCHAR2
176 );
177
178 PROCEDURE ship_qtys_within_deviation (
179 p_line_loc_id_tbl IN PO_TBL_NUMBER
180 , p_item_id_tbl IN PO_TBL_NUMBER
181 , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
182 , p_quantity_tbl IN PO_TBL_NUMBER
183 , p_primary_uom_tbl IN PO_TBL_VARCHAR30
184 , p_sec_quantity_tbl IN PO_TBL_NUMBER
185 , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
186 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
187 , x_result_type OUT NOCOPY VARCHAR2
188 );
189 -- OPM Integration R12 End
190
191 /*
192 Bug 5385686 : Unit of measure must be checked for null on Pay Items
193 */
194 PROCEDURE unit_of_measure_not_null(
195 p_line_loc_id_tbl IN PO_TBL_NUMBER
196 , p_payment_type_tbl IN PO_TBL_VARCHAR30
197 , p_value_basis_tbl IN PO_TBL_VARCHAR30
198 , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30
199 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
200 , x_result_type OUT NOCOPY VARCHAR2
201 );
202
203 --Mod Project
204 PROCEDURE mod_no_cancel_shp_complt(
205 p_line_loc_id_tbl IN PO_TBL_NUMBER
206 ,p_control_action_tbl IN PO_TBL_VARCHAR30
207 ,x_result_set_id IN OUT NOCOPY NUMBER
208 ,x_result_type OUT NOCOPY VARCHAR2
209 );
210
211 PROCEDURE pop_date_need_by_date
212 (
213 p_line_id_tbl IN PO_TBL_NUMBER
214 , p_start_date_tbl IN PO_TBL_DATE
215 , p_end_date_tbl IN PO_TBL_DATE
216 , p_need_by_date_tbl IN PO_TBL_DATE
217 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
218 , x_result_type OUT NOCOPY VARCHAR2
219 );
220
221 PROCEDURE pop_start_date_le_end_date
222 (
223 p_line_id_tbl IN PO_TBL_NUMBER
224 , p_start_date_tbl IN PO_TBL_DATE
225 , p_expiration_date_tbl IN PO_TBL_DATE
226 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
227 , x_result_type OUT NOCOPY VARCHAR2
228 );
229
230 PROCEDURE complex_price_or_gt_zero(
231 p_line_loc_id_tbl IN PO_TBL_NUMBER
232 , p_price_override_tbl IN PO_TBL_NUMBER
233 , p_value_basis_tbl IN PO_TBL_VARCHAR30
234 , p_payment_type_tbl IN PO_TBL_VARCHAR30
235 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
236 , x_result_type OUT NOCOPY VARCHAR2
237 );
238
239 END PO_VAL_SHIPMENTS;