[Home] [Help]
547: -- ----------------------------------------------------------------------------
548: --
549: -- Description:
550: -- This procedure is used to ensure that LOOKUP_TYPE can be entered only
551: -- when Unit Of Measure is 'Character' and is the one present in HR_LOOKUPS,
552: -- enabled and valid as of current date.
553: --
554: -- ----------------------------------------------------------------------------
555: PROCEDURE chk_lookup_type
557: ,p_uom varchar2
558: ,p_effective_date date
559: ) IS
560: cursor csr_lookup is
561: select 'X' from hr_lookups
562: where upper(lookup_type) = nvl(upper(p_lookup_type),lookup_type)
563: and enabled_flag = 'Y'
564: and p_effective_date between
565: nvl(start_date_active,hr_api.g_sot) and nvl(end_date_active,hr_api.g_eot);
1048: ,p_effective_date in date)
1049: IS
1050: cursor csr_uom is
1051: select lookup_code from
1052: hr_lookups
1053: where upper(substr(lookup_code,1,2))
1054: = upper(substr(pay_ivl_shd.g_old_rec.uom,1,2))
1055: and lookup_type = 'UNITS'
1056: and enabled_flag = 'Y'
1303: -- Description:
1304: -- This procedure will do the following validations
1305: -- 1) The UOM cannot be 'Money' if no currencies have been specified for the
1306: -- element type
1307: -- 2) Validate UOM with HR_LOOKUPS having LOOKUP_TYPE as 'UNITS'
1308: -- and lookup_code not equal to 'M' if element_types'
1309: -- output_currency_code is null
1310: --
1311: -- ----------------------------------------------------------------------------
1320: from pay_element_types_f
1321: where element_type_id = p_element_type_id;
1322:
1323: cursor csr_lookup is
1324: select 'X' from hr_lookups
1325: where upper(lookup_code) = nvl(upper(p_uom),lookup_code)
1326: and lookup_type = 'UNITS'
1327: and enabled_flag = 'Y'
1328: and p_effective_date between
1362: -- ----------------------------------------------------------------------------
1363: --
1364: -- Description:
1365: -- This procedure will do the following validations
1366: -- 1) DEFAULT_VALUE has to be validated against HR_LOOKUPS for lookup_type
1367: -- equal to specified in LOOKUP_TYPE field (active as of current date),
1368: -- if not null
1369: --
1370: -- 2) DEFAULT_VALUE must lie between MIN_VALUE and MAX_VALUE (if LOOKUP_TYPE is
1386: )
1387: IS
1388: --
1389: cursor csr_lookup is
1390: select 'X' from hr_lookups
1391: where upper(lookup_code) = nvl(upper(p_default_value),lookup_code)
1392: and lookup_type = p_lookup_type
1393: and enabled_flag = 'Y'
1394: and p_effective_date between
1479: -- ----------------------------------------------------------------------------
1480: --
1481: -- Description:
1482: -- This procedure will do the following validations
1483: -- 1) DEFAULT_VALUE has to be validated against HR_LOOKUPS for lookup_type
1484: -- equal to specified in LOOKUP_TYPE field (active as of current date),
1485: -- if not null
1486: -- 2) DEFAULT_VALUE must lie between MIN_VALUE and MAX_VALUE (if LOOKUP_TYPE
1487: -- is null) and if DEFAULT_VALUE does not lie between MIN_VALUE and
1504: IS
1505: --
1506: cursor csr_lookup is
1507: select 'X'
1508: from hr_lookups
1509: where upper(lookup_code) = nvl(upper(p_default_value),lookup_code)
1510: and lookup_type = decode(p_lookup_type,
1511: hr_api.g_varchar2, pay_ivl_shd.g_old_rec.lookup_type,
1512: p_lookup_type)
1709: -- Description:
1710: -- This procedure will do the following validations
1711: -- 1) WARNING_OR_ERROR must be set in case a MIN_VALUE/MAX_VALUE/FORMULA_ID
1712: -- is specified
1713: -- 2) Validate with HR_LOOKUPS having LOOKUP_TYPE as 'WARNING_ERROR'
1714: -- and active as of current date
1715: -- ----------------------------------------------------------------------------
1716: PROCEDURE chk_warning_or_error
1717: (p_warning_or_error in varchar2
1722: ,p_effective_date in date
1723: )
1724: IS
1725: cursor csr_lookup is
1726: select 'X' from hr_lookups
1727: where upper(lookup_code) = nvl(upper(p_warning_or_error),lookup_code)
1728: and lookup_type = 'WARNING_ERROR'
1729: and enabled_flag = 'Y'
1730: and p_effective_date between