APPS.HR_BPL_ALERT_TRNSLT dependencies on FND_LOOKUP_VALUES

Line 9: lookup_type fnd_lookup_values.lookup_type%TYPE,

5: -- Variables and Cursors Required by the decode_lookup functions
6: --
7: --
8: TYPE lookup_value_pair_rec IS RECORD(
9: lookup_type fnd_lookup_values.lookup_type%TYPE,
10: lookup_code fnd_lookup_values.lookup_code%TYPE,
11: language fnd_lookup_values.language%TYPE,
12: meaning fnd_lookup_values.meaning%TYPE);
13:

Line 10: lookup_code fnd_lookup_values.lookup_code%TYPE,

6: --
7: --
8: TYPE lookup_value_pair_rec IS RECORD(
9: lookup_type fnd_lookup_values.lookup_type%TYPE,
10: lookup_code fnd_lookup_values.lookup_code%TYPE,
11: language fnd_lookup_values.language%TYPE,
12: meaning fnd_lookup_values.meaning%TYPE);
13:
14: TYPE fnd_lookups_cache_tabtype IS table OF lookup_value_pair_rec

Line 11: language fnd_lookup_values.language%TYPE,

7: --
8: TYPE lookup_value_pair_rec IS RECORD(
9: lookup_type fnd_lookup_values.lookup_type%TYPE,
10: lookup_code fnd_lookup_values.lookup_code%TYPE,
11: language fnd_lookup_values.language%TYPE,
12: meaning fnd_lookup_values.meaning%TYPE);
13:
14: TYPE fnd_lookups_cache_tabtype IS table OF lookup_value_pair_rec
15: INDEX BY BINARY_INTEGER;

Line 12: meaning fnd_lookup_values.meaning%TYPE);

8: TYPE lookup_value_pair_rec IS RECORD(
9: lookup_type fnd_lookup_values.lookup_type%TYPE,
10: lookup_code fnd_lookup_values.lookup_code%TYPE,
11: language fnd_lookup_values.language%TYPE,
12: meaning fnd_lookup_values.meaning%TYPE);
13:
14: TYPE fnd_lookups_cache_tabtype IS table OF lookup_value_pair_rec
15: INDEX BY BINARY_INTEGER;
16: g_lookups_tab fnd_lookups_cache_tabtype;

Line 18: g_security_group_id fnd_lookup_values.security_group_id%TYPE;

14: TYPE fnd_lookups_cache_tabtype IS table OF lookup_value_pair_rec
15: INDEX BY BINARY_INTEGER;
16: g_lookups_tab fnd_lookups_cache_tabtype;
17: -- define the security group
18: g_security_group_id fnd_lookup_values.security_group_id%TYPE;
19: -- define a global meaning
20: g_meaning fnd_lookup_values.meaning%TYPE;
21: -- define a holder for the hash number
22: g_language fnd_lookup_values.language%TYPE;

Line 20: g_meaning fnd_lookup_values.meaning%TYPE;

16: g_lookups_tab fnd_lookups_cache_tabtype;
17: -- define the security group
18: g_security_group_id fnd_lookup_values.security_group_id%TYPE;
19: -- define a global meaning
20: g_meaning fnd_lookup_values.meaning%TYPE;
21: -- define a holder for the hash number
22: g_language fnd_lookup_values.language%TYPE;
23: g_hash_number BINARY_INTEGER;
24: -- define the bis_decode_lookup cursors

Line 22: g_language fnd_lookup_values.language%TYPE;

18: g_security_group_id fnd_lookup_values.security_group_id%TYPE;
19: -- define a global meaning
20: g_meaning fnd_lookup_values.meaning%TYPE;
21: -- define a holder for the hash number
22: g_language fnd_lookup_values.language%TYPE;
23: g_hash_number BINARY_INTEGER;
24: -- define the bis_decode_lookup cursors
25:
26: --

Line 32: FROM fnd_lookup_values flv

28: ,c_lookup_code VARCHAR2
29: ,c_language VARCHAR2)
30: IS
31: SELECT flv.meaning
32: FROM fnd_lookup_values flv
33: WHERE flv.lookup_code = c_lookup_code
34: AND flv.lookup_type = c_lookup_type
35: AND flv.language = c_language
36: AND flv.view_application_id = 3

Line 463: RETURN fnd_lookup_values.meaning%TYPE IS

459: --
460: FUNCTION psn_lng_decode_lookup(p_lookup_type IN VARCHAR2
461: ,p_lookup_code IN VARCHAR2
462: ,p_person_id IN NUMBER)
463: RETURN fnd_lookup_values.meaning%TYPE IS
464:
465: BEGIN
466: -- check to ensure the lookup type/code combo is NOT NULL
467: IF p_lookup_type IS NULL

Line 710: RETURN fnd_lookup_values.meaning%TYPE IS

706:
707: FUNCTION asg_lng_decode_lookup(p_lookup_type IN VARCHAR2
708: ,p_lookup_code IN VARCHAR2
709: ,p_assignment_id IN NUMBER)
710: RETURN fnd_lookup_values.meaning%TYPE IS
711:
712: BEGIN
713: -- check to ensure the lookup type/code combo is NOT NULL
714: IF p_lookup_type IS NULL

Line 823: RETURN fnd_lookup_values.meaning%TYPE IS

819:
820: FUNCTION asg_sup_lng_decode_lookup(p_lookup_type IN VARCHAR2
821: ,p_lookup_code IN VARCHAR2
822: ,p_assignment_id IN NUMBER)
823: RETURN fnd_lookup_values.meaning%TYPE IS
824:
825: BEGIN
826: -- check to ensure the lookup type/code combo is NOT NULL
827: IF p_lookup_type IS NULL

Line 989: RETURN fnd_lookup_values.meaning%TYPE IS

985:
986: FUNCTION pasg_sup_lng_decode_lookup(p_lookup_type IN VARCHAR2
987: ,p_lookup_code IN VARCHAR2
988: ,p_assignment_id IN NUMBER)
989: RETURN fnd_lookup_values.meaning%TYPE IS
990:
991: BEGIN
992: -- check to ensure the lookup type/code combo is NOT NULL
993: IF p_lookup_type IS NULL