DBA Data[Home] [Help]

APPS.PA_TEAM_TEMPLATES_PKG dependencies on FND_GLOBAL

Line 117: ,fnd_global.user_id

113: ,DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13)
114: ,DECODE(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14)
115: ,DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15)
116: ,sysdate
117: ,fnd_global.user_id
118: ,sysdate
119: ,fnd_global.user_id
120: ,fnd_global.login_id
121: );

Line 119: ,fnd_global.user_id

115: ,DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15)
116: ,sysdate
117: ,fnd_global.user_id
118: ,sysdate
119: ,fnd_global.user_id
120: ,fnd_global.login_id
121: );
122:
123: EXCEPTION

Line 120: ,fnd_global.login_id

116: ,sysdate
117: ,fnd_global.user_id
118: ,sysdate
119: ,fnd_global.user_id
120: ,fnd_global.login_id
121: );
122:
123: EXCEPTION
124: WHEN OTHERS THEN -- catch the exceptions here

Line 213: ,last_updated_by = fnd_global.user_id

209: ,attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13)
210: ,attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14)
211: ,attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15)
212: ,last_update_date = sysdate
213: ,last_updated_by = fnd_global.user_id
214: ,last_update_login = fnd_global.login_id
215: WHERE team_template_id = p_team_template_id
216: AND record_version_number = p_record_version_number
217: AND nvl(workflow_in_progress_flag, 'N') <> 'Y';

Line 214: ,last_update_login = fnd_global.login_id

210: ,attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14)
211: ,attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15)
212: ,last_update_date = sysdate
213: ,last_updated_by = fnd_global.user_id
214: ,last_update_login = fnd_global.login_id
215: WHERE team_template_id = p_team_template_id
216: AND record_version_number = p_record_version_number
217: AND nvl(workflow_in_progress_flag, 'N') <> 'Y';
218: