DBA Data[Home] [Help]

APPS.AMS_DM_TARGET_SOURCES_PVT dependencies on FND_GLOBAL

Line 23: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

19:
20: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Dm_Target_Sources_PVT';
21: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvdtsb.pls';
22:
23: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
24: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
25:
26: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
27: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line 24: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

20: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Dm_Target_Sources_PVT';
21: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvdtsb.pls';
22:
23: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
24: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
25:
26: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
27: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
28: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

Line 138: IF FND_GLOBAL.USER_ID IS NULL

134: -- =========================================================================
135: -- Validate Environment
136: -- =========================================================================
137:
138: IF FND_GLOBAL.USER_ID IS NULL
139: THEN
140: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
141: RAISE FND_API.G_EXC_ERROR;
142: END IF;

Line 190: p_last_updated_by => FND_GLOBAL.USER_ID,

186: -- Invoke table handler(Ams_Dm_Target_Sources_Pkg.Insert_Row)
187: Ams_Dm_Target_Sources_Pkg.Insert_Row(
188: px_target_source_id => l_target_source_rec.target_source_id,
189: p_last_update_date => SYSDATE,
190: p_last_updated_by => FND_GLOBAL.USER_ID,
191: p_creation_date => SYSDATE,
192: p_created_by => FND_GLOBAL.USER_ID,
193: p_last_update_login => FND_GLOBAL.conc_login_id,
194: px_object_version_number => l_object_version_number,

Line 192: p_created_by => FND_GLOBAL.USER_ID,

188: px_target_source_id => l_target_source_rec.target_source_id,
189: p_last_update_date => SYSDATE,
190: p_last_updated_by => FND_GLOBAL.USER_ID,
191: p_creation_date => SYSDATE,
192: p_created_by => FND_GLOBAL.USER_ID,
193: p_last_update_login => FND_GLOBAL.conc_login_id,
194: px_object_version_number => l_object_version_number,
195: p_target_id => l_target_source_rec.target_id,
196: p_data_source_id => l_target_source_rec.data_source_id

Line 193: p_last_update_login => FND_GLOBAL.conc_login_id,

189: p_last_update_date => SYSDATE,
190: p_last_updated_by => FND_GLOBAL.USER_ID,
191: p_creation_date => SYSDATE,
192: p_created_by => FND_GLOBAL.USER_ID,
193: p_last_update_login => FND_GLOBAL.conc_login_id,
194: px_object_version_number => l_object_version_number,
195: p_target_id => l_target_source_rec.target_id,
196: p_data_source_id => l_target_source_rec.data_source_id
197: );

Line 424: p_last_updated_by => FND_GLOBAL.USER_ID,

420: -- Invoke table handler(Ams_Dm_Target_Sources_Pkg.Update_Row)
421: Ams_Dm_Target_Sources_Pkg.Update_Row(
422: p_target_source_id => p_target_source_rec_type_rec.target_source_id,
423: p_last_update_date => SYSDATE,
424: p_last_updated_by => FND_GLOBAL.USER_ID,
425: p_last_update_login => FND_GLOBAL.conc_login_id,
426: p_object_version_number => l_new_object_version_number,
427: p_target_id => p_target_source_rec_type_rec.target_id,
428: p_data_source_id => p_target_source_rec_type_rec.data_source_id

Line 425: p_last_update_login => FND_GLOBAL.conc_login_id,

421: Ams_Dm_Target_Sources_Pkg.Update_Row(
422: p_target_source_id => p_target_source_rec_type_rec.target_source_id,
423: p_last_update_date => SYSDATE,
424: p_last_updated_by => FND_GLOBAL.USER_ID,
425: p_last_update_login => FND_GLOBAL.conc_login_id,
426: p_object_version_number => l_new_object_version_number,
427: p_target_id => p_target_source_rec_type_rec.target_id,
428: p_data_source_id => p_target_source_rec_type_rec.data_source_id
429: );