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_IN_ORG_INFO_LEG_HOOK dependencies on FND_DATE

Line 1387: WHERE p_start_date <=nvl(fnd_date.canonical_to_date(hoi.org_information3),to_date('4712/12/31','YYYY/MM/DD'))

1383: CURSOR chk_date_overlap_rep_ins(p_start_date DATE
1384: ,p_end_date DATE)IS
1385: SELECT 'X'
1386: FROM hr_organization_information hoi
1387: WHERE p_start_date <=nvl(fnd_date.canonical_to_date(hoi.org_information3),to_date('4712/12/31','YYYY/MM/DD'))
1388: AND nvl(p_end_date,to_date('4712/12/31','YYYY/MM/DD')) >=fnd_date.canonical_to_date(hoi.org_information2)
1389: AND organization_id=p_organization_id
1390: AND org_information_context=p_org_info_type_code;
1391:

Line 1388: AND nvl(p_end_date,to_date('4712/12/31','YYYY/MM/DD')) >=fnd_date.canonical_to_date(hoi.org_information2)

1384: ,p_end_date DATE)IS
1385: SELECT 'X'
1386: FROM hr_organization_information hoi
1387: WHERE p_start_date <=nvl(fnd_date.canonical_to_date(hoi.org_information3),to_date('4712/12/31','YYYY/MM/DD'))
1388: AND nvl(p_end_date,to_date('4712/12/31','YYYY/MM/DD')) >=fnd_date.canonical_to_date(hoi.org_information2)
1389: AND organization_id=p_organization_id
1390: AND org_information_context=p_org_info_type_code;
1391:
1392: ------------------------------------------------------------------

Line 1475: l_start_date := fnd_date.canonical_to_date(p_org_information2);

1471: ,'IN_CONTRACTOR_EMPLOYERS_REP')
1472: THEN
1473:
1474: pay_in_utils.set_location(g_debug,l_procedure,70);
1475: l_start_date := fnd_date.canonical_to_date(p_org_information2);
1476: l_end_date := fnd_date.canonical_to_date(p_org_information3);
1477:
1478:
1479: ------check for start date is not greater than end date--------

Line 1476: l_end_date := fnd_date.canonical_to_date(p_org_information3);

1472: THEN
1473:
1474: pay_in_utils.set_location(g_debug,l_procedure,70);
1475: l_start_date := fnd_date.canonical_to_date(p_org_information2);
1476: l_end_date := fnd_date.canonical_to_date(p_org_information3);
1477:
1478:
1479: ------check for start date is not greater than end date--------
1480:

Line 1515: l_start_date := fnd_date.canonical_to_date(p_org_information2);

1511:
1512: ELSIF p_org_info_type_code IN('IN_CONTRACTOR_WORK_INFO') THEN
1513:
1514: pay_in_utils.set_location(g_debug,l_procedure,95);
1515: l_start_date := fnd_date.canonical_to_date(p_org_information2);
1516: l_end_date := fnd_date.canonical_to_date(p_org_information3);
1517:
1518: --
1519: -- Check that the start date is not greater than end date

Line 1516: l_end_date := fnd_date.canonical_to_date(p_org_information3);

1512: ELSIF p_org_info_type_code IN('IN_CONTRACTOR_WORK_INFO') THEN
1513:
1514: pay_in_utils.set_location(g_debug,l_procedure,95);
1515: l_start_date := fnd_date.canonical_to_date(p_org_information2);
1516: l_end_date := fnd_date.canonical_to_date(p_org_information3);
1517:
1518: --
1519: -- Check that the start date is not greater than end date
1520: --

Line 1676: WHERE p_start_date <=nvl(fnd_date.canonical_to_date(hoi.org_information3),to_date('4712/12/31','YYYY/MM/DD'))

1672: ,p_start_date DATE
1673: ,p_end_date DATE) IS
1674: SELECT 'X'
1675: FROM hr_organization_information hoi
1676: WHERE p_start_date <=nvl(fnd_date.canonical_to_date(hoi.org_information3),to_date('4712/12/31','YYYY/MM/DD'))
1677: AND nvl(p_end_date,to_date('4712/12/31','YYYY/MM/DD')) >=fnd_date.canonical_to_date(hoi.org_information2)
1678: AND organization_id=p_organization_id
1679: AND org_information_id <>p_org_information_id
1680: AND org_information_context=p_org_info_type_code;

Line 1677: AND nvl(p_end_date,to_date('4712/12/31','YYYY/MM/DD')) >=fnd_date.canonical_to_date(hoi.org_information2)

1673: ,p_end_date DATE) IS
1674: SELECT 'X'
1675: FROM hr_organization_information hoi
1676: WHERE p_start_date <=nvl(fnd_date.canonical_to_date(hoi.org_information3),to_date('4712/12/31','YYYY/MM/DD'))
1677: AND nvl(p_end_date,to_date('4712/12/31','YYYY/MM/DD')) >=fnd_date.canonical_to_date(hoi.org_information2)
1678: AND organization_id=p_organization_id
1679: AND org_information_id <>p_org_information_id
1680: AND org_information_context=p_org_info_type_code;
1681:

Line 1785: l_start_date := fnd_date.canonical_to_date(p_org_information2);

1781:
1782:
1783: pay_in_utils.set_location(g_debug,l_procedure,90);
1784:
1785: l_start_date := fnd_date.canonical_to_date(p_org_information2);
1786: l_end_date := fnd_date.canonical_to_date(p_org_information3);
1787:
1788: --check start date is not greater than end date
1789:

Line 1786: l_end_date := fnd_date.canonical_to_date(p_org_information3);

1782:
1783: pay_in_utils.set_location(g_debug,l_procedure,90);
1784:
1785: l_start_date := fnd_date.canonical_to_date(p_org_information2);
1786: l_end_date := fnd_date.canonical_to_date(p_org_information3);
1787:
1788: --check start date is not greater than end date
1789:
1790: validate_date(p_effective_start_date=>l_start_date

Line 1830: l_start_date := fnd_date.canonical_to_date(p_org_information2);

1826:
1827:
1828: pay_in_utils.set_location(g_debug,l_procedure,125);
1829:
1830: l_start_date := fnd_date.canonical_to_date(p_org_information2);
1831: l_end_date := fnd_date.canonical_to_date(p_org_information3);
1832:
1833:
1834: --

Line 1831: l_end_date := fnd_date.canonical_to_date(p_org_information3);

1827:
1828: pay_in_utils.set_location(g_debug,l_procedure,125);
1829:
1830: l_start_date := fnd_date.canonical_to_date(p_org_information2);
1831: l_end_date := fnd_date.canonical_to_date(p_org_information3);
1832:
1833:
1834: --
1835: -- Check that the start date is not greater than end date