APPS.ICX_QUESTIONS_PKG dependencies on ICX_QUESTIONS_TL

Line 40: insert into ICX_QUESTIONS_TL (

36: X_LAST_UPDATED_BY,
37: X_LAST_UPDATE_LOGIN
38: );
39:
40: insert into ICX_QUESTIONS_TL (
41: QUESTION_CODE,
42: QUESTION,
43: CREATED_BY,
44: CREATION_DATE,

Line 64: from ICX_QUESTIONS_TL T

60: from FND_LANGUAGES L
61: where L.INSTALLED_FLAG IN ('I','B')
62: and not exists
63: (select NULL
64: from ICX_QUESTIONS_TL T
65: where T.QUESTION_CODE = X_QUESTION_CODE
66: and T.LANGUAGE = L.LANGUAGE_CODE);
67:
68: open c;

Line 99: update ICX_QUESTIONS_TL set

95: if (sql%notfound) then
96: raise no_data_found;
97: end if;
98:
99: update ICX_QUESTIONS_TL set
100: QUESTION = X_QUESTION,
101: SOURCE_LANG = userenv('LANG'),
102: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
103: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 119: update ICX_QUESTIONS_tl set

115: X_OWNER in VARCHAR2,
116: X_QUESTION in VARCHAR2) is
117: begin
118:
119: update ICX_QUESTIONS_tl set
120: question = X_QUESTION,
121: SOURCE_LANG = userenv('LANG'),
122: last_update_date = sysdate,
123: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),

Line 182: delete from ICX_QUESTIONS_TL T

178: --*****************************************************************************
179: procedure ADD_LANGUAGE
180: is
181: begin
182: delete from ICX_QUESTIONS_TL T
183: where not exists
184: (select NULL
185: from ICX_QUESTIONS B
186: where B.QUESTION_CODE = T.QUESTION_CODE

Line 189: update ICX_QUESTIONS_TL T set (

185: from ICX_QUESTIONS B
186: where B.QUESTION_CODE = T.QUESTION_CODE
187: );
188:
189: update ICX_QUESTIONS_TL T set (
190: QUESTION
191: ) = (select
192: B.QUESTION
193: from ICX_QUESTIONS_TL B

Line 193: from ICX_QUESTIONS_TL B

189: update ICX_QUESTIONS_TL T set (
190: QUESTION
191: ) = (select
192: B.QUESTION
193: from ICX_QUESTIONS_TL B
194: where B.QUESTION_CODE = T.QUESTION_CODE
195: and B.LANGUAGE = T.SOURCE_LANG)
196: where (
197: T.QUESTION_CODE,

Line 202: from ICX_QUESTIONS_TL SUBB, ICX_QUESTIONS_TL SUBT

198: T.LANGUAGE
199: ) in (select
200: SUBT.QUESTION_CODE,
201: SUBT.LANGUAGE
202: from ICX_QUESTIONS_TL SUBB, ICX_QUESTIONS_TL SUBT
203: where SUBB.QUESTION_CODE = SUBT.QUESTION_CODE
204: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
205: and (SUBB.QUESTION <> SUBT.QUESTION
206: or (SUBB.QUESTION is null and SUBT.QUESTION is not null)

Line 209: insert into ICX_QUESTIONS_TL (

205: and (SUBB.QUESTION <> SUBT.QUESTION
206: or (SUBB.QUESTION is null and SUBT.QUESTION is not null)
207: ));
208:
209: insert into ICX_QUESTIONS_TL (
210: QUESTION_CODE,
211: QUESTION,
212: CREATED_BY,
213: CREATION_DATE,

Line 229: from ICX_QUESTIONS_TL B, FND_LANGUAGES L

225: B.LAST_UPDATE_DATE,
226: B.LAST_UPDATE_LOGIN,
227: L.LANGUAGE_CODE,
228: B.SOURCE_LANG
229: from ICX_QUESTIONS_TL B, FND_LANGUAGES L
230: where L.INSTALLED_FLAG in ('I', 'B')
231: and B.LANGUAGE = userenv('LANG')
232: and not exists
233: (select NULL

Line 234: from ICX_QUESTIONS_TL T

230: where L.INSTALLED_FLAG in ('I', 'B')
231: and B.LANGUAGE = userenv('LANG')
232: and not exists
233: (select NULL
234: from ICX_QUESTIONS_TL T
235: where T.QUESTION_CODE = B.QUESTION_CODE
236: and T.LANGUAGE = L.LANGUAGE_CODE);
237: end ADD_LANGUAGE;
238: