1 package ad_pa_validate_criteriaset as
2 /* $Header: adpavacs.pls 120.1 2005/08/12 03:23:50 appldev noship $*/
3
4 Procedure validate_criteriaset(p_advisor_criteria_id varchar2);
5
6 /* This function returns comma separated patches in column Merged_patches in PatchSummary page . Bug # 2813894 -KKSINGH */
7 function get_concat_mergepatches(p_ptch_drvr_id number) return varchar2;
8
9 /* This function detemines to enable or disable Details Image in Action Summary page. Bug # 2803063 -KKSINGH */
10 function get_jobtiming_details(p_action_id number, p_program_run_id number, p_session_id number)
11 return number ;
12
13 /* This function returns comma separated MiniPacks in column MiniPacks in PatchDetails page . Bug # 2803063 -KKSINGH */
14
15 function get_concat_minipks(p_ptch_drvr_id number) return varchar2;
16
17 /* This function returns comma separated product family desc for a give product abbr */
18 function get_cs_prod_fam_name(p_product_abbr varchar2) return varchar2;
19
20 /* This function returns comma separated product family abbr for a give product abbr */
21 function get_cs_prod_fam_abbr(p_product_abbr varchar2) return varchar2;
22
23 pragma restrict_references(get_concat_minipks, WNDS, WNPS);
24
25 end ad_pa_validate_criteriaset;