DBA Data[Home] [Help]

APPS.PO_VAL_LINES2 dependencies on PO_LINE_TYPES_VAL_V

Line 2468: -- Line type id must be populated and exist in po_line_types_val_v

2464: RAISE;
2465: END po_line_id;
2466:
2467: -------------------------------------------------------------------------
2468: -- Line type id must be populated and exist in po_line_types_val_v
2469: -------------------------------------------------------------------------
2470: PROCEDURE line_type_id(
2471: p_id_tbl IN po_tbl_number,
2472: p_line_type_id_tbl IN po_tbl_number,

Line 2519: FROM po_line_types_val_v pltv

2515: PO_VAL_CONSTANTS.c_line_type_id_valid)
2516: FROM DUAL
2517: WHERE p_line_type_id_tbl(i) IS NULL OR
2518: NOT EXISTS(SELECT 1
2519: FROM po_line_types_val_v pltv
2520: WHERE pltv.line_type_id = p_line_type_id_tbl(i));
2521:
2522: IF (SQL%ROWCOUNT > 0) THEN
2523: x_result_type := po_validations.c_result_type_failure;