eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_INTERPRETER_PKG dependencies on HR_UTILITY

Line 6: g_traces BOOLEAN := hr_utility.debug_enabled; --See if hr_utility.traces should be output

2: /* $Header: pyinterp.pkb 120.29.12010000.4 2008/10/03 06:56:30 salogana ship $ */
3: --
4: -- Global Utils
5: g_pkg VARCHAR2(30) := 'pay_interpreter_pkg';
6: g_traces BOOLEAN := hr_utility.debug_enabled; --See if hr_utility.traces should be output
7: g_dbg BOOLEAN := FALSE; --Used for diagnosing issues by dev, more outputs
8:
9: -- Global caches
10: g_business_group_id NUMBER; -- business_group_id cache

Line 185: hr_utility.trace('Dates are ' || TO_CHAR(p_start_date) || ' ' || TO_CHAR(p_end_date));

181: p_end_date := ctp.end_date ;
182: END LOOP; --}
183: --
184: if (g_traces) then
185: hr_utility.trace('Dates are ' || TO_CHAR(p_start_date) || ' ' || TO_CHAR(p_end_date));
186: end if;
187: -- Selects the Proration Type
188: FOR ceg IN c_event_group
189: LOOP

Line 195: hr_utility.trace('Proration Type is ' || l_proration_type);

191: l_time_def_id := ceg.time_definition_id;
192: END LOOP;
193:
194: if (g_traces) then
195: hr_utility.trace('Proration Type is ' || l_proration_type);
196: end if;
197: -- Selects the Legislation Code.
198: FOR clc IN c_legislation_code
199: LOOP

Line 205: hr_utility.trace('Legislation Code ' || l_legislation_code );

201: p_business_group_id := clc.business_group_id;
202: END LOOP;
203: --
204: if (g_traces) then
205: hr_utility.trace('Legislation Code ' || l_legislation_code );
206: hr_utility.trace('Business Group Id ' || p_business_group_id);
207: end if;
208:
209: -- The following code converts the start date to the appropriate date

Line 206: hr_utility.trace('Business Group Id ' || p_business_group_id);

202: END LOOP;
203: --
204: if (g_traces) then
205: hr_utility.trace('Legislation Code ' || l_legislation_code );
206: hr_utility.trace('Business Group Id ' || p_business_group_id);
207: end if;
208:
209: -- The following code converts the start date to the appropriate date
210: -- depending upon the Proration Type

Line 230: hr_utility.trace('Legislation Code is ' || l_legislation_code);

226: ELSIF (l_proration_type = 'F') THEN -- F = Financial Year
227: l_year := TO_CHAR(p_end_date, 'YYYY');
228: --
229: if (g_traces) then
230: hr_utility.trace('Legislation Code is ' || l_legislation_code);
231: end if;
232: --
233: FOR cfy IN c_financial_year(l_legislation_code)
234: LOOP

Line 239: hr_utility.trace('p_start_date ' || TO_CHAR(p_start_date));

235: p_start_date := cfy.start_date;
236: END LOOP;
237: --
238: if (g_traces) then
239: hr_utility.trace('p_start_date ' || TO_CHAR(p_start_date));
240: end if;
241: --
242: IF (p_end_date < p_start_date) THEN
243: p_start_date := TO_DATE(TO_CHAR(p_start_date, 'DD/MM/') ||

Line 377: hr_utility.trace('Dates are ' || TO_CHAR(p_start_date) || ' ' || TO_CHAR(p_end_date));

373: by 1. For end date this criterion is not true.
374: ***/
375: --
376: if (g_traces) then
377: hr_utility.trace('Dates are ' || TO_CHAR(p_start_date) || ' ' || TO_CHAR(p_end_date));
378: end if;
379: --
380: END time_period;
381:

Line 447: hr_utility.trace('Unique Sort : Date = '||p_proration_dates_temp(l_sort_i));

443: BEGIN
444: l_table_count := p_proration_dates_temp.COUNT;
445: /*
446: FOR l_sort_i IN 1..l_table_count LOOP
447: hr_utility.trace('Unique Sort : Date = '||p_proration_dates_temp(l_sort_i));
448: hr_utility.trace(' Style = '||p_proration_type_temp(l_sort_i));
449: END LOOP;
450: */
451:

Line 448: hr_utility.trace(' Style = '||p_proration_type_temp(l_sort_i));

444: l_table_count := p_proration_dates_temp.COUNT;
445: /*
446: FOR l_sort_i IN 1..l_table_count LOOP
447: hr_utility.trace('Unique Sort : Date = '||p_proration_dates_temp(l_sort_i));
448: hr_utility.trace(' Style = '||p_proration_type_temp(l_sort_i));
449: END LOOP;
450: */
451:
452: FOR l_sort_i IN 1..l_table_count

Line 476: --hr_utility.trace('Sorting finished');

472: p_proration_type_temp(l_var) := p_proration_type_temp(l_sort_i);
473: p_proration_type_temp(l_sort_i) := l_temp_pro_type;
474: END LOOP;
475:
476: --hr_utility.trace('Sorting finished');
477:
478: IF (l_table_count >= 1) THEN
479: l_temp_date := p_proration_dates_temp(1);
480: p_proration_dates(1) := p_proration_dates_temp(1);

Line 489: --hr_utility.trace('Finding Unique Dates');

485: END IF;
486:
487: l_counter := 1;
488:
489: --hr_utility.trace('Finding Unique Dates');
490:
491: FOR l_unique IN 1..l_table_count
492: LOOP
493: --hr_utility.trace('Date = '||p_proration_dates_temp(l_unique));

Line 493: --hr_utility.trace('Date = '||p_proration_dates_temp(l_unique));

489: --hr_utility.trace('Finding Unique Dates');
490:
491: FOR l_unique IN 1..l_table_count
492: LOOP
493: --hr_utility.trace('Date = '||p_proration_dates_temp(l_unique));
494: --hr_utility.trace('Style = '||p_proration_type_temp(l_unique));
495: /* Proration Uniqueness is different to others */
496: if (p_internal_mode = 'PRORATION') then
497: IF (l_temp_date <> p_proration_dates_temp(l_unique)) then

Line 494: --hr_utility.trace('Style = '||p_proration_type_temp(l_unique));

490:
491: FOR l_unique IN 1..l_table_count
492: LOOP
493: --hr_utility.trace('Date = '||p_proration_dates_temp(l_unique));
494: --hr_utility.trace('Style = '||p_proration_type_temp(l_unique));
495: /* Proration Uniqueness is different to others */
496: if (p_internal_mode = 'PRORATION') then
497: IF (l_temp_date <> p_proration_dates_temp(l_unique)) then
498: l_counter := l_counter + 1 ;

Line 583: hr_utility.trace('Date Earned ' || TO_CHAR(l_date_earned,'DD-MON-YYYY'));

579: p_start_date => p_start_date ,
580: p_end_date => p_end_date );
581:
582: if (g_traces) then
583: hr_utility.trace('Date Earned ' || TO_CHAR(l_date_earned,'DD-MON-YYYY'));
584: end if;
585:
586: END;
587:

Line 635: hr_utility.trace('Miss in Cache');

631: t_proration_group_tab(p_event_group_id).range_start := 0;
632: t_proration_group_tab(p_event_group_id).range_end := 0 ;
633:
634: if (g_traces) then
635: hr_utility.trace('Miss in Cache');
636: end if;
637: FOR cdt IN c_distinct_table(p_event_group_id)
638: LOOP
639: if (g_dbg) then

Line 640: hr_utility.trace('Store Event in Cache: '||l_tab_counter);

636: end if;
637: FOR cdt IN c_distinct_table(p_event_group_id)
638: LOOP
639: if (g_dbg) then
640: hr_utility.trace('Store Event in Cache: '||l_tab_counter);
641: end if;
642: p_distinct_tab(l_tab_counter).table_id := cdt.table_id ;
643: p_distinct_tab(l_tab_counter).table_name := cdt.table_name ;
644: p_distinct_tab(l_tab_counter).owner := cdt.owner ;

Line 820: hr_utility.trace('-Dynamic SQL: ' || p_statement);

816: ' AND :col1 BETWEEN ' ||
817: p_start_date_name || ' AND ' ||
818: p_end_date_name;
819: if (g_dbg) then
820: hr_utility.trace('-Dynamic SQL: ' || p_statement);
821: end if;
822:
823: END;
824:

Line 851: hr_utility.trace(p_statement);

847:
848: -- The following code creates the dynamic SQL for the column names selected
849: -- above.
850: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
851: hr_utility.trace(p_statement);
852: DBMS_SQL.PARSE(l_cursor_id , p_statement , DBMS_SQL.V7);
853: --
854: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_surrogate_key', p_surrogate_key);
855: IF (p_updated_column_name = p_start_date_name) THEN

Line 858: hr_utility.trace('Effective Start Date changed');

