eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_TASK_PUB1 dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 1856: from PA_PROJ_ELEMENT_VERSIONS

1852: --Lock row
1853: IF( p_validate_only <> FND_API.G_TRUE) THEN
1854: BEGIN
1855: select 'x' into l_dummy
1856: from PA_PROJ_ELEMENT_VERSIONS
1857: where element_version_id = p_task_version_id
1858: and record_version_number = p_record_version_number
1859: for update of record_version_number NOWAIT;
1860: EXCEPTION

Line 1882: from PA_PROJ_ELEMENT_VERSIONS

1878: ELSE
1879: --check record_version_number
1880: BEGIN
1881: select 'x' into l_dummy
1882: from PA_PROJ_ELEMENT_VERSIONS
1883: where element_version_id = p_task_version_id
1884: and record_version_number = p_record_version_number;
1885: EXCEPTION
1886: WHEN NO_DATA_FOUND THEN

Line 2086: FROM pa_proj_element_versions

2082: l_project_id NUMBER;
2083: CURSOR cur_proj_id
2084: IS
2085: SELECT project_id
2086: FROM pa_proj_element_versions
2087: WHERE element_version_id = p_task_version_id;
2088:
2089: -- end hyau Bug 2852753
2090:

Line 2096: from pa_proj_element_versions a,

2092: --hsiu: added for task version status
2093: CURSOR get_task_info(c_task_version_id NUMBER) IS
2094: select a.project_id, b.proj_element_id, parent_structure_version_id,
2095: TASK_UNPUB_VER_STATUS_CODE, b.link_task_flag
2096: from pa_proj_element_versions a,
2097: pa_proj_elements b --bug 4501280
2098: where element_version_id = c_task_version_id
2099: --bug 4501280
2100: AND a.proj_element_id = b.proj_element_id

Line 2107: l_structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE ;

2103: ;
2104: l_task_info_rec get_task_info%ROWTYPE;
2105: --end changes for task version status
2106:
2107: l_structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE ;
2108:
2109: -- Bug Fix 4576640
2110: -- Adding a new check to stop users from deleting a linked task.
2111: -- Example:

Line 2164: from PA_PROJ_ELEMENT_VERSIONS

2160: --Lock row
2161: IF( p_validate_only <> FND_API.G_TRUE) THEN
2162: BEGIN
2163: select 'x' into l_dummy
2164: from PA_PROJ_ELEMENT_VERSIONS
2165: where element_version_id = p_task_version_id
2166: and record_version_number = p_record_version_number
2167: for update of record_version_number NOWAIT;
2168: EXCEPTION

Line 2193: from PA_PROJ_ELEMENT_VERSIONS

2189: ELSE
2190: --check record_version_number
2191: BEGIN
2192: select 'x' into l_dummy
2193: from PA_PROJ_ELEMENT_VERSIONS
2194: where element_version_id = p_task_version_id
2195: and record_version_number = p_record_version_number;
2196: EXCEPTION
2197: WHEN NO_DATA_FOUND THEN

Line 2967: From PA_Proj_Element_Versions a, pa_proj_elem_ver_schedule b

