APPS.AR_CREDIT_MEMO_API_PUB dependencies on FND_DESCRIPTIVE_FLEXS

Line 1420: l_flex_name fnd_descriptive_flexs.descriptive_flexfield_name%type;

1416: p_desc_flex_name IN VARCHAR2,
1417: p_return_status IN OUT NOCOPY varchar2
1418: ) IS
1419:
1420: l_flex_name fnd_descriptive_flexs.descriptive_flexfield_name%type;
1421: l_count NUMBER;
1422: l_col_name VARCHAR2(50);
1423: l_flex_exists VARCHAR2(1);
1424: CURSOR desc_flex_exists IS

Line 1426: FROM fnd_descriptive_flexs

1422: l_col_name VARCHAR2(50);
1423: l_flex_exists VARCHAR2(1);
1424: CURSOR desc_flex_exists IS
1425: SELECT 'Y'
1426: FROM fnd_descriptive_flexs
1427: WHERE application_id = 222
1428: and descriptive_flexfield_name = p_desc_flex_name;
1429: BEGIN
1430: IF PG_DEBUG = 'Y' THEN

Line 1540: l_flex_name fnd_descriptive_flexs.descriptive_flexfield_name%type;

1536: p_desc_flex_name IN VARCHAR2,
1537: p_return_status IN OUT NOCOPY varchar2
1538: ) IS
1539:
1540: l_flex_name fnd_descriptive_flexs.descriptive_flexfield_name%type;
1541: l_count NUMBER;
1542: l_col_name VARCHAR2(50);
1543: l_flex_exists VARCHAR2(1);
1544: CURSOR desc_flex_exists IS

Line 1546: FROM fnd_descriptive_flexs

1542: l_col_name VARCHAR2(50);
1543: l_flex_exists VARCHAR2(1);
1544: CURSOR desc_flex_exists IS
1545: SELECT 'Y'
1546: FROM fnd_descriptive_flexs
1547: WHERE application_id = 222
1548: and descriptive_flexfield_name = p_desc_flex_name;
1549: BEGIN
1550: IF PG_DEBUG = 'Y' THEN