DBA Data[Home] [Help]

APPS.MTL_CATEGORIES_PKG dependencies on MTL_CATEGORIES_KFV

Line 856: FROM mtl_categories_kfv

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

Line 896: x_CATEGORY_NAME IN MTL_CATEGORIES_KFV.CONCATENATED_SEGMENTS%TYPE

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