APPS.PO_VAL_LINES2 dependencies on MTL_CATEGORY_SETS_V

Line 1627: x_flag mtl_category_sets_v.validate_flag%TYPE;

1623: x_results IN OUT NOCOPY po_validation_results_type,
1624: x_result_type OUT NOCOPY VARCHAR2)
1625: IS
1626: d_mod CONSTANT VARCHAR2(100) := d_category_id;
1627: x_flag mtl_category_sets_v.validate_flag%TYPE;
1628: x_category_set_id mtl_category_sets_v.category_set_id%TYPE;
1629: BEGIN
1630: IF x_result_set_id IS NULL THEN
1631: x_result_set_id := po_validations.next_result_set_id();

Line 1628: x_category_set_id mtl_category_sets_v.category_set_id%TYPE;

1624: x_result_type OUT NOCOPY VARCHAR2)
1625: IS
1626: d_mod CONSTANT VARCHAR2(100) := d_category_id;
1627: x_flag mtl_category_sets_v.validate_flag%TYPE;
1628: x_category_set_id mtl_category_sets_v.category_set_id%TYPE;
1629: BEGIN
1630: IF x_result_set_id IS NULL THEN
1631: x_result_set_id := po_validations.next_result_set_id();
1632: END IF;

Line 1658: FROM mtl_category_sets_v

1654: SELECT validate_flag,
1655: category_set_id
1656: INTO x_flag,
1657: x_category_set_id
1658: FROM mtl_category_sets_v
1659: WHERE category_set_id = (SELECT category_set_id
1660: FROM mtl_default_category_sets
1661: WHERE functional_area_id = 2); /*** purchasing***/
1662: