APPS.AD_PATCH_HIST_REPS dependencies on AD_PATCH_HIST_REPS

Line 1: package body ad_patch_hist_reps as

1: package body ad_patch_hist_reps as
2: /* $Header: adphrepb.pls 115.27 2004/09/13 08:49:31 sgadag ship $ */
3:
4: maxLineLen number;
5:

Line 678: -- ad_patch_hist_reps.get_level_if_one(aap.applied_patch_id) lvl,

674:
675: -- Build up the following query:
676:
677: -- select pr.patch_run_id, at.name, l.language, aap.patch_name,
678: -- ad_patch_hist_reps.get_level_if_one(aap.applied_patch_id) lvl,
679: -- ad_patch_hist_reps.get_concat_minipks(pd.patch_driver_id) minipks,
680: -- pr.start_date, pr.end_date, pd.driver_file_name,
681: -- decode(pd.driver_type_c_flag, 'Y', 'Copy', null)||
682: -- decode(pd.driver_type_d_flag, 'Y',

Line 679: -- ad_patch_hist_reps.get_concat_minipks(pd.patch_driver_id) minipks,

675: -- Build up the following query:
676:
677: -- select pr.patch_run_id, at.name, l.language, aap.patch_name,
678: -- ad_patch_hist_reps.get_level_if_one(aap.applied_patch_id) lvl,
679: -- ad_patch_hist_reps.get_concat_minipks(pd.patch_driver_id) minipks,
680: -- pr.start_date, pr.end_date, pd.driver_file_name,
681: -- decode(pd.driver_type_c_flag, 'Y', 'Copy', null)||
682: -- decode(pd.driver_type_d_flag, 'Y',
683: -- decode(pd.driver_type_c_flag, ''Y'', '',DB'', ''DB''),null)||

Line 709: 'ad_patch_hist_reps.get_level_if_one('||

705: 'pr.patch_run_id, '||
706: 'at.name, '||
707: 'l.language, '||
708: 'aap.patch_name, '||
709: 'ad_patch_hist_reps.get_level_if_one('||
710: 'aap.applied_patch_id) lvl, '||
711: 'ad_patch_hist_reps.get_concat_minipks('||
712: 'pd.patch_driver_id) minipks, '||
713: 'ad_patch_hist_reps.get_concat_mergepatches('||

Line 711: 'ad_patch_hist_reps.get_concat_minipks('||

707: 'l.language, '||
708: 'aap.patch_name, '||
709: 'ad_patch_hist_reps.get_level_if_one('||
710: 'aap.applied_patch_id) lvl, '||
711: 'ad_patch_hist_reps.get_concat_minipks('||
712: 'pd.patch_driver_id) minipks, '||
713: 'ad_patch_hist_reps.get_concat_mergepatches('||
714: 'pd.patch_driver_id) comprptch, '||
715: 'to_char(pr.start_date,''mm/dd/rr hh24:mi'') start_date,'||

Line 713: 'ad_patch_hist_reps.get_concat_mergepatches('||

709: 'ad_patch_hist_reps.get_level_if_one('||
710: 'aap.applied_patch_id) lvl, '||
711: 'ad_patch_hist_reps.get_concat_minipks('||
712: 'pd.patch_driver_id) minipks, '||
713: 'ad_patch_hist_reps.get_concat_mergepatches('||
714: 'pd.patch_driver_id) comprptch, '||
715: 'to_char(pr.start_date,''mm/dd/rr hh24:mi'') start_date,'||
716: 'to_char(pr.end_date,''mm/dd/rr hh24:mi'') end_date ,'||
717: 'pd.driver_file_name,';

Line 1161: end ad_patch_hist_reps;

1157: end populate_search_results;
1158: --
1159: --
1160: --
1161: end ad_patch_hist_reps;