APPS.PA_PAGE_TYPE_REGION_PUB SQL Statements

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

Line: 46

      select 'Y' from dual
      where exists
      (select * from pa_page_type_regions
      where page_type_code = p_page_type_code
      and region_source_type = p_region_source_type
       and region_source_code = l_region_source_code);

Line: 212

PROCEDURE Update_Page_Type_Region
(
 p_api_version                 IN     NUMBER :=  1.0,
 p_init_msg_list               IN     VARCHAR2 := 'T',
 p_commit                      IN     VARCHAR2 := 'F',
 p_validate_only               IN     VARCHAR2 := 'T',
 p_max_msg_count               IN     NUMBER := 1.7E20,

 P_PAGE_TYPE_CODE in VARCHAR2,
 P_REGION_SOURCE_TYPE in VARCHAR2,
 P_REGION_SOURCE_CODE in VARCHAR2 := null,
 P_REGION_SOURCE_NAME in VARCHAR2 := null,

 P_VIEW_REGION_CODE in VARCHAR2 := null,
 P_EDIT_REGION_CODE in VARCHAR2 := null,
 P_VIEW_REGION_NAME in VARCHAR2 := null,
 P_EDIT_REGION_NAME in VARCHAR2 := null,
 P_REGION_STYLE in VARCHAR2 := '^',
 P_DISPLAY_ORDER in NUMBER := 1.7E20,
 P_MANDATORY_FLAG in VARCHAR2 := '^',
 P_DEFAULT_REGION_POSITION in VARCHAR2 := '^',
 P_PLACEHOLDER_REGION_FLAG in VARCHAR2 := '^',
 P_START_DATE_ACTIVE in DATE,
 P_END_DATE_ACTIVE in DATE,

 P_DOCUMENT_SOURCE in VARCHAR2 := null,
 P_PAGE_FUNCTION_NAME in VARCHAR2 := null,
 P_SECURITY_FUNCTION_NAME 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: 253

  PA_DEBUG.init_err_stack('PA_PAGE_TYPE_REGION_PUB.Update_Page_Type_Region');

Line: 309

  pa_page_type_region_pvt.Update_Page_Type_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_type_code => p_page_type_code,
	 P_REGION_SOURCE_TYPE => p_region_source_type,
	 P_REGION_SOURCE_CODE => p_region_source_code,

	 P_VIEW_REGION_CODE => p_view_region_code,
	 P_EDIT_REGION_CODE => p_edit_region_code,
	 P_REGION_STYLE => p_region_style,
	 P_DISPLAY_ORDER => p_display_order,
	 P_MANDATORY_FLAG => p_mandatory_flag,
	 P_DEFAULT_REGION_POSITION => p_default_region_position,
	 P_PLACEHOLDER_REGION_FLAG => p_placeholder_region_flag,
	 P_START_DATE_ACTIVE => P_START_DATE_ACTIVE,
	 P_END_DATE_ACTIVE => P_END_DATE_ACTIVE,

	 P_DOCUMENT_SOURCE =>  p_document_source,
         P_PAGE_FUNCTION_NAME => p_page_function_name,
         P_SECURITY_FUNCTION_NAME => p_security_function_name,

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

Line: 366

      FND_MSG_PUB.add_exc_msg ( p_pkg_name       => 'PA_PAGE_TYPE_REGION_PUB.Update_Page_Type_Region'
                               ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 373

END update_page_type_region;

Line: 377

PROCEDURE Delete_Page_Type_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_rowid                       IN     VARCHAR2 := NULL,
 P_PAGE_TYPE_CODE in VARCHAR2 := NULL,
 P_REGION_SOURCE_TYPE in VARCHAR2 := NULL,
 P_REGION_SOURCE_CODE 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: 400

  PA_DEBUG.init_err_stack('PA_PAGE_TYPE_REGION_PUB.Delete_Page_Type_Region');

Line: 411

  PA_PAGE_TYPE_REGION_PVT.Delete_Page_Type_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_type_code => p_page_type_code
      ,P_REGION_SOURCE_TYPE => p_region_source_type
      ,P_REGION_SOURCE_CODE => p_region_source_code

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

Line: 452

         FND_MSG_PUB.add_exc_msg( p_pkg_name       => 'PA_PAGE_TYPE_REGION_PUB.Delete_Page_Type_Region'
                                 ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 458

END delete_page_type_region;