The following lines contain the word 'select', 'insert', 'update' or 'delete':
select pa_workflow_itemkey_s.nextval
into l_item_key
from dual;
select STATUS_CODE
from pa_proj_elem_ver_structure
where project_id = l_project_id
and element_version_id = l_structure_version_id;
select a.element_version_id
from pa_proj_elem_ver_structure a,
pa_proj_element_versions b
where b.project_id = a.project_id
and b.proj_element_id = a.proj_element_id
and a.status_code = 'STRUCTURE_WORKING'
and b.element_version_id = c_structure_version_id;
update pa_proj_elem_ver_structure
set status_code = 'STRUCTURE_WORKING',
record_version_number = l_record_version_num + 1
where project_id = l_project_id
and element_version_id = l_structure_version_id;
SELECT 'Y'
from pa_proj_workplan_attr
where project_id = l_project_id
and WP_AUTO_PUBLISH_FLAG = 'Y';
procedure SELECT_ERROR_RECEIVER
(
p_item_type IN VARCHAR2
,p_item_key IN VARCHAR2
,actid IN NUMBER
,funcmode IN VARCHAR2
,resultout OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
)
IS
l_project_id NUMBER;
select distinct fu.user_id, fu.user_name, papf.email_address,
papf.full_name person_name
from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,
pa_project_role_types pprt
where object_type = 'PA_PROJECTS'
and object_id = l_project_id
and ppp.resource_type_id = 101
and ppp.project_role_id = pprt.project_role_id
and ppp.resource_source_id = fu.employee_id
and papf.person_id = fu.employee_id
and trunc(sysdate) between papf.effective_start_date
and nvl(papf.effective_end_date, sysdate+1)
and trunc(sysdate) between fu.start_date
and nvl(fu.end_date, sysdate+1)
and trunc(sysdate) between ppp.start_date_active
and nvl(ppp.end_date_active, sysdate+1)
and pprt.menu_id IN (select f1.menu_id
from fnd_compiled_menu_functions f1, fnd_form_functions f2
where (f2.function_name = 'PA_PAXPREPR_OPT_WORKPLAN_STR')
and f2.function_id = f1.function_id)
UNION /*Added this clause for 4482957 */
select distinct fu.user_id, fu.user_name, papf.email_address,
papf.full_name person_name
from fnd_user fu, per_all_people_f papf
where fu.user_id = fnd_global.USER_ID
and papf.person_id = fu.employee_id
and trunc(sysdate) between papf.effective_start_date
and nvl(papf.effective_end_date, sysdate+1)
and trunc(sysdate) between fu.start_date
and nvl(fu.end_date, sysdate+1) ;
select distinct fu.user_id, fu.user_name, papf.email_address,
papf.full_name person_name
from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,
pa_project_role_types pprt
where object_type = 'PA_PROJECTS'
and object_id = l_project_id
and ppp.resource_type_id = 112
and ppp.project_role_id = pprt.project_role_id
and ppp.resource_id = fu.customer_id
and papf.person_id = fu.employee_id
and trunc(sysdate) between papf.effective_start_date
and nvl(papf.effective_end_date, sysdate+1)
and trunc(sysdate) between fu.start_date
and nvl(fu.end_date, sysdate+1)
and trunc(sysdate) between ppp.start_date_active
and nvl(ppp.end_date_active, sysdate+1)
and pprt.menu_id IN (select f1.menu_id
from fnd_compiled_menu_functions f1, fnd_form_functions f2
where (f2.function_name = 'PA_PAXPREPR_OPT_WORKPLAN_STR')
and f2.function_id = f1.function_id);
select distinct fu.user_id, fu.user_name, papf.email_address,
papf.full_name person_name
from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,
pa_project_role_types pprt
where object_type = 'PA_PROJECTS'
and object_id = l_project_id
and ppp.resource_type_id = 112
and ppp.project_role_id = pprt.project_role_id
and ppp.resource_id = fu.person_party_id -- customer_id is changed to person_party_id
and papf.person_id = fu.employee_id
and trunc(sysdate) between papf.effective_start_date
and nvl(papf.effective_end_date, sysdate+1)
and trunc(sysdate) between fu.start_date
and nvl(fu.end_date, sysdate+1)
and trunc(sysdate) between ppp.start_date_active
and nvl(ppp.end_date_active, sysdate+1)
and pprt.menu_id IN (select f1.menu_id
from fnd_compiled_menu_functions f1, fnd_form_functions f2
where (f2.function_name = 'PA_PAXPREPR_OPT_WORKPLAN_STR')
and f2.function_id = f1.function_id);
Wf_Core.Context('pa_workplan_workflow','SELECT_ERROR_RECEIVER',p_item_type,p_item_key,to_char(actid),funcmode);
END SELECT_ERROR_RECEIVER;
SELECT page_content
FROM PA_PAGE_CONTENTS
WHERE pk1_value = document_id
AND object_type = 'PA_STRUCTURES'
AND pk2_value = 1;
SELECT segment1
from pa_projects_all
where project_id = p_project_id ;
SELECT 'Y' from pa_wf_processes where item_key= to_char(p_project_id) and item_type = 'PAPRJEX' ;
PA_WORKFLOW_UTILS.INSERT_WF_PROCESSES
(
p_wf_type_code => 'PROJECT'
,p_item_type => l_item_type
,p_item_key => to_char(p_project_id)
,p_entity_key1 => to_char(p_project_id)
,p_entity_key2 => to_char(p_project_id)
,p_description => NULL
,p_err_code => l_err_code
,p_err_stage => l_err_stage
,p_err_stack => l_err_stack
);
DELETE FROM PA_WF_PROCESSES
WHERE item_key = to_char(p_project_id)
AND item_type = 'PAPRJEX' ;
SELECT pev.element_version_id
FROM pa_proj_element_versions pev ,
pa_proj_structure_types pst
WHERE pev.project_id = l_project_id
AND pev.object_type = 'PA_STRUCTURES'
AND pev.proj_element_id = pst.proj_element_id
AND pst.structure_type_id = 1; -- WORKPLAN
SELECT ppe.proj_element_id
,pevs.scheduled_start_date
,ppe.wf_item_type
,ppe.wf_process
,ppe.wf_start_lead_days
,element_number
FROM pa_proj_elem_ver_schedule pevs ,
pa_proj_element_versions pev,
pa_proj_elements ppe
WHERE pev.parent_structure_version_id = c_parent_struct_ver_id
AND pev.object_type = 'PA_TASKS'
AND ppe.object_type = 'PA_TASKS'
AND pev.proj_element_id = ppe.proj_element_id
AND pev.project_id = ppe.project_id
AND nvl(ppe.enable_wf_flag,'N')= 'Y'
AND pevs.element_version_id = pev.element_version_id
AND pev.project_id = pevs.project_id
AND pev.proj_element_id = pevs.proj_element_id ;
SELECT pa_workflow_itemkey_s.nextval
INTO l_item_key
FROM dual;
PA_WORKFLOW_UTILS.INSERT_WF_PROCESSES
(
p_wf_type_code => 'TASK_EXECUTION'
,p_item_type => get_all_tasks_rec.wf_item_type
,p_item_key => to_char(l_item_key)
,p_entity_key1 => to_char(l_project_id)
,p_entity_key2 => to_char(get_all_tasks_rec.proj_element_id)
,p_description => NULL
,p_err_code => l_err_code
,p_err_stage => l_err_stage
,p_err_stack => l_err_stack
);
SELECT enable_wf_flag
,wf_item_type
,wf_process
,wf_start_lead_days
,project_id
FROM pa_proj_elements
WHERE proj_element_id = p_task_id ;
SELECT pa_workflow_itemkey_s.nextval
INTO l_item_key
FROM dual;
PA_WORKFLOW_UTILS.INSERT_WF_PROCESSES
(
p_wf_type_code => 'TASK_EXECUTION'
,p_item_type => task_info_rec.wf_item_type
,p_item_key => to_char(l_item_key)
,p_entity_key1 => to_char(task_info_rec.project_id)
,p_entity_key2 => to_char(p_task_id)
,p_description => NULL
,p_err_code => l_err_code
,p_err_stage => l_err_stage
,p_err_stack => l_err_stack
);
Select enable_wf_flag
,wf_item_type
,project_id
from pa_proj_elements
where proj_element_id = p_task_id ;
SELECT pst.project_system_status_code
FROM pa_projects_all pa ,
pa_project_statuses pst
WHERE pa.project_id = c_project_id
AND pa.project_status_code = pst.project_status_code;
Wf_Core.Context('pa_workplan_workflow','SELECT_ERROR_RECEIVER',itemtype,itemkey,to_char(actid),funcmode);