APPS.HRI_EDW_DIM_JOB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 20

  SELECT jei.jei_information1, hrl.meaning
  FROM per_job_extra_info jei,
  hr_lookups hrl
  WHERE jei.job_id = p_job_id
  AND hrl.lookup_type = 'JOB_CATEGORIES'
  AND hrl.lookup_code = jei.jei_information1
  AND information_type = 'Job Category';

Line: 31

  SELECT 1 FROM hri_job_category_sets
  WHERE job_category_set = p_sequence
  AND member_lookup_code = v_job_cat_code;

Line: 37

  SELECT hrl.meaning
  FROM hri_job_category_sets jsc,
  hr_lookups hrl
  WHERE jsc.job_category_set = p_sequence
  AND jsc.member_lookup_code IS NULL
  AND hrl.lookup_type = 'HRI_JOB_CATEGORY_SETS'
  AND hrl.lookup_code = jsc.other_lookup_code;

Line: 82

/* Add_job_category inserts a row if it does not already exist, but updates   */
/* the other lookup row if it exists already and is different.                */
/******************************************************************************/
PROCEDURE add_job_category( p_job_cat_set     IN NUMBER,
                            p_job_cat_lookup  IN VARCHAR2 := null,
                            p_other_lookup    IN VARCHAR2 := null )
IS

BEGIN
	hri_bpl_job.add_job_category
                          ( p_job_cat_set     => p_job_cat_set
                          , p_job_cat_lookup  => p_job_cat_lookup
                          , p_other_lookup    => p_other_lookup);

Line: 103

/* Removes given job category by blanket delete                               */
/******************************************************************************/
PROCEDURE remove_job_category( p_job_cat_set     IN NUMBER,
                               p_job_cat_lookup  IN VARCHAR2 := null,
                               p_other_lookup    IN VARCHAR2 := null )
IS

BEGIN
	hri_bpl_job.remove_job_category
		          ( p_job_cat_set     => p_job_cat_set,
                    p_job_cat_lookup  => p_job_cat_lookup,
                    p_other_lookup    => p_other_lookup);

Line: 120

/* Load row simply calls the update procedure                                 */
/******************************************************************************/
PROCEDURE load_row( p_job_cat_set     IN NUMBER,
                    p_job_cat_lookup  IN VARCHAR2,
                    p_other_lookup    IN VARCHAR2,
                    p_owner           IN VARCHAR2 )
IS

BEGIN

hri_bpl_job.load_row
        ( p_job_cat_set     => p_job_cat_set,
          p_job_cat_lookup  => p_job_cat_lookup,
          p_other_lookup    => p_other_lookup,
          p_owner           => p_owner );