DBA Data[Home] [Help]

APPS.HR_ENTRY dependencies on STANDARD

Line 1198: hr_utility.trace ('LSP: '||l_service_rec.last_standard_process_date);

1194: l_eff_term_date := null;
1195:
1196: if g_debug then
1197: hr_utility.trace ('ATD: '||l_service_rec.actual_termination_date);
1198: hr_utility.trace ('LSP: '||l_service_rec.last_standard_process_date);
1199: hr_utility.trace ('FPD: '||l_service_rec.final_process_date);
1200: end if;
1201:
1202: -- if terminated employee, set element termination rule date as max elig date

Line 1205: l_service_rec.last_standard_process_date is not null) then

1201:
1202: -- if terminated employee, set element termination rule date as max elig date
1203: if (l_service_rec.actual_termination_date is not null or
1204: l_service_rec.final_process_date is not null or
1205: l_service_rec.last_standard_process_date is not null) then
1206:
1207: select decode (l_post_termination_rule, 'A', l_service_rec.actual_termination_date
1208: , 'L', l_service_rec.last_standard_process_date
1209: , 'F', l_service_rec.final_process_date, null)

Line 1208: , 'L', l_service_rec.last_standard_process_date

1204: l_service_rec.final_process_date is not null or
1205: l_service_rec.last_standard_process_date is not null) then
1206:
1207: select decode (l_post_termination_rule, 'A', l_service_rec.actual_termination_date
1208: , 'L', l_service_rec.last_standard_process_date
1209: , 'F', l_service_rec.final_process_date, null)
1210: into l_eff_term_date
1211: from dual;
1212:

Line 1392: v_last_standard_process_date date;

1388: v_processing_type varchar2(30);
1389: v_period_of_service_id number;
1390: -- Bugfix 5616075
1391: v_actual_termination_date date;
1392: v_last_standard_process_date date;
1393: v_final_process_date date;
1394: v_employee_terminated boolean := false;
1395: v_orig_term_rule_date_func varchar2(30); -- value of 'EE_ORIG_TERM_RULE_DATE_FUNC' action parameter
1396: v_action_param_found boolean;

Line 1451: pos.last_standard_process_date,

1447: select asg.period_of_service_id,
1448: asg.primary_flag,
1449: -- Bugfix 5616075
1450: pos.actual_termination_date,
1451: pos.last_standard_process_date,
1452: pos.final_process_date
1453: into v_period_of_service_id,
1454: v_primary_flag,
1455: v_actual_termination_date,

Line 1456: v_last_standard_process_date,

1452: pos.final_process_date
1453: into v_period_of_service_id,
1454: v_primary_flag,
1455: v_actual_termination_date,
1456: v_last_standard_process_date,
1457: v_final_process_date
1458: from per_assignments_f asg,
1459: per_periods_of_service pos
1460: where asg.assignment_id = p_assignment_id

Line 1469: hr_utility.trace(' v_last_standard_process_date : '|| v_last_standard_process_date);

1465: if g_debug then
1466: hr_utility.trace(' v_period_of_service_id : '|| v_period_of_service_id);
1467: hr_utility.trace(' v_primary_flag : '|| v_primary_flag);
1468: hr_utility.trace(' v_actual_termination_date : '|| v_actual_termination_date);
1469: hr_utility.trace(' v_last_standard_process_date : '|| v_last_standard_process_date);
1470: hr_utility.trace(' v_final_process_date : '|| v_final_process_date);
1471: end if;
1472: --
1473: select pet.post_termination_rule,

Line 1508: -- Last standard process date...

1504: else
1505: hr_utility.trace(' v_actual_termination_date><');
1506: end if;
1507: --
1508: -- Last standard process date...
1509: if v_last_standard_process_date is not null then
1510: hr_utility.trace(' v_last_standard_process_date>' ||
1511: to_char(v_last_standard_process_date, 'DD-MON-YYYY') || '<');
1512: else

Line 1509: if v_last_standard_process_date is not null then

1505: hr_utility.trace(' v_actual_termination_date><');
1506: end if;
1507: --
1508: -- Last standard process date...
1509: if v_last_standard_process_date is not null then
1510: hr_utility.trace(' v_last_standard_process_date>' ||
1511: to_char(v_last_standard_process_date, 'DD-MON-YYYY') || '<');
1512: else
1513: hr_utility.trace(' v_last_standard_process_date><');

Line 1510: hr_utility.trace(' v_last_standard_process_date>' ||

1506: end if;
1507: --
1508: -- Last standard process date...
1509: if v_last_standard_process_date is not null then
1510: hr_utility.trace(' v_last_standard_process_date>' ||
1511: to_char(v_last_standard_process_date, 'DD-MON-YYYY') || '<');
1512: else
1513: hr_utility.trace(' v_last_standard_process_date><');
1514: end if;

Line 1511: to_char(v_last_standard_process_date, 'DD-MON-YYYY') || '<');

1507: --
1508: -- Last standard process date...
1509: if v_last_standard_process_date is not null then
1510: hr_utility.trace(' v_last_standard_process_date>' ||
1511: to_char(v_last_standard_process_date, 'DD-MON-YYYY') || '<');
1512: else
1513: hr_utility.trace(' v_last_standard_process_date><');
1514: end if;
1515: --

Line 1513: hr_utility.trace(' v_last_standard_process_date><');

1509: if v_last_standard_process_date is not null then
1510: hr_utility.trace(' v_last_standard_process_date>' ||
1511: to_char(v_last_standard_process_date, 'DD-MON-YYYY') || '<');
1512: else
1513: hr_utility.trace(' v_last_standard_process_date><');
1514: end if;
1515: --
1516: -- Final process date...
1517: if v_final_process_date is not null then

Line 1546: v_last_standard_process_date is not null or

1542: end if;
1543: --
1544: v_employee_terminated :=
1545: (v_actual_termination_date is not null or
1546: v_last_standard_process_date is not null or
1547: v_final_process_date is not null);
1548: --
1549: -- Original behaviour:
1550: -- -------------------

Line 1572: v_element_term_rule_date := nvl(v_last_standard_process_date, hr_general.end_of_time);

1568: --
1569: -- Get the termination rule date
1570: --
1571: if v_post_termination_rule = 'L' then
1572: v_element_term_rule_date := nvl(v_last_standard_process_date, hr_general.end_of_time);
1573: elsif v_post_termination_rule = 'F' then
1574: v_element_term_rule_date := nvl(v_final_process_date, hr_general.end_of_time);
1575: else
1576: v_element_term_rule_date := nvl(v_actual_termination_date, hr_general.end_of_time);

Line 1579: -- Bug 382760. If termination rule is Actual Termination or Last Standard

1575: else
1576: v_element_term_rule_date := nvl(v_actual_termination_date, hr_general.end_of_time);
1577: end if;
1578: --
1579: -- Bug 382760. If termination rule is Actual Termination or Last Standard
1580: -- Process and element is Nonrecurring then entries close down on the last day
1581: -- of the pay period. Only recurring entries close down on the termination
1582: -- date.
1583: --

Line 1771: -- for Last Standard Process entries on TERM assignments, periods do not

1767: -- period as the element termination rule,
1768: -- this could be less the ED (the ESD of the EL), thus error
1769: -- HR_6370_ELE_ENTRY_NO_TERM was returned,
1770: --
1771: -- for Last Standard Process entries on TERM assignments, periods do not
1772: -- apply, the entry can span out to the EED of the TERM assignment,
1773: -- nb. the EED of the ALU is limited by the EED of the EL and TERM assignment
1774: --
1775: /*v_element_term_rule_date := v_asg_term_date; Added for Bug 8485543 and commented below*/

Line 2904: -- This procedure is used for referential/standard checks when inserting/

2900: -- NAME
2901: -- hr_entry.chk_element_entry
2902: --
2903: -- DESCRIPTION
2904: -- This procedure is used for referential/standard checks when inserting/
2905: -- updating or deleteing element enries.
2906: --
2907: -- Procedure Parameter Name Description
2908: -- ========================== =================================================

Line 2995: -- This procedure is used for referential/standard checks when inserting/

2991: -- NAME
2992: -- hr_entry.chk_element_entry_main
2993: --
2994: -- DESCRIPTION
2995: -- This procedure is used for referential/standard checks when inserting/
2996: -- updating or deleteing element enries.
2997: --
2998: -- Procedure Parameter Name Description
2999: -- ========================== =================================================

Line 3461: -- If inserting an entry which is NOT a standard Recurring entry then

3457: end if;
3458: g_target_entry_id := p_target_entry_id;
3459:
3460: --
3461: -- If inserting an entry which is NOT a standard Recurring entry then
3462: -- perform various date validation.
3463: --
3464: if (p_usage = 'INSERT' and
3465: ((v_processing_type = 'R' and

Line 3533: -- Standard recurring entry checks.

3529: end if;
3530: --
3531: end if;
3532: --
3533: -- Standard recurring entry checks.
3534: --
3535: if ((p_entry_type = 'E' and
3536: v_processing_type = 'R') and
3537: (p_dt_delete_mode = 'ZAP' or

Line 3645: -- Standard adjustment entry insert checks.

3641: end if;
3642: --
3643: end if;
3644: --
3645: -- Standard adjustment entry insert checks.
3646: --
3647: if ((p_entry_type = 'R' or
3648: p_entry_type = 'A') and
3649: p_usage = 'INSERT') then

Line 4735: -- standard recurring entry which could be datetracked.

4731: end;
4732: end if;
4733: --
4734: -- We only need to delete from element entries where the entry is a
4735: -- standard recurring entry which could be datetracked.
4736: --
4737: if (p_processing_type = 'R' and
4738: p_entry_type = 'E') then
4739: --

Line 6052: -- We need to get the standard assignment payroll and time period details

6048: l_run_result_status varchar2(30);
6049: begin
6050: g_debug := hr_utility.debug_enabled;
6051: --
6052: -- We need to get the standard assignment payroll and time period details
6053: --
6054: if g_debug then
6055: hr_utility.set_location('hr_entry.return_entry_display_status', 1);
6056: end if;