APPS.CSD_RT_TRANS_PVT SQL Statements

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

Line: 99

                       'Calling Insert_Row table handler');

Line: 105

         CSD_RT_TRANS_PKG.Insert_Row
         (
          px_rt_tran_id               => x_rt_tran_id,
          p_from_repair_type_id       => p_rt_tran_rec.from_repair_type_id,
          p_to_repair_type_id         => p_rt_tran_rec.to_repair_type_id,
          p_common_flow_status_id     => p_rt_tran_rec.common_flow_status_id,
          p_reason_required_flag      => p_rt_tran_rec.reason_required_flag,
          p_capture_activity_flag     => p_rt_tran_rec.capture_activity_flag,
          p_allow_all_resp_flag       => p_rt_tran_rec.allow_all_resp_flag,
          p_description               => p_rt_tran_rec.description,
          p_object_version_number     => l_obj_ver_num,
          p_created_by                => FND_GLOBAL.USER_ID,
          p_creation_date             => SYSDATE,
          p_last_updated_by           => FND_GLOBAL.USER_ID,
          p_last_update_date          => SYSDATE,
          p_last_update_login         => FND_GLOBAL.LOGIN_ID
 	   );

Line: 127

                       'Returned from Insert_Row table handler');

Line: 237

/* procedure name: Update_Rt_Tran                   */
/* description   : procedure used to update         */
/*                 repair type transition 	    */
/*                                                  */
/*--------------------------------------------------*/
PROCEDURE Update_Rt_Tran
(
  p_api_version        		IN  NUMBER,
  p_commit	   		      IN  VARCHAR2,
  p_init_msg_list      		IN  VARCHAR2,
  p_validation_level   		IN  NUMBER,
  x_return_status      		OUT NOCOPY VARCHAR2,
  x_msg_count          		OUT NOCOPY NUMBER,
  x_msg_data           		OUT NOCOPY VARCHAR2,
  p_rt_tran_rec               IN  RT_TRAN_REC_TYPE,
  x_obj_ver_number 		OUT NOCOPY NUMBER
) IS

-- CONSTANTS --
 lc_mod_name              CONSTANT VARCHAR2(100)  := 'csd.plsql.CSD_RT_TRANS_PVT.update_rt_tran';

Line: 257

 lc_api_name              CONSTANT VARCHAR2(30)   := 'Update_Rt_Tran';

Line: 277

       SAVEPOINT  Update_Rt_Tran;

Line: 295

              'Entered Update_Rt_Tran');

Line: 333

                        'Calling Update_Row table handler');

Line: 339

         CSD_RT_TRANS_PKG.Update_Row
         (p_rt_tran_id                => p_rt_tran_rec.rt_tran_id,
          p_from_repair_type_id       => p_rt_tran_rec.from_repair_type_id,
          p_to_repair_type_id         => p_rt_tran_rec.to_repair_type_id,
          p_common_flow_status_id     => p_rt_tran_rec.common_flow_status_id,
          p_reason_required_flag      => p_rt_tran_rec.reason_required_flag,
          p_capture_activity_flag     => p_rt_tran_rec.capture_activity_flag,
          p_allow_all_resp_flag       => p_rt_tran_rec.allow_all_resp_flag,
          p_description               => p_rt_tran_rec.description,
          p_object_version_number     => p_rt_tran_rec.object_version_number,
          p_last_updated_by           => FND_GLOBAL.USER_ID,
          p_last_update_date          => SYSDATE,
          p_last_update_login         => FND_GLOBAL.LOGIN_ID
     	 );

Line: 360

                       'Returned from Update_Row table handler');

Line: 377

                       'Leaving Update_Rt_Tran');

Line: 382

          ROLLBACK TO Update_Rt_Tran;

Line: 399

          ROLLBACK TO Update_Rt_Tran;

Line: 413

          ROLLBACK TO Update_Rt_Tran;

Line: 439

          ROLLBACK TO Update_Rt_Tran;

Line: 466

END Update_Rt_Tran;

Line: 469

/* procedure name: Delete_Rt_Tran               */
/* description   : procedure used to delete         */
/*                 repair type transition 	    */
/*                                                  */
/*--------------------------------------------------*/
PROCEDURE Delete_Rt_Tran
(
  p_api_version        		IN  NUMBER,
  p_commit	   		      IN  VARCHAR2,
  p_init_msg_list      		IN  VARCHAR2,
  p_validation_level   		IN  NUMBER,
  x_return_status      		OUT NOCOPY VARCHAR2,
  x_msg_count          		OUT NOCOPY NUMBER,
  x_msg_data           		OUT NOCOPY VARCHAR2,
  p_rt_tran_id	 	IN  NUMBER
) IS

-- CONSTANTS --
 lc_mod_name              CONSTANT VARCHAR2(100)  := 'csd.plsql.CSD_RT_TRANS_PVT.Delete_Rt_Tran';

Line: 488

 lc_api_name              CONSTANT VARCHAR2(30)   := 'Delete_Rt_Tran';

Line: 498

       SAVEPOINT  Delete_Rt_Tran;

Line: 516

                'Entered Delete_Rt_Tran');

Line: 539

                        'Calling Delete_Row table handler');

Line: 545

         CSD_RT_TRANS_PKG.Delete_Row
         (  p_rt_tran_id => p_rt_tran_id);

Line: 552

                       'Returned from Delete_Row table handler');

Line: 569

                       'Leaving Delete_Rt_Tran');

Line: 575

          ROLLBACK TO Delete_Rt_Tran;

Line: 590

          ROLLBACK TO Delete_Rt_Tran;

Line: 617

          ROLLBACK TO Delete_Rt_Tran;

Line: 645

END Delete_Rt_Tran;