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.45.12020000.5 2012/07/06 11:53:14 vmaripal 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 4913: hr_utility.trace('table name is :PAY_INPUT_VALUES_F' );

4909: --
4910: /*Added the following code for bug 13029951*/
4911: elsif (p_table_name = 'PAY_INPUT_VALUES_F') then
4912:
4913: hr_utility.trace('table name is :PAY_INPUT_VALUES_F' );
4914: hr_utility.trace('Assignment id is '||p_assignment_id );
4915: hr_utility.trace('Surrogate Key is '||p_surrogate_key );
4916:
4917: l_valid_event := 'N';

Line 4914: hr_utility.trace('Assignment id is '||p_assignment_id );

4910: /*Added the following code for bug 13029951*/
4911: elsif (p_table_name = 'PAY_INPUT_VALUES_F') then
4912:
4913: hr_utility.trace('table name is :PAY_INPUT_VALUES_F' );
4914: hr_utility.trace('Assignment id is '||p_assignment_id );
4915: hr_utility.trace('Surrogate Key is '||p_surrogate_key );
4916:
4917: l_valid_event := 'N';
4918:

Line 4915: hr_utility.trace('Surrogate Key is '||p_surrogate_key );

4911: elsif (p_table_name = 'PAY_INPUT_VALUES_F') then
4912:
4913: hr_utility.trace('table name is :PAY_INPUT_VALUES_F' );
4914: hr_utility.trace('Assignment id is '||p_assignment_id );
4915: hr_utility.trace('Surrogate Key is '||p_surrogate_key );
4916:
4917: l_valid_event := 'N';
4918:
4919: for grrec in validate_input_value_id(p_assignment_id,p_surrogate_key) loop

Line 4922: hr_utility.trace('The input_values event is valid for this assignment');

4918:
4919: for grrec in validate_input_value_id(p_assignment_id,p_surrogate_key) loop
4920: --
4921: l_valid_event := 'Y';
4922: hr_utility.trace('The input_values event is valid for this assignment');
4923: --
4924: end loop;
4925: --
4926: /*Added the following code for bug 13384584*/

Line 4929: hr_utility.trace('table name is PER_CAGR_ENTITLEMENT_LINES_F' );

4925: --
4926: /*Added the following code for bug 13384584*/
4927: elsif (p_table_name = 'PER_CAGR_ENTITLEMENT_LINES_F') then
4928:
4929: hr_utility.trace('table name is PER_CAGR_ENTITLEMENT_LINES_F' );
4930: hr_utility.trace('Assignment id is '||p_assignment_id );
4931: hr_utility.trace('Surrogate Key is '||p_surrogate_key );
4932:
4933: l_valid_event := 'N';

Line 4930: hr_utility.trace('Assignment id is '||p_assignment_id );

4926: /*Added the following code for bug 13384584*/
4927: elsif (p_table_name = 'PER_CAGR_ENTITLEMENT_LINES_F') then
4928:
4929: hr_utility.trace('table name is PER_CAGR_ENTITLEMENT_LINES_F' );
4930: hr_utility.trace('Assignment id is '||p_assignment_id );
4931: hr_utility.trace('Surrogate Key is '||p_surrogate_key );
4932:
4933: l_valid_event := 'N';
4934:

Line 4931: hr_utility.trace('Surrogate Key is '||p_surrogate_key );

4927: elsif (p_table_name = 'PER_CAGR_ENTITLEMENT_LINES_F') then
4928:
4929: hr_utility.trace('table name is PER_CAGR_ENTITLEMENT_LINES_F' );
4930: hr_utility.trace('Assignment id is '||p_assignment_id );
4931: hr_utility.trace('Surrogate Key is '||p_surrogate_key );
4932:
4933: l_valid_event := 'N';
4934:
4935: for grrec in val_entl_line_elig(p_assignment_id,p_surrogate_key) loop

Line 4937: hr_utility.trace('The Entitlement lines event is valid for this assignment');

4933: l_valid_event := 'N';
4934:
4935: for grrec in val_entl_line_elig(p_assignment_id,p_surrogate_key) loop
4936: --
4937: hr_utility.trace('The Entitlement lines event is valid for this assignment');
4938: l_valid_event := 'Y';
4939: --
4940: end loop;
4941: --

Line 4944: hr_utility.trace('table name is FF_GLOBALS_F ' );

4940: end loop;
4941: --
4942: elsif (p_table_name = 'FF_GLOBALS_F') then
4943:
4944: hr_utility.trace('table name is FF_GLOBALS_F ' );
4945: hr_utility.trace('Assignment id is '||p_assignment_id );
4946: hr_utility.trace('Surrogate Key is '||p_surrogate_key );
4947: --
4948: l_valid_event := pay_group_event_pkg.ff_global_check(p_assignment_id,p_surrogate_key);

Line 4945: hr_utility.trace('Assignment id is '||p_assignment_id );

4941: --
4942: elsif (p_table_name = 'FF_GLOBALS_F') then
4943:
4944: hr_utility.trace('table name is FF_GLOBALS_F ' );
4945: hr_utility.trace('Assignment id is '||p_assignment_id );
4946: hr_utility.trace('Surrogate Key is '||p_surrogate_key );
4947: --
4948: l_valid_event := pay_group_event_pkg.ff_global_check(p_assignment_id,p_surrogate_key);
4949: --

Line 4946: hr_utility.trace('Surrogate Key is '||p_surrogate_key );

4942: elsif (p_table_name = 'FF_GLOBALS_F') then
4943:
4944: hr_utility.trace('table name is FF_GLOBALS_F ' );
4945: hr_utility.trace('Assignment id is '||p_assignment_id );
4946: hr_utility.trace('Surrogate Key is '||p_surrogate_key );
4947: --
4948: l_valid_event := pay_group_event_pkg.ff_global_check(p_assignment_id,p_surrogate_key);
4949: --
4950: elsif (p_table_name = 'PAY_USER_COLUMN_INSTANCES_F') then

Line 5021: hr_utility.trace('p_lapp_date :' ||p_lapp_date);

5017:
5018: l_penserver_date := l_penserver_date - 1;
5019:
5020:
5021: hr_utility.trace('p_lapp_date :' ||p_lapp_date);
5022: hr_utility.trace('l_penserver_date :' ||l_penserver_date);
5023:
5024: RETURN l_penserver_date;
5025:

Line 5022: hr_utility.trace('l_penserver_date :' ||l_penserver_date);

5018: l_penserver_date := l_penserver_date - 1;
5019:
5020:
5021: hr_utility.trace('p_lapp_date :' ||p_lapp_date);
5022: hr_utility.trace('l_penserver_date :' ||l_penserver_date);
5023:
5024: RETURN l_penserver_date;
5025:
5026: END get_penserver_date;

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

5628: AND ext_stat_cd = 'A'
5629: ORDER BY app_date DESC;
5630:
5631: BEGIN
5632: hr_utility.set_location(l_proc, 10);
5633:
5634: if (g_dbg) then
5635: hr_utility.trace('The Business Group id is '||p_business_group_id);
5636: hr_utility.trace('The p_assignment_id '||p_assignment_id);

Line 5635: hr_utility.trace('The Business Group id is '||p_business_group_id);

5631: BEGIN
5632: hr_utility.set_location(l_proc, 10);
5633:
5634: if (g_dbg) then
5635: hr_utility.trace('The Business Group id is '||p_business_group_id);
5636: hr_utility.trace('The p_assignment_id '||p_assignment_id);
5637: hr_utility.trace('The p_event_group_id '||p_event_group_id);
5638: hr_utility.trace('The g_leg_code is '||g_leg_code);
5639: hr_utility.trace('The p_mode is '||p_mode);

Line 5636: hr_utility.trace('The p_assignment_id '||p_assignment_id);

5632: hr_utility.set_location(l_proc, 10);
5633:
5634: if (g_dbg) then
5635: hr_utility.trace('The Business Group id is '||p_business_group_id);
5636: hr_utility.trace('The p_assignment_id '||p_assignment_id);
5637: hr_utility.trace('The p_event_group_id '||p_event_group_id);
5638: hr_utility.trace('The g_leg_code is '||g_leg_code);
5639: hr_utility.trace('The p_mode is '||p_mode);
5640: hr_utility.trace('The p_element_entry_id is '||p_element_entry_id);

Line 5637: hr_utility.trace('The p_event_group_id '||p_event_group_id);

