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_PVT1 dependencies on PA_OBJECT_RELATIONSHIPS

Line 3322: l_weighting_percentage PA_OBJECT_RELATIONSHIPS.weighting_percentage%TYPE;

3318: l_attribute12 PA_PROJ_ELEMENT_VERSIONS.attribute12%TYPE;
3319: l_attribute13 PA_PROJ_ELEMENT_VERSIONS.attribute13%TYPE;
3320: l_attribute14 PA_PROJ_ELEMENT_VERSIONS.attribute14%TYPE;
3321: l_attribute15 PA_PROJ_ELEMENT_VERSIONS.attribute15%TYPE;
3322: l_weighting_percentage PA_OBJECT_RELATIONSHIPS.weighting_percentage%TYPE;
3323:
3324: CURSOR cur_proj_elems
3325: IS
3326: SELECT *

Line 3339: FROM pa_object_relationships

3335: avoid hash join issue */
3336:
3337: /* SELECT max( b.display_sequence )
3338: FROM( SELECT object_id_to1
3339: FROM pa_object_relationships
3340: WHERE relationship_type = 'S'
3341: START WITH object_id_from1 = p_ref_task_version_id
3342: CONNECT BY object_id_from1 = PRIOR object_id_to1
3343: AND relationship_type = 'S' ) a, pa_proj_element_versions b

Line 3350: FROM pa_object_relationships

3346: SELECT max( b.display_sequence )
3347: FROM pa_proj_element_versions b
3348: WHERE b.element_version_id IN
3349: ( SELECT object_id_to1
3350: FROM pa_object_relationships
3351: WHERE relationship_type = 'S'
3352: START WITH object_id_from1 = p_ref_task_version_id
3353: CONNECT BY object_id_from1 = PRIOR object_id_to1
3354: AND relationship_type = PRIOR relationship_type --bug 3919266

Line 3363: FROM pa_object_relationships

3359:
3360: CURSOR cur_parent
3361: IS
3362: SELECT object_id_from1, object_type_from
3363: FROM pa_object_relationships
3364: WHERE object_id_to1 = p_ref_task_version_id
3365: AND relationship_type = 'S';
3366: CURSOR get_task_detail(cp_task_id NUMBER)
3367: IS

Line 4053: FROM pa_object_relationships

4049: CURSOR cur_child_tasks( c_task_version_id NUMBER )
4050: IS SELECT a.object_id_from1, a.object_id_to1, b.parent_structure_version_id, b.display_sequence
4051: FROM
4052: ( SELECT object_id_from1, object_id_to1
4053: FROM pa_object_relationships
4054: WHERE relationship_type = 'S'
4055: START WITH object_id_from1 = c_task_version_id
4056: CONNECT BY object_id_from1 = PRIOR object_id_to1
4057: AND relationship_type = prior relationship_type --bug 3919266

Line 4067: FROM pa_object_relationships

4063: CURSOR cur_child_tasks2( c_task_version_id NUMBER )
4064: IS SELECT max( display_sequence )
4065: FROM pa_proj_element_versions
4066: WHERE element_version_id in ( SELECT object_id_to1
4067: FROM pa_object_relationships
4068: WHERE relationship_type = 'S'
4069: START WITH object_id_from1 = c_task_version_id
4070: CONNECT BY object_id_from1 = PRIOR object_id_to1
4071: AND relationship_type = PRIOR relationship_type --bug 3919266

Line 4080: FROM pa_object_relationships

4076: CURSOR cur_child_tasks3( c_task_version_id NUMBER ,c_ref_task_disp_seq NUMBER) -- Bug 6628382 modified existing cursor to restrict the tasks which are being moved to fall between the source and the destination task
4077: IS SELECT max( display_sequence )
4078: FROM pa_proj_element_versions
4079: WHERE element_version_id in ( SELECT object_id_to1
4080: FROM pa_object_relationships
4081: WHERE relationship_type = 'S'
4082: and object_id_to1 <> p_task_version_id
4083: START WITH object_id_from1 = c_task_version_id
4084: CONNECT BY object_id_from1 = PRIOR object_id_to1 --bug 3919266

Line 4095: FROM pa_object_relationships

4091: CURSOR cur_child_tasks4( c_task_version_id NUMBER) -- Bug 6628382. Added another cursor to compute the last child task of any task.
4092: IS SELECT max( display_sequence)
4093: FROM pa_proj_element_versions
4094: WHERE element_version_id in ( SELECT object_id_to1
4095: FROM pa_object_relationships
4096: WHERE relationship_type = 'S'
4097: and object_id_to1 <> p_task_version_id
4098: START WITH object_id_from1 = c_task_version_id
4099: CONNECT BY object_id_from1 = PRIOR object_id_to1 --bug 3919266

Line 4109: FROM pa_object_relationships

4105: --to get the object rel id and record version number of the task version id.
4106: CURSOR cur_obj_rel( p_child_version_id NUMBER )
4107: IS
4108: SELECT object_id_from1, object_relationship_id, record_version_number, relationship_subtype
4109: FROM pa_object_relationships
4110: WHERE object_id_to1 = p_child_version_id
4111: AND relationship_type = 'S';
4112:
4113: --This cursor fetches all tasks that are child of ref task but now become child of p_task_version

Line 4117: FROM pa_object_relationships por,

4113: --This cursor fetches all tasks that are child of ref task but now become child of p_task_version
4114: CURSOR cur_new_child
4115: IS
4116: SELECT por.object_id_to1, ppev.display_sequence, por.record_version_number, por.object_relationship_id
4117: FROM pa_object_relationships por,
4118: pa_proj_element_versions ppev
4119: WHERE object_id_from1 = p_ref_task_version_id
4120: AND object_id_to1 = element_version_id
4121: AND display_sequence > l_display_sequence

Line 4147: from pa_object_relationships a

4143: --hsiu added
4144: --for task weighting
4145: cursor get_task_weighting(c_task_version_id NUMBER) IS
4146: select a.object_id_from1, a.weighting_percentage
4147: from pa_object_relationships a
4148: where a.object_id_to1 = c_task_version_id
4149: and a.object_type_to = 'PA_TASKS'
4150: and a.relationship_type = 'S'
4151: and a.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');

Line 4157: from pa_object_relationships

4153:
4154: -- anlee task weighting changes
4155: cursor get_sub_tasks(c_task_version_id NUMBER) IS
4156: select '1'
4157: from pa_object_relationships
4158: where object_id_from1 = c_task_version_id
4159: and object_type_from IN ('PA_TASKS', 'PA_STRUCTURES')
4160: and relationship_type = 'S';
4161: l_dummy varchar2(1);

Line 4184: l_parent_task_id PA_OBJECT_RELATIONSHIPS.object_id_from1%TYPE;

4180:
4181: l_progress_allowed VARCHAR2(1);
4182: --bug 2673570
4183: --Bug 13895419 start
4184: l_parent_task_id PA_OBJECT_RELATIONSHIPS.object_id_from1%TYPE;
4185: l_ref_parent_task_id PA_OBJECT_RELATIONSHIPS.object_id_from1%TYPE;
4186: --Bug 13895419 end
4187: -- 14556729:Huawei code change :
4188: l2_task_wbs_level number;

Line 4185: l_ref_parent_task_id PA_OBJECT_RELATIONSHIPS.object_id_from1%TYPE;

4181: l_progress_allowed VARCHAR2(1);
4182: --bug 2673570
4183: --Bug 13895419 start
4184: l_parent_task_id PA_OBJECT_RELATIONSHIPS.object_id_from1%TYPE;
4185: l_ref_parent_task_id PA_OBJECT_RELATIONSHIPS.object_id_from1%TYPE;
4186: --Bug 13895419 end
4187: -- 14556729:Huawei code change :
4188: l2_task_wbs_level number;
4189: l2_ref_task_wbs_level number;

Line 4253: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel

4249: --Bug 13895419 start
4250: --Fetch parent_task_id and ref_parent_task_id for source task and target task respectively from db.
4251: begin
4252: SELECT rel.object_id_from1 INTO l_parent_task_id
4253: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel
4254: WHERE pev.element_version_id = p_task_version_id
4255: AND pev.object_type = 'PA_TASKS'
4256: AND rel.object_id_to1 = pev.element_version_id
4257: AND rel.relationship_type = 'S'

Line 4261: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel

4257: AND rel.relationship_type = 'S'
4258: AND rel.object_type_from in ('PA_TASKS', 'PA_STRUCTURES');
4259:
4260: SELECT rel.object_id_from1 INTO l_ref_parent_task_id
4261: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel
4262: WHERE pev.element_version_id = p_ref_task_version_id
4263: AND pev.object_type = 'PA_TASKS'
4264: AND rel.object_id_to1 = pev.element_version_id
4265: AND rel.relationship_type = 'S'

Line 4577: FROM pa_object_relationships

4573: DECLARE
4574: CURSOR cur_parent_of_task_version
4575: IS
4576: SELECT object_id_from1
4577: FROM pa_object_relationships
4578: WHERE object_id_to1 = p_task_version_id
4579: AND relationship_type = 'S';
4580: BEGIN
4581: open cur_parent_of_task_version;

Line 4995: FROM pa_proj_element_versions pev, pa_object_relationships rel,

4991: pev.element_version_id child_ver_id,
4992: parent.element_version_id parent_ver_id,
4993: pev.display_sequence, rel.object_id_to1, rel.object_type_to,
4994: rel.relationship_type, rel.object_id_from1, rel.object_type_from
4995: FROM pa_proj_element_versions pev, pa_object_relationships rel,
4996: pa_proj_element_versions parent
4997: WHERE rel.object_type_from = 'PA_TASKS'
4998: AND rel.relationship_type = 'S'
4999: AND rel.object_type_to = 'PA_TASKS'

Line 5043: FROM pa_proj_element_versions pev, pa_object_relationships rel,

5039: pev.element_version_id child_ver_id,
5040: parent.element_version_id parent_ver_id,
5041: pev.display_sequence, rel.object_id_to1, rel.object_type_to,
5042: rel.relationship_type, rel.object_id_from1, rel.object_type_from
5043: FROM pa_proj_element_versions pev, pa_object_relationships rel,
5044: pa_proj_element_versions parent
5045: WHERE rel.object_type_from = 'PA_TASKS'
5046: AND rel.relationship_type = 'S'
5047: AND rel.object_type_to = 'PA_TASKS'

Line 5353: FROM pa_object_relationships

5349: SELECT a.object_relationship_id object_relationship_id, a.object_id_to1 object_id_to1,
5350: a.record_version_number record_version_number, b.wbs_level wbs_level, b.display_sequence
5351: FROM (
5352: SELECT object_relationship_id, object_id_to1, record_version_number
5353: FROM pa_object_relationships
5354: WHERE relationship_type = 'S'
5355: START WITH object_id_from1 = p_task_version_id
5356: CONNECT BY object_id_from1 = PRIOR object_id_to1
5357: AND relationship_type = prior relationship_type -- bug 3919266

Line 5369: FROM pa_object_relationships a, pa_proj_element_versions b

5365: --bug 4573340
5366: UNION
5367: SELECT a.object_relationship_id, element_version_id object_id_to1,
5368: a.record_version_number, wbs_level, b.display_sequence
5369: FROM pa_object_relationships a, pa_proj_element_versions b
5370: WHERE element_version_id = p_task_version_id
5371: AND object_id_to1 = p_task_version_id
5372: AND element_version_id = object_id_to1
5373: AND relationship_type = 'S'

Line 5422: FROM pa_object_relationships

5418: --Ansari
5419: CURSOR cur_parent_ver_id( c_task_version_id NUMBER )
5420: IS
5421: SELECT object_id_from1
5422: FROM pa_object_relationships
5423: WHERE object_id_to1 = c_task_version_id
5424: AND relationship_type = 'S';
5425: l_parent_task_verion_id NUMBER;
5426: --Ansari

Line 5433: from pa_object_relationships a,

5429: --hsiu added, for dates rollup
5430: CURSOR get_peer_tasks
5431: IS
5432: select b.object_id_to1 object_id_to1
5433: from pa_object_relationships a,
5434: pa_object_relationships b,
5435: pa_proj_element_versions c,
5436: pa_proj_elements d
5437: where a.object_id_to1 = p_task_version_id

Line 5434: pa_object_relationships b,

5430: CURSOR get_peer_tasks
5431: IS
5432: select b.object_id_to1 object_id_to1
5433: from pa_object_relationships a,
5434: pa_object_relationships b,
5435: pa_proj_element_versions c,
5436: pa_proj_elements d
5437: where a.object_id_to1 = p_task_version_id
5438: and a.object_type_to = 'PA_TASKS'

Line 5456: from pa_object_relationships

5452:
5453: --hsiu added, for task weighting
5454: CURSOR get_parent_version_id IS
5455: select object_id_from1
5456: from pa_object_relationships
5457: where object_id_to1 = p_task_version_id
5458: and object_type_to = 'PA_TASKS'
5459: and relationship_type = 'S'
5460: and object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');

Line 5530: FROM pa_object_relationships

5526: -- Added by Skannoji
5527: CURSOR cur_fp_tsk_ver_id( c_task_version_id NUMBER )
5528: IS
5529: SELECT object_id_to1
5530: FROM pa_object_relationships
5531: -- bug# 3766336 Satish 19/07/04
5532: --WHERE object_id_from1 = p_task_version_id
5533: WHERE object_id_from1 = c_task_version_id
5534: AND relationship_type = 'M';

Line 5536: l_fp_task_version_id PA_OBJECT_RELATIONSHIPS.object_id_to1%TYPE;

5532: --WHERE object_id_from1 = p_task_version_id
5533: WHERE object_id_from1 = c_task_version_id
5534: AND relationship_type = 'M';
5535:
5536: l_fp_task_version_id PA_OBJECT_RELATIONSHIPS.object_id_to1%TYPE;
5537: /* Bug #: 3305199 SMukka */
5538: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
5539: /* l_element_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; */
5540: l_element_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

