APPS.INV_LOT_SEL_ATTR dependencies on FND_DESCRIPTIVE_FLEXS_VL

Line 415: l_context_prompt fnd_descriptive_flexs_vl.form_context_prompt%TYPE; --bug#2474713

411: v_colName VARCHAR2(50);
412: v_value VARCHAR2(200);
413: v_a_name VARCHAR2(50);
414: l_context_column_name VARCHAR2(240); --bug 2474713
415: l_context_prompt fnd_descriptive_flexs_vl.form_context_prompt%TYPE; --bug#2474713
416: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
417:
418: TYPE t_genref is REF CURSOR;
419: default_value_csr t_genref;

Line 724: FROM fnd_application_vl a, fnd_descriptive_flexs_vl df

720:
721:
722: SELECT df.context_required_flag
723: INTO v_dflex_context_flag
724: FROM fnd_application_vl a, fnd_descriptive_flexs_vl df
725: WHERE a.application_short_name = p_application_short_name
726: AND df.application_id = a.application_id
727: AND df.descriptive_flexfield_name = p_flex_name
728: AND a.application_id = df.table_application_id;

Line 767: FROM fnd_application_vl a, fnd_descriptive_flexs_vl df

763: BEGIN
764:
765: SELECT df.context_user_override_flag
766: INTO l_context_override_flag
767: FROM fnd_application_vl a, fnd_descriptive_flexs_vl df
768: WHERE a.application_short_name = p_application_short_name
769: AND df.application_id = a.application_id
770: AND df.descriptive_flexfield_name = p_flex_name
771: AND a.application_id = df.table_application_id;

Line 1017: l_context_prompt fnd_descriptive_flexs_vl.form_context_prompt%TYPE; --bug 6636904

1013:
1014: l_count NUMBER;
1015: l_lot_serial_number VARCHAR2(240) := p_lot_serial_number;
1016: l_column_attributes INV_LOT_SEL_ATTR.LOT_SEL_ATTRIBUTES_TBL_TYPE;
1017: l_context_prompt fnd_descriptive_flexs_vl.form_context_prompt%TYPE; --bug 6636904
1018: l_context_column_name VARCHAR2(240); --bug 2474713
1019: l_module_name VARCHAR2(25) := 'GET_ATTRIBUTE_VALUES';
1020: l_debug_level NUMBER := 9;
1021: l_status VARCHAR2(1);

Line 2123: FROM fnd_application_vl a, fnd_descriptive_flexs_vl df

2119:
2120: BEGIN
2121: SELECT df.context_required_flag
2122: INTO l_context_req_flag
2123: FROM fnd_application_vl a, fnd_descriptive_flexs_vl df
2124: WHERE a.application_short_name = 'INV'
2125: AND df.application_id = a.application_id
2126: AND df.descriptive_flexfield_name = p_flex_name
2127: AND a.application_id = df.table_application_id;