APPS.PA_PROJECT_SETS_PKG dependencies on FND_GLOBAL

Line 97: ,fnd_global.user_id

93: ,p_attribute14
94: ,p_attribute15
95: ,1
96: ,sysdate
97: ,fnd_global.user_id
98: ,sysdate
99: ,fnd_global.user_id
100: ,fnd_global.login_id
101: )

Line 99: ,fnd_global.user_id

95: ,1
96: ,sysdate
97: ,fnd_global.user_id
98: ,sysdate
99: ,fnd_global.user_id
100: ,fnd_global.login_id
101: )
102: RETURNING project_set_id INTO x_project_set_id;
103:

Line 100: ,fnd_global.login_id

96: ,sysdate
97: ,fnd_global.user_id
98: ,sysdate
99: ,fnd_global.user_id
100: ,fnd_global.login_id
101: )
102: RETURNING project_set_id INTO x_project_set_id;
103:
104: INSERT INTO pa_project_sets_tl

Line 122: ,fnd_global.user_id

118: ,userenv('LANG')
119: ,p_project_set_name
120: ,p_description
121: ,sysdate
122: ,fnd_global.user_id
123: ,sysdate
124: ,fnd_global.user_id
125: ,fnd_global.login_id
126: FROM fnd_languages L

Line 124: ,fnd_global.user_id

120: ,p_description
121: ,sysdate
122: ,fnd_global.user_id
123: ,sysdate
124: ,fnd_global.user_id
125: ,fnd_global.login_id
126: FROM fnd_languages L
127: WHERE l.installed_flag IN ('I', 'B')
128: AND NOT EXISTS

Line 125: ,fnd_global.login_id

121: ,sysdate
122: ,fnd_global.user_id
123: ,sysdate
124: ,fnd_global.user_id
125: ,fnd_global.login_id
126: FROM fnd_languages L
127: WHERE l.installed_flag IN ('I', 'B')
128: AND NOT EXISTS
129: (select null

Line 212: ,last_updated_by = fnd_global.user_id

208: ,attribute13 = decode(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13)
209: ,attribute14 = decode(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14)
210: ,attribute15 = decode(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15)
211: ,last_update_date = sysdate
212: ,last_updated_by = fnd_global.user_id
213: ,last_update_login = fnd_global.login_id
214: WHERE project_set_id = p_project_set_id
215: AND record_version_number = nvl(p_record_version_number, record_version_number);
216:

Line 213: ,last_update_login = fnd_global.login_id

209: ,attribute14 = decode(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14)
210: ,attribute15 = decode(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15)
211: ,last_update_date = sysdate
212: ,last_updated_by = fnd_global.user_id
213: ,last_update_login = fnd_global.login_id
214: WHERE project_set_id = p_project_set_id
215: AND record_version_number = nvl(p_record_version_number, record_version_number);
216:
217: IF (sql%notfound) THEN

Line 227: ,last_updated_by = fnd_global.user_id

223: UPDATE pa_project_sets_tl
224: SET name = decode(p_project_set_name, FND_API.G_MISS_CHAR, name, p_project_set_name)
225: ,description = decode(p_description, FND_API.G_MISS_CHAR, description, p_description)
226: ,last_update_date = sysdate
227: ,last_updated_by = fnd_global.user_id
228: ,last_update_login = fnd_global.login_id
229: WHERE project_set_id = p_project_set_id
230: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG);
231:

Line 228: ,last_update_login = fnd_global.login_id

224: SET name = decode(p_project_set_name, FND_API.G_MISS_CHAR, name, p_project_set_name)
225: ,description = decode(p_description, FND_API.G_MISS_CHAR, description, p_description)
226: ,last_update_date = sysdate
227: ,last_updated_by = fnd_global.user_id
228: ,last_update_login = fnd_global.login_id
229: WHERE project_set_id = p_project_set_id
230: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG);
231:
232: IF (sql%notfound) THEN

Line 322: ,fnd_global.user_id

318: ,last_update_login)
319: VALUES ( p_project_set_id
320: ,p_project_id
321: ,sysdate
322: ,fnd_global.user_id
323: ,sysdate
324: ,fnd_global.user_id
325: ,fnd_global.login_id);
326:

Line 324: ,fnd_global.user_id

320: ,p_project_id
321: ,sysdate
322: ,fnd_global.user_id
323: ,sysdate
324: ,fnd_global.user_id
325: ,fnd_global.login_id);
326:
327: -- Put any message text from message stack into the Message ARRAY
328: EXCEPTION

Line 325: ,fnd_global.login_id);

321: ,sysdate
322: ,fnd_global.user_id
323: ,sysdate
324: ,fnd_global.user_id
325: ,fnd_global.login_id);
326:
327: -- Put any message text from message stack into the Message ARRAY
328: EXCEPTION
329: WHEN OTHERS THEN