The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE update_project_set
(p_project_set_id IN pa_project_sets_b.project_set_id%TYPE
,p_project_set_name IN pa_project_sets_tl.name%TYPE := FND_API.G_MISS_CHAR
,p_party_id IN pa_project_sets_b.party_id%TYPE := FND_API.G_MISS_NUM
,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE := FND_API.G_MISS_DATE
,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE := FND_API.G_MISS_DATE
,p_access_level IN pa_project_sets_b.access_level%TYPE := FND_API.G_MISS_NUM
,p_description IN pa_project_sets_tl.description%TYPE := FND_API.G_MISS_CHAR
,p_party_name IN hz_parties.party_name%TYPE := FND_API.G_MISS_CHAR
,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
,p_attribute1 IN pa_project_sets_b.attribute1%TYPE := FND_API.G_MISS_CHAR
,p_attribute2 IN pa_project_sets_b.attribute2%TYPE := FND_API.G_MISS_CHAR
,p_attribute3 IN pa_project_sets_b.attribute3%TYPE := FND_API.G_MISS_CHAR
,p_attribute4 IN pa_project_sets_b.attribute4%TYPE := FND_API.G_MISS_CHAR
,p_attribute5 IN pa_project_sets_b.attribute5%TYPE := FND_API.G_MISS_CHAR
,p_attribute6 IN pa_project_sets_b.attribute6%TYPE := FND_API.G_MISS_CHAR
,p_attribute7 IN pa_project_sets_b.attribute7%TYPE := FND_API.G_MISS_CHAR
,p_attribute8 IN pa_project_sets_b.attribute8%TYPE := FND_API.G_MISS_CHAR
,p_attribute9 IN pa_project_sets_b.attribute9%TYPE := FND_API.G_MISS_CHAR
,p_attribute10 IN pa_project_sets_b.attribute10%TYPE := FND_API.G_MISS_CHAR
,p_attribute11 IN pa_project_sets_b.attribute11%TYPE := FND_API.G_MISS_CHAR
,p_attribute12 IN pa_project_sets_b.attribute12%TYPE := FND_API.G_MISS_CHAR
,p_attribute13 IN pa_project_sets_b.attribute13%TYPE := FND_API.G_MISS_CHAR
,p_attribute14 IN pa_project_sets_b.attribute14%TYPE := FND_API.G_MISS_CHAR
,p_attribute15 IN pa_project_sets_b.attribute15%TYPE := FND_API.G_MISS_CHAR
,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE := NULL
,p_api_version IN NUMBER := 1.0
,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
,p_commit IN VARCHAR2 := FND_API.G_FALSE
,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
,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_return_status VARCHAR2(1);
PA_DEBUG.init_err_stack('PA_PROJECT_SETS_PUB.Update_Project_Set');
SAVEPOINT UPDATE_PROJECT_SETS_PUB;
PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SETS_PUB.Update_Project_Set.begin'
,x_msg => 'Beginning of Update_Project_Set pub'
,x_log_level => 5);
PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SETS_PUB.Update_Project_Set.begin'
,x_msg => 'calling Update_Project_Set pvt'
,x_log_level => 5);
PA_PROJECT_SETS_PVT.update_project_set(
p_project_set_id => p_project_set_id
,p_project_set_name => p_project_set_name
,p_party_id => p_party_id
,p_effective_start_date => p_effective_start_date
,p_effective_end_date => p_effective_end_date
,p_access_level => p_access_level
,p_description => p_description
,p_party_name => p_party_name
,p_attribute_category => p_attribute_category
,p_attribute1 => p_attribute1
,p_attribute2 => p_attribute2
,p_attribute3 => p_attribute3
,p_attribute4 => p_attribute4
,p_attribute5 => p_attribute5
,p_attribute6 => p_attribute6
,p_attribute7 => p_attribute7
,p_attribute8 => p_attribute8
,p_attribute9 => p_attribute9
,p_attribute10 => p_attribute10
,p_attribute11 => p_attribute11
,p_attribute12 => p_attribute12
,p_attribute13 => p_attribute13
,p_attribute14 => p_attribute14
,p_attribute15 => p_attribute15
,p_record_version_number => p_record_version_number
,x_return_status => l_return_status);
ROLLBACK TO UPDATE_PROJECT_SETS_PUB;
FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SETS_PUB.Update_Project_Set'
,p_procedure_name => PA_DEBUG.G_Err_Stack );
END update_project_set;
PROCEDURE delete_project_set
(p_project_set_id IN pa_project_sets_b.project_set_id%TYPE := NULL
,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE := NULL
,p_api_version IN NUMBER := 1.0
,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
,p_commit IN VARCHAR2 := FND_API.G_FALSE
,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
,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_return_status VARCHAR2(1);
PA_DEBUG.init_err_stack('PA_PROJECT_SETS_PUB.Delete_Project_Set');
SAVEPOINT Delete_PROJECT_SETS_PUB;
PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SETS_PUB.Delete_Project_Set.begin'
,x_msg => 'Beginning of Delete_Project_Set pub'
,x_log_level => 5);
PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SETS_PUB.Delete_Project_Set.begin'
,x_msg => 'calling Delete_Project_Set pvt'
,x_log_level => 5);
PA_PROJECT_SETS_PVT.delete_project_set
(p_project_set_id => p_project_set_id
,p_record_version_number => p_record_version_number
,x_return_status => l_return_status);
ROLLBACK TO Delete_PROJECT_SETS_PUB;
FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SETS_PUB.Delete_Project_Set'
,p_procedure_name => PA_DEBUG.G_Err_Stack );
END delete_project_set;
PROCEDURE delete_project_set_line
(p_project_set_id IN pa_project_set_lines.project_set_id%TYPE
,p_project_id IN pa_project_set_lines.project_id%TYPE
,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
,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_return_status VARCHAR2(1);
PA_DEBUG.init_err_stack('PA_PROJECT_SETS_PUB.Delete_Project_Set_Line');
SAVEPOINT Delete_PROJECT_SET_LINE_PUB;
PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SETS_PUB.Delete_Project_Set_Line.begin'
,x_msg => 'Beginning of Delete_Project_Set_Line pub'
,x_log_level => 5);
PA_DEBUG.write_log (x_module => 'pa.plsql.PA_PROJECT_SETS_PUB.Delete_Project_Set_Line.begin'
,x_msg => 'calling Delete_Project_Set_Line pvt'
,x_log_level => 5);
PA_PROJECT_SETS_PVT.delete_project_set_line
(p_project_set_id => p_project_set_id
,p_project_id => p_project_id
,x_return_status => l_return_status);
ROLLBACK TO Delete_PROJECT_SET_LINE_PUB;
FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SETS_PUB.Delete_Project_Set_Line'
,p_procedure_name => PA_DEBUG.G_Err_Stack );
END delete_project_set_line;
update PA_PROJECT_SETS_B
set PARTY_ID = p_to_fk_id,
last_update_date = hz_utility_pub.last_update_date,
last_updated_by = hz_utility_pub.user_id,
last_update_login = hz_utility_pub.last_update_login,
record_version_number = nvl(record_Version_number,0) +1
where PARTY_ID = p_from_fk_id;