APPS.PA_PROJECT_PUB dependencies on PA_OBJECT_RELATIONSHIPS

Line 10342: from pa_projects_all ppa, pa_object_relationships por

10338: where ppa.project_id = c_project_id;
10339:
10340: cursor cur_prog_name (c_project_id NUMBER) is
10341: select ppa.name
10342: from pa_projects_all ppa, pa_object_relationships por
10343: where ppa.project_id = por.object_id_to2
10344: and por.object_id_to2 = c_project_id
10345: and por.relationship_type in ('LW','LF')
10346: union all

Line 10348: from pa_projects_all ppa, pa_object_relationships por

10344: and por.object_id_to2 = c_project_id
10345: and por.relationship_type in ('LW','LF')
10346: union all
10347: select ppa.name
10348: from pa_projects_all ppa, pa_object_relationships por
10349: where ppa.project_id = por.object_id_from2
10350: and por.object_id_from2 = c_project_id
10351: and por.relationship_type in ('LW','LF');
10352:

Line 32166: l_object_relationship_Id pa_object_relationships.object_relationship_Id%TYPE;

32162: l_task_reference VARCHAR2(240);
32163: l_deliverable_id NUMBER;
32164: l_dlvr_version_id NUMBER;
32165: l_function_code Pa_Proj_Elements.function_code%TYPE;
32166: l_object_relationship_Id pa_object_relationships.object_relationship_Id%TYPE;
32167: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
32168:
32169: l_function_allowed VARCHAR2(1);
32170: l_resp_id NUMBER := FND_GLOBAL.Resp_id;

Line 32454: l_object_relationship_Id pa_object_relationships.object_relationship_Id%TYPE;

32450: l_task_reference VARCHAR2(240);
32451: l_deliverable_id NUMBER;
32452: l_dlvr_version_id NUMBER;
32453: l_function_code Pa_Proj_Elements.function_code%TYPE;
32454: l_object_relationship_Id pa_object_relationships.object_relationship_Id%TYPE;
32455:
32456: l_function_allowed VARCHAR2(1);
32457: l_resp_id NUMBER := FND_GLOBAL.Resp_id;
32458:

Line 32742: l_object_relationship_Id pa_object_relationships.object_relationship_Id%TYPE;

32738: l_task_assign_reference VARCHAR2(240);
32739: l_deliverable_id NUMBER;
32740: l_dlvr_version_id NUMBER;
32741: l_function_code Pa_Proj_Elements.function_code%TYPE;
32742: l_object_relationship_Id pa_object_relationships.object_relationship_Id%TYPE;
32743: l_task_assignment_id NUMBER ;
32744:
32745: l_function_allowed VARCHAR2(1);
32746: l_resp_id NUMBER := FND_GLOBAL.Resp_id;

Line 33021: l_object_relationship_Id pa_object_relationships.object_relationship_Id%TYPE;

33017: l_task_assign_reference VARCHAR2(240);
33018: l_deliverable_id NUMBER;
33019: l_dlvr_version_id NUMBER;
33020: l_function_code Pa_Proj_Elements.function_code%TYPE;
33021: l_object_relationship_Id pa_object_relationships.object_relationship_Id%TYPE;
33022: l_task_assignment_id NUMBER ;
33023:
33024: l_function_allowed VARCHAR2(1);
33025: l_resp_id NUMBER := FND_GLOBAL.Resp_id;

Line 33038: FROM PA_OBJECT_RELATIONSHIPS OBJ

33034:
33035: CURSOR c_obj_rel_id(l_task_assng_id NUMBER, l_dlvr_id NUMBER) IS
33036: SELECT
33037: OBJ.OBJECT_RELATIONSHIP_ID
33038: FROM PA_OBJECT_RELATIONSHIPS OBJ
33039: WHERE
33040: OBJ.OBJECT_ID_FROM2 = l_task_assng_id
33041: AND OBJ.OBJECT_ID_TO2 = l_dlvr_id
33042: AND OBJ.OBJECT_TYPE_FROM = 'PA_ASSIGNMENTS'

Line 34782: FROM pa_object_relationships

34778: and element_version_id = c_structure_version_id;
34779:
34780: CURSOR get_rvn(c_id_from NUMBER, c_id_to NUMBER) IS
34781: SELECT record_version_number
34782: FROM pa_object_relationships
34783: WHERE object_id_to1 = c_id_to
34784: AND object_id_from1 = c_id_from
34785: AND relationship_type = 'D';
34786: BEGIN

Line 35043: FROM pa_object_relationships

35039: and element_version_id = c_structure_version_id;
35040:
35041: CURSOR get_rvn(c_id_from NUMBER, c_id_to NUMBER) IS
35042: SELECT object_relationship_id, record_version_number
35043: FROM pa_object_relationships
35044: WHERE object_id_to1 = c_id_to
35045: AND object_id_from1 = c_id_from
35046: AND relationship_type = 'D';
35047: BEGIN

Line 36976: from pa_object_relationships por1, pa_object_relationships por2

36972: and pst.structure_type = c_structure_type;
36973:
36974: cursor l_cur_por1(c_task_version_id NUMBER, c_sub_proj_id NUMBER, c_structure_type VARCHAR2) is
36975: select por2.object_relationship_id, por2.record_version_number
36976: from pa_object_relationships por1, pa_object_relationships por2
36977: where por1.object_id_to1 = por2.object_id_from1
36978: and por1.relationship_type = 'S'
36979: and por1.object_id_from1 = c_task_version_id
36980: and por2.object_id_to2 = c_sub_proj_id

Line 36985: from pa_object_relationships por

36981: and por2.relationship_type = decode(c_structure_type, 'WORKPLAN', 'LW', 'FINANCIAL', 'LF');
36982:
36983: cursor l_cur_por2(c_object_relationship_id NUMBER) is
36984: select por.object_relationship_id, por.record_version_number, por.object_id_from2
36985: from pa_object_relationships por
36986: where por.relationship_type in ('LW','LF')
36987: and por.object_relationship_id = c_object_relationship_id;
36988:
36989: cursor l_cur_prog_name (c_task_version_id NUMBER) is

Line 37564: from pa_object_relationships por1, pa_object_relationships por2

37560: and pst.structure_type = c_structure_type;
37561:
37562: cursor l_cur_por1(c_task_version_id NUMBER, c_sub_proj_id NUMBER, c_structure_type VARCHAR2) is
37563: select por2.object_relationship_id, por2.record_version_number
37564: from pa_object_relationships por1, pa_object_relationships por2
37565: where por1.object_id_to1 = por2.object_id_from1
37566: and por1.relationship_type = 'S'
37567: and por1.object_id_from1 = c_task_version_id
37568: and por2.object_id_to2 = c_sub_proj_id

Line 37573: from pa_object_relationships por

37569: and por2.relationship_type = decode(c_structure_type, 'WORKPLAN', 'LW', 'FINANCIAL', 'LF');
37570:
37571: cursor l_cur_por2(c_object_relationship_id NUMBER) is
37572: select por.object_relationship_id, por.record_version_number, por.object_id_from2
37573: from pa_object_relationships por
37574: where por.relationship_type in ('LW','LF')
37575: and por.object_relationship_id = c_object_relationship_id;
37576:
37577: cursor l_cur_prog_name (c_task_version_id NUMBER) is