7713: p_desc_flex_name IN VARCHAR2,
7714: p_return_status IN OUT NOCOPY varchar2
7715: ) IS
7716:
7717: l_flex_name fnd_descriptive_flexs.descriptive_flexfield_name%type;
7718: l_count NUMBER;
7719: l_col_name VARCHAR2(50);
7720: l_flex_exists VARCHAR2(1);
7721: CURSOR desc_flex_exists IS
7719: l_col_name VARCHAR2(50);
7720: l_flex_exists VARCHAR2(1);
7721: CURSOR desc_flex_exists IS
7722: SELECT 'Y'
7723: FROM fnd_descriptive_flexs
7724: WHERE application_id = 222
7725: and descriptive_flexfield_name = p_desc_flex_name;
7726: BEGIN
7727: IF PG_DEBUG in ('Y', 'C') THEN