eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ICX_QUESTIONS_PKG dependencies on ICX_QUESTIONS

Line 1: package body ICX_QUESTIONS_PKG as

1: package body ICX_QUESTIONS_PKG as
2: /* $Header: ICXQUESB.pls 115.3 1999/11/12 15:35:18 pkm ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out VARCHAR2,

Line 16: cursor C is select ROWID from ICX_QUESTIONS

12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: cursor C is select ROWID from ICX_QUESTIONS
17: where QUESTION_CODE = X_QUESTION_CODE;
18:
19: begin
20: insert into ICX_QUESTIONS (

Line 20: insert into ICX_QUESTIONS (

16: cursor C is select ROWID from ICX_QUESTIONS
17: where QUESTION_CODE = X_QUESTION_CODE;
18:
19: begin
20: insert into ICX_QUESTIONS (
21: QUESTION_CODE,
22: APPLICATION_ID,
23: TYPE,
24: CREATION_DATE,

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 87: update ICX_QUESTIONS set

83: X_LAST_UPDATED_BY in NUMBER,
84: X_LAST_UPDATE_LOGIN in NUMBER
85: ) is
86: begin
87: update ICX_QUESTIONS set
88: APPLICATION_ID = X_APPLICATION_ID,
89: TYPE = X_TYPE,
90: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
91: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

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 149: from ICX_QUESTIONS

145: user_id := 1;
146: end if;
147:
148: select QUESTION_CODE into ques_code
149: from ICX_QUESTIONS
150: where QUESTION_CODE = X_QUESTION_CODE;
151:
152: icx_questions_pkg.UPDATE_ROW (
153: X_QUESTION_CODE => X_QUESTION_CODE,

Line 152: icx_questions_pkg.UPDATE_ROW (

148: select QUESTION_CODE into ques_code
149: from ICX_QUESTIONS
150: where QUESTION_CODE = X_QUESTION_CODE;
151:
152: icx_questions_pkg.UPDATE_ROW (
153: X_QUESTION_CODE => X_QUESTION_CODE,
154: X_APPLICATION_ID => X_APPLICATION_ID,
155: X_TYPE => X_TYPE,
156: X_QUESTION => X_QUESTION,

Line 164: icx_questions_pkg.INSERT_ROW (

160:
161: exception
162: when NO_DATA_FOUND then
163:
164: icx_questions_pkg.INSERT_ROW (
165: X_ROWID => row_id,
166: X_QUESTION_CODE => X_QUESTION_CODE,
167: X_APPLICATION_ID => X_APPLICATION_ID,
168: X_TYPE => X_TYPE,

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 185: from ICX_QUESTIONS B

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
187: );
188:
189: update ICX_QUESTIONS_TL T set (

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:

Line 239: end ICX_QUESTIONS_PKG;

235: where T.QUESTION_CODE = B.QUESTION_CODE
236: and T.LANGUAGE = L.LANGUAGE_CODE);
237: end ADD_LANGUAGE;
238:
239: end ICX_QUESTIONS_PKG;