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

Line 81: update FND_COLUMNS

77: maxseq number;
78: begin
79:
80: -- If there is no row updated, no exception will be raise.
81: update FND_COLUMNS
82: set USER_COLUMN_NAME = '@'||USER_COLUMN_NAME
83: where APPLICATION_ID = x_application_id
84: and TABLE_ID = x_table_id
85: and COLUMN_NAME <> x_column_name

Line 90: from FND_COLUMNS

86: and USER_COLUMN_NAME = x_user_column_name;
87:
88: select max(column_sequence)
89: into maxseq
90: from FND_COLUMNS
91: where APPLICATION_ID = x_application_id
92: and TABLE_ID = x_table_id;
93:
94: update FND_COLUMNS

Line 94: update FND_COLUMNS

90: from FND_COLUMNS
91: where APPLICATION_ID = x_application_id
92: and TABLE_ID = x_table_id;
93:
94: update FND_COLUMNS
95: set COLUMN_SEQUENCE = to_number('200001') + maxseq
96: where APPLICATION_ID = x_application_id
97: and TABLE_ID = x_table_id
98: and COLUMN_NAME <> x_column_name

Line 183: -- Add a new column into FND_COLUMNS. This is only called after checking

179: end InsertTable;
180:
181: --
182: -- InsertColumn (PRIVATE))
183: -- Add a new column into FND_COLUMNS. This is only called after checking
184: -- there is no such column exists in UploadColumn().
185: --
186: procedure InsertColumn (
187: x_application_id in number,

Line 214: insert into FND_COLUMNS (

210: ) is
211:
212: begin
213:
214: insert into FND_COLUMNS (
215: APPLICATION_ID,
216: TABLE_ID,
217: COLUMN_ID,
218: COLUMN_NAME,

Line 242: FND_COLUMNS_S.NEXTVAL,

238: LAST_UPDATE_LOGIN)
239: values (
240: x_application_id,
241: x_table_id,
242: FND_COLUMNS_S.NEXTVAL,
243: x_column_name,
244: x_user_column_name,
245: x_column_sequence,
246: x_column_type,

Line 1093: -- Remove column from FND_COLUMNS table.

1089: end ViewTextLength;
1090:
1091: --
1092: -- RemoveColumn (PUBLIC)
1093: -- Remove column from FND_COLUMNS table.
1094: -- Before removing this column, make sure that there is no index,
1095: -- primary key or foreign key is using this column
1096: --
1097: procedure RemoveColumn(

Line 1138: from fnd_columns

1134:
1135: begin
1136: select column_id
1137: into col_id
1138: from fnd_columns
1139: where application_id = appl_id
1140: and table_id = tab_id
1141: and column_name = upper(x_column_name);
1142: exception

Line 1145: -20001, 'Fnd columns '

1141: and column_name = upper(x_column_name);
1142: exception
1143: when no_data_found then
1144: RAISE_APPLICATION_ERROR(
1145: -20001, 'Fnd columns '
1146: || x_column_name
1147: || ' not found in the table fnd_columns ', TRUE);
1148: return;
1149: end;

Line 1147: || ' not found in the table fnd_columns ', TRUE);

1143: when no_data_found then
1144: RAISE_APPLICATION_ERROR(
1145: -20001, 'Fnd columns '
1146: || x_column_name
1147: || ' not found in the table fnd_columns ', TRUE);
1148: return;
1149: end;
1150:
1151: -- Before removing this column, make sure that there is no index,

Line 1205: delete from fnd_columns

1201: || ' foreign key column ', TRUE);
1202: return;
1203: end if;
1204:
1205: delete from fnd_columns
1206: where application_id = appl_id
1207: and table_id = tab_id
1208: and column_id = col_id;
1209:

Line 1594: delete from fnd_columns

1590: c_pk.primary_key_name);
1591: end loop;
1592:
1593: -- Remove columns
1594: delete from fnd_columns
1595: where application_id = appl_id
1596: and table_id = tab_id;
1597:
1598: -- Remove table itself

Line 1799: from FND_COLUMNS

1795:
1796: begin
1797: select LAST_UPDATED_BY, LAST_UPDATE_DATE
1798: into db_luby, db_ludate
1799: from FND_COLUMNS
1800: where APPLICATION_ID = appl_id
1801: and TABLE_ID = tab_id
1802: and COLUMN_NAME = x_column_name;
1803:

Line 1807: update FND_COLUMNS set

1803:
1804: if (upload_test(f_luby, f_ludate, db_luby,
1805: db_ludate, X_CUSTOM_MODE)) then
1806:
1807: update FND_COLUMNS set
1808: USER_COLUMN_NAME = x_user_column_name,
1809: COLUMN_SEQUENCE = x_column_sequence,
1810: COLUMN_TYPE = x_column_type,
1811: WIDTH = x_width,

Line 2394: select C.COLUMN_ID into col_id from FND_COLUMNS C

2390: and I.TABLE_ID = tab_id
2391: and I.INDEX_NAME = x_index_name;
2392:
2393: begin
2394: select C.COLUMN_ID into col_id from FND_COLUMNS C
2395: where C.APPLICATION_ID = appl_id
2396: and C.TABLE_ID = tab_id
2397: and C.COLUMN_NAME = x_index_column_name;
2398: exception

Line 2853: select C.COLUMN_ID into col_id from FND_COLUMNS C

2849: and P.TABLE_ID = tab_id
2850: and P.PRIMARY_KEY_NAME = x_primary_key_name;
2851:
2852: begin
2853: select C.COLUMN_ID into col_id from FND_COLUMNS C
2854: where C.APPLICATION_ID = appl_id
2855: and C.TABLE_ID = tab_id
2856: and C.COLUMN_NAME = x_primary_key_column_name;
2857: exception

Line 2860: -20001, 'No data found Fnd columns column name '

2856: and C.COLUMN_NAME = x_primary_key_column_name;
2857: exception
2858: when no_data_found then
2859: RAISE_APPLICATION_ERROR(
2860: -20001, 'No data found Fnd columns column name '
2861: || x_primary_key_column_name || ' object type - primary key '
2862: || x_primary_key_name, TRUE);
2863: end;
2864:

Line 3270: select C.COLUMN_ID into col_id from FND_COLUMNS C

3266: and F.TABLE_ID = tab_id
3267: and F.FOREIGN_KEY_NAME = x_foreign_key_name;
3268:
3269: begin
3270: select C.COLUMN_ID into col_id from FND_COLUMNS C
3271: where C.APPLICATION_ID = appl_id
3272: and C.TABLE_ID = tab_id
3273: and C.COLUMN_NAME = x_foreign_key_column_name;
3274: exception

Line 3277: -20001, 'No data found Fnd columns column name '

3273: and C.COLUMN_NAME = x_foreign_key_column_name;
3274: exception
3275: when no_data_found then
3276: RAISE_APPLICATION_ERROR(
3277: -20001, 'No data found Fnd columns column name '
3278: || x_foreign_key_column_name || ' object type - foreign key '
3279: || x_foreign_key_name, TRUE);
3280: end;
3281: