eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_FLEX_KEY_API dependencies on FND_FLEX_KEY_API

Line 1: PACKAGE BODY fnd_flex_key_api AS

1: PACKAGE BODY fnd_flex_key_api AS
2: /* $Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $ */
3:
4: -- ==================================================
5: -- CACHING

Line 3326: printbuf('flexfield := fnd_flex_key_api.new_flexfield(');

3322: BEGIN
3323: message_init;
3324:
3325: printbuf('/* FLEXFIELD */');
3326: printbuf('flexfield := fnd_flex_key_api.new_flexfield(');
3327: printbuf('appl_short_name => ' || quot(flexfield.appl_short_name) || ',');
3328: printbuf('flex_code => ' || quot(flexfield.flex_code) || ',');
3329: printbuf('flex_title => ' || quot(flexfield.flex_title) || ',');
3330: printbuf('description => ' || quot(flexfield.description) || ',');

Line 3342: printbuf('fnd_flex_key_api.register(flexfield,');

3338: printbuf('concat_seg_len_max => ' || quot(flexfield.concat_seg_len_max) || ',');
3339: printbuf('concat_len_warning => ' || quot(flexfield.concat_len_warning) || ',');
3340: printbuf('concatenated_segs_view_name => ' || quot(flexfield.concatenated_segs_view_name) || ');');
3341:
3342: printbuf('fnd_flex_key_api.register(flexfield,');
3343: printbuf('enable_columns => ''N'');');
3344:
3345: FOR column_r IN column_c LOOP
3346: printbuf('/* ENABLE COLUMN */');

Line 3347: printbuf('fnd_flex_key_api.enable_column(flexfield => flexfield,');

3343: printbuf('enable_columns => ''N'');');
3344:
3345: FOR column_r IN column_c LOOP
3346: printbuf('/* ENABLE COLUMN */');
3347: printbuf('fnd_flex_key_api.enable_column(flexfield => flexfield,');
3348: printbuf('column_name => ' || quot(column_r.column_name) || ');');
3349: END LOOP;
3350:
3351: IF(recurse) THEN

Line 3377: printbuf('fnd_flex_key_api.add_flex_qualifier(flexfield => flexfield,');

3373: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;
3374: BEGIN
3375: FOR flex_qualifier_r IN flex_qualifier_c LOOP
3376: printbuf('/* FLEX QUALIFIER */');
3377: printbuf('fnd_flex_key_api.add_flex_qualifier(flexfield => flexfield,');
3378: printbuf('qualifier_name => ' || quot(flex_qualifier_r.segment_attribute_type) || ',');
3379: printbuf('prompt => ' || quot(flex_qualifier_r.segment_prompt) || ',');
3380: printbuf('description => ' || quot(flex_qualifier_r.description) || ',');
3381: printbuf('global_flag => ' || quot(flex_qualifier_r.global_flag) || ',');

Line 3411: printbuf('fnd_flex_key_api.add_seg_qualifier(flexfield => flexfield,');

3407: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;
3408: BEGIN
3409: FOR seg_qualifier_r IN seg_qualifier_c LOOP
3410: printbuf('/* SEGMENT QUALIFIER */');
3411: printbuf('fnd_flex_key_api.add_seg_qualifier(flexfield => flexfield,');
3412: printbuf('flex_qualifier => ' || quot(flex_qualifier) || ',');
3413: printbuf('qualifier_name => ' || quot(seg_qualifier_r.value_attribute_type) || ',');
3414: printbuf('prompt => ' || quot(seg_qualifier_r.prompt) || ',');
3415: printbuf('description => ' || quot(seg_qualifier_r.description) || ',');

Line 3457: printbuf('structure := fnd_flex_key_api.new_structure(flexfield => flexfield,');

3453: BEGIN
3454: message_init;
3455:
3456: printbuf('/* STRUCTURE */');
3457: printbuf('structure := fnd_flex_key_api.new_structure(flexfield => flexfield,');
3458: printbuf('structure_code => ' || quot(structure.structure_code) || ',');
3459: printbuf('structure_title => ' || quot(structure.structure_name) || ',');
3460: printbuf('description => ' || quot(structure.description) || ',');
3461: printbuf('view_name => ' || quot(structure.view_name) || ',');

Line 3473: printbuf('structure2 := fnd_flex_key_api.find_structure(');

3469: printbuf('shorthand_prompt => ' || quot(structure.shorthand_prompt) || ',');
3470: printbuf('shorthand_length => ' || quot(structure.shorthand_length) || ');');
3471:
3472: IF(structure.structure_number = 101) THEN
3473: printbuf('structure2 := fnd_flex_key_api.find_structure(');
3474: printbuf('flexfield => flexfield,');
3475: printbuf('structure_number => 101);');
3476: printbuf('fnd_flex_key_api.modify_structure(flexfield => flexfield,');
3477: printbuf('original => structure2,');

Line 3476: printbuf('fnd_flex_key_api.modify_structure(flexfield => flexfield,');

3472: IF(structure.structure_number = 101) THEN
3473: printbuf('structure2 := fnd_flex_key_api.find_structure(');
3474: printbuf('flexfield => flexfield,');
3475: printbuf('structure_number => 101);');
3476: printbuf('fnd_flex_key_api.modify_structure(flexfield => flexfield,');
3477: printbuf('original => structure2,');
3478: printbuf('modified => structure);');
3479: ELSE
3480: printbuf('fnd_flex_key_api.add_structure(flexfield => flexfield,');

Line 3480: printbuf('fnd_flex_key_api.add_structure(flexfield => flexfield,');

3476: printbuf('fnd_flex_key_api.modify_structure(flexfield => flexfield,');
3477: printbuf('original => structure2,');
3478: printbuf('modified => structure);');
3479: ELSE
3480: printbuf('fnd_flex_key_api.add_structure(flexfield => flexfield,');
3481: printbuf('structure => structure);');
3482: END IF;
3483:
3484: IF(recurse) THEN

Line 3520: printbuf('fnd_flex_key_api.assign_qualifier(');

3516: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;
3517: BEGIN
3518: FOR assignments_r IN assignments_c LOOP
3519: printbuf('/* QUALIFIER ASSIGNMENT */');
3520: printbuf('fnd_flex_key_api.assign_qualifier(');
3521: printbuf('flexfield => flexfield,' );
3522: printbuf('structure => structure,' );
3523: printbuf('segment => segment,');
3524: printbuf('flexfield_qualifier => ' ||

Line 3543: printbuf('segment := fnd_flex_key_api.new_segment(');

3539: BEGIN
3540: message_init;
3541:
3542: printbuf('/* SEGMENT */');
3543: printbuf('segment := fnd_flex_key_api.new_segment(');
3544: printbuf('flexfield => flexfield,');
3545: printbuf('structure => structure,');
3546: printbuf('segment_name => ' || quot(segment.segment_name) || ',');
3547: printbuf('description => ' || quot(segment.description) || ',');

Line 3567: printbuf('fnd_flex_key_api.add_segment(flexfield => flexfield,');

3563: printbuf('window_prompt => ' || quot(segment.window_prompt) || ',');
3564: printbuf('runtime_property_function => ' || quot(segment.runtime_property_function) || ',');
3565: printbuf('additional_where_clause => ' || quot(segment.additional_where_clause) || ');');
3566:
3567: printbuf('fnd_flex_key_api.add_segment(flexfield => flexfield,');
3568: printbuf('structure => structure,');
3569: printbuf('segment => segment);');
3570:
3571: dump_qualifier_assignments(flexfield => flexfield,

Line 3696: 'FND_FLEX_KEY_API.IS_TABLE_USED is failed. ' || chr_newline ||

3692: RETURN(FALSE);
3693: EXCEPTION
3694: WHEN OTHERS THEN
3695: x_message :=
3696: 'FND_FLEX_KEY_API.IS_TABLE_USED is failed. ' || chr_newline ||
3697: 'SQLERRM : ' || Sqlerrm;
3698: RETURN(TRUE);
3699: END is_table_used;
3700:

Line 3837: 'FND_FLEX_KEY_API.IS_COLUMN_USED is failed. ' || chr_newline ||

3833: RETURN(FALSE);
3834: EXCEPTION
3835: WHEN OTHERS THEN
3836: x_message :=
3837: 'FND_FLEX_KEY_API.IS_COLUMN_USED is failed. ' || chr_newline ||
3838: 'SQLERRM : ' || Sqlerrm;
3839: RETURN(TRUE);
3840: END is_column_used;
3841:

Line 4438: END fnd_flex_key_api;

4434: fnd_plsql_cache.generic_1to1_init('KAI.SOQ',
4435: soq_cache_controller,
4436: soq_cache_storage);
4437:
4438: END fnd_flex_key_api;