APPS.QA_SPECS_PUB dependencies on MTL_CATEGORY_SETS

Line 469: x_validate_flag OUT NOCOPY mtl_category_sets.validate_flag%TYPE)

465:
466: FUNCTION get_category_set_id(
467: p_category_set_name IN VARCHAR2,
468: x_structure_id OUT NOCOPY NUMBER,
469: x_validate_flag OUT NOCOPY mtl_category_sets.validate_flag%TYPE)
470: RETURN NUMBER IS
471:
472: CURSOR c IS
473: SELECT category_set_id, structure_id, validate_flag

Line 474: FROM mtl_category_sets

470: RETURN NUMBER IS
471:
472: CURSOR c IS
473: SELECT category_set_id, structure_id, validate_flag
474: FROM mtl_category_sets
475: WHERE category_set_name = p_category_set_name;
476:
477: l_category_set_id NUMBER;
478:

Line 501: p_validate_flag mtl_category_sets.validate_flag%TYPE)

497: p_category_name IN VARCHAR2,
498: p_category_set_id IN NUMBER,
499: p_org_id IN NUMBER,
500: p_structure_id IN NUMBER,
501: p_validate_flag mtl_category_sets.validate_flag%TYPE)
502: RETURN NUMBER IS
503:
504: -- Bug 2532177. Removed the Default value for l_category_id variable.
505: l_category_id NUMBER;

Line 803: l_validate_flag mtl_category_sets.validate_flag%TYPE;

799: l_org_id NUMBER := -1;
800: l_category_set_id NUMBER := -1;
801: l_category_id NUMBER := -1;
802: l_structure_id NUMBER;
803: l_validate_flag mtl_category_sets.validate_flag%TYPE;
804: l_item_id NUMBER := -1;
805: l_vendor_id NUMBER := -1;
806: l_customer_id NUMBER := -1;
807: l_char_id NUMBER := -1;