eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_ASSIGNMENT_API dependencies on STANDARD

Line 2155: l_last_standard_process_date

2151: per_all_assignments_f.assignment_status_type_id%TYPE;
2152: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
2153: l_asg_business_group_id per_all_assignments_f.business_group_id%TYPE;
2154: l_exists varchar2(1);
2155: l_last_standard_process_date
2156: per_periods_of_service.last_standard_process_date%TYPE;
2157: l_actual_termination_date
2158: per_periods_of_service.actual_termination_date%TYPE;
2159: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 2156: per_periods_of_service.last_standard_process_date%TYPE;

2152: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
2153: l_asg_business_group_id per_all_assignments_f.business_group_id%TYPE;
2154: l_exists varchar2(1);
2155: l_last_standard_process_date
2156: per_periods_of_service.last_standard_process_date%TYPE;
2157: l_actual_termination_date
2158: per_periods_of_service.actual_termination_date%TYPE;
2159: l_legislation_code per_business_groups.legislation_code%TYPE;
2160: l_payroll_id per_all_assignments_f.payroll_id%TYPE;

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

2353: if g_debug then
2354: hr_utility.set_location(l_proc, 110);
2355: end if;
2356: --
2357: -- Derive the last standard process date.
2358: --
2359: -- Bug 1711085. VS. 27-MAR-01. Commented out the code associated with
2360: -- disabling last_standard_process for US legislature.
2361: --

Line 2360: -- disabling last_standard_process for US legislature.

2356: --
2357: -- Derive the last standard process date.
2358: --
2359: -- Bug 1711085. VS. 27-MAR-01. Commented out the code associated with
2360: -- disabling last_standard_process for US legislature.
2361: --
2362: -- if l_legislation_code = 'US'
2363: -- then
2364: --

Line 2369: -- l_last_standard_process_date := l_actual_termination_date;

2365: if g_debug then
2366: hr_utility.set_location(l_proc, 120);
2367: end if;
2368: --
2369: -- l_last_standard_process_date := l_actual_termination_date;
2370: -- else
2371: --
2372: if g_debug then
2373: hr_utility.set_location(l_proc, 130);

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

2379: if g_debug then
2380: hr_utility.set_location(l_proc, 140);
2381: end if;
2382: --
2383: -- Assignment is assigned to a payroll, so set the last standard process
2384: -- to date to the payroll's period end date as of the actual termination
2385: -- date.
2386: --
2387: open csr_get_period_end_date;

Line 2389: into l_last_standard_process_date;

2385: -- date.
2386: --
2387: open csr_get_period_end_date;
2388: fetch csr_get_period_end_date
2389: into l_last_standard_process_date;
2390: --
2391: if csr_get_period_end_date%NOTFOUND then
2392: --
2393: if g_debug then

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

2412: if g_debug then
2413: hr_utility.set_location(l_proc, 170);
2414: end if;
2415: --
2416: -- Assignment is not assigned to a payroll, so set the last standard
2417: -- process date to the actual termination date.
2418: --
2419: l_last_standard_process_date := l_actual_termination_date;
2420: end if;

Line 2419: l_last_standard_process_date := l_actual_termination_date;

2415: --
2416: -- Assignment is not assigned to a payroll, so set the last standard
2417: -- process date to the actual termination date.
2418: --
2419: l_last_standard_process_date := l_actual_termination_date;
2420: end if;
2421: -- end if;
2422: --
2423: if g_debug then

Line 2435: ,p_last_standard_process_date => l_last_standard_process_date

2431: hr_assignment_internal.actual_term_cwk_asg
2432: (p_assignment_id => p_assignment_id
2433: ,p_object_version_number => l_object_version_number
2434: ,p_actual_termination_date => l_actual_termination_date
2435: ,p_last_standard_process_date => l_last_standard_process_date
2436: ,p_assignment_status_type_id => l_assignment_status_type_id
2437: ,p_effective_start_date => l_effective_start_date
2438: ,p_effective_end_date => l_effective_end_date
2439: ,p_asg_future_changes_warning => l_asg_future_changes_warning

Line 3071: l_last_standard_process_date

3067: per_all_assignments_f.assignment_status_type_id%TYPE;
3068: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
3069: l_asg_business_group_id per_all_assignments_f.business_group_id%TYPE;
3070: l_exists varchar2(1);
3071: l_last_standard_process_date
3072: per_periods_of_service.last_standard_process_date%TYPE;
3073: l_actual_termination_date
3074: per_periods_of_service.actual_termination_date%TYPE;
3075: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 3072: per_periods_of_service.last_standard_process_date%TYPE;

3068: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
3069: l_asg_business_group_id per_all_assignments_f.business_group_id%TYPE;
3070: l_exists varchar2(1);
3071: l_last_standard_process_date
3072: per_periods_of_service.last_standard_process_date%TYPE;
3073: l_actual_termination_date
3074: per_periods_of_service.actual_termination_date%TYPE;
3075: l_legislation_code per_business_groups.legislation_code%TYPE;
3076: l_payroll_id per_all_assignments_f.payroll_id%TYPE;

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

3269: if g_debug then
3270: hr_utility.set_location(l_proc, 110);
3271: end if;
3272: --
3273: -- Derive the last standard process date.
3274: --
3275: -- Bug 1711085. VS. 27-MAR-01. Commented out the code associated with
3276: -- disabling last_standard_process for US legislature.
3277: --

Line 3276: -- disabling last_standard_process for US legislature.

3272: --
3273: -- Derive the last standard process date.
3274: --
3275: -- Bug 1711085. VS. 27-MAR-01. Commented out the code associated with
3276: -- disabling last_standard_process for US legislature.
3277: --
3278: -- if l_legislation_code = 'US'
3279: -- then
3280: --

Line 3285: -- l_last_standard_process_date := l_actual_termination_date;

3281: if g_debug then
3282: hr_utility.set_location(l_proc, 120);
3283: end if;
3284: --
3285: -- l_last_standard_process_date := l_actual_termination_date;
3286: -- else
3287: --
3288: if g_debug then
3289: hr_utility.set_location(l_proc, 130);

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

3295: if g_debug then
3296: hr_utility.set_location(l_proc, 140);
3297: end if;
3298: --
3299: -- Assignment is assigned to a payroll, so set the last standard process
3300: -- to date to the payroll's period end date as of the actual termination
3301: -- date.
3302: --
3303: open csr_get_period_end_date;

Line 3305: into l_last_standard_process_date;

3301: -- date.
3302: --
3303: open csr_get_period_end_date;
3304: fetch csr_get_period_end_date
3305: into l_last_standard_process_date;
3306: --
3307: if csr_get_period_end_date%NOTFOUND then
3308: --
3309: if g_debug then

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

3328: if g_debug then
3329: hr_utility.set_location(l_proc, 170);
3330: end if;
3331: --
3332: -- Assignment is not assigned to a payroll, so set the last standard
3333: -- process date to the actual termination date.
3334: --
3335: l_last_standard_process_date := l_actual_termination_date;
3336: end if;

Line 3335: l_last_standard_process_date := l_actual_termination_date;

3331: --
3332: -- Assignment is not assigned to a payroll, so set the last standard
3333: -- process date to the actual termination date.
3334: --
3335: l_last_standard_process_date := l_actual_termination_date;
3336: end if;
3337: -- end if;
3338: --
3339: if g_debug then

Line 3350: ,p_last_standard_process_date => l_last_standard_process_date

3346: hr_assignment_internal.actual_term_emp_asg_sup
3347: (p_assignment_id => p_assignment_id
3348: ,p_object_version_number => l_object_version_number
3349: ,p_actual_termination_date => l_actual_termination_date
3350: ,p_last_standard_process_date => l_last_standard_process_date
3351: ,p_assignment_status_type_id => l_assignment_status_type_id
3352: ,p_effective_start_date => l_effective_start_date
3353: ,p_effective_end_date => l_effective_end_date
3354: ,p_asg_future_changes_warning => l_asg_future_changes_warning

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

13365: end if;
13366: end if;
13367: */
13368: --
13369: -- Maintain standard element entries for this assignment.
13370: --
13371: -- Payroll functionality is not included in the 1st phase
13372: -- of non payrolled worker. As a result this code has been commented
13373: -- out, but left in as it is likely to form part of a later phase

Line 13404: ,p_last_standard_date => null

13400: ,p_new_payroll_id => l_new_payroll_id
13401: ,p_business_group_id => l_business_group_id
13402: ,p_operation => 'ASG_CRITERIA'
13403: ,p_actual_term_date => null
13404: ,p_last_standard_date => null
13405: ,p_final_process_date => null
13406: ,p_dt_mode => p_datetrack_update_mode
13407: ,p_validation_start_date => l_validation_start_date
13408: ,p_validation_end_date => l_validation_end_date

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

16961: -- end of fix for bug 4464072
16962: --
16963: -- Bug 560185 fix ends
16964: --
16965: -- Maintain standard element entries for this assignment.
16966: --
16967: -- Bug 638026 fix starts
16968: --
16969: if p_payroll_id = hr_api.g_number

Line 17008: ,p_last_standard_date => null

17004: ,p_new_payroll_id => l_new_payroll_id
17005: ,p_business_group_id => l_business_group_id
17006: ,p_operation => 'ASG_CRITERIA'
17007: ,p_actual_term_date => null
17008: ,p_last_standard_date => null
17009: ,p_final_process_date => null
17010: ,p_dt_mode => l_new_dt_update_mode
17011: ,p_validation_start_date => l_validation_start_date
17012: ,p_validation_end_date => l_validation_end_date