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

Line 50: AND p_effective_start_date BETWEEN fnd_date.canonical_to_date(org_information15)

46: WHERE org_information_context= 'PER_CONT_AREA_CONT_BASE_CN'
47: AND org_information1 = p_org_information1
48: AND org_information2 = p_org_information2
49: AND nvl(org_information3,'X') = nvl(p_org_information3,'X')
50: AND p_effective_start_date BETWEEN fnd_date.canonical_to_date(org_information15)
51: AND fnd_date.canonical_to_date(NVL(org_information16,'4712/12/31 00:00:00'))
52: AND organization_id = p_organization_id
53: AND (org_information_id <> p_org_information_id
54: OR p_org_information_id IS NULL);

Line 51: AND fnd_date.canonical_to_date(NVL(org_information16,'4712/12/31 00:00:00'))

47: AND org_information1 = p_org_information1
48: AND org_information2 = p_org_information2
49: AND nvl(org_information3,'X') = nvl(p_org_information3,'X')
50: AND p_effective_start_date BETWEEN fnd_date.canonical_to_date(org_information15)
51: AND fnd_date.canonical_to_date(NVL(org_information16,'4712/12/31 00:00:00'))
52: AND organization_id = p_organization_id
53: AND (org_information_id <> p_org_information_id
54: OR p_org_information_id IS NULL);
55:

Line 66: AND p_effective_start_date BETWEEN fnd_date.canonical_to_date(org_information10)

62: AND org_information1 = p_org_information1
63: AND nvl(org_information2,'X') = nvl(p_org_information2,'X')
64: AND org_information3 = p_org_information3
65: AND nvl(org_information9,'X') = nvl(p_org_information4,'X')
66: AND p_effective_start_date BETWEEN fnd_date.canonical_to_date(org_information10)
67: AND fnd_date.canonical_to_date(NVL(org_information11,'4712/12/31 00:00:00'))
68: AND organization_id = p_organization_id
69: AND (org_information_id <> p_org_information_id
70: OR p_org_information_id IS NULL) ;

Line 67: AND fnd_date.canonical_to_date(NVL(org_information11,'4712/12/31 00:00:00'))

63: AND nvl(org_information2,'X') = nvl(p_org_information2,'X')
64: AND org_information3 = p_org_information3
65: AND nvl(org_information9,'X') = nvl(p_org_information4,'X')
66: AND p_effective_start_date BETWEEN fnd_date.canonical_to_date(org_information10)
67: AND fnd_date.canonical_to_date(NVL(org_information11,'4712/12/31 00:00:00'))
68: AND organization_id = p_organization_id
69: AND (org_information_id <> p_org_information_id
70: OR p_org_information_id IS NULL) ;
71:

Line 74: SELECT min(fnd_date.canonical_to_date(org_information15))

70: OR p_org_information_id IS NULL) ;
71:
72: CURSOR csr_future_rec_cont_base
73: IS
74: SELECT min(fnd_date.canonical_to_date(org_information15))
75: FROM hr_organization_information
76: WHERE org_information1 = p_org_information1
77: AND org_information2 = p_org_information2
78: AND nvl(org_information3,'X') = nvl(p_org_information3,'X')

Line 81: AND fnd_date.canonical_to_date(org_information15) > p_effective_start_date

77: AND org_information2 = p_org_information2
78: AND nvl(org_information3,'X') = nvl(p_org_information3,'X')
79: AND org_information_context='PER_CONT_AREA_CONT_BASE_CN'
80: AND NVL(org_information_id,-1) <> NVL(p_org_information_id,-1)
81: AND fnd_date.canonical_to_date(org_information15) > p_effective_start_date
82: AND organization_id = p_organization_id
83: AND (org_information_id <> p_org_information_id
84: OR p_org_information_id IS NULL);
85:

Line 88: SELECT min(fnd_date.canonical_to_date(org_information10))

