[Home] [Help]
233: l_rem_space number :=0; -- remaining space
234: l_len_till_now number :=0; -- length of l_concat_bugid
235:
236: cursor c1(p_patch_driver_id number) is
237: select bug_number from ad_bugs where bug_id in (
238: select bug_id from ad_comprising_patches
239: where patch_driver_id = p_patch_driver_id);
240: begin
241: l_concat_bugNumber := null;
846: --joined
847: if (p_bug_num IS NOT NULL) or
848: (p_bug_prod_abbr IS NOT NULL)
849: then
850: l_from_bug := l_from_bug ||',ad_patch_run_bugs prb, ad_bugs b';
851: l_where_bug := l_where_bug||' and b.bug_id = prb.bug_id '||
852: ' and prb.patch_run_id = pr.patch_run_id ';
853:
854: if (p_bug_num IS NOT NULL)
928: 'SELECT
929: bgs.BUG_NUMBER,prb.APPLICATION_SHORT_NAME,
930: decode(APPLIED_FLAG,''Y'',''Yes'',''N'',''No'',''No'') APPLIED_FLAG,
931: REASON_NOT_APPLIED, prb.PATCH_RUN_BUG_ID
932: FROM ad_patch_run_bugs prb, ad_bugs bgs
933: WHERE bgs.bug_id=prb.bug_id and prb.PATCH_RUN_ID='||v_patch_run_id;
934:
935: -- if the bug number has been passed as arguments then
936:
1002: nvl(dver.TRANSLATION_LEVEL,0) DTrans_Level ,
1003: nvl(cact.ACTION_PHASE,''.'') Phase ,
1004: nvl(cact.ACTION_ARGUMENTS,''.'') Arguments ,
1005: nvl(cact.ACTION_WHAT_SQL_EXEC,''.'') Modifier
1006: FROM ad_files files, ad_bugs bugs, ad_patch_common_actions cact,
1007: ad_file_versions pver, ad_file_versions over,
1008: ad_file_versions dver, ad_patch_run_bug_actions prba,
1009: ad_patch_run_bugs pbug
1010: WHERE pbug.PATCH_RUN_BUG_ID = '||v_patch_run_bug_id||