DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT_API dependencies on STANDARD

Line 1594: l_last_standard_process_date

1590: per_all_assignments_f.assignment_status_type_id%TYPE;
1591: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
1592: l_asg_business_group_id per_all_assignments_f.business_group_id%TYPE;
1593: l_exists varchar2(1);
1594: l_last_standard_process_date
1595: per_periods_of_service.last_standard_process_date%TYPE;
1596: l_actual_termination_date
1597: per_periods_of_service.actual_termination_date%TYPE;
1598: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 1595: per_periods_of_service.last_standard_process_date%TYPE;

1591: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
1592: l_asg_business_group_id per_all_assignments_f.business_group_id%TYPE;
1593: l_exists varchar2(1);
1594: l_last_standard_process_date
1595: per_periods_of_service.last_standard_process_date%TYPE;
1596: l_actual_termination_date
1597: per_periods_of_service.actual_termination_date%TYPE;
1598: l_legislation_code per_business_groups.legislation_code%TYPE;
1599: l_payroll_id per_all_assignments_f.payroll_id%TYPE;

Line 1796: -- Derive the last standard process date.

1792: if g_debug then
1793: hr_utility.set_location(l_proc, 110);
1794: end if;
1795: --
1796: -- Derive the last standard process date.
1797: --
1798: -- Bug 1711085. VS. 27-MAR-01. Commented out the code associated with
1799: -- disabling last_standard_process for US legislature.
1800: --

Line 1799: -- disabling last_standard_process for US legislature.

1795: --
1796: -- Derive the last standard process date.
1797: --
1798: -- Bug 1711085. VS. 27-MAR-01. Commented out the code associated with
1799: -- disabling last_standard_process for US legislature.
1800: --
1801: -- if l_legislation_code = 'US'
1802: -- then
1803: --

Line 1808: -- l_last_standard_process_date := l_actual_termination_date;

1804: if g_debug then
1805: hr_utility.set_location(l_proc, 120);
1806: end if;
1807: --
1808: -- l_last_standard_process_date := l_actual_termination_date;
1809: -- else
1810: --
1811: if g_debug then
1812: hr_utility.set_location(l_proc, 130);

Line 1822: -- Assignment is assigned to a payroll, so set the last standard process

1818: if g_debug then
1819: hr_utility.set_location(l_proc, 140);
1820: end if;
1821: --
1822: -- Assignment is assigned to a payroll, so set the last standard process
1823: -- to date to the payroll's period end date as of the actual termination
1824: -- date.
1825: --
1826: open csr_get_period_end_date;

Line 1828: into l_last_standard_process_date;

1824: -- date.
1825: --
1826: open csr_get_period_end_date;
1827: fetch csr_get_period_end_date
1828: into l_last_standard_process_date;
1829: --
1830: if csr_get_period_end_date%NOTFOUND then
1831: --
1832: if g_debug then

Line 1855: -- Assignment is not assigned to a payroll, so set the last standard

1851: if g_debug then
1852: hr_utility.set_location(l_proc, 170);
1853: end if;
1854: --
1855: -- Assignment is not assigned to a payroll, so set the last standard
1856: -- process date to the actual termination date.
1857: --
1858: l_last_standard_process_date := l_actual_termination_date;
1859: end if;

Line 1858: l_last_standard_process_date := l_actual_termination_date;

1854: --
1855: -- Assignment is not assigned to a payroll, so set the last standard
1856: -- process date to the actual termination date.
1857: --
1858: l_last_standard_process_date := l_actual_termination_date;
1859: end if;
1860: -- end if;
1861: --
1862: if g_debug then

Line 1874: ,p_last_standard_process_date => l_last_standard_process_date

1870: hr_assignment_internal.actual_term_cwk_asg
1871: (p_assignment_id => p_assignment_id
1872: ,p_object_version_number => l_object_version_number
1873: ,p_actual_termination_date => l_actual_termination_date
1874: ,p_last_standard_process_date => l_last_standard_process_date
1875: ,p_assignment_status_type_id => l_assignment_status_type_id
1876: ,p_effective_start_date => l_effective_start_date
1877: ,p_effective_end_date => l_effective_end_date
1878: ,p_asg_future_changes_warning => l_asg_future_changes_warning

Line 2504: l_last_standard_process_date

2500: per_all_assignments_f.assignment_status_type_id%TYPE;
2501: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
2502: l_asg_business_group_id per_all_assignments_f.business_group_id%TYPE;
2503: l_exists varchar2(1);
2504: l_last_standard_process_date
2505: per_periods_of_service.last_standard_process_date%TYPE;
2506: l_actual_termination_date
2507: per_periods_of_service.actual_termination_date%TYPE;
2508: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 2505: per_periods_of_service.last_standard_process_date%TYPE;

2501: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
2502: l_asg_business_group_id per_all_assignments_f.business_group_id%TYPE;
2503: l_exists varchar2(1);
2504: l_last_standard_process_date
2505: per_periods_of_service.last_standard_process_date%TYPE;
2506: l_actual_termination_date
2507: per_periods_of_service.actual_termination_date%TYPE;
2508: l_legislation_code per_business_groups.legislation_code%TYPE;
2509: l_payroll_id per_all_assignments_f.payroll_id%TYPE;

Line 2706: -- Derive the last standard process date.

2702: if g_debug then
2703: hr_utility.set_location(l_proc, 110);
2704: end if;
2705: --
2706: -- Derive the last standard process date.
2707: --
2708: -- Bug 1711085. VS. 27-MAR-01. Commented out the code associated with
2709: -- disabling last_standard_process for US legislature.
2710: --

Line 2709: -- disabling last_standard_process for US legislature.

2705: --
2706: -- Derive the last standard process date.
2707: --
2708: -- Bug 1711085. VS. 27-MAR-01. Commented out the code associated with
2709: -- disabling last_standard_process for US legislature.
2710: --
2711: -- if l_legislation_code = 'US'
2712: -- then
2713: --

Line 2718: -- l_last_standard_process_date := l_actual_termination_date;

2714: if g_debug then
2715: hr_utility.set_location(l_proc, 120);
2716: end if;
2717: --
2718: -- l_last_standard_process_date := l_actual_termination_date;
2719: -- else
2720: --
2721: if g_debug then
2722: hr_utility.set_location(l_proc, 130);

Line 2732: -- Assignment is assigned to a payroll, so set the last standard process

2728: if g_debug then
2729: hr_utility.set_location(l_proc, 140);
2730: end if;
2731: --
2732: -- Assignment is assigned to a payroll, so set the last standard process
2733: -- to date to the payroll's period end date as of the actual termination
2734: -- date.
2735: --
2736: open csr_get_period_end_date;

Line 2738: into l_last_standard_process_date;

2734: -- date.
2735: --
2736: open csr_get_period_end_date;
2737: fetch csr_get_period_end_date
2738: into l_last_standard_process_date;
2739: --
2740: if csr_get_period_end_date%NOTFOUND then
2741: --
2742: if g_debug then

Line 2765: -- Assignment is not assigned to a payroll, so set the last standard

2761: if g_debug then
2762: hr_utility.set_location(l_proc, 170);
2763: end if;
2764: --
2765: -- Assignment is not assigned to a payroll, so set the last standard
2766: -- process date to the actual termination date.
2767: --
2768: l_last_standard_process_date := l_actual_termination_date;
2769: end if;

Line 2768: l_last_standard_process_date := l_actual_termination_date;

2764: --
2765: -- Assignment is not assigned to a payroll, so set the last standard
2766: -- process date to the actual termination date.
2767: --
2768: l_last_standard_process_date := l_actual_termination_date;
2769: end if;
2770: -- end if;
2771: --
2772: if g_debug then

Line 2783: ,p_last_standard_process_date => l_last_standard_process_date

2779: hr_assignment_internal.actual_term_emp_asg_sup
2780: (p_assignment_id => p_assignment_id
2781: ,p_object_version_number => l_object_version_number
2782: ,p_actual_termination_date => l_actual_termination_date
2783: ,p_last_standard_process_date => l_last_standard_process_date
2784: ,p_assignment_status_type_id => l_assignment_status_type_id
2785: ,p_effective_start_date => l_effective_start_date
2786: ,p_effective_end_date => l_effective_end_date
2787: ,p_asg_future_changes_warning => l_asg_future_changes_warning

Line 12768: -- Maintain standard element entries for this assignment.

12764: end if;
12765: end if;
12766: */
12767: --
12768: -- Maintain standard element entries for this assignment.
12769: --
12770: -- Payroll functionality is not included in the 1st phase
12771: -- of non payrolled worker. As a result this code has been commented
12772: -- out, but left in as it is likely to form part of a later phase

Line 12803: ,p_last_standard_date => null

12799: ,p_new_payroll_id => l_new_payroll_id
12800: ,p_business_group_id => l_business_group_id
12801: ,p_operation => 'ASG_CRITERIA'
12802: ,p_actual_term_date => null
12803: ,p_last_standard_date => null
12804: ,p_final_process_date => null
12805: ,p_dt_mode => p_datetrack_update_mode
12806: ,p_validation_start_date => l_validation_start_date
12807: ,p_validation_end_date => l_validation_end_date

Line 16148: -- Maintain standard element entries for this assignment.

16144: -- end of fix for bug 4464072
16145: --
16146: -- Bug 560185 fix ends
16147: --
16148: -- Maintain standard element entries for this assignment.
16149: --
16150: -- Bug 638026 fix starts
16151: --
16152: if p_payroll_id = hr_api.g_number

Line 16183: ,p_last_standard_date => null

16179: ,p_new_payroll_id => l_new_payroll_id
16180: ,p_business_group_id => l_business_group_id
16181: ,p_operation => 'ASG_CRITERIA'
16182: ,p_actual_term_date => null
16183: ,p_last_standard_date => null
16184: ,p_final_process_date => null
16185: ,p_dt_mode => l_new_dt_update_mode
16186: ,p_validation_start_date => l_validation_start_date
16187: ,p_validation_end_date => l_validation_end_date