[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
insert into ad_generic_temp (LINE_SEQUENCE,CONTENTS) values(counter,inStr);
lineCnt := writeStrToDb(lineCounter,sqlErr||' Select String is:');
select bug_number from ad_bugs where bug_id in (
select bug_id from ad_comprising_patches
where patch_driver_id = p_patch_driver_id);
select patch_level
from ad_patch_driver_minipks
where patch_driver_id = p_patch_driver_id;
select patch_level
from ad_patch_driver_minipks
where patch_driver_id = p_patch_driver_id;
select patch_type, maint_pack_level
into l_patch_type, l_maint_pack_level
from ad_applied_patches
where applied_patch_id = p_app_ptch_id;
select patch_driver_id
into l_patch_driver_id
from ad_patch_drivers
where applied_patch_id = p_app_ptch_id
and driver_type_d_flag = 'Y';
l_select1 varchar2(400);
l_select2 varchar2(255);
l_select3 varchar2(255);
l_select4 varchar2(255);
l_select5 varchar2(255);
query_str1:='Select '''||query_str1||''' LIMITTOFORMS from dual';
query_str1:='Select '''||query_str1||''' LIMITTOPATCHES from dual';
query_str1:='Select '''||NVL(p_bug_num,'ALL')||''' BUGNUMBER from dual';
query_str1:='Select '''||NVL(p_bug_prod_abbr,'ALL')||''' BUG_PRODUCT from dual';
query_str1:='Select '''||NVL(p_end_dt_from_v,'ALL')||''' END_DATE_FROM from dual';
query_str1:='Select '''||NVL(p_end_dt_to_v,'ALL')||''' END_DATE_TO from dual';
query_str1:='Select '''||NVL(p_patch_nm,'ALL')||''' PATCH_NAME from dual';
query_str1:='Select '''||NVL(p_patch_type,'ALL')||''' PATCH_TYPE from dual';
query_str1:='Select '''||NVL(p_level,'ALL')||''' PATCH_LEVEL from dual';
query_str1:='Select '''||NVL(p_lang,'ALL')||''' LANGUAGE from dual';
query_str1:='Select '''||NVL(p_appltop_nm,'ALL')||''' APPL_TOP from dual';
l_select1 := 'SELECT '||
'pr.patch_run_id, '||
'at.name, '||
'l.language, '||
'aap.patch_name, '||
'ad_patch_hist_reps.get_level_if_one('||
'aap.applied_patch_id) lvl, '||
'ad_patch_hist_reps.get_concat_minipks('||
'pd.patch_driver_id) minipks, '||
'ad_patch_hist_reps.get_concat_mergepatches('||
'pd.patch_driver_id) comprptch, '||
'to_char(pr.start_date,''mm/dd/rr hh24:mi'') start_date,'||
'to_char(pr.end_date,''mm/dd/rr hh24:mi'') end_date ,'||
'pd.driver_file_name,';
l_select2 := 'decode(pd.driver_type_c_flag,'||'''Y'',''Copy'','||
'null)|| '||'decode(pd.driver_type_d_flag,'||
'''Y'',decode(pd.driver_type_c_flag,'||
'''Y'',''DB'',''DB''),';
l_select3 := 'null)|| '||'decode(pd.driver_type_g_flag,'||
'''Y'',decode(pd.driver_type_c_flag,'||
'''Y'',''Generate'','||
'decode(pd.driver_type_d_flag,'||
'''Y'',''Generate'','||
'''Generate'')),'||'null) driver_type,';
l_select4 := 'pr.patch_action_options,pr.patch_top,pd.platform,';
l_select5 := ' decode (pr.server_type_admin_flag,''Y'',''Admin'',null)||'||
' decode (pr.server_type_forms_flag,''Y'',''Forms'',null)||'||
' decode (pr.server_type_node_flag ,''Y'',''Node'',null)||'||
' decode (pr.server_type_web_flag,''Y'',''Web'',null) '||
'servertype';
'select pd2.applied_patch_id '||
'from ad_patch_drivers pd2 '||
'where pd2.patch_driver_id in ('||
'select mi.patch_driver_id '||
'from ad_patch_driver_minipks mi '||
'where mi.patch_level = '''||p_level||'''';
query_str := nvl(l_select1,' ') ||nvl(l_select2,' ') ||nvl(l_select3,' ')||
nvl(l_select4,' ') ||nvl(l_select5,' ') ||nvl(l_from1 ,' ')||
nvl(l_from_bug,' ')||nvl(l_where1 ,' ') ||nvl(l_where2 ,' ')||
nvl(l_where3 ,' ')||nvl(l_where_bug,' ')||nvl(l_order_by1,' ');
query_str1:= 'select ''' ||
v_name ||''' APPL_TOP_NAME ,''' ||
v_language ||''' LANGUAGE ,''' ||
v_patch_name ||''' PATCH_NAME ,''' ||
v_lvl ||''' PATCH_LEVEL , ''' ||
v_minipks ||''' MINIPACKS ,''' ||
v_comprptch ||''' COMPRISING_PATCH,''' ||
v_start_date ||''' START_DATE , ''' ||
v_end_date ||''' END_DATE , ''' ||
v_driver_file_name ||''' DRIVER_NAME ,'''||
v_driver_type ||''' DRIVER_TYPE , ''' ||
v_patch_action_options ||''' PATCH_OPTIONS , '''||
v_patch_top ||''' PATCH_TOP ,''' ||
v_platform ||''' PATCH_PLATFORM , ''' ||
v_servertype ||''' SERVERTYPE from dual';
'SELECT
bgs.BUG_NUMBER,prb.APPLICATION_SHORT_NAME,
decode(APPLIED_FLAG,''Y'',''Yes'',''N'',''No'',''No'') APPLIED_FLAG,
REASON_NOT_APPLIED, prb.PATCH_RUN_BUG_ID
FROM ad_patch_run_bugs prb, ad_bugs bgs
WHERE bgs.bug_id=prb.bug_id and prb.PATCH_RUN_ID='||v_patch_run_id;
query_str1:='select '''||
v_bug_number||''' BUGNUMBER ,'''||
v_product||''' PRODUCT ,'''||
v_applied||''' APPLIED_FLAG ,'''||
v_reason ||''' REASON_NOT_APPLIED from dual';
'SELECT cact.ACTION_CODE Action ,
prba.EXECUTED_FLAG Executed ,
files.APP_SHORT_NAME Product ,
files.SUBDIR Directory ,
files.FILENAME Filename ,
nvl(pver.VERSION,''.'') Patch_Version ,
nvl(pver.TRANSLATION_LEVEL,0) PTrans_Level ,
nvl(over.VERSION,''.'') Onsite_Version,
nvl(over.TRANSLATION_LEVEL,0) OTrans_Level ,
nvl(dver.VERSION,''.'') DB_Version ,
nvl(dver.TRANSLATION_LEVEL,0) DTrans_Level ,
nvl(cact.ACTION_PHASE,''.'') Phase ,
nvl(cact.ACTION_ARGUMENTS,''.'') Arguments ,
nvl(cact.ACTION_WHAT_SQL_EXEC,''.'') Modifier
FROM ad_files files, ad_bugs bugs, ad_patch_common_actions cact,
ad_file_versions pver, ad_file_versions over,
ad_file_versions dver, ad_patch_run_bug_actions prba,
ad_patch_run_bugs pbug
WHERE pbug.PATCH_RUN_BUG_ID = '||v_patch_run_bug_id||
' and pbug.PATCH_RUN_BUG_ID = prba.PATCH_RUN_BUG_ID
and cact.COMMON_ACTION_ID = prba.COMMON_ACTION_ID
and pver.FILE_VERSION_ID(+) = prba.PATCH_FILE_VERSION_ID
and over.FILE_VERSION_ID(+) = prba.ONSITE_FILE_VERSION_ID
and dver.FILE_VERSION_ID(+) = prba.ONSITE_PKG_VERSION_IN_DB_ID
and bugs.BUG_ID = pbug.BUG_ID
and files.FILE_ID = prba.FILE_ID
ORDER BY '||
-- The below ORDER-BY decode to be in sync with the sequence
-- of calls to adpaex() in adpmrp().
'decode(cact.ACTION_CODE,''libout'',1,''copy'',2,
''forcecopy'',3,''libin'',4,''makedir'',5,''link'',6,
''jcopy'',7,'||
-- sql,exec,exectier intentionally kept at same level
'''sql'',8,''exec'',8,''exectier'',8,''genfpll'',9,
''genmenu'',10,''genform'',11,''genrpll'',12,''genrep'',13,
''gengpll'',14,''genogd'',15,''genmesg'',16,''genwfmsg'',17,50),
cact.numeric_phase,cact.numeric_sub_phase,
files.FILENAME,cact.ACTION_ARGUMENTS';
query_str1:='select '''||v_act_actioncode||''' ACTION, '''||
v_act_executed||''' EXECUTED, '''||
v_act_product||''' PRODUCT, '''||
v_act_subdir||''' DIRECTORY, '''||
v_act_filename||''' FILENAME, '''||
v_act_patch_ver||''' PATCH_VERSION, '''||
v_act_patch_trlev||''' PTRANS_LEVEL, '''||
v_act_onsitever||''' ONSITE_VERSION, '''||
v_act_onsite_trlev||''' OTRANS_LEVEL, '''||
v_act_pkgverdb||''' PACKAGE_VERSION, '''||
v_act_pkgdb_trlev||''' PKG_TRANLEVEL, '''||
v_act_phase||''' ACTION_PHASE, '''||
v_act_args||''' ACTION_ARGS, '''||
v_act_Modfr||''' ACTION_MODIFIER from dual';