DBA Data[Home] [Help]

APPS.MSC_ASK_ORACLE dependencies on FND_GLOBAL

Line 60: ,fnd_global.user_id

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

Line 62: ,fnd_global.user_id

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

Line 63: ,fnd_global.conc_login_id

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);

Line 90: ,fnd_global.user_id

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

Line 92: ,fnd_global.user_id

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'

Line 93: ,fnd_global.conc_login_id

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

Line 128: ,fnd_global.user_id

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

Line 130: ,fnd_global.user_id

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'

Line 131: ,fnd_global.conc_login_id

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

Line 159: ,fnd_global.user_id

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

Line 161: ,fnd_global.user_id

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

Line 162: ,fnd_global.conc_login_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

Line 364: FND_GLOBAL.USER_ID,

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:

Line 366: FND_GLOBAL.USER_ID

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