[Home] [Help]
165: WHERE p_document_num_tbl(i) IS NOT NULL AND
166: EXISTS(SELECT 1
167: FROM po_headers
168: WHERE segment1 = p_document_num_tbl(i)
169: AND ((p_type_lookup_code_tbl(i) IN ('BLANKET', 'STANDARD')
170: AND
171: type_lookup_code IN ('BLANKET', 'CONTRACT',
172: 'PLANNED', 'STANDARD'))
173: OR
168: WHERE segment1 = p_document_num_tbl(i)
169: AND ((p_type_lookup_code_tbl(i) IN ('BLANKET', 'STANDARD')
170: AND
171: type_lookup_code IN ('BLANKET', 'CONTRACT',
172: 'PLANNED', 'STANDARD'))
173: OR
174: (p_type_lookup_code_tbl(i) = 'QUOTATION' AND
175: type_lookup_code = p_type_lookup_code_tbl(i))));
176:
191: p_token2_value => p_document_num_tbl(i),
192: p_validation_id => PO_VAL_CONSTANTS.c_document_num_not_null);
193:
194: x_result_type := po_validations.c_result_type_failure; -- bug5101044
195: ELSIF ((p_type_lookup_code_tbl(i) IN ('BLANKET', 'STANDARD')
196: AND p_manual_po_num_type = 'NUMERIC')
197: OR
198: (p_type_lookup_code_tbl(i) = 'QUOTATION'
199: AND p_manual_quote_num_type = 'NUMERIC')) THEN
254: END document_num;
255:
256: -------------------------------------------------------------------------
257: -- type_lookup_code cannot be null and must be equal to
258: -- BLANKET, STANDARD or QUOTATION.
259: -------------------------------------------------------------------------
260: PROCEDURE type_lookup_code(
261: p_id_tbl IN po_tbl_number,
262: p_type_lookup_code_tbl IN po_tbl_varchar30,
289: p_token2_name => 'VALUE',
290: p_token2_value => p_type_lookup_code_tbl(i),
291: p_validation_id => PO_VAL_CONSTANTS.c_type_lookup_code_not_null);
292: x_result_type := po_validations.c_result_type_failure;
293: ELSIF p_type_lookup_code_tbl(i) NOT IN('BLANKET', 'STANDARD', 'QUOTATION') THEN
294: x_results.add_result(p_entity_type => c_entity_type_header,
295: p_entity_id => p_id_tbl(i),
296: p_column_name => 'TYPE_LOOKUP_CODE',
297: p_column_val => p_type_lookup_code_tbl(i),