APPS.HR_WPM_MASS_APR_PUSH dependencies on FND_DATE

Line 1398: l_effective_date varchar2(30) := fnd_date.date_to_canonical(nvl(p_effective_date,trunc(sysdate)));

1394: l_object_version_number number ;
1395: l_status_code per_perf_mgmt_plans.status_code%TYPE;
1396: l_dummy boolean;
1397: l_request_id number;
1398: l_effective_date varchar2(30) := fnd_date.date_to_canonical(nvl(p_effective_date,trunc(sysdate)));
1399:
1400: --
1401: begin
1402: -- Submit the request

Line 1441: l_effective_date date := fnd_date.canonical_to_date(nvl(p_effective_date,trunc(sysdate)));

1437: from per_perf_mgmt_plans
1438: where plan_id = p_plan_id;
1439:
1440: l_object_version_number number;
1441: l_effective_date date := fnd_date.canonical_to_date(nvl(p_effective_date,trunc(sysdate)));
1442: CURSOR csr_pend_trans(p_plan_id IN NUMBER) IS
1443: SELECT 'x'
1444: FROM DUAL
1445: WHERE EXISTS (SELECT 'x'