DBA Data[Home] [Help]

APPS.AMS_TEMPLATE_ATTR_PVT dependencies on FND_GLOBAL

Line 107: IF FND_GLOBAL.User_Id IS NULL

103: -- =========================================================================
104: -- Validate Environment
105: -- =========================================================================
106:
107: IF FND_GLOBAL.User_Id IS NULL
108: THEN
109: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
110: RAISE FND_API.G_EXC_ERROR;
111: END IF;

Line 156: fnd_global.user_id,

152: ) VALUES (
153: DECODE( l_template_attribute_id, FND_API.g_miss_num, NULL, l_template_attribute_id),
154: DECODE( p_template_attr_rec.template_id, FND_API.g_miss_num, NULL, p_template_attr_rec.template_id),
155: sysdate,
156: fnd_global.user_id,
157: SYSDATE,
158: fnd_global.user_id,
159: l_object_version_number,
160: FND_GLOBAL.CONC_LOGIN_ID,

Line 158: fnd_global.user_id,

154: DECODE( p_template_attr_rec.template_id, FND_API.g_miss_num, NULL, p_template_attr_rec.template_id),
155: sysdate,
156: fnd_global.user_id,
157: SYSDATE,
158: fnd_global.user_id,
159: l_object_version_number,
160: FND_GLOBAL.CONC_LOGIN_ID,
161: DECODE( p_template_attr_rec.parent_attribute_code, FND_API.g_miss_char, NULL, p_template_attr_rec.parent_attribute_code),
162: DECODE( p_template_attr_rec.parent_select_all, FND_API.g_miss_char, NULL, p_template_attr_rec.parent_select_all),

Line 160: FND_GLOBAL.CONC_LOGIN_ID,

156: fnd_global.user_id,
157: SYSDATE,
158: fnd_global.user_id,
159: l_object_version_number,
160: FND_GLOBAL.CONC_LOGIN_ID,
161: DECODE( p_template_attr_rec.parent_attribute_code, FND_API.g_miss_char, NULL, p_template_attr_rec.parent_attribute_code),
162: DECODE( p_template_attr_rec.parent_select_all, FND_API.g_miss_char, NULL, p_template_attr_rec.parent_select_all),
163: DECODE( p_template_attr_rec.attribute_code, FND_API.g_miss_char, NULL, p_template_attr_rec.attribute_code),
164: DECODE( p_template_attr_rec.default_flag, FND_API.g_miss_char, NULL, p_template_attr_rec.default_flag),

Line 377: last_updated_by = fnd_global.user_id,

373: Update AMS_PROD_TEMPLATE_ATTR
374: SET template_attribute_id = DECODE( l_template_attr_rec.template_attribute_id, FND_API.g_miss_num, template_attribute_id, l_template_attr_rec.template_attribute_id),
375: template_id = DECODE( l_template_attr_rec.template_id, FND_API.g_miss_num, template_id, l_template_attr_rec.template_id),
376: last_update_date = sysdate,
377: last_updated_by = fnd_global.user_id,
378: object_version_number = l_template_attr_rec.object_version_number + 1,
379: last_update_login = FND_GLOBAL.CONC_LOGIN_ID,
380: parent_attribute_code = DECODE( l_template_attr_rec.parent_attribute_code, FND_API.g_miss_char, parent_attribute_code, l_template_attr_rec.parent_attribute_code),
381: --parent_select_all = DECODE( l_template_attr_rec.parent_select_all, FND_API.g_miss_char, 'N', l_template_attr_rec.parent_select_all),

Line 379: last_update_login = FND_GLOBAL.CONC_LOGIN_ID,

375: template_id = DECODE( l_template_attr_rec.template_id, FND_API.g_miss_num, template_id, l_template_attr_rec.template_id),
376: last_update_date = sysdate,
377: last_updated_by = fnd_global.user_id,
378: object_version_number = l_template_attr_rec.object_version_number + 1,
379: last_update_login = FND_GLOBAL.CONC_LOGIN_ID,
380: parent_attribute_code = DECODE( l_template_attr_rec.parent_attribute_code, FND_API.g_miss_char, parent_attribute_code, l_template_attr_rec.parent_attribute_code),
381: --parent_select_all = DECODE( l_template_attr_rec.parent_select_all, FND_API.g_miss_char, 'N', l_template_attr_rec.parent_select_all),
382: attribute_code = DECODE( l_template_attr_rec.attribute_code, FND_API.g_miss_char, attribute_code, l_template_attr_rec.attribute_code),
383: default_flag = DECODE( l_template_attr_rec.default_flag, FND_API.g_miss_char,'N', l_template_attr_rec.default_flag),

Line 426: , last_updated_by = fnd_global.user_id

422:
423: UPDATE ams_prod_template_attr
424: SET parent_select_all = l_template_attr_rec.parent_select_all
425: , last_update_date = sysdate
426: , last_updated_by = fnd_global.user_id
427: , last_update_login = FND_GLOBAL.CONC_LOGIN_ID
428: --, object_version_number = object_version_number + 1
429: WHERE template_id = l_template_attr_rec.template_id
430: AND parent_attribute_code = l_template_attr_rec.parent_attribute_code;

Line 427: , last_update_login = FND_GLOBAL.CONC_LOGIN_ID

423: UPDATE ams_prod_template_attr
424: SET parent_select_all = l_template_attr_rec.parent_select_all
425: , last_update_date = sysdate
426: , last_updated_by = fnd_global.user_id
427: , last_update_login = FND_GLOBAL.CONC_LOGIN_ID
428: --, object_version_number = object_version_number + 1
429: WHERE template_id = l_template_attr_rec.template_id
430: AND parent_attribute_code = l_template_attr_rec.parent_attribute_code;
431: