DBA Data[Home] [Help]

APPS.OE_VALIDATE_LINE dependencies on FND_DESCRIPTIVE_FLEXS_VL

Line 9618: l_context_required_flag fnd_descriptive_flexs_vl.context_required_flag%TYPE;

9614: )
9615: IS
9616: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
9617: --Start of bug#7380336
9618: l_context_required_flag fnd_descriptive_flexs_vl.context_required_flag%TYPE;
9619: l_default_context_field_name fnd_descriptive_flexs_vl.default_context_field_name%TYPE;
9620: l_validate_line VARCHAR2(1) := 'Y';
9621: l_is_get_item VARCHAR2(1) := 'N'; -- ADDED FOR BUG#8282656
9622: CURSOR c_check_context(l_flex_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE) IS

Line 9619: l_default_context_field_name fnd_descriptive_flexs_vl.default_context_field_name%TYPE;

9615: IS
9616: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
9617: --Start of bug#7380336
9618: l_context_required_flag fnd_descriptive_flexs_vl.context_required_flag%TYPE;
9619: l_default_context_field_name fnd_descriptive_flexs_vl.default_context_field_name%TYPE;
9620: l_validate_line VARCHAR2(1) := 'Y';
9621: l_is_get_item VARCHAR2(1) := 'N'; -- ADDED FOR BUG#8282656
9622: CURSOR c_check_context(l_flex_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE) IS
9623: SELECT context_required_flag, default_context_field_name

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

9618: l_context_required_flag fnd_descriptive_flexs_vl.context_required_flag%TYPE;
9619: l_default_context_field_name fnd_descriptive_flexs_vl.default_context_field_name%TYPE;
9620: l_validate_line VARCHAR2(1) := 'Y';
9621: l_is_get_item VARCHAR2(1) := 'N'; -- ADDED FOR BUG#8282656
9622: CURSOR c_check_context(l_flex_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE) IS
9623: SELECT context_required_flag, default_context_field_name
9624: FROM FND_DESCRIPTIVE_FLEXS_VL
9625: WHERE (application_id = 660)
9626: AND (descriptive_flexfield_name = l_flex_name); --End of bug#7380336

Line 9624: FROM FND_DESCRIPTIVE_FLEXS_VL

9620: l_validate_line VARCHAR2(1) := 'Y';
9621: l_is_get_item VARCHAR2(1) := 'N'; -- ADDED FOR BUG#8282656
9622: CURSOR c_check_context(l_flex_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE) IS
9623: SELECT context_required_flag, default_context_field_name
9624: FROM FND_DESCRIPTIVE_FLEXS_VL
9625: WHERE (application_id = 660)
9626: AND (descriptive_flexfield_name = l_flex_name); --End of bug#7380336
9627:
9628: BEGIN