[Home] [Help]
1196: v_processing_type varchar2(30);
1197: v_period_of_service_id number;
1198: -- Bugfix 5616075
1199: v_actual_termination_date date;
1200: v_last_standard_process_date date;
1201: v_final_process_date date;
1202: v_employee_terminated boolean := false;
1203: v_orig_term_rule_date_func varchar2(30); -- value of 'EE_ORIG_TERM_RULE_DATE_FUNC' action parameter
1204: v_action_param_found boolean;
1255: select asg.period_of_service_id,
1256: asg.primary_flag,
1257: -- Bugfix 5616075
1258: pos.actual_termination_date,
1259: pos.last_standard_process_date,
1260: pos.final_process_date
1261: into v_period_of_service_id,
1262: v_primary_flag,
1263: v_actual_termination_date,
1260: pos.final_process_date
1261: into v_period_of_service_id,
1262: v_primary_flag,
1263: v_actual_termination_date,
1264: v_last_standard_process_date,
1265: v_final_process_date
1266: from per_assignments_f asg,
1267: per_periods_of_service pos
1268: where asg.assignment_id = p_assignment_id
1304: else
1305: hr_utility.trace(' v_actual_termination_date><');
1306: end if;
1307: --
1308: -- Last standard process date...
1309: if v_last_standard_process_date is not null then
1310: hr_utility.trace(' v_last_standard_process_date>' ||
1311: to_char(v_last_standard_process_date, 'DD-MON-YYYY') || '<');
1312: else
1305: hr_utility.trace(' v_actual_termination_date><');
1306: end if;
1307: --
1308: -- Last standard process date...
1309: if v_last_standard_process_date is not null then
1310: hr_utility.trace(' v_last_standard_process_date>' ||
1311: to_char(v_last_standard_process_date, 'DD-MON-YYYY') || '<');
1312: else
1313: hr_utility.trace(' v_last_standard_process_date><');
1306: end if;
1307: --
1308: -- Last standard process date...
1309: if v_last_standard_process_date is not null then
1310: hr_utility.trace(' v_last_standard_process_date>' ||
1311: to_char(v_last_standard_process_date, 'DD-MON-YYYY') || '<');
1312: else
1313: hr_utility.trace(' v_last_standard_process_date><');
1314: end if;
1307: --
1308: -- Last standard process date...
1309: if v_last_standard_process_date is not null then
1310: hr_utility.trace(' v_last_standard_process_date>' ||
1311: to_char(v_last_standard_process_date, 'DD-MON-YYYY') || '<');
1312: else
1313: hr_utility.trace(' v_last_standard_process_date><');
1314: end if;
1315: --
1309: if v_last_standard_process_date is not null then
1310: hr_utility.trace(' v_last_standard_process_date>' ||
1311: to_char(v_last_standard_process_date, 'DD-MON-YYYY') || '<');
1312: else
1313: hr_utility.trace(' v_last_standard_process_date><');
1314: end if;
1315: --
1316: -- Final process date...
1317: if v_final_process_date is not null then
1342: end if;
1343: --
1344: v_employee_terminated :=
1345: (v_actual_termination_date is not null or
1346: v_last_standard_process_date is not null or
1347: v_final_process_date is not null);
1348: --
1349: -- Original behaviour:
1350: -- -------------------
1368: --
1369: -- Get the termination rule date
1370: --
1371: if v_post_termination_rule = 'L' then
1372: v_element_term_rule_date := nvl(v_last_standard_process_date, hr_general.end_of_time);
1373: elsif v_post_termination_rule = 'F' then
1374: v_element_term_rule_date := nvl(v_final_process_date, hr_general.end_of_time);
1375: else
1376: v_element_term_rule_date := nvl(v_actual_termination_date, hr_general.end_of_time);
1375: else
1376: v_element_term_rule_date := nvl(v_actual_termination_date, hr_general.end_of_time);
1377: end if;
1378: --
1379: -- Bug 382760. If termination rule is Actual Termination or Last Standard
1380: -- Process and element is Nonrecurring then entries close down on the last day
1381: -- of the pay period. Only recurring entries close down on the termination
1382: -- date.
1383: --
1559: -- period as the element termination rule,
1560: -- this could be less the ED (the ESD of the EL), thus error
1561: -- HR_6370_ELE_ENTRY_NO_TERM was returned,
1562: --
1563: -- for Last Standard Process entries on TERM assignments, periods do not
1564: -- apply, the entry can span out to the EED of the TERM assignment,
1565: -- nb. the EED of the ALU is limited by the EED of the EL and TERM assignment
1566: --
1567: begin
2649: -- NAME
2650: -- hr_entry.chk_element_entry
2651: --
2652: -- DESCRIPTION
2653: -- This procedure is used for referential/standard checks when inserting/
2654: -- updating or deleteing element enries.
2655: --
2656: -- Procedure Parameter Name Description
2657: -- ========================== =================================================
2720: -- NAME
2721: -- hr_entry.chk_element_entry_main
2722: --
2723: -- DESCRIPTION
2724: -- This procedure is used for referential/standard checks when inserting/
2725: -- updating or deleteing element enries.
2726: --
2727: -- Procedure Parameter Name Description
2728: -- ========================== =================================================
3082: v_validation_end_date,
3083: p_assignment_id);
3084:
3085: --
3086: -- If inserting an entry which is NOT a standard Recurring entry then
3087: -- perform various date validation.
3088: --
3089: if (p_usage = 'INSERT' and
3090: ((v_processing_type = 'R' and
3153: end if;
3154: --
3155: end if;
3156: --
3157: -- Standard recurring entry checks.
3158: --
3159: if ((p_entry_type = 'E' and
3160: v_processing_type = 'R') and
3161: (p_dt_delete_mode = 'ZAP' or
3265: end if;
3266: --
3267: end if;
3268: --
3269: -- Standard adjustment entry insert checks.
3270: --
3271: if ((p_entry_type = 'R' or
3272: p_entry_type = 'A') and
3273: p_usage = 'INSERT') then
4355: end;
4356: end if;
4357: --
4358: -- We only need to delete from element entries where the entry is a
4359: -- standard recurring entry which could be datetracked.
4360: --
4361: if (p_processing_type = 'R' and
4362: p_entry_type = 'E') then
4363: --
5659: l_run_result_status varchar2(30);
5660: begin
5661: g_debug := hr_utility.debug_enabled;
5662: --
5663: -- We need to get the standard assignment payroll and time period details
5664: --
5665: if g_debug then
5666: hr_utility.set_location('hr_entry.return_entry_display_status', 1);
5667: end if;