APPS.AR_DEPOSIT_LIB_PVT dependencies on FND_DESCRIPTIVE_FLEXS

Line 2940: l_flex_name fnd_descriptive_flexs.descriptive_flexfield_name%type;

2936: p_desc_flex_name IN VARCHAR2,
2937: p_return_status IN OUT NOCOPY varchar2
2938: ) IS
2939:
2940: l_flex_name fnd_descriptive_flexs.descriptive_flexfield_name%type;
2941: l_count NUMBER;
2942: l_col_name VARCHAR2(50);
2943: l_flex_exists VARCHAR2(1);
2944: CURSOR desc_flex_exists IS

Line 2946: FROM fnd_descriptive_flexs

2942: l_col_name VARCHAR2(50);
2943: l_flex_exists VARCHAR2(1);
2944: CURSOR desc_flex_exists IS
2945: SELECT 'Y'
2946: FROM fnd_descriptive_flexs
2947: WHERE application_id = 222 and
2948: descriptive_flexfield_name = p_desc_flex_name;
2949: /* Start FP Bug 5467022 */
2950: /* bug 5467021 created get_flex_title to get title of flex field*/

Line 2952: l_flex_title FND_DESCRIPTIVE_FLEXS_VL.title%type;

2948: descriptive_flexfield_name = p_desc_flex_name;
2949: /* Start FP Bug 5467022 */
2950: /* bug 5467021 created get_flex_title to get title of flex field*/
2951: function get_flex_title ( p_flex_name in varchar2) return varchar2 is
2952: l_flex_title FND_DESCRIPTIVE_FLEXS_VL.title%type;
2953: begin
2954: select title
2955: into l_flex_title
2956: from FND_DESCRIPTIVE_FLEXS_VL

Line 2956: from FND_DESCRIPTIVE_FLEXS_VL

2952: l_flex_title FND_DESCRIPTIVE_FLEXS_VL.title%type;
2953: begin
2954: select title
2955: into l_flex_title
2956: from FND_DESCRIPTIVE_FLEXS_VL
2957: where DESCRIPTIVE_FLEXFIELD_NAME=p_flex_name;
2958:
2959: return l_flex_title;
2960: exception