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_AUDIT_UPDATE_PKG dependencies on AD_DDL

Line 97: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.alter_table, v_ddl_sql, v_shadname);

93: WHERE application_id = p_taplid;
94:
95: -- Copy the Shadow Table over to saved copy
96: v_ddl_sql := 'alter table ' || v_owner ||'.' || v_shadname || ' rename to ' || v_oldtname;
97: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.alter_table, v_ddl_sql, v_shadname);
98:
99: -- Drop Associated Synonyms
100: v_ddl_sql := 'drop synonym ' || v_shadname;
101: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_synonym, v_ddl_sql, v_shadname);

Line 101: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_synonym, v_ddl_sql, v_shadname);

97: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.alter_table, v_ddl_sql, v_shadname);
98:
99: -- Drop Associated Synonyms
100: v_ddl_sql := 'drop synonym ' || v_shadname;
101: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_synonym, v_ddl_sql, v_shadname);
102:
103: -- Create Associated Synonyms
104: v_ddl_sql := 'create synonym '|| v_oldtname || ' for ' || v_owner ||'.' || v_oldtname;
105: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.create_synonym, v_ddl_sql, v_shadname);

Line 105: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.create_synonym, v_ddl_sql, v_shadname);

101: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_synonym, v_ddl_sql, v_shadname);
102:
103: -- Create Associated Synonyms
104: v_ddl_sql := 'create synonym '|| v_oldtname || ' for ' || v_owner ||'.' || v_oldtname;
105: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.create_synonym, v_ddl_sql, v_shadname);
106:
107: -- Alter Table and add the row_key
108: v_ddl_sql := 'alter table '|| v_owner ||'.'|| v_oldtname || ' add (row_key number)';
109: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.alter_table, v_ddl_sql, v_shadname);

Line 109: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.alter_table, v_ddl_sql, v_shadname);

105: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.create_synonym, v_ddl_sql, v_shadname);
106:
107: -- Alter Table and add the row_key
108: v_ddl_sql := 'alter table '|| v_owner ||'.'|| v_oldtname || ' add (row_key number)';
109: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.alter_table, v_ddl_sql, v_shadname);
110:
111: -- Update Table for row_key
112: v_updatetable := 'update '|| v_owner ||'.'|| v_oldtname || ' set row_key = ' ||
113: '(TO_NUMBER(TO_CHAR(AUDIT_TIMESTAMP,''YYYYMMDDHH24MISS''))'

Line 124: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.create_table, v_createtable, v_tname);

120: v_createtable := v_createtable || ', ' || l_get_col_rec.column_name;
121: end loop;
122: v_createtable := v_createtable || ' from '|| v_owner ||'.'|| v_oldtname || ')';
123:
124: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.create_table, v_createtable, v_tname);
125:
126: -- Error checking
127: execute immediate ('select count(*) from '|| v_owner ||'.'|| v_tname) into tcount;
128: execute immediate ('select count(*) from '|| v_owner ||'.'|| v_oldtname) into toldcount;

Line 134: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_table, v_ddl_sql, v_oldtname);

130: if (tcount = toldcount) then
131:
132: -- Drop the copy of shadow table
133: v_ddl_sql := 'drop table '|| v_owner ||'.'|| v_oldtname;
134: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_table, v_ddl_sql, v_oldtname);
135:
136: -- Drop the synonym to the copy of shadow table
137: v_ddl_sql := 'drop synonym '|| v_oldtname;
138: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_synonym, v_ddl_sql, v_oldtname);

Line 138: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_synonym, v_ddl_sql, v_oldtname);

134: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_table, v_ddl_sql, v_oldtname);
135:
136: -- Drop the synonym to the copy of shadow table
137: v_ddl_sql := 'drop synonym '|| v_oldtname;
138: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_synonym, v_ddl_sql, v_oldtname);
139:
140: if (v_longflag = 'Y') then
141: -- Drop the procedurea, triggers, views from renamed shadow table
142: v_ddl_sql := 'drop procedure '|| v_shadname || 'IP';

Line 143: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);

139:
140: if (v_longflag = 'Y') then
141: -- Drop the procedurea, triggers, views from renamed shadow table
142: v_ddl_sql := 'drop procedure '|| v_shadname || 'IP';
143: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);
144:
145: v_ddl_sql := 'drop procedure '|| v_shadname || 'UP';
146: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);
147:

