The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE check_delete_phase_ok(
p_api_version IN NUMBER :=1.0 ,
p_phase_id IN NUMBER ,
p_init_msg_list IN VARCHAR2 := NULL ,
x_delete_ok OUT NOCOPY VARCHAR2 , -- NOCOPY change for Bug 4939368
x_return_status OUT NOCOPY VARCHAR2 , -- NOCOPY change for Bug 4939368
x_errorcode OUT NOCOPY NUMBER , -- NOCOPY change for Bug 4939368
x_msg_count OUT NOCOPY NUMBER , -- NOCOPY change for Bug 4939368
x_msg_data OUT NOCOPY VARCHAR2 -- NOCOPY change for Bug 4939368
)
IS
l_api_name CONSTANT VARCHAR(30) := 'check_delete_phase_ok';
l_delete_ok VARCHAR2(1);
x_delete_ok := FND_API.G_FALSE;
EGO_LIFECYCLE_ADMIN_PUB.check_delete_phase_ok(
p_api_version => p_api_version ,
p_phase_id => p_phase_id ,
p_init_msg_list => p_init_msg_list ,
x_delete_ok => l_delete_ok ,
x_return_status => l_return_status ,
x_errorcode => l_errorcode ,
x_msg_count => l_msg_count ,
x_msg_data => l_msg_data );
/* Bug 2760719 -- Added check for l_delete_ok <> FND_API.G_TRUE and moved raise statement
outside the IF l_msg_count > 0 */
IF l_delete_ok <> FND_API.G_TRUE OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
l_msg_count := FND_MSG_PUB.count_msg;
x_delete_ok := l_delete_ok;
x_delete_ok := FND_API.G_FALSE; -- NOCOPY change for Bug 4939368
p_procedure_name => 'check_delete_phase_ok',
p_error_text => x_msg_data);
x_delete_ok := FND_API.G_FALSE; -- NOCOPY change for Bug 4939368
p_procedure_name => 'check_delete_phase_ok',
p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
x_delete_ok := FND_API.G_FALSE; -- NOCOPY change for Bug 4939368
p_procedure_name => 'check_delete_phase_ok',
p_error_text => x_msg_data);
END check_delete_phase_ok;
PROCEDURE process_phase_delete(
p_api_version IN NUMBER := 1.0 ,
p_phase_id IN NUMBER ,
p_init_msg_list IN VARCHAR2 := NULL ,
p_commit IN VARCHAR2 := NULL ,
x_errorcode OUT NOCOPY NUMBER , -- NOCOPY change for Bug 4939368
x_return_status OUT NOCOPY VARCHAR2 , -- NOCOPY change for Bug 4939368
x_msg_count OUT NOCOPY NUMBER , -- NOCOPY change for Bug 4939368
x_msg_data OUT NOCOPY VARCHAR2 -- NOCOPY change for Bug 4939368
)
IS
l_api_name CONSTANT VARCHAR(30) := 'process_phase_delete';
SAVEPOINT wrapper_process_phase_delete;
EGO_LIFECYCLE_ADMIN_PUB.process_phase_delete(
p_api_version => p_api_version ,
p_phase_id => p_phase_id ,
p_init_msg_list => p_init_msg_list ,
p_commit => p_commit ,
x_errorcode => l_errorcode ,
x_msg_count => l_msg_count ,
x_return_status => l_return_status ,
x_msg_data => l_msg_data
);
ROLLBACK TO wrapper_process_phase_delete;
p_procedure_name => 'process_phase_delete',
p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
p_procedure_name => 'process_phase_delete',
p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
ROLLBACK TO wrapper_process_phase_delete;
ROLLBACK TO wrapper_process_phase_delete;
p_procedure_name => 'process_phase_delete',
p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
END process_phase_delete;
PROCEDURE check_delete_lifecycle_ok(
p_api_version IN NUMBER := 1.0 ,
p_lifecycle_id IN NUMBER ,
p_init_msg_list IN VARCHAR2 := NULL ,
x_delete_ok OUT NOCOPY VARCHAR2 , -- NOCOPY change for Bug 4939368
x_return_status OUT NOCOPY VARCHAR2 , -- NOCOPY change for Bug 4939368
x_errorcode OUT NOCOPY NUMBER , -- NOCOPY change for Bug 4939368
x_msg_count OUT NOCOPY NUMBER , -- NOCOPY change for Bug 4939368
x_msg_data OUT NOCOPY VARCHAR2 -- NOCOPY change for Bug 4939368
)
IS
l_api_name CONSTANT VARCHAR(30) := 'check_delete_lifecycle_ok';
l_delete_ok VARCHAR2(1);
x_delete_ok := FND_API.G_FALSE;
EGO_LIFECYCLE_ADMIN_PUB.check_delete_lifecycle_ok(
p_api_version => p_api_version ,
p_lifecycle_id => p_lifecycle_id ,
p_init_msg_list => p_init_msg_list ,
x_delete_ok => l_delete_ok ,
x_return_status => l_return_status ,
x_errorcode => l_errorcode ,
x_msg_count => l_msg_count ,
x_msg_data => l_msg_data );
/* Bug 2760719 -- Added check for l_delete_ok <> FND_API.G_TRUE and moved raise statement
outside the IF l_msg_count > 0 */
IF l_delete_ok <> FND_API.G_TRUE OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
l_msg_count := FND_MSG_PUB.count_msg;
x_delete_ok := l_delete_ok;
x_delete_ok := FND_API.G_FALSE; -- NOCOPY change for Bug 4939368
p_procedure_name => 'check_delete_lifecycle_ok',
p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
x_delete_ok := FND_API.G_FALSE; -- NOCOPY change for Bug 4939368
p_procedure_name => 'check_delete_lifecycle_ok',
p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
x_delete_ok := FND_API.G_FALSE; -- NOCOPY change for Bug 4939368
p_procedure_name => 'check_delete_lifecycle_ok',
p_error_text => x_msg_data);
END check_delete_lifecycle_ok;
PROCEDURE delete_stale_data_for_lc(
p_api_version IN NUMBER := 1.0 ,
p_lifecycle_id IN NUMBER ,
p_init_msg_list IN VARCHAR2 := NULL ,
p_commit IN VARCHAR2 := NULL ,
x_errorcode OUT NOCOPY NUMBER , -- NOCOPY change for Bug 4939368
x_return_status OUT NOCOPY VARCHAR2 , -- NOCOPY change for Bug 4939368
x_msg_count OUT NOCOPY NUMBER , -- NOCOPY change for Bug 4939368
x_msg_data OUT NOCOPY VARCHAR2 -- NOCOPY change for Bug 4939368
)
IS
l_api_name CONSTANT VARCHAR(30) := 'delete_stale_data_for_lc';
SAVEPOINT wrapper_delete_data_for_lc;
EGO_LIFECYCLE_ADMIN_PUB.delete_stale_data_for_lc(
p_api_version => p_api_version ,
p_lifecycle_id => p_lifecycle_id ,
p_init_msg_list => p_init_msg_list ,
p_commit => p_commit ,
x_errorcode => l_errorcode ,
x_msg_count => l_msg_count ,
x_return_status => l_return_status ,
x_msg_data => l_msg_data
);
ROLLBACK TO wrapper_delete_data_for_lc;
p_procedure_name => 'delete_stale_data_for_lc',
p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
p_procedure_name => 'delete_stale_data_for_lc',
p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
ROLLBACK TO wrapper_delete_data_for_lc;
ROLLBACK TO wrapper_delete_data_for_lc;
p_procedure_name => 'delete_stale_data_for_lc',
p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
END delete_stale_data_for_lc;
PROCEDURE check_delete_project_ok(
p_api_version IN NUMBER :=1.0 ,
p_project_id IN NUMBER ,
p_init_msg_list IN VARCHAR2 := NULL ,
x_delete_ok OUT NOCOPY VARCHAR2 , -- NOCOPY change for Bug 4939368
x_return_status OUT NOCOPY VARCHAR2 , -- NOCOPY change for Bug 4939368
x_errorcode OUT NOCOPY NUMBER , -- NOCOPY change for Bug 4939368
x_msg_count OUT NOCOPY NUMBER , -- NOCOPY change for Bug 4939368
x_msg_data OUT NOCOPY VARCHAR2 -- NOCOPY change for Bug 4939368
)
IS
l_api_name CONSTANT VARCHAR(30) := 'check_delete_project_ok';
l_delete_ok VARCHAR2(1);
x_delete_ok := FND_API.G_FALSE;
EGO_LIFECYCLE_USER_PUB.check_delete_project_ok(
p_api_version => p_api_version ,
p_project_id => p_project_id ,
p_init_msg_list => p_init_msg_list ,
x_delete_ok => l_delete_ok ,
x_return_status => l_return_status ,
x_errorcode => l_errorcode ,
x_msg_count => l_msg_count ,
x_msg_data => l_msg_data );
/* Bug 2760719 -- Added check for l_delete_ok <> FND_API.G_TRUE and moved raise statement
outside the IF l_msg_count > 0 */
IF l_delete_ok <> FND_API.G_TRUE OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
l_msg_count := FND_MSG_PUB.count_msg;
x_delete_ok := l_delete_ok;
x_delete_ok := FND_API.G_FALSE; -- NOCOPY change for Bug 4939368
p_procedure_name => 'check_delete_project_ok',
p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
x_delete_ok := FND_API.G_FALSE; -- NOCOPY change for Bug 4939368
p_procedure_name => 'check_delete_project_ok',
p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
x_delete_ok := FND_API.G_FALSE; -- NOCOPY change for Bug 4939368
p_procedure_name => 'check_delete_project_ok',
p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
END check_delete_project_ok;
PROCEDURE delete_all_item_assocs(
p_api_version IN NUMBER :=1.0 ,
p_project_id IN NUMBER ,
p_init_msg_list IN VARCHAR2 := NULL ,
p_commit IN VARCHAR2 := NULL ,
x_errorcode OUT NOCOPY NUMBER , -- NOCOPY change for Bug 4939368
x_return_status OUT NOCOPY VARCHAR2 , -- NOCOPY change for Bug 4939368
x_msg_count OUT NOCOPY NUMBER , -- NOCOPY change for Bug 4939368
x_msg_data OUT NOCOPY VARCHAR2 -- NOCOPY change for Bug 4939368
)
IS
l_api_name CONSTANT VARCHAR(30) := 'delete_all_item_assocs';
SAVEPOINT wrapper_delete_all_item_assocs;
EGO_LIFECYCLE_USER_PUB.delete_all_item_assocs(
p_api_version => p_api_version ,
p_project_id => p_project_id ,
p_commit => p_commit ,
x_errorcode => l_errorcode ,
x_msg_count => l_msg_count ,
x_return_status => l_return_status ,
x_msg_data => l_msg_data );
ROLLBACK TO wrapper_delete_all_item_assocs;
p_procedure_name => 'delete_all_item_assocs',
p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
p_procedure_name => 'delete_all_item_assocs',
p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
ROLLBACK TO wrapper_delete_all_item_assocs;
ROLLBACK TO wrapper_delete_all_item_assocs;
p_procedure_name => 'delete_all_item_assocs',
p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
END delete_all_item_assocs;
select application_id
from fnd_application
where application_short_name = 'EGO';
select nvl(status,'N') from fnd_product_installations
where application_id = x_application_id;
PROCEDURE check_delete_project_ok_eng(
p_api_version IN NUMBER :=1.0 ,
p_project_id IN NUMBER ,
p_init_msg_list IN VARCHAR2 := NULL ,
x_delete_ok OUT NOCOPY VARCHAR2 , -- NOCOPY change for Bug 4939368
x_return_status OUT NOCOPY VARCHAR2 , -- NOCOPY change for Bug 4939368
x_errorcode OUT NOCOPY NUMBER , -- NOCOPY change for Bug 4939368
x_msg_count OUT NOCOPY NUMBER , -- NOCOPY change for Bug 4939368
x_msg_data OUT NOCOPY VARCHAR2 -- NOCOPY change for Bug 4939368
)
IS
l_api_name CONSTANT VARCHAR(30) := 'check_delete_project_ok_eng';
l_delete_ok VARCHAR2(1);
x_delete_ok := FND_API.G_FALSE;
ENG_LIFECYCLE_USER_PUB.check_delete_project_ok(
p_api_version => p_api_version ,
p_project_id => p_project_id ,
p_init_msg_list => p_init_msg_list ,
x_delete_ok => l_delete_ok ,
x_return_status => l_return_status ,
x_errorcode => l_errorcode ,
x_msg_count => l_msg_count ,
x_msg_data => l_msg_data );
IF l_delete_ok <> FND_API.G_TRUE OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
l_msg_count := FND_MSG_PUB.count_msg;
x_delete_ok := l_delete_ok;
x_delete_ok := FND_API.G_FALSE; -- NOCOPY change for Bug 4939368
p_procedure_name => 'check_delete_project_ok_eng',
p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
x_delete_ok := FND_API.G_FALSE; -- NOCOPY change for Bug 4939368
p_procedure_name => 'check_delete_project_ok_eng',
p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
x_delete_ok := FND_API.G_FALSE; -- NOCOPY change for Bug 4939368
p_procedure_name => 'check_delete_project_ok_eng',
p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
END check_delete_project_ok_eng;
PROCEDURE check_delete_task_ok_eng(
p_api_version IN NUMBER :=1.0 ,
p_task_id IN NUMBER ,
p_init_msg_list IN VARCHAR2 := NULL ,
x_delete_ok OUT NOCOPY VARCHAR2 , -- NOCOPY change for Bug 4939368
x_return_status OUT NOCOPY VARCHAR2 , -- NOCOPY change for Bug 4939368
x_errorcode OUT NOCOPY NUMBER , -- NOCOPY change for Bug 4939368
x_msg_count OUT NOCOPY NUMBER , -- NOCOPY change for Bug 4939368
x_msg_data OUT NOCOPY VARCHAR2 -- NOCOPY change for Bug 4939368
)
IS
l_api_name CONSTANT VARCHAR(30) := 'check_delete_task_ok_eng';
l_delete_ok VARCHAR2(1);
x_delete_ok := FND_API.G_FALSE;
ENG_LIFECYCLE_USER_PUB.check_delete_task_ok(
p_api_version => p_api_version ,
p_task_id => p_task_id ,
p_init_msg_list => p_init_msg_list ,
x_delete_ok => l_delete_ok ,
x_return_status => l_return_status ,
x_errorcode => l_errorcode ,
x_msg_count => l_msg_count ,
x_msg_data => l_msg_data );
IF l_delete_ok <> FND_API.G_TRUE OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
l_msg_count := FND_MSG_PUB.count_msg;
x_delete_ok := l_delete_ok;
x_delete_ok := FND_API.G_FALSE; -- NOCOPY change for Bug 4939368
p_procedure_name => 'check_delete_task_ok_eng',
p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
x_delete_ok := FND_API.G_FALSE; -- NOCOPY change for Bug 4939368
p_procedure_name => 'check_delete_task_ok_eng',
p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
x_delete_ok := FND_API.G_FALSE; -- NOCOPY change for Bug 4939368
p_procedure_name => 'check_delete_task_ok_eng',
p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
END check_delete_task_ok_eng;
PROCEDURE process_phase_code_delete(
p_api_version IN NUMBER := 1.0 ,
p_phase_code IN NUMBER ,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
p_commit IN VARCHAR2 := FND_API.G_FALSE ,
x_return_status OUT NOCOPY VARCHAR2 , -- NOCOPY change for Bug 4939368
x_errorcode OUT NOCOPY NUMBER , -- NOCOPY change for Bug 4939368
x_msg_count OUT NOCOPY NUMBER , -- NOCOPY change for Bug 4939368
x_msg_data OUT NOCOPY VARCHAR2 -- NOCOPY change for Bug 4939368
)
IS
l_api_name CONSTANT VARCHAR(30) := 'process_phase_code_delete';
SAVEPOINT wrp_process_phase_code_delete;
EGO_LIFECYCLE_ADMIN_PUB.process_phase_code_delete(
p_api_version => p_api_version ,
p_phase_code => p_phase_code ,
p_init_msg_list => p_init_msg_list ,
p_commit => p_commit ,
x_return_status => l_return_status ,
x_errorcode => l_errorcode ,
x_msg_count => l_msg_count ,
x_msg_data => l_msg_data
);
ROLLBACK TO wrp_process_phase_code_delete;
p_procedure_name => 'process_phase_code_delete',
p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
p_procedure_name => 'process_phase_code_delete',
p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
ROLLBACK TO wrp_process_phase_code_delete;
ROLLBACK TO wrp_process_phase_code_delete;
p_procedure_name => 'process_phase_code_delete',
p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
END process_phase_code_delete;