APPS.PA_LIFECYCLES_PVT dependencies on PA_PROJ_STRUCTURE_TYPES

Line 289: SELECT PA_PROJ_STRUCTURE_TYPES_S.NEXTVAL

285: IF(p_debug_mode = 'Y') THEN
286: pa_debug.debug('CREATE_LIFECYCLE PVT:Obtaining proj_structure_type_id...');
287: END IF;
288:
289: SELECT PA_PROJ_STRUCTURE_TYPES_S.NEXTVAL
290: INTO l_proj_struct_type_id
291: FROM dual;
292:
293: OPEN cur_struc_type_id;

Line 298: pa_debug.debug('CREATE_LIFECYCLE PVT:Inserting into pa_proj_structure_types...');

294: FETCH cur_struc_type_id INTO l_structure_type_id;
295: CLOSE cur_struc_type_id;
296:
297: IF(p_debug_mode = 'Y') THEN
298: pa_debug.debug('CREATE_LIFECYCLE PVT:Inserting into pa_proj_structure_types...');
299: END IF;
300:
301:
302: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(

Line 302: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(

298: pa_debug.debug('CREATE_LIFECYCLE PVT:Inserting into pa_proj_structure_types...');
299: END IF;
300:
301:
302: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(
303: X_ROWID => l_row_id ,
304: X_PROJ_STRUCTURE_TYPE_ID => l_proj_struct_type_id ,
305: X_PROJ_ELEMENT_ID => l_lifecycle_id ,
306: X_STRUCTURE_TYPE_ID => l_structure_type_id ,

Line 925: FROM pa_proj_structure_types

921:
922: CURSOR l_row_proj_structure_types
923: IS
924: SELECT rowid
925: FROM pa_proj_structure_types
926: WHERE proj_element_id = P_lifecycle_id;
927:
928:
929: cursor l_row_lifecycle_usages

Line 1101: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle:Calling PA_PROJ_STRUCTURE_TYPES_PKG.delete_Row');

1097:
1098: PA_PROJ_ELEM_VER_STRUCTURE_PKG.delete_Row(l_rowid);
1099:
1100: IF (p_debug_mode = 'Y') THEN
1101: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle:Calling PA_PROJ_STRUCTURE_TYPES_PKG.delete_Row');
1102: END IF;
1103:
1104: OPEN l_row_proj_structure_types;
1105: FETCH l_row_proj_structure_types into l_rowid;

Line 1108: PA_PROJ_STRUCTURE_TYPES_PKG.delete_Row(l_rowid);

1104: OPEN l_row_proj_structure_types;
1105: FETCH l_row_proj_structure_types into l_rowid;
1106: CLOSE l_row_proj_structure_types;
1107:
1108: PA_PROJ_STRUCTURE_TYPES_PKG.delete_Row(l_rowid);
1109:
1110: IF (p_debug_mode = 'Y') THEN
1111: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle:Calling PA_LIFECYCLE_USAGES_PKG.delete_Row');
1112: END IF;