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.

[Home] [Help]

APPS.PA_TASK_PUB1 dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 1869: from PA_PROJ_ELEMENT_VERSIONS

1865: --Lock row
1866: IF( p_validate_only <> FND_API.G_TRUE) THEN
1867: BEGIN
1868: select 'x' into l_dummy
1869: from PA_PROJ_ELEMENT_VERSIONS
1870: where element_version_id = p_task_version_id
1871: and record_version_number = p_record_version_number
1872: for update of record_version_number NOWAIT;
1873: EXCEPTION

Line 1895: from PA_PROJ_ELEMENT_VERSIONS

1891: ELSE
1892: --check record_version_number
1893: BEGIN
1894: select 'x' into l_dummy
1895: from PA_PROJ_ELEMENT_VERSIONS
1896: where element_version_id = p_task_version_id
1897: and record_version_number = p_record_version_number;
1898: EXCEPTION
1899: WHEN NO_DATA_FOUND THEN

Line 2099: FROM pa_proj_element_versions

2095: l_project_id NUMBER;
2096: CURSOR cur_proj_id
2097: IS
2098: SELECT project_id
2099: FROM pa_proj_element_versions
2100: WHERE element_version_id = p_task_version_id;
2101:
2102: -- end hyau Bug 2852753
2103:

Line 2109: from pa_proj_element_versions a,

2105: --hsiu: added for task version status
2106: CURSOR get_task_info(c_task_version_id NUMBER) IS
2107: select a.project_id, b.proj_element_id, parent_structure_version_id,
2108: TASK_UNPUB_VER_STATUS_CODE, b.link_task_flag
2109: from pa_proj_element_versions a,
2110: pa_proj_elements b --bug 4501280
2111: where element_version_id = c_task_version_id
2112: --bug 4501280
2113: AND a.proj_element_id = b.proj_element_id

Line 2120: l_structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE ;

2116: ;
2117: l_task_info_rec get_task_info%ROWTYPE;
2118: --end changes for task version status
2119:
2120: l_structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE ;
2121:
2122: -- Bug Fix 4576640
2123: -- Adding a new check to stop users from deleting a linked task.
2124: -- Example:

Line 2204: from PA_PROJ_ELEMENT_VERSIONS

2200: --Lock row
2201: IF( p_validate_only <> FND_API.G_TRUE) THEN
2202: BEGIN
2203: select 'x' into l_dummy
2204: from PA_PROJ_ELEMENT_VERSIONS
2205: where element_version_id = p_task_version_id
2206: and record_version_number = p_record_version_number
2207: for update of record_version_number NOWAIT;
2208: EXCEPTION

Line 2233: from PA_PROJ_ELEMENT_VERSIONS

2229: ELSE
2230: --check record_version_number
2231: BEGIN
2232: select 'x' into l_dummy
2233: from PA_PROJ_ELEMENT_VERSIONS
2234: where element_version_id = p_task_version_id
2235: and record_version_number = p_record_version_number;
2236: EXCEPTION
2237: WHEN NO_DATA_FOUND THEN

Line 3017: From PA_Proj_Element_Versions a, pa_proj_elem_ver_schedule b

