APPS.CSD_RT_TRAN_RESPS_PVT SQL Statements

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

Line: 95

                       'Calling Insert_Row table handler');

Line: 101

         CSD_RT_TRAN_RESPS_PKG.Insert_Row
         (
          px_rt_tran_resp_id      => x_rt_tran_resp_id,
          p_rt_tran_id            => p_rt_tran_resp_rec.rt_tran_id,
          p_responsibility_id         => p_rt_tran_resp_rec.responsibility_id,
          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: 118

                       'Returned from Insert_Row table handler');

Line: 228

/* procedure name: Update_Rt_Tran_Resp          */
/* description   : procedure used to update         */
/*                FS transition responsibility rec  */
/*                                                  */
/*--------------------------------------------------*/
PROCEDURE Update_Rt_Tran_Resp
(
  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_resp_rec      IN  RT_TRAN_RESP_REC_TYPE,
  x_obj_ver_number 		OUT NOCOPY NUMBER
) IS

-- CONSTANTS --
 lc_mod_name              CONSTANT VARCHAR2(100)  := 'csd.plsql.CSD_RT_TRAN_RESPS_PVT.update_rt_tran_resp';

Line: 248

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

Line: 268

       SAVEPOINT  Update_Rt_Tran_Resp;

Line: 286

              'Entered Update_Rt_Tran_Resp');

Line: 318

                        'Calling Update_Row table handler');

Line: 324

         CSD_RT_TRAN_RESPS_PKG.Update_Row
         (
          p_rt_tran_resp_id           => p_rt_tran_resp_rec.rt_tran_resp_id,
          p_rt_tran_id                => p_rt_tran_resp_rec.rt_tran_id,
          p_responsibility_id         => p_rt_tran_resp_rec.responsibility_id,
          p_object_version_number     => p_rt_tran_resp_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: 341

                       'Returned from Update_Row table handler');

Line: 358

                       'Leaving Update_Rt_Tran_Resp');

Line: 363

          ROLLBACK TO Update_Rt_Tran_Resp;

Line: 380

          ROLLBACK TO Update_Rt_Tran_Resp;

Line: 394

          ROLLBACK TO Update_Rt_Tran_Resp;

Line: 420

          ROLLBACK TO Update_Rt_Tran_Resp;

Line: 447

END Update_Rt_Tran_Resp;

Line: 450

/* procedure name: Delete_Rt_Tran_Resp          */
/* description   : procedure used to delete         */
/*                FS transition responsibility rec  */
/*                                                  */
/*--------------------------------------------------*/
PROCEDURE Delete_Rt_Tran_Resp
(
  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_resp_id	 	IN  NUMBER
) IS

-- CONSTANTS --
 lc_mod_name              CONSTANT VARCHAR2(100)  := 'csd.plsql.CSD_RT_TRAN_RESPS_PVT.Delete_Rt_Tran_Resp';

Line: 469

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

Line: 479

       SAVEPOINT  Delete_Rt_Tran_Resp;

Line: 497

                'Entered Delete_Rt_Tran_Resp');

Line: 520

                        'Calling Delete_Row table handler');

Line: 526

         CSD_RT_TRAN_RESPS_PKG.Delete_Row
         (  p_rt_tran_resp_id => p_rt_tran_resp_id);

Line: 533

                       'Returned from Delete_Row table handler');

Line: 550

                       'Leaving Delete_Rt_Tran_Resp');

Line: 556

          ROLLBACK TO Delete_Rt_Tran_Resp;

Line: 571

          ROLLBACK TO Delete_Rt_Tran_Resp;

Line: 598

          ROLLBACK TO Delete_Rt_Tran_Resp;

Line: 626

END Delete_Rt_Tran_Resp;