854: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_surrogate_key', p_surrogate_key);
855: IF (p_updated_column_name = p_start_date_name) THEN
856: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':col1', p_effective_date - 1);
857: if (g_dbg) then
858: hr_utility.trace('Effective Start Date changed');
859: hr_utility.trace('date = '||(p_effective_date - 1));
860: hr_utility.trace('key = '||p_surrogate_key);
861: end if;
862: ELSIF (p_updated_column_name = p_end_date_name) THEN

Line 859: hr_utility.trace('date = '||(p_effective_date - 1));

855: IF (p_updated_column_name = p_start_date_name) THEN
856: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':col1', p_effective_date - 1);
857: if (g_dbg) then
858: hr_utility.trace('Effective Start Date changed');
859: hr_utility.trace('date = '||(p_effective_date - 1));
860: hr_utility.trace('key = '||p_surrogate_key);
861: end if;
862: ELSIF (p_updated_column_name = p_end_date_name) THEN
863: --

Line 860: hr_utility.trace('key = '||p_surrogate_key);

856: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':col1', p_effective_date - 1);
857: if (g_dbg) then
858: hr_utility.trace('Effective Start Date changed');
859: hr_utility.trace('date = '||(p_effective_date - 1));
860: hr_utility.trace('key = '||p_surrogate_key);
861: end if;
862: ELSIF (p_updated_column_name = p_end_date_name) THEN
863: --
864: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':col1', p_effective_date);

Line 866: hr_utility.trace('date = '||p_effective_date);

862: ELSIF (p_updated_column_name = p_end_date_name) THEN
863: --
864: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':col1', p_effective_date);
865: if (g_dbg) then
866: hr_utility.trace('date = '||p_effective_date);
867: hr_utility.trace('key = '||p_surrogate_key);
868: end if;
869: --
870: END IF;

Line 867: hr_utility.trace('key = '||p_surrogate_key);

863: --
864: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':col1', p_effective_date);
865: if (g_dbg) then
866: hr_utility.trace('date = '||p_effective_date);
867: hr_utility.trace('key = '||p_surrogate_key);
868: end if;
869: --
870: END IF;
871:

Line 902: hr_utility.trace('Effective Start Date changed');

898: IF (p_updated_column_name = p_start_date_name) THEN
899: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':col1', p_effective_date);
900: p_final_effective_date := p_effective_date;
901: if (g_dbg) then
902: hr_utility.trace('Effective Start Date changed');
903: hr_utility.trace('date = '||p_effective_date);
904: hr_utility.trace('key = '||p_surrogate_key);
905: end if;
906: ELSIF (p_updated_column_name = p_end_date_name) THEN

Line 903: hr_utility.trace('date = '||p_effective_date);

899: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':col1', p_effective_date);
900: p_final_effective_date := p_effective_date;
901: if (g_dbg) then
902: hr_utility.trace('Effective Start Date changed');
903: hr_utility.trace('date = '||p_effective_date);
904: hr_utility.trace('key = '||p_surrogate_key);
905: end if;
906: ELSIF (p_updated_column_name = p_end_date_name) THEN
907: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':col1', p_effective_date + 1);

Line 904: hr_utility.trace('key = '||p_surrogate_key);

900: p_final_effective_date := p_effective_date;
901: if (g_dbg) then
902: hr_utility.trace('Effective Start Date changed');
903: hr_utility.trace('date = '||p_effective_date);
904: hr_utility.trace('key = '||p_surrogate_key);
905: end if;
906: ELSIF (p_updated_column_name = p_end_date_name) THEN
907: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':col1', p_effective_date + 1);
908: p_final_effective_date := p_effective_date + 1;

Line 910: hr_utility.trace('Effective End Date changed');

906: ELSIF (p_updated_column_name = p_end_date_name) THEN
907: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':col1', p_effective_date + 1);
908: p_final_effective_date := p_effective_date + 1;
909: if (g_dbg) then
910: hr_utility.trace('Effective End Date changed');
911: hr_utility.trace('date = '||(p_effective_date + 1));
912: hr_utility.trace('key = '||p_surrogate_key);
913: end if;
914: END IF;

Line 911: hr_utility.trace('date = '||(p_effective_date + 1));

907: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':col1', p_effective_date + 1);
908: p_final_effective_date := p_effective_date + 1;
909: if (g_dbg) then
910: hr_utility.trace('Effective End Date changed');
911: hr_utility.trace('date = '||(p_effective_date + 1));
912: hr_utility.trace('key = '||p_surrogate_key);
913: end if;
914: END IF;
915:

Line 912: hr_utility.trace('key = '||p_surrogate_key);

908: p_final_effective_date := p_effective_date + 1;
909: if (g_dbg) then
910: hr_utility.trace('Effective End Date changed');
911: hr_utility.trace('date = '||(p_effective_date + 1));
912: hr_utility.trace('key = '||p_surrogate_key);
913: end if;
914: END IF;
915:
916: -- The following loop executes for all the columns

Line 926: hr_utility.trace('Second statement executed ');

922: END LOOP;
923: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
924:
925: if (g_dbg) then
926: hr_utility.trace('Second statement executed ');
927: end if;
928:
929: LOOP
930:

Line 944: hr_utility.trace('old = '||t_dynamic_sql(l_counter).old_value||' new = '||t_dynamic_sql(l_counter).new_value);

940: LOOP
941: l_new_sql_fetch := 1;
942: DBMS_SQL.COLUMN_VALUE(l_cursor_id, l_counter,t_dynamic_sql(l_counter).new_value);
943: if (g_traces) then
944: hr_utility.trace('old = '||t_dynamic_sql(l_counter).old_value||' new = '||t_dynamic_sql(l_counter).new_value);
945: end if;
946:
947: END LOOP;
948: END LOOP;

Line 1159: hr_utility.trace('Procedure Name ' || l_proc_name);

1155: l_proc_name := glo_event_procedures(evt_idx).procedure_name;
1156: -- Execute Procedure name
1157:
1158: if (g_traces) then
1159: hr_utility.trace('Procedure Name ' || l_proc_name);
1160: end if;
1161:
1162: l_proc_string := 'BEGIN ' || l_proc_name || '(' ||
1163: 'p_surrogate_key => :col1,' ||

Line 1176: hr_utility.trace('Parameters');

1172:
1173: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
1174:
1175: if (g_dbg) then
1176: hr_utility.trace('Parameters');
1177: hr_utility.trace('p_surrogate_key = '||p_surrogate_key);
1178: hr_utility.trace('p_element_entry_id = '||p_element_entry_id);
1179: hr_utility.trace('p_assignment_action_id = '||p_assignment_action_id);
1180: hr_utility.trace('p_column_name = '||p_column_name);

Line 1177: hr_utility.trace('p_surrogate_key = '||p_surrogate_key);

1173: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
1174:
1175: if (g_dbg) then
1176: hr_utility.trace('Parameters');
1177: hr_utility.trace('p_surrogate_key = '||p_surrogate_key);
1178: hr_utility.trace('p_element_entry_id = '||p_element_entry_id);
1179: hr_utility.trace('p_assignment_action_id = '||p_assignment_action_id);
1180: hr_utility.trace('p_column_name = '||p_column_name);
1181: hr_utility.trace('p_old_value = '||p_old_value);

Line 1178: hr_utility.trace('p_element_entry_id = '||p_element_entry_id);

1174:
1175: if (g_dbg) then
1176: hr_utility.trace('Parameters');
1177: hr_utility.trace('p_surrogate_key = '||p_surrogate_key);
1178: hr_utility.trace('p_element_entry_id = '||p_element_entry_id);
1179: hr_utility.trace('p_assignment_action_id = '||p_assignment_action_id);
1180: hr_utility.trace('p_column_name = '||p_column_name);
1181: hr_utility.trace('p_old_value = '||p_old_value);
1182: hr_utility.trace('p_new_value = '||p_new_value);

Line 1179: hr_utility.trace('p_assignment_action_id = '||p_assignment_action_id);

1175: if (g_dbg) then
1176: hr_utility.trace('Parameters');
1177: hr_utility.trace('p_surrogate_key = '||p_surrogate_key);
1178: hr_utility.trace('p_element_entry_id = '||p_element_entry_id);
1179: hr_utility.trace('p_assignment_action_id = '||p_assignment_action_id);
1180: hr_utility.trace('p_column_name = '||p_column_name);
1181: hr_utility.trace('p_old_value = '||p_old_value);
1182: hr_utility.trace('p_new_value = '||p_new_value);
1183: end if;

Line 1180: hr_utility.trace('p_column_name = '||p_column_name);

1176: hr_utility.trace('Parameters');
1177: hr_utility.trace('p_surrogate_key = '||p_surrogate_key);
1178: hr_utility.trace('p_element_entry_id = '||p_element_entry_id);
1179: hr_utility.trace('p_assignment_action_id = '||p_assignment_action_id);
1180: hr_utility.trace('p_column_name = '||p_column_name);
1181: hr_utility.trace('p_old_value = '||p_old_value);
1182: hr_utility.trace('p_new_value = '||p_new_value);
1183: end if;
1184: DBMS_SQL.PARSE(l_cursor_id, l_proc_string, DBMS_SQL.V7);

