APPS.PA_OPPORTUNITY_MGT_PVT dependencies on PA_OBJECT_RELATIONSHIPS

Line 625: FROM pa_object_relationships

621:
622: IS
623: CURSOR c1 IS
624: SELECT object_id_from1 request_id
625: FROM pa_object_relationships
626: WHERE relationship_type = 'A'
627: AND object_type_from = 'PA_PROJECT_REQUESTS'
628: AND object_type_to = 'PA_PROJECTS'
629: AND object_id_to1 = p_project_id;

Line 635: FROM pa_object_relationships

631: l_request_id NUMBER;
632:
633: CURSOR c2 IS
634: SELECT object_relationship_id, record_version_number
635: FROM pa_object_relationships
636: WHERE ((object_type_from = 'PA_PROJECT_REQUESTS'
637: AND object_type_to = 'PA_PROJECTS'
638: AND object_id_from1 = l_request_id
639: AND object_id_to1 = p_project_id) OR

Line 670: PA_OBJECT_RELATIONSHIPS_PKG.delete_row (

666:
667: -- Delete relationship.
668: l_request_id := v_c1.request_id;
669: FOR v_c2 IN c2 LOOP
670: PA_OBJECT_RELATIONSHIPS_PKG.delete_row (
671: p_object_relationship_id => v_c2.object_relationship_id,
672: p_object_type_from => NULL,
673: p_object_id_from1 => NULL,
674: p_object_id_from2 => NULL,

Line 955: FROM pa_object_relationships

951: IS
952: -- Start of changes for bug 4757078
953: /* CURSOR c1 IS
954: SELECT object_type_from, object_type_to
955: FROM pa_object_relationships
956: WHERE relationship_type = 'A'
957: AND relationship_subtype = 'PROJECT_REQUEST'
958: START WITH (object_type_from = 'PA_PROJECTS'
959: AND object_type_to = 'PA_PROJECT_REQUESTS'

Line 966: FROM pa_object_relationships

962: AND PRIOR object_id_from1 <> object_id_to1);*/
963:
964: CURSOR c1 IS
965: SELECT object_type_from, object_type_to
966: FROM pa_object_relationships
967: START WITH (object_type_from = 'PA_PROJECTS'
968: AND object_type_to = 'PA_PROJECT_REQUESTS'
969: AND object_id_from1 = p_project_id)
970: CONNECT BY (PRIOR object_id_to1 = object_id_from1