153: -- CONSTANTS
154: -- =========
155: --
156: -- @@ Code specific to this view/table below
157: -- @@ in the call to hri_bpl_conc_log.get_last_collect_to_date
158: -- @@ change param1/2 to be the concurrent program short name,
159: -- @@ and the target table name respectively.
160: --
161: g_target_table VARCHAR2(30) DEFAULT 'HRI_MB_REC_VACANCY_CT';
895: THEN
896: -- log('Input dates NULL.');
897: --
898: g_start_date := fnd_date.displaydt_to_date(
899: hri_bpl_conc_log.get_last_collect_to_date(
900: g_cncrnt_prgrm_shrtnm
901: ,g_target_table));
902: --
903: g_end_date := SYSDATE;
1044: -- Update information about collection
1045: --
1046: -- log('Record process start.');
1047: /* double check correct val passed in below */
1048: hri_bpl_conc_log.record_process_start(g_cncrnt_prgrm_shrtnm);
1049: --
1050: -- Time at start
1051: --
1052: -- log('collect.');
1073: output('Gathered stats: ' ||
1074: to_char(sysdate,'HH24:MI:SS'));
1075: --
1076: -- log('log end.');
1077: hri_bpl_conc_log.log_process_end(
1078: p_status => TRUE,
1079: p_period_from => TRUNC(g_start_date),
1080: p_period_to => TRUNC(g_end_date),
1081: p_attribute1 => p_full_refresh,
1125: p_process_table_name => 'HRI_MB_REC_VACANCY_CT');
1126: ELSE
1127: l_start_date := fnd_date.date_to_canonical
1128: (fnd_date.displaydt_to_date
1129: (hri_bpl_conc_log.get_last_collect_to_date
1130: ('HRI_MB_REC_VACANCY_CT','HRI_MB_REC_VACANCY_CT')));
1131: END IF;
1132:
1133: load(p_chunk_size => to_number(null),