APPS.DT_COLUMN_PROMPTS_PKG dependencies on DT_COLUMN_PROMPTS_TL

Line 6: update DT_COLUMN_PROMPTS_TL T set (

2: /* $Header: dtclprhi.pkb 115.5 2002/12/09 13:36:34 apholt ship $ */
3: procedure ADD_LANGUAGE
4: is
5: begin
6: update DT_COLUMN_PROMPTS_TL T set (
7: COLUMN_PROMPT
8: ) = (select
9: B.COLUMN_PROMPT
10: from DT_COLUMN_PROMPTS_TL B

Line 10: from DT_COLUMN_PROMPTS_TL B

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

Line 25: from DT_COLUMN_PROMPTS_TL SUBB, DT_COLUMN_PROMPTS_TL SUBT

21: SUBT.VIEW_NAME,
22: SUBT.COLUMN_NAME,
23: SUBT.LANGUAGE,
24: SUBT.LANGUAGE
25: from DT_COLUMN_PROMPTS_TL SUBB, DT_COLUMN_PROMPTS_TL SUBT
26: where SUBB.VIEW_NAME = SUBT.VIEW_NAME
27: and SUBB.COLUMN_NAME = SUBT.COLUMN_NAME
28: and SUBB.LANGUAGE = SUBT.LANGUAGE
29: and SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 35: insert into DT_COLUMN_PROMPTS_TL (

31: or (SUBB.COLUMN_PROMPT is null and SUBT.COLUMN_PROMPT is not null)
32: or (SUBB.COLUMN_PROMPT is not null and SUBT.COLUMN_PROMPT is null)
33: ));
34:
35: insert into DT_COLUMN_PROMPTS_TL (
36: LAST_UPDATE_LOGIN,
37: CREATED_BY,
38: CREATION_DATE,
39: COLUMN_NAME,

Line 57: from DT_COLUMN_PROMPTS_TL B, FND_LANGUAGES L

53: B.LAST_UPDATE_DATE,
54: B.LAST_UPDATED_BY,
55: L.LANGUAGE_CODE,
56: B.SOURCE_LANG
57: from DT_COLUMN_PROMPTS_TL B, FND_LANGUAGES L
58: where L.INSTALLED_FLAG in ('I', 'B')
59: and B.LANGUAGE = userenv('LANG')
60: and not exists
61: (select NULL

Line 62: from DT_COLUMN_PROMPTS_TL T

58: where L.INSTALLED_FLAG in ('I', 'B')
59: and B.LANGUAGE = userenv('LANG')
60: and not exists
61: (select NULL
62: from DT_COLUMN_PROMPTS_TL T
63: where T.VIEW_NAME = B.VIEW_NAME
64: and T.COLUMN_NAME = B.COLUMN_NAME
65: and T.LANGUAGE = L.LANGUAGE_CODE);
66: end ADD_LANGUAGE;

Line 79: cursor C is select ROWID from DT_COLUMN_PROMPTS_TL

75: X_LAST_UPDATE_DATE in DATE,
76: X_LAST_UPDATED_BY in NUMBER,
77: X_LAST_UPDATE_LOGIN in NUMBER
78: ) IS
79: cursor C is select ROWID from DT_COLUMN_PROMPTS_TL
80: where VIEW_NAME = X_VIEW_NAME
81: and COLUMN_NAME = X_COLUMN_NAME
82: and LANGUAGE = userenv('LANG')
83: ;

Line 85: insert into DT_COLUMN_PROMPTS_TL (

81: and COLUMN_NAME = X_COLUMN_NAME
82: and LANGUAGE = userenv('LANG')
83: ;
84: BEGIN
85: insert into DT_COLUMN_PROMPTS_TL (
86: LAST_UPDATE_LOGIN,
87: CREATED_BY,
88: CREATION_DATE,
89: COLUMN_NAME,

Line 111: from DT_COLUMN_PROMPTS_TL T

107: from FND_LANGUAGES L
108: where L.INSTALLED_FLAG in ('I', 'B')
109: and not exists
110: (select NULL
111: from DT_COLUMN_PROMPTS_TL T
112: where T.VIEW_NAME = X_VIEW_NAME
113: and T.COLUMN_NAME = X_COLUMN_NAME
114: and T.LANGUAGE = L.LANGUAGE_CODE);
115:

Line 135: update DT_COLUMN_PROMPTS_TL set

131: X_LAST_UPDATED_BY in NUMBER,
132: X_LAST_UPDATE_LOGIN in NUMBER
133: ) is
134: begin
135: update DT_COLUMN_PROMPTS_TL set
136: COLUMN_PROMPT = X_COLUMN_PROMPT,
137: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
138: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
139: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 239: update DT_COLUMN_PROMPTS_TL set

235: X_LAST_UPDATE_DATE,
236: X_LAST_UPDATED_BY,
237: X_LAST_UPDATE_LOGIN
238: );
239: update DT_COLUMN_PROMPTS_TL set
240: COLUMN_PROMPT = X_COLUMN_PROMPT,
241: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
242: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
243: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,