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
14: g_key3_1 NUMBER(10) := null; -- application_id in fnd_descriptive_flexs_tl
15: g_key3_2 VARCHAR2(40) := null; -- descriptive_flexfield_name
16: g_col3_1 VARCHAR2(60) := null; -- title
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
26: BEGIN
27: do_fnd_profile_options_tl(p_profile_option_name);
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
50: BEGIN
51: do_fnd_descriptive_flexs_tl(p_application_id, p_descriptive_flexfield_name);
52: RETURN g_col3_1;
53: END get_fnd_descriptive_flexs_titl;
54:
55: FUNCTION get_fnd_descriptive_flexs_prom (p_application_id VARCHAR2, p_descriptive_flexfield_name VARCHAR2) RETURN VARCHAR2 IS
53: END get_fnd_descriptive_flexs_titl;
54:
55: FUNCTION get_fnd_descriptive_flexs_prom (p_application_id VARCHAR2, p_descriptive_flexfield_name VARCHAR2) RETURN VARCHAR2 IS
56: BEGIN
57: do_fnd_descriptive_flexs_tl(p_application_id, p_descriptive_flexfield_name);
58: RETURN g_col3_2;
59: END get_fnd_descriptive_flexs_prom;
60:
61: FUNCTION get_fnd_descriptive_flexs_desc (p_application_id VARCHAR2, p_descriptive_flexfield_name VARCHAR2) RETURN VARCHAR2 IS
59: END get_fnd_descriptive_flexs_prom;
60:
61: FUNCTION get_fnd_descriptive_flexs_desc (p_application_id VARCHAR2, p_descriptive_flexfield_name VARCHAR2) RETURN VARCHAR2 IS
62: BEGIN
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
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
110: FROM fnd_descriptive_flexs_tl
111: WHERE application_id = p_application_id
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
110: FROM fnd_descriptive_flexs_tl
111: WHERE application_id = p_application_id
112: AND descriptive_flexfield_name = p_descriptive_flexfield_name
113: AND language = USERENV('LANG');
114: BEGIN
122: CLOSE c_desc_flex;
123: g_key3_1 := p_application_id;
124: g_key3_2 := p_descriptive_flexfield_name;
125: END IF;
126: END do_fnd_descriptive_flexs_tl;
127:
128: END jtm_view;