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

Line 85: update FND_COLUMNS

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

Line 94: from FND_COLUMNS

90: and USER_COLUMN_NAME = x_user_column_name;
91:
92: select max(column_sequence)
93: into maxseq
94: from FND_COLUMNS
95: where APPLICATION_ID = x_application_id
96: and TABLE_ID = x_table_id;
97:
98: update FND_COLUMNS

Line 98: update FND_COLUMNS

94: from FND_COLUMNS
95: where APPLICATION_ID = x_application_id
96: and TABLE_ID = x_table_id;
97:
98: update FND_COLUMNS
99: set COLUMN_SEQUENCE = to_number('200001') + maxseq
100: where APPLICATION_ID = x_application_id
101: and TABLE_ID = x_table_id
102: and COLUMN_NAME <> x_column_name

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

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

Line 218: insert into FND_COLUMNS (

214: ) is
215:
216: begin
217:
218: insert into FND_COLUMNS (
219: APPLICATION_ID,
220: TABLE_ID,
221: COLUMN_ID,
222: COLUMN_NAME,

Line 246: FND_COLUMNS_S.NEXTVAL,

242: LAST_UPDATE_LOGIN)
243: values (
244: x_application_id,
245: x_table_id,
246: FND_COLUMNS_S.NEXTVAL,
247: x_column_name,
248: x_user_column_name,
249: x_column_sequence,
250: x_column_type,

Line 1095: -- Remove column from FND_COLUMNS table.

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

Line 1142: from fnd_columns

1138:
1139: begin
1140: select column_id
1141: into col_id
1142: from fnd_columns
1143: where application_id = appl_id
1144: and table_id = tab_id
1145: and column_name = upper(x_column_name);
1146: exception

Line 1149: fnd_message.set_token('TABLE', 'FND_COLUMNS');

1145: and column_name = upper(x_column_name);
1146: exception
1147: when no_data_found then
1148: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1149: fnd_message.set_token('TABLE', 'FND_COLUMNS');
1150: fnd_message.set_token('COLUMN', 'COLUMN_NAME');
1151: fnd_message.set_token('VALUE', x_column_name);
1152: app_exception.raise_exception;
1153: return;

Line 1210: delete from fnd_columns

1206: app_exception.raise_exception;
1207: return;
1208: end if;
1209:
1210: delete from fnd_columns
1211: where application_id = appl_id
1212: and table_id = tab_id
1213: and column_id = col_id;
1214:

Line 1629: delete from fnd_columns

1625: c_pk.primary_key_name);
1626: end loop;
1627:
1628: -- Remove columns
1629: delete from fnd_columns
1630: where application_id = appl_id
1631: and table_id = tab_id;
1632:
1633: -- Remove table itself

Line 1832: from FND_COLUMNS

1828:
1829: begin
1830: select LAST_UPDATED_BY, LAST_UPDATE_DATE
1831: into db_luby, db_ludate
1832: from FND_COLUMNS
1833: where APPLICATION_ID = appl_id
1834: and TABLE_ID = tab_id
1835: and COLUMN_NAME = x_column_name;
1836:

Line 1840: update FND_COLUMNS set

1836:
1837: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
1838: db_ludate, X_CUSTOM_MODE)) then
1839:
1840: update FND_COLUMNS set
1841: USER_COLUMN_NAME = x_user_column_name,
1842: COLUMN_SEQUENCE = x_column_sequence,
1843: COLUMN_TYPE = x_column_type,
1844: WIDTH = x_width,

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

2326: and I.TABLE_ID = tab_id
2327: and I.INDEX_NAME = x_index_name;
2328:
2329: begin
2330: select C.COLUMN_ID into col_id from FND_COLUMNS C
2331: where C.APPLICATION_ID = appl_id
2332: and C.TABLE_ID = tab_id
2333: and C.COLUMN_NAME = x_index_column_name;
2334: exception

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

2769: and P.TABLE_ID = tab_id
2770: and P.PRIMARY_KEY_NAME = x_primary_key_name;
2771:
2772: begin
2773: select C.COLUMN_ID into col_id from FND_COLUMNS C
2774: where C.APPLICATION_ID = appl_id
2775: and C.TABLE_ID = tab_id
2776: and C.COLUMN_NAME = x_primary_key_column_name;
2777: exception

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

3195: and F.TABLE_ID = tab_id
3196: and F.FOREIGN_KEY_NAME = x_foreign_key_name;
3197:
3198: begin
3199: select C.COLUMN_ID into col_id from FND_COLUMNS C
3200: where C.APPLICATION_ID = appl_id
3201: and C.TABLE_ID = tab_id
3202: and C.COLUMN_NAME = x_foreign_key_column_name;
3203: exception

Line 3718: from fnd_columns fc, fnd_foreign_key_columns fcc

3714: and ft.application_id = a.application_id;
3715:
3716: cursor fkcols(fkapplid number, fktabid number, fkid number) is
3717: select fc.column_name
3718: from fnd_columns fc, fnd_foreign_key_columns fcc
3719: where fcc.foreign_key_id = fkid
3720: and fcc.table_id = fktabid
3721: and fcc.application_id = fkapplid
3722: and fcc.column_id = fc.column_id

Line 4042: from fnd_columns c, fnd_primary_key_columns pc

4038:
4039: -- Validate primary key column name
4040: cursor pkcols(aid number, tid number, pid number) is
4041: select c.column_name
4042: from fnd_columns c, fnd_primary_key_columns pc
4043: where pc.application_id = aid
4044: and pc.table_id = tid
4045: and pc.primary_key_id = pid
4046: and pc.column_id = c.column_id