APPS.HRI_OPL_GEO_LOCHR dependencies on HRI_BPL_CONC_LOG

Line 38: -- @@ in the call to hri_bpl_conc_log.get_last_collect_to_date

34: -- CONSTANTS
35: -- =========
36: --
37: -- @@ Code specific to this view/table below
38: -- @@ in the call to hri_bpl_conc_log.get_last_collect_to_date
39: -- @@ change param1/2 to be the concurrent program short name,
40: -- @@ and the target table name respectively.
41: --
42: -- 115.15 4278978

Line 68: HRI_BPL_CONC_LOG.output(p_text);

64: BEGIN
65: --
66: -- Bug 4105868: Global to store msg_sub_group
67: --
68: HRI_BPL_CONC_LOG.output(p_text);
69: --
70: END output;
71: --
72: -- -------------------------------------------------------------------------

Line 82: HRI_BPL_CONC_LOG.dbg(p_text);

78: BEGIN
79: --
80: -- Bug 4105868: Collection Diagnostics
81: --
82: HRI_BPL_CONC_LOG.dbg(p_text);
83: --
84: END dbg;
85: --
86: -- -----------------------------------------------------------------------------

Line 124: hri_bpl_conc_log.log_process_info

120: output(SUBSTR(p_sql_stmt,1,230));
121: --
122: -- Bug 4105868: Collection Diagnostic Call
123: --
124: hri_bpl_conc_log.log_process_info
125: (p_package_name => 'HRI_OPL_GEO_LOCHR'
126: ,p_msg_type => 'WARNING'
127: ,p_msg_group => 'GEOGRAPHY'
128: ,p_msg_sub_group => 'RUN_SQL_STMT_NOERR'

Line 1050: (hri_bpl_conc_log.get_last_collect_to_date

1046: dbg('Before updating globals Start Date = '
1047: || g_start_date||', End Date = '||g_end_date);
1048: --
1049: g_start_date := fnd_date.displaydt_to_date
1050: (hri_bpl_conc_log.get_last_collect_to_date
1051: (g_cncrnt_prgrm_shrtnm
1052: ,g_target_lochr_table
1053: )
1054: );

Line 1140: hri_bpl_conc_log.record_process_start(g_cncrnt_prgrm_shrtnm);

1136: END IF;
1137: --
1138: -- Update information about collection
1139: --
1140: hri_bpl_conc_log.record_process_start(g_cncrnt_prgrm_shrtnm);
1141: --
1142: collect;
1143: --
1144: dbg_time('Completed table changes');

Line 1163: hri_bpl_conc_log.log_process_end(

1159: /**/
1160: --
1161: -- Bug 4105868: Collection Diagnostic Call
1162: --
1163: hri_bpl_conc_log.log_process_end(
1164: p_status => TRUE,
1165: p_period_from => TRUNC(g_start_date),
1166: p_period_to => TRUNC(g_end_date),
1167: p_attribute1 => p_full_refresh,

Line 1188: hri_bpl_conc_log.log_process_info

1184: -- Bug 4105868: Collection Diagnostic Call
1185: --
1186: g_msg_sub_group := nvl(g_msg_sub_group, 'LOAD');
1187: --
1188: hri_bpl_conc_log.log_process_info
1189: (p_package_name => 'HRI_OPL_GEO_LOCHR'
1190: ,p_msg_type => 'ERROR'
1191: ,p_msg_group => 'GEOGRAPHY'
1192: ,p_msg_sub_group => g_msg_sub_group

Line 1199: hri_bpl_conc_log.log_process_end

1195: --
1196: -- Insert Program failure details into the log tables
1197: -- Bug 4105868: Collection Diagnostic Call
1198: --
1199: hri_bpl_conc_log.log_process_end
1200: (p_status => FALSE
1201: ,p_period_from => TRUNC(g_start_date)
1202: ,p_period_to => TRUNC(g_end_date)
1203: ,p_attribute1 => p_full_refresh

Line 1262: (hri_bpl_conc_log.get_last_collect_to_date

1258: ELSE
1259: -- Bug 4704157 - converted displaydt to canonical
1260: l_start_date := fnd_date.date_to_canonical
1261: (fnd_date.displaydt_to_date
1262: (hri_bpl_conc_log.get_last_collect_to_date
1263: ('HRI_OPL_GEO_LOCHR','HRI_CS_GEO_LOCHR_CT')));
1264: END IF;
1265:
1266: hri_bpl_conc_log.dbg('Full refresh: ' || l_full_refresh);

Line 1266: hri_bpl_conc_log.dbg('Full refresh: ' || l_full_refresh);

1262: (hri_bpl_conc_log.get_last_collect_to_date
1263: ('HRI_OPL_GEO_LOCHR','HRI_CS_GEO_LOCHR_CT')));
1264: END IF;
1265:
1266: hri_bpl_conc_log.dbg('Full refresh: ' || l_full_refresh);
1267: hri_bpl_conc_log.dbg('Collect from: ' || l_start_date);
1268:
1269: --
1270: load(p_chunk_size => 1500

Line 1267: hri_bpl_conc_log.dbg('Collect from: ' || l_start_date);

1263: ('HRI_OPL_GEO_LOCHR','HRI_CS_GEO_LOCHR_CT')));
1264: END IF;
1265:
1266: hri_bpl_conc_log.dbg('Full refresh: ' || l_full_refresh);
1267: hri_bpl_conc_log.dbg('Collect from: ' || l_start_date);
1268:
1269: --
1270: load(p_chunk_size => 1500
1271: ,p_start_date => l_start_date