Line 1181: hr_utility.trace('p_old_value = '||p_old_value);

1177: hr_utility.trace('p_surrogate_key = '||p_surrogate_key);
1178: hr_utility.trace('p_element_entry_id = '||p_element_entry_id);
1179: hr_utility.trace('p_assignment_action_id = '||p_assignment_action_id);
1180: hr_utility.trace('p_column_name = '||p_column_name);
1181: hr_utility.trace('p_old_value = '||p_old_value);
1182: hr_utility.trace('p_new_value = '||p_new_value);
1183: end if;
1184: DBMS_SQL.PARSE(l_cursor_id, l_proc_string, DBMS_SQL.V7);
1185:

Line 1182: hr_utility.trace('p_new_value = '||p_new_value);

1178: hr_utility.trace('p_element_entry_id = '||p_element_entry_id);
1179: hr_utility.trace('p_assignment_action_id = '||p_assignment_action_id);
1180: hr_utility.trace('p_column_name = '||p_column_name);
1181: hr_utility.trace('p_old_value = '||p_old_value);
1182: hr_utility.trace('p_new_value = '||p_new_value);
1183: end if;
1184: DBMS_SQL.PARSE(l_cursor_id, l_proc_string, DBMS_SQL.V7);
1185:
1186: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col1',p_surrogate_key);

Line 1196: hr_utility.trace('All Variables Bound');

1192: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col6', p_new_value);
1193: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col7', p_output_result, 40);
1194: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':col8', p_final_effective_date);
1195: if (g_dbg) then
1196: hr_utility.trace('All Variables Bound');
1197: end if;
1198:
1199: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
1200:

Line 1202: hr_utility.trace('Procedure Executed');

1198:
1199: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
1200:
1201: if (g_dbg) then
1202: hr_utility.trace('Procedure Executed');
1203: end if;
1204:
1205: DBMS_SQL.VARIABLE_VALUE(l_cursor_id, ':col7', p_output_result);
1206: --hr_utility.trace('Got Results');

Line 1206: --hr_utility.trace('Got Results');

1202: hr_utility.trace('Procedure Executed');
1203: end if;
1204:
1205: DBMS_SQL.VARIABLE_VALUE(l_cursor_id, ':col7', p_output_result);
1206: --hr_utility.trace('Got Results');
1207:
1208: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
1209:
1210: --hr_utility.trace('Closed cursor');

Line 1210: --hr_utility.trace('Closed cursor');

1206: --hr_utility.trace('Got Results');
1207:
1208: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
1209:
1210: --hr_utility.trace('Closed cursor');
1211:
1212: IF (p_output_result = 'FALSE') THEN
1213: -- False means no proration event occured
1214: hr_utility.trace('Not a valid event');

Line 1214: hr_utility.trace('Not a valid event');

1210: --hr_utility.trace('Closed cursor');
1211:
1212: IF (p_output_result = 'FALSE') THEN
1213: -- False means no proration event occured
1214: hr_utility.trace('Not a valid event');
1215: EXIT;
1216: END IF;
1217: END LOOP;
1218: end if;

Line 1293: hr_utility.trace('>> FOUND EVENT: '||p_datetracked_event||', desc '||t_detailed_output(p_date_counter).change_values);

1289: end if;
1290:
1291:
1292: if (g_traces) then
1293: hr_utility.trace('>> FOUND EVENT: '||p_datetracked_event||', desc '||t_detailed_output(p_date_counter).change_values);
1294: end if;
1295:
1296: p_date_counter := p_date_counter + 1;
1297: if (g_dbg) then

Line 1298: hr_utility.trace(' For base record :' || p_surrogate_key );

1294: end if;
1295:
1296: p_date_counter := p_date_counter + 1;
1297: if (g_dbg) then
1298: hr_utility.trace(' For base record :' || p_surrogate_key );
1299: hr_utility.trace(' On Table :' || p_dated_table_id );
1300: hr_utility.trace(' Event Type :' || p_update_type );
1301: hr_utility.trace('>> adding at pos p_date_counter: '||p_date_counter);
1302: end if;

Line 1299: hr_utility.trace(' On Table :' || p_dated_table_id );

1295:
1296: p_date_counter := p_date_counter + 1;
1297: if (g_dbg) then
1298: hr_utility.trace(' For base record :' || p_surrogate_key );
1299: hr_utility.trace(' On Table :' || p_dated_table_id );
1300: hr_utility.trace(' Event Type :' || p_update_type );
1301: hr_utility.trace('>> adding at pos p_date_counter: '||p_date_counter);
1302: end if;
1303:

Line 1300: hr_utility.trace(' Event Type :' || p_update_type );

1296: p_date_counter := p_date_counter + 1;
1297: if (g_dbg) then
1298: hr_utility.trace(' For base record :' || p_surrogate_key );
1299: hr_utility.trace(' On Table :' || p_dated_table_id );
1300: hr_utility.trace(' Event Type :' || p_update_type );
1301: hr_utility.trace('>> adding at pos p_date_counter: '||p_date_counter);
1302: end if;
1303:
1304: END add_found_event;

Line 1301: hr_utility.trace('>> adding at pos p_date_counter: '||p_date_counter);

1297: if (g_dbg) then
1298: hr_utility.trace(' For base record :' || p_surrogate_key );
1299: hr_utility.trace(' On Table :' || p_dated_table_id );
1300: hr_utility.trace(' Event Type :' || p_update_type );
1301: hr_utility.trace('>> adding at pos p_date_counter: '||p_date_counter);
1302: end if;
1303:
1304: END add_found_event;
1305:

Line 1567: hr_utility.trace('Value of the column has changed');

1563: IF (NVL(t_dynamic_sql(l_counter).old_value,'-9999') <>
1564: NVL(t_dynamic_sql(l_counter).new_value,'-9999'))
1565: THEN
1566: if (g_dbg) then
1567: hr_utility.trace('Value of the column has changed');
1568: end if;
1569: --
1570: -- We could be saving the results in one for 2 modes.
1571: -- First mode is that the events are being generated for a

Line 1672: hr_utility.trace(' >= Found a valid event, valid for our ee, now check qualifiers');

1668:
1669: --
1670: if (process_event = TRUE) then
1671: --
1672: hr_utility.trace(' >= Found a valid event, valid for our ee, now check qualifiers');
1673: perform_qualifications
1674: (
1675: p_table_id => p_table_id,
1676: p_final_effective_date => p_final_effective_date,

Line 1798: hr_utility.trace('-Dynamic SQL ' || l_statement);

1794: || p_table_name || ' where ' ||
1795: p_surrogate_key_name ||' = :p_surrogate_key '||
1796: ' and ' || p_end_date_name ||' > :col1)';
1797: if (g_traces) then
1798: hr_utility.trace('-Dynamic SQL ' || l_statement);
1799: end if;
1800:
1801: execute immediate l_statement into l_result using p_surrogate_key, p_effective_date;
1802: return;

Line 1969: hr_utility.trace('Procedure Name ' || g_tim_def_prc_name);

1965: l_proc_string VARCHAR2(400);
1966: begin
1967:
1968: if (g_traces) then
1969: hr_utility.trace('Procedure Name ' || g_tim_def_prc_name);
1970: end if;
1971:
1972: l_proc_string := 'BEGIN :res := ' || g_tim_def_prc_name || '(' ||
1973: 'p_assignment_action_id => :aa' ||

Line 1979: hr_utility.trace('Parameters');

1975:
1976: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
1977:
1978: if (g_dbg) then
1979: hr_utility.trace('Parameters');
1980: end if;
1981:
1982: DBMS_SQL.PARSE(l_cursor_id, l_proc_string, DBMS_SQL.V7);
1983:

Line 1988: hr_utility.trace('All Variables Bound');

1984: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':res', l_res);
1985: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':aa',p_assignment_action_id);
1986:
1987: if (g_dbg) then
1988: hr_utility.trace('All Variables Bound');
1989: end if;
1990:
1991: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
1992:

Line 1994: hr_utility.trace('Procedure Executed');

1990:
1991: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
1992:
1993: if (g_dbg) then
1994: hr_utility.trace('Procedure Executed');
1995: end if;
1996:
1997: DBMS_SQL.VARIABLE_VALUE(l_cursor_id, ':res', l_res);
1998: --

Line 2055: hr_utility.trace('td id '|| p_time_definition_id );

2051: l_ee_max_date
2052: from pay_element_entries_f
2053: where element_entry_id = p_element_entry_id;
2054: --
2055: hr_utility.trace('td id '|| p_time_definition_id );
2056: hr_utility.trace('asg act id '|| p_assignment_action_id );
2057: l_date_counter := t_proration_dates_temp.count + 1;
2058: --
2059: for datrec in find_start_dates(p_assignment_action_id,

Line 2056: hr_utility.trace('asg act id '|| p_assignment_action_id );

2052: from pay_element_entries_f
2053: where element_entry_id = p_element_entry_id;
2054: --
2055: hr_utility.trace('td id '|| p_time_definition_id );
2056: hr_utility.trace('asg act id '|| p_assignment_action_id );
2057: l_date_counter := t_proration_dates_temp.count + 1;
2058: --
2059: for datrec in find_start_dates(p_assignment_action_id,
2060: p_time_definition_id) loop

Line 2062: hr_utility.trace('Allocation Date '||datrec.start_date);

2058: --
2059: for datrec in find_start_dates(p_assignment_action_id,
2060: p_time_definition_id) loop
2061: --
2062: hr_utility.trace('Allocation Date '||datrec.start_date);
2063: --
2064: if (datrec.start_date > l_ee_min_date
2065: and datrec.start_date <= l_ee_max_date) then
2066: --

Line 2550: hr_utility.trace(' +Compare value change details...');

2546: )
2547: is
2548: begin
2549: if (g_traces) then
2550: hr_utility.trace(' +Compare value change details...');
2551: hr_utility.trace(' |Compare '||nvl(p_old_value, ''));
2552: hr_utility.trace(' | with '||nvl(p_from_value, ''));
2553: hr_utility.trace(' |Compare '||nvl(p_new_value, ''));
2554: hr_utility.trace(' | with '||nvl(p_to_value, ''));

Line 2551: hr_utility.trace(' |Compare '||nvl(p_old_value, ''));

2547: is
2548: begin
2549: if (g_traces) then
2550: hr_utility.trace(' +Compare value change details...');
2551: hr_utility.trace(' |Compare '||nvl(p_old_value, ''));
2552: hr_utility.trace(' | with '||nvl(p_from_value, ''));
2553: hr_utility.trace(' |Compare '||nvl(p_new_value, ''));
2554: hr_utility.trace(' | with '||nvl(p_to_value, ''));
2555: end if;

Line 2552: hr_utility.trace(' | with '||nvl(p_from_value, ''));

2548: begin
2549: if (g_traces) then
2550: hr_utility.trace(' +Compare value change details...');
2551: hr_utility.trace(' |Compare '||nvl(p_old_value, ''));
2552: hr_utility.trace(' | with '||nvl(p_from_value, ''));
2553: hr_utility.trace(' |Compare '||nvl(p_new_value, ''));
2554: hr_utility.trace(' | with '||nvl(p_to_value, ''));
2555: end if;
2556:

Line 2553: hr_utility.trace(' |Compare '||nvl(p_new_value, ''));

2549: if (g_traces) then
2550: hr_utility.trace(' +Compare value change details...');
2551: hr_utility.trace(' |Compare '||nvl(p_old_value, ''));
2552: hr_utility.trace(' | with '||nvl(p_from_value, ''));
2553: hr_utility.trace(' |Compare '||nvl(p_new_value, ''));
2554: hr_utility.trace(' | with '||nvl(p_to_value, ''));
2555: end if;
2556:
2557: -- Bug 2681385

Line 2554: hr_utility.trace(' | with '||nvl(p_to_value, ''));

2550: hr_utility.trace(' +Compare value change details...');
2551: hr_utility.trace(' |Compare '||nvl(p_old_value, ''));
2552: hr_utility.trace(' | with '||nvl(p_from_value, ''));
2553: hr_utility.trace(' |Compare '||nvl(p_new_value, ''));
2554: hr_utility.trace(' | with '||nvl(p_to_value, ''));
2555: end if;
2556:
2557: -- Bug 2681385
2558: -- Dont do further comparisons if old and new are the same

Line 2561: hr_utility.trace(' + Does NOT pass comparison');

2557: -- Bug 2681385
2558: -- Dont do further comparisons if old and new are the same
2559: IF p_old_value = p_new_value Then
2560: if (g_traces) then
2561: hr_utility.trace(' + Does NOT pass comparison');
2562: end if;
2563: p_qualifier_valid := FALSE ;
2564: ELSE
2565:

Line 2576: hr_utility.trace('NULL path');

2572: and p_from_value = ''
2573: and nvl(p_old_value, '') = nvl(p_new_value, '')
2574: ) then
2575: if (g_traces) then
2576: hr_utility.trace('NULL path');
2577: end if;
2578: null;
2579: else
2580: if (p_valid_event = 'Y') then

Line 2582: hr_utility.trace(' + PASS comparison, event is thus TRUE');

2578: null;
2579: else
2580: if (p_valid_event = 'Y') then
2581: if (g_traces) then
2582: hr_utility.trace(' + PASS comparison, event is thus TRUE');
2583: end if;
2584: p_qualifier_valid := TRUE ;
2585: if p_qual_pro_type <> 'R' then
2586: p_qual_pro_type := p_prorate_type;

Line 2590: hr_utility.trace(' + PASS comparison, event is thus FALSE');

2586: p_qual_pro_type := p_prorate_type;
2587: end if ;
2588: else
2589: if (g_traces) then
2590: hr_utility.trace(' + PASS comparison, event is thus FALSE');
2591: end if;
2592: p_qualifier_valid := TRUE ; -- fixed in 3939168
2593: end if ;
2594: end if;

Line 2597: hr_utility.trace(' + FAILED comparison');

2593: end if ;
2594: end if;
2595: else
2596: if (g_traces) then
2597: hr_utility.trace(' + FAILED comparison');
2598: end if;
2599: end if ;
2600:
2601: END IF;

Line 2643: hr_utility.trace('++Testing value_change qualifier value.');

2639: end if;
2640: --
2641: -- Perform the qualifications
2642: if (g_dbg) then
2643: hr_utility.trace('++Testing value_change qualifier value.');
2644: hr_utility.trace(' +Qualifier cursor = evc qual value ? '||l_qual_value||' = '||p_qualifying_value);
2645: end if;
2646: if l_qual_value = p_qualifying_value then
2647: p_qualified := TRUE;

Line 2644: hr_utility.trace(' +Qualifier cursor = evc qual value ? '||l_qual_value||' = '||p_qualifying_value);

2640: --
2641: -- Perform the qualifications
2642: if (g_dbg) then
2643: hr_utility.trace('++Testing value_change qualifier value.');
2644: hr_utility.trace(' +Qualifier cursor = evc qual value ? '||l_qual_value||' = '||p_qualifying_value);
2645: end if;
2646: if l_qual_value = p_qualifying_value then
2647: p_qualified := TRUE;
2648: if p_comparison_column is not null then

Line 2969: hr_utility.trace('Default valid entry '||default_val_event);

2965: l_asg_ee_valid);
2966: end if;
2967: --
2968: if (g_dbg) then
2969: hr_utility.trace('Default valid entry '||default_val_event);
2970: hr_utility.trace('Default proration type '||default_pro_type);
2971: end if;
2972: --
2973: -- Only process if the event is valid for the assignment

Line 2970: hr_utility.trace('Default proration type '||default_pro_type);

2966: end if;
2967: --
2968: if (g_dbg) then
2969: hr_utility.trace('Default valid entry '||default_val_event);
2970: hr_utility.trace('Default proration type '||default_pro_type);
2971: end if;
2972: --
2973: -- Only process if the event is valid for the assignment
2974: if (l_asg_ee_valid) then

Line 3051: hr_utility.trace(' >= Generic data validation, Event qualification Result: '||p_valid);

3047: p_valid := 'N';
3048: end if;
3049: --
3050:
3051: hr_utility.trace(' >= Generic data validation, Event qualification Result: '||p_valid);
3052: end;
3053: --
3054: function get_object_key return varchar2
3055: is

Line 3298: hr_utility.trace('Candidate has passed tests, final test as in ee list mode');

3294: );
3295: else
3296: --
3297: if (g_dbg) then
3298: hr_utility.trace('Candidate has passed tests, final test as in ee list mode');
3299: end if;
3300: if (glo_datetrack_ee_hash_tab.exists(p_datetracked_event)) then
3301: --
3302: curr_ptr := glo_datetrack_ee_hash_tab(p_datetracked_event);

Line 3624: hr_utility.set_location(l_proc, 900);

3620: --
3621: end if;
3622: --
3623: if (g_dbg) then
3624: hr_utility.set_location(l_proc, 900);
3625: end if;
3626:
3627: END extra_tests_dbt_df;
3628:

Line 3704: hr_utility.set_location(l_proc, 10);

3700:
3701: BEGIN
3702:
3703: if (g_dbg) then
3704: hr_utility.set_location(l_proc, 10);
3705: end if;
3706:
3707: /* Only interested in the event if it is a change to the
3708: effective date columns

Line 3721: hr_utility.set_location(l_proc, 25);

3717: and l_search = 'U') THEN
3718: --defo got DT-U
3719: --Allow existing involved code to further test and add to our list
3720: if (g_dbg) then
3721: hr_utility.set_location(l_proc, 25);
3722: end if;
3723: event_group_table_updated(p_element_entry_id,
3724: p_assignment_action_id,
3725: p_business_group_id,

Line 3756: -- hr_utility.set_location(l_proc, 35);

3752: -- and p_pro_evt_rec.effective_date > p_pro_evt_rec.calculation_date
3753: -- and l_search = 'DF') THEN
3754: -- --Add found API-DF to store
3755: -- if (g_dbg) then
3756: -- hr_utility.set_location(l_proc, 35);
3757: -- end if;
3758: -- p_disco := G_DISCO_DF;
3759: --
3760: ELSE

Line 3765: hr_utility.set_location(l_proc, 45);

3761: -- >>> PHASE 4: Differentiate between remaining API-U,API-E,DT-E,DT-DF
3762: --
3763: --
3764: if (g_dbg) then
3765: hr_utility.set_location(l_proc, 45);
3766: end if;
3767:
3768:
3769: l_statement :=

Line 3777: hr_utility.trace('- Dynamic SQL: '||l_statement);

3773: ' and '|| p_dtevent_rec.end_date_name || '>= :2'||
3774: ' group by '|| p_dtevent_rec.surrogate_key_name;
3775:
3776: if (g_dbg) then
3777: hr_utility.trace('- Dynamic SQL: '||l_statement);
3778: end if;
3779: begin
3780: execute immediate l_statement
3781: into l_date_dummy

Line 3825: hr_utility.trace('-Dynamic SQL: '||l_statement);

3821: ' WHERE '||p_dtevent_rec.surrogate_key_name ||' = :1 '||
3822: ' AND '|| p_dtevent_rec.end_date_name || ' >= :2 ';
3823: --
3824: if (g_dbg) then
3825: hr_utility.trace('-Dynamic SQL: '||l_statement);
3826: end if;
3827: --
3828: execute immediate l_statement
3829: into l_dummy

Line 3848: hr_utility.set_location(l_proc, 55);

3844: and l_dummy > 1
3845: and l_search = 'U') THEN
3846: --
3847: if (g_dbg) then
3848: hr_utility.set_location(l_proc, 55);
3849: end if;
3850: --
3851: --Allow existing involved code to further test and add API-U
3852: event_group_table_updated(p_element_entry_id,

Line 3884: hr_utility.set_location(l_proc, 65);

3880: and l_dummy = 1
3881: and l_search = 'E') THEN
3882: --
3883: if (g_dbg) then
3884: hr_utility.set_location(l_proc, 65);
3885: end if;
3886: --
3887: --Add found API-E to store
3888: p_disco := G_DISCO_STANDARD;

Line 3896: -- hr_utility.set_location(l_proc, 75);

3892: --
3893: -- and l_dummy = 1
3894: -- and l_search = 'DF') THEN
3895: -- if (g_dbg) then
3896: -- hr_utility.set_location(l_proc, 75);
3897: -- end if;
3898: -- We have got either a DT-E or DT-F
3899: -- NB. As it is impossible to identify exactly which one
3900: -- it is proposed that it is simply classified as DT-DF

Line 3911: hr_utility.set_location(l_proc, 900);

3907: END IF; --end of main IF
3908: end if; -- IS it effective_start_date or effective_end_date.
3909:
3910: if (g_dbg) then
3911: hr_utility.set_location(l_proc, 900);
3912: end if;
3913: END extra_tests_dbt_u_e;
3914:
3915:

Line 3939: hr_utility.set_location(l_proc, 10);

3935: l_proc VARCHAR2(80) := g_pkg||'.extra_tests_dyt_pkg_e';
3936:
3937: BEGIN
3938: if (g_dbg) then
3939: hr_utility.set_location(l_proc, 10);
3940: end if;
3941: if (p_pro_evt_rec.event_type = hr_api.g_delete) then
3942:
3943: -- >>> PHASE 2: Check e is still relevant

Line 3945: hr_utility.set_location(l_proc, 20);

3941: if (p_pro_evt_rec.event_type = hr_api.g_delete) then
3942:
3943: -- >>> PHASE 2: Check e is still relevant
3944: --
3945: hr_utility.set_location(l_proc, 20);
3946: -- If end date is still relevant, then base key has no rows
3947: -- with end dates later than this end date.
3948:
3949: --Check the base table to see if any future dated records exist,

Line 3955: hr_utility.trace(l_statement);

3951: 'SELECT count(*) FROM '||p_dtevent_rec.table_name||
3952: ' WHERE '||p_dtevent_rec.surrogate_key_name ||' = :1 '||
3953: ' AND '|| p_dtevent_rec.end_date_name ||' >= :2';
3954: if (g_dbg) then
3955: hr_utility.trace(l_statement);
3956: end if;
3957: execute immediate l_statement
3958: into l_dummy
3959: using p_pro_evt_rec.surrogate_key, --:1

Line 3970: hr_utility.set_location(l_proc, 900);

3966:
3967: end if; --If not delete type then dont do anything
3968:
3969: if (g_dbg) then
3970: hr_utility.set_location(l_proc, 900);
3971: end if;
3972: END extra_tests_dyt_pkg_e;
3973:
3974: /* ----------------------------------------------------------

Line 4039: hr_utility.set_location(l_proc, 10);

4035: l_pos number := 0;
4036:
4037: BEGIN
4038: if (g_dbg) then
4039: hr_utility.set_location(l_proc, 10);
4040: end if;
4041:
4042: l_key := p_event_update_id||'_'
4043: ||p_surrogate_key||'_'

Line 4050: hr_utility.trace('Found key in cache, pos '||l_pos);

4046: for j in 1..g_key_date_cache.count() loop
4047: if (g_key_date_cache(j).key = l_key) then
4048: l_pos := j;
4049: if (g_traces) then
4050: hr_utility.trace('Found key in cache, pos '||l_pos);
4051: end if;
4052: l_min_date := g_key_date_cache(j).min_date;
4053: l_max_date := g_key_date_cache(j).max_date;
4054: l_got_flag := g_key_date_cache(j).got_flag;

Line 4062: hr_utility.trace('Not in cache, get dates now, key '||l_key);

4058:
4059: --if no date obtained then get it now
4060: if (l_max_date is null) then
4061: if (g_traces) then
4062: hr_utility.trace('Not in cache, get dates now, key '||l_key);
4063: end if;
4064: if p_assignment_id is not null then
4065: open csr_get_cache_asgid(
4066: p_surrogate_key,

Line 4090: hr_utility.trace('Cache utilised key = '||l_key||', pos = '||l_pos);

4086: g_key_date_cache(l_pos).got_flag := l_got_flag;
4087:
4088: end if;
4089: if (g_traces) then
4090: hr_utility.trace('Cache utilised key = '||l_key||', pos = '||l_pos);
4091: hr_utility.trace('min date = '||
4092: to_char(g_key_date_cache(l_pos).min_date,'DD-MON-RR HH24:MI:SS'));
4093: hr_utility.trace('max date = '||
4094: to_char(g_key_date_cache(l_pos).max_date,'DD-MON-RR HH24:MI:SS'));

Line 4091: hr_utility.trace('min date = '||

4087:
4088: end if;
4089: if (g_traces) then
4090: hr_utility.trace('Cache utilised key = '||l_key||', pos = '||l_pos);
4091: hr_utility.trace('min date = '||
4092: to_char(g_key_date_cache(l_pos).min_date,'DD-MON-RR HH24:MI:SS'));
4093: hr_utility.trace('max date = '||
4094: to_char(g_key_date_cache(l_pos).max_date,'DD-MON-RR HH24:MI:SS'));
4095: end if;

Line 4093: hr_utility.trace('max date = '||

4089: if (g_traces) then
4090: hr_utility.trace('Cache utilised key = '||l_key||', pos = '||l_pos);
4091: hr_utility.trace('min date = '||
4092: to_char(g_key_date_cache(l_pos).min_date,'DD-MON-RR HH24:MI:SS'));
4093: hr_utility.trace('max date = '||
4094: to_char(g_key_date_cache(l_pos).max_date,'DD-MON-RR HH24:MI:SS'));
4095: end if;
4096: p_cache_number :=l_pos;
4097:

Line 4099: hr_utility.set_location(l_proc, 900);

4095: end if;
4096: p_cache_number :=l_pos;
4097:
4098: if (g_dbg) then
4099: hr_utility.set_location(l_proc, 900);
4100: end if;
4101: end get_dbt_i_p_cache;
4102:
4103:

Line 4135: hr_utility.set_location(l_proc, 10);

4131: l_proc VARCHAR2(80) := g_pkg||'.extra_tests_i';
4132:
4133: BEGIN
4134: if (g_dbg) then
4135: hr_utility.set_location(l_proc, 10);
4136: end if;
4137:
4138: -- 1 >>> Check the found process event is an Insert
4139: --Quick short-circuit opportunity

Line 4166: hr_utility.trace('Compare date = '||to_char(g_key_date_cache(l_pos).min_date,'DD-MON-RR HH24:MI:SS')||

4162: ) ;
4163:
4164:
4165: if (g_traces) then
4166: hr_utility.trace('Compare date = '||to_char(g_key_date_cache(l_pos).min_date,'DD-MON-RR HH24:MI:SS')||
4167: ' - '||
4168: to_char(p_pro_evt_rec.creation_date,'DD-MON-RR HH24:MI:SS'));
4169: hr_utility.trace('Compare N flag to '||g_key_date_cache(l_pos).got_flag);
4170: end if;

Line 4169: hr_utility.trace('Compare N flag to '||g_key_date_cache(l_pos).got_flag);

4165: if (g_traces) then
4166: hr_utility.trace('Compare date = '||to_char(g_key_date_cache(l_pos).min_date,'DD-MON-RR HH24:MI:SS')||
4167: ' - '||
4168: to_char(p_pro_evt_rec.creation_date,'DD-MON-RR HH24:MI:SS'));
4169: hr_utility.trace('Compare N flag to '||g_key_date_cache(l_pos).got_flag);
4170: end if;
4171:
4172: --MAIN COMPARE
4173: if (p_pro_evt_rec.creation_date = g_key_date_cache(l_pos).min_date

Line 4191: hr_utility.trace('>>> Dynamic SQL: '||l_statement);

4187: ' WHERE ' || p_dtevent_rec.surrogate_key_name || ' = :1 '||
4188: ' AND '|| p_dtevent_rec.start_date_name || ' <= :2 ';
4189:
4190: if (g_dbg) then
4191: hr_utility.trace('>>> Dynamic SQL: '||l_statement);
4192: end if;
4193: execute immediate l_statement
4194: into l_dummy
4195: using p_pro_evt_rec.surrogate_key, --:1

Line 4205: hr_utility.set_location(l_proc, 900);

4201: end if;
4202: end if;
4203: END IF; --end if else due to non-dated support
4204: if (g_dbg) then
4205: hr_utility.set_location(l_proc, 900);
4206: end if;
4207: END extra_tests_i;
4208:
4209: /* ----------------------------------------------------------

Line 4248: hr_utility.set_location(l_proc, 10);

4244: l_proc VARCHAR2(80) := g_pkg||'.extra_tests_dyt_pkg_u';
4245:
4246: BEGIN
4247: if (g_dbg) then
4248: hr_utility.set_location(l_proc, 10);
4249: end if;
4250:
4251: if ( p_pro_evt_rec.event_type = hr_api.g_update
4252: or p_pro_evt_rec.event_type = hr_api.g_update_override

Line 4287: hr_utility.set_location(l_proc, 900);

4283: -- existing code has already added the event so dont explicitly flag it for addition here
4284: end if;
4285:
4286: if (g_dbg) then
4287: hr_utility.set_location(l_proc, 900);
4288: end if;
4289: END extra_tests_dyt_pkg_u;
4290:
4291: /* ----------------------------------------------------------

Line 4322: hr_utility.set_location(l_proc, 10);

4318: l_proc VARCHAR2(80) := g_pkg||'.extra_tests_dbt_p';
4319:
4320: BEGIN
4321: if (g_dbg) then
4322: hr_utility.set_location(l_proc, 10);
4323: end if;
4324:
4325: -- 1 >>> Check the found process event is an Delete
4326: -- Quick short-circuit opportunity

Line 4347: hr_utility.trace('Compare date = '||to_char(g_key_date_cache(l_pos).min_date,'DD-MON-RR HH24:MI:SS')||

4343: ) ;
4344:
4345:
4346: if (g_traces) then
4347: hr_utility.trace('Compare date = '||to_char(g_key_date_cache(l_pos).min_date,'DD-MON-RR HH24:MI:SS')||
4348: ' - '||
4349: to_char(p_pro_evt_rec.creation_date,'DD-MON-RR HH24:MI:SS'));
4350: hr_utility.trace('Compare N flag to '||g_key_date_cache(l_pos).got_flag);
4351: end if;

Line 4350: hr_utility.trace('Compare N flag to '||g_key_date_cache(l_pos).got_flag);

4346: if (g_traces) then
4347: hr_utility.trace('Compare date = '||to_char(g_key_date_cache(l_pos).min_date,'DD-MON-RR HH24:MI:SS')||
4348: ' - '||
4349: to_char(p_pro_evt_rec.creation_date,'DD-MON-RR HH24:MI:SS'));
4350: hr_utility.trace('Compare N flag to '||g_key_date_cache(l_pos).got_flag);
4351: end if;
4352:
4353: -- MAIN TEST
4354: if (p_pro_evt_rec.creation_date = g_key_date_cache(l_pos).max_date

Line 4359: hr_utility.set_location(l_proc, 30);

4355: and g_key_date_cache(l_pos).got_flag = 'N') then
4356:
4357: -- 3 >>> Now check base table
4358: if (g_dbg) then
4359: hr_utility.set_location(l_proc, 30);
4360: end if;
4361:
4362: --Now check base table to see if we have any rows for this surrogate key
4363: -- just need one row

Line 4369: hr_utility.trace('-Dynamic SQL: '||l_statement);

4365: 'SELECT count(*) FROM '||p_dtevent_rec.table_name||
4366: ' WHERE '||p_dtevent_rec.surrogate_key_name ||' = :1 ';
4367:
4368: if (g_dbg) then
4369: hr_utility.trace('-Dynamic SQL: '||l_statement);
4370: end if;
4371: execute immediate l_statement
4372: into l_dummy
4373: using p_pro_evt_rec.surrogate_key; --:1

Line 4386: hr_utility.set_location(l_proc, 900);

4382: end if;
4383:
4384:
4385: if (g_dbg) then
4386: hr_utility.set_location(l_proc, 900);
4387: end if;
4388: END extra_tests_dbt_p;
4389:
4390:

Line 4418: hr_utility.set_location(l_proc, 10);

4414: l_proc VARCHAR2(80) := g_pkg||'.extra_tests_dyt_pkg_df';
4415:
4416: BEGIN
4417: if (g_dbg) then
4418: hr_utility.set_location(l_proc, 10);
4419: end if;
4420:
4421: -- >>> PHASE 4: Check no future rows
4422: --

Line 4436: hr_utility.trace(l_statement);

4432: ' WHERE ' || p_dtevent_rec.surrogate_key_name || ' = :1 ' ||
4433: ' AND '|| p_dtevent_rec.end_date_name || ' >= :2 ';
4434:
4435: if (g_dbg) then
4436: hr_utility.trace(l_statement);
4437: end if;
4438: execute immediate l_statement
4439: into l_dummy
4440: using p_pro_evt_rec.surrogate_key, --:1

Line 4449: hr_utility.set_location(l_proc, 900);

4445: END IF;
4446:
4447: END IF;
4448: if (g_dbg) then
4449: hr_utility.set_location(l_proc, 900);
4450: end if;
4451: END extra_tests_dyt_pkg_df;
4452: --
4453: procedure analyse_disco_process_events

Line 4487: hr_utility.trace('>> New master candidate PE: '||

4483: l_all_upd_events_recorded boolean := FALSE; --tested before doing extra upd checks below
4484: BEGIN
4485: --
4486: if (g_traces) then
4487: hr_utility.trace('>> New master candidate PE: '||
4488: p_mst_pe_rec.process_event_id||
4489: ' , indicative of update_id: '||
4490: p_mst_pe_rec.event_update_id||
4491: ' key: '||

Line 4495: hr_utility.trace(' Look within Event group '||

4491: ' key: '||
4492: p_mst_pe_rec.surrogate_key );
4493: end if;
4494: if (g_dbg) then
4495: hr_utility.trace(' Look within Event group '||
4496: p_event_group_id||
4497: ' with: '||
4498: to_char( to_number(nvl(p_range_end,0))
4499: - to_number(nvl(p_range_start,0)) + 1 )||

Line 4518: hr_utility.trace(' + Searching... event '||

4514: l_look_for_rec := p_distinct_tab(l_tab_loop_counter);
4515: l_search := l_look_for_rec.update_type;
4516:
4517: if (g_dbg) then
4518: hr_utility.trace(' + Searching... event '||
4519: l_look_for_rec.datetracked_event_id||
4520: ' an: '||
4521: l_search||
4522: ' on '||

Line 4571: hr_utility.trace(

4567: ------------ End fix for BUG 3598389 --------------------------
4568:
4569: -- a chance we're interested, so do extra work
4570: if (g_dbg) then
4571: hr_utility.trace(
4572: ' Found a candidate PE on same table as our DE: '||
4573: 'so call extra logic');
4574: end if;
4575:

Line 5389: hr_utility.set_location(l_proc, 10);

5385: l_pen_ext_exists VARCHAR2(5);
5386: --bug 7443747:Stop
5387:
5388: BEGIN
5389: hr_utility.set_location(l_proc, 10);
5390: l_date_counter := 1;
5391:
5392: -- As part of looking for a dbt_i and dbt_p we create a cache
5393: -- This is a new call to the Interpreter so we destroy this cache

Line 5422: hr_utility.trace('MASTER PROCESS MODE '||l_mst_pm);

5418: -- NB. More notes in get_master_process_mode, but summary
5419: -- CRE = tune for mode, creation date
5420: -- EFF = tune for process, mode and effective date
5421: if(g_traces) then
5422: hr_utility.trace('MASTER PROCESS MODE '||l_mst_pm);
5423: hr_utility.trace('p_penserv_mode '||p_penserv_mode);
5424: end if;
5425: -- >>> PHASE 2: Get candidate rows from PPE
5426: --

Line 5423: hr_utility.trace('p_penserv_mode '||p_penserv_mode);

5419: -- CRE = tune for mode, creation date
5420: -- EFF = tune for process, mode and effective date
5421: if(g_traces) then
5422: hr_utility.trace('MASTER PROCESS MODE '||l_mst_pm);
5423: hr_utility.trace('p_penserv_mode '||p_penserv_mode);
5424: end if;
5425: -- >>> PHASE 2: Get candidate rows from PPE
5426: --
5427: IF (l_mst_pm = 'CRE') THEN

Line 5428: hr_utility.set_location(l_proc,20);

5424: end if;
5425: -- >>> PHASE 2: Get candidate rows from PPE
5426: --
5427: IF (l_mst_pm = 'CRE') THEN
5428: hr_utility.set_location(l_proc,20);
5429: --
5430: l_column_name.delete;
5431: l_event_type.delete;
5432: l_event_update_id.delete;

Line 5510: hr_utility.set_location(l_proc,320);

5506:
5507:
5508: ELSIF (l_mst_pm = 'EFF') THEN
5509: --
5510: hr_utility.set_location(l_proc,320);
5511: --
5512: l_column_name.delete;
5513: l_event_type.delete;
5514: l_event_update_id.delete;

Line 5548: hr_utility.trace('ben_ext_thread.g_ext_dfn_id '||ben_ext_thread.g_ext_dfn_id);

5544: l_table_name;
5545: --
5546: else
5547: --bug 7443747:Start
5548: hr_utility.trace('ben_ext_thread.g_ext_dfn_id '||ben_ext_thread.g_ext_dfn_id);
5549: hr_utility.trace('g_pen_collect_reports '||g_pen_collect_reports);
5550:
5551: IF g_pen_collect_reports is null
5552: THEN

Line 5549: hr_utility.trace('g_pen_collect_reports '||g_pen_collect_reports);

5545: --
5546: else
5547: --bug 7443747:Start
5548: hr_utility.trace('ben_ext_thread.g_ext_dfn_id '||ben_ext_thread.g_ext_dfn_id);
5549: hr_utility.trace('g_pen_collect_reports '||g_pen_collect_reports);
5550:
5551: IF g_pen_collect_reports is null
5552: THEN
5553: OPEN csr_get_pen_reports_exts(ben_ext_thread.g_ext_dfn_id);

Line 5677: hr_utility.set_location(l_proc, 900);

5673:
5674: END IF; --END MAIN IF CRE OR EFF
5675:
5676:
5677: hr_utility.set_location(l_proc, 900);
5678: END record_all_disco_events;
5679:
5680:
5681:

Line 5725: hr_utility.set_location(l_proc, 10);

5721: l_proc VARCHAR2(80) := 'event_group_tables_affected';
5722:
5723:
5724: BEGIN
5725: hr_utility.set_location(l_proc, 10);
5726: if (g_traces) then
5727: hr_utility.trace('Event group ID '||p_event_group_id||
5728: ' number of events in t_proration_group_tab: '||t_proration_group_tab.COUNT);
5729: end if;

Line 5727: hr_utility.trace('Event group ID '||p_event_group_id||

5723:
5724: BEGIN
5725: hr_utility.set_location(l_proc, 10);
5726: if (g_traces) then
5727: hr_utility.trace('Event group ID '||p_event_group_id||
5728: ' number of events in t_proration_group_tab: '||t_proration_group_tab.COUNT);
5729: end if;
5730:
5731:

Line 5770: hr_utility.set_location(l_proc, 900);

5766: t_detailed_output => t_detailed_output,
5767: p_penserv_mode => p_penserv_mode
5768: );
5769:
5770: hr_utility.set_location(l_proc, 900);
5771: END event_group_tables_affected;
5772:
5773:
5774: PROCEDURE event_group_tables_affected

Line 5945: g_traces := hr_utility.debug_enabled ;

5941:
5942: l_proc VARCHAR2(80) := 'entry_affected';
5943:
5944: BEGIN
5945: g_traces := hr_utility.debug_enabled ;
5946:
5947: if (g_traces) then
5948: hr_utility.trace('+------ ENTERED INTERPRETER ----+');
5949: hr_utility.trace('| Assignment Id ' || p_assignment_id);

Line 5948: hr_utility.trace('+------ ENTERED INTERPRETER ----+');

5944: BEGIN
5945: g_traces := hr_utility.debug_enabled ;
5946:
5947: if (g_traces) then
5948: hr_utility.trace('+------ ENTERED INTERPRETER ----+');
5949: hr_utility.trace('| Assignment Id ' || p_assignment_id);
5950: hr_utility.trace('| Assignment Act Id ' || p_assignment_action_id);
5951: hr_utility.trace('| Element Entry Id ' || TO_CHAR(p_element_entry_id));
5952: hr_utility.trace('| Event Group Id ' || p_event_group_id);

Line 5949: hr_utility.trace('| Assignment Id ' || p_assignment_id);

5945: g_traces := hr_utility.debug_enabled ;
5946:
5947: if (g_traces) then
5948: hr_utility.trace('+------ ENTERED INTERPRETER ----+');
5949: hr_utility.trace('| Assignment Id ' || p_assignment_id);
5950: hr_utility.trace('| Assignment Act Id ' || p_assignment_action_id);
5951: hr_utility.trace('| Element Entry Id ' || TO_CHAR(p_element_entry_id));
5952: hr_utility.trace('| Event Group Id ' || p_event_group_id);
5953: end if;

Line 5950: hr_utility.trace('| Assignment Act Id ' || p_assignment_action_id);

5946:
5947: if (g_traces) then
5948: hr_utility.trace('+------ ENTERED INTERPRETER ----+');
5949: hr_utility.trace('| Assignment Id ' || p_assignment_id);
5950: hr_utility.trace('| Assignment Act Id ' || p_assignment_action_id);
5951: hr_utility.trace('| Element Entry Id ' || TO_CHAR(p_element_entry_id));
5952: hr_utility.trace('| Event Group Id ' || p_event_group_id);
5953: end if;
5954:

Line 5951: hr_utility.trace('| Element Entry Id ' || TO_CHAR(p_element_entry_id));

5947: if (g_traces) then
5948: hr_utility.trace('+------ ENTERED INTERPRETER ----+');
5949: hr_utility.trace('| Assignment Id ' || p_assignment_id);
5950: hr_utility.trace('| Assignment Act Id ' || p_assignment_action_id);
5951: hr_utility.trace('| Element Entry Id ' || TO_CHAR(p_element_entry_id));
5952: hr_utility.trace('| Event Group Id ' || p_event_group_id);
5953: end if;
5954:
5955: if (g_dbg) then

Line 5952: hr_utility.trace('| Event Group Id ' || p_event_group_id);

5948: hr_utility.trace('+------ ENTERED INTERPRETER ----+');
5949: hr_utility.trace('| Assignment Id ' || p_assignment_id);
5950: hr_utility.trace('| Assignment Act Id ' || p_assignment_action_id);
5951: hr_utility.trace('| Element Entry Id ' || TO_CHAR(p_element_entry_id));
5952: hr_utility.trace('| Event Group Id ' || p_event_group_id);
5953: end if;
5954:
5955: if (g_dbg) then
5956: hr_utility.trace('| P_mode ' || p_mode);

Line 5956: hr_utility.trace('| P_mode ' || p_mode);

5952: hr_utility.trace('| Event Group Id ' || p_event_group_id);
5953: end if;
5954:
5955: if (g_dbg) then
5956: hr_utility.trace('| P_mode ' || p_mode);
5957: hr_utility.trace('| P_process ' || p_process);
5958: hr_utility.trace('| P_process_mode ' || p_process_mode);
5959: hr_utility.trace('+-------------------------------+ ');
5960: end if;

Line 5957: hr_utility.trace('| P_process ' || p_process);

5953: end if;
5954:
5955: if (g_dbg) then
5956: hr_utility.trace('| P_mode ' || p_mode);
5957: hr_utility.trace('| P_process ' || p_process);
5958: hr_utility.trace('| P_process_mode ' || p_process_mode);
5959: hr_utility.trace('+-------------------------------+ ');
5960: end if;
5961: --

Line 5958: hr_utility.trace('| P_process_mode ' || p_process_mode);

5954:
5955: if (g_dbg) then
5956: hr_utility.trace('| P_mode ' || p_mode);
5957: hr_utility.trace('| P_process ' || p_process);
5958: hr_utility.trace('| P_process_mode ' || p_process_mode);
5959: hr_utility.trace('+-------------------------------+ ');
5960: end if;
5961: --
5962: -- were either passed in and ee_id,event_group_id ,assignment_id ,date, mode

Line 5959: hr_utility.trace('+-------------------------------+ ');

5955: if (g_dbg) then
5956: hr_utility.trace('| P_mode ' || p_mode);
5957: hr_utility.trace('| P_process ' || p_process);
5958: hr_utility.trace('| P_process_mode ' || p_process_mode);
5959: hr_utility.trace('+-------------------------------+ ');
5960: end if;
5961: --
5962: -- were either passed in and ee_id,event_group_id ,assignment_id ,date, mode
5963: -- or a ee_id and assign_act_id.

Line 6023: hr_utility.trace('BG ID was null, now ' ||l_business_group_id);

6019: end if;
6020:
6021:
6022: if (g_dbg) then
6023: hr_utility.trace('BG ID was null, now ' ||l_business_group_id);
6024: end if;
6025:
6026: -- set cache value
6027: g_business_group_id := l_business_group_id;

Line 6044: hr_utility.set_location(l_proc, 20);

6040: l_event_group_id:=p_event_group_id;
6041: l_internal_mode := 'RECALCULATION';
6042: END IF;
6043:
6044: hr_utility.set_location(l_proc, 20);
6045: -- If event group id has not been passed then check to see if there is
6046: -- a default event group for this element type
6047: --
6048: if (l_event_group_id is null) then

Line 6063: hr_utility.trace(' Event Group ID from element type dflt: '||l_event_group_id);

6059: --just one row, but fetch neatly
6060: l_event_group_id := dflt_ev_grp.recalc_event_group_id;
6061: end loop;
6062: if (g_traces) then
6063: hr_utility.trace(' Event Group ID from element type dflt: '||l_event_group_id);
6064: end if;
6065:
6066: -- if we still have no event group just bug out
6067: if (l_event_group_id is null) then

Line 6069: hr_utility.trace('>>> No event group => return null from interpreter');

6065:
6066: -- if we still have no event group just bug out
6067: if (l_event_group_id is null) then
6068: if (g_traces) then
6069: hr_utility.trace('>>> No event group => return null from interpreter');
6070: end if;
6071: return;
6072: end if;
6073: end if;

Line 6089: hr_utility.set_location(l_proc, 30);

6085: t_proration_group_tab(l_event_group_id).range_start;
6086: l_global_env.monitor_end_ptr :=
6087: t_proration_group_tab(l_event_group_id).range_end;
6088: --
6089: hr_utility.set_location(l_proc, 30);
6090:
6091: event_group_tables_affected( p_element_entry_id,
6092: p_assignment_action_id,
6093: l_event_group_id,

Line 6109: hr_utility.set_location(l_proc, 40);

6105: t_proration_type_temp,
6106: t_detailed_output,
6107: p_penserv_mode);
6108:
6109: hr_utility.set_location(l_proc, 40);
6110:
6111: --Only perform the sort if calling procedure has requested it
6112: --NB detailed output results table is never sorted
6113: if (p_unique_sort = 'Y') then

Line 6131: hr_utility.set_location(l_proc, 900);

6127: t_proration_change_type := t_proration_change_type_temp;
6128: --
6129: end if;
6130:
6131: hr_utility.set_location(l_proc, 900);
6132: END entry_affected;
6133:
6134: PROCEDURE get_subset_given_new_evg
6135: (

Line 6157: g_traces := hr_utility.debug_enabled ;

6153: l_proc VARCHAR2(80) := 'get_subset_given_new_evg';
6154:
6155: k number := 1;
6156: BEGIN
6157: g_traces := hr_utility.debug_enabled ;
6158:
6159: if (g_traces) then
6160: hr_utility.set_location(l_proc,10);
6161: hr_utility.trace('| Filter full results using new Event Group Id: ' ||

Line 6160: hr_utility.set_location(l_proc,10);

6156: BEGIN
6157: g_traces := hr_utility.debug_enabled ;
6158:
6159: if (g_traces) then
6160: hr_utility.set_location(l_proc,10);
6161: hr_utility.trace('| Filter full results using new Event Group Id: ' ||
6162: p_filter_event_group_id);
6163: end if;
6164:

Line 6161: hr_utility.trace('| Filter full results using new Event Group Id: ' ||

6157: g_traces := hr_utility.debug_enabled ;
6158:
6159: if (g_traces) then
6160: hr_utility.set_location(l_proc,10);
6161: hr_utility.trace('| Filter full results using new Event Group Id: ' ||
6162: p_filter_event_group_id);
6163: end if;
6164:
6165: -- For each given event, look for the event in our new event group

Line 6172: hr_utility.trace('Looking for '||reqd_event_rec.update_type||' on '||

6168: -- Loop through the required events
6169: for reqd_event_rec in csr_reqd_events loop
6170:
6171: if (g_dbg) then
6172: hr_utility.trace('Looking for '||reqd_event_rec.update_type||' on '||
6173: reqd_event_rec.table_name||'.'||reqd_event_rec.column_name);
6174: end if;
6175:
6176: -- Loop through all the full table events

Line 6205: hr_utility.trace('| p_complete_details_tab contained: '

6201:
6202: end loop; --Get next reqd event from the filter event group
6203:
6204: if (g_traces) then
6205: hr_utility.trace('| p_complete_details_tab contained: '
6206: ||p_complete_detail_tab.count() );
6207: hr_utility.trace('| p_subset_detail_tab contains: '
6208: ||p_subset_detail_tab.count() );
6209: hr_utility.set_location(l_proc,900);

Line 6207: hr_utility.trace('| p_subset_detail_tab contains: '

6203:
6204: if (g_traces) then
6205: hr_utility.trace('| p_complete_details_tab contained: '
6206: ||p_complete_detail_tab.count() );
6207: hr_utility.trace('| p_subset_detail_tab contains: '
6208: ||p_subset_detail_tab.count() );
6209: hr_utility.set_location(l_proc,900);
6210: end if;
6211: END get_subset_given_new_evg;

Line 6209: hr_utility.set_location(l_proc,900);

6205: hr_utility.trace('| p_complete_details_tab contained: '
6206: ||p_complete_detail_tab.count() );
6207: hr_utility.trace('| p_subset_detail_tab contains: '
6208: ||p_subset_detail_tab.count() );
6209: hr_utility.set_location(l_proc,900);
6210: end if;
6211: END get_subset_given_new_evg;
6212:
6213:

Line 6242: g_traces := hr_utility.debug_enabled ;

6238:
6239: l_proc VARCHAR2(80) := 'entries_affected';
6240:
6241: BEGIN
6242: g_traces := hr_utility.debug_enabled ;
6243:
6244: if (g_traces) then
6245: hr_utility.trace('+------ ENTERED INTERPRETER ----+');
6246: hr_utility.trace('| Assignment Id ' || p_assignment_id);

Line 6245: hr_utility.trace('+------ ENTERED INTERPRETER ----+');

6241: BEGIN
6242: g_traces := hr_utility.debug_enabled ;
6243:
6244: if (g_traces) then
6245: hr_utility.trace('+------ ENTERED INTERPRETER ----+');
6246: hr_utility.trace('| Assignment Id ' || p_assignment_id);
6247: end if;
6248:
6249: if (g_dbg) then

Line 6246: hr_utility.trace('| Assignment Id ' || p_assignment_id);

6242: g_traces := hr_utility.debug_enabled ;
6243:
6244: if (g_traces) then
6245: hr_utility.trace('+------ ENTERED INTERPRETER ----+');
6246: hr_utility.trace('| Assignment Id ' || p_assignment_id);
6247: end if;
6248:
6249: if (g_dbg) then
6250: hr_utility.trace('| P_mode ' || p_mode);

Line 6250: hr_utility.trace('| P_mode ' || p_mode);

6246: hr_utility.trace('| Assignment Id ' || p_assignment_id);
6247: end if;
6248:
6249: if (g_dbg) then
6250: hr_utility.trace('| P_mode ' || p_mode);
6251: hr_utility.trace('+-------------------------------+ ');
6252: end if;
6253: --
6254: -- Setup the global structure

Line 6251: hr_utility.trace('+-------------------------------+ ');

6247: end if;
6248:
6249: if (g_dbg) then
6250: hr_utility.trace('| P_mode ' || p_mode);
6251: hr_utility.trace('+-------------------------------+ ');
6252: end if;
6253: --
6254: -- Setup the global structure
6255: --

Line 6288: hr_utility.set_location(l_proc, 20);

6284:
6285: l_assignment_id:=p_assignment_id;
6286: l_internal_mode := 'RECALCULATION';
6287:
6288: hr_utility.set_location(l_proc, 20);
6289:
6290: event_group_tables_affected( null,
6291: l_assignment_action_id,
6292: null,

Line 6308: hr_utility.set_location(l_proc, 40);

6304: t_proration_type_temp,
6305: t_detailed_output,
6306: p_penserv_mode);
6307:
6308: hr_utility.set_location(l_proc, 40);
6309:
6310: hr_utility.set_location(l_proc, 900);
6311: END entries_affected;
6312:

Line 6310: hr_utility.set_location(l_proc, 900);

6306: p_penserv_mode);
6307:
6308: hr_utility.set_location(l_proc, 40);
6309:
6310: hr_utility.set_location(l_proc, 900);
6311: END entries_affected;
6312:
6313:
6314: begin