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_DSC_API dependencies on FND_COLUMNS

Line 862: FROM fnd_columns c, fnd_tables t, fnd_descriptive_flexs df

858: -- flexfield
859: BEGIN
860: SELECT /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
861: NULL INTO dummy
862: FROM fnd_columns c, fnd_tables t, fnd_descriptive_flexs df
863: WHERE df.application_id = application_id_in
864: AND df.descriptive_flexfield_name = descriptive_flexfield_name_in
865: AND t.application_id = df.table_application_id
866: AND t.table_name = df.application_table_name

Line 981: ffucode fnd_columns.flexfield_usage_code%TYPE;

977: table_application_id_i fnd_application.application_id%TYPE;
978: application_table_id_i fnd_tables.table_id%TYPE;
979: itisSRS BOOLEAN;
980: numcount NUMBER;
981: ffucode fnd_columns.flexfield_usage_code%TYPE;
982: BEGIN
983: itisSRS := (SUBSTR(flexfield_name,1,6) = '$SRS$.');
984: if (itisSRS is NULL) then
985: itisSRS := FALSE;

Line 1024: FROM fnd_columns

1020: IF (itisSRS) THEN
1021: BEGIN
1022: SELECT /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
1023: flexfield_usage_code INTO ffucode
1024: FROM fnd_columns
1025: WHERE application_id = register.table_application_id_i
1026: AND table_id = register.application_table_id_i
1027: -- AND flexfield_usage_code = 'N'
1028: AND column_name = register.structure_column;

Line 1031: fnd_columns SET

1027: -- AND flexfield_usage_code = 'N'
1028: AND column_name = register.structure_column;
1029: IF (ffucode = 'N') THEN
1030: UPDATE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
1031: fnd_columns SET
1032: flexfield_usage_code = 'C'
1033: WHERE application_id = register.table_application_id_i
1034: AND table_id = register.application_table_id_i
1035: -- AND flexfield_usage_code = 'N'

Line 1046: ': $SRS$ context column is not registered in fnd_columns.');

1042: END IF;
1043: EXCEPTION
1044: WHEN no_data_found THEN
1045: message('column '||structure_column||
1046: ': $SRS$ context column is not registered in fnd_columns.');
1047: RAISE no_data_found;
1048: WHEN OTHERS THEN
1049: message('register : Error in $SRS$. structure column');
1050: RAISE;

Line 1056: fnd_columns SET

1052: ELSE
1053: BEGIN
1054: IF(customer_mode) THEN
1055: UPDATE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
1056: fnd_columns SET
1057: last_update_date = last_update_date_i,
1058: last_updated_by = last_updated_by_i,
1059: last_update_login = last_update_login_i
1060: WHERE application_id = register.table_application_id_i

Line 1072: fnd_columns SET

1068: END IF;
1069: END IF;
1070:
1071: UPDATE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
1072: fnd_columns SET
1073: flexfield_usage_code = 'C',
1074: flexfield_application_id = register.application_id_i,
1075: flexfield_name = register.flexfield_name
1076: WHERE application_id = register.table_application_id_i

Line 1093: fnd_columns SET

1089: -- enable columns named /ATTRIBUTE[0-9]*/
1090: IF (itisSRS) THEN
1091: BEGIN
1092: UPDATE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
1093: fnd_columns SET
1094: flexfield_usage_code = 'D'
1095: WHERE application_id = register.table_application_id_i
1096: AND table_id = register.application_table_id_i
1097: AND flexfield_usage_code = 'N'

Line 1104: FROM fnd_columns

1100: OR (Rtrim(column_name, '0123456789') = 'ATTRIBUTE'));
1101:
1102: SELECT /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
1103: COUNT(*) INTO numcount
1104: FROM fnd_columns
1105: WHERE application_id = register.table_application_id_i
1106: AND table_id = register.application_table_id_i
1107: AND flexfield_usage_code = 'D'
1108: AND column_name LIKE Nvl(enable_columns, 'ATTRIBUTE%')

Line 1125: fnd_columns SET

1121: ELSE
1122: BEGIN
1123: IF(customer_mode) THEN
1124: UPDATE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
1125: fnd_columns SET
1126: last_update_date = register.last_update_date_i,
1127: last_updated_by = register.last_updated_by_i,
1128: last_update_login = register.last_update_login_i
1129: WHERE application_id = register.table_application_id_i

Line 1144: fnd_columns SET

1140:
1141: END IF;
1142:
1143: UPDATE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
1144: fnd_columns SET
1145: flexfield_usage_code = 'D',
1146: flexfield_application_id = register.application_id_i,
1147: flexfield_name = register.flexfield_name
1148: WHERE application_id = register.table_application_id_i

Line 1216: fnd_columns SET

1212: END;
1213: BEGIN
1214: IF(NOT customer_mode) THEN
1215: UPDATE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
1216: fnd_columns SET
1217: flexfield_usage_code = 'D',
1218: flexfield_application_id = application_id_i,
1219: flexfield_name = enable_columns.flexfield_name
1220: WHERE application_id = table_application_id_i

Line 1226: fnd_columns SET

1222: AND flexfield_usage_code = 'N'
1223: AND column_name LIKE pattern;
1224: ELSE
1225: UPDATE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
1226: fnd_columns SET
1227: flexfield_usage_code = 'D',
1228: flexfield_application_id = application_id_i,
1229: flexfield_name = enable_columns.flexfield_name,
1230: last_update_date = last_update_date_i,

Line 1240: message('could not update fnd_columns:' ||

1236: AND column_name LIKE pattern;
1237: END IF;
1238: EXCEPTION
1239: WHEN OTHERS THEN
1240: message('could not update fnd_columns:' ||
1241: Sqlerrm);
1242: RAISE bad_parameter;
1243: END;
1244: END;

Line 1461: fnd_columns.column_type%TYPE;

1457: END;
1458: -- make sure the value set can be used in this segment
1459: DECLARE
1460: application_column_type_i
1461: fnd_columns.column_type%TYPE;
1462: application_column_width_i
1463: fnd_columns.width%TYPE;
1464: application_table_name_i
1465: fnd_descriptive_flexs.application_table_name%TYPE;

Line 1463: fnd_columns.width%TYPE;

1459: DECLARE
1460: application_column_type_i
1461: fnd_columns.column_type%TYPE;
1462: application_column_width_i
1463: fnd_columns.width%TYPE;
1464: application_table_name_i
1465: fnd_descriptive_flexs.application_table_name%TYPE;
1466: BEGIN
1467: -- get information on the table column

Line 1474: FROM fnd_columns c, fnd_tables t, fnd_descriptive_flexs df

1470: c.column_type, c.width,
1471: df.application_table_name
1472: INTO application_column_type_i, application_column_width_i,
1473: application_table_name_i
1474: FROM fnd_columns c, fnd_tables t, fnd_descriptive_flexs df
1475: WHERE c.application_id = t.application_id
1476: AND c.table_id = t.table_id
1477: AND c.column_name = create_segment.column
1478: AND t.table_name = df.application_table_name

Line 1678: l_column_type fnd_columns.column_type%TYPE;

1674: l_flex_value_set_id fnd_descr_flex_col_usage_vl.flex_value_set_id%TYPE;
1675: dummy VARCHAR2(100);
1676: l_segment_name fnd_descr_flex_col_usage_vl.end_user_column_name%TYPE;
1677: l_column_name fnd_descr_flex_col_usage_vl.application_column_name%TYPE;
1678: l_column_type fnd_columns.column_type%TYPE;
1679: l_column_width fnd_columns.width%TYPE;
1680: l_table_name fnd_descriptive_flexs.application_table_name%TYPE;
1681:
1682: l_last_update_login fnd_descr_flex_col_usage_vl.last_update_login%TYPE

Line 1679: l_column_width fnd_columns.width%TYPE;

1675: dummy VARCHAR2(100);
1676: l_segment_name fnd_descr_flex_col_usage_vl.end_user_column_name%TYPE;
1677: l_column_name fnd_descr_flex_col_usage_vl.application_column_name%TYPE;
1678: l_column_type fnd_columns.column_type%TYPE;
1679: l_column_width fnd_columns.width%TYPE;
1680: l_table_name fnd_descriptive_flexs.application_table_name%TYPE;
1681:
1682: l_last_update_login fnd_descr_flex_col_usage_vl.last_update_login%TYPE
1683: := last_update_login_f;

Line 1781: FROM fnd_columns c, fnd_tables t, fnd_descriptive_flexs df

1777: BEGIN
1778: SELECT /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
1779: c.column_type, c.width, df.application_table_name
1780: INTO l_column_type, l_column_width, l_table_name
1781: FROM fnd_columns c, fnd_tables t, fnd_descriptive_flexs df
1782: WHERE c.application_id = t.application_id
1783: AND c.table_id = t.table_id
1784: AND c.column_name = l_column_name
1785: AND t.table_name = df.application_table_name

Line 2064: fnd_columns SET

2060: END;
2061: BEGIN
2062: IF(NOT customer_mode) THEN
2063: UPDATE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2064: fnd_columns SET
2065: flexfield_usage_code = 'N',
2066: flexfield_application_id = NULL,
2067: flexfield_name = NULL
2068: WHERE application_id = table_application_id_i

Line 2074: fnd_columns SET

2070: AND flexfield_usage_code = 'D'
2071: AND column_name LIKE pattern;
2072: ELSE
2073: UPDATE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2074: fnd_columns SET
2075: flexfield_usage_code = 'N',
2076: flexfield_application_id = application_id_i,
2077: flexfield_name = disable_columns.flexfield_name,
2078: last_update_date = last_update_date_i,

Line 2088: message('could not update fnd_columns:' ||

2084: AND column_name LIKE pattern;
2085: END IF;
2086: EXCEPTION
2087: WHEN OTHERS THEN
2088: message('could not update fnd_columns:' ||
2089: Sqlerrm);
2090: RAISE bad_parameter;
2091: END;
2092: END;

Line 2152: fnd_columns SET

2148: WHERE descriptive_flexfield_name = flexfield_name
2149: AND application_id = application_id_i;
2150:
2151: UPDATE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2152: fnd_columns SET
2153: flexfield_usage_code = 'N',
2154: flexfield_name = NULL
2155: WHERE flexfield_name = delete_flexfield.flexfield_name
2156: AND application_id = table_application_id_i;

Line 2157: println('updated fnd_columns');

2153: flexfield_usage_code = 'N',
2154: flexfield_name = NULL
2155: WHERE flexfield_name = delete_flexfield.flexfield_name
2156: AND application_id = table_application_id_i;
2157: println('updated fnd_columns');
2158: EXCEPTION
2159: WHEN no_data_found THEN
2160: NULL;
2161: END;

Line 2562: p_column_name IN fnd_columns.column_name%TYPE,

2558:
2559:
2560: FUNCTION is_column_used(p_application_id IN fnd_tables.application_id%TYPE,
2561: p_table_name IN fnd_tables.table_name%TYPE,
2562: p_column_name IN fnd_columns.column_name%TYPE,
2563: x_message OUT nocopy VARCHAR2) RETURN BOOLEAN
2564: IS
2565: up_table_name fnd_tables.table_name%TYPE := Upper(p_table_name);
2566: up_column_name fnd_columns.column_name%TYPE := Upper(p_column_name);

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

2562: p_column_name IN fnd_columns.column_name%TYPE,
2563: x_message OUT nocopy VARCHAR2) RETURN BOOLEAN
2564: IS
2565: up_table_name fnd_tables.table_name%TYPE := Upper(p_table_name);
2566: up_column_name fnd_columns.column_name%TYPE := Upper(p_column_name);
2567: l_a_id fnd_descriptive_flexs.application_id%TYPE;
2568: l_dff_name fnd_descriptive_flexs.descriptive_flexfield_name%TYPE;
2569: l_context_col fnd_descriptive_flexs.context_column_name%TYPE;
2570: l_context fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE;

Line 2848: fnd_columns

2844: WHERE application_id = l_old_application.application_id
2845: AND descriptive_flexfield_name = l_old_dff.descriptive_flexfield_name;
2846:
2847: UPDATE /* $Header: AFFFDAIB.pls 120.10 2011/12/12 15:31:39 hgeorgi ship $ */
2848: fnd_columns
2849: SET flexfield_application_id = l_new_application.application_id,
2850: flexfield_name = p_new_dff_name,
2851: last_update_date = l_last_update_date,
2852: last_updated_by = l_last_updated_by,

Line 2893: l_column_name fnd_columns.column_name%TYPE;

2889: l_old_table fnd_tbl_type;
2890: l_new_table_app fnd_app_type;
2891: l_new_table fnd_tbl_type;
2892:
2893: l_column_name fnd_columns.column_name%TYPE;
2894: l_error_message VARCHAR2(4000);
2895:
2896: l_error_msg VARCHAR2(4000) := '';
2897: l_last_update_date fnd_descriptive_flexs.last_update_date%TYPE;

Line 2916: FROM fnd_columns old, fnd_columns new

2912: new.width new_width,
2913: new.flexfield_usage_code new_flexfield_usage_code,
2914: new.flexfield_application_id new_flexfield_application_id,
2915: new.flexfield_name new_flexfield_name
2916: FROM fnd_columns old, fnd_columns new
2917: WHERE old.application_id = p_old_table.application_id
2918: AND old.table_id = p_old_table.table_id
2919:
2920: AND old.flexfield_usage_code in ('C', 'D')

Line 3017: UPDATE fnd_columns

3013: l_old_table,
3014: l_new_table)
3015: LOOP
3016: -- Update for the column definition for the new table
3017: UPDATE fnd_columns
3018: SET flexfield_usage_code = rec_columns_reg.old_flexfield_usage_code,
3019: flexfield_application_id = l_dff.application_id,
3020: flexfield_name = l_dff.descriptive_flexfield_name,
3021: last_update_date = l_last_update_date,

Line 3029: UPDATE fnd_columns

3025: AND table_id = l_new_table.table_id
3026: AND column_name = rec_columns_reg.new_column_name;
3027:
3028: -- Update for the column definition for old table
3029: UPDATE fnd_columns
3030: SET flexfield_usage_code = 'N',
3031: flexfield_application_id = NULL,
3032: flexfield_name = NULL,
3033: last_update_date = l_last_update_date,

Line 3084: l_column_type fnd_columns.column_type%TYPE;

3080: dummy VARCHAR2(100);
3081: l_segment_name fnd_descr_flex_col_usage_vl.end_user_column_name%TYPE;
3082: l_column_name
3083: fnd_descr_flex_col_usage_vl.application_column_name%TYPE;
3084: l_column_type fnd_columns.column_type%TYPE;
3085: l_column_width fnd_columns.width%TYPE;
3086: l_table_name fnd_descriptive_flexs.application_table_name%TYPE;
3087:
3088: l_last_update_login fnd_descr_flex_col_usage_vl.last_update_login%TYPE

Line 3085: l_column_width fnd_columns.width%TYPE;

3081: l_segment_name fnd_descr_flex_col_usage_vl.end_user_column_name%TYPE;
3082: l_column_name
3083: fnd_descr_flex_col_usage_vl.application_column_name%TYPE;
3084: l_column_type fnd_columns.column_type%TYPE;
3085: l_column_width fnd_columns.width%TYPE;
3086: l_table_name fnd_descriptive_flexs.application_table_name%TYPE;
3087:
3088: l_last_update_login fnd_descr_flex_col_usage_vl.last_update_login%TYPE
3089: := last_update_login_f;