Line 5547: FROM pa_object_relationships pors

5543: --
5544: --Bug No 3450684 Smukka For Subproject Association
5545: CURSOR get_subproj_relation(cp_task_ver_id NUMBER) IS
5546: SELECT pors.object_relationship_id,pors.record_version_number
5547: FROM pa_object_relationships pors
5548: --bug 4573340
5549: ,pa_object_relationships pors1
5550: WHERE
5551: --pors.object_id_from1= cp_task_ver_id

Line 5549: ,pa_object_relationships pors1

5545: CURSOR get_subproj_relation(cp_task_ver_id NUMBER) IS
5546: SELECT pors.object_relationship_id,pors.record_version_number
5547: FROM pa_object_relationships pors
5548: --bug 4573340
5549: ,pa_object_relationships pors1
5550: WHERE
5551: --pors.object_id_from1= cp_task_ver_id
5552: pors1.object_id_from1 = cp_task_ver_id
5553: AND pors.object_id_from1 = pors1.object_id_to1

Line 5567: from pa_object_relationships pors

5563:
5564: --bug 4006401
5565: CURSOR get_all_subtasks(c_task_version_id NUMBER) IS
5566: select object_id_to1 task_ver_id
5567: from pa_object_relationships pors
5568: start with object_id_from1 = c_task_version_id
5569: and relationship_type = 'S'
5570: and object_type_from = 'PA_TASKS'
5571: and object_type_to = 'PA_TASKS'

