APPS.PA_PAGE_TYPE_REGION_PVT SQL Statements

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

Line: 35

           SELECT meaning FROM pa_lookups pl
             WHERE lookup_type = 'PA_PAGE_TYPES'
             AND lookup_code = p_page_type_code;

Line: 79

	pa_page_type_region_pkg.Insert_page_type_region_Row
	  (
	   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
	   );

Line: 128

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,

 P_VIEW_REGION_CODE in VARCHAR2,
 P_EDIT_REGION_CODE in VARCHAR2,
 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


BEGIN

 -- Initialize the Error Stack
  PA_DEBUG.init_err_stack('PA_PAGE_TYPE_REGION_PVT.Update_Page_Type_Region');

Line: 168

    SAVEPOINT page_type_REGION_PVT_UPDATE;

Line: 182

	pa_page_type_region_pkg.Update_page_type_region_Row
	  (
	   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
	   );

Line: 219

        ROLLBACK TO PAGE_TYPE_REGION_PVT_UPDATE;

Line: 224

          ROLLBACK TO PAGE_TYPE_REGION_PVT_UPDATE;

Line: 228

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

Line: 234

END update_page_type_region;

Line: 238

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

BEGIN

  -- Initialize the Error Stack
  PA_DEBUG.init_err_stack('PA_PAGE_TYPE_REGION_PVT.Delete_Page_Type_Region');

Line: 266

    SAVEPOINT PAGE_TYPE_REGION_PVT_DELETE;

Line: 271

     PA_PAGE_TYPE_REGION_PKG.Delete_page_type_region_Row
       (
	 p_rowid => p_rowid,
	 p_page_type_code => p_page_type_code,
	 P_REGION_SOURCE_TYPE => p_region_source_type,
	 P_REGION_SOURCE_CODE => p_region_source_code
	 );

Line: 294

          ROLLBACK TO PAGE_TYPE_REGION_PVT_DELETE;

Line: 298

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

Line: 304

END delete_page_type_region;