DBA Data[Home] [Help]

APPS.PO_VAL_LINES2 dependencies on PO_LINE_TYPES_VAL_V

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

2403: RAISE;
2404: END po_line_id;
2405:
2406: -------------------------------------------------------------------------
2407: -- Line type id must be populated and exist in po_line_types_val_v
2408: -------------------------------------------------------------------------
2409: PROCEDURE line_type_id(
2410: p_id_tbl IN po_tbl_number,
2411: p_line_type_id_tbl IN po_tbl_number,

Line 2458: FROM po_line_types_val_v pltv

2454: PO_VAL_CONSTANTS.c_line_type_id_valid)
2455: FROM DUAL
2456: WHERE p_line_type_id_tbl(i) IS NULL OR
2457: NOT EXISTS(SELECT 1
2458: FROM po_line_types_val_v pltv
2459: WHERE pltv.line_type_id = p_line_type_id_tbl(i));
2460:
2461: IF (SQL%ROWCOUNT > 0) THEN
2462: x_result_type := po_validations.c_result_type_failure;