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_PAGE_LAYOUT_PUB SQL Statements

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

Line: 50


      select menu_id from fnd_menus where menu_name = c_menu_name;   -- #Bug 3693907

Line: 153


PROCEDURE Update_Page_Layout
(
 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_page_id                     IN     NUMBER := null,

 p_page_name                   IN     VARCHAR2  := FND_API.g_miss_char,

-- p_page_type                   IN     VARCHAR2 := FND_API.g_miss_char,

 p_description                 IN     VARCHAR2 := FND_API.g_miss_char,

 p_start_date                  IN     DATE := null,

 p_end_date                    IN     DATE := null,
 p_shortcut_menu_id            IN     NUMBER := FND_API.g_miss_num,
 p_shortcut_menu_name          IN     VARCHAR2 := NULL,
 p_record_version_number       IN NUMBER := null,
 p_function_name	       IN     VARCHAR2,
 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: 185


  PA_DEBUG.init_err_stack('PA_PAGE_LAYOUT_PUB.Update_Page_Layout');

Line: 196


  pa_page_layout_pvt.Update_Page_Layout
	(
	 p_api_version             => p_api_version,
	 p_init_msg_list           => p_init_msg_list,
	 p_commit                  => p_commit,
	 p_validate_only           => p_validate_only,
	 p_max_msg_count           => p_max_msg_count,
	 p_page_id                 => p_page_id,
	 p_page_name               => p_page_name,
--	 p_page_type               => p_page_type,
	 p_description             => p_description,
	 p_start_date              => p_start_date,
	 p_end_date                => p_end_date,
         p_shortcut_menu_id        => p_shortcut_menu_id,
	 p_shortcut_menu_name        => p_shortcut_menu_name,
         p_record_version_number   => p_record_version_number,
	 p_function_name           => p_function_name,
	 x_return_status           => x_return_status,
	 x_msg_count               => x_msg_count,
	 x_msg_data                => x_msg_data
	 );

Line: 243


      FND_MSG_PUB.add_exc_msg ( p_pkg_name       => 'PA_PAGE_LAYOUT_PUB.Update_Page_Layout'
                               ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 250


END update_page_layout;

Line: 254


PROCEDURE Delete_Page_Layout
(
 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_page_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: 275


  PA_DEBUG.init_err_stack('PA_PAGE_LAYOUT_PUB.Delete_Page_Layout');

Line: 286


  PA_PAGE_LAYOUT_PVT.Delete_Page_Layout
     (
      p_api_version            => p_api_version
      ,p_init_msg_list         => p_init_msg_list
      ,p_commit                => p_commit
      ,p_validate_only         => p_validate_only
      ,p_max_msg_count         => p_max_msg_count
      ,p_page_id               => p_page_id
      ,p_record_version_number   => p_record_version_number
      ,x_return_status         => x_return_status
      ,x_msg_count             => x_msg_count
      ,x_msg_data              => x_msg_data
      );

Line: 324


         FND_MSG_PUB.add_exc_msg( p_pkg_name       => 'PA_PAGE_LAYOUT_PUB.Delete_Page_Layout'
                                 ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 330


END delete_page_layout;

Line: 358


	 SELECT pptr.view_region_code,
	   pptr.edit_region_code,
	   pptr.region_style
	   FROM pa_page_type_regions pptr,
	   pa_page_layouts ppl
	   WHERE pptr.page_type_code = ppl.page_type_code
	   AND ppl.page_id = p_page_id
       and pptr.region_source_type = p_region_source_type
       and pptr.region_source_code = p_region_source_code;

Line: 450


PROCEDURE Delete_Page_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_page_id                     IN     NUMBER := null,
 P_REGION_SOURCE_TYPE          in     VARCHAR2 := 'STD',
 P_REGION_SOURCE_CODE          in     VARCHAR2,
 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: 471


  PA_DEBUG.init_err_stack('PA_PAGE_LAYOUT_PUB.Delete_Page_Region');

Line: 481


  pa_page_layout_pvt.Delete_Page_Region
	(
	 p_api_version             => p_api_version,
	 p_init_msg_list           => p_init_msg_list,
	 p_commit                  => p_commit,
	 p_validate_only           => p_validate_only,
	 p_max_msg_count           => p_max_msg_count,
	 p_page_id                 => p_page_id,
         p_region_source_type      => p_region_source_type,
         p_region_source_code      => p_region_source_code,
	 p_record_version_number   => p_record_version_number,
	 x_return_status           => x_return_status,
	 x_msg_count               => x_msg_count,
	 x_msg_data                => x_msg_data
	 );

Line: 522


      FND_MSG_PUB.add_exc_msg ( p_pkg_name       => 'PA_PAGE_LAYOUT_PUB.Delete_Page_Region'
                               ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 529


END delete_page_region;

Line: 531


PROCEDURE Delete_All_Page_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_page_id                     IN     NUMBER := null,
 p_region_position             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: 551


  PA_DEBUG.init_err_stack('PA_PAGE_LAYOUT_PUB.Delete_All_Page_Region');

Line: 561


  pa_page_layout_pvt.Delete_All_Page_Region
	(
	 p_api_version             => p_api_version,
	 p_init_msg_list           => p_init_msg_list,
	 p_commit                  => p_commit,
	 p_validate_only           => p_validate_only,
	 p_max_msg_count           => p_max_msg_count,

	 p_page_id                 => p_page_id,
	 p_region_position         => p_region_position,

	 x_return_status           => x_return_status,
	 x_msg_count               => x_msg_count,
	 x_msg_data                => x_msg_data
	 );

Line: 602


      FND_MSG_PUB.add_exc_msg ( p_pkg_name       => 'PA_PAGE_LAYOUT_PUB.Delete_All_Page_Region'
                               ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 609


END delete_all_page_region;

Line: 611


PROCEDURE Delete_All_link_Page_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_page_id                     IN     NUMBER := null,
 p_region_position             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: 631


  PA_DEBUG.init_err_stack('PA_PAGE_LAYOUT_PUB.Delete_All_link_Page_Region');

Line: 641


  pa_page_layout_pvt.Delete_All_link_Page_Region
	(
	 p_api_version             => p_api_version,
	 p_init_msg_list           => p_init_msg_list,
	 p_commit                  => p_commit,
	 p_validate_only           => p_validate_only,
	 p_max_msg_count           => p_max_msg_count,

	 p_page_id                 => p_page_id,
	 p_region_position         => p_region_position,

	 x_return_status           => x_return_status,
	 x_msg_count               => x_msg_count,
	 x_msg_data                => x_msg_data
	 );

Line: 682


      FND_MSG_PUB.add_exc_msg ( p_pkg_name       => 'PA_PAGE_LAYOUT_PUB.Delete_All_link_Page_Region'
                               ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 689


END delete_all_link_page_region;