2963: If PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(l_Project_ID) = 'Y' Then
2964:
2965: Select a.Parent_Structure_Version_ID
2966: Into l_Structure_Version_ID
2967: From PA_Proj_Element_Versions a, pa_proj_elem_ver_schedule b
2968: Where a.Element_Version_ID = b.Element_Version_ID
2969: and b.pev_schedule_id = p_pev_schedule_id;
2970:
2971: PA_PROJECT_STRUCTURE_PVT1.update_sch_dirty_flag(

Line 3408: FROM pa_proj_element_versions b,

3404: b.attribute13,
3405: b.attribute14,
3406: b.attribute15,
3407: Financial_Task_Flag -- FP_M changes 3305199 Bhumesh
3408: FROM pa_proj_element_versions b,
3409: pa_proj_elements c
3410: WHERE b.proj_element_id = c.proj_element_id
3411: AND c.link_task_flag = 'N'
3412: AND p_copy_option IN ( 'PA_TASK_SUBTASK', 'PA_ENTIRE_VERSION' )

Line 3446: FROM pa_proj_element_versions ppev

3442: attribute13,
3443: attribute14,
3444: attribute15,
3445: Financial_Task_Flag -- FP_M changes 3305199 Bhumesh
3446: FROM pa_proj_element_versions ppev
3447: WHERE ppev.element_version_id = p_src_task_version_id
3448: /* not required any more
3449: -- Added for FP_M changes : Bug 3305199
3450: and ( p_structure_type = 'WORKPLAN' OR

Line 3531: CONNECT BY object_id_to1 = PRIOR object_id_from1 AND relationship_type = 'S' ) a, pa_proj_element_versions b

3527: START WITH OBJECT_ID_TO1 = x_child_task_id
3528: --hsiu: bug 2669388
3529: -- START WITH object_id_from1 = x_child_task_id
3530: --traverse reverse
3531: CONNECT BY object_id_to1 = PRIOR object_id_from1 AND relationship_type = 'S' ) a, pa_proj_element_versions b
3532: WHERE a.object_id_from1 = b.element_version_id
3533: AND b.wbs_level = x_wbs_level;
3534: */
3535:

Line 3539: FROM pa_proj_element_versions b

3535:
3536: CURSOR cur_rev_parent_task( x_child_task_id NUMBER, x_wbs_level NUMBER )
3537: IS
3538: SELECT b.element_version_id parent_task_id
3539: FROM pa_proj_element_versions b
3540: WHERE b.wbs_level = x_wbs_level
3541: AND b.element_version_id IN ( SELECT object_id_from1
3542: FROM pa_object_relationships
3543: WHERE relationship_type = 'S'

Line 3604: FROM pa_proj_element_versions

3600:
3601: CURSOR cur_dest_proj_id
3602: IS
3603: SELECT project_id
3604: FROM pa_proj_element_versions
3605: WHERE element_version_id = p_dest_task_version_id;
3606:
3607: /* Added the Cursor For Bug #3573143*/
3608: CURSOR cur_task_id (c_element_version_id IN NUMBER, c_project_id IN NUMBER) IS

Line 3610: FROM pa_proj_element_versions

3606:
3607: /* Added the Cursor For Bug #3573143*/
3608: CURSOR cur_task_id (c_element_version_id IN NUMBER, c_project_id IN NUMBER) IS
3609: SELECT proj_element_id
3610: FROM pa_proj_element_versions
3611: where element_version_id = c_element_version_id
3612: AND project_id = c_project_id;
3613: l_cur_task_id cur_task_id%ROWTYPE;
3614: /* Ended Bug 3573143*/

Line 3673: l_task_unpub_ver_status_code PA_PROJ_ELEMENT_VERSIONS.TASK_UNPUB_VER_STATUS_CODE%TYPE;

3669: where project_id = c_project_id
3670: and template_flag = 'Y';
3671: l_template_flag VARCHAR2(1);
3672:
3673: l_task_unpub_ver_status_code PA_PROJ_ELEMENT_VERSIONS.TASK_UNPUB_VER_STATUS_CODE%TYPE;
3674: --end hsiu changes
3675:
3676: -- xxlu added for DFF attributes for calling create_schedule_version
3677: CURSOR cur_proj_elem_ver_sch(c_element_version_id NUMBER, c_project_id NUMBER) IS

Line 3698: from pa_proj_element_versions

3694:
3695: --hsiu added for bug 2669388
3696: CURSOR get_ref_tk_wbs(c_element_version_id NUMBER) IS
3697: select WBS_LEVEL
3698: from pa_proj_element_versions
3699: where element_version_id = c_element_version_id;
3700:
3701: l_ref_tk_wbs_level NUMBER;
3702: l_src_tasks_found boolean := false; --Bug2741989

Line 4467: FROM pa_proj_element_versions

4463: IF is_top_task = 'x' THEN
4464: IF l_peer_or_sub = 'PEER' THEN
4465: SELECT proj_element_id
4466: INTO l_ref_task_id
4467: FROM pa_proj_element_versions
4468: WHERE element_version_id = l_ref_task_version_id;
4469: ELSE
4470: l_ref_task_id := null;
4471: END IF;

Line 4478: FROM pa_proj_element_versions

4474: l_ref_task_id := NULL;
4475: ELSE
4476: SELECT proj_element_id
4477: INTO l_ref_task_id
4478: FROM pa_proj_element_versions
4479: WHERE element_version_id = l_ref_task_version_id;
4480: END IF;
4481: END IF;
4482:

Line 4487: FROM pa_proj_element_versions

4483: -- 3905123 end
4484: ELSE
4485: SELECT proj_element_id
4486: INTO l_ref_task_id
4487: FROM pa_proj_element_versions
4488: WHERE element_version_id = l_ref_task_version_id;
4489: --commented for bug 2846700
4490: --WHERE element_version_id = p_dest_task_version_id;
4491: END IF;

Line 4855: FROM pa_proj_element_versions

4851:
4852: /* Bug 2623999 coomnted out the code below. It is redundant and causing issues */
4853: /*
4854: SELECT proj_element_id, project_id INTO l_structure_id, l_project_id
4855: FROM pa_proj_element_versions
4856: WHERE element_version_id = p_dest_structure_version_id
4857: AND object_type = 'PA_STRUCTURES';
4858:
4859: --Do financial task check

Line 4886: FROM pa_proj_element_versions

4882:
4883: --get the reference task and project ids
4884: SELECT proj_element_id, project_id
4885: INTO l_ref_task_id, l_ref_project_id
4886: FROM pa_proj_element_versions
4887: WHERE element_version_id = p_dest_task_version_id;
4888:
4889: --get the task and project ids
4890: SELECT proj_element_id, project_id

Line 4892: FROM pa_proj_element_versions

4888:
4889: --get the task and project ids
4890: SELECT proj_element_id, project_id
4891: INTO l_task_id, l_project_id
4892: FROM pa_proj_element_versions
4893: WHERE element_version_id = p_src_task_version_id;
4894:
4895: IF p_copy_option = 'PA_TASK_ONLY'
4896: THEN

Line 5387: l_parent_object_type PA_PROJ_ELEMENT_VERSIONS.object_type%TYPE;

5383: l_parent_struct_ver_id NUMBER;
5384:
5385: l_parent_id NUMBER;
5386: l_parent_task_id NUMBER;
5387: l_parent_object_type PA_PROJ_ELEMENT_VERSIONS.object_type%TYPE;
5388:
5389: l_project_id NUMBER;
5390: l_ref_task_id NUMBER;
5391: l_task_id NUMBER;

Line 5501: FROM pa_proj_element_versions

5497: l_cur_project_id NUMBER;
5498: CURSOR cur_proj_id
5499: IS
5500: SELECT project_id
5501: FROM pa_proj_element_versions
5502: WHERE element_version_id = p_structure_version_id;
5503:
5504: -- Merged from 85
5505: -- end hyau Bug 2852753

Line 5550: from pa_proj_element_versions

5546: and prior object_type_to = object_type_from
5547: and prior relationship_type = relationship_type
5548: UNION
5549: select element_version_id
5550: from pa_proj_element_versions
5551: where element_version_id = c_task_ver_id;
5552: l_child_ver_id NUMBER;
5553: --end bug 3911698
5554:

Line 5569: from pa_object_relationships a, pa_proj_element_versions b

5565: and prior object_type_from = object_type_to
5566: and prior relationship_type = relationship_type
5567: intersect
5568: select a.object_id_to1
5569: from pa_object_relationships a, pa_proj_element_versions b
5570: where a.relationshiP_type = 'S'
5571: and a.object_id_from1 = b.parent_structure_version_id
5572: and b.element_version_id = c_task_ver_id
5573: and a.object_type_from = 'PA_STRUCTURES';

Line 5742: FROM PA_PROJ_ELEMENT_VERSIONS

5738: (p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
5739:
5740: SELECT proj_element_id
5741: INTO l_proj_element_id
5742: FROM PA_PROJ_ELEMENT_VERSIONS
5743: WHERE element_version_id = p_task_version_id;
5744:
5745: IF ('Y' = pa_proj_elements_utils.CHECK_ELEMENT_HAS_PHASE(
5746: l_proj_element_id)) THEN

Line 5772: FROM PA_PROJ_ELEMENT_VERSIONS

5768:
5769: -- get the display sequence of the reference task
5770: SELECT display_sequence, parent_structure_version_id
5771: INTO l_ref_display_sequence, l_ref_parent_struct_ver_id
5772: FROM PA_PROJ_ELEMENT_VERSIONS
5773: WHERE element_version_id = p_ref_task_version_id;
5774:
5775: -- get the display sequence of the task being moved
5776: SELECT display_sequence, parent_structure_version_id

Line 5778: FROM PA_PROJ_ELEMENT_VERSIONS

5774:
5775: -- get the display sequence of the task being moved
5776: SELECT display_sequence, parent_structure_version_id
5777: INTO l_display_sequence, l_parent_struct_ver_id
5778: FROM PA_PROJ_ELEMENT_VERSIONS
5779: WHERE element_version_id = p_task_version_id;
5780:
5781: -- get the parent of the task being moved
5782: SELECT object_id_from1, object_type_from

Line 5966: FROM pa_proj_element_versions

5962: END IF;
5963:
5964:
5965: /* SELECT proj_element_id, project_id INTO l_structure_id, l_project_id
5966: FROM pa_proj_element_versions
5967: WHERE element_version_id = p_structure_version_id
5968: AND object_type = 'PA_STRUCTURES';*/
5969:
5970: IF p_called_from_bulk_api = 'N' -- 4269830

Line 5974: FROM pa_proj_element_versions

5970: IF p_called_from_bulk_api = 'N' -- 4269830
5971: THEN
5972:
5973: SELECT proj_element_id, project_id, element_version_id INTO l_structure_id, l_project_id, l_structure_ver_id
5974: FROM pa_proj_element_versions
5975: WHERE element_version_id = ( Select parent_structure_version_id
5976: from pa_proj_element_versions
5977: where element_version_id = p_task_version_id )
5978: AND object_type = 'PA_STRUCTURES';

Line 5976: from pa_proj_element_versions

5972:
5973: SELECT proj_element_id, project_id, element_version_id INTO l_structure_id, l_project_id, l_structure_ver_id
5974: FROM pa_proj_element_versions
5975: WHERE element_version_id = ( Select parent_structure_version_id
5976: from pa_proj_element_versions
5977: where element_version_id = p_task_version_id )
5978: AND object_type = 'PA_STRUCTURES';
5979: END IF; -- 4269830
5980:

Line 6033: PA_PROJ_ELEMENT_VERSIONS ppev

6029: SELECT ppev.proj_element_id, pt.record_version_number, ppa.wbs_record_version_number, ppev.project_id
6030: INTO l_task_id, l_task_record_version_number, l_wbs_record_version_number, l_project_id
6031: FROM PA_TASKS pt,
6032: pa_proj_elem_ver_structure ppa,
6033: PA_PROJ_ELEMENT_VERSIONS ppev
6034: WHERE ppev.element_version_id = p_task_version_id
6035: AND ppev.project_id = ppa.project_id
6036: AND ppev.parent_structure_version_id = ppa.element_version_id
6037: AND ppev.proj_element_id = pt.task_id;

Line 6041: FROM PA_PROJ_ELEMENT_VERSIONS

6037: AND ppev.proj_element_id = pt.task_id;
6038:
6039: SELECT proj_element_id
6040: INTO l_ref_task_id
6041: FROM PA_PROJ_ELEMENT_VERSIONS
6042: WHERE element_version_id = p_ref_task_version_id;
6043: -- merged from 85
6044: SELECT record_version_number, parent_task_id --get old parent id for bug 2947492 (move )
6045: ,top_task_id --bug 2967204

Line 6684: FROM PA_PROJ_ELEMENT_VERSIONS

6680: (p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
6681:
6682: SELECT proj_element_id, wbs_level, display_sequence, parent_structure_version_id
6683: INTO l_proj_element_id, l_wbs_level, l_display_sequence, l_parent_structure_version_id
6684: FROM PA_PROJ_ELEMENT_VERSIONS
6685: WHERE element_version_id = p_task_version_id;
6686:
6687: IF ('Y' = pa_proj_elements_utils.CHECK_ELEMENT_HAS_PHASE(
6688: l_proj_element_id)) THEN

Line 6717: FROM PA_PROJ_ELEMENT_VERSIONS

6713:
6714: /* Moved up for performance bug 2832807
6715: SELECT wbs_level, display_sequence, parent_structure_version_id
6716: INTO l_wbs_level, l_display_sequence, l_parent_structure_version_id
6717: FROM PA_PROJ_ELEMENT_VERSIONS
6718: WHERE element_version_id = p_task_version_id;
6719: */
6720:
6721: --dbms_output.put_line( 'Indent Task Stage 3 ' );

Line 6734: FROM PA_PROJ_ELEMENT_VERSIONS

6730:
6731: --need to specify parent structure version id
6732: SELECT wbs_level, element_version_id
6733: INTO l_prev_wbs_level, l_ref_task_version_id
6734: FROM PA_PROJ_ELEMENT_VERSIONS
6735: WHERE display_sequence = l_display_sequence - 1
6736: AND parent_structure_version_id = l_parent_structure_version_id;
6737:
6738: --dbms_output.put_line( 'Indent Task Stage 5 ' );

Line 6775: FROM PA_PROJ_ELEMENT_VERSIONS

6771: --need to specify which structure version
6772: --need to specify parent in the inner select statement
6773: SELECT element_version_id
6774: INTO l_ref_task_version_id
6775: FROM PA_PROJ_ELEMENT_VERSIONS
6776: WHERE wbs_level = l_wbs_level + 1
6777: AND object_type = 'PA_TASKS'
6778: AND display_sequence < l_display_sequence
6779: AND parent_structure_version_id = l_parent_structure_version_id

Line 6782: FROM PA_PROJ_ELEMENT_VERSIONS

6778: AND display_sequence < l_display_sequence
6779: AND parent_structure_version_id = l_parent_structure_version_id
6780: AND display_sequence =
6781: (SELECT max(display_sequence)
6782: FROM PA_PROJ_ELEMENT_VERSIONS
6783: WHERE wbs_level = l_wbs_level + 1
6784: AND object_type = 'PA_TASKS'
6785: AND display_sequence < l_display_sequence
6786: AND parent_structure_version_id = l_parent_structure_version_id);

Line 6875: FROM PA_PROJ_ELEMENT_VERSIONS

6871:
6872: -- Update WBS numbers
6873: SELECT parent_structure_version_id
6874: INTO l_parent_structure_version_id
6875: FROM PA_PROJ_ELEMENT_VERSIONS
6876: WHERE element_version_id = p_task_version_id;
6877:
6878: --dbms_output.put_line( 'Indent Task Stage 12 ' );
6879:

Line 6893: FROM pa_proj_element_versions

6889: ,x_return_status => l_return_status );
6890:
6891:
6892: SELECT proj_element_id, project_id INTO l_structure_id, l_project_id
6893: FROM pa_proj_element_versions
6894: WHERE element_version_id = ( Select parent_structure_version_id
6895: from pa_proj_element_versions
6896: where element_version_id = p_task_version_id )
6897: AND object_type = 'PA_STRUCTURES';

Line 6895: from pa_proj_element_versions

6891:
6892: SELECT proj_element_id, project_id INTO l_structure_id, l_project_id
6893: FROM pa_proj_element_versions
6894: WHERE element_version_id = ( Select parent_structure_version_id
6895: from pa_proj_element_versions
6896: where element_version_id = p_task_version_id )
6897: AND object_type = 'PA_STRUCTURES';
6898:
6899:

Line 6930: PA_PROJ_ELEMENT_VERSIONS ppev

6926: SELECT ppev.proj_element_id, pt.record_version_number, ppa.wbs_record_version_number, ppev.project_id
6927: INTO l_task_id, l_task_record_version_number, l_wbs_record_version_number, l_project_id
6928: FROM PA_TASKS pt,
6929: pa_proj_elem_ver_structure ppa,
6930: PA_PROJ_ELEMENT_VERSIONS ppev
6931: WHERE ppev.element_version_id = p_task_version_id
6932: AND ppev.parent_structure_version_id = ppa.element_version_id
6933: AND ppev.project_id = ppa.project_id
6934: AND ppev.proj_element_id = pt.task_id;

Line 6938: FROM PA_PROJ_ELEMENT_VERSIONS

6934: AND ppev.proj_element_id = pt.task_id;
6935:
6936: SELECT proj_element_id
6937: INTO l_ref_task_id
6938: FROM PA_PROJ_ELEMENT_VERSIONS
6939: WHERE element_version_id = l_ref_task_version_id;
6940:
6941: SELECT record_version_number INTO l_task_record_version_number
6942: FROM pa_tasks

Line 7254: FROM PA_PROJ_ELEMENT_VERSIONS

7250:
7251:
7252: SELECT wbs_level, display_sequence, parent_structure_version_id
7253: INTO l_wbs_level, l_display_sequence, l_parent_structure_version_id
7254: FROM PA_PROJ_ELEMENT_VERSIONS
7255: WHERE element_version_id = p_task_version_id;
7256:
7257: if l_wbs_level = 1 then
7258: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

Line 7281: FROM PA_PROJ_ELEMENT_VERSIONS

7277:
7278: --get the reference task version of p_task_version_id
7279: SELECT element_version_id
7280: INTO l_ref_task_version_id
7281: FROM PA_PROJ_ELEMENT_VERSIONS
7282: WHERE wbs_level = l_wbs_level - 1
7283: AND object_type = 'PA_TASKS'
7284: AND parent_structure_version_id = l_parent_structure_version_id
7285: AND display_sequence < l_display_sequence

Line 7288: FROM PA_PROJ_ELEMENT_VERSIONS

7284: AND parent_structure_version_id = l_parent_structure_version_id
7285: AND display_sequence < l_display_sequence
7286: AND display_sequence =
7287: (SELECT max(display_sequence)
7288: FROM PA_PROJ_ELEMENT_VERSIONS
7289: WHERE wbs_level = l_wbs_level - 1
7290: AND object_type = 'PA_TASKS'
7291: AND parent_structure_version_id = l_parent_structure_version_id
7292: AND display_sequence < l_display_sequence);

Line 7357: FROM PA_PROJ_ELEMENT_VERSIONS

7353:
7354: -- Update WBS numbers
7355: SELECT parent_structure_version_id
7356: INTO l_parent_structure_version_id
7357: FROM PA_PROJ_ELEMENT_VERSIONS
7358: WHERE element_version_id = p_task_version_id;
7359:
7360: PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS
7361: ( p_commit => p_commit

Line 7371: FROM pa_proj_element_versions

7367: ,p_parent_task_id => NULL
7368: ,x_return_status => l_return_status );
7369:
7370: /* SELECT proj_element_id, project_id INTO l_structure_id, l_project_id
7371: FROM pa_proj_element_versions
7372: WHERE element_version_id = p_structure_version_id
7373: AND object_type = 'PA_STRUCTURES';*/
7374:
7375: SELECT proj_element_id, project_id INTO l_structure_id, l_project_id

Line 7376: FROM pa_proj_element_versions

7372: WHERE element_version_id = p_structure_version_id
7373: AND object_type = 'PA_STRUCTURES';*/
7374:
7375: SELECT proj_element_id, project_id INTO l_structure_id, l_project_id
7376: FROM pa_proj_element_versions
7377: WHERE element_version_id = ( Select parent_structure_version_id
7378: from pa_proj_element_versions
7379: where element_version_id = p_task_version_id )
7380: AND object_type = 'PA_STRUCTURES';

Line 7378: from pa_proj_element_versions

7374:
7375: SELECT proj_element_id, project_id INTO l_structure_id, l_project_id
7376: FROM pa_proj_element_versions
7377: WHERE element_version_id = ( Select parent_structure_version_id
7378: from pa_proj_element_versions
7379: where element_version_id = p_task_version_id )
7380: AND object_type = 'PA_STRUCTURES';
7381:
7382: --Do financial task check

Line 7411: PA_PROJ_ELEMENT_VERSIONS ppev

7407: SELECT ppev.proj_element_id, pt.record_version_number, ppa.wbs_record_version_number, ppev.project_id
7408: INTO l_task_id, l_task_record_version_number, l_wbs_record_version_number, l_project_id
7409: FROM PA_TASKS pt,
7410: pa_proj_elem_ver_structure ppa,
7411: PA_PROJ_ELEMENT_VERSIONS ppev
7412: WHERE ppev.element_version_id = p_task_version_id
7413: AND ppev.parent_structure_version_id = ppa.element_version_id
7414: AND ppev.project_id = ppa.project_id
7415: AND ppev.proj_element_id = pt.task_id;

Line 7419: FROM PA_PROJ_ELEMENT_VERSIONS

7415: AND ppev.proj_element_id = pt.task_id;
7416:
7417: SELECT proj_element_id
7418: INTO l_ref_task_id
7419: FROM PA_PROJ_ELEMENT_VERSIONS
7420: WHERE element_version_id = l_ref_task_version_id;
7421:
7422: SELECT record_version_number INTO l_task_record_version_number
7423: FROM pa_tasks

Line 7654: FROM pa_proj_element_versions

7650:
7651: CURSOR cur_ref_proj_elem_id( p_ref_task_ver_id NUMBER )
7652: IS
7653: SELECT proj_element_id
7654: FROM pa_proj_element_versions
7655: WHERE element_version_id = p_ref_task_ver_id
7656: AND object_type = 'PA_TASKS';
7657:
7658: --Hsiu added for date rollup

Line 7673: l_task_unpub_ver_status_code PA_PROJ_ELEMENT_VERSIONS.TASK_UNPUB_VER_STATUS_CODE%TYPE;

7669: where project_id = c_project_id
7670: and template_flag = 'Y';
7671: l_template_flag VARCHAR2(1);
7672:
7673: l_task_unpub_ver_status_code PA_PROJ_ELEMENT_VERSIONS.TASK_UNPUB_VER_STATUS_CODE%TYPE;
7674:
7675: CURSOR get_parent_version_id(c_elem_ver_id NUMBER) IS
7676: select object_id_from1
7677: from pa_object_relationships

Line 7696: from pa_proj_element_versions

7692: --end bug 3053281
7693:
7694: CURSOR get_base_ref_obj_type IS
7695: select object_type
7696: from pa_proj_element_versions
7697: where element_version_id = p_ref_task_version_id;
7698: l_ref_obj_type VARCHAR2(30);
7699:
7700: -- Added for FP_M changes : Bug 3305199 : Bhumesh

Line 8459: pa_proj_element_versions ppev,

8455: IS
8456: SELECT sum(ppevs.duration)
8457: FROM pa_proj_elem_ver_schedule ppevs,
8458: pa_object_relationships por,
8459: pa_proj_element_versions ppev,
8460: pa_proj_elements ppe,
8461: pa_task_types ptt
8462: WHERE por.object_id_from1 = c_parent_element_version_id
8463: AND por.object_type_to = 'PA_TASKS'

Line 8494: pa_proj_element_versions ppev,

8490: CURSOR check_progress_allowed(c_element_version_id NUMBER)
8491: IS
8492: SELECT ptt.prog_entry_enable_flag, ppe.project_id /* for bug 2822963 */
8493: FROM pa_task_types ptt,
8494: pa_proj_element_versions ppev,
8495: pa_proj_elements ppe
8496: WHERE ppev.element_version_id = c_element_version_id
8497: AND ppev.proj_element_id = ppe.proj_element_id
8498: AND ptt.object_type = 'PA_TASKS' /* for bug 3279978 FP M Enhancement */

Line 8516: FROM PA_OBJECT_RELATIONSHIPS rel,pa_proj_element_versions ver,pa_proj_elements ele,pa_task_types tt

8512: -- on all the child tasks equally.
8513: CURSOR get_progressible_child_count(c_parent_element_version_id NUMBER)
8514: IS
8515: SELECT count(rel.object_id_to1)
8516: FROM PA_OBJECT_RELATIONSHIPS rel,pa_proj_element_versions ver,pa_proj_elements ele,pa_task_types tt
8517: WHERE rel.object_id_from1 = c_parent_element_version_id
8518: AND rel.object_type_to = 'PA_TASKS'
8519: AND rel.relationship_type = 'S'
8520: AND rel.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

Line 9156: , pa_proj_element_versions ppev,

9152:
9153: CURSOR check_progress_allowed(c_element_version_id NUMBER) IS
9154: SELECT ptt.prog_entry_enable_flag
9155: FROM pa_task_types ptt
9156: , pa_proj_element_versions ppev,
9157: pa_proj_elements ppe
9158: WHERE ppev.element_version_id = c_element_version_id
9159: AND ppev.proj_element_id = ppe.proj_element_id
9160: AND ptt.object_type = 'PA_TASKS' /* for bug 3279978 FP M Enhancement */

Line 9248: from pa_proj_element_versions

9244: --end bug 2843737
9245:
9246: CURSOR get_wbs_number(c_elem_ver_id NUMBER) is
9247: select wbs_number
9248: from pa_proj_element_versions
9249: where element_version_id = c_elem_ver_id
9250: and object_type ='PA_TASKS';
9251:
9252: -- hyau Bug 2852753

Line 9285: FROM pa_proj_element_versions

9281: l_cur_project_id NUMBER;
9282: CURSOR cur_proj_id
9283: IS
9284: SELECT project_id
9285: FROM pa_proj_element_versions
9286: WHERE element_version_id = p_structure_version_id;
9287:
9288: -- end hyau Bug 2852753
9289:

Line 9334: from pa_object_relationships a, pa_proj_element_versions b

9330: and prior object_type_from = object_type_to
9331: and prior relationship_type = relationship_type
9332: intersect
9333: select a.object_id_to1
9334: from pa_object_relationships a, pa_proj_element_versions b
9335: where a.relationshiP_type = 'S'
9336: and a.object_id_from1 = b.parent_structure_version_id
9337: and b.element_version_id = c_task_ver_id
9338: and a.object_type_from = 'PA_STRUCTURES';

Line 9357: FROM PA_PROJ_ELEMENT_VERSIONS

9353: l_ref_tsk_version_id NUMBER;
9354:
9355: CURSOR cur_get_ref_tsk_ver_id(c_src_wbs_level NUMBER) IS
9356: SELECT element_version_id
9357: FROM PA_PROJ_ELEMENT_VERSIONS
9358: WHERE parent_structure_version_id = p_structure_version_id
9359: AND project_id = p_project_id
9360: AND wbs_level = c_src_wbs_level
9361: AND object_type = 'PA_TASKS'

Line 9365: FROM pa_proj_element_versions

9361: AND object_type = 'PA_TASKS'
9362: AND display_sequence < src_seq_number
9363: AND display_sequence =
9364: (SELECT max (display_sequence)
9365: FROM pa_proj_element_versions
9366: WHERE project_id = p_project_id
9367: AND parent_structure_version_id = p_structure_version_id
9368: AND wbs_level = c_src_wbs_level
9369: AND display_sequence < src_seq_number

Line 9463: FROM PA_PROJ_ELEMENT_VERSIONS

9459: -- Get Source Task Information
9460: BEGIN
9461: SELECT element_version_id, proj_element_id, wbs_number, wbs_level, display_sequence, parent_structure_version_id, object_type
9462: INTO src_elem_ver_id, src_proj_element_id, src_wbs_number, src_wbs_level, src_seq_number, src_parent_str_ver_id, src_object_type
9463: FROM PA_PROJ_ELEMENT_VERSIONS
9464: WHERE element_version_id = p_task_version_id
9465: AND project_id = p_project_id
9466: AND parent_structure_version_id = p_structure_version_id;
9467: EXCEPTION

Line 9501: FROM PA_PROJ_ELEMENT_VERSIONS

9497: -- Otherwise we will again fetch the correct reference task
9498:
9499: SELECT element_version_id, proj_element_id, wbs_number, wbs_level, display_sequence, parent_structure_version_id, object_type
9500: INTO ref_elem_ver_id, ref_proj_element_id, ref_wbs_number, ref_wbs_level, ref_seq_number, ref_parent_str_ver_id, ref_object_type
9501: FROM PA_PROJ_ELEMENT_VERSIONS
9502: WHERE display_sequence = src_seq_number - 1
9503: AND parent_structure_version_id = p_structure_version_id
9504: AND project_id = p_project_id
9505: AND object_type = 'PA_TASKS';

Line 9523: FROM PA_PROJ_ELEMENT_VERSIONS

9519: l_peer_or_sub := 'PEER';
9520:
9521: SELECT element_version_id, proj_element_id, wbs_number, wbs_level, display_sequence, parent_structure_version_id, object_type
9522: INTO ref_elem_ver_id, ref_proj_element_id, ref_wbs_number, ref_wbs_level, ref_seq_number, ref_parent_str_ver_id, ref_object_type
9523: FROM PA_PROJ_ELEMENT_VERSIONS
9524: WHERE parent_structure_version_id = p_structure_version_id
9525: AND project_id = p_project_id
9526: AND wbs_level = src_wbs_level+1
9527: AND object_type = 'PA_TASKS'

Line 9531: FROM pa_proj_element_versions

9527: AND object_type = 'PA_TASKS'
9528: AND display_sequence < src_seq_number
9529: AND display_sequence =
9530: (SELECT max (display_sequence)
9531: FROM pa_proj_element_versions
9532: WHERE project_id = p_project_id
9533: AND parent_structure_version_id = p_structure_version_id
9534: AND wbs_level = src_wbs_level+1
9535: AND display_sequence < src_seq_number

Line 9554: FROM PA_PROJ_ELEMENT_VERSIONS

9550:
9551: BEGIN
9552: SELECT element_version_id, proj_element_id, wbs_number, wbs_level, display_sequence, parent_structure_version_id, object_type
9553: INTO ref_elem_ver_id, ref_proj_element_id, ref_wbs_number, ref_wbs_level, ref_seq_number, ref_parent_str_ver_id, ref_object_type
9554: FROM PA_PROJ_ELEMENT_VERSIONS
9555: WHERE parent_structure_version_id = p_structure_version_id
9556: AND project_id = p_project_id
9557: AND (wbs_level = src_wbs_level OR wbs_level = src_wbs_level+1) -- Sub or Peer
9558: AND object_type = 'PA_TASKS'

Line 9562: FROM pa_proj_element_versions

9558: AND object_type = 'PA_TASKS'
9559: AND display_sequence < src_seq_number
9560: AND display_sequence =
9561: (SELECT max (display_sequence)
9562: FROM pa_proj_element_versions
9563: WHERE project_id = p_project_id
9564: AND parent_structure_version_id = p_structure_version_id
9565: AND (wbs_level = src_wbs_level OR wbs_level = src_wbs_level+1) -- Sub or Peer
9566: AND display_sequence < src_seq_number

Line 9774: pa_proj_element_versions

9770: l_display_sequence_tab, l_wbs_level_tab,
9771: l_wbs_number_tab, l_record_version_tab,
9772: l_changed_flag_tab
9773: FROM
9774: pa_proj_element_versions
9775: WHERE
9776: project_id = p_project_id
9777: AND parent_structure_version_id = p_structure_version_id
9778: AND object_type = 'PA_TASKS'

Line 9910: UPDATE PA_PROJ_ELEMENT_VERSIONS

9906:
9907: -- Locking should be implemnted here
9908:
9909: FORALL j IN l_element_version_id_tab.FIRST..l_element_version_id_tab.LAST
9910: UPDATE PA_PROJ_ELEMENT_VERSIONS
9911: SET
9912: wbs_level = l_wbs_level_tab(j) ,
9913: wbs_number = l_wbs_number_tab(j) ,
9914: last_update_date = sysdate ,

Line 10084: FROM pa_proj_element_versions

10080:
10081: /*** End Update_task_version and Update_wbs_number code ***/
10082:
10083: SELECT proj_element_id, project_id INTO l_structure_id, l_project_id
10084: FROM pa_proj_element_versions
10085: WHERE element_version_id = ( Select parent_structure_version_id
10086: from pa_proj_element_versions
10087: where element_version_id = p_task_version_id )
10088: AND object_type = 'PA_STRUCTURES';

Line 10086: from pa_proj_element_versions

10082:
10083: SELECT proj_element_id, project_id INTO l_structure_id, l_project_id
10084: FROM pa_proj_element_versions
10085: WHERE element_version_id = ( Select parent_structure_version_id
10086: from pa_proj_element_versions
10087: where element_version_id = p_task_version_id )
10088: AND object_type = 'PA_STRUCTURES';
10089:
10090:

Line 10120: PA_PROJ_ELEMENT_VERSIONS ppev

10116: SELECT ppev.proj_element_id, pt.record_version_number, ppa.wbs_record_version_number, ppev.project_id
10117: INTO l_task_id, l_task_record_version_number, l_wbs_record_version_number, l_project_id
10118: FROM PA_TASKS pt,
10119: pa_proj_elem_ver_structure ppa,
10120: PA_PROJ_ELEMENT_VERSIONS ppev
10121: WHERE ppev.element_version_id = p_task_version_id
10122: AND ppev.parent_structure_version_id = ppa.element_version_id
10123: AND ppev.project_id = ppa.project_id
10124: AND ppev.proj_element_id = pt.task_id;

Line 10624: , pa_proj_element_versions ppev,

10620:
10621: CURSOR check_progress_allowed(c_element_version_id NUMBER) IS
10622: SELECT ptt.prog_entry_enable_flag
10623: FROM pa_task_types ptt
10624: , pa_proj_element_versions ppev,
10625: pa_proj_elements ppe
10626: WHERE ppev.element_version_id = c_element_version_id
10627: AND ppev.proj_element_id = ppe.proj_element_id
10628: AND ppe.TYPE_ID = ptt.task_type_id;

Line 10650: pa_proj_element_versions ppev

10646: -- This case should not be possible for Outdent/Indent
10647: CURSOR cur_new_child(c_ref_task_version_id NUMBER, c_display_sequence NUMBER) IS
10648: SELECT por.object_id_to1, ppev.display_sequence, por.record_version_number, por.object_relationship_id
10649: FROM pa_object_relationships por,
10650: pa_proj_element_versions ppev
10651: WHERE object_id_from1 = c_ref_task_version_id
10652: AND object_id_to1 = element_version_id
10653: AND display_sequence > c_display_sequence
10654: AND relationship_type = 'S'

Line 10750: from pa_proj_element_versions

10746: --end bug 2843737
10747:
10748: CURSOR get_wbs_number(c_elem_ver_id NUMBER) is
10749: select wbs_number
10750: from pa_proj_element_versions
10751: where element_version_id = c_elem_ver_id
10752: and object_type ='PA_TASKS';
10753:
10754: ref_parent_branch_mask VARCHAR2(1000);

Line 10789: FROM pa_proj_element_versions

10785: l_cur_project_id NUMBER;
10786: CURSOR cur_proj_id
10787: IS
10788: SELECT project_id
10789: FROM pa_proj_element_versions
10790: WHERE element_version_id = p_structure_version_id;
10791:
10792: -- end hyau Bug 2852753
10793:

Line 10816: FROM pa_tasks pt, pa_proj_element_versions ppev

10812: CURSOR cur_new_child_task( c_project_id NUMBER, c_wbs_level NUMBER,
10813: c_task_id NUMBER , c_parent_task_id NUMBER )
10814: IS
10815: SELECT pt.task_id, pt.top_task_id, pt.parent_task_id
10816: FROM pa_tasks pt, pa_proj_element_versions ppev
10817: WHERE pt.wbs_level = c_wbs_level
10818: AND parent_task_id = c_parent_task_id
10819: AND pt.project_id = c_project_id
10820: AND pt.task_id = ppev.proj_element_id

Line 10821: AND ppev.display_sequence > ( SELECT display_sequence FROM pa_proj_element_versions

10817: WHERE pt.wbs_level = c_wbs_level
10818: AND parent_task_id = c_parent_task_id
10819: AND pt.project_id = c_project_id
10820: AND pt.task_id = ppev.proj_element_id
10821: AND ppev.display_sequence > ( SELECT display_sequence FROM pa_proj_element_versions
10822: WHERE project_id = c_project_id
10823: AND object_type = 'PA_TASKS'
10824: AND proj_element_id = c_task_id );
10825:

Line 10861: from pa_object_relationships a, pa_proj_element_versions b

10857: and prior object_type_from = object_type_to
10858: and prior relationship_type = relationship_type
10859: intersect
10860: select a.object_id_to1
10861: from pa_object_relationships a, pa_proj_element_versions b
10862: where a.relationshiP_type = 'S'
10863: and a.object_id_from1 = b.parent_structure_version_id
10864: and b.element_version_id = c_task_ver_id
10865: and a.object_type_from = 'PA_STRUCTURES';

Line 10984: FROM PA_PROJ_ELEMENT_VERSIONS

10980: -- Get Source Task Information
10981: BEGIN
10982: SELECT element_version_id, proj_element_id, wbs_number, wbs_level, display_sequence, parent_structure_version_id, object_type
10983: INTO src_elem_ver_id, src_proj_element_id, src_wbs_number, src_wbs_level, src_seq_number, src_parent_str_ver_id, src_object_type
10984: FROM PA_PROJ_ELEMENT_VERSIONS
10985: WHERE element_version_id = p_task_version_id
10986: AND project_id = p_project_id
10987: AND parent_structure_version_id = p_structure_version_id;
10988: EXCEPTION

Line 11007: FROM PA_PROJ_ELEMENT_VERSIONS

11003:
11004: BEGIN
11005: SELECT element_version_id, proj_element_id, wbs_number, wbs_level, display_sequence, parent_structure_version_id, object_type
11006: INTO ref_elem_ver_id, ref_proj_element_id, ref_wbs_number, ref_wbs_level, ref_seq_number, ref_parent_str_ver_id, ref_object_type
11007: FROM PA_PROJ_ELEMENT_VERSIONS
11008: WHERE parent_structure_version_id = p_structure_version_id
11009: AND project_id = p_project_id
11010: AND (wbs_level = src_wbs_level-1)
11011: AND object_type = 'PA_TASKS'

Line 11014: FROM pa_proj_element_versions

11010: AND (wbs_level = src_wbs_level-1)
11011: AND object_type = 'PA_TASKS'
11012: AND display_sequence =
11013: (SELECT max (display_sequence)
11014: FROM pa_proj_element_versions
11015: WHERE project_id = p_project_id
11016: AND parent_structure_version_id = p_structure_version_id
11017: AND (wbs_level = src_wbs_level-1)
11018: AND display_sequence < src_seq_number

Line 11199: pa_proj_element_versions

11195: l_display_sequence_tab, l_wbs_level_tab,
11196: l_wbs_number_tab, l_record_version_tab,
11197: l_changed_flag_tab
11198: FROM
11199: pa_proj_element_versions
11200: WHERE
11201: project_id = p_project_id
11202: AND parent_structure_version_id = p_structure_version_id
11203: AND object_type = 'PA_TASKS'

Line 11414: UPDATE PA_PROJ_ELEMENT_VERSIONS

11410:
11411: -- Locking should be implemented here
11412:
11413: FORALL j IN l_element_version_id_tab.FIRST..l_element_version_id_tab.LAST
11414: UPDATE PA_PROJ_ELEMENT_VERSIONS
11415: SET
11416: wbs_level = l_wbs_level_tab(j) ,
11417: wbs_number = l_wbs_number_tab(j) ,
11418: last_update_date = sysdate ,

Line 11664: FROM pa_proj_element_versions

11660:
11661: /*** End Update_task_version and Update_wbs_number code ***/
11662:
11663: SELECT proj_element_id, project_id INTO l_structure_id, l_project_id
11664: FROM pa_proj_element_versions
11665: WHERE element_version_id = ( Select parent_structure_version_id
11666: from pa_proj_element_versions
11667: where element_version_id = p_task_version_id )
11668: AND object_type = 'PA_STRUCTURES';

Line 11666: from pa_proj_element_versions

11662:
11663: SELECT proj_element_id, project_id INTO l_structure_id, l_project_id
11664: FROM pa_proj_element_versions
11665: WHERE element_version_id = ( Select parent_structure_version_id
11666: from pa_proj_element_versions
11667: where element_version_id = p_task_version_id )
11668: AND object_type = 'PA_STRUCTURES';
11669:
11670:

Line 11701: PA_PROJ_ELEMENT_VERSIONS ppev

11697: SELECT ppev.proj_element_id, pt.record_version_number, ppa.wbs_record_version_number, ppev.project_id
11698: INTO l_task_id, l_task_record_version_number, l_wbs_record_version_number, l_project_id
11699: FROM PA_TASKS pt,
11700: pa_proj_elem_ver_structure ppa,
11701: PA_PROJ_ELEMENT_VERSIONS ppev
11702: WHERE ppev.element_version_id = p_task_version_id
11703: AND ppev.parent_structure_version_id = ppa.element_version_id
11704: AND ppev.project_id = ppa.project_id
11705: AND ppev.proj_element_id = pt.task_id;

Line 12292: ,pa_proj_element_versions v

12288: ,e.name
12289: INTO l_element_number
12290: ,l_element_name
12291: FROM pa_proj_elements e
12292: ,pa_proj_element_versions v
12293: WHERE v.element_version_id = p_task_version_id_tbl(i)
12294: AND e.proj_element_id = v.proj_element_id ;
12295:
12296: PA_INTERFACE_UTILS_PUB.get_messages

Line 13349: FROM pa_proj_element_versions

13345:
13346: CURSOR c_proj_element_id
13347: IS
13348: SELECT proj_element_id
13349: FROM pa_proj_element_versions
13350: WHERE project_id = p_project_id
13351: and parent_structure_version_id = p_structure_version_id
13352: and element_version_id = p_task_ver_id
13353: and object_type = decode(p_object_type, 'PA_ASSIGNMENTS','PA_TASKS', p_object_type); -- Bug 3856161 : Added Decode

Line 13376: from pa_task_types ptt, pa_proj_elements ppe, pa_proj_element_versions ppev

13372: -- Start modifications for Bug # 3879658.
13373:
13374: cursor cur_progress_status is
13375: select ptt.initial_progress_status_code
13376: from pa_task_types ptt, pa_proj_elements ppe, pa_proj_element_versions ppev
13377: where ppev.project_id = ppe.project_id
13378: and ppev.proj_element_id = ppe.proj_element_id
13379: and ppe.type_id = ptt.task_type_id
13380: and ppe.project_id = p_project_id

Line 13534: from pa_proj_element_versions

13530: -- Get the task_id.
13531:
13532: select proj_element_id
13533: into l_task_id
13534: from pa_proj_element_versions
13535: where element_version_id = p_task_ver_id
13536: and parent_structure_version_id = p_structure_version_id;
13537:
13538: IF l_debug_mode = 'Y' THEN

Line 14679: l_task_unpub_ver_status_code PA_PROJ_ELEMENT_VERSIONS.TASK_UNPUB_VER_STATUS_CODE%TYPE;

14675: l_src_structure_id NUMBER;
14676: l_src_structure_version_id NUMBER;
14677:
14678: l_dest_project_id NUMBER ;
14679: l_task_unpub_ver_status_code PA_PROJ_ELEMENT_VERSIONS.TASK_UNPUB_VER_STATUS_CODE%TYPE;
14680: l_dest_structure_id NUMBER;
14681: l_template_flag VARCHAR2(1);
14682: l_fin_task_flag VARCHAR2(1);
14683:

Line 14720: FROM pa_proj_element_versions

14716:
14717: CURSOR cur_dest_proj_id
14718: IS
14719: SELECT project_id
14720: FROM pa_proj_element_versions
14721: WHERE element_version_id = p_dest_task_version_id;
14722:
14723: CURSOR cur_struc_id( x_structure_version_id NUMBER, x_project_id NUMBER )
14724: IS

Line 15169: FROM pa_proj_element_versions

15165: l_cur_project_id NUMBER;
15166: CURSOR cur_proj_id
15167: IS
15168: SELECT project_id
15169: FROM pa_proj_element_versions
15170: WHERE element_version_id = p_structure_version_id;
15171:
15172: CURSOR get_product_code ( c_project_id NUMBER ) IS
15173: SELECT pm_product_code

Line 15310: FROM pa_proj_element_versions

15306: IF nvl(p_task_version_id_tbl.LAST,0)>0 THEN
15307: l_task_version_id := p_task_version_id_tbl(1);
15308:
15309: SELECT proj_element_id INTO l_structure_id
15310: FROM pa_proj_element_versions
15311: WHERE element_version_id = ( Select parent_structure_version_id
15312: from pa_proj_element_versions
15313: where element_version_id = l_task_version_id )
15314: AND object_type = 'PA_STRUCTURES';

Line 15312: from pa_proj_element_versions

15308:
15309: SELECT proj_element_id INTO l_structure_id
15310: FROM pa_proj_element_versions
15311: WHERE element_version_id = ( Select parent_structure_version_id
15312: from pa_proj_element_versions
15313: where element_version_id = l_task_version_id )
15314: AND object_type = 'PA_STRUCTURES';
15315: -----------------------------------------------------------
15316: OPEN cur_struc_type( l_structure_id );

Line 15722: FROM pa_proj_element_versions ver

15718:
15719: -- 4533534 : Included join of pa_proj_elem_ver_structure too
15720: CURSOR c_get_all_task_versions(c_task_id NUMBER, c_project_id NUMBER) IS
15721: SELECT ver.element_version_id, str.status_code
15722: FROM pa_proj_element_versions ver
15723: , pa_proj_elem_ver_structure str
15724: WHERE ver.project_id = c_project_id
15725: AND ver.proj_element_id = c_task_id
15726: AND ver.project_id = str.project_id

Line 15745: pa_proj_element_versions ppv1 -- linking task

15741: ,por1.object_relationship_id object_relationship_id
15742: ,por1.record_version_number record_version_number
15743: ,ppv1.task_unpub_ver_status_code task_unpub_ver_status_code
15744: FROM
15745: pa_proj_element_versions ppv1 -- linking task
15746: ,pa_proj_element_versions ppv2 -- linked project
15747: ,pa_object_relationships por1
15748: ,pa_object_relationships por2
15749: ,(SELECT object_id_from1, object_id_to1

Line 15746: ,pa_proj_element_versions ppv2 -- linked project

15742: ,por1.record_version_number record_version_number
15743: ,ppv1.task_unpub_ver_status_code task_unpub_ver_status_code
15744: FROM
15745: pa_proj_element_versions ppv1 -- linking task
15746: ,pa_proj_element_versions ppv2 -- linked project
15747: ,pa_object_relationships por1
15748: ,pa_object_relationships por2
15749: ,(SELECT object_id_from1, object_id_to1
15750: FROM pa_object_relationships

Line 15778: pa_proj_element_versions ppv -- linked project

15774: ,por.object_relationship_id object_relationship_id
15775: ,por.record_version_number record_version_number
15776: ,por.relationship_type relationship_type
15777: FROM
15778: pa_proj_element_versions ppv -- linked project
15779: ,pa_object_relationships por
15780: ,(SELECT object_id_from1, object_id_to1 -- Get all sub tasks including linking tasks
15781: FROM pa_object_relationships
15782: START WITH object_id_from1 = c_task_version_id

Line 16014: from pa_proj_elements ppe, pa_proj_element_versions ppev

16010: l_task_error_tbl l_task_error_tbl_type;
16011:
16012: cursor l_cur_task_attr(c_project_id NUMBER, c_element_version_id NUMBER) is
16013: select ppe.name, ppev.wbs_number --Bug 6878138
16014: from pa_proj_elements ppe, pa_proj_element_versions ppev
16015: where ppe.project_id = ppev.project_id
16016: and ppe.proj_element_id = ppev.proj_element_id
16017: and ppev.project_id = c_project_id
16018: and ppev.element_version_id = c_element_version_id;

Line 16246: from pa_proj_elements ppe, pa_proj_element_versions ppev

16242: l_task_error_tbl l_task_error_tbl_type;
16243:
16244: cursor l_cur_task_attr(c_project_id NUMBER, c_element_version_id NUMBER) is
16245: select ppe.name, ppev.wbs_number --Bug 6878138
16246: from pa_proj_elements ppe, pa_proj_element_versions ppev
16247: where ppe.project_id = ppev.project_id
16248: and ppe.proj_element_id = ppev.proj_element_id
16249: and ppev.project_id = c_project_id
16250: and ppev.element_version_id = c_element_version_id;