The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT DISTINCT ppp.resource_source_id party_id
INTO l_party_id
FROM hz_parties hzp,
pa_project_parties ppp
WHERE hzp.party_name = p_name
AND hzp.party_type = 'PERSON'
AND ppp.resource_source_id = hzp.party_id
AND ppp.resource_type_id = 112
AND ppp.project_id = p_project_id
AND (TRUNC(SYSDATE) BETWEEN TRUNC(ppp.start_date_active)
AND TRUNC(NVL(ppp.end_date_active, SYSDATE)));
SELECT DISTINCT ppf.party_id party_id
INTO l_party_id
FROM pa_project_parties ppp,
per_all_people_f ppf
WHERE ppf.full_name = p_name
AND (TRUNC(SYSDATE) BETWEEN TRUNC(ppf.effective_start_date)
AND TRUNC(ppf.effective_end_date))
AND ppp.resource_source_id = ppf.person_id
AND ppp.resource_type_id = 101
AND ppp.project_id = p_project_id
AND (TRUNC(SYSDATE) BETWEEN TRUNC(ppp.start_date_active)
AND TRUNC(NVL(ppp.end_date_active, SYSDATE)));
select proj_element_id
into l_object_id
from PA_FIN_LATEST_PUB_TASKS_V
where element_name = p_object_name
and project_id = p_project_id;
procedure UPDATE_CONTROL_ITEM (
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_ci_id IN NUMBER
,p_ci_type_id IN NUMBER
,p_summary IN VARCHAR2
,p_status_code IN VARCHAR2 := NULL
,p_owner_id IN NUMBER := NULL
,p_owner_name IN VARCHAR2 := NULL
,p_highlighted_flag IN VARCHAR2 := 'N'
,p_progress_status_code IN VARCHAR2
,p_progress_as_of_date IN DATE
,p_classification_code IN NUMBER
,p_reason_code IN NUMBER
,p_record_version_number IN NUMBER
,p_project_id IN NUMBER
,p_object_type IN VARCHAR2 := NULL
,p_object_id IN NUMBER := NULL
,p_object_name IN VARCHAR2 := NULL
,p_ci_number IN VARCHAR2 := NULL
,p_date_required IN DATE := NULL
,p_date_closed IN DATE := NULL
,p_closed_by_id IN NUMBER := NULL
,p_description IN VARCHAR2 := NULL
,p_status_overview IN VARCHAR2 := NULL
,p_resolution IN VARCHAR2 := NULL
,p_resolution_code IN NUMBER := NULL
,p_priority_code IN VARCHAR2 := NULL
,p_effort_level_code IN VARCHAR2 := NULL
,p_open_action_num IN NUMBER := NULL
,p_price IN NUMBER := NULL
,p_price_currency_code IN VARCHAR2 := NULL
,p_source_type_code IN VARCHAR2 := NULL
,p_source_comment IN VARCHAR2 := NULL
,p_source_number IN VARCHAR2 := NULL
,p_source_date_received IN DATE := NULL
,p_source_organization IN VARCHAR2 := NULL
,p_source_person IN VARCHAR2 := NULL
,p_attribute_category IN VARCHAR2 := NULL
,p_attribute1 IN VARCHAR2 := NULL
,p_attribute2 IN VARCHAR2 := NULL
,p_attribute3 IN VARCHAR2 := NULL
,p_attribute4 IN VARCHAR2 := NULL
,p_attribute5 IN VARCHAR2 := NULL
,p_attribute6 IN VARCHAR2 := NULL
,p_attribute7 IN VARCHAR2 := NULL
,p_attribute8 IN VARCHAR2 := NULL
,p_attribute9 IN VARCHAR2 := NULL
,p_attribute10 IN VARCHAR2 := NULL
,p_attribute11 IN VARCHAR2 := NULL
,p_attribute12 IN VARCHAR2 := NULL
,p_attribute13 IN VARCHAR2 := NULL
,p_attribute14 IN VARCHAR2 := NULL
,p_attribute15 IN VARCHAR2 := NULL
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) is
l_msg_index_out NUMBER;
select owner_id from pa_control_items
where ci_id = p_ci_id;
PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PUB.UPDATE_CONTROL_ITEM');
select proj_element_id
into l_object_id
from PA_FIN_LATEST_PUB_TASKS_V
where element_name = p_object_name
and project_id = p_project_id;
PA_CONTROL_ITEMS_PVT.UPDATE_CONTROL_ITEM(
p_api_version
,p_init_msg_list
,p_commit
,p_validate_only
,p_max_msg_count
,p_ci_id
,p_ci_type_id
,p_summary
,p_status_code
,l_owner_id
,nvl(p_highlighted_flag,'N')
,p_progress_status_code
,p_progress_as_of_date
,p_classification_code
,p_reason_code
,p_record_version_number
,p_project_id
,l_last_modified_by_id
,p_object_type
,l_object_id
,p_ci_number
,p_date_required
,p_date_closed
,p_closed_by_id
,p_description
,p_status_overview
,p_resolution
,p_resolution_code
,p_priority_code
,p_effort_level_code
,p_open_action_num
,p_price
,p_price_currency_code
,p_source_type_code
,p_source_comment
,p_source_number
,p_source_date_received
,p_source_organization
,p_source_person
,p_attribute_category
,p_attribute1
,p_attribute2
,p_attribute3
,p_attribute4
,p_attribute5
,p_attribute6
,p_attribute7
,p_attribute8
,p_attribute9
,p_attribute10
,p_attribute11
,p_attribute12
,p_attribute13
,p_attribute14
,p_attribute15
,x_return_status
,x_msg_count
,x_msg_data
);
FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PUB.UPDATE_CONTROL_ITEM'
,p_procedure_name => PA_DEBUG.G_Err_Stack );
end UPDATE_CONTROL_ITEM;
procedure DELETE_CONTROL_ITEM (
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_ci_id IN NUMBER
,p_record_version_number IN NUMBER
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) is
l_msg_index_out NUMBER;
PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PUB.DELETE_CONTROL_ITEM');
PA_CONTROL_ITEMS_PVT.DELETE_CONTROL_ITEM(
p_api_version
,p_init_msg_list
,p_commit
,p_validate_only
,p_max_msg_count
,p_ci_id
,p_record_version_number
,x_return_status
,x_msg_count
,x_msg_data
);
FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PUB.DELETE_CONTROL_ITEM'
,p_procedure_name => PA_DEBUG.G_Err_Stack );
end DELETE_CONTROL_ITEM;