The following lines contain the word 'select', 'insert', 'update' or 'delete':
conv_tbl.delete;
| PROCEDURE Insert_Itf |
+=====================================================================================*/
PROCEDURE Insert_Itf(
X_Report_Type IN VARCHAR2,
X_Request_Id IN NUMBER,
X_Mass_Reclass_Id IN NUMBER,
X_Asset_Rec IN ASSET_REC,
X_New_Category IN VARCHAR2 := NULL,
X_Last_Update_Date IN DATE,
X_Last_Updated_By IN NUMBER,
X_Created_By IN NUMBER,
X_Creation_Date IN DATE,
X_Last_Update_Login IN NUMBER,
p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
-- cursor to fetch the meaning for depreciate flag.
CURSOR get_deprn_flag IS
SELECT nvl(meaning, X_Asset_Rec.depreciate_flag)
FROM fa_lookups
WHERE lookup_code = X_Asset_Rec.depreciate_flag
AND lookup_type = 'YESNO';
INSERT INTO fa_mass_reclass_itf (
request_id, mass_reclass_id,
asset_id, asset_number,
description, book,
old_category, new_category,
convention, ceiling, method,
life, basic_rate, adjusted_rate,
bonus_rule, production_capacity, unit_of_measure,
depreciate_flag, deprn_limit_percentage,
deprn_limit_amount, salvage_val_percentage,
cost_acct, deprn_reserve_acct,
last_update_date, last_updated_by, created_by,
creation_date, last_update_login
)
VALUES (
X_Request_Id, X_Mass_Reclass_Id,
X_Asset_Rec.asset_id, X_Asset_Rec.asset_number,
X_Asset_Rec.description, X_Asset_Rec.book_type_code,
X_Asset_Rec.category, X_New_Category,
X_Asset_Rec.convention, X_Asset_Rec.ceiling, X_Asset_Rec.method,
fnd_number.canonical_to_number(X_Asset_Rec.life),
X_Asset_Rec.basic_rate_pct, X_Asset_Rec.adjusted_rate_pct,
X_Asset_Rec.bonus_rule, X_Asset_Rec.capacity, X_Asset_Rec.unit_of_measure,
h_deprn_flag_mean, X_Asset_Rec.deprn_limit_pct,
X_Asset_Rec.deprn_limit_amt, X_Asset_Rec.salvage_val_pct,
X_Asset_Rec.cost_acct, X_Asset_Rec.deprn_rsv_acct,
X_Last_Update_Date, X_Last_Updated_By, X_Created_By,
X_Creation_Date, X_Last_Update_Login
);
INSERT INTO fa_mass_reclass_itf (
request_id, mass_reclass_id,
asset_id, asset_number,
description, book,
old_category, new_category,
convention, ceiling, method,
life, basic_rate, adjusted_rate,
bonus_rule, production_capacity, unit_of_measure,
depreciate_flag, deprn_limit_percentage,
deprn_limit_amount, salvage_val_percentage,
cost_acct, deprn_reserve_acct,
last_update_date, last_updated_by, created_by,
creation_date, last_update_login
)
VALUES (
X_Request_Id, X_Mass_Reclass_Id,
X_Asset_Rec.asset_id, X_Asset_Rec.asset_number,
X_Asset_Rec.description, X_Asset_Rec.book_type_code,
NULL, X_Asset_Rec.category,
X_Asset_Rec.convention, X_Asset_Rec.ceiling, X_Asset_Rec.method,
fnd_number.canonical_to_number(X_Asset_Rec.life),
X_Asset_Rec.basic_rate_pct, X_Asset_Rec.adjusted_rate_pct,
X_Asset_Rec.bonus_rule, X_Asset_Rec.capacity, X_Asset_Rec.unit_of_measure,
h_deprn_flag_mean, X_Asset_Rec.deprn_limit_pct,
X_Asset_Rec.deprn_limit_amt, X_Asset_Rec.salvage_val_pct,
X_Asset_Rec.cost_acct, X_Asset_Rec.deprn_rsv_acct,
X_Last_Update_Date, X_Last_Updated_By, X_Created_By,
X_Creation_Date, X_Last_Update_Login
);
CALLING_FN => 'FA_MASS_REC_UTILS_PKG.Insert_Itf',
NAME => 'FA_SHARED_INSERT_FAILED',
TOKEN1 => 'FAILED',
VALUE1 => 'FA_MASS_RECLASS_ITF'
,p_log_level_rec => p_log_level_rec);
CALLING_FN => 'FA_MASS_REC_UTILS_PKG.Insert_Itf'
,p_log_level_rec => p_log_level_rec);
END Insert_Itf;
| PROCEDURE Get_Selection_Criteria |
+=====================================================================================*/
PROCEDURE Get_Selection_Criteria(
X_Mass_Reclass_ID IN NUMBER,
X_Book_Type_Code OUT NOCOPY VARCHAR2,
X_Asset_Type OUT NOCOPY VARCHAR2,
X_Fully_Rsvd OUT NOCOPY VARCHAR2,
X_From_Cost OUT NOCOPY NUMBER,
X_To_Cost OUT NOCOPY NUMBER,
X_From_Asset OUT NOCOPY VARCHAR2,
X_To_Asset OUT NOCOPY VARCHAR2,
X_From_Dpis OUT NOCOPY DATE,
X_To_Dpis OUT NOCOPY DATE,
X_Location OUT NOCOPY VARCHAR2,
X_Employee_Name OUT NOCOPY VARCHAR2,
X_Employee_Number OUT NOCOPY VARCHAR2,
X_Old_Category OUT NOCOPY VARCHAR2,
X_New_Category OUT NOCOPY VARCHAR2,
X_Asset_Key OUT NOCOPY VARCHAR2,
X_From_Exp_Acct OUT NOCOPY VARCHAR2,
X_To_Exp_Acct OUT NOCOPY VARCHAR2,
p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
mr_rec mass_reclass_rec;
SELECT mr.book_type_code, mr.asset_type,
mr.include_fully_rsvd_flag,
mr.from_cost, mr.to_cost,
mr.from_asset_number, mr.to_asset_number,
mr.from_date_placed_in_service, mr.to_date_placed_in_service,
mr.location_id, mr.employee_id,
mr.from_category_id, mr.to_category_id, mr.asset_key_id,
mr.segment1_low, mr.segment2_low, mr.segment3_low,
mr.segment4_low, mr.segment5_low, mr.segment6_low,
mr.segment7_low, mr.segment8_low, mr.segment9_low,
mr.segment10_low, mr.segment11_low, mr.segment12_low,
mr.segment13_low, mr.segment14_low, mr.segment15_low,
mr.segment16_low, mr.segment17_low, mr.segment18_low,
mr.segment19_low, mr.segment20_low, mr.segment21_low,
mr.segment22_low, mr.segment23_low, mr.segment24_low,
mr.segment25_low, mr.segment26_low, mr.segment27_low,
mr.segment28_low, mr.segment29_low, mr.segment30_low,
mr.segment1_high, mr.segment2_high, mr.segment3_high,
mr.segment4_high, mr.segment5_high, mr.segment6_high,
mr.segment7_high, mr.segment8_high, mr.segment9_high,
mr.segment10_high, mr.segment11_high, mr.segment12_high,
mr.segment13_high, mr.segment14_high, mr.segment15_high,
mr.segment16_high, mr.segment17_high, mr.segment18_high,
mr.segment19_high, mr.segment20_high, mr.segment21_high,
mr.segment22_high, mr.segment23_high, mr.segment24_high,
mr.segment25_high, mr.segment26_high, mr.segment27_high,
mr.segment28_high, mr.segment29_high, mr.segment30_high
FROM fa_mass_reclass mr
WHERE mr.mass_reclass_id = X_Mass_Reclass_Id;
SELECT curr.precision
FROM fnd_currencies curr, gl_sets_of_books sob,
fa_book_controls bc
WHERE curr.currency_code = sob.currency_code
AND sob.set_of_books_id = bc.set_of_books_id
AND bc.book_type_code = mr_rec.book_type_code;
SELECT category_flex_structure, location_flex_structure,
asset_key_flex_structure
FROM fa_system_controls;
SELECT name, employee_number
FROM fa_employees
WHERE employee_id = mr_rec.employee_id;
SELECT accounting_flex_structure FROM fa_book_controls
WHERE book_type_code = mr_rec.book_type_code;
SELECT table_id FROM fnd_tables
WHERE table_name = 'GL_CODE_COMBINATIONS' AND application_id = 101;
SELECT s.concatenated_segment_delimiter
FROM fnd_id_flex_structures s, fnd_application a
WHERE s.application_id = a.application_id
AND s.id_flex_code = 'GL#'
AND s.id_flex_num = h_acct_flex_struct
AND a.application_short_name = 'SQLGL';
SELECT distinct g.application_column_name, g.segment_num
FROM fnd_columns c, fnd_id_flex_segments g
WHERE g.application_id = 101
AND g.id_flex_code = 'GL#'
AND g.id_flex_num = h_acct_flex_struct
AND g.enabled_flag = 'Y'
AND c.application_id = 101
AND c.table_id = h_table_id
AND c.column_name = g.application_column_name;
SELECT nvl(meaning, h_asset_type)
FROM fa_lookups
WHERE lookup_code = h_asset_type
AND lookup_type = 'ASSET TYPE';
SELECT nvl(meaning, h_fully_rsvd)
FROM fa_lookups
WHERE lookup_code = h_fully_rsvd
AND lookup_type = 'YESNO';
END Get_Selection_Criteria;
SELECT category_flex_structure
FROM FA_SYSTEM_CONTROLS;