DBA Data[Home] [Help]

APPS.HRI_OPL_CMPTNC_LVL dependencies on HRI_CS_CMPTNC_LVL_CT

Line 83: g_target_table VARCHAR2(30) DEFAULT 'HRI_CS_CMPTNC_LVL_CT';

79: -- @@ in the call to hri_bpl_conc_log.get_last_collect_to_date
80: -- @@ change param1/2 to be the concurrent program short name,
81: -- @@ and the target table name respectively.
82: --
83: g_target_table VARCHAR2(30) DEFAULT 'HRI_CS_CMPTNC_LVL_CT';
84: g_cncrnt_prgrm_shrtnm VARCHAR2(30) DEFAULT 'HRICMPTNCLVL';
85: --
86: -- @@ Code specific to this view/table below ENDS
87: --

Line 138: INSERT INTO hri_cs_cmptnc_lvl_ct

134: -- @@ statement below.
135: -- @@ 2/ Prefix each column in the VALUE clause with g_
136: -- @@ 3/ make sure (i) is at the end of each column in the value clause
137: --
138: INSERT INTO hri_cs_cmptnc_lvl_ct
139: (row_indicator
140: ,no_level_indicator
141: ,scale_level_value
142: ,min_scale_level_value

Line 225: INSERT INTO hri_cs_cmptnc_lvl_ct

221: -- @@ 2/ Prefix each column in the VALUE clause with g_
222: -- @@ 3/ make sure (i) is at the end of each column in the value clause
223: --
224: FORALL i IN 1..p_stored_rows_to_insert
225: INSERT INTO hri_cs_cmptnc_lvl_ct
226: (row_indicator
227: ,no_level_indicator
228: ,scale_level_value
229: ,min_scale_level_value