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

[Home] [Help]

APPS.PA_TASK_PUB1 dependencies on PA_OBJECT_RELATIONSHIPS

Line 2138: FROM pa_object_relationships pors,

2134: SELECT 'Y'
2135: FROM DUAL
2136: WHERE EXISTS(
2137: SELECT pors.object_relationship_id
2138: FROM pa_object_relationships pors,
2139: pa_object_relationships pors1
2140: WHERE pors1.object_id_from1 = c_task_version_id
2141: AND pors.object_id_from1 = pors1.object_id_to1
2142: AND pors1.relationship_type = 'S'

Line 2139: pa_object_relationships pors1

2135: FROM DUAL
2136: WHERE EXISTS(
2137: SELECT pors.object_relationship_id
2138: FROM pa_object_relationships pors,
2139: pa_object_relationships pors1
2140: WHERE pors1.object_id_from1 = c_task_version_id
2141: AND pors.object_id_from1 = pors1.object_id_to1
2142: AND pors1.relationship_type = 'S'
2143: AND pors.relationship_type IN ('LW','LF')

Line 3446: from pa_object_relationships

3442: --hsiu
3443: --added for task weighing
3444: CURSOR get_cur_task_ver_weighting(c_ver_id NUMBER) IS
3445: select WEIGHTING_PERCENTAGE
3446: from pa_object_relationships
3447: where object_id_to1 = c_ver_id
3448: and object_type_to = 'PA_TASKS'
3449: and relationship_type = 'S';
3450: --end changes

Line 3490: FROM pa_object_relationships

3486: )
3487: -- End of FP_M changes : Bug 3305199
3488: */
3489: AND b.element_version_id IN ( SELECT object_id_to1
3490: FROM pa_object_relationships
3491: WHERE relationship_type = 'S'
3492: START WITH object_id_from1 = x_element_version_id AND relationship_type = 'S'
3493: CONNECT BY object_id_from1 = PRIOR object_id_to1 AND relationship_type = prior relationship_type AND relationship_type = 'S' )
3494: UNION

Line 3594: FROM pa_object_relationships

3590: /* CURSOR cur_rev_parent_task( x_child_task_id NUMBER, x_wbs_level NUMBER )
3591: IS
3592: SELECT a.object_id_from1 parent_task_id
3593: FROM( SELECT object_id_from1
3594: FROM pa_object_relationships
3595: WHERE relationship_type = 'S'
3596: START WITH OBJECT_ID_TO1 = x_child_task_id
3597: --hsiu: bug 2669388
3598: -- START WITH object_id_from1 = x_child_task_id

Line 3611: FROM pa_object_relationships

3607: SELECT b.element_version_id parent_task_id
3608: FROM pa_proj_element_versions b
3609: WHERE b.wbs_level = x_wbs_level
3610: AND b.element_version_id IN ( SELECT object_id_from1
3611: FROM pa_object_relationships
3612: WHERE relationship_type = 'S'
3613: START WITH OBJECT_ID_TO1 = x_child_task_id
3614: --hsiu: bug 2669388
3615: -- START WITH object_id_from1 = x_child_task_id

Line 3728: from pa_object_relationships

3724: l_rollup_task_id NUMBER;
3725:
3726: cursor sub_task_exists(l_parent_task_version_id NUMBER) IS
3727: select '1'
3728: from pa_object_relationships
3729: where object_id_from1 = l_parent_task_version_id
3730: and object_type_from IN ('PA_TASKS','PA_STRUCTURES')
3731: and object_type_to IN ('PA_TASKS','PA_STRUCTURES')
3732: and relationship_type = 'S';

Line 3758: from pa_object_relationships

3754:
3755: --hsiu added for task status
3756: CURSOR get_parent_version_id(c_elem_ver_id NUMBER) IS
3757: select object_id_from1
3758: from pa_object_relationships
3759: where object_id_to1 = c_elem_ver_id
3760: and object_type_to = 'PA_TASKS'
3761: and relationship_type = 'S';
3762: l_parent_ver_id NUMBER;

Line 3845: pa_object_relationships obj

3841: IS
3842: SELECT
3843: 'x'
3844: FROM
3845: pa_object_relationships obj
3846: WHERE
3847: obj.object_id_to1 = task_ver_id
3848: AND obj.object_id_from1 = struct_ver_id
3849: AND object_type_from = 'PA_STRUCTURES'

Line 5711: from pa_object_relationships a,

5707: --hsiu added, for dates rollup
5708: CURSOR get_peer_tasks
5709: IS
5710: select b.object_id_to1 object_id_to1
5711: from pa_object_relationships a,
5712: pa_object_relationships b
5713: where a.object_id_to1 = p_task_version_id
5714: and a.object_type_to = 'PA_TASKS'
5715: and a.relationship_type = 'S' -- Bug # 4622939.

Line 5712: pa_object_relationships b

5708: CURSOR get_peer_tasks
5709: IS
5710: select b.object_id_to1 object_id_to1
5711: from pa_object_relationships a,
5712: pa_object_relationships b
5713: where a.object_id_to1 = p_task_version_id
5714: and a.object_type_to = 'PA_TASKS'
5715: and a.relationship_type = 'S' -- Bug # 4622939.
5716: and a.object_id_from1 = b.object_id_from1

Line 5736: from pa_object_relationships

5732:
5733: --hsiu added for task status
5734: CURSOR get_parent_version_id(c_elem_ver_id NUMBER) IS
5735: select object_id_from1
5736: from pa_object_relationships
5737: where object_id_to1 = c_elem_ver_id
5738: and object_type_to = 'PA_TASKS'
5739: and relationship_type = 'S';
5740: l_parent_ver_id NUMBER;

Line 5815: from pa_object_relationships

5811: --bug 3911698
5812: --cursor to get all child
5813: cursor get_child_ver_id(c_task_ver_id NUMBER) IS
5814: select object_id_to1
5815: from pa_object_relationships
5816: where relationship_type = 'S'
5817: and object_type_to = 'PA_TASKS'
5818: start with object_id_from1 = c_task_ver_id
5819: and object_type_from = 'PA_TASKS'

Line 5834: from pa_object_relationships

5830:
5831: --bug 3069306
5832: Cursor get_top_task_ver_id(c_task_ver_id NUMBER) IS
5833: select object_id_to1
5834: from pa_object_relationships
5835: where relationshiP_type = 'S'
5836: and object_type_to = 'PA_TASKS'
5837: start with object_id_to1 = c_task_ver_id
5838: and object_type_to = 'PA_TASKS'

Line 5844: from pa_object_relationships a, pa_proj_element_versions b

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

Line 6059: FROM PA_OBJECT_RELATIONSHIPS

6055:
6056: -- get the parent of the task being moved
6057: SELECT object_id_from1, object_type_from
6058: INTO l_parent_id, l_parent_object_type
6059: FROM PA_OBJECT_RELATIONSHIPS
6060: WHERE object_type_to = 'PA_TASKS'
6061: AND object_id_to1 = p_task_version_id
6062: AND relationship_type = 'S'
6063: AND object_type_from in ('PA_STRUCTURES', 'PA_TASKS');

Line 6904: from pa_object_relationships

6900:
6901: --hsiu added for task status
6902: CURSOR get_parent_version_id(c_elem_ver_id NUMBER) IS
6903: select object_id_from1
6904: from pa_object_relationships
6905: where object_id_to1 = c_elem_ver_id
6906: and object_type_to = 'PA_TASKS'
6907: and relationship_type = 'S';
6908: l_parent_ver_id NUMBER;

Line 7463: from pa_object_relationships a,

7459: --hsiu added, for dates rollup
7460: CURSOR get_peer_tasks
7461: IS
7462: select b.object_id_to1 object_id_to1
7463: from pa_object_relationships a,
7464: pa_object_relationships b
7465: where a.object_id_to1 = p_task_version_id
7466: and a.object_type_to = 'PA_TASKS'
7467: and a.object_id_from1 = b.object_id_from1

Line 7464: pa_object_relationships b

7460: CURSOR get_peer_tasks
7461: IS
7462: select b.object_id_to1 object_id_to1
7463: from pa_object_relationships a,
7464: pa_object_relationships b
7465: where a.object_id_to1 = p_task_version_id
7466: and a.object_type_to = 'PA_TASKS'
7467: and a.object_id_from1 = b.object_id_from1
7468: and a.object_type_from = b.object_type_from

Line 7481: from pa_object_relationships

7477:
7478: --hsiu added for task status
7479: CURSOR get_parent_version_id(c_elem_ver_id NUMBER) IS
7480: select object_id_from1
7481: from pa_object_relationships
7482: where object_id_to1 = c_elem_ver_id
7483: and object_type_to = 'PA_TASKS'
7484: and relationship_type = 'S';
7485: l_parent_ver_id NUMBER;

Line 7974: from pa_object_relationships

7970: l_task_unpub_ver_status_code PA_PROJ_ELEMENT_VERSIONS.TASK_UNPUB_VER_STATUS_CODE%TYPE;
7971:
7972: CURSOR get_parent_version_id(c_elem_ver_id NUMBER) IS
7973: select object_id_from1
7974: from pa_object_relationships
7975: where object_id_to1 = c_elem_ver_id
7976: and object_type_to = 'PA_TASKS'
7977: and relationship_type = 'S';
7978: l_parent_ver_id NUMBER;

Line 8811: FROM PA_OBJECT_RELATIONSHIPS

8807: IS
8808: CURSOR get_child_count(c_parent_element_version_id NUMBER)
8809: IS
8810: SELECT count(object_id_to1)
8811: FROM PA_OBJECT_RELATIONSHIPS
8812: WHERE object_id_from1 = c_parent_element_version_id
8813: AND object_type_to = 'PA_TASKS'
8814: AND relationship_type = 'S'
8815: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');

Line 8821: pa_object_relationships por,

8817: CURSOR get_summed_duration(c_parent_element_version_id NUMBER)
8818: IS
8819: SELECT sum(ppevs.duration)
8820: FROM pa_proj_elem_ver_schedule ppevs,
8821: pa_object_relationships por,
8822: pa_proj_element_versions ppev,
8823: pa_proj_elements ppe,
8824: pa_task_types ptt
8825: WHERE por.object_id_from1 = c_parent_element_version_id

Line 8847: FROM pa_object_relationships

8843:
8844: CURSOR get_parent(c_element_version_id NUMBER)
8845: IS
8846: SELECT object_id_from1
8847: FROM pa_object_relationships
8848: WHERE object_id_to1 = c_element_version_id
8849: AND object_type_to = 'PA_TASKS'
8850: AND relationship_type = 'S'
8851: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');

Line 8867: FROM PA_OBJECT_RELATIONSHIPS

8863:
8864: CURSOR get_existing_weights(c_parent_element_version_id NUMBER)
8865: IS
8866: SELECT sum(weighting_percentage)
8867: FROM PA_OBJECT_RELATIONSHIPS
8868: WHERE object_id_from1 = c_parent_element_version_id
8869: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
8870: AND object_type_to = 'PA_TASKS'
8871: AND relationship_type = 'S';

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

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

Line 8912: -- l_task_weight PA_OBJECT_RELATIONSHIPS.weighting_percentage%TYPE;

8908: l_total_sub_count NUMBER;
8909: l_total_duration NUMBER;
8910: l_progress_allowed VARCHAR2(1);
8911: l_task_duration NUMBER;
8912: -- l_task_weight PA_OBJECT_RELATIONSHIPS.weighting_percentage%TYPE;
8913: l_task_weight NUMBER;
8914: l_existing_weight NUMBER;
8915: l_remaining_weight NUMBER;
8916: l_project_id NUMBER;

Line 8973: UPDATE PA_OBJECT_RELATIONSHIPS

8969: l_outline_level := p_outline_level(i);
8970:
8971: if l_outline_level = 0 then
8972: -- Automatically update task weighting as zero
8973: UPDATE PA_OBJECT_RELATIONSHIPS
8974: SET weighting_percentage = 0
8975: WHERE object_id_from1 = l_parent_element_version_id
8976: AND object_id_to1 = l_element_version_id
8977: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

Line 8998: UPDATE PA_OBJECT_RELATIONSHIPS

8994:
8995: if l_is_sub_new = 'N' then
8996: -- There were existing tasks at this level, populate
8997: -- task weights of new tasks to 0
8998: UPDATE PA_OBJECT_RELATIONSHIPS
8999: SET weighting_percentage = 0
9000: WHERE object_id_from1 = l_parent_element_version_id
9001: AND object_id_to1 = l_element_version_id
9002: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

Line 9014: UPDATE PA_OBJECT_RELATIONSHIPS

9010: CLOSE check_progress_allowed;
9011:
9012: if l_progress_allowed = 'N' then
9013: -- Populate task weight as zero
9014: UPDATE PA_OBJECT_RELATIONSHIPS
9015: SET weighting_percentage = 0
9016: WHERE object_id_from1 = l_parent_element_version_id
9017: AND object_id_to1 = l_element_version_id
9018: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

Line 9154: UPDATE PA_OBJECT_RELATIONSHIPS

9150: l_task_weight := l_remaining_weight;
9151: end if;
9152:
9153: --END IF; Bug 3098574.
9154: UPDATE PA_OBJECT_RELATIONSHIPS
9155: SET weighting_percentage = l_task_weight
9156: WHERE object_id_from1 = l_parent_element_version_id
9157: AND object_id_to1 = l_element_version_id
9158: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

Line 9172: UPDATE PA_OBJECT_RELATIONSHIPS

9168: CLOSE check_progress_allowed;
9169:
9170: if l_progress_allowed = 'N' then
9171: -- Populate task weight as zero
9172: UPDATE PA_OBJECT_RELATIONSHIPS
9173: SET weighting_percentage = 0
9174: WHERE object_id_from1 = l_parent_element_version_id
9175: AND object_id_to1 = l_element_version_id
9176: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

Line 9313: UPDATE PA_OBJECT_RELATIONSHIPS

9309: if(abs(l_remaining_weight - l_task_weight) <= .05) then
9310: l_task_weight := l_remaining_weight;
9311: end if;
9312: --END IF; Bug 3098574.
9313: UPDATE PA_OBJECT_RELATIONSHIPS
9314: SET weighting_percentage = l_task_weight
9315: WHERE object_id_from1 = l_parent_element_version_id
9316: AND object_id_to1 = l_element_version_id
9317: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

Line 9480: FROM pa_object_relationships

9476: );
9477:
9478: CURSOR get_parent_version_id(c_elem_ver_id NUMBER) IS
9479: SELECT object_id_from1
9480: FROM pa_object_relationships
9481: WHERE object_id_to1 = c_elem_ver_id
9482: AND object_type_to = 'PA_TASKS'
9483: AND relationship_type = 'S';
9484:

Line 9490: FROM pa_object_relationships

9486: SELECT object_id_from1
9487: , object_relationship_id
9488: , record_version_number
9489: , relationship_subtype
9490: FROM pa_object_relationships
9491: WHERE object_id_to1 = p_child_version_id
9492: AND relationship_type = 'S';
9493:
9494: v_cur_obj_rel_rec cur_obj_rel%ROWTYPE;

Line 9499: FROM pa_object_relationships a

9495:
9496: CURSOR get_task_weighting(c_task_version_id NUMBER) IS
9497: SELECT a.object_id_from1
9498: , a.weighting_percentage
9499: FROM pa_object_relationships a
9500: WHERE a.object_id_to1 = c_task_version_id
9501: AND a.object_type_to = 'PA_TASKS'
9502: AND a.relationship_type = 'S'
9503: AND a.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');

Line 9510: FROM pa_object_relationships

9506: SELECT '1'
9507: FROM dual
9508: WHERE EXISTS
9509: (SELECT 'xyz'
9510: FROM pa_object_relationships
9511: WHERE object_id_from1 = c_task_version_id
9512: AND object_type_from IN ('PA_TASKS', 'PA_STRUCTURES')
9513: AND relationship_type = 'S'
9514: );

Line 9603: from pa_object_relationships

9599:
9600: --bug 2843737
9601: CURSOR get_ref_parent_id(c_object_id_to1 NUMBER) is
9602: select object_id_from1
9603: from pa_object_relationships
9604: where object_id_to1 = c_object_id_to1
9605: and relationship_type = 'S';
9606: l_ref_parent_ver_id NUMBER;
9607: --end bug 2843737

Line 9686: from pa_object_relationships

9682:
9683: --bug 3069306
9684: Cursor get_top_task_ver_id(c_task_ver_id NUMBER) IS
9685: select object_id_to1
9686: from pa_object_relationships
9687: where relationshiP_type = 'S'
9688: and object_type_to = 'PA_TASKS'
9689: start with object_id_to1 = c_task_ver_id
9690: and object_type_to = 'PA_TASKS'

Line 9697: from pa_object_relationships a, pa_proj_element_versions b

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

Line 10163: from pa_object_relationships

10159: AND(
10160: element_version_id = p_task_version_id -- Source task itself
10161: OR (element_version_id IN -- All tasks below the source task with wbs_level >= src_wbs_level-1
10162: (select object_id_to1
10163: from pa_object_relationships
10164: where relationship_type = 'S'
10165: and object_type_to = 'PA_TASKS'
10166: start with object_id_from1 = l_ref_parent_ver_id
10167: connect by object_id_from1 = PRIOR object_id_to1

Line 10965: FROM pa_object_relationships

10961: );
10962:
10963: CURSOR get_parent_version_id(c_elem_ver_id NUMBER) IS
10964: SELECT object_id_from1
10965: FROM pa_object_relationships
10966: WHERE object_id_to1 = c_elem_ver_id
10967: AND object_type_to = 'PA_TASKS'
10968: AND relationship_type = 'S';
10969:

Line 10975: FROM pa_object_relationships

10971: SELECT object_id_from1
10972: , object_relationship_id
10973: , record_version_number
10974: , relationship_subtype
10975: FROM pa_object_relationships
10976: WHERE object_id_to1 = p_child_version_id
10977: AND relationship_type = 'S';
10978:
10979: v_cur_obj_rel_rec cur_obj_rel%ROWTYPE;

Line 10984: FROM pa_object_relationships a

10980:
10981: CURSOR get_task_weighting(c_task_version_id NUMBER) IS
10982: SELECT a.object_id_from1
10983: , a.weighting_percentage
10984: FROM pa_object_relationships a
10985: WHERE a.object_id_to1 = c_task_version_id
10986: AND a.object_type_to = 'PA_TASKS'
10987: AND a.relationship_type = 'S'
10988: AND a.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');

Line 10995: FROM pa_object_relationships

10991: SELECT '1'
10992: FROM dual
10993: WHERE EXISTS
10994: (SELECT 'xyz'
10995: FROM pa_object_relationships
10996: WHERE object_id_from1 = c_task_version_id
10997: AND object_type_from IN ('PA_TASKS', 'PA_STRUCTURES')
10998: AND relationship_type = 'S'
10999: );

Line 11012: FROM pa_object_relationships a

11008: AND ppe.TYPE_ID = ptt.task_type_id;
11009:
11010: CURSOR get_peer_tasks IS
11011: SELECT b.object_id_to1 object_id_to1
11012: FROM pa_object_relationships a
11013: , pa_object_relationships b
11014: WHERE a.object_id_to1 = p_task_version_id
11015: AND a.object_type_to = 'PA_TASKS'
11016: AND a.object_id_from1 = b.object_id_from1

Line 11013: , pa_object_relationships b

11009:
11010: CURSOR get_peer_tasks IS
11011: SELECT b.object_id_to1 object_id_to1
11012: FROM pa_object_relationships a
11013: , pa_object_relationships b
11014: WHERE a.object_id_to1 = p_task_version_id
11015: AND a.object_type_to = 'PA_TASKS'
11016: AND a.object_id_from1 = b.object_id_from1
11017: AND a.object_type_from = b.object_type_from

Line 11029: FROM pa_object_relationships por,

11025: --This cursor fetches all tasks that are child of ref task but now become child of p_task_version
11026: -- This case should not be possible for Outdent/Indent
11027: CURSOR cur_new_child(c_ref_task_version_id NUMBER, c_display_sequence NUMBER) IS
11028: SELECT por.object_id_to1, ppev.display_sequence, por.record_version_number, por.object_relationship_id
11029: FROM pa_object_relationships por,
11030: pa_proj_element_versions ppev
11031: WHERE object_id_from1 = c_ref_task_version_id
11032: AND object_id_to1 = element_version_id
11033: AND display_sequence > c_display_sequence

Line 11122: from pa_object_relationships

11118:
11119: --bug 2843737
11120: CURSOR get_ref_parent_id(c_object_id_to1 NUMBER) is
11121: select object_id_from1
11122: from pa_object_relationships
11123: where object_id_to1 = c_object_id_to1
11124: and relationship_type = 'S';
11125: l_ref_parent_ver_id NUMBER;
11126: --end bug 2843737

Line 11230: from pa_object_relationships

11226:
11227: --bug 3069306
11228: Cursor get_top_task_ver_id(c_task_ver_id NUMBER) IS
11229: select object_id_to1
11230: from pa_object_relationships
11231: where relationshiP_type = 'S'
11232: and object_type_to = 'PA_TASKS'
11233: start with object_id_to1 = c_task_ver_id
11234: and object_type_to = 'PA_TASKS'

Line 11241: from pa_object_relationships a, pa_proj_element_versions b

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

Line 11264: FROM pa_object_relationships por,

11260: --Cursor to check if there are any child tasks (which are set to financial tasks) are present to
11261: --ref task but now become child of p_task_version_id
11262: CURSOR cur_child_tasks_exists(c_ref_task_version_id NUMBER, c_display_sequence NUMBER) IS
11263: SELECT 'Y'
11264: FROM pa_object_relationships por,
11265: pa_proj_element_versions ppev
11266: WHERE object_id_from1 = c_ref_task_version_id
11267: AND object_id_to1 = element_version_id
11268: AND display_sequence > c_display_sequence

Line 11624: from pa_object_relationships

11620: AND(
11621: element_version_id = p_task_version_id -- Source task itself
11622: OR element_version_id IN -- All tasks below the source task
11623: (select object_id_to1
11624: from pa_object_relationships
11625: where relationship_type = 'S'
11626: and object_type_to = 'PA_TASKS'
11627: start with object_id_from1 = l_ref_parent_ver_id
11628: connect by object_id_from1 = PRIOR object_id_to1

Line 12678: FROM pa_object_relationships pors

12674: AND rownum = 1;
12675:
12676: CURSOR get_all_subtasks(c_task_version_id NUMBER) IS
12677: SELECT object_id_to1 task_ver_id
12678: FROM pa_object_relationships pors
12679: START WITH object_id_from1 = c_task_version_id
12680: AND relationship_type = 'S'
12681: AND object_type_from = 'PA_TASKS'
12682: AND object_type_to = 'PA_TASKS'

Line 12948: l_type_to PA_OBJECT_RELATIONSHIPS.object_type_to%TYPE;

12944: l_return_status VARCHAR2(1);
12945: l_msg_count NUMBER;
12946: l_msg_data VARCHAR2(250);
12947: l_id_to NUMBER;
12948: l_type_to PA_OBJECT_RELATIONSHIPS.object_type_to%TYPE;
12949:
12950: l_data VARCHAR2(250);
12951: l_msg_index_out NUMBER;
12952: l_error_msg_code VARCHAR2(30);

Line 13006: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

13002: END IF;
13003:
13004: -- Create a new association row
13005: IF p_relationship_id is NULL and x_return_status = FND_API.G_RET_STS_SUCCESS THEN
13006: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
13007: p_user_id => FND_GLOBAL.USER_ID
13008: ,p_object_type_from => 'PA_TASKS'
13009: ,p_object_id_from1 => p_task_id
13010: ,p_object_id_from2 => NULL

Line 13035: UPDATE PA_OBJECT_RELATIONSHIPS

13031:
13032: END IF;
13033:
13034: IF p_relationship_id is not null and l_id_to is not null THEN
13035: UPDATE PA_OBJECT_RELATIONSHIPS
13036: SET object_id_to1 = l_id_to
13037: ,object_type_to = l_type_to
13038: WHERE object_relationship_id = p_relationship_id;
13039: --WHERE object_id_from1 = p_task_id

Line 13120: FROM PA_OBJECT_RELATIONSHIPS

13116:
13117: CURSOR task_associations( p_task_id NUMBER )
13118: IS
13119: SELECT object_relationship_id
13120: FROM PA_OBJECT_RELATIONSHIPS
13121: WHERE relationship_type = p_relationship_type
13122: AND ( (object_type_from = 'PA_TASKS' AND object_id_from1 = p_task_id)
13123: OR (object_type_to = 'PA_TASKS' AND object_id_to1 = p_task_id));
13124:

Line 13214: PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW(

13210:
13211: BEGIN
13212:
13213: IF p_relationship_id is not null THEN
13214: PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW(
13215: p_object_relationship_id => p_relationship_id
13216: ,p_object_type_from => NULL
13217: ,p_object_id_from1 => NULL
13218: ,p_object_id_from2 => NULL

Line 13257: from pa_object_relationships

13253: )return VARCHAR2
13254: IS
13255: cursor relationship_exists(p_task_id NUMBER) IS
13256: select '1'
13257: from pa_object_relationships
13258: WHERE relationship_type = p_relationship_type
13259: AND ( (object_type_from = 'PA_TASKS' AND object_id_from1 = p_task_id
13260: AND object_type_to in ( 'PA_STRUCTURES', 'PA_TASKS')) --bug 4091647
13261: OR (object_type_to = 'PA_TASKS' AND object_id_to1 = p_task_id

Line 13286: from pa_object_relationships

13282: )return VARCHAR2
13283: IS
13284: cursor relationship_exists(p_project_id NUMBER) IS
13285: select '1'
13286: from pa_object_relationships
13287: WHERE relationship_type = p_relationship_type
13288: AND object_type_from = 'PA_TASKS'
13289: AND object_type_to = 'PA_PROJECTS' AND object_id_to1 = p_project_id;
13290:

Line 13374: FROM PA_OBJECT_RELATIONSHIPS

13370:
13371: CURSOR task_associations( p_task_id NUMBER )
13372: IS
13373: SELECT object_relationship_id
13374: FROM PA_OBJECT_RELATIONSHIPS
13375: WHERE relationship_type = p_relationship_type
13376: AND object_type_from = 'PA_TASKS'
13377: AND object_type_to = 'PA_PROJECTS' AND object_id_to1 = p_project_id;
13378:

Line 13488: from pa_object_relationships

13484:
13485: CURSOR task_association( task_id NUMBER, p_relationship_type VARCHAR2 )
13486: IS
13487: Select object_type_to, object_id_to1
13488: from pa_object_relationships
13489: where object_type_from = 'PA_TASKS'
13490: and object_id_from1 = task_id
13491: and relationship_type = p_relationship_type;
13492:

Line 13493: l_object_type_to pa_object_relationships.object_type_to%Type;

13489: where object_type_from = 'PA_TASKS'
13490: and object_id_from1 = task_id
13491: and relationship_type = p_relationship_type;
13492:
13493: l_object_type_to pa_object_relationships.object_type_to%Type;
13494: l_object_id_to1 pa_object_relationships.object_id_to1%Type;
13495: x_relationship_id pa_object_relationships.object_relationship_id%type;
13496: l_ret_code VARCHAR2(1);
13497: l_data VARCHAR2(250);

Line 13494: l_object_id_to1 pa_object_relationships.object_id_to1%Type;

13490: and object_id_from1 = task_id
13491: and relationship_type = p_relationship_type;
13492:
13493: l_object_type_to pa_object_relationships.object_type_to%Type;
13494: l_object_id_to1 pa_object_relationships.object_id_to1%Type;
13495: x_relationship_id pa_object_relationships.object_relationship_id%type;
13496: l_ret_code VARCHAR2(1);
13497: l_data VARCHAR2(250);
13498: l_msg_index_out NUMBER;

Line 13495: x_relationship_id pa_object_relationships.object_relationship_id%type;

13491: and relationship_type = p_relationship_type;
13492:
13493: l_object_type_to pa_object_relationships.object_type_to%Type;
13494: l_object_id_to1 pa_object_relationships.object_id_to1%Type;
13495: x_relationship_id pa_object_relationships.object_relationship_id%type;
13496: l_ret_code VARCHAR2(1);
13497: l_data VARCHAR2(250);
13498: l_msg_index_out NUMBER;
13499:

Line 13524: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

13520: open task_association(task_list_rec.old_task_id,p_relationship_type);
13521: fetch task_association into l_object_type_to, l_object_id_to1;
13522: IF task_association%found THEN
13523:
13524: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
13525: p_user_id => FND_GLOBAL.USER_ID
13526: ,p_object_type_from => 'PA_TASKS'
13527: ,p_object_id_from1 => task_list_rec.new_task_id
13528: ,p_object_id_from2 => NULL

Line 16404: ,pa_object_relationships por1

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

Line 16405: ,pa_object_relationships por2

16401: FROM
16402: pa_proj_element_versions ppv1 -- linking task
16403: ,pa_proj_element_versions ppv2 -- linked project
16404: ,pa_object_relationships por1
16405: ,pa_object_relationships por2
16406: ,(SELECT object_id_from1, object_id_to1
16407: FROM pa_object_relationships
16408: START WITH object_id_from1 = c_task_version_id
16409: and relationship_type = 'S'

Line 16407: FROM pa_object_relationships

16403: ,pa_proj_element_versions ppv2 -- linked project
16404: ,pa_object_relationships por1
16405: ,pa_object_relationships por2
16406: ,(SELECT object_id_from1, object_id_to1
16407: FROM pa_object_relationships
16408: START WITH object_id_from1 = c_task_version_id
16409: and relationship_type = 'S'
16410: CONNECT BY object_id_from1 = PRIOR object_id_to1
16411: and relationship_type = 'S'

Line 16436: ,pa_object_relationships por

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

Line 16438: FROM pa_object_relationships

16434: FROM
16435: pa_proj_element_versions ppv -- linked project
16436: ,pa_object_relationships por
16437: ,(SELECT object_id_from1, object_id_to1 -- Get all sub tasks including linking tasks
16438: FROM pa_object_relationships
16439: START WITH object_id_from1 = c_task_version_id
16440: and relationship_type = 'S'
16441: CONNECT BY object_id_from1 = PRIOR object_id_to1
16442: and relationship_type = 'S'

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

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