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

Line 10604: from pa_projects_all ppa, pa_object_relationships por

10600: where ppa.project_id = c_project_id;
10601:
10602: cursor cur_prog_name (c_project_id NUMBER) is
10603: select ppa.name
10604: from pa_projects_all ppa, pa_object_relationships por
10605: where ppa.project_id = por.object_id_to2
10606: and por.object_id_to2 = c_project_id
10607: and por.relationship_type in ('LW','LF')
10608: union all

Line 10610: from pa_projects_all ppa, pa_object_relationships por

10606: and por.object_id_to2 = c_project_id
10607: and por.relationship_type in ('LW','LF')
10608: union all
10609: select ppa.name
10610: from pa_projects_all ppa, pa_object_relationships por
10611: where ppa.project_id = por.object_id_from2
10612: and por.object_id_from2 = c_project_id
10613: and por.relationship_type in ('LW','LF');
10614:

Line 32791: l_object_relationship_Id pa_object_relationships.object_relationship_Id%TYPE;

32787: l_task_reference VARCHAR2(240);
32788: l_deliverable_id NUMBER;
32789: l_dlvr_version_id NUMBER;
32790: l_function_code Pa_Proj_Elements.function_code%TYPE;
32791: l_object_relationship_Id pa_object_relationships.object_relationship_Id%TYPE;
32792: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
32793:
32794: l_function_allowed VARCHAR2(1);
32795: l_resp_id NUMBER := FND_GLOBAL.Resp_id;

Line 33079: l_object_relationship_Id pa_object_relationships.object_relationship_Id%TYPE;

33075: l_task_reference VARCHAR2(240);
33076: l_deliverable_id NUMBER;
33077: l_dlvr_version_id NUMBER;
33078: l_function_code Pa_Proj_Elements.function_code%TYPE;
33079: l_object_relationship_Id pa_object_relationships.object_relationship_Id%TYPE;
33080:
33081: l_function_allowed VARCHAR2(1);
33082: l_resp_id NUMBER := FND_GLOBAL.Resp_id;
33083:

Line 33367: l_object_relationship_Id pa_object_relationships.object_relationship_Id%TYPE;

33363: l_task_assign_reference VARCHAR2(240);
33364: l_deliverable_id NUMBER;
33365: l_dlvr_version_id NUMBER;
33366: l_function_code Pa_Proj_Elements.function_code%TYPE;
33367: l_object_relationship_Id pa_object_relationships.object_relationship_Id%TYPE;
33368: l_task_assignment_id NUMBER ;
33369:
33370: l_function_allowed VARCHAR2(1);
33371: l_resp_id NUMBER := FND_GLOBAL.Resp_id;

Line 33646: l_object_relationship_Id pa_object_relationships.object_relationship_Id%TYPE;

33642: l_task_assign_reference VARCHAR2(240);
33643: l_deliverable_id NUMBER;
33644: l_dlvr_version_id NUMBER;
33645: l_function_code Pa_Proj_Elements.function_code%TYPE;
33646: l_object_relationship_Id pa_object_relationships.object_relationship_Id%TYPE;
33647: l_task_assignment_id NUMBER ;
33648:
33649: l_function_allowed VARCHAR2(1);
33650: l_resp_id NUMBER := FND_GLOBAL.Resp_id;

Line 33663: FROM PA_OBJECT_RELATIONSHIPS OBJ

33659:
33660: CURSOR c_obj_rel_id(l_task_assng_id NUMBER, l_dlvr_id NUMBER) IS
33661: SELECT
33662: OBJ.OBJECT_RELATIONSHIP_ID
33663: FROM PA_OBJECT_RELATIONSHIPS OBJ
33664: WHERE
33665: OBJ.OBJECT_ID_FROM2 = l_task_assng_id
33666: AND OBJ.OBJECT_ID_TO2 = l_dlvr_id
33667: AND OBJ.OBJECT_TYPE_FROM = 'PA_ASSIGNMENTS'

Line 35429: FROM pa_object_relationships

35425: and element_version_id = c_structure_version_id;
35426:
35427: CURSOR get_rvn(c_id_from NUMBER, c_id_to NUMBER) IS
35428: SELECT record_version_number
35429: FROM pa_object_relationships
35430: WHERE object_id_to1 = c_id_to
35431: AND object_id_from1 = c_id_from
35432: AND relationship_type = 'D';
35433: BEGIN

Line 35690: FROM pa_object_relationships

35686: and element_version_id = c_structure_version_id;
35687:
35688: CURSOR get_rvn(c_id_from NUMBER, c_id_to NUMBER) IS
35689: SELECT object_relationship_id, record_version_number
35690: FROM pa_object_relationships
35691: WHERE object_id_to1 = c_id_to
35692: AND object_id_from1 = c_id_from
35693: AND relationship_type = 'D';
35694: BEGIN

Line 37631: from pa_object_relationships por1, pa_object_relationships por2

37627: and pst.structure_type = c_structure_type;
37628:
37629: cursor l_cur_por1(c_task_version_id NUMBER, c_sub_proj_id NUMBER, c_structure_type VARCHAR2) is
37630: select por2.object_relationship_id, por2.record_version_number
37631: from pa_object_relationships por1, pa_object_relationships por2
37632: where por1.object_id_to1 = por2.object_id_from1
37633: and por1.relationship_type = 'S'
37634: and por1.object_id_from1 = c_task_version_id
37635: and por2.object_id_to2 = c_sub_proj_id

Line 37640: from pa_object_relationships por

37636: and por2.relationship_type = decode(c_structure_type, 'WORKPLAN', 'LW', 'FINANCIAL', 'LF');
37637:
37638: cursor l_cur_por2(c_object_relationship_id NUMBER) is
37639: select por.object_relationship_id, por.record_version_number, por.object_id_from2
37640: from pa_object_relationships por
37641: where por.relationship_type in ('LW','LF')
37642: and por.object_relationship_id = c_object_relationship_id;
37643:
37644: cursor l_cur_prog_name (c_task_version_id NUMBER) is

Line 38221: from pa_object_relationships por1, pa_object_relationships por2

38217: and pst.structure_type = c_structure_type;
38218:
38219: cursor l_cur_por1(c_task_version_id NUMBER, c_sub_proj_id NUMBER, c_structure_type VARCHAR2) is
38220: select por2.object_relationship_id, por2.record_version_number
38221: from pa_object_relationships por1, pa_object_relationships por2
38222: where por1.object_id_to1 = por2.object_id_from1
38223: and por1.relationship_type = 'S'
38224: and por1.object_id_from1 = c_task_version_id
38225: and por2.object_id_to2 = c_sub_proj_id

Line 38230: from pa_object_relationships por

38226: and por2.relationship_type = decode(c_structure_type, 'WORKPLAN', 'LW', 'FINANCIAL', 'LF');
38227:
38228: cursor l_cur_por2(c_object_relationship_id NUMBER) is
38229: select por.object_relationship_id, por.record_version_number, por.object_id_from2
38230: from pa_object_relationships por
38231: where por.relationship_type in ('LW','LF')
38232: and por.object_relationship_id = c_object_relationship_id;
38233:
38234: cursor l_cur_prog_name (c_task_version_id NUMBER) is

Line 39969: FROM pa_object_relationships

39965: );
39966:
39967: CURSOR get_parent_version_id(c_elem_ver_id NUMBER) IS
39968: SELECT object_id_from1
39969: FROM pa_object_relationships
39970: WHERE object_id_to1 = c_elem_ver_id
39971: AND object_type_to = 'PA_TASKS'
39972: AND relationship_type = 'S';
39973:

Line 39979: FROM pa_object_relationships

39975: SELECT object_id_from1
39976: , object_relationship_id
39977: , record_version_number
39978: , relationship_subtype
39979: FROM pa_object_relationships
39980: WHERE object_id_to1 = p_child_version_id
39981: AND relationship_type = 'S';
39982:
39983: v_cur_obj_rel_rec cur_obj_rel%ROWTYPE;

