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

Line 1828: from pa_object_relationships por, pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs

1824:
1825: cursor cur_relationship_ids(c_structure_version_id NUMBER, c_project_id NUMBER)
1826: is select por.object_relationship_id, por.record_version_number
1827: , por2.object_id_from1, por.object_id_from2, por.comments, ppa.name -- Bug # 4556844.
1828: from pa_object_relationships por, pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs
1829: , pa_projects_all ppa, pa_object_relationships por2 -- Bug # 4556844.
1830: where ppevs.element_version_id = ppev.parent_structure_version_id
1831: and ppevs.project_id = ppev.project_id
1832: and ppev.element_version_id = por.object_id_to1

Line 1829: , pa_projects_all ppa, pa_object_relationships por2 -- Bug # 4556844.

1825: cursor cur_relationship_ids(c_structure_version_id NUMBER, c_project_id NUMBER)
1826: is select por.object_relationship_id, por.record_version_number
1827: , por2.object_id_from1, por.object_id_from2, por.comments, ppa.name -- Bug # 4556844.
1828: from pa_object_relationships por, pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs
1829: , pa_projects_all ppa, pa_object_relationships por2 -- Bug # 4556844.
1830: where ppevs.element_version_id = ppev.parent_structure_version_id
1831: and ppevs.project_id = ppev.project_id
1832: and ppev.element_version_id = por.object_id_to1
1833: and ppev.project_id = por.object_id_to2

Line 2517: from pa_object_relationships por

2513: -- Begin fix for Bug # 4483222.
2514:
2515: cursor l_cur_rel_id(p_str_ver_id NUMBER) is
2516: select por.object_relationship_id, por.record_version_number
2517: from pa_object_relationships por
2518: where por.object_id_to1 = p_str_ver_id
2519: and por.relationship_type in ('LW', 'LF');
2520:
2521: l_rec_rel_id l_cur_rel_id%ROWTYPE;

Line 3009: l_new_obj_rel_id PA_OBJECT_RELATIONSHIPS.OBJECT_RELATIONSHIP_ID%TYPE;

3005: l_tmp_struct_ver_id NUMBER;
3006: -- added for Bug fix: 4537865
3007: l_new_pev_structure_id PA_PROJ_ELEM_VER_STRUCTURE.PEV_STRUCTURE_ID%TYPE;
3008: l_new_pev_schedule_id PA_PROJ_ELEM_VER_SCHEDULE.PEV_SCHEDULE_ID%TYPE;
3009: l_new_obj_rel_id PA_OBJECT_RELATIONSHIPS.OBJECT_RELATIONSHIP_ID%TYPE;
3010:
3011: l_original_baseline_flag VARCHAR2(1);
3012: l_current_baseline_flag VARCHAR2(1);
3013:

Line 3060: from pa_object_relationships

3056:
3057: cursor get_from_id(c_element_version_id NUMBER) IS
3058: select object_relationship_id, object_id_from1 object_id_from,
3059: object_type_from, record_version_number
3060: from pa_object_relationships
3061: where relationship_type = 'L'
3062: and object_id_to1 = c_element_version_id
3063: and object_type_to IN ('PA_TASKS','PA_STRUCTURES');
3064: l_from_object_info get_from_id%ROWTYPE;

Line 3069: from pa_object_relationships

3065:
3066: cursor get_to_id(c_element_version_id NUMBER) IS
3067: select object_relationship_id, object_id_to1 object_id_to, object_id_to2,
3068: object_type_to, record_version_number
3069: from pa_object_relationships
3070: where relationship_type IN ('LW', 'LF')
3071: and object_id_from1 = c_element_version_id
3072: and object_type_from IN ('PA_TASKS','PA_STRUCTURES');
3073: l_to_object_info get_to_id%ROWTYPE;

Line 3129: PA_OBJECT_RELATIONSHIPS b

