[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
452:
453: IF g_ci_id is null or g_CI_id <> p_ci_id then
454: select 'Y'
455: into l_ci_type_has_impact
456: from dual
457: where exists ( select '1'
458: from pa_ci_impact_type_usage CIIU
459: ,pa_control_items CI
460: where CIIU.ci_type_id= CI.ci_type_id
486:
487: IF g_ci_type_id is null or g_ci_type_id <> p_ci_type_id then
488: select 'Y'
489: into l_type_has_impact
490: from dual
491: where exists ( select '1'
492: from pa_ci_impact_type_usage CIIU
493: where CIIU.ci_type_id = p_ci_type_id
494: ) ;
780: AND pwp.entity_key1 = l_project_id;
781:
782:
783: CURSOR get_wf_status IS
784: select 'Y' FROM dual
785: WHERE exists
786: (SELECT *
787: from wf_item_activity_statuses wias, pa_project_statuses pps
788: WHERE wias.item_type = pps.WORKFLOW_ITEM_TYPE
887: l_project_id NUMBER;
888:
889: CURSOR check_if_fin_impact_exists
890: is
891: SELECT 'Y' FROM dual
892: WHERE exists
893: (
894: SELECT * FROM pa_ci_impacts
895: WHERE ci_id = p_ci_id
2115: l_comment_text := fnd_message.get;
2116:
2117: SELECT pa_obj_status_changes_s.NEXTVAL
2118: INTO l_obj_status_change_id
2119: FROM dual;
2120:
2121: PA_OBJ_STATUS_CHANGES_PKG.INSERT_ROW (
2122: X_ROWID => l_rowid,
2123: X_OBJ_STATUS_CHANGE_ID => l_obj_status_change_id,
2227: l_project_id NUMBER;
2228:
2229: CURSOR check_if_fin_impact_exists
2230: is
2231: SELECT 'Y' FROM dual
2232: WHERE exists
2233: (
2234: SELECT * FROM pa_ci_impacts
2235: WHERE ci_id = p_ci_id