APPS.AS_CATALOG_MIGRATION dependencies on MTL_CATEGORIES_B

Line 723: a) MTL_CATEGORIES_B

719:
720: /*
721: This procedure creates new MTL categories corresponding to the interest type/code passed in.
722: It creates/updates records in following MTL tables:
723: a) MTL_CATEGORIES_B
724: b) MTL_CATEGORIES_TL
725: c) MTL_CATEGORY_SET_VALID_CATS
726: d) MTL_ITEM_CATEGORIES
727: */

Line 755: FROM MTL_CATEGORIES_B MC

751: select MIC.INVENTORY_ITEM_ID,
752: MIC.ORGANIZATION_ID
753: from
754: ( SELECT CATEGORY_ID
755: FROM MTL_CATEGORIES_B MC
756: WHERE MC.STRUCTURE_ID = c_structure_id
757: and DECODE(c_interest_level,0,MC.SEGMENT1,1,MC.SEGMENT2,2,MC.SEGMENT3,NULL) = c_type_code_id
758: and DECODE(c_interest_level,0,MC.SEGMENT2,1,MC.SEGMENT3,NULL) IS NULL
759: and DECODE(c_interest_level,0,MC.SEGMENT3,NULL) IS NULL

Line 839: -- Create Records in MTL_CATEGORIES_B and MTL_CATEGORIES_TL

835: -- Initialize API return status to success
836: x_return_status := FND_API.G_RET_STS_SUCCESS;
837: l_return_status := FND_API.G_RET_STS_SUCCESS;
838:
839: -- Create Records in MTL_CATEGORIES_B and MTL_CATEGORIES_TL
840: l_category_rec.segment1 := l_category_name;
841: l_category_rec.structure_id := p_structure_id;
842: l_category_rec.description := p_category_name; -- This is the original non-truncated name
843:

Line 954: -- Create Legacy Records in MTL_CATEGORIES_B and MTL_CATEGORIES_TL

950: IF l_create_legacy = 'Y' THEN
951: BEGIN
952:
953:
954: -- Create Legacy Records in MTL_CATEGORIES_B and MTL_CATEGORIES_TL
955: l_category_rec.segment1 := l_legacy_category_name;
956: l_category_rec.structure_id := p_structure_id;
957: l_category_rec.description := p_category_name || ' LEGACY';
958:

Line 1154: FROM mtl_categories_b

1150:
1151: CURSOR category_exists_csr (p_category_id NUMBER)
1152: IS
1153: SELECT 'x'
1154: FROM mtl_categories_b
1155: WHERE category_id = p_category_id
1156: AND NVL(DISABLE_DATE,SYSDATE+1) > SYSDATE;
1157:
1158: BEGIN

Line 1300: Given a category name, find the category id by looking into MTL_CATEGORIES_B table

1296: end loop;
1297: END Check_Duplicate_Category;
1298:
1299: /*
1300: Given a category name, find the category id by looking into MTL_CATEGORIES_B table
1301: */
1302: PROCEDURE Find_Duplicate_Category_Id(
1303: p_structure_id IN NUMBER,
1304: p_category_name IN VARCHAR2,

Line 1312: from MTL_CATEGORIES_B

1308: l_category_id NUMBER;
1309:
1310: CURSOR C_Get_Category_Id(c_structure_id Number, c_category_name VARCHAR2) IS
1311: select category_id
1312: from MTL_CATEGORIES_B
1313: where structure_id = c_structure_id
1314: and segment1 = c_category_name
1315: and segment2 is null
1316: and segment3 is null

Line 1354: select B.category_id, B.segment1 category_name from mtl_category_set_valid_cats V, mtl_categories_b B

1350: PROCEDURE Cleanup_Legacy_Categories(p_category_set_id IN NUMBER,
1351: p_category_id IN NUMBER) IS
1352:
1353: CURSOR C_Get_Legacy_Category_Id(c_category_set_id NUMBER, c_category_id NUMBER) IS
1354: select B.category_id, B.segment1 category_name from mtl_category_set_valid_cats V, mtl_categories_b B
1355: where V.category_set_id=c_category_set_id
1356: and V.parent_category_id=c_category_id
1357: and V.category_id = B.category_id;
1358: --and B.segment1 like '%LEGACY';

Line 1374: delete from mtl_categories_b where category_id=scr.category_id;

1370: delete from ego_product_cat_set_ext
1371: where category_id=scr.category_id and category_set_id=p_category_set_id;
1372: delete from mtl_category_set_valid_cats
1373: where category_id=scr.category_id and category_set_id=p_category_set_id;
1374: delete from mtl_categories_b where category_id=scr.category_id;
1375: delete from mtl_categories_tl where category_id=scr.category_id;
1376: END LOOP;
1377:
1378: END Cleanup_Legacy_Categories;

Line 1383: (select category_id from mtl_categories_b where structure_id in

1379:
1380:
1381: /* For testing purposes we can use the following statements.
1382: delete from mtl_categories_tl where category_id in
1383: (select category_id from mtl_categories_b where structure_id in
1384: (select structure_id from mtl_category_sets where category_set_name='SME Product Catalog'));
1385: delete from mtl_categories_b where structure_id in
1386: (select structure_id from mtl_category_sets where category_set_name='SME Product Catalog');
1387: delete from mtl_category_set_valid_cats where category_set_id in

Line 1385: delete from mtl_categories_b where structure_id in

1381: /* For testing purposes we can use the following statements.
1382: delete from mtl_categories_tl where category_id in
1383: (select category_id from mtl_categories_b where structure_id in
1384: (select structure_id from mtl_category_sets where category_set_name='SME Product Catalog'));
1385: delete from mtl_categories_b where structure_id in
1386: (select structure_id from mtl_category_sets where category_set_name='SME Product Catalog');
1387: delete from mtl_category_set_valid_cats where category_set_id in
1388: (select category_set_id from mtl_category_sets where category_set_name='SME Product Catalog');
1389: delete from mtl_item_categories where category_set_id in