[Home] [Help]
48: -- BEFORE MULTI-THREADING
49: -- ----------------------
50: -- PRE_PROCESS
51: -- - Shared HR mode
52: -- - Call the bis process to insert a entry in the bis refresh log
53: -- for the process
54: -- - Full Refresh mode / Process Running for the first time
55: -- - Call the bis process to insert a entry in the bis refresh log
56: -- for the process
51: -- - Shared HR mode
52: -- - Call the bis process to insert a entry in the bis refresh log
53: -- for the process
54: -- - Full Refresh mode / Process Running for the first time
55: -- - Call the bis process to insert a entry in the bis refresh log
56: -- for the process
57: -- - When the event queue profiles are not set
58: -- - Call the bis process to insert a entry in the bis refresh log
59: -- for the process
54: -- - Full Refresh mode / Process Running for the first time
55: -- - Call the bis process to insert a entry in the bis refresh log
56: -- for the process
57: -- - When the event queue profiles are not set
58: -- - Call the bis process to insert a entry in the bis refresh log
59: -- for the process
60: -- - Incremental Mode
61: -- - Return the SQL based on which the range will be generated
62: --
64: -- - Evaluate the events for every assignment in the range and
65: -- insert/update the records in the event queue
66: --
67: -- POST_PROCESS
68: -- - Call the bis process to insert a entry in the bis refresh log
69: -- for the process
70: --
71: -- -----------------------------------------------------------------------------
72: --
375: l_min_suph_date DATE;
376: --
377: CURSOR c_last_full_suph_col_run IS
378: SELECT period_from
379: FROM bis_refresh_log
380: WHERE object_name = 'HRI_CS_SUPH'
381: AND status='SUCCESS'
382: AND attribute1 = 'Y'
383: AND last_update_date =( SELECT max(last_update_date)
380: WHERE object_name = 'HRI_CS_SUPH'
381: AND status='SUCCESS'
382: AND attribute1 = 'Y'
383: AND last_update_date =( SELECT max(last_update_date)
384: FROM bis_refresh_log
385: WHERE object_name= 'HRI_CS_SUPH'
386: AND status='SUCCESS'
387: AND attribute1 = 'Y')
388: ORDER BY last_update_date DESC;
2932: set_parameters( p_mthd_action_id => p_mthd_action_id,
2933: p_called_from => 'PRE_PROCESS');
2934: --
2935: -- In case the process is running in a Foundation HR environment run
2936: -- the post_process to update the bis_refresh_log table and return without
2937: -- returning any SQL. The mulithreading utility will then not invoke the
2938: -- PROCESS_RANGES and POST_PROCESS calls
2939: --
2940: IF g_mthd_action_array.foundation_hr_flag = 'Y' THEN
2939: --
2940: IF g_mthd_action_array.foundation_hr_flag = 'Y' THEN
2941: --
2942: -- This process is not supported in Shared HR mode, update the
2943: -- bis refresh log table and return. The multithreading utility
2944: -- does not do any processing if no SQL is returned
2945: --
2946: dbg('Foundation HR environment found');
2947: post_process (p_mthd_action_id => p_mthd_action_id);
3010: dbg(p_sqlstr);
3011: --
3012: -- 4357755
3013: -- The central refresh procedure should be initialized so that entries
3014: -- about the process are correctly inserted into the bis refresh log table
3015: -- This information is used to determine the start time of the next process.
3016: --
3017: hri_bpl_conc_log.record_process_start(c_object_name);
3018: --
3119: --
3120: -- ----------------------------------------------------------------------------
3121: -- POST_PROCESS
3122: -- This procedure is dynamically invoked by the HRI Multithreading utility.
3123: -- It finishes the processing by updating the BIS_REFRESH_LOG table
3124: -- ----------------------------------------------------------------------------
3125: --
3126: PROCEDURE post_process (p_mthd_action_id NUMBER) IS
3127: --
3148: check_for_new_snapshot_dates;
3149: END IF;
3150: --
3151: -- 4357755
3152: -- Insert the details of the run in the bis refresh log table. This info is
3153: -- read used to set the start date of next run
3154: --
3155: hri_bpl_conc_log.log_process_end
3156: (