APPS.JTM_VIEW dependencies on FND_PROFILE_OPTIONS_TL

Line 6: g_key1 VARCHAR2(80) := null; -- profile_option_name in fnd_profile_options_tl

2: /* $Header: jtmviewb.pls 120.1 2005/08/24 02:19:05 saradhak noship $ */
3:
4: /* declaration of private global variables */
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

Line 21: PROCEDURE do_fnd_profile_options_tl (p_profile_option_name VARCHAR2);

17: g_col3_2 VARCHAR2(45) := null; -- form_context_prompt
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

Line 27: do_fnd_profile_options_tl(p_profile_option_name);

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
27: do_fnd_profile_options_tl(p_profile_option_name);
28: RETURN g_col1_1;
29: END get_fnd_profile_options_name;
30:
31: FUNCTION get_fnd_profile_options_desc (p_profile_option_name VARCHAR2) RETURN VARCHAR2 IS

Line 33: do_fnd_profile_options_tl(p_profile_option_name);

29: END get_fnd_profile_options_name;
30:
31: FUNCTION get_fnd_profile_options_desc (p_profile_option_name VARCHAR2) RETURN VARCHAR2 IS
32: BEGIN
33: do_fnd_profile_options_tl(p_profile_option_name);
34: RETURN g_col1_2;
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

Line 67: PROCEDURE do_fnd_profile_options_tl (p_profile_option_name VARCHAR2) IS

63: do_fnd_descriptive_flexs_tl(p_application_id, p_descriptive_flexfield_name);
64: RETURN g_col3_3;
65: END get_fnd_descriptive_flexs_desc;
66:
67: PROCEDURE do_fnd_profile_options_tl (p_profile_option_name VARCHAR2) IS
68: CURSOR c_profile_option IS
69: SELECT user_profile_option_name, description
70: FROM fnd_profile_options_tl
71: WHERE profile_option_name = p_profile_option_name

Line 70: FROM fnd_profile_options_tl

66:
67: PROCEDURE do_fnd_profile_options_tl (p_profile_option_name VARCHAR2) IS
68: CURSOR c_profile_option IS
69: SELECT user_profile_option_name, description
70: FROM fnd_profile_options_tl
71: WHERE profile_option_name = p_profile_option_name
72: AND language = USERENV('LANG');
73: BEGIN
74: IF g_key1 IS NULL OR g_key1 <> p_profile_option_name THEN

Line 82: END do_fnd_profile_options_tl;

78: FETCH c_profile_option INTO g_col1_1, g_col1_2;
79: CLOSE c_profile_option;
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