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.PA_PROGRESS_REPORT_PUB SQL Statements

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

Line: 211


PROCEDURE Update_REPORT_REGION
(

 p_api_version                 IN     NUMBER :=  1.0,
 p_init_msg_list               IN     VARCHAR2 := fnd_api.g_true,
 p_commit                      IN     VARCHAR2 := FND_API.g_false,
 p_validate_only               IN     VARCHAR2 := FND_API.g_true,
 p_max_msg_count               IN     NUMBER := FND_API.g_miss_num,

 P_VERSION_ID in NUMBER :=NULL,
 P_REGION_SOURCE_TYPE in VARCHAR2 default 'STD',
 P_REGION_CODE in VARCHAR2 :=NULL,
 P_RECORD_SEQUENCE in NUMBER :=NULL,
 P_RECORD_VERSION_NUMBER in NUMBER :=NULL,
 P_ATTRIBUTE1 in VARCHAR2 :=NULL,
 P_ATTRIBUTE2 in VARCHAR2 :=NULL,
 P_ATTRIBUTE3 in VARCHAR2 :=NULL,
 P_ATTRIBUTE4 in VARCHAR2 :=NULL,
 P_ATTRIBUTE5 in VARCHAR2 :=NULL,
 P_ATTRIBUTE6 in VARCHAR2 :=NULL,
 P_ATTRIBUTE7 in VARCHAR2 :=NULL,
 P_ATTRIBUTE8 in VARCHAR2 :=NULL,
 P_ATTRIBUTE9 in VARCHAR2 :=NULL,
 P_ATTRIBUTE10 in VARCHAR2 :=NULL,
 P_ATTRIBUTE11 in VARCHAR2 :=NULL,
 P_ATTRIBUTE12 in VARCHAR2 :=NULL,
 P_ATTRIBUTE13 in VARCHAR2 :=NULL,
 P_ATTRIBUTE14 in VARCHAR2 :=NULL,
 P_ATTRIBUTE15 in VARCHAR2 :=NULL,
 P_ATTRIBUTE16 in VARCHAR2 :=NULL,
 P_ATTRIBUTE17 in VARCHAR2 :=NULL,
 P_ATTRIBUTE18 in VARCHAR2 :=NULL,
 P_ATTRIBUTE19 in VARCHAR2 :=NULL,
 P_ATTRIBUTE20 in VARCHAR2 :=NULL,
  P_UDS_ATTRIBUTE_CATEGORY in VARCHAR2 := NULL,
  P_UDS_ATTRIBUTE1 in VARCHAR2 := NULL,
  P_UDS_ATTRIBUTE2 in VARCHAR2 := NULL,
  P_UDS_ATTRIBUTE3 in VARCHAR2 := NULL,
  P_UDS_ATTRIBUTE4 in VARCHAR2 := NULL,
  P_UDS_ATTRIBUTE5 in VARCHAR2 := NULL,
  P_UDS_ATTRIBUTE6 in VARCHAR2 := NULL,
  P_UDS_ATTRIBUTE7 in VARCHAR2 := NULL,
  P_UDS_ATTRIBUTE8 in VARCHAR2 := NULL,
  P_UDS_ATTRIBUTE9 in VARCHAR2 := NULL,
  P_UDS_ATTRIBUTE10 in VARCHAR2 := NULL,
  P_UDS_ATTRIBUTE11 in VARCHAR2 := NULL,
  P_UDS_ATTRIBUTE12 in VARCHAR2 := NULL,
  P_UDS_ATTRIBUTE13 in VARCHAR2 := NULL,
  P_UDS_ATTRIBUTE14 in VARCHAR2 := NULL,
  P_UDS_ATTRIBUTE15 in VARCHAR2 := NULL,
  P_UDS_ATTRIBUTE16 in VARCHAR2 := NULL,
  P_UDS_ATTRIBUTE17 in VARCHAR2 := NULL,
  P_UDS_ATTRIBUTE18 in VARCHAR2 := NULL,
  P_UDS_ATTRIBUTE19 in VARCHAR2 := NULL,
  P_UDS_ATTRIBUTE20 in VARCHAR2 := NULL,

 x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
 x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
 x_msg_data                    OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
  )  IS
     l_msg_index_out        NUMBER;

Line: 275


  PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PUB.Update_REPORT_REGION');

Line: 286


  pa_progress_report_pvt.Update_REPORT_REGION
  (
   p_api_version   ,
   p_init_msg_list ,
   p_commit        ,
   p_validate_only ,
   p_max_msg_count   ,

   P_VERSION_ID ,
   P_REGION_SOURCE_TYPE ,
   P_REGION_CODE ,
   p_record_sequence,
   p_record_version_number,
   P_ATTRIBUTE1 ,
   P_ATTRIBUTE2 ,
   P_ATTRIBUTE3 ,
   P_ATTRIBUTE4 ,
   P_ATTRIBUTE5 ,
   P_ATTRIBUTE6 ,
   P_ATTRIBUTE7 ,
   P_ATTRIBUTE8 ,
   P_ATTRIBUTE9 ,
   p_attribute10,
   p_attribute11,
   p_attribute12,
   p_attribute13,
   p_attribute14,
   p_attribute15,
   p_attribute16,
   p_attribute17,
   P_ATTRIBUTE18 ,
   P_ATTRIBUTE19 ,
   P_ATTRIBUTE20 ,
 P_UDS_ATTRIBUTE_CATEGORY ,
  P_UDS_ATTRIBUTE1 ,
  P_UDS_ATTRIBUTE2 ,
  P_UDS_ATTRIBUTE3 ,
  P_UDS_ATTRIBUTE4 ,
  P_UDS_ATTRIBUTE5 ,
  P_UDS_ATTRIBUTE6 ,
  P_UDS_ATTRIBUTE7 ,
  P_UDS_ATTRIBUTE8 ,
  P_UDS_ATTRIBUTE9 ,
  P_UDS_ATTRIBUTE10 ,
  P_UDS_ATTRIBUTE11 ,
  P_UDS_ATTRIBUTE12 ,
  P_UDS_ATTRIBUTE13 ,
  P_UDS_ATTRIBUTE14 ,
  P_UDS_ATTRIBUTE15 ,
  P_UDS_ATTRIBUTE16 ,
  P_UDS_ATTRIBUTE17 ,
  P_UDS_ATTRIBUTE18 ,
  P_UDS_ATTRIBUTE19 ,
  P_UDS_ATTRIBUTE20 ,
   x_return_status   ,
   x_msg_count       ,
   x_msg_data
     );

