APPS.CSD_FLWSTS_TRAN_RESPS_PVT SQL Statements

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

Line: 94

                       'Calling Insert_Row table handler');

Line: 100

         CSD_FLWSTS_TRAN_RESPS_PKG.Insert_Row
         (
          px_flwsts_tran_resp_id      => x_flwsts_tran_resp_id,
          p_flwsts_tran_id            => p_flwsts_tran_resp_rec.flwsts_tran_id,
          p_responsibility_id         => p_flwsts_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: 117

                       'Returned from Insert_Row table handler');

Line: 227

/* procedure name: Update_Flwsts_Tran_Resp          */
/* description   : procedure used to update         */
/*                FS transition responsibility rec  */
/*                                                  */
/*--------------------------------------------------*/
PROCEDURE Update_Flwsts_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_flwsts_tran_resp_rec      IN  FLWSTS_TRAN_RESP_REC_TYPE,
  x_obj_ver_number 		OUT NOCOPY NUMBER
) IS

-- CONSTANTS --
 lc_mod_name              CONSTANT VARCHAR2(100)  := 'csd.plsql.CSD_FLWSTS_TRAN_RESPS_PVT.update_flwsts_tran_resp';

Line: 247

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

Line: 267

       SAVEPOINT  Update_Flwsts_Tran_Resp;

Line: 285

              'Entered Update_Flwsts_Tran_Resp');

Line: 317

                        'Calling Update_Row table handler');

Line: 323

         CSD_FLWSTS_TRAN_RESPS_PKG.Update_Row
         (
          p_flwsts_tran_resp_id       => p_flwsts_tran_resp_rec.flwsts_tran_resp_id,
          p_flwsts_tran_id            => p_flwsts_tran_resp_rec.flwsts_tran_id,
          p_responsibility_id         => p_flwsts_tran_resp_rec.responsibility_id,
          p_object_version_number     => p_flwsts_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: 340

                       'Returned from Update_Row table handler');

Line: 357

                       'Leaving Update_Flwsts_Tran_Resp');

Line: 362

          ROLLBACK TO Update_Flwsts_Tran_Resp;

Line: 379

          ROLLBACK TO Update_Flwsts_Tran_Resp;

Line: 393

          ROLLBACK TO Update_Flwsts_Tran_Resp;

Line: 419

          ROLLBACK TO Update_Flwsts_Tran_Resp;

Line: 446

END Update_Flwsts_Tran_Resp;

Line: 449

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

-- CONSTANTS --
 lc_mod_name              CONSTANT VARCHAR2(100)  := 'csd.plsql.CSD_FLWSTS_TRAN_RESPS_PVT.Delete_Flwsts_Tran_Resp';

Line: 468

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

Line: 478

       SAVEPOINT  Delete_Flwsts_Tran_Resp;

Line: 496

                'Entered Delete_Flwsts_Tran_Resp');

Line: 519

                        'Calling Delete_Row table handler');

Line: 525

         CSD_FLWSTS_TRAN_RESPS_PKG.Delete_Row
         (  p_flwsts_tran_resp_id => p_flwsts_tran_resp_id);

Line: 532

                       'Returned from Delete_Row table handler');

Line: 549

                       'Leaving Delete_Flwsts_Tran_Resp');

Line: 555

          ROLLBACK TO Delete_Flwsts_Tran_Resp;

Line: 570

          ROLLBACK TO Delete_Flwsts_Tran_Resp;

Line: 597

          ROLLBACK TO Delete_Flwsts_Tran_Resp;

Line: 625

END Delete_Flwsts_Tran_Resp;