DBA Data[Home] [Help]

APPS.FND_FLEX_DSC_API dependencies on FND_DESCRIPTIVE_FLEXS_TL

Line 477: println('inserting into fnd_descriptive flexs tl');

473: := created_by_f;
474: BEGIN
475: FOR lang_rec IN lang_cur
476: LOOP
477: println('inserting into fnd_descriptive flexs tl');
478: println('application_id ='|| application_id);
479: println('descriptive_flexfield_name ='|| descriptive_flexfield_name);
480: println('title ='|| title);
481: println('form_context_prompt ='|| form_context_prompt);

Line 484: INTO fnd_descriptive_flexs_tl(application_id,

480: println('title ='|| title);
481: println('form_context_prompt ='|| form_context_prompt);
482: println('lang_rec.language_code ='|| lang_rec.language_code);
483: INSERT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
484: INTO fnd_descriptive_flexs_tl(application_id,
485: descriptive_flexfield_name,
486: title,
487: description,
488: form_context_prompt,

Line 508: -- println('inserted into fnd_descriptive_flexs_tl');

504: creation_date,
505: created_by,
506: last_update_login,
507: userenv('LANG'));
508: -- println('inserted into fnd_descriptive_flexs_tl');
509: END LOOP;
510: EXCEPTION
511: WHEN dup_val_on_index THEN
512: message('insert failed - duplicate language, flexfield name, or application id');

Line 1296: fnd_descriptive_flexs_tl

1292: p_context_override_value_set_i => l_context_override_value_set_i,
1293: p_context_runtime_property_fun => context_runtime_property_funct);
1294: IF(prompt IS NOT NULL) THEN
1295: UPDATE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
1296: fnd_descriptive_flexs_tl
1297: SET
1298: form_context_prompt = prompt
1299: WHERE application_id = application_id_i
1300: AND descriptive_flexfield_name = flexfield_name;

Line 2136: FROM fnd_descriptive_flexs_tl

2132: END;
2133:
2134: BEGIN
2135: DELETE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
2136: FROM fnd_descriptive_flexs_tl
2137: WHERE descriptive_flexfield_name = delete_flexfield.flexfield_name
2138: AND application_id = application_id_i;
2139: println('deleted from fnd_descriptive_flexs_tl');
2140: END;

Line 2139: println('deleted from fnd_descriptive_flexs_tl');

2135: DELETE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
2136: FROM fnd_descriptive_flexs_tl
2137: WHERE descriptive_flexfield_name = delete_flexfield.flexfield_name
2138: AND application_id = application_id_i;
2139: println('deleted from fnd_descriptive_flexs_tl');
2140: END;
2141:
2142: BEGIN
2143: SELECT /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */

Line 2787: fnd_descriptive_flexs_tl

2783: WHERE application_id = l_old_application.application_id
2784: AND descriptive_flexfield_name = l_old_dff.descriptive_flexfield_name;
2785:
2786: UPDATE /* $Header: AFFFDAIB.pls 120.8.12010000.1 2008/07/25 14:13:39 appldev ship $ */
2787: fnd_descriptive_flexs_tl
2788: SET application_id = l_new_application.application_id,
2789: descriptive_flexfield_name = p_new_dff_name,
2790: last_update_date = l_last_update_date,
2791: last_updated_by = l_last_updated_by,