5633:
5634: if (g_dbg) then
5635: hr_utility.trace('The Business Group id is '||p_business_group_id);
5636: hr_utility.trace('The p_assignment_id '||p_assignment_id);
5637: hr_utility.trace('The p_event_group_id '||p_event_group_id);
5638: hr_utility.trace('The g_leg_code is '||g_leg_code);
5639: hr_utility.trace('The p_mode is '||p_mode);
5640: hr_utility.trace('The p_element_entry_id is '||p_element_entry_id);
5641: hr_utility.trace('The p_start_date is '||to_char(p_start_date,'DD-MON-YYYY HH24:MI:SS'));

Line 5638: hr_utility.trace('The g_leg_code is '||g_leg_code);

5634: if (g_dbg) then
5635: hr_utility.trace('The Business Group id is '||p_business_group_id);
5636: hr_utility.trace('The p_assignment_id '||p_assignment_id);
5637: hr_utility.trace('The p_event_group_id '||p_event_group_id);
5638: hr_utility.trace('The g_leg_code is '||g_leg_code);
5639: hr_utility.trace('The p_mode is '||p_mode);
5640: hr_utility.trace('The p_element_entry_id is '||p_element_entry_id);
5641: hr_utility.trace('The p_start_date is '||to_char(p_start_date,'DD-MON-YYYY HH24:MI:SS'));
5642: hr_utility.trace('The p_end_date is '||to_char(p_end_date,'DD-MON-YYYY HH24:MI:SS'));

Line 5639: hr_utility.trace('The p_mode is '||p_mode);

5635: hr_utility.trace('The Business Group id is '||p_business_group_id);
5636: hr_utility.trace('The p_assignment_id '||p_assignment_id);
5637: hr_utility.trace('The p_event_group_id '||p_event_group_id);
5638: hr_utility.trace('The g_leg_code is '||g_leg_code);
5639: hr_utility.trace('The p_mode is '||p_mode);
5640: hr_utility.trace('The p_element_entry_id is '||p_element_entry_id);
5641: hr_utility.trace('The p_start_date is '||to_char(p_start_date,'DD-MON-YYYY HH24:MI:SS'));
5642: hr_utility.trace('The p_end_date is '||to_char(p_end_date,'DD-MON-YYYY HH24:MI:SS'));
5643: end if;

Line 5640: hr_utility.trace('The p_element_entry_id is '||p_element_entry_id);

5636: hr_utility.trace('The p_assignment_id '||p_assignment_id);
5637: hr_utility.trace('The p_event_group_id '||p_event_group_id);
5638: hr_utility.trace('The g_leg_code is '||g_leg_code);
5639: hr_utility.trace('The p_mode is '||p_mode);
5640: hr_utility.trace('The p_element_entry_id is '||p_element_entry_id);
5641: hr_utility.trace('The p_start_date is '||to_char(p_start_date,'DD-MON-YYYY HH24:MI:SS'));
5642: hr_utility.trace('The p_end_date is '||to_char(p_end_date,'DD-MON-YYYY HH24:MI:SS'));
5643: end if;
5644:

Line 5641: hr_utility.trace('The p_start_date is '||to_char(p_start_date,'DD-MON-YYYY HH24:MI:SS'));

5637: hr_utility.trace('The p_event_group_id '||p_event_group_id);
5638: hr_utility.trace('The g_leg_code is '||g_leg_code);
5639: hr_utility.trace('The p_mode is '||p_mode);
5640: hr_utility.trace('The p_element_entry_id is '||p_element_entry_id);
5641: hr_utility.trace('The p_start_date is '||to_char(p_start_date,'DD-MON-YYYY HH24:MI:SS'));
5642: hr_utility.trace('The p_end_date is '||to_char(p_end_date,'DD-MON-YYYY HH24:MI:SS'));
5643: end if;
5644:
5645: l_date_counter := 1;

Line 5642: hr_utility.trace('The p_end_date is '||to_char(p_end_date,'DD-MON-YYYY HH24:MI:SS'));

5638: hr_utility.trace('The g_leg_code is '||g_leg_code);
5639: hr_utility.trace('The p_mode is '||p_mode);
5640: hr_utility.trace('The p_element_entry_id is '||p_element_entry_id);
5641: hr_utility.trace('The p_start_date is '||to_char(p_start_date,'DD-MON-YYYY HH24:MI:SS'));
5642: hr_utility.trace('The p_end_date is '||to_char(p_end_date,'DD-MON-YYYY HH24:MI:SS'));
5643: end if;
5644:
5645: l_date_counter := 1;
5646:

