[Home] [Help]
PACKAGE: APPS.PO_VAL_SHIPMENTS
Source
1 PACKAGE PO_VAL_SHIPMENTS AS
2 -- $Header: PO_VAL_SHIPMENTS.pls 120.11 2006/09/01 09:18:47 nlondhe noship $
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 , x_result_set_id IN OUT NOCOPY NUMBER
108 , x_result_type OUT NOCOPY VARCHAR2
109 );
110
111 --PBWC Message Change Impact: Adding a token
112 PROCEDURE is_org_in_current_sob_check (
113 p_line_loc_id_tbl IN PO_TBL_NUMBER
114 , p_line_id_tbl IN PO_TBL_NUMBER
115 , p_org_id_tbl IN PO_TBL_NUMBER
116 , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
117 , p_consigned_flag_tbl IN PO_TBL_VARCHAR1
118 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
119 , x_result_type OUT NOCOPY VARCHAR2
120 );
121
122 PROCEDURE quantity_gt_zero(
123 p_line_loc_id_tbl IN PO_TBL_NUMBER
124 , p_quantity_tbl IN PO_TBL_NUMBER
125 , p_shipment_type_tbl IN PO_TBL_VARCHAR30
126 , p_value_basis_tbl IN PO_TBL_VARCHAR30 -- <Complex Work R12>
127 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
128 , x_result_type OUT NOCOPY VARCHAR2
129 );
130
131 -- <Complex Work R12 Start>: Combine qty rcvd/billed into qty exec
132
133 PROCEDURE quantity_ge_quantity_exec(
134 p_line_loc_id_tbl IN PO_TBL_NUMBER
135 , p_quantity_tbl IN PO_TBL_NUMBER
136 , x_result_set_id IN OUT NOCOPY NUMBER
137 , x_result_type OUT NOCOPY VARCHAR2
138 );
139
140 -- <Complex Work R12 End>
141
142 PROCEDURE amount_gt_zero(
143 p_line_loc_id_tbl IN PO_TBL_NUMBER
144 , p_amount_tbl IN PO_TBL_NUMBER
145 , p_shipment_type_tbl IN PO_TBL_VARCHAR30
146 , p_value_basis_tbl IN PO_TBL_VARCHAR30 -- <Complex Work R12>
147 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
148 , x_result_type OUT NOCOPY VARCHAR2
149 );
150
151 -- <Complex Work R12 Start>: Combine amt rcvd/billed into amt exec
152 PROCEDURE amount_ge_amount_exec(
153 p_line_loc_id_tbl IN PO_TBL_NUMBER
154 , p_amount_tbl IN PO_TBL_NUMBER
155 , x_result_set_id IN OUT NOCOPY NUMBER
156 , x_result_type OUT NOCOPY VARCHAR2
157 );
158 -- <Complex Work R12 End>
159
160 -- OPM Integration R12 Start
161 PROCEDURE ship_sec_quantity_gt_zero(
162 p_line_loc_id_tbl IN PO_TBL_NUMBER
163 , p_item_id_tbl IN PO_TBL_NUMBER
164 , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
165 , p_sec_quantity_tbl IN PO_TBL_NUMBER
166 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
167 , x_result_type OUT NOCOPY VARCHAR2
168 );
169
170 PROCEDURE ship_qtys_within_deviation (
171 p_line_loc_id_tbl IN PO_TBL_NUMBER
172 , p_item_id_tbl IN PO_TBL_NUMBER
173 , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
174 , p_quantity_tbl IN PO_TBL_NUMBER
175 , p_primary_uom_tbl IN PO_TBL_VARCHAR30
176 , p_sec_quantity_tbl IN PO_TBL_NUMBER
177 , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
178 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
179 , x_result_type OUT NOCOPY VARCHAR2
180 );
181 -- OPM Integration R12 End
182
183 /*
184 Bug 5385686 : Unit of measure must be checked for null on Pay Items
185 */
186 PROCEDURE unit_of_measure_not_null(
187 p_line_loc_id_tbl IN PO_TBL_NUMBER
188 , p_payment_type_tbl IN PO_TBL_VARCHAR30
189 , p_value_basis_tbl IN PO_TBL_VARCHAR30
190 , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30
191 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
192 , x_result_type OUT NOCOPY VARCHAR2
193 );
194
195 END PO_VAL_SHIPMENTS;