[Home] [Help]
1: package body hrentmnt as
2: /* $Header: pyentmnt.pkb 120.32.12010000.6 2008/09/30 06:24:40 salogana ship $ */
3: --
4: g_debug boolean := hr_utility.debug_enabled;
5: indent varchar2 (32767) := null;
6: g_package constant varchar2 (32) := 'hrentmnt.';
7: --
8: -- Record type to cache an element entry for use when splitting into two.
237: --
238: procedure check_parameters is
239: begin
240: --
241: hr_utility.trace('In min_eligibility_date');
242: hr_utility.trace ('');
243: hr_utility.trace (' p_element_link_id = '
244: ||to_char (p_element_link_id));
245: hr_utility.trace (' p_assignment_id'
238: procedure check_parameters is
239: begin
240: --
241: hr_utility.trace('In min_eligibility_date');
242: hr_utility.trace ('');
243: hr_utility.trace (' p_element_link_id = '
244: ||to_char (p_element_link_id));
245: hr_utility.trace (' p_assignment_id'
246: ||to_char (p_assignment_id));
239: begin
240: --
241: hr_utility.trace('In min_eligibility_date');
242: hr_utility.trace ('');
243: hr_utility.trace (' p_element_link_id = '
244: ||to_char (p_element_link_id));
245: hr_utility.trace (' p_assignment_id'
246: ||to_char (p_assignment_id));
247: hr_utility.trace (' p_range_start_date'
241: hr_utility.trace('In min_eligibility_date');
242: hr_utility.trace ('');
243: hr_utility.trace (' p_element_link_id = '
244: ||to_char (p_element_link_id));
245: hr_utility.trace (' p_assignment_id'
246: ||to_char (p_assignment_id));
247: hr_utility.trace (' p_range_start_date'
248: ||to_char (p_range_start_date));
249: hr_utility.trace (' p_range_end_date'
243: hr_utility.trace (' p_element_link_id = '
244: ||to_char (p_element_link_id));
245: hr_utility.trace (' p_assignment_id'
246: ||to_char (p_assignment_id));
247: hr_utility.trace (' p_range_start_date'
248: ||to_char (p_range_start_date));
249: hr_utility.trace (' p_range_end_date'
250: ||to_char (p_range_end_date));
251: hr_utility.trace ('');
245: hr_utility.trace (' p_assignment_id'
246: ||to_char (p_assignment_id));
247: hr_utility.trace (' p_range_start_date'
248: ||to_char (p_range_start_date));
249: hr_utility.trace (' p_range_end_date'
250: ||to_char (p_range_end_date));
251: hr_utility.trace ('');
252: --
253: end check_parameters;
247: hr_utility.trace (' p_range_start_date'
248: ||to_char (p_range_start_date));
249: hr_utility.trace (' p_range_end_date'
250: ||to_char (p_range_end_date));
251: hr_utility.trace ('');
252: --
253: end check_parameters;
254: --
255: begin
266: open csr_link(p_element_link_id);
267: fetch csr_link into v_link_rec;
268: if csr_link%notfound then
269: close csr_link;
270: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
271: hr_utility.set_message_token('PROCEDURE', 'hrentmnt.min_eligibility_date');
272: hr_utility.set_message_token('STEP','1');
273: hr_utility.raise_error;
274: end if;
267: fetch csr_link into v_link_rec;
268: if csr_link%notfound then
269: close csr_link;
270: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
271: hr_utility.set_message_token('PROCEDURE', 'hrentmnt.min_eligibility_date');
272: hr_utility.set_message_token('STEP','1');
273: hr_utility.raise_error;
274: end if;
275: close csr_link;
268: if csr_link%notfound then
269: close csr_link;
270: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
271: hr_utility.set_message_token('PROCEDURE', 'hrentmnt.min_eligibility_date');
272: hr_utility.set_message_token('STEP','1');
273: hr_utility.raise_error;
274: end if;
275: close csr_link;
276: --
269: close csr_link;
270: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
271: hr_utility.set_message_token('PROCEDURE', 'hrentmnt.min_eligibility_date');
272: hr_utility.set_message_token('STEP','1');
273: hr_utility.raise_error;
274: end if;
275: close csr_link;
276: --
277: --
302: --
303: fetch csr_assignment into v_asg_rec;
304: if csr_assignment%notfound then
305: close csr_assignment;
306: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
307: hr_utility.set_message_token('PROCEDURE', 'hrentmnt.min_eligibility_date');
308: hr_utility.set_message_token('STEP','2');
309: hr_utility.raise_error;
310: end if;
303: fetch csr_assignment into v_asg_rec;
304: if csr_assignment%notfound then
305: close csr_assignment;
306: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
307: hr_utility.set_message_token('PROCEDURE', 'hrentmnt.min_eligibility_date');
308: hr_utility.set_message_token('STEP','2');
309: hr_utility.raise_error;
310: end if;
311: --
304: if csr_assignment%notfound then
305: close csr_assignment;
306: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
307: hr_utility.set_message_token('PROCEDURE', 'hrentmnt.min_eligibility_date');
308: hr_utility.set_message_token('STEP','2');
309: hr_utility.raise_error;
310: end if;
311: --
312: --
305: close csr_assignment;
306: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
307: hr_utility.set_message_token('PROCEDURE', 'hrentmnt.min_eligibility_date');
308: hr_utility.set_message_token('STEP','2');
309: hr_utility.raise_error;
310: end if;
311: --
312: --
313: -- Initialise variables holding the start and end dates of the current
515: --
516: procedure check_parameters is
517: begin
518: --
519: hr_utility.trace('In '||l_proc);
520: hr_utility.trace ('');
521: hr_utility.trace (' p_assignment_id = '
522: ||to_char (p_assignment_id));
523: --
516: procedure check_parameters is
517: begin
518: --
519: hr_utility.trace('In '||l_proc);
520: hr_utility.trace ('');
521: hr_utility.trace (' p_assignment_id = '
522: ||to_char (p_assignment_id));
523: --
524: hr_utility.trace (' p_business_group_id = '
517: begin
518: --
519: hr_utility.trace('In '||l_proc);
520: hr_utility.trace ('');
521: hr_utility.trace (' p_assignment_id = '
522: ||to_char (p_assignment_id));
523: --
524: hr_utility.trace (' p_business_group_id = '
525: ||to_char (p_business_group_id));
520: hr_utility.trace ('');
521: hr_utility.trace (' p_assignment_id = '
522: ||to_char (p_assignment_id));
523: --
524: hr_utility.trace (' p_business_group_id = '
525: ||to_char (p_business_group_id));
526: --
527: hr_utility.trace (' p_dt_mode = '
528: ||p_dt_mode);
523: --
524: hr_utility.trace (' p_business_group_id = '
525: ||to_char (p_business_group_id));
526: --
527: hr_utility.trace (' p_dt_mode = '
528: ||p_dt_mode);
529: --
530: hr_utility.trace (' p_old_people_group_id = '
531: ||to_char (p_old_people_group_id));
526: --
527: hr_utility.trace (' p_dt_mode = '
528: ||p_dt_mode);
529: --
530: hr_utility.trace (' p_old_people_group_id = '
531: ||to_char (p_old_people_group_id));
532: --
533: hr_utility.trace (' p_new_people_group_id = '
534: ||to_char (p_new_people_group_id));
529: --
530: hr_utility.trace (' p_old_people_group_id = '
531: ||to_char (p_old_people_group_id));
532: --
533: hr_utility.trace (' p_new_people_group_id = '
534: ||to_char (p_new_people_group_id));
535: --
536: hr_utility.trace ('');
537: --
532: --
533: hr_utility.trace (' p_new_people_group_id = '
534: ||to_char (p_new_people_group_id));
535: --
536: hr_utility.trace ('');
537: --
538: end check_parameters;
539: --
540: begin
723: --
724: end if;
725: --
726: if g_debug then
727: hr_utility.trace('Out '||l_proc);
728: end if;
729: --
730: end maintain_alu_asg;
731: --
911: procedure check_parameters is
912: --
913: begin
914: --
915: hr_utility.trace('In check_payroll_changes_asg');
916: hr_utility.trace ('');
917: hr_utility.trace (' p_assignment_id = '
918: ||to_char (p_assignment_id));
919: hr_utility.trace (' p_payroll_id = '
912: --
913: begin
914: --
915: hr_utility.trace('In check_payroll_changes_asg');
916: hr_utility.trace ('');
917: hr_utility.trace (' p_assignment_id = '
918: ||to_char (p_assignment_id));
919: hr_utility.trace (' p_payroll_id = '
920: ||to_char (p_payroll_id));
913: begin
914: --
915: hr_utility.trace('In check_payroll_changes_asg');
916: hr_utility.trace ('');
917: hr_utility.trace (' p_assignment_id = '
918: ||to_char (p_assignment_id));
919: hr_utility.trace (' p_payroll_id = '
920: ||to_char (p_payroll_id));
921: hr_utility.trace (' p_dt_mode = '
915: hr_utility.trace('In check_payroll_changes_asg');
916: hr_utility.trace ('');
917: hr_utility.trace (' p_assignment_id = '
918: ||to_char (p_assignment_id));
919: hr_utility.trace (' p_payroll_id = '
920: ||to_char (p_payroll_id));
921: hr_utility.trace (' p_dt_mode = '
922: ||p_dt_mode);
923: hr_utility.trace (' p_validation_start_date = '
917: hr_utility.trace (' p_assignment_id = '
918: ||to_char (p_assignment_id));
919: hr_utility.trace (' p_payroll_id = '
920: ||to_char (p_payroll_id));
921: hr_utility.trace (' p_dt_mode = '
922: ||p_dt_mode);
923: hr_utility.trace (' p_validation_start_date = '
924: ||to_char (p_validation_start_date));
925: hr_utility.trace (' p_validation_end_date = '
919: hr_utility.trace (' p_payroll_id = '
920: ||to_char (p_payroll_id));
921: hr_utility.trace (' p_dt_mode = '
922: ||p_dt_mode);
923: hr_utility.trace (' p_validation_start_date = '
924: ||to_char (p_validation_start_date));
925: hr_utility.trace (' p_validation_end_date = '
926: ||to_char (p_validation_end_date));
927: hr_utility.trace ('');
921: hr_utility.trace (' p_dt_mode = '
922: ||p_dt_mode);
923: hr_utility.trace (' p_validation_start_date = '
924: ||to_char (p_validation_start_date));
925: hr_utility.trace (' p_validation_end_date = '
926: ||to_char (p_validation_end_date));
927: hr_utility.trace ('');
928: --
929: end check_parameters;
923: hr_utility.trace (' p_validation_start_date = '
924: ||to_char (p_validation_start_date));
925: hr_utility.trace (' p_validation_end_date = '
926: ||to_char (p_validation_end_date));
927: hr_utility.trace ('');
928: --
929: end check_parameters;
930: --
931: --
930: --
931: --
932: begin
933: --
934: g_debug := hr_utility.debug_enabled;
935: if g_debug then
936: check_parameters;
937: end if;
938: --
957: from pay_payrolls_f pay2
958: where pay2.payroll_id = pay.payroll_id));
959: --
960: if v_check_failed = 'Y' then
961: hr_utility.set_message(801,'HR_6590_ASS_PYRLL_NOT_EXIST');
962: hr_utility.raise_error;
963: end if;
964: --
965: exception
958: where pay2.payroll_id = pay.payroll_id));
959: --
960: if v_check_failed = 'Y' then
961: hr_utility.set_message(801,'HR_6590_ASS_PYRLL_NOT_EXIST');
962: hr_utility.raise_error;
963: end if;
964: --
965: exception
966: when no_data_found then null;
1003: l_date := l_rec.effective_date;
1004: v_check_failed := 'Y';
1005: exit;
1006: else
1007: hr_utility.set_message(801,'PAY_449682_RUN_EXISTS_FOR_DE');
1008: hr_utility.set_warning;
1009: end if;
1010: --
1011: end loop;
1004: v_check_failed := 'Y';
1005: exit;
1006: else
1007: hr_utility.set_message(801,'PAY_449682_RUN_EXISTS_FOR_DE');
1008: hr_utility.set_warning;
1009: end if;
1010: --
1011: end loop;
1012: --
1065: v_check_failed := 'Y';
1066: exit;
1067: else
1068: --
1069: hr_utility.set_message(801,'PAY_449682_RUN_EXISTS_FOR_DE');
1070: hr_utility.set_warning;
1071: --
1072: end if;
1073: close csr_valid_payroll;
1066: exit;
1067: else
1068: --
1069: hr_utility.set_message(801,'PAY_449682_RUN_EXISTS_FOR_DE');
1070: hr_utility.set_warning;
1071: --
1072: end if;
1073: close csr_valid_payroll;
1074: --
1073: close csr_valid_payroll;
1074: --
1075: else
1076: --
1077: hr_utility.set_message(801,'PAY_449682_RUN_EXISTS_FOR_DE');
1078: hr_utility.set_warning;
1079: --
1080: end if;
1081: --
1074: --
1075: else
1076: --
1077: hr_utility.set_message(801,'PAY_449682_RUN_EXISTS_FOR_DE');
1078: hr_utility.set_warning;
1079: --
1080: end if;
1081: --
1082: end loop;
1083: --
1084: end if;
1085: --
1086: if v_check_failed = 'Y' then
1087: hr_utility.set_message(801,'HR_449757_ASS_ACTIONS_EXIST');
1088: hr_utility.set_message_token('1', fnd_date.date_to_displaydate(l_date));
1089: hr_utility.raise_error;
1090: end if;
1091: --
1084: end if;
1085: --
1086: if v_check_failed = 'Y' then
1087: hr_utility.set_message(801,'HR_449757_ASS_ACTIONS_EXIST');
1088: hr_utility.set_message_token('1', fnd_date.date_to_displaydate(l_date));
1089: hr_utility.raise_error;
1090: end if;
1091: --
1092: end check_payroll_changes_asg;
1085: --
1086: if v_check_failed = 'Y' then
1087: hr_utility.set_message(801,'HR_449757_ASS_ACTIONS_EXIST');
1088: hr_utility.set_message_token('1', fnd_date.date_to_displaydate(l_date));
1089: hr_utility.raise_error;
1090: end if;
1091: --
1092: end check_payroll_changes_asg;
1093: --
1150: procedure check_parameters is
1151: --
1152: begin
1153: --
1154: hr_utility.trace('In hrentmnt.cache_element_entry');
1155: --
1156: hr_utility.trace ('');
1157: hr_utility.trace (' p_element_entry_id = '
1158: ||to_char (p_element_entry_id));
1152: begin
1153: --
1154: hr_utility.trace('In hrentmnt.cache_element_entry');
1155: --
1156: hr_utility.trace ('');
1157: hr_utility.trace (' p_element_entry_id = '
1158: ||to_char (p_element_entry_id));
1159: hr_utility.trace (' p_date = '
1160: ||to_char (p_date));
1153: --
1154: hr_utility.trace('In hrentmnt.cache_element_entry');
1155: --
1156: hr_utility.trace ('');
1157: hr_utility.trace (' p_element_entry_id = '
1158: ||to_char (p_element_entry_id));
1159: hr_utility.trace (' p_date = '
1160: ||to_char (p_date));
1161: hr_utility.trace ('');
1155: --
1156: hr_utility.trace ('');
1157: hr_utility.trace (' p_element_entry_id = '
1158: ||to_char (p_element_entry_id));
1159: hr_utility.trace (' p_date = '
1160: ||to_char (p_date));
1161: hr_utility.trace ('');
1162: --
1163: end check_parameters;
1157: hr_utility.trace (' p_element_entry_id = '
1158: ||to_char (p_element_entry_id));
1159: hr_utility.trace (' p_date = '
1160: ||to_char (p_date));
1161: hr_utility.trace ('');
1162: --
1163: end check_parameters;
1164: --
1165: begin
1247: and p_date between ee.effective_start_date
1248: and ee.effective_end_date;
1249: exception
1250: when no_data_found then
1251: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1252: hr_utility.set_message_token('PROCEDURE',
1253: 'hrentmnt.cache_element_entry');
1254: hr_utility.set_message_token('STEP','1');
1255: hr_utility.raise_error;
1248: and ee.effective_end_date;
1249: exception
1250: when no_data_found then
1251: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1252: hr_utility.set_message_token('PROCEDURE',
1253: 'hrentmnt.cache_element_entry');
1254: hr_utility.set_message_token('STEP','1');
1255: hr_utility.raise_error;
1256: end;
1250: when no_data_found then
1251: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1252: hr_utility.set_message_token('PROCEDURE',
1253: 'hrentmnt.cache_element_entry');
1254: hr_utility.set_message_token('STEP','1');
1255: hr_utility.raise_error;
1256: end;
1257: --
1258: -- Retrieve all entry values for the element entry and convert into screen
1251: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1252: hr_utility.set_message_token('PROCEDURE',
1253: 'hrentmnt.cache_element_entry');
1254: hr_utility.set_message_token('STEP','1');
1255: hr_utility.raise_error;
1256: end;
1257: --
1258: -- Retrieve all entry values for the element entry and convert into screen
1259: -- format. Store these in a table to be used later by the element entry
1269: v_db_format := v_entry_value.screen_entry_value;
1270:
1271: -- start of change 115.30
1272: if g_debug then
1273: hr_utility.trace('*****before*****');
1274: hr_utility.trace('*****v_entry_value.lookup_type>' ||
1275: v_entry_value.lookup_type || '<');
1276: hr_utility.trace('*****v_entry_value.value_set_id>' ||
1277: v_entry_value.value_set_id || '<');
1270:
1271: -- start of change 115.30
1272: if g_debug then
1273: hr_utility.trace('*****before*****');
1274: hr_utility.trace('*****v_entry_value.lookup_type>' ||
1275: v_entry_value.lookup_type || '<');
1276: hr_utility.trace('*****v_entry_value.value_set_id>' ||
1277: v_entry_value.value_set_id || '<');
1278: hr_utility.trace('*****v_entry_value.screen_entry_value>' ||
1272: if g_debug then
1273: hr_utility.trace('*****before*****');
1274: hr_utility.trace('*****v_entry_value.lookup_type>' ||
1275: v_entry_value.lookup_type || '<');
1276: hr_utility.trace('*****v_entry_value.value_set_id>' ||
1277: v_entry_value.value_set_id || '<');
1278: hr_utility.trace('*****v_entry_value.screen_entry_value>' ||
1279: v_entry_value.screen_entry_value || '<');
1280: end if;
1274: hr_utility.trace('*****v_entry_value.lookup_type>' ||
1275: v_entry_value.lookup_type || '<');
1276: hr_utility.trace('*****v_entry_value.value_set_id>' ||
1277: v_entry_value.value_set_id || '<');
1278: hr_utility.trace('*****v_entry_value.screen_entry_value>' ||
1279: v_entry_value.screen_entry_value || '<');
1280: end if;
1281: --
1282: -- if entry has lookup and the entry_value is not null,
1313: v_entry_value.input_currency_code);
1314: end if;
1315:
1316: if g_debug then
1317: hr_utility.trace('*****v_screen_format>' || v_screen_format || '<');
1318: hr_utility.trace('*****v_db_format>' || v_db_format || '<');
1319: hr_utility.trace('*****after*****');
1320: end if;
1321: -- end of change 115.30
1314: end if;
1315:
1316: if g_debug then
1317: hr_utility.trace('*****v_screen_format>' || v_screen_format || '<');
1318: hr_utility.trace('*****v_db_format>' || v_db_format || '<');
1319: hr_utility.trace('*****after*****');
1320: end if;
1321: -- end of change 115.30
1322:
1315:
1316: if g_debug then
1317: hr_utility.trace('*****v_screen_format>' || v_screen_format || '<');
1318: hr_utility.trace('*****v_db_format>' || v_db_format || '<');
1319: hr_utility.trace('*****after*****');
1320: end if;
1321: -- end of change 115.30
1322:
1323: --
1334: p_input_value_id_tbl := v_input_value_id_tbl;
1335: p_entry_value_tbl := v_entry_value_tbl;
1336: --
1337: if g_debug then
1338: hr_utility.trace('Out hrentmnt.cache_element_entry');
1339: end if;
1340: --
1341: end cache_element_entry;
1342: --
1365: procedure check_parameters is
1366: --
1367: begin
1368: --
1369: hr_utility.trace('In hrentmnt.check_entry_overridden');
1370: hr_utility.trace ('');
1371: hr_utility.trace(' p_assignment_id = '
1372: ||to_char (p_assignment_id));
1373: hr_utility.trace(' p_element_entry_id = '
1366: --
1367: begin
1368: --
1369: hr_utility.trace('In hrentmnt.check_entry_overridden');
1370: hr_utility.trace ('');
1371: hr_utility.trace(' p_assignment_id = '
1372: ||to_char (p_assignment_id));
1373: hr_utility.trace(' p_element_entry_id = '
1374: ||to_char (p_element_entry_id));
1367: begin
1368: --
1369: hr_utility.trace('In hrentmnt.check_entry_overridden');
1370: hr_utility.trace ('');
1371: hr_utility.trace(' p_assignment_id = '
1372: ||to_char (p_assignment_id));
1373: hr_utility.trace(' p_element_entry_id = '
1374: ||to_char (p_element_entry_id));
1375: hr_utility.trace(' p_validation_start_date = '
1369: hr_utility.trace('In hrentmnt.check_entry_overridden');
1370: hr_utility.trace ('');
1371: hr_utility.trace(' p_assignment_id = '
1372: ||to_char (p_assignment_id));
1373: hr_utility.trace(' p_element_entry_id = '
1374: ||to_char (p_element_entry_id));
1375: hr_utility.trace(' p_validation_start_date = '
1376: ||to_char (p_validation_start_date));
1377: hr_utility.trace(' p_validation_end_date = '
1371: hr_utility.trace(' p_assignment_id = '
1372: ||to_char (p_assignment_id));
1373: hr_utility.trace(' p_element_entry_id = '
1374: ||to_char (p_element_entry_id));
1375: hr_utility.trace(' p_validation_start_date = '
1376: ||to_char (p_validation_start_date));
1377: hr_utility.trace(' p_validation_end_date = '
1378: ||to_char (p_validation_end_date));
1379: hr_utility.trace ('');
1373: hr_utility.trace(' p_element_entry_id = '
1374: ||to_char (p_element_entry_id));
1375: hr_utility.trace(' p_validation_start_date = '
1376: ||to_char (p_validation_start_date));
1377: hr_utility.trace(' p_validation_end_date = '
1378: ||to_char (p_validation_end_date));
1379: hr_utility.trace ('');
1380: --
1381: end check_parameters;
1375: hr_utility.trace(' p_validation_start_date = '
1376: ||to_char (p_validation_start_date));
1377: hr_utility.trace(' p_validation_end_date = '
1378: ||to_char (p_validation_end_date));
1379: hr_utility.trace ('');
1380: --
1381: end check_parameters;
1382: --
1383: begin
1407: when no_data_found then null;
1408: end;
1409: --
1410: if v_entry_overridden = 'Y' then
1411: hr_utility.set_message(801, 'HR_6304_ELE_ENTRY_DT_DEL_ADJ');
1412: hr_utility.raise_error;
1413: end if;
1414: --
1415: end check_entry_overridden;
1408: end;
1409: --
1410: if v_entry_overridden = 'Y' then
1411: hr_utility.set_message(801, 'HR_6304_ELE_ENTRY_DT_DEL_ADJ');
1412: hr_utility.raise_error;
1413: end if;
1414: --
1415: end check_entry_overridden;
1416: --
1487: procedure check_parameters is
1488: --
1489: begin
1490: --
1491: hr_utility.trace('In hrentmnt.validate_adjust_entry');
1492: hr_utility.trace ('');
1493: hr_utility.trace (' p_mode = '
1494: ||p_mode);
1495: hr_utility.trace (' p_assignment_id = '
1488: --
1489: begin
1490: --
1491: hr_utility.trace('In hrentmnt.validate_adjust_entry');
1492: hr_utility.trace ('');
1493: hr_utility.trace (' p_mode = '
1494: ||p_mode);
1495: hr_utility.trace (' p_assignment_id = '
1496: ||to_char (p_assignment_id));
1489: begin
1490: --
1491: hr_utility.trace('In hrentmnt.validate_adjust_entry');
1492: hr_utility.trace ('');
1493: hr_utility.trace (' p_mode = '
1494: ||p_mode);
1495: hr_utility.trace (' p_assignment_id = '
1496: ||to_char (p_assignment_id));
1497: hr_utility.trace (' p_element_entry_id = '
1491: hr_utility.trace('In hrentmnt.validate_adjust_entry');
1492: hr_utility.trace ('');
1493: hr_utility.trace (' p_mode = '
1494: ||p_mode);
1495: hr_utility.trace (' p_assignment_id = '
1496: ||to_char (p_assignment_id));
1497: hr_utility.trace (' p_element_entry_id = '
1498: ||to_char (p_element_entry_id));
1499: hr_utility.trace (' p_start_or_end_date = '
1493: hr_utility.trace (' p_mode = '
1494: ||p_mode);
1495: hr_utility.trace (' p_assignment_id = '
1496: ||to_char (p_assignment_id));
1497: hr_utility.trace (' p_element_entry_id = '
1498: ||to_char (p_element_entry_id));
1499: hr_utility.trace (' p_start_or_end_date = '
1500: ||p_start_or_end_date);
1501: hr_utility.trace (' p_old_date = '
1495: hr_utility.trace (' p_assignment_id = '
1496: ||to_char (p_assignment_id));
1497: hr_utility.trace (' p_element_entry_id = '
1498: ||to_char (p_element_entry_id));
1499: hr_utility.trace (' p_start_or_end_date = '
1500: ||p_start_or_end_date);
1501: hr_utility.trace (' p_old_date = '
1502: ||to_char (p_old_date));
1503: hr_utility.trace (' p_new_date = '
1497: hr_utility.trace (' p_element_entry_id = '
1498: ||to_char (p_element_entry_id));
1499: hr_utility.trace (' p_start_or_end_date = '
1500: ||p_start_or_end_date);
1501: hr_utility.trace (' p_old_date = '
1502: ||to_char (p_old_date));
1503: hr_utility.trace (' p_new_date = '
1504: ||to_char (p_new_date));
1505: hr_utility.trace (' p_effective_start_date = '
1499: hr_utility.trace (' p_start_or_end_date = '
1500: ||p_start_or_end_date);
1501: hr_utility.trace (' p_old_date = '
1502: ||to_char (p_old_date));
1503: hr_utility.trace (' p_new_date = '
1504: ||to_char (p_new_date));
1505: hr_utility.trace (' p_effective_start_date = '
1506: ||to_char (p_effective_start_date));
1507: hr_utility.trace (' p_effective_end_date = '
1501: hr_utility.trace (' p_old_date = '
1502: ||to_char (p_old_date));
1503: hr_utility.trace (' p_new_date = '
1504: ||to_char (p_new_date));
1505: hr_utility.trace (' p_effective_start_date = '
1506: ||to_char (p_effective_start_date));
1507: hr_utility.trace (' p_effective_end_date = '
1508: ||to_char (p_effective_end_date));
1509: hr_utility.trace (' p_entries_changed = '
1503: hr_utility.trace (' p_new_date = '
1504: ||to_char (p_new_date));
1505: hr_utility.trace (' p_effective_start_date = '
1506: ||to_char (p_effective_start_date));
1507: hr_utility.trace (' p_effective_end_date = '
1508: ||to_char (p_effective_end_date));
1509: hr_utility.trace (' p_entries_changed = '
1510: ||p_entries_changed);
1511: hr_utility.trace ('');
1505: hr_utility.trace (' p_effective_start_date = '
1506: ||to_char (p_effective_start_date));
1507: hr_utility.trace (' p_effective_end_date = '
1508: ||to_char (p_effective_end_date));
1509: hr_utility.trace (' p_entries_changed = '
1510: ||p_entries_changed);
1511: hr_utility.trace ('');
1512: --
1513: end check_parameters;
1507: hr_utility.trace (' p_effective_end_date = '
1508: ||to_char (p_effective_end_date));
1509: hr_utility.trace (' p_entries_changed = '
1510: ||p_entries_changed);
1511: hr_utility.trace ('');
1512: --
1513: end check_parameters;
1514: --
1515: begin
1528: -- The cursor unexpectedly returned no rows. Present an error message
1529: -- which includes all the procedure's parameters to assist diagnosis of
1530: -- why this error occurred.
1531: --
1532: hr_utility.set_message(801, 'HR_51058_PAY_VALIDATE_ADJUST');
1533: hr_utility.set_message_token('P_MODE',p_mode);
1534: hr_utility.set_message_token('P_ASSIGNMENT_ID',p_assignment_id);
1535: hr_utility.set_message_token('P_ELEMENT_ENTRY_ID',p_element_entry_id);
1536: hr_utility.set_message_token('P_START_OR_END_DATE',p_start_or_end_date);
1529: -- which includes all the procedure's parameters to assist diagnosis of
1530: -- why this error occurred.
1531: --
1532: hr_utility.set_message(801, 'HR_51058_PAY_VALIDATE_ADJUST');
1533: hr_utility.set_message_token('P_MODE',p_mode);
1534: hr_utility.set_message_token('P_ASSIGNMENT_ID',p_assignment_id);
1535: hr_utility.set_message_token('P_ELEMENT_ENTRY_ID',p_element_entry_id);
1536: hr_utility.set_message_token('P_START_OR_END_DATE',p_start_or_end_date);
1537: hr_utility.set_message_token('P_OLD_DATE',p_old_date);
1530: -- why this error occurred.
1531: --
1532: hr_utility.set_message(801, 'HR_51058_PAY_VALIDATE_ADJUST');
1533: hr_utility.set_message_token('P_MODE',p_mode);
1534: hr_utility.set_message_token('P_ASSIGNMENT_ID',p_assignment_id);
1535: hr_utility.set_message_token('P_ELEMENT_ENTRY_ID',p_element_entry_id);
1536: hr_utility.set_message_token('P_START_OR_END_DATE',p_start_or_end_date);
1537: hr_utility.set_message_token('P_OLD_DATE',p_old_date);
1538: hr_utility.set_message_token('P_NEW_DATE',p_new_date);
1531: --
1532: hr_utility.set_message(801, 'HR_51058_PAY_VALIDATE_ADJUST');
1533: hr_utility.set_message_token('P_MODE',p_mode);
1534: hr_utility.set_message_token('P_ASSIGNMENT_ID',p_assignment_id);
1535: hr_utility.set_message_token('P_ELEMENT_ENTRY_ID',p_element_entry_id);
1536: hr_utility.set_message_token('P_START_OR_END_DATE',p_start_or_end_date);
1537: hr_utility.set_message_token('P_OLD_DATE',p_old_date);
1538: hr_utility.set_message_token('P_NEW_DATE',p_new_date);
1539: hr_utility.set_message_token('P_EFFECTIVE_START_DATE',p_effective_start_date);
1532: hr_utility.set_message(801, 'HR_51058_PAY_VALIDATE_ADJUST');
1533: hr_utility.set_message_token('P_MODE',p_mode);
1534: hr_utility.set_message_token('P_ASSIGNMENT_ID',p_assignment_id);
1535: hr_utility.set_message_token('P_ELEMENT_ENTRY_ID',p_element_entry_id);
1536: hr_utility.set_message_token('P_START_OR_END_DATE',p_start_or_end_date);
1537: hr_utility.set_message_token('P_OLD_DATE',p_old_date);
1538: hr_utility.set_message_token('P_NEW_DATE',p_new_date);
1539: hr_utility.set_message_token('P_EFFECTIVE_START_DATE',p_effective_start_date);
1540: hr_utility.set_message_token('P_EFFECTIVE_END_DATE',p_effective_end_date);
1533: hr_utility.set_message_token('P_MODE',p_mode);
1534: hr_utility.set_message_token('P_ASSIGNMENT_ID',p_assignment_id);
1535: hr_utility.set_message_token('P_ELEMENT_ENTRY_ID',p_element_entry_id);
1536: hr_utility.set_message_token('P_START_OR_END_DATE',p_start_or_end_date);
1537: hr_utility.set_message_token('P_OLD_DATE',p_old_date);
1538: hr_utility.set_message_token('P_NEW_DATE',p_new_date);
1539: hr_utility.set_message_token('P_EFFECTIVE_START_DATE',p_effective_start_date);
1540: hr_utility.set_message_token('P_EFFECTIVE_END_DATE',p_effective_end_date);
1541: hr_utility.set_message_token('P_ENTRIES_CHANGED',p_entries_changed);
1534: hr_utility.set_message_token('P_ASSIGNMENT_ID',p_assignment_id);
1535: hr_utility.set_message_token('P_ELEMENT_ENTRY_ID',p_element_entry_id);
1536: hr_utility.set_message_token('P_START_OR_END_DATE',p_start_or_end_date);
1537: hr_utility.set_message_token('P_OLD_DATE',p_old_date);
1538: hr_utility.set_message_token('P_NEW_DATE',p_new_date);
1539: hr_utility.set_message_token('P_EFFECTIVE_START_DATE',p_effective_start_date);
1540: hr_utility.set_message_token('P_EFFECTIVE_END_DATE',p_effective_end_date);
1541: hr_utility.set_message_token('P_ENTRIES_CHANGED',p_entries_changed);
1542: hr_utility.raise_error;
1535: hr_utility.set_message_token('P_ELEMENT_ENTRY_ID',p_element_entry_id);
1536: hr_utility.set_message_token('P_START_OR_END_DATE',p_start_or_end_date);
1537: hr_utility.set_message_token('P_OLD_DATE',p_old_date);
1538: hr_utility.set_message_token('P_NEW_DATE',p_new_date);
1539: hr_utility.set_message_token('P_EFFECTIVE_START_DATE',p_effective_start_date);
1540: hr_utility.set_message_token('P_EFFECTIVE_END_DATE',p_effective_end_date);
1541: hr_utility.set_message_token('P_ENTRIES_CHANGED',p_entries_changed);
1542: hr_utility.raise_error;
1543: end if;
1536: hr_utility.set_message_token('P_START_OR_END_DATE',p_start_or_end_date);
1537: hr_utility.set_message_token('P_OLD_DATE',p_old_date);
1538: hr_utility.set_message_token('P_NEW_DATE',p_new_date);
1539: hr_utility.set_message_token('P_EFFECTIVE_START_DATE',p_effective_start_date);
1540: hr_utility.set_message_token('P_EFFECTIVE_END_DATE',p_effective_end_date);
1541: hr_utility.set_message_token('P_ENTRIES_CHANGED',p_entries_changed);
1542: hr_utility.raise_error;
1543: end if;
1544: close csr_ele_info;
1537: hr_utility.set_message_token('P_OLD_DATE',p_old_date);
1538: hr_utility.set_message_token('P_NEW_DATE',p_new_date);
1539: hr_utility.set_message_token('P_EFFECTIVE_START_DATE',p_effective_start_date);
1540: hr_utility.set_message_token('P_EFFECTIVE_END_DATE',p_effective_end_date);
1541: hr_utility.set_message_token('P_ENTRIES_CHANGED',p_entries_changed);
1542: hr_utility.raise_error;
1543: end if;
1544: close csr_ele_info;
1545: --
1538: hr_utility.set_message_token('P_NEW_DATE',p_new_date);
1539: hr_utility.set_message_token('P_EFFECTIVE_START_DATE',p_effective_start_date);
1540: hr_utility.set_message_token('P_EFFECTIVE_END_DATE',p_effective_end_date);
1541: hr_utility.set_message_token('P_ENTRIES_CHANGED',p_entries_changed);
1542: hr_utility.raise_error;
1543: end if;
1544: close csr_ele_info;
1545: --
1546: -- Set the dates over which the change is taking place.
1693: --
1694: end if;
1695: --
1696: if g_debug then
1697: hr_utility.trace('Out hrentmnt.validate_adjust_entry');
1698: end if;
1699: --
1700: end validate_adjust_entry;
1701: --
1756: (l_prof_value = 'I' and l_non_payments_flag = 'N')
1757: then
1758: -- Either no entries can be purged or attempting to
1759: -- purge a payments type of entry when we shouldn't.
1760: hr_utility.set_message (800,'HR_33000_ENTRY_CANT_PURGE');
1761: hr_utility.raise_error;
1762: end if;
1763: --
1764: end if;
1757: then
1758: -- Either no entries can be purged or attempting to
1759: -- purge a payments type of entry when we shouldn't.
1760: hr_utility.set_message (800,'HR_33000_ENTRY_CANT_PURGE');
1761: hr_utility.raise_error;
1762: end if;
1763: --
1764: end if;
1765: --
1773: p_new_element_entry_ESD in date,
1774: p_new_element_entry_EED in date)
1775: is
1776: begin
1777: hr_utility.trace('> hrentmnt.maintain_dependent_entities');
1778:
1779: if g_debug then
1780: hr_utility.trace('p_element_entry_id >' || p_element_entry_id || '<');
1781: hr_utility.trace('p_element_entry_ESD >' || p_element_entry_ESD || '<');
1776: begin
1777: hr_utility.trace('> hrentmnt.maintain_dependent_entities');
1778:
1779: if g_debug then
1780: hr_utility.trace('p_element_entry_id >' || p_element_entry_id || '<');
1781: hr_utility.trace('p_element_entry_ESD >' || p_element_entry_ESD || '<');
1782: hr_utility.trace('p_element_entry_EED >' || p_element_entry_EED || '<');
1783:
1784: hr_utility.trace('p_new_element_entry_id >' || p_new_element_entry_id || '<');
1777: hr_utility.trace('> hrentmnt.maintain_dependent_entities');
1778:
1779: if g_debug then
1780: hr_utility.trace('p_element_entry_id >' || p_element_entry_id || '<');
1781: hr_utility.trace('p_element_entry_ESD >' || p_element_entry_ESD || '<');
1782: hr_utility.trace('p_element_entry_EED >' || p_element_entry_EED || '<');
1783:
1784: hr_utility.trace('p_new_element_entry_id >' || p_new_element_entry_id || '<');
1785: hr_utility.trace('p_new_element_entry_ESD>' || p_new_element_entry_ESD || '<');
1778:
1779: if g_debug then
1780: hr_utility.trace('p_element_entry_id >' || p_element_entry_id || '<');
1781: hr_utility.trace('p_element_entry_ESD >' || p_element_entry_ESD || '<');
1782: hr_utility.trace('p_element_entry_EED >' || p_element_entry_EED || '<');
1783:
1784: hr_utility.trace('p_new_element_entry_id >' || p_new_element_entry_id || '<');
1785: hr_utility.trace('p_new_element_entry_ESD>' || p_new_element_entry_ESD || '<');
1786: hr_utility.trace('p_new_element_entry_EED>' || p_new_element_entry_EED || '<');
1780: hr_utility.trace('p_element_entry_id >' || p_element_entry_id || '<');
1781: hr_utility.trace('p_element_entry_ESD >' || p_element_entry_ESD || '<');
1782: hr_utility.trace('p_element_entry_EED >' || p_element_entry_EED || '<');
1783:
1784: hr_utility.trace('p_new_element_entry_id >' || p_new_element_entry_id || '<');
1785: hr_utility.trace('p_new_element_entry_ESD>' || p_new_element_entry_ESD || '<');
1786: hr_utility.trace('p_new_element_entry_EED>' || p_new_element_entry_EED || '<');
1787: end if;
1788:
1781: hr_utility.trace('p_element_entry_ESD >' || p_element_entry_ESD || '<');
1782: hr_utility.trace('p_element_entry_EED >' || p_element_entry_EED || '<');
1783:
1784: hr_utility.trace('p_new_element_entry_id >' || p_new_element_entry_id || '<');
1785: hr_utility.trace('p_new_element_entry_ESD>' || p_new_element_entry_ESD || '<');
1786: hr_utility.trace('p_new_element_entry_EED>' || p_new_element_entry_EED || '<');
1787: end if;
1788:
1789: null;
1782: hr_utility.trace('p_element_entry_EED >' || p_element_entry_EED || '<');
1783:
1784: hr_utility.trace('p_new_element_entry_id >' || p_new_element_entry_id || '<');
1785: hr_utility.trace('p_new_element_entry_ESD>' || p_new_element_entry_ESD || '<');
1786: hr_utility.trace('p_new_element_entry_EED>' || p_new_element_entry_EED || '<');
1787: end if;
1788:
1789: null;
1790:
2007: --
2008: begin
2009: --
2010: if g_debug then
2011: hr_utility.set_location(l_proc,10);
2012: hr_utility.trace('********** BEFORE OAB **********');
2013: end if;
2014: --
2015: -- Read the prof value
2008: begin
2009: --
2010: if g_debug then
2011: hr_utility.set_location(l_proc,10);
2012: hr_utility.trace('********** BEFORE OAB **********');
2013: end if;
2014: --
2015: -- Read the prof value
2016: --
2015: -- Read the prof value
2016: --
2017: fnd_profile.get('PAY_ORIG_EL_BEHAVE', l_prof_value);
2018: if g_debug then
2019: hr_utility.trace('l_prof_value>' || l_prof_value || '<');
2020: end if;
2021: --
2022: -- Check if any other entries can be created up to the REE's EED,
2023: -- create REE from VSD to REE's EED
2027: -- change 115.28
2028: and p_ee_creator_type <> 'SP' then
2029: --
2030: if g_debug then
2031: hr_utility.set_location(l_proc,20);
2032: hr_utility.trace('EE being updated>' || p_element_entry_id || '<');
2033: hr_utility.trace('VSD>' || p_validation_start_date || '<');
2034: hr_utility.trace('VED>' || p_validation_end_date || '<');
2035: hr_utility.trace('EE ESD>' || p_ee_effective_start_date || '<');
2028: and p_ee_creator_type <> 'SP' then
2029: --
2030: if g_debug then
2031: hr_utility.set_location(l_proc,20);
2032: hr_utility.trace('EE being updated>' || p_element_entry_id || '<');
2033: hr_utility.trace('VSD>' || p_validation_start_date || '<');
2034: hr_utility.trace('VED>' || p_validation_end_date || '<');
2035: hr_utility.trace('EE ESD>' || p_ee_effective_start_date || '<');
2036: hr_utility.trace('EE EED>' || p_ee_effective_end_date || '<');
2029: --
2030: if g_debug then
2031: hr_utility.set_location(l_proc,20);
2032: hr_utility.trace('EE being updated>' || p_element_entry_id || '<');
2033: hr_utility.trace('VSD>' || p_validation_start_date || '<');
2034: hr_utility.trace('VED>' || p_validation_end_date || '<');
2035: hr_utility.trace('EE ESD>' || p_ee_effective_start_date || '<');
2036: hr_utility.trace('EE EED>' || p_ee_effective_end_date || '<');
2037: end if;
2030: if g_debug then
2031: hr_utility.set_location(l_proc,20);
2032: hr_utility.trace('EE being updated>' || p_element_entry_id || '<');
2033: hr_utility.trace('VSD>' || p_validation_start_date || '<');
2034: hr_utility.trace('VED>' || p_validation_end_date || '<');
2035: hr_utility.trace('EE ESD>' || p_ee_effective_start_date || '<');
2036: hr_utility.trace('EE EED>' || p_ee_effective_end_date || '<');
2037: end if;
2038: --
2031: hr_utility.set_location(l_proc,20);
2032: hr_utility.trace('EE being updated>' || p_element_entry_id || '<');
2033: hr_utility.trace('VSD>' || p_validation_start_date || '<');
2034: hr_utility.trace('VED>' || p_validation_end_date || '<');
2035: hr_utility.trace('EE ESD>' || p_ee_effective_start_date || '<');
2036: hr_utility.trace('EE EED>' || p_ee_effective_end_date || '<');
2037: end if;
2038: --
2039: -- Fetch the assignment criteria
2032: hr_utility.trace('EE being updated>' || p_element_entry_id || '<');
2033: hr_utility.trace('VSD>' || p_validation_start_date || '<');
2034: hr_utility.trace('VED>' || p_validation_end_date || '<');
2035: hr_utility.trace('EE ESD>' || p_ee_effective_start_date || '<');
2036: hr_utility.trace('EE EED>' || p_ee_effective_end_date || '<');
2037: end if;
2038: --
2039: -- Fetch the assignment criteria
2040: open_asg_criteria_cur(p_assignment_id, p_validation_start_date, l_asg_criteria_cv);
2062: --
2063: loop
2064: --
2065: if g_debug then
2066: hr_utility.set_location(l_proc,25);
2067: end if;
2068: --
2069: fetch l_eligible_links_cv into rec_eligible_links;
2070: exit when l_eligible_links_cv%notfound;
2069: fetch l_eligible_links_cv into rec_eligible_links;
2070: exit when l_eligible_links_cv%notfound;
2071: --
2072: if g_debug then
2073: hr_utility.set_location(l_proc,30);
2074: hr_utility.trace('***** element_link_id>' ||
2075: rec_eligible_links.element_link_id || '<');
2076: hr_utility.trace('***** ESD of EL>' ||
2077: rec_eligible_links.effective_start_date || '<');
2070: exit when l_eligible_links_cv%notfound;
2071: --
2072: if g_debug then
2073: hr_utility.set_location(l_proc,30);
2074: hr_utility.trace('***** element_link_id>' ||
2075: rec_eligible_links.element_link_id || '<');
2076: hr_utility.trace('***** ESD of EL>' ||
2077: rec_eligible_links.effective_start_date || '<');
2078: hr_utility.trace('***** EED of EL>' ||
2072: if g_debug then
2073: hr_utility.set_location(l_proc,30);
2074: hr_utility.trace('***** element_link_id>' ||
2075: rec_eligible_links.element_link_id || '<');
2076: hr_utility.trace('***** ESD of EL>' ||
2077: rec_eligible_links.effective_start_date || '<');
2078: hr_utility.trace('***** EED of EL>' ||
2079: rec_eligible_links.effective_end_date || '<');
2080: end if;
2074: hr_utility.trace('***** element_link_id>' ||
2075: rec_eligible_links.element_link_id || '<');
2076: hr_utility.trace('***** ESD of EL>' ||
2077: rec_eligible_links.effective_start_date || '<');
2078: hr_utility.trace('***** EED of EL>' ||
2079: rec_eligible_links.effective_end_date || '<');
2080: end if;
2081: --
2082: l_calc_ee_esd := greatest(p_ee_effective_start_date,
2166: end if;
2167: --
2168: if g_debug then
2169: --
2170: hr_utility.set_location(l_proc,40);
2171: hr_utility.trace('***** new EE>' || l_eeid_out || '<');
2172: hr_utility.trace('***** actual ESD of new EE>' ||
2173: l_calc_ee_esd || '<');
2174: hr_utility.trace('***** actual EED of new EE>' ||
2167: --
2168: if g_debug then
2169: --
2170: hr_utility.set_location(l_proc,40);
2171: hr_utility.trace('***** new EE>' || l_eeid_out || '<');
2172: hr_utility.trace('***** actual ESD of new EE>' ||
2173: l_calc_ee_esd || '<');
2174: hr_utility.trace('***** actual EED of new EE>' ||
2175: l_ee_eed_out || '<');
2168: if g_debug then
2169: --
2170: hr_utility.set_location(l_proc,40);
2171: hr_utility.trace('***** new EE>' || l_eeid_out || '<');
2172: hr_utility.trace('***** actual ESD of new EE>' ||
2173: l_calc_ee_esd || '<');
2174: hr_utility.trace('***** actual EED of new EE>' ||
2175: l_ee_eed_out || '<');
2176: --
2170: hr_utility.set_location(l_proc,40);
2171: hr_utility.trace('***** new EE>' || l_eeid_out || '<');
2172: hr_utility.trace('***** actual ESD of new EE>' ||
2173: l_calc_ee_esd || '<');
2174: hr_utility.trace('***** actual EED of new EE>' ||
2175: l_ee_eed_out || '<');
2176: --
2177: end if;
2178: --
2187: -- nb. only 1 EE exists at this stage, therefore no need
2188: -- to use ESD and EED
2189: --
2190: if g_debug then
2191: hr_utility.set_location(l_proc,50);
2192: hr_utility.trace('***** bring EED of new EE back');
2193: end if;
2194: --
2195: -- Change l_ee_eed_out here, for separate update to
2188: -- to use ESD and EED
2189: --
2190: if g_debug then
2191: hr_utility.set_location(l_proc,50);
2192: hr_utility.trace('***** bring EED of new EE back');
2193: end if;
2194: --
2195: -- Change l_ee_eed_out here, for separate update to
2196: -- pay_element_entries_f, below, which *always* occurs.
2230: -- call routine to maintain entities with FKs to element entry
2231: -- row just date ended and newly created
2232: --
2233: if g_debug then
2234: hr_utility.set_location(l_proc,60);
2235: hr_utility.trace('***** maintain dependent entities');
2236: end if;
2237: --
2238: maintain_dependent_entities(
2231: -- row just date ended and newly created
2232: --
2233: if g_debug then
2234: hr_utility.set_location(l_proc,60);
2235: hr_utility.trace('***** maintain dependent entities');
2236: end if;
2237: --
2238: maintain_dependent_entities(
2239: p_element_entry_id,
2244: l_calc_ee_eed
2245: );
2246: --
2247: if g_debug then
2248: hr_utility.set_location(l_proc,70);
2249: hr_utility.trace('********** AFTER OAB **********');
2250: end if;
2251: --
2252: p_entry_recreated := l_entry_recreated;
2245: );
2246: --
2247: if g_debug then
2248: hr_utility.set_location(l_proc,70);
2249: hr_utility.trace('********** AFTER OAB **********');
2250: end if;
2251: --
2252: p_entry_recreated := l_entry_recreated;
2253: --
2421: is
2422: --
2423: begin
2424: --
2425: hr_utility.trace('In hrentmnt.remove_ineligible_recurring');
2426: hr_utility.trace ('');
2427: hr_utility.trace (' p_assignment_id = '||to_char (p_assignment_id));
2428: hr_utility.trace (' p_entries_changed = '||p_entries_changed);
2429: hr_utility.trace (' p_validation_start_date = '||to_char(p_validation_start_date,'DD-MON-YYYY'));
2422: --
2423: begin
2424: --
2425: hr_utility.trace('In hrentmnt.remove_ineligible_recurring');
2426: hr_utility.trace ('');
2427: hr_utility.trace (' p_assignment_id = '||to_char (p_assignment_id));
2428: hr_utility.trace (' p_entries_changed = '||p_entries_changed);
2429: hr_utility.trace (' p_validation_start_date = '||to_char(p_validation_start_date,'DD-MON-YYYY'));
2430: hr_utility.trace (' p_validation_end_date = '||to_char(p_validation_end_date,'DD-MON-YYYY'));
2423: begin
2424: --
2425: hr_utility.trace('In hrentmnt.remove_ineligible_recurring');
2426: hr_utility.trace ('');
2427: hr_utility.trace (' p_assignment_id = '||to_char (p_assignment_id));
2428: hr_utility.trace (' p_entries_changed = '||p_entries_changed);
2429: hr_utility.trace (' p_validation_start_date = '||to_char(p_validation_start_date,'DD-MON-YYYY'));
2430: hr_utility.trace (' p_validation_end_date = '||to_char(p_validation_end_date,'DD-MON-YYYY'));
2431: hr_utility.trace (' p_dt_mode = '||p_dt_mode);
2424: --
2425: hr_utility.trace('In hrentmnt.remove_ineligible_recurring');
2426: hr_utility.trace ('');
2427: hr_utility.trace (' p_assignment_id = '||to_char (p_assignment_id));
2428: hr_utility.trace (' p_entries_changed = '||p_entries_changed);
2429: hr_utility.trace (' p_validation_start_date = '||to_char(p_validation_start_date,'DD-MON-YYYY'));
2430: hr_utility.trace (' p_validation_end_date = '||to_char(p_validation_end_date,'DD-MON-YYYY'));
2431: hr_utility.trace (' p_dt_mode = '||p_dt_mode);
2432: hr_utility.trace ('');
2425: hr_utility.trace('In hrentmnt.remove_ineligible_recurring');
2426: hr_utility.trace ('');
2427: hr_utility.trace (' p_assignment_id = '||to_char (p_assignment_id));
2428: hr_utility.trace (' p_entries_changed = '||p_entries_changed);
2429: hr_utility.trace (' p_validation_start_date = '||to_char(p_validation_start_date,'DD-MON-YYYY'));
2430: hr_utility.trace (' p_validation_end_date = '||to_char(p_validation_end_date,'DD-MON-YYYY'));
2431: hr_utility.trace (' p_dt_mode = '||p_dt_mode);
2432: hr_utility.trace ('');
2433: --
2426: hr_utility.trace ('');
2427: hr_utility.trace (' p_assignment_id = '||to_char (p_assignment_id));
2428: hr_utility.trace (' p_entries_changed = '||p_entries_changed);
2429: hr_utility.trace (' p_validation_start_date = '||to_char(p_validation_start_date,'DD-MON-YYYY'));
2430: hr_utility.trace (' p_validation_end_date = '||to_char(p_validation_end_date,'DD-MON-YYYY'));
2431: hr_utility.trace (' p_dt_mode = '||p_dt_mode);
2432: hr_utility.trace ('');
2433: --
2434: end check_parameters;
2427: hr_utility.trace (' p_assignment_id = '||to_char (p_assignment_id));
2428: hr_utility.trace (' p_entries_changed = '||p_entries_changed);
2429: hr_utility.trace (' p_validation_start_date = '||to_char(p_validation_start_date,'DD-MON-YYYY'));
2430: hr_utility.trace (' p_validation_end_date = '||to_char(p_validation_end_date,'DD-MON-YYYY'));
2431: hr_utility.trace (' p_dt_mode = '||p_dt_mode);
2432: hr_utility.trace ('');
2433: --
2434: end check_parameters;
2435: --
2428: hr_utility.trace (' p_entries_changed = '||p_entries_changed);
2429: hr_utility.trace (' p_validation_start_date = '||to_char(p_validation_start_date,'DD-MON-YYYY'));
2430: hr_utility.trace (' p_validation_end_date = '||to_char(p_validation_end_date,'DD-MON-YYYY'));
2431: hr_utility.trace (' p_dt_mode = '||p_dt_mode);
2432: hr_utility.trace ('');
2433: --
2434: end check_parameters;
2435: --
2436: --
2465: --
2466: begin
2467: --
2468: if g_debug then
2469: hr_utility.trace ('***** doing normal delete of REE');
2470: hr_utility.trace ('***** caching EE before delete');
2471: end if;
2472: --
2473: hrentmnt.cache_element_entry(
2466: begin
2467: --
2468: if g_debug then
2469: hr_utility.trace ('***** doing normal delete of REE');
2470: hr_utility.trace ('***** caching EE before delete');
2471: end if;
2472: --
2473: hrentmnt.cache_element_entry(
2474: p_element_entry_id,
2521: if not l_entry_recreated then
2522: --
2523: -- Cached entry was not recreated so proceed with deletes
2524: if g_debug then
2525: hr_utility.trace(' Cached entry not recreated. Continuing with delete.');
2526: end if;
2527: --
2528: -- Only delete grossup balance exclusion rows if we are purging the
2529: -- entry.
2599: --
2600: begin
2601: --
2602: if g_debug then
2603: hr_utility.trace ('***** updating "end" date of current REE backwards *****');
2604: hr_utility.trace ('***** VSD|<----- |VED *****');
2605: hr_utility.trace ('***** current |-----------------| *****');
2606: end if;
2607: --
2600: begin
2601: --
2602: if g_debug then
2603: hr_utility.trace ('***** updating "end" date of current REE backwards *****');
2604: hr_utility.trace ('***** VSD|<----- |VED *****');
2605: hr_utility.trace ('***** current |-----------------| *****');
2606: end if;
2607: --
2608: hrentmnt.validate_adjust_entry
2601: --
2602: if g_debug then
2603: hr_utility.trace ('***** updating "end" date of current REE backwards *****');
2604: hr_utility.trace ('***** VSD|<----- |VED *****');
2605: hr_utility.trace ('***** current |-----------------| *****');
2606: end if;
2607: --
2608: hrentmnt.validate_adjust_entry
2609: ('DELETE',
2732: is
2733: begin
2734: --
2735: if g_debug then
2736: hr_utility.trace ('***** updating "start" date of current REE forwards *****');
2737: hr_utility.trace ('***** VSD| ----->|VED *****');
2738: hr_utility.trace ('***** current |-----------------> *****');
2739: end if;
2740: --
2733: begin
2734: --
2735: if g_debug then
2736: hr_utility.trace ('***** updating "start" date of current REE forwards *****');
2737: hr_utility.trace ('***** VSD| ----->|VED *****');
2738: hr_utility.trace ('***** current |-----------------> *****');
2739: end if;
2740: --
2741: hrentmnt.validate_adjust_entry
2734: --
2735: if g_debug then
2736: hr_utility.trace ('***** updating "start" date of current REE forwards *****');
2737: hr_utility.trace ('***** VSD| ----->|VED *****');
2738: hr_utility.trace ('***** current |-----------------> *****');
2739: end if;
2740: --
2741: hrentmnt.validate_adjust_entry
2742: ('DELETE',
2781: -- also maintain salary proposal change date
2782: --
2783: if p_ee_creator_type = 'SP' then
2784: if g_debug then
2785: hr_utility.trace ('***** maintain end date of PP >' ||
2786: (p_validation_end_date + 1) || '<');
2787: end if;
2788: UPDATE PER_PAY_PROPOSALS pp
2789: SET pp.change_date = p_validation_end_date + 1
2808: if p_dt_mode = 'ZAP' then
2809: --
2810: if g_debug then
2811: --
2812: hr_utility.trace('ZAP orphaned entries and entry values');
2813: --
2814: end if;
2815: --
2816: -- Remove orphaned entries and entry values
2826: end loop;
2827: --
2828: if g_debug then
2829: --
2830: hr_utility.trace('Out hrentmnt.remove_ineligible_recurring');
2831: --
2832: end if;
2833: --
2834: return;
2918: --
2919: else
2920: -- start of change 115.23 --
2921: if g_debug then
2922: hr_utility.trace ('***** not adjusting, REE outside validation range *****');
2923: hr_utility.trace ('***** VSD| |VED *****');
2924: hr_utility.trace ('***** current |----| *****');
2925: hr_utility.trace ('***** or *****');
2926: hr_utility.trace ('***** current |-------> *****');
2919: else
2920: -- start of change 115.23 --
2921: if g_debug then
2922: hr_utility.trace ('***** not adjusting, REE outside validation range *****');
2923: hr_utility.trace ('***** VSD| |VED *****');
2924: hr_utility.trace ('***** current |----| *****');
2925: hr_utility.trace ('***** or *****');
2926: hr_utility.trace ('***** current |-------> *****');
2927: end if;
2920: -- start of change 115.23 --
2921: if g_debug then
2922: hr_utility.trace ('***** not adjusting, REE outside validation range *****');
2923: hr_utility.trace ('***** VSD| |VED *****');
2924: hr_utility.trace ('***** current |----| *****');
2925: hr_utility.trace ('***** or *****');
2926: hr_utility.trace ('***** current |-------> *****');
2927: end if;
2928: -- end of change 115.23 --
2921: if g_debug then
2922: hr_utility.trace ('***** not adjusting, REE outside validation range *****');
2923: hr_utility.trace ('***** VSD| |VED *****');
2924: hr_utility.trace ('***** current |----| *****');
2925: hr_utility.trace ('***** or *****');
2926: hr_utility.trace ('***** current |-------> *****');
2927: end if;
2928: -- end of change 115.23 --
2929: end if;
2922: hr_utility.trace ('***** not adjusting, REE outside validation range *****');
2923: hr_utility.trace ('***** VSD| |VED *****');
2924: hr_utility.trace ('***** current |----| *****');
2925: hr_utility.trace ('***** or *****');
2926: hr_utility.trace ('***** current |-------> *****');
2927: end if;
2928: -- end of change 115.23 --
2929: end if;
2930: end loop;
2929: end if;
2930: end loop;
2931: --
2932: if g_debug then
2933: hr_utility.trace('Out hrentmnt.remove_ineligible_recurring');
2934: end if;
2935: --
2936: end remove_ineligible_recurring;
2937: --
3032: asg.effective_start_date)));
3033: --
3034: procedure check_parameters is
3035: begin
3036: hr_utility.trace('In hrentmnt.remove_ineligible_nonrecurring');
3037: --
3038: hr_utility.trace ('');
3039: hr_utility.trace (' p_assignment_id = '
3040: ||to_char(p_assignment_id));
3034: procedure check_parameters is
3035: begin
3036: hr_utility.trace('In hrentmnt.remove_ineligible_nonrecurring');
3037: --
3038: hr_utility.trace ('');
3039: hr_utility.trace (' p_assignment_id = '
3040: ||to_char(p_assignment_id));
3041: hr_utility.trace (' p_validation_start_date = '
3042: ||to_char(p_validation_start_date));
3035: begin
3036: hr_utility.trace('In hrentmnt.remove_ineligible_nonrecurring');
3037: --
3038: hr_utility.trace ('');
3039: hr_utility.trace (' p_assignment_id = '
3040: ||to_char(p_assignment_id));
3041: hr_utility.trace (' p_validation_start_date = '
3042: ||to_char(p_validation_start_date));
3043: hr_utility.trace (' p_validation_end_date = '
3037: --
3038: hr_utility.trace ('');
3039: hr_utility.trace (' p_assignment_id = '
3040: ||to_char(p_assignment_id));
3041: hr_utility.trace (' p_validation_start_date = '
3042: ||to_char(p_validation_start_date));
3043: hr_utility.trace (' p_validation_end_date = '
3044: ||to_char(p_validation_end_date));
3045: hr_utility.trace (' p_entries_changed = '
3039: hr_utility.trace (' p_assignment_id = '
3040: ||to_char(p_assignment_id));
3041: hr_utility.trace (' p_validation_start_date = '
3042: ||to_char(p_validation_start_date));
3043: hr_utility.trace (' p_validation_end_date = '
3044: ||to_char(p_validation_end_date));
3045: hr_utility.trace (' p_entries_changed = '
3046: ||p_entries_changed);
3047: hr_utility.trace ('');
3041: hr_utility.trace (' p_validation_start_date = '
3042: ||to_char(p_validation_start_date));
3043: hr_utility.trace (' p_validation_end_date = '
3044: ||to_char(p_validation_end_date));
3045: hr_utility.trace (' p_entries_changed = '
3046: ||p_entries_changed);
3047: hr_utility.trace ('');
3048: --
3049: end check_parameters;
3043: hr_utility.trace (' p_validation_end_date = '
3044: ||to_char(p_validation_end_date));
3045: hr_utility.trace (' p_entries_changed = '
3046: ||p_entries_changed);
3047: hr_utility.trace ('');
3048: --
3049: end check_parameters;
3050: --
3051: begin
3084: /*Added for 6809717 To enable end dating of invalidated entries
3085: the following code has been added*/
3086:
3087: if g_debug then
3088: hr_utility.trace('before delete');
3089: end if;
3090:
3091: select OBJECT_VERSION_NUMBER into l_obj_ver_num
3092: from pay_element_entries_f
3093: where p_validation_start_date-1 between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE
3094: and element_entry_id=v_entry.element_entry_id;
3095:
3096: if g_debug then
3097: hr_utility.trace(' obj vber no'||l_obj_ver_num);
3098: end if;
3099: pay_element_entry_api.delete_element_entry
3100: (p_datetrack_delete_mode => 'DELETE'
3101: ,p_effective_date => p_validation_start_date-1
3118: --
3119: end loop;
3120: --
3121: if g_debug then
3122: hr_utility.trace('Out hrentmnt.remove_ineligible_nonrecurring');
3123: end if;
3124: --
3125: end remove_ineligible_nonrecurring;
3126: --
3159: procedure check_parameters is
3160: --
3161: begin
3162: --
3163: hr_utility.trace('In hrentmnt.return_entry_dates');
3164: hr_utility.trace ('');
3165: hr_utility.trace (' p_assignment_id = '
3166: ||to_char (p_assignment_id));
3167: hr_utility.trace (' p_asg_start_date = '
3160: --
3161: begin
3162: --
3163: hr_utility.trace('In hrentmnt.return_entry_dates');
3164: hr_utility.trace ('');
3165: hr_utility.trace (' p_assignment_id = '
3166: ||to_char (p_assignment_id));
3167: hr_utility.trace (' p_asg_start_date = '
3168: ||to_char (p_asg_start_date));
3161: begin
3162: --
3163: hr_utility.trace('In hrentmnt.return_entry_dates');
3164: hr_utility.trace ('');
3165: hr_utility.trace (' p_assignment_id = '
3166: ||to_char (p_assignment_id));
3167: hr_utility.trace (' p_asg_start_date = '
3168: ||to_char (p_asg_start_date));
3169: hr_utility.trace (' p_element_link_id = '
3163: hr_utility.trace('In hrentmnt.return_entry_dates');
3164: hr_utility.trace ('');
3165: hr_utility.trace (' p_assignment_id = '
3166: ||to_char (p_assignment_id));
3167: hr_utility.trace (' p_asg_start_date = '
3168: ||to_char (p_asg_start_date));
3169: hr_utility.trace (' p_element_link_id = '
3170: ||to_char (p_element_link_id));
3171: hr_utility.trace (' p_link_start_date = '
3165: hr_utility.trace (' p_assignment_id = '
3166: ||to_char (p_assignment_id));
3167: hr_utility.trace (' p_asg_start_date = '
3168: ||to_char (p_asg_start_date));
3169: hr_utility.trace (' p_element_link_id = '
3170: ||to_char (p_element_link_id));
3171: hr_utility.trace (' p_link_start_date = '
3172: ||to_char (p_link_start_date));
3173: hr_utility.trace (' p_standard_link_flag = '
3167: hr_utility.trace (' p_asg_start_date = '
3168: ||to_char (p_asg_start_date));
3169: hr_utility.trace (' p_element_link_id = '
3170: ||to_char (p_element_link_id));
3171: hr_utility.trace (' p_link_start_date = '
3172: ||to_char (p_link_start_date));
3173: hr_utility.trace (' p_standard_link_flag = '
3174: ||p_standard_link_flag);
3175: hr_utility.trace ('');
3169: hr_utility.trace (' p_element_link_id = '
3170: ||to_char (p_element_link_id));
3171: hr_utility.trace (' p_link_start_date = '
3172: ||to_char (p_link_start_date));
3173: hr_utility.trace (' p_standard_link_flag = '
3174: ||p_standard_link_flag);
3175: hr_utility.trace ('');
3176: --
3177: end check_parameters;
3171: hr_utility.trace (' p_link_start_date = '
3172: ||to_char (p_link_start_date));
3173: hr_utility.trace (' p_standard_link_flag = '
3174: ||p_standard_link_flag);
3175: hr_utility.trace ('');
3176: --
3177: end check_parameters;
3178: --
3179: begin
3232: p_entry_end_date := v_entry_end_date;
3233: end if;
3234: --
3235: if g_debug then
3236: hr_utility.trace('Out hrentmnt.return_entry_dates');
3237: end if;
3238: --
3239: end return_entry_dates;
3240: --
3271: procedure check_parameters is
3272: --
3273: begin
3274: --
3275: hr_utility.trace('In hrentmnt.mult_ent_allowed_flag');
3276: hr_utility.trace ('');
3277: hr_utility.trace (' p_element_link_id = '
3278: ||to_char (p_element_link_id));
3279: hr_utility.trace ('');
3272: --
3273: begin
3274: --
3275: hr_utility.trace('In hrentmnt.mult_ent_allowed_flag');
3276: hr_utility.trace ('');
3277: hr_utility.trace (' p_element_link_id = '
3278: ||to_char (p_element_link_id));
3279: hr_utility.trace ('');
3280: --
3273: begin
3274: --
3275: hr_utility.trace('In hrentmnt.mult_ent_allowed_flag');
3276: hr_utility.trace ('');
3277: hr_utility.trace (' p_element_link_id = '
3278: ||to_char (p_element_link_id));
3279: hr_utility.trace ('');
3280: --
3281: end check_parameters;
3275: hr_utility.trace('In hrentmnt.mult_ent_allowed_flag');
3276: hr_utility.trace ('');
3277: hr_utility.trace (' p_element_link_id = '
3278: ||to_char (p_element_link_id));
3279: hr_utility.trace ('');
3280: --
3281: end check_parameters;
3282: --
3283: begin
3289: open csr_element(p_element_link_id);
3290: fetch csr_element into v_mult_ent_allowed_flag;
3291: if csr_element%notfound then
3292: close csr_element;
3293: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3294: hr_utility.set_message_token('PROCEDURE',
3295: 'hrentmnt.mult_ent_allowed_flag');
3296: hr_utility.set_message_token('STEP','1');
3297: hr_utility.raise_error;
3290: fetch csr_element into v_mult_ent_allowed_flag;
3291: if csr_element%notfound then
3292: close csr_element;
3293: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3294: hr_utility.set_message_token('PROCEDURE',
3295: 'hrentmnt.mult_ent_allowed_flag');
3296: hr_utility.set_message_token('STEP','1');
3297: hr_utility.raise_error;
3298: end if;
3292: close csr_element;
3293: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3294: hr_utility.set_message_token('PROCEDURE',
3295: 'hrentmnt.mult_ent_allowed_flag');
3296: hr_utility.set_message_token('STEP','1');
3297: hr_utility.raise_error;
3298: end if;
3299: close csr_element;
3300: --
3293: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3294: hr_utility.set_message_token('PROCEDURE',
3295: 'hrentmnt.mult_ent_allowed_flag');
3296: hr_utility.set_message_token('STEP','1');
3297: hr_utility.raise_error;
3298: end if;
3299: close csr_element;
3300: --
3301: return v_mult_ent_allowed_flag;
3464: l_del_war boolean;
3465: begin
3466: --
3467: if g_debug then
3468: hr_utility.set_location(l_proc, 10);
3469: hr_utility.trace(' p_assignment_id = ' ||to_char(p_assignment_id));
3470: hr_utility.trace(' p_validation_start_date = ' ||to_char(p_validation_start_date));
3471: hr_utility.trace(' p_validation_end_date = ' ||to_char(p_validation_end_date));
3472: end if;
3465: begin
3466: --
3467: if g_debug then
3468: hr_utility.set_location(l_proc, 10);
3469: hr_utility.trace(' p_assignment_id = ' ||to_char(p_assignment_id));
3470: hr_utility.trace(' p_validation_start_date = ' ||to_char(p_validation_start_date));
3471: hr_utility.trace(' p_validation_end_date = ' ||to_char(p_validation_end_date));
3472: end if;
3473: --
3466: --
3467: if g_debug then
3468: hr_utility.set_location(l_proc, 10);
3469: hr_utility.trace(' p_assignment_id = ' ||to_char(p_assignment_id));
3470: hr_utility.trace(' p_validation_start_date = ' ||to_char(p_validation_start_date));
3471: hr_utility.trace(' p_validation_end_date = ' ||to_char(p_validation_end_date));
3472: end if;
3473: --
3474: -- Get the assignment criteria
3467: if g_debug then
3468: hr_utility.set_location(l_proc, 10);
3469: hr_utility.trace(' p_assignment_id = ' ||to_char(p_assignment_id));
3470: hr_utility.trace(' p_validation_start_date = ' ||to_char(p_validation_start_date));
3471: hr_utility.trace(' p_validation_end_date = ' ||to_char(p_validation_end_date));
3472: end if;
3473: --
3474: -- Get the assignment criteria
3475: open_asg_criteria_cur(p_assignment_id, p_validation_start_date, l_asg_criteria_cv);
3480: --
3481: begin
3482: --
3483: if g_debug then
3484: hr_utility.set_location(l_proc, 20);
3485: end if;
3486: --
3487: select /*+ INDEX(paf PER_ASSIGNMENTS_F_PK)*/ plr.rule_mode
3488: into l_adjust_ee_source
3501: l_adjust_ee_source := 'A';
3502: end;
3503: --
3504: if g_debug then
3505: hr_utility.trace(' l_adjust_ee_source: '||l_adjust_ee_source);
3506: end if;
3507: --
3508: -- Bugfix 5584631
3509: -- Loop through all invalidated nonrecurring entries.
3521: l_adjust_ee_source
3522: ) loop
3523: --
3524: if g_debug then
3525: hr_utility.set_location(l_proc, 30);
3526: end if;
3527: --
3528: -- Look for an alternative element link based on the invalidated entry's
3529: -- element type and the assignment criteria
3560: --
3561: if not l_link_suitable then
3562: --
3563: if g_debug then
3564: hr_utility.set_location(l_proc, 40);
3565: end if;
3566: --
3567: -- No alternative link found.
3568: -- Clear down l_entry_table and raise error.
3577: -- Special entry was invalidated eg. Balance Adjustment, Quickpay etc .
3578: -- Lookup the entry type for reporting in error.
3579: --
3580: if g_debug then
3581: hr_utility.set_location(l_proc, 50);
3582: end if;
3583: --
3584: select hl.meaning
3585: into l_creator_type_meaning
3586: from hr_lookups hl
3587: where hl.lookup_type = 'CREATOR_TYPE'
3588: and hl.lookup_code = r_entry.creator_type;
3589: --
3590: hr_utility.set_message(801,'HR_6589_ASS_SPCL_NONREC_EXIST');
3591: hr_utility.set_message_token('TYPE',l_creator_type_meaning);
3592: hr_utility.raise_error;
3593: --
3594: else
3587: where hl.lookup_type = 'CREATOR_TYPE'
3588: and hl.lookup_code = r_entry.creator_type;
3589: --
3590: hr_utility.set_message(801,'HR_6589_ASS_SPCL_NONREC_EXIST');
3591: hr_utility.set_message_token('TYPE',l_creator_type_meaning);
3592: hr_utility.raise_error;
3593: --
3594: else
3595: --
3588: and hl.lookup_code = r_entry.creator_type;
3589: --
3590: hr_utility.set_message(801,'HR_6589_ASS_SPCL_NONREC_EXIST');
3591: hr_utility.set_message_token('TYPE',l_creator_type_meaning);
3592: hr_utility.raise_error;
3593: --
3594: else
3595: --
3596: -- An unprocessed nonrecurring entry was invalidated. Includes
3596: -- An unprocessed nonrecurring entry was invalidated. Includes
3597: -- overrides etc .
3598: --
3599: if g_debug then
3600: hr_utility.set_location(l_proc, 60);
3601: end if;
3602: --Bug 6809717 Added the following code to end date entries
3603: select OBJECT_VERSION_NUMBER into l_obj_ver_num
3604: from pay_element_entries_f
3605: where p_validation_start_date-1 between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE
3606: and element_entry_id=r_entry.element_entry_id;
3607:
3608: if g_debug then
3609: hr_utility.trace(' obj vber no'||l_obj_ver_num);
3610: end if;
3611: pay_element_entry_api.delete_element_entry
3612: (p_datetrack_delete_mode => 'DELETE'
3613: ,p_effective_date => p_validation_start_date-1
3615: ,p_object_version_number => l_obj_ver_num
3616: ,p_effective_start_date =>l_eff_str_date
3617: ,p_effective_end_date =>l_eff_end_date
3618: ,p_delete_warning =>l_del_war);
3619: -- hr_utility.set_message(801,'HR_6588_ASS_UNPROC_NONREC');
3620: -- hr_utility.raise_error;
3621: --
3622: end if;
3623: --
3616: ,p_effective_start_date =>l_eff_str_date
3617: ,p_effective_end_date =>l_eff_end_date
3618: ,p_delete_warning =>l_del_war);
3619: -- hr_utility.set_message(801,'HR_6588_ASS_UNPROC_NONREC');
3620: -- hr_utility.raise_error;
3621: --
3622: end if;
3623: --
3624: else
3626: -- A suitable alternative link was found
3627: -- Store the new link id with the entry details for a bulk update later
3628: --
3629: if g_debug then
3630: hr_utility.set_location(l_proc, 70);
3631: hr_utility.trace(' Alt element_link_id found for entry '||to_char(r_entry.element_entry_id));
3632: hr_utility.trace(' Old element_link_id: '||to_char(r_entry.element_link_id)||', new element_link_id: '||to_char(l_eligible_links_rec.element_link_id));
3633: end if;
3634: --
3627: -- Store the new link id with the entry details for a bulk update later
3628: --
3629: if g_debug then
3630: hr_utility.set_location(l_proc, 70);
3631: hr_utility.trace(' Alt element_link_id found for entry '||to_char(r_entry.element_entry_id));
3632: hr_utility.trace(' Old element_link_id: '||to_char(r_entry.element_link_id)||', new element_link_id: '||to_char(l_eligible_links_rec.element_link_id));
3633: end if;
3634: --
3635: l_entry_table.element_entry_id(l_counter) := r_entry.element_entry_id;
3628: --
3629: if g_debug then
3630: hr_utility.set_location(l_proc, 70);
3631: hr_utility.trace(' Alt element_link_id found for entry '||to_char(r_entry.element_entry_id));
3632: hr_utility.trace(' Old element_link_id: '||to_char(r_entry.element_link_id)||', new element_link_id: '||to_char(l_eligible_links_rec.element_link_id));
3633: end if;
3634: --
3635: l_entry_table.element_entry_id(l_counter) := r_entry.element_entry_id;
3636: l_entry_table.element_link_id(l_counter) := l_eligible_links_rec.element_link_id;
3645: --
3646: if l_entry_table.element_entry_id.count > 0 then
3647: --
3648: if g_debug then
3649: hr_utility.set_location(l_proc, 80);
3650: hr_utility.trace('Doing bulk update of element_link_id');
3651: end if;
3652: --
3653: -- Do bulk update of element entries, to point to their respective new
3646: if l_entry_table.element_entry_id.count > 0 then
3647: --
3648: if g_debug then
3649: hr_utility.set_location(l_proc, 80);
3650: hr_utility.trace('Doing bulk update of element_link_id');
3651: end if;
3652: --
3653: -- Do bulk update of element entries, to point to their respective new
3654: -- alternative links
3662: --
3663: end if;
3664: --
3665: if g_debug then
3666: hr_utility.set_location(l_proc, 90);
3667: end if;
3668: --
3669: end val_nonrec_entries;
3670: --
3731: procedure check_parameters is
3732: --
3733: begin
3734: --
3735: hr_utility.trace ('In hrentmnt.adjust_nonrecurring_entries');
3736: hr_utility.trace ('');
3737: hr_utility.trace (' p_assignment_id = '
3738: ||to_char (p_assignment_id));
3739: hr_utility.trace (' p_val_start_date_minus_one = '
3732: --
3733: begin
3734: --
3735: hr_utility.trace ('In hrentmnt.adjust_nonrecurring_entries');
3736: hr_utility.trace ('');
3737: hr_utility.trace (' p_assignment_id = '
3738: ||to_char (p_assignment_id));
3739: hr_utility.trace (' p_val_start_date_minus_one = '
3740: ||to_char (p_val_start_date_minus_one));
3733: begin
3734: --
3735: hr_utility.trace ('In hrentmnt.adjust_nonrecurring_entries');
3736: hr_utility.trace ('');
3737: hr_utility.trace (' p_assignment_id = '
3738: ||to_char (p_assignment_id));
3739: hr_utility.trace (' p_val_start_date_minus_one = '
3740: ||to_char (p_val_start_date_minus_one));
3741: hr_utility.trace (' p_val_end_date_plus_one = '
3735: hr_utility.trace ('In hrentmnt.adjust_nonrecurring_entries');
3736: hr_utility.trace ('');
3737: hr_utility.trace (' p_assignment_id = '
3738: ||to_char (p_assignment_id));
3739: hr_utility.trace (' p_val_start_date_minus_one = '
3740: ||to_char (p_val_start_date_minus_one));
3741: hr_utility.trace (' p_val_end_date_plus_one = '
3742: ||to_char (p_val_end_date_plus_one));
3743: hr_utility.trace (' p_entries_changed = '
3737: hr_utility.trace (' p_assignment_id = '
3738: ||to_char (p_assignment_id));
3739: hr_utility.trace (' p_val_start_date_minus_one = '
3740: ||to_char (p_val_start_date_minus_one));
3741: hr_utility.trace (' p_val_end_date_plus_one = '
3742: ||to_char (p_val_end_date_plus_one));
3743: hr_utility.trace (' p_entries_changed = '
3744: ||p_entries_changed);
3745: hr_utility.trace ('');
3739: hr_utility.trace (' p_val_start_date_minus_one = '
3740: ||to_char (p_val_start_date_minus_one));
3741: hr_utility.trace (' p_val_end_date_plus_one = '
3742: ||to_char (p_val_end_date_plus_one));
3743: hr_utility.trace (' p_entries_changed = '
3744: ||p_entries_changed);
3745: hr_utility.trace ('');
3746: --
3747: end check_parameters;
3741: hr_utility.trace (' p_val_end_date_plus_one = '
3742: ||to_char (p_val_end_date_plus_one));
3743: hr_utility.trace (' p_entries_changed = '
3744: ||p_entries_changed);
3745: hr_utility.trace ('');
3746: --
3747: end check_parameters;
3748: --
3749: begin
3762: assignment_id=p_assignment_id
3763: and effective_start_date>=p_val_start_date_minus_one
3764: and effective_end_date>=p_val_start_date_minus_one;
3765: if g_debug then
3766: hr_utility.trace ('1');
3767: end if;
3768: --
3769:
3770: select count(*) into v_start_date_check from per_time_periods where payroll_id in(
3777: and p_val_end_date_plus_one between effective_start_date and effective_end_date)
3778: and p_val_end_date_plus_one between start_date and end_date;
3779:
3780: if g_debug then
3781: hr_utility.trace ('2');
3782: end if;
3783: --
3784: if v_start_date_check=0 and v_end_date_check=0 then
3785: v_chng_date:=p_val_start_date_minus_one;
3788: else
3789: v_chng_date:=p_val_start_date_minus_one;
3790: end if;
3791: if g_debug then
3792: hr_utility.trace ('3');
3793: end if;
3794: --
3795: if v_start_date_check<>0 or v_end_date_check<>0 then
3796: select end_date into v_vale_start_date from per_time_periods where payroll_id in(
3799: and v_chng_date between start_date and end_date;
3800: end if;
3801:
3802: if g_debug then
3803: hr_utility.trace ('4');
3804: end if;
3805: --
3806: if v_vale_start_date<>p_val_start_date_minus_one and v_alu_cnt=0 then
3807: v_vale_start_date:=p_val_start_date_minus_one;
3897: --
3898: end loop;
3899: --
3900: if g_debug then
3901: hr_utility.trace ('Out hrentmnt.adjust_nonrecurring_entries');
3902: end if;
3903: --
3904: end adjust_nonrecurring_entries;
3905: --
4088: procedure check_parameters is
4089: --
4090: begin
4091: --
4092: hr_utility.trace('In hrentmnt.adjust_recurring_entries');
4093: hr_utility.trace ('');
4094: hr_utility.trace (' p_dt_mode = '
4095: ||p_dt_mode);
4096: hr_utility.trace (' p_assignment_id = '
4089: --
4090: begin
4091: --
4092: hr_utility.trace('In hrentmnt.adjust_recurring_entries');
4093: hr_utility.trace ('');
4094: hr_utility.trace (' p_dt_mode = '
4095: ||p_dt_mode);
4096: hr_utility.trace (' p_assignment_id = '
4097: ||to_char (p_assignment_id));
4090: begin
4091: --
4092: hr_utility.trace('In hrentmnt.adjust_recurring_entries');
4093: hr_utility.trace ('');
4094: hr_utility.trace (' p_dt_mode = '
4095: ||p_dt_mode);
4096: hr_utility.trace (' p_assignment_id = '
4097: ||to_char (p_assignment_id));
4098: hr_utility.trace (' p_element_link_id = '
4092: hr_utility.trace('In hrentmnt.adjust_recurring_entries');
4093: hr_utility.trace ('');
4094: hr_utility.trace (' p_dt_mode = '
4095: ||p_dt_mode);
4096: hr_utility.trace (' p_assignment_id = '
4097: ||to_char (p_assignment_id));
4098: hr_utility.trace (' p_element_link_id = '
4099: ||to_char (p_element_link_id));
4100: hr_utility.trace (' p_standard_link_flag = '
4094: hr_utility.trace (' p_dt_mode = '
4095: ||p_dt_mode);
4096: hr_utility.trace (' p_assignment_id = '
4097: ||to_char (p_assignment_id));
4098: hr_utility.trace (' p_element_link_id = '
4099: ||to_char (p_element_link_id));
4100: hr_utility.trace (' p_standard_link_flag = '
4101: ||p_standard_link_flag);
4102: hr_utility.trace (' p_mult_ent_allowed_flag = '
4096: hr_utility.trace (' p_assignment_id = '
4097: ||to_char (p_assignment_id));
4098: hr_utility.trace (' p_element_link_id = '
4099: ||to_char (p_element_link_id));
4100: hr_utility.trace (' p_standard_link_flag = '
4101: ||p_standard_link_flag);
4102: hr_utility.trace (' p_mult_ent_allowed_flag = '
4103: ||p_mult_ent_allowed_flag);
4104: hr_utility.trace (' p_validation_start_date = '
4098: hr_utility.trace (' p_element_link_id = '
4099: ||to_char (p_element_link_id));
4100: hr_utility.trace (' p_standard_link_flag = '
4101: ||p_standard_link_flag);
4102: hr_utility.trace (' p_mult_ent_allowed_flag = '
4103: ||p_mult_ent_allowed_flag);
4104: hr_utility.trace (' p_validation_start_date = '
4105: ||to_char (p_validation_start_date));
4106: hr_utility.trace (' p_validation_end_date = '
4100: hr_utility.trace (' p_standard_link_flag = '
4101: ||p_standard_link_flag);
4102: hr_utility.trace (' p_mult_ent_allowed_flag = '
4103: ||p_mult_ent_allowed_flag);
4104: hr_utility.trace (' p_validation_start_date = '
4105: ||to_char (p_validation_start_date));
4106: hr_utility.trace (' p_validation_end_date = '
4107: ||to_char (p_validation_end_date));
4108: hr_utility.trace (' p_val_start_date_minus_one = '
4102: hr_utility.trace (' p_mult_ent_allowed_flag = '
4103: ||p_mult_ent_allowed_flag);
4104: hr_utility.trace (' p_validation_start_date = '
4105: ||to_char (p_validation_start_date));
4106: hr_utility.trace (' p_validation_end_date = '
4107: ||to_char (p_validation_end_date));
4108: hr_utility.trace (' p_val_start_date_minus_one = '
4109: ||to_char (p_val_start_date_minus_one));
4110: hr_utility.trace (' p_val_end_date_plus_one = '
4104: hr_utility.trace (' p_validation_start_date = '
4105: ||to_char (p_validation_start_date));
4106: hr_utility.trace (' p_validation_end_date = '
4107: ||to_char (p_validation_end_date));
4108: hr_utility.trace (' p_val_start_date_minus_one = '
4109: ||to_char (p_val_start_date_minus_one));
4110: hr_utility.trace (' p_val_end_date_plus_one = '
4111: ||to_char (p_val_end_date_plus_one));
4112: --
4106: hr_utility.trace (' p_validation_end_date = '
4107: ||to_char (p_validation_end_date));
4108: hr_utility.trace (' p_val_start_date_minus_one = '
4109: ||to_char (p_val_start_date_minus_one));
4110: hr_utility.trace (' p_val_end_date_plus_one = '
4111: ||to_char (p_val_end_date_plus_one));
4112: --
4113: hr_utility.trace (' p_entry_count = '
4114: ||to_char (p_entry_count));
4109: ||to_char (p_val_start_date_minus_one));
4110: hr_utility.trace (' p_val_end_date_plus_one = '
4111: ||to_char (p_val_end_date_plus_one));
4112: --
4113: hr_utility.trace (' p_entry_count = '
4114: ||to_char (p_entry_count));
4115: hr_utility.trace (' p_entries_changed = '
4116: ||p_entries_changed);
4117: hr_utility.trace ('');
4111: ||to_char (p_val_end_date_plus_one));
4112: --
4113: hr_utility.trace (' p_entry_count = '
4114: ||to_char (p_entry_count));
4115: hr_utility.trace (' p_entries_changed = '
4116: ||p_entries_changed);
4117: hr_utility.trace ('');
4118: --
4119: end check_parameters;
4113: hr_utility.trace (' p_entry_count = '
4114: ||to_char (p_entry_count));
4115: hr_utility.trace (' p_entries_changed = '
4116: ||p_entries_changed);
4117: hr_utility.trace ('');
4118: --
4119: end check_parameters;
4120: --
4121: function standard_element (
4196: --
4197: -- Continue for all distinct current element entries.
4198: --
4199: if g_debug then
4200: hr_utility.trace('Distinct entries found');
4201: end if;
4202: --
4203: while csr_distinct_entries%found loop
4204: --
4219: v_calc_entry_start_date := p_entry_start_date_tbl(v_loop);
4220: v_calc_entry_end_date := p_entry_end_date_tbl(v_loop);
4221: --
4222: if g_debug then
4223: hr_utility.trace('esd : ' || v_calc_entry_start_date);
4224: hr_utility.trace('eed : ' || v_calc_entry_end_date);
4225: end if;
4226: --
4227: -- Initialise the flag.
4220: v_calc_entry_end_date := p_entry_end_date_tbl(v_loop);
4221: --
4222: if g_debug then
4223: hr_utility.trace('esd : ' || v_calc_entry_start_date);
4224: hr_utility.trace('eed : ' || v_calc_entry_end_date);
4225: end if;
4226: --
4227: -- Initialise the flag.
4228: --
4307: v_calc_entry_start_date <= p_val_end_date_plus_one and
4308: not v_first_entry_adjusted then
4309:
4310: if g_debug then
4311: hr_utility.trace ('***** bringing "start" date of current REE forwards *****');
4312: hr_utility.trace ('***** calc |-------------> *****');
4313: hr_utility.trace ('***** -----> *****');
4314: hr_utility.trace ('***** current |--------------------> *****');
4315: end if;
4308: not v_first_entry_adjusted then
4309:
4310: if g_debug then
4311: hr_utility.trace ('***** bringing "start" date of current REE forwards *****');
4312: hr_utility.trace ('***** calc |-------------> *****');
4313: hr_utility.trace ('***** -----> *****');
4314: hr_utility.trace ('***** current |--------------------> *****');
4315: end if;
4316: --
4309:
4310: if g_debug then
4311: hr_utility.trace ('***** bringing "start" date of current REE forwards *****');
4312: hr_utility.trace ('***** calc |-------------> *****');
4313: hr_utility.trace ('***** -----> *****');
4314: hr_utility.trace ('***** current |--------------------> *****');
4315: end if;
4316: --
4317: -- Validate the adjustment, maintain referential integrity,
4310: if g_debug then
4311: hr_utility.trace ('***** bringing "start" date of current REE forwards *****');
4312: hr_utility.trace ('***** calc |-------------> *****');
4313: hr_utility.trace ('***** -----> *****');
4314: hr_utility.trace ('***** current |--------------------> *****');
4315: end if;
4316: --
4317: -- Validate the adjustment, maintain referential integrity,
4318: -- and adjust the element entry.
4364: )
4365: then
4366:
4367: if g_debug then
4368: hr_utility.trace ('***** bringing "start" date of current REE backwards *****');
4369: hr_utility.trace ('***** calc |--------------------> *****');
4370: hr_utility.trace ('***** <----- *****');
4371: hr_utility.trace ('***** current |-------------> *****');
4372: end if;
4365: then
4366:
4367: if g_debug then
4368: hr_utility.trace ('***** bringing "start" date of current REE backwards *****');
4369: hr_utility.trace ('***** calc |--------------------> *****');
4370: hr_utility.trace ('***** <----- *****');
4371: hr_utility.trace ('***** current |-------------> *****');
4372: end if;
4373: --
4366:
4367: if g_debug then
4368: hr_utility.trace ('***** bringing "start" date of current REE backwards *****');
4369: hr_utility.trace ('***** calc |--------------------> *****');
4370: hr_utility.trace ('***** <----- *****');
4371: hr_utility.trace ('***** current |-------------> *****');
4372: end if;
4373: --
4374: -- Validate the adjustment, maintain referential integrity,
4367: if g_debug then
4368: hr_utility.trace ('***** bringing "start" date of current REE backwards *****');
4369: hr_utility.trace ('***** calc |--------------------> *****');
4370: hr_utility.trace ('***** <----- *****');
4371: hr_utility.trace ('***** current |-------------> *****');
4372: end if;
4373: --
4374: -- Validate the adjustment, maintain referential integrity,
4375: -- and adjust the element entry.
4400: --
4401: if v_entry_end_date > v_calc_entry_end_date then
4402:
4403: if g_debug then
4404: hr_utility.trace ('***** bringing "end" date of current REE backwards *****');
4405: hr_utility.trace ('***** calc |-------------| *****');
4406: hr_utility.trace ('***** <----- *****');
4407: hr_utility.trace ('***** current |--------------------> *****');
4408: end if;
4401: if v_entry_end_date > v_calc_entry_end_date then
4402:
4403: if g_debug then
4404: hr_utility.trace ('***** bringing "end" date of current REE backwards *****');
4405: hr_utility.trace ('***** calc |-------------| *****');
4406: hr_utility.trace ('***** <----- *****');
4407: hr_utility.trace ('***** current |--------------------> *****');
4408: end if;
4409: hrentmnt.validate_adjust_entry
4402:
4403: if g_debug then
4404: hr_utility.trace ('***** bringing "end" date of current REE backwards *****');
4405: hr_utility.trace ('***** calc |-------------| *****');
4406: hr_utility.trace ('***** <----- *****');
4407: hr_utility.trace ('***** current |--------------------> *****');
4408: end if;
4409: hrentmnt.validate_adjust_entry
4410: ('UPDATE',
4403: if g_debug then
4404: hr_utility.trace ('***** bringing "end" date of current REE backwards *****');
4405: hr_utility.trace ('***** calc |-------------| *****');
4406: hr_utility.trace ('***** <----- *****');
4407: hr_utility.trace ('***** current |--------------------> *****');
4408: end if;
4409: hrentmnt.validate_adjust_entry
4410: ('UPDATE',
4411: p_assignment_id,
4541: (p_dt_mode <> 'CORRECTION')
4542: ) then
4543:
4544: if g_debug then
4545: hr_utility.trace ('***** bringing "end" date of current REE forwards *****');
4546: hr_utility.trace ('***** calc |--------------------> *****');
4547: hr_utility.trace ('***** -----> *****');
4548: hr_utility.trace ('***** current |--------------| *****');
4549: end if;
4542: ) then
4543:
4544: if g_debug then
4545: hr_utility.trace ('***** bringing "end" date of current REE forwards *****');
4546: hr_utility.trace ('***** calc |--------------------> *****');
4547: hr_utility.trace ('***** -----> *****');
4548: hr_utility.trace ('***** current |--------------| *****');
4549: end if;
4550: --
4543:
4544: if g_debug then
4545: hr_utility.trace ('***** bringing "end" date of current REE forwards *****');
4546: hr_utility.trace ('***** calc |--------------------> *****');
4547: hr_utility.trace ('***** -----> *****');
4548: hr_utility.trace ('***** current |--------------| *****');
4549: end if;
4550: --
4551: -- Another current entry exists in the future so only move the
4544: if g_debug then
4545: hr_utility.trace ('***** bringing "end" date of current REE forwards *****');
4546: hr_utility.trace ('***** calc |--------------------> *****');
4547: hr_utility.trace ('***** -----> *****');
4548: hr_utility.trace ('***** current |--------------| *****');
4549: end if;
4550: --
4551: -- Another current entry exists in the future so only move the
4552: -- end date to the day before the this element entry.
4627: elsif (v_calc_entry_start_date >= p_validation_start_date and
4628: v_ele_entry_rec.creator_type <> 'SP') then
4629: --
4630: if g_debug then
4631: hr_utility.trace('Original_entry_id : ' || v_distinct_entry_id);
4632: end if;
4633: hr_entry_api.insert_element_entry
4634: (p_effective_start_date => v_calc_entry_start_date,
4635: p_effective_end_date => v_dummy_date,
4752: --
4753: if v_calc_entry_start_date >= p_validation_start_date then
4754: --
4755: if g_debug then
4756: hr_utility.trace('********** ASG criteria delta');
4757: hr_utility.trace('********** for SL call EE insert interface');
4758: end if;
4759: hr_entry_api.insert_element_entry
4760: (p_effective_start_date => v_calc_entry_start_date,
4753: if v_calc_entry_start_date >= p_validation_start_date then
4754: --
4755: if g_debug then
4756: hr_utility.trace('********** ASG criteria delta');
4757: hr_utility.trace('********** for SL call EE insert interface');
4758: end if;
4759: hr_entry_api.insert_element_entry
4760: (p_effective_start_date => v_calc_entry_start_date,
4761: p_effective_end_date => v_dummy_date,
4781: -- and these may have validation set up
4782: --
4783: if l_category is not null then
4784: if g_debug then
4785: hr_utility.trace('********** ASG criteria delta');
4786: hr_utility.trace('********** l_category>' || l_category || '<');
4787: end if;
4788:
4789: --
4782: --
4783: if l_category is not null then
4784: if g_debug then
4785: hr_utility.trace('********** ASG criteria delta');
4786: hr_utility.trace('********** l_category>' || l_category || '<');
4787: end if;
4788:
4789: --
4790: -- only single element entry row exists, no need for effective dates
4802: --
4803: close csr_distinct_entries;
4804: --
4805: if g_debug then
4806: hr_utility.trace('Out hrentmnt.adjust_recurring_entries');
4807: end if;
4808: --
4809: end adjust_recurring_entries;
4810: --
4865: procedure check_parameters is
4866: --
4867: begin
4868: --
4869: hr_utility.trace('In hrentmnt.adjust_entries_pqc');
4870: hr_utility.trace ('');
4871: hr_utility.trace (' p_assignment_id = '
4872: ||to_char (p_assignment_id));
4873: hr_utility.trace (' p_entries_changed = '
4866: --
4867: begin
4868: --
4869: hr_utility.trace('In hrentmnt.adjust_entries_pqc');
4870: hr_utility.trace ('');
4871: hr_utility.trace (' p_assignment_id = '
4872: ||to_char (p_assignment_id));
4873: hr_utility.trace (' p_entries_changed = '
4874: ||p_entries_changed);
4867: begin
4868: --
4869: hr_utility.trace('In hrentmnt.adjust_entries_pqc');
4870: hr_utility.trace ('');
4871: hr_utility.trace (' p_assignment_id = '
4872: ||to_char (p_assignment_id));
4873: hr_utility.trace (' p_entries_changed = '
4874: ||p_entries_changed);
4875: hr_utility.trace ('');
4869: hr_utility.trace('In hrentmnt.adjust_entries_pqc');
4870: hr_utility.trace ('');
4871: hr_utility.trace (' p_assignment_id = '
4872: ||to_char (p_assignment_id));
4873: hr_utility.trace (' p_entries_changed = '
4874: ||p_entries_changed);
4875: hr_utility.trace ('');
4876: --
4877: end check_parameters;
4871: hr_utility.trace (' p_assignment_id = '
4872: ||to_char (p_assignment_id));
4873: hr_utility.trace (' p_entries_changed = '
4874: ||p_entries_changed);
4875: hr_utility.trace ('');
4876: --
4877: end check_parameters;
4878: --
4879: begin
5113: --
5114: end loop;
5115: --
5116: if g_debug then
5117: hr_utility.trace('Out hrentmnt.adjust_entries_pqc');
5118: end if;
5119: --
5120: end adjust_entries_pqc;
5121: --
5200: procedure check_parameters is
5201: --
5202: begin
5203: --
5204: hr_utility.trace('In hrentmnt.adjust_entries_cncl_term');
5205: hr_utility.trace ('');
5206: hr_utility.trace (' p_business_group_id = '
5207: ||to_char (p_business_group_id));
5208: hr_utility.trace (' p_assignment_id = '
5201: --
5202: begin
5203: --
5204: hr_utility.trace('In hrentmnt.adjust_entries_cncl_term');
5205: hr_utility.trace ('');
5206: hr_utility.trace (' p_business_group_id = '
5207: ||to_char (p_business_group_id));
5208: hr_utility.trace (' p_assignment_id = '
5209: ||to_char (p_assignment_id));
5202: begin
5203: --
5204: hr_utility.trace('In hrentmnt.adjust_entries_cncl_term');
5205: hr_utility.trace ('');
5206: hr_utility.trace (' p_business_group_id = '
5207: ||to_char (p_business_group_id));
5208: hr_utility.trace (' p_assignment_id = '
5209: ||to_char (p_assignment_id));
5210: hr_utility.trace (' p_actual_term_date = '
5204: hr_utility.trace('In hrentmnt.adjust_entries_cncl_term');
5205: hr_utility.trace ('');
5206: hr_utility.trace (' p_business_group_id = '
5207: ||to_char (p_business_group_id));
5208: hr_utility.trace (' p_assignment_id = '
5209: ||to_char (p_assignment_id));
5210: hr_utility.trace (' p_actual_term_date = '
5211: ||to_char (p_actual_term_date));
5212: hr_utility.trace (' p_last_standard_date = '
5206: hr_utility.trace (' p_business_group_id = '
5207: ||to_char (p_business_group_id));
5208: hr_utility.trace (' p_assignment_id = '
5209: ||to_char (p_assignment_id));
5210: hr_utility.trace (' p_actual_term_date = '
5211: ||to_char (p_actual_term_date));
5212: hr_utility.trace (' p_last_standard_date = '
5213: ||to_char (p_last_standard_date));
5214: hr_utility.trace (' p_final_process_date = '
5208: hr_utility.trace (' p_assignment_id = '
5209: ||to_char (p_assignment_id));
5210: hr_utility.trace (' p_actual_term_date = '
5211: ||to_char (p_actual_term_date));
5212: hr_utility.trace (' p_last_standard_date = '
5213: ||to_char (p_last_standard_date));
5214: hr_utility.trace (' p_final_process_date = '
5215: ||to_char (p_final_process_date));
5216: hr_utility.trace (' p_entries_changed = '
5210: hr_utility.trace (' p_actual_term_date = '
5211: ||to_char (p_actual_term_date));
5212: hr_utility.trace (' p_last_standard_date = '
5213: ||to_char (p_last_standard_date));
5214: hr_utility.trace (' p_final_process_date = '
5215: ||to_char (p_final_process_date));
5216: hr_utility.trace (' p_entries_changed = '
5217: ||p_entries_changed);
5218: hr_utility.trace ('');
5212: hr_utility.trace (' p_last_standard_date = '
5213: ||to_char (p_last_standard_date));
5214: hr_utility.trace (' p_final_process_date = '
5215: ||to_char (p_final_process_date));
5216: hr_utility.trace (' p_entries_changed = '
5217: ||p_entries_changed);
5218: hr_utility.trace ('');
5219: --
5220: end check_parameters;
5214: hr_utility.trace (' p_final_process_date = '
5215: ||to_char (p_final_process_date));
5216: hr_utility.trace (' p_entries_changed = '
5217: ||p_entries_changed);
5218: hr_utility.trace ('');
5219: --
5220: end check_parameters;
5221: --
5222: begin
5299: --
5300: end loop;
5301: --
5302: if g_debug then
5303: hr_utility.trace('Out hrentmnt.adjust_entries_cncl_term');
5304: end if;
5305: --
5306: end adjust_entries_cncl_term;
5307: --
5329: procedure check_parameters is
5330: --
5331: begin
5332: --
5333: hr_utility.trace('In hrentmnt.adjust_entries_cncl_hire');
5334: hr_utility.trace ('');
5335: hr_utility.trace (' p_business_group_id = '
5336: ||to_char (p_business_group_id));
5337: hr_utility.trace (' p_assignment_id = '
5330: --
5331: begin
5332: --
5333: hr_utility.trace('In hrentmnt.adjust_entries_cncl_hire');
5334: hr_utility.trace ('');
5335: hr_utility.trace (' p_business_group_id = '
5336: ||to_char (p_business_group_id));
5337: hr_utility.trace (' p_assignment_id = '
5338: ||to_char (p_assignment_id));
5331: begin
5332: --
5333: hr_utility.trace('In hrentmnt.adjust_entries_cncl_hire');
5334: hr_utility.trace ('');
5335: hr_utility.trace (' p_business_group_id = '
5336: ||to_char (p_business_group_id));
5337: hr_utility.trace (' p_assignment_id = '
5338: ||to_char (p_assignment_id));
5339: hr_utility.trace (' p_validation_start_date = '
5333: hr_utility.trace('In hrentmnt.adjust_entries_cncl_hire');
5334: hr_utility.trace ('');
5335: hr_utility.trace (' p_business_group_id = '
5336: ||to_char (p_business_group_id));
5337: hr_utility.trace (' p_assignment_id = '
5338: ||to_char (p_assignment_id));
5339: hr_utility.trace (' p_validation_start_date = '
5340: ||to_char (p_validation_start_date));
5341: hr_utility.trace (' p_validation_end_date = '
5335: hr_utility.trace (' p_business_group_id = '
5336: ||to_char (p_business_group_id));
5337: hr_utility.trace (' p_assignment_id = '
5338: ||to_char (p_assignment_id));
5339: hr_utility.trace (' p_validation_start_date = '
5340: ||to_char (p_validation_start_date));
5341: hr_utility.trace (' p_validation_end_date = '
5342: ||to_char (p_validation_end_date));
5343: hr_utility.trace (' p_entries_changed = '
5337: hr_utility.trace (' p_assignment_id = '
5338: ||to_char (p_assignment_id));
5339: hr_utility.trace (' p_validation_start_date = '
5340: ||to_char (p_validation_start_date));
5341: hr_utility.trace (' p_validation_end_date = '
5342: ||to_char (p_validation_end_date));
5343: hr_utility.trace (' p_entries_changed = '
5344: ||p_entries_changed);
5345: hr_utility.trace ('');
5339: hr_utility.trace (' p_validation_start_date = '
5340: ||to_char (p_validation_start_date));
5341: hr_utility.trace (' p_validation_end_date = '
5342: ||to_char (p_validation_end_date));
5343: hr_utility.trace (' p_entries_changed = '
5344: ||p_entries_changed);
5345: hr_utility.trace ('');
5346: --
5347: end check_parameters;
5341: hr_utility.trace (' p_validation_end_date = '
5342: ||to_char (p_validation_end_date));
5343: hr_utility.trace (' p_entries_changed = '
5344: ||p_entries_changed);
5345: hr_utility.trace ('');
5346: --
5347: end check_parameters;
5348: --
5349: begin
5393: p_validation_end_date,
5394: p_entries_changed);
5395: --
5396: if g_debug then
5397: hr_utility.trace('Out hrentmnt.adjust_entries_cncl_hire');
5398: end if;
5399: --
5400: end adjust_entries_cncl_hire;
5401: --
5682: procedure check_parameters is
5683: --
5684: begin
5685: --
5686: hr_utility.trace('In '||l_proc);
5687: hr_utility.trace ('');
5688: hr_utility.trace (' p_business_group_id = '
5689: ||to_char (p_business_group_id));
5690: --
5683: --
5684: begin
5685: --
5686: hr_utility.trace('In '||l_proc);
5687: hr_utility.trace ('');
5688: hr_utility.trace (' p_business_group_id = '
5689: ||to_char (p_business_group_id));
5690: --
5691: hr_utility.trace (' p_assignment_id = '
5684: begin
5685: --
5686: hr_utility.trace('In '||l_proc);
5687: hr_utility.trace ('');
5688: hr_utility.trace (' p_business_group_id = '
5689: ||to_char (p_business_group_id));
5690: --
5691: hr_utility.trace (' p_assignment_id = '
5692: ||to_char (p_assignment_id));
5687: hr_utility.trace ('');
5688: hr_utility.trace (' p_business_group_id = '
5689: ||to_char (p_business_group_id));
5690: --
5691: hr_utility.trace (' p_assignment_id = '
5692: ||to_char (p_assignment_id));
5693: --
5694: hr_utility.trace (' p_dt_mode = '
5695: ||p_dt_mode);
5690: --
5691: hr_utility.trace (' p_assignment_id = '
5692: ||to_char (p_assignment_id));
5693: --
5694: hr_utility.trace (' p_dt_mode = '
5695: ||p_dt_mode);
5696: --
5697: hr_utility.trace (' p_old_payroll_id = '
5698: ||to_char (p_old_payroll_id));
5693: --
5694: hr_utility.trace (' p_dt_mode = '
5695: ||p_dt_mode);
5696: --
5697: hr_utility.trace (' p_old_payroll_id = '
5698: ||to_char (p_old_payroll_id));
5699: --
5700: hr_utility.trace (' p_new_payroll_id = '
5701: ||to_char (p_new_payroll_id));
5696: --
5697: hr_utility.trace (' p_old_payroll_id = '
5698: ||to_char (p_old_payroll_id));
5699: --
5700: hr_utility.trace (' p_new_payroll_id = '
5701: ||to_char (p_new_payroll_id));
5702: --
5703: hr_utility.trace (' p_validation_start_date = '
5704: ||to_char (p_validation_start_date));
5699: --
5700: hr_utility.trace (' p_new_payroll_id = '
5701: ||to_char (p_new_payroll_id));
5702: --
5703: hr_utility.trace (' p_validation_start_date = '
5704: ||to_char (p_validation_start_date));
5705: --
5706: hr_utility.trace (' p_validation_end_date = '
5707: ||to_char (p_validation_end_date));
5702: --
5703: hr_utility.trace (' p_validation_start_date = '
5704: ||to_char (p_validation_start_date));
5705: --
5706: hr_utility.trace (' p_validation_end_date = '
5707: ||to_char (p_validation_end_date));
5708: --
5709: hr_utility.trace (' p_entries_changed = '
5710: ||p_entries_changed);
5705: --
5706: hr_utility.trace (' p_validation_end_date = '
5707: ||to_char (p_validation_end_date));
5708: --
5709: hr_utility.trace (' p_entries_changed = '
5710: ||p_entries_changed);
5711: --
5712: hr_utility.trace (' p_old_hire_date = '
5713: ||to_char(p_old_hire_date));
5708: --
5709: hr_utility.trace (' p_entries_changed = '
5710: ||p_entries_changed);
5711: --
5712: hr_utility.trace (' p_old_hire_date = '
5713: ||to_char(p_old_hire_date));
5714: --
5715: hr_utility.trace (' p_old_people_group_id = '
5716: ||to_char(p_old_people_group_id));
5711: --
5712: hr_utility.trace (' p_old_hire_date = '
5713: ||to_char(p_old_hire_date));
5714: --
5715: hr_utility.trace (' p_old_people_group_id = '
5716: ||to_char(p_old_people_group_id));
5717: --
5718: hr_utility.trace (' p_new_people_group_id = '
5719: ||to_char(p_new_people_group_id));
5714: --
5715: hr_utility.trace (' p_old_people_group_id = '
5716: ||to_char(p_old_people_group_id));
5717: --
5718: hr_utility.trace (' p_new_people_group_id = '
5719: ||to_char(p_new_people_group_id));
5720: --
5721: hr_utility.trace ('');
5722: --
5717: --
5718: hr_utility.trace (' p_new_people_group_id = '
5719: ||to_char(p_new_people_group_id));
5720: --
5721: hr_utility.trace ('');
5722: --
5723: end check_parameters;
5724: --
5725: begin
5873: v_entry_end_date);
5874: --
5875: exception
5876: --
5877: when hr_utility.hr_error then
5878: --
5879: hr_utility.get_message_details(v_message_name,v_appl_short_name);
5880: --
5881: if v_message_name = 'HR_6370_ELE_ENTRY_NO_TERM' then
5875: exception
5876: --
5877: when hr_utility.hr_error then
5878: --
5879: hr_utility.get_message_details(v_message_name,v_appl_short_name);
5880: --
5881: if v_message_name = 'HR_6370_ELE_ENTRY_NO_TERM' then
5882: --
5883: v_entry_start_date := null;
5928: -- Compare the calculated element entries with those on the system
5929: -- and adjust as necessary.
5930: --
5931: if g_debug then
5932: hr_utility.trace('v_entry_count : ' || v_entry_count);
5933: end if;
5934: --
5935: -- See if multiple entries are allowed.
5936: --
5964: --
5965: end loop;
5966: --
5967: if g_debug then
5968: hr_utility.trace('Out hrentmnt.adjust_entries_asg_criteria');
5969: end if;
5970: --
5971: end adjust_entries_asg_criteria;
5972: --
6140: procedure check_parameters is
6141: --
6142: begin
6143: --
6144: hr_utility.trace ('hrentmnt.maintain_entries_el');
6145: hr_utility.trace ('');
6146: hr_utility.trace (' p_business_group_id = '
6147: ||to_char (p_business_group_id));
6148: hr_utility.trace (' p_element_link_id = '
6141: --
6142: begin
6143: --
6144: hr_utility.trace ('hrentmnt.maintain_entries_el');
6145: hr_utility.trace ('');
6146: hr_utility.trace (' p_business_group_id = '
6147: ||to_char (p_business_group_id));
6148: hr_utility.trace (' p_element_link_id = '
6149: ||to_char (p_element_link_id));
6142: begin
6143: --
6144: hr_utility.trace ('hrentmnt.maintain_entries_el');
6145: hr_utility.trace ('');
6146: hr_utility.trace (' p_business_group_id = '
6147: ||to_char (p_business_group_id));
6148: hr_utility.trace (' p_element_link_id = '
6149: ||to_char (p_element_link_id));
6150: hr_utility.trace (' p_element_type_id = '
6144: hr_utility.trace ('hrentmnt.maintain_entries_el');
6145: hr_utility.trace ('');
6146: hr_utility.trace (' p_business_group_id = '
6147: ||to_char (p_business_group_id));
6148: hr_utility.trace (' p_element_link_id = '
6149: ||to_char (p_element_link_id));
6150: hr_utility.trace (' p_element_type_id = '
6151: ||to_char (p_element_type_id));
6152: hr_utility.trace (' p_effective_start_date = '
6146: hr_utility.trace (' p_business_group_id = '
6147: ||to_char (p_business_group_id));
6148: hr_utility.trace (' p_element_link_id = '
6149: ||to_char (p_element_link_id));
6150: hr_utility.trace (' p_element_type_id = '
6151: ||to_char (p_element_type_id));
6152: hr_utility.trace (' p_effective_start_date = '
6153: ||to_char (p_effective_start_date));
6154: hr_utility.trace (' p_effective_end_date = '
6148: hr_utility.trace (' p_element_link_id = '
6149: ||to_char (p_element_link_id));
6150: hr_utility.trace (' p_element_type_id = '
6151: ||to_char (p_element_type_id));
6152: hr_utility.trace (' p_effective_start_date = '
6153: ||to_char (p_effective_start_date));
6154: hr_utility.trace (' p_effective_end_date = '
6155: ||to_char (p_effective_end_date));
6156: hr_utility.trace (' p_payroll_id = '
6150: hr_utility.trace (' p_element_type_id = '
6151: ||to_char (p_element_type_id));
6152: hr_utility.trace (' p_effective_start_date = '
6153: ||to_char (p_effective_start_date));
6154: hr_utility.trace (' p_effective_end_date = '
6155: ||to_char (p_effective_end_date));
6156: hr_utility.trace (' p_payroll_id = '
6157: ||to_char (p_payroll_id));
6158: hr_utility.trace (' p_link_to_all_payrolls_flag = '
6152: hr_utility.trace (' p_effective_start_date = '
6153: ||to_char (p_effective_start_date));
6154: hr_utility.trace (' p_effective_end_date = '
6155: ||to_char (p_effective_end_date));
6156: hr_utility.trace (' p_payroll_id = '
6157: ||to_char (p_payroll_id));
6158: hr_utility.trace (' p_link_to_all_payrolls_flag = '
6159: ||p_link_to_all_payrolls_flag);
6160: hr_utility.trace (' p_job_id = '
6154: hr_utility.trace (' p_effective_end_date = '
6155: ||to_char (p_effective_end_date));
6156: hr_utility.trace (' p_payroll_id = '
6157: ||to_char (p_payroll_id));
6158: hr_utility.trace (' p_link_to_all_payrolls_flag = '
6159: ||p_link_to_all_payrolls_flag);
6160: hr_utility.trace (' p_job_id = '
6161: ||to_char (p_job_id));
6162: hr_utility.trace (' p_grade_id = '
6156: hr_utility.trace (' p_payroll_id = '
6157: ||to_char (p_payroll_id));
6158: hr_utility.trace (' p_link_to_all_payrolls_flag = '
6159: ||p_link_to_all_payrolls_flag);
6160: hr_utility.trace (' p_job_id = '
6161: ||to_char (p_job_id));
6162: hr_utility.trace (' p_grade_id = '
6163: ||to_char (p_grade_id));
6164: hr_utility.trace (' p_position_id = '
6158: hr_utility.trace (' p_link_to_all_payrolls_flag = '
6159: ||p_link_to_all_payrolls_flag);
6160: hr_utility.trace (' p_job_id = '
6161: ||to_char (p_job_id));
6162: hr_utility.trace (' p_grade_id = '
6163: ||to_char (p_grade_id));
6164: hr_utility.trace (' p_position_id = '
6165: ||to_char (p_position_id));
6166: hr_utility.trace (' p_organization_id = '
6160: hr_utility.trace (' p_job_id = '
6161: ||to_char (p_job_id));
6162: hr_utility.trace (' p_grade_id = '
6163: ||to_char (p_grade_id));
6164: hr_utility.trace (' p_position_id = '
6165: ||to_char (p_position_id));
6166: hr_utility.trace (' p_organization_id = '
6167: ||to_char (p_organization_id));
6168: hr_utility.trace (' p_location_id = '
6162: hr_utility.trace (' p_grade_id = '
6163: ||to_char (p_grade_id));
6164: hr_utility.trace (' p_position_id = '
6165: ||to_char (p_position_id));
6166: hr_utility.trace (' p_organization_id = '
6167: ||to_char (p_organization_id));
6168: hr_utility.trace (' p_location_id = '
6169: ||to_char (p_location_id));
6170: hr_utility.trace (' p_pay_basis_id = '
6164: hr_utility.trace (' p_position_id = '
6165: ||to_char (p_position_id));
6166: hr_utility.trace (' p_organization_id = '
6167: ||to_char (p_organization_id));
6168: hr_utility.trace (' p_location_id = '
6169: ||to_char (p_location_id));
6170: hr_utility.trace (' p_pay_basis_id = '
6171: ||to_char (p_pay_basis_id));
6172: hr_utility.trace (' p_employment_category = '
6166: hr_utility.trace (' p_organization_id = '
6167: ||to_char (p_organization_id));
6168: hr_utility.trace (' p_location_id = '
6169: ||to_char (p_location_id));
6170: hr_utility.trace (' p_pay_basis_id = '
6171: ||to_char (p_pay_basis_id));
6172: hr_utility.trace (' p_employment_category = '
6173: ||p_employment_category);
6174: hr_utility.trace (' p_people_group_id = '
6168: hr_utility.trace (' p_location_id = '
6169: ||to_char (p_location_id));
6170: hr_utility.trace (' p_pay_basis_id = '
6171: ||to_char (p_pay_basis_id));
6172: hr_utility.trace (' p_employment_category = '
6173: ||p_employment_category);
6174: hr_utility.trace (' p_people_group_id = '
6175: ||to_char (p_people_group_id));
6176: hr_utility.trace ('');
6170: hr_utility.trace (' p_pay_basis_id = '
6171: ||to_char (p_pay_basis_id));
6172: hr_utility.trace (' p_employment_category = '
6173: ||p_employment_category);
6174: hr_utility.trace (' p_people_group_id = '
6175: ||to_char (p_people_group_id));
6176: hr_utility.trace ('');
6177: --
6178: end check_parameters;
6172: hr_utility.trace (' p_employment_category = '
6173: ||p_employment_category);
6174: hr_utility.trace (' p_people_group_id = '
6175: ||to_char (p_people_group_id));
6176: hr_utility.trace ('');
6177: --
6178: end check_parameters;
6179: --
6180: begin
6177: --
6178: end check_parameters;
6179: --
6180: begin
6181: g_debug := hr_utility.debug_enabled;
6182: --
6183: if g_debug then
6184: check_parameters;
6185: end if;
6207: when hr_api.object_locked then
6208: --
6209: -- Failed to lock the assignment.
6210: --
6211: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
6212: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');
6213: hr_utility.raise_error;
6214: end;
6215: --
6208: --
6209: -- Failed to lock the assignment.
6210: --
6211: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
6212: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');
6213: hr_utility.raise_error;
6214: end;
6215: --
6216: -- Get first assignment piece matching the standard link.
6209: -- Failed to lock the assignment.
6210: --
6211: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
6212: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');
6213: hr_utility.raise_error;
6214: end;
6215: --
6216: -- Get first assignment piece matching the standard link.
6217: --
6234: fetch csr_sec_asg into v_asg_visible;
6235: if csr_sec_asg%notfound then
6236: --
6237: if g_debug then
6238: hr_utility.trace('Assignment ID Not Found: '||v_asg_id);
6239: end if;
6240: --
6241: -- The user is not authorized to process this assignment.
6242: --
6242: --
6243: close csr_sec_asg;
6244: close csr_assignment;
6245: --
6246: hr_utility.set_message(801,'PAY_33449_STD_LINK_SEC_ASG');
6247: hr_utility.raise_error;
6248: end if;
6249: close csr_sec_asg;
6250:
6243: close csr_sec_asg;
6244: close csr_assignment;
6245: --
6246: hr_utility.set_message(801,'PAY_33449_STD_LINK_SEC_ASG');
6247: hr_utility.raise_error;
6248: end if;
6249: close csr_sec_asg;
6250:
6251: --
6279: 'Y',
6280: v_entry_start_date,
6281: v_entry_end_date);
6282: exception
6283: when hr_utility.hr_error then
6284: hr_utility.get_message_details(v_message_name,v_appl_short_name);
6285: if v_message_name = 'HR_6370_ELE_ENTRY_NO_TERM' then
6286: v_entry_start_date := null;
6287: v_message_name := null;
6280: v_entry_start_date,
6281: v_entry_end_date);
6282: exception
6283: when hr_utility.hr_error then
6284: hr_utility.get_message_details(v_message_name,v_appl_short_name);
6285: if v_message_name = 'HR_6370_ELE_ENTRY_NO_TERM' then
6286: v_entry_start_date := null;
6287: v_message_name := null;
6288: v_appl_short_name := null;
6297: --
6298: -- Create new element netry for standard link.
6299: --
6300: if g_debug then
6301: hr_utility.trace('********** SL creation');
6302: hr_utility.trace('********** for SL call EE insert interface');
6303: end if;
6304: hr_entry_api.insert_element_entry
6305: (p_effective_start_date => v_entry_start_date,
6298: -- Create new element netry for standard link.
6299: --
6300: if g_debug then
6301: hr_utility.trace('********** SL creation');
6302: hr_utility.trace('********** for SL call EE insert interface');
6303: end if;
6304: hr_entry_api.insert_element_entry
6305: (p_effective_start_date => v_entry_start_date,
6306: p_effective_end_date => v_entry_end_date,
6315: v_entry_start_date,
6316: p_element_link_id);
6317: if l_category is not null then
6318: if g_debug then
6319: hr_utility.trace('********** SL creation');
6320: hr_utility.trace('********** l_category>' || l_category || '<');
6321: end if;
6322:
6323: UPDATE pay_element_entries_f
6316: p_element_link_id);
6317: if l_category is not null then
6318: if g_debug then
6319: hr_utility.trace('********** SL creation');
6320: hr_utility.trace('********** l_category>' || l_category || '<');
6321: end if;
6322:
6323: UPDATE pay_element_entries_f
6324: SET entry_information_category = l_category
6355: --
6356: close csr_assignment;
6357: --
6358: if g_debug then
6359: hr_utility.trace ('Out hrentmnt.maintain_entries_el');
6360: end if;
6361: --
6362: end maintain_entries_el;
6363: --
6419: where pee.assignment_id = p_assignment_id
6420: and pel.element_link_id = pee.element_link_id;
6421:
6422: begin
6423: hr_utility.trace('***** dump start *****');
6424:
6425: for rec_assignment in csr_assignment(p_assignment_id,
6426: p_business_group_id) loop
6427: hr_utility.trace('rec_assignment.assignment_id>' ||
6423: hr_utility.trace('***** dump start *****');
6424:
6425: for rec_assignment in csr_assignment(p_assignment_id,
6426: p_business_group_id) loop
6427: hr_utility.trace('rec_assignment.assignment_id>' ||
6428: rec_assignment.assignment_id || '<');
6429: hr_utility.trace(' rec_assignment.effective_start_date>' ||
6430: rec_assignment.effective_start_date || '<');
6431: hr_utility.trace(' rec_assignment.effective_end_date>' ||
6425: for rec_assignment in csr_assignment(p_assignment_id,
6426: p_business_group_id) loop
6427: hr_utility.trace('rec_assignment.assignment_id>' ||
6428: rec_assignment.assignment_id || '<');
6429: hr_utility.trace(' rec_assignment.effective_start_date>' ||
6430: rec_assignment.effective_start_date || '<');
6431: hr_utility.trace(' rec_assignment.effective_end_date>' ||
6432: rec_assignment.effective_end_date || '<');
6433: hr_utility.trace(' rec_assignment.primary_flag>' ||
6427: hr_utility.trace('rec_assignment.assignment_id>' ||
6428: rec_assignment.assignment_id || '<');
6429: hr_utility.trace(' rec_assignment.effective_start_date>' ||
6430: rec_assignment.effective_start_date || '<');
6431: hr_utility.trace(' rec_assignment.effective_end_date>' ||
6432: rec_assignment.effective_end_date || '<');
6433: hr_utility.trace(' rec_assignment.primary_flag>' ||
6434: rec_assignment.primary_flag || '<');
6435: hr_utility.trace(' rec_assignment.organization_id>' ||
6429: hr_utility.trace(' rec_assignment.effective_start_date>' ||
6430: rec_assignment.effective_start_date || '<');
6431: hr_utility.trace(' rec_assignment.effective_end_date>' ||
6432: rec_assignment.effective_end_date || '<');
6433: hr_utility.trace(' rec_assignment.primary_flag>' ||
6434: rec_assignment.primary_flag || '<');
6435: hr_utility.trace(' rec_assignment.organization_id>' ||
6436: rec_assignment.organization_id || '<');
6437: hr_utility.trace(' rec_assignment.people_group_id>' ||
6431: hr_utility.trace(' rec_assignment.effective_end_date>' ||
6432: rec_assignment.effective_end_date || '<');
6433: hr_utility.trace(' rec_assignment.primary_flag>' ||
6434: rec_assignment.primary_flag || '<');
6435: hr_utility.trace(' rec_assignment.organization_id>' ||
6436: rec_assignment.organization_id || '<');
6437: hr_utility.trace(' rec_assignment.people_group_id>' ||
6438: rec_assignment.people_group_id || '<');
6439: hr_utility.trace(' rec_assignment.job_id>' ||
6433: hr_utility.trace(' rec_assignment.primary_flag>' ||
6434: rec_assignment.primary_flag || '<');
6435: hr_utility.trace(' rec_assignment.organization_id>' ||
6436: rec_assignment.organization_id || '<');
6437: hr_utility.trace(' rec_assignment.people_group_id>' ||
6438: rec_assignment.people_group_id || '<');
6439: hr_utility.trace(' rec_assignment.job_id>' ||
6440: rec_assignment.job_id || '<');
6441: hr_utility.trace(' rec_assignment.position_id>' ||
6435: hr_utility.trace(' rec_assignment.organization_id>' ||
6436: rec_assignment.organization_id || '<');
6437: hr_utility.trace(' rec_assignment.people_group_id>' ||
6438: rec_assignment.people_group_id || '<');
6439: hr_utility.trace(' rec_assignment.job_id>' ||
6440: rec_assignment.job_id || '<');
6441: hr_utility.trace(' rec_assignment.position_id>' ||
6442: rec_assignment.position_id || '<');
6443: hr_utility.trace(' rec_assignment.grade_id>' ||
6437: hr_utility.trace(' rec_assignment.people_group_id>' ||
6438: rec_assignment.people_group_id || '<');
6439: hr_utility.trace(' rec_assignment.job_id>' ||
6440: rec_assignment.job_id || '<');
6441: hr_utility.trace(' rec_assignment.position_id>' ||
6442: rec_assignment.position_id || '<');
6443: hr_utility.trace(' rec_assignment.grade_id>' ||
6444: rec_assignment.grade_id || '<');
6445: hr_utility.trace(' rec_assignment.location_id>' ||
6439: hr_utility.trace(' rec_assignment.job_id>' ||
6440: rec_assignment.job_id || '<');
6441: hr_utility.trace(' rec_assignment.position_id>' ||
6442: rec_assignment.position_id || '<');
6443: hr_utility.trace(' rec_assignment.grade_id>' ||
6444: rec_assignment.grade_id || '<');
6445: hr_utility.trace(' rec_assignment.location_id>' ||
6446: rec_assignment.location_id || '<');
6447: hr_utility.trace(' rec_assignment.employment_category>' ||
6441: hr_utility.trace(' rec_assignment.position_id>' ||
6442: rec_assignment.position_id || '<');
6443: hr_utility.trace(' rec_assignment.grade_id>' ||
6444: rec_assignment.grade_id || '<');
6445: hr_utility.trace(' rec_assignment.location_id>' ||
6446: rec_assignment.location_id || '<');
6447: hr_utility.trace(' rec_assignment.employment_category>' ||
6448: rec_assignment.employment_category || '<');
6449: hr_utility.trace(' rec_assignment.payroll_id>' ||
6443: hr_utility.trace(' rec_assignment.grade_id>' ||
6444: rec_assignment.grade_id || '<');
6445: hr_utility.trace(' rec_assignment.location_id>' ||
6446: rec_assignment.location_id || '<');
6447: hr_utility.trace(' rec_assignment.employment_category>' ||
6448: rec_assignment.employment_category || '<');
6449: hr_utility.trace(' rec_assignment.payroll_id>' ||
6450: rec_assignment.payroll_id || '<');
6451: hr_utility.trace(' rec_assignment.pay_basis_id>' ||
6445: hr_utility.trace(' rec_assignment.location_id>' ||
6446: rec_assignment.location_id || '<');
6447: hr_utility.trace(' rec_assignment.employment_category>' ||
6448: rec_assignment.employment_category || '<');
6449: hr_utility.trace(' rec_assignment.payroll_id>' ||
6450: rec_assignment.payroll_id || '<');
6451: hr_utility.trace(' rec_assignment.pay_basis_id>' ||
6452: rec_assignment.pay_basis_id || '<');
6453: end loop;
6447: hr_utility.trace(' rec_assignment.employment_category>' ||
6448: rec_assignment.employment_category || '<');
6449: hr_utility.trace(' rec_assignment.payroll_id>' ||
6450: rec_assignment.payroll_id || '<');
6451: hr_utility.trace(' rec_assignment.pay_basis_id>' ||
6452: rec_assignment.pay_basis_id || '<');
6453: end loop;
6454:
6455: hr_utility.trace('>>> Element Entry info <<<');
6451: hr_utility.trace(' rec_assignment.pay_basis_id>' ||
6452: rec_assignment.pay_basis_id || '<');
6453: end loop;
6454:
6455: hr_utility.trace('>>> Element Entry info <<<');
6456: hr_utility.trace('EEID ET CT ESD EED ELID ETID PYID JOB POS PGRP ORG LOC GRD PBID LFLG SLFLG');
6457:
6458: for eerec in ee loop
6459:
6452: rec_assignment.pay_basis_id || '<');
6453: end loop;
6454:
6455: hr_utility.trace('>>> Element Entry info <<<');
6456: hr_utility.trace('EEID ET CT ESD EED ELID ETID PYID JOB POS PGRP ORG LOC GRD PBID LFLG SLFLG');
6457:
6458: for eerec in ee loop
6459:
6460: hr_utility.trace(
6456: hr_utility.trace('EEID ET CT ESD EED ELID ETID PYID JOB POS PGRP ORG LOC GRD PBID LFLG SLFLG');
6457:
6458: for eerec in ee loop
6459:
6460: hr_utility.trace(
6461: eerec.element_entry_id || ' ' ||
6462: eerec.entry_type || ' ' ||
6463: eerec.creator_type || ' ' ||
6464: eerec.esd || ' ' ||
6477: eerec.standard_link_flag);
6478:
6479: end loop;
6480:
6481: hr_utility.trace('***** dump end *****');
6482: end dump_info;
6483: --
6484: --
6485: --
6520: procedure check_parameters is
6521: --
6522: begin
6523: --
6524: hr_utility.trace('In hrentmnt.maintain_entries_asg');
6525: hr_utility.trace ('');
6526: hr_utility.trace (' p_assignment_id = '
6527: ||to_char (p_assignment_id));
6528: hr_utility.trace (' p_old_payroll_id = '
6521: --
6522: begin
6523: --
6524: hr_utility.trace('In hrentmnt.maintain_entries_asg');
6525: hr_utility.trace ('');
6526: hr_utility.trace (' p_assignment_id = '
6527: ||to_char (p_assignment_id));
6528: hr_utility.trace (' p_old_payroll_id = '
6529: ||to_char (p_old_payroll_id));
6522: begin
6523: --
6524: hr_utility.trace('In hrentmnt.maintain_entries_asg');
6525: hr_utility.trace ('');
6526: hr_utility.trace (' p_assignment_id = '
6527: ||to_char (p_assignment_id));
6528: hr_utility.trace (' p_old_payroll_id = '
6529: ||to_char (p_old_payroll_id));
6530: hr_utility.trace (' p_new_payroll_id = '
6524: hr_utility.trace('In hrentmnt.maintain_entries_asg');
6525: hr_utility.trace ('');
6526: hr_utility.trace (' p_assignment_id = '
6527: ||to_char (p_assignment_id));
6528: hr_utility.trace (' p_old_payroll_id = '
6529: ||to_char (p_old_payroll_id));
6530: hr_utility.trace (' p_new_payroll_id = '
6531: ||to_char (p_new_payroll_id));
6532: hr_utility.trace (' p_business_group_id = '
6526: hr_utility.trace (' p_assignment_id = '
6527: ||to_char (p_assignment_id));
6528: hr_utility.trace (' p_old_payroll_id = '
6529: ||to_char (p_old_payroll_id));
6530: hr_utility.trace (' p_new_payroll_id = '
6531: ||to_char (p_new_payroll_id));
6532: hr_utility.trace (' p_business_group_id = '
6533: ||to_char (p_business_group_id));
6534: hr_utility.trace (' p_operation = '
6528: hr_utility.trace (' p_old_payroll_id = '
6529: ||to_char (p_old_payroll_id));
6530: hr_utility.trace (' p_new_payroll_id = '
6531: ||to_char (p_new_payroll_id));
6532: hr_utility.trace (' p_business_group_id = '
6533: ||to_char (p_business_group_id));
6534: hr_utility.trace (' p_operation = '
6535: ||p_operation);
6536: hr_utility.trace (' p_actual_term_date = '
6530: hr_utility.trace (' p_new_payroll_id = '
6531: ||to_char (p_new_payroll_id));
6532: hr_utility.trace (' p_business_group_id = '
6533: ||to_char (p_business_group_id));
6534: hr_utility.trace (' p_operation = '
6535: ||p_operation);
6536: hr_utility.trace (' p_actual_term_date = '
6537: ||to_char (p_actual_term_date));
6538: hr_utility.trace (' p_last_standard_date = '
6532: hr_utility.trace (' p_business_group_id = '
6533: ||to_char (p_business_group_id));
6534: hr_utility.trace (' p_operation = '
6535: ||p_operation);
6536: hr_utility.trace (' p_actual_term_date = '
6537: ||to_char (p_actual_term_date));
6538: hr_utility.trace (' p_last_standard_date = '
6539: ||to_char (p_last_standard_date));
6540: hr_utility.trace (' p_final_process_date = '
6534: hr_utility.trace (' p_operation = '
6535: ||p_operation);
6536: hr_utility.trace (' p_actual_term_date = '
6537: ||to_char (p_actual_term_date));
6538: hr_utility.trace (' p_last_standard_date = '
6539: ||to_char (p_last_standard_date));
6540: hr_utility.trace (' p_final_process_date = '
6541: ||to_char (p_final_process_date));
6542: hr_utility.trace (' p_dt_mode = '
6536: hr_utility.trace (' p_actual_term_date = '
6537: ||to_char (p_actual_term_date));
6538: hr_utility.trace (' p_last_standard_date = '
6539: ||to_char (p_last_standard_date));
6540: hr_utility.trace (' p_final_process_date = '
6541: ||to_char (p_final_process_date));
6542: hr_utility.trace (' p_dt_mode = '
6543: ||p_dt_mode);
6544: hr_utility.trace (' p_validation_start_date = '
6538: hr_utility.trace (' p_last_standard_date = '
6539: ||to_char (p_last_standard_date));
6540: hr_utility.trace (' p_final_process_date = '
6541: ||to_char (p_final_process_date));
6542: hr_utility.trace (' p_dt_mode = '
6543: ||p_dt_mode);
6544: hr_utility.trace (' p_validation_start_date = '
6545: ||to_char (p_validation_start_date));
6546: hr_utility.trace (' p_validation_end_date = '
6540: hr_utility.trace (' p_final_process_date = '
6541: ||to_char (p_final_process_date));
6542: hr_utility.trace (' p_dt_mode = '
6543: ||p_dt_mode);
6544: hr_utility.trace (' p_validation_start_date = '
6545: ||to_char (p_validation_start_date));
6546: hr_utility.trace (' p_validation_end_date = '
6547: ||to_char (p_validation_end_date));
6548: hr_utility.trace (' p_entries_changed = '
6542: hr_utility.trace (' p_dt_mode = '
6543: ||p_dt_mode);
6544: hr_utility.trace (' p_validation_start_date = '
6545: ||to_char (p_validation_start_date));
6546: hr_utility.trace (' p_validation_end_date = '
6547: ||to_char (p_validation_end_date));
6548: hr_utility.trace (' p_entries_changed = '
6549: ||p_entries_changed);
6550: hr_utility.trace (' p_old_hire_date = '
6544: hr_utility.trace (' p_validation_start_date = '
6545: ||to_char (p_validation_start_date));
6546: hr_utility.trace (' p_validation_end_date = '
6547: ||to_char (p_validation_end_date));
6548: hr_utility.trace (' p_entries_changed = '
6549: ||p_entries_changed);
6550: hr_utility.trace (' p_old_hire_date = '
6551: ||to_char(p_old_hire_date));
6552: hr_utility.trace (' p_old_people_group_id = '
6546: hr_utility.trace (' p_validation_end_date = '
6547: ||to_char (p_validation_end_date));
6548: hr_utility.trace (' p_entries_changed = '
6549: ||p_entries_changed);
6550: hr_utility.trace (' p_old_hire_date = '
6551: ||to_char(p_old_hire_date));
6552: hr_utility.trace (' p_old_people_group_id = '
6553: ||to_char(p_old_people_group_id));
6554: hr_utility.trace (' p_new_people_group_id = '
6548: hr_utility.trace (' p_entries_changed = '
6549: ||p_entries_changed);
6550: hr_utility.trace (' p_old_hire_date = '
6551: ||to_char(p_old_hire_date));
6552: hr_utility.trace (' p_old_people_group_id = '
6553: ||to_char(p_old_people_group_id));
6554: hr_utility.trace (' p_new_people_group_id = '
6555: ||to_char(p_new_people_group_id));
6556: hr_utility.trace ('');
6550: hr_utility.trace (' p_old_hire_date = '
6551: ||to_char(p_old_hire_date));
6552: hr_utility.trace (' p_old_people_group_id = '
6553: ||to_char(p_old_people_group_id));
6554: hr_utility.trace (' p_new_people_group_id = '
6555: ||to_char(p_new_people_group_id));
6556: hr_utility.trace ('');
6557: --
6558: end check_parameters;
6552: hr_utility.trace (' p_old_people_group_id = '
6553: ||to_char(p_old_people_group_id));
6554: hr_utility.trace (' p_new_people_group_id = '
6555: ||to_char(p_new_people_group_id));
6556: hr_utility.trace ('');
6557: --
6558: end check_parameters;
6559: --
6560: begin
6561: --
6562: null;
6563: -- --
6564: begin
6565: g_debug := hr_utility.debug_enabled;
6566: --
6567: if g_debug then
6568: check_parameters;
6569: end if;
6648: p_new_people_group_id);
6649: end if;
6650: --
6651: if g_debug then
6652: hr_utility.trace('Out hrentmnt.maintain_entries_asg');
6653: end if;
6654: --
6655: exception
6656: when others then
6657: --
6658: -- if an error occurs, print the message and raise the error again
6659: if g_debug then
6660:
6661: hr_utility.trace('****************************************');
6662: hr_utility.trace('Sqlcode>' || Sqlcode || '<');
6663: hr_utility.trace('Sqlerrm>' || Sqlerrm || '<');
6664: hr_utility.trace('****************************************');
6665:
6658: -- if an error occurs, print the message and raise the error again
6659: if g_debug then
6660:
6661: hr_utility.trace('****************************************');
6662: hr_utility.trace('Sqlcode>' || Sqlcode || '<');
6663: hr_utility.trace('Sqlerrm>' || Sqlerrm || '<');
6664: hr_utility.trace('****************************************');
6665:
6666: dump_info(p_assignment_id, p_business_group_id);
6659: if g_debug then
6660:
6661: hr_utility.trace('****************************************');
6662: hr_utility.trace('Sqlcode>' || Sqlcode || '<');
6663: hr_utility.trace('Sqlerrm>' || Sqlerrm || '<');
6664: hr_utility.trace('****************************************');
6665:
6666: dump_info(p_assignment_id, p_business_group_id);
6667:
6660:
6661: hr_utility.trace('****************************************');
6662: hr_utility.trace('Sqlcode>' || Sqlcode || '<');
6663: hr_utility.trace('Sqlerrm>' || Sqlerrm || '<');
6664: hr_utility.trace('****************************************');
6665:
6666: dump_info(p_assignment_id, p_business_group_id);
6667:
6668: end if;
6699: procedure check_parameters is
6700: --
6701: begin
6702: --
6703: hr_utility.trace ('In hrentmnt.maintain_entries_asg');
6704: hr_utility.trace ('');
6705: hr_utility.trace (' p_assignment_id = '
6706: ||to_char (p_assignment_id));
6707: hr_utility.trace (' p_business_group_id = '
6700: --
6701: begin
6702: --
6703: hr_utility.trace ('In hrentmnt.maintain_entries_asg');
6704: hr_utility.trace ('');
6705: hr_utility.trace (' p_assignment_id = '
6706: ||to_char (p_assignment_id));
6707: hr_utility.trace (' p_business_group_id = '
6708: ||to_char (p_business_group_id));
6701: begin
6702: --
6703: hr_utility.trace ('In hrentmnt.maintain_entries_asg');
6704: hr_utility.trace ('');
6705: hr_utility.trace (' p_assignment_id = '
6706: ||to_char (p_assignment_id));
6707: hr_utility.trace (' p_business_group_id = '
6708: ||to_char (p_business_group_id));
6709: hr_utility.trace (' p_operation = '
6703: hr_utility.trace ('In hrentmnt.maintain_entries_asg');
6704: hr_utility.trace ('');
6705: hr_utility.trace (' p_assignment_id = '
6706: ||to_char (p_assignment_id));
6707: hr_utility.trace (' p_business_group_id = '
6708: ||to_char (p_business_group_id));
6709: hr_utility.trace (' p_operation = '
6710: ||p_operation);
6711: hr_utility.trace (' p_actual_term_date = '
6705: hr_utility.trace (' p_assignment_id = '
6706: ||to_char (p_assignment_id));
6707: hr_utility.trace (' p_business_group_id = '
6708: ||to_char (p_business_group_id));
6709: hr_utility.trace (' p_operation = '
6710: ||p_operation);
6711: hr_utility.trace (' p_actual_term_date = '
6712: ||to_char (p_actual_term_date));
6713: hr_utility.trace (' p_last_standard_date = '
6707: hr_utility.trace (' p_business_group_id = '
6708: ||to_char (p_business_group_id));
6709: hr_utility.trace (' p_operation = '
6710: ||p_operation);
6711: hr_utility.trace (' p_actual_term_date = '
6712: ||to_char (p_actual_term_date));
6713: hr_utility.trace (' p_last_standard_date = '
6714: ||to_char (p_last_standard_date));
6715: hr_utility.trace (' p_final_process_date = '
6709: hr_utility.trace (' p_operation = '
6710: ||p_operation);
6711: hr_utility.trace (' p_actual_term_date = '
6712: ||to_char (p_actual_term_date));
6713: hr_utility.trace (' p_last_standard_date = '
6714: ||to_char (p_last_standard_date));
6715: hr_utility.trace (' p_final_process_date = '
6716: ||to_char (p_final_process_date));
6717: hr_utility.trace (' p_dt_mode = '
6711: hr_utility.trace (' p_actual_term_date = '
6712: ||to_char (p_actual_term_date));
6713: hr_utility.trace (' p_last_standard_date = '
6714: ||to_char (p_last_standard_date));
6715: hr_utility.trace (' p_final_process_date = '
6716: ||to_char (p_final_process_date));
6717: hr_utility.trace (' p_dt_mode = '
6718: ||p_dt_mode);
6719: hr_utility.trace (' p_validation_start_date = '
6713: hr_utility.trace (' p_last_standard_date = '
6714: ||to_char (p_last_standard_date));
6715: hr_utility.trace (' p_final_process_date = '
6716: ||to_char (p_final_process_date));
6717: hr_utility.trace (' p_dt_mode = '
6718: ||p_dt_mode);
6719: hr_utility.trace (' p_validation_start_date = '
6720: ||to_char (p_validation_start_date));
6721: hr_utility.trace (' p_validation_end_date = '
6715: hr_utility.trace (' p_final_process_date = '
6716: ||to_char (p_final_process_date));
6717: hr_utility.trace (' p_dt_mode = '
6718: ||p_dt_mode);
6719: hr_utility.trace (' p_validation_start_date = '
6720: ||to_char (p_validation_start_date));
6721: hr_utility.trace (' p_validation_end_date = '
6722: ||to_char (p_validation_end_date));
6723: hr_utility.trace ('');
6717: hr_utility.trace (' p_dt_mode = '
6718: ||p_dt_mode);
6719: hr_utility.trace (' p_validation_start_date = '
6720: ||to_char (p_validation_start_date));
6721: hr_utility.trace (' p_validation_end_date = '
6722: ||to_char (p_validation_end_date));
6723: hr_utility.trace ('');
6724: --
6725: end check_parameters;
6719: hr_utility.trace (' p_validation_start_date = '
6720: ||to_char (p_validation_start_date));
6721: hr_utility.trace (' p_validation_end_date = '
6722: ||to_char (p_validation_end_date));
6723: hr_utility.trace ('');
6724: --
6725: end check_parameters;
6726: --
6727: begin
6727: begin
6728: null;
6729: -- --
6730: begin
6731: g_debug := hr_utility.debug_enabled;
6732: --
6733: if g_debug then
6734: check_parameters;
6735: end if;
6755: --
6756: -- if an error occurs, print the message and raise the error again
6757: --
6758: if g_debug then
6759: hr_utility.trace('***** over');
6760: hr_utility.trace('Sqlcode>' || Sqlcode || '<');
6761: hr_utility.trace('Sqlerrm>' || Sqlerrm || '<');
6762: hr_utility.trace('*****');
6763: end if;
6756: -- if an error occurs, print the message and raise the error again
6757: --
6758: if g_debug then
6759: hr_utility.trace('***** over');
6760: hr_utility.trace('Sqlcode>' || Sqlcode || '<');
6761: hr_utility.trace('Sqlerrm>' || Sqlerrm || '<');
6762: hr_utility.trace('*****');
6763: end if;
6764: raise;
6757: --
6758: if g_debug then
6759: hr_utility.trace('***** over');
6760: hr_utility.trace('Sqlcode>' || Sqlcode || '<');
6761: hr_utility.trace('Sqlerrm>' || Sqlerrm || '<');
6762: hr_utility.trace('*****');
6763: end if;
6764: raise;
6765: end;
6758: if g_debug then
6759: hr_utility.trace('***** over');
6760: hr_utility.trace('Sqlcode>' || Sqlcode || '<');
6761: hr_utility.trace('Sqlerrm>' || Sqlerrm || '<');
6762: hr_utility.trace('*****');
6763: end if;
6764: raise;
6765: end;
6766: -- --
6809: procedure check_parameters is
6810: --
6811: begin
6812: --
6813: hr_utility.trace ('In hrentmnt.check_opmu');
6814: hr_utility.trace ('');
6815: hr_utility.trace (' p_assignment_id = '
6816: ||to_char (p_assignment_id));
6817: hr_utility.trace (' p_payroll_id = '
6810: --
6811: begin
6812: --
6813: hr_utility.trace ('In hrentmnt.check_opmu');
6814: hr_utility.trace ('');
6815: hr_utility.trace (' p_assignment_id = '
6816: ||to_char (p_assignment_id));
6817: hr_utility.trace (' p_payroll_id = '
6818: ||to_char (p_payroll_id));
6811: begin
6812: --
6813: hr_utility.trace ('In hrentmnt.check_opmu');
6814: hr_utility.trace ('');
6815: hr_utility.trace (' p_assignment_id = '
6816: ||to_char (p_assignment_id));
6817: hr_utility.trace (' p_payroll_id = '
6818: ||to_char (p_payroll_id));
6819: hr_utility.trace (' p_dt_mode = '
6813: hr_utility.trace ('In hrentmnt.check_opmu');
6814: hr_utility.trace ('');
6815: hr_utility.trace (' p_assignment_id = '
6816: ||to_char (p_assignment_id));
6817: hr_utility.trace (' p_payroll_id = '
6818: ||to_char (p_payroll_id));
6819: hr_utility.trace (' p_dt_mode = '
6820: ||p_dt_mode);
6821: hr_utility.trace (' p_validation_start_date = '
6815: hr_utility.trace (' p_assignment_id = '
6816: ||to_char (p_assignment_id));
6817: hr_utility.trace (' p_payroll_id = '
6818: ||to_char (p_payroll_id));
6819: hr_utility.trace (' p_dt_mode = '
6820: ||p_dt_mode);
6821: hr_utility.trace (' p_validation_start_date = '
6822: ||to_char (p_validation_start_date));
6823: hr_utility.trace (' p_validation_end_date = '
6817: hr_utility.trace (' p_payroll_id = '
6818: ||to_char (p_payroll_id));
6819: hr_utility.trace (' p_dt_mode = '
6820: ||p_dt_mode);
6821: hr_utility.trace (' p_validation_start_date = '
6822: ||to_char (p_validation_start_date));
6823: hr_utility.trace (' p_validation_end_date = '
6824: ||to_char (p_validation_end_date));
6825: hr_utility.trace ('');
6819: hr_utility.trace (' p_dt_mode = '
6820: ||p_dt_mode);
6821: hr_utility.trace (' p_validation_start_date = '
6822: ||to_char (p_validation_start_date));
6823: hr_utility.trace (' p_validation_end_date = '
6824: ||to_char (p_validation_end_date));
6825: hr_utility.trace ('');
6826: --
6827: end check_parameters;
6821: hr_utility.trace (' p_validation_start_date = '
6822: ||to_char (p_validation_start_date));
6823: hr_utility.trace (' p_validation_end_date = '
6824: ||to_char (p_validation_end_date));
6825: hr_utility.trace ('');
6826: --
6827: end check_parameters;
6828: --
6829: begin
6826: --
6827: end check_parameters;
6828: --
6829: begin
6830: g_debug := hr_utility.debug_enabled;
6831: --
6832: if g_debug then
6833: check_parameters;
6834: end if;
6849: and ppm.effective_end_date >= p_validation_start_date);
6850: exception
6851: when no_data_found then
6852: if g_debug then
6853: hr_utility.trace('No opmu for DELETE or ZAP mode');
6854: end if;
6855: end;
6856: --
6857: -- Otherwise check that the existing PPMs remain valid after the Transfer
6891: end;
6892: --
6893: if no_opmu = 'Y' then
6894: if g_debug then
6895: hr_utility.trace('No opmu from first check.');
6896: end if;
6897: exit;
6898: end if;
6899: --
6939: end;
6940: --
6941: if no_opmu = 'Y' then
6942: if g_debug then
6943: hr_utility.trace('No opmu from second check.');
6944: end if;
6945: exit;
6946: end if;
6947: --
6949: --
6950: end if;
6951: --
6952: if no_opmu = 'Y' then
6953: hr_utility.set_message(801,'HR_6844_ASS_PPM_INVALID');
6954: hr_utility.raise_error;
6955: end if;
6956: --
6957: if g_debug then
6950: end if;
6951: --
6952: if no_opmu = 'Y' then
6953: hr_utility.set_message(801,'HR_6844_ASS_PPM_INVALID');
6954: hr_utility.raise_error;
6955: end if;
6956: --
6957: if g_debug then
6958: hr_utility.trace ('Out hrentmnt.check_opmu');
6954: hr_utility.raise_error;
6955: end if;
6956: --
6957: if g_debug then
6958: hr_utility.trace ('Out hrentmnt.check_opmu');
6959: end if;
6960: --
6961: end check_opmu;
6962: --
7009: and c_old_final_process_date between ee.effective_start_date and ee.effective_end_date
7010: and c_old_final_process_date between et.effective_start_date and et.effective_end_date;
7011:
7012: BEGIN
7013: hr_utility.set_location(l_proc, 10);
7014:
7015: SAVEPOINT move_fpd_entries;
7016:
7017: l_new_final_process_date := p_new_final_process_date;
7024: -- Get all the entries of termination rule type F which could be affected by change in fpd.
7025: for r_entry in process_entries(p_old_final_process_date,p_assignment_id)
7026: loop
7027: --
7028: hr_utility.set_location(l_proc,20);
7029: hr_utility.trace('EE processing type: '||r_entry.processing_type);
7030: hr_utility.trace('Old EE effective end date: '||to_char(r_entry.effective_end_date,'DD-MON-YYYY'));
7031:
7032: l_object_version_number := r_entry.object_version_number;
7025: for r_entry in process_entries(p_old_final_process_date,p_assignment_id)
7026: loop
7027: --
7028: hr_utility.set_location(l_proc,20);
7029: hr_utility.trace('EE processing type: '||r_entry.processing_type);
7030: hr_utility.trace('Old EE effective end date: '||to_char(r_entry.effective_end_date,'DD-MON-YYYY'));
7031:
7032: l_object_version_number := r_entry.object_version_number;
7033: l_new_esd := r_entry.effective_start_date;
7026: loop
7027: --
7028: hr_utility.set_location(l_proc,20);
7029: hr_utility.trace('EE processing type: '||r_entry.processing_type);
7030: hr_utility.trace('Old EE effective end date: '||to_char(r_entry.effective_end_date,'DD-MON-YYYY'));
7031:
7032: l_object_version_number := r_entry.object_version_number;
7033: l_new_esd := r_entry.effective_start_date;
7034: l_new_eed := r_entry.effective_end_date;
7036:
7037: if l_new_final_process_date < r_entry.effective_start_date then
7038:
7039: /* Code to ZAP the element entry*/
7040: hr_utility.set_location(l_proc,30);
7041:
7042: pay_element_entry_api.delete_element_entry
7043: (p_validate => false
7044: ,p_datetrack_delete_mode => 'ZAP'
7051: );
7052:
7053: else
7054: if r_entry.processing_type = 'N' then
7055: hr_utility.set_location(l_proc,40);
7056: -- Non-recurring entry
7057: -- Derive new effective end date using chk_element_entry_main
7058: -- This will ensure the payroll period is considered
7059: hr_entry.chk_element_entry_main
7074: p_target_entry_id => r_entry.target_entry_id,
7075: p_creator_type => r_entry.creator_type
7076: );
7077: else
7078: hr_utility.set_location(l_proc,50);
7079: -- Recurring entry
7080: -- Derive new effective end date using get_eligibility_period
7081: -- This will ensure entry is not extended beyond lifetime of link
7082: hr_entry.get_eligibility_period
7088: p_max_eligibility_date => l_new_eed
7089: );
7090: end if;
7091: --
7092: hr_utility.trace('New EE effective end date: '||to_char(l_new_eed,'DD-MON-YYYY'));
7093: --
7094: -- Now we have the new effective end date
7095: -- Perform checks to make sure we don't move the EED unnecessarily
7096:
7103:
7104: if r_entry.effective_end_date >= p_old_final_process_date
7105: AND r_entry.updating_action_id IS NULL THEN -- bug 7315564
7106:
7107: hr_utility.set_location(l_proc,60);
7108:
7109: update pay_element_entry_values_f
7110: set effective_end_date = l_new_eed
7111: where element_entry_id = r_entry.element_entry_id
7122: -- Moving FPD backwards
7123: -- Only change effective end date of entry if it is greater than the new FPD
7124: if r_entry.effective_end_date > l_new_final_process_date then
7125:
7126: hr_utility.set_location(l_proc,70);
7127:
7128: update pay_element_entry_values_f
7129: set effective_end_date = l_new_eed
7130: where element_entry_id = r_entry.element_entry_id