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_CONTINGENT_WORKER_API dependencies on STANDARD

Line 1673: ,p_last_standard_process_date in out nocopy date

1669: ,p_person_id in number
1670: ,p_date_start in date
1671: ,p_object_version_number in out nocopy number
1672: ,p_actual_termination_date in date
1673: ,p_last_standard_process_date in out nocopy date
1674: ,p_person_type_id in number default hr_api.g_number
1675: ,p_assignment_status_type_id in number default hr_api.g_number
1676: ,p_termination_reason in varchar2 default hr_api.g_varchar2
1677: ,p_supervisor_warning out nocopy boolean

Line 1696: l_last_standard_process_date date;

1692: l_asg_future_changes_warning boolean := FALSE;
1693: l_entries_changed_warning varchar2(1) := 'N';
1694: l_event_warning boolean := FALSE;
1695: l_interview_warning boolean := FALSE;
1696: l_last_standard_process_date date;
1697: l_pdp_object_version_number number;
1698: l_recruiter_warning boolean := FALSE;
1699: l_review_warning boolean := FALSE;
1700: l_supervisor_warning boolean := FALSE;

Line 1811: l_last_standard_process_date := trunc(p_last_standard_process_date);

1807: -- Initialise local variables
1808: --
1809: l_person_type_id := p_person_type_id;
1810: l_assignment_status_type_id := p_assignment_status_type_id;
1811: l_last_standard_process_date := trunc(p_last_standard_process_date);
1812: l_pdp_object_version_number := p_object_version_number;
1813: l_actual_termination_date := trunc(p_actual_termination_date);
1814: l_effective_date := trunc(p_effective_date);
1815: l_date_start := trunc(p_date_start);

Line 1947: -- Validate/derive the last standard process date.

1943: */
1944: --
1945: hr_utility.set_location(l_proc, 100);
1946: --
1947: -- Validate/derive the last standard process date.
1948: --
1949: --
1950: hr_utility.set_location(l_proc, 130);
1951: --

Line 1952: if l_last_standard_process_date is not null

1948: --
1949: --
1950: hr_utility.set_location(l_proc, 130);
1951: --
1952: if l_last_standard_process_date is not null
1953: then
1954: --
1955: hr_utility.set_location(l_proc, 140);
1956: --

Line 1957: -- Check that the last standard process date is on or after the actual

1953: then
1954: --
1955: hr_utility.set_location(l_proc, 140);
1956: --
1957: -- Check that the last standard process date is on or after the actual
1958: -- termination date.
1959: --
1960: if not l_last_standard_process_date >= l_actual_termination_date
1961: then

Line 1960: if not l_last_standard_process_date >= l_actual_termination_date

1956: --
1957: -- Check that the last standard process date is on or after the actual
1958: -- termination date.
1959: --
1960: if not l_last_standard_process_date >= l_actual_termination_date
1961: then
1962: --
1963: hr_utility.set_location(l_proc, 150);
1964: --

Line 1972: -- Last standard process date is null => derive it.

1968: else
1969: --
1970: hr_utility.set_location(l_proc, 160);
1971: --
1972: -- Last standard process date is null => derive it.
1973: --
1974: -- Find the max tpe end date of any payrolls that are assigned.
1975: --
1976: open csr_get_max_tpe_end_date;

Line 2005: -- A time period end date has been found, so set the last standard

2001: then
2002: --
2003: hr_utility.set_location(l_proc, 190);
2004: --
2005: -- A time period end date has been found, so set the last standard
2006: -- process date to that.
2007: --
2008: l_last_standard_process_date := l_max_tpe_end_date;
2009: else

Line 2008: l_last_standard_process_date := l_max_tpe_end_date;

2004: --
2005: -- A time period end date has been found, so set the last standard
2006: -- process date to that.
2007: --
2008: l_last_standard_process_date := l_max_tpe_end_date;
2009: else
2010: --
2011: hr_utility.set_location(l_proc, 200);
2012: --

Line 2018: l_last_standard_process_date := l_actual_termination_date;

2014: -- there was no time period for that payroll as of the actual
2015: -- termination date. It doesn't matter which as we will default
2016: -- the LSPD to the ATD.
2017: --
2018: l_last_standard_process_date := l_actual_termination_date;
2019: end if;
2020: end if;
2021: --
2022: hr_utility.set_location(l_proc, 240);

Line 2042: -- Update actual termination date and last standard process date in

2038: );
2039:
2040: hr_utility.set_location(l_proc, 245);
2041: --
2042: -- Update actual termination date and last standard process date in
2043: -- periods of placement table.
2044:
2045: per_pdp_upd.upd
2046: (p_effective_date => p_actual_termination_date + 1

Line 2051: ,p_last_standard_process_date => l_last_standard_process_date

2047: ,p_object_version_number => l_pdp_object_version_number
2048: ,p_person_id => l_person_id
2049: ,p_date_start => l_date_start
2050: ,p_actual_termination_date => l_actual_termination_date
2051: ,p_last_standard_process_date => l_last_standard_process_date
2052: ,p_termination_reason => p_termination_reason);
2053:
2054: --
2055: if p_termination_reason = 'D' then

Line 2114: ,p_last_standard_process_date => l_last_standard_process_date

2110: hr_assignment_internal.actual_term_cwk_asg
2111: (p_assignment_id => csr_rec.assignment_id
2112: ,p_object_version_number => csr_rec.object_version_number
2113: ,p_actual_termination_date => l_actual_termination_date
2114: ,p_last_standard_process_date => l_last_standard_process_date
2115: ,p_assignment_status_type_id => l_assignment_status_type_id
2116: ,p_effective_start_date => l_effective_start_date
2117: ,p_effective_end_date => l_effective_end_date
2118: ,p_asg_future_changes_warning => l_cr_asg_future_changes_warn

Line 2248: p_last_standard_process_date := l_last_standard_process_date;

2244: p_asg_future_changes_warning := l_asg_future_changes_warning;
2245: p_entries_changed_warning := l_entries_changed_warning;
2246: p_pay_proposal_warning := l_pay_proposal_warn;
2247: p_dod_warning := l_dod_warning;
2248: p_last_standard_process_date := l_last_standard_process_date;
2249: p_object_version_number := l_pdp_object_version_number;
2250: --
2251: --
2252: hr_utility.set_location(' Leaving:'||l_proc, 340);

Line 2270: -- p_object_version_number and p_last_standard_process_date

2266: p_entries_changed_warning := l_entries_changed_warning;
2267: p_pay_proposal_warning := l_pay_proposal_warn;
2268: p_dod_warning := l_dod_warning;
2269: --
2270: -- p_object_version_number and p_last_standard_process_date
2271: -- should return their IN values, they still hold their IN values
2272: -- so do nothing here.
2273: --
2274: --

Line 2284: p_last_standard_process_date := l_last_standard_process_date;

2280: --
2281: -- set in out parameters and set out parameters
2282: --
2283: p_object_version_number := l_pdp_object_version_number;
2284: p_last_standard_process_date := l_last_standard_process_date;
2285: p_supervisor_warning := null;
2286: p_event_warning := null;
2287: p_interview_warning := null;
2288: p_review_warning := null;

Line 2333: l_last_standard_process_date date;

2329: l_cr_org_now_no_manager_warn boolean := FALSE;
2330: l_effective_end_date date;
2331: l_effective_start_date date;
2332: l_exists varchar2(1);
2333: l_last_standard_process_date date;
2334: l_legislation_code per_business_groups.legislation_code%TYPE;
2335: l_object_version_number number;
2336: l_person_id number;
2337: l_proc varchar2(72) := g_package ||

Line 2344: , pdp.last_standard_process_date

2340: --
2341: cursor csr_get_derived_details is
2342: select bus.legislation_code
2343: , pdp.actual_termination_date
2344: , pdp.last_standard_process_date
2345: , pdp.person_id
2346: , pdp.object_version_number
2347: from per_business_groups bus
2348: , per_periods_of_placement pdp

Line 2408: ,l_last_standard_process_date

2404: open csr_get_derived_details;
2405: fetch csr_get_derived_details
2406: into l_legislation_code
2407: ,l_actual_termination_date
2408: ,l_last_standard_process_date
2409: ,l_person_id
2410: ,l_object_version_number;
2411: --
2412: if csr_get_derived_details%NOTFOUND

Line 2457: -- Add one day to the last standard process date to get the

2453: -- Default the FPD to the LSPD
2454: --
2455: l_final_process_date := l_actual_termination_date;
2456: --
2457: -- Add one day to the last standard process date to get the
2458: -- validation date
2459: --
2460: -- Set the EX CWK effective date to the FPD + 1
2461: --

Line 2472: l_final_process_date := l_last_standard_process_date;

2468: then
2469: --
2470: -- Default the FPD to the LSPD
2471: --
2472: l_final_process_date := l_last_standard_process_date;
2473: --
2474: -- Add one day to the last standard process date to get the
2475: -- validation date
2476: --

Line 2474: -- Add one day to the last standard process date to get the

2470: -- Default the FPD to the LSPD
2471: --
2472: l_final_process_date := l_last_standard_process_date;
2473: --
2474: -- Add one day to the last standard process date to get the
2475: -- validation date
2476: --
2477: -- Set the EX CWK effective date to the FPD + 1
2478: --

Line 2685: ,p_last_standard_process_date in out nocopy date

2681: payroll support for contingent workers is introduced. Setting them has
2682: no impact.
2683: */
2684: ,p_final_process_date in out nocopy date
2685: ,p_last_standard_process_date in out nocopy date
2686:
2687: ,p_termination_reason in varchar2 default hr_api.g_varchar2
2688: ,p_projected_termination_date in date default hr_api.g_date
2689: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 2809: and last standard process date to the actual

2805:
2806: hr_utility.set_location(l_proc, 15);
2807:
2808: /* For CWK Phase I we default the final process
2809: and last standard process date to the actual
2810: termination date so that assignments are immediately
2811: ended.
2812: For CWK Phase II, this defaulting will be removed
2813: so that the behaviour supports CWKs on payrolls. */

Line 2817: p_last_standard_process_date := p_actual_termination_date;

2813: so that the behaviour supports CWKs on payrolls. */
2814:
2815: -- l_final_process_date := p_final_process_date;
2816: l_final_process_date := p_actual_termination_date;
2817: p_last_standard_process_date := p_actual_termination_date;
2818:
2819: --
2820: -- Start of API User Hook for the before hook of terminate_placement
2821: --

Line 2832: ,p_last_standard_process_date => p_last_standard_process_date

2828: ,p_person_type_id => p_person_type_id
2829: ,p_assignment_status_type_id => p_assignment_status_type_id
2830: ,p_actual_termination_date => p_actual_termination_date
2831: ,p_final_process_date => l_final_process_date
2832: ,p_last_standard_process_date => p_last_standard_process_date
2833: ,p_termination_reason => p_termination_reason
2834: ,p_projected_termination_date => null
2835: ,p_attribute_category => p_attribute_category
2836: ,p_attribute1 => p_attribute1

Line 3018: ,p_last_standard_process_date => p_last_standard_process_date

3014: ,p_person_id => p_person_id
3015: ,p_date_start => p_date_start
3016: ,p_object_version_number => p_object_version_number
3017: ,p_actual_termination_date => p_actual_termination_date
3018: ,p_last_standard_process_date => p_last_standard_process_date
3019: ,p_person_type_id => p_person_type_id
3020: ,p_assignment_status_type_id => p_assignment_status_type_id
3021: ,p_termination_reason => p_termination_reason
3022: ,p_supervisor_warning => p_supervisor_warning

Line 3112: ,p_last_standard_process_date => p_last_standard_process_date

3108: ,p_person_type_id => p_person_type_id
3109: ,p_assignment_status_type_id => p_assignment_status_type_id
3110: ,p_actual_termination_date => p_actual_termination_date
3111: ,p_final_process_date => l_final_process_date
3112: ,p_last_standard_process_date => p_last_standard_process_date
3113: ,p_termination_reason => p_termination_reason
3114: ,p_projected_termination_date => null
3115: ,p_attribute_category => p_attribute_category
3116: ,p_attribute1 => p_attribute1

Line 3244: l_last_standard_process_date DATE;

3240: ) is
3241:
3242: l_proc varchar2(80) := g_package||'reverse_terminate_placement';
3243: l_final_process_date DATE;
3244: l_last_standard_process_date DATE;
3245: l_per_system_status VARCHAR2(30);
3246: l_max_end_date DATE;
3247: l_effective_end_date DATE;
3248: l_action_chk VARCHAR2(1) := 'N';

Line 3363: , pdp.last_standard_process_date

3359: --
3360: hr_utility.set_location(l_proc,25);
3361: begin
3362: SELECT pdp.final_process_date
3363: , pdp.last_standard_process_date
3364: INTO l_final_process_date
3365: , l_last_standard_process_date
3366: FROM per_periods_of_placement pdp
3367: WHERE pdp.person_id = p_person_id

Line 3365: , l_last_standard_process_date

3361: begin
3362: SELECT pdp.final_process_date
3363: , pdp.last_standard_process_date
3364: INTO l_final_process_date
3365: , l_last_standard_process_date
3366: FROM per_periods_of_placement pdp
3367: WHERE pdp.person_id = p_person_id
3368: AND pdp.actual_termination_date = p_actual_termination_date;
3369: --

Line 3404: if l_last_standard_process_date is not null then

3400:
3401: --
3402: -- Check for future completed actions.
3403: --
3404: if l_last_standard_process_date is not null then
3405:
3406: if p_actual_termination_date is not null
3407: and l_last_standard_process_date > p_actual_termination_date then
3408: l_action_date := l_last_standard_process_date;

Line 3407: and l_last_standard_process_date > p_actual_termination_date then

3403: --
3404: if l_last_standard_process_date is not null then
3405:
3406: if p_actual_termination_date is not null
3407: and l_last_standard_process_date > p_actual_termination_date then
3408: l_action_date := l_last_standard_process_date;
3409: else
3410: l_action_date := null;
3411: end if;

Line 3408: l_action_date := l_last_standard_process_date;

3404: if l_last_standard_process_date is not null then
3405:
3406: if p_actual_termination_date is not null
3407: and l_last_standard_process_date > p_actual_termination_date then
3408: l_action_date := l_last_standard_process_date;
3409: else
3410: l_action_date := null;
3411: end if;
3412:

Line 3537: , pdp.last_standard_process_date = null

3533: -- END WWBUG fix for 1390173
3534: --
3535: UPDATE per_periods_of_placement pdp
3536: SET pdp.actual_termination_date = null
3537: , pdp.last_standard_process_date = null
3538: , pdp.final_process_date = null
3539: , pdp.termination_reason = null
3540: , pdp.projected_termination_date = null
3541: WHERE pdp.person_id = p_person_id

Line 3590: , pdp.last_standard_process_date = null

3586: -- END WWBUG fix for 1390173
3587: --
3588: UPDATE per_periods_of_placement pdp
3589: SET pdp.actual_termination_date = null
3590: , pdp.last_standard_process_date = null
3591: , pdp.final_process_date = null
3592: , pdp.termination_reason = null
3593: , pdp.projected_termination_date = null
3594: WHERE pdp.person_id = p_person_id

Line 3793: ,l_last_standard_process_date

3789: hrentmnt.maintain_entries_asg(c_asg_rec.assignment_id
3790: ,c_asg_rec.business_group_id
3791: ,'CNCL_TERM'
3792: ,p_actual_termination_date
3793: ,l_last_standard_process_date
3794: ,l_final_process_date
3795: ,'DELETE_NEXT_CHANGE'
3796: ,null
3797: ,null);