DBA Data[Home] [Help]

APPS.HRI_OPL_JOBH dependencies on HRI_CNFG_JOBH_FLEX_COLS

Line 92: hri_cnfg_jobh_flex_cols

88: CURSOR incr_jfm_flex_type_csr IS
89: SELECT
90: flexfield_type
91: FROM
92: hri_cnfg_jobh_flex_cols
93: WHERE job_fmly_column IS NOT NULL
94: AND rownum = 1;
95:
96: CURSOR incr_jfn_flex_type_csr IS

Line 100: hri_cnfg_jobh_flex_cols

96: CURSOR incr_jfn_flex_type_csr IS
97: SELECT
98: flexfield_type
99: FROM
100: hri_cnfg_jobh_flex_cols
101: WHERE job_fnctn_column IS NOT NULL
102: AND rownum = 1;
103:
104: l_flexfield_type VARCHAR2(30);

Line 228: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_hri_schema || '.hri_cnfg_jobh_flex_cols';

224:
225: BEGIN
226:
227: -- Truncate table
228: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_hri_schema || '.hri_cnfg_jobh_flex_cols';
229:
230: -- Get flexfield types for full refresh of config table
231: l_job_fnctn_flex_type := get_flexfield_type('JOB_FUNCTION');
232: l_job_fmly_flex_type := get_flexfield_type('JOB_FAMILY');

Line 313: INSERT INTO hri_cnfg_jobh_flex_cols

309:
310: END IF;
311:
312: -- Insert the value into the configuration table
313: INSERT INTO hri_cnfg_jobh_flex_cols
314: (flexfield_type
315: ,job_flex_code
316: ,job_fnctn_column
317: ,job_fmly_column)

Line 713: hri_cnfg_jobh_flex_cols

709: SELECT
710: job_fmly_column
711: ,job_fnctn_column
712: FROM
713: hri_cnfg_jobh_flex_cols
714: WHERE flexfield_type = p_flex_type
715: AND job_flex_code = p_flex_code;
716:
717: BEGIN