DBA Data[Home] [Help]

APPS.AMS_CAL_CRT_PVT dependencies on FND_GLOBAL

Line 24: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

20: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
21:
22: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Cal_Crt_PVT';
23: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvcctb.pls';
24: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
25: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
26:
27: PROCEDURE Default_Cal_Crt_Rec_Items (
28: p_cal_crt_rec_rec IN cal_crt_rec_rec_type ,

Line 25: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

21:
22: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Cal_Crt_PVT';
23: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvcctb.pls';
24: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
25: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
26:
27: PROCEDURE Default_Cal_Crt_Rec_Items (
28: p_cal_crt_rec_rec IN cal_crt_rec_rec_type ,
29: x_cal_crt_rec_rec OUT NOCOPY cal_crt_rec_rec_type

Line 120: IF FND_GLOBAL.USER_ID IS NULL

116:
117: -- =========================================================================
118: -- Validate Environment
119: -- =========================================================================
120: IF FND_GLOBAL.USER_ID IS NULL
121: THEN
122: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
123: RAISE FND_API.G_EXC_ERROR;
124: END IF;

Line 135: l_cal_crt_rec_rec.last_updated_by := FND_GLOBAL.user_id;

131: AMS_UTILITY_PVT.debug_message('Private API: Validate_Cal_Crt');
132: END IF;
133: -- Charu: Populate the default required items.
134: l_cal_crt_rec_rec.last_update_date := SYSDATE;
135: l_cal_crt_rec_rec.last_updated_by := FND_GLOBAL.user_id;
136: l_cal_crt_rec_rec.creation_date := SYSDATE;
137: l_cal_crt_rec_rec.created_by := FND_GLOBAL.user_id;
138: l_cal_crt_rec_rec.last_update_login := FND_GLOBAL.conc_login_id;
139: l_cal_crt_rec_rec.object_version_number := l_object_version_number;

Line 137: l_cal_crt_rec_rec.created_by := FND_GLOBAL.user_id;

133: -- Charu: Populate the default required items.
134: l_cal_crt_rec_rec.last_update_date := SYSDATE;
135: l_cal_crt_rec_rec.last_updated_by := FND_GLOBAL.user_id;
136: l_cal_crt_rec_rec.creation_date := SYSDATE;
137: l_cal_crt_rec_rec.created_by := FND_GLOBAL.user_id;
138: l_cal_crt_rec_rec.last_update_login := FND_GLOBAL.conc_login_id;
139: l_cal_crt_rec_rec.object_version_number := l_object_version_number;
140: -- Invoke validation procedures
141: Validate_cal_crt(

Line 138: l_cal_crt_rec_rec.last_update_login := FND_GLOBAL.conc_login_id;

134: l_cal_crt_rec_rec.last_update_date := SYSDATE;
135: l_cal_crt_rec_rec.last_updated_by := FND_GLOBAL.user_id;
136: l_cal_crt_rec_rec.creation_date := SYSDATE;
137: l_cal_crt_rec_rec.created_by := FND_GLOBAL.user_id;
138: l_cal_crt_rec_rec.last_update_login := FND_GLOBAL.conc_login_id;
139: l_cal_crt_rec_rec.object_version_number := l_object_version_number;
140: -- Invoke validation procedures
141: Validate_cal_crt(
142: p_api_version_number => 1.0,

Line 191: p_last_updated_by => FND_GLOBAL.USER_ID,

187: p_criteria_end_date => l_cal_crt_rec_rec.criteria_end_date,
188: p_criteria_deleted => l_cal_crt_rec_rec.criteria_deleted,
189: p_criteria_enabled => l_cal_crt_rec_rec.criteria_enabled,
190: p_last_update_date => SYSDATE,
191: p_last_updated_by => FND_GLOBAL.USER_ID,
192: p_creation_date => SYSDATE,
193: p_created_by => FND_GLOBAL.USER_ID,
194: p_last_update_login => FND_GLOBAL.conc_login_id,
195: px_object_version_number => l_object_version_number

Line 193: p_created_by => FND_GLOBAL.USER_ID,

189: p_criteria_enabled => l_cal_crt_rec_rec.criteria_enabled,
190: p_last_update_date => SYSDATE,
191: p_last_updated_by => FND_GLOBAL.USER_ID,
192: p_creation_date => SYSDATE,
193: p_created_by => FND_GLOBAL.USER_ID,
194: p_last_update_login => FND_GLOBAL.conc_login_id,
195: px_object_version_number => l_object_version_number
196: );
197:

Line 194: p_last_update_login => FND_GLOBAL.conc_login_id,

190: p_last_update_date => SYSDATE,
191: p_last_updated_by => FND_GLOBAL.USER_ID,
192: p_creation_date => SYSDATE,
193: p_created_by => FND_GLOBAL.USER_ID,
194: p_last_update_login => FND_GLOBAL.conc_login_id,
195: px_object_version_number => l_object_version_number
196: );
197:
198: x_criteria_id := l_criteria_id;

Line 340: l_tar_cal_crt_rec_rec.last_updated_by := FND_GLOBAL.user_id;

336: END IF;
337:
338: -- Charu added
339: l_tar_cal_crt_rec_rec.last_update_date := SYSDATE;
340: l_tar_cal_crt_rec_rec.last_updated_by := FND_GLOBAL.user_id;
341: l_tar_cal_crt_rec_rec.last_update_login := FND_GLOBAL.conc_login_id;
342: -- Initialize API return status to SUCCESS
343: x_return_status := FND_API.G_RET_STS_SUCCESS;
344: IF (AMS_DEBUG_HIGH_ON) THEN

Line 341: l_tar_cal_crt_rec_rec.last_update_login := FND_GLOBAL.conc_login_id;

337:
338: -- Charu added
339: l_tar_cal_crt_rec_rec.last_update_date := SYSDATE;
340: l_tar_cal_crt_rec_rec.last_updated_by := FND_GLOBAL.user_id;
341: l_tar_cal_crt_rec_rec.last_update_login := FND_GLOBAL.conc_login_id;
342: -- Initialize API return status to SUCCESS
343: x_return_status := FND_API.G_RET_STS_SUCCESS;
344: IF (AMS_DEBUG_HIGH_ON) THEN
345: AMS_UTILITY_PVT.debug_message('l_tar_cal_crt_rec_rec.criteria_deleted: ' || l_tar_cal_crt_rec_rec.criteria_deleted);

Line 436: p_last_updated_by => FND_GLOBAL.USER_ID,

432: p_criteria_end_date => l_tar_cal_crt_rec_rec.criteria_end_date,
433: p_criteria_deleted => l_tar_cal_crt_rec_rec.criteria_deleted,
434: p_criteria_enabled => l_tar_cal_crt_rec_rec.criteria_enabled,
435: p_last_update_date => SYSDATE,
436: p_last_updated_by => FND_GLOBAL.USER_ID,
437: p_last_update_login => FND_GLOBAL.conc_login_id,
438: p_object_version_number => l_tar_cal_crt_rec_rec.object_version_number
439: );
440: --

Line 437: p_last_update_login => FND_GLOBAL.conc_login_id,

433: p_criteria_deleted => l_tar_cal_crt_rec_rec.criteria_deleted,
434: p_criteria_enabled => l_tar_cal_crt_rec_rec.criteria_enabled,
435: p_last_update_date => SYSDATE,
436: p_last_updated_by => FND_GLOBAL.USER_ID,
437: p_last_update_login => FND_GLOBAL.conc_login_id,
438: p_object_version_number => l_tar_cal_crt_rec_rec.object_version_number
439: );
440: --
441: -- End of API body.