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.HXC_TIMEKEEPER_UTILITIES dependencies on HR_UTILITY

Line 3: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY hxc_timekeeper_utilities AS
2: /* $Header: hxctkutil.pkb 120.30 2011/12/23 12:45:26 jnerella ship $ */
3: g_debug boolean := hr_utility.debug_enabled;
4: -------------------------------------------------------------------------------
5: -- this procedure add a block in the block_table
6: -------- -----------------------------------------------------------------------
7: PROCEDURE add_block (

Line 96: hr_utility.trace('l_block_index1 = '||l_block_index);

92: IF p_timecard_index_info.EXISTS (p_timecard_id) THEN
93: l_block_index := p_timecard_index_info (p_timecard_id).time_block_row_index;
94:
95: if g_debug then
96: hr_utility.trace('l_block_index1 = '||l_block_index);
97: end if;
98: --it is an update and we don't have to change detae from or date to
99: IF p_date_from IS NULL AND p_date_to IS NULL THEN
100: l_date_from := p_timecard (l_block_index).date_from;

Line 124: hr_utility.trace('l_block_index2 = '||l_block_index);

120: ELSE
121: p_timecard.EXTEND;
122: l_block_index := p_timecard.LAST;
123: if g_debug then
124: hr_utility.trace('l_block_index2 = '||l_block_index);
125: end if;
126:
127: END IF;
128:

Line 130: hr_utility.trace('Going to create hxc_block_type');

126:
127: END IF;
128:
129: if g_debug then
130: hr_utility.trace('Going to create hxc_block_type');
131: end if;
132:
133: p_timecard (l_block_index) := hxc_block_type (
134: p_timecard_id,

Line 159: hr_utility.trace('after create hxc_block_type');

155: l_APPLICATION_SET_ID,
156: NULL
157: );
158: if g_debug then
159: hr_utility.trace('after create hxc_block_type');
160: end if;
161:
162: p_timecard_index_info (p_timecard_id).time_block_row_index := l_block_index;
163:

Line 165: hr_utility.trace('after p_timecard_index_info');

161:
162: p_timecard_index_info (p_timecard_id).time_block_row_index := l_block_index;
163:
164: if g_debug then
165: hr_utility.trace('after p_timecard_index_info');
166: end if;
167:
168: END add_block;
169:

Line 454: g_debug :=hr_utility.debug_enabled;

450: AND z.status = 'I'
451: AND d.descriptive_flexfield_name = 'PA_EXPENDITURE_ITEMS_DESC_FLEX';
452:
453: BEGIN
454: g_debug :=hr_utility.debug_enabled;
455: --get the number say 3 FROM ATTRIBUTE3 using substr function
456: att_dep_item := TO_NUMBER (SUBSTR (p_base_dff, 10));
457: if g_debug then
458: hr_utility.trace('att_dep_item is '||att_dep_item);

Line 458: hr_utility.trace('att_dep_item is '||att_dep_item);

454: g_debug :=hr_utility.debug_enabled;
455: --get the number say 3 FROM ATTRIBUTE3 using substr function
456: att_dep_item := TO_NUMBER (SUBSTR (p_base_dff, 10));
457: if g_debug then
458: hr_utility.trace('att_dep_item is '||att_dep_item);
459: hr_utility.trace('in detail is '||p_insert_detail.attr_id_3);
460: end if;
461: ---depending upon the number select id value from the timecard block
462: -- for 3 it will be attr_id_3

Line 459: hr_utility.trace('in detail is '||p_insert_detail.attr_id_3);

455: --get the number say 3 FROM ATTRIBUTE3 using substr function
456: att_dep_item := TO_NUMBER (SUBSTR (p_base_dff, 10));
457: if g_debug then
458: hr_utility.trace('att_dep_item is '||att_dep_item);
459: hr_utility.trace('in detail is '||p_insert_detail.attr_id_3);
460: end if;
461: ---depending upon the number select id value from the timecard block
462: -- for 3 it will be attr_id_3
463: IF att_dep_item = 1 THEN

Line 508: hr_utility.trace('new cat is '||new_att_catg);

504: new_att_catg := p_insert_detail.attr_id_20;
505: END IF;
506:
507: if g_debug then
508: hr_utility.trace('new cat is '||new_att_catg);
509: end if;
510: IF new_att_catg IS NOT NULL THEN
511: l_reference_field := NULL;
512: if g_debug then

Line 513: hr_utility.trace('new cat is '||new_att_catg);

509: end if;
510: IF new_att_catg IS NOT NULL THEN
511: l_reference_field := NULL;
512: if g_debug then
513: hr_utility.trace('new cat is '||new_att_catg);
514: end if;
515: OPEN c_reference_field;
516: FETCH c_reference_field INTO l_reference_field;
517: CLOSE c_reference_field;

Line 576: hr_utility.trace('return new cat is '||new_att_catg);

572: FROM DUAL;
573: end if;
574: end if;*/
575: if g_debug then
576: hr_utility.trace('return new cat is '||new_att_catg);
577: end if;
578: RETURN (new_att_catg);
579: END;
580:

Line 1058: g_debug :=hr_utility.debug_enabled;

1054: l_emp_start_date DATE;
1055: l_emp_terminate_date DATE;
1056: l_audit_enabled VARCHAR2 (150);
1057: BEGIN
1058: g_debug :=hr_utility.debug_enabled;
1059: newtab.DELETE;
1060: if g_debug then
1061: hr_utility.trace('p_resource_id '||p_resource_id);
1062: hr_utility.trace('p_end_date'||to_date(p_end_date,'dd-mm-rrrr'));

Line 1061: hr_utility.trace('p_resource_id '||p_resource_id);

1057: BEGIN
1058: g_debug :=hr_utility.debug_enabled;
1059: newtab.DELETE;
1060: if g_debug then
1061: hr_utility.trace('p_resource_id '||p_resource_id);
1062: hr_utility.trace('p_end_date'||to_date(p_end_date,'dd-mm-rrrr'));
1063: hr_utility.trace('start '||to_date(p_start_date,'dd-mm-rrrr'));
1064: end if;
1065: l_emp_negpref := NULL;

Line 1062: hr_utility.trace('p_end_date'||to_date(p_end_date,'dd-mm-rrrr'));

1058: g_debug :=hr_utility.debug_enabled;
1059: newtab.DELETE;
1060: if g_debug then
1061: hr_utility.trace('p_resource_id '||p_resource_id);
1062: hr_utility.trace('p_end_date'||to_date(p_end_date,'dd-mm-rrrr'));
1063: hr_utility.trace('start '||to_date(p_start_date,'dd-mm-rrrr'));
1064: end if;
1065: l_emp_negpref := NULL;
1066: l_emp_recpref := NULL;

Line 1063: hr_utility.trace('start '||to_date(p_start_date,'dd-mm-rrrr'));

1059: newtab.DELETE;
1060: if g_debug then
1061: hr_utility.trace('p_resource_id '||p_resource_id);
1062: hr_utility.trace('p_end_date'||to_date(p_end_date,'dd-mm-rrrr'));
1063: hr_utility.trace('start '||to_date(p_start_date,'dd-mm-rrrr'));
1064: end if;
1065: l_emp_negpref := NULL;
1066: l_emp_recpref := NULL;
1067: l_emp_appstyle := NULL;

Line 1099: hr_utility.trace(' just checking cout'||p_spemp_tc_info.count);

1095: l_audit_enabled
1096: );
1097:
1098: if g_debug then
1099: hr_utility.trace(' just checking cout'||p_spemp_tc_info.count);
1100: end if;
1101: IF p_spemp_tc_info.COUNT > 0 THEN --this means the person is a mid period change
1102: --and we need to split the timecard.
1103: if g_debug then

Line 1104: hr_utility.trace('get the periods');

1100: end if;
1101: IF p_spemp_tc_info.COUNT > 0 THEN --this means the person is a mid period change
1102: --and we need to split the timecard.
1103: if g_debug then
1104: hr_utility.trace('get the periods');
1105: end if;
1106:
1107: get_resource_time_periods (
1108: p_resource_id => p_resource_id,

Line 1120: hr_utility.trace('newtab.count'||newtab.count);

1116: );
1117: --New tab contains the timecard periods in that range through which
1118: --we loop and save the timecard
1119: if g_debug then
1120: hr_utility.trace('newtab.count'||newtab.count);
1121: end if;
1122: emp_tab_index := p_spemp_tc_info.FIRST;
1123:
1124: LOOP

Line 1128: hr_utility.trace(emp_tab_index);

1124: LOOP
1125: EXIT WHEN NOT p_spemp_tc_info.EXISTS (emp_tab_index);
1126:
1127: if g_debug then
1128: hr_utility.trace(emp_tab_index);
1129: end if;
1130: IF TO_NUMBER (emp_tab_index) < TO_NUMBER (TO_CHAR (TO_DATE (p_start_date, 'dd-mm-rrrr'), 'J'))
1131: OR TO_NUMBER (emp_tab_index) > TO_NUMBER (TO_CHAR (TO_DATE (p_end_date, 'dd-mm-rrrr'), 'J')) THEN
1132: --remove the rows from the pl/sql table table which are out of range

Line 1137: hr_utility.trace('in delete emptab ');

1133: --incomplete timecard
1134: IF newtab.EXISTS (emp_tab_index) THEN
1135: newtab.DELETE (emp_tab_index);
1136: if g_debug then
1137: hr_utility.trace('in delete emptab ');
1138: end if;
1139: END IF;
1140: END IF;
1141:

Line 1147: hr_utility.trace('mid hire employee1 ');

1143: END LOOP;
1144: ELSE
1145: IF TRUNC (p_start_date) < l_emp_start_date THEN -- Bug 13489321
1146: if g_debug then
1147: hr_utility.trace('mid hire employee1 ');
1148: hr_utility.trace('p_start_date'|| l_emp_start_date);
1149: end if;
1150: newtab (TO_NUMBER (TO_CHAR (l_emp_start_date, 'J'))).start_date := l_emp_start_date; --Bug 13489321
1151: /* changes done by senthil for emp terminate enhancement*/

Line 1148: hr_utility.trace('p_start_date'|| l_emp_start_date);

1144: ELSE
1145: IF TRUNC (p_start_date) < l_emp_start_date THEN -- Bug 13489321
1146: if g_debug then
1147: hr_utility.trace('mid hire employee1 ');
1148: hr_utility.trace('p_start_date'|| l_emp_start_date);
1149: end if;
1150: newtab (TO_NUMBER (TO_CHAR (l_emp_start_date, 'J'))).start_date := l_emp_start_date; --Bug 13489321
1151: /* changes done by senthil for emp terminate enhancement*/
1152: IF TRUNC (p_end_date) > nvl(l_emp_terminate_date,p_end_date) THEN --Bug 13489321

Line 1154: hr_utility.trace('Terminated employee ');

1150: newtab (TO_NUMBER (TO_CHAR (l_emp_start_date, 'J'))).start_date := l_emp_start_date; --Bug 13489321
1151: /* changes done by senthil for emp terminate enhancement*/
1152: IF TRUNC (p_end_date) > nvl(l_emp_terminate_date,p_end_date) THEN --Bug 13489321
1153: if g_debug then
1154: hr_utility.trace('Terminated employee ');
1155: hr_utility.trace('p_end_date'|| nvl(l_emp_terminate_date,p_end_date));
1156: end if;
1157: newtab (TO_NUMBER (TO_CHAR (l_emp_start_date, 'J'))).end_date := nvl(l_emp_terminate_date,p_end_date); --Bug 13489321
1158: else

Line 1155: hr_utility.trace('p_end_date'|| nvl(l_emp_terminate_date,p_end_date));

1151: /* changes done by senthil for emp terminate enhancement*/
1152: IF TRUNC (p_end_date) > nvl(l_emp_terminate_date,p_end_date) THEN --Bug 13489321
1153: if g_debug then
1154: hr_utility.trace('Terminated employee ');
1155: hr_utility.trace('p_end_date'|| nvl(l_emp_terminate_date,p_end_date));
1156: end if;
1157: newtab (TO_NUMBER (TO_CHAR (l_emp_start_date, 'J'))).end_date := nvl(l_emp_terminate_date,p_end_date); --Bug 13489321
1158: else
1159: if g_debug then

