APPS.CSD_REPAIR_MILESTONES_PVT SQL Statements

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

Line: 100

                       'Calling Insert_Row table handler');

Line: 106

         CSD_REPAIR_MILESTONES_PKG.Insert_Row
         (
          px_repair_milestone_id      => x_repair_milestone_id,
          p_repair_line_id            => p_repair_milestone_rec.repair_line_id,
          p_milestone_code            => p_repair_milestone_rec.milestone_code,
          p_milestone_date            => p_repair_milestone_rec.milestone_date,
          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: 125

                              'Others exception in CSD_REPAIR_MILESTONES_PKG.Insert_Row Call :' ||
                              SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));

Line: 137

                       'Returned from Insert_Row table handler');

Line: 230

/* procedure name: Update_Repair_Milestone          */
/* description   : procedure used to update         */
/*                 repair milestone                 */
/*                                                  */
/*--------------------------------------------------*/
PROCEDURE Update_Repair_Milestone
(
  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_repair_milestone_rec      IN  REPAIR_MILESTONE_REC_TYPE,
  x_obj_ver_number 		OUT NOCOPY NUMBER
) IS

-- CONSTANTS --
 lc_mod_name              CONSTANT VARCHAR2(100)  := 'csd.plsql.CSD_REPAIR_MILESTONES_PVT.update_repair_milestone';

Line: 250

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

Line: 263

       SAVEPOINT  Update_Repair_Milestone;

Line: 281

              'Entered Update_Repair_Milestone');

Line: 326

                        'Calling Update_Row table handler');

Line: 332

         CSD_REPAIR_MILESTONES_PKG.Update_Row
         (
          p_repair_milestone_id       => p_repair_milestone_rec.repair_milestone_id,
          p_repair_line_id            => p_repair_milestone_rec.repair_line_id,
          p_milestone_code            => p_repair_milestone_rec.milestone_code,
          p_milestone_date            => p_repair_milestone_rec.milestone_date,
          p_object_version_number     => p_repair_milestone_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: 350

               'Others exception in CSD_REPAIR_MILESTONES_PKG.Update_Row Call :' ||
               SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));

Line: 362

                       'Returned from Update_Row table handler');

Line: 379

                       'Leaving Update_Repair_Milestone');

Line: 384

          ROLLBACK TO Update_Repair_Milestone;

Line: 398

          ROLLBACK TO Update_Repair_Milestone;

Line: 424

          ROLLBACK TO Update_Repair_Milestone;

Line: 451

END Update_Repair_Milestone;

Line: 454

/* procedure name: Delete_Repair_Milestone          */
/* description   : procedure used to delete         */
/*                 repair milestone                 */
/*                                                  */
/*--------------------------------------------------*/
PROCEDURE Delete_Repair_Milestone
(
  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_repair_milestone_id	 	IN  NUMBER
) IS

-- CONSTANTS --
 lc_mod_name              CONSTANT VARCHAR2(100)  := 'csd.plsql.CSD_REPAIR_MILESTONES_PVT.Delete_Repair_Milestone';

Line: 473

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

Line: 483

       SAVEPOINT  Delete_Repair_Milestone;

Line: 501

                'Entered Delete_Repair_Milestone');

Line: 524

                        'Calling Delete_Row table handler');

Line: 530

         CSD_REPAIR_MILESTONES_PKG.Delete_Row
         (  p_repair_milestone_id => p_repair_milestone_id);

Line: 537

               'Others exception in CSD_REPAIR_MILESTONES_PKG.Delete_Row Call :' ||
               SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));

Line: 549

                       'Returned from Delete_Row table handler');

Line: 566

                       'Leaving Delete_Repair_Milestone');

Line: 572

          ROLLBACK TO Delete_Repair_Milestone;

Line: 587

          ROLLBACK TO Delete_Repair_Milestone;

Line: 614

          ROLLBACK TO Delete_Repair_Milestone;

Line: 642

END Delete_Repair_Milestone;