[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
X_Method_Id IN OUT NOCOPY NUMBER,
X_Method_Code VARCHAR2,
X_Life_In_Months NUMBER DEFAULT NULL,
X_Depreciate_Lastyear_Flag VARCHAR2,
X_Stl_Method_Flag VARCHAR2,
X_Rate_Source_Rule VARCHAR2,
X_Deprn_Basis_Rule VARCHAR2,
X_Prorate_Periods_Per_Year NUMBER DEFAULT NULL,
X_Name 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_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_Attribute_Category_Code VARCHAR2 DEFAULT NULL,
X_Exclude_Salvage_Value_Flag VARCHAR2 DEFAULT 'NO',
-- alternative flat depreciation calculation. added for 11.5.2
X_Deprn_Basis_Formula VARCHAR2 DEFAULT NULL,
X_Polish_Adj_Calc_Basis_Flag VARCHAR2 DEFAULT NULL,
X_Guarantee_Rate_Method_Flag VARCHAR2 DEFAULT NULL,
X_Calling_Fn VARCHAR2,
-- For Depreciable Basis Formula
X_Deprn_Basis_Rule_Id NUMBER DEFAULT NULL,
x_jp_imp_calc_basis_flag VARCHAR2 DEFAULT NULL
, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
CURSOR C IS SELECT rowid FROM fa_methods
WHERE method_id = X_Method_Id;
CURSOR C2 IS SELECT fa_methods_s.nextval FROM sys.dual;
INSERT INTO fa_methods(
method_id,
method_code,
life_in_months,
depreciate_lastyear_flag,
stl_method_flag,
rate_source_rule,
deprn_basis_rule,
prorate_periods_per_year,
name,
last_update_date,
last_updated_by,
created_by,
creation_date,
last_update_login,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute_category_code,
exclude_salvage_value_flag,
deprn_basis_formula,
deprn_basis_rule_id,
polish_adj_calc_basis_flag,
guarantee_rate_method_flag,
jp_imp_calc_basis_flag
) VALUES (
X_Method_Id,
X_Method_Code,
X_Life_In_Months,
X_Depreciate_Lastyear_Flag,
X_Stl_Method_Flag,
X_Rate_Source_Rule,
X_Deprn_Basis_Rule,
X_Prorate_Periods_Per_Year,
X_Name,
X_Last_Update_Date,
X_Last_Updated_By,
X_Created_By,
X_Creation_Date,
X_Last_Update_Login,
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,
X_Attribute15,
X_Attribute_Category_Code,
X_Exclude_Salvage_Value_Flag,
X_Deprn_Basis_Formula,
X_Deprn_Basis_Rule_Id,
X_Polish_Adj_Calc_Basis_Flag,
X_Guarantee_Rate_Method_Flag,
x_jp_imp_calc_basis_flag
);
UPDATE fa_methods
SET deprn_basis_rule_id =
(SELECT deprn_basis_rule_id
FROM fa_deprn_basis_rules
WHERE RULE_NAME='TRANSACTION')
WHERE rate_source_rule='FLAT'
AND deprn_basis_rule='NBV'
AND deprn_basis_formula IS NULL
AND deprn_basis_rule_id IS NULL
AND method_id = X_Method_Id;
UPDATE fa_methods
SET deprn_basis_rule_id =
(SELECT deprn_basis_rule_id
FROM fa_deprn_basis_rules
WHERE RULE_NAME='FYBEGIN')
WHERE rate_source_rule='FLAT'
AND deprn_basis_rule='NBV'
AND deprn_basis_formula ='STRICT_FLAT'
AND deprn_basis_rule_id IS NULL
AND method_id = X_Method_Id;
calling_fn => 'fa_methods_pkg.insert_row', p_log_level_rec => p_log_level_rec);
CALLED_FN => 'fa_methods_pkg.insert_row',
CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec);
END Insert_Row;
SELECT method_id,
method_code,
life_in_months,
depreciate_lastyear_flag,
stl_method_flag,
rate_source_rule,
deprn_basis_rule,
prorate_periods_per_year,
name,
last_update_date,
last_updated_by,
created_by,
creation_date,
last_update_login,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute_category_code,
deprn_basis_formula,
exclude_salvage_value_flag,
deprn_basis_rule_id,
polish_adj_calc_basis_flag,
guarantee_rate_method_flag,
jp_imp_calc_basis_flag
FROM fa_methods
WHERE method_code = X_Method_Code
AND ((life_in_months = X_Life_In_Months) or
((life_in_months is null) and (X_Life_In_Months is null)))
FOR UPDATE of Method_Id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
PROCEDURE Update_Row(X_Rowid VARCHAR2,
X_Method_Id NUMBER,
X_Method_Code VARCHAR2,
X_Life_In_Months NUMBER,
X_Depreciate_Lastyear_Flag VARCHAR2,
X_Stl_Method_Flag VARCHAR2,
X_Rate_Source_Rule VARCHAR2,
X_Deprn_Basis_Rule VARCHAR2,
X_Prorate_Periods_Per_Year NUMBER,
X_Name VARCHAR2,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Last_Update_Login NUMBER,
X_Attribute1 VARCHAR2,
X_Attribute2 VARCHAR2,
X_Attribute3 VARCHAR2,
X_Attribute4 VARCHAR2,
X_Attribute5 VARCHAR2,
X_Attribute6 VARCHAR2,
X_Attribute7 VARCHAR2,
X_Attribute8 VARCHAR2,
X_Attribute9 VARCHAR2,
X_Attribute10 VARCHAR2,
X_Attribute11 VARCHAR2,
X_Attribute12 VARCHAR2,
X_Attribute13 VARCHAR2,
X_Attribute14 VARCHAR2,
X_Attribute15 VARCHAR2,
X_Attribute_Category_Code VARCHAR2,
X_Exclude_Salvage_Value_Flag VARCHAR2,
-- added for alternative flat rate depreciation calculation. for 11.5.2
X_Deprn_Basis_Formula VARCHAR2,
X_Polish_Adj_Calc_Basis_Flag VARCHAR2,
X_Guarantee_Rate_Method_Flag VARCHAR2,
X_Calling_Fn VARCHAR2,
-- added for Depreciable Basis Formula
X_Deprn_Basis_Rule_Id NUMBER DEFAULT NULL,
x_jp_imp_calc_basis_flag VARCHAR2 DEFAULT NULL
, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
BEGIN
ad_zd_seed.prepare('fa_methods');
UPDATE fa_methods
SET
depreciate_lastyear_flag = X_Depreciate_Lastyear_Flag,
stl_method_flag = X_Stl_Method_Flag,
rate_source_rule = X_Rate_Source_Rule,
deprn_basis_rule = X_Deprn_Basis_Rule,
prorate_periods_per_year = X_Prorate_Periods_Per_Year,
name = X_Name,
last_update_date = X_Last_Update_Date,
last_updated_by = X_Last_Updated_By,
last_update_login = X_Last_Update_Login,
attribute1 = X_Attribute1,
attribute2 = X_Attribute2,
attribute3 = X_Attribute3,
attribute4 = X_Attribute4,
attribute5 = X_Attribute5,
attribute6 = X_Attribute6,
attribute7 = X_Attribute7,
attribute8 = X_Attribute8,
attribute9 = X_Attribute9,
attribute10 = X_Attribute10,
attribute11 = X_Attribute11,
attribute12 = X_Attribute12,
attribute13 = X_Attribute13,
attribute14 = X_Attribute14,
attribute15 = X_Attribute15,
attribute_category_code = X_Attribute_Category_Code,
exclude_salvage_value_flag = X_Exclude_Salvage_Value_Flag,
deprn_basis_formula = X_Deprn_Basis_Formula,
polish_adj_calc_basis_flag = X_Polish_Adj_Calc_Basis_Flag,
guarantee_rate_method_flag = X_Guarantee_Rate_Method_Flag,
deprn_basis_rule_id = X_Deprn_Basis_Rule_Id,
jp_imp_calc_basis_flag = x_jp_imp_calc_basis_flag
WHERE method_code = X_Method_Code
AND life_in_months = X_Life_In_Months;
UPDATE fa_methods
SET deprn_basis_rule_id =
(SELECT deprn_basis_rule_id
FROM fa_deprn_basis_rules
WHERE RULE_NAME='TRANSACTION')
WHERE rate_source_rule='FLAT'
AND deprn_basis_rule='NBV'
AND deprn_basis_formula IS NULL
AND deprn_basis_rule_id IS NULL
AND method_code = X_Method_Code
AND life_in_months = X_Life_In_Months;
UPDATE fa_methods
SET deprn_basis_rule_id =
(SELECT deprn_basis_rule_id
FROM fa_deprn_basis_rules
WHERE RULE_NAME='FYBEGIN')
WHERE rate_source_rule='FLAT'
AND deprn_basis_rule='NBV'
AND deprn_basis_formula ='STRICT_FLAT'
AND deprn_basis_rule_id IS NULL
AND method_code = X_Method_Code
AND life_in_months = X_Life_In_Months;
UPDATE fa_methods
SET
depreciate_lastyear_flag = X_Depreciate_Lastyear_Flag,
stl_method_flag = X_Stl_Method_Flag,
rate_source_rule = X_Rate_Source_Rule,
deprn_basis_rule = X_Deprn_Basis_Rule,
prorate_periods_per_year = X_Prorate_Periods_Per_Year,
name = X_Name,
last_update_date = X_Last_Update_Date,
last_updated_by = X_Last_Updated_By,
last_update_login = X_Last_Update_Login,
attribute1 = X_Attribute1,
attribute2 = X_Attribute2,
attribute3 = X_Attribute3,
attribute4 = X_Attribute4,
attribute5 = X_Attribute5,
attribute6 = X_Attribute6,
attribute7 = X_Attribute7,
attribute8 = X_Attribute8,
attribute9 = X_Attribute9,
attribute10 = X_Attribute10,
attribute11 = X_Attribute11,
attribute12 = X_Attribute12,
attribute13 = X_Attribute13,
attribute14 = X_Attribute14,
attribute15 = X_Attribute15,
attribute_category_code = X_Attribute_Category_Code,
exclude_salvage_value_flag = X_Exclude_Salvage_Value_Flag,
deprn_basis_formula = X_Deprn_Basis_Formula,
polish_adj_calc_basis_flag = X_Polish_Adj_Calc_Basis_Flag,
guarantee_rate_method_flag = X_Guarantee_Rate_Method_Flag,
deprn_basis_rule_id = X_Deprn_Basis_Rule_Id,
jp_imp_calc_basis_flag = x_jp_imp_calc_basis_flag
WHERE method_code = X_Method_Code
AND life_in_months is null;
UPDATE fa_methods
SET deprn_basis_rule_id =
(SELECT deprn_basis_rule_id
FROM fa_deprn_basis_rules
WHERE RULE_NAME='TRANSACTION')
WHERE rate_source_rule='FLAT'
AND deprn_basis_rule='NBV'
AND deprn_basis_formula IS NULL
AND deprn_basis_rule_id IS NULL
AND method_code = X_Method_Code
AND life_in_months is null;
UPDATE fa_methods
SET deprn_basis_rule_id =
(SELECT deprn_basis_rule_id
FROM fa_deprn_basis_rules
WHERE RULE_NAME='FYBEGIN')
WHERE rate_source_rule='FLAT'
AND deprn_basis_rule='NBV'
AND deprn_basis_formula ='STRICT_FLAT'
AND deprn_basis_rule_id IS NULL
AND method_code = X_Method_Code
AND life_in_months is null;
calling_fn => 'fa_methods_pkg.update_row', p_log_level_rec => p_log_level_rec);
CALLED_FN => 'fa_methods_pkg.update_row',
CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec);
END Update_Row;
PROCEDURE Delete_Row(X_Rowid VARCHAR2,
X_Calling_Fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
BEGIN
ad_zd_seed.prepare('fa_methods');
DELETE FROM fa_methods
WHERE rowid = X_Rowid;
calling_fn => 'fa_methods_pkg.delete_row', p_log_level_rec => p_log_level_rec);
CALLED_FN => 'fa_methods_pkg.delete_row',
CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec);
end DELETE_ROW;
select count(*)
into h_record_exists
from fa_methods
where method_code = X_Method_Code
and life_in_months = X_Life_In_Months;
select count(*)
into h_record_exists
from fa_methods
where method_code = X_Method_Code
and life_in_months is null;
fa_methods_pkg.update_row (
X_Rowid => row_id,
X_Method_ID => h_method_id,
X_Method_Code => X_Method_Code,
X_Life_In_Months => X_Life_In_Months,
X_Depreciate_Lastyear_Flag => X_Depreciate_Lastyear_Flag,
X_Stl_Method_Flag => X_Stl_Method_Flag,
X_Rate_Source_Rule => X_Rate_Source_Rule,
X_Deprn_Basis_Rule => X_Deprn_Basis_Rule,
X_Prorate_Periods_Per_Year => X_Prorate_Periods_Per_Year,
X_Name => X_Name,
X_Last_Update_Date => sysdate,
X_Last_Updated_By => user_id,
X_Last_Update_Login => 0,
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_Attribute_Category_Code => X_Attribute_Category_Code,
X_Exclude_Salvage_Value_Flag => X_Exclude_Salvage_Value_Flag,
X_Deprn_Basis_Formula => X_Deprn_Basis_Formula,
X_Polish_Adj_Calc_Basis_Flag => X_Polish_Adj_Calc_Basis_Flag,
X_Guarantee_Rate_Method_Flag => X_Guarantee_Rate_Method_Flag,
X_Calling_Fn => 'fa_methods_pkg.load_row',
X_Deprn_Basis_Rule_Id => X_Deprn_Basis_Rule_Id,
x_jp_imp_calc_basis_flag => x_jp_imp_calc_basis_flag
, p_log_level_rec => p_log_level_rec);
fa_methods_pkg.insert_row (
X_Rowid => row_id,
X_Method_ID => h_method_id,
X_Method_Code => X_Method_Code,
X_Life_In_Months => X_Life_In_Months,
X_Depreciate_Lastyear_Flag => X_Depreciate_Lastyear_Flag,
X_Stl_Method_Flag => X_Stl_Method_Flag,
X_Rate_Source_Rule => X_Rate_Source_Rule,
X_Deprn_Basis_Rule => X_Deprn_Basis_Rule,
X_Prorate_Periods_Per_Year => X_Prorate_Periods_Per_Year,
X_Name => X_Name,
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_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_Attribute_Category_Code => X_Attribute_Category_Code,
X_Exclude_Salvage_Value_Flag => X_Exclude_Salvage_Value_Flag,
X_Deprn_Basis_Formula => X_Deprn_Basis_Formula,
X_Polish_Adj_Calc_Basis_Flag => X_Polish_Adj_Calc_Basis_Flag,
X_Guarantee_Rate_Method_Flag => X_Guarantee_Rate_Method_Flag,
X_Calling_Fn => 'fa_methods_pkg.load_row',
X_Deprn_Basis_Rule_Id => X_Deprn_Basis_Rule_Id,
x_jp_imp_calc_basis_flag => x_jp_imp_calc_basis_flag
, p_log_level_rec => p_log_level_rec);
X_DB_LAST_UPDATED_BY NUMBER,
X_DB_LAST_UPDATE_DATE DATE,
X_OWNER in VARCHAR2,
X_LAST_UPDATE_DATE in DATE,
X_METHOD_CODE in VARCHAR2,
X_LIFE_IN_MONTHS in NUMBER,
X_DEPRECIATE_LASTYEAR_FLAG in VARCHAR2,
X_STL_METHOD_FLAG in VARCHAR2,
X_RATE_SOURCE_RULE in VARCHAR2,
X_DEPRN_BASIS_RULE in VARCHAR2,
X_PRORATE_PERIODS_PER_YEAR in NUMBER,
X_NAME 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_ATTRIBUTE_CATEGORY_CODE in VARCHAR2,
X_EXCLUDE_SALVAGE_VALUE_FLAG in VARCHAR2,
-- added for alternative flat depreciatio calculation. for 11.5.2
X_DEPRN_BASIS_FORMULA in VARCHAR2,
X_POLISH_ADJ_CALC_BASIS_FLAG in VARCHAR2,
X_GUARANTEE_RATE_METHOD_FLAG in VARCHAR2,
-- added for Depreciable Basis Formula
X_DEPRN_BASIS_RULE_ID in NUMBER DEFAULT NULL,
X_JP_IMP_CALC_BASIS_FLAG IN VARCHAR2 DEFAULT NULL,
p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is
h_record_exists number(15);
if (fnd_load_util.upload_test(user_id, x_last_update_date,
X_db_last_updated_by, X_db_last_update_date,
X_CUSTOM_MODE)) then
fa_methods_pkg.update_row (
X_Rowid => row_id,
X_Method_ID => h_method_id,
X_Method_Code => X_Method_Code,
X_Life_In_Months => X_Life_In_Months,
X_Depreciate_Lastyear_Flag => X_Depreciate_Lastyear_Flag,
X_Stl_Method_Flag => X_Stl_Method_Flag,
X_Rate_Source_Rule => X_Rate_Source_Rule,
X_Deprn_Basis_Rule => X_Deprn_Basis_Rule,
X_Prorate_Periods_Per_Year => X_Prorate_Periods_Per_Year,
X_Name => X_Name,
X_Last_Update_Date => sysdate,
X_Last_Updated_By => user_id,
X_Last_Update_Login => 0,
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_Attribute_Category_Code => X_Attribute_Category_Code,
X_Exclude_Salvage_Value_Flag => X_Exclude_Salvage_Value_Flag,
X_Deprn_Basis_Formula => X_Deprn_Basis_Formula,
X_Polish_Adj_Calc_Basis_Flag => X_Polish_Adj_Calc_Basis_Flag,
X_Guarantee_Rate_Method_Flag => X_Guarantee_Rate_Method_Flag,
X_Calling_Fn => 'fa_methods_pkg.load_row',
X_Deprn_Basis_Rule_Id => X_Deprn_Basis_Rule_Id,
x_jp_imp_calc_basis_flag => x_jp_imp_calc_basis_flag
,p_log_level_rec => p_log_level_rec);
fa_methods_pkg.insert_row (
X_Rowid => row_id,
X_Method_ID => h_method_id,
X_Method_Code => X_Method_Code,
X_Life_In_Months => X_Life_In_Months,
X_Depreciate_Lastyear_Flag => X_Depreciate_Lastyear_Flag,
X_Stl_Method_Flag => X_Stl_Method_Flag,
X_Rate_Source_Rule => X_Rate_Source_Rule,
X_Deprn_Basis_Rule => X_Deprn_Basis_Rule,
X_Prorate_Periods_Per_Year => X_Prorate_Periods_Per_Year,
X_Name => X_Name,
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_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_Attribute_Category_Code => X_Attribute_Category_Code,
X_Exclude_Salvage_Value_Flag => X_Exclude_Salvage_Value_Flag,
X_Deprn_Basis_Formula => X_Deprn_Basis_Formula,
X_Polish_Adj_Calc_Basis_Flag => X_Polish_Adj_Calc_Basis_Flag,
X_Guarantee_Rate_Method_Flag => X_Guarantee_Rate_Method_Flag,
X_Calling_Fn => 'fa_methods_pkg.load_row',
X_Deprn_Basis_Rule_Id => X_Deprn_Basis_Rule_Id,
x_jp_imp_calc_basis_flag => x_jp_imp_calc_basis_flag
,p_log_level_rec => p_log_level_rec);
/*Bugfix 6449856: Use method_code and life_in_months to update
* the appropriate row instead of method_id. This is because
* for new methods, method_id will be different from what is being
* passed from ldt file. fyi, LOAD_ROW procedure passes method_id
* as null to INSERT_ROW. To translate the new row, we need to make use
* of method_code and life_in_months.
* */
if (X_Life_In_Months is not null) then
update FA_METHODS set
NAME = nvl(X_Name, Name),
LAST_UPDATE_DATE = sysdate,
LAST_UPDATED_BY = user_id,
LAST_UPDATE_LOGIN = 0
--where METHOD_ID = X_Method_ID
where method_code = X_Method_Code
and life_in_months = X_Life_In_Months
and userenv('LANG') =
(select language_code
from FND_LANGUAGES
where installed_flag = 'B');
update FA_METHODS set
NAME = nvl(X_Name, Name),
LAST_UPDATE_DATE = sysdate,
LAST_UPDATED_BY = user_id,
LAST_UPDATE_LOGIN = 0
--where METHOD_ID = X_Method_ID
where method_code = X_Method_Code
and life_in_months is null
and userenv('LANG') =
(select language_code
from FND_LANGUAGES
where installed_flag = 'B');
X_DB_LAST_UPDATED_BY NUMBER,
X_DB_LAST_UPDATE_DATE DATE,
X_OWNER in VARCHAR2,
X_LAST_UPDATE_DATE DATE,
X_NAME in VARCHAR2,
p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is
user_id number;
if (fnd_load_util.upload_test(user_id, x_last_update_date,
x_db_last_updated_by, x_db_last_update_date,
X_CUSTOM_MODE)) then
/*Bugfix 6685881: Use method_code and life_in_months to update
* the appropriate row instead of method_id. This is because
* for new methods, method_id will be different from what is being
* passed from ldt file. fyi, LOAD_ROW procedure passes method_id
* as null to INSERT_ROW. To translate the new row, we need to make use
* of method_code and life_in_months.
* */
if (X_Life_In_Months is not null) then
update FA_METHODS
set NAME = nvl(X_Name, Name),
LAST_UPDATE_DATE = sysdate,
LAST_UPDATED_BY = user_id
--where METHOD_ID = X_Method_ID
where method_code = X_Method_Code
and life_in_months = X_Life_In_Months
and userenv('LANG') =
(select language_code
from FND_LANGUAGES
where installed_flag = 'B');
update FA_METHODS set
NAME = nvl(X_Name, Name),
LAST_UPDATE_DATE = sysdate,
LAST_UPDATED_BY = user_id,
LAST_UPDATE_LOGIN = 0
--where METHOD_ID = X_Method_ID
where method_code = X_Method_Code
and life_in_months is null
and userenv('LANG') =
(select language_code
from FND_LANGUAGES
where installed_flag = 'B');
x_last_update_date IN DATE,
x_method_code IN VARCHAR2,
x_life_in_months IN NUMBER,
x_depreciate_lastyear_flag IN VARCHAR2,
x_stl_method_flag IN VARCHAR2,
x_rate_source_rule IN VARCHAR2,
x_deprn_basis_rule IN VARCHAR2,
x_prorate_periods_per_year IN NUMBER,
x_name 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_attribute_category_code IN VARCHAR2,
x_exclude_salvage_value_flag IN VARCHAR2,
x_deprn_basis_formula IN VARCHAR2,
X_Polish_Adj_Calc_Basis_Flag IN VARCHAR2,
X_Guarantee_Rate_Method_Flag IN VARCHAR2,
x_deprn_basis_rule_id IN NUMBER,
x_jp_imp_calc_basis_flag IN VARCHAR2) IS
h_method_id number(15);
h_last_update_date date;
h_last_updated_by number;
h_last_update_date := fa_cache_pkg.fazccmt_record.last_update_date;
h_last_updated_by := fa_cache_pkg.fazccmt_record.last_updated_by;
x_db_last_update_date => h_last_update_date,
x_db_last_updated_by => h_last_updated_by,
x_owner => x_owner,
x_last_update_date => x_last_update_date,
x_name => x_name);
x_db_last_update_date => h_last_update_date,
x_db_last_updated_by => h_last_updated_by,
x_owner => x_owner,
x_last_update_date => x_last_update_date,
x_method_code => x_method_code,
x_life_in_months => x_life_in_months,
x_depreciate_lastyear_flag => x_depreciate_lastyear_flag,
x_stl_method_flag => x_stl_method_flag,
x_rate_source_rule => x_rate_source_rule,
x_deprn_basis_rule => x_deprn_basis_rule,
x_prorate_periods_per_year => x_prorate_periods_per_year,
x_name => x_name,
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_attribute14,
x_attribute_category_code => x_attribute_category_code,
x_exclude_salvage_value_flag => x_exclude_salvage_value_flag,
x_deprn_basis_formula => x_deprn_basis_formula,
X_Polish_Adj_Calc_Basis_Flag => X_Polish_Adj_Calc_Basis_Flag,
X_Guarantee_Rate_Method_Flag => X_Guarantee_Rate_Method_Flag,
x_deprn_basis_rule_id => x_deprn_basis_rule_id,
x_jp_imp_calc_basis_flag => x_jp_imp_calc_basis_flag);