51: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_DMSource_PVT';
52: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvdsrb.pls';
53:
54: /***
55: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
56: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
57: ***/
58:
59:
52: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvdsrb.pls';
53:
54: /***
55: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
56: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
57: ***/
58:
59:
60: --
396: BEGIN
397: ams_dm_source_PKG.Insert_Row(
398: px_SOURCE_ID => l_SOURCE_ID,
399: p_LAST_UPDATE_DATE => SYSDATE,
400: p_LAST_UPDATED_BY => FND_GLOBAL.user_id,
401: p_CREATION_DATE => SYSDATE,
402: p_CREATED_BY => FND_GLOBAL.user_id,
403: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
404: px_OBJECT_VERSION_NUMBER => l_object_version_number,
398: px_SOURCE_ID => l_SOURCE_ID,
399: p_LAST_UPDATE_DATE => SYSDATE,
400: p_LAST_UPDATED_BY => FND_GLOBAL.user_id,
401: p_CREATION_DATE => SYSDATE,
402: p_CREATED_BY => FND_GLOBAL.user_id,
403: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
404: px_OBJECT_VERSION_NUMBER => l_object_version_number,
405: p_MODEL_TYPE => p_source_rec.model_type,
406: p_ARC_USED_FOR_OBJECT => p_source_rec.arc_used_for_object,
399: p_LAST_UPDATE_DATE => SYSDATE,
400: p_LAST_UPDATED_BY => FND_GLOBAL.user_id,
401: p_CREATION_DATE => SYSDATE,
402: p_CREATED_BY => FND_GLOBAL.user_id,
403: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
404: px_OBJECT_VERSION_NUMBER => l_object_version_number,
405: p_MODEL_TYPE => p_source_rec.model_type,
406: p_ARC_USED_FOR_OBJECT => p_source_rec.arc_used_for_object,
407: p_USED_FOR_OBJECT_ID => p_source_rec.used_for_object_id,
608: -- Invoke table handler(ams_dm_source_PKG.Update_Row)
609: ams_dm_source_PKG.Update_Row(
610: p_source_id => p_source_rec.source_id,
611: p_last_update_date => SYSDATE,
612: p_last_updated_by => FND_GLOBAL.user_id,
613: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
614: p_object_version_number => p_source_rec.object_version_number + 1,
615: p_model_type => p_source_rec.model_type,
616: p_arc_used_for_object => p_source_rec.arc_used_for_object,
609: ams_dm_source_PKG.Update_Row(
610: p_source_id => p_source_rec.source_id,
611: p_last_update_date => SYSDATE,
612: p_last_updated_by => FND_GLOBAL.user_id,
613: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
614: p_object_version_number => p_source_rec.object_version_number + 1,
615: p_model_type => p_source_rec.model_type,
616: p_arc_used_for_object => p_source_rec.arc_used_for_object,
617: p_used_for_object_id => p_source_rec.used_for_object_id,