APPS.CS_SR_TYPE_CATEGORIES_PKG dependencies on CS_SR_TYPE_CATEGORIES_TL

Line 97: insert into CS_SR_TYPE_CATEGORIES_TL (

93: X_LAST_UPDATED_BY,
94: X_LAST_UPDATE_LOGIN
95: );
96:
97: insert into CS_SR_TYPE_CATEGORIES_TL (
98: SR_TYPE_CATEGORY_ID,
99: NAME,
100: DESCRIPTION,
101: OBJECT_VERSION_NUMBER,

Line 125: from CS_SR_TYPE_CATEGORIES_TL T

121: from FND_LANGUAGES L
122: where L.INSTALLED_FLAG in ('I', 'B')
123: and not exists
124: (select NULL
125: from CS_SR_TYPE_CATEGORIES_TL T
126: where T.SR_TYPE_CATEGORY_ID = X_SR_TYPE_CATEGORY_ID
127: and T.LANGUAGE = L.LANGUAGE_CODE);
128:
129: open c;

Line 196: from CS_SR_TYPE_CATEGORIES_TL

192: cursor c1 is select
193: NAME,
194: DESCRIPTION,
195: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
196: from CS_SR_TYPE_CATEGORIES_TL
197: where SR_TYPE_CATEGORY_ID = X_SR_TYPE_CATEGORY_ID
198: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
199: for update of SR_TYPE_CATEGORY_ID nowait;
200: begin

Line 335: update CS_SR_TYPE_CATEGORIES_TL set

331: if (sql%notfound) then
332: raise no_data_found;
333: end if;
334:
335: update CS_SR_TYPE_CATEGORIES_TL set
336: NAME = X_NAME,
337: DESCRIPTION = X_DESCRIPTION,
338: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
339: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 354: delete from CS_SR_TYPE_CATEGORIES_TL

350: procedure DELETE_ROW (
351: X_SR_TYPE_CATEGORY_ID in NUMBER
352: ) is
353: begin
354: delete from CS_SR_TYPE_CATEGORIES_TL
355: where SR_TYPE_CATEGORY_ID = X_SR_TYPE_CATEGORY_ID;
356:
357: if (sql%notfound) then
358: raise no_data_found;

Line 372: delete from CS_SR_TYPE_CATEGORIES_TL T

368:
369: procedure ADD_LANGUAGE
370: is
371: begin
372: delete from CS_SR_TYPE_CATEGORIES_TL T
373: where not exists
374: (select NULL
375: from CS_SR_TYPE_CATEGORIES_B B
376: where B.SR_TYPE_CATEGORY_ID = T.SR_TYPE_CATEGORY_ID

Line 379: update CS_SR_TYPE_CATEGORIES_TL T set (

375: from CS_SR_TYPE_CATEGORIES_B B
376: where B.SR_TYPE_CATEGORY_ID = T.SR_TYPE_CATEGORY_ID
377: );
378:
379: update CS_SR_TYPE_CATEGORIES_TL T set (
380: NAME,
381: DESCRIPTION
382: ) = (select
383: B.NAME,

Line 385: from CS_SR_TYPE_CATEGORIES_TL B

381: DESCRIPTION
382: ) = (select
383: B.NAME,
384: B.DESCRIPTION
385: from CS_SR_TYPE_CATEGORIES_TL B
386: where B.SR_TYPE_CATEGORY_ID = T.SR_TYPE_CATEGORY_ID
387: and B.LANGUAGE = T.SOURCE_LANG)
388: where (
389: T.SR_TYPE_CATEGORY_ID,

Line 394: from CS_SR_TYPE_CATEGORIES_TL SUBB, CS_SR_TYPE_CATEGORIES_TL SUBT

390: T.LANGUAGE
391: ) in (select
392: SUBT.SR_TYPE_CATEGORY_ID,
393: SUBT.LANGUAGE
394: from CS_SR_TYPE_CATEGORIES_TL SUBB, CS_SR_TYPE_CATEGORIES_TL SUBT
395: where SUBB.SR_TYPE_CATEGORY_ID = SUBT.SR_TYPE_CATEGORY_ID
396: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
397: and (SUBB.NAME <> SUBT.NAME
398: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 403: insert into CS_SR_TYPE_CATEGORIES_TL (

399: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
400: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
401: ));
402:
403: insert into CS_SR_TYPE_CATEGORIES_TL (
404: SR_TYPE_CATEGORY_ID,
405: NAME,
406: DESCRIPTION,
407: OBJECT_VERSION_NUMBER,

Line 427: from CS_SR_TYPE_CATEGORIES_TL B, FND_LANGUAGES L

423: B.LAST_UPDATED_BY,
424: B.LAST_UPDATE_LOGIN,
425: L.LANGUAGE_CODE,
426: B.SOURCE_LANG
427: from CS_SR_TYPE_CATEGORIES_TL B, FND_LANGUAGES L
428: where L.INSTALLED_FLAG in ('I', 'B')
429: and B.LANGUAGE = userenv('LANG')
430: and not exists
431: (select NULL

Line 432: from CS_SR_TYPE_CATEGORIES_TL T

428: where L.INSTALLED_FLAG in ('I', 'B')
429: and B.LANGUAGE = userenv('LANG')
430: and not exists
431: (select NULL
432: from CS_SR_TYPE_CATEGORIES_TL T
433: where T.SR_TYPE_CATEGORY_ID = B.SR_TYPE_CATEGORY_ID
434: and T.LANGUAGE = L.LANGUAGE_CODE);
435: end ADD_LANGUAGE;
436:

Line 454: update cs_sr_type_categories_tl set

450: else
451: l_user_id := 0;
452: end if;
453:
454: update cs_sr_type_categories_tl set
455: name = nvl(x_name,name),
456: description = nvl(x_description,description),
457: last_update_date = nvl(x_last_update_date,sysdate),
458: last_updated_by = l_user_id,