The following lines contain the word 'select', 'insert', 'update' or 'delete':
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);
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;
PA_DEBUG.init_err_stack('PA_PAGE_TYPE_REGION_PUB.Update_Page_Type_Region');
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
);
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 );
END update_page_type_region;
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;
PA_DEBUG.init_err_stack('PA_PAGE_TYPE_REGION_PUB.Delete_Page_Type_Region');
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
);
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 );
END delete_page_type_region;