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

Line 104: select max(fnd_date.canonical_to_date(org_information4)) max_end_date

100: --
101: l_proc varchar2(72) := g_package||'chk_cost_center_gap';
102: --
103: cursor c1 is
104: select max(fnd_date.canonical_to_date(org_information4)) max_end_date
105: from hr_organization_information
106: where organization_id = p_organization_id
107: and org_information_context = 'Organization Name Alias'
108: and org_information_id <> nvl(p_org_information_id,-1)

Line 109: and fnd_date.canonical_to_date(org_information4) < p_start_date;

105: from hr_organization_information
106: where organization_id = p_organization_id
107: and org_information_context = 'Organization Name Alias'
108: and org_information_id <> nvl(p_org_information_id,-1)
109: and fnd_date.canonical_to_date(org_information4) < p_start_date;
110: --
111: cursor c2 is
112: select min(fnd_date.canonical_to_date(org_information3)) min_start_date
113: from hr_organization_information

Line 112: select min(fnd_date.canonical_to_date(org_information3)) min_start_date

108: and org_information_id <> nvl(p_org_information_id,-1)
109: and fnd_date.canonical_to_date(org_information4) < p_start_date;
110: --
111: cursor c2 is
112: select min(fnd_date.canonical_to_date(org_information3)) min_start_date
113: from hr_organization_information
114: where organization_id = p_organization_id
115: and org_information_context = 'Organization Name Alias'
116: and org_information_id <> nvl(p_org_information_id,-1)

Line 117: and fnd_date.canonical_to_date(org_information3)

113: from hr_organization_information
114: where organization_id = p_organization_id
115: and org_information_context = 'Organization Name Alias'
116: and org_information_id <> nvl(p_org_information_id,-1)
117: and fnd_date.canonical_to_date(org_information3)
118: > nvl(p_end_date,hr_api.g_eot);
119: --
120: l_c2 c2%rowtype;
121: l_c1 c1%rowtype;

Line 271: l_start_date := fnd_date.canonical_to_date(p_org_information3);

267: --
268: -- Since we are checking the format prior to flex we need to make sure
269: -- its all good and valid.
270: --
271: l_start_date := fnd_date.canonical_to_date(p_org_information3);
272: --
273: exception
274: --
275: when others then

Line 289: l_end_date := fnd_date.canonical_to_date(p_org_information4);

285: --
286: -- Since we are checking the format prior to flex we need to make sure
287: -- its all good and valid.
288: --
289: l_end_date := fnd_date.canonical_to_date(p_org_information4);
290: --
291: exception
292: --
293: when others then

Line 428: l_start_date := fnd_date.canonical_to_date(p_org_information3);

424: --
425: -- Since we are checking the format prior to flex we need to make sure
426: -- its all good and valid.
427: --
428: l_start_date := fnd_date.canonical_to_date(p_org_information3);
429: --
430: exception
431: --
432: when others then

Line 458: l_end_date := fnd_date.canonical_to_date(p_org_information4);

454: --
455: -- Since we are checking the format prior to flex we need to make sure
456: -- its all good and valid.
457: --
458: l_end_date := fnd_date.canonical_to_date(p_org_information4);
459: --
460: exception
461: --
462: when others then

Line 673: between fnd_date.canonical_to_date(org_information3)

669: from hr_organization_information
670: where organization_id = p_organization_id
671: and org_information_context = 'Organization Name Alias'
672: and (l_start_date
673: between fnd_date.canonical_to_date(org_information3)
674: and nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot)
675: or
676: nvl(l_end_date,hr_api.g_eot)
677: between fnd_date.canonical_to_date(org_information3)

Line 674: and nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot)

670: where organization_id = p_organization_id
671: and org_information_context = 'Organization Name Alias'
672: and (l_start_date
673: between fnd_date.canonical_to_date(org_information3)
674: and nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot)
675: or
676: nvl(l_end_date,hr_api.g_eot)
677: between fnd_date.canonical_to_date(org_information3)
678: and nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot)

Line 677: between fnd_date.canonical_to_date(org_information3)

673: between fnd_date.canonical_to_date(org_information3)
674: and nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot)
675: or
676: nvl(l_end_date,hr_api.g_eot)
677: between fnd_date.canonical_to_date(org_information3)
678: and nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot)
679: or fnd_date.canonical_to_date(org_information3)
680: between l_start_date
681: and nvl(l_end_date,hr_api.g_eot)

Line 678: and nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot)

674: and nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot)
675: or
676: nvl(l_end_date,hr_api.g_eot)
677: between fnd_date.canonical_to_date(org_information3)
678: and nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot)
679: or fnd_date.canonical_to_date(org_information3)
680: between l_start_date
681: and nvl(l_end_date,hr_api.g_eot)
682: or nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot)

Line 679: or fnd_date.canonical_to_date(org_information3)

675: or
676: nvl(l_end_date,hr_api.g_eot)
677: between fnd_date.canonical_to_date(org_information3)
678: and nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot)
679: or fnd_date.canonical_to_date(org_information3)
680: between l_start_date
681: and nvl(l_end_date,hr_api.g_eot)
682: or nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot)
683: between l_start_date

Line 682: or nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot)

678: and nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot)
679: or fnd_date.canonical_to_date(org_information3)
680: between l_start_date
681: and nvl(l_end_date,hr_api.g_eot)
682: or nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot)
683: between l_start_date
684: and nvl(l_end_date,hr_api.g_eot))
685: and org_information_id <> nvl(p_org_information_id,-1)
686: and org_information3 is not null;

Line 731: l_start_date := fnd_date.canonical_to_date(p_org_information3);

727: --
728: -- Since we are checking the format prior to flex we need to make sure
729: -- its all good and valid.
730: --
731: l_start_date := fnd_date.canonical_to_date(p_org_information3);
732: --
733: exception
734: --
735: when others then

Line 749: l_end_date := fnd_date.canonical_to_date(p_org_information4);

745: --
746: -- Since we are checking the format prior to flex we need to make sure
747: -- its all good and valid.
748: --
749: l_end_date := fnd_date.canonical_to_date(p_org_information4);
750: --
751: exception
752: --
753: when others then

Line 2224: if(fnd_date.canonical_to_date(p_rec.org_information4) > fnd_date.date_to_canonical(l_enddate)) then

2220: fetch c_date into l_startdate,l_enddate;
2221: hr_utility.set_location('Start:'||l_startdate||' Enddate :'||l_enddate,555);
2222: if c_date%notfound then
2223: close c_date;
2224: if(fnd_date.canonical_to_date(p_rec.org_information4) > fnd_date.date_to_canonical(l_enddate)) then
2225:
2226: hr_ori_bus.chk_ddf(p_rec);
2227: --
2228: end if;