I am building an application that will control the authorization assigned to each component like page items of other applications through PL/SQL code instead of doing it manually through the workspace page development area. Is there any built-in package that I can use for my task.
I tried to explore how APEX is doing that and here are my findings so far:
- Oracle APEX application 4000 on page 4500 on load call ajax process i.e. "getpagedata" , this process creates json using "wwv_flow_property_dev"."emit_page_data" and keep it in a global variable.
- When we make any change to any object i.e. text field authorization, another ajax process fires i.e. "writepagedata", this also creates a JSON and pass it to package i.e. "wwv_flow_property_dev"."write_page_data"
- Now as the body for this package is encrypted and so we cannot analyze how it is making a change to the core table that stores page items information i.e. "wwv_flow_step_items".
I am not able to figure out the remaining flow that happens in "wwv_flow_property_dev"."write_page_data"
I will appreciate if someone can guide me further.
Thanks
@"joelkallman-Oracle" can you please help me in this regard.