1 PACKAGE PO_VAL_HEADERS2 AUTHID CURRENT_USER AS
2 -- $Header: PO_VAL_HEADERS2.pls 120.13 2010/12/20 11:16:55 sknandip ship $
3
4 -------------------------------------------------------------------------
5 -- po_header_id cannot be null and must not exist in Transaction header table.
6 -- Called for the create case.
7 -------------------------------------------------------------------------
8 PROCEDURE po_header_id(p_id_tbl IN po_tbl_number,
9 p_po_header_id_tbl IN po_tbl_number,
10 x_result_set_id IN OUT NOCOPY NUMBER,
11 x_result_type OUT NOCOPY VARCHAR2);
12
13 -------------------------------------------------------------------------
14 -- type_lookup_code cannot be null and must be equal to
15 -- BLANKET, STANDARD or QUOTATION.
16 -------------------------------------------------------------------------
17 PROCEDURE type_lookup_code(p_id_tbl IN po_tbl_number,
18 p_type_lookup_code_tbl IN po_tbl_varchar30,
19 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
20 x_result_type OUT NOCOPY VARCHAR2);
21
22 -----------------------------------------------------------------------------------------
23 -- document_num must not null, must be unique, greater than or equal to zero and be of the correct type.
24 -----------------------------------------------------------------------------------------
25 PROCEDURE document_num(
26 p_id_tbl IN po_tbl_number,
27 p_po_header_id_tbl IN po_tbl_number,
28 p_document_num_tbl IN po_tbl_varchar30,
29 p_type_lookup_code_tbl IN po_tbl_varchar30,
30 p_manual_po_num_type IN VARCHAR2,
31 p_manual_quote_num_type IN VARCHAR2,
32 x_results IN OUT NOCOPY po_validation_results_type,
33 x_result_set_id IN OUT NOCOPY NUMBER,
34 x_result_type OUT NOCOPY VARCHAR2);
35
36 -------------------------------------------------------------------------
37 -- validate currency_code not null and against FND_CURRENCIES.
38 -------------------------------------------------------------------------
39 PROCEDURE currency_code(p_id_tbl IN po_tbl_number,
40 p_currency_code_tbl IN po_tbl_varchar30,
41 x_result_set_id IN OUT NOCOPY NUMBER,
42 x_result_type OUT NOCOPY VARCHAR2);
43
44 -------------------------------------------------------------------------
45 -- If currency_code equals functional currency code, rate_type, rate_date and rate must be null.
46 -- If currency_code does not equal functional currency code, validate rate_type not null,
47 -- validate rate_type against gl_daily_conversion_type_v, validate rate is not null and positive,
48 -- validate rate against g1_currency_api.get_rate().
49 -------------------------------------------------------------------------
50 PROCEDURE rate_info(p_id_tbl IN po_tbl_number,
51 p_currency_code_tbl IN PO_TBL_VARCHAR30,
52 p_rate_type_tbl IN PO_TBL_VARCHAR30,
53 p_rate_tbl IN po_tbl_number,
54 p_rate_date_tbl IN po_tbl_date,
55 p_func_currency_code IN VARCHAR2,
56 p_set_of_books_id IN NUMBER,
57 x_result_set_id IN OUT NOCOPY NUMBER,
58 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
59 x_result_type OUT NOCOPY VARCHAR2);
60
61 -------------------------------------------------------------------------
62 -- Agent Id must not be null and validate against PO_AGENTS.
63 -------------------------------------------------------------------------
64 PROCEDURE agent_id(p_id_tbl IN po_tbl_number,
65 p_agent_id_tbl IN po_tbl_number,
66 x_result_set_id IN OUT NOCOPY NUMBER,
67 x_result_type OUT NOCOPY VARCHAR2);
68
69 -------------------------------------------------------------------------
70 -- validate vendorId is Not Null
71 -- validate vendorSiteId is Not Null
72 -- validate vendor_id using po_suppliers_val_v
73 -- validate vendor_site_id using po_supplier_sites_val_v
74 -- validate vendor_contact_id using po_vendor_contacts
75 -- validate vendor site CCR if approval status is APPROVED.
76 -------------------------------------------------------------------------
77 PROCEDURE vendor_info(p_id_tbl IN po_tbl_number,
78 p_vendor_id_tbl IN po_tbl_number,
79 p_vendor_site_id_tbl IN po_tbl_number,
80 p_vendor_contact_id_tbl IN po_tbl_number,
81 p_type_lookup_code_tbl IN po_tbl_varchar30, --8913559 bug
82 p_federal_instance IN VARCHAR,
83 x_result_set_id IN OUT NOCOPY NUMBER,
84 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
85 x_result_type OUT NOCOPY VARCHAR2);
86
87 -------------------------------------------------------------------------
88 -- ShipToLocationId must not be null and valid in HR_LOCATIONS.
89 -------------------------------------------------------------------------
90 PROCEDURE ship_to_location_id(p_id_tbl IN po_tbl_number,
91 p_ship_to_location_id_tbl IN po_tbl_number,
92 -- Bug 7007502: Added new param p_type_lookup_code_tbl
93 p_type_lookup_code_tbl IN po_tbl_varchar30,
94 x_result_set_id IN OUT NOCOPY NUMBER,
95 x_result_type OUT NOCOPY VARCHAR2);
96
97 -------------------------------------------------------------------------
98 -- BillToLocationId must not be null and validate against HR_LOCATIONS.
99 -------------------------------------------------------------------------
100 PROCEDURE bill_to_location_id(p_id_tbl IN po_tbl_number,
101 p_bill_to_location_id_tbl IN po_tbl_number,
102 -- Bug 7007502: Added new param p_type_lookup_code_tbl
103 p_type_lookup_code_tbl IN po_tbl_varchar30,
104 x_result_set_id IN OUT NOCOPY NUMBER,
105 x_result_type OUT NOCOPY VARCHAR2);
106
107 -------------------------------------------------------------------------
108 -- validate ship_via_lookup_code against ORG_FREIGHT
109 -------------------------------------------------------------------------
110 PROCEDURE ship_via_lookup_code(p_id_tbl IN po_tbl_number,
111 p_ship_via_lookup_code_tbl IN PO_TBL_VARCHAR30,
112 p_inventory_org_id IN NUMBER,
113 x_result_set_id IN OUT NOCOPY NUMBER,
114 x_result_type OUT NOCOPY VARCHAR2);
115
116 -------------------------------------------------------------------------
117 -- validate fob_lookup_code against PO_LOOKUP_CODES
118 -------------------------------------------------------------------------
119 PROCEDURE fob_lookup_code(p_id_tbl IN po_tbl_number,
120 p_fob_lookup_code_tbl IN PO_TBL_VARCHAR30,
121 x_result_set_id IN OUT NOCOPY NUMBER,
122 x_result_type OUT NOCOPY VARCHAR2);
123
124 -------------------------------------------------------------------------
125 -- validate freight_terms_lookup_code against PO_LOOKUP_CODES
126 -------------------------------------------------------------------------
127 PROCEDURE freight_terms_lookup_code(p_id_tbl IN po_tbl_number,
128 p_freight_terms_lookup_tbl IN PO_TBL_VARCHAR30,
129 x_result_set_id IN OUT NOCOPY NUMBER,
130 x_result_type OUT NOCOPY VARCHAR2);
131
132 -------------------------------------------------------------------------
133 -- validate shipping_control against PO_LOOKUP_CODES
134 -------------------------------------------------------------------------
135 PROCEDURE shipping_control(p_id_tbl IN po_tbl_number,
136 p_shipping_control_tbl IN PO_TBL_VARCHAR30,
137 x_result_set_id IN OUT NOCOPY NUMBER,
138 x_result_type OUT NOCOPY VARCHAR2);
139
140 -------------------------------------------------------------------------
141 -- validate acceptance_due_date is not null if acceptance_required_flag = Y.
142 -- Only called for Blanket and SPO.
143 -------------------------------------------------------------------------
144 PROCEDURE acceptance_due_date(p_id_tbl IN po_tbl_number,
145 p_acceptance_reqd_flag_tbl IN PO_TBL_VARCHAR1,
146 p_acceptance_due_date_tbl IN po_tbl_date,
147 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
148 x_result_type OUT NOCOPY VARCHAR2);
149
150 -------------------------------------------------------------------------
151 -- validate cancel_flag = N. Only called for Blanket and SPO.
152 -------------------------------------------------------------------------
153 PROCEDURE cancel_flag(p_id_tbl IN po_tbl_number,
154 p_cancel_flag_tbl IN PO_TBL_VARCHAR1,
155 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
156 x_result_type OUT NOCOPY VARCHAR2);
157
158 -------------------------------------------------------------------------
159 -- validate closed_code = OPEN. Only called for Blanket and SPO.
160 -------------------------------------------------------------------------
161 PROCEDURE closed_code(p_id_tbl IN po_tbl_number,
162 p_closed_code_tbl IN PO_TBL_VARCHAR30,
163 p_acceptance_reqd_flag_tbl IN PO_TBL_VARCHAR1,
164 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
165 x_result_type OUT NOCOPY VARCHAR2);
166
167 -------------------------------------------------------------------------
168 -- validate print_count = 0. Only called for Blanket and SPO.
169 -------------------------------------------------------------------------
170 PROCEDURE print_count(p_id_tbl IN po_tbl_number,
171 p_print_count_tbl IN po_tbl_number,
172 p_approval_status_tbl IN PO_TBL_VARCHAR30,
173 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
174 x_result_type OUT NOCOPY VARCHAR2);
175
176 -------------------------------------------------------------------------
177 -- validate approval_status = INCOMPLETE, APPROVED, INITIATE APPROVAL.
178 -- Only called for Blanket and SPO.
179 -------------------------------------------------------------------------
180 PROCEDURE approval_status(p_id_tbl IN po_tbl_number,
181 p_approval_status_tbl IN PO_TBL_VARCHAR30,
182 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
183 x_result_type OUT NOCOPY VARCHAR2);
184
185 -------------------------------------------------------------------------
186 -- validate amount_to_encumber > 0
187 -------------------------------------------------------------------------
188 PROCEDURE amount_to_encumber(p_id_tbl IN po_tbl_number,
189 p_amount_to_encumber_tbl IN po_tbl_number,
190 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
191 x_result_type OUT NOCOPY VARCHAR2);
192
193 ------------------------------------------------------------------------------
194 -- Validate style_id exists in system, is active and is not enabled for complex work.
195 ------------------------------------------------------------------------------
196 PROCEDURE style_id(p_id_tbl IN po_tbl_number,
197 p_style_id_tbl IN po_tbl_number,
198 x_result_set_id IN OUT NOCOPY NUMBER,
199 x_result_type OUT NOCOPY VARCHAR2);
200
201 -- bug4911388
202 -------------------------------------------------------------------------
203 -- validate that acceptance_reuqired_flag has correct value
204 -------------------------------------------------------------------------
205 PROCEDURE acceptance_required_flag
206 ( p_id_tbl IN PO_TBL_NUMBER,
207 p_type_lookup_code_tbl IN PO_TBL_VARCHAR30,
208 p_acceptance_required_flag_tbl IN PO_TBL_VARCHAR1,
209 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
210 x_result_type OUT NOCOPY VARCHAR2
211 );
212
213
214 -- bug5352625
215 -------------------------------------------------------------------------
216 -- validate that amount limit is valid
217 -------------------------------------------------------------------------
218 PROCEDURE amount_limit
219 ( p_id_tbl IN PO_TBL_NUMBER,
220 p_amount_limit_tbl IN PO_TBL_NUMBER,
221 p_amount_agreed_tbl IN PO_TBL_NUMBER,
222 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
223 x_result_type OUT NOCOPY VARCHAR2
224 );
225
226
227 END PO_VAL_HEADERS2;