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.MSD_VALIDATE dependencies on MSD_AUDIT_SQL_STATEMENTS

Line 139: TYPE SelectRec is record(c1 msd_audit_sql_statements.column1%TYPE,

135: p_token2 in number,
136: p_token3 in number) is
137:
138: TYPE CurTyp is ref cursor;
139: TYPE SelectRec is record(c1 msd_audit_sql_statements.column1%TYPE,
140: c2 msd_audit_sql_statements.column1%TYPE,
141: c3 msd_audit_sql_statements.column1%TYPE,
142: c4 msd_audit_sql_statements.column1%TYPE,
143: c5 msd_audit_sql_statements.column1%TYPE,

Line 140: c2 msd_audit_sql_statements.column1%TYPE,

136: p_token3 in number) is
137:
138: TYPE CurTyp is ref cursor;
139: TYPE SelectRec is record(c1 msd_audit_sql_statements.column1%TYPE,
140: c2 msd_audit_sql_statements.column1%TYPE,
141: c3 msd_audit_sql_statements.column1%TYPE,
142: c4 msd_audit_sql_statements.column1%TYPE,
143: c5 msd_audit_sql_statements.column1%TYPE,
144: c6 msd_audit_sql_statements.column1%TYPE,

Line 141: c3 msd_audit_sql_statements.column1%TYPE,

137:
138: TYPE CurTyp is ref cursor;
139: TYPE SelectRec is record(c1 msd_audit_sql_statements.column1%TYPE,
140: c2 msd_audit_sql_statements.column1%TYPE,
141: c3 msd_audit_sql_statements.column1%TYPE,
142: c4 msd_audit_sql_statements.column1%TYPE,
143: c5 msd_audit_sql_statements.column1%TYPE,
144: c6 msd_audit_sql_statements.column1%TYPE,
145: c7 msd_audit_sql_statements.column1%TYPE,

Line 142: c4 msd_audit_sql_statements.column1%TYPE,

138: TYPE CurTyp is ref cursor;
139: TYPE SelectRec is record(c1 msd_audit_sql_statements.column1%TYPE,
140: c2 msd_audit_sql_statements.column1%TYPE,
141: c3 msd_audit_sql_statements.column1%TYPE,
142: c4 msd_audit_sql_statements.column1%TYPE,
143: c5 msd_audit_sql_statements.column1%TYPE,
144: c6 msd_audit_sql_statements.column1%TYPE,
145: c7 msd_audit_sql_statements.column1%TYPE,
146: c8 msd_audit_sql_statements.column1%TYPE,

Line 143: c5 msd_audit_sql_statements.column1%TYPE,

139: TYPE SelectRec is record(c1 msd_audit_sql_statements.column1%TYPE,
140: c2 msd_audit_sql_statements.column1%TYPE,
141: c3 msd_audit_sql_statements.column1%TYPE,
142: c4 msd_audit_sql_statements.column1%TYPE,
143: c5 msd_audit_sql_statements.column1%TYPE,
144: c6 msd_audit_sql_statements.column1%TYPE,
145: c7 msd_audit_sql_statements.column1%TYPE,
146: c8 msd_audit_sql_statements.column1%TYPE,
147: c9 msd_audit_sql_statements.column1%TYPE,

Line 144: c6 msd_audit_sql_statements.column1%TYPE,

140: c2 msd_audit_sql_statements.column1%TYPE,
141: c3 msd_audit_sql_statements.column1%TYPE,
142: c4 msd_audit_sql_statements.column1%TYPE,
143: c5 msd_audit_sql_statements.column1%TYPE,
144: c6 msd_audit_sql_statements.column1%TYPE,
145: c7 msd_audit_sql_statements.column1%TYPE,
146: c8 msd_audit_sql_statements.column1%TYPE,
147: c9 msd_audit_sql_statements.column1%TYPE,
148: c10 msd_audit_sql_statements.column1%TYPE,

Line 145: c7 msd_audit_sql_statements.column1%TYPE,

141: c3 msd_audit_sql_statements.column1%TYPE,
142: c4 msd_audit_sql_statements.column1%TYPE,
143: c5 msd_audit_sql_statements.column1%TYPE,
144: c6 msd_audit_sql_statements.column1%TYPE,
145: c7 msd_audit_sql_statements.column1%TYPE,
146: c8 msd_audit_sql_statements.column1%TYPE,
147: c9 msd_audit_sql_statements.column1%TYPE,
148: c10 msd_audit_sql_statements.column1%TYPE,
149: c11 msd_audit_sql_statements.column1%TYPE);

Line 146: c8 msd_audit_sql_statements.column1%TYPE,

142: c4 msd_audit_sql_statements.column1%TYPE,
143: c5 msd_audit_sql_statements.column1%TYPE,
144: c6 msd_audit_sql_statements.column1%TYPE,
145: c7 msd_audit_sql_statements.column1%TYPE,
146: c8 msd_audit_sql_statements.column1%TYPE,
147: c9 msd_audit_sql_statements.column1%TYPE,
148: c10 msd_audit_sql_statements.column1%TYPE,
149: c11 msd_audit_sql_statements.column1%TYPE);
150:

Line 147: c9 msd_audit_sql_statements.column1%TYPE,

143: c5 msd_audit_sql_statements.column1%TYPE,
144: c6 msd_audit_sql_statements.column1%TYPE,
145: c7 msd_audit_sql_statements.column1%TYPE,
146: c8 msd_audit_sql_statements.column1%TYPE,
147: c9 msd_audit_sql_statements.column1%TYPE,
148: c10 msd_audit_sql_statements.column1%TYPE,
149: c11 msd_audit_sql_statements.column1%TYPE);
150:
151: p_summary boolean := (p_report_type = '1');

Line 148: c10 msd_audit_sql_statements.column1%TYPE,

144: c6 msd_audit_sql_statements.column1%TYPE,
145: c7 msd_audit_sql_statements.column1%TYPE,
146: c8 msd_audit_sql_statements.column1%TYPE,
147: c9 msd_audit_sql_statements.column1%TYPE,
148: c10 msd_audit_sql_statements.column1%TYPE,
149: c11 msd_audit_sql_statements.column1%TYPE);
150:
151: p_summary boolean := (p_report_type = '1');
152: write_label boolean := FALSE;

Line 149: c11 msd_audit_sql_statements.column1%TYPE);

145: c7 msd_audit_sql_statements.column1%TYPE,
146: c8 msd_audit_sql_statements.column1%TYPE,
147: c9 msd_audit_sql_statements.column1%TYPE,
148: c10 msd_audit_sql_statements.column1%TYPE,
149: c11 msd_audit_sql_statements.column1%TYPE);
150:
151: p_summary boolean := (p_report_type = '1');
152: write_label boolean := FALSE;
153: existing_dp_functionality boolean := FALSE;

Line 175: select * from msd_audit_sql_statements

171: str varchar2(4000);
172: log_str varchar2(4000);
173:
174: cursor statements (c_application_code in varchar2) is
175: select * from msd_audit_sql_statements
176: where function = p_function
177: and application_code = c_application_code
178: and nvl(enabled, 'Y') = 'Y'
179: order by statement_id, STATEMENT_DESCRIPTION;