Line 39988: FROM pa_object_relationships a

39984:
39985: CURSOR get_task_weighting(c_task_version_id NUMBER) IS
39986: SELECT a.object_id_from1
39987: , a.weighting_percentage
39988: FROM pa_object_relationships a
39989: WHERE a.object_id_to1 = c_task_version_id
39990: AND a.object_type_to = 'PA_TASKS'
39991: AND a.relationship_type = 'S'
39992: AND a.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');

Line 39999: FROM pa_object_relationships

39995: SELECT '1'
39996: FROM dual
39997: WHERE EXISTS
39998: (SELECT 'xyz'
39999: FROM pa_object_relationships
40000: WHERE object_id_from1 = c_task_version_id
40001: AND object_type_from IN ('PA_TASKS', 'PA_STRUCTURES')
40002: AND relationship_type = 'S'
40003: );

Line 40091: from pa_object_relationships

40087: l_login_id NUMBER;
40088:
40089: CURSOR get_ref_parent_id(c_object_id_to1 NUMBER) is
40090: select object_id_from1
40091: from pa_object_relationships
40092: where object_id_to1 = c_object_id_to1
40093: and relationship_type = 'S';
40094: l_ref_parent_ver_id NUMBER;
40095:

Line 40159: from pa_object_relationships

40155: l_wp_process_flag VARCHAR2(1);
40156:
40157: Cursor get_top_task_ver_id(c_task_ver_id NUMBER) IS
40158: select object_id_to1
40159: from pa_object_relationships
40160: where relationshiP_type = 'S'
40161: and object_type_to = 'PA_TASKS'
40162: start with object_id_to1 = c_task_ver_id
40163: and object_type_to = 'PA_TASKS'

Line 40170: from pa_object_relationships a, pa_proj_element_versions b

40166: and prior object_type_from = object_type_to
40167: and prior relationship_type = relationship_type
40168: intersect
40169: select a.object_id_to1
40170: from pa_object_relationships a, pa_proj_element_versions b
40171: where a.relationshiP_type = 'S'
40172: and a.object_id_from1 = b.parent_structure_version_id
40173: and b.element_version_id = c_task_ver_id
40174: and a.object_type_from = 'PA_STRUCTURES';

Line 40607: from pa_object_relationships

