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_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 2498: from pa_object_relationships por

2494: -- Begin fix for Bug # 4483222.
2495:
2496: cursor l_cur_rel_id(p_str_ver_id NUMBER) is
2497: select por.object_relationship_id, por.record_version_number
2498: from pa_object_relationships por
2499: where por.object_id_to1 = p_str_ver_id
2500: and por.relationship_type in ('LW', 'LF');
2501:
2502: l_rec_rel_id l_cur_rel_id%ROWTYPE;

Line 2979: l_new_obj_rel_id PA_OBJECT_RELATIONSHIPS.OBJECT_RELATIONSHIP_ID%TYPE;

2975: l_tmp_struct_ver_id NUMBER;
2976: -- added for Bug fix: 4537865
2977: l_new_pev_structure_id PA_PROJ_ELEM_VER_STRUCTURE.PEV_STRUCTURE_ID%TYPE;
2978: l_new_pev_schedule_id PA_PROJ_ELEM_VER_SCHEDULE.PEV_SCHEDULE_ID%TYPE;
2979: l_new_obj_rel_id PA_OBJECT_RELATIONSHIPS.OBJECT_RELATIONSHIP_ID%TYPE;
2980:
2981: l_original_baseline_flag VARCHAR2(1);
2982: l_current_baseline_flag VARCHAR2(1);
2983:

Line 3030: from pa_object_relationships

3026:
3027: cursor get_from_id(c_element_version_id NUMBER) IS
3028: select object_relationship_id, object_id_from1 object_id_from,
3029: object_type_from, record_version_number
3030: from pa_object_relationships
3031: where relationship_type = 'L'
3032: and object_id_to1 = c_element_version_id
3033: and object_type_to IN ('PA_TASKS','PA_STRUCTURES');
3034: l_from_object_info get_from_id%ROWTYPE;

Line 3039: from pa_object_relationships

3035:
3036: cursor get_to_id(c_element_version_id NUMBER) IS
3037: select object_relationship_id, object_id_to1 object_id_to, object_id_to2,
3038: object_type_to, record_version_number
3039: from pa_object_relationships
3040: where relationship_type IN ('LW', 'LF')
3041: and object_id_from1 = c_element_version_id
3042: and object_type_from IN ('PA_TASKS','PA_STRUCTURES');
3043: l_to_object_info get_to_id%ROWTYPE;

Line 3099: PA_OBJECT_RELATIONSHIPS b

3095: SELECT a.element_version_id, a.proj_element_id, a.display_sequence, a.wbs_level,
3096: a.project_id, b.object_id_from1 parent_element_version_id,
3097: a.TASK_UNPUB_VER_STATUS_CODE, a.parent_structure_version_id
3098: FROM PA_PROJ_ELEMENT_VERSIONS a,
3099: PA_OBJECT_RELATIONSHIPS b
3100: WHERE a.object_type = 'PA_TASKS'
3101: AND a.parent_structure_version_id = c_structure_version_id
3102: AND a.element_version_id = b.object_id_to1
3103: AND b.relationship_type = 'S'

Line 3158: from pa_object_relationships

3154:
3155: CURSOR get_task_ver_weighting(p_task_ver_id NUMBER)
3156: IS
3157: select weighting_percentage
3158: from pa_object_relationships
3159: where object_id_to1 = p_task_ver_id
3160: and object_type_to = 'PA_TASKS'
3161: and object_type_from in ('PA_STRUCTURES','PA_TASKS')
3162: and object_type_to = 'PA_TASKS' -- Bug 6429275

Line 3193: from pa_object_relationships

3189: l_tbd_tasks_info_rec get_tbd_tasks_info%ROWTYPE;
3190:
3191: CURSOR get_parent_id(c_task_ver_id NUMBER) IS
3192: select object_id_from1
3193: from pa_object_relationships
3194: where object_id_to1 = c_task_ver_id
3195: and object_type_to = 'PA_TASKS'
3196: and relationship_type = 'S';
3197: l_parent_id NUMBER;

Line 3205: from pa_object_relationships

3201:
3202: --bug 2662139
3203: CURSOR is_summary_elem(c_elem_ver_id NUMBER) IS
3204: SELECT '1'
3205: from pa_object_relationships
3206: where object_type_from IN ('PA_TASKS', 'PA_STRUCTURES')
3207: and object_id_from1 = c_elem_ver_id
3208: and relationship_type = 'S';
3209:

Line 3758: -- PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

3754: -- OPEN get_structure_version_info(l_to_object_info.object_id_to);
3755: -- FETCH get_structure_version_info INTO l_info_struc_ver_rec;
3756: /*****************************/
3757: --dbms_output.put_line('creating rel: structure out going links for structures');
3758: -- PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
3759: -- p_user_id => FND_GLOBAL.USER_ID
3760: -- ,p_object_type_from => 'PA_STRUCTURES'
3761: -- ,p_object_id_from1 => l_new_struct_ver_id
3762: -- ,p_object_id_from2 => NULL

Line 3794: -- PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

3790: -- OPEN get_task_version_info(l_to_object_info.object_id_to);
3791: -- FETCH get_task_version_info INTO l_info_task_ver_rec;
3792: /*****************************/
3793: --dbms_output.put_line('creating rel: structure out going links for tasks');
3794: -- PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
3795: -- p_user_id => FND_GLOBAL.USER_ID
3796: -- ,p_object_type_from => 'PA_STRUCTURES'
3797: -- ,p_object_id_from1 => l_new_struct_ver_id
3798: -- ,p_object_id_from2 => NULL

Line 3876: pa_object_relationships b

3872: --Removing due to changes in publishing
3873: select a.proj_element_id, b.object_id_from1
3874: into l_parent_id, l_parent_ver_id
3875: from pa_proj_element_versions a,
3876: pa_object_relationships b
3877: where a.element_version_id = b.object_id_from1
3878: and a.object_type = b.object_type_from
3879: and relationship_type = 'S'
3880: and object_id_to1 = l_task_versions_rec.element_version_id

Line 4259: -- PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

4255: /*****************************/
4256: --dbms_output.put_line('creating rel: task out going links for structures');
4257: --dbms_output.put_line(l_project_id||','||l_struc_ver_rec.proj_element_id||','||l_new_struct_ver_id||','||','||l_task_version_id||', TO: '
4258: --||l_info_struc_ver_rec.project_id||','||l_info_struc_ver_rec.structure_id||','||l_info_struc_ver_rec.structure_version_id);
4259: -- PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
4260: -- p_user_id => FND_GLOBAL.USER_ID
4261: -- ,p_object_type_from => 'PA_TASKS'
4262: -- ,p_object_id_from1 => l_task_version_id
4263: -- ,p_object_id_from2 => NULL

Line 4294: -- PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

4290: -- OPEN get_task_version_info(l_to_object_info.object_id_to);
4291: -- FETCH get_task_version_info INTO l_info_task_ver_rec;
4292: /*****************************/
4293: --dbms_output.put_line('creating rel: task out going links for tasks');
4294: -- PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
4295: -- p_user_id => FND_GLOBAL.USER_ID
4296: -- ,p_object_type_from => 'PA_TASKS'
4297: -- ,p_object_id_from1 => l_task_version_id
4298: -- ,p_object_id_from2 => NULL

