[Home] [Help]
21:
22: l_rowid ROWID;
23: l_object_name VARCHAR2(250) := NULL;
24:
25: -- cursor c_task_name is select 'Wait for fix from Sakthi' from dual;
26:
27: -- cursor c_task_name is select element_name from PA_LATEST_PUB_STRUC_TASKS_V
28: cursor c_task_name is select element_name from PA_FIN_LATEST_PUB_TASKS_V
29: where proj_element_id = p_object_id
408:
409: IF g_ci_id is null or g_CI_id <> p_ci_id then
410: select 'Y'
411: into l_ci_type_has_impact
412: from dual
413: where exists ( select '1'
414: from pa_ci_impact_type_usage CIIU
415: ,pa_control_items CI
416: where CIIU.ci_type_id= CI.ci_type_id
442:
443: IF g_ci_type_id is null or g_ci_type_id <> p_ci_type_id then
444: select 'Y'
445: into l_type_has_impact
446: from dual
447: where exists ( select '1'
448: from pa_ci_impact_type_usage CIIU
449: where CIIU.ci_type_id = p_ci_type_id
450: ) ;
736: AND pwp.entity_key1 = l_project_id;
737:
738:
739: CURSOR get_wf_status IS
740: select 'Y' FROM dual
741: WHERE exists
742: (SELECT *
743: from wf_item_activity_statuses wias, pa_project_statuses pps
744: WHERE wias.item_type = pps.WORKFLOW_ITEM_TYPE
843: l_project_id NUMBER;
844:
845: CURSOR check_if_fin_impact_exists
846: is
847: SELECT 'Y' FROM dual
848: WHERE exists
849: (
850: SELECT * FROM pa_ci_impacts
851: WHERE ci_id = p_ci_id
2019: l_comment_text := fnd_message.get;
2020:
2021: SELECT pa_obj_status_changes_s.NEXTVAL
2022: INTO l_obj_status_change_id
2023: FROM dual;
2024:
2025: PA_OBJ_STATUS_CHANGES_PKG.INSERT_ROW (
2026: X_ROWID => l_rowid,
2027: X_OBJ_STATUS_CHANGE_ID => l_obj_status_change_id,
2131: l_project_id NUMBER;
2132:
2133: CURSOR check_if_fin_impact_exists
2134: is
2135: SELECT 'Y' FROM dual
2136: WHERE exists
2137: (
2138: SELECT * FROM pa_ci_impacts
2139: WHERE ci_id = p_ci_id