The APEX_AUTOMATION package provides automated functionality to your environment. Automations are a sequential set of actions that are triggered by query results. Use automation to monitor data and then perform the appropriate action, such as auto-approving specific requests and sending email alerts.
VIDEO
https://youtu.be/jq2uMbrxTds
DISABLE Procedure
ENABLE Procedure
EXECUTE Procedure
EXECUTE for Query Context Procedure
EXIT Procedure
GET_LAST_RUN Return Function
GET_LAST_RUN_TIMESTAMP Function
LOG_ERROR Procedure
LOG_INFO Procedure
LOG_WARN Procedure
RESCHEDULE Procedure
SKIP_CURRENT_ROW Procedure
BEGIN
apex_automation.enable(
p_application_id => 75605,
p_static_id => 'expenses' );
END;
BEGIN
apex_automation.disable(
p_application_id => 75605,
p_static_id => 'expenses' );
END;
-- This example executes the automation my_emp_table_automation and applies a filter to the automation query on the DEPTNO column (DEPTNO = 10).
DECLARE
l_filters apex_exec.t_filters;
BEGIN
apex_session.create_session( 100, 1, 'ADMIN' );
apex_exec.add_filter(
p_filters => l_filters,
p_column_name => 'DEPTNO',
p_filter_type => apex_exec.c_filter_eq,
p_value => 10 );
apex_automation.execute(
p_static_id => 'my_emp_table_automation',
p_filters => l_filters );
END;
https://docs.oracle.com/en/database/ora ... 730775ABE7
APEX_AUTOMATION Package
APEX_AUTOMATION Package
Malik Sikandar Hayat
admin@erpstuff.com
admin@erpstuff.com
Who is online
Users browsing this forum: No registered users and 48 guests