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_COLUMNS

Line 435: FROM fnd_columns c --, fnd_lookups ct

431:
432: -- check column name in table
433: SELECT NULL
434: INTO dummy
435: FROM fnd_columns c --, fnd_lookups ct
436: WHERE c.application_id = flexfield.table_application_id
437: AND c.table_id = flexfield.table_id
438: AND c.column_name = column_name_in
439: -- AND c.flexfield_application_id = flexfield.application_id

Line 465: application_column_size_i fnd_columns.width%TYPE;

461: structure IN structure_type,
462: segment IN segment_type,
463: vset IN NUMBER)
464: IS
465: application_column_size_i fnd_columns.width%TYPE;
466: application_column_type_i fnd_columns.column_type%TYPE;
467: dummy NUMBER;
468: BEGIN
469: IF(NOT do_validation) THEN

Line 466: application_column_type_i fnd_columns.column_type%TYPE;

462: segment IN segment_type,
463: vset IN NUMBER)
464: IS
465: application_column_size_i fnd_columns.width%TYPE;
466: application_column_type_i fnd_columns.column_type%TYPE;
467: dummy NUMBER;
468: BEGIN
469: IF(NOT do_validation) THEN
470: RETURN;

Line 477: FROM fnd_columns

473: BEGIN
474: SELECT width, column_type
475: INTO application_column_size_i,
476: application_column_type_i
477: FROM fnd_columns
478: WHERE application_id = flexfield.table_application_id
479: AND table_id = flexfield.table_id
480: AND column_name = segment.column_name
481: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;

Line 817: UPDATE fnd_columns SET

813: structure_column IN VARCHAR2)
814: IS
815: BEGIN
816: IF(structure_column IS NOT NULL) THEN
817: UPDATE fnd_columns SET
818: flexfield_usage_code = 'S',
819: -- flexfield_application_id = flexfield.application_id,
820: -- flexfield_name = flexfield.flex_code,
821: last_update_date = last_update_date_i,

Line 842: UPDATE fnd_columns SET

838: PROCEDURE unset_structure_column(flexfield IN flexfield_type)
839: IS
840: BEGIN
841: IF(flexfield.structure_column IS NOT NULL) THEN
842: UPDATE fnd_columns SET
843: flexfield_usage_code = 'N',
844: -- flexfield_application_id = flexfield.application_id,
845: -- flexfield_name = flexfield.flex_code,
846: last_update_date = last_update_date_i,

Line 867: UPDATE fnd_columns SET

863: PROCEDURE set_id_column(flexfield IN flexfield_type,
864: id_column IN VARCHAR2)
865: IS
866: BEGIN
867: UPDATE fnd_columns SET
868: flexfield_usage_code = 'I',
869: -- flexfield_application_id = flexfield.application_id,
870: -- flexfield_name = flexfield.flex_code,
871: last_update_date = last_update_date_i,

Line 890: UPDATE fnd_columns SET

886: /* ---------------------------------------------------------------------- */
887: PROCEDURE unset_id_column(flexfield IN flexfield_type)
888: IS
889: BEGIN
890: UPDATE fnd_columns SET
891: flexfield_usage_code = 'N',
892: -- flexfield_application_id = flexfield.application_id,
893: -- flexfield_name = flexfield.flex_code,
894: last_update_date = last_update_date_i,

Line 1392: UPDATE fnd_columns SET

1388: -- Key flexfield segment columns. These can later be
1389: -- changed in the COLUMN block.
1390: --
1391: IF(enable_columns = 'Y') THEN
1392: UPDATE fnd_columns SET
1393: flexfield_usage_code = 'K',
1394: -- flexfield_application_id = flexfield.application_id,
1395: -- flexfield_name = flexfield.flex_code,
1396: last_update_date = last_update_date_i,

Line 1449: UPDATE fnd_columns SET

1445: message_init;
1446: check_instantiated(flexfield);
1447:
1448: IF(enable_flag = 'Y') THEN
1449: UPDATE fnd_columns SET
1450: flexfield_usage_code = 'K',
1451: -- flexfield_application_id = flexfield.application_id,
1452: -- flexfield_name = flexfield.flex_code,
1453: last_update_date = last_update_date_i,

Line 1458: AND fnd_columns.column_name = enable_column.column_name

1454: last_updated_by = last_updated_by_i,
1455: last_update_login = last_update_login_i
1456: WHERE application_id = flexfield.table_application_id
1457: AND table_id = flexfield.table_id
1458: AND fnd_columns.column_name = enable_column.column_name
1459: AND flexfield_usage_code = 'N'
1460: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;
1461: IF(SQL%notfound) THEN
1462: message('could not acquire column');

Line 1468: UPDATE fnd_columns SET

1464: message(to_string(flexfield));
1465: RAISE no_data_found;
1466: END IF;
1467: ELSE
1468: UPDATE fnd_columns SET
1469: flexfield_usage_code = 'N',
1470: -- flexfield_application_id = NULL,
1471: -- flexfield_name = NULL,
1472: last_update_date = last_update_date_i,

Line 1477: AND fnd_columns.column_name = enable_column.column_name

1473: last_updated_by = last_updated_by_i,
1474: last_update_login = last_update_login_i
1475: WHERE application_id = flexfield.table_application_id
1476: AND table_id = flexfield.table_id
1477: AND fnd_columns.column_name = enable_column.column_name
1478: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;
1479: -- AND flexfield_application_id = flexfield.application_id
1480: -- AND flexfield_name = flexfield.flex_code
1481: IF(SQL%notfound) THEN

Line 1816: -- Check derived_column is registered in fnd_columns and has usage code 'N'

1812: RAISE;
1813: END;
1814:
1815:
1816: -- Check derived_column is registered in fnd_columns and has usage code 'N'
1817: BEGIN
1818: SELECT 1
1819: INTO dummy
1820: FROM dual

Line 1823: FROM fnd_columns c

1819: INTO dummy
1820: FROM dual
1821: WHERE EXISTS
1822: (SELECT 1
1823: FROM fnd_columns c
1824: WHERE c.application_id = flexfield.table_application_id
1825: AND c.table_id = flexfield.table_id
1826: AND c.column_name = derived_column
1827: AND c.flexfield_usage_code = 'N')

Line 1881: -- Mark the qualifier column in fnd_columns.

1877: X_LAST_UPDATE_DATE => last_update_date_i,
1878: X_LAST_UPDATED_BY => last_updated_by_i,
1879: X_LAST_UPDATE_LOGIN => last_update_login_i);
1880:
1881: -- Mark the qualifier column in fnd_columns.
1882: UPDATE fnd_columns
1883: SET flexfield_usage_code = 'Q',
1884: last_update_date = last_update_date_i,
1885: last_updated_by = last_updated_by_i,

Line 1882: UPDATE fnd_columns

1878: X_LAST_UPDATED_BY => last_updated_by_i,
1879: X_LAST_UPDATE_LOGIN => last_update_login_i);
1880:
1881: -- Mark the qualifier column in fnd_columns.
1882: UPDATE fnd_columns
1883: SET flexfield_usage_code = 'Q',
1884: last_update_date = last_update_date_i,
1885: last_updated_by = last_updated_by_i,
1886: last_update_login = last_update_login_i

Line 2145: UPDATE fnd_columns SET

2141: AND id_flex_code = flexfield.flex_code
2142: AND '$Header: AFFFKAIB.pls 120.10.12010000.1 2008/07/25 14:14:04 appldev ship $' IS NOT NULL;
2143:
2144: BEGIN
2145: UPDATE fnd_columns SET
2146: flexfield_usage_code = 'N',
2147: -- flexfield_application_id = NULL,
2148: -- flexfield_name = NULL,
2149: last_update_date = last_update_date_i,

Line 2159: message('error updating fnd_columns');

2155: -- AND flexfield_name = flexfield.flex_code
2156: -- AND flexfield_application_id = flexfield.application_id
2157: EXCEPTION
2158: WHEN OTHERS THEN
2159: message('error updating fnd_columns');
2160: RAISE;
2161: END;
2162:
2163: DELETE FROM fnd_id_flexs

Line 3315: FROM fnd_columns

3311: recurse IN BOOLEAN DEFAULT TRUE)
3312: IS
3313: CURSOR column_c IS
3314: SELECT column_name
3315: FROM fnd_columns
3316: WHERE application_id = flexfield.table_application_id
3317: AND table_id = flexfield.table_id
3318: -- AND flexfield_application_id = flexfield.application_id
3319: -- AND flexfield_name = flexfield.flex_code

Line 3704: p_column_name IN fnd_columns.column_name%TYPE,

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);
3708: up_column_name fnd_columns.column_name%TYPE := Upper(p_column_name);

Line 3708: up_column_name fnd_columns.column_name%TYPE := Upper(p_column_name);

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;
3712: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;