APPS.MTL_CATEGORIES_PKG dependencies on MTL_CATEGORY_SETS_B

Line 825: MTL_CATEGORY_SETS_B B

821: IF x_upload_to_functional_area <> '-1' THEN
822: SELECT B.STRUCTURE_ID
823: INTO l_structure_id
824: FROM MTL_DEFAULT_CATEGORY_SETS A,
825: MTL_CATEGORY_SETS_B B
826: WHERE FUNCTIONAL_AREA_ID = (select lookup_code from mfg_lookups
827: where lookup_type = 'MTL_FUNCTIONAL_AREAS' and upper(meaning) = upper(x_upload_to_functional_area))
828: AND A.CATEGORY_SET_ID = B.CATEGORY_SET_ID;
829: ELSE

Line 924: ,X_CATEGORY_SET_ID IN MTL_CATEGORY_SETS_B.CATEGORY_SET_ID%TYPE

920: ,X_ENABLED_FLAG IN MTL_CATEGORIES_B.ENABLED_FLAG%TYPE
921: ,X_START_DATE_ACTIVE IN MTL_CATEGORIES_B.START_DATE_ACTIVE%TYPE
922: ,X_END_DATE_ACTIVE IN MTL_CATEGORIES_B.END_DATE_ACTIVE%TYPE
923: ,X_DISABLE_DATE IN MTL_CATEGORIES_B.DISABLE_DATE%TYPE
924: ,X_CATEGORY_SET_ID IN MTL_CATEGORY_SETS_B.CATEGORY_SET_ID%TYPE
925: ,X_CATEGORY_SET_NAME IN MTL_CATEGORY_SETS_TL.CATEGORY_SET_NAME%TYPE
926: ,X_OWNER IN VARCHAR2
927: ,X_LAST_UPDATE_DATE IN MTL_CATEGORIES_B.LAST_UPDATE_DATE%TYPE
928: ,X_DESCRIPTION IN MTL_CATEGORIES_TL.DESCRIPTION%TYPE

Line 933: l_category_set_id MTL_CATEGORY_SETS_B.CATEGORY_SET_ID%TYPE;

929: ,X_APPLICATION_SHORT_NAME IN VARCHAR2
930: ,X_UPLOAD_TO_FUNCTIONAL_AREA IN VARCHAR2
931: ) IS
932:
933: l_category_set_id MTL_CATEGORY_SETS_B.CATEGORY_SET_ID%TYPE;
934: l_structure_id MTL_CATEGORY_SETS_B.STRUCTURE_ID%TYPE;
935: l_category_id MTL_CATEGORIES_B.CATEGORY_ID%TYPE;
936: l_category_rec INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE;
937: l_new_catg_id NUMBER;

Line 934: l_structure_id MTL_CATEGORY_SETS_B.STRUCTURE_ID%TYPE;

930: ,X_UPLOAD_TO_FUNCTIONAL_AREA IN VARCHAR2
931: ) IS
932:
933: l_category_set_id MTL_CATEGORY_SETS_B.CATEGORY_SET_ID%TYPE;
934: l_structure_id MTL_CATEGORY_SETS_B.STRUCTURE_ID%TYPE;
935: l_category_id MTL_CATEGORIES_B.CATEGORY_ID%TYPE;
936: l_category_rec INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE;
937: l_new_catg_id NUMBER;
938: l_category_set_name MTL_CATEGORY_SETS_TL.CATEGORY_SET_NAME%TYPE := X_CATEGORY_SET_NAME ;

Line 988: MTL_CATEGORY_SETS B

984: IF x_upload_to_functional_area <> '-1' THEN
985: SELECT A.CATEGORY_SET_ID, B.STRUCTURE_ID
986: INTO l_category_set_id, l_structure_id
987: FROM MTL_DEFAULT_CATEGORY_SETS A,
988: MTL_CATEGORY_SETS B
989: WHERE FUNCTIONAL_AREA_ID = (select lookup_code from mfg_lookups
990: where lookup_type = 'MTL_FUNCTIONAL_AREAS'
991: and upper(meaning) = upper(x_upload_to_functional_area))
992: AND A.CATEGORY_SET_ID = B.CATEGORY_SET_ID;