DBA Data[Home] [Help]

APPS.FND_FLEX_DESCVAL dependencies on FND_DESCRIPTIVE_FLEXS_VL

Line 928: l_default_context_value fnd_descriptive_flexs_vl.default_context_value%TYPE;

924: FUNCTION get_default_context(p_application_short_name IN VARCHAR2,
925: p_descriptive_flexfield_name IN VARCHAR2)
926: RETURN VARCHAR2
927: IS
928: l_default_context_value fnd_descriptive_flexs_vl.default_context_value%TYPE;
929: BEGIN
930: SELECT fdfv.default_context_value
931: INTO l_default_context_value
932: FROM fnd_application fa,

Line 933: fnd_descriptive_flexs_vl fdfv

929: BEGIN
930: SELECT fdfv.default_context_value
931: INTO l_default_context_value
932: FROM fnd_application fa,
933: fnd_descriptive_flexs_vl fdfv
934: WHERE fa.application_short_name = p_application_short_name
935: AND fdfv.application_id = fa.application_id
936: AND fdfv.descriptive_flexfield_name = p_descriptive_flexfield_name;
937:

Line 951: l_default_context_value fnd_descriptive_flexs_vl.default_context_value%TYPE;

947: FUNCTION get_ref_field_context(p_application_short_name IN VARCHAR2,
948: p_descriptive_flexfield_name IN VARCHAR2)
949: RETURN VARCHAR2
950: IS
951: l_default_context_value fnd_descriptive_flexs_vl.default_context_value%TYPE;
952: l_default_context_field_name fnd_descriptive_flexs_vl.default_context_field_name%TYPE;
953: bind_val VARCHAR2(2000);
954:
955: BEGIN

Line 952: l_default_context_field_name fnd_descriptive_flexs_vl.default_context_field_name%TYPE;

948: p_descriptive_flexfield_name IN VARCHAR2)
949: RETURN VARCHAR2
950: IS
951: l_default_context_value fnd_descriptive_flexs_vl.default_context_value%TYPE;
952: l_default_context_field_name fnd_descriptive_flexs_vl.default_context_field_name%TYPE;
953: bind_val VARCHAR2(2000);
954:
955: BEGIN
956: SELECT fdfv.default_context_value, fdfv.default_context_field_name

Line 959: fnd_descriptive_flexs_vl fdfv

955: BEGIN
956: SELECT fdfv.default_context_value, fdfv.default_context_field_name
957: INTO l_default_context_value, l_default_context_field_name
958: FROM fnd_application fa,
959: fnd_descriptive_flexs_vl fdfv
960: WHERE fa.application_short_name = p_application_short_name
961: AND fdfv.application_id = fa.application_id
962: AND fdfv.descriptive_flexfield_name = p_descriptive_flexfield_name;
963: