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 3165: l_weighting_percentage PA_OBJECT_RELATIONSHIPS.weighting_percentage%TYPE;

3161: l_attribute12 PA_PROJ_ELEMENT_VERSIONS.attribute12%TYPE;
3162: l_attribute13 PA_PROJ_ELEMENT_VERSIONS.attribute13%TYPE;
3163: l_attribute14 PA_PROJ_ELEMENT_VERSIONS.attribute14%TYPE;
3164: l_attribute15 PA_PROJ_ELEMENT_VERSIONS.attribute15%TYPE;
3165: l_weighting_percentage PA_OBJECT_RELATIONSHIPS.weighting_percentage%TYPE;
3166:
3167: CURSOR cur_proj_elems
3168: IS
3169: SELECT *

Line 3182: FROM pa_object_relationships

3178: avoid hash join issue */
3179:
3180: /* SELECT max( b.display_sequence )
3181: FROM( SELECT object_id_to1
3182: FROM pa_object_relationships
3183: WHERE relationship_type = 'S'
3184: START WITH object_id_from1 = p_ref_task_version_id
3185: CONNECT BY object_id_from1 = PRIOR object_id_to1
3186: AND relationship_type = 'S' ) a, pa_proj_element_versions b

Line 3193: FROM pa_object_relationships

3189: SELECT max( b.display_sequence )
3190: FROM pa_proj_element_versions b
3191: WHERE b.element_version_id IN
3192: ( SELECT object_id_to1
3193: FROM pa_object_relationships
3194: WHERE relationship_type = 'S'
3195: START WITH object_id_from1 = p_ref_task_version_id
3196: CONNECT BY object_id_from1 = PRIOR object_id_to1
3197: AND relationship_type = PRIOR relationship_type --bug 3919266

Line 3206: FROM pa_object_relationships

3202:
3203: CURSOR cur_parent
3204: IS
3205: SELECT object_id_from1, object_type_from
3206: FROM pa_object_relationships
3207: WHERE object_id_to1 = p_ref_task_version_id
3208: AND relationship_type = 'S';
3209: CURSOR get_task_detail(cp_task_id NUMBER)
3210: IS

Line 3848: FROM pa_object_relationships

3844: CURSOR cur_child_tasks( c_task_version_id NUMBER )
3845: IS SELECT a.object_id_from1, a.object_id_to1, b.parent_structure_version_id, b.display_sequence
3846: FROM
3847: ( SELECT object_id_from1, object_id_to1
3848: FROM pa_object_relationships
3849: WHERE relationship_type = 'S'
3850: START WITH object_id_from1 = c_task_version_id
3851: CONNECT BY object_id_from1 = PRIOR object_id_to1
3852: AND relationship_type = prior relationship_type --bug 3919266

Line 3862: FROM pa_object_relationships

3858: CURSOR cur_child_tasks2( c_task_version_id NUMBER )
3859: IS SELECT max( display_sequence )
3860: FROM pa_proj_element_versions
3861: WHERE element_version_id in ( SELECT object_id_to1
3862: FROM pa_object_relationships
3863: WHERE relationship_type = 'S'
3864: START WITH object_id_from1 = c_task_version_id
3865: CONNECT BY object_id_from1 = PRIOR object_id_to1
3866: AND relationship_type = PRIOR relationship_type --bug 3919266

Line 3875: FROM pa_object_relationships

3871: 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
3872: IS SELECT max( display_sequence )
3873: FROM pa_proj_element_versions
3874: WHERE element_version_id in ( SELECT object_id_to1
3875: FROM pa_object_relationships
3876: WHERE relationship_type = 'S'
3877: and object_id_to1 <> p_task_version_id
3878: START WITH object_id_from1 = c_task_version_id
3879: CONNECT BY object_id_from1 = PRIOR object_id_to1 --bug 3919266

Line 3890: FROM pa_object_relationships

3886: CURSOR cur_child_tasks4( c_task_version_id NUMBER) -- Bug 6628382. Added another cursor to compute the last child task of any task.
3887: IS SELECT max( display_sequence)
3888: FROM pa_proj_element_versions
3889: WHERE element_version_id in ( SELECT object_id_to1
3890: FROM pa_object_relationships
3891: WHERE relationship_type = 'S'
3892: and object_id_to1 <> p_task_version_id
3893: START WITH object_id_from1 = c_task_version_id
3894: CONNECT BY object_id_from1 = PRIOR object_id_to1 --bug 3919266

Line 3904: FROM pa_object_relationships

3900: --to get the object rel id and record version number of the task version id.
3901: CURSOR cur_obj_rel( p_child_version_id NUMBER )
3902: IS
3903: SELECT object_id_from1, object_relationship_id, record_version_number, relationship_subtype
3904: FROM pa_object_relationships
3905: WHERE object_id_to1 = p_child_version_id
3906: AND relationship_type = 'S';
3907:
3908: --This cursor fetches all tasks that are child of ref task but now become child of p_task_version

Line 3912: FROM pa_object_relationships por,

3908: --This cursor fetches all tasks that are child of ref task but now become child of p_task_version
3909: CURSOR cur_new_child
3910: IS
3911: SELECT por.object_id_to1, ppev.display_sequence, por.record_version_number, por.object_relationship_id
3912: FROM pa_object_relationships por,
3913: pa_proj_element_versions ppev
3914: WHERE object_id_from1 = p_ref_task_version_id
3915: AND object_id_to1 = element_version_id
3916: AND display_sequence > l_display_sequence

Line 3942: from pa_object_relationships a

3938: --hsiu added
3939: --for task weighting
3940: cursor get_task_weighting(c_task_version_id NUMBER) IS
3941: select a.object_id_from1, a.weighting_percentage
3942: from pa_object_relationships a
3943: where a.object_id_to1 = c_task_version_id
3944: and a.object_type_to = 'PA_TASKS'
3945: and a.relationship_type = 'S'
3946: and a.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');

Line 3952: from pa_object_relationships

3948:
3949: -- anlee task weighting changes
3950: cursor get_sub_tasks(c_task_version_id NUMBER) IS
3951: select '1'
3952: from pa_object_relationships
3953: where object_id_from1 = c_task_version_id
3954: and object_type_from IN ('PA_TASKS', 'PA_STRUCTURES')
3955: and relationship_type = 'S';
3956: l_dummy varchar2(1);

Line 4296: FROM pa_object_relationships

4292: DECLARE
4293: CURSOR cur_parent_of_task_version
4294: IS
4295: SELECT object_id_from1
4296: FROM pa_object_relationships
4297: WHERE object_id_to1 = p_task_version_id
4298: AND relationship_type = 'S';
4299: BEGIN
4300: open cur_parent_of_task_version;

Line 4853: FROM pa_object_relationships

4849: SELECT a.object_relationship_id object_relationship_id, a.object_id_to1 object_id_to1,
4850: a.record_version_number record_version_number, b.wbs_level wbs_level, b.display_sequence
4851: FROM (
4852: SELECT object_relationship_id, object_id_to1, record_version_number
4853: FROM pa_object_relationships
4854: WHERE relationship_type = 'S'
4855: START WITH object_id_from1 = p_task_version_id
4856: CONNECT BY object_id_from1 = PRIOR object_id_to1
4857: AND relationship_type = prior relationship_type -- bug 3919266

Line 4869: FROM pa_object_relationships a, pa_proj_element_versions b

4865: --bug 4573340
4866: UNION
4867: SELECT a.object_relationship_id, element_version_id object_id_to1,
4868: a.record_version_number, wbs_level, b.display_sequence
4869: FROM pa_object_relationships a, pa_proj_element_versions b
4870: WHERE element_version_id = p_task_version_id
4871: AND object_id_to1 = p_task_version_id
4872: AND element_version_id = object_id_to1
4873: AND relationship_type = 'S'

Line 4922: FROM pa_object_relationships

4918: --Ansari
4919: CURSOR cur_parent_ver_id( c_task_version_id NUMBER )
4920: IS
4921: SELECT object_id_from1
4922: FROM pa_object_relationships
4923: WHERE object_id_to1 = c_task_version_id
4924: AND relationship_type = 'S';
4925: l_parent_task_verion_id NUMBER;
4926: --Ansari

Line 4933: from pa_object_relationships a,

4929: --hsiu added, for dates rollup
4930: CURSOR get_peer_tasks
4931: IS
4932: select b.object_id_to1 object_id_to1
4933: from pa_object_relationships a,
4934: pa_object_relationships b,
4935: pa_proj_element_versions c,
4936: pa_proj_elements d
4937: where a.object_id_to1 = p_task_version_id

Line 4934: pa_object_relationships b,

4930: CURSOR get_peer_tasks
4931: IS
4932: select b.object_id_to1 object_id_to1
4933: from pa_object_relationships a,
4934: pa_object_relationships b,
4935: pa_proj_element_versions c,
4936: pa_proj_elements d
4937: where a.object_id_to1 = p_task_version_id
4938: and a.object_type_to = 'PA_TASKS'

Line 4956: from pa_object_relationships

4952:
4953: --hsiu added, for task weighting
4954: CURSOR get_parent_version_id IS
4955: select object_id_from1
4956: from pa_object_relationships
4957: where object_id_to1 = p_task_version_id
4958: and object_type_to = 'PA_TASKS'
4959: and relationship_type = 'S'
4960: and object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');

Line 5030: FROM pa_object_relationships

5026: -- Added by Skannoji
5027: CURSOR cur_fp_tsk_ver_id( c_task_version_id NUMBER )
5028: IS
5029: SELECT object_id_to1
5030: FROM pa_object_relationships
5031: -- bug# 3766336 Satish 19/07/04
5032: --WHERE object_id_from1 = p_task_version_id
5033: WHERE object_id_from1 = c_task_version_id
5034: AND relationship_type = 'M';

Line 5036: l_fp_task_version_id PA_OBJECT_RELATIONSHIPS.object_id_to1%TYPE;

5032: --WHERE object_id_from1 = p_task_version_id
5033: WHERE object_id_from1 = c_task_version_id
5034: AND relationship_type = 'M';
5035:
5036: l_fp_task_version_id PA_OBJECT_RELATIONSHIPS.object_id_to1%TYPE;
5037: /* Bug #: 3305199 SMukka */
5038: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
5039: /* l_element_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; */
5040: l_element_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

