The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure INSERT_ROW (
X_ROWID in out nocopy VARCHAR2,
X_CATEGORY_ID in NUMBER,
X_SUMMARY_FLAG in VARCHAR2,
X_ENABLED_FLAG in VARCHAR2,
X_OWNED_LEASED in VARCHAR2,
X_CATEGORY_TYPE in VARCHAR2,
X_CAPITALIZE_FLAG in VARCHAR2,
X_DESCRIPTION in VARCHAR2,
X_SEGMENT1 in VARCHAR2,
X_SEGMENT2 in VARCHAR2,
X_SEGMENT3 in VARCHAR2,
X_SEGMENT4 in VARCHAR2,
X_SEGMENT5 in VARCHAR2,
X_SEGMENT6 in VARCHAR2,
X_SEGMENT7 in VARCHAR2,
X_START_DATE_ACTIVE in DATE,
X_END_DATE_ACTIVE in DATE,
X_PROPERTY_TYPE_CODE in VARCHAR2,
X_PROPERTY_1245_1250_CODE in VARCHAR2,
X_DATE_INEFFECTIVE in DATE,
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_ATTRIBUTE_CATEGORY_CODE in VARCHAR2 DEFAULT NULL,
X_PRODUCTION_CAPACITY in NUMBER DEFAULT NULL,
X_GLOBAL_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE16 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE17 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE18 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE19 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE20 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
X_INVENTORIAL in VARCHAR2,
X_CREATION_DATE in DATE,
X_CREATED_BY in NUMBER,
X_LAST_UPDATE_DATE in DATE,
X_LAST_UPDATED_BY in NUMBER,
X_LAST_UPDATE_LOGIN in NUMBER,
p_log_level_rec in fa_api_types.log_level_rec_type default null) is
cursor C is select ROWID from FA_CATEGORIES_B
where CATEGORY_ID = X_CATEGORY_ID
;
insert into FA_CATEGORIES_B (
CATEGORY_ID,
SUMMARY_FLAG,
ENABLED_FLAG,
OWNED_LEASED,
CATEGORY_TYPE,
CAPITALIZE_FLAG,
SEGMENT1,
SEGMENT2,
SEGMENT3,
SEGMENT4,
SEGMENT5,
SEGMENT6,
SEGMENT7,
START_DATE_ACTIVE,
END_DATE_ACTIVE,
PROPERTY_TYPE_CODE,
PROPERTY_1245_1250_CODE,
DATE_INEFFECTIVE,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ATTRIBUTE_CATEGORY_CODE,
PRODUCTION_CAPACITY,
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,
INVENTORIAL,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN
) values (
X_CATEGORY_ID,
X_SUMMARY_FLAG,
X_ENABLED_FLAG,
X_OWNED_LEASED,
X_CATEGORY_TYPE,
X_CAPITALIZE_FLAG,
X_SEGMENT1,
X_SEGMENT2,
X_SEGMENT3,
X_SEGMENT4,
X_SEGMENT5,
X_SEGMENT6,
X_SEGMENT7,
X_START_DATE_ACTIVE,
X_END_DATE_ACTIVE,
X_PROPERTY_TYPE_CODE,
X_PROPERTY_1245_1250_CODE,
X_DATE_INEFFECTIVE,
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_PRODUCTION_CAPACITY,
X_GLOBAL_ATTRIBUTE1,
X_GLOBAL_ATTRIBUTE2,
X_GLOBAL_ATTRIBUTE3,
X_GLOBAL_ATTRIBUTE4,
X_GLOBAL_ATTRIBUTE5,
X_GLOBAL_ATTRIBUTE6,
X_GLOBAL_ATTRIBUTE7,
X_GLOBAL_ATTRIBUTE8,
X_GLOBAL_ATTRIBUTE9,
X_GLOBAL_ATTRIBUTE10,
X_GLOBAL_ATTRIBUTE11,
X_GLOBAL_ATTRIBUTE12,
X_GLOBAL_ATTRIBUTE13,
X_GLOBAL_ATTRIBUTE14,
X_GLOBAL_ATTRIBUTE15,
X_GLOBAL_ATTRIBUTE16,
X_GLOBAL_ATTRIBUTE17,
X_GLOBAL_ATTRIBUTE18,
X_GLOBAL_ATTRIBUTE19,
X_GLOBAL_ATTRIBUTE20,
X_GLOBAL_ATTRIBUTE_CATEGORY,
X_INVENTORIAL,
X_CREATION_DATE,
X_CREATED_BY,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN
);
insert into FA_CATEGORIES_TL (
DESCRIPTION,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATED_BY,
CREATION_DATE,
LAST_UPDATE_LOGIN,
CATEGORY_ID,
LANGUAGE,
SOURCE_LANG
) select
X_DESCRIPTION,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_CREATED_BY,
X_CREATION_DATE,
X_LAST_UPDATE_LOGIN,
X_CATEGORY_ID,
L.LANGUAGE_CODE,
userenv('LANG')
from FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I', 'B')
and not exists
(select NULL
from FA_CATEGORIES_TL T
where T.CATEGORY_ID = X_CATEGORY_ID
and T.LANGUAGE = L.LANGUAGE_CODE);
end INSERT_ROW;
cursor c is select
SUMMARY_FLAG,
ENABLED_FLAG,
OWNED_LEASED,
CATEGORY_TYPE,
CAPITALIZE_FLAG,
SEGMENT1,
SEGMENT2,
SEGMENT3,
SEGMENT4,
SEGMENT5,
SEGMENT6,
SEGMENT7,
START_DATE_ACTIVE,
END_DATE_ACTIVE,
PROPERTY_TYPE_CODE,
PROPERTY_1245_1250_CODE,
DATE_INEFFECTIVE,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ATTRIBUTE_CATEGORY_CODE,
PRODUCTION_CAPACITY,
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,
INVENTORIAL
from FA_CATEGORIES_B
where CATEGORY_ID = X_CATEGORY_ID
for update of CATEGORY_ID nowait;
cursor c1 is select
DESCRIPTION,
decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
from FA_CATEGORIES_TL
where CATEGORY_ID = X_CATEGORY_ID
and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
for update of CATEGORY_ID nowait;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
procedure UPDATE_ROW (
X_CATEGORY_ID in NUMBER,
X_SUMMARY_FLAG in VARCHAR2,
X_ENABLED_FLAG in VARCHAR2,
X_OWNED_LEASED in VARCHAR2,
X_CATEGORY_TYPE in VARCHAR2,
X_CAPITALIZE_FLAG in VARCHAR2,
X_DESCRIPTION in VARCHAR2,
X_SEGMENT1 in VARCHAR2,
X_SEGMENT2 in VARCHAR2,
X_SEGMENT3 in VARCHAR2,
X_SEGMENT4 in VARCHAR2,
X_SEGMENT5 in VARCHAR2,
X_SEGMENT6 in VARCHAR2,
X_SEGMENT7 in VARCHAR2,
X_START_DATE_ACTIVE in DATE,
X_END_DATE_ACTIVE in DATE,
X_PROPERTY_TYPE_CODE in VARCHAR2,
X_PROPERTY_1245_1250_CODE in VARCHAR2,
X_DATE_INEFFECTIVE in DATE,
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_ATTRIBUTE_CATEGORY_CODE in VARCHAR2 DEFAULT NULL,
X_PRODUCTION_CAPACITY in NUMBER DEFAULT NULL,
X_GLOBAL_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE16 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE17 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE18 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE19 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE20 in VARCHAR2 DEFAULT NULL,
X_GLOBAL_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
X_INVENTORIAL in VARCHAR2,
X_LAST_UPDATE_DATE in DATE,
X_LAST_UPDATED_BY in NUMBER,
X_LAST_UPDATE_LOGIN in NUMBER,
p_log_level_rec in fa_api_types.log_level_rec_type default null) is
begin
update FA_CATEGORIES_B set
SUMMARY_FLAG = X_SUMMARY_FLAG,
ENABLED_FLAG = X_ENABLED_FLAG,
OWNED_LEASED = X_OWNED_LEASED,
CATEGORY_TYPE = X_CATEGORY_TYPE,
CAPITALIZE_FLAG = X_CAPITALIZE_FLAG,
SEGMENT1 = X_SEGMENT1,
SEGMENT2 = X_SEGMENT2,
SEGMENT3 = X_SEGMENT3,
SEGMENT4 = X_SEGMENT4,
SEGMENT5 = X_SEGMENT5,
SEGMENT6 = X_SEGMENT6,
SEGMENT7 = X_SEGMENT7,
START_DATE_ACTIVE = X_START_DATE_ACTIVE,
END_DATE_ACTIVE = X_END_DATE_ACTIVE,
PROPERTY_TYPE_CODE = X_PROPERTY_TYPE_CODE,
PROPERTY_1245_1250_CODE = X_PROPERTY_1245_1250_CODE,
DATE_INEFFECTIVE = X_DATE_INEFFECTIVE,
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,
PRODUCTION_CAPACITY = X_PRODUCTION_CAPACITY,
GLOBAL_ATTRIBUTE1 = X_GLOBAL_ATTRIBUTE1,
GLOBAL_ATTRIBUTE2 = X_GLOBAL_ATTRIBUTE2,
GLOBAL_ATTRIBUTE3 = X_GLOBAL_ATTRIBUTE3,
GLOBAL_ATTRIBUTE4 = X_GLOBAL_ATTRIBUTE4,
GLOBAL_ATTRIBUTE5 = X_GLOBAL_ATTRIBUTE5,
GLOBAL_ATTRIBUTE6 = X_GLOBAL_ATTRIBUTE6,
GLOBAL_ATTRIBUTE7 = X_GLOBAL_ATTRIBUTE7,
GLOBAL_ATTRIBUTE8 = X_GLOBAL_ATTRIBUTE8,
GLOBAL_ATTRIBUTE9 = X_GLOBAL_ATTRIBUTE9,
GLOBAL_ATTRIBUTE10 = X_GLOBAL_ATTRIBUTE10,
GLOBAL_ATTRIBUTE11 = X_GLOBAL_ATTRIBUTE11,
GLOBAL_ATTRIBUTE12 = X_GLOBAL_ATTRIBUTE12,
GLOBAL_ATTRIBUTE13 = X_GLOBAL_ATTRIBUTE13,
GLOBAL_ATTRIBUTE14 = X_GLOBAL_ATTRIBUTE14,
GLOBAL_ATTRIBUTE15 = X_GLOBAL_ATTRIBUTE15,
GLOBAL_ATTRIBUTE16 = X_GLOBAL_ATTRIBUTE16,
GLOBAL_ATTRIBUTE17 = X_GLOBAL_ATTRIBUTE17,
GLOBAL_ATTRIBUTE18 = X_GLOBAL_ATTRIBUTE18,
GLOBAL_ATTRIBUTE19 = X_GLOBAL_ATTRIBUTE19,
GLOBAL_ATTRIBUTE20 = X_GLOBAL_ATTRIBUTE20,
GLOBAL_ATTRIBUTE_CATEGORY = X_GLOBAL_ATTRIBUTE_CATEGORY,
INVENTORIAL = X_INVENTORIAL,
LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
LAST_UPDATED_BY = X_LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
where CATEGORY_ID = X_CATEGORY_ID;
update FA_CATEGORIES_TL set
DESCRIPTION = X_DESCRIPTION,
LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
LAST_UPDATED_BY = X_LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
SOURCE_LANG = userenv('LANG')
where CATEGORY_ID = X_CATEGORY_ID
and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
end UPDATE_ROW;
procedure DELETE_ROW (
X_CATEGORY_ID in NUMBER
,p_log_level_rec in fa_api_types.log_level_rec_type default null) is
begin
delete from FA_CATEGORIES_TL
where CATEGORY_ID = X_CATEGORY_ID;
delete from FA_CATEGORIES_B
where CATEGORY_ID = X_CATEGORY_ID;
end DELETE_ROW;
delete from FA_CATEGORIES_TL T
where not exists
(select NULL
from FA_CATEGORIES_B B
where B.CATEGORY_ID = T.CATEGORY_ID
);
update FA_CATEGORIES_TL T set (
DESCRIPTION
) = (select
B.DESCRIPTION
from FA_CATEGORIES_TL B
where B.CATEGORY_ID = T.CATEGORY_ID
and B.LANGUAGE = T.SOURCE_LANG)
where (
T.CATEGORY_ID,
T.LANGUAGE
) in (select
SUBT.CATEGORY_ID,
SUBT.LANGUAGE
from FA_CATEGORIES_TL SUBB, FA_CATEGORIES_TL SUBT
where SUBB.CATEGORY_ID = SUBT.CATEGORY_ID
and SUBB.LANGUAGE = SUBT.SOURCE_LANG
and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
));
insert into FA_CATEGORIES_TL (
DESCRIPTION,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATED_BY,
CREATION_DATE,
LAST_UPDATE_LOGIN,
CATEGORY_ID,
LANGUAGE,
SOURCE_LANG
) select
B.DESCRIPTION,
B.LAST_UPDATE_DATE,
B.LAST_UPDATED_BY,
B.CREATED_BY,
B.CREATION_DATE,
B.LAST_UPDATE_LOGIN,
B.CATEGORY_ID,
L.LANGUAGE_CODE,
B.SOURCE_LANG
from FA_CATEGORIES_TL B, FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I', 'B')
and B.LANGUAGE = userenv('LANG')
and not exists
(select NULL
from FA_CATEGORIES_TL T
where T.CATEGORY_ID = B.CATEGORY_ID
and T.LANGUAGE = L.LANGUAGE_CODE);
X_LAST_UPDATE_DATE in DATE,
X_SUMMARY_FLAG in VARCHAR2,
X_ENABLED_FLAG in VARCHAR2,
X_OWNED_LEASED in VARCHAR2,
X_PRODUCTION_CAPACITY in NUMBER DEFAULT NULL,
X_CATEGORY_TYPE in VARCHAR2,
X_CAPITALIZE_FLAG in VARCHAR2,
X_DESCRIPTION in VARCHAR2,
X_SEGMENT1 in VARCHAR2,
X_SEGMENT2 in VARCHAR2,
X_SEGMENT3 in VARCHAR2,
X_SEGMENT4 in VARCHAR2,
X_SEGMENT5 in VARCHAR2,
X_SEGMENT6 in VARCHAR2,
X_SEGMENT7 in VARCHAR2,
X_START_DATE_ACTIVE in DATE,
X_END_DATE_ACTIVE in DATE,
X_PROPERTY_TYPE_CODE in VARCHAR2,
X_PROPERTY_1245_1250_CODE in VARCHAR2,
X_DATE_INEFFECTIVE in DATE,
X_INVENTORIAL 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_ATTRIBUTE_CATEGORY_CODE 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_record_exists number(15);
db_last_updated_by number;
db_last_update_date date;
select count(*)
into h_record_exists
from fa_categories_b
where category_id = X_Category_Id;
select last_updated_by, last_update_date
into db_last_updated_by, db_last_update_date
from fa_categories_b
where category_id = X_Category_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_categories_pkg.update_row (
X_Category_ID => X_Category_Id,
X_Summary_Flag => X_Summary_Flag,
X_Enabled_Flag => X_Enabled_Flag,
X_Owned_Leased => X_Owned_Leased,
X_Category_Type => X_Category_Type,
X_Capitalize_Flag => X_Capitalize_Flag,
X_Description => X_Description,
X_Segment1 => X_Segment1,
X_Segment2 => X_Segment2,
X_Segment3 => X_Segment3,
X_Segment4 => X_Segment4,
X_Segment5 => X_Segment5,
X_Segment6 => X_Segment6,
X_Segment7 => X_Segment7,
X_Start_Date_Active => X_Start_Date_Active,
X_End_Date_Active => X_End_Date_Active,
X_Property_Type_Code => X_Property_Type_Code,
X_Property_1245_1250_Code => X_Property_1245_1250_Code,
X_Date_Ineffective => X_Date_Ineffective,
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_Production_Capacity => X_Production_Capacity,
X_Global_Attribute1 => X_gf_Attribute1,
X_Global_Attribute2 => X_gf_Attribute2,
X_Global_Attribute3 => X_gf_Attribute3,
X_Global_Attribute4 => X_gf_Attribute4,
X_Global_Attribute5 => X_gf_Attribute5,
X_Global_Attribute6 => X_gf_Attribute6,
X_Global_Attribute7 => X_gf_Attribute7,
X_Global_Attribute8 => X_gf_Attribute8,
X_Global_Attribute9 => X_gf_Attribute9,
X_Global_Attribute10 => X_gf_Attribute10,
X_Global_Attribute11 => X_gf_Attribute11,
X_Global_Attribute12 => X_gf_Attribute12,
X_Global_Attribute13 => X_gf_Attribute13,
X_Global_Attribute14 => X_gf_Attribute14,
X_Global_Attribute15 => X_gf_Attribute15,
X_Global_Attribute16 => X_gf_Attribute16,
X_Global_Attribute17 => X_gf_Attribute17,
X_Global_Attribute18 => X_gf_Attribute18,
X_Global_Attribute19 => X_gf_Attribute19,
X_Global_Attribute20 => X_gf_Attribute20,
X_Inventorial => X_Inventorial,
X_Last_Update_Date => sysdate,
X_Last_Updated_By => user_id,
X_Last_Update_Login => 0
,p_log_level_rec => p_log_level_rec);
fa_categories_pkg.insert_row (
X_Rowid => row_id,
X_Category_Id => X_Category_Id,
X_Summary_Flag => X_Summary_Flag,
X_Enabled_Flag => X_Enabled_Flag,
X_Owned_Leased => X_Owned_Leased,
X_Category_Type => X_Category_Type,
X_Capitalize_Flag => X_Capitalize_Flag,
X_Description => X_Description,
X_Segment1 => X_Segment1,
X_Segment2 => X_Segment2,
X_Segment3 => X_Segment3,
X_Segment4 => X_Segment4,
X_Segment5 => X_Segment5,
X_Segment6 => X_Segment6,
X_Segment7 => X_Segment7,
X_Start_Date_Active => X_Start_Date_Active,
X_End_Date_Active => X_End_Date_Active,
X_Property_Type_Code => X_Property_Type_Code,
X_Property_1245_1250_Code => X_Property_1245_1250_Code,
X_Date_Ineffective => X_Date_Ineffective,
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_Production_Capacity => X_Production_Capacity,
X_Global_Attribute1 => X_gf_Attribute1,
X_Global_Attribute2 => X_gf_Attribute2,
X_Global_Attribute3 => X_gf_Attribute3,
X_Global_Attribute4 => X_gf_Attribute4,
X_Global_Attribute5 => X_gf_Attribute5,
X_Global_Attribute6 => X_gf_Attribute6,
X_Global_Attribute7 => X_gf_Attribute7,
X_Global_Attribute8 => X_gf_Attribute8,
X_Global_Attribute9 => X_gf_Attribute9,
X_Global_Attribute10 => X_gf_Attribute10,
X_Global_Attribute11 => X_gf_Attribute11,
X_Global_Attribute12 => X_gf_Attribute12,
X_Global_Attribute13 => X_gf_Attribute13,
X_Global_Attribute14 => X_gf_Attribute14,
X_Global_Attribute15 => X_gf_Attribute15,
X_Global_Attribute16 => X_gf_Attribute16,
X_Global_Attribute17 => X_gf_Attribute17,
X_Global_Attribute18 => X_gf_Attribute18,
X_Global_Attribute19 => X_gf_Attribute19,
X_Global_Attribute20 => X_gf_Attribute20,
X_Inventorial => X_Inventorial,
X_Creation_Date => sysdate,
X_Created_By => user_id,
X_Last_Update_Date => sysdate,
X_Last_Updated_By => user_id,
X_Last_Update_Login => 0
,p_log_level_rec => p_log_level_rec);
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_categories_tl
where category_id = X_Category_Id
and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
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_CATEGORIES_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 CATEGORY_ID = X_Category_ID;
x_last_update_date IN DATE,
x_summary_flag IN VARCHAR2,
x_enabled_flag IN VARCHAR2,
x_owned_leased IN VARCHAR2,
x_production_capacity IN NUMBER,
x_category_type IN VARCHAR2,
x_capitalize_flag IN VARCHAR2,
x_description IN VARCHAR2,
x_segment1 IN VARCHAR2,
x_segment2 IN VARCHAR2,
x_segment3 IN VARCHAR2,
x_segment4 IN VARCHAR2,
x_segment5 IN VARCHAR2,
x_segment6 IN VARCHAR2,
x_segment7 IN VARCHAR2,
x_start_date_active IN DATE,
x_end_date_active IN DATE,
x_property_type_code IN VARCHAR2,
x_property_1245_1250_code IN VARCHAR2,
x_date_ineffective IN DATE,
x_inventorial 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_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) IS
BEGIN
if (x_upload_mode = 'NLS') then
fa_categories_pkg.TRANSLATE_ROW (
x_custom_mode => x_custom_mode,
x_category_id => x_category_id,
x_owner => x_owner,
x_last_update_date => x_last_update_date,
x_description => x_description);
x_last_update_date => x_last_update_date,
x_summary_flag => x_summary_flag,
x_enabled_flag => x_enabled_flag,
x_owned_leased => x_owned_leased,
x_production_capacity => x_production_capacity,
x_category_type => x_category_type,
x_capitalize_flag => x_capitalize_flag,
x_description => x_description,
x_segment1 => x_segment1,
x_segment2 => x_segment2,
x_segment3 => x_segment3,
x_segment4 => x_segment4,
x_segment5 => x_segment5,
x_segment6 => x_segment6,
x_segment7 => x_segment7,
x_start_date_active => x_start_date_active,
x_end_date_active => x_end_date_active,
x_property_type_code => x_property_type_code,
x_property_1245_1250_code => x_property_1245_1250_code,
x_date_ineffective => x_date_ineffective,
x_inventorial => x_inventorial,
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_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);