827: AND A.CATEGORY_SET_ID = B.CATEGORY_SET_ID;
828: ELSE
829: SELECT ID_FLEX_NUM
830: INTO l_structure_id
831: FROM FND_ID_FLEX_STRUCTURES
832: WHERE APPLICATION_ID = (select application_id from fnd_application
833: where application_short_name =
834: x_application_short_name)
835: AND ID_FLEX_CODE = 'MCAT'
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
901: ,X_SEGMENT4 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
991: AND A.CATEGORY_SET_ID = B.CATEGORY_SET_ID;
992: ELSE
993: SELECT ID_FLEX_NUM
994: INTO l_structure_id
995: FROM FND_ID_FLEX_STRUCTURES
996: WHERE APPLICATION_ID = (select application_id from fnd_application
997: where application_short_name =
998: x_application_short_name)
999: AND ID_FLEX_CODE = 'MCAT'