APPS.AS_CATALOG_MIGRATION dependencies on MTL_CATEGORIES_TL

Line 724: b) MTL_CATEGORIES_TL

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: */
728: PROCEDURE Process_Categories(p_int_typ_cod_id IN NUMBER,

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 1375: delete from mtl_categories_tl where category_id=scr.category_id;

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;
1379:

Line 1382: delete from mtl_categories_tl where category_id in

1378: END Cleanup_Legacy_Categories;
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');