hhudson

{
	"ad 0.0 create session": {
		"prefix": "ad create session",
		"body": [
		  "apex_session.create_session(p_app_id=>$1,p_page_id=>$2,p_username=>'HHH');"
		],
		"description": "Create session to run outside of apex"
	  },
	  "ad 0.1 enable debug": {
		"prefix": "ad enable debug",

hhudson

{
	"logger_0 gc_scope_prefix": {
	  "prefix": "logger_0",
	  "body": [
		"gc_scope_prefix constant varchar2(31) := lower($$plsql_unit) || '.';"
	  ],
	  "description": "Define the logger scope prefix at the top of the package body"
	},
	"logger_1.0 l_scope": {
	  "prefix": "logger_1.0",

hhudson

{
	"ad 0.0 create session": {
		"prefix": "ad create session",
		"body": [
		  "apex_session.create_session(p_app_id=>$1,p_page_id=>$2,p_username=>'HHH');"
		],
		"description": "Create session to run outside of apex"
	  },
	  "ad 0.1 enable debug": {
		"prefix": "ad enable debug",

hhudson

select aale.list_entry_id,
       aale.entry_text, 
       aale.entry_target, 
       apex_plugin_util.replace_substitutions (
        p_value => aale.entry_target) entry_url,
       aale.entry_attribute_01, 
       aale.authorization_scheme,
       aale.entry_image
from apex_application_list_entries aale
inner join apex_applications aa on aa.application_id = aale.application_id

hhudson

window.onload = function() {

    apex.actions.add({
    name: "page-help",
    label: "Get Page Help",
    action: function getPageHelp(){
                $('[data-id=pageHelp]').click();
            }
    });

hhudson

/*
 * This script needs to be run from a privileged account with the following grants (SYS will work):
 *    • GRANT CREATE TRIGGER TO {your privileged schema};
 *    • GRANT ADMINISTER DATABASE TRIGGER TO {your privileged schema};
 */

create or replace trigger ait_logon_trigger
after logon on database
when (user not in ('SYS','SYSTEM') and user not like 'APEX%')
begin

hhudson

create or replace force view v_execution_stats as
with execution_stats as (
  select fi.runid,
         fi.symbolid,
         pci.parentsymid,
         rtrim(fi.module || '.' || nullif(fi.function,fi.module), '.') as unit,
         nvl(pci.subtree_elapsed_time, fi.subtree_elapsed_time)/1000000 as subtree_elapsed_time_seconds,
         nvl(pci.function_elapsed_time, fi.function_elapsed_time)/1000000 as function_elapsed_time_seconds,
         fi.line#,
         nvl(pci.calls, fi.calls) as calls,

hhudson

DECLARE
   l_report APEX_IR.T_REPORT;
   l_region_id apex_application_page_regions.region_id%type;
   l_binds varchar2(4000);
BEGIN
   select region_id 
      into l_region_id 
      from apex_application_page_regions 
      where application_id = :APP_ID
      and page_id = :APP_PAGE_ID

hhudson

//window.onbeforeunload = confirmExit;
/* The below will not run unless the above is uncommented.
 * The recommendation is to run the above command in a
 * dynamic action on page load of Page 0 with the Server
 * Side Condition of 'Rows returned' for the following query:
 * select 1
 *   from apex_application_pages
 *   where application_id = :APP_ID
 *   and page_id = :APP_PAGE_ID
 *   and warn_on_unsaved_changes = 'Yes'