[Home] [Help]
1081:
1082: /* Bug 3946599 . This Cursor is Wrong.This will return both Financial as well as WP record
1083: CURSOR c1 IS
1084: select wp_approval_reqd_flag, wp_auto_publish_flag
1085: from pa_proj_workplan_attr
1086: where project_id = p_project_id; */
1087:
1088: -- Bug 3946599 : Included an additional clause in above cursor that
1089: -- The Structure Type is Workplan.
1089: -- The Structure Type is Workplan.
1090:
1091: CURSOR c1 IS
1092: select wp_approval_reqd_flag, wp_auto_publish_flag
1093: from pa_proj_workplan_attr ppw
1094: ,pa_proj_structure_types ppst
1095: ,pa_structure_types pst
1096: where ppw.project_id = p_project_id
1097: and ppw.proj_element_id = ppst.proj_element_id
3916: RETURN VARCHAR2
3917: IS
3918: cursor get_third_party_flag IS
3919: Select ppwa.SCHEDULE_THIRD_PARTY_FLAG
3920: from pa_proj_workplan_attr ppwa,
3921: pa_proj_structure_types ppst,
3922: pa_structure_types pst
3923: where p_project_id = ppwa.project_id
3924: and ppwa.proj_element_id = ppst.proj_element_id
3941: RETURN VARCHAR2
3942: IS
3943: cursor get_lowest_tsk_dep_flag IS
3944: Select ppwa.ALLOW_LOWEST_TSK_DEP_FLAG
3945: from pa_proj_workplan_attr ppwa,
3946: pa_proj_structure_types ppst,
3947: pa_structure_types pst
3948: where p_project_id = ppwa.project_id
3949: and ppwa.proj_element_id = ppst.proj_element_id
5262: l_return_status VARCHAR2(1);
5263: l_msg_data VARCHAR2(2000);
5264:
5265: l_structure_id pa_proj_elem_ver_structure.proj_element_id%TYPE;
5266: l_buffer pa_proj_workplan_attr.txn_date_sync_buf_days%TYPE;
5267:
5268: l_old_task_start_date DATE;
5269: l_old_task_finish_date DATE;
5270: l_task_start_date DATE;
5284:
5285: CURSOR get_buffer(c_structure_id pa_proj_elem_ver_structure.proj_element_id%TYPE)
5286: IS
5287: SELECT NVL(txn_date_sync_buf_days, 0)
5288: FROM pa_proj_workplan_attr
5289: WHERE proj_element_id = c_structure_id;
5290:
5291: CURSOR get_tasks
5292: IS