Line 5677: hr_utility.trace('The value of l_bulk_processing is '||l_bulk_processing);

5673: -- NB. More notes in get_master_process_mode, but summary
5674: -- CRE = tune for mode, creation date
5675: -- EFF = tune for process, mode and effective date
5676: if(g_traces) then
5677: hr_utility.trace('The value of l_bulk_processing is '||l_bulk_processing);
5678: hr_utility.trace('MASTER PROCESS MODE '||l_mst_pm);
5679: hr_utility.trace('p_penserv_mode '||p_penserv_mode);
5680: end if;
5681: -- >>> PHASE 2: Get candidate rows from PPE

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

5674: -- CRE = tune for mode, creation date
5675: -- EFF = tune for process, mode and effective date
5676: if(g_traces) then
5677: hr_utility.trace('The value of l_bulk_processing is '||l_bulk_processing);
5678: hr_utility.trace('MASTER PROCESS MODE '||l_mst_pm);
5679: hr_utility.trace('p_penserv_mode '||p_penserv_mode);
5680: end if;
5681: -- >>> PHASE 2: Get candidate rows from PPE
5682: --

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

5675: -- EFF = tune for process, mode and effective date
5676: if(g_traces) then
5677: hr_utility.trace('The value of l_bulk_processing is '||l_bulk_processing);
5678: hr_utility.trace('MASTER PROCESS MODE '||l_mst_pm);
5679: hr_utility.trace('p_penserv_mode '||p_penserv_mode);
5680: end if;
5681: -- >>> PHASE 2: Get candidate rows from PPE
5682: --
5683: IF (l_mst_pm = 'CRE') THEN

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

5680: end if;
5681: -- >>> PHASE 2: Get candidate rows from PPE
5682: --
5683: IF (l_mst_pm = 'CRE') THEN
5684: hr_utility.set_location(l_proc,20);
5685: --
5686: l_column_name.delete;
5687: l_event_type.delete;
5688: l_event_update_id.delete;

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

5762:
5763:
5764: ELSIF (l_mst_pm = 'EFF') THEN
5765: --
5766: hr_utility.set_location(l_proc,320);
5767: --
5768: l_column_name.delete;
5769: l_event_type.delete;
5770: l_event_update_id.delete;

Line 5813: hr_utility.trace('-------g_pen_lapp_date----------');

5809: THEN
5810: OPEN csr_pen_get_lapp_date;
5811: FETCH csr_pen_get_lapp_date INTO g_pen_lapp_date;
5812: CLOSE csr_pen_get_lapp_date;
5813: hr_utility.trace('-------g_pen_lapp_date----------');
5814: hr_utility.trace('g_pen_lapp_date :'||to_char(g_pen_lapp_date,'DD-MON-YYYY HH24:MI:SS'));
5815: END IF;
5816:
5817: -- Get the Actual Start Date for Each assignment

Line 5814: hr_utility.trace('g_pen_lapp_date :'||to_char(g_pen_lapp_date,'DD-MON-YYYY HH24:MI:SS'));

5810: OPEN csr_pen_get_lapp_date;
5811: FETCH csr_pen_get_lapp_date INTO g_pen_lapp_date;
5812: CLOSE csr_pen_get_lapp_date;
5813: hr_utility.trace('-------g_pen_lapp_date----------');
5814: hr_utility.trace('g_pen_lapp_date :'||to_char(g_pen_lapp_date,'DD-MON-YYYY HH24:MI:SS'));
5815: END IF;
5816:
5817: -- Get the Actual Start Date for Each assignment
5818: IF g_pen_lapp_date is not null

Line 5824: hr_utility.trace('-------p_assignment_id----------');

5820: IF p_assignment_id <> g_pen_prev_ass_id
5821: THEN
5822: g_pen_from_date := get_penserver_date(p_assignment_id,p_business_group_id,trunc(g_pen_lapp_date),p_end_date); -- For bug 8359083
5823: g_pen_prev_ass_id := p_assignment_id;
5824: hr_utility.trace('-------p_assignment_id----------');
5825: hr_utility.trace('p_assignment_id :'||p_assignment_id);
5826: END IF;
5827: ELSE
5828: g_pen_from_date := p_start_date;

Line 5825: hr_utility.trace('p_assignment_id :'||p_assignment_id);

5821: THEN
5822: g_pen_from_date := get_penserver_date(p_assignment_id,p_business_group_id,trunc(g_pen_lapp_date),p_end_date); -- For bug 8359083
5823: g_pen_prev_ass_id := p_assignment_id;
5824: hr_utility.trace('-------p_assignment_id----------');
5825: hr_utility.trace('p_assignment_id :'||p_assignment_id);
5826: END IF;
5827: ELSE
5828: g_pen_from_date := p_start_date;
5829: END IF;

Line 5830: hr_utility.trace('-------g_pen_prev_ass_id----------');

5826: END IF;
5827: ELSE
5828: g_pen_from_date := p_start_date;
5829: END IF;
5830: hr_utility.trace('-------g_pen_prev_ass_id----------');
5831: hr_utility.trace('g_pen_prev_ass_id :'||g_pen_prev_ass_id);
5832: hr_utility.trace('g_pen_from_date :'||g_pen_from_date);
5833:
5834: -- BUG 7525608 :End

Line 5831: hr_utility.trace('g_pen_prev_ass_id :'||g_pen_prev_ass_id);

5827: ELSE
5828: g_pen_from_date := p_start_date;
5829: END IF;
5830: hr_utility.trace('-------g_pen_prev_ass_id----------');
5831: hr_utility.trace('g_pen_prev_ass_id :'||g_pen_prev_ass_id);
5832: hr_utility.trace('g_pen_from_date :'||g_pen_from_date);
5833:
5834: -- BUG 7525608 :End
5835:

Line 5832: hr_utility.trace('g_pen_from_date :'||g_pen_from_date);

5828: g_pen_from_date := p_start_date;
5829: END IF;
5830: hr_utility.trace('-------g_pen_prev_ass_id----------');
5831: hr_utility.trace('g_pen_prev_ass_id :'||g_pen_prev_ass_id);
5832: hr_utility.trace('g_pen_from_date :'||g_pen_from_date);
5833:
5834: -- BUG 7525608 :End
5835:
5836: --bug 7443747:Start

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

5833:
5834: -- BUG 7525608 :End
5835:
5836: --bug 7443747:Start
5837: hr_utility.trace('ben_ext_thread.g_ext_dfn_id '||ben_ext_thread.g_ext_dfn_id);
5838: hr_utility.trace('g_pen_collect_reports '||g_pen_collect_reports);
5839:
5840: IF g_pen_collect_reports is null
5841: THEN

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

5834: -- BUG 7525608 :End
5835:
5836: --bug 7443747:Start
5837: hr_utility.trace('ben_ext_thread.g_ext_dfn_id '||ben_ext_thread.g_ext_dfn_id);
5838: hr_utility.trace('g_pen_collect_reports '||g_pen_collect_reports);
5839:
5840: IF g_pen_collect_reports is null
5841: THEN
5842: OPEN csr_get_pen_reports_exts(ben_ext_thread.g_ext_dfn_id);

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

5849:
5850: CLOSE csr_get_pen_reports_exts;
5851:
5852: END IF;
5853: hr_utility.trace('g_pen_collect_reports '||g_pen_collect_reports);
5854: IF g_pen_collect_reports = 'A'
5855: THEN
5856: open csr_all_proces_eve_eff_pen_rep(
5857: l_bulk_processing,

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

6022:
6023: END IF; --END MAIN IF CRE OR EFF
6024:
6025:
6026: hr_utility.set_location(l_proc, 900);
6027: END record_all_disco_events;
6028:
6029:
6030:

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

6070: l_proc VARCHAR2(80) := 'event_group_tables_affected';
6071:
6072:
6073: BEGIN
6074: hr_utility.set_location(l_proc, 10);
6075: if (g_traces) then
6076: hr_utility.trace('Event group ID '||p_event_group_id||
6077: ' number of events in t_proration_group_tab: '||t_proration_group_tab.COUNT);
6078: end if;

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

6072:
6073: BEGIN
6074: hr_utility.set_location(l_proc, 10);
6075: if (g_traces) then
6076: hr_utility.trace('Event group ID '||p_event_group_id||
6077: ' number of events in t_proration_group_tab: '||t_proration_group_tab.COUNT);
6078: end if;
6079:
6080:

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

6115: t_detailed_output => t_detailed_output,
6116: p_penserv_mode => p_penserv_mode
6117: );
6118:
6119: hr_utility.set_location(l_proc, 900);
6120: END event_group_tables_affected;
6121:
6122:
6123: PROCEDURE event_group_tables_affected

Line 6294: g_traces := hr_utility.debug_enabled ;

6290:
6291: l_proc VARCHAR2(80) := 'entry_affected';
6292:
6293: BEGIN
6294: g_traces := hr_utility.debug_enabled ;
6295:
6296: if (g_traces) then
6297: hr_utility.trace('+------ ENTERED INTERPRETER ----+');
6298: hr_utility.trace('| Assignment Id ' || p_assignment_id);

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

6293: BEGIN
6294: g_traces := hr_utility.debug_enabled ;
6295:
6296: if (g_traces) then
6297: hr_utility.trace('+------ ENTERED INTERPRETER ----+');
6298: hr_utility.trace('| Assignment Id ' || p_assignment_id);
6299: hr_utility.trace('| Assignment Act Id ' || p_assignment_action_id);
6300: hr_utility.trace('| Element Entry Id ' || TO_CHAR(p_element_entry_id));
6301: hr_utility.trace('| Event Group Id ' || p_event_group_id);

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

6294: g_traces := hr_utility.debug_enabled ;
6295:
6296: if (g_traces) then
6297: hr_utility.trace('+------ ENTERED INTERPRETER ----+');
6298: hr_utility.trace('| Assignment Id ' || p_assignment_id);
6299: hr_utility.trace('| Assignment Act Id ' || p_assignment_action_id);
6300: hr_utility.trace('| Element Entry Id ' || TO_CHAR(p_element_entry_id));
6301: hr_utility.trace('| Event Group Id ' || p_event_group_id);
6302: end if;

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

6295:
6296: if (g_traces) then
6297: hr_utility.trace('+------ ENTERED INTERPRETER ----+');
6298: hr_utility.trace('| Assignment Id ' || p_assignment_id);
6299: hr_utility.trace('| Assignment Act Id ' || p_assignment_action_id);
6300: hr_utility.trace('| Element Entry Id ' || TO_CHAR(p_element_entry_id));
6301: hr_utility.trace('| Event Group Id ' || p_event_group_id);
6302: end if;
6303:

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

6296: if (g_traces) then
6297: hr_utility.trace('+------ ENTERED INTERPRETER ----+');
6298: hr_utility.trace('| Assignment Id ' || p_assignment_id);
6299: hr_utility.trace('| Assignment Act Id ' || p_assignment_action_id);
6300: hr_utility.trace('| Element Entry Id ' || TO_CHAR(p_element_entry_id));
6301: hr_utility.trace('| Event Group Id ' || p_event_group_id);
6302: end if;
6303:
6304: if (g_dbg) then

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

6297: hr_utility.trace('+------ ENTERED INTERPRETER ----+');
6298: hr_utility.trace('| Assignment Id ' || p_assignment_id);
6299: hr_utility.trace('| Assignment Act Id ' || p_assignment_action_id);
6300: hr_utility.trace('| Element Entry Id ' || TO_CHAR(p_element_entry_id));
6301: hr_utility.trace('| Event Group Id ' || p_event_group_id);
6302: end if;
6303:
6304: if (g_dbg) then
6305: hr_utility.trace('| P_mode ' || p_mode);

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

6301: hr_utility.trace('| Event Group Id ' || p_event_group_id);
6302: end if;
6303:
6304: if (g_dbg) then
6305: hr_utility.trace('| P_mode ' || p_mode);
6306: hr_utility.trace('| P_process ' || p_process);
6307: hr_utility.trace('| P_process_mode ' || p_process_mode);
6308: hr_utility.trace('+-------------------------------+ ');
6309: end if;

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

6302: end if;
6303:
6304: if (g_dbg) then
6305: hr_utility.trace('| P_mode ' || p_mode);
6306: hr_utility.trace('| P_process ' || p_process);
6307: hr_utility.trace('| P_process_mode ' || p_process_mode);
6308: hr_utility.trace('+-------------------------------+ ');
6309: end if;
6310: --

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

6303:
6304: if (g_dbg) then
6305: hr_utility.trace('| P_mode ' || p_mode);
6306: hr_utility.trace('| P_process ' || p_process);
6307: hr_utility.trace('| P_process_mode ' || p_process_mode);
6308: hr_utility.trace('+-------------------------------+ ');
6309: end if;
6310: --
6311: -- were either passed in and ee_id,event_group_id ,assignment_id ,date, mode

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

6304: if (g_dbg) then
6305: hr_utility.trace('| P_mode ' || p_mode);
6306: hr_utility.trace('| P_process ' || p_process);
6307: hr_utility.trace('| P_process_mode ' || p_process_mode);
6308: hr_utility.trace('+-------------------------------+ ');
6309: end if;
6310: --
6311: -- were either passed in and ee_id,event_group_id ,assignment_id ,date, mode
6312: -- or a ee_id and assign_act_id.

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

6368: end if;
6369:
6370:
6371: if (g_dbg) then
6372: hr_utility.trace('BG ID was null, now ' ||l_business_group_id);
6373: end if;
6374:
6375: -- set cache value
6376: g_business_group_id := l_business_group_id;

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

6389: l_event_group_id:=p_event_group_id;
6390: l_internal_mode := 'RECALCULATION';
6391: END IF;
6392:
6393: hr_utility.set_location(l_proc, 20);
6394: -- If event group id has not been passed then check to see if there is
6395: -- a default event group for this element type
6396: --
6397: if (l_event_group_id is null) then

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

6408: --just one row, but fetch neatly
6409: l_event_group_id := dflt_ev_grp.recalc_event_group_id;
6410: end loop;
6411: if (g_traces) then
6412: hr_utility.trace(' Event Group ID from element type dflt: '||l_event_group_id);
6413: end if;
6414:
6415: -- if we still have no event group just bug out
6416: if (l_event_group_id is null) then

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

6414:
6415: -- if we still have no event group just bug out
6416: if (l_event_group_id is null) then
6417: if (g_traces) then
6418: hr_utility.trace('>>> No event group => return null from interpreter');
6419: end if;
6420: return;
6421: end if;
6422: end if;

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

6434: t_proration_group_tab(l_event_group_id).range_start;
6435: l_global_env.monitor_end_ptr :=
6436: t_proration_group_tab(l_event_group_id).range_end;
6437: --
6438: hr_utility.set_location(l_proc, 30);
6439:
6440: event_group_tables_affected( p_element_entry_id,
6441: p_assignment_action_id,
6442: l_event_group_id,

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

6454: t_proration_type_temp,
6455: t_detailed_output,
6456: p_penserv_mode);
6457:
6458: hr_utility.set_location(l_proc, 40);
6459:
6460: --Only perform the sort if calling procedure has requested it
6461: --NB detailed output results table is never sorted
6462: if (p_unique_sort = 'Y') then

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

