[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
X_Asset_Id IN OUT NOCOPY NUMBER,
X_Asset_Number IN OUT NOCOPY VARCHAR2,
X_Asset_Key_Ccid NUMBER DEFAULT NULL,
X_Current_Units NUMBER,
X_Asset_Type VARCHAR2,
X_Tag_Number VARCHAR2 DEFAULT NULL,
X_Description VARCHAR2,
X_Asset_Category_Id NUMBER,
X_Parent_Asset_Id NUMBER DEFAULT NULL,
X_Manufacturer_Name VARCHAR2 DEFAULT NULL,
X_Serial_Number VARCHAR2 DEFAULT NULL,
X_Model_Number VARCHAR2 DEFAULT NULL,
X_Property_Type_Code VARCHAR2 DEFAULT NULL,
X_Property_1245_1250_Code VARCHAR2 DEFAULT NULL,
X_In_Use_Flag VARCHAR2,
X_Owned_Leased VARCHAR2,
X_New_Used VARCHAR2,
X_Unit_Adjustment_Flag VARCHAR2,
X_Add_Cost_Je_Flag VARCHAR2,
X_Attribute1 VARCHAR2 DEFAULT NULL,
X_Attribute2 VARCHAR2 DEFAULT NULL,
X_Attribute3 VARCHAR2 DEFAULT NULL,
X_Attribute4 VARCHAR2 DEFAULT NULL,
X_Attribute5 VARCHAR2 DEFAULT NULL,
X_Attribute6 VARCHAR2 DEFAULT NULL,
X_Attribute7 VARCHAR2 DEFAULT NULL,
X_Attribute8 VARCHAR2 DEFAULT NULL,
X_Attribute9 VARCHAR2 DEFAULT NULL,
X_Attribute10 VARCHAR2 DEFAULT NULL,
X_Attribute11 VARCHAR2 DEFAULT NULL,
X_Attribute12 VARCHAR2 DEFAULT NULL,
X_Attribute13 VARCHAR2 DEFAULT NULL,
X_Attribute14 VARCHAR2 DEFAULT NULL,
X_Attribute15 VARCHAR2 DEFAULT NULL,
X_Attribute16 VARCHAR2 DEFAULT NULL,
X_Attribute17 VARCHAR2 DEFAULT NULL,
X_Attribute18 VARCHAR2 DEFAULT NULL,
X_Attribute19 VARCHAR2 DEFAULT NULL,
X_Attribute20 VARCHAR2 DEFAULT NULL,
X_Attribute21 VARCHAR2 DEFAULT NULL,
X_Attribute22 VARCHAR2 DEFAULT NULL,
X_Attribute23 VARCHAR2 DEFAULT NULL,
X_Attribute24 VARCHAR2 DEFAULT NULL,
X_Attribute25 VARCHAR2 DEFAULT NULL,
X_Attribute26 VARCHAR2 DEFAULT NULL,
X_Attribute27 VARCHAR2 DEFAULT NULL,
X_Attribute28 VARCHAR2 DEFAULT NULL,
X_Attribute29 VARCHAR2 DEFAULT NULL,
X_Attribute30 VARCHAR2 DEFAULT NULL,
X_Attribute_Category_Code VARCHAR2,
X_gf_Attribute1 VARCHAR2 DEFAULT NULL,
X_gf_Attribute2 VARCHAR2 DEFAULT NULL,
X_gf_Attribute3 VARCHAR2 DEFAULT NULL,
X_gf_Attribute4 VARCHAR2 DEFAULT NULL,
X_gf_Attribute5 VARCHAR2 DEFAULT NULL,
X_gf_Attribute6 VARCHAR2 DEFAULT NULL,
X_gf_Attribute7 VARCHAR2 DEFAULT NULL,
X_gf_Attribute8 VARCHAR2 DEFAULT NULL,
X_gf_Attribute9 VARCHAR2 DEFAULT NULL,
X_gf_Attribute10 VARCHAR2 DEFAULT NULL,
X_gf_Attribute11 VARCHAR2 DEFAULT NULL,
X_gf_Attribute12 VARCHAR2 DEFAULT NULL,
X_gf_Attribute13 VARCHAR2 DEFAULT NULL,
X_gf_Attribute14 VARCHAR2 DEFAULT NULL,
X_gf_Attribute15 VARCHAR2 DEFAULT NULL,
X_gf_Attribute16 VARCHAR2 DEFAULT NULL,
X_gf_Attribute17 VARCHAR2 DEFAULT NULL,
X_gf_Attribute18 VARCHAR2 DEFAULT NULL,
X_gf_Attribute19 VARCHAR2 DEFAULT NULL,
X_gf_Attribute20 VARCHAR2 DEFAULT NULL,
X_gf_Attribute_Category_Code VARCHAR2 DEFAULT NULL,
X_Context VARCHAR2 DEFAULT NULL,
X_Lease_Id NUMBER DEFAULT NULL,
X_Inventorial VARCHAR2,
X_Commitment VARCHAR2 DEFAULT NULL,
X_Investment_Law VARCHAR2 DEFAULT NULL,
X_Status VARCHAR2 DEFAULT NULL,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Created_By NUMBER DEFAULT NULL,
X_Creation_Date DATE DEFAULT NULL,
X_Last_Update_Login NUMBER DEFAULT NULL,
X_Calling_Fn VARCHAR2
, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
h_error_message varchar2(255);
CURSOR C IS SELECT rowid FROM fa_additions_B
WHERE asset_id = X_Asset_Id;
CURSOR C2 IS SELECT fa_additions_s.nextval FROM sys.dual;
INSERT INTO fa_additions_B(
asset_id,
asset_number,
asset_key_ccid,
current_units,
asset_type,
tag_number,
/* description, */
asset_category_id,
parent_asset_id,
manufacturer_name,
serial_number,
model_number,
property_type_code,
property_1245_1250_code,
in_use_flag,
owned_leased,
new_used,
unit_adjustment_flag,
add_cost_je_flag,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
attribute21,
attribute22,
attribute23,
attribute24,
attribute25,
attribute26,
attribute27,
attribute28,
attribute29,
attribute30,
attribute_category_code,
global_attribute1,
global_attribute2,
global_attribute3,
global_attribute4,
global_attribute5,
global_attribute6,
global_attribute7,
global_attribute8,
global_attribute9,
global_attribute10,
global_attribute11,
global_attribute12,
global_attribute13,
global_attribute14,
global_attribute15,
global_attribute16,
global_attribute17,
global_attribute18,
global_attribute19,
global_attribute20,
global_attribute_category,
context,
lease_id,
inventorial,
commitment,
investment_law,
last_update_date,
last_updated_by,
created_by,
creation_date,
last_update_login
) VALUES (
X_Asset_Id,
X_Asset_Number,
X_Asset_Key_Ccid,
X_Current_Units,
X_Asset_Type,
X_Tag_Number,
/* X_Description, */
X_Asset_Category_Id,
X_Parent_Asset_Id,
X_Manufacturer_Name,
X_Serial_Number,
X_Model_Number,
X_Property_Type_Code,
X_Property_1245_1250_Code,
X_In_Use_Flag,
X_Owned_Leased,
X_New_Used,
X_Unit_Adjustment_Flag,
X_Add_Cost_Je_Flag,
X_Attribute1,
X_Attribute2,
X_Attribute3,
X_Attribute4,
X_Attribute5,
X_Attribute6,
X_Attribute7,
X_Attribute8,
X_Attribute9,
X_Attribute10,
X_Attribute11,
X_Attribute12,
X_Attribute13,
X_Attribute14,
l_Attribute15,
X_Attribute16,
X_Attribute17,
X_Attribute18,
X_Attribute19,
X_Attribute20,
X_Attribute21,
X_Attribute22,
X_Attribute23,
X_Attribute24,
X_Attribute25,
X_Attribute26,
X_Attribute27,
X_Attribute28,
X_Attribute29,
X_Attribute30,
X_Attribute_Category_Code,
X_gf_Attribute1,
X_gf_Attribute2,
X_gf_Attribute3,
X_gf_Attribute4,
X_gf_Attribute5,
X_gf_Attribute6,
X_gf_Attribute7,
X_gf_Attribute8,
X_gf_Attribute9,
X_gf_Attribute10,
X_gf_Attribute11,
X_gf_Attribute12,
X_gf_Attribute13,
X_gf_Attribute14,
X_gf_Attribute15,
X_gf_Attribute16,
X_gf_Attribute17,
X_gf_Attribute18,
X_gf_Attribute19,
X_gf_Attribute20,
X_gf_Attribute_Category_Code,
X_Context,
X_Lease_Id,
X_Inventorial,
X_Commitment,
X_Investment_law,
X_Last_Update_Date,
X_Last_Updated_By,
X_Created_By,
X_Creation_Date,
X_Last_Update_Login
);
insert into FA_ADDITIONS_TL (
LAST_UPDATED_BY,
CREATED_BY,
CREATION_DATE,
LAST_UPDATE_LOGIN,
ASSET_ID,
DESCRIPTION,
LAST_UPDATE_DATE,
LANGUAGE,
SOURCE_LANG
) select
X_LAST_UPDATED_BY,
X_CREATED_BY,
X_CREATION_DATE,
X_LAST_UPDATE_LOGIN,
X_ASSET_ID,
X_DESCRIPTION,
X_LAST_UPDATE_DATE,
L.LANGUAGE_CODE,
userenv('LANG')
from FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I', 'B')
and not exists
(select NULL
from FA_ADDITIONS_TL T
where T.ASSET_ID = X_ASSET_ID
and T.LANGUAGE = L.LANGUAGE_CODE);
CALLING_FN => 'fa_additions_pkg.insert_row',
NAME => 'FA_ADD_ASSET_NUMBER_EXISTS',
TOKEN1 => 'ASSET_NUMBER',
VALUE1 => X_Asset_Number, p_log_level_rec => p_log_level_rec);
CALLING_FN => 'fa_additions_pkg.insert_row', p_log_level_rec => p_log_level_rec);
CALLING_FN => 'fa_additions_pkg.insert_row',
NAME => 'FA_ADD_TAG_NUMBER_EXISTS',
TOKEN1 => 'TAG_NUMBER',
VALUE1 => X_Tag_Number, p_log_level_rec => p_log_level_rec);
CALLING_FN => 'fa_additions_pkg.insert_row', p_log_level_rec => p_log_level_rec);
CALLING_FN => 'fa_additions_pkg.insert_row', p_log_level_rec => p_log_level_rec);
CALLING_FN => 'fa_additions_pkg.insert_row', p_log_level_rec => p_log_level_rec);
END Insert_Row;
SELECT *
FROM fa_additions_b
WHERE rowid = X_Rowid
FOR UPDATE of Asset_Id NOWAIT;
select description,decode(language,userenv('LANG'),'Y','N') BASELANG
from fa_additions_tl
where asset_id = x_asset_id
and userenv('LANG') in (LANGUAGE,SOURCE_LANG)
for update of asset_id nowait;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
PROCEDURE Update_Row(X_Rowid VARCHAR2 DEFAULT NULL,
X_Asset_Id NUMBER DEFAULT NULL,
X_Asset_Number VARCHAR2 DEFAULT NULL,
X_Asset_Key_Ccid NUMBER DEFAULT NULL,
X_Current_Units NUMBER DEFAULT NULL,
X_Asset_Type VARCHAR2 DEFAULT NULL,
X_Tag_Number VARCHAR2 DEFAULT NULL,
X_Description VARCHAR2 DEFAULT NULL,
X_Asset_Category_Id NUMBER DEFAULT NULL,
X_Parent_Asset_Id NUMBER DEFAULT NULL,
X_Manufacturer_Name VARCHAR2 DEFAULT NULL,
X_Serial_Number VARCHAR2 DEFAULT NULL,
X_Model_Number VARCHAR2 DEFAULT NULL,
X_Property_Type_Code VARCHAR2 DEFAULT NULL,
X_Property_1245_1250_Code VARCHAR2 DEFAULT NULL,
X_In_Use_Flag VARCHAR2 DEFAULT NULL,
X_Owned_Leased VARCHAR2 DEFAULT NULL,
X_New_Used VARCHAR2 DEFAULT NULL,
X_Unit_Adjustment_Flag VARCHAR2 DEFAULT NULL,
X_Add_Cost_Je_Flag VARCHAR2 DEFAULT NULL,
X_Attribute1 VARCHAR2 DEFAULT NULL,
X_Attribute2 VARCHAR2 DEFAULT NULL,
X_Attribute3 VARCHAR2 DEFAULT NULL,
X_Attribute4 VARCHAR2 DEFAULT NULL,
X_Attribute5 VARCHAR2 DEFAULT NULL,
X_Attribute6 VARCHAR2 DEFAULT NULL,
X_Attribute7 VARCHAR2 DEFAULT NULL,
X_Attribute8 VARCHAR2 DEFAULT NULL,
X_Attribute9 VARCHAR2 DEFAULT NULL,
X_Attribute10 VARCHAR2 DEFAULT NULL,
X_Attribute11 VARCHAR2 DEFAULT NULL,
X_Attribute12 VARCHAR2 DEFAULT NULL,
X_Attribute13 VARCHAR2 DEFAULT NULL,
X_Attribute14 VARCHAR2 DEFAULT NULL,
X_Attribute15 VARCHAR2 DEFAULT NULL,
X_Attribute16 VARCHAR2 DEFAULT NULL,
X_Attribute17 VARCHAR2 DEFAULT NULL,
X_Attribute18 VARCHAR2 DEFAULT NULL,
X_Attribute19 VARCHAR2 DEFAULT NULL,
X_Attribute20 VARCHAR2 DEFAULT NULL,
X_Attribute21 VARCHAR2 DEFAULT NULL,
X_Attribute22 VARCHAR2 DEFAULT NULL,
X_Attribute23 VARCHAR2 DEFAULT NULL,
X_Attribute24 VARCHAR2 DEFAULT NULL,
X_Attribute25 VARCHAR2 DEFAULT NULL,
X_Attribute26 VARCHAR2 DEFAULT NULL,
X_Attribute27 VARCHAR2 DEFAULT NULL,
X_Attribute28 VARCHAR2 DEFAULT NULL,
X_Attribute29 VARCHAR2 DEFAULT NULL,
X_Attribute30 VARCHAR2 DEFAULT NULL,
X_Attribute_Category_Code VARCHAR2 DEFAULT NULL,
X_gf_Attribute1 VARCHAR2 DEFAULT NULL,
X_gf_Attribute2 VARCHAR2 DEFAULT NULL,
X_gf_Attribute3 VARCHAR2 DEFAULT NULL,
X_gf_Attribute4 VARCHAR2 DEFAULT NULL,
X_gf_Attribute5 VARCHAR2 DEFAULT NULL,
X_gf_Attribute6 VARCHAR2 DEFAULT NULL,
X_gf_Attribute7 VARCHAR2 DEFAULT NULL,
X_gf_Attribute8 VARCHAR2 DEFAULT NULL,
X_gf_Attribute9 VARCHAR2 DEFAULT NULL,
X_gf_Attribute10 VARCHAR2 DEFAULT NULL,
X_gf_Attribute11 VARCHAR2 DEFAULT NULL,
X_gf_Attribute12 VARCHAR2 DEFAULT NULL,
X_gf_Attribute13 VARCHAR2 DEFAULT NULL,
X_gf_Attribute14 VARCHAR2 DEFAULT NULL,
X_gf_Attribute15 VARCHAR2 DEFAULT NULL,
X_gf_Attribute16 VARCHAR2 DEFAULT NULL,
X_gf_Attribute17 VARCHAR2 DEFAULT NULL,
X_gf_Attribute18 VARCHAR2 DEFAULT NULL,
X_gf_Attribute19 VARCHAR2 DEFAULT NULL,
X_gf_Attribute20 VARCHAR2 DEFAULT NULL,
X_gf_Attribute_Category_Code VARCHAR2 DEFAULT NULL,
X_Context VARCHAR2 DEFAULT NULL,
X_Lease_Id NUMBER DEFAULT NULL,
X_Inventorial VARCHAR2 DEFAULT NULL,
X_Commitment VARCHAR2 DEFAULT NULL,
X_Investment_Law VARCHAR2 DEFAULT NULL,
X_Status VARCHAR2 DEFAULT NULL,
X_Last_Update_Date DATE DEFAULT NULL,
X_Last_Updated_By NUMBER DEFAULT NULL,
X_Last_Update_Login NUMBER DEFAULT NULL,
X_Return_Status OUT NOCOPY BOOLEAN,
X_Calling_Fn VARCHAR2
, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
l_asset_id number;
select rowid
into l_rowid
from fa_additions_b
where asset_id = X_Asset_Id;
UPDATE fa_additions_b
SET
asset_id = decode(X_Asset_Id,
NULL, asset_id,
FND_API.G_MISS_NUM, NULL,
X_Asset_Id),
asset_number = decode(X_Asset_Number,
NULL, asset_number,
FND_API.G_MISS_CHAR, NULL,
X_Asset_Number),
asset_key_ccid = decode(X_Asset_Key_Ccid,
NULL, asset_key_ccid,
FND_API.G_MISS_NUM, NULL,
X_Asset_Key_Ccid),
current_units = decode(X_Current_Units,
NULL, current_units,
FND_API.G_MISS_NUM, NULL,
X_Current_Units),
asset_type = decode(X_Asset_Type,
NULL, asset_type,
FND_API.G_MISS_CHAR, NULL,
X_Asset_Type),
tag_number = decode(X_Tag_Number,
NULL, tag_number,
FND_API.G_MISS_CHAR, NULL,
X_Tag_Number),
asset_category_id = decode(X_Asset_Category_Id,
NULL, asset_category_id,
FND_API.G_MISS_NUM, NULL,
X_Asset_Category_Id),
parent_asset_id = decode(X_Parent_Asset_Id,
NULL, parent_asset_id,
FND_API.G_MISS_NUM, NULL,
X_Parent_Asset_Id),
manufacturer_name = decode(X_Manufacturer_Name,
NULL, manufacturer_name,
FND_API.G_MISS_CHAR, NULL,
X_Manufacturer_Name),
serial_number = decode(X_Serial_Number,
NULL, serial_number,
FND_API.G_MISS_CHAR, NULL,
X_Serial_Number),
model_number = decode(X_Model_Number,
NULL, model_number,
FND_API.G_MISS_CHAR, NULL,
X_Model_Number),
property_type_code = decode(X_Property_Type_Code,
NULL, property_type_code,
FND_API.G_MISS_CHAR, NULL,
X_Property_Type_Code),
property_1245_1250_code = decode(X_Property_1245_1250_Code,
NULL, property_1245_1250_code,
FND_API.G_MISS_CHAR, NULL,
X_Property_1245_1250_Code),
in_use_flag = decode(X_In_Use_Flag,
NULL, in_use_flag,
FND_API.G_MISS_CHAR, NULL,
X_In_Use_Flag),
owned_leased = decode(X_Owned_Leased,
NULL, owned_leased,
FND_API.G_MISS_CHAR, NULL,
X_Owned_Leased),
new_used = decode(X_New_Used,
NULL, new_used,
FND_API.G_MISS_CHAR, NULL,
X_New_Used),
unit_adjustment_flag = decode(X_Unit_Adjustment_Flag,
NULL, unit_adjustment_flag,
FND_API.G_MISS_CHAR, NULL,
X_Unit_Adjustment_Flag),
add_cost_je_flag = decode(X_Add_Cost_Je_Flag,
NULL, add_cost_je_flag,
FND_API.G_MISS_CHAR, NULL,
X_Add_Cost_Je_Flag),
attribute1 = decode(X_Attribute1,
NULL, attribute1,
FND_API.G_MISS_CHAR, NULL,
X_Attribute1),
attribute2 = decode(X_Attribute2,
NULL, attribute2,
FND_API.G_MISS_CHAR, NULL,
X_Attribute2),
attribute3 = decode(X_Attribute3,
NULL, attribute3,
FND_API.G_MISS_CHAR, NULL,
X_Attribute3),
attribute4 = decode(X_Attribute4,
NULL, attribute4,
FND_API.G_MISS_CHAR, NULL,
X_Attribute4),
attribute5 = decode(X_Attribute5,
NULL, attribute5,
FND_API.G_MISS_CHAR, NULL,
X_Attribute5),
attribute6 = decode(X_Attribute6,
NULL, attribute6,
FND_API.G_MISS_CHAR, NULL,
X_Attribute6),
attribute7 = decode(X_Attribute7,
NULL, attribute7,
FND_API.G_MISS_CHAR, NULL,
X_Attribute7),
attribute8 = decode(X_Attribute8,
NULL, attribute8,
FND_API.G_MISS_CHAR, NULL,
X_Attribute8),
attribute9 = decode(X_Attribute9,
NULL, attribute9,
FND_API.G_MISS_CHAR, NULL,
X_Attribute9),
attribute10 = decode(X_Attribute10,
NULL, attribute10,
FND_API.G_MISS_CHAR, NULL,
X_Attribute10),
attribute11 = decode(X_Attribute11,
NULL, attribute11,
FND_API.G_MISS_CHAR, NULL,
X_Attribute11),
attribute12 = decode(X_Attribute12,
NULL, attribute12,
FND_API.G_MISS_CHAR, NULL,
X_Attribute12),
attribute13 = decode(X_Attribute13,
NULL, attribute13,
FND_API.G_MISS_CHAR, NULL,
X_Attribute13),
attribute14 = decode(X_Attribute14,
NULL, attribute14,
FND_API.G_MISS_CHAR, NULL,
X_Attribute14),
attribute15 = decode(l_temp_attribute15,
NULL, attribute15,
FND_API.G_MISS_CHAR,
NULL,
l_temp_attribute15),
attribute16 = decode(X_Attribute16,
NULL, attribute16,
FND_API.G_MISS_CHAR, NULL,
X_Attribute16),
attribute17 = decode(X_Attribute17,
NULL, attribute17,
FND_API.G_MISS_CHAR, NULL,
X_Attribute17),
attribute18 = decode(X_Attribute18,
NULL, attribute18,
FND_API.G_MISS_CHAR, NULL,
X_Attribute18),
attribute19 = decode(X_Attribute19,
NULL, attribute19,
FND_API.G_MISS_CHAR, NULL,
X_Attribute19),
attribute20 = decode(X_Attribute20,
NULL, attribute20,
FND_API.G_MISS_CHAR, NULL,
X_Attribute20),
attribute21 = decode(X_Attribute21,
NULL, attribute21,
FND_API.G_MISS_CHAR, NULL,
X_Attribute21),
attribute22 = decode(X_Attribute22,
NULL, attribute22,
FND_API.G_MISS_CHAR, NULL,
X_Attribute22),
attribute23 = decode(X_Attribute23,
NULL, attribute23,
FND_API.G_MISS_CHAR, NULL,
X_Attribute23),
attribute24 = decode(X_Attribute24,
NULL, attribute24,
FND_API.G_MISS_CHAR, NULL,
X_Attribute24),
attribute25 = decode(X_Attribute25,
NULL, attribute25,
FND_API.G_MISS_CHAR, NULL,
X_Attribute25),
attribute26 = decode(X_Attribute26,
NULL, attribute26,
FND_API.G_MISS_CHAR, NULL,
X_Attribute26),
attribute27 = decode(X_Attribute27,
NULL, attribute27,
FND_API.G_MISS_CHAR, NULL,
X_Attribute27),
attribute28 = decode(X_Attribute28,
NULL, attribute28,
FND_API.G_MISS_CHAR, NULL,
X_Attribute28),
attribute29 = decode(X_Attribute29,
NULL, attribute29,
FND_API.G_MISS_CHAR, NULL,
X_Attribute29),
attribute30 = decode(X_Attribute30,
NULL, attribute30,
FND_API.G_MISS_CHAR, NULL,
X_Attribute30),
attribute_category_code = decode(X_Attribute_Category_Code,
NULL, attribute_category_code,
FND_API.G_MISS_CHAR, NULL,
X_Attribute_Category_Code),
global_attribute1 = decode(X_gf_Attribute1,
NULL, global_attribute1,
FND_API.G_MISS_CHAR, NULL,
X_gf_Attribute1),
global_attribute2 = decode(X_gf_Attribute2,
NULL, global_attribute2,
FND_API.G_MISS_CHAR, NULL,
X_gf_Attribute2),
global_attribute3 = decode(X_gf_Attribute3,
NULL, global_attribute3,
FND_API.G_MISS_CHAR, NULL,
X_gf_Attribute3),
global_attribute4 = decode(X_gf_Attribute4,
NULL, global_attribute4,
FND_API.G_MISS_CHAR, NULL,
X_gf_Attribute4),
global_attribute5 = decode(X_gf_Attribute5,
NULL, global_attribute5,
FND_API.G_MISS_CHAR, NULL,
X_gf_Attribute5),
global_attribute6 = decode(X_gf_Attribute6,
NULL, global_attribute6,
FND_API.G_MISS_CHAR, NULL,
X_gf_Attribute6),
global_attribute7 = decode(X_gf_Attribute7,
NULL, global_attribute7,
FND_API.G_MISS_CHAR, NULL,
X_gf_Attribute7),
global_attribute8 = decode(X_gf_Attribute8,
NULL, global_attribute8,
FND_API.G_MISS_CHAR, NULL,
X_gf_Attribute8),
global_attribute9 = decode(X_gf_Attribute9,
NULL, global_attribute9,
FND_API.G_MISS_CHAR, NULL,
X_gf_Attribute9),
global_attribute10 = decode(X_gf_Attribute10,
NULL, global_attribute10,
FND_API.G_MISS_CHAR, NULL,
X_gf_Attribute10),
global_attribute11 = decode(X_gf_Attribute11,
NULL, global_attribute11,
FND_API.G_MISS_CHAR, NULL,
X_gf_Attribute11),
global_attribute12 = decode(X_gf_Attribute12,
NULL, global_attribute12,
FND_API.G_MISS_CHAR, NULL,
X_gf_Attribute12),
global_attribute13 = decode(X_gf_Attribute13,
NULL, global_attribute13,
FND_API.G_MISS_CHAR, NULL,
X_gf_Attribute13),
global_attribute14 = decode(X_gf_Attribute14,
NULL, global_attribute14,
FND_API.G_MISS_CHAR, NULL,
X_gf_Attribute14),
global_attribute15 = decode(X_gf_Attribute15,
NULL, global_attribute15,
FND_API.G_MISS_CHAR, NULL,
X_gf_Attribute15),
global_attribute16 = decode(X_gf_Attribute16,
NULL, global_attribute16,
FND_API.G_MISS_CHAR, NULL,
X_gf_Attribute16),
global_attribute17 = decode(X_gf_Attribute17,
NULL, global_attribute17,
FND_API.G_MISS_CHAR, NULL,
X_gf_Attribute17),
global_attribute18 = decode(X_gf_Attribute18,
NULL, global_attribute18,
FND_API.G_MISS_CHAR, NULL,
X_gf_Attribute18),
global_attribute19 = decode(X_gf_Attribute19,
NULL, global_attribute19,
FND_API.G_MISS_CHAR, NULL,
X_gf_Attribute19),
global_attribute20 = decode(X_gf_Attribute20,
NULL, global_attribute20,
FND_API.G_MISS_CHAR, NULL,
X_gf_Attribute20),
global_attribute_category = decode(X_gf_Attribute_category_code,
NULL,
global_attribute_category,
FND_API.G_MISS_CHAR, NULL,
X_gf_Attribute_category_code),
context = decode(X_Context,
NULL, context,
FND_API.G_MISS_CHAR, NULL,
X_Context),
lease_id = decode(X_Lease_Id,
NULL, lease_id,
FND_API.G_MISS_NUM, NULL,
X_Lease_Id),
inventorial = decode(X_Inventorial,
NULL, inventorial,
FND_API.G_MISS_CHAR, NULL,
X_Inventorial),
commitment = decode(X_Commitment,
NULL, commitment,
FND_API.G_MISS_CHAR, NULL,
X_commitment),
investment_law = decode(X_investment_law,
NULL, investment_law,
FND_API.G_MISS_CHAR, NULL,
X_investment_law),
last_update_date = decode(X_Last_Update_Date,
NULL, last_update_date,
X_Last_Update_Date),
last_updated_by = decode(X_Last_Updated_By,
NULL, last_updated_by,
FND_API.G_MISS_NUM, NULL,
X_Last_Updated_By),
last_update_login = decode(X_Last_Update_Login,
NULL, last_update_login,
FND_API.G_MISS_NUM, NULL,
X_Last_Update_Login)
WHERE rowid = l_rowid;
select asset_id
into l_asset_id
from fa_additions
where rowid = X_rowid;
update FA_ADDITIONS_TL set
DESCRIPTION = decode(X_DESCRIPTION,
NULL, description,
FND_API.G_MISS_CHAR, NULL,
X_description),
LAST_UPDATE_DATE = decode(X_LAST_UPDATE_DATE,
NULL, last_update_date,
X_LAST_UPDATE_DATE),
LAST_UPDATED_BY = decode(X_LAST_UPDATED_BY,
NULL, last_updated_by,
FND_API.G_MISS_NUM, NULL,
X_LAST_UPDATED_BY),
LAST_UPDATE_LOGIN = decode(X_LAST_UPDATE_LOGIN,
NULL, last_update_login,
FND_API.G_MISS_NUM, NULL,
X_LAST_UPDATE_LOGIN),
SOURCE_LANG = userenv('LANG')
where ASSET_ID = L_ASSET_ID
and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
CALLING_FN => 'FA_ADDITIONS_PKG.Update_Row', p_log_level_rec => p_log_level_rec);
END Update_Row;
PROCEDURE Delete_Row(X_Rowid VARCHAR2,
X_Asset_Id number,
X_calling_Fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
-- CURSOR C IS SELECT asset_id FROM fa_additions_B
-- WHERE rowid = X_Rowid;
delete from FA_ADDITIONS_TL
where ASSET_ID = X_asset_id;
DELETE FROM fa_additions_b
WHERE asset_id = X_asset_id;
CALLING_FN => 'fa_additions_pkg.delete_row', p_log_level_rec => p_log_level_rec);
END Delete_Row;
PROCEDURE Update_Units(X_Asset_Id NUMBER,
X_Calling_Fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
BEGIN
UPDATE fa_additions_b
SET current_units = (select units from fa_asset_history
where asset_id = X_Asset_Id
and date_ineffective is null)
WHERE asset_id = X_Asset_Id;
CALLING_FN => 'fa_additions_pkg.update_units', p_log_level_rec => p_log_level_rec);
END Update_Units;
delete from FA_ADDITIONS_TL T
where not exists
(select NULL
from FA_ADDITIONS_B B
where B.ASSET_ID = T.ASSET_ID
);
update FA_ADDITIONS_TL T
set (DESCRIPTION) =
(select B.DESCRIPTION
from FA_ADDITIONS_TL B
where B.ASSET_ID = T.ASSET_ID
and B.LANGUAGE = T.SOURCE_LANG)
where (T.ASSET_ID, T.LANGUAGE) in
(select SUBT.ASSET_ID,
SUBT.LANGUAGE
from FA_ADDITIONS_TL SUBB, FA_ADDITIONS_TL SUBT
where SUBB.ASSET_ID = SUBT.ASSET_ID
and SUBB.LANGUAGE = SUBT.SOURCE_LANG
and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION));
insert into FA_ADDITIONS_TL (
LAST_UPDATED_BY,
CREATED_BY,
CREATION_DATE,
LAST_UPDATE_LOGIN,
ASSET_ID,
DESCRIPTION,
LAST_UPDATE_DATE,
LANGUAGE,
SOURCE_LANG)
select
B.LAST_UPDATED_BY,
B.CREATED_BY,
B.CREATION_DATE,
B.LAST_UPDATE_LOGIN,
B.ASSET_ID,
B.DESCRIPTION,
B.LAST_UPDATE_DATE,
L.LANGUAGE_CODE,
B.SOURCE_LANG
from FA_ADDITIONS_TL B, FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I', 'B')
and B.LANGUAGE = userenv('LANG')
and not exists
(select NULL
from FA_ADDITIONS_TL T
where T.ASSET_ID = B.ASSET_ID
and T.LANGUAGE = L.LANGUAGE_CODE);
select count(*)
into h_record_exists
from fa_additions_b
where asset_id = X_Asset_Id;
fa_additions_pkg.Update_Row(
X_Asset_Id => h_asset_id,
X_Asset_Number => h_asset_number,
X_Asset_Key_Ccid => X_Asset_Key_Ccid,
X_Current_Units => X_Current_Units,
X_Asset_Type => X_Asset_Type,
X_Tag_Number => X_Tag_Number,
X_Description => X_Description,
X_Asset_Category_Id => X_Asset_Category_Id,
X_Parent_Asset_Id => X_Parent_Asset_Id,
X_Manufacturer_Name => X_Manufacturer_Name,
X_Serial_Number => X_Serial_Number,
X_Model_Number => X_Model_Number,
X_Property_Type_Code => X_Property_Type_Code,
X_Property_1245_1250_Code => X_Property_1245_1250_Code,
X_In_Use_Flag => X_In_Use_Flag,
X_Owned_Leased => X_Owned_Leased,
X_New_Used => X_New_Used,
X_Unit_Adjustment_Flag => X_Unit_Adjustment_Flag,
X_Add_Cost_Je_Flag => X_Add_Cost_Je_Flag,
X_Attribute1 => X_Attribute1,
X_Attribute2 => X_Attribute2,
X_Attribute3 => X_Attribute3,
X_Attribute4 => X_Attribute4,
X_Attribute5 => X_Attribute5,
X_Attribute6 => X_Attribute6,
X_Attribute7 => X_Attribute7,
X_Attribute8 => X_Attribute8,
X_Attribute9 => X_Attribute9,
X_Attribute10 => X_Attribute10,
X_Attribute11 => X_Attribute11,
X_Attribute12 => X_Attribute12,
X_Attribute13 => X_Attribute13,
X_Attribute14 => X_Attribute14,
X_Attribute15 => X_Attribute15,
X_Attribute16 => X_Attribute16,
X_Attribute17 => X_Attribute17,
X_Attribute18 => X_Attribute18,
X_Attribute19 => X_Attribute19,
X_Attribute20 => X_Attribute20,
X_Attribute21 => X_Attribute21,
X_Attribute22 => X_Attribute22,
X_Attribute23 => X_Attribute23,
X_Attribute24 => X_Attribute24,
X_Attribute25 => X_Attribute25,
X_Attribute26 => X_Attribute26,
X_Attribute27 => X_Attribute27,
X_Attribute28 => X_Attribute28,
X_Attribute29 => X_Attribute29,
X_Attribute30 => X_Attribute30,
X_Attribute_Category_Code => X_Attribute_Category_Code,
X_gf_Attribute1 => X_gf_Attribute1,
X_gf_Attribute2 => X_gf_Attribute2,
X_gf_Attribute3 => X_gf_Attribute3,
X_gf_Attribute4 => X_gf_Attribute4,
X_gf_Attribute5 => X_gf_Attribute5,
X_gf_Attribute6 => X_gf_Attribute6,
X_gf_Attribute7 => X_gf_Attribute7,
X_gf_Attribute8 => X_gf_Attribute8,
X_gf_Attribute9 => X_gf_Attribute9,
X_gf_Attribute10 => X_gf_Attribute10,
X_gf_Attribute11 => X_gf_Attribute11,
X_gf_Attribute12 => X_gf_Attribute12,
X_gf_Attribute13 => X_gf_Attribute13,
X_gf_Attribute14 => X_gf_Attribute14,
X_gf_Attribute15 => X_gf_Attribute15,
X_gf_Attribute16 => X_gf_Attribute16,
X_gf_Attribute17 => X_gf_Attribute17,
X_gf_Attribute18 => X_gf_Attribute18,
X_gf_Attribute19 => X_gf_Attribute19,
X_gf_Attribute20 => X_gf_Attribute20,
X_gf_Attribute_Category_Code => X_gf_Attribute_Category,
X_Context => X_Context,
X_Lease_Id => X_Lease_Id,
X_Inventorial => X_Inventorial,
X_Commitment => X_Commitment,
X_Investment_Law => X_Investment_Law,
X_Status => X_Status,
X_Last_Update_Date => sysdate,
X_Last_Updated_By => user_id,
X_Last_Update_Login => 0,
X_Return_Status => return_status,
X_Calling_Fn => 'fa_additions_pkg.load_row'
, p_log_level_rec => p_log_level_rec);
fa_additions_pkg.Insert_Row(
X_Rowid => row_id,
X_Asset_Id => h_asset_id,
X_Asset_Number => h_asset_number,
X_Asset_Key_Ccid => X_Asset_Key_Ccid,
X_Current_Units => X_Current_Units,
X_Asset_Type => X_Asset_Type,
X_Tag_Number => X_Tag_Number,
X_Description => X_Description,
X_Asset_Category_Id => X_Asset_Category_Id,
X_Parent_Asset_Id => X_Parent_Asset_Id,
X_Manufacturer_Name => X_Manufacturer_Name,
X_Serial_Number => X_Serial_Number,
X_Model_Number => X_Model_Number,
X_Property_Type_Code => X_Property_Type_Code,
X_Property_1245_1250_Code => X_Property_1245_1250_Code,
X_In_Use_Flag => X_In_Use_Flag,
X_Owned_Leased => X_Owned_Leased,
X_New_Used => X_New_Used,
X_Unit_Adjustment_Flag => X_Unit_Adjustment_Flag,
X_Add_Cost_Je_Flag => X_Add_Cost_Je_Flag,
X_Attribute1 => X_Attribute1,
X_Attribute2 => X_Attribute2,
X_Attribute3 => X_Attribute3,
X_Attribute4 => X_Attribute4,
X_Attribute5 => X_Attribute5,
X_Attribute6 => X_Attribute6,
X_Attribute7 => X_Attribute7,
X_Attribute8 => X_Attribute8,
X_Attribute9 => X_Attribute9,
X_Attribute10 => X_Attribute10,
X_Attribute11 => X_Attribute11,
X_Attribute12 => X_Attribute12,
X_Attribute13 => X_Attribute13,
X_Attribute14 => X_Attribute14,
X_Attribute15 => X_Attribute15,
X_Attribute16 => X_Attribute16,
X_Attribute17 => X_Attribute17,
X_Attribute18 => X_Attribute18,
X_Attribute19 => X_Attribute19,
X_Attribute20 => X_Attribute20,
X_Attribute21 => X_Attribute21,
X_Attribute22 => X_Attribute22,
X_Attribute23 => X_Attribute23,
X_Attribute24 => X_Attribute24,
X_Attribute25 => X_Attribute25,
X_Attribute26 => X_Attribute26,
X_Attribute27 => X_Attribute27,
X_Attribute28 => X_Attribute28,
X_Attribute29 => X_Attribute29,
X_Attribute30 => X_Attribute30,
X_Attribute_Category_Code => X_Attribute_Category_Code,
X_gf_Attribute1 => X_gf_Attribute1,
X_gf_Attribute2 => X_gf_Attribute2,
X_gf_Attribute3 => X_gf_Attribute3,
X_gf_Attribute4 => X_gf_Attribute4,
X_gf_Attribute5 => X_gf_Attribute5,
X_gf_Attribute6 => X_gf_Attribute6,
X_gf_Attribute7 => X_gf_Attribute7,
X_gf_Attribute8 => X_gf_Attribute8,
X_gf_Attribute9 => X_gf_Attribute9,
X_gf_Attribute10 => X_gf_Attribute10,
X_gf_Attribute11 => X_gf_Attribute11,
X_gf_Attribute12 => X_gf_Attribute12,
X_gf_Attribute13 => X_gf_Attribute13,
X_gf_Attribute14 => X_gf_Attribute14,
X_gf_Attribute15 => X_gf_Attribute15,
X_gf_Attribute16 => X_gf_Attribute16,
X_gf_Attribute17 => X_gf_Attribute17,
X_gf_Attribute18 => X_gf_Attribute18,
X_gf_Attribute19 => X_gf_Attribute19,
X_gf_Attribute20 => X_gf_Attribute20,
X_gf_Attribute_Category_Code => X_gf_Attribute_Category,
X_Context => X_Context,
X_Lease_Id => X_Lease_Id,
X_Inventorial => X_Inventorial,
X_Commitment => X_Commitment,
X_Investment_Law => X_Investment_Law,
X_Status => X_Status,
X_Last_Update_Date => sysdate,
X_Last_Updated_By => user_id,
X_Created_By => user_id,
X_Creation_Date => sysdate,
X_Last_Update_Login => 0,
X_Calling_Fn => 'fa_additions_pkg.load_row'
, p_log_level_rec => p_log_level_rec);
X_Last_Update_Date IN DATE,
X_Asset_Number IN VARCHAR2,
X_Asset_Key_Ccid IN NUMBER DEFAULT NULL,
X_Current_Units IN NUMBER,
X_Asset_Type IN VARCHAR2,
X_Tag_Number IN VARCHAR2 DEFAULT NULL,
X_Description IN VARCHAR2,
X_Asset_Category_Id IN NUMBER,
X_Parent_Asset_Id IN NUMBER DEFAULT NULL,
X_Manufacturer_Name IN VARCHAR2 DEFAULT NULL,
X_Serial_Number IN VARCHAR2 DEFAULT NULL,
X_Model_Number IN VARCHAR2 DEFAULT NULL,
X_Property_Type_Code IN VARCHAR2 DEFAULT NULL,
X_Property_1245_1250_Code IN VARCHAR2 DEFAULT NULL,
X_In_Use_Flag IN VARCHAR2,
X_Owned_Leased IN VARCHAR2,
X_New_Used IN VARCHAR2,
X_Unit_Adjustment_Flag IN VARCHAR2,
X_Add_Cost_Je_Flag IN VARCHAR2,
X_Attribute1 IN VARCHAR2 DEFAULT NULL,
X_Attribute2 IN VARCHAR2 DEFAULT NULL,
X_Attribute3 IN VARCHAR2 DEFAULT NULL,
X_Attribute4 IN VARCHAR2 DEFAULT NULL,
X_Attribute5 IN VARCHAR2 DEFAULT NULL,
X_Attribute6 IN VARCHAR2 DEFAULT NULL,
X_Attribute7 IN VARCHAR2 DEFAULT NULL,
X_Attribute8 IN VARCHAR2 DEFAULT NULL,
X_Attribute9 IN VARCHAR2 DEFAULT NULL,
X_Attribute10 IN VARCHAR2 DEFAULT NULL,
X_Attribute11 IN VARCHAR2 DEFAULT NULL,
X_Attribute12 IN VARCHAR2 DEFAULT NULL,
X_Attribute13 IN VARCHAR2 DEFAULT NULL,
X_Attribute14 IN VARCHAR2 DEFAULT NULL,
X_Attribute15 IN VARCHAR2 DEFAULT NULL,
X_Attribute16 IN VARCHAR2 DEFAULT NULL,
X_Attribute17 IN VARCHAR2 DEFAULT NULL,
X_Attribute18 IN VARCHAR2 DEFAULT NULL,
X_Attribute19 IN VARCHAR2 DEFAULT NULL,
X_Attribute20 IN VARCHAR2 DEFAULT NULL,
X_Attribute21 IN VARCHAR2 DEFAULT NULL,
X_Attribute22 IN VARCHAR2 DEFAULT NULL,
X_Attribute23 IN VARCHAR2 DEFAULT NULL,
X_Attribute24 IN VARCHAR2 DEFAULT NULL,
X_Attribute25 IN VARCHAR2 DEFAULT NULL,
X_Attribute26 IN VARCHAR2 DEFAULT NULL,
X_Attribute27 IN VARCHAR2 DEFAULT NULL,
X_Attribute28 IN VARCHAR2 DEFAULT NULL,
X_Attribute29 IN VARCHAR2 DEFAULT NULL,
X_Attribute30 IN VARCHAR2 DEFAULT NULL,
X_Attribute_Category_Code IN VARCHAR2,
X_Context IN VARCHAR2 DEFAULT NULL,
X_Lease_Id IN NUMBER DEFAULT NULL,
X_Inventorial IN VARCHAR2,
X_Commitment IN VARCHAR2 DEFAULT NULL,
X_Investment_Law IN VARCHAR2 DEFAULT NULL,
X_Status IN VARCHAR2 DEFAULT NULL,
X_gf_Attribute1 IN VARCHAR2 DEFAULT NULL,
X_gf_Attribute2 IN VARCHAR2 DEFAULT NULL,
X_gf_Attribute3 IN VARCHAR2 DEFAULT NULL,
X_gf_Attribute4 IN VARCHAR2 DEFAULT NULL,
X_gf_Attribute5 IN VARCHAR2 DEFAULT NULL,
X_gf_Attribute6 IN VARCHAR2 DEFAULT NULL,
X_gf_Attribute7 IN VARCHAR2 DEFAULT NULL,
X_gf_Attribute8 IN VARCHAR2 DEFAULT NULL,
X_gf_Attribute9 IN VARCHAR2 DEFAULT NULL,
X_gf_Attribute10 IN VARCHAR2 DEFAULT NULL,
X_gf_Attribute11 IN VARCHAR2 DEFAULT NULL,
X_gf_Attribute12 IN VARCHAR2 DEFAULT NULL,
X_gf_Attribute13 IN VARCHAR2 DEFAULT NULL,
X_gf_Attribute14 IN VARCHAR2 DEFAULT NULL,
X_gf_Attribute15 IN VARCHAR2 DEFAULT NULL,
X_gf_Attribute16 IN VARCHAR2 DEFAULT NULL,
X_gf_Attribute17 IN VARCHAR2 DEFAULT NULL,
X_gf_Attribute18 IN VARCHAR2 DEFAULT NULL,
X_gf_Attribute19 IN VARCHAR2 DEFAULT NULL,
X_gf_Attribute20 IN VARCHAR2 DEFAULT NULL,
X_gf_Attribute_Category IN VARCHAR2 DEFAULT NULL,
p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
h_asset_id number;
db_last_updated_by number;
db_last_update_date date;
select count(*)
into h_record_exists
from fa_additions_b
where asset_id = X_Asset_Id;
select last_updated_by, last_update_date
into db_last_updated_by, db_last_update_date
from fa_additions_b
where asset_id = X_Asset_Id;
if (fnd_load_util.upload_test(user_id, x_last_update_date,
db_last_updated_by, db_last_update_date,
X_CUSTOM_MODE
)) then
fa_additions_pkg.Update_Row(
X_Asset_Id => h_asset_id,
X_Asset_Number => h_asset_number,
X_Asset_Key_Ccid => X_Asset_Key_Ccid,
X_Current_Units => X_Current_Units,
X_Asset_Type => X_Asset_Type,
X_Tag_Number => X_Tag_Number,
X_Description => X_Description,
X_Asset_Category_Id => X_Asset_Category_Id,
X_Parent_Asset_Id => X_Parent_Asset_Id,
X_Manufacturer_Name => X_Manufacturer_Name,
X_Serial_Number => X_Serial_Number,
X_Model_Number => X_Model_Number,
X_Property_Type_Code => X_Property_Type_Code,
X_Property_1245_1250_Code => X_Property_1245_1250_Code,
X_In_Use_Flag => X_In_Use_Flag,
X_Owned_Leased => X_Owned_Leased,
X_New_Used => X_New_Used,
X_Unit_Adjustment_Flag => X_Unit_Adjustment_Flag,
X_Add_Cost_Je_Flag => X_Add_Cost_Je_Flag,
X_Attribute1 => X_Attribute1,
X_Attribute2 => X_Attribute2,
X_Attribute3 => X_Attribute3,
X_Attribute4 => X_Attribute4,
X_Attribute5 => X_Attribute5,
X_Attribute6 => X_Attribute6,
X_Attribute7 => X_Attribute7,
X_Attribute8 => X_Attribute8,
X_Attribute9 => X_Attribute9,
X_Attribute10 => X_Attribute10,
X_Attribute11 => X_Attribute11,
X_Attribute12 => X_Attribute12,
X_Attribute13 => X_Attribute13,
X_Attribute14 => X_Attribute14,
X_Attribute15 => X_Attribute15,
X_Attribute16 => X_Attribute16,
X_Attribute17 => X_Attribute17,
X_Attribute18 => X_Attribute18,
X_Attribute19 => X_Attribute19,
X_Attribute20 => X_Attribute20,
X_Attribute21 => X_Attribute21,
X_Attribute22 => X_Attribute22,
X_Attribute23 => X_Attribute23,
X_Attribute24 => X_Attribute24,
X_Attribute25 => X_Attribute25,
X_Attribute26 => X_Attribute26,
X_Attribute27 => X_Attribute27,
X_Attribute28 => X_Attribute28,
X_Attribute29 => X_Attribute29,
X_Attribute30 => X_Attribute30,
X_Attribute_Category_Code => X_Attribute_Category_Code,
X_gf_Attribute1 => X_gf_Attribute1,
X_gf_Attribute2 => X_gf_Attribute2,
X_gf_Attribute3 => X_gf_Attribute3,
X_gf_Attribute4 => X_gf_Attribute4,
X_gf_Attribute5 => X_gf_Attribute5,
X_gf_Attribute6 => X_gf_Attribute6,
X_gf_Attribute7 => X_gf_Attribute7,
X_gf_Attribute8 => X_gf_Attribute8,
X_gf_Attribute9 => X_gf_Attribute9,
X_gf_Attribute10 => X_gf_Attribute10,
X_gf_Attribute11 => X_gf_Attribute11,
X_gf_Attribute12 => X_gf_Attribute12,
X_gf_Attribute13 => X_gf_Attribute13,
X_gf_Attribute14 => X_gf_Attribute14,
X_gf_Attribute15 => X_gf_Attribute15,
X_gf_Attribute16 => X_gf_Attribute16,
X_gf_Attribute17 => X_gf_Attribute17,
X_gf_Attribute18 => X_gf_Attribute18,
X_gf_Attribute19 => X_gf_Attribute19,
X_gf_Attribute20 => X_gf_Attribute20,
X_gf_Attribute_Category_Code => X_gf_Attribute_Category,
X_Context => X_Context,
X_Lease_Id => X_Lease_Id,
X_Inventorial => X_Inventorial,
X_Commitment => X_Commitment,
X_Investment_Law => X_Investment_Law,
X_Status => X_Status,
X_Last_Update_Date => sysdate,
X_Last_Updated_By => user_id,
X_Last_Update_Login => 0,
X_Return_Status => return_status,
X_Calling_Fn => 'fa_additions_pkg.load_row',
p_log_level_rec => p_log_level_rec);
fa_additions_pkg.Insert_Row(
X_Rowid => row_id,
X_Asset_Id => h_asset_id,
X_Asset_Number => h_asset_number,
X_Asset_Key_Ccid => X_Asset_Key_Ccid,
X_Current_Units => X_Current_Units,
X_Asset_Type => X_Asset_Type,
X_Tag_Number => X_Tag_Number,
X_Description => X_Description,
X_Asset_Category_Id => X_Asset_Category_Id,
X_Parent_Asset_Id => X_Parent_Asset_Id,
X_Manufacturer_Name => X_Manufacturer_Name,
X_Serial_Number => X_Serial_Number,
X_Model_Number => X_Model_Number,
X_Property_Type_Code => X_Property_Type_Code,
X_Property_1245_1250_Code => X_Property_1245_1250_Code,
X_In_Use_Flag => X_In_Use_Flag,
X_Owned_Leased => X_Owned_Leased,
X_New_Used => X_New_Used,
X_Unit_Adjustment_Flag => X_Unit_Adjustment_Flag,
X_Add_Cost_Je_Flag => X_Add_Cost_Je_Flag,
X_Attribute1 => X_Attribute1,
X_Attribute2 => X_Attribute2,
X_Attribute3 => X_Attribute3,
X_Attribute4 => X_Attribute4,
X_Attribute5 => X_Attribute5,
X_Attribute6 => X_Attribute6,
X_Attribute7 => X_Attribute7,
X_Attribute8 => X_Attribute8,
X_Attribute9 => X_Attribute9,
X_Attribute10 => X_Attribute10,
X_Attribute11 => X_Attribute11,
X_Attribute12 => X_Attribute12,
X_Attribute13 => X_Attribute13,
X_Attribute14 => X_Attribute14,
X_Attribute15 => X_Attribute15,
X_Attribute16 => X_Attribute16,
X_Attribute17 => X_Attribute17,
X_Attribute18 => X_Attribute18,
X_Attribute19 => X_Attribute19,
X_Attribute20 => X_Attribute20,
X_Attribute21 => X_Attribute21,
X_Attribute22 => X_Attribute22,
X_Attribute23 => X_Attribute23,
X_Attribute24 => X_Attribute24,
X_Attribute25 => X_Attribute25,
X_Attribute26 => X_Attribute26,
X_Attribute27 => X_Attribute27,
X_Attribute28 => X_Attribute28,
X_Attribute29 => X_Attribute29,
X_Attribute30 => X_Attribute30,
X_Attribute_Category_Code => X_Attribute_Category_Code,
X_gf_Attribute1 => X_gf_Attribute1,
X_gf_Attribute2 => X_gf_Attribute2,
X_gf_Attribute3 => X_gf_Attribute3,
X_gf_Attribute4 => X_gf_Attribute4,
X_gf_Attribute5 => X_gf_Attribute5,
X_gf_Attribute6 => X_gf_Attribute6,
X_gf_Attribute7 => X_gf_Attribute7,
X_gf_Attribute8 => X_gf_Attribute8,
X_gf_Attribute9 => X_gf_Attribute9,
X_gf_Attribute10 => X_gf_Attribute10,
X_gf_Attribute11 => X_gf_Attribute11,
X_gf_Attribute12 => X_gf_Attribute12,
X_gf_Attribute13 => X_gf_Attribute13,
X_gf_Attribute14 => X_gf_Attribute14,
X_gf_Attribute15 => X_gf_Attribute15,
X_gf_Attribute16 => X_gf_Attribute16,
X_gf_Attribute17 => X_gf_Attribute17,
X_gf_Attribute18 => X_gf_Attribute18,
X_gf_Attribute19 => X_gf_Attribute19,
X_gf_Attribute20 => X_gf_Attribute20,
X_gf_Attribute_Category_Code => X_gf_Attribute_Category,
X_Context => X_Context,
X_Lease_Id => X_Lease_Id,
X_Inventorial => X_Inventorial,
X_Commitment => X_Commitment,
X_Investment_Law => X_Investment_Law,
X_Status => X_Status,
X_Last_Update_Date => sysdate,
X_Last_Updated_By => user_id,
X_Created_By => user_id,
X_Creation_Date => sysdate,
X_Last_Update_Login => 0,
X_Calling_Fn => 'fa_additions_pkg.load_row'
,p_log_level_rec => p_log_level_rec);
update FA_ADDITIONS_TL set
DESCRIPTION = nvl(X_Description, DESCRIPTION),
LAST_UPDATE_DATE = sysdate,
LAST_UPDATED_BY = 0,
LAST_UPDATE_LOGIN = 0,
SOURCE_LANG = userenv('LANG')
where userenv('LANG') in (LANGUAGE, SOURCE_LANG)
and ASSET_ID = X_Asset_ID;
X_Last_Update_Date IN DATE,
X_Description IN VARCHAR2,
p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
user_id number;
db_last_updated_by number;
db_last_update_date date;
select last_updated_by, last_update_date
into db_last_updated_by, db_last_update_date
from fa_additions_tl
where userenv('LANG') in (LANGUAGE, SOURCE_LANG)
and asset_id = X_Asset_ID;
if (fnd_load_util.upload_test(user_id, x_last_update_date,
db_last_updated_by, db_last_update_date,
X_CUSTOM_MODE )) then
update FA_ADDITIONS_TL set
DESCRIPTION = nvl(X_Description, DESCRIPTION),
LAST_UPDATE_DATE = sysdate,
LAST_UPDATED_BY = 0,
LAST_UPDATE_LOGIN = 0,
SOURCE_LANG = userenv('LANG')
where userenv('LANG') in (LANGUAGE, SOURCE_LANG)
and ASSET_ID = X_Asset_ID;
x_last_update_date IN DATE,
x_asset_number IN VARCHAR2,
x_asset_key_ccid IN NUMBER,
x_current_units IN NUMBER,
x_asset_type IN VARCHAR2,
x_tag_number IN VARCHAR2,
x_description IN VARCHAR2,
x_asset_category_id IN NUMBER,
x_parent_asset_id IN NUMBER,
x_manufacturer_name IN VARCHAR2,
x_serial_number IN VARCHAR2,
x_model_number IN VARCHAR2,
x_property_type_code IN VARCHAR2,
x_property_1245_1250_code IN VARCHAR2,
x_in_use_flag IN VARCHAR2,
x_owned_leased IN VARCHAR2,
x_new_used IN VARCHAR2,
x_unit_adjustment_flag IN VARCHAR2,
x_add_cost_je_flag IN VARCHAR2,
x_attribute1 IN VARCHAR2,
x_attribute2 IN VARCHAR2,
x_attribute3 IN VARCHAR2,
x_attribute4 IN VARCHAR2,
x_attribute5 IN VARCHAR2,
x_attribute6 IN VARCHAR2,
x_attribute7 IN VARCHAR2,
x_attribute8 IN VARCHAR2,
x_attribute9 IN VARCHAR2,
x_attribute10 IN VARCHAR2,
x_attribute11 IN VARCHAR2,
x_attribute12 IN VARCHAR2,
x_attribute13 IN VARCHAR2,
x_attribute14 IN VARCHAR2,
x_attribute15 IN VARCHAR2,
x_attribute16 IN VARCHAR2,
x_attribute17 IN VARCHAR2,
x_attribute18 IN VARCHAR2,
x_attribute19 IN VARCHAR2,
x_attribute20 IN VARCHAR2,
x_attribute21 IN VARCHAR2,
x_attribute22 IN VARCHAR2,
x_attribute23 IN VARCHAR2,
x_attribute24 IN VARCHAR2,
x_attribute25 IN VARCHAR2,
x_attribute26 IN VARCHAR2,
x_attribute27 IN VARCHAR2,
x_attribute28 IN VARCHAR2,
x_attribute29 IN VARCHAR2,
x_attribute30 IN VARCHAR2,
x_attribute_category_code IN VARCHAR2,
x_context IN VARCHAR2,
x_lease_id IN NUMBER,
x_inventorial IN VARCHAR2,
x_commitment IN VARCHAR2,
x_investment_law IN VARCHAR2,
x_gf_attribute1 IN VARCHAR2,
x_gf_attribute2 IN VARCHAR2,
x_gf_attribute3 IN VARCHAR2,
x_gf_attribute4 IN VARCHAR2,
x_gf_attribute5 IN VARCHAR2,
x_gf_attribute6 IN VARCHAR2,
x_gf_attribute7 IN VARCHAR2,
x_gf_attribute8 IN VARCHAR2,
x_gf_attribute9 IN VARCHAR2,
x_gf_attribute10 IN VARCHAR2,
x_gf_attribute11 IN VARCHAR2,
x_gf_attribute12 IN VARCHAR2,
x_gf_attribute13 IN VARCHAR2,
x_gf_attribute14 IN VARCHAR2,
x_gf_attribute15 IN VARCHAR2,
x_gf_attribute16 IN VARCHAR2,
x_gf_attribute17 IN VARCHAR2,
x_gf_attribute18 IN VARCHAR2,
x_gf_attribute19 IN VARCHAR2,
x_gf_attribute20 IN VARCHAR2,
x_gf_attribute_category IN VARCHAR2
,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
BEGIN
if (x_upload_mode = 'NLS') then
fa_additions_pkg.TRANSLATE_ROW (
x_custom_mode => x_custom_mode,
x_asset_id => x_asset_id,
x_owner => x_owner,
x_last_update_date => x_last_update_date,
x_description => x_description
,p_log_level_rec => p_log_level_rec);
x_last_update_date => x_last_update_date,
x_asset_number => x_asset_number,
x_asset_key_ccid => x_asset_key_ccid,
x_current_units => x_current_units,
x_asset_type => x_asset_type,
x_tag_number => x_tag_number,
x_description => x_description,
x_asset_category_id => x_asset_category_id,
x_parent_asset_id => x_parent_asset_id,
x_manufacturer_name => x_manufacturer_name,
x_serial_number => x_serial_number,
x_model_number => x_model_number,
x_property_type_code => x_property_type_code,
x_property_1245_1250_code => x_property_1245_1250_code,
x_in_use_flag => x_in_use_flag,
x_owned_leased => x_owned_leased,
x_new_used => x_new_used,
x_unit_adjustment_flag => x_unit_adjustment_flag,
x_add_cost_je_flag => x_add_cost_je_flag,
x_attribute1 => x_attribute1,
x_attribute2 => x_attribute2,
x_attribute3 => x_attribute3,
x_attribute4 => x_attribute4,
x_attribute5 => x_attribute5,
x_attribute6 => x_attribute6,
x_attribute7 => x_attribute7,
x_attribute8 => x_attribute8,
x_attribute9 => x_attribute9,
x_attribute10 => x_attribute10,
x_attribute11 => x_attribute11,
x_attribute12 => x_attribute12,
x_attribute13 => x_attribute13,
x_attribute14 => x_attribute14,
x_attribute15 => x_attribute15,
x_attribute16 => x_attribute16,
x_attribute17 => x_attribute17,
x_attribute18 => x_attribute18,
x_attribute19 => x_attribute19,
x_attribute20 => x_attribute20,
x_attribute21 => x_attribute21,
x_attribute22 => x_attribute22,
x_attribute23 => x_attribute23,
x_attribute24 => x_attribute24,
x_attribute25 => x_attribute25,
x_attribute26 => x_attribute26,
x_attribute27 => x_attribute27,
x_attribute28 => x_attribute28,
x_attribute29 => x_attribute29,
x_attribute30 => x_attribute30,
x_attribute_category_code => x_attribute_category_code,
x_context => x_context,
x_lease_id => x_lease_id,
x_inventorial => x_inventorial,
x_commitment => x_commitment,
x_investment_law => x_investment_law,
x_gf_attribute1 => x_gf_attribute1,
x_gf_attribute2 => x_gf_attribute2,
x_gf_attribute3 => x_gf_attribute3,
x_gf_attribute4 => x_gf_attribute4,
x_gf_attribute5 => x_gf_attribute5,
x_gf_attribute6 => x_gf_attribute6,
x_gf_attribute7 => x_gf_attribute7,
x_gf_attribute8 => x_gf_attribute8,
x_gf_attribute9 => x_gf_attribute9,
x_gf_attribute10 => x_gf_attribute10,
x_gf_attribute11 => x_gf_attribute11,
x_gf_attribute12 => x_gf_attribute12,
x_gf_attribute13 => x_gf_attribute13,
x_gf_attribute14 => x_gf_attribute14,
x_gf_attribute15 => x_gf_attribute15,
x_gf_attribute16 => x_gf_attribute16,
x_gf_attribute17 => x_gf_attribute17,
x_gf_attribute18 => x_gf_attribute18,
x_gf_attribute19 => x_gf_attribute19,
x_gf_attribute20 => x_gf_attribute20,
x_gf_attribute_category => x_gf_attribute_category
,p_log_level_rec => p_log_level_rec);