[Home] [Help]
527: l_check_sec_level VARCHAR2(1) := 'N';
528:
529: CURSOR cur_check_sec_level(p_proj_sec_level IN VARCHAR2 ) IS
530: SELECT 'Y' FROM
531: dual
532: WHERE EXISTS
533: (SELECT NULL FROM pa_lookups
534: WHERE
535: lookup_type = 'PA_PROJECT_ACCESS_LEVEL' AND
543: l_check_prob_id VARCHAR2(1) := 'N';
544:
545: CURSOR cur_validate_prob_member( p_project_id IN NUMBER ,p_probability_member_id IN NUMBER )
546: IS
547: SELECT 'Y' FROM dual
548: WHERE EXISTS
549: (
550: SELECT
551: NULL
640:
641: /* CURSOR cur_rev_inv(p_project_id IN VARCHAR2)
642: IS
643: SELECT 'Y'
644: FROM dual
645: WHERE EXISTS
646: (SELECT NULL
647: FROM
648: pa_draft_revenues r
661: */
662: CURSOR chk_task_level_funding(p_project_id IN VARCHAR2)
663: IS
664: SELECT 'Y'
665: FROM sys.dual
666: WHERE exists
667: ( select 1
668: from pa_summary_project_fundings
669: where project_id = p_project_id
10652: l_check_sec_level VARCHAR2(1) := 'N';
10653:
10654: CURSOR cur_check_sec_level(p_proj_sec_level IN VARCHAR2 ) IS
10655: SELECT 'Y' FROM
10656: dual
10657: WHERE EXISTS
10658: (SELECT NULL FROM pa_lookups
10659: WHERE
10660: lookup_type = 'PA_PROJECT_ACCESS_LEVEL' AND
10669: l_check_prob_id VARCHAR2(1) := 'N';
10670:
10671: CURSOR cur_validate_prob_member( p_project_id IN NUMBER ,p_probability_member_id IN NUMBER )
10672: IS
10673: SELECT 'Y' FROM dual
10674: WHERE EXISTS
10675: (
10676: SELECT
10677: NULL
10803: /* Added for 12.2Payroll billing ER 11899223 */
10804: CURSOR cur_rev_inv(p_project_id IN VARCHAR2)
10805: IS
10806: SELECT 'Y'
10807: FROM dual
10808: WHERE EXISTS
10809: (SELECT NULL
10810: FROM
10811: pa_draft_revenues r
10824:
10825: CURSOR chk_task_level_funding(p_project_id IN VARCHAR2)
10826: IS
10827: SELECT 'Y'
10828: FROM dual
10829: WHERE exists
10830: ( select 1
10831: from pa_summary_project_fundings
10832: where project_id = p_project_id
21632: p_project_out.return_status := l_return_status;
21633: RAISE FND_API.G_EXC_ERROR;
21634: --Fix for bug#9110781 Starts
21635: ELSIF l_verify_ok_flag = 'Y' THEN
21636: SELECT pa_obj_status_changes_s.NEXTVAL INTO l_obj_status_change_id FROM dual;
21637:
21638: IF (l_debug_mode = 'Y') THEN
21639: pa_debug.debug('Calling PA_OBJ_STATUS_CHANGES_PKG.INSERT_ROW');
21640: pa_debug.debug('Project_id '|| l_project_rec.project_id);
35968: and modify the logic to use the above column value.
35969:
35970:
35971: cursor l_amg_task_csr (p_pa_task_id pa_tasks.task_id%type) is
35972: select 1 from dual
35973: where exists (select ppe.element_number
35974: from pa_proj_elements ppe, pa_proj_elem_ver_structure ppevs
35975: where ppe.proj_element_id = p_pa_task_id
35976: and ppe.object_type = 'PA_TASKS'
35979: and ppevs.status_code = 'STRUCTURE_PUBLISHED');
35980: */
35981:
35982: cursor l_amg_task_csr (p_pa_task_id pa_tasks.task_id%type) is
35983: select 1 from dual
35984: where exists(
35985: select pev.task_unpub_ver_status_code
35986: from pa_proj_element_versions pev
35987: where pev.proj_element_id = p_pa_task_id
39954: AND pst.structure_type_class_code IN( 'FINANCIAL' );
39955:
39956: CURSOR cur_pub_versions( c_structure_id NUMBER, c_project_id NUMBER ) is
39957: SELECT 'Y'
39958: FROM dual
39959: WHERE EXISTS(
39960: SELECT 'xyz'
39961: FROM pa_proj_elem_ver_structure
39962: WHERE proj_element_id = c_structure_id
39992: AND a.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');
39993:
39994: CURSOR get_sub_tasks(c_task_version_id NUMBER) IS
39995: SELECT '1'
39996: FROM dual
39997: WHERE EXISTS
39998: (SELECT 'xyz'
39999: FROM pa_object_relationships
40000: WHERE object_id_from1 = c_task_version_id
41365: AND pst.structure_type_class_code IN( 'FINANCIAL' );
41366:
41367: CURSOR cur_pub_versions( c_structure_id NUMBER, c_project_id NUMBER ) is
41368: SELECT 'Y'
41369: FROM dual
41370: WHERE EXISTS(
41371: SELECT 'xyz'
41372: FROM pa_proj_elem_ver_structure
41373: WHERE proj_element_id = c_structure_id
41403: AND a.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');
41404:
41405: CURSOR get_sub_tasks(c_task_version_id NUMBER) IS
41406: SELECT '1'
41407: FROM dual
41408: WHERE EXISTS
41409: (SELECT 'xyz'
41410: FROM pa_object_relationships
41411: WHERE object_id_from1 = c_task_version_id