DBA Data[Home] [Help]

APPS.AMS_PS_POSTING_PVT dependencies on FND_GLOBAL

Line 94: IF FND_GLOBAL.User_Id IS NULL

90: -- ==============================================================
91: -- Validate Environment
92: -- ==============================================================
93:
94: IF FND_GLOBAL.User_Id IS NULL
95: THEN
96: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
97: RAISE FND_API.G_EXC_ERROR;
98: END IF;

Line 150: p_created_by => FND_GLOBAL.user_id,

146:
147:
148: -- Invoke table handler(AMS_IBA_PS_POSTINGS_B_PKG.Insert_Row)
149: AMS_IBA_PS_POSTINGS_B_PKG.Insert_Row(
150: p_created_by => FND_GLOBAL.user_id,
151: p_creation_date => SYSDATE,
152: p_last_updated_by => FND_GLOBAL.user_id,
153: p_last_update_date => SYSDATE,
154: p_last_update_login => FND_GLOBAL.conc_login_id,

Line 152: p_last_updated_by => FND_GLOBAL.user_id,

148: -- Invoke table handler(AMS_IBA_PS_POSTINGS_B_PKG.Insert_Row)
149: AMS_IBA_PS_POSTINGS_B_PKG.Insert_Row(
150: p_created_by => FND_GLOBAL.user_id,
151: p_creation_date => SYSDATE,
152: p_last_updated_by => FND_GLOBAL.user_id,
153: p_last_update_date => SYSDATE,
154: p_last_update_login => FND_GLOBAL.conc_login_id,
155: px_object_version_number => l_object_version_number,
156: px_posting_id => l_posting_id,

Line 154: p_last_update_login => FND_GLOBAL.conc_login_id,

150: p_created_by => FND_GLOBAL.user_id,
151: p_creation_date => SYSDATE,
152: p_last_updated_by => FND_GLOBAL.user_id,
153: p_last_update_date => SYSDATE,
154: p_last_update_login => FND_GLOBAL.conc_login_id,
155: px_object_version_number => l_object_version_number,
156: px_posting_id => l_posting_id,
157: p_max_no_contents => p_ps_posting_rec.max_no_contents,
158: p_posting_type => p_ps_posting_rec.posting_type,

Line 365: last_updated_by = FND_GLOBAL.user_id,

361: END IF;
362:
363: Update AMS_IBA_PS_POSTINGS_B
364: SET
365: last_updated_by = FND_GLOBAL.user_id,
366: last_update_date = SYSDATE,
367: last_update_login = FND_GLOBAL.conc_login_id,
368: object_version_number = p_ps_posting_rec.object_version_number+1,
369: max_no_contents = DECODE( p_ps_posting_rec.max_no_contents, FND_API.g_miss_num, max_no_contents, p_ps_posting_rec.max_no_contents),

Line 367: last_update_login = FND_GLOBAL.conc_login_id,

363: Update AMS_IBA_PS_POSTINGS_B
364: SET
365: last_updated_by = FND_GLOBAL.user_id,
366: last_update_date = SYSDATE,
367: last_update_login = FND_GLOBAL.conc_login_id,
368: object_version_number = p_ps_posting_rec.object_version_number+1,
369: max_no_contents = DECODE( p_ps_posting_rec.max_no_contents, FND_API.g_miss_num, max_no_contents, p_ps_posting_rec.max_no_contents),
370: posting_type = DECODE( p_ps_posting_rec.posting_type, FND_API.g_miss_char, posting_type, p_ps_posting_rec.posting_type),
371: content_type = DECODE( p_ps_posting_rec.content_type, FND_API.g_miss_char, content_type, p_ps_posting_rec.content_type),

Line 432: last_updated_by = FND_GLOBAL.user_id,

428: posting_name = decode( p_ps_posting_rec.posting_name, FND_API.G_MISS_CHAR, posting_name, p_ps_posting_rec.posting_name),
429: display_name = decode( p_ps_posting_rec.display_name, FND_API.G_MISS_CHAR, display_name, p_ps_posting_rec.display_name),
430: posting_description = decode( p_ps_posting_rec.posting_description, FND_API.G_MISS_CHAR, posting_description, p_ps_posting_rec.posting_description),
431: last_update_date = SYSDATE,
432: last_updated_by = FND_GLOBAL.user_id,
433: last_update_login = FND_GLOBAL.conc_login_id,
434: source_lang = USERENV('LANG')
435: WHERE posting_id = p_ps_posting_rec.posting_id
436: AND USERENV('LANG') IN (language, source_lang);

Line 433: last_update_login = FND_GLOBAL.conc_login_id,

429: display_name = decode( p_ps_posting_rec.display_name, FND_API.G_MISS_CHAR, display_name, p_ps_posting_rec.display_name),
430: posting_description = decode( p_ps_posting_rec.posting_description, FND_API.G_MISS_CHAR, posting_description, p_ps_posting_rec.posting_description),
431: last_update_date = SYSDATE,
432: last_updated_by = FND_GLOBAL.user_id,
433: last_update_login = FND_GLOBAL.conc_login_id,
434: source_lang = USERENV('LANG')
435: WHERE posting_id = p_ps_posting_rec.posting_id
436: AND USERENV('LANG') IN (language, source_lang);
437: