PACKAGE: APPS.HRI_EDW_DIM_JOB

Source

1 PACKAGE hri_edw_dim_job AUTHID CURRENT_USER AS
2 /* $Header: hriedjob.pkh 115.2 2002/06/10 01:30:51 pkm ship       $ */
3 
4 FUNCTION find_job_category(p_job_id          IN NUMBER,
5                            p_sequence        IN NUMBER)
6                            RETURN VARCHAR2;
7 
8 PROCEDURE add_job_category( p_job_cat_set     IN NUMBER,
9                             p_job_cat_lookup  IN VARCHAR2 := null,
10                             p_other_lookup    IN VARCHAR2 := null);
11 
12 PROCEDURE remove_job_category( p_job_cat_set     IN NUMBER,
13                                p_job_cat_lookup  IN VARCHAR2 := null,
14                                p_other_lookup    IN VARCHAR2 := null);
15 
16 PROCEDURE load_row( p_job_cat_set     IN NUMBER,
17                     p_job_cat_lookup  IN VARCHAR2,
18                     p_other_lookup    IN VARCHAR2,
19                     p_owner           IN VARCHAR2 );
20 
21 END hri_edw_dim_job;