PACKAGE: APPS.AD_PATCH_HIST_REPS

Source

1 package ad_patch_hist_reps AUTHID CURRENT_USER as
2 /* $Header: adphreps.pls 115.11 2004/06/02 11:57:32 sallamse ship $ */
3 
4 function get_concat_mergepatches(p_ptch_drvr_id number) return varchar2;
5 pragma restrict_references(get_concat_mergepatches, WNDS, WNPS);
6 
7 function get_concat_minipks(p_ptch_drvr_id number) return varchar2;
8 pragma restrict_references(get_concat_minipks, WNDS, WNPS);
9 
10 function get_level_if_one(p_app_ptch_id number) return varchar2;
11 pragma restrict_references(get_level_if_one, WNDS, WNPS);
12 
13 function printClobOut(result IN OUT NOCOPY CLOB,line_num in number)
14      return number;
15 
16 function writeStrToDb(lineCounter number,
17                       inStr       varchar2) return number;
18 
19 function printBeginXML(line_num in number,is_patch boolean) return number;
20 
21 function printEndXML(line_num in number) return number;
22 
23 procedure populate_search_results
24 ( p_query_depth       varchar2  default 1, -- PATCHES/BUGS/ACTIONS
25   p_bug_num           varchar2  default NULL,
26   p_bug_prod_abbr     varchar2  default NULL,
27   p_end_dt_from_v     varchar2  default NULL,
28   p_end_dt_to_v       varchar2  default NULL,
29   p_patch_nm          varchar2  default NULL,
30   p_patch_type        varchar2  default NULL,
31   p_level             varchar2  default NULL,
32   p_lang              varchar2  default NULL,
33   p_appltop_nm        varchar2  default NULL,
34   p_limit_to_forms    boolean   default FALSE,
35   p_limit_to_node     boolean   default FALSE,
36   p_limit_to_web      boolean   default FALSE,
37   p_limit_to_admin    boolean   default FALSE,
38   p_limit_to_db_drvrs boolean   default FALSE,
39   p_report_format     varchar2);
40 
41 end ad_patch_hist_reps;