APPS.CSD_MIGRATE_FROM_115X_PKG2 SQL Statements

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

Line: 22

  select cr.repair_line_id,
         cr.rowid
  from   csd_repairs cr
  where  cr.currency_code IS NULL
   and   cr.repair_line_id >= p_start
   and   cr.repair_line_id <= p_end;

Line: 47

    select gl.currency_code
      into l_currency_code
    from   gl_sets_of_books gl, hr_operating_units ou
    where  ou.organization_id = cs_std.get_item_valdn_orgzn_id
    and    ou.set_of_books_id = gl.set_of_books_id;

Line: 76

              select distinct currency_code
              into   l_currency_code
              from   cs_estimate_details
              where  source_id = repair_line_id_mig(j)
              and    source_code = 'DR';

Line: 99

               UPDATE csd_repairs
               SET   currency_code       = l_currency_code,
                     last_update_date    = sysdate,
				 last_updated_by     = fnd_global.user_id,
				 last_update_login   = fnd_global.login_id
               WHERE  rowid = rowid_mig(j);

Line: 115

                 INSERT INTO CSD_UPG_ERRORS
		          (ORIG_SYSTEM_REFERENCE,
          	      TARGET_SYSTEM_REFERENCE,
		           ORIG_SYSTEM_REFERENCE_ID,
		           UPGRADE_DATETIME,
		           ERROR_MESSAGE,
		           MIGRATION_PHASE)
                 VALUES( 'CSD_REPAIRS'
          	     ,'CSD_REPAIRS'
	     	     ,repair_line_id_mig(j)
		          ,sysdate
	               ,v_error_text
	      	     ,'11.5.9'  );

Line: 152

/* procedure name: insert_rep_typ_sar                                            */
/* description   : procedure for inserting Material , Labor and Expense SAR      */
/*                 data into CSD_REPAIR_TYPES_SAR table in 11.5.9                */
/*-------------------------------------------------------------------------------*/
  PROCEDURE insert_rep_typ_sar( p_repair_type_id          IN NUMBER
                               ,p_txn_billing_type_id IN NUMBER
                               ,p_created_by              IN NUMBER
                               ,p_creation_date           IN DATE)
  IS
    l_user_id                NUMBER := fnd_global.user_id;

Line: 170

       select count(*)
         into l_count
         from CSD_REPAIR_TYPES_SAR
        where REPAIR_TYPE_ID = p_repair_type_id
          and TXN_BILLING_TYPE_ID = p_txn_billing_type_id;

Line: 188

        insert into CSD_REPAIR_TYPES_SAR
                    ( REPAIR_TXN_BILLING_TYPE_ID
                     ,REPAIR_TYPE_ID
                     ,TXN_BILLING_TYPE_ID
                     ,CREATED_BY
                     ,CREATION_DATE
                     ,LAST_UPDATED_BY
                     ,LAST_UPDATE_DATE
                     ,OBJECT_VERSION_NUMBER
                     ) VALUES
                    ( CSD_REPAIR_TYPES_SAR_S1.NEXTVAL
                     ,p_repair_type_id
                     ,p_txn_billing_type_id
                     ,p_created_by
                     ,p_creation_date
                     ,l_user_id
                     ,SYSDATE
                     ,1
                     );

Line: 212

            INSERT INTO csd_upg_errors
                        (orig_system_reference,
                        target_system_reference,
                        orig_system_reference_id,
                        upgrade_datetime,
                        error_message,
                        migration_phase)
                VALUES ('CS_REPAIR_TYPES_B',
                        'CSD_REPAIR_TYPES_SAR',
                        p_repair_type_id,
                        sysdate,
                        v_error_text,
                        '11.5.9');

Line: 228

                raise_application_error( -20000, 'Error while migrating CSD_REPAIR_TYPES_B table data: Error while inserting into CSD_REPAIR_TYPES_SAR. '|| v_error_text);

Line: 236

  END insert_rep_typ_sar;

Line: 257

  select crtb.REPAIR_TYPE_ID,
         crtb.MTL_TXN_BILLING_TYPE_ID,
         crtb.LBR_TXN_BILLING_TYPE_ID,
         crtb.EXP_TXN_BILLING_TYPE_ID,
         crtb.CREATED_BY,
         crtb.CREATION_DATE
  from   csd_repair_types_b crtb
  where  ((crtb.MTL_TXN_BILLING_TYPE_ID IS NOT NULL) OR
           (crtb.LBR_TXN_BILLING_TYPE_ID IS NOT NULL) OR
           (crtb.EXP_TXN_BILLING_TYPE_ID IS NOT NULL))
    and  trunc(sysdate) between nvl(trunc(crtb.start_date_active),trunc(sysdate))
         and nvl(trunc(crtb.end_date_active),trunc(sysdate));

Line: 296

         insert_rep_typ_sar( l_repair_type_id
                            ,l_mtl_txn_billing_type_id
                            ,l_created_by
                            ,l_creation_date);

Line: 305

         insert_rep_typ_sar( l_repair_type_id
                            ,l_lbr_txn_billing_type_id
                            ,l_created_by
                            ,l_creation_date);

Line: 314

         insert_rep_typ_sar( l_repair_type_id
                            ,l_exp_txn_billing_type_id
                            ,l_created_by
                            ,l_creation_date);