3013: If PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(l_Project_ID) = 'Y' Then
3014:
3015: Select a.Parent_Structure_Version_ID
3016: Into l_Structure_Version_ID
3017: From PA_Proj_Element_Versions a, pa_proj_elem_ver_schedule b
3018: Where a.Element_Version_ID = b.Element_Version_ID
3019: and b.pev_schedule_id = p_pev_schedule_id;
3020:
3021: PA_PROJECT_STRUCTURE_PVT1.update_sch_dirty_flag(

Line 3423: FROM pa_proj_element_versions

3419: /* not required
3420: CURSOR cur_dest_proj_element_id(c_dest_task_version_id NUMBER,c_project_id NUMBER)
3421: IS
3422: SELECT proj_element_id
3423: FROM pa_proj_element_versions
3424: WHERE element_version_id = c_dest_task_version_id and project_id=c_project_id;
3425: */
3426: -- End of 14209636
3427:

Line 3477: FROM pa_proj_element_versions b,

3473: b.attribute13,
3474: b.attribute14,
3475: b.attribute15,
3476: Financial_Task_Flag -- FP_M changes 3305199 Bhumesh
3477: FROM pa_proj_element_versions b,
3478: pa_proj_elements c
3479: WHERE b.proj_element_id = c.proj_element_id
3480: AND c.link_task_flag = 'N'
3481: AND p_copy_option IN ( 'PA_TASK_SUBTASK', 'PA_ENTIRE_VERSION' )

Line 3515: FROM pa_proj_element_versions ppev

3511: attribute13,
3512: attribute14,
3513: attribute15,
3514: Financial_Task_Flag -- FP_M changes 3305199 Bhumesh
3515: FROM pa_proj_element_versions ppev
3516: WHERE ppev.element_version_id = p_src_task_version_id
3517: /* not required any more
3518: -- Added for FP_M changes : Bug 3305199
3519: and ( p_structure_type = 'WORKPLAN' OR

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

3596: START WITH OBJECT_ID_TO1 = x_child_task_id
3597: --hsiu: bug 2669388
3598: -- START WITH object_id_from1 = x_child_task_id
3599: --traverse reverse
3600: CONNECT BY object_id_to1 = PRIOR object_id_from1 AND relationship_type = 'S' ) a, pa_proj_element_versions b
3601: WHERE a.object_id_from1 = b.element_version_id
3602: AND b.wbs_level = x_wbs_level;
3603: */
3604:

Line 3608: FROM pa_proj_element_versions b

3604:
3605: CURSOR cur_rev_parent_task( x_child_task_id NUMBER, x_wbs_level NUMBER )
3606: IS
3607: SELECT b.element_version_id parent_task_id
3608: FROM pa_proj_element_versions b
3609: WHERE b.wbs_level = x_wbs_level
3610: AND b.element_version_id IN ( SELECT object_id_from1
3611: FROM pa_object_relationships
3612: WHERE relationship_type = 'S'

Line 3673: FROM pa_proj_element_versions

3669:
3670: CURSOR cur_dest_proj_id
3671: IS
3672: SELECT project_id
3673: FROM pa_proj_element_versions
3674: WHERE element_version_id = p_dest_task_version_id;
3675:
3676: /* Added the Cursor For Bug #3573143*/
3677: CURSOR cur_task_id (c_element_version_id IN NUMBER, c_project_id IN NUMBER) IS

Line 3679: FROM pa_proj_element_versions

3675:
3676: /* Added the Cursor For Bug #3573143*/
3677: CURSOR cur_task_id (c_element_version_id IN NUMBER, c_project_id IN NUMBER) IS
3678: SELECT proj_element_id
3679: FROM pa_proj_element_versions
3680: where element_version_id = c_element_version_id
3681: AND project_id = c_project_id;
3682: l_cur_task_id cur_task_id%ROWTYPE;
3683: /* Ended Bug 3573143*/

Line 3742: l_task_unpub_ver_status_code PA_PROJ_ELEMENT_VERSIONS.TASK_UNPUB_VER_STATUS_CODE%TYPE;

3738: where project_id = c_project_id
3739: and template_flag = 'Y';
3740: l_template_flag VARCHAR2(1);
3741:
3742: l_task_unpub_ver_status_code PA_PROJ_ELEMENT_VERSIONS.TASK_UNPUB_VER_STATUS_CODE%TYPE;
3743: --end hsiu changes
3744:
3745: -- xxlu added for DFF attributes for calling create_schedule_version
3746: CURSOR cur_proj_elem_ver_sch(c_element_version_id NUMBER, c_project_id NUMBER) IS

Line 3767: from pa_proj_element_versions

3763:
3764: --hsiu added for bug 2669388
3765: CURSOR get_ref_tk_wbs(c_element_version_id NUMBER) IS
3766: select WBS_LEVEL
3767: from pa_proj_element_versions
3768: where element_version_id = c_element_version_id;
3769:
3770: -- bug#16083858
3771: CURSOR check_cost_code_enabled(c_project_id NUMBER) IS

Line 4662: FROM pa_proj_element_versions

4658: IF is_top_task = 'x' THEN
4659: IF l_peer_or_sub = 'PEER' THEN
4660: SELECT proj_element_id
4661: INTO l_ref_task_id
4662: FROM pa_proj_element_versions
4663: WHERE element_version_id = l_ref_task_version_id;
4664: ELSE
4665: l_ref_task_id := null;
4666: END IF;

Line 4673: FROM pa_proj_element_versions

4669: l_ref_task_id := NULL;
4670: ELSE
4671: SELECT proj_element_id
4672: INTO l_ref_task_id
4673: FROM pa_proj_element_versions
4674: WHERE element_version_id = l_ref_task_version_id;
4675: END IF;
4676: END IF;
4677:

Line 4682: FROM pa_proj_element_versions

4678: -- 3905123 end
4679: ELSE
4680: SELECT proj_element_id
4681: INTO l_ref_task_id
4682: FROM pa_proj_element_versions
4683: WHERE element_version_id = l_ref_task_version_id;
4684: --commented for bug 2846700
4685: --WHERE element_version_id = p_dest_task_version_id;
4686: END IF;

Line 5130: FROM pa_proj_element_versions

5126:
5127: /* Bug 2623999 coomnted out the code below. It is redundant and causing issues */
5128: /*
5129: SELECT proj_element_id, project_id INTO l_structure_id, l_project_id
5130: FROM pa_proj_element_versions
5131: WHERE element_version_id = p_dest_structure_version_id
5132: AND object_type = 'PA_STRUCTURES';
5133:
5134: --Do financial task check

Line 5161: FROM pa_proj_element_versions

5157:
5158: --get the reference task and project ids
5159: SELECT proj_element_id, project_id
5160: INTO l_ref_task_id, l_ref_project_id
5161: FROM pa_proj_element_versions
5162: WHERE element_version_id = p_dest_task_version_id;
5163:
5164: --get the task and project ids
5165: SELECT proj_element_id, project_id

Line 5167: FROM pa_proj_element_versions

5163:
5164: --get the task and project ids
5165: SELECT proj_element_id, project_id
5166: INTO l_task_id, l_project_id
5167: FROM pa_proj_element_versions
5168: WHERE element_version_id = p_src_task_version_id;
5169:
5170: IF p_copy_option = 'PA_TASK_ONLY'
5171: THEN

Line 5662: l_parent_object_type PA_PROJ_ELEMENT_VERSIONS.object_type%TYPE;

5658: l_parent_struct_ver_id NUMBER;
5659:
5660: l_parent_id NUMBER;
5661: l_parent_task_id NUMBER;
5662: l_parent_object_type PA_PROJ_ELEMENT_VERSIONS.object_type%TYPE;
5663:
5664: l_project_id NUMBER;
5665: l_ref_task_id NUMBER;
5666: l_task_id NUMBER;

Line 5776: FROM pa_proj_element_versions

5772: l_cur_project_id NUMBER;
5773: CURSOR cur_proj_id
5774: IS
5775: SELECT project_id
5776: FROM pa_proj_element_versions
5777: WHERE element_version_id = p_structure_version_id;
5778:
5779: -- Merged from 85
5780: -- end hyau Bug 2852753

Line 5825: from pa_proj_element_versions

5821: and prior object_type_to = object_type_from
5822: and prior relationship_type = relationship_type
5823: UNION
5824: select element_version_id
5825: from pa_proj_element_versions
5826: where element_version_id = c_task_ver_id;
5827: l_child_ver_id NUMBER;
5828: --end bug 3911698
5829:

Line 5844: from pa_object_relationships a, pa_proj_element_versions b

5840: and prior object_type_from = object_type_to
5841: and prior relationship_type = relationship_type
5842: intersect
5843: select a.object_id_to1
5844: from pa_object_relationships a, pa_proj_element_versions b
5845: where a.relationshiP_type = 'S'
5846: and a.object_id_from1 = b.parent_structure_version_id
5847: and b.element_version_id = c_task_ver_id
5848: and a.object_type_from = 'PA_STRUCTURES';

Line 6017: FROM PA_PROJ_ELEMENT_VERSIONS

6013: (p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
6014:
6015: SELECT proj_element_id
6016: INTO l_proj_element_id
6017: FROM PA_PROJ_ELEMENT_VERSIONS
6018: WHERE element_version_id = p_task_version_id;
6019:
6020: IF ('Y' = pa_proj_elements_utils.CHECK_ELEMENT_HAS_PHASE(
6021: l_proj_element_id)) THEN

Line 6047: FROM PA_PROJ_ELEMENT_VERSIONS

6043:
6044: -- get the display sequence of the reference task
6045: SELECT display_sequence, parent_structure_version_id
6046: INTO l_ref_display_sequence, l_ref_parent_struct_ver_id
6047: FROM PA_PROJ_ELEMENT_VERSIONS
6048: WHERE element_version_id = p_ref_task_version_id;
6049:
6050: -- get the display sequence of the task being moved
6051: SELECT display_sequence, parent_structure_version_id

Line 6053: FROM PA_PROJ_ELEMENT_VERSIONS

6049:
6050: -- get the display sequence of the task being moved
6051: SELECT display_sequence, parent_structure_version_id
6052: INTO l_display_sequence, l_parent_struct_ver_id
6053: FROM PA_PROJ_ELEMENT_VERSIONS
6054: WHERE element_version_id = p_task_version_id;
6055:
6056: -- get the parent of the task being moved
6057: SELECT object_id_from1, object_type_from

Line 6248: FROM pa_proj_element_versions

6244: END IF;
6245:
6246:
6247: /* SELECT proj_element_id, project_id INTO l_structure_id, l_project_id
6248: FROM pa_proj_element_versions
6249: WHERE element_version_id = p_structure_version_id
6250: AND object_type = 'PA_STRUCTURES';*/
6251:
6252: IF p_called_from_bulk_api = 'N' -- 4269830

Line 6256: FROM pa_proj_element_versions

6252: IF p_called_from_bulk_api = 'N' -- 4269830
6253: THEN
6254:
6255: SELECT proj_element_id, project_id, element_version_id INTO l_structure_id, l_project_id, l_structure_ver_id
6256: FROM pa_proj_element_versions
6257: WHERE element_version_id = ( Select parent_structure_version_id
6258: from pa_proj_element_versions
6259: where element_version_id = p_task_version_id )
6260: AND object_type = 'PA_STRUCTURES';

Line 6258: from pa_proj_element_versions

6254:
6255: SELECT proj_element_id, project_id, element_version_id INTO l_structure_id, l_project_id, l_structure_ver_id
6256: FROM pa_proj_element_versions
6257: WHERE element_version_id = ( Select parent_structure_version_id
6258: from pa_proj_element_versions
6259: where element_version_id = p_task_version_id )
6260: AND object_type = 'PA_STRUCTURES';
6261: END IF; -- 4269830
6262:

Line 6315: PA_PROJ_ELEMENT_VERSIONS ppev

6311: SELECT ppev.proj_element_id, pt.record_version_number, ppa.wbs_record_version_number, ppev.project_id
6312: INTO l_task_id, l_task_record_version_number, l_wbs_record_version_number, l_project_id
6313: FROM PA_TASKS pt,
6314: pa_proj_elem_ver_structure ppa,
6315: PA_PROJ_ELEMENT_VERSIONS ppev
6316: WHERE ppev.element_version_id = p_task_version_id
6317: AND ppev.project_id = ppa.project_id
6318: AND ppev.parent_structure_version_id = ppa.element_version_id
6319: AND ppev.proj_element_id = pt.task_id;

Line 6323: FROM PA_PROJ_ELEMENT_VERSIONS

6319: AND ppev.proj_element_id = pt.task_id;
6320:
6321: SELECT proj_element_id
6322: INTO l_ref_task_id
6323: FROM PA_PROJ_ELEMENT_VERSIONS
6324: WHERE element_version_id = p_ref_task_version_id;
6325: -- merged from 85
6326: SELECT record_version_number, parent_task_id --get old parent id for bug 2947492 (move )
6327: ,top_task_id --bug 2967204

Line 6939: FROM PA_PROJ_ELEMENT_VERSIONS

6935:
6936: BEGIN
6937: SELECT proj_element_id,project_id
6938: INTO src_proj_element_id,l_project_id
6939: FROM PA_PROJ_ELEMENT_VERSIONS
6940: WHERE element_version_id = p_task_version_id
6941: AND parent_structure_version_id = p_structure_version_id;
6942: EXCEPTION
6943: WHEN OTHERS THEN

Line 6981: FROM PA_PROJ_ELEMENT_VERSIONS

6977: (p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
6978:
6979: SELECT proj_element_id, wbs_level, display_sequence, parent_structure_version_id
6980: INTO l_proj_element_id, l_wbs_level, l_display_sequence, l_parent_structure_version_id
6981: FROM PA_PROJ_ELEMENT_VERSIONS
6982: WHERE element_version_id = p_task_version_id;
6983:
6984: IF ('Y' = pa_proj_elements_utils.CHECK_ELEMENT_HAS_PHASE(
6985: l_proj_element_id)) THEN

Line 7014: FROM PA_PROJ_ELEMENT_VERSIONS

7010:
7011: /* Moved up for performance bug 2832807
7012: SELECT wbs_level, display_sequence, parent_structure_version_id
7013: INTO l_wbs_level, l_display_sequence, l_parent_structure_version_id
7014: FROM PA_PROJ_ELEMENT_VERSIONS
7015: WHERE element_version_id = p_task_version_id;
7016: */
7017:
7018: --dbms_output.put_line( 'Indent Task Stage 3 ' );

Line 7031: FROM PA_PROJ_ELEMENT_VERSIONS

7027:
7028: --need to specify parent structure version id
7029: SELECT wbs_level, element_version_id
7030: INTO l_prev_wbs_level, l_ref_task_version_id
7031: FROM PA_PROJ_ELEMENT_VERSIONS
7032: WHERE display_sequence = l_display_sequence - 1
7033: AND parent_structure_version_id = l_parent_structure_version_id;
7034:
7035: --dbms_output.put_line( 'Indent Task Stage 5 ' );

Line 7072: FROM PA_PROJ_ELEMENT_VERSIONS

7068: --need to specify which structure version
7069: --need to specify parent in the inner select statement
7070: SELECT element_version_id
7071: INTO l_ref_task_version_id
7072: FROM PA_PROJ_ELEMENT_VERSIONS
7073: WHERE wbs_level = l_wbs_level + 1
7074: AND object_type = 'PA_TASKS'
7075: AND display_sequence < l_display_sequence
7076: AND parent_structure_version_id = l_parent_structure_version_id

Line 7079: FROM PA_PROJ_ELEMENT_VERSIONS

7075: AND display_sequence < l_display_sequence
7076: AND parent_structure_version_id = l_parent_structure_version_id
7077: AND display_sequence =
7078: (SELECT max(display_sequence)
7079: FROM PA_PROJ_ELEMENT_VERSIONS
7080: WHERE wbs_level = l_wbs_level + 1
7081: AND object_type = 'PA_TASKS'
7082: AND display_sequence < l_display_sequence
7083: AND parent_structure_version_id = l_parent_structure_version_id);

Line 7172: FROM PA_PROJ_ELEMENT_VERSIONS

7168:
7169: -- Update WBS numbers
7170: SELECT parent_structure_version_id
7171: INTO l_parent_structure_version_id
7172: FROM PA_PROJ_ELEMENT_VERSIONS
7173: WHERE element_version_id = p_task_version_id;
7174:
7175: --dbms_output.put_line( 'Indent Task Stage 12 ' );
7176:

Line 7190: FROM pa_proj_element_versions

7186: ,x_return_status => l_return_status );
7187:
7188:
7189: SELECT proj_element_id, project_id INTO l_structure_id, l_project_id
7190: FROM pa_proj_element_versions
7191: WHERE element_version_id = ( Select parent_structure_version_id
7192: from pa_proj_element_versions
7193: where element_version_id = p_task_version_id )
7194: AND object_type = 'PA_STRUCTURES';

Line 7192: from pa_proj_element_versions

7188:
7189: SELECT proj_element_id, project_id INTO l_structure_id, l_project_id
7190: FROM pa_proj_element_versions
7191: WHERE element_version_id = ( Select parent_structure_version_id
7192: from pa_proj_element_versions
7193: where element_version_id = p_task_version_id )
7194: AND object_type = 'PA_STRUCTURES';
7195:
7196:

Line 7227: PA_PROJ_ELEMENT_VERSIONS ppev

7223: SELECT ppev.proj_element_id, pt.record_version_number, ppa.wbs_record_version_number, ppev.project_id
7224: INTO l_task_id, l_task_record_version_number, l_wbs_record_version_number, l_project_id
7225: FROM PA_TASKS pt,
7226: pa_proj_elem_ver_structure ppa,
7227: PA_PROJ_ELEMENT_VERSIONS ppev
7228: WHERE ppev.element_version_id = p_task_version_id
7229: AND ppev.parent_structure_version_id = ppa.element_version_id
7230: AND ppev.project_id = ppa.project_id
7231: AND ppev.proj_element_id = pt.task_id;

Line 7235: FROM PA_PROJ_ELEMENT_VERSIONS

7231: AND ppev.proj_element_id = pt.task_id;
7232:
7233: SELECT proj_element_id
7234: INTO l_ref_task_id
7235: FROM PA_PROJ_ELEMENT_VERSIONS
7236: WHERE element_version_id = l_ref_task_version_id;
7237:
7238: SELECT record_version_number INTO l_task_record_version_number
7239: FROM pa_tasks

Line 7551: FROM PA_PROJ_ELEMENT_VERSIONS

7547:
7548:
7549: SELECT wbs_level, display_sequence, parent_structure_version_id
7550: INTO l_wbs_level, l_display_sequence, l_parent_structure_version_id
7551: FROM PA_PROJ_ELEMENT_VERSIONS
7552: WHERE element_version_id = p_task_version_id;
7553:
7554: if l_wbs_level = 1 then
7555: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

Line 7578: FROM PA_PROJ_ELEMENT_VERSIONS

7574:
7575: --get the reference task version of p_task_version_id
7576: SELECT element_version_id
7577: INTO l_ref_task_version_id
7578: FROM PA_PROJ_ELEMENT_VERSIONS
7579: WHERE wbs_level = l_wbs_level - 1
7580: AND object_type = 'PA_TASKS'
7581: AND parent_structure_version_id = l_parent_structure_version_id
7582: AND display_sequence < l_display_sequence

Line 7585: FROM PA_PROJ_ELEMENT_VERSIONS

7581: AND parent_structure_version_id = l_parent_structure_version_id
7582: AND display_sequence < l_display_sequence
7583: AND display_sequence =
7584: (SELECT max(display_sequence)
7585: FROM PA_PROJ_ELEMENT_VERSIONS
7586: WHERE wbs_level = l_wbs_level - 1
7587: AND object_type = 'PA_TASKS'
7588: AND parent_structure_version_id = l_parent_structure_version_id
7589: AND display_sequence < l_display_sequence);

Line 7654: FROM PA_PROJ_ELEMENT_VERSIONS

7650:
7651: -- Update WBS numbers
7652: SELECT parent_structure_version_id
7653: INTO l_parent_structure_version_id
7654: FROM PA_PROJ_ELEMENT_VERSIONS
7655: WHERE element_version_id = p_task_version_id;
7656:
7657: PA_PROJ_ELEMENTS_UTILS.UPDATE_WBS_NUMBERS
7658: ( p_commit => p_commit

Line 7668: FROM pa_proj_element_versions

7664: ,p_parent_task_id => NULL
7665: ,x_return_status => l_return_status );
7666:
7667: /* SELECT proj_element_id, project_id INTO l_structure_id, l_project_id
7668: FROM pa_proj_element_versions
7669: WHERE element_version_id = p_structure_version_id
7670: AND object_type = 'PA_STRUCTURES';*/
7671:
7672: SELECT proj_element_id, project_id INTO l_structure_id, l_project_id

Line 7673: FROM pa_proj_element_versions

7669: WHERE element_version_id = p_structure_version_id
7670: AND object_type = 'PA_STRUCTURES';*/
7671:
7672: SELECT proj_element_id, project_id INTO l_structure_id, l_project_id
7673: FROM pa_proj_element_versions
7674: WHERE element_version_id = ( Select parent_structure_version_id
7675: from pa_proj_element_versions
7676: where element_version_id = p_task_version_id )
7677: AND object_type = 'PA_STRUCTURES';

Line 7675: from pa_proj_element_versions

7671:
7672: SELECT proj_element_id, project_id INTO l_structure_id, l_project_id
7673: FROM pa_proj_element_versions
7674: WHERE element_version_id = ( Select parent_structure_version_id
7675: from pa_proj_element_versions
7676: where element_version_id = p_task_version_id )
7677: AND object_type = 'PA_STRUCTURES';
7678:
7679: --Do financial task check

Line 7708: PA_PROJ_ELEMENT_VERSIONS ppev

7704: SELECT ppev.proj_element_id, pt.record_version_number, ppa.wbs_record_version_number, ppev.project_id
7705: INTO l_task_id, l_task_record_version_number, l_wbs_record_version_number, l_project_id
7706: FROM PA_TASKS pt,
7707: pa_proj_elem_ver_structure ppa,
7708: PA_PROJ_ELEMENT_VERSIONS ppev
7709: WHERE ppev.element_version_id = p_task_version_id
7710: AND ppev.parent_structure_version_id = ppa.element_version_id
7711: AND ppev.project_id = ppa.project_id
7712: AND ppev.proj_element_id = pt.task_id;

Line 7716: FROM PA_PROJ_ELEMENT_VERSIONS

7712: AND ppev.proj_element_id = pt.task_id;
7713:
7714: SELECT proj_element_id
7715: INTO l_ref_task_id
7716: FROM PA_PROJ_ELEMENT_VERSIONS
7717: WHERE element_version_id = l_ref_task_version_id;
7718:
7719: SELECT record_version_number INTO l_task_record_version_number
7720: FROM pa_tasks

Line 7951: FROM pa_proj_element_versions

7947:
7948: CURSOR cur_ref_proj_elem_id( p_ref_task_ver_id NUMBER )
7949: IS
7950: SELECT proj_element_id
7951: FROM pa_proj_element_versions
7952: WHERE element_version_id = p_ref_task_ver_id
7953: AND object_type = 'PA_TASKS';
7954:
7955: --Hsiu added for date rollup

Line 7970: l_task_unpub_ver_status_code PA_PROJ_ELEMENT_VERSIONS.TASK_UNPUB_VER_STATUS_CODE%TYPE;

7966: where project_id = c_project_id
7967: and template_flag = 'Y';
7968: l_template_flag VARCHAR2(1);
7969:
7970: l_task_unpub_ver_status_code PA_PROJ_ELEMENT_VERSIONS.TASK_UNPUB_VER_STATUS_CODE%TYPE;
7971:
7972: CURSOR get_parent_version_id(c_elem_ver_id NUMBER) IS
7973: select object_id_from1
7974: from pa_object_relationships

Line 7993: from pa_proj_element_versions

7989: --end bug 3053281
7990:
7991: CURSOR get_base_ref_obj_type IS
7992: select object_type
7993: from pa_proj_element_versions
7994: where element_version_id = p_ref_task_version_id;
7995: l_ref_obj_type VARCHAR2(30);
7996:
7997: -- Added for FP_M changes : Bug 3305199 : Bhumesh

Line 8822: pa_proj_element_versions ppev,

8818: IS
8819: SELECT sum(ppevs.duration)
8820: FROM pa_proj_elem_ver_schedule ppevs,
8821: pa_object_relationships por,
8822: pa_proj_element_versions ppev,
8823: pa_proj_elements ppe,
8824: pa_task_types ptt
8825: WHERE por.object_id_from1 = c_parent_element_version_id
8826: AND por.object_type_to = 'PA_TASKS'

Line 8857: pa_proj_element_versions ppev,

8853: CURSOR check_progress_allowed(c_element_version_id NUMBER)
8854: IS
8855: SELECT ptt.prog_entry_enable_flag, ppe.project_id /* for bug 2822963 */
8856: FROM pa_task_types ptt,
8857: pa_proj_element_versions ppev,
8858: pa_proj_elements ppe
8859: WHERE ppev.element_version_id = c_element_version_id
8860: AND ppev.proj_element_id = ppe.proj_element_id
8861: AND ptt.object_type = 'PA_TASKS' /* for bug 3279978 FP M Enhancement */

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

8875: -- on all the child tasks equally.
8876: CURSOR get_progressible_child_count(c_parent_element_version_id NUMBER)
8877: IS
8878: SELECT count(rel.object_id_to1)
8879: FROM PA_OBJECT_RELATIONSHIPS rel,pa_proj_element_versions ver,pa_proj_elements ele,pa_task_types tt
8880: WHERE rel.object_id_from1 = c_parent_element_version_id
8881: AND rel.object_type_to = 'PA_TASKS'
8882: AND rel.relationship_type = 'S'
8883: AND rel.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

Line 9519: , pa_proj_element_versions ppev,

9515:
9516: CURSOR check_progress_allowed(c_element_version_id NUMBER) IS
9517: SELECT ptt.prog_entry_enable_flag
9518: FROM pa_task_types ptt
9519: , pa_proj_element_versions ppev,
9520: pa_proj_elements ppe
9521: WHERE ppev.element_version_id = c_element_version_id
9522: AND ppev.proj_element_id = ppe.proj_element_id
9523: AND ptt.object_type = 'PA_TASKS' /* for bug 3279978 FP M Enhancement */

Line 9611: from pa_proj_element_versions

9607: --end bug 2843737
9608:
9609: CURSOR get_wbs_number(c_elem_ver_id NUMBER) is
9610: select wbs_number
9611: from pa_proj_element_versions
9612: where element_version_id = c_elem_ver_id
9613: and object_type ='PA_TASKS';
9614:
9615: -- hyau Bug 2852753

Line 9648: FROM pa_proj_element_versions

9644: l_cur_project_id NUMBER;
9645: CURSOR cur_proj_id
9646: IS
9647: SELECT project_id
9648: FROM pa_proj_element_versions
9649: WHERE element_version_id = p_structure_version_id;
9650:
9651: -- end hyau Bug 2852753
9652:

Line 9697: from pa_object_relationships a, pa_proj_element_versions b

9693: and prior object_type_from = object_type_to
9694: and prior relationship_type = relationship_type
9695: intersect
9696: select a.object_id_to1
9697: from pa_object_relationships a, pa_proj_element_versions b
9698: where a.relationshiP_type = 'S'
9699: and a.object_id_from1 = b.parent_structure_version_id
9700: and b.element_version_id = c_task_ver_id
9701: and a.object_type_from = 'PA_STRUCTURES';

Line 9720: FROM PA_PROJ_ELEMENT_VERSIONS

9716: l_ref_tsk_version_id NUMBER;
9717:
9718: CURSOR cur_get_ref_tsk_ver_id(c_src_wbs_level NUMBER) IS
9719: SELECT element_version_id
9720: FROM PA_PROJ_ELEMENT_VERSIONS
9721: WHERE parent_structure_version_id = p_structure_version_id
9722: AND project_id = p_project_id
9723: AND wbs_level = c_src_wbs_level
9724: AND object_type = 'PA_TASKS'

Line 9728: FROM pa_proj_element_versions

9724: AND object_type = 'PA_TASKS'
9725: AND display_sequence < src_seq_number
9726: AND display_sequence =
9727: (SELECT max (display_sequence)
9728: FROM pa_proj_element_versions
9729: WHERE project_id = p_project_id
9730: AND parent_structure_version_id = p_structure_version_id
9731: AND wbs_level = c_src_wbs_level
9732: AND display_sequence < src_seq_number

Line 9816: FROM PA_PROJ_ELEMENT_VERSIONS

9812:
9813: BEGIN
9814: SELECT element_version_id, proj_element_id, wbs_number, wbs_level, display_sequence, parent_structure_version_id, object_type
9815: 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
9816: FROM PA_PROJ_ELEMENT_VERSIONS
9817: WHERE element_version_id = p_task_version_id
9818: AND project_id = p_project_id
9819: AND parent_structure_version_id = p_structure_version_id;
9820: EXCEPTION

Line 9843: FROM PA_PROJ_ELEMENT_VERSIONS

9839: -- Get Source Task Information
9840: BEGIN
9841: SELECT element_version_id, proj_element_id, wbs_number, wbs_level, display_sequence, parent_structure_version_id, object_type
9842: 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
9843: FROM PA_PROJ_ELEMENT_VERSIONS
9844: WHERE element_version_id = p_task_version_id
9845: AND project_id = p_project_id
9846: AND parent_structure_version_id = p_structure_version_id;
9847: EXCEPTION

Line 9881: FROM PA_PROJ_ELEMENT_VERSIONS

9877: -- Otherwise we will again fetch the correct reference task
9878:
9879: SELECT element_version_id, proj_element_id, wbs_number, wbs_level, display_sequence, parent_structure_version_id, object_type
9880: 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
9881: FROM PA_PROJ_ELEMENT_VERSIONS
9882: WHERE display_sequence = src_seq_number - 1
9883: AND parent_structure_version_id = p_structure_version_id
9884: AND project_id = p_project_id
9885: AND object_type = 'PA_TASKS';

Line 9903: FROM PA_PROJ_ELEMENT_VERSIONS

9899: l_peer_or_sub := 'PEER';
9900:
9901: SELECT element_version_id, proj_element_id, wbs_number, wbs_level, display_sequence, parent_structure_version_id, object_type
9902: 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
9903: FROM PA_PROJ_ELEMENT_VERSIONS
9904: WHERE parent_structure_version_id = p_structure_version_id
9905: AND project_id = p_project_id
9906: AND wbs_level = src_wbs_level+1
9907: AND object_type = 'PA_TASKS'

Line 9911: FROM pa_proj_element_versions

9907: AND object_type = 'PA_TASKS'
9908: AND display_sequence < src_seq_number
9909: AND display_sequence =
9910: (SELECT max (display_sequence)
9911: FROM pa_proj_element_versions
9912: WHERE project_id = p_project_id
9913: AND parent_structure_version_id = p_structure_version_id
9914: AND wbs_level = src_wbs_level+1
9915: AND display_sequence < src_seq_number

Line 9934: FROM PA_PROJ_ELEMENT_VERSIONS

9930:
9931: BEGIN
9932: SELECT element_version_id, proj_element_id, wbs_number, wbs_level, display_sequence, parent_structure_version_id, object_type
9933: 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
9934: FROM PA_PROJ_ELEMENT_VERSIONS
9935: WHERE parent_structure_version_id = p_structure_version_id
9936: AND project_id = p_project_id
9937: AND (wbs_level = src_wbs_level OR wbs_level = src_wbs_level+1) -- Sub or Peer
9938: AND object_type = 'PA_TASKS'

Line 9942: FROM pa_proj_element_versions

9938: AND object_type = 'PA_TASKS'
9939: AND display_sequence < src_seq_number
9940: AND display_sequence =
9941: (SELECT max (display_sequence)
9942: FROM pa_proj_element_versions
9943: WHERE project_id = p_project_id
9944: AND parent_structure_version_id = p_structure_version_id
9945: AND (wbs_level = src_wbs_level OR wbs_level = src_wbs_level+1) -- Sub or Peer
9946: AND display_sequence < src_seq_number

Line 10154: pa_proj_element_versions

10150: l_display_sequence_tab, l_wbs_level_tab,
10151: l_wbs_number_tab, l_record_version_tab,
10152: l_changed_flag_tab
10153: FROM
10154: pa_proj_element_versions
10155: WHERE
10156: project_id = p_project_id
10157: AND parent_structure_version_id = p_structure_version_id
10158: AND object_type = 'PA_TASKS'

Line 10290: UPDATE PA_PROJ_ELEMENT_VERSIONS

10286:
10287: -- Locking should be implemnted here
10288:
10289: FORALL j IN l_element_version_id_tab.FIRST..l_element_version_id_tab.LAST
10290: UPDATE PA_PROJ_ELEMENT_VERSIONS
10291: SET
10292: wbs_level = l_wbs_level_tab(j) ,
10293: wbs_number = l_wbs_number_tab(j) ,
10294: last_update_date = sysdate ,

Line 10464: FROM pa_proj_element_versions

10460:
10461: /*** End Update_task_version and Update_wbs_number code ***/
10462:
10463: SELECT proj_element_id, project_id INTO l_structure_id, l_project_id
10464: FROM pa_proj_element_versions
10465: WHERE element_version_id = ( Select parent_structure_version_id
10466: from pa_proj_element_versions
10467: where element_version_id = p_task_version_id )
10468: AND object_type = 'PA_STRUCTURES';

Line 10466: from pa_proj_element_versions

10462:
10463: SELECT proj_element_id, project_id INTO l_structure_id, l_project_id
10464: FROM pa_proj_element_versions
10465: WHERE element_version_id = ( Select parent_structure_version_id
10466: from pa_proj_element_versions
10467: where element_version_id = p_task_version_id )
10468: AND object_type = 'PA_STRUCTURES';
10469:
10470:

Line 10500: PA_PROJ_ELEMENT_VERSIONS ppev

10496: SELECT ppev.proj_element_id, pt.record_version_number, ppa.wbs_record_version_number, ppev.project_id
10497: INTO l_task_id, l_task_record_version_number, l_wbs_record_version_number, l_project_id
10498: FROM PA_TASKS pt,
10499: pa_proj_elem_ver_structure ppa,
10500: PA_PROJ_ELEMENT_VERSIONS ppev
10501: WHERE ppev.element_version_id = p_task_version_id
10502: AND ppev.parent_structure_version_id = ppa.element_version_id
10503: AND ppev.project_id = ppa.project_id
10504: AND ppev.proj_element_id = pt.task_id;

Line 11004: , pa_proj_element_versions ppev,

11000:
11001: CURSOR check_progress_allowed(c_element_version_id NUMBER) IS
11002: SELECT ptt.prog_entry_enable_flag
11003: FROM pa_task_types ptt
11004: , pa_proj_element_versions ppev,
11005: pa_proj_elements ppe
11006: WHERE ppev.element_version_id = c_element_version_id
11007: AND ppev.proj_element_id = ppe.proj_element_id
11008: AND ppe.TYPE_ID = ptt.task_type_id;

Line 11030: pa_proj_element_versions ppev

11026: -- This case should not be possible for Outdent/Indent
11027: CURSOR cur_new_child(c_ref_task_version_id NUMBER, c_display_sequence NUMBER) IS
11028: SELECT por.object_id_to1, ppev.display_sequence, por.record_version_number, por.object_relationship_id
11029: FROM pa_object_relationships por,
11030: pa_proj_element_versions ppev
11031: WHERE object_id_from1 = c_ref_task_version_id
11032: AND object_id_to1 = element_version_id
11033: AND display_sequence > c_display_sequence
11034: AND relationship_type = 'S'

Line 11130: from pa_proj_element_versions

11126: --end bug 2843737
11127:
11128: CURSOR get_wbs_number(c_elem_ver_id NUMBER) is
11129: select wbs_number
11130: from pa_proj_element_versions
11131: where element_version_id = c_elem_ver_id
11132: and object_type ='PA_TASKS';
11133:
11134: ref_parent_branch_mask VARCHAR2(1000);

Line 11169: FROM pa_proj_element_versions

11165: l_cur_project_id NUMBER;
11166: CURSOR cur_proj_id
11167: IS
11168: SELECT project_id
11169: FROM pa_proj_element_versions
11170: WHERE element_version_id = p_structure_version_id;
11171:
11172: -- end hyau Bug 2852753
11173:

Line 11196: FROM pa_tasks pt, pa_proj_element_versions ppev

11192: CURSOR cur_new_child_task( c_project_id NUMBER, c_wbs_level NUMBER,
11193: c_task_id NUMBER , c_parent_task_id NUMBER )
11194: IS
11195: SELECT pt.task_id, pt.top_task_id, pt.parent_task_id
11196: FROM pa_tasks pt, pa_proj_element_versions ppev
11197: WHERE pt.wbs_level = c_wbs_level
11198: AND parent_task_id = c_parent_task_id
11199: AND pt.project_id = c_project_id
11200: AND pt.task_id = ppev.proj_element_id

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

11197: WHERE pt.wbs_level = c_wbs_level
11198: AND parent_task_id = c_parent_task_id
11199: AND pt.project_id = c_project_id
11200: AND pt.task_id = ppev.proj_element_id
11201: AND ppev.display_sequence > ( SELECT display_sequence FROM pa_proj_element_versions
11202: WHERE project_id = c_project_id
11203: AND object_type = 'PA_TASKS'
11204: AND proj_element_id = c_task_id );
11205:

Line 11241: from pa_object_relationships a, pa_proj_element_versions b

11237: and prior object_type_from = object_type_to
11238: and prior relationship_type = relationship_type
11239: intersect
11240: select a.object_id_to1
11241: from pa_object_relationships a, pa_proj_element_versions b
11242: where a.relationshiP_type = 'S'
11243: and a.object_id_from1 = b.parent_structure_version_id
11244: and b.element_version_id = c_task_ver_id
11245: and a.object_type_from = 'PA_STRUCTURES';

Line 11265: pa_proj_element_versions ppev

11261: --ref task but now become child of p_task_version_id
11262: CURSOR cur_child_tasks_exists(c_ref_task_version_id NUMBER, c_display_sequence NUMBER) IS
11263: SELECT 'Y'
11264: FROM pa_object_relationships por,
11265: pa_proj_element_versions ppev
11266: WHERE object_id_from1 = c_ref_task_version_id
11267: AND object_id_to1 = element_version_id
11268: AND display_sequence > c_display_sequence
11269: AND relationship_type = 'S'

Line 11378: FROM PA_PROJ_ELEMENT_VERSIONS

11374: -- Get Source Task Information
11375: BEGIN
11376: SELECT element_version_id, proj_element_id, wbs_number, wbs_level, display_sequence, parent_structure_version_id, object_type
11377: 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
11378: FROM PA_PROJ_ELEMENT_VERSIONS
11379: WHERE element_version_id = p_task_version_id
11380: AND project_id = p_project_id
11381: AND parent_structure_version_id = p_structure_version_id;
11382: EXCEPTION

Line 11401: FROM PA_PROJ_ELEMENT_VERSIONS

11397:
11398: BEGIN
11399: SELECT element_version_id, proj_element_id, wbs_number, wbs_level, display_sequence, parent_structure_version_id, object_type
11400: 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
11401: FROM PA_PROJ_ELEMENT_VERSIONS
11402: WHERE parent_structure_version_id = p_structure_version_id
11403: AND project_id = p_project_id
11404: AND (wbs_level = src_wbs_level-1)
11405: AND object_type = 'PA_TASKS'

Line 11408: FROM pa_proj_element_versions

11404: AND (wbs_level = src_wbs_level-1)
11405: AND object_type = 'PA_TASKS'
11406: AND display_sequence =
11407: (SELECT max (display_sequence)
11408: FROM pa_proj_element_versions
11409: WHERE project_id = p_project_id
11410: AND parent_structure_version_id = p_structure_version_id
11411: AND (wbs_level = src_wbs_level-1)
11412: AND display_sequence < src_seq_number

Line 11615: pa_proj_element_versions

11611: l_display_sequence_tab, l_wbs_level_tab,
11612: l_wbs_number_tab, l_record_version_tab,
11613: l_changed_flag_tab
11614: FROM
11615: pa_proj_element_versions
11616: WHERE
11617: project_id = p_project_id
11618: AND parent_structure_version_id = p_structure_version_id
11619: AND object_type = 'PA_TASKS'

Line 11830: UPDATE PA_PROJ_ELEMENT_VERSIONS

11826:
11827: -- Locking should be implemented here
11828:
11829: FORALL j IN l_element_version_id_tab.FIRST..l_element_version_id_tab.LAST
11830: UPDATE PA_PROJ_ELEMENT_VERSIONS
11831: SET
11832: wbs_level = l_wbs_level_tab(j) ,
11833: wbs_number = l_wbs_number_tab(j) ,
11834: last_update_date = sysdate ,

Line 12080: FROM pa_proj_element_versions

12076:
12077: /*** End Update_task_version and Update_wbs_number code ***/
12078:
12079: SELECT proj_element_id, project_id INTO l_structure_id, l_project_id
12080: FROM pa_proj_element_versions
12081: WHERE element_version_id = ( Select parent_structure_version_id
12082: from pa_proj_element_versions
12083: where element_version_id = p_task_version_id )
12084: AND object_type = 'PA_STRUCTURES';

Line 12082: from pa_proj_element_versions

12078:
12079: SELECT proj_element_id, project_id INTO l_structure_id, l_project_id
12080: FROM pa_proj_element_versions
12081: WHERE element_version_id = ( Select parent_structure_version_id
12082: from pa_proj_element_versions
12083: where element_version_id = p_task_version_id )
12084: AND object_type = 'PA_STRUCTURES';
12085:
12086:

Line 12117: PA_PROJ_ELEMENT_VERSIONS ppev

12113: SELECT ppev.proj_element_id, pt.record_version_number, ppa.wbs_record_version_number, ppev.project_id
12114: INTO l_task_id, l_task_record_version_number, l_wbs_record_version_number, l_project_id
12115: FROM PA_TASKS pt,
12116: pa_proj_elem_ver_structure ppa,
12117: PA_PROJ_ELEMENT_VERSIONS ppev
12118: WHERE ppev.element_version_id = p_task_version_id
12119: AND ppev.parent_structure_version_id = ppa.element_version_id
12120: AND ppev.project_id = ppa.project_id
12121: AND ppev.proj_element_id = pt.task_id;

Line 12688: FROM pa_proj_element_versions

12684: AND PRIOR object_type_to = object_type_from
12685: AND PRIOR object_id_to1 = object_id_from1
12686: UNION
12687: SELECT element_version_id task_ver_id
12688: FROM pa_proj_element_versions
12689: WHERE element_version_id = c_task_version_id;
12690:
12691: BEGIN
12692:

Line 12754: ,pa_proj_element_versions v

12750: ,e.name
12751: INTO l_element_number
12752: ,l_element_name
12753: FROM pa_proj_elements e
12754: ,pa_proj_element_versions v
12755: WHERE v.element_version_id = p_task_version_id_tbl(i)
12756: AND e.proj_element_id = v.proj_element_id ;
12757:
12758: PA_INTERFACE_UTILS_PUB.get_messages

Line 13873: FROM pa_proj_element_versions

13869:
13870: CURSOR c_proj_element_id
13871: IS
13872: SELECT proj_element_id
13873: FROM pa_proj_element_versions
13874: WHERE project_id = p_project_id
13875: and parent_structure_version_id = p_structure_version_id
13876: and element_version_id = p_task_ver_id
13877: and object_type = decode(p_object_type, 'PA_ASSIGNMENTS','PA_TASKS', p_object_type); -- Bug 3856161 : Added Decode

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

13896: -- Start modifications for Bug # 3879658.
13897:
13898: cursor cur_progress_status is
13899: select ptt.initial_progress_status_code
13900: from pa_task_types ptt, pa_proj_elements ppe, pa_proj_element_versions ppev
13901: where ppev.project_id = ppe.project_id
13902: and ppev.proj_element_id = ppe.proj_element_id
13903: and ppe.type_id = ptt.task_type_id
13904: and ppe.project_id = p_project_id

Line 14058: from pa_proj_element_versions

14054: -- Get the task_id.
14055:
14056: select proj_element_id
14057: into l_task_id
14058: from pa_proj_element_versions
14059: where element_version_id = p_task_ver_id
14060: and parent_structure_version_id = p_structure_version_id;
14061:
14062: IF l_debug_mode = 'Y' THEN

Line 15210: l_task_unpub_ver_status_code PA_PROJ_ELEMENT_VERSIONS.TASK_UNPUB_VER_STATUS_CODE%TYPE;

15206: l_src_structure_id NUMBER;
15207: l_src_structure_version_id NUMBER;
15208:
15209: l_dest_project_id NUMBER ;
15210: l_task_unpub_ver_status_code PA_PROJ_ELEMENT_VERSIONS.TASK_UNPUB_VER_STATUS_CODE%TYPE;
15211: l_dest_structure_id NUMBER;
15212: l_template_flag VARCHAR2(1);
15213: l_fin_task_flag VARCHAR2(1);
15214:

Line 15251: FROM pa_proj_element_versions

15247:
15248: CURSOR cur_dest_proj_id
15249: IS
15250: SELECT project_id
15251: FROM pa_proj_element_versions
15252: WHERE element_version_id = p_dest_task_version_id;
15253:
15254: CURSOR cur_struc_id( x_structure_version_id NUMBER, x_project_id NUMBER )
15255: IS

Line 15702: FROM pa_proj_element_versions

15698: l_cur_project_id NUMBER;
15699: CURSOR cur_proj_id
15700: IS
15701: SELECT project_id
15702: FROM pa_proj_element_versions
15703: WHERE element_version_id = p_structure_version_id;
15704:
15705: CURSOR get_product_code ( c_project_id NUMBER ) IS
15706: SELECT pm_product_code

Line 15843: FROM pa_proj_element_versions

15839: IF nvl(p_task_version_id_tbl.LAST,0)>0 THEN
15840: l_task_version_id := p_task_version_id_tbl(1);
15841:
15842: SELECT proj_element_id INTO l_structure_id
15843: FROM pa_proj_element_versions
15844: WHERE element_version_id = ( Select parent_structure_version_id
15845: from pa_proj_element_versions
15846: where element_version_id = l_task_version_id )
15847: AND object_type = 'PA_STRUCTURES';

Line 15845: from pa_proj_element_versions

15841:
15842: SELECT proj_element_id INTO l_structure_id
15843: FROM pa_proj_element_versions
15844: WHERE element_version_id = ( Select parent_structure_version_id
15845: from pa_proj_element_versions
15846: where element_version_id = l_task_version_id )
15847: AND object_type = 'PA_STRUCTURES';
15848: -----------------------------------------------------------
15849: OPEN cur_struc_type( l_structure_id );

Line 16379: FROM pa_proj_element_versions ver

16375:
16376: -- 4533534 : Included join of pa_proj_elem_ver_structure too
16377: CURSOR c_get_all_task_versions(c_task_id NUMBER, c_project_id NUMBER) IS
16378: SELECT ver.element_version_id, str.status_code
16379: FROM pa_proj_element_versions ver
16380: , pa_proj_elem_ver_structure str
16381: WHERE ver.project_id = c_project_id
16382: AND ver.proj_element_id = c_task_id
16383: AND ver.project_id = str.project_id

Line 16402: pa_proj_element_versions ppv1 -- linking task

16398: ,por1.object_relationship_id object_relationship_id
16399: ,por1.record_version_number record_version_number
16400: ,ppv1.task_unpub_ver_status_code task_unpub_ver_status_code
16401: FROM
16402: pa_proj_element_versions ppv1 -- linking task
16403: ,pa_proj_element_versions ppv2 -- linked project
16404: ,pa_object_relationships por1
16405: ,pa_object_relationships por2
16406: ,(SELECT object_id_from1, object_id_to1

Line 16403: ,pa_proj_element_versions ppv2 -- linked project

16399: ,por1.record_version_number record_version_number
16400: ,ppv1.task_unpub_ver_status_code task_unpub_ver_status_code
16401: FROM
16402: pa_proj_element_versions ppv1 -- linking task
16403: ,pa_proj_element_versions ppv2 -- linked project
16404: ,pa_object_relationships por1
16405: ,pa_object_relationships por2
16406: ,(SELECT object_id_from1, object_id_to1
16407: FROM pa_object_relationships

Line 16435: pa_proj_element_versions ppv -- linked project

16431: ,por.object_relationship_id object_relationship_id
16432: ,por.record_version_number record_version_number
16433: ,por.relationship_type relationship_type
16434: FROM
16435: pa_proj_element_versions ppv -- linked project
16436: ,pa_object_relationships por
16437: ,(SELECT object_id_from1, object_id_to1 -- Get all sub tasks including linking tasks
16438: FROM pa_object_relationships
16439: START WITH object_id_from1 = c_task_version_id

Line 16671: from pa_proj_elements ppe, pa_proj_element_versions ppev

16667: l_task_error_tbl l_task_error_tbl_type;
16668:
16669: cursor l_cur_task_attr(c_project_id NUMBER, c_element_version_id NUMBER) is
16670: select ppe.name, ppev.wbs_number --Bug 6878138
16671: from pa_proj_elements ppe, pa_proj_element_versions ppev
16672: where ppe.project_id = ppev.project_id
16673: and ppe.proj_element_id = ppev.proj_element_id
16674: and ppev.project_id = c_project_id
16675: and ppev.element_version_id = c_element_version_id;

Line 16903: from pa_proj_elements ppe, pa_proj_element_versions ppev

16899: l_task_error_tbl l_task_error_tbl_type;
16900:
16901: cursor l_cur_task_attr(c_project_id NUMBER, c_element_version_id NUMBER) is
16902: select ppe.name, ppev.wbs_number --Bug 6878138
16903: from pa_proj_elements ppe, pa_proj_element_versions ppev
16904: where ppe.project_id = ppev.project_id
16905: and ppe.proj_element_id = ppev.proj_element_id
16906: and ppev.project_id = c_project_id
16907: and ppev.element_version_id = c_element_version_id;

Line 17144: (select ppev1.proj_element_id from pa_proj_element_versions ppev1,pa_object_relationships por

17140:
17141: cursor parent_task_status(c_task_id NUMBER) is
17142: select task_status,ppe.proj_element_id from pa_proj_elements ppe where
17143: ppe.proj_element_id =
17144: (select ppev1.proj_element_id from pa_proj_element_versions ppev1,pa_object_relationships por
17145: where por.object_id_to1 = (select element_version_id from pa_proj_element_versions ppev2
17146: where proj_element_id = c_task_id)
17147: and por.relationship_type = 'S'
17148: and por.relationship_subtype = 'TASK_TO_TASK'

Line 17145: where por.object_id_to1 = (select element_version_id from pa_proj_element_versions ppev2

17141: cursor parent_task_status(c_task_id NUMBER) is
17142: select task_status,ppe.proj_element_id from pa_proj_elements ppe where
17143: ppe.proj_element_id =
17144: (select ppev1.proj_element_id from pa_proj_element_versions ppev1,pa_object_relationships por
17145: where por.object_id_to1 = (select element_version_id from pa_proj_element_versions ppev2
17146: where proj_element_id = c_task_id)
17147: and por.relationship_type = 'S'
17148: and por.relationship_subtype = 'TASK_TO_TASK'
17149: and ppev1.element_version_id = por.object_id_from1);

Line 17187: from pa_proj_elem_ver_schedule ppvsch,pa_proj_elements ppe,pa_proj_element_versions ppv

17183: for i in p_task_id_tbl.FIRST..p_task_id_tbl.LAST loop
17184:
17185: select ppvsch.scheduled_start_date,ppvsch.scheduled_finish_date
17186: into l_task_start_date,l_task_finish_date
17187: from pa_proj_elem_ver_schedule ppvsch,pa_proj_elements ppe,pa_proj_element_versions ppv
17188: where ppe.proj_element_id = ppv.proj_element_id
17189: and ppv.element_version_id = ppvsch.element_version_id
17190: and ppe.proj_element_id = p_task_id_tbl(i);
17191: