APPS.PER_WPM_SUMMARY_PKG dependencies on FND_DATE

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

49: l_effective_date DATE;
50: l_proc VARCHAR2 (80) := g_package || 'main';
51: BEGIN
52: hr_utility.set_location ('Entering : ' || l_proc, 10);
53: l_effective_date := fnd_date.canonical_to_date (p_effective_date);
54: populate_plan_hierarchy (p_plan_id => p_plan_id, p_effective_date => l_effective_date);
55: hr_utility.set_location ('Leaving : ' || l_proc, 10);
56: EXCEPTION
57: WHEN OTHERS

Line 501: l_effective_date VARCHAR2 (30) := fnd_date.date_to_canonical (TRUNC (SYSDATE));

497: )
498: IS
499: --
500: l_request_id NUMBER;
501: l_effective_date VARCHAR2 (30) := fnd_date.date_to_canonical (TRUNC (SYSDATE));
502: --
503: BEGIN
504: -- Submit the request
505: l_request_id :=

Line 540: NVL (fnd_date.canonical_to_date (p_effective_date), TRUNC (SYSDATE));

536: l_effective_date DATE;
537: BEGIN
538: hr_utility.set_location ('Entering:' || l_proc, 10);
539: l_effective_date :=
540: NVL (fnd_date.canonical_to_date (p_effective_date), TRUNC (SYSDATE));
541: populate_appraisal_summary (p_plan_id => p_plan_id,
542: p_appraisal_period_id => p_appraisal_period_id,
543: p_effective_date => l_effective_date
544: );

Line 1218: fnd_date.date_to_canonical (SYSDATE),

1214: VALUES (per_wpm_appraisal_summary_s.NEXTVAL,
1215: p_plan_id,
1216: g_appr_period_rec.appraisal_period_id,
1217: -1,
1218: fnd_date.date_to_canonical (SYSDATE),
1219: fnd_global.conc_request_id
1220: );
1221:
1222: --

Line 1235: SELECT NVL (fnd_date.canonical_to_date (supervisor_name), SYSDATE)

1231: RETURN DATE
1232: IS
1233: CURSOR csr_get_date (p_plan_id NUMBER, p_period_id NUMBER)
1234: IS
1235: SELECT NVL (fnd_date.canonical_to_date (supervisor_name), SYSDATE)
1236: -- supervisor_name is used to store the run date with id as -1.
1237: FROM per_wpm_appraisal_summary
1238: WHERE plan_id = p_plan_id AND appraisal_period_id = p_period_id
1239: AND supervisor_person_id = -1;