DBA Data[Home] [Help]

APPS.FA_LOAD_TBL_PKG SQL Statements

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

Line: 26

         dist_table.delete;
Line: 67

	     p_deleted_flag        varchar2,
	     p_inv_transfer_cost	number,
	     p_inv_update_only		varchar2,
	     p_inv_new_cost			number,
        p_depreciate_in_group_flag  varchar2,
	     p_attribute1			varchar2 default null,
	     p_attribute2			varchar2 default null,
	     p_attribute3			varchar2 default null,
	     p_attribute4			varchar2 default null,
	     p_attribute5			varchar2 default null,
	     p_attribute6			varchar2 default null,
	     p_attribute7			varchar2 default null,
	     p_attribute8			varchar2 default null,
	     p_attribute9			varchar2 default null,
	     p_attribute10		varchar2 default null,
	     p_attribute11		varchar2 default null,
	     p_attribute12		varchar2 default null,
	     p_attribute13		varchar2 default null,
	     p_attribute14		varchar2 default null,
	     p_attribute15		varchar2 default null,
	     p_attribute_cat_code 	    varchar2 default null,
        p_invoice_distribution_id number   default null,
        p_invoice_line_number     number   default null,
        p_po_distribution_id      number   default null,
        p_log_level_rec        IN     FA_API_TYPES.log_level_rec_type default null)
IS
BEGIN
  if (g_inv_count=0) then  /* initialize inv_line_tbl  */
	   inv_table.delete;
Line: 144

     inv_table(g_inv_count).deleted_flag
				:= p_deleted_flag;
Line: 148

     inv_table(g_inv_count).inv_update_only
				:= p_inv_update_only;
Line: 202

        dist_table.delete;
Line: 221

        inv_table.delete;
Line: 237

            SELECT bc.book_type_code
            FROM fa_category_books cb, fa_book_controls bc
            WHERE p_corp_book =
                        decode(bc.book_class, 'CORPORATE', bc.book_type_code,
                               'TAX', bc.distribution_source_book, '')
	    AND bc.book_type_code = cb.book_type_code
	    AND cb.category_id = p_category_id
            AND nvl(bc.date_ineffective, sysdate + 1) > sysdate;
Line: 248

            SELECT      h_book, cbd.start_dpis, cbd.end_dpis,
			cbd.prorate_convention_code, cbd.deprn_method,
                        cbd.life_in_months,cbd.basic_rate,cbd.adjusted_rate,
                        cbd.production_capacity, cbd.unit_of_measure,
                        cbd.bonus_rule, NULL, cbd.ceiling_name,
                        cbd.depreciate_flag, cbd.allowed_deprn_limit,
                        cbd.special_deprn_limit_amount,cbd.percent_salvage_value
            FROM        FA_CATEGORY_BOOK_DEFAULTS cbd
            WHERE       cbd.book_type_code = h_book
            AND         cbd.category_id = p_category_id;
Line: 277

	        deprn_table.delete;