DBA Data[Home] [Help]

APPS.MTL_CATEGORIES_PKG dependencies on MTL_CATEGORIES_KFV

Line 857: FROM mtl_categories_kfv

853: -- find out the category_id based on the structure_id and the concat segments
854: BEGIN
855: SELECT category_id
856: INTO l_category_id
857: FROM mtl_categories_kfv
858: WHERE structure_id = l_structure_id
859: AND concatenated_segments = x_category_name;
860: EXCEPTION
861: WHEN NO_DATA_FOUND THEN

Line 897: x_CATEGORY_NAME IN MTL_CATEGORIES_KFV.CONCATENATED_SEGMENTS%TYPE

893: -- ----------------------------------------------------------------------
894:
895: PROCEDURE Load_Row
896: (
897: x_CATEGORY_NAME IN MTL_CATEGORIES_KFV.CONCATENATED_SEGMENTS%TYPE
898: ,x_STRUCTURE_CODE IN FND_ID_FLEX_STRUCTURES.ID_FLEX_STRUCTURE_CODE%TYPE --BUG 6975120
899: ,X_SEGMENT1 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
900: ,X_SEGMENT2 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
901: ,X_SEGMENT3 IN MTL_CATEGORIES_B.SEGMENT1%TYPE