[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select person_id
from pa_employees
where upper(full_name) = upper(p_task_mgr_name)
and active = '*'; --for bug 3245820
select person_id
from pa_employees
where upper(full_name) = upper(p_task_mgr_name)
and active = '*' -- for bug 3245820
and person_id in
( select RESOURCE_source_ID
from pa_project_parties ppp
where ppp.RESOURCE_type_ID = 101
and ppp.project_id = p_project_id
and trunc(sysdate) between ppp.START_DATE_ACTIVE
and NVL(ppp.end_date_active, SYSDATE));
SELECT person_id
INTO x_task_mgr_id
FROM pa_employees
WHERE person_id = p_task_mgr_id;
SELECT person_id
INTO x_task_mgr_id
FROM pa_employees
WHERE person_id = p_task_mgr_id
AND person_id in
( select RESOURCE_source_ID
from pa_project_parties ppp
where ppp.RESOURCE_type_ID = 101
and ppp.project_id = p_project_id
and trunc(sysdate) between ppp.START_DATE_ACTIVE
and NVL(ppp.end_date_active, SYSDATE));
select project_id
from pa_projects_all
where UPPER(name) = UPPER(p_project_name);
SELECT project_id
INTO x_project_id
FROM pa_projects_all
WHERE project_id = p_project_id;
select task_id
from pa_tasks
where UPPER(task_name) = UPPER(p_task_name)
and project_id = p_project_id;
SELECT task_id
INTO x_task_id
FROM pa_tasks
WHERE task_id = p_task_id and project_id = p_project_id;
select display_sequence
into l_s_num
from pa_tasks
where project_id = p_project_id
and task_id = p_task_id;
select max(display_sequence), min(display_sequence)
into l_s_num, l_s_num_min
from (
select display_sequence
from pa_tasks
where project_id = p_project_id
start with task_id = p_task_id
connect by prior task_id = parent_task_id
);
select min(ship_to_address_id) address_id, count('1') count
from pa_project_customers
where project_id = p_proj_id;
select min(start_date), max(completion_date) --Bug 6163119
from pa_tasks
where --parent_task_id = c1.tid --Bug 6163119
project_id = p_project_id
start with parent_task_id=c1.tid
connect by prior task_id= parent_task_id; --Bug 6163119
select start_date, completion_date
into l_start_date, l_end_date
from pa_projects_all
where project_id = p_project_id;
select start_date, completion_date
into l_start_date, l_end_date
from pa_tasks
where task_id = p_parent_task_id;
select start_date, completion_date
into l_pstart_date, l_pend_date
from pa_projects_all
where project_id = p_project_id;
select max(start_date),
min(completion_date)
into l_tstart_date,
l_tend_date
from pa_tasks
where project_id=p_project_id
start with task_id=p_parent_task_id
connect by task_id= prior parent_task_id;
select min(start_date), max(completion_date) --Bug 6163119
from pa_tasks
where --parent_task_id = c1.tid --Bug 6163119
project_id = p_project_id
start with parent_task_id=c1.tid
connect by prior task_id= parent_task_id;--Bug 6163119
select start_date, completion_date
into l_start_date, l_end_date
from pa_projects_all
where project_id = p_project_id;
select start_date, completion_date
into l_start_date, l_end_date
from pa_tasks
where task_id = p_parent_task_id;
select start_date, completion_date
into l_pstart_date, l_pend_date
from pa_projects_all
where project_id = p_project_id;
select max(start_date),
min(completion_date)
into l_tstart_date,
l_tend_date
from pa_tasks
where project_id=p_project_id
start with task_id=p_parent_task_id
connect by task_id= prior parent_task_id;
select nvl(cc_ic_billing_recvr_flag, 'N')
from pa_implementations_all -- Modified pa_implementations to pa_implementations_all for bug#3512486
where org_id = (select org_id from pa_projects_all where project_id = p_project_id); -- Added the where condition for bug#3512486
select nvl(cc_prvdr_flag, 'N')
from pa_project_types_all -- Modified pa_project_types to pa_project_types_all for bug#3512486
where project_type = p_project_type
and org_id = (select org_id from pa_projects_all where project_id = p_project_id); -- Added the and condition for bug#3512486
select SCHEDULED_START_DATE, SCHEDULED_FINISH_DATE
from pa_projects_all
where project_id = p_project_id;
p_update_start_date_flag => l_f1,
p_update_end_date_flag => l_f2,
p_return_status => l_ret);
p_update_start_date_flag => l_f1,
p_update_end_date_flag => l_f2,
p_return_status => l_ret);
p_update_start_date_flag => l_f1,
p_update_end_date_flag => l_f2,
p_return_status => l_ret);
SELECT org_id INTO l_org_id
FROM PA_PROJECTS_ALL
WHERE project_id = p_project_id;
if p_mode = 'INSERT' then
if p_display_seq < 0 then
i := abs(p_display_seq);
if p_mode = 'DELETE' then
i := p_display_seq - p_number_tasks;
SELECT parent_task_id, project_id
FROM pa_tasks
WHERE task_id = p_reference_task_id;
SELECT PT.CARRYING_OUT_ORGANIZATION_ID
,HOU.NAME CARRYING_OUT_ORGANIZATION_NAME
,PT.WORK_TYPE_ID
,PWT.NAME WORK_TYPE_NAME
,PT.SERVICE_TYPE_CODE
,PL.MEANING SERVICE_TYPE_NAME
FROM PA_TASKS PT
,HR_ORGANIZATION_UNITS HOU
,PA_WORK_TYPES_TL PWT
,PA_LOOKUPS PL
WHERE PT.TASK_ID = p_task_id
AND PT.CARRYING_OUT_ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND PT.WORK_TYPE_ID = PWT.WORK_TYPE_ID(+)
AND userenv('lang') = PWT.language(+)
AND PT.SERVICE_TYPE_CODE = PL.LOOKUP_CODE(+)
AND PL.LOOKUP_TYPE(+) = 'SERVICE_TYPE';
SELECT PPA.CARRYING_OUT_ORGANIZATION_ID
,HOU.NAME CARRYING_OUT_ORGANIZATION_NAME
,PPA.WORK_TYPE_ID
,PWT.NAME WORK_TYPE_NAME
,PPT.SERVICE_TYPE_CODE
,PL.MEANING SERVICE_TYPE_NAME
FROM PA_PROJECTS_ALL PPA
,HR_ORGANIZATION_UNITS HOU
,PA_WORK_TYPES_TL PWT
,PA_LOOKUPS PL
,PA_PROJECT_TYPES_ALL PPT
WHERE PPA.PROJECT_ID = p_project_id
AND PPA.CARRYING_OUT_ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND PPA.WORK_TYPE_ID = PWT.WORK_TYPE_ID(+)
AND userenv('lang') = PWT.language(+)
AND PPA.PROJECT_TYPE = PPT.PROJECT_TYPE
AND PPA.ORG_ID = PPT.ORG_ID
AND PPT.SERVICE_TYPE_CODE = PL.LOOKUP_CODE(+)
AND PL.LOOKUP_TYPE(+) = 'SERVICE_TYPE';
select 'Y'
from pa_tasks t
where t.project_id = p_project_id and
t.parent_task_id = p_task_id;
SELECT wbs_level, task_id, top_task_id, parent_task_id, display_sequence
FROM pa_tasks
WHERE project_id = p_project_id
AND display_sequence = ( SELECT max( display_sequence )
FROM pa_tasks
WHERE project_id = p_project_id
AND display_sequence < ( SELECT display_sequence
FROM pa_tasks
WHERE project_id = p_project_id
AND task_id = p_task_id ) );*/
SELECT pt.wbs_level, pt.task_id, pt.top_task_id, pt.parent_task_id, ppev.display_sequence
FROM pa_tasks pt, pa_proj_element_versions ppev
WHERE pt.project_id = p_project_id
AND ppev.proj_element_id = pt.task_id
AND ppev.display_sequence = ( SELECT max( display_sequence )
FROM pa_proj_element_versions
WHERE project_id = p_project_id
AND display_sequence < ( SELECT display_sequence
FROM pa_proj_element_versions
WHERE project_id = p_project_id
AND proj_element_id = p_task_id ) );
SELECT wbs_level, top_task_id, parent_task_id, display_sequence
FROM pa_tasks
WHERE project_id = p_project_id
AND task_id = p_task_id;*/
SELECT pt.wbs_level, pt.top_task_id, pt.parent_task_id, ppev.display_sequence
FROM pa_tasks pt, pa_proj_element_versions ppev
WHERE pt.project_id = p_project_id
AND ppev.proj_element_id = p_task_id
AND ppev.proj_element_id = pt.task_id;
,p_update_start_date_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
,p_update_end_date_flag OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
IS
l_api_name CONSTANT VARCHAR2(30) := 'check_start_end_date';
select meaning into l_meaning
from pa_lookups
where lookup_type = 'PA_DATE' and lookup_code = p_context;
p_update_start_date_flag := 'Y';
p_update_start_date_flag := 'N';
p_update_end_date_flag := 'Y';
p_update_end_date_flag := 'N';
p_update_end_date_flag := 'Y';
p_update_end_date_flag := 'N';
p_update_end_date_flag := 'N';
p_update_start_date_flag := 'Y';
p_update_start_date_flag := 'N';
p_update_end_date_flag := 'Y';
p_update_end_date_flag := 'N';
p_update_end_date_flag := 'N';
p_update_start_date_flag := 'N';
p_update_end_date_flag := 'Y';
p_update_end_date_flag := 'N';
p_update_end_date_flag := 'Y';
p_update_end_date_flag := 'N';
p_update_end_date_flag := 'N';
p_update_start_date_flag := NULL ;
p_update_end_date_flag := NULL ;
p_update_start_date_flag := NULL ;
p_update_end_date_flag := NULL ;
p_update_start_date_flag := NULL ;
p_update_end_date_flag := NULL ;
SELECT 'x' INTO l_dummy_char
-- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
FROM pa_proj_elem_ver_structure
WHERE project_id = p_project_id
AND wbs_record_version_number = p_wbs_record_version_number
FOR UPDATE OF record_version_number NOWAIT;
SELECT 'x' INTO l_dummy_char
-- HY: changed from pa_projects_all to pa_proj_elem_ver_structure
FROM pa_proj_elem_ver_structure
WHERE project_id = p_project_id
AND wbs_record_version_number = p_wbs_record_version_number;
UPDATE pa_proj_elem_ver_structure
SET wbs_record_version_number = NVL( wbs_record_version_number, 0 ) + 1
WHERE project_id = p_project_id
AND wbs_record_version_number = p_wbs_record_version_number;
SELECT FINANCIAL_TASK_FLAG
FROM PA_PROJ_ELEMENT_VERSIONS plv
WHERE plv.ELEMENT_VERSION_ID = l_task_version_id;
x_error_msg_code := 'PA_CANT_MOVE_SELECTED_TASK';
SELECT 'X'
FROM dual
WHERE EXISTS
(
SELECT proj_element_id
, element_version_id
, financial_task_flag
FROM PA_PROJ_ELEMENT_VERSIONS plv
WHERE element_version_id
IN
( -- This select statement tries to select childs task version ids
SELECT object_id_to1
FROM pa_object_relationships
WHERE relationship_type='S'
AND relationship_subtype='TASK_TO_TASK'
START WITH object_id_from1 = l_element_version_id
CONNECT BY object_id_from1 = PRIOR object_id_to1
)
AND financial_task_flag = 'N'
);
SELECT MAX(pe.expenditure_item_date) ei_date
FROM pa_expenditure_items_all pe
WHERE pe.task_id IN (SELECT p.task_id
FROM pa_tasks p
where p.project_id = l_project_id
--Added by rtarway for bug 4242216
AND not exists
(
select parent_task_id
from pa_tasks pt
where pt.parent_task_id =p.task_id
and pt.project_id=l_project_id
)
--Added by rtarway for bug 4242216
START WITH p.task_id= l_task_id
CONNECT BY PRIOR p.task_id = p.parent_task_id
and p.project_id = l_project_id)
AND pe.project_id = l_project_id;
SELECT MIN(pe.expenditure_item_date) ei_date
FROM pa_expenditure_items_all pe
WHERE pe.task_id IN (
SELECT p.task_id
FROM pa_tasks p
WHERE p.project_id = l_project_id
--Added by rtarway for bug 4242216
AND not exists
(
select parent_task_id
from pa_tasks pt
where pt.parent_task_id =p.task_id
and pt.project_id=l_project_id
)
--Added by rtarway for bug 4242216
START WITH p.task_id= l_task_id
CONNECT BY PRIOR p.task_id = p.parent_task_id
AND p.project_id = l_project_id
)
and pe.project_id = l_project_id;