APPS.PA_LIFECYCLES_PVT dependencies on PA_OBJECT_RELATIONSHIPS

Line 757: SELECT pa_object_relationships_s.NEXTVAL

753: IF(p_debug_mode = 'Y') THEN
754: pa_debug.debug('CREATE_LIFECYCLE PVT.create_lifecyle_phase:Obtaining OBJECT_RELATIONSHIP_ID...');
755: END IF;
756:
757: SELECT pa_object_relationships_s.NEXTVAL
758: INTO l_obj_relnship_id
759: FROM dual;
760:
761: IF(p_debug_mode = 'Y') THEN

Line 762: pa_debug.debug('CREATE_LIFECYCLE PVT.create_lifecyle_phas:Inserting into PA_OBJECT_RELATIONSHIPS...');

758: INTO l_obj_relnship_id
759: FROM dual;
760:
761: IF(p_debug_mode = 'Y') THEN
762: pa_debug.debug('CREATE_LIFECYCLE PVT.create_lifecyle_phas:Inserting into PA_OBJECT_RELATIONSHIPS...');
763: END IF;
764:
765: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
766: p_user_id => FND_GLOBAL.USER_ID ,

Line 765: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

761: IF(p_debug_mode = 'Y') THEN
762: pa_debug.debug('CREATE_LIFECYCLE PVT.create_lifecyle_phas:Inserting into PA_OBJECT_RELATIONSHIPS...');
763: END IF;
764:
765: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
766: p_user_id => FND_GLOBAL.USER_ID ,
767: p_object_type_from => 'PA_STRUCTURES' ,
768: p_object_id_from1 => l_life_elem_ver_id ,
769: p_object_id_from2 => NULL ,

Line 1240: From pa_object_relationships

1236:
1237: CURSOR l_row_object_relationship
1238: IS
1239: Select object_relationship_id, record_version_number
1240: From pa_object_relationships
1241: Where object_type_from = 'PA_STRUCTURES'
1242: and object_id_from1 = l_par_element_version_id
1243: and object_type_to = c_object_type
1244: and object_id_to1 = l_element_version_id

Line 1384: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle_phases:Calling PA_OBJECT_RELATIONSHIPS_PKG.delete_Row');

1380: PA_PROJ_ELEMENT_SCH_PKG.delete_Row(l_rowid);
1381:
1382:
1383: IF (p_debug_mode = 'Y') THEN
1384: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle_phases:Calling PA_OBJECT_RELATIONSHIPS_PKG.delete_Row');
1385: END IF;
1386:
1387: OPEN l_row_object_relationship;
1388: FETCH l_row_object_relationship INTO l_obj_rel_id, l_record_version_number;

Line 1391: PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW(

1387: OPEN l_row_object_relationship;
1388: FETCH l_row_object_relationship INTO l_obj_rel_id, l_record_version_number;
1389: CLOSE l_row_object_relationship;
1390:
1391: PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW(
1392: p_object_relationship_id => l_obj_rel_id ,
1393: p_object_type_from => NULL ,
1394: p_object_id_from1 => NULL ,
1395: p_object_id_from2 => NULL ,