56: ,x_question_code
57: ,x_question_type
58: ,x_package_name
59: ,sysdate
60: ,fnd_global.user_id
61: ,sysdate
62: ,fnd_global.user_id
63: ,fnd_global.conc_login_id
64: FROM dual
58: ,x_package_name
59: ,sysdate
60: ,fnd_global.user_id
61: ,sysdate
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
59: ,sysdate
60: ,fnd_global.user_id
61: ,sysdate
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);
86: ,NULL
87: ,x_lang_code
88: ,NULL
89: ,sysdate
90: ,fnd_global.user_id
91: ,sysdate
92: ,fnd_global.user_id
93: ,fnd_global.conc_login_id
94: FROM dual
88: ,NULL
89: ,sysdate
90: ,fnd_global.user_id
91: ,sysdate
92: ,fnd_global.user_id
93: ,fnd_global.conc_login_id
94: FROM dual
95: WHERE not exists
96: (select 'already exists'
89: ,sysdate
90: ,fnd_global.user_id
91: ,sysdate
92: ,fnd_global.user_id
93: ,fnd_global.conc_login_id
94: FROM dual
95: WHERE not exists
96: (select 'already exists'
97: from msc_questions_tl
124: ,x_question_code
125: ,q.question_type
126: ,q.package_name
127: ,sysdate
128: ,fnd_global.user_id
129: ,sysdate
130: ,fnd_global.user_id
131: ,fnd_global.conc_login_id
132: FROM msc_questions_b q
126: ,q.package_name
127: ,sysdate
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'
127: ,sysdate
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
155: ,NULL
156: ,x_lang_code
157: ,NULL
158: ,sysdate
159: ,fnd_global.user_id
160: ,sysdate
161: ,fnd_global.user_id
162: ,fnd_global.conc_login_id
163: FROM msc_questions_tl q
157: ,NULL
158: ,sysdate
159: ,fnd_global.user_id
160: ,sysdate
161: ,fnd_global.user_id
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
158: ,sysdate
159: ,fnd_global.user_id
160: ,sysdate
161: ,fnd_global.user_id
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
360: seq,
361: USERENV('SESSIONID'),
362: ans,
363: sysdate,
364: FND_GLOBAL.USER_ID,
365: sysdate,
366: FND_GLOBAL.USER_ID
367: FROM sys.dual;
368:
362: ans,
363: sysdate,
364: FND_GLOBAL.USER_ID,
365: sysdate,
366: FND_GLOBAL.USER_ID
367: FROM sys.dual;
368:
369: return;
370: EXCEPTION