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_OBJECT_RELATIONSHIPS

Line 2125: FROM pa_object_relationships pors,

2121: SELECT 'Y'
2122: FROM DUAL
2123: WHERE EXISTS(
2124: SELECT pors.object_relationship_id
2125: FROM pa_object_relationships pors,
2126: pa_object_relationships pors1
2127: WHERE pors1.object_id_from1 = c_task_version_id
2128: AND pors.object_id_from1 = pors1.object_id_to1
2129: AND pors1.relationship_type = 'S'

Line 2126: pa_object_relationships pors1

2122: FROM DUAL
2123: WHERE EXISTS(
2124: SELECT pors.object_relationship_id
2125: FROM pa_object_relationships pors,
2126: pa_object_relationships pors1
2127: WHERE pors1.object_id_from1 = c_task_version_id
2128: AND pors.object_id_from1 = pors1.object_id_to1
2129: AND pors1.relationship_type = 'S'
2130: AND pors.relationship_type IN ('LW','LF')

Line 3377: from pa_object_relationships

3373: --hsiu
3374: --added for task weighing
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

Line 3421: FROM pa_object_relationships

3417: )
3418: -- End of FP_M changes : Bug 3305199
3419: */
3420: AND b.element_version_id IN ( SELECT object_id_to1
3421: FROM pa_object_relationships
3422: WHERE relationship_type = 'S'
3423: START WITH object_id_from1 = x_element_version_id AND relationship_type = 'S'
3424: CONNECT BY object_id_from1 = PRIOR object_id_to1 AND relationship_type = prior relationship_type AND relationship_type = 'S' )
3425: UNION

Line 3525: FROM pa_object_relationships

3521: /* CURSOR cur_rev_parent_task( x_child_task_id NUMBER, x_wbs_level NUMBER )
3522: IS
3523: SELECT a.object_id_from1 parent_task_id
3524: FROM( SELECT object_id_from1
3525: FROM pa_object_relationships
3526: WHERE relationship_type = 'S'
3527: START WITH OBJECT_ID_TO1 = x_child_task_id
3528: --hsiu: bug 2669388
3529: -- START WITH object_id_from1 = x_child_task_id

Line 3542: FROM pa_object_relationships

3538: SELECT b.element_version_id parent_task_id
3539: FROM pa_proj_element_versions b
3540: WHERE b.wbs_level = x_wbs_level
3541: AND b.element_version_id IN ( SELECT object_id_from1
3542: FROM pa_object_relationships
3543: WHERE relationship_type = 'S'
3544: START WITH OBJECT_ID_TO1 = x_child_task_id
3545: --hsiu: bug 2669388
3546: -- START WITH object_id_from1 = x_child_task_id

Line 3659: from pa_object_relationships

3655: l_rollup_task_id NUMBER;
3656:
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';

Line 3689: from pa_object_relationships

3685:
3686: --hsiu added for task status
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;

Line 3744: pa_object_relationships obj

3740: IS
3741: SELECT
3742: 'x'
3743: FROM
3744: pa_object_relationships obj
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'

Line 5436: from pa_object_relationships a,

5432: --hsiu added, for dates rollup
5433: CURSOR get_peer_tasks
5434: IS
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.

Line 5437: pa_object_relationships b

5433: CURSOR get_peer_tasks
5434: IS
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

Line 5461: from pa_object_relationships

5457:
5458: --hsiu added for task status
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;

Line 5540: from pa_object_relationships

5536: --bug 3911698
5537: --cursor to get all child
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'

Line 5559: from pa_object_relationships

5555:
5556: --bug 3069306
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'

Line 5569: from pa_object_relationships a, pa_proj_element_versions b

5565: and prior object_type_from = object_type_to
5566: and prior relationship_type = relationship_type
5567: intersect
5568: select a.object_id_to1
5569: from pa_object_relationships a, pa_proj_element_versions b
5570: where a.relationshiP_type = 'S'
5571: and a.object_id_from1 = b.parent_structure_version_id
5572: and b.element_version_id = c_task_ver_id
5573: and a.object_type_from = 'PA_STRUCTURES';

Line 5784: FROM PA_OBJECT_RELATIONSHIPS

5780:
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');

Line 6621: from pa_object_relationships

6617:
6618: --hsiu added for task status
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;

Line 7166: from pa_object_relationships a,

7162: --hsiu added, for dates rollup
7163: CURSOR get_peer_tasks
7164: IS
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

Line 7167: pa_object_relationships b

7163: CURSOR get_peer_tasks
7164: IS
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

Line 7184: from pa_object_relationships

7180:
7181: --hsiu added for task status
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;

Line 7677: from pa_object_relationships

7673: l_task_unpub_ver_status_code PA_PROJ_ELEMENT_VERSIONS.TASK_UNPUB_VER_STATUS_CODE%TYPE;
7674:
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;

Line 8448: FROM PA_OBJECT_RELATIONSHIPS

8444: IS
8445: CURSOR get_child_count(c_parent_element_version_id NUMBER)
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');

Line 8458: pa_object_relationships por,

8454: CURSOR get_summed_duration(c_parent_element_version_id NUMBER)
8455: IS
8456: SELECT sum(ppevs.duration)
8457: FROM pa_proj_elem_ver_schedule ppevs,
8458: pa_object_relationships por,
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

Line 8484: FROM pa_object_relationships

8480:
8481: CURSOR get_parent(c_element_version_id NUMBER)
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');

Line 8504: FROM PA_OBJECT_RELATIONSHIPS

8500:
8501: CURSOR get_existing_weights(c_parent_element_version_id NUMBER)
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';

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

8512: -- on all the child tasks equally.
8513: CURSOR get_progressible_child_count(c_parent_element_version_id NUMBER)
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')

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

8545: l_total_sub_count NUMBER;
8546: l_total_duration NUMBER;
8547: l_progress_allowed VARCHAR2(1);
8548: l_task_duration NUMBER;
8549: -- l_task_weight PA_OBJECT_RELATIONSHIPS.weighting_percentage%TYPE;
8550: l_task_weight NUMBER;
8551: l_existing_weight NUMBER;
8552: l_remaining_weight NUMBER;
8553: l_project_id NUMBER;

Line 8610: UPDATE PA_OBJECT_RELATIONSHIPS

8606: l_outline_level := p_outline_level(i);
8607:
8608: if l_outline_level = 0 then
8609: -- Automatically update task weighting as zero
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')

Line 8635: UPDATE PA_OBJECT_RELATIONSHIPS

8631:
8632: if l_is_sub_new = 'N' then
8633: -- There were existing tasks at this level, populate
8634: -- task weights of new tasks to 0
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')

Line 8651: UPDATE PA_OBJECT_RELATIONSHIPS

8647: CLOSE check_progress_allowed;
8648:
8649: if l_progress_allowed = 'N' then
8650: -- Populate task weight as zero
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')

Line 8791: UPDATE PA_OBJECT_RELATIONSHIPS

8787: l_task_weight := l_remaining_weight;
8788: end if;
8789:
8790: --END IF; Bug 3098574.
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')

Line 8809: UPDATE PA_OBJECT_RELATIONSHIPS

8805: CLOSE check_progress_allowed;
8806:
8807: if l_progress_allowed = 'N' then
8808: -- Populate task weight as zero
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')

Line 8950: UPDATE PA_OBJECT_RELATIONSHIPS

8946: if(abs(l_remaining_weight - l_task_weight) <= .05) then
8947: l_task_weight := l_remaining_weight;
8948: end if;
8949: --END IF; Bug 3098574.
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')

Line 9117: FROM pa_object_relationships

9113: );
9114:
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:

Line 9127: FROM pa_object_relationships

9123: SELECT object_id_from1
9124: , object_relationship_id
9125: , record_version_number
9126: , relationship_subtype
9127: FROM pa_object_relationships
9128: WHERE object_id_to1 = p_child_version_id
9129: AND relationship_type = 'S';
9130:
9131: v_cur_obj_rel_rec cur_obj_rel%ROWTYPE;

Line 9136: FROM pa_object_relationships a

9132:
9133: CURSOR get_task_weighting(c_task_version_id NUMBER) IS
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');

Line 9147: FROM pa_object_relationships

9143: SELECT '1'
9144: FROM dual
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: );

Line 9240: from pa_object_relationships

9236:
9237: --bug 2843737
9238: CURSOR get_ref_parent_id(c_object_id_to1 NUMBER) is
9239: select object_id_from1
9240: from pa_object_relationships
9241: where object_id_to1 = c_object_id_to1
9242: and relationship_type = 'S';
9243: l_ref_parent_ver_id NUMBER;
9244: --end bug 2843737

Line 9323: from pa_object_relationships

9319:
9320: --bug 3069306
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'

Line 9334: from pa_object_relationships a, pa_proj_element_versions b

9330: and prior object_type_from = object_type_to
9331: and prior relationship_type = relationship_type
9332: intersect
9333: select a.object_id_to1
9334: from pa_object_relationships a, pa_proj_element_versions b
9335: where a.relationshiP_type = 'S'
9336: and a.object_id_from1 = b.parent_structure_version_id
9337: and b.element_version_id = c_task_ver_id
9338: and a.object_type_from = 'PA_STRUCTURES';

Line 9783: from pa_object_relationships

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
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

Line 10585: FROM pa_object_relationships

10581: );
10582:
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:

Line 10595: FROM pa_object_relationships

10591: SELECT object_id_from1
10592: , object_relationship_id
10593: , record_version_number
10594: , relationship_subtype
10595: FROM pa_object_relationships
10596: WHERE object_id_to1 = p_child_version_id
10597: AND relationship_type = 'S';
10598:
10599: v_cur_obj_rel_rec cur_obj_rel%ROWTYPE;

Line 10604: FROM pa_object_relationships a

10600:
10601: CURSOR get_task_weighting(c_task_version_id NUMBER) IS
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');

Line 10615: FROM pa_object_relationships

10611: SELECT '1'
10612: FROM dual
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: );

Line 10632: FROM pa_object_relationships a

10628: AND ppe.TYPE_ID = ptt.task_type_id;
10629:
10630: CURSOR get_peer_tasks IS
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

Line 10633: , pa_object_relationships b

10629:
10630: CURSOR get_peer_tasks IS
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

Line 10649: FROM pa_object_relationships por,

10645: --This cursor fetches all tasks that are child of ref task but now become child of p_task_version
10646: -- This case should not be possible for Outdent/Indent
10647: CURSOR cur_new_child(c_ref_task_version_id NUMBER, c_display_sequence NUMBER) IS
10648: SELECT por.object_id_to1, ppev.display_sequence, por.record_version_number, por.object_relationship_id
10649: FROM pa_object_relationships por,
10650: pa_proj_element_versions ppev
10651: WHERE object_id_from1 = c_ref_task_version_id
10652: AND object_id_to1 = element_version_id
10653: AND display_sequence > c_display_sequence

Line 10742: from pa_object_relationships

10738:
10739: --bug 2843737
10740: CURSOR get_ref_parent_id(c_object_id_to1 NUMBER) is
10741: select object_id_from1
10742: from pa_object_relationships
10743: where object_id_to1 = c_object_id_to1
10744: and relationship_type = 'S';
10745: l_ref_parent_ver_id NUMBER;
10746: --end bug 2843737

Line 10850: from pa_object_relationships

10846:
10847: --bug 3069306
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'

Line 10861: from pa_object_relationships a, pa_proj_element_versions b

10857: and prior object_type_from = object_type_to
10858: and prior relationship_type = relationship_type
10859: intersect
10860: select a.object_id_to1
10861: from pa_object_relationships a, pa_proj_element_versions b
10862: where a.relationshiP_type = 'S'
10863: and a.object_id_from1 = b.parent_structure_version_id
10864: and b.element_version_id = c_task_ver_id
10865: and a.object_type_from = 'PA_STRUCTURES';

Line 11208: from pa_object_relationships

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
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

Line 12424: l_type_to PA_OBJECT_RELATIONSHIPS.object_type_to%TYPE;

12420: l_return_status VARCHAR2(1);
12421: l_msg_count NUMBER;
12422: l_msg_data VARCHAR2(250);
12423: l_id_to NUMBER;
12424: l_type_to PA_OBJECT_RELATIONSHIPS.object_type_to%TYPE;
12425:
12426: l_data VARCHAR2(250);
12427: l_msg_index_out NUMBER;
12428: l_error_msg_code VARCHAR2(30);

Line 12482: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

12478: END IF;
12479:
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

Line 12511: UPDATE PA_OBJECT_RELATIONSHIPS

12507:
12508: END IF;
12509:
12510: IF p_relationship_id is not null and l_id_to is not null THEN
12511: UPDATE PA_OBJECT_RELATIONSHIPS
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

Line 12596: FROM PA_OBJECT_RELATIONSHIPS

12592:
12593: CURSOR task_associations( p_task_id NUMBER )
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:

Line 12690: PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW(

12686:
12687: BEGIN
12688:
12689: IF p_relationship_id is not null THEN
12690: PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW(
12691: p_object_relationship_id => p_relationship_id
12692: ,p_object_type_from => NULL
12693: ,p_object_id_from1 => NULL
12694: ,p_object_id_from2 => NULL

Line 12733: from pa_object_relationships

12729: )return VARCHAR2
12730: IS
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

Line 12762: from pa_object_relationships

12758: )return VARCHAR2
12759: IS
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:

Line 12850: FROM PA_OBJECT_RELATIONSHIPS

12846:
12847: CURSOR task_associations( p_task_id NUMBER )
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:

Line 12964: from pa_object_relationships

12960:
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:

Line 12969: l_object_type_to pa_object_relationships.object_type_to%Type;

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;
12970: l_object_id_to1 pa_object_relationships.object_id_to1%Type;
12971: x_relationship_id pa_object_relationships.object_relationship_id%type;
12972: l_ret_code VARCHAR2(1);
12973: l_data VARCHAR2(250);

Line 12970: l_object_id_to1 pa_object_relationships.object_id_to1%Type;

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;
12970: l_object_id_to1 pa_object_relationships.object_id_to1%Type;
12971: x_relationship_id pa_object_relationships.object_relationship_id%type;
12972: l_ret_code VARCHAR2(1);
12973: l_data VARCHAR2(250);
12974: l_msg_index_out NUMBER;

Line 12971: x_relationship_id pa_object_relationships.object_relationship_id%type;

12967: and relationship_type = p_relationship_type;
12968:
12969: l_object_type_to pa_object_relationships.object_type_to%Type;
12970: l_object_id_to1 pa_object_relationships.object_id_to1%Type;
12971: x_relationship_id pa_object_relationships.object_relationship_id%type;
12972: l_ret_code VARCHAR2(1);
12973: l_data VARCHAR2(250);
12974: l_msg_index_out NUMBER;
12975:

Line 13000: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

12996: open task_association(task_list_rec.old_task_id,p_relationship_type);
12997: fetch task_association into l_object_type_to, l_object_id_to1;
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

Line 15747: ,pa_object_relationships por1

15743: ,ppv1.task_unpub_ver_status_code task_unpub_ver_status_code
15744: FROM
15745: pa_proj_element_versions ppv1 -- linking task
15746: ,pa_proj_element_versions ppv2 -- linked project
15747: ,pa_object_relationships por1
15748: ,pa_object_relationships por2
15749: ,(SELECT object_id_from1, object_id_to1
15750: FROM pa_object_relationships
15751: START WITH object_id_from1 = c_task_version_id

Line 15748: ,pa_object_relationships por2

15744: FROM
15745: pa_proj_element_versions ppv1 -- linking task
15746: ,pa_proj_element_versions ppv2 -- linked project
15747: ,pa_object_relationships por1
15748: ,pa_object_relationships por2
15749: ,(SELECT object_id_from1, object_id_to1
15750: FROM pa_object_relationships
15751: START WITH object_id_from1 = c_task_version_id
15752: and relationship_type = 'S'

Line 15750: FROM pa_object_relationships

15746: ,pa_proj_element_versions ppv2 -- linked project
15747: ,pa_object_relationships por1
15748: ,pa_object_relationships por2
15749: ,(SELECT object_id_from1, object_id_to1
15750: FROM pa_object_relationships
15751: START WITH object_id_from1 = c_task_version_id
15752: and relationship_type = 'S'
15753: CONNECT BY object_id_from1 = PRIOR object_id_to1
15754: and relationship_type = 'S'

Line 15779: ,pa_object_relationships por

15775: ,por.record_version_number record_version_number
15776: ,por.relationship_type relationship_type
15777: FROM
15778: pa_proj_element_versions ppv -- linked project
15779: ,pa_object_relationships por
15780: ,(SELECT object_id_from1, object_id_to1 -- Get all sub tasks including linking tasks
15781: FROM pa_object_relationships
15782: START WITH object_id_from1 = c_task_version_id
15783: and relationship_type = 'S'

Line 15781: FROM pa_object_relationships

15777: FROM
15778: pa_proj_element_versions ppv -- linked project
15779: ,pa_object_relationships por
15780: ,(SELECT object_id_from1, object_id_to1 -- Get all sub tasks including linking tasks
15781: FROM pa_object_relationships
15782: START WITH object_id_from1 = c_task_version_id
15783: and relationship_type = 'S'
15784: CONNECT BY object_id_from1 = PRIOR object_id_to1
15785: and relationship_type = 'S'