[Home] [Help]
12: , p_entity_id_tbl IN PO_TBL_NUMBER
13: , p_entity_type IN VARCHAR2
14: , p_column_name IN VARCHAR2
15: , p_message_name IN VARCHAR2 DEFAULT NULL
16: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
17: , x_result_type OUT NOCOPY VARCHAR2
18: );
19:
20: PROCEDURE greater_or_equal_zero(
29: p_token1_value IN VARCHAR2 DEFAULT NULL,
30: p_token2_name IN VARCHAR2 DEFAULT NULL,
31: p_token2_value_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,
32: p_validation_id IN NUMBER DEFAULT NULL,
33: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
34: x_result_type OUT NOCOPY VARCHAR2);
35:
36: PROCEDURE within_percentage_range(
37: p_calling_module IN VARCHAR2
42: , p_column_name IN VARCHAR2
43: , p_message_name IN VARCHAR2 DEFAULT NULL
44: , p_token1_name IN VARCHAR2 DEFAULT NULL
45: , p_token1_value_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL
46: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
47: , x_result_type OUT NOCOPY VARCHAR2
48: );
49:
50: PROCEDURE open_period(
72: p_token1_value IN VARCHAR2 DEFAULT NULL,
73: p_token2_name IN VARCHAR2 DEFAULT NULL,
74: p_token2_value_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,
75: p_validation_id IN NUMBER DEFAULT NULL,
76: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
77: x_result_type OUT NOCOPY VARCHAR2);
78:
79: PROCEDURE ensure_null(p_calling_module IN VARCHAR2,
80: p_value_tbl IN PO_TBL_VARCHAR4000,
86: p_token1_value IN VARCHAR2 DEFAULT NULL,
87: p_token2_name IN VARCHAR2 DEFAULT NULL,
88: p_token2_value_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,
89: p_validation_id IN NUMBER DEFAULT NULL,
90: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
91: x_result_type OUT NOCOPY VARCHAR2);
92:
93: PROCEDURE flag_value_Y_N(p_calling_module IN VARCHAR2,
94: p_flag_value_tbl IN PO_TBL_VARCHAR1,
100: p_token1_value IN VARCHAR2 DEFAULT NULL,
101: p_token2_name IN VARCHAR2 DEFAULT NULL,
102: p_token2_value_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,
103: p_validation_id IN NUMBER DEFAULT NULL,
104: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
105: x_result_type OUT NOCOPY VARCHAR2);
106:
107: PROCEDURE gt_zero_order_type_filter(
108: p_calling_module IN VARCHAR2
113: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
114: , p_check_quantity_types_flag IN VARCHAR2
115: , p_entity_type IN VARCHAR2
116: , p_column_name IN VARCHAR2
117: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
118: , x_result_type OUT NOCOPY VARCHAR2
119: , p_header_id_tbl IN PO_TBL_NUMBER --
120: );
121:
126: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
127: , p_check_quantity_types_flag IN VARCHAR2
128: , p_entity_type IN VARCHAR2
129: , p_column_name IN VARCHAR2
130: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
131: , x_result_type OUT NOCOPY VARCHAR2
132: );
133:
134:
138: , p_start_date_tbl IN PO_TBL_DATE DEFAULT NULL
139: , p_expiration_date_tbl IN PO_TBL_DATE DEFAULT NULL
140: , p_column_name IN VARCHAR2
141: , p_message_name IN VARCHAR2
142: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
143: , x_result_type OUT NOCOPY VARCHAR2
144: );
145:
146: PROCEDURE amount_notif_ctrl_warning(
187: , p_column_name IN VARCHAR2
188: , p_column_val_selector IN VARCHAR2
189: , p_message_name IN VARCHAR2
190: , p_validation_id IN NUMBER DEFAULT NULL
191: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
192: , x_result_type OUT NOCOPY VARCHAR2
193: );
194:
195: PROCEDURE num1_less_or_equal_num2(
199: , p_entity_id_tbl IN PO_TBL_NUMBER
200: , p_entity_type IN VARCHAR2
201: , p_column_name IN VARCHAR2
202: , p_message_name IN VARCHAR2
203: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
204: , x_result_type OUT NOCOPY VARCHAR2
205: );
206:
207: PROCEDURE zero(p_calling_module IN VARCHAR2,
214: p_token1_value IN VARCHAR2 DEFAULT NULL,
215: p_token2_name IN VARCHAR2 DEFAULT NULL,
216: p_token2_value_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL,
217: p_validation_id IN NUMBER DEFAULT NULL,
218: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
219: x_result_type OUT NOCOPY VARCHAR2);
220:
221: PROCEDURE terms_id(p_calling_module IN VARCHAR2,
222: p_terms_id_tbl IN PO_TBL_NUMBER,
233: , p_item_id_tbl IN PO_TBL_NUMBER
234: , p_inv_org_id_tbl IN PO_TBL_NUMBER
235: , p_entity_type IN VARCHAR2
236: , p_column_name IN VARCHAR2
237: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
238: , x_result_type OUT NOCOPY VARCHAR2
239: );
240:
241: PROCEDURE qtys_within_deviation(
247: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
248: , p_sec_quantity_tbl IN PO_TBL_NUMBER
249: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
250: , p_column_name IN VARCHAR2
251: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
252: , x_result_type OUT NOCOPY VARCHAR2
253: );
254:
255: PROCEDURE secondary_unit_of_measure(
260: p_item_tbl IN po_tbl_varchar2000,
261: p_organization_id_tbl IN po_tbl_number,
262: p_doc_type IN VARCHAR2,
263: p_create_or_update_item_flag IN VARCHAR2,
264: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
265: x_result_type OUT NOCOPY VARCHAR2);
266:
267: PROCEDURE secondary_quantity(
268: p_id_tbl IN po_tbl_number,
273: p_item_tbl IN po_tbl_varchar2000,
274: p_organization_id_tbl IN po_tbl_number,
275: p_doc_type IN VARCHAR2,
276: p_create_or_update_item_flag IN VARCHAR2,
277: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
278: x_result_type OUT NOCOPY VARCHAR2);
279:
280: PROCEDURE secondary_uom_update(
281: p_id_tbl IN po_tbl_number,
295: p_item_tbl IN po_tbl_varchar2000,
296: p_organization_id_tbl IN po_tbl_number,
297: p_create_or_update_item_flag IN VARCHAR2,
298: p_validation_id IN NUMBER DEFAULT NULL,
299: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
300: x_result_set_id IN OUT NOCOPY NUMBER,
301: x_result_type OUT NOCOPY VARCHAR2);
302:
303: PROCEDURE process_enabled(
318: , p_entity_type IN VARCHAR2
319: , p_column_name IN VARCHAR2
320: , p_message_name IN VARCHAR2
321: , p_validation_id IN NUMBER DEFAULT NULL
322: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
323: , x_result_type OUT NOCOPY VARCHAR2
324: );
325: --UCA Project - CLMR4 Changes End
326: