APPS.DT_DATE_PROMPTS_PKG dependencies on DT_DATE_PROMPTS_TL

Line 7: update DT_DATE_PROMPTS_TL T set (

3:
4: procedure ADD_LANGUAGE
5: is
6: begin
7: update DT_DATE_PROMPTS_TL T set (
8: EFFECTIVE_END_PROMPT,
9: EFFECTIVE_START_PROMPT
10: ) = (select
11: B.EFFECTIVE_END_PROMPT,

Line 13: from DT_DATE_PROMPTS_TL B

9: EFFECTIVE_START_PROMPT
10: ) = (select
11: B.EFFECTIVE_END_PROMPT,
12: B.EFFECTIVE_START_PROMPT
13: from DT_DATE_PROMPTS_TL B
14: where B.LANGUAGE = T.LANGUAGE
15: and B.LANGUAGE = T.SOURCE_LANG)
16: where (
17: T.LANGUAGE,

Line 22: from DT_DATE_PROMPTS_TL SUBB, DT_DATE_PROMPTS_TL SUBT

18: T.LANGUAGE
19: ) in (select
20: SUBT.LANGUAGE,
21: SUBT.LANGUAGE
22: from DT_DATE_PROMPTS_TL SUBB, DT_DATE_PROMPTS_TL SUBT
23: where SUBB.LANGUAGE = SUBT.LANGUAGE
24: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
25: and (SUBB.EFFECTIVE_END_PROMPT <> SUBT.EFFECTIVE_END_PROMPT
26: or (SUBB.EFFECTIVE_END_PROMPT is null and SUBT.EFFECTIVE_END_PROMPT is not null)

Line 33: insert into DT_DATE_PROMPTS_TL (

29: or (SUBB.EFFECTIVE_START_PROMPT is null and SUBT.EFFECTIVE_START_PROMPT is not null)
30: or (SUBB.EFFECTIVE_START_PROMPT is not null and SUBT.EFFECTIVE_START_PROMPT is null)
31: ));
32:
33: insert into DT_DATE_PROMPTS_TL (
34: CREATED_BY,
35: CREATION_DATE,
36: EFFECTIVE_END_PROMPT,
37: EFFECTIVE_START_PROMPT,

Line 53: from DT_DATE_PROMPTS_TL B, FND_LANGUAGES L

49: B.LAST_UPDATED_BY,
50: B.LAST_UPDATE_LOGIN,
51: L.LANGUAGE_CODE,
52: B.SOURCE_LANG
53: from DT_DATE_PROMPTS_TL B, FND_LANGUAGES L
54: where L.INSTALLED_FLAG in ('I', 'B')
55: and B.LANGUAGE = userenv('LANG')
56: and not exists
57: (select NULL

Line 58: from DT_DATE_PROMPTS_TL T

54: where L.INSTALLED_FLAG in ('I', 'B')
55: and B.LANGUAGE = userenv('LANG')
56: and not exists
57: (select NULL
58: from DT_DATE_PROMPTS_TL T
59: where T.LANGUAGE = L.LANGUAGE_CODE);
60: end ADD_LANGUAGE;
61: --
62: procedure INSERT_ROW (

Line 72: cursor C is select ROWID from DT_DATE_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_DATE_PROMPTS_TL
73: where LANGUAGE = userenv('LANG')
74: ;
75: begin
76: insert into DT_DATE_PROMPTS_TL (

Line 76: insert into DT_DATE_PROMPTS_TL (

72: cursor C is select ROWID from DT_DATE_PROMPTS_TL
73: where LANGUAGE = userenv('LANG')
74: ;
75: begin
76: insert into DT_DATE_PROMPTS_TL (
77: CREATED_BY,
78: CREATION_DATE,
79: EFFECTIVE_END_PROMPT,
80: EFFECTIVE_START_PROMPT,

Line 100: from DT_DATE_PROMPTS_TL T

96: from FND_LANGUAGES L
97: where L.INSTALLED_FLAG in ('I', 'B')
98: and not exists
99: (select NULL
100: from DT_DATE_PROMPTS_TL T
101: where T.LANGUAGE = L.LANGUAGE_CODE);
102:
103: open c;
104: fetch c into X_ROWID;

Line 121: update DT_DATE_PROMPTS_TL set

117: X_LAST_UPDATED_BY in NUMBER,
118: X_LAST_UPDATE_LOGIN in NUMBER
119: ) is
120: begin
121: update DT_DATE_PROMPTS_TL set
122: EFFECTIVE_END_PROMPT = X_EFFECTIVE_END_PROMPT,
123: EFFECTIVE_START_PROMPT = X_EFFECTIVE_START_PROMPT,
124: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
125: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 218: update DT_DATE_PROMPTS_TL set

214: X_LAST_UPDATE_DATE,
215: X_LAST_UPDATED_BY,
216: X_LAST_UPDATE_LOGIN
217: );
218: update DT_DATE_PROMPTS_TL set
219: EFFECTIVE_END_PROMPT = X_EFFECTIVE_END_PROMPT,
220: EFFECTIVE_START_PROMPT = X_EFFECTIVE_START_PROMPT,
221: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
222: LAST_UPDATED_BY = X_LAST_UPDATED_BY,