eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_FLOW_STATUSES_PVT SQL Statements

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

Line: 95


                       'Calling Insert_Row table handler');

Line: 101


         CSD_FLOW_STATUSES_PKG.Insert_Row
         (
          px_flow_status_id           => x_flow_status_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,
          p_flow_status_code          => p_flow_status_rec.flow_status_code,
          p_status_code               => p_flow_status_rec.status_code,
          p_seeded_flag               => p_flow_status_rec.seeded_flag,
          p_external_display_status   => p_flow_status_rec.external_display_status,
          p_attribute_category        => p_flow_status_rec.attribute_category,
          p_attribute1                => p_flow_status_rec.attribute1,
          p_attribute2                => p_flow_status_rec.attribute2,
          p_attribute3                => p_flow_status_rec.attribute3,
          p_attribute4                => p_flow_status_rec.attribute4,
          p_attribute5                => p_flow_status_rec.attribute5,
          p_attribute6                => p_flow_status_rec.attribute6,
          p_attribute7                => p_flow_status_rec.attribute7,
          p_attribute8                => p_flow_status_rec.attribute8,
          p_attribute9                => p_flow_status_rec.attribute9,
          p_attribute10               => p_flow_status_rec.attribute10,
          p_attribute11               => p_flow_status_rec.attribute11,
          p_attribute12               => p_flow_status_rec.attribute12,
          p_attribute13               => p_flow_status_rec.attribute13,
          p_attribute14               => p_flow_status_rec.attribute14,
          p_attribute15               => p_flow_status_rec.attribute15
 	      );

Line: 135


                       'Returned from Insert_Row table handler');

Line: 246


/* procedure name: Update_Flow_Status               */
/* description   : procedure used to update         */
/*                 Flow Status                      */
/*                                                  */
/*--------------------------------------------------*/
PROCEDURE Update_Flow_Status
(
  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_flow_status_rec      IN  FLOW_STATUS_REC_TYPE,
  x_obj_ver_number 		OUT NOCOPY NUMBER
) IS

-- CONSTANTS --
 lc_mod_name              CONSTANT VARCHAR2(100)  := 'csd.plsql.CSD_FLOW_STATUSES_PVT.update_flow_status';

Line: 266


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

Line: 286


       SAVEPOINT  Update_Flow_Status;

Line: 304


              'Entered Update_Flow_Status');

Line: 339


                        'Calling Update_Row table handler');

Line: 345


         CSD_FLOW_STATUSES_PKG.Update_Row
         (p_flow_status_id            => p_flow_status_rec.flow_status_id,
          p_object_version_number     => p_flow_status_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,
          p_flow_status_code          => p_flow_status_rec.flow_status_code,
          p_status_code               => p_flow_status_rec.status_code,
          p_seeded_flag               => p_flow_status_rec.seeded_flag,
          p_external_display_status   => p_flow_status_rec.external_display_status,
          p_attribute_category        => p_flow_status_rec.attribute_category,
          p_attribute1                => p_flow_status_rec.attribute1,
          p_attribute2                => p_flow_status_rec.attribute2,
          p_attribute3                => p_flow_status_rec.attribute3,
          p_attribute4                => p_flow_status_rec.attribute4,
          p_attribute5                => p_flow_status_rec.attribute5,
          p_attribute6                => p_flow_status_rec.attribute6,
          p_attribute7                => p_flow_status_rec.attribute7,
          p_attribute8                => p_flow_status_rec.attribute8,
          p_attribute9                => p_flow_status_rec.attribute9,
          p_attribute10               => p_flow_status_rec.attribute10,
          p_attribute11               => p_flow_status_rec.attribute11,
          p_attribute12               => p_flow_status_rec.attribute12,
          p_attribute13               => p_flow_status_rec.attribute13,
          p_attribute14               => p_flow_status_rec.attribute14,
          p_attribute15               => p_flow_status_rec.attribute15
 	     );

Line: 379


                       'Returned from Update_Row table handler');

Line: 396


                       'Leaving Update_Flow_Status');

Line: 401


          ROLLBACK TO Update_Flow_Status;

Line: 418


          ROLLBACK TO Update_Flow_Status;

Line: 432


          ROLLBACK TO Update_Flow_Status;

Line: 458


          ROLLBACK TO Update_Flow_Status;

Line: 485


END Update_Flow_Status;

Line: 488


/* procedure name: Delete_Flow_Status               */
/* description   : procedure used to delete         */
/*                 Flow Status	                */
/*                                                  */
/*--------------------------------------------------*/
PROCEDURE Delete_Flow_Status
(
  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_flow_status_id	 	IN  NUMBER
) IS

-- CONSTANTS --
 lc_mod_name              CONSTANT VARCHAR2(100)  := 'csd.plsql.CSD_FLOW_STATUSES_PVT.Delete_Flow_Status';

Line: 507


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

Line: 517


       SAVEPOINT  Delete_Flow_Status;

Line: 535


                'Entered Delete_Flow_Status');

Line: 558


                        'Calling Delete_Row table handler');

Line: 564


         CSD_FLOW_STATUSES_PKG.Delete_Row
         (  p_flow_status_id => p_flow_status_id);

Line: 571


                       'Returned from Delete_Row table handler');

Line: 588


                       'Leaving Delete_Flow_Status');

Line: 594


          ROLLBACK TO Delete_Flow_Status;

Line: 609


          ROLLBACK TO Delete_Flow_Status;

Line: 636


          ROLLBACK TO Delete_Flow_Status;

Line: 664


END Delete_Flow_Status;