Line: 369


       FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PUB.Update_REPORT_REGION'
                                ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 374


END Update_REPORT_REGION;

Line: 378


PROCEDURE Delete_Report_Region
(
 p_api_version                 IN     NUMBER :=  1.0,
 p_init_msg_list               IN     VARCHAR2 := fnd_api.g_true,
 p_commit                      IN     VARCHAR2 := FND_API.g_false,
 p_validate_only               IN     VARCHAR2 := FND_API.g_true,
 p_max_msg_count               IN     NUMBER := FND_API.g_miss_num,

 p_version_id                  IN     NUMBER := NULL,
 P_REGION_SOURCE_TYPE          in VARCHAR2 := NULL,
 P_REGION_CODE                 in VARCHAR2 := NULL,
 P_RECORD_SEQUENCE             in NUMBER := NULL,
 p_record_version_number       IN NUMBER  := NULL,

 x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
 x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
 x_msg_data                    OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
 ) IS
     l_msg_index_out        NUMBER;

Line: 400


  PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PUB.Delete_Progress_Report');

Line: 411


  pa_progress_report_pvt.delete_report_region
  (
   p_api_version   ,
   p_init_msg_list ,
   p_commit        ,
   p_validate_only ,
   p_max_msg_count   ,

   p_version_id         ,
   p_region_source_type      ,
   p_region_code      ,
   p_record_sequence ,
   p_record_version_number,

   x_return_status   ,
   x_msg_count       ,
   x_msg_data
     );

Line: 454


       FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PUB.Delete_Progress_Report'
                                ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 459


END Delete_Report_Region;

Line: 839


PROCEDURE update_report_details
  (
   p_api_version                 IN     NUMBER :=  1.0,
   p_init_msg_list               IN     VARCHAR2 := fnd_api.g_true,
   p_commit                      IN     VARCHAR2 := FND_API.g_false,
   p_validate_only               IN     VARCHAR2 := FND_API.g_true,
   p_max_msg_count               IN     NUMBER := FND_API.g_miss_num,

   p_version_id                  IN     NUMBER := NULL,

   p_report_start_date           IN     DATE:= NULL,
   p_report_end_date             IN     DATE:= NULL,
   p_reported_by                 IN     NUMBER:= NULL,
   p_reported_by_name            IN     VARCHAR2:= NULL,
   p_progress_status             IN     VARCHAR2:= NULL,
   p_overview                    IN     VARCHAR2:= NULL,
   p_record_version_number       IN     NUMBER := NULL,

   x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
   x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
   x_msg_data                    OUT    NOCOPY VARCHAR2    --File.Sql.39 bug 4440895
   ) IS
 l_msg_index_out        NUMBER;

Line: 865


  PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PUB.update_report_details');

Line: 876


  pa_progress_report_pvt.update_report_details
  (
   p_api_version   ,
   p_init_msg_list ,
   p_commit        ,
   p_validate_only ,
   p_max_msg_count   ,

   p_version_id                  ,
   p_report_start_date      ,
   p_report_end_date        ,
   p_reported_by             ,
   p_reported_by_name             ,
   p_progress_status          ,
   p_overview                  ,
   p_record_version_number       ,

   x_return_status   ,
   x_msg_count       ,
   x_msg_data
     );

Line: 922


       FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PUB.update_report_details'
                                ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 928


END update_report_details;

Line: 930


PROCEDURE delete_report
  (
   p_api_version                 IN     NUMBER :=  1.0,
   p_init_msg_list               IN     VARCHAR2 := fnd_api.g_true,
   p_commit                      IN     VARCHAR2 := FND_API.g_false,
   p_validate_only               IN     VARCHAR2 := FND_API.g_true,
   p_max_msg_count               IN     NUMBER := FND_API.g_miss_num,

   p_version_id                  IN     NUMBER :=NULL,
   p_record_version_number       IN     NUMBER := NULL,

   x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
   x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
   x_msg_data                    OUT    NOCOPY VARCHAR2    --File.Sql.39 bug 4440895
   ) IS

  l_msg_index_out        NUMBER;

Line: 950


  PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_PUB.delete_report');

Line: 961


  pa_progress_report_pvt.delete_report
  (
   p_api_version   ,
   p_init_msg_list ,
   p_commit        ,
   p_validate_only ,
   p_max_msg_count   ,

   p_version_id                  ,
   p_record_version_number       ,

   x_return_status   ,
   x_msg_count       ,
   x_msg_data
     );

Line: 1001


       FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROGRESS_REPORT_PUB.delete_report'
                                ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 1006


END delete_report;