APPS.MTL_CATEGORY_SETS_PKG dependencies on MTL_CATEGORY_SETS_TL

Line 73: insert into MTL_CATEGORY_SETS_TL (

69: X_LAST_UPDATE_LOGIN
70: -- X_REQUEST_ID,
71: );
72:
73: insert into MTL_CATEGORY_SETS_TL (
74: CATEGORY_SET_ID,
75: LANGUAGE,
76: SOURCE_LANG,
77: CATEGORY_SET_NAME,

Line 99: from MTL_CATEGORY_SETS_TL T

95: from FND_LANGUAGES L
96: where L.INSTALLED_FLAG in ('I', 'B')
97: and not exists
98: ( select NULL
99: from MTL_CATEGORY_SETS_TL T
100: where T.CATEGORY_SET_ID = X_CATEGORY_SET_ID
101: and T.LANGUAGE = L.LANGUAGE_CODE );
102:
103: open c;

Line 148: from MTL_CATEGORY_SETS_TL

144: select
145: CATEGORY_SET_NAME,
146: DESCRIPTION,
147: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
148: from MTL_CATEGORY_SETS_TL
149: where CATEGORY_SET_ID = X_CATEGORY_SET_ID
150: -- Commented out. All translation rows need to be locked.
151: -- and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
152: for update of CATEGORY_SET_ID nowait ;

Line 243: update MTL_CATEGORY_SETS_TL set

239: if (sql%notfound) then
240: raise no_data_found;
241: end if;
242:
243: update MTL_CATEGORY_SETS_TL set
244: SOURCE_LANG = userenv('LANG'),
245: CATEGORY_SET_NAME = DECODE(X_CATEGORY_SET_NAME,l_miss_char,CATEGORY_SET_NAME,X_CATEGORY_SET_NAME),
246: DESCRIPTION = DECODE(X_DESCRIPTION,l_miss_char,DESCRIPTION,X_DESCRIPTION),
247: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 273: delete from MTL_CATEGORY_SETS_TL

269:
270: -- This code is for future use when decided to validate
271: -- and delete category sets.
272: /*
273: delete from MTL_CATEGORY_SETS_TL
274: where CATEGORY_SET_ID = X_CATEGORY_SET_ID;
275:
276: if (sql%notfound) then
277: raise no_data_found;

Line 299: delete from MTL_CATEGORY_SETS_TL T

295: procedure ADD_LANGUAGE
296: is
297: begin
298:
299: delete from MTL_CATEGORY_SETS_TL T
300: where not exists
301: ( select NULL
302: from MTL_CATEGORY_SETS_B B
303: where B.CATEGORY_SET_ID = T.CATEGORY_SET_ID

Line 306: update MTL_CATEGORY_SETS_TL T set (

302: from MTL_CATEGORY_SETS_B B
303: where B.CATEGORY_SET_ID = T.CATEGORY_SET_ID
304: );
305:
306: update MTL_CATEGORY_SETS_TL T set (
307: CATEGORY_SET_NAME,
308: DESCRIPTION
309: ) = ( select
310: B.CATEGORY_SET_NAME,

Line 312: from MTL_CATEGORY_SETS_TL B

308: DESCRIPTION
309: ) = ( select
310: B.CATEGORY_SET_NAME,
311: B.DESCRIPTION
312: from MTL_CATEGORY_SETS_TL B
313: where B.CATEGORY_SET_ID = T.CATEGORY_SET_ID
314: and B.LANGUAGE = T.SOURCE_LANG )
315: where (
316: T.CATEGORY_SET_ID,

Line 321: from MTL_CATEGORY_SETS_TL SUBB,

317: T.LANGUAGE
318: ) in ( select
319: SUBT.CATEGORY_SET_ID,
320: SUBT.LANGUAGE
321: from MTL_CATEGORY_SETS_TL SUBB,
322: MTL_CATEGORY_SETS_TL SUBT
323: where SUBB.CATEGORY_SET_ID = SUBT.CATEGORY_SET_ID
324: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
325: and ( SUBB.CATEGORY_SET_NAME <> SUBT.CATEGORY_SET_NAME

Line 322: MTL_CATEGORY_SETS_TL SUBT

318: ) in ( select
319: SUBT.CATEGORY_SET_ID,
320: SUBT.LANGUAGE
321: from MTL_CATEGORY_SETS_TL SUBB,
322: MTL_CATEGORY_SETS_TL SUBT
323: where SUBB.CATEGORY_SET_ID = SUBT.CATEGORY_SET_ID
324: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
325: and ( SUBB.CATEGORY_SET_NAME <> SUBT.CATEGORY_SET_NAME
326: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 331: insert into MTL_CATEGORY_SETS_TL (

327: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null )
328: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null ) )
329: );
330:
331: insert into MTL_CATEGORY_SETS_TL (
332: CATEGORY_SET_ID,
333: CATEGORY_SET_NAME,
334: DESCRIPTION,
335: LAST_UPDATE_DATE,

Line 353: from MTL_CATEGORY_SETS_TL B,

349: B.CREATED_BY,
350: B.LAST_UPDATE_LOGIN,
351: L.LANGUAGE_CODE,
352: B.SOURCE_LANG
353: from MTL_CATEGORY_SETS_TL B,
354: FND_LANGUAGES L
355: where L.INSTALLED_FLAG in ('I', 'B')
356: and B.LANGUAGE = userenv('LANG')
357: and not exists

Line 359: from MTL_CATEGORY_SETS_TL T

355: where L.INSTALLED_FLAG in ('I', 'B')
356: and B.LANGUAGE = userenv('LANG')
357: and not exists
358: ( select NULL
359: from MTL_CATEGORY_SETS_TL T
360: where T.CATEGORY_SET_ID = B.CATEGORY_SET_ID
361: and T.LANGUAGE = L.LANGUAGE_CODE );
362:
363: end ADD_LANGUAGE;

Line 406: FROM mtl_category_sets_tl

402:
403: --5103579: Added rownum clause in translate_row.
404: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE
405: INTO db_luby, db_ludate
406: FROM mtl_category_sets_tl
407: WHERE category_set_id = x_category_set_id
408: AND userenv('LANG') IN (language, source_lang)
409: AND ROWNUM = 1;
410:

Line 414: UPDATE mtl_category_sets_tl

410:
411: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
412: db_ludate, x_custom_mode)) THEN
413:
414: UPDATE mtl_category_sets_tl
415: SET category_set_name = NVL(x_category_set_name, category_set_name)
416: , description = NVL(x_description, description)
417: , last_update_date = db_ludate
418: , last_updated_by = db_luby