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.
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: -------------------------------------------------------------------------
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.
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.
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.
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
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.
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:
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: