DBA Data[Home] [Help]

APPS.PAY_CA_GROUP_LEVEL_BAL_PKG dependencies on FND_DATE

Line 2224: fnd_date.date_to_canonical(p_effective_date));

2220:
2221: /* hr_utility.trace_on(NULL,'ORASDR'); */
2222: hr_utility.trace('Starting routine: '||l_routine_name);
2223: pay_ca_balance_view_pkg.set_context('DATE_EARNED',
2224: fnd_date.date_to_canonical(p_effective_date));
2225:
2226: l_balance_name := p_balance_name;
2227:
2228: IF p_time_dimension <> 'PYDATE' AND

Line 2251: l_start_date := fnd_date.canonical_to_date(l_date_context);

2247: hr_utility.trace(l_routine_name||': 20');
2248: IF p_start_date IS NULL THEN
2249: l_date_context := pay_ca_balance_view_pkg.get_context('BALANCE_DATE');
2250: IF l_date_context IS NOT NULL THEN
2251: l_start_date := fnd_date.canonical_to_date(l_date_context);
2252: ELSE
2253: RAISE e_no_start_date_for_pydate;
2254: END IF;
2255: ELSE

Line 2258: fnd_date.date_to_canonical(p_start_date));

2254: END IF;
2255: ELSE
2256: l_start_date := p_start_date;
2257: pay_ca_balance_view_pkg.set_context('BALANCE_DATE',
2258: fnd_date.date_to_canonical(p_start_date));
2259: END IF;
2260: ELSIF p_time_dimension = 'PTD' THEN
2261: hr_utility.trace(l_routine_name||': 25');
2262: l_start_date := NULL;

Line 2772: fnd_date.date_to_canonical(p_effective_date));

2768: );
2769: Elsif p_flag = 'Y' then
2770: -- Process rb cursors to find assignments
2771: pay_ca_balance_view_pkg.set_context('DATE_EARNED',
2772: fnd_date.date_to_canonical(p_effective_date));
2773:
2774: l_balance_name := p_balance_name;
2775:
2776: IF p_time_dimension <> 'PYDATE' AND

Line 2799: l_start_date := fnd_date.canonical_to_date(l_date_context);

2795: hr_utility.trace(l_routine_name||': 20');
2796: IF p_start_date IS NULL THEN
2797: l_date_context := pay_ca_balance_view_pkg.get_context('BALANCE_DATE');
2798: IF l_date_context IS NOT NULL THEN
2799: l_start_date := fnd_date.canonical_to_date(l_date_context);
2800: ELSE
2801: RAISE e_no_start_date_for_pydate;
2802: END IF;
2803: ELSE

Line 2806: fnd_date.date_to_canonical(p_start_date));

2802: END IF;
2803: ELSE
2804: l_start_date := p_start_date;
2805: pay_ca_balance_view_pkg.set_context('BALANCE_DATE',
2806: fnd_date.date_to_canonical(p_start_date));
2807: END IF;
2808: ELSIF p_time_dimension = 'PTD' THEN
2809: hr_utility.trace(l_routine_name||': 25');
2810: l_start_date := NULL;