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_ID_FLEXS

Line 1098: application_id_i fnd_id_flexs.application_id%TYPE;

1094: shorthand_prompt IN VARCHAR2,
1095: shorthand_length IN NUMBER,
1096: flex_num IN NUMBER)
1097: IS
1098: application_id_i fnd_id_flexs.application_id%TYPE;
1099: rowid_i VARCHAR2(64);
1100: BEGIN
1101: message_init;
1102: application_id_i := application_id_f(appl_short_name);

Line 1186: application_id_i fnd_id_flexs.application_id%TYPE;

1182: flex_title IN VARCHAR2 DEFAULT NULL)
1183: RETURN BOOLEAN
1184: IS
1185: cnt NUMBER;
1186: application_id_i fnd_id_flexs.application_id%TYPE;
1187: BEGIN
1188: message_init;
1189: application_id_i := application_id_f(appl_short_name);
1190: SELECT COUNT(*)

Line 1192: FROM fnd_id_flexs

1188: message_init;
1189: application_id_i := application_id_f(appl_short_name);
1190: SELECT COUNT(*)
1191: INTO cnt
1192: FROM fnd_id_flexs
1193: WHERE application_id = application_id_i
1194: AND (id_flex_code = flex_code
1195: OR id_flex_name = flex_title)
1196: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;

Line 1296: FROM fnd_id_flexs idf, fnd_application tap, fnd_tables tab

1292: idf.application_id,
1293: tap.application_id,
1294: tab.table_id
1295: INTO flexfield
1296: FROM fnd_id_flexs idf, fnd_application tap, fnd_tables tab
1297: WHERE idf.application_id = flexfield.application_id
1298: AND id_flex_code = flexfield.flex_code
1299: AND idf.table_application_id = tap.application_id
1300: AND tab.application_id = table_application_id

Line 1330: INTO fnd_id_flexs (application_id,

1326: END IF;
1327:
1328: validate_flexfield(flexfield);
1329: INSERT
1330: INTO fnd_id_flexs (application_id,
1331: id_flex_code,
1332: id_flex_name,
1333:
1334: table_application_id,

Line 2041: UPDATE fnd_id_flexs SET

2037: check_instantiated(original);
2038:
2039: flexfield := compose(original, modified);
2040:
2041: UPDATE fnd_id_flexs SET
2042: id_flex_name = flexfield.flex_title,
2043:
2044: table_application_id = flexfield.table_application_id,
2045: application_table_name = flexfield.table_name,

Line 2163: DELETE FROM fnd_id_flexs

2159: message('error updating fnd_columns');
2160: RAISE;
2161: END;
2162:
2163: DELETE FROM fnd_id_flexs
2164: WHERE application_id = flexfield.application_id
2165: AND id_flex_code = flexfield.flex_code
2166: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;
2167:

Line 3664: l_a_id fnd_id_flexs.application_id%TYPE;

3660: p_table_name IN fnd_tables.table_name%TYPE,
3661: x_message OUT nocopy VARCHAR2) RETURN BOOLEAN
3662: IS
3663: up_table_name fnd_tables.table_name%TYPE := Upper(p_table_name);
3664: l_a_id fnd_id_flexs.application_id%TYPE;
3665: l_flex_code fnd_id_flexs.id_flex_code%TYPE;
3666: l_flex_name fnd_id_flexs.id_flex_name%TYPE;
3667: BEGIN
3668: x_message := 'This table is not used by Key Flexfields.';

Line 3665: l_flex_code fnd_id_flexs.id_flex_code%TYPE;

3661: x_message OUT nocopy VARCHAR2) RETURN BOOLEAN
3662: IS
3663: up_table_name fnd_tables.table_name%TYPE := Upper(p_table_name);
3664: l_a_id fnd_id_flexs.application_id%TYPE;
3665: l_flex_code fnd_id_flexs.id_flex_code%TYPE;
3666: l_flex_name fnd_id_flexs.id_flex_name%TYPE;
3667: BEGIN
3668: x_message := 'This table is not used by Key Flexfields.';
3669: BEGIN

Line 3666: l_flex_name fnd_id_flexs.id_flex_name%TYPE;

3662: IS
3663: up_table_name fnd_tables.table_name%TYPE := Upper(p_table_name);
3664: l_a_id fnd_id_flexs.application_id%TYPE;
3665: l_flex_code fnd_id_flexs.id_flex_code%TYPE;
3666: l_flex_name fnd_id_flexs.id_flex_name%TYPE;
3667: BEGIN
3668: x_message := 'This table is not used by Key Flexfields.';
3669: BEGIN
3670: SELECT application_id, id_flex_code, id_flex_name

Line 3672: FROM fnd_id_flexs

3668: x_message := 'This table is not used by Key Flexfields.';
3669: BEGIN
3670: SELECT application_id, id_flex_code, id_flex_name
3671: INTO l_a_id, l_flex_code, l_flex_name
3672: FROM fnd_id_flexs
3673: WHERE table_application_id = p_application_id
3674: AND Upper(application_table_name) = up_table_name
3675: AND ROWNUM = 1
3676: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;

Line 3688: 'SELECT FROM FND_ID_FLEXS is failed. ' || chr_newline ||

3684: WHEN no_data_found THEN
3685: NULL;
3686: WHEN OTHERS THEN
3687: x_message :=
3688: 'SELECT FROM FND_ID_FLEXS is failed. ' || chr_newline ||
3689: 'SQLERRM : ' || Sqlerrm;
3690: RETURN(TRUE);
3691: END;
3692: RETURN(FALSE);

Line 3709: l_a_id fnd_id_flexs.application_id%TYPE;

3705: x_message OUT nocopy VARCHAR2) RETURN BOOLEAN
3706: IS
3707: up_table_name fnd_tables.table_name%TYPE := Upper(p_table_name);
3708: up_column_name fnd_columns.column_name%TYPE := Upper(p_column_name);
3709: l_a_id fnd_id_flexs.application_id%TYPE;
3710: l_flex_code fnd_id_flexs.id_flex_code%TYPE;
3711: l_flex_name fnd_id_flexs.id_flex_name%TYPE;
3712: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3713: l_segment fnd_id_flex_segments.segment_name%TYPE;

Line 3710: l_flex_code fnd_id_flexs.id_flex_code%TYPE;

3706: IS
3707: up_table_name fnd_tables.table_name%TYPE := Upper(p_table_name);
3708: up_column_name fnd_columns.column_name%TYPE := Upper(p_column_name);
3709: l_a_id fnd_id_flexs.application_id%TYPE;
3710: l_flex_code fnd_id_flexs.id_flex_code%TYPE;
3711: l_flex_name fnd_id_flexs.id_flex_name%TYPE;
3712: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3713: l_segment fnd_id_flex_segments.segment_name%TYPE;
3714: l_seg_att fnd_value_attribute_types.segment_attribute_type%TYPE;

Line 3711: l_flex_name fnd_id_flexs.id_flex_name%TYPE;

3707: up_table_name fnd_tables.table_name%TYPE := Upper(p_table_name);
3708: up_column_name fnd_columns.column_name%TYPE := Upper(p_column_name);
3709: l_a_id fnd_id_flexs.application_id%TYPE;
3710: l_flex_code fnd_id_flexs.id_flex_code%TYPE;
3711: l_flex_name fnd_id_flexs.id_flex_name%TYPE;
3712: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3713: l_segment fnd_id_flex_segments.segment_name%TYPE;
3714: l_seg_att fnd_value_attribute_types.segment_attribute_type%TYPE;
3715: l_val_att fnd_value_attribute_types.value_attribute_type%TYPE;

Line 3716: l_id_col fnd_id_flexs.unique_id_column_name%TYPE;

3712: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3713: l_segment fnd_id_flex_segments.segment_name%TYPE;
3714: l_seg_att fnd_value_attribute_types.segment_attribute_type%TYPE;
3715: l_val_att fnd_value_attribute_types.value_attribute_type%TYPE;
3716: l_id_col fnd_id_flexs.unique_id_column_name%TYPE;
3717: l_set_col fnd_id_flexs.set_defining_column_name%TYPE;
3718: BEGIN
3719: x_message := 'This column is not used by Key Flexfields.';
3720: BEGIN

Line 3717: l_set_col fnd_id_flexs.set_defining_column_name%TYPE;

