[Home] [Help]
1370: IF (SQL%ROWCOUNT > 0) THEN
1371: x_result_type := po_validations.c_result_type_failure;
1372: END IF;
1373:
1374: -- check to see if x_uom_code is valid in po_units_of_measure_val_v
1375: FORALL i IN 1 .. p_id_tbl.COUNT
1376: INSERT INTO po_validation_results_gt
1377: (result_set_id,
1378: result_type,
1398: WHERE p_order_type_lookup_code_tbl(i) NOT IN('RATE', 'FIXED PRICE')
1399: AND p_item_id_tbl(i) IS NULL
1400: AND p_unit_meas_lookup_code_tbl(i) IS NOT NULL
1401: AND NOT EXISTS(SELECT 1
1402: FROM po_units_of_measure_val_v pumv
1403: WHERE pumv.unit_of_measure = p_unit_meas_lookup_code_tbl(i));
1404:
1405: IF (SQL%ROWCOUNT > 0) THEN
1406: x_result_type := po_validations.c_result_type_failure;
3282: RAISE;
3283: END ip_category_id_update;
3284:
3285: -----------------------------------------------------------------------------
3286: -- We need to validate UOM against po_lines_all and po_units_of_measure_val_v
3287: -----------------------------------------------------------------------------
3288: PROCEDURE uom_update(
3289: p_id_tbl IN po_tbl_number,
3290: p_unit_meas_lookup_code_tbl IN po_tbl_varchar30,
3358: p_unit_meas_lookup_code_tbl(i) IS NOT NULL AND
3359: p_unit_meas_lookup_code_tbl(i) <> NVL(pol.unit_meas_lookup_code,
3360: p_unit_meas_lookup_code_tbl(i)) AND
3361: p_unit_meas_lookup_code_tbl(i) NOT IN --- Bug#13936604
3362: (select unit_of_measure from po_units_of_measure_val_v))
3363: OR EXISTS(
3364: SELECT 1
3365: FROM po_lines_all pol
3366: WHERE p_order_type_lookup_code_tbl(i) NOT IN('RATE', 'FIXED PRICE') AND
3367: po_header_id = p_po_header_id_tbl(i) AND
3368: po_line_id = p_po_line_id_tbl(i) AND
3369: pol.unit_meas_lookup_code IS NULL AND
3370: p_unit_meas_lookup_code_tbl(i) NOT IN --- Bug#13936604
3371: (select unit_of_measure from po_units_of_measure_val_v));
3372:
3373: IF (SQL%ROWCOUNT > 0) THEN
3374: x_result_type := po_validations.c_result_type_failure;
3375: END IF;