[Home] [Help]
500: l_proc varchar2(72) := g_package||'chk_cost_center_valid';
501: --
502: cursor c1 is
503: select null
504: from dual
505: where exists
506: (select null
507: from hr_organization_units org,
508: hr_organization_information org2,
1341: -- error will be raised and processing is terminated.
1342: --
1343: -- Developer/Implementation Notes:
1344: -- Duplicate validation exists on form, so any changes made here
1345: -- or on form must be dual-maintained.
1346: --
1347: -- Access Status:
1348: -- Internal Row Table Handler Use Only.
1349: --
1365: --
1366: BEGIN
1367: SELECT 'Y'
1368: INTO l_exists
1369: FROM sys.dual
1370: WHERE EXISTS
1371: (SELECT null
1372: FROM hr_all_organization_units
1373: WHERE organization_id = p_organization_id);
1412: -- error will be raised and processing is terminated.
1413: --
1414: -- Developer/Implementation Notes:
1415: -- Duplicate validation exists on form, so any changes made here
1416: -- or on form must be dual-maintained.
1417: --
1418: -- Access Status:
1419: -- Internal Row Table Handler Use Only.
1420: --
1493: -- error will be raised and processing is terminated.
1494: --
1495: -- Developer/Implementation Notes:
1496: -- Duplicate validation exists on form, so any changes made here
1497: -- or on form must be dual-maintained.
1498: --
1499: -- Access Status:
1500: -- Internal Row Table Handler Use Only.
1501: --
1517: --
1518: BEGIN
1519: SELECT 'Y'
1520: INTO l_exists
1521: FROM sys.dual
1522: WHERE EXISTS
1523: (SELECT null
1524: FROM hr_organization_information
1525: WHERE organization_id = p_organization_id
1567: -- error will be raised and processing is terminated.
1568: --
1569: -- Developer/Implementation Notes:
1570: -- Duplicate validation exists on form, so any changes made here
1571: -- or on form must be dual-maintained.
1572: --
1573: -- Access Status:
1574: -- Internal Row Table Handler Use Only.
1575: --
1593: --
1594: BEGIN
1595: SELECT 'Y'
1596: INTO l_exists
1597: FROM sys.dual
1598: WHERE EXISTS
1599: (SELECT hoit.org_information_type
1600: FROM hr_org_information_types hoit
1601: WHERE hoit.org_information_type = p_org_information_context
1660: -- error will be raised and processing is terminated.
1661: --
1662: -- Developer/Implementation Notes:
1663: -- Duplicate validation exists on form, so any changes made here
1664: -- or on form must be dual-maintained.
1665: --
1666: -- Access Status:
1667: -- Internal Row Table Handler Use Only.
1668: --
1684: --
1685: BEGIN
1686: SELECT 'Y'
1687: INTO l_exists
1688: FROM sys.dual
1689: WHERE EXISTS
1690: (SELECT null
1691: FROM hr_organization_information hoi
1692: ,hr_org_information_types hoit