APPS.AMS_MTL_CATG_LOADER_PVT dependencies on AMS_MTL_CATEGORIES_DENORM_TL

Line 51: cursor get_cat_tl is select count(*) from AMS_MTL_CATEGORIES_DENORM_TL;

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;
54:
55:

Line 78: delete from AMS_MTL_CATEGORIES_DENORM_TL;

74: CLOSE get_cat_tl;
75:
76: if (lcount > 1) then
77:
78: delete from AMS_MTL_CATEGORIES_DENORM_TL;
79:
80: end if;
81:
82:

Line 117: insert into AMS_MTL_CATEGORIES_DENORM_TL (

113: FND_GLOBAL.conc_login_id,
114: FND_FLEX_KEYVAL.concatenated_values
115: );
116:
117: insert into AMS_MTL_CATEGORIES_DENORM_TL (
118: CATEGORY_ID ,
119: LANGUAGE ,
120: SOURCE_LANG ,
121: LAST_UPDATE_DATE ,

Line 140: FROM AMS_MTL_CATEGORIES_DENORM_TL t

136: FND_FLEX_KEYVAL.concatenated_descriptions
137: FROM fnd_languages l
138: WHERE l.installed_flag IN ('I', 'B')
139: AND NOT EXISTS (SELECT NULL
140: FROM AMS_MTL_CATEGORIES_DENORM_TL t
141: WHERE t.category_id = c1_rec.category_id
142: AND t.language = l.language_code);
143:
144:

Line 171: delete from AMS_MTL_CATEGORIES_DENORM_TL T

167: --=============================================
168: procedure ADD_LANGUAGE
169: is
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

Line 178: update AMS_MTL_CATEGORIES_DENORM_TL T set (

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 (
179: CATEGORY_ID
180: ) = (select
181: B.CATEGORY_ID
182: from AMS_MTL_CATEGORIES_DENORM_TL B

Line 182: from AMS_MTL_CATEGORIES_DENORM_TL B

178: update AMS_MTL_CATEGORIES_DENORM_TL T set (
179: CATEGORY_ID
180: ) = (select
181: B.CATEGORY_ID
182: from AMS_MTL_CATEGORIES_DENORM_TL B
183: where B.CATEGORY_ID = T.CATEGORY_ID
184: and B.LANGUAGE = T.SOURCE_LANG)
185: where (
186: T.CATEGORY_ID,

Line 191: from AMS_MTL_CATEGORIES_DENORM_TL SUBB, AMS_MTL_CATEGORIES_DENORM_TL SUBT

187: T.LANGUAGE
188: ) in (select
189: SUBT.CATEGORY_ID,
190: SUBT.LANGUAGE
191: from AMS_MTL_CATEGORIES_DENORM_TL SUBB, AMS_MTL_CATEGORIES_DENORM_TL SUBT
192: where SUBB.CATEGORY_ID = SUBT.CATEGORY_ID
193: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
194: and (SUBB.CATEGORY_ID <> SUBT.CATEGORY_ID
195: ));

Line 198: INSERT INTO AMS_MTL_CATEGORIES_DENORM_TL (

194: and (SUBB.CATEGORY_ID <> SUBT.CATEGORY_ID
195: ));
196:
197:
198: INSERT INTO AMS_MTL_CATEGORIES_DENORM_TL (
199: CATEGORY_ID ,
200: LANGUAGE ,
201: SOURCE_LANG ,
202: LAST_UPDATE_DATE ,

Line 218: from AMS_MTL_CATEGORIES_DENORM_TL B, FND_LANGUAGES L

214: B.CREATION_DATE,
215: B.CREATED_BY,
216: B.LAST_UPDATE_LOGIN,
217: B.concatenated_description
218: from AMS_MTL_CATEGORIES_DENORM_TL B, FND_LANGUAGES L
219: where L.INSTALLED_FLAG in ('I', 'B')
220: and B.LANGUAGE = userenv('LANG')
221: and not exists
222: (select NULL

Line 223: from AMS_MTL_CATEGORIES_DENORM_TL T

219: where L.INSTALLED_FLAG in ('I', 'B')
220: and B.LANGUAGE = userenv('LANG')
221: and not exists
222: (select NULL
223: from AMS_MTL_CATEGORIES_DENORM_TL T
224: where T.CATEGORY_ID = B.CATEGORY_ID
225: and T.LANGUAGE = L.LANGUAGE_CODE);
226:
227: end ADD_LANGUAGE;