6476: t_proration_change_type := t_proration_change_type_temp;
6477: --
6478: end if;
6479:
6480: hr_utility.set_location(l_proc, 900);
6481: END entry_affected;
6482:
6483: PROCEDURE get_subset_given_new_evg
6484: (

Line 6506: g_traces := hr_utility.debug_enabled ;

6502: l_proc VARCHAR2(80) := 'get_subset_given_new_evg';
6503:
6504: k number := 1;
6505: BEGIN
6506: g_traces := hr_utility.debug_enabled ;
6507:
6508: if (g_traces) then
6509: hr_utility.set_location(l_proc,10);
6510: hr_utility.trace('| Filter full results using new Event Group Id: ' ||

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

6505: BEGIN
6506: g_traces := hr_utility.debug_enabled ;
6507:
6508: if (g_traces) then
6509: hr_utility.set_location(l_proc,10);
6510: hr_utility.trace('| Filter full results using new Event Group Id: ' ||
6511: p_filter_event_group_id);
6512: end if;
6513:

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

6506: g_traces := hr_utility.debug_enabled ;
6507:
6508: if (g_traces) then
6509: hr_utility.set_location(l_proc,10);
6510: hr_utility.trace('| Filter full results using new Event Group Id: ' ||
6511: p_filter_event_group_id);
6512: end if;
6513:
6514: -- For each given event, look for the event in our new event group

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

6517: -- Loop through the required events
6518: for reqd_event_rec in csr_reqd_events loop
6519:
6520: if (g_dbg) then
6521: hr_utility.trace('Looking for '||reqd_event_rec.update_type||' on '||
6522: reqd_event_rec.table_name||'.'||reqd_event_rec.column_name);
6523: end if;
6524:
6525: -- Loop through all the full table events

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

6550:
6551: end loop; --Get next reqd event from the filter event group
6552:
6553: if (g_traces) then
6554: hr_utility.trace('| p_complete_details_tab contained: '
6555: ||p_complete_detail_tab.count() );
6556: hr_utility.trace('| p_subset_detail_tab contains: '
6557: ||p_subset_detail_tab.count() );
6558: hr_utility.set_location(l_proc,900);

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

6552:
6553: if (g_traces) then
6554: hr_utility.trace('| p_complete_details_tab contained: '
6555: ||p_complete_detail_tab.count() );
6556: hr_utility.trace('| p_subset_detail_tab contains: '
6557: ||p_subset_detail_tab.count() );
6558: hr_utility.set_location(l_proc,900);
6559: end if;
6560: END get_subset_given_new_evg;

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

6554: hr_utility.trace('| p_complete_details_tab contained: '
6555: ||p_complete_detail_tab.count() );
6556: hr_utility.trace('| p_subset_detail_tab contains: '
6557: ||p_subset_detail_tab.count() );
6558: hr_utility.set_location(l_proc,900);
6559: end if;
6560: END get_subset_given_new_evg;
6561:
6562:

Line 6591: g_traces := hr_utility.debug_enabled ;

6587:
6588: l_proc VARCHAR2(80) := 'entries_affected';
6589:
6590: BEGIN
6591: g_traces := hr_utility.debug_enabled ;
6592:
6593: if (g_traces) then
6594: hr_utility.trace('+------ ENTERED INTERPRETER ----+');
6595: hr_utility.trace('| Assignment Id ' || p_assignment_id);

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

6590: BEGIN
6591: g_traces := hr_utility.debug_enabled ;
6592:
6593: if (g_traces) then
6594: hr_utility.trace('+------ ENTERED INTERPRETER ----+');
6595: hr_utility.trace('| Assignment Id ' || p_assignment_id);
6596: end if;
6597:
6598: if (g_dbg) then

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

6591: g_traces := hr_utility.debug_enabled ;
6592:
6593: if (g_traces) then
6594: hr_utility.trace('+------ ENTERED INTERPRETER ----+');
6595: hr_utility.trace('| Assignment Id ' || p_assignment_id);
6596: end if;
6597:
6598: if (g_dbg) then
6599: hr_utility.trace('| P_mode ' || p_mode);

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

6595: hr_utility.trace('| Assignment Id ' || p_assignment_id);
6596: end if;
6597:
6598: if (g_dbg) then
6599: hr_utility.trace('| P_mode ' || p_mode);
6600: hr_utility.trace('+-------------------------------+ ');
6601: end if;
6602: --
6603: -- Setup the global structure

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

6596: end if;
6597:
6598: if (g_dbg) then
6599: hr_utility.trace('| P_mode ' || p_mode);
6600: hr_utility.trace('+-------------------------------+ ');
6601: end if;
6602: --
6603: -- Setup the global structure
6604: --

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

6641:
6642: l_assignment_id:=p_assignment_id;
6643: l_internal_mode := 'RECALCULATION';
6644:
6645: hr_utility.set_location(l_proc, 20);
6646:
6647: event_group_tables_affected( null,
6648: l_assignment_action_id,
6649: null,

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

6661: t_proration_type_temp,
6662: t_detailed_output,
6663: p_penserv_mode);
6664:
6665: hr_utility.set_location(l_proc, 40);
6666:
6667: hr_utility.set_location(l_proc, 900);
6668: END entries_affected;
6669:

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

6663: p_penserv_mode);
6664:
6665: hr_utility.set_location(l_proc, 40);
6666:
6667: hr_utility.set_location(l_proc, 900);
6668: END entries_affected;
6669:
6670:
6671: begin