APPS.PA_PROJ_STRUCTURE_PVT dependencies on PA_OBJECT_RELATIONSHIPS

Line 203: /*pa_object_relationships_pkg.insert_row(

199: PA_UTILS.ADD_Message('PA','PA_STRUCT_CREATE_ERR');
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: ELSE
202: /* call table handler */
203: /*pa_object_relationships_pkg.insert_row(
204: p_user_id => l_user_id,
205: p_object_type_from => 'PA_TASKS',
206: p_object_id_from1 => p_task_id,
207: p_object_id_from2 => l_owning_proj_id,

Line 348: pa_object_relationships

344: CURSOR get_all_projects_for_task(l_task_id NUMBER) IS
345: select
346: object_id_to1, object_relationship_id
347: from
348: pa_object_relationships
349: where
350: object_id_from1 = l_task_id and
351: OBJECT_TYPE_FROM = 'PA_TASKS' and
352: relationship_type = 'H';

Line 358: pa_object_relationships

354: CURSOR get_all_tasks_for_project(l_project_id NUMBER) IS
355: select
356: object_id_from1, object_relationship_id
357: from
358: pa_object_relationships
359: where
360: (object_id_to1 = l_project_id and
361: relationship_type = 'H')
362: or

Line 370: pa_object_relationships

366: CURSOR get_selected_relationship(l_task_id NUMBER, l_project_id NUMBER) IS
367: select
368: object_relationship_id
369: from
370: pa_object_relationships
371: where
372: object_type_to = 'PA_PROJECTS' and
373: object_type_from = 'PA_TASKS' and
374: object_id_to1 = l_project_id and

Line 401: pa_object_relationships pora,

397: cp_dest_proj_id NUMBER) IS
398: SELECT porb.object_relationship_id lnk_obj_rel_id,
399: porb.record_version_number lnk_rel_rec_ver_number
400: FROM pa_proj_element_versions ppev,
401: pa_object_relationships pora,
402: pa_object_relationships porb,
403: pa_proj_elements ppe
404: WHERE pora.relationship_type = 'S'
405: AND ppev.project_id = cp_src_proj_id

Line 402: pa_object_relationships porb,

398: SELECT porb.object_relationship_id lnk_obj_rel_id,
399: porb.record_version_number lnk_rel_rec_ver_number
400: FROM pa_proj_element_versions ppev,
401: pa_object_relationships pora,
402: pa_object_relationships porb,
403: pa_proj_elements ppe
404: WHERE pora.relationship_type = 'S'
405: AND ppev.project_id = cp_src_proj_id
406: AND pora.OBJECT_ID_FROM1 = cp_src_task_ver_id

Line 425: pa_object_relationships pora,

421: cp_src_proj_id NUMBER) IS
422: SELECT porb.object_relationship_id lnk_obj_rel_id,
423: porb.record_version_number lnk_rel_rec_ver_number
424: FROM pa_proj_element_versions ppev,
425: pa_object_relationships pora,
426: pa_object_relationships porb,
427: pa_proj_elements ppe
428: WHERE pora.relationship_type = 'S'
429: AND ppev.project_id = cp_src_proj_id

Line 426: pa_object_relationships porb,

422: SELECT porb.object_relationship_id lnk_obj_rel_id,
423: porb.record_version_number lnk_rel_rec_ver_number
424: FROM pa_proj_element_versions ppev,
425: pa_object_relationships pora,
426: pa_object_relationships porb,
427: pa_proj_elements ppe
428: WHERE pora.relationship_type = 'S'
429: AND ppev.project_id = cp_src_proj_id
430: AND pora.OBJECT_ID_FROM1 = cp_src_task_ver_id

Line 449: FROM pa_object_relationships porb

445: CURSOR get_str_sub_proj_ass_det(cp_dest_struct_ver_id NUMBER,
446: cp_dest_proj_id NUMBER) IS
447: SELECT porb.object_relationship_id lnk_obj_rel_id,
448: porb.record_version_number lnk_rel_rec_ver_number
449: FROM pa_object_relationships porb
450: WHERE porb.OBJECT_ID_to1 = cp_dest_struct_ver_id
451: AND porb.object_id_from2 = cp_dest_proj_id
452: AND porb.object_id_to2 <> porb.object_id_from2
453: AND porb.object_type_to = 'PA_STRUCTURES'

Line 526: pa_object_relationships_pkg.delete_row(

522: LOOP
523: FETCH get_selected_relationship INTO l_object_relationship_id;
524: EXIT WHEN get_selected_relationship%NOTFOUND;
525: BEGIN
526: pa_object_relationships_pkg.delete_row(
527: P_OBJECT_RELATIONSHIP_ID => l_object_relationship_id,
528: P_OBJECT_TYPE_FROM => null,
529: P_OBJECT_ID_FROM1 => p_task_id,
530: P_OBJECT_ID_FROM2 => null,

Line 609: /*pa_object_relationships_pkg.delete_row(

605: --EXIT when l_disassociation = 'N';
606: --
607: -- call table handler api
608: BEGIN
609: /*pa_object_relationships_pkg.delete_row(
610: P_OBJECT_RELATIONSHIP_ID => l_object_relationship_id,
611: P_OBJECT_TYPE_FROM => null,
612: P_OBJECT_ID_FROM1 => p_task_id,
613: P_OBJECT_ID_FROM2 => null,

Line 673: /*pa_object_relationships_pkg.delete_row(

669: /* will check them. do not need to check current project relationship */
670: /* with other tasks because we check if contract is associated to it */
671: /* call table handler api */
672: BEGIN
673: /*pa_object_relationships_pkg.delete_row(
674: P_OBJECT_RELATIONSHIP_ID => l_object_relationship_id,
675: P_OBJECT_TYPE_FROM => null,
676: P_OBJECT_ID_FROM1 => l_task_id,
677: P_OBJECT_ID_FROM2 => null,