CREATE OR REPLACE PACKAGE OPLK_JOB_SHORTAGE_QTY AS
 
  g_tab         VARCHAR2(1) := chr(9);
  g_change_line VARCHAR2(2) := chr(10) || chr(13);
  g_line        VARCHAR2(150) := rpad('-', 150, '-');
  g_space       VARCHAR2(40) := 'exit';

  g_last_updated_date DATE := SYSDATE;
  g_last_updated_by   NUMBER := fnd_global.user_id;
  g_creation_date     DATE := SYSDATE;
  g_created_by        NUMBER := fnd_global.user_id;
  g_last_update_login NUMBER := fnd_global.login_id;
  g_num_format        VARCHAR2(30) := 'FM9999999999999999999990.00';
  g_date_format       VARCHAR2(30) := 'YYYY-MM-DD HH24:MI:SS';