Line 146: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);

142: v_ddl_sql := 'drop procedure '|| v_shadname || 'IP';
143: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);
144:
145: v_ddl_sql := 'drop procedure '|| v_shadname || 'UP';
146: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);
147:
148: v_ddl_sql := 'drop procedure '|| v_shadname || 'DP';
149: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);
150:

Line 149: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);

145: v_ddl_sql := 'drop procedure '|| v_shadname || 'UP';
146: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);
147:
148: v_ddl_sql := 'drop procedure '|| v_shadname || 'DP';
149: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);
150:
151: v_ddl_sql := 'drop trigger ' || v_shadname || 'D';
152: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);
153:

Line 152: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);

148: v_ddl_sql := 'drop procedure '|| v_shadname || 'DP';
149: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);
150:
151: v_ddl_sql := 'drop trigger ' || v_shadname || 'D';
152: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);
153:
154: v_ddl_sql := 'drop trigger ' || v_shadname || 'I';
155: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);
156:

Line 155: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);

151: v_ddl_sql := 'drop trigger ' || v_shadname || 'D';
152: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);
153:
154: v_ddl_sql := 'drop trigger ' || v_shadname || 'I';
155: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);
156:
157: v_ddl_sql := 'drop trigger ' || v_shadname || 'U';
158: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);
159:

Line 158: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);

154: v_ddl_sql := 'drop trigger ' || v_shadname || 'I';
155: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);
156:
157: v_ddl_sql := 'drop trigger ' || v_shadname || 'U';
158: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);
159:
160: v_ddl_sql := 'drop trigger ' || v_shadname || 'H';
161: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);
162:

Line 161: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);

157: v_ddl_sql := 'drop trigger ' || v_shadname || 'U';
158: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);
159:
160: v_ddl_sql := 'drop trigger ' || v_shadname || 'H';
161: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);
162:
163: v_ddl_sql := 'drop trigger ' || v_shadname || 'T';
164: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);
165:

Line 164: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);

160: v_ddl_sql := 'drop trigger ' || v_shadname || 'H';
161: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);
162:
163: v_ddl_sql := 'drop trigger ' || v_shadname || 'T';
164: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);
165:
166: v_ddl_sql := 'drop trigger ' || v_shadname || 'C';
167: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);
168:

Line 167: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);

163: v_ddl_sql := 'drop trigger ' || v_shadname || 'T';
164: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);
165:
166: v_ddl_sql := 'drop trigger ' || v_shadname || 'C';
167: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);
168:
169: v_ddl_sql := 'drop view ' || v_shadname || 'C1';
170: v_viewname := v_shadname || 'C1';
171: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_view, v_ddl_sql, v_viewname);

Line 171: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_view, v_ddl_sql, v_viewname);

167: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_trigger, v_ddl_sql, v_shadname);
168:
169: v_ddl_sql := 'drop view ' || v_shadname || 'C1';
170: v_viewname := v_shadname || 'C1';
171: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_view, v_ddl_sql, v_viewname);
172:
173: v_ddl_sql := 'drop view ' || v_shadname || 'V1';
174: v_viewname := v_shadname || 'V1';
175: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_view, v_ddl_sql, v_viewname);

Line 175: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_view, v_ddl_sql, v_viewname);

171: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_view, v_ddl_sql, v_viewname);
172:
173: v_ddl_sql := 'drop view ' || v_shadname || 'V1';
174: v_viewname := v_shadname || 'V1';
175: ad_ddl.do_ddl( v_fnd_schema, app_short_name, ad_ddl.drop_view, v_ddl_sql, v_viewname);
176:
177: end if;
178: else
179: null;

Line 193: fnd_message.set_token('SQLSTMT', ad_ddl.error_buf, FALSE);

189: fnd_message.set_token('ERRNO', sqlcode, FALSE);
190: fnd_message.set_token('ROUTINE', 'fnd_audit_row_key', FALSE);
191: fnd_message.set_token('REASON', sqlerrm, FALSE);
192: fnd_message.set_token('ERRFILE', 'fdaaddrk.pls', FALSE);
193: fnd_message.set_token('SQLSTMT', ad_ddl.error_buf, FALSE);
194: app_exception.raise_exception;
195:
196: end FND_AUDIT_ROW_KEY;
197: