APPS.FA_MASS_REC_UTILS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 85

    conv_tbl.delete;

Line: 123

|   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) 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';

Line: 152

        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
    		);

Line: 182

        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
    		);

Line: 215

                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);

Line: 220

                CALLING_FN => 'FA_MASS_REC_UTILS_PKG.Insert_Itf',  p_log_level_rec => p_log_level_rec);

Line: 222

END Insert_Itf;

Line: 226

|   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) IS

    mr_rec		mass_reclass_rec;

Line: 255

        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;

Line: 287

        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;

Line: 296

	SELECT 	category_flex_structure, location_flex_structure,
		asset_key_flex_structure
	FROM 	fa_system_controls;

Line: 302

	SELECT 	name, employee_number
	FROM	fa_employees
	WHERE	employee_id = mr_rec.employee_id;

Line: 308

        SELECT accounting_flex_structure FROM fa_book_controls
        WHERE book_type_code = mr_rec.book_type_code;

Line: 313

        SELECT  table_id FROM fnd_tables
        WHERE   table_name = 'GL_CODE_COMBINATIONS' AND application_id = 101;

Line: 319

        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';

Line: 329

        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;

Line: 342

	SELECT nvl(meaning, h_asset_type)
	FROM fa_lookups
	WHERE lookup_code = h_asset_type
	AND lookup_type = 'ASSET TYPE';

Line: 347

	SELECT nvl(meaning, h_fully_rsvd)
	FROM fa_lookups
	WHERE lookup_code = h_fully_rsvd
	AND lookup_type = 'YESNO';

Line: 600

END Get_Selection_Criteria;

Line: 614

            SELECT category_flex_structure
            FROM FA_SYSTEM_CONTROLS;