APPS.CSD_FLWSTS_TRAN_MILES_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_MILES_PKG.Insert_Row
         (
          px_flwsts_tran_mile_id      => x_flwsts_tran_mile_id,
          p_flwsts_tran_id            => p_flwsts_tran_mile_rec.flwsts_tran_id,
          p_milestone_code            => p_flwsts_tran_mile_rec.milestone_code,
          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_Mile          */
/* description   : procedure used to update         */
/*                FS transition milestone rec       */
/*                                                  */
/*--------------------------------------------------*/
PROCEDURE Update_Flwsts_Tran_Mile
(
  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_mile_rec      IN  FLWSTS_TRAN_MILE_REC_TYPE,
  x_obj_ver_number 		OUT NOCOPY NUMBER
) IS

-- CONSTANTS --
 lc_mod_name              CONSTANT VARCHAR2(100)  := 'csd.plsql.CSD_FLWSTS_TRAN_MILES_PVT.update_flwsts_tran_mile';

Line: 247

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

Line: 267

       SAVEPOINT  Update_Flwsts_Tran_Mile;

Line: 285

              'Entered Update_Flwsts_Tran_Mile');

Line: 317

                        'Calling Update_Row table handler');

Line: 323

         CSD_FLWSTS_TRAN_MILES_PKG.Update_Row
         (
          p_flwsts_tran_mile_id       => p_flwsts_tran_mile_rec.flwsts_tran_mile_id,
          p_flwsts_tran_id            => p_flwsts_tran_mile_rec.flwsts_tran_id,
          p_milestone_code            => p_flwsts_tran_mile_rec.milestone_code,
          p_object_version_number     => p_flwsts_tran_mile_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: 339

                       'Returned from Update_Row table handler');

Line: 356

                       'Leaving Update_Flwsts_Tran_Mile');

Line: 361

          ROLLBACK TO Update_Flwsts_Tran_Mile;

Line: 378

          ROLLBACK TO Update_Flwsts_Tran_Mile;

Line: 392

          ROLLBACK TO Update_Flwsts_Tran_Mile;

Line: 418

          ROLLBACK TO Update_Flwsts_Tran_Mile;

Line: 445

END Update_Flwsts_Tran_Mile;

Line: 448

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

-- CONSTANTS --
 lc_mod_name              CONSTANT VARCHAR2(100)  := 'csd.plsql.CSD_FLWSTS_TRAN_MILES_PVT.Delete_Flwsts_Tran_Mile';

Line: 467

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

Line: 477

       SAVEPOINT  Delete_Flwsts_Tran_Mile;

Line: 495

                'Entered Delete_Flwsts_Tran_Mile');

Line: 518

                        'Calling Delete_Row table handler');

Line: 524

         CSD_FLWSTS_TRAN_MILES_PKG.Delete_Row
         (  p_flwsts_tran_mile_id => p_flwsts_tran_mile_id);

Line: 531

                       'Returned from Delete_Row table handler');

Line: 548

                       'Leaving Delete_Flwsts_Tran_Mile');

Line: 554

          ROLLBACK TO Delete_Flwsts_Tran_Mile;

Line: 569

          ROLLBACK TO Delete_Flwsts_Tran_Mile;

Line: 596

          ROLLBACK TO Delete_Flwsts_Tran_Mile;

Line: 624

END Delete_Flwsts_Tran_Mile;