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.10 2011/12/12 15:31:39 hgeorgi 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 2170: FROM fnd_default_context_fields

2166: AND application_id = application_id_i;
2167: println('deleted from fnd_descriptive_flexs');
2168:
2169: DELETE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2170: FROM fnd_default_context_fields
2171: WHERE application_id = application_id_i
2172: AND descriptive_flexfield_name = flexfield_name;
2173: println('deleted from fnd_default_context_fields');
2174:

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

2169: DELETE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2170: FROM fnd_default_context_fields
2171: WHERE application_id = application_id_i
2172: AND descriptive_flexfield_name = flexfield_name;
2173: println('deleted from fnd_default_context_fields');
2174:
2175: DELETE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2176: FROM fnd_compiled_descriptive_flexs
2177: WHERE application_id = application_id_i

Line 2798: fnd_default_context_fields

2794: WHERE application_id = l_old_application.application_id
2795: AND descriptive_flexfield_name = l_old_dff.descriptive_flexfield_name;
2796:
2797: UPDATE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2798: fnd_default_context_fields
2799: SET application_id = l_new_application.application_id,
2800: descriptive_flexfield_name = p_new_dff_name,
2801: last_update_date = l_last_update_date,
2802: last_updated_by = l_last_updated_by,