[Home] [Help]
2292: FROM DUAL
2293: WHERE p_po_header_id_tbl(i) IS NOT NULL
2294: AND p_line_num_tbl(i) IS NOT NULL
2295: AND (EXISTS(SELECT 'Y'
2296: FROM po_lines_all pln
2297: WHERE pln.po_header_id = p_po_header_id_tbl(i)
2298: AND pln.line_num = p_line_num_tbl(i)
2299: AND NOT EXISTS (SELECT 'Y'
2300: FROM po_lines_draft_all PLD
3221: RAISE;
3222: END ip_category_id_update;
3223:
3224: -----------------------------------------------------------------------------
3225: -- We need to validate UOM against po_lines_all and po_units_of_measure_val_v
3226: -----------------------------------------------------------------------------
3227: PROCEDURE uom_update(
3228: p_id_tbl IN po_tbl_number,
3229: p_unit_meas_lookup_code_tbl IN po_tbl_varchar30,
3287: PO_VAL_CONSTANTS.c_uom_update_valid
3288: FROM DUAL
3289: WHERE EXISTS(
3290: SELECT 1
3291: FROM po_lines_all pol,
3292: po_units_of_measure_val_v pumv
3293: WHERE po_header_id = p_po_header_id_tbl(i) AND
3294: po_line_id = p_po_line_id_tbl(i) AND
3295: p_unit_meas_lookup_code_tbl(i) IS NOT NULL AND
3297: p_unit_meas_lookup_code_tbl(i)) AND
3298: pumv.unit_of_measure <> p_unit_meas_lookup_code_tbl(i))
3299: OR EXISTS(
3300: SELECT 1
3301: FROM po_lines_all pol,
3302: po_units_of_measure_val_v pumv
3303: WHERE p_order_type_lookup_code_tbl(i) NOT IN('RATE', 'FIXED PRICE') AND
3304: po_header_id = p_po_header_id_tbl(i) AND
3305: po_line_id = p_po_line_id_tbl(i) AND
3326:
3327: -------------------------------------------------------------------------
3328: -- Make sure that the item_description can be different from what is setup in the item master.
3329: -- Would not allow item_description update if item attribute allow_item_desc_update_flag is N.
3330: -- Also need to check the value in po_lines_all to make sure it is the same there, if necessary.
3331: -------------------------------------------------------------------------
3332: PROCEDURE item_desc_update(
3333: p_id_tbl IN po_tbl_number,
3334: p_item_description_tbl IN po_tbl_varchar2000,
3398: FROM DUAL
3399: WHERE EXISTS(
3400: SELECT 1
3401: FROM mtl_system_items msi,
3402: po_lines_all pol,
3403: mtl_system_items_tl mtl
3404: WHERE p_po_line_id_tbl(i) IS NOT NULL AND
3405: p_item_id_tbl(i) IS NOT NULL AND
3406: pol.po_header_id = nvl(p_po_header_id_tbl(i),pol.po_header_id) AND
3623: FROM DUAL
3624: WHERE p_category_id_tbl(i) IS NOT NULL
3625: AND (p_item_id_tbl(i) IS NOT NULL OR p_job_id_tbl(i) IS NOT NULL)
3626: AND (EXISTS(SELECT 1
3627: FROM po_lines_all pol
3628: WHERE p_po_line_id_tbl(i) = pol.po_line_id
3629: AND p_category_id_tbl(i) <> pol.category_id)
3630: OR EXISTS(SELECT 1
3631: FROM po_lines_draft_all pld
3739: 'PO_PDOI_SVC_NO_PRICE',
3740: 'UNIT_PRICE',
3741: p_unit_price_tbl(i),
3742: PO_VAL_CONSTANTS.c_unit_price_null
3743: FROM po_lines_all POL
3744: WHERE POL.po_line_id = p_po_line_id_tbl(i)
3745: AND POL.order_type_lookup_code = 'FIXED PRICE'
3746: AND p_unit_price_tbl(i) IS NOT NULL
3747: -- missin draft id
3791: p_unit_price_tbl(i),
3792: 'UNIT_PRICE',
3793: p_unit_price_tbl(i),
3794: PO_VAL_CONSTANTS.c_not_to_exceed_price_valid
3795: FROM po_lines_all POL
3796: WHERE POL.po_line_id = p_po_line_id_tbl(i)
3797: AND POL.not_to_exceed_price < p_unit_price_tbl(i);
3798:
3799: IF (SQL%ROWCOUNT > 0) THEN
3864: 'PO_PDOI_SVC_BLKT_NO_AMT',
3865: 'AMOUNT',
3866: p_amount_tbl(i),
3867: PO_VAL_CONSTANTS.c_amount_blanket
3868: FROM po_lines_all POL
3869: WHERE POL.po_line_id = p_po_line_id_tbl(i)
3870: AND POL.order_type_lookup_code <> 'FIXED PRICE'
3871: AND p_amount_tbl(i) IS NOT NULL
3872: -- missin draft id