[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,
1331: -- error will be raised and processing is terminated.
1332: --
1333: -- Developer/Implementation Notes:
1334: -- Duplicate validation exists on form, so any changes made here
1335: -- or on form must be dual-maintained.
1336: --
1337: -- Access Status:
1338: -- Internal Row Table Handler Use Only.
1339: --
1355: --
1356: BEGIN
1357: SELECT 'Y'
1358: INTO l_exists
1359: FROM sys.dual
1360: WHERE EXISTS
1361: (SELECT null
1362: FROM hr_all_organization_units
1363: WHERE organization_id = p_organization_id);
1402: -- error will be raised and processing is terminated.
1403: --
1404: -- Developer/Implementation Notes:
1405: -- Duplicate validation exists on form, so any changes made here
1406: -- or on form must be dual-maintained.
1407: --
1408: -- Access Status:
1409: -- Internal Row Table Handler Use Only.
1410: --
1483: -- error will be raised and processing is terminated.
1484: --
1485: -- Developer/Implementation Notes:
1486: -- Duplicate validation exists on form, so any changes made here
1487: -- or on form must be dual-maintained.
1488: --
1489: -- Access Status:
1490: -- Internal Row Table Handler Use Only.
1491: --
1507: --
1508: BEGIN
1509: SELECT 'Y'
1510: INTO l_exists
1511: FROM sys.dual
1512: WHERE EXISTS
1513: (SELECT null
1514: FROM hr_organization_information
1515: WHERE organization_id = p_organization_id
1557: -- error will be raised and processing is terminated.
1558: --
1559: -- Developer/Implementation Notes:
1560: -- Duplicate validation exists on form, so any changes made here
1561: -- or on form must be dual-maintained.
1562: --
1563: -- Access Status:
1564: -- Internal Row Table Handler Use Only.
1565: --
1583: --
1584: BEGIN
1585: SELECT 'Y'
1586: INTO l_exists
1587: FROM sys.dual
1588: WHERE EXISTS
1589: (SELECT hoit.org_information_type
1590: FROM hr_org_information_types hoit
1591: WHERE hoit.org_information_type = p_org_information_context
1650: -- error will be raised and processing is terminated.
1651: --
1652: -- Developer/Implementation Notes:
1653: -- Duplicate validation exists on form, so any changes made here
1654: -- or on form must be dual-maintained.
1655: --
1656: -- Access Status:
1657: -- Internal Row Table Handler Use Only.
1658: --
1674: --
1675: BEGIN
1676: SELECT 'Y'
1677: INTO l_exists
1678: FROM sys.dual
1679: WHERE EXISTS
1680: (SELECT null
1681: FROM hr_organization_information hoi
1682: ,hr_org_information_types hoit