{"SPECIFIC_NAME":"audit_insert_to_ohrm_audittrail_online_training","ROUTINE_NAME":"audit_insert_to_ohrm_audittrail_online_training","ROUTINE_TYPE":"PROCEDURE","DATA_TYPE":"","CHARACTER_MAXIMUM_LENGTH":null,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DTD_IDENTIFIER":null,"ROUTINE_BODY":"SQL","ROUTINE_DEFINITION":"BEGIN\nSET @section := (SELECT DISTINCT ohrm_audittrail_section.name FROM ohrm_audittrail_training_online_course_trail\n                 LEFT JOIN ohrm_audittrail_section_actions\n                   ON (ohrm_audittrail_training_online_course_trail.action = ohrm_audittrail_section_actions.action)\n                 LEFT JOIN ohrm_audittrail_section\n                   ON (ohrm_audittrail_section.id = ohrm_audittrail_section_actions.section_id)\n                 WHERE ohrm_audittrail_training_online_course_trail.action = action);\nCASE\nWHEN (SELECT @section) = 'CourseDetail' THEN\nCALL audit_insert_to_ohrm_audittrail_online_training_course_detail(\n            action_time,\n            action_owner_id,\n            action_owner_name,\n            action,\n            action_description,\n            version_id,\n            affected_entity_id,\n            affected_entity_name\n        );\nWHEN (SELECT @section) = 'Resource' THEN\nCALL audit_insert_to_ohrm_audittrail_online_training_resource(\n            action_time,\n            action_owner_id,\n            action_owner_name,\n            action,\n            action_description,\n            version_id,\n            affected_entity_id,\n            affected_entity_name\n        );\nWHEN (SELECT @section) = 'Assessment' THEN\nCALL audit_insert_to_ohrm_audittrail_online_training_assessment(\n            action_time,\n            action_owner_id,\n            action_owner_name,\n            action,\n            action_description,\n            version_id,\n            affected_entity_id,\n            affected_entity_name\n        );\nWHEN (SELECT @section) = 'Reviewer' THEN\nCALL audit_insert_to_ohrm_audittrail_online_training_reviewer(\n            action_time,\n            action_owner_id,\n            action_owner_name,\n            action,\n            action_description,\n            version_id,\n            affected_entity_id,\n            affected_entity_name\n        );\nWHEN (SELECT @section) = 'Approver' THEN\nCALL audit_insert_to_ohrm_audittrail_online_training_approver(\n            action_time,\n            action_owner_id,\n            action_owner_name,\n            action,\n            action_description,\n            version_id,\n            affected_entity_id,\n            affected_entity_name\n        );\nWHEN (SELECT @section) = 'CourseEmployee' THEN\nCALL audit_insert_to_ohrm_audittrail_online_training_course_employee(\n            action_time,\n            action_owner_id,\n            action_owner_name,\n            action,\n            action_description,\n            version_id,\n            affected_entity_id,\n            affected_entity_name\n        );\nWHEN (SELECT @section) = 'MyCourse' THEN\nCALL audit_insert_to_ohrm_audittrail_online_training_my_course(\n            action_time,\n            action_owner_id,\n            action_owner_name,\n            action,\n            action_description,\n            version_id,\n            affected_entity_id,\n            affected_entity_name\n        );\nEND CASE;\nEND","EXTERNAL_NAME":null,"EXTERNAL_LANGUAGE":null,"PARAMETER_STYLE":"SQL","IS_DETERMINISTIC":"NO","SQL_DATA_ACCESS":"CONTAINS SQL","SQL_PATH":null,"SECURITY_TYPE":"DEFINER","SQL_MODE":"","ROUTINE_COMMENT":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"}
{"SPECIFIC_NAME":"audit_insert_to_ohrm_audittrail_online_training_approver","ROUTINE_NAME":"audit_insert_to_ohrm_audittrail_online_training_approver","ROUTINE_TYPE":"PROCEDURE","DATA_TYPE":"","CHARACTER_MAXIMUM_LENGTH":null,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DTD_IDENTIFIER":null,"ROUTINE_BODY":"SQL","ROUTINE_DEFINITION":"BEGIN\n  DECLARE app_id INT;\n  DECLARE app_name VARCHAR(1000) CHARSET UTF8;\n  DECLARE screen_name VARCHAR(1000) CHARSET UTF8;\n\n  SET app_id = @provenience_app_id;\n  SET app_name = @provenience_app_name;\n  SET screen_name = @provenience_screen_name;\nINSERT INTO `ohrm_audittrail_online_training_approver_trail` (\n    action_time,\n    action_owner_id,\n    action_owner_name,\n    action,\n    action_description,\n    version_id,\n    affected_entity_id,\n    affected_entity_name,\n    app_id,\n    app_name,\n    screen_name\n) VALUES (\n             action_time,\n             action_owner_id,\n             action_owner_name,\n             action,\n             action_description,\n             version_id,\n             affected_entity_id,\n             affected_entity_name,\n             app_id,\n             app_name,\n             screen_name\n\n         );\nEND","EXTERNAL_NAME":null,"EXTERNAL_LANGUAGE":null,"PARAMETER_STYLE":"SQL","IS_DETERMINISTIC":"NO","SQL_DATA_ACCESS":"CONTAINS SQL","SQL_PATH":null,"SECURITY_TYPE":"DEFINER","SQL_MODE":"","ROUTINE_COMMENT":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"}
{"SPECIFIC_NAME":"audit_insert_to_ohrm_audittrail_online_training_assessment","ROUTINE_NAME":"audit_insert_to_ohrm_audittrail_online_training_assessment","ROUTINE_TYPE":"PROCEDURE","DATA_TYPE":"","CHARACTER_MAXIMUM_LENGTH":null,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DTD_IDENTIFIER":null,"ROUTINE_BODY":"SQL","ROUTINE_DEFINITION":"BEGIN\n  DECLARE app_id INT;\n  DECLARE app_name VARCHAR(1000) CHARSET UTF8;\n  DECLARE screen_name VARCHAR(1000) CHARSET UTF8;\n\n  SET app_id = @provenience_app_id;\n  SET app_name = @provenience_app_name;\n  SET screen_name = @provenience_screen_name;\nINSERT INTO `ohrm_audittrail_online_training_assessment_trail` (\n    action_time,\n    action_owner_id,\n    action_owner_name,\n    action,\n    action_description,\n    version_id,\n    affected_entity_id,\n    affected_entity_name,\n    app_id,\n    app_name,\n    screen_name\n) VALUES (\n             action_time,\n             action_owner_id,\n             action_owner_name,\n             action,\n             action_description,\n             version_id,\n             affected_entity_id,\n             affected_entity_name,\n             app_id,\n             app_name,\n             screen_name\n         );\nEND","EXTERNAL_NAME":null,"EXTERNAL_LANGUAGE":null,"PARAMETER_STYLE":"SQL","IS_DETERMINISTIC":"NO","SQL_DATA_ACCESS":"CONTAINS SQL","SQL_PATH":null,"SECURITY_TYPE":"DEFINER","SQL_MODE":"","ROUTINE_COMMENT":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"}
{"SPECIFIC_NAME":"audit_insert_to_ohrm_audittrail_online_training_course_detail","ROUTINE_NAME":"audit_insert_to_ohrm_audittrail_online_training_course_detail","ROUTINE_TYPE":"PROCEDURE","DATA_TYPE":"","CHARACTER_MAXIMUM_LENGTH":null,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DTD_IDENTIFIER":null,"ROUTINE_BODY":"SQL","ROUTINE_DEFINITION":"BEGIN\n  DECLARE app_id INT;\n  DECLARE app_name VARCHAR(1000) CHARSET UTF8;\n  DECLARE screen_name VARCHAR(1000) CHARSET UTF8;\n\n  SET app_id = @provenience_app_id;\n  SET app_name = @provenience_app_name;\n  SET screen_name = @provenience_screen_name;\nINSERT INTO `ohrm_audittrail_online_training_course_detail_trail` (\n    action_time,\n    action_owner_id,\n    action_owner_name,\n    action,\n    action_description,\n    version_id,\n    affected_entity_id,\n    affected_entity_name,\n    app_id,\n    app_name,\n    screen_name\n) VALUES (\n             action_time,\n             action_owner_id,\n             action_owner_name,\n             action,\n             action_description,\n             version_id,\n             affected_entity_id,\n             affected_entity_name,\n             app_id,\n             app_name,\n             screen_name\n         );\nEND","EXTERNAL_NAME":null,"EXTERNAL_LANGUAGE":null,"PARAMETER_STYLE":"SQL","IS_DETERMINISTIC":"NO","SQL_DATA_ACCESS":"CONTAINS SQL","SQL_PATH":null,"SECURITY_TYPE":"DEFINER","SQL_MODE":"","ROUTINE_COMMENT":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"}
{"SPECIFIC_NAME":"audit_insert_to_ohrm_audittrail_online_training_course_employee","ROUTINE_NAME":"audit_insert_to_ohrm_audittrail_online_training_course_employee","ROUTINE_TYPE":"PROCEDURE","DATA_TYPE":"","CHARACTER_MAXIMUM_LENGTH":null,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DTD_IDENTIFIER":null,"ROUTINE_BODY":"SQL","ROUTINE_DEFINITION":"BEGIN\n  DECLARE app_id INT;\n  DECLARE app_name VARCHAR(1000) CHARSET UTF8;\n  DECLARE screen_name VARCHAR(1000) CHARSET UTF8;\n\n  SET app_id = @provenience_app_id;\n  SET app_name = @provenience_app_name;\n  SET screen_name = @provenience_screen_name;\nINSERT INTO `ohrm_audittrail_online_training_course_employee_trail` (\n    action_time,\n    action_owner_id,\n    action_owner_name,\n    action,\n    action_description,\n    version_id,\n    affected_entity_id,\n    affected_entity_name,\n    app_id,\n    app_name,\n    screen_name\n) VALUES (\n             action_time,\n             action_owner_id,\n             action_owner_name,\n             action,\n             action_description,\n             version_id,\n             affected_entity_id,\n             affected_entity_name,\n             app_id,\n             app_name,\n             screen_name\n         );\nEND","EXTERNAL_NAME":null,"EXTERNAL_LANGUAGE":null,"PARAMETER_STYLE":"SQL","IS_DETERMINISTIC":"NO","SQL_DATA_ACCESS":"CONTAINS SQL","SQL_PATH":null,"SECURITY_TYPE":"DEFINER","SQL_MODE":"","ROUTINE_COMMENT":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"}
{"SPECIFIC_NAME":"audit_insert_to_ohrm_audittrail_online_training_my_course","ROUTINE_NAME":"audit_insert_to_ohrm_audittrail_online_training_my_course","ROUTINE_TYPE":"PROCEDURE","DATA_TYPE":"","CHARACTER_MAXIMUM_LENGTH":null,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DTD_IDENTIFIER":null,"ROUTINE_BODY":"SQL","ROUTINE_DEFINITION":"BEGIN\n  DECLARE app_id INT;\n  DECLARE app_name VARCHAR(1000) CHARSET UTF8;\n  DECLARE screen_name VARCHAR(1000) CHARSET UTF8;\n\n  SET app_id = @provenience_app_id;\n  SET app_name = @provenience_app_name;\n  SET screen_name = @provenience_screen_name;\nINSERT INTO `ohrm_audittrail_online_training_my_course_trail` (\n    action_time,\n    action_owner_id,\n    action_owner_name,\n    action,\n    action_description,\n    version_id,\n    affected_entity_id,\n    affected_entity_name,\n    app_id,\n    app_name,\n    screen_name\n) VALUES (\n             action_time,\n             action_owner_id,\n             action_owner_name,\n             action,\n             action_description,\n             version_id,\n             affected_entity_id,\n             affected_entity_name,\n             app_id,\n             app_name,\n             screen_name\n         );\nEND","EXTERNAL_NAME":null,"EXTERNAL_LANGUAGE":null,"PARAMETER_STYLE":"SQL","IS_DETERMINISTIC":"NO","SQL_DATA_ACCESS":"CONTAINS SQL","SQL_PATH":null,"SECURITY_TYPE":"DEFINER","SQL_MODE":"","ROUTINE_COMMENT":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"}
{"SPECIFIC_NAME":"audit_insert_to_ohrm_audittrail_online_training_resource","ROUTINE_NAME":"audit_insert_to_ohrm_audittrail_online_training_resource","ROUTINE_TYPE":"PROCEDURE","DATA_TYPE":"","CHARACTER_MAXIMUM_LENGTH":null,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DTD_IDENTIFIER":null,"ROUTINE_BODY":"SQL","ROUTINE_DEFINITION":"BEGIN\n  DECLARE app_id INT;\n  DECLARE app_name VARCHAR(1000) CHARSET UTF8;\n  DECLARE screen_name VARCHAR(1000) CHARSET UTF8;\n\n  SET app_id = @provenience_app_id;\n  SET app_name = @provenience_app_name;\n  SET screen_name = @provenience_screen_name;\nINSERT INTO `ohrm_audittrail_online_training_resource_trail` (\n    action_time,\n    action_owner_id,\n    action_owner_name,\n    action,\n    action_description,\n    version_id,\n    affected_entity_id,\n    affected_entity_name,\n    app_id,\n    app_name,\n    screen_name\n) VALUES (\n             action_time,\n             action_owner_id,\n             action_owner_name,\n             action,\n             action_description,\n             version_id,\n             affected_entity_id,\n             affected_entity_name,\n             app_id,\n             app_name,\n             screen_name\n         );\nEND","EXTERNAL_NAME":null,"EXTERNAL_LANGUAGE":null,"PARAMETER_STYLE":"SQL","IS_DETERMINISTIC":"NO","SQL_DATA_ACCESS":"CONTAINS SQL","SQL_PATH":null,"SECURITY_TYPE":"DEFINER","SQL_MODE":"","ROUTINE_COMMENT":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"}
{"SPECIFIC_NAME":"audit_insert_to_ohrm_audittrail_online_training_reviewer","ROUTINE_NAME":"audit_insert_to_ohrm_audittrail_online_training_reviewer","ROUTINE_TYPE":"PROCEDURE","DATA_TYPE":"","CHARACTER_MAXIMUM_LENGTH":null,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DTD_IDENTIFIER":null,"ROUTINE_BODY":"SQL","ROUTINE_DEFINITION":"BEGIN\n  DECLARE app_id INT;\n  DECLARE app_name VARCHAR(1000) CHARSET UTF8;\n  DECLARE screen_name VARCHAR(1000) CHARSET UTF8;\n\n  SET app_id = @provenience_app_id;\n  SET app_name = @provenience_app_name;\n  SET screen_name = @provenience_screen_name;\nINSERT INTO `ohrm_audittrail_online_training_reviewer_trail` (\n    action_time,\n    action_owner_id,\n    action_owner_name,\n    action,\n    action_description,\n    version_id,\n    affected_entity_id,\n    affected_entity_name,\n    app_id,\n    app_name,\n    screen_name\n) VALUES (\n             action_time,\n             action_owner_id,\n             action_owner_name,\n             action,\n             action_description,\n             version_id,\n             affected_entity_id,\n             affected_entity_name,\n             app_id,\n             app_name,\n             screen_name\n         );\nEND","EXTERNAL_NAME":null,"EXTERNAL_LANGUAGE":null,"PARAMETER_STYLE":"SQL","IS_DETERMINISTIC":"NO","SQL_DATA_ACCESS":"CONTAINS SQL","SQL_PATH":null,"SECURITY_TYPE":"DEFINER","SQL_MODE":"","ROUTINE_COMMENT":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"}