3125: SELECT a.element_version_id, a.proj_element_id, a.display_sequence, a.wbs_level,
3126: a.project_id, b.object_id_from1 parent_element_version_id,
3127: a.TASK_UNPUB_VER_STATUS_CODE, a.parent_structure_version_id
3128: FROM PA_PROJ_ELEMENT_VERSIONS a,
3129: PA_OBJECT_RELATIONSHIPS b
3130: WHERE a.object_type = 'PA_TASKS'
3131: AND a.parent_structure_version_id = c_structure_version_id
3132: AND a.element_version_id = b.object_id_to1
3133: AND b.relationship_type = 'S'

Line 3188: from pa_object_relationships

3184:
3185: CURSOR get_task_ver_weighting(p_task_ver_id NUMBER)
3186: IS
3187: select weighting_percentage
3188: from pa_object_relationships
3189: where object_id_to1 = p_task_ver_id
3190: and object_type_to = 'PA_TASKS'
3191: and object_type_from in ('PA_STRUCTURES','PA_TASKS')
3192: and object_type_to = 'PA_TASKS' -- Bug 6429275

Line 3223: from pa_object_relationships

3219: l_tbd_tasks_info_rec get_tbd_tasks_info%ROWTYPE;
3220:
3221: CURSOR get_parent_id(c_task_ver_id NUMBER) IS
3222: select object_id_from1
3223: from pa_object_relationships
3224: where object_id_to1 = c_task_ver_id
3225: and object_type_to = 'PA_TASKS'
3226: and relationship_type = 'S';
3227: l_parent_id NUMBER;

Line 3235: from pa_object_relationships

3231:
3232: --bug 2662139
3233: CURSOR is_summary_elem(c_elem_ver_id NUMBER) IS
3234: SELECT '1'
3235: from pa_object_relationships
3236: where object_type_from IN ('PA_TASKS', 'PA_STRUCTURES')
3237: and object_id_from1 = c_elem_ver_id
3238: and relationship_type = 'S';
3239:

Line 3818: -- PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

3814: -- OPEN get_structure_version_info(l_to_object_info.object_id_to);
3815: -- FETCH get_structure_version_info INTO l_info_struc_ver_rec;
3816: /*****************************/
3817: --dbms_output.put_line('creating rel: structure out going links for structures');
3818: -- PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
3819: -- p_user_id => FND_GLOBAL.USER_ID
3820: -- ,p_object_type_from => 'PA_STRUCTURES'
3821: -- ,p_object_id_from1 => l_new_struct_ver_id
3822: -- ,p_object_id_from2 => NULL

Line 3854: -- PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

3850: -- OPEN get_task_version_info(l_to_object_info.object_id_to);
3851: -- FETCH get_task_version_info INTO l_info_task_ver_rec;
3852: /*****************************/
3853: --dbms_output.put_line('creating rel: structure out going links for tasks');
3854: -- PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
3855: -- p_user_id => FND_GLOBAL.USER_ID
3856: -- ,p_object_type_from => 'PA_STRUCTURES'
3857: -- ,p_object_id_from1 => l_new_struct_ver_id
3858: -- ,p_object_id_from2 => NULL

Line 3936: pa_object_relationships b

3932: --Removing due to changes in publishing
3933: select a.proj_element_id, b.object_id_from1
3934: into l_parent_id, l_parent_ver_id
3935: from pa_proj_element_versions a,
3936: pa_object_relationships b
3937: where a.element_version_id = b.object_id_from1
3938: and a.object_type = b.object_type_from
3939: and relationship_type = 'S'
3940: and object_id_to1 = l_task_versions_rec.element_version_id

Line 4319: -- PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

