[Home] [Help]
172: OR
173: EXISTS(SELECT 1
174: FROM po_headers
175: WHERE segment1 = p_document_num_tbl(i)
176: AND ((p_type_lookup_code_tbl(i) IN ('BLANKET', 'STANDARD')
177: AND
178: type_lookup_code IN ('BLANKET', 'CONTRACT',
179: 'PLANNED', 'STANDARD'))
180: OR
175: WHERE segment1 = p_document_num_tbl(i)
176: AND ((p_type_lookup_code_tbl(i) IN ('BLANKET', 'STANDARD')
177: AND
178: type_lookup_code IN ('BLANKET', 'CONTRACT',
179: 'PLANNED', 'STANDARD'))
180: OR
181: (p_type_lookup_code_tbl(i) = 'QUOTATION' AND
182: type_lookup_code = p_type_lookup_code_tbl(i)))));
183:
198: p_token2_value => p_document_num_tbl(i),
199: p_validation_id => PO_VAL_CONSTANTS.c_document_num_not_null);
200:
201: x_result_type := po_validations.c_result_type_failure; -- bug5101044
202: ELSIF ((p_type_lookup_code_tbl(i) IN ('BLANKET', 'STANDARD')
203: AND p_manual_po_num_type = 'NUMERIC')
204: OR
205: (p_type_lookup_code_tbl(i) = 'QUOTATION'
206: AND p_manual_quote_num_type = 'NUMERIC')) THEN
261: END document_num;
262:
263: -------------------------------------------------------------------------
264: -- type_lookup_code cannot be null and must be equal to
265: -- BLANKET, STANDARD or QUOTATION.
266: -------------------------------------------------------------------------
267: PROCEDURE type_lookup_code(
268: p_id_tbl IN po_tbl_number,
269: p_type_lookup_code_tbl IN po_tbl_varchar30,
296: p_token2_name => 'VALUE',
297: p_token2_value => p_type_lookup_code_tbl(i),
298: p_validation_id => PO_VAL_CONSTANTS.c_type_lookup_code_not_null);
299: x_result_type := po_validations.c_result_type_failure;
300: ELSIF p_type_lookup_code_tbl(i) NOT IN('BLANKET', 'STANDARD', 'QUOTATION') THEN
301: x_results.add_result(p_entity_type => c_entity_type_header,
302: p_entity_id => p_id_tbl(i),
303: p_column_name => 'TYPE_LOOKUP_CODE',
304: p_column_val => p_type_lookup_code_tbl(i),