DBA Data[Home] [Help]

APPS.OE_VALIDATE_LINE dependencies on FND_DESCRIPTIVE_FLEXS_VL

Line 9130: l_context_required_flag fnd_descriptive_flexs_vl.context_required_flag%TYPE;

9126: )
9127: IS
9128: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
9129: --Start of bug#7380336
9130: l_context_required_flag fnd_descriptive_flexs_vl.context_required_flag%TYPE;
9131: l_default_context_field_name fnd_descriptive_flexs_vl.default_context_field_name%TYPE;
9132: l_validate_line VARCHAR2(1) := 'Y';
9133: CURSOR c_check_context(l_flex_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE) IS
9134: SELECT context_required_flag, default_context_field_name

Line 9131: l_default_context_field_name fnd_descriptive_flexs_vl.default_context_field_name%TYPE;

9127: IS
9128: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
9129: --Start of bug#7380336
9130: l_context_required_flag fnd_descriptive_flexs_vl.context_required_flag%TYPE;
9131: l_default_context_field_name fnd_descriptive_flexs_vl.default_context_field_name%TYPE;
9132: l_validate_line VARCHAR2(1) := 'Y';
9133: CURSOR c_check_context(l_flex_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE) IS
9134: SELECT context_required_flag, default_context_field_name
9135: FROM FND_DESCRIPTIVE_FLEXS_VL

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

9129: --Start of bug#7380336
9130: l_context_required_flag fnd_descriptive_flexs_vl.context_required_flag%TYPE;
9131: l_default_context_field_name fnd_descriptive_flexs_vl.default_context_field_name%TYPE;
9132: l_validate_line VARCHAR2(1) := 'Y';
9133: CURSOR c_check_context(l_flex_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE) IS
9134: SELECT context_required_flag, default_context_field_name
9135: FROM FND_DESCRIPTIVE_FLEXS_VL
9136: WHERE (application_id = 660)
9137: AND (descriptive_flexfield_name = l_flex_name); --End of bug#7380336

Line 9135: FROM FND_DESCRIPTIVE_FLEXS_VL

9131: l_default_context_field_name fnd_descriptive_flexs_vl.default_context_field_name%TYPE;
9132: l_validate_line VARCHAR2(1) := 'Y';
9133: CURSOR c_check_context(l_flex_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE) IS
9134: SELECT context_required_flag, default_context_field_name
9135: FROM FND_DESCRIPTIVE_FLEXS_VL
9136: WHERE (application_id = 660)
9137: AND (descriptive_flexfield_name = l_flex_name); --End of bug#7380336
9138:
9139: BEGIN