[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: --
372: l_min_suph_date DATE;
373: --
374: CURSOR c_last_full_suph_col_run IS
375: SELECT period_from
376: FROM bis_refresh_log
377: WHERE object_name = 'HRI_CS_SUPH'
378: AND status='SUCCESS'
379: AND attribute1 = 'Y'
380: AND last_update_date =( SELECT max(last_update_date)
377: WHERE object_name = 'HRI_CS_SUPH'
378: AND status='SUCCESS'
379: AND attribute1 = 'Y'
380: AND last_update_date =( SELECT max(last_update_date)
381: FROM bis_refresh_log
382: WHERE object_name= 'HRI_CS_SUPH'
383: AND status='SUCCESS'
384: AND attribute1 = 'Y')
385: ORDER BY last_update_date DESC;
2929: set_parameters( p_mthd_action_id => p_mthd_action_id,
2930: p_called_from => 'PRE_PROCESS');
2931: --
2932: -- In case the process is running in a Foundation HR environment run
2933: -- the post_process to update the bis_refresh_log table and return without
2934: -- returning any SQL. The mulithreading utility will then not invoke the
2935: -- PROCESS_RANGES and POST_PROCESS calls
2936: --
2937: IF g_mthd_action_array.foundation_hr_flag = 'Y' THEN
2936: --
2937: IF g_mthd_action_array.foundation_hr_flag = 'Y' THEN
2938: --
2939: -- This process is not supported in Shared HR mode, update the
2940: -- bis refresh log table and return. The multithreading utility
2941: -- does not do any processing if no SQL is returned
2942: --
2943: dbg('Foundation HR environment found');
2944: post_process (p_mthd_action_id => p_mthd_action_id);
3007: dbg(p_sqlstr);
3008: --
3009: -- 4357755
3010: -- The central refresh procedure should be initialized so that entries
3011: -- about the process are correctly inserted into the bis refresh log table
3012: -- This information is used to determine the start time of the next process.
3013: --
3014: hri_bpl_conc_log.record_process_start(c_object_name);
3015: --
3116: --
3117: -- ----------------------------------------------------------------------------
3118: -- POST_PROCESS
3119: -- This procedure is dynamically invoked by the HRI Multithreading utility.
3120: -- It finishes the processing by updating the BIS_REFRESH_LOG table
3121: -- ----------------------------------------------------------------------------
3122: --
3123: PROCEDURE post_process (p_mthd_action_id NUMBER) IS
3124: --
3145: check_for_new_snapshot_dates;
3146: END IF;
3147: --
3148: -- 4357755
3149: -- Insert the details of the run in the bis refresh log table. This info is
3150: -- read used to set the start date of next run
3151: --
3152: hri_bpl_conc_log.log_process_end
3153: (