eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_CATALOG_MIGRATION dependencies on MTL_CATEGORY_SET_VALID_CATS

Line 725: c) MTL_CATEGORY_SET_VALID_CATS

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,
729: p_structure_id IN NUMBER,

Line 766: from MTL_CATEGORY_SET_VALID_CATS

762: where MIC.CATEGORY_ID = MC1.CATEGORY_ID;
763:
764: CURSOR C_Valid_Cat_Exists(c_category_set_id Number, c_category_id Number) IS
765: select 1
766: from MTL_CATEGORY_SET_VALID_CATS
767: where
768: category_id = c_category_id
769: and category_set_id = c_category_set_id;
770:

Line 889: -- already exists in MTL_CATEGORY_SET_VALID_CATS. If such a record exists then skip

885: END IF;
886:
887: l_skip_valid_cat := 'N';
888: -- If a duplicate category was found, there is a chance that a record for this category
889: -- already exists in MTL_CATEGORY_SET_VALID_CATS. If such a record exists then skip
890: -- creating a new record in MTL_CATEGORY_SET_VALID_CATS table
891: IF (l_dup_category_id is not null) THEN
892: OPEN C_Valid_Cat_Exists(p_category_set_id, l_dup_category_id);
893: FETCH C_Valid_Cat_Exists INTO l_val;

Line 890: -- creating a new record in MTL_CATEGORY_SET_VALID_CATS table

886:
887: l_skip_valid_cat := 'N';
888: -- If a duplicate category was found, there is a chance that a record for this category
889: -- already exists in MTL_CATEGORY_SET_VALID_CATS. If such a record exists then skip
890: -- creating a new record in MTL_CATEGORY_SET_VALID_CATS table
891: IF (l_dup_category_id is not null) THEN
892: OPEN C_Valid_Cat_Exists(p_category_set_id, l_dup_category_id);
893: FETCH C_Valid_Cat_Exists INTO l_val;
894: IF (C_Valid_Cat_Exists%FOUND) THEN

Line 902: -- Create Record in MTL_CATEGORY_SET_VALID_CATS

898: CLOSE C_Valid_Cat_Exists;
899: END IF;
900:
901: IF (l_skip_valid_cat = 'N') THEN
902: -- Create Record in MTL_CATEGORY_SET_VALID_CATS
903: INV_ITEM_CATEGORY_PUB.Create_Valid_Category (
904: p_api_version => G_CREATE_CAT_API_VER,
905: p_init_msg_list => FND_API.G_FALSE,
906: p_commit => FND_API.G_FALSE,

Line 1000: -- already exists in MTL_CATEGORY_SET_VALID_CATS. If such a record exists then skip

996: END IF;
997:
998: l_skip_valid_cat := 'N';
999: -- If a duplicate category was found, there is a chance that a record for this category
1000: -- already exists in MTL_CATEGORY_SET_VALID_CATS. If such a record exists then skip
1001: -- creating a new record in MTL_CATEGORY_SET_VALID_CATS table
1002: IF (l_dup_legacy_category_id is not null) THEN
1003: OPEN C_Valid_Cat_Exists(p_category_set_id, l_dup_legacy_category_id);
1004: FETCH C_Valid_Cat_Exists INTO l_val;

Line 1001: -- creating a new record in MTL_CATEGORY_SET_VALID_CATS table

997:
998: l_skip_valid_cat := 'N';
999: -- If a duplicate category was found, there is a chance that a record for this category
1000: -- already exists in MTL_CATEGORY_SET_VALID_CATS. If such a record exists then skip
1001: -- creating a new record in MTL_CATEGORY_SET_VALID_CATS table
1002: IF (l_dup_legacy_category_id is not null) THEN
1003: OPEN C_Valid_Cat_Exists(p_category_set_id, l_dup_legacy_category_id);
1004: FETCH C_Valid_Cat_Exists INTO l_val;
1005: IF (C_Valid_Cat_Exists%FOUND) THEN

Line 1013: -- Create Legacy Records in MTL_CATEGORY_SET_VALID_CATS

1009: CLOSE C_Valid_Cat_Exists;
1010: END IF;
1011:
1012: IF (l_skip_valid_cat = 'N') THEN
1013: -- Create Legacy Records in MTL_CATEGORY_SET_VALID_CATS
1014: INV_ITEM_CATEGORY_PUB.Create_Valid_Category (
1015: p_api_version => G_CREATE_CAT_API_VER,
1016: p_init_msg_list => FND_API.G_FALSE,
1017: p_commit => FND_API.G_FALSE,

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 1372: delete from mtl_category_set_valid_cats

1368: where category_id=scr.category_id
1369: and category_set_id=p_category_set_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;

Line 1387: delete from mtl_category_set_valid_cats where category_set_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
1390: (select category_set_id from mtl_category_sets where category_set_name='SME Product Catalog');
1391: delete from EGO_PRODUCT_CAT_SET_EXT where category_set_id in