4315: /*****************************/
4316: --dbms_output.put_line('creating rel: task out going links for structures');
4317: --dbms_output.put_line(l_project_id||','||l_struc_ver_rec.proj_element_id||','||l_new_struct_ver_id||','||','||l_task_version_id||', TO: '
4318: --||l_info_struc_ver_rec.project_id||','||l_info_struc_ver_rec.structure_id||','||l_info_struc_ver_rec.structure_version_id);
4319: -- PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
4320: -- p_user_id => FND_GLOBAL.USER_ID
4321: -- ,p_object_type_from => 'PA_TASKS'
4322: -- ,p_object_id_from1 => l_task_version_id
4323: -- ,p_object_id_from2 => NULL

Line 4354: -- PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

4350: -- OPEN get_task_version_info(l_to_object_info.object_id_to);
4351: -- FETCH get_task_version_info INTO l_info_task_ver_rec;
4352: /*****************************/
4353: --dbms_output.put_line('creating rel: task out going links for tasks');
4354: -- PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
4355: -- p_user_id => FND_GLOBAL.USER_ID
4356: -- ,p_object_type_from => 'PA_TASKS'
4357: -- ,p_object_id_from1 => l_task_version_id
4358: -- ,p_object_id_from2 => NULL

Line 4784: INSERT INTO PA_OBJECT_RELATIONSHIPS (

4780: ;
4781: */
4782:
4783: -- Bug 4205167 : Added hint to use Hash Join
4784: INSERT INTO PA_OBJECT_RELATIONSHIPS (
4785: object_relationship_id,
4786: object_type_from,
4787: object_id_from1,
4788: object_type_to,

Line 4801: pa_object_relationships_s.nextval,

4797: LAST_UPDATE_LOGIN,
4798: weighting_percentage
4799: )
4800: SELECT /*+ USE_HASH(ppev2 ppev1)*/
4801: pa_object_relationships_s.nextval,
4802: pobj.object_type_from,
4803: ppev1.element_version_id,
4804: pobj.object_type_to,
4805: ppev2.element_version_id,

Line 4819: FROM pa_object_relationships

4815: FROM ( SELECT object_type_from, object_id_from1,
4816: object_type_to, object_id_to1,
4817: relationship_type, relationship_subtype,
4818: Record_Version_Number, weighting_percentage
4819: FROM pa_object_relationships
4820: --bug#3094283 WHERE RELATIONSHIP_TYPE = 'S'
4821: start with object_id_from1 = p_structure_version_id
4822: and RELATIONSHIP_TYPE = 'S' /* Bug 2881667 - Added this condition */
4823: connect by object_id_from1 = prior object_id_to1

Line 5985: from pa_object_relationships

5981: IS
5982: cursor get_from_id(c_element_version_id NUMBER) IS
5983: select object_relationship_id, object_id_from1 object_id_from,
5984: object_type_from, record_version_number
5985: from pa_object_relationships
5986: where relationship_type = 'L'
5987: and object_id_to1 = c_element_version_id
5988: and object_type_to IN ('PA_TASKS','PA_STRUCTURES');
5989: l_from_object_info get_from_id%ROWTYPE;

Line 6280: PA_OBJECT_RELATIONSHIPS b

6276: SELECT a.element_version_id, a.proj_element_id, a.display_sequence, a.wbs_level,
6277: b.object_id_from1 parent_element_version_id,
6278: a.TASK_UNPUB_VER_STATUS_CODE
6279: FROM PA_PROJ_ELEMENT_VERSIONS a,
6280: PA_OBJECT_RELATIONSHIPS b
6281: WHERE a.object_type = 'PA_TASKS'
6282: AND a.parent_structure_version_id = c_structure_version_id
6283: AND a.element_version_id = b.object_id_to1
6284: AND b.relationship_type = 'S'

Line 6356: from pa_object_relationships

6352:
6353: cursor get_to_id(c_element_version_id NUMBER) IS
6354: select object_relationship_id, object_id_to1 object_id_to,
6355: object_type_to, record_version_number
6356: from pa_object_relationships
6357: where relationship_type = 'L'
6358: and object_id_from1 = c_element_version_id
6359: and object_type_from IN ('PA_TASKS','PA_STRUCTURES');
6360: l_to_object_info get_to_id%ROWTYPE;

Line 6372: l_new_obj_rel_id PA_OBJECT_RELATIONSHIPS.OBJECT_RELATIONSHIP_ID%TYPE;

6368: where v1.element_version_id = c_task_version_id
6369: and v1.parent_structure_version_id = v2.element_version_id;
6370: l_info_task_ver_rec get_task_version_info%ROWTYPE;
6371:
6372: l_new_obj_rel_id PA_OBJECT_RELATIONSHIPS.OBJECT_RELATIONSHIP_ID%TYPE;
6373: l_structure_type1 PA_STRUCTURE_TYPES.structure_type_class_code%TYPE;
6374:
6375: --hsiu
6376: --added for task weighting

Line 6379: from pa_object_relationships

6375: --hsiu
6376: --added for task weighting
6377: CURSOR get_cur_task_ver_weighting(c_ver_id NUMBER) IS
6378: select WEIGHTING_PERCENTAGE
6379: from pa_object_relationships
6380: where object_id_to1 = c_ver_id
6381: and object_type_to = 'PA_TASKS'
6382: and relationship_type = 'S';
6383: l_weighting NUMBER(17,2);

Line 6909: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

6905: If (l_to_object_info.object_type_to = 'PA_STRUCTURES') THEN
6906: OPEN l_get_structure_ver_csr(l_to_object_info.object_id_to);
6907: FETCH l_get_structure_ver_csr INTO l_structure_ver_to_rec;
6908:
6909: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
6910: p_user_id => FND_GLOBAL.USER_ID
6911: ,p_object_type_from => 'PA_TASKS'
6912: ,p_object_id_from1 => l_task_version_id
6913: ,p_object_id_from2 => NULL

Line 6968: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

6964: ELSIF (l_to_object_info.object_type_to = 'PA_TASKS') THEN
6965: OPEN get_task_version_info(l_to_object_info.object_id_to);
6966: FETCH get_task_version_info INTO l_info_task_ver_rec;
6967:
6968: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
6969: p_user_id => FND_GLOBAL.USER_ID
6970: ,p_object_type_from => 'PA_TASKS'
6971: ,p_object_id_from1 => l_task_version_id
6972: ,p_object_id_from2 => NULL

Line 7193: PA_OBJECT_RELATIONSHIPS b,

7189: IS
7190: SELECT a.element_version_id, a.proj_element_id, a.display_sequence, a.wbs_level,
7191: b.object_id_from1 parent_element_version_id
7192: FROM PA_PROJ_ELEMENT_VERSIONS a,
7193: PA_OBJECT_RELATIONSHIPS b,
7194: pa_proj_elements c
7195: WHERE a.object_type = 'PA_TASKS'
7196: AND a.parent_structure_version_id = c_structure_version_id
7197: AND a.element_version_id = b.object_id_to1

Line 7208: from pa_object_relationships

7204:
7205: CURSOR get_task_ver_weighting(p_task_ver_id NUMBER)
7206: IS
7207: select weighting_percentage
7208: from pa_object_relationships
7209: where object_id_to1 = p_task_ver_id
7210: and object_type_to = 'PA_TASKS'
7211: and relationship_type = 'S';
7212: l_weighting_percentage NUMBER;

Line 10002: from pa_proj_element_versions pev, pa_object_relationships rel

9998: -- from pa_proj_element_versions
9999: -- where parent_structure_version_id = c_struc_ver_id;
10000: cursor sel_struc_and_task_vers(c_struc_ver_id NUMBER) IS
10001: select pev.object_type, pev.proj_element_id, pev.element_version_id
10002: from pa_proj_element_versions pev, pa_object_relationships rel
10003: where pev.parent_structure_version_id = c_struc_ver_id
10004: and rel.object_id_to1 = pev.element_version_id
10005: and rel.relationship_type = 'S'
10006: and NOT EXISTS (

Line 10008: from pa_object_Relationships

10004: and rel.object_id_to1 = pev.element_version_id
10005: and rel.relationship_type = 'S'
10006: and NOT EXISTS (
10007: select 1
10008: from pa_object_Relationships
10009: where object_id_from1 = pev.element_version_id
10010: and relationship_type = 'S'
10011: );
10012:

Line 10028: pa_object_relationships r

10024:
10025: CURSOR get_top_tasks(c_structure_version_id NUMBER) IS
10026: select v.element_version_id
10027: from pa_proj_element_versions v,
10028: pa_object_relationships r
10029: where v.element_version_id = r.object_id_to1
10030: and r.object_id_from1 = c_structure_version_id
10031: and r.object_type_from = 'PA_STRUCTURES';
10032:

Line 12299: pa_object_relationships r

12295:
12296: CURSOR get_top_tasks IS
12297: select v.element_version_id
12298: from pa_proj_element_versions v,
12299: pa_object_relationships r
12300: where v.element_version_id = r.object_id_to1
12301: and r.object_id_from1 = p_structure_version_id
12302: and r.object_type_from = 'PA_STRUCTURES';
12303:

Line 13091: FROM pa_object_relationships

13087: AND ppe.TYPE_ID = ptt.task_type_id;
13088:
13089: CURSOR get_parent(c_element_version_id NUMBER) IS
13090: SELECT object_id_from1
13091: FROM pa_object_relationships
13092: WHERE object_id_to1 = c_element_version_id
13093: AND object_type_to = 'PA_TASKS'
13094: AND relationship_type = 'S'
13095: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');

Line 13100: , pa_object_relationships por

13096:
13097: CURSOR get_summed_duration(c_parent_element_version_id NUMBER) IS
13098: SELECT sum(ppevs.duration)
13099: FROM pa_proj_elem_ver_schedule ppevs
13100: , pa_object_relationships por
13101: , pa_proj_element_versions ppev
13102: , pa_proj_elements ppe
13103: , pa_task_types ptt
13104: WHERE por.object_id_from1 = c_parent_element_version_id

Line 13124: FROM PA_OBJECT_RELATIONSHIPS

13120: AND project_id = c_project_id;
13121:
13122: CURSOR get_existing_weights(c_parent_element_version_id NUMBER) IS
13123: SELECT sum(weighting_percentage)
13124: FROM PA_OBJECT_RELATIONSHIPS
13125: WHERE object_id_from1 = c_parent_element_version_id
13126: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
13127: AND object_type_to = 'PA_TASKS'
13128: AND relationship_type = 'S';

Line 13141: l_task_weight PA_OBJECT_RELATIONSHIPS.weighting_percentage%TYPE;

13137: INDEX BY BINARY_INTEGER;
13138:
13139: l_durations durations;
13140: l_total_duration NUMBER;
13141: l_task_weight PA_OBJECT_RELATIONSHIPS.weighting_percentage%TYPE;
13142: l_task_duration NUMBER;
13143: l_existing_weight NUMBER;
13144: l_remaining_weight NUMBER;
13145:

Line 13164: UPDATE PA_OBJECT_RELATIONSHIPS

13160:
13161:
13162: IF l_progress_allowed = 'N' THEN
13163: -- Populate task weight as zero
13164: UPDATE PA_OBJECT_RELATIONSHIPS
13165: SET weighting_percentage = 0
13166: WHERE object_id_from1 = l_parent_element_version_id
13167: AND object_id_to1 = l_element_version_id
13168: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

Line 13205: UPDATE PA_OBJECT_RELATIONSHIPS

13201: l_task_weight := l_task_weight+l_remaining_weight;
13202: END IF;
13203: END IF;
13204:
13205: UPDATE PA_OBJECT_RELATIONSHIPS
13206: SET weighting_percentage = l_task_weight
13207: WHERE object_id_from1 = l_parent_element_version_id
13208: AND object_id_to1 = l_element_version_id
13209: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

Line 13356: l_new_obj_rel_id PA_OBJECT_RELATIONSHIPS.OBJECT_RELATIONSHIP_ID%TYPE;

13352:
13353: l_dummy VARCHAR2(1);
13354:
13355:
13356: l_new_obj_rel_id PA_OBJECT_RELATIONSHIPS.OBJECT_RELATIONSHIP_ID%TYPE;
13357: l_structure_type1 PA_STRUCTURE_TYPES.structure_type_class_code%TYPE;
13358:
13359: --Added by rtarway
13360: l_rowid VARCHAR2(255);

Line 13713: INSERT INTO PA_OBJECT_RELATIONSHIPS (

13709: and ppev2.object_type = 'PA_TASKS'
13710: order by ppev2.display_sequence ) ppev
13711: ;
13712: -- Bug 4205167 : Added hint to use Hash Join
13713: INSERT INTO PA_OBJECT_RELATIONSHIPS (
13714: object_relationship_id,
13715: object_type_from,
13716: object_id_from1,
13717: object_type_to,

Line 13730: pa_object_relationships_s.nextval,

13726: LAST_UPDATE_LOGIN,
13727: weighting_percentage
13728: )
13729: SELECT /*+ USE_HASH(ppev2 ppev1)*/
13730: pa_object_relationships_s.nextval,
13731: pobj.object_type_from,
13732: ppev1.element_version_id,
13733: pobj.object_type_to,
13734: ppev2.element_version_id,

Line 13748: FROM pa_object_relationships

13744: FROM ( SELECT object_type_from, object_id_from1,
13745: object_type_to, object_id_to1,
13746: relationship_type, relationship_subtype,
13747: Record_Version_Number, weighting_percentage
13748: FROM pa_object_relationships
13749: --bug#3094283 WHERE RELATIONSHIP_TYPE = 'S'
13750: start with object_id_from1 = p_structure_version_id
13751: and RELATIONSHIP_TYPE = 'S' /* Bug 2881667 - Added this condition */
13752: connect by object_id_from1 = prior object_id_to1

Line 14369: from pa_proj_element_versions pev, pa_object_relationships rel

14365: -- from pa_proj_element_versions
14366: -- where parent_structure_version_id = c_struc_ver_id;
14367: cursor sel_struc_and_task_vers(c_struc_ver_id NUMBER) IS
14368: select pev.object_type, pev.proj_element_id, pev.element_version_id
14369: from pa_proj_element_versions pev, pa_object_relationships rel
14370: where pev.parent_structure_version_id = c_struc_ver_id
14371: and rel.object_id_to1 = pev.element_version_id
14372: and rel.relationship_type = 'S'
14373: and NOT EXISTS (

Line 14375: from pa_object_Relationships

14371: and rel.object_id_to1 = pev.element_version_id
14372: and rel.relationship_type = 'S'
14373: and NOT EXISTS (
14374: select 1
14375: from pa_object_Relationships
14376: where object_id_from1 = pev.element_version_id
14377: and relationship_type = 'S'
14378: );
14379:

Line 14395: pa_object_relationships r

14391:
14392: CURSOR get_top_tasks(c_structure_version_id NUMBER) IS
14393: select v.element_version_id
14394: from pa_proj_element_versions v,
14395: pa_object_relationships r
14396: where v.element_version_id = r.object_id_to1
14397: and r.object_id_from1 = c_structure_version_id
14398: and r.object_type_from = 'PA_STRUCTURES';
14399:

Line 14447: from pa_object_relationships por

14443: -- Begin fix for Bug # 4426392.
14444:
14445: cursor cur_program (c_project_id NUMBER) is
14446: select 'Y'
14447: from pa_object_relationships por
14448: where (por.object_id_from2 = c_project_id
14449: or por.object_id_to2 = c_project_id)
14450: and por.relationship_type in ('LW', 'LF');
14451:

Line 14463: from pa_object_relationships por1

14459: , por2.object_id_from1 task_ver_id
14460: , c_project_id dest_proj_id
14461: , ppev.parent_structure_version_id src_str_ver_id
14462: , por1.record_version_number rec_ver_number
14463: from pa_object_relationships por1
14464: , pa_object_relationships por2
14465: , pa_projects_all ppa
14466: , pa_proj_element_versions ppev
14467: , pa_proj_elem_ver_structure ppevs

Line 14464: , pa_object_relationships por2

14460: , c_project_id dest_proj_id
14461: , ppev.parent_structure_version_id src_str_ver_id
14462: , por1.record_version_number rec_ver_number
14463: from pa_object_relationships por1
14464: , pa_object_relationships por2
14465: , pa_projects_all ppa
14466: , pa_proj_element_versions ppev
14467: , pa_proj_elem_ver_structure ppevs
14468: where por1.object_id_to2 = c_project_id

Line 14491: from pa_object_relationships por1

14487: , por2.object_id_from1 task_ver_id
14488: , por1.object_id_to2 dest_proj_id
14489: , ppev.parent_structure_version_id src_str_ver_id
14490: , por1.record_version_number rec_ver_number
14491: from pa_object_relationships por1
14492: , pa_object_relationships por2
14493: , pa_projects_all ppa
14494: , pa_proj_element_versions ppev
14495: , pa_proj_elem_ver_structure ppevs

Line 14492: , pa_object_relationships por2

14488: , por1.object_id_to2 dest_proj_id
14489: , ppev.parent_structure_version_id src_str_ver_id
14490: , por1.record_version_number rec_ver_number
14491: from pa_object_relationships por1
14492: , pa_object_relationships por2
14493: , pa_projects_all ppa
14494: , pa_proj_element_versions ppev
14495: , pa_proj_elem_ver_structure ppevs
14496: where por1.object_id_from2 = c_project_id

Line 16431: /* delete from pa_object_relationships rel

16427: and object_type IN ('PA_TASKS', 'PA_STRUCTURES'));
16428:
16429: --delete relationships
16430: --Bug No 3634334 Commented for performance tuning and rewritten the query.
16431: /* delete from pa_object_relationships rel
16432: where rel.relationship_type IN ('D','S')
16433: and EXISTS (
16434: select 1 from pa_proj_element_versions
16435: where (rel.object_id_from1 = element_version_id OR

Line 16442: delete from pa_object_relationships rel

16438: financial_task_flag = 'N'); */
16439:
16440: --Bug No 3634334 Created for performance tuning for the above query.
16441:
16442: delete from pa_object_relationships rel
16443: where OBJECT_RELATIONSHIP_ID IN (
16444: select OBJECT_RELATIONSHIP_ID
16445: from pa_object_relationships rel,
16446: pa_proj_element_versions

Line 16445: from pa_object_relationships rel,

16441:
16442: delete from pa_object_relationships rel
16443: where OBJECT_RELATIONSHIP_ID IN (
16444: select OBJECT_RELATIONSHIP_ID
16445: from pa_object_relationships rel,
16446: pa_proj_element_versions
16447: where rel.relationship_type IN ('D','S')
16448: and object_type_to = 'PA_TASKS'
16449: and rel.object_id_to1 = element_version_id

Line 16454: from pa_object_relationships rel,

16450: and parent_structure_version_id = l_keep_structure_ver_id
16451: and financial_task_flag = 'N'
16452: UNION
16453: select OBJECT_RELATIONSHIP_ID
16454: from pa_object_relationships rel,
16455: pa_proj_element_versions
16456: where rel.relationship_type IN ('D','S')
16457: and object_type_from = 'PA_TASKS'
16458: and rel.object_id_from1 = element_version_id