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.MSC_ASK_ORACLE dependencies on MSC_QUESTIONS_B

Line 34: -- First insert into msc_questions_b and then into msc_questions_tl

30: -- (2) copy question from a existing question, so insert data
31: -- (3) update question, so update data
32: -- (4) delete question, so delete data
33: IF (x_mode = 1) THEN
34: -- First insert into msc_questions_b and then into msc_questions_tl
35: -- Note that the sequence will ensure that all question_ids are
36: -- greater than 5001
37: SELECT msc_questions_s.nextval
38: INTO x_question_id

Line 42: INSERT INTO MSC_QUESTIONS_B(

38: INTO x_question_id
39: FROM dual;
40: msc_util.msc_debug('QuestionId:'|| to_char(x_question_id));
41:
42: INSERT INTO MSC_QUESTIONS_B(
43: QUESTION_ID
44: ,ANSWER_ID
45: ,QUESTION_CODE
46: ,QUESTION_TYPE

Line 66: from msc_questions_b

62: ,fnd_global.user_id
63: ,fnd_global.conc_login_id
64: FROM dual
65: WHERE not exists (select 'already exists'
66: from msc_questions_b
67: where question_code = x_question_code);
68: msc_util.msc_debug('Inserted into msc_questions_b:'|| sql%rowcount);
69:
70: INSERT INTO MSC_QUESTIONS_TL(

Line 68: msc_util.msc_debug('Inserted into msc_questions_b:'|| sql%rowcount);

64: FROM dual
65: WHERE not exists (select 'already exists'
66: from msc_questions_b
67: where question_code = x_question_code);
68: msc_util.msc_debug('Inserted into msc_questions_b:'|| sql%rowcount);
69:
70: INSERT INTO MSC_QUESTIONS_TL(
71: QUESTION_ID
72: ,LANGUAGE

Line 99: from msc_questions_b

95: WHERE not exists
96: (select 'already exists'
97: from msc_questions_tl
98: where question_id = (select question_id
99: from msc_questions_b
100: where question_code = x_question_code)
101: and language = x_lang_code);
102:
103: msc_util.msc_debug('Inserted msc_questions_tl:' || to_char(sql%rowcount));

Line 110: INSERT INTO MSC_QUESTIONS_B(

106: INTO x_question_id
107: FROM dual;
108: msc_util.msc_debug('QuestionId:'|| to_char(x_question_id));
109:
110: INSERT INTO MSC_QUESTIONS_B(
111: QUESTION_ID
112: ,ANSWER_ID
113: ,QUESTION_CODE
114: ,QUESTION_TYPE

Line 132: FROM msc_questions_b q

128: ,fnd_global.user_id
129: ,sysdate
130: ,fnd_global.user_id
131: ,fnd_global.conc_login_id
132: FROM msc_questions_b q
133: WHERE q.question_code = x_copy_question
134: AND not exists (select 'already exists'
135: from msc_questions_b
136: where question_code = x_question_code);

Line 135: from msc_questions_b

131: ,fnd_global.conc_login_id
132: FROM msc_questions_b q
133: WHERE q.question_code = x_copy_question
134: AND not exists (select 'already exists'
135: from msc_questions_b
136: where question_code = x_question_code);
137: msc_util.msc_debug('Inserted into msc_questions_b:'|| sql%rowcount);
138:
139: INSERT INTO MSC_QUESTIONS_TL(

Line 137: msc_util.msc_debug('Inserted into msc_questions_b:'|| sql%rowcount);

133: WHERE q.question_code = x_copy_question
134: AND not exists (select 'already exists'
135: from msc_questions_b
136: where question_code = x_question_code);
137: msc_util.msc_debug('Inserted into msc_questions_b:'|| sql%rowcount);
138:
139: INSERT INTO MSC_QUESTIONS_TL(
140: QUESTION_ID
141: ,LANGUAGE

Line 166: from msc_questions_b

162: ,fnd_global.conc_login_id
163: FROM msc_questions_tl q
164: WHERE q.language = x_lang_code
165: AND q.question_id = (select question_id
166: from msc_questions_b
167: x where question_code = x_copy_question)
168: AND not exists
169: (select 'already exists'
170: from msc_questions_tl

Line 172: from msc_questions_b

168: AND not exists
169: (select 'already exists'
170: from msc_questions_tl
171: where question_id = (select question_id
172: from msc_questions_b
173: where question_code = x_question_code)
174: and language = x_lang_code);
175:
176: msc_util.msc_debug('Inserted msc_questions_tl:' || to_char(sql%rowcount));

Line 178: update msc_questions_b

174: and language = x_lang_code);
175:
176: msc_util.msc_debug('Inserted msc_questions_tl:' || to_char(sql%rowcount));
177: ELSIF (x_mode = 3) THEN -- update mode
178: update msc_questions_b
179: set package_name = x_package_name
180: where question_code = x_question_code;
181: msc_util.msc_debug('Updated msc_questions_b:' || to_char(sql%rowcount) ||
182: ':'|| x_question_code ||'with package name value:' ||

Line 181: msc_util.msc_debug('Updated msc_questions_b:' || to_char(sql%rowcount) ||

177: ELSIF (x_mode = 3) THEN -- update mode
178: update msc_questions_b
179: set package_name = x_package_name
180: where question_code = x_question_code;
181: msc_util.msc_debug('Updated msc_questions_b:' || to_char(sql%rowcount) ||
182: ':'|| x_question_code ||'with package name value:' ||
183: x_package_name);
184:
185: update msc_questions_tl

Line 188: from msc_questions_b

184:
185: update msc_questions_tl
186: set user_question_name = x_question
187: where question_id = (select question_id
188: from msc_questions_b
189: where question_code = x_question_code)
190: and language = x_lang_code;
191: msc_util.msc_debug('Updated msc_questions_tl:' || to_char(sql%rowcount) ||
192: ':' || x_question_code || 'with user question:' ||

Line 197: from msc_questions_b

193: x_question);
194: ELSIF (x_mode = 4) THEN -- delete mode
195: delete msc_questions_tl
196: where question_id = (select question_id
197: from msc_questions_b
198: where question_code = x_question_code);
199: msc_util.msc_debug('Deleted msc_questions_tl:'|| to_char(sql%rowcount) ||
200: ':' || x_question_code);
201:

Line 202: delete msc_questions_b

198: where question_code = x_question_code);
199: msc_util.msc_debug('Deleted msc_questions_tl:'|| to_char(sql%rowcount) ||
200: ':' || x_question_code);
201:
202: delete msc_questions_b
203: where question_code = x_question_code;
204: msc_util.msc_debug('Deleted msc_questions_b:'|| to_char(sql%rowcount) ||
205: ':' || x_question_code);
206: END IF;

Line 204: msc_util.msc_debug('Deleted msc_questions_b:'|| to_char(sql%rowcount) ||

200: ':' || x_question_code);
201:
202: delete msc_questions_b
203: where question_code = x_question_code;
204: msc_util.msc_debug('Deleted msc_questions_b:'|| to_char(sql%rowcount) ||
205: ':' || x_question_code);
206: END IF;
207: COMMIT WORK;
208: retcode := 0;

Line 259: FROM msc_questions_b

255: -- Call the appropriate procedure to process this questions
256: x_stmt_num := 30;
257: SELECT NVL(package_name,'MSC_ASK_ORACLE'), question_code
258: INTO x_pkg_name, x_question_code
259: FROM msc_questions_b
260: WHERE question_id = x_question_id;
261:
262: x_stmt_num := 40;
263: v_sql_stmt := 'BEGIN' || ' ' ||