84: OR p_org_information_id IS NULL);
85:
86: CURSOR csr_future_rec_phfsi_base
87: IS
88: SELECT min(fnd_date.canonical_to_date(org_information10))
89: FROM hr_organization_information
90: WHERE org_information1 = p_org_information1
91: AND NVL(org_information2,'X') = NVL(p_org_information2,'X')
92: AND nvl(org_information3,'X') = nvl(p_org_information3,'X')

Line 95: AND fnd_date.canonical_to_date(org_information10) > p_effective_start_date

91: AND NVL(org_information2,'X') = NVL(p_org_information2,'X')
92: AND nvl(org_information3,'X') = nvl(p_org_information3,'X')
93: AND org_information_context='PER_CONT_AREA_PHF_SI_RATES_CN'
94: AND NVL(org_information_id,-1) <> NVL(p_org_information_id,-1)
95: AND fnd_date.canonical_to_date(org_information10) > p_effective_start_date
96: AND organization_id = p_organization_id
97: AND (org_information_id <> p_org_information_id
98: OR p_org_information_id IS NULL);
99:

Line 201: fnd_date.canonical_to_date(NVL(hoi.org_information3,'1900/01/01 00:00:00'))

197: FROM hr_organization_information hoi
198: WHERE hoi.organization_id = p_organization_id
199: AND hoi.org_information_context = p_org_info_type_code
200: AND p_effective_start_date BETWEEN
201: fnd_date.canonical_to_date(NVL(hoi.org_information3,'1900/01/01 00:00:00'))
202: AND fnd_date.canonical_to_date(NVL(hoi.org_information4,'4712/12/31 00:00:00'))
203: AND (org_information_id <>p_org_information_id OR p_org_information_id IS NULL);
204:
205:

Line 202: AND fnd_date.canonical_to_date(NVL(hoi.org_information4,'4712/12/31 00:00:00'))

198: WHERE hoi.organization_id = p_organization_id
199: AND hoi.org_information_context = p_org_info_type_code
200: AND p_effective_start_date BETWEEN
201: fnd_date.canonical_to_date(NVL(hoi.org_information3,'1900/01/01 00:00:00'))
202: AND fnd_date.canonical_to_date(NVL(hoi.org_information4,'4712/12/31 00:00:00'))
203: AND (org_information_id <>p_org_information_id OR p_org_information_id IS NULL);
204:
205:
206: CURSOR c_fut_term_info_setup

Line 208: SELECT min(fnd_date.canonical_to_date(org_information3))

204:
205:
206: CURSOR c_fut_term_info_setup
207: IS
208: SELECT min(fnd_date.canonical_to_date(org_information3))
209: FROM hr_organization_information
210: WHERE org_information_context= p_org_info_type_code
211: AND NVL(org_information_id,-1) <> NVL(p_org_information_id,-1)
212: AND fnd_date.canonical_to_date(NVL(org_information3,'1900/01/01 00:00:00')) > p_effective_start_date

Line 212: AND fnd_date.canonical_to_date(NVL(org_information3,'1900/01/01 00:00:00')) > p_effective_start_date

208: SELECT min(fnd_date.canonical_to_date(org_information3))
209: FROM hr_organization_information
210: WHERE org_information_context= p_org_info_type_code
211: AND NVL(org_information_id,-1) <> NVL(p_org_information_id,-1)
212: AND fnd_date.canonical_to_date(NVL(org_information3,'1900/01/01 00:00:00')) > p_effective_start_date
213: AND organization_id = p_organization_id
214: AND (org_information_id <> p_org_information_id
215: OR p_org_information_id IS NULL);
216:

Line 434: l_start_date := fnd_date.canonical_to_date(NVL(p_org_information3,'1900/01/01 00:00:00'));

430:
431: /* Changes for Bug 6943573 start */
432: IF p_org_info_type_code = 'PER_TERM_STAT_INFO_CN' THEN
433:
434: l_start_date := fnd_date.canonical_to_date(NVL(p_org_information3,'1900/01/01 00:00:00'));
435: l_end_date := fnd_date.canonical_to_date(NVL(p_org_information4,'4712/12/31 00:00:00'));
436: validate_date(l_start_date,l_end_date);
437:
438: --call a new procedure to check if any records are overlapping or if any duplicate records are

Line 435: l_end_date := fnd_date.canonical_to_date(NVL(p_org_information4,'4712/12/31 00:00:00'));

431: /* Changes for Bug 6943573 start */
432: IF p_org_info_type_code = 'PER_TERM_STAT_INFO_CN' THEN
433:
434: l_start_date := fnd_date.canonical_to_date(NVL(p_org_information3,'1900/01/01 00:00:00'));
435: l_end_date := fnd_date.canonical_to_date(NVL(p_org_information4,'4712/12/31 00:00:00'));
436: validate_date(l_start_date,l_end_date);
437:
438: --call a new procedure to check if any records are overlapping or if any duplicate records are
439: --existing

Line 450: l_start_date := fnd_date.canonical_to_date(NVL(p_org_information3,'1900/01/01 00:00:00'));

446: );
447:
448: ELSIF p_org_info_type_code = 'PER_TERM_GRE_INFO_CN' THEN
449:
450: l_start_date := fnd_date.canonical_to_date(NVL(p_org_information3,'1900/01/01 00:00:00'));
451: l_end_date := fnd_date.canonical_to_date(NVL(p_org_information4,'4712/12/31 00:00:00'));
452: validate_date(l_start_date,l_end_date);
453:
454: --call a new procedure to check if any records are overlapping or if any duplicate records are

Line 451: l_end_date := fnd_date.canonical_to_date(NVL(p_org_information4,'4712/12/31 00:00:00'));

447:
448: ELSIF p_org_info_type_code = 'PER_TERM_GRE_INFO_CN' THEN
449:
450: l_start_date := fnd_date.canonical_to_date(NVL(p_org_information3,'1900/01/01 00:00:00'));
451: l_end_date := fnd_date.canonical_to_date(NVL(p_org_information4,'4712/12/31 00:00:00'));
452: validate_date(l_start_date,l_end_date);
453:
454: --call a new procedure to check if any records are overlapping or if any duplicate records are
455: --existing

Line 472: l_start_date := fnd_date.canonical_to_date(p_org_information15);

468: IF g_debug THEN
469: hr_utility.trace('Validating Effective Start Date and Effective End Date');
470: END IF;
471:
472: l_start_date := fnd_date.canonical_to_date(p_org_information15);
473: l_end_date := fnd_date.canonical_to_date(NVL(p_org_information16,'4712/12/31 00:00:00'));
474: validate_date(l_start_date
475: ,l_end_date);
476:

Line 473: l_end_date := fnd_date.canonical_to_date(NVL(p_org_information16,'4712/12/31 00:00:00'));

469: hr_utility.trace('Validating Effective Start Date and Effective End Date');
470: END IF;
471:
472: l_start_date := fnd_date.canonical_to_date(p_org_information15);
473: l_end_date := fnd_date.canonical_to_date(NVL(p_org_information16,'4712/12/31 00:00:00'));
474: validate_date(l_start_date
475: ,l_end_date);
476:
477: IF g_debug THEN

Line 527: l_start_date := fnd_date.canonical_to_date(p_org_information10);

523: IF g_debug THEN
524: hr_utility.trace('Validating Effective Start Date and Effective End Date');
525: END IF;
526:
527: l_start_date := fnd_date.canonical_to_date(p_org_information10);
528: l_end_date := fnd_date.canonical_to_date(p_org_information11);
529: validate_date(l_start_date
530: ,l_end_date);
531:

Line 528: l_end_date := fnd_date.canonical_to_date(p_org_information11);

524: hr_utility.trace('Validating Effective Start Date and Effective End Date');
525: END IF;
526:
527: l_start_date := fnd_date.canonical_to_date(p_org_information10);
528: l_end_date := fnd_date.canonical_to_date(p_org_information11);
529: validate_date(l_start_date
530: ,l_end_date);
531:
532: IF g_debug THEN