40603: AND(
40604: element_version_id = p_task_version_id -- Source task itself
40605: OR (element_version_id IN -- All tasks below the source task with wbs_level >= src_wbs_level-1
40606: (select object_id_to1
40607: from pa_object_relationships
40608: where relationship_type = 'S'
40609: and object_type_to = 'PA_TASKS'
40610: start with object_id_from1 = l_ref_parent_ver_id
40611: connect by object_id_from1 = PRIOR object_id_to1

Line 41380: FROM pa_object_relationships

41376: );
41377:
41378: CURSOR get_parent_version_id(c_elem_ver_id NUMBER) IS
41379: SELECT object_id_from1
41380: FROM pa_object_relationships
41381: WHERE object_id_to1 = c_elem_ver_id
41382: AND object_type_to = 'PA_TASKS'
41383: AND relationship_type = 'S';
41384:

Line 41390: FROM pa_object_relationships

41386: SELECT object_id_from1
41387: , object_relationship_id
41388: , record_version_number
41389: , relationship_subtype
41390: FROM pa_object_relationships
41391: WHERE object_id_to1 = p_child_version_id
41392: AND relationship_type = 'S';
41393:
41394: v_cur_obj_rel_rec cur_obj_rel%ROWTYPE;

Line 41399: FROM pa_object_relationships a

41395:
41396: CURSOR get_task_weighting(c_task_version_id NUMBER) IS
41397: SELECT a.object_id_from1
41398: , a.weighting_percentage
41399: FROM pa_object_relationships a
41400: WHERE a.object_id_to1 = c_task_version_id
41401: AND a.object_type_to = 'PA_TASKS'
41402: AND a.relationship_type = 'S'
41403: AND a.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');

Line 41410: FROM pa_object_relationships

41406: SELECT '1'
41407: FROM dual
41408: WHERE EXISTS
41409: (SELECT 'xyz'
41410: FROM pa_object_relationships
41411: WHERE object_id_from1 = c_task_version_id
41412: AND object_type_from IN ('PA_TASKS', 'PA_STRUCTURES')
41413: AND relationship_type = 'S'
41414: );

Line 41427: FROM pa_object_relationships a

41423: AND ppe.TYPE_ID = ptt.task_type_id;
41424:
41425: CURSOR get_peer_tasks IS
41426: SELECT b.object_id_to1 object_id_to1
41427: FROM pa_object_relationships a
41428: , pa_object_relationships b
41429: WHERE a.object_id_to1 = p_task_version_id
41430: AND a.object_type_to = 'PA_TASKS'
41431: AND a.object_id_from1 = b.object_id_from1

Line 41428: , pa_object_relationships b

41424:
41425: CURSOR get_peer_tasks IS
41426: SELECT b.object_id_to1 object_id_to1
41427: FROM pa_object_relationships a
41428: , pa_object_relationships b
41429: WHERE a.object_id_to1 = p_task_version_id
41430: AND a.object_type_to = 'PA_TASKS'
41431: AND a.object_id_from1 = b.object_id_from1
41432: AND a.object_type_from = b.object_type_from

Line 41444: FROM pa_object_relationships por,

41440: --This cursor fetches all tasks that are child of ref task but now become child of p_task_version
41441: -- This case should not be possible for Outdent/Indent
41442: CURSOR cur_new_child(c_ref_task_version_id NUMBER, c_display_sequence NUMBER) IS
41443: SELECT por.object_id_to1, ppev.display_sequence, por.record_version_number, por.object_relationship_id
41444: FROM pa_object_relationships por,
41445: pa_proj_element_versions ppev
41446: WHERE object_id_from1 = c_ref_task_version_id
41447: AND object_id_to1 = element_version_id
41448: AND display_sequence > c_display_sequence

Line 41537: from pa_object_relationships

41533:
41534: --bug 2843737
41535: CURSOR get_ref_parent_id(c_object_id_to1 NUMBER) is
41536: select object_id_from1
41537: from pa_object_relationships
41538: where object_id_to1 = c_object_id_to1
41539: and relationship_type = 'S';
41540: l_ref_parent_ver_id NUMBER;
41541: --end bug 2843737

Line 41634: from pa_object_relationships

41630: l_wp_process_flag VARCHAR2(1);
41631:
41632: Cursor get_top_task_ver_id(c_task_ver_id NUMBER) IS
41633: select object_id_to1
41634: from pa_object_relationships
41635: where relationshiP_type = 'S'
41636: and object_type_to = 'PA_TASKS'
41637: start with object_id_to1 = c_task_ver_id
41638: and object_type_to = 'PA_TASKS'

Line 41645: from pa_object_relationships a, pa_proj_element_versions b

41641: and prior object_type_from = object_type_to
41642: and prior relationship_type = relationship_type
41643: intersect
41644: select a.object_id_to1
41645: from pa_object_relationships a, pa_proj_element_versions b
41646: where a.relationshiP_type = 'S'
41647: and a.object_id_from1 = b.parent_structure_version_id
41648: and b.element_version_id = c_task_ver_id
41649: and a.object_type_from = 'PA_STRUCTURES';

Line 41989: from pa_object_relationships

41985: AND(
41986: element_version_id = p_task_version_id -- Source task itself
41987: OR element_version_id IN -- All tasks below the source task
41988: (select object_id_to1
41989: from pa_object_relationships
41990: where relationship_type = 'S'
41991: and object_type_to = 'PA_TASKS'
41992: start with object_id_from1 = l_ref_parent_ver_id
41993: connect by object_id_from1 = PRIOR object_id_to1