jon-dixon

PROCEDURE save_note_bg
  (p_note_id       IN cnnt_notes.note_id%TYPE,
   p_old_checksum  IN VARCHAR2,
   p_note_array    IN wwv_flow_global.vc_arr2) IS

  l_new_checksum      VARCHAR2(100);
  l_current_checksum  VARCHAR2(100);
  l_note_content      cnnt_notes.note_content%TYPE;

BEGIN

jon-dixon

var iteration      = 0;
// Javascript Interval used to call the function saveNote every X seconds.
var saveInterval   = null;
// Page item used to store how many Milliseconds to wait
//   between checks to see if the RTE field has changed.
var saveIntervalMS = $v("P50_SAVE_INTERVAL_MS");
// The maximum number of times we should check for changes.
// Between these two values we could say chek for changes every 
//  30 seconds and stop after an hour.
var saveIterations = $v("P50_SAVE_ITERATIONS");

jon-dixon

create or replace PACKAGE BODY CN_MDM_UTL_PK AS

  GC_SCOPE_PREFIX  CONSTANT VARCHAR2(100) := 'cn.mdm.'||LOWER($$plsql_unit) || '.';

-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
PROCEDURE sync_changed_items (p_last_sync_time VARCHAR2) IS

  CURSOR cr_changed_items (cp_items_json IN CLOB) IS
    SELECT jt.*

jon-dixon

/**
* @namespace var cnHelpUtil = {};
**/
var cnHelpUtil = {};

/**
* @function showHelp
* @example cnHelpUtil.showHelp(this, 'ITEM');
**/
cnHelpUtil.showHelp = function (theEvent, helpTrigger) {

jon-dixon

CREATE OR REPLACE PACKAGE BODY DEMO.CN_CUSTOM_HELP_PK AS
  
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
FUNCTION get_page_item_help_key
  (p_page_item_id IN apex_application_page_items.item_id%TYPE) RETURN custom_apex_help_text.help_key%TYPE IS

  l_help_key      apex_application_page_items.item_help_text%TYPE;

BEGIN

jon-dixon

/**
* @namespace var cnUtil = {};
**/
var cnUtil = {};

/**
* @function setInlineHelp
* @example cnUtil.setInlineHelp('P3_JUSTIFICATION', 'Hello World');
**/
cnUtil.setInlineHelp = function  (itemID, inLineHelpText) {

jon-dixon

CREATE OR REPLACE PACKAGE TABLE_FN_PK AUTHID DEFINER AS

-- Record Type used to define columns for the pipelined output.
TYPE rec_evs_sold IS RECORD
(year_sold      ev_sales_by_year.data_year%TYPE,
 make           ev_sales_by_year.make%TYPE,
 vehicles_sold  NUMBER,
 top_model      ev_sales_by_year.model%TYPE,
 top_model_pct  NUMBER);

jon-dixon

DECLARE
  CURSOR cr_tasks IS
    SELECT task_id
    ,      task_owner
    FROM   cndemo_tasks;
  lt_owner_task_count  apex_t_varchar2;
  l_task_count         NUMBER;
BEGIN
  -- Loop through all tasks.
  FOR task_rec IN cr_tasks LOOP

jon-dixon

DECLARE
  CURSOR cr_tasks IS
    SELECT task_id
    ,      task_status
    FROM   cndemo_tasks;
  lt_archived_task_ids  apex_t_number;
BEGIN
  -- Loop through all tasks.
  FOR task_rec IN cr_tasks LOOP
    IF task_rec.task_status = 'ARCHIVE' THEN

jon-dixon

PROCEDURE sendgrid_webhook 
  (p_json   IN CLOB,
   x_status OUT NUMBER) IS

  l_logger_scope        logger_logs.SCOPE%TYPE := GC_SCOPE_PREFIX || utl_call_stack.subprogram(1)(2);
  l_logger_params       logger.tab_param;

BEGIN

  -- Assume Success.