DBA Data[Home] [Help]

APPS.FND_FLEX_DSC_API dependencies on FND_DEFAULT_CONTEXT_FIELDS

Line 819: INTO fnd_default_context_fields(application_id,

815: created_by fnd_flex_value_sets.created_by%TYPE
816: := created_by_f;
817: BEGIN
818: INSERT
819: INTO fnd_default_context_fields(application_id,
820: descriptive_flexfield_name,
821: default_context_field_name,
822: last_update_date,
823: last_updated_by,

Line 940: FROM fnd_default_context_fields

936: -- null is also allowed for the field name
937: IF(context_field_in IS NOT NULL) THEN
938: SELECT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
939: NULL INTO dummy
940: FROM fnd_default_context_fields
941: WHERE application_id = application_id_in
942: AND descriptive_flexfield_name = descriptive_flexfield_name_in
943: AND default_context_field_name = context_field_in;
944: END IF;

Line 947: message('could not locate context field in fnd_default_context_fields:'

943: AND default_context_field_name = context_field_in;
944: END IF;
945: EXCEPTION
946: WHEN no_data_found THEN
947: message('could not locate context field in fnd_default_context_fields:'
948: || context_field_in);
949: RAISE bad_parameter;
950: END;
951:

Line 2169: FROM fnd_default_context_fields

2165: AND application_id = application_id_i;
2166: println('deleted from fnd_descriptive_flexs');
2167:
2168: DELETE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
2169: FROM fnd_default_context_fields
2170: WHERE application_id = application_id_i
2171: AND descriptive_flexfield_name = flexfield_name;
2172: println('deleted from fnd_default_context_fields');
2173:

Line 2172: println('deleted from fnd_default_context_fields');

2168: DELETE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
2169: FROM fnd_default_context_fields
2170: WHERE application_id = application_id_i
2171: AND descriptive_flexfield_name = flexfield_name;
2172: println('deleted from fnd_default_context_fields');
2173:
2174: DELETE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
2175: FROM fnd_compiled_descriptive_flexs
2176: WHERE application_id = application_id_i

Line 2797: fnd_default_context_fields

2793: WHERE application_id = l_old_application.application_id
2794: AND descriptive_flexfield_name = l_old_dff.descriptive_flexfield_name;
2795:
2796: UPDATE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
2797: fnd_default_context_fields
2798: SET application_id = l_new_application.application_id,
2799: descriptive_flexfield_name = p_new_dff_name,
2800: last_update_date = l_last_update_date,
2801: last_updated_by = l_last_updated_by,