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_TASKS

Line 263: ,p_object_type => 'PA_TASKS'

259: p_element_number => rtrim(p_task_number)
260: ,p_element_id => null
261: ,p_project_id => p_project_id
262: ,p_structure_id => p_parent_structure_id
263: ,p_object_type => 'PA_TASKS'
264: ) = 'N'
265: THEN
266: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
267: p_msg_name => 'PA_PS_TASK_NOT_NUM_UNIQ');

Line 334: pa_tasks_maint_utils.check_task_mgr_name_or_id(

330: (p_task_manager_name IS NOT NULL)) OR
331: ((p_task_manager_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
332: (p_task_manager_id IS NOT NULL)) THEN
333: --Call Check API.
334: pa_tasks_maint_utils.check_task_mgr_name_or_id(
335: p_task_mgr_name => p_task_manager_name,
336: p_task_mgr_id => p_task_manager_id,
337: p_project_id => p_project_id,
338: p_check_id_flag => 'Y',

Line 358: pa_tasks_maint_utils.check_task_mgr_name_or_id(

354: (p_task_manager_name IS NOT NULL)) OR
355: ((p_task_manager_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
356: (p_task_manager_id IS NOT NULL)) THEN
357: --Call Check API.
358: pa_tasks_maint_utils.check_task_mgr_name_or_id(
359: p_task_mgr_name => p_task_manager_name,
360: p_task_mgr_id => p_task_manager_id,
361: p_project_id => p_project_id,
362: --p_check_id_flag => PA_STARTUP.G_Check_ID_Flag,

Line 859: FROM pa_tasks

855: WHERE proj_element_id = p_task_id;
856:
857: CURSOR cur_trans_dates ( c_task_id NUMBER ) IS
858: SELECT START_DATE, COMPLETION_DATE
859: FROM pa_tasks
860: WHERE task_id = c_task_id;
861:
862: CURSOR cur_task_attr IS
863: SELECT pe.ELEMENT_NUMBER, pe.NAME, pe.DESCRIPTION, hou.name

Line 871: FROM PA_TASKS

867:
868: --Bug 3940203 avaithia
869: CURSOR cur_is_fin_task IS
870: SELECT task_id
871: FROM PA_TASKS
872: WHERE task_id = p_task_id ;
873:
874: l_tsk_id PA_TASKS.task_id%TYPE ;
875: l_err_message fnd_new_messages.message_text%TYPE ;

Line 874: l_tsk_id PA_TASKS.task_id%TYPE ;

870: SELECT task_id
871: FROM PA_TASKS
872: WHERE task_id = p_task_id ;
873:
874: l_tsk_id PA_TASKS.task_id%TYPE ;
875: l_err_message fnd_new_messages.message_text%TYPE ;
876: --Bug 3940203 avaithia
877:
878: l_trans_start_date DATE;

Line 911: -- for Financial Tasks (because Organisation field is a NOT NULL Column in pa_tasks table)

907: END IF;
908:
909: --Bug 3940203 avaithia <>
910: -- From Forms and SelfService ,User should not be able to null out Organisation Field
911: -- for Financial Tasks (because Organisation field is a NOT NULL Column in pa_tasks table)
912:
913: -- Actually ,If No Org. Value is passed from UI ,(If user explicitly nulls out the org. field)
914: -- in PA_TASKS table , the Org. for the task is defaulted as the Project's Org.
915:

Line 914: -- in PA_TASKS table , the Org. for the task is defaulted as the Project's Org.

910: -- From Forms and SelfService ,User should not be able to null out Organisation Field
911: -- for Financial Tasks (because Organisation field is a NOT NULL Column in pa_tasks table)
912:
913: -- Actually ,If No Org. Value is passed from UI ,(If user explicitly nulls out the org. field)
914: -- in PA_TASKS table , the Org. for the task is defaulted as the Project's Org.
915:
916: -- Current Behaviour is : Though it is populating default org.id (project's org.id) for task
917: -- in pa_tasks table,In UI it is showing Org. field as NULL
918:

Line 917: -- in pa_tasks table,In UI it is showing Org. field as NULL

913: -- Actually ,If No Org. Value is passed from UI ,(If user explicitly nulls out the org. field)
914: -- in PA_TASKS table , the Org. for the task is defaulted as the Project's Org.
915:
916: -- Current Behaviour is : Though it is populating default org.id (project's org.id) for task
917: -- in pa_tasks table,In UI it is showing Org. field as NULL
918:
919: -- We should not allow this (Org. field being nulled out )
920: -- Note : Same should be the case with AMG also .Because ,AMG changes will be reflected in UI
921:

Line 1196: pa_tasks_maint_utils.check_task_mgr_name_or_id(

1192: OR (l_cur_task_mgr_person_id IS NULL)
1193: OR (p_task_manager_id IS NULL) THEN
1194: --end changes for task manager
1195:
1196: pa_tasks_maint_utils.check_task_mgr_name_or_id(
1197: p_task_mgr_name => p_task_manager_name,
1198: p_task_mgr_id => p_task_manager_id,
1199: p_project_id => l_project_id,
1200: p_check_id_flag => 'Y',

Line 1245: pa_tasks_maint_utils.check_task_mgr_name_or_id(

1241: OR (l_cur_task_mgr_person IS NULL)
1242: OR (p_task_manager_name IS NULL) THEN
1243: --end changes for task manager
1244:
1245: pa_tasks_maint_utils.check_task_mgr_name_or_id(
1246: p_task_mgr_name => p_task_manager_name,
1247: p_task_mgr_id => p_task_manager_id,
1248: p_project_id => l_project_id,
1249: p_check_id_flag => 'A', --bug fix 2646762

Line 2132: AND pors.object_type_from = 'PA_TASKS'

2128: AND pors.object_id_from1 = pors1.object_id_to1
2129: AND pors1.relationship_type = 'S'
2130: AND pors.relationship_type IN ('LW','LF')
2131: AND pors.object_id_from2 <> pors.object_id_to2
2132: AND pors.object_type_from = 'PA_TASKS'
2133: AND pors.object_type_to = 'PA_STRUCTURES');
2134:
2135: l_linked_task VARCHAR2(1);
2136:

Line 3379: and object_type_to = 'PA_TASKS'

3375: CURSOR get_cur_task_ver_weighting(c_ver_id NUMBER) IS
3376: select WEIGHTING_PERCENTAGE
3377: from pa_object_relationships
3378: where object_id_to1 = c_ver_id
3379: and object_type_to = 'PA_TASKS'
3380: and relationship_type = 'S';
3381: --end changes
3382:
3383: /* Bug 2680486 -- Performance changes -- Selected project_id also in the following cursor, which will

Line 3619: FROM pa_tasks

3615:
3616: -- xxlu added task DFF attributes
3617: CURSOR cur_task_attr (c_task_id IN NUMBER) IS
3618: SELECT *
3619: FROM pa_tasks
3620: WHERE task_id = c_task_id;
3621: l_cur_task_attr cur_task_attr%ROWTYPE;
3622: -- end xxlu changes
3623:

Line 3661: and object_type_from IN ('PA_TASKS','PA_STRUCTURES')

3657: cursor sub_task_exists(l_parent_task_version_id NUMBER) IS
3658: select '1'
3659: from pa_object_relationships
3660: where object_id_from1 = l_parent_task_version_id
3661: and object_type_from IN ('PA_TASKS','PA_STRUCTURES')
3662: and object_type_to IN ('PA_TASKS','PA_STRUCTURES')
3663: and relationship_type = 'S';
3664:
3665: --hsiu added for task version status

Line 3662: and object_type_to IN ('PA_TASKS','PA_STRUCTURES')

3658: select '1'
3659: from pa_object_relationships
3660: where object_id_from1 = l_parent_task_version_id
3661: and object_type_from IN ('PA_TASKS','PA_STRUCTURES')
3662: and object_type_to IN ('PA_TASKS','PA_STRUCTURES')
3663: and relationship_type = 'S';
3664:
3665: --hsiu added for task version status
3666: CURSOR cur_proj_is_template(c_project_id NUMBER)

Line 3691: and object_type_to = 'PA_TASKS'

3687: CURSOR get_parent_version_id(c_elem_ver_id NUMBER) IS
3688: select object_id_from1
3689: from pa_object_relationships
3690: where object_id_to1 = c_elem_ver_id
3691: and object_type_to = 'PA_TASKS'
3692: and relationship_type = 'S';
3693: l_parent_ver_id NUMBER;
3694:
3695: --hsiu added for bug 2669388

Line 3749: AND object_type_to = 'PA_TASKS'

3745: WHERE
3746: obj.object_id_to1 = task_ver_id
3747: AND obj.object_id_from1 = struct_ver_id
3748: AND object_type_from = 'PA_STRUCTURES'
3749: AND object_type_to = 'PA_TASKS'
3750: AND relationship_type = 'S'
3751: AND relationship_subtype = 'STRUCTURE_TO_TASK';
3752:
3753: is_top_task_in_dest varchar2(1) := 'N';

Line 3801: PA_TASKS_MAINT_UTILS.CHECK_MOVE_FINANCIAL_TASK_OK (

3797: PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_dest_project_id)
3798: IN ('SHARE_PARTIAL')
3799: Then
3800:
3801: PA_TASKS_MAINT_UTILS.CHECK_MOVE_FINANCIAL_TASK_OK (
3802: p_task_version_id =>
3803: , p_ref_task_version_id => p_dest_task_version_id
3804: , x_return_status => x_return_status
3805: , x_msg_count => x_msg_count

Line 4200: PA_TASKS_MAINT_UTILS.CHECK_MOVE_FINANCIAL_TASK_OK (

4196: PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_dest_project_id) = 'SHARE_PARTIAL'
4197: Then
4198: IF p_dest_structure_version_id <> p_dest_task_version_id -- reference should not be str ver
4199: THEN
4200: PA_TASKS_MAINT_UTILS.CHECK_MOVE_FINANCIAL_TASK_OK (
4201: p_task_version_id => l_element_version_id
4202: , p_ref_task_version_id => l_ref_task_version_id
4203: , x_return_status => x_return_status
4204: , x_msg_count => x_msg_count

Line 4906: PA_TASKS_MAINT_PUB.Copy_Task(

4902: THEN
4903: l_copy_node_flag := 'P'; ---copy entire project
4904: END IF;
4905:
4906: PA_TASKS_MAINT_PUB.Copy_Task(
4907: p_reference_project_id => l_ref_project_id
4908: ,p_reference_task_id => l_ref_task_id
4909: ,p_project_id => l_project_id
4910: ,p_task_id => l_task_id

Line 5439: and a.object_type_to = 'PA_TASKS'

5435: select b.object_id_to1 object_id_to1
5436: from pa_object_relationships a,
5437: pa_object_relationships b
5438: where a.object_id_to1 = p_task_version_id
5439: and a.object_type_to = 'PA_TASKS'
5440: and a.relationship_type = 'S' -- Bug # 4622939.
5441: and a.object_id_from1 = b.object_id_from1
5442: and a.object_type_from = b.object_type_from
5443: and b.object_type_to = 'PA_TASKS'

Line 5443: and b.object_type_to = 'PA_TASKS'

5439: and a.object_type_to = 'PA_TASKS'
5440: and a.relationship_type = 'S' -- Bug # 4622939.
5441: and a.object_id_from1 = b.object_id_from1
5442: and a.object_type_from = b.object_type_from
5443: and b.object_type_to = 'PA_TASKS'
5444: and b.relationship_type = 'S' -- Bug # 4622939.
5445: and b.object_id_to1 <> p_task_version_id;
5446: c_get_peer_tasks get_peer_tasks%ROWTYPE;
5447:

Line 5463: and object_type_to = 'PA_TASKS'

5459: CURSOR get_parent_version_id(c_elem_ver_id NUMBER) IS
5460: select object_id_from1
5461: from pa_object_relationships
5462: where object_id_to1 = c_elem_ver_id
5463: and object_type_to = 'PA_TASKS'
5464: and relationship_type = 'S';
5465: l_parent_ver_id NUMBER;
5466: l_error_msg_code VARCHAR2(30);
5467:

Line 5517: SELECT parent_task_id, top_task_id FROM pa_tasks

5513: l_old_parent_task_id NUMBER;
5514: l_top_task_id NUMBER;
5515:
5516: CURSOR get_parent_task_id( c_task_id NUMBER, c_project_id NUMBER ) IS
5517: SELECT parent_task_id, top_task_id FROM pa_tasks
5518: WHERE project_id = c_project_id and task_id = c_task_id;
5519:
5520: --End Bug 2947492 ( move )
5521: -- Merged from 85

Line 5542: and object_type_to = 'PA_TASKS'

5538: cursor get_child_ver_id(c_task_ver_id NUMBER) IS
5539: select object_id_to1
5540: from pa_object_relationships
5541: where relationship_type = 'S'
5542: and object_type_to = 'PA_TASKS'
5543: start with object_id_from1 = c_task_ver_id
5544: and object_type_from = 'PA_TASKS'
5545: connect by prior object_id_to1 = object_id_from1
5546: and prior object_type_to = object_type_from

Line 5544: and object_type_from = 'PA_TASKS'

5540: from pa_object_relationships
5541: where relationship_type = 'S'
5542: and object_type_to = 'PA_TASKS'
5543: start with object_id_from1 = c_task_ver_id
5544: and object_type_from = 'PA_TASKS'
5545: connect by prior object_id_to1 = object_id_from1
5546: and prior object_type_to = object_type_from
5547: and prior relationship_type = relationship_type
5548: UNION

Line 5561: and object_type_to = 'PA_TASKS'

5557: Cursor get_top_task_ver_id(c_task_ver_id NUMBER) IS
5558: select object_id_to1
5559: from pa_object_relationships
5560: where relationshiP_type = 'S'
5561: and object_type_to = 'PA_TASKS'
5562: start with object_id_to1 = c_task_ver_id
5563: and object_type_to = 'PA_TASKS'
5564: connect by prior object_id_from1 = object_id_to1
5565: and prior object_type_from = object_type_to

Line 5563: and object_type_to = 'PA_TASKS'

5559: from pa_object_relationships
5560: where relationshiP_type = 'S'
5561: and object_type_to = 'PA_TASKS'
5562: start with object_id_to1 = c_task_ver_id
5563: and object_type_to = 'PA_TASKS'
5564: connect by prior object_id_from1 = object_id_to1
5565: and prior object_type_from = object_type_to
5566: and prior relationship_type = relationship_type
5567: intersect

Line 5668: PA_TASKS_MAINT_UTILS.CHECK_MOVE_FINANCIAL_TASK_OK (

5664: -- Added for FP_M changes. Bug 3305199 : xxx
5665: If l_sharing_code = 'SHARE_PARTIAL' /*4269830 : Replaced function usage with l_sharing_code*/
5666: Then
5667:
5668: PA_TASKS_MAINT_UTILS.CHECK_MOVE_FINANCIAL_TASK_OK (
5669: p_task_version_id => p_task_version_id
5670: , p_ref_task_version_id => p_ref_task_version_id
5671: , x_return_status => x_return_status
5672: , x_msg_count => x_msg_count

Line 5785: WHERE object_type_to = 'PA_TASKS'

5781: -- get the parent of the task being moved
5782: SELECT object_id_from1, object_type_from
5783: INTO l_parent_id, l_parent_object_type
5784: FROM PA_OBJECT_RELATIONSHIPS
5785: WHERE object_type_to = 'PA_TASKS'
5786: AND object_id_to1 = p_task_version_id
5787: AND relationship_type = 'S'
5788: AND object_type_from in ('PA_STRUCTURES', 'PA_TASKS');
5789:

Line 5788: AND object_type_from in ('PA_STRUCTURES', 'PA_TASKS');

5784: FROM PA_OBJECT_RELATIONSHIPS
5785: WHERE object_type_to = 'PA_TASKS'
5786: AND object_id_to1 = p_task_version_id
5787: AND relationship_type = 'S'
5788: AND object_type_from in ('PA_STRUCTURES', 'PA_TASKS');
5789:
5790: --hsiu added, for dates rollup
5791: --need to get peer task before it has been moved.
5792: OPEN get_peer_tasks;

Line 6018: l_fin_task_flag := PA_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(l_proj_element_id); --bug 3301192 move in pa_tasks also if it exists there.

6014:
6015: IF l_fin_type = 'Y' -- 4269830 this is equivalent to cur_struc_type%FOUND
6016: THEN
6017:
6018: l_fin_task_flag := PA_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(l_proj_element_id); --bug 3301192 move in pa_tasks also if it exists there.
6019:
6020: IF (NVL( l_published_version, 'N' ) = 'N' AND l_fin_task_flag = 'Y') OR
6021: (l_published_version = 'Y' AND l_versioned = 'N' AND l_shared = 'Y' AND l_fin_task_flag = 'Y' )
6022: OR ((l_published_version = 'Y') AND (l_shared = 'N') AND (l_fin_task_flag = 'Y')) -- Bug # 5064340. -- To accomodate split financial tasks.

Line 6031: FROM PA_TASKS pt,

6027:
6028: --hsiu Fixed parent_structure_version_id condition
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

Line 6048: FROM pa_tasks

6044: SELECT record_version_number, parent_task_id --get old parent id for bug 2947492 (move )
6045: ,top_task_id --bug 2967204
6046: INTO l_record_version_number, l_old_parent_task_id
6047: ,l_old_top_task_id --bug 2967204
6048: FROM pa_tasks
6049: WHERE task_id = l_task_id
6050: AND project_id = l_project_id;
6051: -- merged from 85
6052:

Line 6057: PA_TASKS_MAINT_PUB.Move_Task(

6053: x_msg_count := FND_MSG_PUB.count_msg;
6054:
6055: --dbms_output.put_line( 'before move task old '|| x_msg_count );
6056:
6057: PA_TASKS_MAINT_PUB.Move_Task(
6058: p_reference_project_id => l_project_id
6059: ,p_reference_task_id => l_ref_task_id
6060: ,p_project_id => l_project_id
6061: ,p_task_id => l_task_id

Line 6064: ,p_wbs_record_version_number => 1 --temporarily passing 1. Lock project is commented out in PA_TASKS_MAIN_PUB.Move_Task api.

6060: ,p_project_id => l_project_id
6061: ,p_task_id => l_task_id
6062: ,p_peer_or_sub => p_peer_or_sub
6063: ,p_record_version_number => l_record_version_number
6064: ,p_wbs_record_version_number => 1 --temporarily passing 1. Lock project is commented out in PA_TASKS_MAIN_PUB.Move_Task api.
6065: ,x_return_status => l_return_status
6066: ,x_msg_count => l_msg_count
6067: ,x_msg_data => l_msg_data );
6068:

Line 6623: and object_type_to = 'PA_TASKS'

6619: CURSOR get_parent_version_id(c_elem_ver_id NUMBER) IS
6620: select object_id_from1
6621: from pa_object_relationships
6622: where object_id_to1 = c_elem_ver_id
6623: and object_type_to = 'PA_TASKS'
6624: and relationship_type = 'S';
6625: l_parent_ver_id NUMBER;
6626: l_error_msg_code VARCHAR2(30);
6627:

Line 6777: AND object_type = 'PA_TASKS'

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
6780: AND display_sequence =
6781: (SELECT max(display_sequence)

Line 6784: AND object_type = 'PA_TASKS'

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);
6787: --dbms_output.put_line( 'Indent Task Stage 8 ' );
6788:

Line 6928: FROM PA_TASKS pt,

6924: --end changes
6925:
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

Line 6942: FROM pa_tasks

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
6943: WHERE task_id = l_task_id
6944: AND project_id = l_project_id;
6945:
6946:

Line 6947: PA_TASKS_MAINT_PUB.Edit_Task_Structure(

6943: WHERE task_id = l_task_id
6944: AND project_id = l_project_id;
6945:
6946:
6947: PA_TASKS_MAINT_PUB.Edit_Task_Structure(
6948: p_project_id => l_project_id
6949: ,p_task_id => l_task_id
6950: ,p_edit_mode => 'INDENT'
6951: ,p_record_version_number => l_task_record_version_number

Line 7169: and a.object_type_to = 'PA_TASKS'

7165: select b.object_id_to1 object_id_to1
7166: from pa_object_relationships a,
7167: pa_object_relationships b
7168: where a.object_id_to1 = p_task_version_id
7169: and a.object_type_to = 'PA_TASKS'
7170: and a.object_id_from1 = b.object_id_from1
7171: and a.object_type_from = b.object_type_from
7172: and b.object_type_to = 'PA_TASKS'
7173: and b.object_id_to1 <> p_task_version_id;

Line 7172: and b.object_type_to = 'PA_TASKS'

7168: where a.object_id_to1 = p_task_version_id
7169: and a.object_type_to = 'PA_TASKS'
7170: and a.object_id_from1 = b.object_id_from1
7171: and a.object_type_from = b.object_type_from
7172: and b.object_type_to = 'PA_TASKS'
7173: and b.object_id_to1 <> p_task_version_id;
7174: c_get_peer_tasks get_peer_tasks%ROWTYPE;
7175:
7176: --Hsiu added, for dates rollup

Line 7186: and object_type_to = 'PA_TASKS'

7182: CURSOR get_parent_version_id(c_elem_ver_id NUMBER) IS
7183: select object_id_from1
7184: from pa_object_relationships
7185: where object_id_to1 = c_elem_ver_id
7186: and object_type_to = 'PA_TASKS'
7187: and relationship_type = 'S';
7188: l_parent_ver_id NUMBER;
7189: l_error_msg_code VARCHAR2(30);
7190: BEGIN

Line 7283: AND object_type = 'PA_TASKS'

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
7286: AND display_sequence =
7287: (SELECT max(display_sequence)

Line 7290: AND object_type = 'PA_TASKS'

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);
7293:
7294: --hsiu added for task status

Line 7409: FROM PA_TASKS pt,

7405: --end changes
7406:
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

Line 7423: FROM pa_tasks

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
7424: WHERE task_id = l_task_id
7425: AND project_id = l_project_id;
7426:
7427: PA_TASKS_MAINT_PUB.Edit_Task_Structure(

Line 7427: PA_TASKS_MAINT_PUB.Edit_Task_Structure(

7423: FROM pa_tasks
7424: WHERE task_id = l_task_id
7425: AND project_id = l_project_id;
7426:
7427: PA_TASKS_MAINT_PUB.Edit_Task_Structure(
7428: p_project_id => l_project_id
7429: ,p_task_id => l_task_id
7430: ,p_edit_mode => 'OUTDENT'
7431: ,p_record_version_number => l_task_record_version_number

Line 7656: AND object_type = 'PA_TASKS';

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
7659: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
7660:

Line 7679: and object_type_to = 'PA_TASKS'

7675: CURSOR get_parent_version_id(c_elem_ver_id NUMBER) IS
7676: select object_id_from1
7677: from pa_object_relationships
7678: where object_id_to1 = c_elem_ver_id
7679: and object_type_to = 'PA_TASKS'
7680: and relationship_type = 'S';
7681: l_parent_ver_id NUMBER;
7682: l_error_msg_code VARCHAR2(30);
7683: --end task version status changes

Line 7983: ,p_object_type => 'PA_TASKS'

7979: --3035902: end process update flag changes
7980:
7981: PA_TASK_PUB1.CREATE_TASK
7982: ( p_validate_only => FND_API.G_FALSE
7983: ,p_object_type => 'PA_TASKS'
7984: ,p_project_id => p_project_id
7985: ,p_ref_task_id => l_ref_proj_eleme_id
7986: ,p_peer_or_sub => l_peer_or_sub
7987: ,p_structure_id => p_structure_id

Line 8450: AND object_type_to = 'PA_TASKS'

8446: IS
8447: SELECT count(object_id_to1)
8448: FROM PA_OBJECT_RELATIONSHIPS
8449: WHERE object_id_from1 = c_parent_element_version_id
8450: AND object_type_to = 'PA_TASKS'
8451: AND relationship_type = 'S'
8452: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');
8453:
8454: CURSOR get_summed_duration(c_parent_element_version_id NUMBER)

Line 8452: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');

8448: FROM PA_OBJECT_RELATIONSHIPS
8449: WHERE object_id_from1 = c_parent_element_version_id
8450: AND object_type_to = 'PA_TASKS'
8451: AND relationship_type = 'S'
8452: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');
8453:
8454: CURSOR get_summed_duration(c_parent_element_version_id NUMBER)
8455: IS
8456: SELECT sum(ppevs.duration)

Line 8463: AND por.object_type_to = 'PA_TASKS'

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'
8464: AND por.relationship_type = 'S'
8465: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
8466: AND por.object_id_to1 = ppevs.element_version_id
8467: AND por.object_id_to1 = ppev.element_version_id

Line 8465: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

8461: pa_task_types ptt
8462: WHERE por.object_id_from1 = c_parent_element_version_id
8463: AND por.object_type_to = 'PA_TASKS'
8464: AND por.relationship_type = 'S'
8465: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
8466: AND por.object_id_to1 = ppevs.element_version_id
8467: AND por.object_id_to1 = ppev.element_version_id
8468: AND ppev.proj_element_id = ppe.proj_element_id
8469: AND ppe.project_id = ppevs.project_id /* for bug 2822963 */

Line 8471: AND ptt.object_type = 'PA_TASKS' /* for bug 3279978 FP M Enhancement */

8467: AND por.object_id_to1 = ppev.element_version_id
8468: AND ppev.proj_element_id = ppe.proj_element_id
8469: AND ppe.project_id = ppevs.project_id /* for bug 2822963 */
8470: AND ppe.TYPE_ID = ptt.task_type_id
8471: AND ptt.object_type = 'PA_TASKS' /* for bug 3279978 FP M Enhancement */
8472: AND ptt.prog_entry_enable_flag = 'Y';
8473:
8474: CURSOR get_task_duration(c_element_version_id NUMBER,c_project_id NUMBER)
8475: IS

Line 8486: AND object_type_to = 'PA_TASKS'

8482: IS
8483: SELECT object_id_from1
8484: FROM pa_object_relationships
8485: WHERE object_id_to1 = c_element_version_id
8486: AND object_type_to = 'PA_TASKS'
8487: AND relationship_type = 'S'
8488: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');
8489:
8490: CURSOR check_progress_allowed(c_element_version_id NUMBER)

Line 8488: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');

8484: FROM pa_object_relationships
8485: WHERE object_id_to1 = c_element_version_id
8486: AND object_type_to = 'PA_TASKS'
8487: AND relationship_type = 'S'
8488: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');
8489:
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 */

Line 8498: AND ptt.object_type = 'PA_TASKS' /* for bug 3279978 FP M Enhancement */

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 */
8499: AND ppe.TYPE_ID = ptt.task_type_id;
8500:
8501: CURSOR get_existing_weights(c_parent_element_version_id NUMBER)
8502: IS

Line 8506: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

8502: IS
8503: SELECT sum(weighting_percentage)
8504: FROM PA_OBJECT_RELATIONSHIPS
8505: WHERE object_id_from1 = c_parent_element_version_id
8506: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
8507: AND object_type_to = 'PA_TASKS'
8508: AND relationship_type = 'S';
8509:
8510: -- Bug 3098574. This cursor gives the number of progressible tasks

Line 8507: AND object_type_to = 'PA_TASKS'

8503: SELECT sum(weighting_percentage)
8504: FROM PA_OBJECT_RELATIONSHIPS
8505: WHERE object_id_from1 = c_parent_element_version_id
8506: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
8507: AND object_type_to = 'PA_TASKS'
8508: AND relationship_type = 'S';
8509:
8510: -- Bug 3098574. This cursor gives the number of progressible tasks
8511: -- under a parent. This count will be used to pro-rate the task weightage

Line 8518: AND rel.object_type_to = 'PA_TASKS'

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')
8521: AND rel.object_id_to1 = ver.element_version_id
8522: AND ver.proj_element_id = ele.proj_element_id

Line 8520: AND rel.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

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')
8521: AND rel.object_id_to1 = ver.element_version_id
8522: AND ver.proj_element_id = ele.proj_element_id
8523: AND ele.type_id = tt.task_type_id
8524: AND tt.object_type = 'PA_TASKS' /* for bug 3279978 FP M Enhancement */

Line 8524: AND tt.object_type = 'PA_TASKS' /* for bug 3279978 FP M Enhancement */

8520: AND rel.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
8521: AND rel.object_id_to1 = ver.element_version_id
8522: AND ver.proj_element_id = ele.proj_element_id
8523: AND ele.type_id = tt.task_type_id
8524: AND tt.object_type = 'PA_TASKS' /* for bug 3279978 FP M Enhancement */
8525: AND tt.prog_entry_enable_flag = 'Y';
8526:
8527: l_progressible_child_count NUMBER; -- Bug 3098574.
8528:

Line 8614: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

8610: UPDATE PA_OBJECT_RELATIONSHIPS
8611: SET weighting_percentage = 0
8612: WHERE object_id_from1 = l_parent_element_version_id
8613: AND object_id_to1 = l_element_version_id
8614: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
8615: AND object_type_to = 'PA_TASKS'
8616: AND relationship_type = 'S';
8617: elsif l_outline_level = 1 then
8618: if l_is_sub_new is NULL then

Line 8615: AND object_type_to = 'PA_TASKS'

8611: SET weighting_percentage = 0
8612: WHERE object_id_from1 = l_parent_element_version_id
8613: AND object_id_to1 = l_element_version_id
8614: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
8615: AND object_type_to = 'PA_TASKS'
8616: AND relationship_type = 'S';
8617: elsif l_outline_level = 1 then
8618: if l_is_sub_new is NULL then
8619: -- Determine whether there we any existing tasks for this level before

Line 8639: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

8635: UPDATE PA_OBJECT_RELATIONSHIPS
8636: SET weighting_percentage = 0
8637: WHERE object_id_from1 = l_parent_element_version_id
8638: AND object_id_to1 = l_element_version_id
8639: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
8640: AND object_type_to = 'PA_TASKS'
8641: AND relationship_type = 'S';
8642: else
8643: -- There were no existing tasks at this level, populate

Line 8640: AND object_type_to = 'PA_TASKS'

8636: SET weighting_percentage = 0
8637: WHERE object_id_from1 = l_parent_element_version_id
8638: AND object_id_to1 = l_element_version_id
8639: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
8640: AND object_type_to = 'PA_TASKS'
8641: AND relationship_type = 'S';
8642: else
8643: -- There were no existing tasks at this level, populate
8644: -- the correct task weight

Line 8655: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

8651: UPDATE PA_OBJECT_RELATIONSHIPS
8652: SET weighting_percentage = 0
8653: WHERE object_id_from1 = l_parent_element_version_id
8654: AND object_id_to1 = l_element_version_id
8655: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
8656: AND object_type_to = 'PA_TASKS'
8657: AND relationship_type = 'S';
8658: else
8659:

Line 8656: AND object_type_to = 'PA_TASKS'

8652: SET weighting_percentage = 0
8653: WHERE object_id_from1 = l_parent_element_version_id
8654: AND object_id_to1 = l_element_version_id
8655: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
8656: AND object_type_to = 'PA_TASKS'
8657: AND relationship_type = 'S';
8658: else
8659:
8660: if l_durations.exists(l_parent_element_version_id) then

Line 8795: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

8791: UPDATE PA_OBJECT_RELATIONSHIPS
8792: SET weighting_percentage = l_task_weight
8793: WHERE object_id_from1 = l_parent_element_version_id
8794: AND object_id_to1 = l_element_version_id
8795: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
8796: AND object_type_to = 'PA_TASKS'
8797: AND relationship_type = 'S';
8798: end if;
8799: end if;

Line 8796: AND object_type_to = 'PA_TASKS'

8792: SET weighting_percentage = l_task_weight
8793: WHERE object_id_from1 = l_parent_element_version_id
8794: AND object_id_to1 = l_element_version_id
8795: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
8796: AND object_type_to = 'PA_TASKS'
8797: AND relationship_type = 'S';
8798: end if;
8799: end if;
8800: else

Line 8813: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

8809: UPDATE PA_OBJECT_RELATIONSHIPS
8810: SET weighting_percentage = 0
8811: WHERE object_id_from1 = l_parent_element_version_id
8812: AND object_id_to1 = l_element_version_id
8813: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
8814: AND object_type_to = 'PA_TASKS'
8815: AND relationship_type = 'S';
8816: else
8817:

Line 8814: AND object_type_to = 'PA_TASKS'

8810: SET weighting_percentage = 0
8811: WHERE object_id_from1 = l_parent_element_version_id
8812: AND object_id_to1 = l_element_version_id
8813: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
8814: AND object_type_to = 'PA_TASKS'
8815: AND relationship_type = 'S';
8816: else
8817:
8818: if l_durations.exists(l_parent_element_version_id) then

Line 8954: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

8950: UPDATE PA_OBJECT_RELATIONSHIPS
8951: SET weighting_percentage = l_task_weight
8952: WHERE object_id_from1 = l_parent_element_version_id
8953: AND object_id_to1 = l_element_version_id
8954: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
8955: AND object_type_to = 'PA_TASKS'
8956: AND relationship_type = 'S';
8957: end if;
8958: end if;

Line 8955: AND object_type_to = 'PA_TASKS'

8951: SET weighting_percentage = l_task_weight
8952: WHERE object_id_from1 = l_parent_element_version_id
8953: AND object_id_to1 = l_element_version_id
8954: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
8955: AND object_type_to = 'PA_TASKS'
8956: AND relationship_type = 'S';
8957: end if;
8958: end if;
8959:

Line 9119: AND object_type_to = 'PA_TASKS'

9115: CURSOR get_parent_version_id(c_elem_ver_id NUMBER) IS
9116: SELECT object_id_from1
9117: FROM pa_object_relationships
9118: WHERE object_id_to1 = c_elem_ver_id
9119: AND object_type_to = 'PA_TASKS'
9120: AND relationship_type = 'S';
9121:
9122: CURSOR cur_obj_rel( p_child_version_id NUMBER ) IS
9123: SELECT object_id_from1

Line 9138: AND a.object_type_to = 'PA_TASKS'

9134: SELECT a.object_id_from1
9135: , a.weighting_percentage
9136: FROM pa_object_relationships a
9137: WHERE a.object_id_to1 = c_task_version_id
9138: AND a.object_type_to = 'PA_TASKS'
9139: AND a.relationship_type = 'S'
9140: AND a.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');
9141:
9142: CURSOR get_sub_tasks(c_task_version_id NUMBER) IS

Line 9140: AND a.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');

9136: FROM pa_object_relationships a
9137: WHERE a.object_id_to1 = c_task_version_id
9138: AND a.object_type_to = 'PA_TASKS'
9139: AND a.relationship_type = 'S'
9140: AND a.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');
9141:
9142: CURSOR get_sub_tasks(c_task_version_id NUMBER) IS
9143: SELECT '1'
9144: FROM dual

Line 9149: AND object_type_from IN ('PA_TASKS', 'PA_STRUCTURES')

9145: WHERE EXISTS
9146: (SELECT 'xyz'
9147: FROM pa_object_relationships
9148: WHERE object_id_from1 = c_task_version_id
9149: AND object_type_from IN ('PA_TASKS', 'PA_STRUCTURES')
9150: AND relationship_type = 'S'
9151: );
9152:
9153: CURSOR check_progress_allowed(c_element_version_id NUMBER) IS

Line 9160: AND ptt.object_type = 'PA_TASKS' /* for bug 3279978 FP M Enhancement */

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 */
9161: AND ppe.TYPE_ID = ptt.task_type_id;
9162:
9163:
9164:

Line 9250: and object_type ='PA_TASKS';

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
9253: l_delete_project_allowed VARCHAR2(1);
9254: l_update_proj_num_allowed VARCHAR2(1);

Line 9300: SELECT parent_task_id, top_task_id FROM pa_tasks

9296: l_top_task_id NUMBER;
9297: l_old_top_task_id NUMBER; --bug 2967204
9298:
9299: CURSOR get_parent_task_id( c_task_id NUMBER, c_project_id NUMBER ) IS
9300: SELECT parent_task_id, top_task_id FROM pa_tasks
9301: WHERE project_id = c_project_id and task_id = c_task_id;
9302:
9303: --End Bug 2947492 ( indent )
9304: -- Merged from 85

Line 9325: and object_type_to = 'PA_TASKS'

9321: Cursor get_top_task_ver_id(c_task_ver_id NUMBER) IS
9322: select object_id_to1
9323: from pa_object_relationships
9324: where relationshiP_type = 'S'
9325: and object_type_to = 'PA_TASKS'
9326: start with object_id_to1 = c_task_ver_id
9327: and object_type_to = 'PA_TASKS'
9328: and relationship_type = 'S'
9329: connect by prior object_id_from1 = object_id_to1

Line 9327: and object_type_to = 'PA_TASKS'

9323: from pa_object_relationships
9324: where relationshiP_type = 'S'
9325: and object_type_to = 'PA_TASKS'
9326: start with object_id_to1 = c_task_ver_id
9327: and object_type_to = 'PA_TASKS'
9328: and relationship_type = 'S'
9329: connect by prior object_id_from1 = object_id_to1
9330: and prior object_type_from = object_type_to
9331: and prior relationship_type = relationship_type

Line 9361: AND object_type = 'PA_TASKS'

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'
9362: AND display_sequence < src_seq_number
9363: AND display_sequence =
9364: (SELECT max (display_sequence)
9365: FROM pa_proj_element_versions

Line 9370: AND object_type = 'PA_TASKS');

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
9370: AND object_type = 'PA_TASKS');
9371: --bug 4214825, end
9372:
9373: BEGIN
9374:

Line 9505: AND object_type = 'PA_TASKS';

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';
9506:
9507: IF src_wbs_level > ref_wbs_level then
9508: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
9509: ,p_msg_name => 'PA_PS_CANNOT_INDENT');

Line 9527: AND object_type = 'PA_TASKS'

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'
9528: AND display_sequence < src_seq_number
9529: AND display_sequence =
9530: (SELECT max (display_sequence)
9531: FROM pa_proj_element_versions

Line 9536: AND object_type = 'PA_TASKS');

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
9536: AND object_type = 'PA_TASKS');
9537:
9538: --bug 4214825, start
9539: OPEN cur_get_ref_tsk_ver_id(src_wbs_level);
9540: FETCH cur_get_ref_tsk_ver_id INTO l_ref_tsk_version_id;

Line 9558: AND object_type = 'PA_TASKS'

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'
9559: AND display_sequence < src_seq_number
9560: AND display_sequence =
9561: (SELECT max (display_sequence)
9562: FROM pa_proj_element_versions

Line 9567: AND object_type = 'PA_TASKS');

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
9567: AND object_type = 'PA_TASKS');
9568: EXCEPTION
9569: WHEN OTHERS THEN
9570: raise;
9571: END;

Line 9688: PA_TASKS_MAINT_UTILS.CHECK_MOVE_FINANCIAL_TASK_OK (

9684: If PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_project_id)
9685: IN ('SHARE_PARTIAL')
9686: Then
9687:
9688: PA_TASKS_MAINT_UTILS.CHECK_MOVE_FINANCIAL_TASK_OK (
9689: p_task_version_id => p_task_version_id
9690: , p_ref_task_version_id => ref_elem_ver_id
9691: , x_return_status => x_return_status
9692: , x_msg_count => x_msg_count

Line 9778: AND object_type = 'PA_TASKS'

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'
9779: AND(
9780: element_version_id = p_task_version_id -- Source task itself
9781: OR (element_version_id IN -- All tasks below the source task with wbs_level >= src_wbs_level-1
9782: (select object_id_to1

Line 9785: and object_type_to = 'PA_TASKS'

9781: OR (element_version_id IN -- All tasks below the source task with wbs_level >= src_wbs_level-1
9782: (select object_id_to1
9783: from pa_object_relationships
9784: where relationship_type = 'S'
9785: and object_type_to = 'PA_TASKS'
9786: start with object_id_from1 = l_ref_parent_ver_id
9787: connect by object_id_from1 = PRIOR object_id_to1
9788: and relationship_type = PRIOR relationship_type
9789: and relationship_type = 'S')

Line 9924: IF ref_object_type = 'PA_TASKS'

9920:
9921:
9922: -- Update Relationship
9923:
9924: IF ref_object_type = 'PA_TASKS'
9925: THEN
9926: IF l_peer_or_sub = 'PEER'
9927: THEN
9928: OPEN cur_obj_rel( ref_elem_ver_id );

Line 9950: END IF; -- ref_object_type = 'PA_TASKS'

9946: l_relationship_subtype := 'TASK_TO_TASK';
9947:
9948:
9949: END IF;
9950: END IF; -- ref_object_type = 'PA_TASKS'
9951: -- No need to check for PA_STRUCTURES as this is indent and you can not indent below a structure
9952:
9953:
9954: --update relatonship of the task version p_task_version.

Line 10109: l_fin_task_flag := PA_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(src_proj_element_id); --indent in corresponding task in pa_tasks

10105: l_project_id);
10106: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
10107: l_project_id);
10108:
10109: l_fin_task_flag := PA_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(src_proj_element_id); --indent in corresponding task in pa_tasks
10110:
10111: IF (NVL( l_published_version, 'N' ) = 'N' AND l_fin_task_flag = 'Y' ) OR
10112: (l_published_version = 'Y' AND l_versioned = 'N' AND l_shared = 'Y' AND l_fin_task_flag = 'Y' )
10113: OR ((l_published_version = 'Y') AND (l_shared = 'N') AND (l_fin_task_flag = 'Y')) -- Bug # 5064340. -- To accomodate split financial tasks.

Line 10118: FROM PA_TASKS pt,

10114: THEN
10115:
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

Line 10131: FROM pa_tasks

10127: SELECT record_version_number, parent_task_id --get old parent id for bug 2947492 (indent )
10128: ,top_task_id --bug 2967204
10129: INTO l_task_record_version_number, l_old_parent_task_id
10130: ,l_old_top_task_id --bug 2967204
10131: FROM pa_tasks
10132: WHERE task_id = l_task_id
10133: AND project_id = l_project_id;
10134: -- Merged from 85
10135:

Line 10137: PA_TASKS_MAINT_PUB.Edit_Task_Structure(

10133: AND project_id = l_project_id;
10134: -- Merged from 85
10135:
10136:
10137: PA_TASKS_MAINT_PUB.Edit_Task_Structure(
10138: p_project_id => l_project_id
10139: ,p_task_id => l_task_id
10140: ,p_edit_mode => 'INDENT'
10141: ,p_record_version_number => l_task_record_version_number

Line 10587: AND object_type_to = 'PA_TASKS'

10583: CURSOR get_parent_version_id(c_elem_ver_id NUMBER) IS
10584: SELECT object_id_from1
10585: FROM pa_object_relationships
10586: WHERE object_id_to1 = c_elem_ver_id
10587: AND object_type_to = 'PA_TASKS'
10588: AND relationship_type = 'S';
10589:
10590: CURSOR cur_obj_rel( p_child_version_id NUMBER ) IS
10591: SELECT object_id_from1

Line 10606: AND a.object_type_to = 'PA_TASKS'

10602: SELECT a.object_id_from1
10603: , a.weighting_percentage
10604: FROM pa_object_relationships a
10605: WHERE a.object_id_to1 = c_task_version_id
10606: AND a.object_type_to = 'PA_TASKS'
10607: AND a.relationship_type = 'S'
10608: AND a.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');
10609:
10610: CURSOR get_sub_tasks(c_task_version_id NUMBER) IS

Line 10608: AND a.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');

10604: FROM pa_object_relationships a
10605: WHERE a.object_id_to1 = c_task_version_id
10606: AND a.object_type_to = 'PA_TASKS'
10607: AND a.relationship_type = 'S'
10608: AND a.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');
10609:
10610: CURSOR get_sub_tasks(c_task_version_id NUMBER) IS
10611: SELECT '1'
10612: FROM dual

Line 10617: AND object_type_from IN ('PA_TASKS', 'PA_STRUCTURES')

10613: WHERE EXISTS
10614: (SELECT 'xyz'
10615: FROM pa_object_relationships
10616: WHERE object_id_from1 = c_task_version_id
10617: AND object_type_from IN ('PA_TASKS', 'PA_STRUCTURES')
10618: AND relationship_type = 'S'
10619: );
10620:
10621: CURSOR check_progress_allowed(c_element_version_id NUMBER) IS

Line 10635: AND a.object_type_to = 'PA_TASKS'

10631: SELECT b.object_id_to1 object_id_to1
10632: FROM pa_object_relationships a
10633: , pa_object_relationships b
10634: WHERE a.object_id_to1 = p_task_version_id
10635: AND a.object_type_to = 'PA_TASKS'
10636: AND a.object_id_from1 = b.object_id_from1
10637: AND a.object_type_from = b.object_type_from
10638: AND b.object_type_to = 'PA_TASKS'
10639: AND b.object_id_to1 <> p_task_version_id

Line 10638: AND b.object_type_to = 'PA_TASKS'

10634: WHERE a.object_id_to1 = p_task_version_id
10635: AND a.object_type_to = 'PA_TASKS'
10636: AND a.object_id_from1 = b.object_id_from1
10637: AND a.object_type_from = b.object_type_from
10638: AND b.object_type_to = 'PA_TASKS'
10639: AND b.object_id_to1 <> p_task_version_id
10640: AND a.relationship_type = 'S'
10641: AND b.relationship_type = 'S';
10642:

Line 10752: and object_type ='PA_TASKS';

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);
10755:
10756: -- hyau Bug 2852753

Line 10808: FROM pa_tasks

10804:
10805: CURSOR get_parent_task_id( c_task_id NUMBER, c_project_id NUMBER )
10806: IS
10807: SELECT parent_task_id, top_task_id
10808: FROM pa_tasks
10809: WHERE project_id = c_project_id
10810: AND task_id = c_task_id;
10811:
10812: CURSOR cur_new_child_task( c_project_id NUMBER, c_wbs_level NUMBER,

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 10823: AND object_type = 'PA_TASKS'

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:
10826: --For financial tasks we can directly join with pa_proj-element_version using proj_element_id
10827: --bcoz this api will be called as long as there is only one version for financial otherwise

Line 10852: and object_type_to = 'PA_TASKS'

10848: Cursor get_top_task_ver_id(c_task_ver_id NUMBER) IS
10849: select object_id_to1
10850: from pa_object_relationships
10851: where relationshiP_type = 'S'
10852: and object_type_to = 'PA_TASKS'
10853: start with object_id_to1 = c_task_ver_id
10854: and object_type_to = 'PA_TASKS'
10855: and relationship_type = 'S'
10856: connect by prior object_id_from1 = object_id_to1

Line 10854: and object_type_to = 'PA_TASKS'

10850: from pa_object_relationships
10851: where relationshiP_type = 'S'
10852: and object_type_to = 'PA_TASKS'
10853: start with object_id_to1 = c_task_ver_id
10854: and object_type_to = 'PA_TASKS'
10855: and relationship_type = 'S'
10856: connect by prior object_id_from1 = object_id_to1
10857: and prior object_type_from = object_type_to
10858: and prior relationship_type = relationship_type

Line 11011: AND object_type = 'PA_TASKS'

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'
11012: AND display_sequence =
11013: (SELECT max (display_sequence)
11014: FROM pa_proj_element_versions
11015: WHERE project_id = p_project_id

Line 11019: AND object_type = 'PA_TASKS');

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
11019: AND object_type = 'PA_TASKS');
11020: EXCEPTION
11021: WHEN OTHERS THEN
11022: raise;
11023: -- It will never return NO_DATA_FOUND as there will always at least one task with wbs_level-1

Line 11121: PA_TASKS_MAINT_UTILS.CHECK_MOVE_FINANCIAL_TASK_OK (

11117: If PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_project_id)
11118: IN ('SHARE_PARTIAL')
11119: Then
11120:
11121: PA_TASKS_MAINT_UTILS.CHECK_MOVE_FINANCIAL_TASK_OK (
11122: p_task_version_id => p_task_version_id
11123: , p_ref_task_version_id => ref_elem_ver_id
11124: , x_return_status => x_return_status
11125: , x_msg_count => x_msg_count

Line 11203: AND object_type = 'PA_TASKS'

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'
11204: AND(
11205: element_version_id = p_task_version_id -- Source task itself
11206: OR element_version_id IN -- All tasks below the source task
11207: (select object_id_to1

Line 11210: and object_type_to = 'PA_TASKS'

11206: OR element_version_id IN -- All tasks below the source task
11207: (select object_id_to1
11208: from pa_object_relationships
11209: where relationship_type = 'S'
11210: and object_type_to = 'PA_TASKS'
11211: start with object_id_from1 = l_ref_parent_ver_id
11212: connect by object_id_from1 = PRIOR object_id_to1
11213: and relationship_type = prior relationship_type
11214: and relationship_type = 'S')

Line 11428: IF ref_object_type = 'PA_TASKS'

11424:
11425:
11426: -- Update Relationship
11427:
11428: IF ref_object_type = 'PA_TASKS'
11429: THEN
11430: IF l_peer_or_sub = 'PEER'
11431: THEN
11432: OPEN cur_obj_rel( ref_elem_ver_id );

Line 11464: END IF; -- ref_object_type = 'PA_TASKS'

11460: THEN
11461: l_struc_version_from := ref_elem_ver_id;
11462: l_task_version_from := null;
11463: l_relationship_subtype := 'STRUCTURE_TO_TASK';
11464: END IF; -- ref_object_type = 'PA_TASKS'
11465:
11466:
11467: --update relatonship of the task version p_task_version.
11468: --set structure_version_from and task_version_from accordingly.

Line 11690: l_fin_task_flag := PA_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(src_proj_element_id); --outdent in corresponding task in pa_tasks

11686: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
11687: l_project_id);
11688:
11689: --o IF (NVL( l_published_version, 'N' ) = 'N') OR (l_published_version = 'Y' AND l_versioned = 'N' AND l_shared = 'Y') THEN
11690: l_fin_task_flag := PA_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(src_proj_element_id); --outdent in corresponding task in pa_tasks
11691:
11692: IF (NVL( l_published_version, 'N' ) = 'N' AND l_fin_task_flag = 'Y' ) OR
11693: (l_published_version = 'Y' AND l_versioned = 'N' AND l_shared = 'Y' AND l_fin_task_flag = 'Y' )
11694: OR ((l_published_version = 'Y') AND (l_shared = 'N') AND (l_fin_task_flag = 'Y')) -- Bug # 5064340. -- To accomodate split financial tasks.

Line 11699: FROM PA_TASKS pt,

11695: THEN
11696:
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

Line 11712: FROM pa_tasks

11708: SELECT record_version_number, parent_task_id, wbs_level --get old parent id for bug 2947492 (outdent )
11709: ,top_task_id
11710: INTO l_task_record_version_number, l_old_parent_task_id, l_old_wbs_level
11711: ,l_old_top_task_id
11712: FROM pa_tasks
11713: WHERE task_id = l_task_id
11714: AND project_id = l_project_id;
11715: -- Merged from 85
11716:

Line 11770: PA_TASKS_MAINT_PUB.Edit_Task_Structure(

11766: */ ---commenitng out, please check venkatesh mail dated 22 jan 04
11767:
11768: -- Merged from 85
11769:
11770: PA_TASKS_MAINT_PUB.Edit_Task_Structure(
11771: p_project_id => l_project_id
11772: ,p_task_id => l_task_id
11773: ,p_edit_mode => 'OUTDENT'
11774: ,p_record_version_number => l_task_record_version_number

Line 12450: l_type_to := 'PA_TASKS';

12446: l_type_to := 'PA_PROJECTS';
12447: l_id_to := p_associated_project_id;
12448:
12449: IF p_associated_task_id is not NULL THEN
12450: l_type_to := 'PA_TASKS';
12451: l_id_to := p_associated_task_id;
12452: END IF;
12453:
12454: -- when creating a new relationship check both ids and object types

Line 12460: IF p_task_id = l_id_to and l_type_to = 'PA_TASKS' then

12456: IF p_task_id is NULL or l_id_to is NULL THEN
12457: x_return_status := FND_API.G_RET_STS_ERROR;
12458: l_error_msg_code:= 'PA_PS_TASK_NUMBER_NULL';
12459: ELSE
12460: IF p_task_id = l_id_to and l_type_to = 'PA_TASKS' then
12461: x_return_status := FND_API.G_RET_STS_ERROR;
12462: l_error_msg_code:= 'PA_TASK_ID_INVALID';
12463: END IF;
12464: END IF;

Line 12469: IF p_task_id = l_id_to and l_type_to = 'PA_TASKS' then

12465: END IF;
12466:
12467: -- when updating an existing relationship check both ids and object types
12468: IF p_relationship_id is not null and l_id_to is not null THEN
12469: IF p_task_id = l_id_to and l_type_to = 'PA_TASKS' then
12470: x_return_status := FND_API.G_RET_STS_ERROR;
12471: l_error_msg_code:= 'PA_TASK_ID_INVALID';
12472: END IF;
12473: END IF;

Line 12484: ,p_object_type_from => 'PA_TASKS'

12480: -- Create a new association row
12481: IF p_relationship_id is NULL and x_return_status = FND_API.G_RET_STS_SUCCESS THEN
12482: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
12483: p_user_id => FND_GLOBAL.USER_ID
12484: ,p_object_type_from => 'PA_TASKS'
12485: ,p_object_id_from1 => p_task_id
12486: ,p_object_id_from2 => NULL
12487: ,p_object_id_from3 => NULL
12488: ,p_object_id_from4 => NULL

Line 12516: --AND object_type_from = 'PA_TASKS'

12512: SET object_id_to1 = l_id_to
12513: ,object_type_to = l_type_to
12514: WHERE object_relationship_id = p_relationship_id;
12515: --WHERE object_id_from1 = p_task_id
12516: --AND object_type_from = 'PA_TASKS'
12517: --AND relationship_type = 'A';
12518: END IF;
12519:
12520: IF p_relationship_id is not null and l_id_to is null THEN

Line 12598: AND ( (object_type_from = 'PA_TASKS' AND object_id_from1 = p_task_id)

12594: IS
12595: SELECT object_relationship_id
12596: FROM PA_OBJECT_RELATIONSHIPS
12597: WHERE relationship_type = p_relationship_type
12598: AND ( (object_type_from = 'PA_TASKS' AND object_id_from1 = p_task_id)
12599: OR (object_type_to = 'PA_TASKS' AND object_id_to1 = p_task_id));
12600:
12601: l_data VARCHAR2(250);
12602: l_msg_index_out NUMBER;

Line 12599: OR (object_type_to = 'PA_TASKS' AND object_id_to1 = p_task_id));

12595: SELECT object_relationship_id
12596: FROM PA_OBJECT_RELATIONSHIPS
12597: WHERE relationship_type = p_relationship_type
12598: AND ( (object_type_from = 'PA_TASKS' AND object_id_from1 = p_task_id)
12599: OR (object_type_to = 'PA_TASKS' AND object_id_to1 = p_task_id));
12600:
12601: l_data VARCHAR2(250);
12602: l_msg_index_out NUMBER;
12603:

Line 12735: AND ( (object_type_from = 'PA_TASKS' AND object_id_from1 = p_task_id

12731: cursor relationship_exists(p_task_id NUMBER) IS
12732: select '1'
12733: from pa_object_relationships
12734: WHERE relationship_type = p_relationship_type
12735: AND ( (object_type_from = 'PA_TASKS' AND object_id_from1 = p_task_id
12736: AND object_type_to in ( 'PA_STRUCTURES', 'PA_TASKS')) --bug 4091647
12737: OR (object_type_to = 'PA_TASKS' AND object_id_to1 = p_task_id
12738: AND object_type_from = 'PA_TASKS')); --bug 4091647
12739: l_dummy_char VARCHAR2(1);

Line 12736: AND object_type_to in ( 'PA_STRUCTURES', 'PA_TASKS')) --bug 4091647

12732: select '1'
12733: from pa_object_relationships
12734: WHERE relationship_type = p_relationship_type
12735: AND ( (object_type_from = 'PA_TASKS' AND object_id_from1 = p_task_id
12736: AND object_type_to in ( 'PA_STRUCTURES', 'PA_TASKS')) --bug 4091647
12737: OR (object_type_to = 'PA_TASKS' AND object_id_to1 = p_task_id
12738: AND object_type_from = 'PA_TASKS')); --bug 4091647
12739: l_dummy_char VARCHAR2(1);
12740:

Line 12737: OR (object_type_to = 'PA_TASKS' AND object_id_to1 = p_task_id

12733: from pa_object_relationships
12734: WHERE relationship_type = p_relationship_type
12735: AND ( (object_type_from = 'PA_TASKS' AND object_id_from1 = p_task_id
12736: AND object_type_to in ( 'PA_STRUCTURES', 'PA_TASKS')) --bug 4091647
12737: OR (object_type_to = 'PA_TASKS' AND object_id_to1 = p_task_id
12738: AND object_type_from = 'PA_TASKS')); --bug 4091647
12739: l_dummy_char VARCHAR2(1);
12740:
12741: BEGIN

Line 12738: AND object_type_from = 'PA_TASKS')); --bug 4091647

12734: WHERE relationship_type = p_relationship_type
12735: AND ( (object_type_from = 'PA_TASKS' AND object_id_from1 = p_task_id
12736: AND object_type_to in ( 'PA_STRUCTURES', 'PA_TASKS')) --bug 4091647
12737: OR (object_type_to = 'PA_TASKS' AND object_id_to1 = p_task_id
12738: AND object_type_from = 'PA_TASKS')); --bug 4091647
12739: l_dummy_char VARCHAR2(1);
12740:
12741: BEGIN
12742: OPEN relationship_exists(p_task_id);

Line 12764: AND object_type_from = 'PA_TASKS'

12760: cursor relationship_exists(p_project_id NUMBER) IS
12761: select '1'
12762: from pa_object_relationships
12763: WHERE relationship_type = p_relationship_type
12764: AND object_type_from = 'PA_TASKS'
12765: AND object_type_to = 'PA_PROJECTS' AND object_id_to1 = p_project_id;
12766:
12767: l_dummy_char VARCHAR2(1);
12768:

Line 12852: AND object_type_from = 'PA_TASKS'

12848: IS
12849: SELECT object_relationship_id
12850: FROM PA_OBJECT_RELATIONSHIPS
12851: WHERE relationship_type = p_relationship_type
12852: AND object_type_from = 'PA_TASKS'
12853: AND object_type_to = 'PA_PROJECTS' AND object_id_to1 = p_project_id;
12854:
12855: l_data VARCHAR2(250);
12856: l_msg_index_out NUMBER;

Line 12965: where object_type_from = 'PA_TASKS'

12961: CURSOR task_association( task_id NUMBER, p_relationship_type VARCHAR2 )
12962: IS
12963: Select object_type_to, object_id_to1
12964: from pa_object_relationships
12965: where object_type_from = 'PA_TASKS'
12966: and object_id_from1 = task_id
12967: and relationship_type = p_relationship_type;
12968:
12969: l_object_type_to pa_object_relationships.object_type_to%Type;

Line 13002: ,p_object_type_from => 'PA_TASKS'

12998: IF task_association%found THEN
12999:
13000: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
13001: p_user_id => FND_GLOBAL.USER_ID
13002: ,p_object_type_from => 'PA_TASKS'
13003: ,p_object_id_from1 => task_list_rec.new_task_id
13004: ,p_object_id_from2 => NULL
13005: ,p_object_id_from3 => NULL
13006: ,p_object_id_from4 => NULL

Line 13200: p_object_type IN VARCHAR2 := 'PA_TASKS',

13196: p_project_id IN NUMBER,
13197: p_planned_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
13198: p_ETC_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
13199: p_structure_version_id IN NUMBER,
13200: p_object_type IN VARCHAR2 := 'PA_TASKS',
13201: p_etc_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
13202: p_actual_effort IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
13203: p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
13204: p_res_assign_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

Line 13236: and ppr.object_type in ('PA_TASKS','PA_ASSIGNMENTS','PA_STRUCTURES') -- 4498610 : Added PA_STRUCTURES also

13232: where ppr.project_id = p_project_id
13233: and ppr.object_id = p_object_id
13234: and ppr.object_version_id = p_object_version_id
13235: and ppr.structure_version_id = p_structure_version_id
13236: and ppr.object_type in ('PA_TASKS','PA_ASSIGNMENTS','PA_STRUCTURES') -- 4498610 : Added PA_STRUCTURES also
13237: and ppr.current_flag = 'Y'
13238: and ppr.as_of_date = (select max(as_of_date) from pa_progress_rollup ppr2
13239: where ppr2.project_id = p_project_id
13240: and ppr2.object_id = p_object_id

Line 13243: and ppr2.object_type in ('PA_TASKS','PA_ASSIGNMENTS','PA_STRUCTURES'));

13239: where ppr2.project_id = p_project_id
13240: and ppr2.object_id = p_object_id
13241: and ppr2.object_version_id = p_object_version_id
13242: and ppr2.structure_version_id = p_structure_version_id
13243: and ppr2.object_type in ('PA_TASKS','PA_ASSIGNMENTS','PA_STRUCTURES'));
13244:
13245: cur_progress_rec cur_progress%rowtype;
13246:
13247:

Line 13257: and ppr.object_type in ('PA_TASKS','PA_ASSIGNMENTS','PA_STRUCTURES'); -- 4498610 : Added PA_STRUCTURES also

13253: and ppr.object_id = p_object_id
13254: and ppr.object_version_id = p_object_version_id
13255: and ppr.structure_version_id IS NULL
13256: and ppr.current_flag = p_current_flag
13257: and ppr.object_type in ('PA_TASKS','PA_ASSIGNMENTS','PA_STRUCTURES'); -- 4498610 : Added PA_STRUCTURES also
13258: --bug 3959087, following code is commented as it is not needed
13259: /*and ppr.as_of_date = (select max(as_of_date) from pa_progress_rollup ppr2
13260: where ppr2.project_id = p_project_id
13261: and ppr2.object_id = p_object_id

Line 13265: and ppr2.object_type in ('PA_TASKS','PA_ASSIGNMENTS'));*/

13261: and ppr2.object_id = p_object_id
13262: and ppr2.object_version_id = p_object_version_id
13263: and ppr2.structure_version_id IS NULL
13264: and ppr2.current_flag = p_current_flag --bug 3708948
13265: and ppr2.object_type in ('PA_TASKS','PA_ASSIGNMENTS'));*/
13266:
13267: cursor cur_prev_planned_task_effort(p_project_id NUMBER, p_proj_element_id NUMBER
13268: , p_structure_version_id NUMBER) is
13269: select (labor_effort+equipment_effort)

Line 13353: and object_type = decode(p_object_type, 'PA_ASSIGNMENTS','PA_TASKS', p_object_type); -- Bug 3856161 : Added Decode

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
13354:
13355: l_rollup_method VARCHAR2(30);
13356: l_actual_finish_DATE DATE;
13357: l_actual_start_DATE DATE;

Line 13422: and ppr.object_type IN ('PA_TASKS','PA_STRUCTURES') -- -- Bug 4498610 : Added PA_STRUCTURES

13418: where ppr.project_id = p_project_id
13419: and ppr.object_id = p_object_id
13420: and ppr.object_version_id = p_object_version_id
13421: and ppr.structure_version_id = p_structure_version_id
13422: and ppr.object_type IN ('PA_TASKS','PA_STRUCTURES') -- -- Bug 4498610 : Added PA_STRUCTURES
13423: and ppr.current_flag = 'Y';
13424:
13425:
13426: cursor cur_rollup_percent2 (p_project_id NUMBER, p_object_id NUMBER, p_object_version_id NUMBER,

Line 13435: and ppr.object_type IN ('PA_TASKS','PA_STRUCTURES') -- Bug 4498610 : Added PA_STRUCTURES

13431: and ppr.object_id = p_object_id
13432: and ppr.object_version_id = p_object_version_id
13433: and ppr.structure_version_id IS NULL
13434: and ppr.current_flag = 'Y'
13435: and ppr.object_type IN ('PA_TASKS','PA_STRUCTURES') -- Bug 4498610 : Added PA_STRUCTURES
13436: ;
13437:
13438: --bug 3959087, end
13439:

Line 13447: and ppr.object_type = 'PA_TASKS'

13443: from pa_progress_rollup ppr
13444: where ppr.project_id = c_project_id
13445: and ppr.object_id = c_object_id
13446: and ((c_version_enabled_flag = 'N' AND ppr.structure_version_id IS NULL) OR (c_version_enabled_flag = 'Y' AND ppr.structure_version_id = p_structure_version_id))
13447: and ppr.object_type = 'PA_TASKS'
13448: and ppr.structure_type = 'WORKPLAN';
13449:
13450: l_progress_exists VARCHAR2(1):='N';
13451:

Line 13491: --The following actions are to be performed only when p_object_type = 'PA_TASKS'

13487: END IF;
13488:
13489: l_version_enabled := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_project_id); --maansari5/9
13490:
13491: --The following actions are to be performed only when p_object_type = 'PA_TASKS'
13492:
13493: --IF (p_object_type = 'PA_TASKS') THEN --- Bug 4498610
13494: IF (p_object_type IN ('PA_TASKS','PA_STRUCTURES')) THEN --- Bug 4498610
13495:

Line 13493: --IF (p_object_type = 'PA_TASKS') THEN --- Bug 4498610

13489: l_version_enabled := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_project_id); --maansari5/9
13490:
13491: --The following actions are to be performed only when p_object_type = 'PA_TASKS'
13492:
13493: --IF (p_object_type = 'PA_TASKS') THEN --- Bug 4498610
13494: IF (p_object_type IN ('PA_TASKS','PA_STRUCTURES')) THEN --- Bug 4498610
13495:
13496: -- Bug Fix 5726773
13497: -- Support negative quantities and amounts.

Line 13494: IF (p_object_type IN ('PA_TASKS','PA_STRUCTURES')) THEN --- Bug 4498610

13490:
13491: --The following actions are to be performed only when p_object_type = 'PA_TASKS'
13492:
13493: --IF (p_object_type = 'PA_TASKS') THEN --- Bug 4498610
13494: IF (p_object_type IN ('PA_TASKS','PA_STRUCTURES')) THEN --- Bug 4498610
13495:
13496: -- Bug Fix 5726773
13497: -- Support negative quantities and amounts.
13498: -- Commenting out the following validations.

Line 13693: l_assignment_exists := PA_PROGRESS_UTILS.check_assignment_exists(p_project_id, p_task_ver_id, 'PA_TASKS');

13689: END IF;
13690:
13691: --bug 3959087, start
13692: l_lowest_level_task := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_task_ver_id );
13693: l_assignment_exists := PA_PROGRESS_UTILS.check_assignment_exists(p_project_id, p_task_ver_id, 'PA_TASKS');
13694:
13695: IF l_debug_mode = 'Y' THEN
13696: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_lowest_level_task='||l_lowest_level_task, x_Log_Level=> 3);
13697: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_assignment_exists='||l_assignment_exists, x_Log_Level=> 3);

Line 13709: AND p_object_type = 'PA_TASKS'

13705: PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN') = 'Y'
13706: -- Progress Management Changes, Bug # 3420093.
13707: --AND PA_PROGRESS_UTILS.check_assignment_exists(p_project_id,p_task_ver_id,p_object_type) = 'N' --bug 3864543
13708: AND l_assignment_exists = 'N' --bug 3959087
13709: AND p_object_type = 'PA_TASKS'
13710: AND p_calling_module <> 'AMG')
13711: THEN
13712:
13713: OPEN cur_sch;

Line 13843: -- 4498610 : Added PA_TASKS condition

13839: END IF;
13840: -- Bug 3856161 : Reduced the scope of IF
13841: END IF;*/
13842:
13843: -- 4498610 : Added PA_TASKS condition
13844: IF p_object_type = 'PA_TASKS' AND NVL( l_lowest_level_task, 'N' ) = 'Y' AND l_assignment_exists = 'N'
13845: THEN
13846: OPEN cur_proj_elements(l_task_id);
13847: FETCH cur_proj_elements INTO l_BASE_PERCENT_COMP_DERIV_CODE;

Line 13844: IF p_object_type = 'PA_TASKS' AND NVL( l_lowest_level_task, 'N' ) = 'Y' AND l_assignment_exists = 'N'

13840: -- Bug 3856161 : Reduced the scope of IF
13841: END IF;*/
13842:
13843: -- 4498610 : Added PA_TASKS condition
13844: IF p_object_type = 'PA_TASKS' AND NVL( l_lowest_level_task, 'N' ) = 'Y' AND l_assignment_exists = 'N'
13845: THEN
13846: OPEN cur_proj_elements(l_task_id);
13847: FETCH cur_proj_elements INTO l_BASE_PERCENT_COMP_DERIV_CODE;
13848: CLOSE cur_proj_elements;

Line 14380: IF p_object_type = 'PA_TASKS' THEN-- Bug 4498610 : Added IF

14376: -- end if;--IF Bug 3856161 (nvl(p_percent_complete,0) > 0 AND p_percent_complete <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
14377: END IF; -- Bug 3856161 ( (nvl(p_percent_complete,0) > 0 AND p_percent_complete <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
14378:
14379:
14380: IF p_object_type = 'PA_TASKS' THEN-- Bug 4498610 : Added IF
14381: -- Bug 3976633 : Added cursor cur_progress_exists
14382: OPEN cur_progress_exists (p_project_id, l_task_id, p_structure_version_id, l_version_enabled);
14383: FETCH cur_progress_exists INTO l_progress_exists;
14384: CLOSE cur_progress_exists;

Line 14444: END IF;-- p_object_type = 'PA_TASKS' THEN-- Bug 4498610 : Added END IF

14440: ,x_return_status => l_return_status
14441: ,x_msg_count => l_msg_count
14442: ,x_msg_data => l_msg_data);
14443: END IF ;--IF NVL(l_progress_exists, 'N') = 'Y' THEN
14444: END IF;-- p_object_type = 'PA_TASKS' THEN-- Bug 4498610 : Added END IF
14445: END IF; -- if (p_object_type ='PA_TASKS') then
14446:
14447: -- Code to insert progress records nto the pa_progress_rollup_table.
14448:

Line 14445: END IF; -- if (p_object_type ='PA_TASKS') then

14441: ,x_msg_count => l_msg_count
14442: ,x_msg_data => l_msg_data);
14443: END IF ;--IF NVL(l_progress_exists, 'N') = 'Y' THEN
14444: END IF;-- p_object_type = 'PA_TASKS' THEN-- Bug 4498610 : Added END IF
14445: END IF; -- if (p_object_type ='PA_TASKS') then
14446:
14447: -- Code to insert progress records nto the pa_progress_rollup_table.
14448:
14449: /* END: The above actions are to be performed only when p_object_type = 'PA_TASKS'. */

Line 14449: /* END: The above actions are to be performed only when p_object_type = 'PA_TASKS'. */

14445: END IF; -- if (p_object_type ='PA_TASKS') then
14446:
14447: -- Code to insert progress records nto the pa_progress_rollup_table.
14448:
14449: /* END: The above actions are to be performed only when p_object_type = 'PA_TASKS'. */
14450:
14451:
14452: /* BEGIN: The following actions are to be performed only when p_object_type = 'PA_ASSIGNMENTS'. */
14453:

Line 14532: ,p_object_type => 'PA_TASKS' -- p_object_type Bug 3856161

14528: ,p_project_id => p_project_id
14529: ,p_structure_version_id => p_structure_version_id
14530: ,p_calling_module => p_calling_module--BUG 3919800, rtarway
14531: --maansari5/10
14532: ,p_object_type => 'PA_TASKS' -- p_object_type Bug 3856161
14533: ,p_object_id => l_task_id
14534: ,p_object_version_id => p_task_ver_id
14535: ,p_task_version_id => p_task_ver_id
14536: --maansari5/10

Line 15865: ,p_object_type => 'PA_TASKS'

15861: ,p_task_status => p_cancel_status_code
15862: ,p_project_id => p_project_id
15863: ,p_object_id => p_task_id
15864: ,p_object_version_id => p_task_version_id
15865: ,p_object_type => 'PA_TASKS'
15866: ,x_return_status => x_return_status
15867: ,x_msg_count => x_msg_count
15868: ,x_msg_data => x_msg_data
15869: );