APPS.DT_TITLE_PROMPTS_PKG dependencies on DT_TITLE_PROMPTS_TL

Line 6: update DT_TITLE_PROMPTS_TL T set (

2: /* $Header: dttprrhi.pkb 115.5 2002/12/06 11:35:26 apholt ship $ */
3: procedure ADD_LANGUAGE
4: is
5: begin
6: update DT_TITLE_PROMPTS_TL T set (
7: TITLE_PROMPT
8: ) = (select
9: B.TITLE_PROMPT
10: from DT_TITLE_PROMPTS_TL B

Line 10: from DT_TITLE_PROMPTS_TL B

6: update DT_TITLE_PROMPTS_TL T set (
7: TITLE_PROMPT
8: ) = (select
9: B.TITLE_PROMPT
10: from DT_TITLE_PROMPTS_TL B
11: where B.VIEW_NAME = T.VIEW_NAME
12: and B.LANGUAGE = T.LANGUAGE
13: and B.LANGUAGE = T.SOURCE_LANG)
14: where (

Line 22: from DT_TITLE_PROMPTS_TL SUBB, DT_TITLE_PROMPTS_TL SUBT

18: ) in (select
19: SUBT.VIEW_NAME,
20: SUBT.LANGUAGE,
21: SUBT.LANGUAGE
22: from DT_TITLE_PROMPTS_TL SUBB, DT_TITLE_PROMPTS_TL SUBT
23: where SUBB.VIEW_NAME = SUBT.VIEW_NAME
24: and SUBB.LANGUAGE = SUBT.LANGUAGE
25: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
26: and (SUBB.TITLE_PROMPT <> SUBT.TITLE_PROMPT

Line 31: insert into DT_TITLE_PROMPTS_TL (

27: or (SUBB.TITLE_PROMPT is null and SUBT.TITLE_PROMPT is not null)
28: or (SUBB.TITLE_PROMPT is not null and SUBT.TITLE_PROMPT is null)
29: ));
30:
31: insert into DT_TITLE_PROMPTS_TL (
32: VIEW_NAME,
33: TITLE_PROMPT,
34: LAST_UPDATE_DATE,
35: LAST_UPDATED_BY,

Line 51: from DT_TITLE_PROMPTS_TL B, FND_LANGUAGES L

47: B.CREATED_BY,
48: B.CREATION_DATE,
49: L.LANGUAGE_CODE,
50: B.SOURCE_LANG
51: from DT_TITLE_PROMPTS_TL B, FND_LANGUAGES L
52: where L.INSTALLED_FLAG in ('I', 'B')
53: and B.LANGUAGE = userenv('LANG')
54: and not exists
55: (select NULL

Line 56: from DT_TITLE_PROMPTS_TL T

52: where L.INSTALLED_FLAG in ('I', 'B')
53: and B.LANGUAGE = userenv('LANG')
54: and not exists
55: (select NULL
56: from DT_TITLE_PROMPTS_TL T
57: where T.VIEW_NAME = B.VIEW_NAME
58: and T.LANGUAGE = L.LANGUAGE_CODE);
59: end ADD_LANGUAGE;
60: --

Line 72: cursor C is select ROWID from DT_TITLE_PROMPTS_TL

68: X_LAST_UPDATE_DATE in DATE,
69: X_LAST_UPDATED_BY in NUMBER,
70: X_LAST_UPDATE_LOGIN in NUMBER
71: ) is
72: cursor C is select ROWID from DT_TITLE_PROMPTS_TL
73: where VIEW_NAME = X_VIEW_NAME
74: and LANGUAGE = userenv('LANG')
75: ;
76: begin

Line 77: insert into DT_TITLE_PROMPTS_TL (

73: where VIEW_NAME = X_VIEW_NAME
74: and LANGUAGE = userenv('LANG')
75: ;
76: begin
77: insert into DT_TITLE_PROMPTS_TL (
78: VIEW_NAME,
79: TITLE_PROMPT,
80: LAST_UPDATE_DATE,
81: LAST_UPDATED_BY,

Line 101: from DT_TITLE_PROMPTS_TL T

97: from FND_LANGUAGES L
98: where L.INSTALLED_FLAG in ('I', 'B')
99: and not exists
100: (select NULL
101: from DT_TITLE_PROMPTS_TL T
102: where T.VIEW_NAME = X_VIEW_NAME
103: and T.LANGUAGE = L.LANGUAGE_CODE);
104:
105: open c;

Line 123: update DT_TITLE_PROMPTS_TL set

119: X_LAST_UPDATED_BY in NUMBER,
120: X_LAST_UPDATE_LOGIN in NUMBER
121: ) is
122: begin
123: update DT_TITLE_PROMPTS_TL set
124: TITLE_PROMPT = X_TITLE_PROMPT,
125: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
126: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
127: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 220: update DT_TITLE_PROMPTS_TL set

216: X_LAST_UPDATE_DATE,
217: X_LAST_UPDATED_BY,
218: X_LAST_UPDATE_LOGIN
219: );
220: update DT_TITLE_PROMPTS_TL set
221: TITLE_PROMPT = X_TITLE_PROMPT,
222: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
223: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
224: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,