DBA Data[Home] [Help]

APPS.PQH_BUDGET_ANALYSIS_PKG dependencies on FND_DATE

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

186: end if;
187: --
188: hr_utility.set_location('Entering'|| l_proc_name, 13);
189: --
190: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
191: l_start_date := fnd_date.canonical_to_date(p_start_date);
192: l_end_date := fnd_date.canonical_to_date(p_end_date);
193: --
194: -- Fetch the Organization Structure Version

Line 191: l_start_date := fnd_date.canonical_to_date(p_start_date);

187: --
188: hr_utility.set_location('Entering'|| l_proc_name, 13);
189: --
190: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
191: l_start_date := fnd_date.canonical_to_date(p_start_date);
192: l_end_date := fnd_date.canonical_to_date(p_end_date);
193: --
194: -- Fetch the Organization Structure Version
195: --

Line 192: l_end_date := fnd_date.canonical_to_date(p_end_date);

188: hr_utility.set_location('Entering'|| l_proc_name, 13);
189: --
190: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
191: l_start_date := fnd_date.canonical_to_date(p_start_date);
192: l_end_date := fnd_date.canonical_to_date(p_end_date);
193: --
194: -- Fetch the Organization Structure Version
195: --
196: open c_org_version(l_effective_date);

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

1469: end if;
1470: --
1471: hr_utility.set_location('Entering'|| l_proc_name, 13);
1472: --
1473: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
1474: l_start_date := fnd_date.canonical_to_date(p_start_date);
1475: l_end_date := fnd_date.canonical_to_date(p_end_date);
1476: --
1477: -- Fetch the Organization Structure Version

Line 1474: l_start_date := fnd_date.canonical_to_date(p_start_date);

1470: --
1471: hr_utility.set_location('Entering'|| l_proc_name, 13);
1472: --
1473: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
1474: l_start_date := fnd_date.canonical_to_date(p_start_date);
1475: l_end_date := fnd_date.canonical_to_date(p_end_date);
1476: --
1477: -- Fetch the Organization Structure Version
1478: --

Line 1475: l_end_date := fnd_date.canonical_to_date(p_end_date);

1471: hr_utility.set_location('Entering'|| l_proc_name, 13);
1472: --
1473: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
1474: l_start_date := fnd_date.canonical_to_date(p_start_date);
1475: l_end_date := fnd_date.canonical_to_date(p_end_date);
1476: --
1477: -- Fetch the Organization Structure Version
1478: --
1479: open c_org_version(l_effective_date);

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

1700: end if;
1701: --
1702: hr_utility.set_location('Entering'|| l_proc_name, 13);
1703: --
1704: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
1705: l_start_date := fnd_date.canonical_to_date(p_start_date);
1706: l_end_date := fnd_date.canonical_to_date(p_end_date);
1707: --
1708: -- Fetch the batch Id into the l_batch_id

Line 1705: l_start_date := fnd_date.canonical_to_date(p_start_date);

1701: --
1702: hr_utility.set_location('Entering'|| l_proc_name, 13);
1703: --
1704: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
1705: l_start_date := fnd_date.canonical_to_date(p_start_date);
1706: l_end_date := fnd_date.canonical_to_date(p_end_date);
1707: --
1708: -- Fetch the batch Id into the l_batch_id
1709: --

Line 1706: l_end_date := fnd_date.canonical_to_date(p_end_date);

1702: hr_utility.set_location('Entering'|| l_proc_name, 13);
1703: --
1704: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
1705: l_start_date := fnd_date.canonical_to_date(p_start_date);
1706: l_end_date := fnd_date.canonical_to_date(p_end_date);
1707: --
1708: -- Fetch the batch Id into the l_batch_id
1709: --
1710: open c_batch;

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

2309: end if;
2310: --
2311: hr_utility.set_location('Entering'|| l_proc_name, 13);
2312: --
2313: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
2314: l_start_date := fnd_date.canonical_to_date(p_start_date);
2315: l_end_date := fnd_date.canonical_to_date(p_end_date);
2316: --
2317: -- Fetch the batch Id into the l_batch_id

Line 2314: l_start_date := fnd_date.canonical_to_date(p_start_date);

2310: --
2311: hr_utility.set_location('Entering'|| l_proc_name, 13);
2312: --
2313: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
2314: l_start_date := fnd_date.canonical_to_date(p_start_date);
2315: l_end_date := fnd_date.canonical_to_date(p_end_date);
2316: --
2317: -- Fetch the batch Id into the l_batch_id
2318: --

Line 2315: l_end_date := fnd_date.canonical_to_date(p_end_date);

2311: hr_utility.set_location('Entering'|| l_proc_name, 13);
2312: --
2313: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
2314: l_start_date := fnd_date.canonical_to_date(p_start_date);
2315: l_end_date := fnd_date.canonical_to_date(p_end_date);
2316: --
2317: -- Fetch the batch Id into the l_batch_id
2318: --
2319: open c_batch;

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

3390: end if;
3391: --
3392: hr_utility.set_location('Entering'|| l_proc_name, 13);
3393: --
3394: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
3395: l_start_date := fnd_date.canonical_to_date(p_start_date);
3396: l_end_date := fnd_date.canonical_to_date(p_end_date);
3397: --
3398: -- Fetch the Organization Structure Version

Line 3395: l_start_date := fnd_date.canonical_to_date(p_start_date);

3391: --
3392: hr_utility.set_location('Entering'|| l_proc_name, 13);
3393: --
3394: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
3395: l_start_date := fnd_date.canonical_to_date(p_start_date);
3396: l_end_date := fnd_date.canonical_to_date(p_end_date);
3397: --
3398: -- Fetch the Organization Structure Version
3399: --

Line 3396: l_end_date := fnd_date.canonical_to_date(p_end_date);

3392: hr_utility.set_location('Entering'|| l_proc_name, 13);
3393: --
3394: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
3395: l_start_date := fnd_date.canonical_to_date(p_start_date);
3396: l_end_date := fnd_date.canonical_to_date(p_end_date);
3397: --
3398: -- Fetch the Organization Structure Version
3399: --
3400: open c_org_version(l_effective_date);