APPS.JTM_VIEW dependencies on FND_LOOKUP_TYPES_TL

Line 9: g_key2_1 VARCHAR2(30) := null; -- lookup_type in fnd_lookup_types_tl

5: -- simple cache
6: g_key1 VARCHAR2(80) := null; -- profile_option_name in fnd_profile_options_tl
7: g_col1_1 VARCHAR2(240) := null; -- user_profile_option_name
8: g_col1_2 VARCHAR2(240) := null; -- description
9: g_key2_1 VARCHAR2(30) := null; -- lookup_type in fnd_lookup_types_tl
10: g_key2_2 NUMBER(15) := null; -- security_group_id
11: g_key2_3 NUMBER(15) := null; -- view_application_id
12: g_col2_1 VARCHAR2(80) := null; -- meaning
13: g_col2_2 VARCHAR2(240) := null; -- description

Line 22: PROCEDURE do_fnd_lookup_types_tl (p_lookup_type VARCHAR2, p_security_group_id NUMBER, p_view_application_id NUMBER);

18: g_col3_3 VARCHAR2(240) := null; -- description
19:
20: /* declaration of private procedures and functions */
21: PROCEDURE do_fnd_profile_options_tl (p_profile_option_name VARCHAR2);
22: PROCEDURE do_fnd_lookup_types_tl (p_lookup_type VARCHAR2, p_security_group_id NUMBER, p_view_application_id NUMBER);
23: PROCEDURE do_fnd_descriptive_flexs_tl (p_application_id NUMBER, p_descriptive_flexfield_name VARCHAR2);
24:
25: FUNCTION get_fnd_profile_options_name (p_profile_option_name VARCHAR2) RETURN VARCHAR2 IS
26: BEGIN

Line 39: do_fnd_lookup_types_tl(p_lookup_type, p_security_group_id, p_view_application_id);

35: END get_fnd_profile_options_desc;
36:
37: FUNCTION get_fnd_lookup_types_mean (p_lookup_type VARCHAR2, p_security_group_id NUMBER, p_view_application_id NUMBER) RETURN VARCHAR2 IS
38: BEGIN
39: do_fnd_lookup_types_tl(p_lookup_type, p_security_group_id, p_view_application_id);
40: RETURN g_col2_1;
41: END get_fnd_lookup_types_mean;
42:
43: FUNCTION get_fnd_lookup_types_desc (p_lookup_type VARCHAR2, p_security_group_id NUMBER, p_view_application_id NUMBER) RETURN VARCHAR2 IS

Line 45: do_fnd_lookup_types_tl(p_lookup_type, p_security_group_id, p_view_application_id);

41: END get_fnd_lookup_types_mean;
42:
43: FUNCTION get_fnd_lookup_types_desc (p_lookup_type VARCHAR2, p_security_group_id NUMBER, p_view_application_id NUMBER) RETURN VARCHAR2 IS
44: BEGIN
45: do_fnd_lookup_types_tl(p_lookup_type, p_security_group_id, p_view_application_id);
46: RETURN g_col2_2;
47: END get_fnd_lookup_types_desc;
48:
49: FUNCTION get_fnd_descriptive_flexs_titl (p_application_id VARCHAR2, p_descriptive_flexfield_name VARCHAR2) RETURN VARCHAR2 IS

Line 84: PROCEDURE do_fnd_lookup_types_tl (p_lookup_type VARCHAR2, p_security_group_id NUMBER, p_view_application_id NUMBER) IS

80: g_key1 := p_profile_option_name;
81: END IF;
82: END do_fnd_profile_options_tl;
83:
84: PROCEDURE do_fnd_lookup_types_tl (p_lookup_type VARCHAR2, p_security_group_id NUMBER, p_view_application_id NUMBER) IS
85: CURSOR c_lookup_type IS
86: SELECT meaning, description
87: FROM fnd_lookup_types_tl
88: WHERE lookup_type = p_lookup_type

Line 87: FROM fnd_lookup_types_tl

83:
84: PROCEDURE do_fnd_lookup_types_tl (p_lookup_type VARCHAR2, p_security_group_id NUMBER, p_view_application_id NUMBER) IS
85: CURSOR c_lookup_type IS
86: SELECT meaning, description
87: FROM fnd_lookup_types_tl
88: WHERE lookup_type = p_lookup_type
89: AND security_group_id = p_security_group_id
90: AND view_application_id = p_view_application_id
91: AND language = USERENV('LANG');

Line 105: END do_fnd_lookup_types_tl;

101: g_key2_1 := p_lookup_type;
102: g_key2_2 := p_security_group_id;
103: g_key2_3 := p_view_application_id;
104: END IF;
105: END do_fnd_lookup_types_tl;
106:
107: PROCEDURE do_fnd_descriptive_flexs_tl (p_application_id NUMBER, p_descriptive_flexfield_name VARCHAR2) IS
108: CURSOR c_desc_flex IS
109: SELECT title, form_context_prompt, description