Line 9120: pa_object_relationships b,

9116: CURSOR get_parent_task_type_attr IS
9117: select c.TYPE_ID , c.WQ_ITEM_CODE, c.WQ_UOM_CODE, c.WQ_ACTUAL_ENTRY_CODE,
9118: c.TASK_PROGRESS_ENTRY_PAGE_ID
9119: from pa_proj_element_versions a,
9120: pa_object_relationships b,
9121: pa_proj_elements c
9122: where b.object_id_to1 = p_task_version_id
9123: and b.object_type_to = 'PA_TASKS'
9124: and b.relationship_type = 'S'

Line 9227: FROM pa_object_relationships

9223: ,RELATIONSHIP_SUBTYPE
9224: ,LAG_DAY
9225: ,PRIORITY
9226: ,PM_PRODUCT_CODE
9227: FROM pa_object_relationships
9228: WHERE OBJECT_RELATIONSHIP_ID = c_object_relationship_id;
9229:
9230: cur_obj_relationships_rec cur_obj_relationships%ROWTYPE;
9231:

Line 9263: PA_OBJECT_RELATIONSHIPS_PKG.UPDATE_ROW(

9259: RAISE FND_API.G_EXC_ERROR;
9260: END IF;
9261: CLOSE cur_obj_relationships;
9262:
9263: PA_OBJECT_RELATIONSHIPS_PKG.UPDATE_ROW(
9264: p_user_id => FND_GLOBAL.USER_ID
9265: ,p_object_relationship_id => p_object_relationship_id
9266: ,p_relationship_type => cur_obj_relationships_rec.relationship_type
9267: ,p_relationship_subtype => cur_obj_relationships_rec.relationship_subtype

Line 9315: from pa_object_relationships

9311: )
9312: IS
9313: CURSOR get_weighting_sum IS
9314: select sum(weighting_percentage)
9315: from pa_object_relationships
9316: where object_id_from1 = p_task_version_id
9317: and object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
9318: and relationship_type = 'S';
9319:

Line 9323: from pa_object_relationships

9319:
9320: CURSOR get_child_weighting IS
9321: select object_relationship_id, weighting_percentage,
9322: record_version_number, object_id_to1
9323: from pa_object_relationships
9324: where object_id_from1 = p_task_version_id
9325: and object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
9326: and relationship_type = 'S';
9327:

Line 9498: from pa_object_relationships

9494: )
9495: IS
9496: CURSOR get_task_versions IS
9497: select object_id_to1
9498: from pa_object_relationships
9499: where relationship_type = 'S'
9500: and object_type_from = 'PA_TASKS'
9501: and object_type_to = 'PA_TASKS'
9502: and relationship_type = 'S'