Line 5047: FROM pa_object_relationships pors

5043: --
5044: --Bug No 3450684 Smukka For Subproject Association
5045: CURSOR get_subproj_relation(cp_task_ver_id NUMBER) IS
5046: SELECT pors.object_relationship_id,pors.record_version_number
5047: FROM pa_object_relationships pors
5048: --bug 4573340
5049: ,pa_object_relationships pors1
5050: WHERE
5051: --pors.object_id_from1= cp_task_ver_id

Line 5049: ,pa_object_relationships pors1

5045: CURSOR get_subproj_relation(cp_task_ver_id NUMBER) IS
5046: SELECT pors.object_relationship_id,pors.record_version_number
5047: FROM pa_object_relationships pors
5048: --bug 4573340
5049: ,pa_object_relationships pors1
5050: WHERE
5051: --pors.object_id_from1= cp_task_ver_id
5052: pors1.object_id_from1 = cp_task_ver_id
5053: AND pors.object_id_from1 = pors1.object_id_to1

Line 5067: from pa_object_relationships pors

5063:
5064: --bug 4006401
5065: CURSOR get_all_subtasks(c_task_version_id NUMBER) IS
5066: select object_id_to1 task_ver_id
5067: from pa_object_relationships pors
5068: start with object_id_from1 = c_task_version_id
5069: and relationship_type = 'S'
5070: and object_type_from = 'PA_TASKS'
5071: and object_type_to = 'PA_TASKS'

