[Home] [Help]
1322: FUNCTION convert_lookup (p_lookup_code IN VARCHAR2,
1323: p_lookup_type IN VARCHAR2,
1324: p_date_active IN DATE)
1325: RETURN VARCHAR2 IS
1326: l_meaning HR_LOOKUPS.MEANING%TYPE;
1327: cursor get_meaning_cur(p_code VARCHAR2, p_type VARCHAR2, p_date DATE) is
1328: SELECT fcl.meaning
1329: FROM hr_lookups fcl
1330: WHERE fcl.lookup_code = p_code
1325: RETURN VARCHAR2 IS
1326: l_meaning HR_LOOKUPS.MEANING%TYPE;
1327: cursor get_meaning_cur(p_code VARCHAR2, p_type VARCHAR2, p_date DATE) is
1328: SELECT fcl.meaning
1329: FROM hr_lookups fcl
1330: WHERE fcl.lookup_code = p_code
1331: AND fcl.lookup_type = p_type
1332: AND fcl.enabled_flag = 'Y'
1333: AND p_date BETWEEN nvl(fcl.start_date_active, p_date)
1384: --
1385: FUNCTION get_lookup_code (p_meaning IN VARCHAR2,
1386: p_date_active IN DATE)
1387: RETURN VARCHAR2 IS
1388: l_lookup_code HR_LOOKUPS.lookup_code%TYPE;
1389: cursor get_lookup_code_cur is
1390: SELECT lookup_code
1391: FROM fnd_lookup_values
1392: WHERE meaning = p_meaning
1450: -- values with the name which is directly translated from the above names for
1451: -- OTM elements.
1452: -- For example: In French the user must create an input value for 'Hours'
1453: -- to be 'Heures' and then to determine which input value 'Heures' is
1454: -- associated with we look at the hr_lookups and if we find an entry with
1455: -- lookup_type = 'NAME_TRANSLATIONS' and lookup_code = 'HOURS' and
1456: -- Meaning to be 'Heures' then we know that this input value would map
1457: -- to 'Hours'.
1458: -- What need to be noted that it is the customer's responsibilty to create
1464: p_batch_sequence IN NUMBER)
1465: IS
1466: --l_batch_sequence PAY_BATCH_LINES.BATCH_SEQUENCE%TYPE;
1467: l_batch_line_id PAY_BATCH_LINES.BATCH_LINE_ID%TYPE;
1468: l_value_meaning hr_lookups.meaning%TYPE;
1469: l_return NUMBER;
1470: l_line_ovn number;
1471:
1472: -- Bug 12993528
1808: -- translated from the above names for OTM elements.
1809: --
1810: -- For example: In French the user must create an input value for 'Hours'
1811: -- to be 'Heures' and then to determine which input value 'Heures' is
1812: -- associated with we look at the hr_lookups and if we find an entry with
1813: -- lookup_type = 'NAME_TRANSLATIONS' and lookup_code = 'HOURS' and Meaning
1814: -- to be 'Heures' then we know that this input vale woul map to 'Hours'.
1815: --
1816: -- What need to be noted that it is the customer's responsibilty to create