DBA Data[Home] [Help]

APPS.HRI_OPL_CMPTNC_RQRMNT dependencies on HRI_MB_CMPTNC_RQRMNT_CT

Line 84: g_target_table VARCHAR2(30) DEFAULT 'HRI_MB_CMPTNC_RQRMNT_CT';

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

Line 139: INSERT INTO hri_mb_cmptnc_rqrmnt_ct

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

Line 226: INSERT INTO hri_mb_cmptnc_rqrmnt_ct

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