3713: l_segment fnd_id_flex_segments.segment_name%TYPE;
3714: l_seg_att fnd_value_attribute_types.segment_attribute_type%TYPE;
3715: l_val_att fnd_value_attribute_types.value_attribute_type%TYPE;
3716: l_id_col fnd_id_flexs.unique_id_column_name%TYPE;
3717: l_set_col fnd_id_flexs.set_defining_column_name%TYPE;
3718: BEGIN
3719: x_message := 'This column is not used by Key Flexfields.';
3720: BEGIN
3721: SELECT application_id, id_flex_code, id_flex_name,

Line 3724: FROM fnd_id_flexs

3720: BEGIN
3721: SELECT application_id, id_flex_code, id_flex_name,
3722: unique_id_column_name
3723: INTO l_a_id, l_flex_code, l_flex_name, l_id_col
3724: FROM fnd_id_flexs
3725: WHERE table_application_id = p_application_id
3726: AND Upper(application_table_name) = up_table_name
3727: AND Upper(unique_id_column_name) = up_column_name
3728: AND ROWNUM = 1

Line 3742: 'SELECT FROM FND_ID_FLEXS is failed. ' || chr_newline ||

3738: WHEN no_data_found THEN
3739: NULL;
3740: WHEN OTHERS THEN
3741: x_message :=
3742: 'SELECT FROM FND_ID_FLEXS is failed. ' || chr_newline ||
3743: 'SQLERRM : ' || Sqlerrm;
3744: RETURN(TRUE);
3745: END;
3746: BEGIN

Line 3750: FROM fnd_id_flexs

3746: BEGIN
3747: SELECT application_id, id_flex_code, id_flex_name,
3748: set_defining_column_name
3749: INTO l_a_id, l_flex_code, l_flex_name, l_set_col
3750: FROM fnd_id_flexs
3751: WHERE table_application_id = p_application_id
3752: AND Upper(application_table_name) = up_table_name
3753: AND set_defining_column_name IS NOT NULL
3754: AND Upper(set_defining_column_name) = up_column_name

Line 3769: 'SELECT FROM FND_ID_FLEXS is failed. ' || chr_newline ||

3765: WHEN no_data_found THEN
3766: NULL;
3767: WHEN OTHERS THEN
3768: x_message :=
3769: 'SELECT FROM FND_ID_FLEXS is failed. ' || chr_newline ||
3770: 'SQLERRM : ' || Sqlerrm;
3771: RETURN(TRUE);
3772: END;
3773:

Line 3778: FROM fnd_id_flexs idf, fnd_id_flex_segments ifst

3774: BEGIN
3775: SELECT idf.application_id, idf.id_flex_code,
3776: idf.id_flex_name, ifst.id_flex_num, ifst.segment_name
3777: INTO l_a_id, l_flex_code, l_flex_name, l_flex_num, l_segment
3778: FROM fnd_id_flexs idf, fnd_id_flex_segments ifst
3779: WHERE idf.application_id = ifst.application_id
3780: AND idf.id_flex_code = ifst.id_flex_code
3781: AND idf.table_application_id = p_application_id
3782: AND Upper(idf.application_table_name) = up_table_name

Line 3808: FROM fnd_id_flexs idf, fnd_value_attribute_types vat

3804: BEGIN
3805: SELECT idf.application_id, idf.id_flex_code,
3806: idf.id_flex_name, vat.segment_attribute_type, vat.value_attribute_type
3807: INTO l_a_id, l_flex_code, l_flex_name, l_seg_att, l_val_att
3808: FROM fnd_id_flexs idf, fnd_value_attribute_types vat
3809: WHERE idf.application_id = vat.application_id
3810: AND idf.id_flex_code = vat.id_flex_code
3811: AND idf.table_application_id = p_application_id
3812: AND Upper(idf.application_table_name) = up_table_name

Line 4071: p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE,

4067: -- Deletes compiled definition from fnd_compiled_id_flexs and fnd_compiled_id_flex_structs tables.
4068:
4069: PROCEDURE delete_compiled_definition
4070: (p_application_id IN fnd_application.application_id%TYPE,
4071: p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE,
4072: p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE)
4073: IS
4074: BEGIN
4075: