APPS.AR_CREDIT_MEMO_API_PUB dependencies on FND_DESCRIPTIVE_FLEXS

Line 1346: l_flex_name fnd_descriptive_flexs.descriptive_flexfield_name%type;

1342: p_desc_flex_name IN VARCHAR2,
1343: p_return_status IN OUT NOCOPY varchar2
1344: ) IS
1345:
1346: l_flex_name fnd_descriptive_flexs.descriptive_flexfield_name%type;
1347: l_count NUMBER;
1348: l_col_name VARCHAR2(50);
1349: l_flex_exists VARCHAR2(1);
1350: CURSOR desc_flex_exists IS

Line 1352: FROM fnd_descriptive_flexs

1348: l_col_name VARCHAR2(50);
1349: l_flex_exists VARCHAR2(1);
1350: CURSOR desc_flex_exists IS
1351: SELECT 'Y'
1352: FROM fnd_descriptive_flexs
1353: WHERE application_id = 222
1354: and descriptive_flexfield_name = p_desc_flex_name;
1355: BEGIN
1356: IF PG_DEBUG = 'Y' THEN

Line 1466: l_flex_name fnd_descriptive_flexs.descriptive_flexfield_name%type;

1462: p_desc_flex_name IN VARCHAR2,
1463: p_return_status IN OUT NOCOPY varchar2
1464: ) IS
1465:
1466: l_flex_name fnd_descriptive_flexs.descriptive_flexfield_name%type;
1467: l_count NUMBER;
1468: l_col_name VARCHAR2(50);
1469: l_flex_exists VARCHAR2(1);
1470: CURSOR desc_flex_exists IS

Line 1472: FROM fnd_descriptive_flexs

1468: l_col_name VARCHAR2(50);
1469: l_flex_exists VARCHAR2(1);
1470: CURSOR desc_flex_exists IS
1471: SELECT 'Y'
1472: FROM fnd_descriptive_flexs
1473: WHERE application_id = 222
1474: and descriptive_flexfield_name = p_desc_flex_name;
1475: BEGIN
1476: IF PG_DEBUG = 'Y' THEN