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.AK_FOREIGN_KEYS_PKG dependencies on AK_FOREIGN_KEY_COLUMNS

Line 164: cursor C is select ROWID from AK_FOREIGN_KEY_COLUMNS

160: X_ATTRIBUTE13 in VARCHAR2,
161: X_ATTRIBUTE14 in VARCHAR2,
162: X_ATTRIBUTE15 in VARCHAR2
163: ) is
164: cursor C is select ROWID from AK_FOREIGN_KEY_COLUMNS
165: where FOREIGN_KEY_NAME = X_FOREIGN_KEY_NAME;
166: begin
167: insert into AK_FOREIGN_KEY_COLUMNS (
168: FOREIGN_KEY_NAME,

Line 167: insert into AK_FOREIGN_KEY_COLUMNS (

163: ) is
164: cursor C is select ROWID from AK_FOREIGN_KEY_COLUMNS
165: where FOREIGN_KEY_NAME = X_FOREIGN_KEY_NAME;
166: begin
167: insert into AK_FOREIGN_KEY_COLUMNS (
168: FOREIGN_KEY_NAME,
169: ATTRIBUTE_APPLICATION_ID,
170: ATTRIBUTE_CODE,
171: FOREIGN_KEY_SEQUENCE,

Line 431: from AK_FOREIGN_KEY_COLUMNS

427: ATTRIBUTE12,
428: ATTRIBUTE13,
429: ATTRIBUTE14,
430: ATTRIBUTE15
431: from AK_FOREIGN_KEY_COLUMNS
432: where FOREIGN_KEY_NAME = X_FOREIGN_KEY_NAME
433: and FOREIGN_KEY_SEQUENCE = X_FOREIGN_KEY_SEQUENCE
434: for update of FOREIGN_KEY_NAME nowait;
435: recinfo c%rowtype;

Line 605: update AK_FOREIGN_KEY_COLUMNS set

601: X_ATTRIBUTE14 in VARCHAR2,
602: X_ATTRIBUTE15 in VARCHAR2
603: ) is
604: begin
605: update AK_FOREIGN_KEY_COLUMNS set
606: ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID,
607: ATTRIBUTE_CODE = X_ATTRIBUTE_CODE,
608: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
609: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 660: delete from AK_FOREIGN_KEY_COLUMNS

656: X_FOREIGN_KEY_SEQUENCE in NUMBER
657: ) is
658: begin
659: if X_FOREIGN_KEY_SEQUENCE is null then
660: delete from AK_FOREIGN_KEY_COLUMNS
661: where FOREIGN_KEY_NAME = X_FOREIGN_KEY_NAME
662: and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
663: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
664: else

Line 665: delete from AK_FOREIGN_KEY_COLUMNS

661: where FOREIGN_KEY_NAME = X_FOREIGN_KEY_NAME
662: and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
663: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;
664: else
665: delete from AK_FOREIGN_KEY_COLUMNS
666: where FOREIGN_KEY_NAME = X_FOREIGN_KEY_NAME
667: and FOREIGN_KEY_SEQUENCE = X_FOREIGN_KEY_SEQUENCE;
668: end if;
669: