The following lines contain the word 'select', 'insert', 'update' or 'delete':
insert into msd_test values(p_text);*/
/*insert into msd_test values(p_text);*/
select DECODE(p_detail,'1','2','2','1') into lv_report_type from DUAL;
TYPE SelectRec is record(c1 msd_audit_sql_statements.column1%TYPE,
c2 msd_audit_sql_statements.column1%TYPE,
c3 msd_audit_sql_statements.column1%TYPE,
c4 msd_audit_sql_statements.column1%TYPE,
c5 msd_audit_sql_statements.column1%TYPE,
c6 msd_audit_sql_statements.column1%TYPE,
c7 msd_audit_sql_statements.column1%TYPE,
c8 msd_audit_sql_statements.column1%TYPE,
c9 msd_audit_sql_statements.column1%TYPE,
c10 msd_audit_sql_statements.column1%TYPE,
c11 msd_audit_sql_statements.column1%TYPE);
selrow SelectRec;
select * from msd_audit_sql_statements
where function = p_function
and application_code = c_application_code
and nvl(enabled, 'Y') = 'Y'
order by statement_id, STATEMENT_DESCRIPTION;
SELECT DECODE( M2A_DBLINK, NULL, NULL_DBLINK, '@'||M2A_DBLINK||' ') M2A_DBLINK,
INSTANCE_TYPE, apps_ver,
DECODE( A2M_DBLINK, NULL, NULL_DBLINK, '@'||A2M_DBLINK||' ') A2M_DBLINK,
instance_code,
instance_id
FROM MSC_APPS_INSTANCES
where instance_id = decode(c_instance_id, -1, instance_id,
0, instance_id,
c_instance_id);
SELECT DECODE( M2A_DBLINK, NULL, NULL_DBLINK, '@'||M2A_DBLINK||' '),
INSTANCE_TYPE, apps_ver,
DECODE( A2M_DBLINK, NULL, NULL_DBLINK, '@'||A2M_DBLINK||' '),
instance_code
INTO v_m2a_dblink,
v_instance_type, v_apps_ver,
v_a2m_dblink,
v_instance_code
FROM MSC_APPS_INSTANCES
WHERE INSTANCE_ID= p_INSTANCE_ID;
SELECT FND_GLOBAL.USER_NAME,
FND_GLOBAL.RESP_NAME,
FND_GLOBAL.APPLICATION_NAME
INTO v_user_name,
v_resp_name,
v_application_name
FROM dual;
select meaning
into v_function_name
from fnd_lookup_values_vl
where lookup_type = 'MSD_AUDIT_REPORT'
and lookup_code = p_function;
'SELECT ' ||
get_td_tag('msd_validate.get_translated_string(' ||
'''' || s.summary_message || ''', ' ||
'''' || v_application_code || ''', ' ||
'''' || s.summary_token1 || ''', ' ||
nvl(s.summary_token1_value,'''''') || ', ' ||
'''' || s.summary_token2 || ''', ' ||
nvl(s.summary_token2_value,'''''') || ', ' ||
'''' || s.summary_token3 || ''', ' ||
nvl(s.summary_token3_value,'''''') || ')') ||
', '''', '''', '''', '''', '''', '''', '''', '''', '''', '''' ';
/* select all query columns */
v_sql_stmt :=
'SELECT ' ||
get_td_tag(s.column1) || ',' ||
get_td_tag(s.column2) || ',' ||
get_td_tag(s.column3) || ',' ||
get_td_tag(s.column4) || ',' ||
get_td_tag(s.column5) || ',' ||
get_td_tag(s.column6) || ',' ||
get_td_tag(s.column7) || ',' ||
get_td_tag(s.column8) || ',' ||
get_td_tag(s.column9) || ',' ||
get_td_tag(s.column10) || ',' ||
get_td_tag(s.column11);
select decode(nvl(s.where_clause,'N'),'N','N','Y') into lv_where_clause from dual;
select application_name
into v_appl_name
from fnd_application_vl
where application_short_name = v_application_code;
select count(*)
into v_count
from msd_level_values
where level_id = p_level_id
and instance = p_instance
and sr_level_pk = p_sr_pk;