[Home] [Help]
515: l_check_sec_level VARCHAR2(1) := 'N';
516:
517: CURSOR cur_check_sec_level(p_proj_sec_level IN VARCHAR2 ) IS
518: SELECT 'Y' FROM
519: dual
520: WHERE EXISTS
521: (SELECT NULL FROM pa_lookups
522: WHERE
523: lookup_type = 'PA_PROJECT_ACCESS_LEVEL' AND
531: l_check_prob_id VARCHAR2(1) := 'N';
532:
533: CURSOR cur_validate_prob_member( p_project_id IN NUMBER ,p_probability_member_id IN NUMBER )
534: IS
535: SELECT 'Y' FROM dual
536: WHERE EXISTS
537: (
538: SELECT
539: NULL
607:
608: /* CURSOR cur_rev_inv(p_project_id IN VARCHAR2)
609: IS
610: SELECT 'Y'
611: FROM dual
612: WHERE EXISTS
613: (SELECT NULL
614: FROM
615: pa_draft_revenues r
628: */
629: CURSOR chk_task_level_funding(p_project_id IN VARCHAR2)
630: IS
631: SELECT 'Y'
632: FROM sys.dual
633: WHERE exists
634: ( select 1
635: from pa_summary_project_fundings
636: where project_id = p_project_id
10390: l_check_sec_level VARCHAR2(1) := 'N';
10391:
10392: CURSOR cur_check_sec_level(p_proj_sec_level IN VARCHAR2 ) IS
10393: SELECT 'Y' FROM
10394: dual
10395: WHERE EXISTS
10396: (SELECT NULL FROM pa_lookups
10397: WHERE
10398: lookup_type = 'PA_PROJECT_ACCESS_LEVEL' AND
10407: l_check_prob_id VARCHAR2(1) := 'N';
10408:
10409: CURSOR cur_validate_prob_member( p_project_id IN NUMBER ,p_probability_member_id IN NUMBER )
10410: IS
10411: SELECT 'Y' FROM dual
10412: WHERE EXISTS
10413: (
10414: SELECT
10415: NULL
10536:
10537: CURSOR cur_rev_inv(p_project_id IN VARCHAR2)
10538: IS
10539: SELECT 'Y'
10540: FROM dual
10541: WHERE EXISTS
10542: (SELECT NULL
10543: FROM
10544: pa_draft_revenues r
10557:
10558: CURSOR chk_task_level_funding(p_project_id IN VARCHAR2)
10559: IS
10560: SELECT 'Y'
10561: FROM dual
10562: WHERE exists
10563: ( select 1
10564: from pa_summary_project_fundings
10565: where project_id = p_project_id
35321: and modify the logic to use the above column value.
35322:
35323:
35324: cursor l_amg_task_csr (p_pa_task_id pa_tasks.task_id%type) is
35325: select 1 from dual
35326: where exists (select ppe.element_number
35327: from pa_proj_elements ppe, pa_proj_elem_ver_structure ppevs
35328: where ppe.proj_element_id = p_pa_task_id
35329: and ppe.object_type = 'PA_TASKS'
35332: and ppevs.status_code = 'STRUCTURE_PUBLISHED');
35333: */
35334:
35335: cursor l_amg_task_csr (p_pa_task_id pa_tasks.task_id%type) is
35336: select 1 from dual
35337: where exists(
35338: select pev.task_unpub_ver_status_code
35339: from pa_proj_element_versions pev
35340: where pev.proj_element_id = p_pa_task_id