APPS.MTL_CATEGORIES_PKG dependencies on MTL_CATEGORY_SETS_B

Line 824: MTL_CATEGORY_SETS_B B

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

Line 923: ,X_CATEGORY_SET_ID IN MTL_CATEGORY_SETS_B.CATEGORY_SET_ID%TYPE

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

Line 932: l_category_set_id MTL_CATEGORY_SETS_B.CATEGORY_SET_ID%TYPE;

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

Line 933: l_structure_id MTL_CATEGORY_SETS_B.STRUCTURE_ID%TYPE;

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

Line 987: MTL_CATEGORY_SETS B

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