Line 4724: INSERT INTO PA_OBJECT_RELATIONSHIPS (

4720: ;
4721: */
4722:
4723: -- Bug 4205167 : Added hint to use Hash Join
4724: INSERT INTO PA_OBJECT_RELATIONSHIPS (
4725: object_relationship_id,
4726: object_type_from,
4727: object_id_from1,
4728: object_type_to,

Line 4741: pa_object_relationships_s.nextval,

4737: LAST_UPDATE_LOGIN,
4738: weighting_percentage
4739: )
4740: SELECT /*+ USE_HASH(ppev2 ppev1)*/
4741: pa_object_relationships_s.nextval,
4742: pobj.object_type_from,
4743: ppev1.element_version_id,
4744: pobj.object_type_to,
4745: ppev2.element_version_id,

Line 4759: FROM pa_object_relationships

4755: FROM ( SELECT object_type_from, object_id_from1,
4756: object_type_to, object_id_to1,
4757: relationship_type, relationship_subtype,
4758: Record_Version_Number, weighting_percentage
4759: FROM pa_object_relationships
4760: --bug#3094283 WHERE RELATIONSHIP_TYPE = 'S'
4761: start with object_id_from1 = p_structure_version_id
4762: and RELATIONSHIP_TYPE = 'S' /* Bug 2881667 - Added this condition */
4763: connect by object_id_from1 = prior object_id_to1

Line 5925: from pa_object_relationships

5921: IS
5922: cursor get_from_id(c_element_version_id NUMBER) IS
5923: select object_relationship_id, object_id_from1 object_id_from,
5924: object_type_from, record_version_number
5925: from pa_object_relationships
5926: where relationship_type = 'L'
5927: and object_id_to1 = c_element_version_id
5928: and object_type_to IN ('PA_TASKS','PA_STRUCTURES');
5929: l_from_object_info get_from_id%ROWTYPE;

Line 6220: PA_OBJECT_RELATIONSHIPS b

6216: SELECT a.element_version_id, a.proj_element_id, a.display_sequence, a.wbs_level,
6217: b.object_id_from1 parent_element_version_id,
6218: a.TASK_UNPUB_VER_STATUS_CODE
6219: FROM PA_PROJ_ELEMENT_VERSIONS a,
6220: PA_OBJECT_RELATIONSHIPS b
6221: WHERE a.object_type = 'PA_TASKS'
6222: AND a.parent_structure_version_id = c_structure_version_id
6223: AND a.element_version_id = b.object_id_to1
6224: AND b.relationship_type = 'S'

Line 6296: from pa_object_relationships

6292:
6293: cursor get_to_id(c_element_version_id NUMBER) IS
6294: select object_relationship_id, object_id_to1 object_id_to,
6295: object_type_to, record_version_number
6296: from pa_object_relationships
6297: where relationship_type = 'L'
6298: and object_id_from1 = c_element_version_id
6299: and object_type_from IN ('PA_TASKS','PA_STRUCTURES');
6300: l_to_object_info get_to_id%ROWTYPE;

Line 6312: l_new_obj_rel_id PA_OBJECT_RELATIONSHIPS.OBJECT_RELATIONSHIP_ID%TYPE;

6308: where v1.element_version_id = c_task_version_id
6309: and v1.parent_structure_version_id = v2.element_version_id;
6310: l_info_task_ver_rec get_task_version_info%ROWTYPE;
6311:
6312: l_new_obj_rel_id PA_OBJECT_RELATIONSHIPS.OBJECT_RELATIONSHIP_ID%TYPE;
6313: l_structure_type1 PA_STRUCTURE_TYPES.structure_type_class_code%TYPE;
6314:
6315: --hsiu
6316: --added for task weighting

Line 6319: from pa_object_relationships

6315: --hsiu
6316: --added for task weighting
6317: CURSOR get_cur_task_ver_weighting(c_ver_id NUMBER) IS
6318: select WEIGHTING_PERCENTAGE
6319: from pa_object_relationships
6320: where object_id_to1 = c_ver_id
6321: and object_type_to = 'PA_TASKS'
6322: and relationship_type = 'S';
6323: l_weighting NUMBER(17,2);

Line 6849: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

6845: If (l_to_object_info.object_type_to = 'PA_STRUCTURES') THEN
6846: OPEN l_get_structure_ver_csr(l_to_object_info.object_id_to);
6847: FETCH l_get_structure_ver_csr INTO l_structure_ver_to_rec;
6848:
6849: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
6850: p_user_id => FND_GLOBAL.USER_ID
6851: ,p_object_type_from => 'PA_TASKS'
6852: ,p_object_id_from1 => l_task_version_id
6853: ,p_object_id_from2 => NULL

Line 6908: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

6904: ELSIF (l_to_object_info.object_type_to = 'PA_TASKS') THEN
6905: OPEN get_task_version_info(l_to_object_info.object_id_to);
6906: FETCH get_task_version_info INTO l_info_task_ver_rec;
6907:
6908: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
6909: p_user_id => FND_GLOBAL.USER_ID
6910: ,p_object_type_from => 'PA_TASKS'
6911: ,p_object_id_from1 => l_task_version_id
6912: ,p_object_id_from2 => NULL

Line 7133: PA_OBJECT_RELATIONSHIPS b,

7129: IS
7130: SELECT a.element_version_id, a.proj_element_id, a.display_sequence, a.wbs_level,
7131: b.object_id_from1 parent_element_version_id
7132: FROM PA_PROJ_ELEMENT_VERSIONS a,
7133: PA_OBJECT_RELATIONSHIPS b,
7134: pa_proj_elements c
7135: WHERE a.object_type = 'PA_TASKS'
7136: AND a.parent_structure_version_id = c_structure_version_id
7137: AND a.element_version_id = b.object_id_to1

Line 7148: from pa_object_relationships

7144:
7145: CURSOR get_task_ver_weighting(p_task_ver_id NUMBER)
7146: IS
7147: select weighting_percentage
7148: from pa_object_relationships
7149: where object_id_to1 = p_task_ver_id
7150: and object_type_to = 'PA_TASKS'
7151: and relationship_type = 'S';
7152: l_weighting_percentage NUMBER;

Line 9630: from pa_proj_element_versions pev, pa_object_relationships rel

9626: -- from pa_proj_element_versions
9627: -- where parent_structure_version_id = c_struc_ver_id;
9628: cursor sel_struc_and_task_vers(c_struc_ver_id NUMBER) IS
9629: select pev.object_type, pev.proj_element_id, pev.element_version_id
9630: from pa_proj_element_versions pev, pa_object_relationships rel
9631: where pev.parent_structure_version_id = c_struc_ver_id
9632: and rel.object_id_to1 = pev.element_version_id
9633: and rel.relationship_type = 'S'
9634: and NOT EXISTS (

Line 9636: from pa_object_Relationships

9632: and rel.object_id_to1 = pev.element_version_id
9633: and rel.relationship_type = 'S'
9634: and NOT EXISTS (
9635: select 1
9636: from pa_object_Relationships
9637: where object_id_from1 = pev.element_version_id
9638: and relationship_type = 'S'
9639: );
9640:

Line 9656: pa_object_relationships r

9652:
9653: CURSOR get_top_tasks(c_structure_version_id NUMBER) IS
9654: select v.element_version_id
9655: from pa_proj_element_versions v,
9656: pa_object_relationships r
9657: where v.element_version_id = r.object_id_to1
9658: and r.object_id_from1 = c_structure_version_id
9659: and r.object_type_from = 'PA_STRUCTURES';
9660:

Line 11927: pa_object_relationships r

11923:
11924: CURSOR get_top_tasks IS
11925: select v.element_version_id
11926: from pa_proj_element_versions v,
11927: pa_object_relationships r
11928: where v.element_version_id = r.object_id_to1
11929: and r.object_id_from1 = p_structure_version_id
11930: and r.object_type_from = 'PA_STRUCTURES';
11931:

Line 12719: FROM pa_object_relationships

12715: AND ppe.TYPE_ID = ptt.task_type_id;
12716:
12717: CURSOR get_parent(c_element_version_id NUMBER) IS
12718: SELECT object_id_from1
12719: FROM pa_object_relationships
12720: WHERE object_id_to1 = c_element_version_id
12721: AND object_type_to = 'PA_TASKS'
12722: AND relationship_type = 'S'
12723: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');

Line 12728: , pa_object_relationships por

12724:
12725: CURSOR get_summed_duration(c_parent_element_version_id NUMBER) IS
12726: SELECT sum(ppevs.duration)
12727: FROM pa_proj_elem_ver_schedule ppevs
12728: , pa_object_relationships por
12729: , pa_proj_element_versions ppev
12730: , pa_proj_elements ppe
12731: , pa_task_types ptt
12732: WHERE por.object_id_from1 = c_parent_element_version_id

Line 12752: FROM PA_OBJECT_RELATIONSHIPS

12748: AND project_id = c_project_id;
12749:
12750: CURSOR get_existing_weights(c_parent_element_version_id NUMBER) IS
12751: SELECT sum(weighting_percentage)
12752: FROM PA_OBJECT_RELATIONSHIPS
12753: WHERE object_id_from1 = c_parent_element_version_id
12754: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
12755: AND object_type_to = 'PA_TASKS'
12756: AND relationship_type = 'S';

Line 12769: l_task_weight PA_OBJECT_RELATIONSHIPS.weighting_percentage%TYPE;

12765: INDEX BY BINARY_INTEGER;
12766:
12767: l_durations durations;
12768: l_total_duration NUMBER;
12769: l_task_weight PA_OBJECT_RELATIONSHIPS.weighting_percentage%TYPE;
12770: l_task_duration NUMBER;
12771: l_existing_weight NUMBER;
12772: l_remaining_weight NUMBER;
12773:

Line 12792: UPDATE PA_OBJECT_RELATIONSHIPS

12788:
12789:
12790: IF l_progress_allowed = 'N' THEN
12791: -- Populate task weight as zero
12792: UPDATE PA_OBJECT_RELATIONSHIPS
12793: SET weighting_percentage = 0
12794: WHERE object_id_from1 = l_parent_element_version_id
12795: AND object_id_to1 = l_element_version_id
12796: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

Line 12833: UPDATE PA_OBJECT_RELATIONSHIPS

12829: l_task_weight := l_task_weight+l_remaining_weight;
12830: END IF;
12831: END IF;
12832:
12833: UPDATE PA_OBJECT_RELATIONSHIPS
12834: SET weighting_percentage = l_task_weight
12835: WHERE object_id_from1 = l_parent_element_version_id
12836: AND object_id_to1 = l_element_version_id
12837: AND object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

Line 12984: l_new_obj_rel_id PA_OBJECT_RELATIONSHIPS.OBJECT_RELATIONSHIP_ID%TYPE;

12980:
12981: l_dummy VARCHAR2(1);
12982:
12983:
12984: l_new_obj_rel_id PA_OBJECT_RELATIONSHIPS.OBJECT_RELATIONSHIP_ID%TYPE;
12985: l_structure_type1 PA_STRUCTURE_TYPES.structure_type_class_code%TYPE;
12986:
12987: --Added by rtarway
12988: l_rowid VARCHAR2(255);

Line 13341: INSERT INTO PA_OBJECT_RELATIONSHIPS (

13337: and ppev2.object_type = 'PA_TASKS'
13338: order by ppev2.display_sequence ) ppev
13339: ;
13340: -- Bug 4205167 : Added hint to use Hash Join
13341: INSERT INTO PA_OBJECT_RELATIONSHIPS (
13342: object_relationship_id,
13343: object_type_from,
13344: object_id_from1,
13345: object_type_to,

Line 13358: pa_object_relationships_s.nextval,

13354: LAST_UPDATE_LOGIN,
13355: weighting_percentage
13356: )
13357: SELECT /*+ USE_HASH(ppev2 ppev1)*/
13358: pa_object_relationships_s.nextval,
13359: pobj.object_type_from,
13360: ppev1.element_version_id,
13361: pobj.object_type_to,
13362: ppev2.element_version_id,

Line 13376: FROM pa_object_relationships

13372: FROM ( SELECT object_type_from, object_id_from1,
13373: object_type_to, object_id_to1,
13374: relationship_type, relationship_subtype,
13375: Record_Version_Number, weighting_percentage
13376: FROM pa_object_relationships
13377: --bug#3094283 WHERE RELATIONSHIP_TYPE = 'S'
13378: start with object_id_from1 = p_structure_version_id
13379: and RELATIONSHIP_TYPE = 'S' /* Bug 2881667 - Added this condition */
13380: connect by object_id_from1 = prior object_id_to1

Line 13995: from pa_proj_element_versions pev, pa_object_relationships rel

13991: -- from pa_proj_element_versions
13992: -- where parent_structure_version_id = c_struc_ver_id;
13993: cursor sel_struc_and_task_vers(c_struc_ver_id NUMBER) IS
13994: select pev.object_type, pev.proj_element_id, pev.element_version_id
13995: from pa_proj_element_versions pev, pa_object_relationships rel
13996: where pev.parent_structure_version_id = c_struc_ver_id
13997: and rel.object_id_to1 = pev.element_version_id
13998: and rel.relationship_type = 'S'
13999: and NOT EXISTS (

Line 14001: from pa_object_Relationships

13997: and rel.object_id_to1 = pev.element_version_id
13998: and rel.relationship_type = 'S'
13999: and NOT EXISTS (
14000: select 1
14001: from pa_object_Relationships
14002: where object_id_from1 = pev.element_version_id
14003: and relationship_type = 'S'
14004: );
14005:

Line 14021: pa_object_relationships r

14017:
14018: CURSOR get_top_tasks(c_structure_version_id NUMBER) IS
14019: select v.element_version_id
14020: from pa_proj_element_versions v,
14021: pa_object_relationships r
14022: where v.element_version_id = r.object_id_to1
14023: and r.object_id_from1 = c_structure_version_id
14024: and r.object_type_from = 'PA_STRUCTURES';
14025:

Line 14073: from pa_object_relationships por

14069: -- Begin fix for Bug # 4426392.
14070:
14071: cursor cur_program (c_project_id NUMBER) is
14072: select 'Y'
14073: from pa_object_relationships por
14074: where (por.object_id_from2 = c_project_id
14075: or por.object_id_to2 = c_project_id)
14076: and por.relationship_type in ('LW', 'LF');
14077:

Line 14089: from pa_object_relationships por1

14085: , por2.object_id_from1 task_ver_id
14086: , c_project_id dest_proj_id
14087: , ppev.parent_structure_version_id src_str_ver_id
14088: , por1.record_version_number rec_ver_number
14089: from pa_object_relationships por1
14090: , pa_object_relationships por2
14091: , pa_projects_all ppa
14092: , pa_proj_element_versions ppev
14093: , pa_proj_elem_ver_structure ppevs

Line 14090: , pa_object_relationships por2

14086: , c_project_id dest_proj_id
14087: , ppev.parent_structure_version_id src_str_ver_id
14088: , por1.record_version_number rec_ver_number
14089: from pa_object_relationships por1
14090: , pa_object_relationships por2
14091: , pa_projects_all ppa
14092: , pa_proj_element_versions ppev
14093: , pa_proj_elem_ver_structure ppevs
14094: where por1.object_id_to2 = c_project_id

Line 14117: from pa_object_relationships por1

14113: , por2.object_id_from1 task_ver_id
14114: , por1.object_id_to2 dest_proj_id
14115: , ppev.parent_structure_version_id src_str_ver_id
14116: , por1.record_version_number rec_ver_number
14117: from pa_object_relationships por1
14118: , pa_object_relationships por2
14119: , pa_projects_all ppa
14120: , pa_proj_element_versions ppev
14121: , pa_proj_elem_ver_structure ppevs

Line 14118: , pa_object_relationships por2

14114: , por1.object_id_to2 dest_proj_id
14115: , ppev.parent_structure_version_id src_str_ver_id
14116: , por1.record_version_number rec_ver_number
14117: from pa_object_relationships por1
14118: , pa_object_relationships por2
14119: , pa_projects_all ppa
14120: , pa_proj_element_versions ppev
14121: , pa_proj_elem_ver_structure ppevs
14122: where por1.object_id_from2 = c_project_id

Line 16055: /* delete from pa_object_relationships rel

16051: and object_type IN ('PA_TASKS', 'PA_STRUCTURES'));
16052:
16053: --delete relationships
16054: --Bug No 3634334 Commented for performance tuning and rewritten the query.
16055: /* delete from pa_object_relationships rel
16056: where rel.relationship_type IN ('D','S')
16057: and EXISTS (
16058: select 1 from pa_proj_element_versions
16059: where (rel.object_id_from1 = element_version_id OR

Line 16066: delete from pa_object_relationships rel

16062: financial_task_flag = 'N'); */
16063:
16064: --Bug No 3634334 Created for performance tuning for the above query.
16065:
16066: delete from pa_object_relationships rel
16067: where OBJECT_RELATIONSHIP_ID IN (
16068: select OBJECT_RELATIONSHIP_ID
16069: from pa_object_relationships rel,
16070: pa_proj_element_versions

Line 16069: from pa_object_relationships rel,

16065:
16066: delete from pa_object_relationships rel
16067: where OBJECT_RELATIONSHIP_ID IN (
16068: select OBJECT_RELATIONSHIP_ID
16069: from pa_object_relationships rel,
16070: pa_proj_element_versions
16071: where rel.relationship_type IN ('D','S')
16072: and object_type_to = 'PA_TASKS'
16073: and rel.object_id_to1 = element_version_id

Line 16078: from pa_object_relationships rel,

16074: and parent_structure_version_id = l_keep_structure_ver_id
16075: and financial_task_flag = 'N'
16076: UNION
16077: select OBJECT_RELATIONSHIP_ID
16078: from pa_object_relationships rel,
16079: pa_proj_element_versions
16080: where rel.relationship_type IN ('D','S')
16081: and object_type_from = 'PA_TASKS'
16082: and rel.object_id_from1 = element_version_id