The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT pev.element_version_id
INTO x_lifecycle_id
FROM pa_proj_elements pe, pa_proj_element_versions pev,
pa_lifecycle_usages plu
WHERE pe.project_id=0
AND pe.proj_element_id = pev.proj_element_id
AND pe.element_number = p_lifecycle_name
AND pe.proj_element_id = plu.LIFECYCLE_ID
AND plu.USAGE_TYPE = 'PROJECTS';
SELECT pev.element_version_id
INTO x_lifecycle_id
FROM pa_proj_elements pe, pa_proj_element_versions pev,
pa_lifecycle_usages plu
WHERE pe.project_id=0
AND pe.proj_element_id = pev.proj_element_id
AND pe.element_number = p_lifecycle_name
AND pe.proj_element_id = plu.LIFECYCLE_ID
AND plu.USAGE_TYPE = 'PROJECTS';
SELECT pev.element_version_id
INTO x_current_lifecycle_phase_id
FROM pa_proj_elements pe, pa_proj_element_versions pev
WHERE pe.project_id=0
AND pe.element_number = p_current_lifecycle_phase
AND pe.proj_element_id = pev.proj_element_id
AND pev.parent_structure_version_id = p_lifecycle_id;
SELECT pev.element_version_id
INTO x_current_lifecycle_phase_id
FROM pa_proj_elements pe, pa_proj_element_versions pev
WHERE pe.project_id=0
AND pe.element_number = p_current_lifecycle_phase
AND pe.proj_element_id = pev.proj_element_id
AND pev.parent_structure_version_id = p_lifecycle_id;
SELECT resource_source_id, resource_type_id
FROM pa_people_lov_v
WHERE name = p_approver_name;
SELECT resource_source_id, resource_type_id
INTO x_approver_source_id, x_approver_source_type
FROM pa_people_lov_v
WHERE name = p_approver_name;
SELECT resource_source_id, resource_type_id
INTO x_approver_source_id, x_approver_source_type
FROM pa_people_lov_v
WHERE resource_source_id = p_approver_source_id
AND resource_type_id = p_approver_source_type;
SELECT wp_enable_version_flag
FROM pa_proj_workplan_attr
WHERE project_id = p_project_id;*/
SELECT ppwa.wp_enable_version_flag
FROM pa_proj_workplan_attr ppwa,
pa_proj_elements ppe,
pa_proj_structure_types ppst,
pa_structure_types pst
WHERE ppwa.project_id = p_project_id
AND ppe.project_id = ppwa.project_id
AND ppe.proj_element_id = ppwa.proj_element_id
AND ppe.proj_element_id = ppst.proj_element_id
AND ppst.structure_type_id = pst.structure_type_id
AND pst.structure_type_class_code = 'WORKPLAN';
select ppwa.AUTO_SYNC_TXN_DATE_FLAG
from pa_proj_workplan_attr ppwa,
pa_proj_elements ppe,
pa_proj_structure_types ppst,
pa_structure_types pst
WHERE ppwa.proj_element_id = p_proj_element_id
AND ppe.project_id = ppwa.project_id
AND ppe.proj_element_id = ppwa.proj_element_id
AND ppe.proj_element_id = ppst.proj_element_id
AND ppst.structure_type_id = pst.structure_type_id
AND pst.structure_type_class_code = 'WORKPLAN';
/* select AUTO_SYNC_TXN_DATE_FLAG
from pa_proj_workplan_attr
Where proj_element_id = p_proj_element_id;*/
select ppwa.TXN_DATE_SYNC_BUF_DAYS
from pa_proj_workplan_attr ppwa,
pa_proj_elements ppe,
pa_proj_structure_types ppst,
pa_structure_types pst
WHERE ppwa.proj_element_id = p_proj_element_id
AND ppe.project_id = ppwa.project_id
AND ppe.proj_element_id = ppwa.proj_element_id
AND ppe.proj_element_id = ppst.proj_element_id
AND ppst.structure_type_id = pst.structure_type_id
AND pst.structure_type_class_code = 'WORKPLAN';
/* select TXN_DATE_SYNC_BUF_DAYS
from pa_proj_workplan_attr
Where proj_element_id = p_proj_element_id; */
SELECT element_version_id
FROM pa_proj_element_versions
WHERE proj_element_id = c_proj_element_id;
SELECT project_id
FROM pa_proj_workplan_attr
WHERE lifecycle_version_id = c_lifecycle_version_id;
l_delete_lifecycle_error EXCEPTION;
RAISE l_delete_lifecycle_error;
WHEN l_delete_lifecycle_error THEN
PA_UTILS.add_message('PA','PA_DEL_LIFECYCLE_ERROR');
SELECT element_version_id
FROM pa_proj_element_versions
WHERE proj_element_id = c_proj_element_id;
SELECT proj_element_id
FROM pa_proj_elements
WHERE phase_version_id = c_phase_version_id;
PROCEDURE UPDATE_CURRENT_PHASE
(
p_lifecycle_phase_id IN NUMBER
,p_proj_element_id IN NUMBER
,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
--Jul 23rd Only Workplan
CURSOR cur_wrkpln_attrs
IS
select ppwa.*
from pa_proj_workplan_attr ppwa,
pa_proj_elements ppe,
pa_proj_structure_types ppst,
pa_structure_types pst
WHERE ppwa.proj_element_id = p_proj_element_id
AND ppe.project_id = ppwa.project_id
AND ppe.proj_element_id = ppwa.proj_element_id
AND ppe.proj_element_id = ppst.proj_element_id
AND ppst.structure_type_id = pst.structure_type_id
AND pst.structure_type_class_code = 'WORKPLAN';
/*SELECT *
FROM PA_PROJ_WORKPLAN_ATTR
WHERE proj_element_id = p_proj_element_id; */
PA_WORKPLAN_ATTR_PUB.update_proj_workplan_attrs(
p_validate_only => FND_API.G_FALSE
,p_project_id => l_cur_wrkpln_attrs_rec.project_id
,p_proj_element_id => p_proj_element_id
,p_approval_reqd_flag => l_cur_wrkpln_attrs_rec.WP_APPROVAL_REQD_FLAG
,p_auto_publish_flag => l_cur_wrkpln_attrs_rec.WP_AUTO_PUBLISH_FLAG
,p_approver_source_id => l_cur_wrkpln_attrs_rec.WP_APPROVER_SOURCE_ID
,p_approver_source_type => l_cur_wrkpln_attrs_rec.WP_APPROVER_SOURCE_TYPE
,p_default_display_lvl => l_cur_wrkpln_attrs_rec.WP_DEFAULT_DISPLAY_LVL
,p_enable_wp_version_flag => l_cur_wrkpln_attrs_rec.WP_ENABLE_VERSION_FLAG
,p_lifecycle_id => l_cur_wrkpln_attrs_rec.LIFECYCLE_VERSION_ID
,p_current_lifecycle_phase_id => p_lifecycle_phase_id
,p_auto_pub_upon_creation_flag => l_cur_wrkpln_attrs_rec.AUTO_PUB_UPON_CREATION_FLAG
,p_auto_sync_txn_date_flag => l_cur_wrkpln_attrs_rec.AUTO_SYNC_TXN_DATE_FLAG
,p_txn_date_sync_buf_days => l_cur_wrkpln_attrs_rec.TXN_DATE_SYNC_BUF_DAYS
,p_record_version_number => l_cur_wrkpln_attrs_rec.RECORD_VERSION_NUMBER
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
);
/* UPDATE PA_PROJ_WORKPLAN_ATTR
SET current_phase_version_id = p_lifecycle_phase_id
WHERE proj_element_id = p_proj_element_id;
(p_pkg_name => 'PA_WORKPLAN_ATTR_UTILS.UPDATE_CURRENT_PHASE',
p_procedure_name => PA_DEBUG.G_Err_Stack );
(p_pkg_name => 'PA_WORKPLAN_ATTR_UTILS.UPDATE_CURRENT_PHASE',
p_procedure_name => PA_DEBUG.G_Err_Stack );
END UPDATE_CURRENT_PHASE;
select ppwa.WP_APPROVAL_REQD_FLAG
from pa_proj_workplan_attr ppwa,
pa_proj_elements ppe,
pa_proj_structure_types ppst,
pa_structure_types pst
WHERE ppwa.project_id = p_project_id
AND ppe.project_id = ppwa.project_id
AND ppe.proj_element_id = ppwa.proj_element_id
AND ppe.proj_element_id = ppst.proj_element_id
AND ppst.structure_type_id = pst.structure_type_id
AND pst.structure_type_class_code = 'WORKPLAN';
/* SELECT WP_APPROVAL_REQD_FLAG
FROM pa_proj_workplan_attr
WHERE project_id = p_project_id;*/
select ppwa.WP_AUTO_PUBLISH_FLAG
from pa_proj_workplan_attr ppwa,
pa_proj_elements ppe,
pa_proj_structure_types ppst,
pa_structure_types pst
WHERE ppwa.project_id = p_project_id
AND ppe.project_id = ppwa.project_id
AND ppe.proj_element_id = ppwa.proj_element_id
AND ppe.proj_element_id = ppst.proj_element_id
AND ppst.structure_type_id = pst.structure_type_id
AND pst.structure_type_class_code = 'WORKPLAN';
/* SELECT WP_AUTO_PUBLISH_FLAG
FROM pa_proj_workplan_attr
WHERE project_id = p_project_id;*/
select ppwa.AUTO_PUB_UPON_CREATION_FLAG
from pa_proj_workplan_attr ppwa,
pa_proj_elements ppe,
pa_proj_structure_types ppst,
pa_structure_types pst
WHERE ppwa.project_id = p_template_id
AND ppe.project_id = ppwa.project_id
AND ppe.proj_element_id = ppwa.proj_element_id
AND ppe.proj_element_id = ppst.proj_element_id
AND ppst.structure_type_id = pst.structure_type_id
AND pst.structure_type_class_code = 'WORKPLAN';
/* SELECT AUTO_PUB_UPON_CREATION_FLAG
FROM pa_proj_workplan_attr
WHERE project_id = p_template_id;*/