[Home] [Help]
28: if (p_lifecycle_id = FND_API.G_MISS_NUM) OR (p_lifecycle_id is NULL) then
29: if (p_lifecycle_name is not NULL) then
30: SELECT pev.element_version_id
31: INTO x_lifecycle_id
32: FROM pa_proj_elements pe, pa_proj_element_versions pev,
33: pa_lifecycle_usages plu
34: WHERE pe.project_id=0
35: AND pe.proj_element_id = pev.proj_element_id
36: AND pe.element_number = p_lifecycle_name
49: x_lifecycle_id := NULL;
50: ELSE
51: SELECT pev.element_version_id
52: INTO x_lifecycle_id
53: FROM pa_proj_elements pe, pa_proj_element_versions pev,
54: pa_lifecycle_usages plu
55: WHERE pe.project_id=0
56: AND pe.proj_element_id = pev.proj_element_id
57: AND pe.element_number = p_lifecycle_name
105: if (p_current_lifecycle_phase_id = FND_API.G_MISS_NUM) OR (p_current_lifecycle_phase_id is NULL) then
106: if (p_current_lifecycle_phase is not NULL) then
107: SELECT pev.element_version_id
108: INTO x_current_lifecycle_phase_id
109: FROM pa_proj_elements pe, pa_proj_element_versions pev
110: WHERE pe.project_id=0
111: AND pe.element_number = p_current_lifecycle_phase
112: AND pe.proj_element_id = pev.proj_element_id
113: AND pev.parent_structure_version_id = p_lifecycle_id;
124: x_current_lifecycle_phase_id := NULL;
125: ELSE
126: SELECT pev.element_version_id
127: INTO x_current_lifecycle_phase_id
128: FROM pa_proj_elements pe, pa_proj_element_versions pev
129: WHERE pe.project_id=0
130: AND pe.element_number = p_current_lifecycle_phase
131: AND pe.proj_element_id = pev.proj_element_id
132: AND pev.parent_structure_version_id = p_lifecycle_id;
286: WHERE project_id = p_project_id;*/
287: CURSOR get_flag IS
288: SELECT ppwa.wp_enable_version_flag
289: FROM pa_proj_workplan_attr ppwa,
290: pa_proj_elements ppe,
291: pa_proj_structure_types ppst,
292: pa_structure_types pst
293: WHERE ppwa.project_id = p_project_id
294: AND ppe.project_id = ppwa.project_id
326: --Jul 23rd Only Workplan
327: CURSOR get_sync_flag IS
328: select ppwa.AUTO_SYNC_TXN_DATE_FLAG
329: from pa_proj_workplan_attr ppwa,
330: pa_proj_elements ppe,
331: pa_proj_structure_types ppst,
332: pa_structure_types pst
333: WHERE ppwa.proj_element_id = p_proj_element_id
334: AND ppe.project_id = ppwa.project_id
363: --Jul 23rd Only Workplan
364: CURSOR get_sync_days IS
365: select ppwa.TXN_DATE_SYNC_BUF_DAYS
366: from pa_proj_workplan_attr ppwa,
367: pa_proj_elements ppe,
368: pa_proj_structure_types ppst,
369: pa_structure_types pst
370: WHERE ppwa.proj_element_id = p_proj_element_id
371: AND ppe.project_id = ppwa.project_id
476: cur_phase_version get_phase_version%ROWTYPE;
477:
478: CURSOR c1(c_phase_version_id IN NUMBER) IS
479: SELECT proj_element_id
480: FROM pa_proj_elements
481: WHERE phase_version_id = c_phase_version_id;
482:
483: l_del_lifecycle_phase_error EXCEPTION;
484: l_msg_index_out NUMBER;
545: CURSOR cur_wrkpln_attrs
546: IS
547: select ppwa.*
548: from pa_proj_workplan_attr ppwa,
549: pa_proj_elements ppe,
550: pa_proj_structure_types ppst,
551: pa_structure_types pst
552: WHERE ppwa.proj_element_id = p_proj_element_id
553: AND ppe.project_id = ppwa.project_id
647: --Jul 23rd Only Workplan
648: CURSOR get_flag IS
649: select ppwa.WP_APPROVAL_REQD_FLAG
650: from pa_proj_workplan_attr ppwa,
651: pa_proj_elements ppe,
652: pa_proj_structure_types ppst,
653: pa_structure_types pst
654: WHERE ppwa.project_id = p_project_id
655: AND ppe.project_id = ppwa.project_id
678: --Jul 23rd Only Workplan
679: CURSOR get_flag IS
680: select ppwa.WP_AUTO_PUBLISH_FLAG
681: from pa_proj_workplan_attr ppwa,
682: pa_proj_elements ppe,
683: pa_proj_structure_types ppst,
684: pa_structure_types pst
685: WHERE ppwa.project_id = p_project_id
686: AND ppe.project_id = ppwa.project_id
709: --Jul 23rd Only Workplan
710: CURSOR get_flag IS
711: select ppwa.AUTO_PUB_UPON_CREATION_FLAG
712: from pa_proj_workplan_attr ppwa,
713: pa_proj_elements ppe,
714: pa_proj_structure_types ppst,
715: pa_structure_types pst
716: WHERE ppwa.project_id = p_template_id
717: AND ppe.project_id = ppwa.project_id