APPS.AMS_MTL_CATG_LOADER_PVT dependencies on AMS_MTL_CATEGORIES_DENORM_B

Line 49: cursor get_cat_b is select count(*) from AMS_MTL_CATEGORIES_DENORM_B;

45: where installed_flag in ('I','B');
46: l_language VARCHAR2(20); ****/
47:
48:
49: cursor get_cat_b is select count(*) from AMS_MTL_CATEGORIES_DENORM_B;
50:
51: cursor get_cat_tl is select count(*) from AMS_MTL_CATEGORIES_DENORM_TL;
52:
53: lcount NUMBER;

Line 68: delete from AMS_MTL_CATEGORIES_DENORM_B;

64: CLOSE get_cat_b;
65:
66: if (lcount > 1) then
67:
68: delete from AMS_MTL_CATEGORIES_DENORM_B;
69:
70: end if;
71:
72: OPEN get_cat_tl;

Line 97: INSERT INTO AMS_MTL_CATEGORIES_DENORM_B (

93: combination_id => c1_rec.category_id);
94: if (valid_ccid) then
95:
96:
97: INSERT INTO AMS_MTL_CATEGORIES_DENORM_B (
98: CATEGORY_ID ,
99: STRUCTURE_ID ,
100: LAST_UPDATE_DATE ,
101: LAST_UPDATED_BY ,

Line 174: from AMS_MTL_CATEGORIES_DENORM_B B

170: begin
171: delete from AMS_MTL_CATEGORIES_DENORM_TL T
172: where not exists
173: (select NULL
174: from AMS_MTL_CATEGORIES_DENORM_B B
175: where B.CATEGORY_ID = T.CATEGORY_ID
176: );
177:
178: update AMS_MTL_CATEGORIES_DENORM_TL T set (