[Home] [Help]
3627: AND wbs_level = p_wbs_level
3628: AND display_sequence < p_display_sequence );*/
3629: --Project Structure changes
3630: SELECT task_id, top_task_id
3631: FROM pa_tasks pt, pa_proj_element_versions ppev
3632: WHERE pt.wbs_level = p_wbs_level
3633: AND top_task_id = p_top_task_id_above
3634: AND pt.task_id = ppev.proj_element_id
3635: AND ppev.display_sequence = ( SELECT max( ppev.display_sequence )
3632: WHERE pt.wbs_level = p_wbs_level
3633: AND top_task_id = p_top_task_id_above
3634: AND pt.task_id = ppev.proj_element_id
3635: AND ppev.display_sequence = ( SELECT max( ppev.display_sequence )
3636: FROM pa_tasks pt, pa_proj_element_versions ppev
3637: WHERE top_task_id = p_top_task_id_above
3638: AND pt.wbs_level = p_wbs_level
3639: AND ppev.proj_element_id = pt.task_id
3640: AND ppev.display_sequence < p_display_sequence );
4015: AND display_sequence > p_display_sequence;*/
4016:
4017: --Project Structure changes
4018: SELECT pt.task_id, pt.record_version_number
4019: FROM pa_tasks pt, pa_proj_element_versions ppev
4020: WHERE top_task_id = p_top_task_id
4021: AND pt.task_id = ppev.proj_element_id
4022: AND ppev.display_sequence >= p_display_sequence; --bug 2968468
4023:
4033: AND project_id = p_project_id
4034: AND display_sequence > p_display_sequence;*/
4035:
4036: SELECT pt.task_id, pt.record_version_number
4037: FROM pa_tasks pt, pa_proj_element_versions ppev
4038: WHERE pt.wbs_level = p_wbs_level
4039: AND parent_task_id = l_parent_task_id
4040: AND pt.project_id = p_project_id
4041: AND pt.task_id = ppev.proj_element_id
4662: pt.work_type_id, pt.service_type_code,
4663: pt.chargeable_flag, pt.billable_flag, pt.receive_project_invoice_flag,
4664: pt.scheduled_start_date, pt.scheduled_finish_date, pt.start_date,
4665: pt.wbs_level, pt.task_id, ppev.display_sequence
4666: FROM pa_tasks pt, pa_proj_element_versions ppev
4667: WHERE pt.project_id = p_project_id
4668: AND pt.task_id = ppev.proj_element_id
4669: ORDER BY ppev.display_sequence;
4670:
5324: FROM pa_tasks
5325: WHERE project_id = p_project_id
5326: START WITH task_id = p_task_id
5327: CONNECT BY PRIOR task_id = parent_task_id ) pt,
5328: pa_proj_element_versions ppev
5329: WHERE pt.task_id = ppev.proj_element_id
5330: ORDER BY ppev.display_sequence;
5331:
5332: CURSOR cur_ref_info
5698: ( SELECT task_id, top_task_id, parent_task_id, wbs_level, record_version_number
5699: FROM pa_tasks
5700: WHERE project_id = p_project_id
5701: START WITH task_id = p_task_id
5702: CONNECT BY PRIOR task_id = parent_task_id ) pt, pa_proj_element_versions ppev
5703: WHERE pt.task_id = ppev.proj_element_id
5704: ORDER BY ppev.display_sequence;
5705:
5706: CURSOR cur_ref_info
5717: ( SELECT task_id, top_task_id, parent_task_id, wbs_level
5718: FROM pa_tasks
5719: WHERE project_id = p_reference_project_id
5720: START WITH task_id = p_reference_task_id
5721: CONNECT BY PRIOR task_id = parent_task_id ) pt, pa_proj_element_versions ppev
5722: WHERE pt.task_id = ppev.proj_element_id
5723: ORDER BY ppev.display_sequence;
5724: --Added cur_task_detail for bug 16088808
5725: CURSOR cur_task_detail
5727: SELECT pt.task_id, ppev.display_sequence, pt.top_task_id, pt.parent_task_id, pt.wbs_level, pt.record_version_number
5728: FROM
5729: ( SELECT task_id, top_task_id, parent_task_id, wbs_level, record_version_number
5730: FROM pa_tasks
5731: WHERE project_id = p_project_id and task_id = p_task_id ) pt, pa_proj_element_versions ppev
5732: WHERE pt.task_id = ppev.proj_element_id
5733: ORDER BY ppev.display_sequence;
5734:
5735: l_rec_cur_ref_info cur_ref_info%ROWTYPE;
6088: --Begin add by rtarway for FP.M development
6089: -- Procedure : SET_UNSET_FINANCIAL_TASK
6090: -- Type : Public Procedure
6091: -- Purpose : This API will be called from set financial tasks page in financial tab
6092: -- : This Api is to set unset the financial_task_flag in pa_proj_element_versions table.
6093:
6094: -- Note :
6095: -- :
6096: -- :
6138: IS
6139: SELECT
6140: proj_element_id
6141: FROM
6142: pa_proj_element_versions
6143: WHERE
6144: project_id = l_project_id
6145: AND
6146: element_version_id = l_task_version_id;
6162: --This cursor gets the immediate parent of the passed task version id from the pa_object_relationships
6163: CURSOR c_get_immediate_parent (l_object_id_to1 NUMBER)
6164: IS
6165: SELECT proj_element_id
6166: FROM pa_proj_element_versions ppev,
6167: pa_object_relationships por
6168: WHERE ppev.element_version_id=por.object_id_from1
6169: AND por.relationship_type ='S'
6170: AND por.relationship_subtype ='TASK_TO_TASK'
6311: --Not using table handler as only one field needs to be updated.
6312:
6313:
6314: UPDATE
6315: PA_PROJ_ELEMENT_VERSIONS
6316: SET
6317: financial_task_flag = p_checked_flag
6318: WHERE
6319: element_version_id = p_task_version_id
6489: IS
6490: SELECT
6491: proj_element_id
6492: FROM
6493: pa_proj_element_versions
6494: WHERE
6495: element_version_id = l_element_version_id
6496: AND
6497: project_id = l_project_id;
6512: IS
6513: SELECT
6514: elever.proj_element_id
6515: FROM
6516: pa_proj_element_versions elever
6517: , pa_object_relationships obRel
6518: WHERE
6519: obRel.relationship_type ='S'
6520: AND
6534: , elements.element_number
6535:
6536: FROM
6537: pa_proj_elements elements
6538: , pa_proj_element_versions elever
6539: WHERE
6540: elever.element_version_id = l_element_version_id
6541: AND
6542: elever.project_id = l_project_id
6562: SELECT
6563: element_version_id
6564: ,financial_task_flag
6565: FROM
6566: pa_proj_element_versions
6567: WHERE
6568: parent_structure_version_id = l_structure_version_id
6569: AND
6570: object_type='PA_TASKS'