[Home] [Help]
479: -- ----------------------------------------------------------------------------
480: --
481: -- Description:
482: -- This procedure is used to ensure that LOOKUP_TYPE can be entered only
483: -- when Unit Of Measure is 'Character' and is the one present in HR_LOOKUPS,
484: -- enabled and valid as of current date.
485: --
486: -- ----------------------------------------------------------------------------
487: PROCEDURE chk_lookup_type
489: ,p_uom varchar2
490: ,p_effective_date date
491: ) IS
492: cursor csr_lookup is
493: select 'X' from hr_lookups
494: where upper(lookup_type) = nvl(upper(p_lookup_type),lookup_type)
495: and enabled_flag = 'Y'
496: and p_effective_date between
497: nvl(start_date_active,hr_api.g_sot) and nvl(end_date_active,hr_api.g_eot);
980: ,p_effective_date in date)
981: IS
982: cursor csr_uom is
983: select lookup_code from
984: hr_lookups
985: where upper(substr(lookup_code,1,2))
986: = upper(substr(pay_ivl_shd.g_old_rec.uom,1,2))
987: and lookup_type = 'UNITS'
988: and enabled_flag = 'Y'
1235: -- Description:
1236: -- This procedure will do the following validations
1237: -- 1) The UOM cannot be 'Money' if no currencies have been specified for the
1238: -- element type
1239: -- 2) Validate UOM with HR_LOOKUPS having LOOKUP_TYPE as 'UNITS'
1240: -- and lookup_code not equal to 'M' if element_types'
1241: -- output_currency_code is null
1242: --
1243: -- ----------------------------------------------------------------------------
1252: from pay_element_types_f
1253: where element_type_id = p_element_type_id;
1254:
1255: cursor csr_lookup is
1256: select 'X' from hr_lookups
1257: where upper(lookup_code) = nvl(upper(p_uom),lookup_code)
1258: and lookup_type = 'UNITS'
1259: and enabled_flag = 'Y'
1260: and p_effective_date between
1294: -- ----------------------------------------------------------------------------
1295: --
1296: -- Description:
1297: -- This procedure will do the following validations
1298: -- 1) DEFAULT_VALUE has to be validated against HR_LOOKUPS for lookup_type
1299: -- equal to specified in LOOKUP_TYPE field (active as of current date),
1300: -- if not null
1301: -- 2) DEFAULT_VALUE must lie between MIN_VALUE and MAX_VALUE (if LOOKUP_TYPE is
1302: -- null) and if DEFAULT_VALUE does not lie between MIN_VALUE and MAX_VALUE
1315: )
1316: IS
1317: --
1318: cursor csr_lookup is
1319: select 'X' from hr_lookups
1320: where upper(lookup_code) = nvl(upper(p_default_value),lookup_code)
1321: and lookup_type = p_lookup_type
1322: and enabled_flag = 'Y'
1323: and p_effective_date between
1399: -- ----------------------------------------------------------------------------
1400: --
1401: -- Description:
1402: -- This procedure will do the following validations
1403: -- 1) DEFAULT_VALUE has to be validated against HR_LOOKUPS for lookup_type
1404: -- equal to specified in LOOKUP_TYPE field (active as of current date),
1405: -- if not null
1406: -- 2) DEFAULT_VALUE must lie between MIN_VALUE and MAX_VALUE (if LOOKUP_TYPE
1407: -- is null) and if DEFAULT_VALUE does not lie between MIN_VALUE and
1421: IS
1422: --
1423: cursor csr_lookup is
1424: select 'X'
1425: from hr_lookups
1426: where upper(lookup_code) = nvl(upper(p_default_value),lookup_code)
1427: and lookup_type = decode(p_lookup_type,
1428: hr_api.g_varchar2, pay_ivl_shd.g_old_rec.lookup_type,
1429: p_lookup_type)
1581: -- Description:
1582: -- This procedure will do the following validations
1583: -- 1) WARNING_OR_ERROR must be set in case a MIN_VALUE/MAX_VALUE/FORMULA_ID
1584: -- is specified
1585: -- 2) Validate with HR_LOOKUPS having LOOKUP_TYPE as 'WARNING_ERROR'
1586: -- and active as of current date
1587: -- ----------------------------------------------------------------------------
1588: PROCEDURE chk_warning_or_error
1589: (p_warning_or_error in varchar2
1594: ,p_effective_date in date
1595: )
1596: IS
1597: cursor csr_lookup is
1598: select 'X' from hr_lookups
1599: where upper(lookup_code) = nvl(upper(p_warning_or_error),lookup_code)
1600: and lookup_type = 'WARNING_ERROR'
1601: and enabled_flag = 'Y'
1602: and p_effective_date between