Line 8374: pa_object_relationships b,

8370: CURSOR get_parent_task_type_attr IS
8371: select c.TYPE_ID , c.WQ_ITEM_CODE, c.WQ_UOM_CODE, c.WQ_ACTUAL_ENTRY_CODE,
8372: c.TASK_PROGRESS_ENTRY_PAGE_ID
8373: from pa_proj_element_versions a,
8374: pa_object_relationships b,
8375: pa_proj_elements c
8376: where b.object_id_to1 = p_task_version_id
8377: and b.object_type_to = 'PA_TASKS'
8378: and b.relationship_type = 'S'

Line 8481: FROM pa_object_relationships

8477: ,RELATIONSHIP_SUBTYPE
8478: ,LAG_DAY
8479: ,PRIORITY
8480: ,PM_PRODUCT_CODE
8481: FROM pa_object_relationships
8482: WHERE OBJECT_RELATIONSHIP_ID = c_object_relationship_id;
8483:
8484: cur_obj_relationships_rec cur_obj_relationships%ROWTYPE;
8485:

Line 8517: PA_OBJECT_RELATIONSHIPS_PKG.UPDATE_ROW(

8513: RAISE FND_API.G_EXC_ERROR;
8514: END IF;
8515: CLOSE cur_obj_relationships;
8516:
8517: PA_OBJECT_RELATIONSHIPS_PKG.UPDATE_ROW(
8518: p_user_id => FND_GLOBAL.USER_ID
8519: ,p_object_relationship_id => p_object_relationship_id
8520: ,p_relationship_type => cur_obj_relationships_rec.relationship_type
8521: ,p_relationship_subtype => cur_obj_relationships_rec.relationship_subtype

Line 8569: from pa_object_relationships

8565: )
8566: IS
8567: CURSOR get_weighting_sum IS
8568: select sum(weighting_percentage)
8569: from pa_object_relationships
8570: where object_id_from1 = p_task_version_id
8571: and object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
8572: and relationship_type = 'S';
8573:

Line 8577: from pa_object_relationships

8573:
8574: CURSOR get_child_weighting IS
8575: select object_relationship_id, weighting_percentage,
8576: record_version_number, object_id_to1
8577: from pa_object_relationships
8578: where object_id_from1 = p_task_version_id
8579: and object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
8580: and relationship_type = 'S';
8581:

Line 8752: from pa_object_relationships

8748: )
8749: IS
8750: CURSOR get_task_versions IS
8751: select object_id_to1
8752: from pa_object_relationships
8753: where relationship_type = 'S'
8754: and object_type_from = 'PA_TASKS'
8755: and object_type_to = 'PA_TASKS'
8756: and relationship_type = 'S'