Line 1160: hr_utility.trace(' Normal employee ');

1156: end if;
1157: newtab (TO_NUMBER (TO_CHAR (l_emp_start_date, 'J'))).end_date := nvl(l_emp_terminate_date,p_end_date); --Bug 13489321
1158: else
1159: if g_debug then
1160: hr_utility.trace(' Normal employee ');
1161: hr_utility.trace('p_end_date'|| p_end_date);
1162: end if;
1163: newtab (TO_NUMBER (TO_CHAR (l_emp_start_date, 'J'))).end_date := p_end_date; --Bug 13489321
1164: end if;

Line 1161: hr_utility.trace('p_end_date'|| p_end_date);

1157: newtab (TO_NUMBER (TO_CHAR (l_emp_start_date, 'J'))).end_date := nvl(l_emp_terminate_date,p_end_date); --Bug 13489321
1158: else
1159: if g_debug then
1160: hr_utility.trace(' Normal employee ');
1161: hr_utility.trace('p_end_date'|| p_end_date);
1162: end if;
1163: newtab (TO_NUMBER (TO_CHAR (l_emp_start_date, 'J'))).end_date := p_end_date; --Bug 13489321
1164: end if;
1165: /* end of changes made by senthil */

Line 1168: hr_utility.trace(' Normal employee ');

1164: end if;
1165: /* end of changes made by senthil */
1166: ELSE
1167: if g_debug then
1168: hr_utility.trace(' Normal employee ');
1169: hr_utility.trace('p_start_date'|| p_start_date);
1170: end if;
1171: newtab (TO_NUMBER (TO_CHAR (p_start_date, 'J'))).start_date := p_start_date; --Bug 13489321
1172: /* changes done by senthil for emp terminate enhancement*/

Line 1169: hr_utility.trace('p_start_date'|| p_start_date);

1165: /* end of changes made by senthil */
1166: ELSE
1167: if g_debug then
1168: hr_utility.trace(' Normal employee ');
1169: hr_utility.trace('p_start_date'|| p_start_date);
1170: end if;
1171: newtab (TO_NUMBER (TO_CHAR (p_start_date, 'J'))).start_date := p_start_date; --Bug 13489321
1172: /* changes done by senthil for emp terminate enhancement*/
1173: IF TRUNC (p_end_date) > nvl(l_emp_terminate_date,p_end_date) THEN --Bug 13489321

Line 1175: hr_utility.trace('Terminated employee ');

1171: newtab (TO_NUMBER (TO_CHAR (p_start_date, 'J'))).start_date := p_start_date; --Bug 13489321
1172: /* changes done by senthil for emp terminate enhancement*/
1173: IF TRUNC (p_end_date) > nvl(l_emp_terminate_date,p_end_date) THEN --Bug 13489321
1174: if g_debug then
1175: hr_utility.trace('Terminated employee ');
1176: hr_utility.trace('p_end_date'|| nvl(l_emp_terminate_date,p_end_date));
1177: end if;
1178: newtab (TO_NUMBER (TO_CHAR (p_start_date, 'J'))).end_date := nvl(l_emp_terminate_date,p_end_date);
1179: else

Line 1176: hr_utility.trace('p_end_date'|| nvl(l_emp_terminate_date,p_end_date));

1172: /* changes done by senthil for emp terminate enhancement*/
1173: IF TRUNC (p_end_date) > nvl(l_emp_terminate_date,p_end_date) THEN --Bug 13489321
1174: if g_debug then
1175: hr_utility.trace('Terminated employee ');
1176: hr_utility.trace('p_end_date'|| nvl(l_emp_terminate_date,p_end_date));
1177: end if;
1178: newtab (TO_NUMBER (TO_CHAR (p_start_date, 'J'))).end_date := nvl(l_emp_terminate_date,p_end_date);
1179: else
1180: if g_debug then

Line 1181: hr_utility.trace(' Normal employee ');

1177: end if;
1178: newtab (TO_NUMBER (TO_CHAR (p_start_date, 'J'))).end_date := nvl(l_emp_terminate_date,p_end_date);
1179: else
1180: if g_debug then
1181: hr_utility.trace(' Normal employee ');
1182: hr_utility.trace('p_end_date'|| p_end_date);
1183: end if;
1184: newtab (TO_NUMBER (TO_CHAR (p_start_date, 'J'))).end_date := p_end_date;
1185: end if;

Line 1182: hr_utility.trace('p_end_date'|| p_end_date);

1178: newtab (TO_NUMBER (TO_CHAR (p_start_date, 'J'))).end_date := nvl(l_emp_terminate_date,p_end_date);
1179: else
1180: if g_debug then
1181: hr_utility.trace(' Normal employee ');
1182: hr_utility.trace('p_end_date'|| p_end_date);
1183: end if;
1184: newtab (TO_NUMBER (TO_CHAR (p_start_date, 'J'))).end_date := p_end_date;
1185: end if;
1186: /* end of changes made by senthil */

Line 1191: hr_utility.trace('newtab.count'||newtab.count);

1187: end if;
1188:
1189: END IF;
1190: if g_debug then
1191: hr_utility.trace('newtab.count'||newtab.count);
1192: end if;
1193: p_tc_list := newtab;
1194:
1195: if g_debug then

Line 1196: hr_utility.trace('p_tc_list.count'||p_tc_list.count);

1192: end if;
1193: p_tc_list := newtab;
1194:
1195: if g_debug then
1196: hr_utility.trace('p_tc_list.count'||p_tc_list.count);
1197: end if;
1198: END;
1199:
1200:

Line 1694: g_debug :=hr_utility.debug_enabled;

1690: l_first_rowindex NUMBER(15);
1691: l_last_rowindex NUMBER(15);
1692: l_term_tc_exists NUMBER(15);
1693: BEGIN
1694: g_debug :=hr_utility.debug_enabled;
1695: --
1696: -- look for the recurring period type
1697: --
1698: OPEN c_period_info (p_recurring_period_id => p_recurring_period_id);

Line 1726: hr_utility.trace('terminate end_date'||NVL(l_person_effective_end_date,p_max_date_in_futur));

1722: END IF;
1723: --2789497
1724: /* changes done by senthil for emp terminate enhancement*/
1725: IF g_debug THEN
1726: hr_utility.trace('terminate end_date'||NVL(l_person_effective_end_date,p_max_date_in_futur));
1727: END if;
1728: IF p_max_date_in_futur >= NVL(l_person_effective_end_date,p_max_date_in_futur) THEN
1729: l_emp_max_date_in_futur := NVL(l_person_effective_end_date,p_max_date_in_futur);
1730: ELSE

Line 1734: hr_utility.trace('p_max_date_in_futur'||p_max_date_in_futur);

1730: ELSE
1731: l_emp_max_date_in_futur := p_max_date_in_futur;
1732: END IF;
1733: IF g_debug THEN
1734: hr_utility.trace('p_max_date_in_futur'||p_max_date_in_futur);
1735: hr_utility.trace('l_emp_max_date_in_futur'||l_emp_max_date_in_futur);
1736: END if;
1737: /* Changes done by senthil */
1738:

Line 1735: hr_utility.trace('l_emp_max_date_in_futur'||l_emp_max_date_in_futur);

1731: l_emp_max_date_in_futur := p_max_date_in_futur;
1732: END IF;
1733: IF g_debug THEN
1734: hr_utility.trace('p_max_date_in_futur'||p_max_date_in_futur);
1735: hr_utility.trace('l_emp_max_date_in_futur'||l_emp_max_date_in_futur);
1736: END if;
1737: /* Changes done by senthil */
1738:
1739: ELSE

Line 1894: hr_utility.trace('###################');

1890: LOOP
1891: EXIT WHEN NOT l_temp_periods.EXISTS (l_index);
1892: if g_debug then
1893:
1894: hr_utility.trace('###################');
1895: hr_utility.trace('#### NEW PERIOD #########');
1896: hr_utility.trace('###################');
1897: end if;
1898: l_period_start := l_temp_periods (l_index).start_date;

Line 1895: hr_utility.trace('#### NEW PERIOD #########');

1891: EXIT WHEN NOT l_temp_periods.EXISTS (l_index);
1892: if g_debug then
1893:
1894: hr_utility.trace('###################');
1895: hr_utility.trace('#### NEW PERIOD #########');
1896: hr_utility.trace('###################');
1897: end if;
1898: l_period_start := l_temp_periods (l_index).start_date;
1899: l_period_end := l_temp_periods (l_index).end_date;

Line 1896: hr_utility.trace('###################');

1892: if g_debug then
1893:
1894: hr_utility.trace('###################');
1895: hr_utility.trace('#### NEW PERIOD #########');
1896: hr_utility.trace('###################');
1897: end if;
1898: l_period_start := l_temp_periods (l_index).start_date;
1899: l_period_end := l_temp_periods (l_index).end_date;
1900: -- help to know if during the process the period

Line 1912: hr_utility.trace('####NEW TIMECARD');

1908: EXIT WHEN NOT l_timecard_tab.EXISTS (l_index_timecard_tab);
1909: l_tc_period_start_date := l_timecard_tab (l_index_timecard_tab).start_date;
1910: l_tc_period_end_date := l_timecard_tab (l_index_timecard_tab).end_date;
1911: if g_debug then
1912: hr_utility.trace('####NEW TIMECARD');
1913: hr_utility.trace('l_period_start :'||l_period_start);
1914: hr_utility.trace('l_period_end :'||l_period_end);
1915: hr_utility.trace('l_tc_period_start_date :'||to_char(l_tc_period_start_date,'DD-MON-YYYY'));
1916: hr_utility.trace('l_tc_period_end_date :'||to_char(l_tc_period_end_date,'DD-MON-YYYY'));

Line 1913: hr_utility.trace('l_period_start :'||l_period_start);

1909: l_tc_period_start_date := l_timecard_tab (l_index_timecard_tab).start_date;
1910: l_tc_period_end_date := l_timecard_tab (l_index_timecard_tab).end_date;
1911: if g_debug then
1912: hr_utility.trace('####NEW TIMECARD');
1913: hr_utility.trace('l_period_start :'||l_period_start);
1914: hr_utility.trace('l_period_end :'||l_period_end);
1915: hr_utility.trace('l_tc_period_start_date :'||to_char(l_tc_period_start_date,'DD-MON-YYYY'));
1916: hr_utility.trace('l_tc_period_end_date :'||to_char(l_tc_period_end_date,'DD-MON-YYYY'));
1917: hr_utility.trace('###################');

Line 1914: hr_utility.trace('l_period_end :'||l_period_end);

1910: l_tc_period_end_date := l_timecard_tab (l_index_timecard_tab).end_date;
1911: if g_debug then
1912: hr_utility.trace('####NEW TIMECARD');
1913: hr_utility.trace('l_period_start :'||l_period_start);
1914: hr_utility.trace('l_period_end :'||l_period_end);
1915: hr_utility.trace('l_tc_period_start_date :'||to_char(l_tc_period_start_date,'DD-MON-YYYY'));
1916: hr_utility.trace('l_tc_period_end_date :'||to_char(l_tc_period_end_date,'DD-MON-YYYY'));
1917: hr_utility.trace('###################');
1918: end if;

Line 1915: hr_utility.trace('l_tc_period_start_date :'||to_char(l_tc_period_start_date,'DD-MON-YYYY'));

1911: if g_debug then
1912: hr_utility.trace('####NEW TIMECARD');
1913: hr_utility.trace('l_period_start :'||l_period_start);
1914: hr_utility.trace('l_period_end :'||l_period_end);
1915: hr_utility.trace('l_tc_period_start_date :'||to_char(l_tc_period_start_date,'DD-MON-YYYY'));
1916: hr_utility.trace('l_tc_period_end_date :'||to_char(l_tc_period_end_date,'DD-MON-YYYY'));
1917: hr_utility.trace('###################');
1918: end if;
1919: IF TRUNC (l_tc_period_start_date) > TRUNC (l_period_start)

Line 1916: hr_utility.trace('l_tc_period_end_date :'||to_char(l_tc_period_end_date,'DD-MON-YYYY'));

1912: hr_utility.trace('####NEW TIMECARD');
1913: hr_utility.trace('l_period_start :'||l_period_start);
1914: hr_utility.trace('l_period_end :'||l_period_end);
1915: hr_utility.trace('l_tc_period_start_date :'||to_char(l_tc_period_start_date,'DD-MON-YYYY'));
1916: hr_utility.trace('l_tc_period_end_date :'||to_char(l_tc_period_end_date,'DD-MON-YYYY'));
1917: hr_utility.trace('###################');
1918: end if;
1919: IF TRUNC (l_tc_period_start_date) > TRUNC (l_period_start)
1920: AND TRUNC (l_tc_period_end_date) < TRUNC (l_period_end) THEN

Line 1917: hr_utility.trace('###################');

1913: hr_utility.trace('l_period_start :'||l_period_start);
1914: hr_utility.trace('l_period_end :'||l_period_end);
1915: hr_utility.trace('l_tc_period_start_date :'||to_char(l_tc_period_start_date,'DD-MON-YYYY'));
1916: hr_utility.trace('l_tc_period_end_date :'||to_char(l_tc_period_end_date,'DD-MON-YYYY'));
1917: hr_utility.trace('###################');
1918: end if;
1919: IF TRUNC (l_tc_period_start_date) > TRUNC (l_period_start)
1920: AND TRUNC (l_tc_period_end_date) < TRUNC (l_period_end) THEN
1921: -- the timecard is in the middle of a period

Line 1926: hr_utility.trace('case 1 :');

1922: -- we are splitting the period in 2 + the timecard which
1923: -- is already there.
1924: -- before the timecard
1925: if g_debug then
1926: hr_utility.trace('case 1 :');
1927: end if;
1928: p_periodtab (TO_NUMBER (TO_CHAR (l_period_start, 'J'))).start_date := l_period_start;
1929: p_periodtab (TO_NUMBER (TO_CHAR (l_period_start, 'J'))).end_date := l_tc_period_start_date - 1;
1930: if g_debug then

Line 1931: hr_utility.trace('l_tab_period_start_date :'||to_char(l_period_start,'DD-MON-YYYY'));

1927: end if;
1928: p_periodtab (TO_NUMBER (TO_CHAR (l_period_start, 'J'))).start_date := l_period_start;
1929: p_periodtab (TO_NUMBER (TO_CHAR (l_period_start, 'J'))).end_date := l_tc_period_start_date - 1;
1930: if g_debug then
1931: hr_utility.trace('l_tab_period_start_date :'||to_char(l_period_start,'DD-MON-YYYY'));
1932: hr_utility.trace('l_tab_period_end_date :'||to_char(l_tc_period_start_date - 1,'DD-MON-YYYY'));
1933: end if;
1934: -- after the timecard
1935: p_periodtab (TO_NUMBER (TO_CHAR (l_tc_period_end_date + 1, 'J'))).start_date :=

Line 1932: hr_utility.trace('l_tab_period_end_date :'||to_char(l_tc_period_start_date - 1,'DD-MON-YYYY'));

1928: p_periodtab (TO_NUMBER (TO_CHAR (l_period_start, 'J'))).start_date := l_period_start;
1929: p_periodtab (TO_NUMBER (TO_CHAR (l_period_start, 'J'))).end_date := l_tc_period_start_date - 1;
1930: if g_debug then
1931: hr_utility.trace('l_tab_period_start_date :'||to_char(l_period_start,'DD-MON-YYYY'));
1932: hr_utility.trace('l_tab_period_end_date :'||to_char(l_tc_period_start_date - 1,'DD-MON-YYYY'));
1933: end if;
1934: -- after the timecard
1935: p_periodtab (TO_NUMBER (TO_CHAR (l_tc_period_end_date + 1, 'J'))).start_date :=
1936: l_tc_period_end_date + 1;

Line 1941: hr_utility.trace('l_tab_period_start_date :'||to_char(l_tc_period_end_date + 1,'DD-MON-YYYY'));

1937: p_periodtab (TO_NUMBER (TO_CHAR (l_tc_period_end_date + 1, 'J'))).end_date := l_period_end;
1938: -- now we are overritting the start period
1939: l_period_start := l_tc_period_end_date + 1;
1940: if g_debug then
1941: hr_utility.trace('l_tab_period_start_date :'||to_char(l_tc_period_end_date + 1,'DD-MON-YYYY'));
1942: hr_utility.trace('l_tab_period_end_date :'||to_char(l_period_end,'DD-MON-YYYY'));
1943: end if;
1944: l_touch_period_in_tc := TRUE;
1945: ELSIF TRUNC (l_tc_period_start_date) < TRUNC (l_period_start)

Line 1942: hr_utility.trace('l_tab_period_end_date :'||to_char(l_period_end,'DD-MON-YYYY'));

1938: -- now we are overritting the start period
1939: l_period_start := l_tc_period_end_date + 1;
1940: if g_debug then
1941: hr_utility.trace('l_tab_period_start_date :'||to_char(l_tc_period_end_date + 1,'DD-MON-YYYY'));
1942: hr_utility.trace('l_tab_period_end_date :'||to_char(l_period_end,'DD-MON-YYYY'));
1943: end if;
1944: l_touch_period_in_tc := TRUE;
1945: ELSIF TRUNC (l_tc_period_start_date) < TRUNC (l_period_start)
1946: AND TRUNC (l_tc_period_end_date) > TRUNC (l_period_end) THEN

Line 1951: hr_utility.trace('case 2 :');

1947: -- the timecard is outside of the period so we have nothing to
1948: -- do
1949: l_touch_period_in_tc := TRUE;
1950: if g_debug then
1951: hr_utility.trace('case 2 :');
1952: end if;
1953: ELSIF TRUNC (l_tc_period_start_date) > TRUNC (l_period_start)
1954: AND TRUNC (l_tc_period_start_date) <= TRUNC (l_period_end)
1955: AND TRUNC (l_tc_period_end_date) >= TRUNC (l_period_end) THEN

Line 1957: hr_utility.trace('case 3 :');

1953: ELSIF TRUNC (l_tc_period_start_date) > TRUNC (l_period_start)
1954: AND TRUNC (l_tc_period_start_date) <= TRUNC (l_period_end)
1955: AND TRUNC (l_tc_period_end_date) >= TRUNC (l_period_end) THEN
1956: if g_debug then
1957: hr_utility.trace('case 3 :');
1958: end if;
1959: -- we are splitting the period in 2
1960: -- we are adding the period just before the timecard
1961: p_periodtab (TO_NUMBER (TO_CHAR (l_period_start, 'J'))).start_date := l_period_start;

Line 1967: hr_utility.trace('l_tab_period_start_date :'||to_char(l_period_start,'DD-MON-YYYY'));

1963: -- in this case we can exit of the loop;
1964: l_index_timecard_tab := l_timecard_tab.LAST;
1965: l_touch_period_in_tc := TRUE;
1966: if g_debug then
1967: hr_utility.trace('l_tab_period_start_date :'||to_char(l_period_start,'DD-MON-YYYY'));
1968: hr_utility.trace('l_tab_period_end_date :'||to_char(l_tc_period_start_date - 1,'DD-MON-YYYY'));
1969: end if;
1970: ELSIF TRUNC (l_tc_period_start_date) <= TRUNC (l_period_start)
1971: AND TRUNC (l_tc_period_end_date) >= TRUNC (l_period_start)

Line 1968: hr_utility.trace('l_tab_period_end_date :'||to_char(l_tc_period_start_date - 1,'DD-MON-YYYY'));

1964: l_index_timecard_tab := l_timecard_tab.LAST;
1965: l_touch_period_in_tc := TRUE;
1966: if g_debug then
1967: hr_utility.trace('l_tab_period_start_date :'||to_char(l_period_start,'DD-MON-YYYY'));
1968: hr_utility.trace('l_tab_period_end_date :'||to_char(l_tc_period_start_date - 1,'DD-MON-YYYY'));
1969: end if;
1970: ELSIF TRUNC (l_tc_period_start_date) <= TRUNC (l_period_start)
1971: AND TRUNC (l_tc_period_end_date) >= TRUNC (l_period_start)
1972: AND TRUNC (l_tc_period_end_date) < TRUNC (l_period_end) THEN

Line 1974: hr_utility.trace('case 4 :');

1970: ELSIF TRUNC (l_tc_period_start_date) <= TRUNC (l_period_start)
1971: AND TRUNC (l_tc_period_end_date) >= TRUNC (l_period_start)
1972: AND TRUNC (l_tc_period_end_date) < TRUNC (l_period_end) THEN
1973: if g_debug then
1974: hr_utility.trace('case 4 :');
1975: end if;
1976: -- we are splitting the period in 2
1977: -- we are adding the period just before the timecard
1978: p_periodtab (TO_NUMBER (TO_CHAR (l_tc_period_end_date + 1, 'J'))).start_date :=

Line 1982: hr_utility.trace('l_tab_period_start_date :'||to_char(l_tc_period_end_date + 1,'DD-MON-YYYY'));

1978: p_periodtab (TO_NUMBER (TO_CHAR (l_tc_period_end_date + 1, 'J'))).start_date :=
1979: l_tc_period_end_date + 1;
1980: p_periodtab (TO_NUMBER (TO_CHAR (l_tc_period_end_date + 1, 'J'))).end_date := l_period_end;
1981: if g_debug then
1982: hr_utility.trace('l_tab_period_start_date :'||to_char(l_tc_period_end_date + 1,'DD-MON-YYYY'));
1983: hr_utility.trace('l_tab_period_end_date :'||to_char(l_period_end,'DD-MON-YYYY'));
1984: end if;
1985: -- now we are overritting the end/start period
1986: l_period_start := l_tc_period_end_date + 1;

Line 1983: hr_utility.trace('l_tab_period_end_date :'||to_char(l_period_end,'DD-MON-YYYY'));

1979: l_tc_period_end_date + 1;
1980: p_periodtab (TO_NUMBER (TO_CHAR (l_tc_period_end_date + 1, 'J'))).end_date := l_period_end;
1981: if g_debug then
1982: hr_utility.trace('l_tab_period_start_date :'||to_char(l_tc_period_end_date + 1,'DD-MON-YYYY'));
1983: hr_utility.trace('l_tab_period_end_date :'||to_char(l_period_end,'DD-MON-YYYY'));
1984: end if;
1985: -- now we are overritting the end/start period
1986: l_period_start := l_tc_period_end_date + 1;
1987: l_touch_period_in_tc := TRUE;

Line 1995: hr_utility.trace('case 5 :');

1991: OR ( TRUNC (l_tc_period_start_date) <= TRUNC (l_period_start)
1992: AND TRUNC (l_tc_period_end_date) = TRUNC (l_period_end)
1993: ) THEN
1994: if g_debug then
1995: hr_utility.trace('case 5 :');
1996: end if;
1997: -- we are splitting the period in 2
1998: -- we are adding the period just before the timecard
1999: p_periodtab (TO_NUMBER (TO_CHAR (l_tc_period_start_date, 'J'))).start_date :=

Line 2017: hr_utility.trace('case 6 :');

2013:
2014:
2015: IF NOT (l_touch_period_in_tc) THEN
2016: if g_debug then
2017: hr_utility.trace('case 6 :');
2018: end if;
2019: -- we are adding the period
2020: p_periodtab (TO_NUMBER (TO_CHAR (l_period_start, 'J'))).start_date := l_period_start;
2021: p_periodtab (TO_NUMBER (TO_CHAR (l_period_start, 'J'))).end_date := l_period_end;

Line 2025: hr_utility.trace('count'||p_periodtab.count);

2021: p_periodtab (TO_NUMBER (TO_CHAR (l_period_start, 'J'))).end_date := l_period_end;
2022: END IF;
2023:
2024: if g_debug then
2025: hr_utility.trace('count'||p_periodtab.count);
2026: end if;
2027: l_index := l_temp_periods.NEXT (l_index);
2028: END LOOP;
2029:

Line 2102: g_debug :=hr_utility.debug_enabled;

2098: VARCHAR2 (72);
2099: l_tc_status hxc_time_building_blocks.approval_status%TYPE;
2100: l_dummy NUMBER (1);
2101: BEGIN
2102: g_debug :=hr_utility.debug_enabled;
2103: if g_debug then
2104: l_proc := 'hxc_timekeeper_utilities'
2105: || 'tc_edit_allowed';
2106: hr_utility.set_location('Entering '||l_proc, 10);

Line 2106: hr_utility.set_location('Entering '||l_proc, 10);

2102: g_debug :=hr_utility.debug_enabled;
2103: if g_debug then
2104: l_proc := 'hxc_timekeeper_utilities'
2105: || 'tc_edit_allowed';
2106: hr_utility.set_location('Entering '||l_proc, 10);
2107: end if;
2108: --l_tc_status := hxc_timecard_search_pkg.get_timecard_status_code(p_timecard_id,p_Timecard_Ovn);
2109: l_tc_status := p_timecard_status;
2110:

Line 2113: hr_utility.set_location('Processing '||l_proc, 20);

2109: l_tc_status := p_timecard_status;
2110:
2111:
2112: if g_debug then
2113: hr_utility.set_location('Processing '||l_proc, 20);
2114: end if;
2115: IF (p_edit_allowed_preference = 'NEW_WORKING_REJECTED') THEN
2116: if g_debug then
2117: hr_utility.set_location('Processing '||l_proc, 30);

Line 2117: hr_utility.set_location('Processing '||l_proc, 30);

2113: hr_utility.set_location('Processing '||l_proc, 20);
2114: end if;
2115: IF (p_edit_allowed_preference = 'NEW_WORKING_REJECTED') THEN
2116: if g_debug then
2117: hr_utility.set_location('Processing '||l_proc, 30);
2118: end if;
2119: IF ((l_tc_status = 'REJECTED') OR (l_tc_status = 'WORKING')) THEN
2120: p_edit_allowed := 'TRUE';
2121: ELSE

Line 2126: hr_utility.set_location('Processing '||l_proc, 40);

2122: p_edit_allowed := 'FALSE';
2123: END IF;
2124: ELSIF (p_edit_allowed_preference = 'SUBMITTED') THEN
2125: if g_debug then
2126: hr_utility.set_location('Processing '||l_proc, 40);
2127: end if;
2128: IF ((l_tc_status = 'REJECTED') OR (l_tc_status = 'WORKING') OR (l_tc_status = 'SUBMITTED')) THEN
2129: p_edit_allowed := 'TRUE';
2130: ELSE

Line 2135: hr_utility.set_location('Processing '||l_proc, 50);

2131: p_edit_allowed := 'FALSE';
2132: END IF;
2133: ELSIF (p_edit_allowed_preference = 'APPROVALS_INITIATED') THEN
2134: if g_debug then
2135: hr_utility.set_location('Processing '||l_proc, 50);
2136: end if;
2137: -- all we need to do here is check that this timecard
2138: -- has not been transferred successfully to any recipient
2139: -- applications

Line 2150: hr_utility.set_location('Processing '||l_proc, 60);

2146: p_edit_allowed := 'TRUE';
2147: END IF;
2148: ELSIF (p_edit_allowed_preference = 'RETRO') THEN
2149: if g_debug then
2150: hr_utility.set_location('Processing '||l_proc, 60);
2151: end if;
2152: IF ( (l_tc_status = 'REJECTED')
2153: OR (l_tc_status = 'WORKING')
2154: OR (l_tc_status = 'SUBMITTED')

Line 2164: hr_utility.set_location('Processing '||l_proc, 70);

2160: p_edit_allowed := 'FALSE';
2161: END IF;
2162: ELSE
2163: if g_debug then
2164: hr_utility.set_location('Processing '||l_proc, 70);
2165: end if;
2166: p_edit_allowed := 'FALSE';
2167: END IF;
2168:

Line 2177: hr_utility.set_location('Leaving '||l_proc, 80);

2173: p_edit_allowed := 'TRUE';
2174: END IF;
2175:
2176: if g_debug then
2177: hr_utility.set_location('Leaving '||l_proc, 80);
2178: end if;
2179: END tc_edit_allowed;
2180:
2181: PROCEDURE convert_type_to_message_table (

Line 4213: hr_utility.trace('Entered get_pref_eval_date ');

4209: BEGIN
4210:
4211: if g_debug then
4212:
4213: hr_utility.trace('Entered get_pref_eval_date ');
4214:
4215: end if;
4216:
4217: OPEN active_periods(p_resource_id,

Line 4223: hr_utility.trace('Opened active_periods ');

4219: p_tc_end_date);
4220:
4221: if g_debug then
4222:
4223: hr_utility.trace('Opened active_periods ');
4224:
4225: end if;
4226:
4227: FETCH active_periods into l_start_date, l_end_date;

Line 4231: hr_utility.trace('Fetched active_periods ');

4227: FETCH active_periods into l_start_date, l_end_date;
4228:
4229: if g_debug then
4230:
4231: hr_utility.trace('Fetched active_periods ');
4232: hr_utility.trace('l_start_date = '||l_start_date);
4233: hr_utility.trace('l_end_date = '||l_end_date);
4234: hr_utility.trace('p_tc_start_date = '||p_tc_start_date);
4235: hr_utility.trace('p_tc_end_date = '||p_tc_end_date);

Line 4232: hr_utility.trace('l_start_date = '||l_start_date);

4228:
4229: if g_debug then
4230:
4231: hr_utility.trace('Fetched active_periods ');
4232: hr_utility.trace('l_start_date = '||l_start_date);
4233: hr_utility.trace('l_end_date = '||l_end_date);
4234: hr_utility.trace('p_tc_start_date = '||p_tc_start_date);
4235: hr_utility.trace('p_tc_end_date = '||p_tc_end_date);
4236:

Line 4233: hr_utility.trace('l_end_date = '||l_end_date);

4229: if g_debug then
4230:
4231: hr_utility.trace('Fetched active_periods ');
4232: hr_utility.trace('l_start_date = '||l_start_date);
4233: hr_utility.trace('l_end_date = '||l_end_date);
4234: hr_utility.trace('p_tc_start_date = '||p_tc_start_date);
4235: hr_utility.trace('p_tc_end_date = '||p_tc_end_date);
4236:
4237: end if;

Line 4234: hr_utility.trace('p_tc_start_date = '||p_tc_start_date);

4230:
4231: hr_utility.trace('Fetched active_periods ');
4232: hr_utility.trace('l_start_date = '||l_start_date);
4233: hr_utility.trace('l_end_date = '||l_end_date);
4234: hr_utility.trace('p_tc_start_date = '||p_tc_start_date);
4235: hr_utility.trace('p_tc_end_date = '||p_tc_end_date);
4236:
4237: end if;
4238:

Line 4235: hr_utility.trace('p_tc_end_date = '||p_tc_end_date);

4231: hr_utility.trace('Fetched active_periods ');
4232: hr_utility.trace('l_start_date = '||l_start_date);
4233: hr_utility.trace('l_end_date = '||l_end_date);
4234: hr_utility.trace('p_tc_start_date = '||p_tc_start_date);
4235: hr_utility.trace('p_tc_end_date = '||p_tc_end_date);
4236:
4237: end if;
4238:
4239: if (p_tc_start_date between nvl(l_start_date, hr_general.start_of_time)

Line 4244: hr_utility.trace('Going to return p_tc_start_date ='|| p_tc_start_date);

4240: and nvl(l_end_date, hr_general.end_of_time)) then
4241:
4242: if g_debug then
4243:
4244: hr_utility.trace('Going to return p_tc_start_date ='|| p_tc_start_date);
4245:
4246: end if;
4247:
4248: return p_tc_start_date;

Line 4254: hr_utility.trace('Going to return l_start_date ='|| l_start_date);

4250: else
4251:
4252: if g_debug then
4253:
4254: hr_utility.trace('Going to return l_start_date ='|| l_start_date);
4255:
4256: end if;
4257:
4258:

Line 4279: hr_utility.trace(' Entered hxctkutil.populate_prepop_detail_id_info');

4275:
4276: BEGIN
4277:
4278: if g_debug then
4279: hr_utility.trace(' Entered hxctkutil.populate_prepop_detail_id_info');
4280: end if;
4281:
4282: if (p_timekeeper_data_rec.detail_id_1 is not null and
4283: p_timekeeper_data_rec.detail_id_1 < 0 ) then

Line 4563: hr_utility.trace(' Leaving hxctkutil.populate_prepop_detail_id_info');

4559:
4560: end if;
4561:
4562: if g_debug then
4563: hr_utility.trace(' Leaving hxctkutil.populate_prepop_detail_id_info');
4564: end if;
4565:
4566:
4567: END; -- populate_prepop_detail_id_info

Line 4601: hr_utility.trace('l_day_value = '||l_day_value);

4597: l_day_value:= p_day_value -
4598: (trunc(to_number(p_start_period - p_tc_start))
4599: );
4600: if g_debug then
4601: hr_utility.trace('l_day_value = '||l_day_value);
4602: end if;
4603: -- Take care if Empty Paramter handliing routine
4604:
4605: if g_debug then

Line 4606: hr_utility.trace (' SVG bfore l_detail_id select query');

4602: end if;
4603: -- Take care if Empty Paramter handliing routine
4604:
4605: if g_debug then
4606: hr_utility.trace (' SVG bfore l_detail_id select query');
4607: end if;
4608:
4609: SELECT time_building_block_id
4610: INTO l_detail_id

Line 4637: hr_utility.trace (' SVG after l_detail_id select query');

4633: AND sessionid = userenv('SESSIONID')
4634: AND rownum<2;
4635:
4636: if g_debug then
4637: hr_utility.trace (' SVG after l_detail_id select query');
4638: hr_utility.trace('SVG l_detail_id ='||l_detail_id);
4639: end if;
4640:
4641: return (l_detail_id);

Line 4638: hr_utility.trace('SVG l_detail_id ='||l_detail_id);

4634: AND rownum<2;
4635:
4636: if g_debug then
4637: hr_utility.trace (' SVG after l_detail_id select query');
4638: hr_utility.trace('SVG l_detail_id ='||l_detail_id);
4639: end if;
4640:
4641: return (l_detail_id);
4642:

Line 4717: hr_utility.trace('Before hxc_preference_evaluation.get_tc_resp');

4713:
4714: p_attribute_array:= HXC_ATTRIBUTE_TABLE_TYPE();
4715:
4716: if g_debug then
4717: hr_utility.trace('Before hxc_preference_evaluation.get_tc_resp');
4718: end if;
4719:
4720: hxc_preference_evaluation.get_tc_resp
4721: (p_resource_id,

Line 4728: hr_utility.trace('After hxc_preference_evaluation.get_tc_resp');

4724: l_resp_id,
4725: l_resp_appl_id);
4726:
4727: if g_debug then
4728: hr_utility.trace('After hxc_preference_evaluation.get_tc_resp');
4729: end if;
4730:
4731: l_approval_style_id := hxc_preference_evaluation.resource_preferences(
4732: p_resource_id,

Line 4739: hr_utility.trace('l_approval_style_id = '||l_approval_style_id);

4735: l_resp_id
4736: );
4737:
4738: if g_debug then
4739: hr_utility.trace('l_approval_style_id = '||l_approval_style_id);
4740: end if;
4741:
4742: HXC_RETRIEVE_ABSENCES.add_absence_types ( p_person_id => p_resource_id,
4743: p_start_date => p_start_period,

Line 4755: hr_utility.trace('Entering build_absence_prepop_table');

4751: p_iteration_count => hxc_timekeeper_process.g_resource_prepop_count
4752: );
4753: */
4754: if g_debug then
4755: hr_utility.trace('Entering build_absence_prepop_table');
4756:
4757: hr_utility.trace('BAPT 1');
4758:
4759:

Line 4757: hr_utility.trace('BAPT 1');

4753: */
4754: if g_debug then
4755: hr_utility.trace('Entering build_absence_prepop_table');
4756:
4757: hr_utility.trace('BAPT 1');
4758:
4759:
4760: hr_utility.trace('p_tk_prepop_info.count = '||p_tk_prepop_info.count);
4761:

Line 4760: hr_utility.trace('p_tk_prepop_info.count = '||p_tk_prepop_info.count);

4756:
4757: hr_utility.trace('BAPT 1');
4758:
4759:
4760: hr_utility.trace('p_tk_prepop_info.count = '||p_tk_prepop_info.count);
4761:
4762:
4763:
4764: if p_tk_prepop_info.count>0 then

Line 4771: hr_utility.trace('p_tk_prepop_info(i).ALIAS_VALUE_ID = '||p_tk_prepop_info(i).ALIAS_VALUE_ID);

4767: LOOP
4768:
4769: if p_tk_prepop_info.EXISTS(i) then
4770:
4771: hr_utility.trace('p_tk_prepop_info(i).ALIAS_VALUE_ID = '||p_tk_prepop_info(i).ALIAS_VALUE_ID);
4772: hr_utility.trace('p_tk_prepop_info(i).ITEM_ATTRIBUTE_CATEGORY = '||p_tk_prepop_info(i).ITEM_ATTRIBUTE_CATEGORY);
4773: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_DATE = '||p_tk_prepop_info(i).ABSENCE_DATE);
4774: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_DURATION = '||p_tk_prepop_info(i).ABSENCE_DURATION);
4775: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_START_TIME = '||p_tk_prepop_info(i).ABSENCE_START_TIME);

Line 4772: hr_utility.trace('p_tk_prepop_info(i).ITEM_ATTRIBUTE_CATEGORY = '||p_tk_prepop_info(i).ITEM_ATTRIBUTE_CATEGORY);

4768:
4769: if p_tk_prepop_info.EXISTS(i) then
4770:
4771: hr_utility.trace('p_tk_prepop_info(i).ALIAS_VALUE_ID = '||p_tk_prepop_info(i).ALIAS_VALUE_ID);
4772: hr_utility.trace('p_tk_prepop_info(i).ITEM_ATTRIBUTE_CATEGORY = '||p_tk_prepop_info(i).ITEM_ATTRIBUTE_CATEGORY);
4773: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_DATE = '||p_tk_prepop_info(i).ABSENCE_DATE);
4774: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_DURATION = '||p_tk_prepop_info(i).ABSENCE_DURATION);
4775: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_START_TIME = '||p_tk_prepop_info(i).ABSENCE_START_TIME);
4776: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_STOP_TIME = '||p_tk_prepop_info(i).ABSENCE_STOP_TIME);

Line 4773: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_DATE = '||p_tk_prepop_info(i).ABSENCE_DATE);

4769: if p_tk_prepop_info.EXISTS(i) then
4770:
4771: hr_utility.trace('p_tk_prepop_info(i).ALIAS_VALUE_ID = '||p_tk_prepop_info(i).ALIAS_VALUE_ID);
4772: hr_utility.trace('p_tk_prepop_info(i).ITEM_ATTRIBUTE_CATEGORY = '||p_tk_prepop_info(i).ITEM_ATTRIBUTE_CATEGORY);
4773: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_DATE = '||p_tk_prepop_info(i).ABSENCE_DATE);
4774: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_DURATION = '||p_tk_prepop_info(i).ABSENCE_DURATION);
4775: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_START_TIME = '||p_tk_prepop_info(i).ABSENCE_START_TIME);
4776: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_STOP_TIME = '||p_tk_prepop_info(i).ABSENCE_STOP_TIME);
4777: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_ATTENDANCE_ID = '||p_tk_prepop_info(i).ABSENCE_ATTENDANCE_ID);

Line 4774: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_DURATION = '||p_tk_prepop_info(i).ABSENCE_DURATION);

4770:
4771: hr_utility.trace('p_tk_prepop_info(i).ALIAS_VALUE_ID = '||p_tk_prepop_info(i).ALIAS_VALUE_ID);
4772: hr_utility.trace('p_tk_prepop_info(i).ITEM_ATTRIBUTE_CATEGORY = '||p_tk_prepop_info(i).ITEM_ATTRIBUTE_CATEGORY);
4773: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_DATE = '||p_tk_prepop_info(i).ABSENCE_DATE);
4774: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_DURATION = '||p_tk_prepop_info(i).ABSENCE_DURATION);
4775: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_START_TIME = '||p_tk_prepop_info(i).ABSENCE_START_TIME);
4776: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_STOP_TIME = '||p_tk_prepop_info(i).ABSENCE_STOP_TIME);
4777: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_ATTENDANCE_ID = '||p_tk_prepop_info(i).ABSENCE_ATTENDANCE_ID);
4778: hr_utility.trace('p_tk_prepop_info(i).TRANSACTION_ID = '||p_tk_prepop_info(i).TRANSACTION_ID);

Line 4775: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_START_TIME = '||p_tk_prepop_info(i).ABSENCE_START_TIME);

4771: hr_utility.trace('p_tk_prepop_info(i).ALIAS_VALUE_ID = '||p_tk_prepop_info(i).ALIAS_VALUE_ID);
4772: hr_utility.trace('p_tk_prepop_info(i).ITEM_ATTRIBUTE_CATEGORY = '||p_tk_prepop_info(i).ITEM_ATTRIBUTE_CATEGORY);
4773: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_DATE = '||p_tk_prepop_info(i).ABSENCE_DATE);
4774: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_DURATION = '||p_tk_prepop_info(i).ABSENCE_DURATION);
4775: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_START_TIME = '||p_tk_prepop_info(i).ABSENCE_START_TIME);
4776: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_STOP_TIME = '||p_tk_prepop_info(i).ABSENCE_STOP_TIME);
4777: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_ATTENDANCE_ID = '||p_tk_prepop_info(i).ABSENCE_ATTENDANCE_ID);
4778: hr_utility.trace('p_tk_prepop_info(i).TRANSACTION_ID = '||p_tk_prepop_info(i).TRANSACTION_ID);
4779:

Line 4776: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_STOP_TIME = '||p_tk_prepop_info(i).ABSENCE_STOP_TIME);

4772: hr_utility.trace('p_tk_prepop_info(i).ITEM_ATTRIBUTE_CATEGORY = '||p_tk_prepop_info(i).ITEM_ATTRIBUTE_CATEGORY);
4773: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_DATE = '||p_tk_prepop_info(i).ABSENCE_DATE);
4774: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_DURATION = '||p_tk_prepop_info(i).ABSENCE_DURATION);
4775: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_START_TIME = '||p_tk_prepop_info(i).ABSENCE_START_TIME);
4776: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_STOP_TIME = '||p_tk_prepop_info(i).ABSENCE_STOP_TIME);
4777: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_ATTENDANCE_ID = '||p_tk_prepop_info(i).ABSENCE_ATTENDANCE_ID);
4778: hr_utility.trace('p_tk_prepop_info(i).TRANSACTION_ID = '||p_tk_prepop_info(i).TRANSACTION_ID);
4779:
4780: end if;

Line 4777: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_ATTENDANCE_ID = '||p_tk_prepop_info(i).ABSENCE_ATTENDANCE_ID);

4773: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_DATE = '||p_tk_prepop_info(i).ABSENCE_DATE);
4774: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_DURATION = '||p_tk_prepop_info(i).ABSENCE_DURATION);
4775: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_START_TIME = '||p_tk_prepop_info(i).ABSENCE_START_TIME);
4776: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_STOP_TIME = '||p_tk_prepop_info(i).ABSENCE_STOP_TIME);
4777: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_ATTENDANCE_ID = '||p_tk_prepop_info(i).ABSENCE_ATTENDANCE_ID);
4778: hr_utility.trace('p_tk_prepop_info(i).TRANSACTION_ID = '||p_tk_prepop_info(i).TRANSACTION_ID);
4779:
4780: end if;
4781:

Line 4778: hr_utility.trace('p_tk_prepop_info(i).TRANSACTION_ID = '||p_tk_prepop_info(i).TRANSACTION_ID);

4774: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_DURATION = '||p_tk_prepop_info(i).ABSENCE_DURATION);
4775: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_START_TIME = '||p_tk_prepop_info(i).ABSENCE_START_TIME);
4776: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_STOP_TIME = '||p_tk_prepop_info(i).ABSENCE_STOP_TIME);
4777: hr_utility.trace('p_tk_prepop_info(i).ABSENCE_ATTENDANCE_ID = '||p_tk_prepop_info(i).ABSENCE_ATTENDANCE_ID);
4778: hr_utility.trace('p_tk_prepop_info(i).TRANSACTION_ID = '||p_tk_prepop_info(i).TRANSACTION_ID);
4779:
4780: end if;
4781:
4782: END LOOP;

Line 4826: hr_utility.trace('index_string = '||index_string);

4822: tmp_sort_tab(index_string).index_value:= i;
4823: tmp_sort_tab(index_string).clash_flag:= l_clash_flag;
4824:
4825: if g_debug then
4826: hr_utility.trace('index_string = '||index_string);
4827: hr_utility.trace('index_value = '||tmp_sort_tab(index_string).index_value);
4828: hr_utility.trace('clash_flag = '||tmp_sort_tab(index_string).clash_flag);
4829: end if;
4830:

Line 4827: hr_utility.trace('index_value = '||tmp_sort_tab(index_string).index_value);

4823: tmp_sort_tab(index_string).clash_flag:= l_clash_flag;
4824:
4825: if g_debug then
4826: hr_utility.trace('index_string = '||index_string);
4827: hr_utility.trace('index_value = '||tmp_sort_tab(index_string).index_value);
4828: hr_utility.trace('clash_flag = '||tmp_sort_tab(index_string).clash_flag);
4829: end if;
4830:
4831:

Line 4828: hr_utility.trace('clash_flag = '||tmp_sort_tab(index_string).clash_flag);

4824:
4825: if g_debug then
4826: hr_utility.trace('index_string = '||index_string);
4827: hr_utility.trace('index_value = '||tmp_sort_tab(index_string).index_value);
4828: hr_utility.trace('clash_flag = '||tmp_sort_tab(index_string).clash_flag);
4829: end if;
4830:
4831:
4832:

Line 4838: hr_utility.trace('BAPT 2');

4834:
4835: END IF; -- p_tk_prepop_info.COUNT
4836:
4837: if g_debug then
4838: hr_utility.trace('BAPT 2');
4839: end if;
4840:
4841: l_prev_attr_id:= p_tk_prepop_info(tmp_sort_tab(tmp_sort_tab.FIRST).index_value).ALIAS_VALUE_ID;
4842: l_prev_attr_category:= p_tk_prepop_info(tmp_sort_tab(tmp_sort_tab.FIRST).index_value).ITEM_ATTRIBUTE_CATEGORY;

Line 4845: hr_utility.trace('BAPT 3');

4841: l_prev_attr_id:= p_tk_prepop_info(tmp_sort_tab(tmp_sort_tab.FIRST).index_value).ALIAS_VALUE_ID;
4842: l_prev_attr_category:= p_tk_prepop_info(tmp_sort_tab(tmp_sort_tab.FIRST).index_value).ITEM_ATTRIBUTE_CATEGORY;
4843:
4844: if g_debug then
4845: hr_utility.trace('BAPT 3');
4846: end if;
4847:
4848: IF tmp_sort_tab.COUNT>0 THEN
4849:

Line 4860: hr_utility.trace('BAPT 3001');

4856:
4857: if tmp_sort_tab.EXISTS(tmp_index) then
4858:
4859: if g_debug then
4860: hr_utility.trace('BAPT 3001');
4861: end if;
4862:
4863: l_clash_index_tmp:=0;
4864:

Line 4866: hr_utility.trace(' BAPT 301');

4862:
4863: l_clash_index_tmp:=0;
4864:
4865: if g_debug then
4866: hr_utility.trace(' BAPT 301');
4867: end if;
4868:
4869: IF to_char(p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ALIAS_VALUE_ID) = l_prev_attr_id AND
4870: p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ITEM_ATTRIBUTE_CATEGORY = l_prev_attr_category THEN

Line 4873: hr_utility.trace(' BAPT 302');

4869: IF to_char(p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ALIAS_VALUE_ID) = l_prev_attr_id AND
4870: p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ITEM_ATTRIBUTE_CATEGORY = l_prev_attr_category THEN
4871:
4872: if g_debug then
4873: hr_utility.trace(' BAPT 302');
4874: end if;
4875:
4876: if tmp_sort_tab(tmp_index).clash_flag='Y' then
4877:

Line 4883: hr_utility.trace(' BAPT 303');

4879: l_clash_index_tmp:= l_clash_index;
4880:
4881: end if;
4882: if g_debug then
4883: hr_utility.trace(' BAPT 303');
4884: end if;
4885:
4886: ELSE
4887: if g_debug then

Line 4888: hr_utility.trace(' BAPT 304');

4884: end if;
4885:
4886: ELSE
4887: if g_debug then
4888: hr_utility.trace(' BAPT 304');
4889: end if;
4890:
4891: l_abs_tab_index:= l_abs_tab_index + l_clash_index + 1;
4892: l_clash_index:=0;

Line 4895: hr_utility.trace(' BAPT 305');

4891: l_abs_tab_index:= l_abs_tab_index + l_clash_index + 1;
4892: l_clash_index:=0;
4893:
4894: if g_debug then
4895: hr_utility.trace(' BAPT 305');
4896: end if;
4897:
4898: END IF;
4899:

Line 4901: hr_utility.trace('BAPT 31');

4897:
4898: END IF;
4899:
4900: if g_debug then
4901: hr_utility.trace('BAPT 31');
4902: end if;
4903:
4904: attr_value := substr(p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ITEM_ATTRIBUTE_CATEGORY,
4905: 16);

Line 4908: hr_utility.trace('ABSENCE_DATE = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_DATE);

4904: attr_value := substr(p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ITEM_ATTRIBUTE_CATEGORY,
4905: 16);
4906:
4907: if g_debug then
4908: hr_utility.trace('ABSENCE_DATE = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_DATE);
4909: end if;
4910:
4911: day_value := to_char (
4912: trunc( to_number( p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_DATE

Line 4920: hr_utility.trace('BAPT 32');

4916: ) +1
4917: );
4918:
4919: if g_debug then
4920: hr_utility.trace('BAPT 32');
4921: end if;
4922:
4923: tmp_bin_index:=l_abs_tab_index+l_clash_index_tmp;
4924:

Line 4927: hr_utility.trace('SVG inputs to get_abs_co_absence_detail_id');

4923: tmp_bin_index:=l_abs_tab_index+l_clash_index_tmp;
4924:
4925:
4926: if g_debug then
4927: hr_utility.trace('SVG inputs to get_abs_co_absence_detail_id');
4928: hr_utility.trace('-------');
4929: hr_utility.trace('p_absence_duration = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_DURATION);
4930: hr_utility.trace('p_absence_start_time = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_START_TIME);
4931: hr_utility.trace('p_absence_stop_time = ' ||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_STOP_TIME);

Line 4928: hr_utility.trace('-------');

4924:
4925:
4926: if g_debug then
4927: hr_utility.trace('SVG inputs to get_abs_co_absence_detail_id');
4928: hr_utility.trace('-------');
4929: hr_utility.trace('p_absence_duration = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_DURATION);
4930: hr_utility.trace('p_absence_start_time = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_START_TIME);
4931: hr_utility.trace('p_absence_stop_time = ' ||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_STOP_TIME);
4932: hr_utility.trace('p_absence_attendance_id = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_ATTENDANCE_ID);

Line 4929: hr_utility.trace('p_absence_duration = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_DURATION);

4925:
4926: if g_debug then
4927: hr_utility.trace('SVG inputs to get_abs_co_absence_detail_id');
4928: hr_utility.trace('-------');
4929: hr_utility.trace('p_absence_duration = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_DURATION);
4930: hr_utility.trace('p_absence_start_time = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_START_TIME);
4931: hr_utility.trace('p_absence_stop_time = ' ||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_STOP_TIME);
4932: hr_utility.trace('p_absence_attendance_id = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_ATTENDANCE_ID);
4933: hr_utility.trace('p_transaction_id = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).transaction_id);

Line 4930: hr_utility.trace('p_absence_start_time = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_START_TIME);

4926: if g_debug then
4927: hr_utility.trace('SVG inputs to get_abs_co_absence_detail_id');
4928: hr_utility.trace('-------');
4929: hr_utility.trace('p_absence_duration = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_DURATION);
4930: hr_utility.trace('p_absence_start_time = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_START_TIME);
4931: hr_utility.trace('p_absence_stop_time = ' ||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_STOP_TIME);
4932: hr_utility.trace('p_absence_attendance_id = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_ATTENDANCE_ID);
4933: hr_utility.trace('p_transaction_id = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).transaction_id);
4934: hr_utility.trace('p_lock_row_id = '||p_lock_row_id);

Line 4931: hr_utility.trace('p_absence_stop_time = ' ||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_STOP_TIME);

4927: hr_utility.trace('SVG inputs to get_abs_co_absence_detail_id');
4928: hr_utility.trace('-------');
4929: hr_utility.trace('p_absence_duration = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_DURATION);
4930: hr_utility.trace('p_absence_start_time = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_START_TIME);
4931: hr_utility.trace('p_absence_stop_time = ' ||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_STOP_TIME);
4932: hr_utility.trace('p_absence_attendance_id = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_ATTENDANCE_ID);
4933: hr_utility.trace('p_transaction_id = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).transaction_id);
4934: hr_utility.trace('p_lock_row_id = '||p_lock_row_id);
4935: hr_utility.trace('p_resource_id = '||p_resource_id);

Line 4932: hr_utility.trace('p_absence_attendance_id = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_ATTENDANCE_ID);

4928: hr_utility.trace('-------');
4929: hr_utility.trace('p_absence_duration = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_DURATION);
4930: hr_utility.trace('p_absence_start_time = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_START_TIME);
4931: hr_utility.trace('p_absence_stop_time = ' ||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_STOP_TIME);
4932: hr_utility.trace('p_absence_attendance_id = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_ATTENDANCE_ID);
4933: hr_utility.trace('p_transaction_id = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).transaction_id);
4934: hr_utility.trace('p_lock_row_id = '||p_lock_row_id);
4935: hr_utility.trace('p_resource_id = '||p_resource_id);
4936: hr_utility.trace('p_start_period = '||p_start_period);

Line 4933: hr_utility.trace('p_transaction_id = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).transaction_id);

4929: hr_utility.trace('p_absence_duration = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_DURATION);
4930: hr_utility.trace('p_absence_start_time = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_START_TIME);
4931: hr_utility.trace('p_absence_stop_time = ' ||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_STOP_TIME);
4932: hr_utility.trace('p_absence_attendance_id = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_ATTENDANCE_ID);
4933: hr_utility.trace('p_transaction_id = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).transaction_id);
4934: hr_utility.trace('p_lock_row_id = '||p_lock_row_id);
4935: hr_utility.trace('p_resource_id = '||p_resource_id);
4936: hr_utility.trace('p_start_period = '||p_start_period);
4937: hr_utility.trace('p_end_period = '||p_end_period);

Line 4934: hr_utility.trace('p_lock_row_id = '||p_lock_row_id);

4930: hr_utility.trace('p_absence_start_time = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_START_TIME);
4931: hr_utility.trace('p_absence_stop_time = ' ||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_STOP_TIME);
4932: hr_utility.trace('p_absence_attendance_id = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_ATTENDANCE_ID);
4933: hr_utility.trace('p_transaction_id = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).transaction_id);
4934: hr_utility.trace('p_lock_row_id = '||p_lock_row_id);
4935: hr_utility.trace('p_resource_id = '||p_resource_id);
4936: hr_utility.trace('p_start_period = '||p_start_period);
4937: hr_utility.trace('p_end_period = '||p_end_period);
4938: hr_utility.trace('p_tc_start = '||p_tc_start);

Line 4935: hr_utility.trace('p_resource_id = '||p_resource_id);

4931: hr_utility.trace('p_absence_stop_time = ' ||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_STOP_TIME);
4932: hr_utility.trace('p_absence_attendance_id = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_ATTENDANCE_ID);
4933: hr_utility.trace('p_transaction_id = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).transaction_id);
4934: hr_utility.trace('p_lock_row_id = '||p_lock_row_id);
4935: hr_utility.trace('p_resource_id = '||p_resource_id);
4936: hr_utility.trace('p_start_period = '||p_start_period);
4937: hr_utility.trace('p_end_period = '||p_end_period);
4938: hr_utility.trace('p_tc_start = '||p_tc_start);
4939: hr_utility.trace('p_tc_end = '||p_tc_end);

Line 4936: hr_utility.trace('p_start_period = '||p_start_period);

4932: hr_utility.trace('p_absence_attendance_id = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_ATTENDANCE_ID);
4933: hr_utility.trace('p_transaction_id = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).transaction_id);
4934: hr_utility.trace('p_lock_row_id = '||p_lock_row_id);
4935: hr_utility.trace('p_resource_id = '||p_resource_id);
4936: hr_utility.trace('p_start_period = '||p_start_period);
4937: hr_utility.trace('p_end_period = '||p_end_period);
4938: hr_utility.trace('p_tc_start = '||p_tc_start);
4939: hr_utility.trace('p_tc_end = '||p_tc_end);
4940: hr_utility.trace('p_day_value = '||day_value);

Line 4937: hr_utility.trace('p_end_period = '||p_end_period);

4933: hr_utility.trace('p_transaction_id = '||p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).transaction_id);
4934: hr_utility.trace('p_lock_row_id = '||p_lock_row_id);
4935: hr_utility.trace('p_resource_id = '||p_resource_id);
4936: hr_utility.trace('p_start_period = '||p_start_period);
4937: hr_utility.trace('p_end_period = '||p_end_period);
4938: hr_utility.trace('p_tc_start = '||p_tc_start);
4939: hr_utility.trace('p_tc_end = '||p_tc_end);
4940: hr_utility.trace('p_day_value = '||day_value);
4941: end if;

Line 4938: hr_utility.trace('p_tc_start = '||p_tc_start);

4934: hr_utility.trace('p_lock_row_id = '||p_lock_row_id);
4935: hr_utility.trace('p_resource_id = '||p_resource_id);
4936: hr_utility.trace('p_start_period = '||p_start_period);
4937: hr_utility.trace('p_end_period = '||p_end_period);
4938: hr_utility.trace('p_tc_start = '||p_tc_start);
4939: hr_utility.trace('p_tc_end = '||p_tc_end);
4940: hr_utility.trace('p_day_value = '||day_value);
4941: end if;
4942:

Line 4939: hr_utility.trace('p_tc_end = '||p_tc_end);

4935: hr_utility.trace('p_resource_id = '||p_resource_id);
4936: hr_utility.trace('p_start_period = '||p_start_period);
4937: hr_utility.trace('p_end_period = '||p_end_period);
4938: hr_utility.trace('p_tc_start = '||p_tc_start);
4939: hr_utility.trace('p_tc_end = '||p_tc_end);
4940: hr_utility.trace('p_day_value = '||day_value);
4941: end if;
4942:
4943:

Line 4940: hr_utility.trace('p_day_value = '||day_value);

4936: hr_utility.trace('p_start_period = '||p_start_period);
4937: hr_utility.trace('p_end_period = '||p_end_period);
4938: hr_utility.trace('p_tc_start = '||p_tc_start);
4939: hr_utility.trace('p_tc_end = '||p_tc_end);
4940: hr_utility.trace('p_day_value = '||day_value);
4941: end if;
4942:
4943:
4944:

Line 4961: hr_utility.trace('attr_value = '||attr_value);

4957: ,p_day_value => to_number(day_value)
4958: );
4959:
4960: if g_debug then
4961: hr_utility.trace('attr_value = '||attr_value);
4962: end if;
4963:
4964: CASE attr_value
4965:

Line 5752: hr_utility.trace('BAPT 33');

5748: attr_assg:= 'BEGIN '||attr_assg||' END;';
5749: day_assg1:= 'BEGIN '||day_assg1||' END;' ;
5750: day_assg2:= 'BEGIN '||day_assg2||' END;' ;
5751:
5752: hr_utility.trace('BAPT 33');
5753:
5754: hr_utility.trace('attr_assg ='||attr_assg);
5755: hr_utility.trace('day_assg1 ='||day_assg1);
5756: hr_utility.trace('day_assg2 ='||day_assg2);

Line 5754: hr_utility.trace('attr_assg ='||attr_assg);

5750: day_assg2:= 'BEGIN '||day_assg2||' END;' ;
5751:
5752: hr_utility.trace('BAPT 33');
5753:
5754: hr_utility.trace('attr_assg ='||attr_assg);
5755: hr_utility.trace('day_assg1 ='||day_assg1);
5756: hr_utility.trace('day_assg2 ='||day_assg2);
5757:
5758: EXECUTE IMMEDIATE attr_assg;

Line 5755: hr_utility.trace('day_assg1 ='||day_assg1);

5751:
5752: hr_utility.trace('BAPT 33');
5753:
5754: hr_utility.trace('attr_assg ='||attr_assg);
5755: hr_utility.trace('day_assg1 ='||day_assg1);
5756: hr_utility.trace('day_assg2 ='||day_assg2);
5757:
5758: EXECUTE IMMEDIATE attr_assg;
5759:

Line 5756: hr_utility.trace('day_assg2 ='||day_assg2);

5752: hr_utility.trace('BAPT 33');
5753:
5754: hr_utility.trace('attr_assg ='||attr_assg);
5755: hr_utility.trace('day_assg1 ='||day_assg1);
5756: hr_utility.trace('day_assg2 ='||day_assg2);
5757:
5758: EXECUTE IMMEDIATE attr_assg;
5759:
5760: hr_utility.trace('BAPT 34');

Line 5760: hr_utility.trace('BAPT 34');

5756: hr_utility.trace('day_assg2 ='||day_assg2);
5757:
5758: EXECUTE IMMEDIATE attr_assg;
5759:
5760: hr_utility.trace('BAPT 34');
5761:
5762: IF g_debug THEN
5763:
5764:

Line 5765: hr_utility.trace('Alias Value = '||

5761:
5762: IF g_debug THEN
5763:
5764:
5765: hr_utility.trace('Alias Value = '||
5766: p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ALIAS_VALUE_ID);
5767: hr_utility.trace('ABSENCE_DURATION = '||
5768: p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_DURATION);
5769: hr_utility.trace('ABSENCE_START_TIME = '||

Line 5767: hr_utility.trace('ABSENCE_DURATION = '||

5763:
5764:
5765: hr_utility.trace('Alias Value = '||
5766: p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ALIAS_VALUE_ID);
5767: hr_utility.trace('ABSENCE_DURATION = '||
5768: p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_DURATION);
5769: hr_utility.trace('ABSENCE_START_TIME = '||
5770: p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_START_TIME);
5771: hr_utility.trace('ABSENCE_STOP_TIME = '||

Line 5769: hr_utility.trace('ABSENCE_START_TIME = '||

5765: hr_utility.trace('Alias Value = '||
5766: p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ALIAS_VALUE_ID);
5767: hr_utility.trace('ABSENCE_DURATION = '||
5768: p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_DURATION);
5769: hr_utility.trace('ABSENCE_START_TIME = '||
5770: p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_START_TIME);
5771: hr_utility.trace('ABSENCE_STOP_TIME = '||
5772: p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_STOP_TIME);
5773:

Line 5771: hr_utility.trace('ABSENCE_STOP_TIME = '||

5767: hr_utility.trace('ABSENCE_DURATION = '||
5768: p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_DURATION);
5769: hr_utility.trace('ABSENCE_START_TIME = '||
5770: p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_START_TIME);
5771: hr_utility.trace('ABSENCE_STOP_TIME = '||
5772: p_tk_prepop_info(tmp_sort_tab(tmp_index).index_value).ABSENCE_STOP_TIME);
5773:
5774:
5775: END IF;

Line 5801: hr_utility.trace('BAPT 4');

5797:
5798: END IF;
5799:
5800: if g_debug then
5801: hr_utility.trace('BAPT 4');
5802: end if;
5803:
5804: END ;
5805:

Line 5880: hr_utility.trace('Before hxc_preference_evaluation.get_tc_resp');

5876:
5877: p_messages:= HXC_MESSAGE_TABLE_TYPE();
5878:
5879: if g_debug then
5880: hr_utility.trace('Before hxc_preference_evaluation.get_tc_resp');
5881: end if;
5882:
5883: hxc_preference_evaluation.get_tc_resp
5884: (p_resource_id,

Line 5891: hr_utility.trace('After hxc_preference_evaluation.get_tc_resp');

5887: l_resp_id,
5888: l_resp_appl_id);
5889:
5890: if g_debug then
5891: hr_utility.trace('After hxc_preference_evaluation.get_tc_resp');
5892: end if;
5893:
5894: l_approval_style_id := hxc_preference_evaluation.resource_preferences(
5895: p_resource_id,

Line 5902: hr_utility.trace('l_approval_style_id = '||l_approval_style_id);

5898: l_resp_id
5899: );
5900:
5901: if g_debug then
5902: hr_utility.trace('l_approval_style_id = '||l_approval_style_id);
5903: end if;
5904:
5905:
5906: HXC_RETRIEVE_ABSENCES.add_absence_types ( p_person_id => p_resource_id,

Line 5919: hr_utility.trace('INSIDE pre_populate absences');

5915: p_iteration_count => hxc_timekeeper_process.g_resource_prepop_count
5916: );
5917:
5918: if g_debug then
5919: hr_utility.trace('INSIDE pre_populate absences');
5920: hr_utility.trace('PPA 1');
5921: end if;
5922:
5923: hxc_retrieve_absences.g_message_string:=null;

Line 5920: hr_utility.trace('PPA 1');

5916: );
5917:
5918: if g_debug then
5919: hr_utility.trace('INSIDE pre_populate absences');
5920: hr_utility.trace('PPA 1');
5921: end if;
5922:
5923: hxc_retrieve_absences.g_message_string:=null;
5924: g_abs_message_string:=null;

Line 5930: hr_utility.trace(' Resource= '||p_resource_id);

5926: hxc_retrieve_absences.g_messages.DELETE;
5927: g_exception_detected:= 'N';
5928:
5929: if g_debug then
5930: hr_utility.trace(' Resource= '||p_resource_id);
5931: hr_utility.trace('After instantiating - hxc_retrieve_absences.g_messages.count = '
5932: ||hxc_retrieve_absences.g_messages.count);
5933: end if;
5934:

Line 5931: hr_utility.trace('After instantiating - hxc_retrieve_absences.g_messages.count = '

5927: g_exception_detected:= 'N';
5928:
5929: if g_debug then
5930: hr_utility.trace(' Resource= '||p_resource_id);
5931: hr_utility.trace('After instantiating - hxc_retrieve_absences.g_messages.count = '
5932: ||hxc_retrieve_absences.g_messages.count);
5933: end if;
5934:
5935: hxc_retrieve_absences.retrieve_absences(p_person_id => p_resource_id,

Line 5941: hr_utility.trace(' Resource= '||p_resource_id);

5937: p_end_date => p_end_period,
5938: p_abs_tab => l_abs_tab);
5939: p_messages:= hxc_retrieve_absences.g_messages;
5940: if g_debug then
5941: hr_utility.trace(' Resource= '||p_resource_id);
5942: hr_utility.trace('After populating - hxc_retrieve_absences.g_messages.count = '
5943: || hxc_retrieve_absences.g_messages.count);
5944: hr_utility.trace('After populating -p_messages.count = '
5945: ||p_messages.count);

Line 5942: hr_utility.trace('After populating - hxc_retrieve_absences.g_messages.count = '

5938: p_abs_tab => l_abs_tab);
5939: p_messages:= hxc_retrieve_absences.g_messages;
5940: if g_debug then
5941: hr_utility.trace(' Resource= '||p_resource_id);
5942: hr_utility.trace('After populating - hxc_retrieve_absences.g_messages.count = '
5943: || hxc_retrieve_absences.g_messages.count);
5944: hr_utility.trace('After populating -p_messages.count = '
5945: ||p_messages.count);
5946: end if;

Line 5944: hr_utility.trace('After populating -p_messages.count = '

5940: if g_debug then
5941: hr_utility.trace(' Resource= '||p_resource_id);
5942: hr_utility.trace('After populating - hxc_retrieve_absences.g_messages.count = '
5943: || hxc_retrieve_absences.g_messages.count);
5944: hr_utility.trace('After populating -p_messages.count = '
5945: ||p_messages.count);
5946: end if;
5947:
5948: if p_messages.count>0 then

Line 5953: hr_utility.trace('PPA 2');

5949: l_index:= p_messages.first;
5950: g_abs_message_string:= p_messages(l_index).message_name;
5951: end if;
5952: if g_debug then
5953: hr_utility.trace('PPA 2');
5954: end if;
5955:
5956: g_abs_message_string:= hxc_retrieve_absences.g_message_string;
5957:

Line 5959: hr_utility.trace('g_message_string = '||g_abs_message_string);

5955:
5956: g_abs_message_string:= hxc_retrieve_absences.g_message_string;
5957:
5958: if g_debug then
5959: hr_utility.trace('g_message_string = '||g_abs_message_string);
5960: end if;
5961:
5962: if (g_abs_message_string = 'HXC_ABS_PEND_APPR_DELETE' OR
5963: g_abs_message_string = 'HXC_ABS_PEND_APPR_ERROR' ) then

Line 5965: hr_utility.trace('Raising exception for '|| p_resource_id);

5961:
5962: if (g_abs_message_string = 'HXC_ABS_PEND_APPR_DELETE' OR
5963: g_abs_message_string = 'HXC_ABS_PEND_APPR_ERROR' ) then
5964:
5965: hr_utility.trace('Raising exception for '|| p_resource_id);
5966: raise l_abs_pending_appr_notif;
5967:
5968: end if;
5969:

Line 5982: hr_utility.trace('SVG entered loop');

5978: THEN
5979: FOR i IN l_abs_tab.FIRST..l_abs_tab.LAST
5980: LOOP
5981:
5982: hr_utility.trace('SVG entered loop');
5983:
5984: hr_utility.trace(l_abs_tab(i).abs_date||
5985: '-'||l_abs_tab(i).element_type_id||
5986: '-'||l_abs_tab(i).abs_type_id||

Line 5984: hr_utility.trace(l_abs_tab(i).abs_date||

5980: LOOP
5981:
5982: hr_utility.trace('SVG entered loop');
5983:
5984: hr_utility.trace(l_abs_tab(i).abs_date||
5985: '-'||l_abs_tab(i).element_type_id||
5986: '-'||l_abs_tab(i).abs_type_id||
5987: '-'||l_abs_tab(i).duration||
5988: '-'||l_abs_tab(i).abs_attendance_id||

Line 6001: hr_utility.trace('PPA 3');

5997: p_alias_def_item => l_alias_def_item
5998: );
5999:
6000: if g_debug then
6001: hr_utility.trace('PPA 3');
6002: end if;
6003:
6004: IF g_debug then
6005:

Line 6010: hr_utility.trace('ALIAS_DEFINITION_ID = '|| l_alias_def_item(i).ALIAS_DEFINITION_ID);

6006: IF l_alias_def_item.COUNT > 0
6007: THEN
6008: FOR i IN l_alias_def_item.FIRST..l_alias_def_item.LAST
6009: LOOP
6010: hr_utility.trace('ALIAS_DEFINITION_ID = '|| l_alias_def_item(i).ALIAS_DEFINITION_ID);
6011: hr_utility.trace('ITEM_ATTRIBUTE_CATEGORY = '|| l_alias_def_item(i).ITEM_ATTRIBUTE_CATEGORY);
6012: hr_utility.trace('RESOURCE_ID = '|| l_alias_def_item(i).RESOURCE_ID);
6013: hr_utility.trace('LAYOUT_ID = '|| l_alias_def_item(i).LAYOUT_ID);
6014: hr_utility.trace('ALIAS_LABEL = '|| l_alias_def_item(i).ALIAS_LABEL);

Line 6011: hr_utility.trace('ITEM_ATTRIBUTE_CATEGORY = '|| l_alias_def_item(i).ITEM_ATTRIBUTE_CATEGORY);

6007: THEN
6008: FOR i IN l_alias_def_item.FIRST..l_alias_def_item.LAST
6009: LOOP
6010: hr_utility.trace('ALIAS_DEFINITION_ID = '|| l_alias_def_item(i).ALIAS_DEFINITION_ID);
6011: hr_utility.trace('ITEM_ATTRIBUTE_CATEGORY = '|| l_alias_def_item(i).ITEM_ATTRIBUTE_CATEGORY);
6012: hr_utility.trace('RESOURCE_ID = '|| l_alias_def_item(i).RESOURCE_ID);
6013: hr_utility.trace('LAYOUT_ID = '|| l_alias_def_item(i).LAYOUT_ID);
6014: hr_utility.trace('ALIAS_LABEL = '|| l_alias_def_item(i).ALIAS_LABEL);
6015: hr_utility.trace('PREF_START_DATE = '|| l_alias_def_item(i).PREF_START_DATE);

Line 6012: hr_utility.trace('RESOURCE_ID = '|| l_alias_def_item(i).RESOURCE_ID);

6008: FOR i IN l_alias_def_item.FIRST..l_alias_def_item.LAST
6009: LOOP
6010: hr_utility.trace('ALIAS_DEFINITION_ID = '|| l_alias_def_item(i).ALIAS_DEFINITION_ID);
6011: hr_utility.trace('ITEM_ATTRIBUTE_CATEGORY = '|| l_alias_def_item(i).ITEM_ATTRIBUTE_CATEGORY);
6012: hr_utility.trace('RESOURCE_ID = '|| l_alias_def_item(i).RESOURCE_ID);
6013: hr_utility.trace('LAYOUT_ID = '|| l_alias_def_item(i).LAYOUT_ID);
6014: hr_utility.trace('ALIAS_LABEL = '|| l_alias_def_item(i).ALIAS_LABEL);
6015: hr_utility.trace('PREF_START_DATE = '|| l_alias_def_item(i).PREF_START_DATE);
6016: hr_utility.trace('PREF_END_DATE = '|| l_alias_def_item(i).PREF_END_DATE);

Line 6013: hr_utility.trace('LAYOUT_ID = '|| l_alias_def_item(i).LAYOUT_ID);

6009: LOOP
6010: hr_utility.trace('ALIAS_DEFINITION_ID = '|| l_alias_def_item(i).ALIAS_DEFINITION_ID);
6011: hr_utility.trace('ITEM_ATTRIBUTE_CATEGORY = '|| l_alias_def_item(i).ITEM_ATTRIBUTE_CATEGORY);
6012: hr_utility.trace('RESOURCE_ID = '|| l_alias_def_item(i).RESOURCE_ID);
6013: hr_utility.trace('LAYOUT_ID = '|| l_alias_def_item(i).LAYOUT_ID);
6014: hr_utility.trace('ALIAS_LABEL = '|| l_alias_def_item(i).ALIAS_LABEL);
6015: hr_utility.trace('PREF_START_DATE = '|| l_alias_def_item(i).PREF_START_DATE);
6016: hr_utility.trace('PREF_END_DATE = '|| l_alias_def_item(i).PREF_END_DATE);
6017: END LOOP;

Line 6014: hr_utility.trace('ALIAS_LABEL = '|| l_alias_def_item(i).ALIAS_LABEL);

6010: hr_utility.trace('ALIAS_DEFINITION_ID = '|| l_alias_def_item(i).ALIAS_DEFINITION_ID);
6011: hr_utility.trace('ITEM_ATTRIBUTE_CATEGORY = '|| l_alias_def_item(i).ITEM_ATTRIBUTE_CATEGORY);
6012: hr_utility.trace('RESOURCE_ID = '|| l_alias_def_item(i).RESOURCE_ID);
6013: hr_utility.trace('LAYOUT_ID = '|| l_alias_def_item(i).LAYOUT_ID);
6014: hr_utility.trace('ALIAS_LABEL = '|| l_alias_def_item(i).ALIAS_LABEL);
6015: hr_utility.trace('PREF_START_DATE = '|| l_alias_def_item(i).PREF_START_DATE);
6016: hr_utility.trace('PREF_END_DATE = '|| l_alias_def_item(i).PREF_END_DATE);
6017: END LOOP;
6018: END IF;

Line 6015: hr_utility.trace('PREF_START_DATE = '|| l_alias_def_item(i).PREF_START_DATE);

6011: hr_utility.trace('ITEM_ATTRIBUTE_CATEGORY = '|| l_alias_def_item(i).ITEM_ATTRIBUTE_CATEGORY);
6012: hr_utility.trace('RESOURCE_ID = '|| l_alias_def_item(i).RESOURCE_ID);
6013: hr_utility.trace('LAYOUT_ID = '|| l_alias_def_item(i).LAYOUT_ID);
6014: hr_utility.trace('ALIAS_LABEL = '|| l_alias_def_item(i).ALIAS_LABEL);
6015: hr_utility.trace('PREF_START_DATE = '|| l_alias_def_item(i).PREF_START_DATE);
6016: hr_utility.trace('PREF_END_DATE = '|| l_alias_def_item(i).PREF_END_DATE);
6017: END LOOP;
6018: END IF;
6019:

Line 6016: hr_utility.trace('PREF_END_DATE = '|| l_alias_def_item(i).PREF_END_DATE);

6012: hr_utility.trace('RESOURCE_ID = '|| l_alias_def_item(i).RESOURCE_ID);
6013: hr_utility.trace('LAYOUT_ID = '|| l_alias_def_item(i).LAYOUT_ID);
6014: hr_utility.trace('ALIAS_LABEL = '|| l_alias_def_item(i).ALIAS_LABEL);
6015: hr_utility.trace('PREF_START_DATE = '|| l_alias_def_item(i).PREF_START_DATE);
6016: hr_utility.trace('PREF_END_DATE = '|| l_alias_def_item(i).PREF_END_DATE);
6017: END LOOP;
6018: END IF;
6019:
6020: END IF;

Line 6029: hr_utility.trace('entering l_abs_tab loop');

6025:
6026: FOR abs_count in l_abs_tab.FIRST .. l_abs_tab.LAST
6027: LOOP
6028: if g_debug then
6029: hr_utility.trace('entering l_abs_tab loop');
6030: hr_utility.trace('l_abs_tab(i).element_type_id='||l_abs_tab(abs_count).element_type_id);
6031: end if;
6032:
6033: IF l_alias_def_item.COUNT > 0 THEN

Line 6030: hr_utility.trace('l_abs_tab(i).element_type_id='||l_abs_tab(abs_count).element_type_id);

6026: FOR abs_count in l_abs_tab.FIRST .. l_abs_tab.LAST
6027: LOOP
6028: if g_debug then
6029: hr_utility.trace('entering l_abs_tab loop');
6030: hr_utility.trace('l_abs_tab(i).element_type_id='||l_abs_tab(abs_count).element_type_id);
6031: end if;
6032:
6033: IF l_alias_def_item.COUNT > 0 THEN
6034:

Line 6038: hr_utility.trace('l_abs_tab(abs_count).element_type_id = '|| l_abs_tab(abs_count).element_type_id);

6034:
6035: FOR alias_def_count in l_alias_def_item.FIRST .. l_alias_def_item.LAST
6036: LOOP
6037: if g_debug then
6038: hr_utility.trace('l_abs_tab(abs_count).element_type_id = '|| l_abs_tab(abs_count).element_type_id);
6039: hr_utility.trace('l_alias_def_item(alias_def_count).ALIAS_DEFINITION_ID = '|| l_alias_def_item(alias_def_count).ALIAS_DEFINITION_ID);
6040: hr_utility.trace('p_start_period = '|| p_start_period);
6041: hr_utility.trace('p_end_period = '|| p_end_period);
6042: end if;

Line 6039: hr_utility.trace('l_alias_def_item(alias_def_count).ALIAS_DEFINITION_ID = '|| l_alias_def_item(alias_def_count).ALIAS_DEFINITION_ID);

6035: FOR alias_def_count in l_alias_def_item.FIRST .. l_alias_def_item.LAST
6036: LOOP
6037: if g_debug then
6038: hr_utility.trace('l_abs_tab(abs_count).element_type_id = '|| l_abs_tab(abs_count).element_type_id);
6039: hr_utility.trace('l_alias_def_item(alias_def_count).ALIAS_DEFINITION_ID = '|| l_alias_def_item(alias_def_count).ALIAS_DEFINITION_ID);
6040: hr_utility.trace('p_start_period = '|| p_start_period);
6041: hr_utility.trace('p_end_period = '|| p_end_period);
6042: end if;
6043:

Line 6040: hr_utility.trace('p_start_period = '|| p_start_period);

6036: LOOP
6037: if g_debug then
6038: hr_utility.trace('l_abs_tab(abs_count).element_type_id = '|| l_abs_tab(abs_count).element_type_id);
6039: hr_utility.trace('l_alias_def_item(alias_def_count).ALIAS_DEFINITION_ID = '|| l_alias_def_item(alias_def_count).ALIAS_DEFINITION_ID);
6040: hr_utility.trace('p_start_period = '|| p_start_period);
6041: hr_utility.trace('p_end_period = '|| p_end_period);
6042: end if;
6043:
6044: FOR alias_info in get_alias_info(

Line 6041: hr_utility.trace('p_end_period = '|| p_end_period);

6037: if g_debug then
6038: hr_utility.trace('l_abs_tab(abs_count).element_type_id = '|| l_abs_tab(abs_count).element_type_id);
6039: hr_utility.trace('l_alias_def_item(alias_def_count).ALIAS_DEFINITION_ID = '|| l_alias_def_item(alias_def_count).ALIAS_DEFINITION_ID);
6040: hr_utility.trace('p_start_period = '|| p_start_period);
6041: hr_utility.trace('p_end_period = '|| p_end_period);
6042: end if;
6043:
6044: FOR alias_info in get_alias_info(
6045: l_abs_tab(abs_count).element_type_id,

Line 6055: hr_utility.trace('PPA entered the loop');

6051:
6052: l_tk_prepop_info_counter:= l_tk_prepop_info_counter + 1;
6053:
6054: if g_debug then
6055: hr_utility.trace('PPA entered the loop');
6056: end if;
6057:
6058: l_tk_prepop_info(l_tk_prepop_info_counter).ALIAS_VALUE_ID:=
6059: alias_info.alias_value_id;

Line 6095: hr_utility.trace('PPA 4');

6091:
6092: END IF;
6093:
6094: if g_debug then
6095: hr_utility.trace('PPA 4');
6096: end if;
6097:
6098: IF l_tk_prepop_info.COUNT > 0 THEN
6099: