DBA Data[Home] [Help]

APPS.PO_VAL_LINES2 dependencies on MTL_CATEGORY_SETS_V

Line 1618: x_flag mtl_category_sets_v.validate_flag%TYPE;

1614: x_results IN OUT NOCOPY po_validation_results_type,
1615: x_result_type OUT NOCOPY VARCHAR2)
1616: IS
1617: d_mod CONSTANT VARCHAR2(100) := d_category_id;
1618: x_flag mtl_category_sets_v.validate_flag%TYPE;
1619: x_category_set_id mtl_category_sets_v.category_set_id%TYPE;
1620: BEGIN
1621: IF x_result_set_id IS NULL THEN
1622: x_result_set_id := po_validations.next_result_set_id();

Line 1619: x_category_set_id mtl_category_sets_v.category_set_id%TYPE;

1615: x_result_type OUT NOCOPY VARCHAR2)
1616: IS
1617: d_mod CONSTANT VARCHAR2(100) := d_category_id;
1618: x_flag mtl_category_sets_v.validate_flag%TYPE;
1619: x_category_set_id mtl_category_sets_v.category_set_id%TYPE;
1620: BEGIN
1621: IF x_result_set_id IS NULL THEN
1622: x_result_set_id := po_validations.next_result_set_id();
1623: END IF;

Line 1649: FROM mtl_category_sets_v

1645: SELECT validate_flag,
1646: category_set_id
1647: INTO x_flag,
1648: x_category_set_id
1649: FROM mtl_category_sets_v
1650: WHERE category_set_id = (SELECT category_set_id
1651: FROM mtl_default_category_sets
1652: WHERE functional_area_id = 2); /*** purchasing***/
1653: