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.PER_WPM_SUMMARY_PKG dependencies on FND_DATE

Line 36: l_effective_date := fnd_date.canonical_to_date(p_effective_date);

32: l_effective_date DATE;
33: l_proc VARCHAR2(80) := g_package||'main';
34: BEGIN
35: hr_utility.set_location('Entering : '||l_proc,10);
36: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
37: populate_plan_hierarchy(p_plan_id => p_plan_id
38: ,p_effective_date => l_effective_date);
39: hr_utility.set_location('Leaving : '||l_proc,10);
40: EXCEPTION

Line 370: l_effective_date varchar2(30) := fnd_date.date_to_canonical(trunc(sysdate));

366: is
367: --
368:
369: l_request_id number ;
370: l_effective_date varchar2(30) := fnd_date.date_to_canonical(trunc(sysdate));
371:
372: --
373: begin
374: -- Submit the request

Line 406: l_effective_date := NVL(fnd_date.canonical_to_date(p_effective_date),TRUNC(SYSDATE));

402: l_proc VARCHAR2(80) := g_package||'populate_appraisal_summary_cp';
403: l_effective_date DATE;
404: BEGIN
405: hr_utility.set_location('Entering:'||l_proc,10);
406: l_effective_date := NVL(fnd_date.canonical_to_date(p_effective_date),TRUNC(SYSDATE));
407: populate_appraisal_summary(p_plan_id => p_plan_id
408: ,p_appraisal_period_id => p_appraisal_period_id
409: ,p_effective_date => l_effective_date);
410: hr_utility.set_location('Leaving:'||l_proc,100);

Line 811: ,fnd_date.date_to_canonical(sysdate)

807: (PER_WPM_APPRAISAL_SUMMARY_S.nextval
808: ,p_plan_id
809: ,g_appr_period_rec.appraisal_period_id
810: ,-1
811: ,fnd_date.date_to_canonical(sysdate)
812: ,fnd_global.conc_request_id);
813: --
814: COMMIT;
815: --

Line 824: SELECT NVL(fnd_date.canonical_to_date(supervisor_name),SYSDATE) -- supervisor_name is used to store the run date with id as -1.

820: FUNCTION get_summary_date(p_plan_id IN NUMBER
821: ,p_appraisal_period_id IN NUMBER) RETURN DATE IS
822: CURSOR csr_get_date(p_plan_id NUMBER
823: ,p_period_id NUMBER) IS
824: SELECT NVL(fnd_date.canonical_to_date(supervisor_name),SYSDATE) -- supervisor_name is used to store the run date with id as -1.
825: FROM per_wpm_appraisal_summary
826: WHERE plan_id = p_plan_id
827: AND appraisal_period_id = p_period_id
828: AND supervisor_person_id = -1;