APPS.AR_DEPOSIT_LIB_PVT dependencies on FND_DESCRIPTIVE_FLEXS

Line 2914: l_flex_name fnd_descriptive_flexs.descriptive_flexfield_name%type;

2910: p_desc_flex_name IN VARCHAR2,
2911: p_return_status IN OUT NOCOPY varchar2
2912: ) IS
2913:
2914: l_flex_name fnd_descriptive_flexs.descriptive_flexfield_name%type;
2915: l_count NUMBER;
2916: l_col_name VARCHAR2(50);
2917: l_flex_exists VARCHAR2(1);
2918: CURSOR desc_flex_exists IS

Line 2920: FROM fnd_descriptive_flexs

2916: l_col_name VARCHAR2(50);
2917: l_flex_exists VARCHAR2(1);
2918: CURSOR desc_flex_exists IS
2919: SELECT 'Y'
2920: FROM fnd_descriptive_flexs
2921: WHERE application_id = 222 and
2922: descriptive_flexfield_name = p_desc_flex_name;
2923: /* Start FP Bug 5467022 */
2924: /* bug 5467021 created get_flex_title to get title of flex field*/

Line 2926: l_flex_title FND_DESCRIPTIVE_FLEXS_VL.title%type;

2922: descriptive_flexfield_name = p_desc_flex_name;
2923: /* Start FP Bug 5467022 */
2924: /* bug 5467021 created get_flex_title to get title of flex field*/
2925: function get_flex_title ( p_flex_name in varchar2) return varchar2 is
2926: l_flex_title FND_DESCRIPTIVE_FLEXS_VL.title%type;
2927: begin
2928: select title
2929: into l_flex_title
2930: from FND_DESCRIPTIVE_FLEXS_VL

Line 2930: from FND_DESCRIPTIVE_FLEXS_VL

2926: l_flex_title FND_DESCRIPTIVE_FLEXS_VL.title%type;
2927: begin
2928: select title
2929: into l_flex_title
2930: from FND_DESCRIPTIVE_FLEXS_VL
2931: where DESCRIPTIVE_FLEXFIELD_NAME=p_flex_name;
2932:
2933: return l_flex_title;
2934: exception