APPS.JTM_VIEW dependencies on FND_DESCRIPTIVE_FLEXS_TL

Line 14: g_key3_1 NUMBER(10) := null; -- application_id in fnd_descriptive_flexs_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
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

Line 23: PROCEDURE do_fnd_descriptive_flexs_tl (p_application_id NUMBER, p_descriptive_flexfield_name VARCHAR2);

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);

Line 51: do_fnd_descriptive_flexs_tl(p_application_id, p_descriptive_flexfield_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

Line 57: do_fnd_descriptive_flexs_tl(p_application_id, p_descriptive_flexfield_name);

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

Line 63: do_fnd_descriptive_flexs_tl(p_application_id, p_descriptive_flexfield_name);

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

Line 107: PROCEDURE do_fnd_descriptive_flexs_tl (p_application_id NUMBER, p_descriptive_flexfield_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

Line 110: FROM fnd_descriptive_flexs_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
112: AND descriptive_flexfield_name = p_descriptive_flexfield_name
113: AND language = USERENV('LANG');
114: BEGIN

Line 126: END do_fnd_descriptive_flexs_tl;

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;