The following lines contain the word 'select', 'insert', 'update' or 'delete':
insert into bis_refresh_log(
Request_id,
Concurrent_id,
object_type,
Object_name,
ERROR_TYPE,
CORRECTIVE_ACTION_FF,
Exception_message,
Creation_date,
Created_by,
Last_update_date,
Last_update_login,
Last_updated_by,
Attribute1,
Attribute2,
Attribute3,
Attribute4,
Attribute5,
Attribute6,
Attribute7,
Attribute8,
Attribute9,
Attribute10 )
values (
g_request_id,
g_concurrent_id,
p_object_type,
p_object_name,
'MISSING_CURRENCY', --error type
p_CORRECTIVE_ACTION_FF,
p_EXCEPTION_MESSAGE,
sysdate,
g_user_id,
sysdate,
g_login_id,
g_user_id,
p_Rate_type,---attribute 1
p_From_currency,---attribute 2
p_To_currency,---attribute 3
p_effective_date,---attribute 4
null,---attribute 5
null ,---attribute 6
null,---attribute 7
null,---attribute 8
null, ---attribute 9
null); ---attribute 10
insert into bis_refresh_log(
Request_id,
Concurrent_id,
object_type,
Object_name,
ERROR_TYPE,
CORRECTIVE_ACTION_FF,
Exception_message,
Creation_date,
Created_by,
Last_update_date,
Last_update_login,
Last_updated_by,
Attribute1,
Attribute2,
Attribute3,
Attribute4,
Attribute5,
Attribute6,
Attribute7,
Attribute8,
Attribute9,
Attribute10 )
values (
g_request_id,
g_concurrent_id,
p_object_type,
p_object_name,
'MISSING_UOM', --error type
p_CORRECTIVE_ACTION_FF,
p_EXCEPTION_MESSAGE,
sysdate,
g_user_id,
sysdate,
g_login_id,
g_user_id,
p_From_UOM,---attribute 1
p_To_UOM,---attribute 2
p_Inventory_items,---attribute 3
null,---attribute 4
null,---attribute 5
null,---attribute 6
null,---attribute 7
null,---attribute 8
null, ---attribute 9
null); ---attribute 10
insert into bis_refresh_log(
Request_id,
Concurrent_id,
object_type,
Object_name,
ERROR_TYPE,
CORRECTIVE_ACTION_FF,
Exception_message,
Creation_date,
Created_by,
Last_update_date,
Last_update_login,
Last_updated_by,
Attribute1,
Attribute2,
Attribute3,
Attribute4,
Attribute5,
Attribute6,
Attribute7,
Attribute8,
Attribute9,
Attribute10 )
values (
g_request_id,
g_concurrent_id,
p_object_type,
p_object_name,
'MISSING_PERIOD', --error type
p_CORRECTIVE_ACTION_FF,
p_EXCEPTION_MESSAGE,
sysdate,
g_user_id,
sysdate,
g_login_id,
g_user_id,
p_period_name,---attribute 1
p_calendar,---attribute 2
null,---attribute 3
null,---attribute 4
null,---attribute 5
null,---attribute 6
null,---attribute 7
null,---attribute 8
null, ---attribute 9
null); ---attribute 10
insert into bis_refresh_log(
Request_id,
Concurrent_id,
object_type,
Object_name,
ERROR_TYPE,
CORRECTIVE_ACTION_FF,
Exception_message,
Creation_date,
Created_by,
Last_update_date,
Last_update_login,
Last_updated_by,
Attribute1,
Attribute2,
Attribute3,
Attribute4,
Attribute5,
Attribute6,
Attribute7,
Attribute8,
Attribute9,
Attribute10 )
values (
g_request_id,
g_concurrent_id,
p_object_type,
p_object_name,
p_error_type, --error type
p_CORRECTIVE_ACTION_FF,
p_EXCEPTION_MESSAGE,
sysdate,
g_user_id,
sysdate,
g_login_id,
g_user_id,
null,---attribute 1
null,---attribute 2
null,---attribute 3
null,---attribute 4
null,---attribute 5
null,---attribute 6
null,---attribute 7
null,---attribute 8
null, ---attribute 9
null); ---attribute 10
insert into bis_refresh_log(
Request_id,
Concurrent_id,
object_type,
Object_name,
ERROR_TYPE,
CORRECTIVE_ACTION_FF,
Exception_message,
Creation_date,
Created_by,
Last_update_date,
Last_update_login,
Last_updated_by,
Attribute1,
Attribute2,
Attribute3,
Attribute4,
Attribute5,
Attribute6,
Attribute7,
Attribute8,
Attribute9,
Attribute10 )
values (
g_request_id,
g_concurrent_id,
p_object_type,
p_object_name,
'MISSING_CONTRACT', --error type
p_CORRECTIVE_ACTION_FF,
p_EXCEPTION_MESSAGE,
sysdate,
g_user_id,
sysdate,
g_login_id,
g_user_id,
p_Rate_type,---attribute 1
p_From_currency,---attribute 2
p_To_currency,---attribute 3
p_date,---attribute 4
p_date_override,---attribute 5
p_Contract_number,---attribute 6
p_Contract_id ,---attribute 7
p_Contract_status,---attribute 8
null,---attribute 9
null); ---attribute 10