The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT project_id
FROM PA_PROJ_ELEMENTS
WHERE proj_element_id = c_task_id;
SELECT proj_element_id
FROM PA_PROJ_ELEMENTS
WHERE project_id = c_project_id;
SELECT ppe2.proj_element_id
FROM PA_PROJ_ELEMENTS ppe, PA_PROJ_ELEMENTS ppe2
WHERE ppe.project_id = c_old_project_id
AND ppe.proj_element_id = c_old_proj_element_id
AND ppe.element_number = ppe2.element_number
AND ppe2.project_id = c_new_project_id;
SELECT DISTINCT limiting_value
FROM pa_project_copy_overrides
WHERE project_id = c_project_id
AND field_name = 'CLASSIFICATION';
SELECT class_category
FROM PA_PROJECT_CLASSES
WHERE project_id = c_old_project_id
AND class_category = c_category
AND class_category NOT IN
(SELECT class_category
FROM PA_PROJECT_CLASSES
where project_id = c_new_project_id);
SELECT class_code
FROM PA_PROJECT_CLASSES
WHERE project_id = c_old_project_id
AND class_category = c_category
MINUS
SELECT class_code
FROM PA_PROJECT_CLASSES
WHERE project_id = c_new_project_id
AND class_category = c_category;
SELECT class_category_id
FROM PA_CLASS_CATEGORIES
WHERE class_category = c_category;
SELECT class_code_id
FROM PA_CLASS_CODES
WHERE class_category = c_category
AND class_code = c_code;
l_deleted_category VARCHAR2(30);
FETCH check_category_removed INTO l_deleted_category;
PA_USER_ATTR_PUB.DELETE_USER_ATTRS_DATA (
p_validate_only => FND_API.G_FALSE
,p_project_id => p_object_id_to
,p_old_classification_id => l_category_id
,p_classification_type => 'CLASS_CATEGORY'
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data );
PA_USER_ATTR_PUB.DELETE_USER_ATTRS_DATA (
p_validate_only => FND_API.G_FALSE
,p_project_id => p_object_id_to
,p_old_classification_id => l_code_id
,p_classification_type => 'CLASS_CODE'
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data );
PROCEDURE DELETE_USER_ATTRS_DATA
( p_api_version IN NUMBER := 1.0
,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
,p_debug_mode IN VARCHAR2 := 'N'
,p_project_id IN NUMBER
,p_proj_element_id IN NUMBER DEFAULT NULL
,p_old_classification_id IN NUMBER
,p_new_classification_id IN NUMBER DEFAULT NULL
,p_classification_type IN VARCHAR2
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
)
IS
l_api_name CONSTANT VARCHAR(30) := 'Delete_User_Attrs_Data';
pa_debug.init_err_stack('PA_USER_ATTR_PUB.Delete_User_Attrs_Data');
pa_debug.debug('PA_USER_ATTR_PUB.Delete_User_Attrs_Data BEGIN');
savepoint delete_user_attrs_data;
PA_USER_ATTR_PVT.DELETE_USER_ATTRS_DATA (
p_commit => FND_API.G_FALSE
,p_validate_only => p_validate_only
,p_validation_level => p_validation_level
,p_calling_module => p_calling_module
,p_debug_mode => p_debug_mode
,p_project_id => p_project_id
,p_proj_element_id => p_proj_element_id
,p_old_classification_id => p_old_classification_id
,p_new_classification_id => p_new_classification_id
,p_classification_type => p_classification_type
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data );
pa_debug.debug('PA_USER_ATTR_PUB.Delete_User_Attrs_Data END');
rollback to delete_user_attrs_data;
rollback to delete_user_attrs_data;
p_procedure_name => 'Delete_User_Attrs_Data',
p_error_text => SUBSTRB(SQLERRM,1,240));
rollback to delete_user_attrs_data;
p_procedure_name => 'Delete_User_Attrs_Data',
p_error_text => SUBSTRB(SQLERRM,1,240));
END DELETE_USER_ATTRS_DATA;
PROCEDURE CHECK_DELETE_ASSOC_OK
( p_api_version IN NUMBER := 1.0
,p_association_id IN NUMBER
,p_classification_code IN VARCHAR2
,p_data_level IN VARCHAR2
,p_attr_group_id IN NUMBER
,p_application_id IN NUMBER
,p_attr_group_type IN VARCHAR2
,p_attr_group_name IN VARCHAR2
,p_enabled_code IN VARCHAR2
,x_ok_to_delete OUT NOCOPY VARCHAR2
,x_return_status OUT NOCOPY VARCHAR2
,x_errorcode OUT NOCOPY NUMBER
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
)
IS
l_api_name CONSTANT VARCHAR(30) := 'Check_Delete_Assoc_Ok';
l_ok_to_delete VARCHAR2(250);
SELECT 'Y'
FROM PA_PROJECTS_ERP_EXT_B
WHERE attr_group_id = p_attr_group_id;
SELECT creation_date
FROM EGO_OBJ_AG_ASSOCS_B
WHERE association_id = p_association_id;
SELECT max(creation_date)
FROM PA_PROJECTS_ERP_EXT_B
WHERE attr_group_id = p_attr_group_id;
x_ok_to_delete := FND_API.G_TRUE;
x_ok_to_delete := FND_API.G_TRUE;
x_ok_to_delete := FND_API.G_FALSE;
p_procedure_name => 'Check_Delete_Assoc_Ok',
p_error_text => SUBSTRB(SQLERRM,1,240));
x_ok_to_delete := FND_API.G_FALSE;
END CHECK_DELETE_ASSOC_OK;
PROCEDURE DELETE_ALL_USER_ATTRS_DATA
( p_api_version IN NUMBER := 1.0
,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
,p_debug_mode IN VARCHAR2 := 'N'
,p_project_id IN NUMBER
,p_proj_element_id IN NUMBER DEFAULT NULL
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
)
IS
l_api_name CONSTANT VARCHAR(30) := 'Delete_All_User_Attrs_Data';
pa_debug.init_err_stack('PA_USER_ATTR_PUB.Delete_All_User_Attrs_Data');
pa_debug.debug('PA_USER_ATTR_PUB.Delete_All_User_Attrs_Data BEGIN');
savepoint delete_all_user_attrs_data;
PA_USER_ATTR_PVT.DELETE_ALL_USER_ATTRS_DATA (
p_commit => FND_API.G_FALSE
,p_validate_only => p_validate_only
,p_validation_level => p_validation_level
,p_calling_module => p_calling_module
,p_debug_mode => p_debug_mode
,p_project_id => p_project_id
,p_proj_element_id => p_proj_element_id
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data );
pa_debug.debug('PA_USER_ATTR_PUB.Delete_All_User_Attrs_Data END');
rollback to delete_all_user_attrs_data;
rollback to delete_all_user_attrs_data;
p_procedure_name => 'Delete_All_User_Attrs_Data',
p_error_text => SUBSTRB(SQLERRM,1,240));
rollback to delete_all_user_attrs_data;
p_procedure_name => 'Delete_All_User_Attrs_Data',
p_error_text => SUBSTRB(SQLERRM,1,240));
END DELETE_ALL_USER_ATTRS_DATA;
SELECT class_category, class_code
FROM PA_PROJECT_CLASSES
WHERE rowid = p_row_id;
SELECT class_category_id
FROM PA_CLASS_CATEGORIES
WHERE class_category = c_class_category;
SELECT class_code_id
FROM PA_CLASS_CODES
WHERE class_category = c_class_category
AND class_code = c_class_code;
SELECT 'Y'
FROM DUAL
WHERE EXISTS
(SELECT classification_code
FROM EGO_OBJ_AG_ASSOCS_B assocs,
FND_OBJECTS obj
WHERE assocs.classification_code = 'CLASS_CATEGORY:'||to_char(c_class_category_id)
AND assocs.object_id = obj.object_id
AND obj.obj_name = 'PA_PROJECTS');
SELECT 'Y'
FROM DUAL
WHERE EXISTS
(SELECT classification_code
FROM EGO_OBJ_AG_ASSOCS_B assocs,
FND_OBJECTS obj
WHERE assocs.classification_code = 'CLASS_CODE:'||to_char(c_class_code_id)
AND assocs.object_id = obj.object_id
AND obj.obj_name = 'PA_PROJECTS');
if p_mode = 'DELETE' then
OPEN C1;
elsif p_mode = 'UPDATE' then
OPEN C1;
SELECT 'Y'
FROM DUAL
WHERE EXISTS
(SELECT classification_code
FROM EGO_OBJ_AG_ASSOCS_B assocs,
FND_OBJECTS obj
WHERE assocs.classification_code = 'PROJECT_TYPE:'||to_char(c_project_type_id)
AND assocs.object_id = obj.object_id
AND obj.obj_name = 'PA_PROJECTS');
SELECT PTT.project_type_id
FROM pa_project_types PTT, pa_projects_all PPA
WHERE PPA.project_id = p_project_id
AND PPA.project_type = PTT.project_type;
SELECT project_type_id
FROM pa_project_types
WHERE project_type = p_new_project_type;