[Home] [Help]
838: FUNCTION convert_lookup (p_lookup_code IN VARCHAR2,
839: p_lookup_type IN VARCHAR2,
840: p_date_active IN DATE)
841: RETURN VARCHAR2 IS
842: l_meaning HR_LOOKUPS.MEANING%TYPE;
843: cursor get_meaning_cur(p_code VARCHAR2, p_type VARCHAR2, p_date DATE) is
844: SELECT fcl.meaning
845: FROM hr_lookups fcl
846: WHERE fcl.lookup_code = p_code
841: RETURN VARCHAR2 IS
842: l_meaning HR_LOOKUPS.MEANING%TYPE;
843: cursor get_meaning_cur(p_code VARCHAR2, p_type VARCHAR2, p_date DATE) is
844: SELECT fcl.meaning
845: FROM hr_lookups fcl
846: WHERE fcl.lookup_code = p_code
847: AND fcl.lookup_type = p_type
848: AND fcl.enabled_flag = 'Y'
849: AND p_date BETWEEN nvl(fcl.start_date_active, p_date)
893: --
894: FUNCTION get_lookup_code (p_meaning IN VARCHAR2,
895: p_date_active IN DATE)
896: RETURN VARCHAR2 IS
897: l_lookup_code HR_LOOKUPS.lookup_code%TYPE;
898: cursor get_lookup_code_cur is
899: SELECT lookup_code
900: FROM fnd_lookup_values
901: WHERE meaning = p_meaning
959: -- values with the name which is directly translated from the above names for
960: -- OTM elements.
961: -- For example: In French the user must create an input value for 'Hours'
962: -- to be 'Heures' and then to determine which input value 'Heures' is
963: -- associated with we look at the hr_lookups and if we find an entry with
964: -- lookup_type = 'NAME_TRANSLATIONS' and lookup_code = 'HOURS' and
965: -- Meaning to be 'Heures' then we know that this input value would map
966: -- to 'Hours'.
967: -- What need to be noted that it is the customer's responsibilty to create
972: p_sum_retcode IN OUT NOCOPY NUMBER,
973: p_batch_sequence IN NUMBER) IS
974: --l_batch_sequence PAY_BATCH_LINES.BATCH_SEQUENCE%TYPE;
975: l_batch_line_id PAY_BATCH_LINES.BATCH_LINE_ID%TYPE;
976: l_value_meaning hr_lookups.meaning%TYPE;
977: l_return NUMBER;
978: l_line_ovn number;
979: TYPE input_value_record IS RECORD
980: (sequence PAY_INPUT_VALUES_F.INPUT_VALUE_ID%TYPE,
1093: -- translated from the above names for OTM elements.
1094: --
1095: -- For example: In French the user must create an input value for 'Hours'
1096: -- to be 'Heures' and then to determine which input value 'Heures' is
1097: -- associated with we look at the hr_lookups and if we find an entry with
1098: -- lookup_type = 'NAME_TRANSLATIONS' and lookup_code = 'HOURS' and Meaning
1099: -- to be 'Heures' then we know that this input vale woul map to 'Hours'.
1100: --
1101: -- What need to be noted that it is the customer's responsibilty to create