DBA Data[Home] [Help]

APPS.OE_BLANKET_UTIL dependencies on FND_DESCRIPTIVE_FLEXS_VL

Line 1495: l_context_required_flag fnd_descriptive_flexs_vl.context_required_flag%TYPE;

1491: , x_return_status OUT NOCOPY VARCHAR2
1492: ) IS
1493: --{ Bug # 5562785
1494:
1495: l_context_required_flag fnd_descriptive_flexs_vl.context_required_flag%TYPE;
1496: l_default_context_field_name fnd_descriptive_flexs_vl.default_context_field_name%TYPE;
1497: l_validate_line VARCHAR2(1) := 'Y';
1498:
1499: CURSOR c_check_context(l_flex_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE) IS

Line 1496: l_default_context_field_name fnd_descriptive_flexs_vl.default_context_field_name%TYPE;

1492: ) IS
1493: --{ Bug # 5562785
1494:
1495: l_context_required_flag fnd_descriptive_flexs_vl.context_required_flag%TYPE;
1496: l_default_context_field_name fnd_descriptive_flexs_vl.default_context_field_name%TYPE;
1497: l_validate_line VARCHAR2(1) := 'Y';
1498:
1499: CURSOR c_check_context(l_flex_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE) IS
1500: SELECT context_required_flag, default_context_field_name

Line 1499: CURSOR c_check_context(l_flex_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE) IS

1495: l_context_required_flag fnd_descriptive_flexs_vl.context_required_flag%TYPE;
1496: l_default_context_field_name fnd_descriptive_flexs_vl.default_context_field_name%TYPE;
1497: l_validate_line VARCHAR2(1) := 'Y';
1498:
1499: CURSOR c_check_context(l_flex_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE) IS
1500: SELECT context_required_flag, default_context_field_name
1501: FROM FND_DESCRIPTIVE_FLEXS_VL
1502: WHERE (application_id = 660)
1503: AND (descriptive_flexfield_name = l_flex_name);

Line 1501: FROM FND_DESCRIPTIVE_FLEXS_VL

1497: l_validate_line VARCHAR2(1) := 'Y';
1498:
1499: CURSOR c_check_context(l_flex_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE) IS
1500: SELECT context_required_flag, default_context_field_name
1501: FROM FND_DESCRIPTIVE_FLEXS_VL
1502: WHERE (application_id = 660)
1503: AND (descriptive_flexfield_name = l_flex_name);
1504: -- Bug # 5562785}
1505: --