Line 8843: FROM pa_object_relationships

8839: SELECT a.object_relationship_id object_relationship_id, a.object_id_to1 object_id_to1,
8840: a.record_version_number record_version_number, b.wbs_level wbs_level, b.display_sequence
8841: FROM (
8842: SELECT object_relationship_id, object_id_to1, record_version_number
8843: FROM pa_object_relationships
8844: WHERE relationship_type = 'S'
8845: START WITH object_id_from1 = p_task_version_id
8846: CONNECT BY object_id_from1 = PRIOR object_id_to1
8847: AND relationship_type = PRIOR relationship_type --bug 3919266

Line 8859: FROM pa_object_relationships a, pa_proj_element_versions b

8855: --bug 4573340
8856: UNION
8857: SELECT a.object_relationship_id, element_version_id object_id_to1,
8858: a.record_version_number, wbs_level, b.display_sequence
8859: FROM pa_object_relationships a, pa_proj_element_versions b
8860: WHERE element_version_id = p_task_version_id
8861: AND object_id_to1 = p_task_version_id
8862: AND element_version_id = object_id_to1
8863: AND relationship_type = 'S'

Line 8912: FROM pa_object_relationships

8908: --Ansari
8909: CURSOR cur_parent_ver_id( c_task_version_id NUMBER )
8910: IS
8911: SELECT object_id_from1
8912: FROM pa_object_relationships
8913: WHERE object_id_to1 = c_task_version_id
8914: AND relationship_type = 'S';
8915: l_parent_task_verion_id NUMBER;
8916: --Ansari

Line 8923: from pa_object_relationships a,

8919: --hsiu added, for dates rollup
8920: CURSOR get_peer_tasks
8921: IS
8922: select b.object_id_to1 object_id_to1
8923: from pa_object_relationships a,
8924: pa_object_relationships b
8925: where a.object_id_to1 = p_task_version_id
8926: and a.object_type_to = 'PA_TASKS'
8927: and a.object_id_from1 = b.object_id_from1

Line 8924: pa_object_relationships b

8920: CURSOR get_peer_tasks
8921: IS
8922: select b.object_id_to1 object_id_to1
8923: from pa_object_relationships a,
8924: pa_object_relationships b
8925: where a.object_id_to1 = p_task_version_id
8926: and a.object_type_to = 'PA_TASKS'
8927: and a.object_id_from1 = b.object_id_from1
8928: and a.object_type_from = b.object_type_from

Line 8940: from pa_object_relationships

8936:
8937: --hsiu added, for task weighting
8938: CURSOR get_parent_version_id IS
8939: select object_id_from1
8940: from pa_object_relationships
8941: where object_id_to1 = p_task_version_id
8942: and object_type_to = 'PA_TASKS'
8943: and relationship_type = 'S'
8944: and object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');

Line 8992: FROM pa_object_relationships

8988: -- Added by Skannoji
8989: CURSOR cur_fp_tsk_ver_id( c_task_version_id NUMBER )
8990: IS
8991: SELECT object_id_to1
8992: FROM pa_object_relationships
8993: --WHERE object_id_from1 = p_task_version_id --4173785
8994: WHERE object_id_from1 = c_task_version_id
8995: AND relationship_type = 'M';
8996:

Line 8997: l_fp_task_version_id PA_OBJECT_RELATIONSHIPS.object_id_to1%TYPE;

8993: --WHERE object_id_from1 = p_task_version_id --4173785
8994: WHERE object_id_from1 = c_task_version_id
8995: AND relationship_type = 'M';
8996:
8997: l_fp_task_version_id PA_OBJECT_RELATIONSHIPS.object_id_to1%TYPE;
8998: /* Bug #: 3305199 SMukka */
8999: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
9000: /* l_element_version_id_tbl PA_PLSQL_DATATYPES.IdTabTyp; */
9001: l_element_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Venky */

Line 9007: FROM pa_object_relationships pors

9003: --
9004: --Bug No 3450684 Smukka For Subproject Association
9005: CURSOR get_subproj_relation(cp_task_ver_id NUMBER) IS
9006: SELECT pors.object_relationship_id,pors.record_version_number
9007: FROM pa_object_relationships pors
9008: --bug 4573340
9009: ,pa_object_relationships pors1
9010: WHERE
9011: --pors.object_id_from1= cp_task_ver_id

Line 9009: ,pa_object_relationships pors1

9005: CURSOR get_subproj_relation(cp_task_ver_id NUMBER) IS
9006: SELECT pors.object_relationship_id,pors.record_version_number
9007: FROM pa_object_relationships pors
9008: --bug 4573340
9009: ,pa_object_relationships pors1
9010: WHERE
9011: --pors.object_id_from1= cp_task_ver_id
9012: pors1.object_id_from1 = cp_task_ver_id
9013: AND pors.object_id_from1 = pors1.object_id_to1

Line 9688: pa_object_relationships c

9684: CURSOR get_working_ver(c_option NUMBER) IS
9685: select a.element_version_id, c.object_id_from1
9686: from pa_proj_element_versions a,
9687: pa_proj_elem_ver_structure b,
9688: pa_object_relationships c
9689: where a.parent_structure_version_id = b.element_version_id
9690: and a.project_id = b.project_id
9691: and a.proj_element_id = p_task_id
9692: and a.element_version_id = c.object_id_to1

Line 9701: pa_object_relationships c

9697: UNION
9698: select a.element_version_id, c.object_id_from1
9699: from pa_proj_element_versions a,
9700: pa_proj_elem_ver_structure b,
9701: pa_object_relationships c
9702: where a.parent_structure_version_id = b.element_version_id
9703: and a.project_id = b.project_id
9704: and a.proj_element_id = p_task_id
9705: and a.element_version_id = c.object_id_to1

Line 9744: update pa_object_relationships

9740: LOOP
9741: FETCH get_working_ver into l_working_ver_id, l_working_parent_id;
9742: EXIT WHEN get_working_ver%NOTFOUND;
9743: --update selected tasks weighting
9744: update pa_object_relationships
9745: set WEIGHTING_PERCENTAGE = p_weighting
9746: where object_id_to1 = l_working_ver_id
9747: and relationship_type = 'S'
9748: and object_type_to = 'PA_TASKS';

Line 9794: ( SELECT object_id_to1 from pa_object_relationships

9790: CURSOR cur_task_hier( c_parent_structure_version_id NUMBER )
9791: IS
9792: SELECT proj_element_id, element_version_id
9793: FROM pa_proj_element_versions ppev,
9794: ( SELECT object_id_to1 from pa_object_relationships
9795: WHERE relationship_type = 'S'
9796: start with object_id_from1 = ( SELECT element_version_id
9797: FROM pa_proj_element_versions ppev
9798: WHERE ppev.proj_element_id = p_task_id

Line 10005: FROM pa_object_relationships

10001:
10002: CURSOR cur_get_parent_tasks(c_elem_ver_id number)
10003: IS
10004: SELECT object_id_from1
10005: FROM pa_object_relationships
10006: WHERE object_type_from IN ('PA_TASKS', 'PA_STRUCTURES')
10007: AND object_type_to = 'PA_TASKS'
10008: AND relationship_type ='S'
10009: CONNECT BY PRIOR OBJECT_ID_FROM1 = OBJECT_ID_TO1