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_TABLES

Line 766: FUNCTION table_id_f(application_id_in IN fnd_tables.application_id%TYPE,

762: RAISE bad_parameter;
763: END;
764:
765: /* ------------------------------------------------------------ */
766: FUNCTION table_id_f(application_id_in IN fnd_tables.application_id%TYPE,
767: table_name_in IN VARCHAR2)
768: RETURN fnd_tables.table_id%TYPE
769: IS
770: table_id_ret fnd_tables.table_id%TYPE;

Line 768: RETURN fnd_tables.table_id%TYPE

764:
765: /* ------------------------------------------------------------ */
766: FUNCTION table_id_f(application_id_in IN fnd_tables.application_id%TYPE,
767: table_name_in IN VARCHAR2)
768: RETURN fnd_tables.table_id%TYPE
769: IS
770: table_id_ret fnd_tables.table_id%TYPE;
771: BEGIN
772: SELECT table_id

Line 770: table_id_ret fnd_tables.table_id%TYPE;

766: FUNCTION table_id_f(application_id_in IN fnd_tables.application_id%TYPE,
767: table_name_in IN VARCHAR2)
768: RETURN fnd_tables.table_id%TYPE
769: IS
770: table_id_ret fnd_tables.table_id%TYPE;
771: BEGIN
772: SELECT table_id
773: INTO table_id_ret
774: FROM fnd_tables

Line 774: FROM fnd_tables

770: table_id_ret fnd_tables.table_id%TYPE;
771: BEGIN
772: SELECT table_id
773: INTO table_id_ret
774: FROM fnd_tables
775: WHERE table_name = table_name_in
776: AND application_id = application_id_in
777: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;
778: RETURN table_id_ret;

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 2093: message('or fnd_tables information is missing.');

2089: delete_flexfield(flexfield);
2090: EXCEPTION
2091: WHEN no_data_found THEN
2092: message('delete_flexfield: Either this flexfield is already deleted');
2093: message('or fnd_tables information is missing.');
2094: RAISE;
2095: WHEN OTHERS THEN
2096: message('delete_flexfield: ' || Sqlerrm);
2097: RAISE;

Line 3659: FUNCTION is_table_used(p_application_id IN fnd_tables.application_id%TYPE,

3655: message('get_segments: ' || Sqlerrm);
3656: RAISE;
3657: END;
3658:
3659: FUNCTION is_table_used(p_application_id IN fnd_tables.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);

Line 3660: p_table_name IN fnd_tables.table_name%TYPE,

3656: RAISE;
3657: END;
3658:
3659: FUNCTION is_table_used(p_application_id IN fnd_tables.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;

Line 3663: up_table_name fnd_tables.table_name%TYPE := Upper(p_table_name);

3659: FUNCTION is_table_used(p_application_id IN fnd_tables.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

Line 3702: FUNCTION is_column_used(p_application_id IN fnd_tables.application_id%TYPE,

3698: RETURN(TRUE);
3699: END is_table_used;
3700:
3701:
3702: FUNCTION is_column_used(p_application_id IN fnd_tables.application_id%TYPE,
3703: p_table_name IN fnd_tables.table_name%TYPE,
3704: p_column_name IN fnd_columns.column_name%TYPE,
3705: x_message OUT nocopy VARCHAR2) RETURN BOOLEAN
3706: IS

Line 3703: p_table_name IN fnd_tables.table_name%TYPE,

3699: END is_table_used;
3700:
3701:
3702: FUNCTION is_column_used(p_application_id IN fnd_tables.application_id%TYPE,
3703: p_table_name IN fnd_tables.table_name%TYPE,
3704: p_column_name IN fnd_columns.column_name%TYPE,
3705: x_message OUT nocopy VARCHAR2) RETURN BOOLEAN
3706: IS
3707: up_table_name fnd_tables.table_name%TYPE := Upper(p_table_name);

Line 3707: up_table_name fnd_tables.table_name%TYPE := Upper(p_table_name);

3703: p_table_name IN fnd_tables.table_name%TYPE,
3704: p_column_name IN fnd_columns.column_name%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;