APPS.CS_TP_CHOICES_PKG dependencies on CS_TP_CHOICES_TL

Line 99: insert into CS_TP_CHOICES_TL (

95: X_LAST_UPDATE_LOGIN
96: ,X_DEFAULT_FLAG
97: );
98:
99: insert into CS_TP_CHOICES_TL (
100: CHOICE_ID,
101: VALUE,
102: CREATION_DATE,
103: CREATED_BY,

Line 123: from CS_TP_CHOICES_TL T

119: from FND_LANGUAGES L
120: where L.INSTALLED_FLAG in ('I', 'B')
121: and not exists
122: (select NULL
123: from CS_TP_CHOICES_TL T
124: where T.CHOICE_ID = X_CHOICE_ID
125: and T.LANGUAGE = L.LANGUAGE_CODE);
126:
127: open c;

Line 196: from CS_TP_CHOICES_TL

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

Line 338: update CS_TP_CHOICES_TL set

334: if (sql%notfound) then
335: raise no_data_found;
336: end if;
337:
338: update CS_TP_CHOICES_TL set
339: VALUE = X_VALUE,
340: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
341: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
342: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 356: delete from CS_TP_CHOICES_TL

352: procedure DELETE_ROW (
353: X_CHOICE_ID in NUMBER
354: ) is
355: begin
356: delete from CS_TP_CHOICES_TL
357: where CHOICE_ID = X_CHOICE_ID;
358:
359: if (sql%notfound) then
360: raise no_data_found;

Line 374: delete from CS_TP_CHOICES_TL T

370:
371: procedure ADD_LANGUAGE
372: is
373: begin
374: delete from CS_TP_CHOICES_TL T
375: where not exists
376: (select NULL
377: from CS_TP_CHOICES_B B
378: where B.CHOICE_ID = T.CHOICE_ID

Line 381: update CS_TP_CHOICES_TL T set (

377: from CS_TP_CHOICES_B B
378: where B.CHOICE_ID = T.CHOICE_ID
379: );
380:
381: update CS_TP_CHOICES_TL T set (
382: VALUE
383: ) = (select
384: B.VALUE
385: from CS_TP_CHOICES_TL B

Line 385: from CS_TP_CHOICES_TL B

381: update CS_TP_CHOICES_TL T set (
382: VALUE
383: ) = (select
384: B.VALUE
385: from CS_TP_CHOICES_TL B
386: where B.CHOICE_ID = T.CHOICE_ID
387: and B.LANGUAGE = T.SOURCE_LANG)
388: where (
389: T.CHOICE_ID,

Line 394: from CS_TP_CHOICES_TL SUBB, CS_TP_CHOICES_TL SUBT

390: T.LANGUAGE
391: ) in (select
392: SUBT.CHOICE_ID,
393: SUBT.LANGUAGE
394: from CS_TP_CHOICES_TL SUBB, CS_TP_CHOICES_TL SUBT
395: where SUBB.CHOICE_ID = SUBT.CHOICE_ID
396: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
397: and (SUBB.VALUE <> SUBT.VALUE
398: ));

Line 400: insert into CS_TP_CHOICES_TL (

396: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
397: and (SUBB.VALUE <> SUBT.VALUE
398: ));
399:
400: insert into CS_TP_CHOICES_TL (
401: CHOICE_ID,
402: VALUE,
403: CREATION_DATE,
404: CREATED_BY,

Line 420: from CS_TP_CHOICES_TL B, FND_LANGUAGES L

416: B.LAST_UPDATED_BY,
417: B.LAST_UPDATE_LOGIN,
418: L.LANGUAGE_CODE,
419: B.SOURCE_LANG
420: from CS_TP_CHOICES_TL B, FND_LANGUAGES L
421: where L.INSTALLED_FLAG in ('I', 'B')
422: and B.LANGUAGE = userenv('LANG')
423: and not exists
424: (select NULL

Line 425: from CS_TP_CHOICES_TL T

421: where L.INSTALLED_FLAG in ('I', 'B')
422: and B.LANGUAGE = userenv('LANG')
423: and not exists
424: (select NULL
425: from CS_TP_CHOICES_TL T
426: where T.CHOICE_ID = B.CHOICE_ID
427: and T.LANGUAGE = L.LANGUAGE_CODE);
428: end ADD_LANGUAGE;
429:

Line 494: update CS_TP_CHOICES_TL set

490: x_value in varchar2) is
491:
492: begin
493:
494: update CS_TP_CHOICES_TL set
495: last_update_date = sysdate,
496: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),
497: last_update_login = 0,
498: source_lang = userenv('LANG')