APPS.AR_INVOICE_VALIDATE_FLEX dependencies on FND_DESCRIPTIVE_FLEXS

Line 926: l_flex_name fnd_descriptive_flexs.descriptive_flexfield_name%type;

922: p_desc_flex_name IN VARCHAR2,
923: p_return_status IN OUT NOCOPY varchar2
924: ) IS
925:
926: l_flex_name fnd_descriptive_flexs.descriptive_flexfield_name%type;
927: l_count NUMBER;
928: l_col_name VARCHAR2(50);
929: l_flex_exists VARCHAR2(1);
930: CURSOR desc_flex_exists IS

Line 932: FROM fnd_descriptive_flexs

928: l_col_name VARCHAR2(50);
929: l_flex_exists VARCHAR2(1);
930: CURSOR desc_flex_exists IS
931: SELECT 'Y'
932: FROM fnd_descriptive_flexs
933: WHERE application_id = 222
934: and descriptive_flexfield_name = p_desc_flex_name;
935: BEGIN
936: IF PG_DEBUG = 'Y' THEN

Line 1047: l_flex_name fnd_descriptive_flexs.descriptive_flexfield_name%type;

1043: p_desc_flex_name IN VARCHAR2,
1044: p_return_status IN OUT NOCOPY varchar2
1045: ) IS
1046:
1047: l_flex_name fnd_descriptive_flexs.descriptive_flexfield_name%type;
1048: l_count NUMBER;
1049: l_col_name VARCHAR2(50);
1050: l_flex_exists VARCHAR2(1);
1051: CURSOR desc_flex_exists IS

Line 1053: FROM fnd_descriptive_flexs

1049: l_col_name VARCHAR2(50);
1050: l_flex_exists VARCHAR2(1);
1051: CURSOR desc_flex_exists IS
1052: SELECT 'Y'
1053: FROM fnd_descriptive_flexs
1054: WHERE application_id = 222
1055: and descriptive_flexfield_name = p_desc_flex_name;
1056: BEGIN
1057: IF PG_DEBUG = 'Y' THEN