Line 9589: FROM pa_object_relationships

9585: SELECT a.object_relationship_id object_relationship_id, a.object_id_to1 object_id_to1,
9586: a.record_version_number record_version_number, b.wbs_level wbs_level, b.display_sequence
9587: FROM (
9588: SELECT object_relationship_id, object_id_to1, record_version_number
9589: FROM pa_object_relationships
9590: WHERE relationship_type = 'S'
9591: START WITH object_id_from1 = p_task_version_id
9592: CONNECT BY object_id_from1 = PRIOR object_id_to1
9593: AND relationship_type = PRIOR relationship_type --bug 3919266

Line 9605: FROM pa_object_relationships a, pa_proj_element_versions b

9601: --bug 4573340
9602: UNION
9603: SELECT a.object_relationship_id, element_version_id object_id_to1,
9604: a.record_version_number, wbs_level, b.display_sequence
9605: FROM pa_object_relationships a, pa_proj_element_versions b
9606: WHERE element_version_id = p_task_version_id
9607: AND object_id_to1 = p_task_version_id
9608: AND element_version_id = object_id_to1
9609: AND relationship_type = 'S'

Line 9658: FROM pa_object_relationships

9654: --Ansari
9655: CURSOR cur_parent_ver_id( c_task_version_id NUMBER )
9656: IS
9657: SELECT object_id_from1
9658: FROM pa_object_relationships
9659: WHERE object_id_to1 = c_task_version_id
9660: AND relationship_type = 'S';
9661: l_parent_task_verion_id NUMBER;
9662: --Ansari

Line 9669: from pa_object_relationships a,

9665: --hsiu added, for dates rollup
9666: CURSOR get_peer_tasks
9667: IS
9668: select b.object_id_to1 object_id_to1
9669: from pa_object_relationships a,
9670: pa_object_relationships b
9671: where a.object_id_to1 = p_task_version_id
9672: and a.object_type_to = 'PA_TASKS'
9673: and a.object_id_from1 = b.object_id_from1

Line 9670: pa_object_relationships b

9666: CURSOR get_peer_tasks
9667: IS
9668: select b.object_id_to1 object_id_to1
9669: from pa_object_relationships a,
9670: pa_object_relationships b
9671: where a.object_id_to1 = p_task_version_id
9672: and a.object_type_to = 'PA_TASKS'
9673: and a.object_id_from1 = b.object_id_from1
9674: and a.object_type_from = b.object_type_from

Line 9686: from pa_object_relationships

9682:
9683: --hsiu added, for task weighting
9684: CURSOR get_parent_version_id IS
9685: select object_id_from1
9686: from pa_object_relationships
9687: where object_id_to1 = p_task_version_id
9688: and object_type_to = 'PA_TASKS'
9689: and relationship_type = 'S'
9690: and object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');

Line 9738: FROM pa_object_relationships

9734: -- Added by Skannoji
9735: CURSOR cur_fp_tsk_ver_id( c_task_version_id NUMBER )
9736: IS
9737: SELECT object_id_to1
9738: FROM pa_object_relationships
9739: --WHERE object_id_from1 = p_task_version_id --4173785
9740: WHERE object_id_from1 = c_task_version_id
9741: AND relationship_type = 'M';
9742:

Line 9743: l_fp_task_version_id PA_OBJECT_RELATIONSHIPS.object_id_to1%TYPE;

9739: --WHERE object_id_from1 = p_task_version_id --4173785
9740: WHERE object_id_from1 = c_task_version_id
9741: AND relationship_type = 'M';
9742:
9743: l_fp_task_version_id PA_OBJECT_RELATIONSHIPS.object_id_to1%TYPE;
9744: /* Bug #: 3305199 SMukka */
9745: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
9746: /* l_element_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; */
9747: l_element_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

Line 9753: FROM pa_object_relationships pors

9749: --
9750: --Bug No 3450684 Smukka For Subproject Association
9751: CURSOR get_subproj_relation(cp_task_ver_id NUMBER) IS
9752: SELECT pors.object_relationship_id,pors.record_version_number,pors.object_id_to2 --pors.object_id_to2 is added for the Bug 14591859
9753: FROM pa_object_relationships pors
9754: --bug 4573340
9755: ,pa_object_relationships pors1
9756: WHERE
9757: --pors.object_id_from1= cp_task_ver_id

Line 9755: ,pa_object_relationships pors1

9751: CURSOR get_subproj_relation(cp_task_ver_id NUMBER) IS
9752: SELECT pors.object_relationship_id,pors.record_version_number,pors.object_id_to2 --pors.object_id_to2 is added for the Bug 14591859
9753: FROM pa_object_relationships pors
9754: --bug 4573340
9755: ,pa_object_relationships pors1
9756: WHERE
9757: --pors.object_id_from1= cp_task_ver_id
9758: pors1.object_id_from1 = cp_task_ver_id
9759: AND pors.object_id_from1 = pors1.object_id_to1

Line 9772: l_dest_proj_id pa_object_relationships.object_id_to2%type; --Bug 14591859

9768: --
9769: l_call_del_plan_txn VARCHAR2(1) := 'N'; --bug 4172646
9770:
9771: l_debug_mode VARCHAR2(1);
9772: l_dest_proj_id pa_object_relationships.object_id_to2%type; --Bug 14591859
9773: BEGIN
9774:
9775: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
9776:

Line 10445: pa_object_relationships c

10441: CURSOR get_working_ver(c_option NUMBER) IS
10442: select a.element_version_id, c.object_id_from1
10443: from pa_proj_element_versions a,
10444: pa_proj_elem_ver_structure b,
10445: pa_object_relationships c
10446: where a.parent_structure_version_id = b.element_version_id
10447: and a.project_id = b.project_id
10448: and a.proj_element_id = p_task_id
10449: and a.element_version_id = c.object_id_to1

Line 10458: pa_object_relationships c

10454: UNION
10455: select a.element_version_id, c.object_id_from1
10456: from pa_proj_element_versions a,
10457: pa_proj_elem_ver_structure b,
10458: pa_object_relationships c
10459: where a.parent_structure_version_id = b.element_version_id
10460: and a.project_id = b.project_id
10461: and a.proj_element_id = p_task_id
10462: and a.element_version_id = c.object_id_to1

Line 10501: update pa_object_relationships

10497: LOOP
10498: FETCH get_working_ver into l_working_ver_id, l_working_parent_id;
10499: EXIT WHEN get_working_ver%NOTFOUND;
10500: --update selected tasks weighting
10501: update pa_object_relationships
10502: set WEIGHTING_PERCENTAGE = p_weighting
10503: where object_id_to1 = l_working_ver_id
10504: and relationship_type = 'S'
10505: and object_type_to = 'PA_TASKS';

Line 10551: ( SELECT object_id_to1 from pa_object_relationships

10547: CURSOR cur_task_hier( c_parent_structure_version_id NUMBER )
10548: IS
10549: SELECT proj_element_id, element_version_id
10550: FROM pa_proj_element_versions ppev,
10551: ( SELECT object_id_to1 from pa_object_relationships
10552: WHERE relationship_type = 'S'
10553: start with object_id_from1 = ( SELECT element_version_id
10554: FROM pa_proj_element_versions ppev
10555: WHERE ppev.proj_element_id = p_task_id

Line 10762: FROM pa_object_relationships

10758:
10759: CURSOR cur_get_parent_tasks(c_elem_ver_id number)
10760: IS
10761: SELECT object_id_from1
10762: FROM pa_object_relationships
10763: WHERE object_type_from IN ('PA_TASKS', 'PA_STRUCTURES')
10764: AND object_type_to = 'PA_TASKS'
10765: AND relationship_type ='S'
10766: CONNECT BY PRIOR OBJECT_ID_FROM1 = OBJECT_ID_TO1

Line 11033: pa_object_relationships por,

11029: ppevs.duration ,
11030: ptt.prog_entry_enable_flag prog_flag ,
11031: ppev.object_type
11032: FROM pa_proj_element_versions ppev,
11033: pa_object_relationships por,
11034: pa_proj_elem_ver_schedule ppevs,
11035: pa_proj_elements ppe,
11036: pa_task_types ptt
11037: WHERE ppev.parent_structure_version_id = c_parent_struc_ver_id -- 377522

Line 11116: UPDATE pa_object_relationships por

11112: END IF;
11113: l_arr_elem_weight_02(i) := l_arr_elem_weight(l_arr_elem_ver_id(i));
11114: END LOOP;
11115: FORALL i IN l_arr_elem_ver_id.first..l_arr_elem_ver_id.last
11116: UPDATE pa_object_relationships por
11117: SET weighting_percentage = l_arr_elem_weight_02(i)
11118: -- SET weighting_percentage = ( l_arr_elem_duration(l_arr_elem_ver_id(i)) / l_arr_parent_sum_duration(l_arr_parent_ver_id(l_arr_elem_ver_id(i)))) * 100
11119: WHERE object_id_to1 = l_arr_elem_ver_id(i)
11120: AND por.relationship_type = 'S'