APPS.CSD_FLWSTS_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_FLWSTS_TRANS_PKG.Insert_Row
         (
          px_flwsts_tran_id           => x_flwsts_tran_id,
          p_repair_type_id            => p_flwsts_tran_rec.repair_type_id,
          p_from_flow_status_id       => p_flwsts_tran_rec.from_flow_status_id,
          p_to_flow_status_id         => p_flwsts_tran_rec.to_flow_status_id,
          p_wf_item_type              => p_flwsts_tran_rec.wf_item_type,
          p_wf_process_name           => p_flwsts_tran_rec.wf_process_name,
          p_reason_required_flag      => p_flwsts_tran_rec.reason_required_flag,
          p_capture_activity_flag     => p_flwsts_tran_rec.capture_activity_flag,
          p_allow_all_resp_flag       => p_flwsts_tran_rec.allow_all_resp_flag,
          p_description               => p_flwsts_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: 128

                       'Returned from Insert_Row table handler');

Line: 238

/* procedure name: Update_Flwsts_Tran               */
/* description   : procedure used to update         */
/*                 Flow Status transition 	    */
/*                                                  */
/*--------------------------------------------------*/
PROCEDURE Update_Flwsts_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_flwsts_tran_rec           IN  FLWSTS_TRAN_REC_TYPE,
  x_obj_ver_number 		OUT NOCOPY NUMBER
) IS

-- CONSTANTS --
 lc_mod_name              CONSTANT VARCHAR2(100)  := 'csd.plsql.CSD_FLWSTS_TRANS_PVT.update_flwsts_tran';

Line: 258

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

Line: 278

       SAVEPOINT  Update_Flwsts_Tran;

Line: 296

              'Entered Update_Flwsts_Tran');

Line: 334

                        'Calling Update_Row table handler');

Line: 340

         CSD_FLWSTS_TRANS_PKG.Update_Row
         (p_flwsts_tran_id            => p_flwsts_tran_rec.flwsts_tran_id,
          p_repair_type_id            => p_flwsts_tran_rec.repair_type_id,
          p_from_flow_status_id       => p_flwsts_tran_rec.from_flow_status_id,
          p_to_flow_status_id         => p_flwsts_tran_rec.to_flow_status_id,
          p_wf_item_type              => p_flwsts_tran_rec.wf_item_type,
          p_wf_process_name           => p_flwsts_tran_rec.wf_process_name,
          p_reason_required_flag      => p_flwsts_tran_rec.reason_required_flag,
          p_capture_activity_flag     => p_flwsts_tran_rec.capture_activity_flag,
          p_allow_all_resp_flag       => p_flwsts_tran_rec.allow_all_resp_flag,
          p_description               => p_flwsts_tran_rec.description,
          p_object_version_number     => p_flwsts_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: 363

                       'Returned from Update_Row table handler');

Line: 380

                       'Leaving Update_Flwsts_Tran');

Line: 385

          ROLLBACK TO Update_Flwsts_Tran;

Line: 402

          ROLLBACK TO Update_Flwsts_Tran;

Line: 416

          ROLLBACK TO Update_Flwsts_Tran;

Line: 442

          ROLLBACK TO Update_Flwsts_Tran;

Line: 469

END Update_Flwsts_Tran;

Line: 472

/* procedure name: Delete_Flwsts_Tran               */
/* description   : procedure used to delete         */
/*                 Flow Status transition 	    */
/*                                                  */
/*--------------------------------------------------*/
PROCEDURE Delete_Flwsts_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_flwsts_tran_id	 	IN  NUMBER
) IS

-- CONSTANTS --
 lc_mod_name              CONSTANT VARCHAR2(100)  := 'csd.plsql.CSD_FLWSTS_TRANS_PVT.Delete_Flwsts_Tran';

Line: 491

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

Line: 501

       SAVEPOINT  Delete_Flwsts_Tran;

Line: 519

                'Entered Delete_Flwsts_Tran');

Line: 542

                        'Calling Delete_Row table handler');

Line: 548

         CSD_FLWSTS_TRANS_PKG.Delete_Row
         (  p_flwsts_tran_id => p_flwsts_tran_id);

Line: 555

                       'Returned from Delete_Row table handler');

Line: 572

                       'Leaving Delete_Flwsts_Tran');

Line: 578

          ROLLBACK TO Delete_Flwsts_Tran;

Line: 593

          ROLLBACK TO Delete_Flwsts_Tran;

Line: 620

          ROLLBACK TO Delete_Flwsts_Tran;

Line: 648

END Delete_Flwsts_Tran;