APPS.CS_TP_QUESTIONS_PKG dependencies on CS_TP_QUESTIONS_TL

Line 109: insert into CS_TP_QUESTIONS_TL (

105: X_NOTE_TYPE ,
106: X_SHOW_ON_CREATION_FLAG
107: );
108:
109: insert into CS_TP_QUESTIONS_TL (
110: QUESTION_ID,
111: NAME,
112: TEXT,
113: DESCRIPTION,

Line 137: from CS_TP_QUESTIONS_TL T

133: from FND_LANGUAGES L
134: where L.INSTALLED_FLAG in ('I', 'B')
135: and not exists
136: (select NULL
137: from CS_TP_QUESTIONS_TL T
138: where T.QUESTION_ID = X_QUESTION_ID
139: and T.LANGUAGE = L.LANGUAGE_CODE);
140:
141: open c;

Line 218: from CS_TP_QUESTIONS_TL

214: NAME,
215: TEXT,
216: DESCRIPTION,
217: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
218: from CS_TP_QUESTIONS_TL
219: where QUESTION_ID = X_QUESTION_ID
220: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
221: for update of QUESTION_ID nowait;
222: begin

Line 375: update CS_TP_QUESTIONS_TL set

371: if (sql%notfound) then
372: raise no_data_found;
373: end if;
374:
375: update CS_TP_QUESTIONS_TL set
376: name = decode(nvl(x_name, fnd_api.g_miss_char), fnd_api.g_miss_char, name,x_name),
377: text = decode(nvl(x_text, fnd_api.g_miss_char), fnd_api.g_miss_char, text,x_text),
378: description = decode(nvl(x_description, fnd_api.g_miss_char), fnd_api.g_miss_char,description, x_description),
379: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 395: delete from CS_TP_QUESTIONS_TL

391: procedure DELETE_ROW (
392: X_QUESTION_ID in NUMBER
393: ) is
394: begin
395: delete from CS_TP_QUESTIONS_TL
396: where QUESTION_ID = X_QUESTION_ID;
397:
398: if (sql%notfound) then
399: raise no_data_found;

Line 413: delete from CS_TP_QUESTIONS_TL T

409:
410: procedure ADD_LANGUAGE
411: is
412: begin
413: delete from CS_TP_QUESTIONS_TL T
414: where not exists
415: (select NULL
416: from CS_TP_QUESTIONS_B B
417: where B.QUESTION_ID = T.QUESTION_ID

Line 420: update CS_TP_QUESTIONS_TL T set (

416: from CS_TP_QUESTIONS_B B
417: where B.QUESTION_ID = T.QUESTION_ID
418: );
419:
420: update CS_TP_QUESTIONS_TL T set (
421: NAME,
422: TEXT,
423: DESCRIPTION
424: ) = (select

Line 428: from CS_TP_QUESTIONS_TL B

424: ) = (select
425: B.NAME,
426: B.TEXT,
427: B.DESCRIPTION
428: from CS_TP_QUESTIONS_TL B
429: where B.QUESTION_ID = T.QUESTION_ID
430: and B.LANGUAGE = T.SOURCE_LANG)
431: where (
432: T.QUESTION_ID,

Line 437: from CS_TP_QUESTIONS_TL SUBB, CS_TP_QUESTIONS_TL SUBT

433: T.LANGUAGE
434: ) in (select
435: SUBT.QUESTION_ID,
436: SUBT.LANGUAGE
437: from CS_TP_QUESTIONS_TL SUBB, CS_TP_QUESTIONS_TL SUBT
438: where SUBB.QUESTION_ID = SUBT.QUESTION_ID
439: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
440: and (SUBB.NAME <> SUBT.NAME
441: or (SUBB.NAME is null and SUBT.NAME is not null)

Line 449: insert into CS_TP_QUESTIONS_TL (

445: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
446: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
447: ));
448:
449: insert into CS_TP_QUESTIONS_TL (
450: QUESTION_ID,
451: NAME,
452: TEXT,
453: DESCRIPTION,

Line 473: from CS_TP_QUESTIONS_TL B, FND_LANGUAGES L

469: B.LAST_UPDATED_BY,
470: B.LAST_UPDATE_LOGIN,
471: L.LANGUAGE_CODE,
472: B.SOURCE_LANG
473: from CS_TP_QUESTIONS_TL B, FND_LANGUAGES L
474: where L.INSTALLED_FLAG in ('I', 'B')
475: and B.LANGUAGE = userenv('LANG')
476: and not exists
477: (select NULL

Line 478: from CS_TP_QUESTIONS_TL T

474: where L.INSTALLED_FLAG in ('I', 'B')
475: and B.LANGUAGE = userenv('LANG')
476: and not exists
477: (select NULL
478: from CS_TP_QUESTIONS_TL T
479: where T.QUESTION_ID = B.QUESTION_ID
480: and T.LANGUAGE = L.LANGUAGE_CODE);
481: end ADD_LANGUAGE;
482:

Line 566: update CS_TP_QUESTIONS_TL set

562: l_amt number;
563: begin
564:
565: -- Update translated non-clob portions for specified language
566: update CS_TP_QUESTIONS_TL set
567: name = x_name,
568: text = x_text,
569: description = x_description,
570: last_update_date = sysdate,