1 package ad_patch as
2 /* $Header: adphpchs.pls 120.5 2007/12/14 13:09:13 diverma ship $ */
3
4 /* Public constants for AOL or any caller to use, as well */
5
6 NOT_APPLIED CONSTANT varchar2(30) := 'NOT_APPLIED';
7 IMPLICITLY_APPLIED CONSTANT varchar2(30) := 'IMPLICIT';
8 EXPLICITLY_APPLIED CONSTANT varchar2(30) := 'EXPLICIT';
9 MANUALLY_APPLIED CONSTANT varchar2(30) := 'MANUAL';
10 AD_UNKNOWN CONSTANT varchar2(30) := 'UNKNOWN';
11 AD_FILES_ONLY CONSTANT varchar2(30) := 'FILES_ONLY';
12
13 function is_patch_applied (p_release_name in varchar2,
14 p_appl_top_id in number,
15 p_bug_number in varchar2,
16 p_bug_language in varchar2)
17 return varchar2;
18
19 function is_patch_applied (p_release_name in varchar2,
20 p_appl_top_id in number,
21 p_bug_number in varchar2)
22 return varchar2;
23
24 function is_codeline_patch_applied (p_release_name in varchar2,
25 p_baseline_name in varchar2,
26 p_appl_top_id in number,
27 p_bug_number in varchar2 )
28 return varchar2;
29
30 function is_codeline_patch_applied ( p_release_name in varchar2,
31 p_baseline_name in varchar2,
32 p_appl_top_id in number,
33 p_bug_number in varchar2,
34 p_language in varchar2)
35 return varchar2;
36
37 function is_file_copied (p_application_short_name in varchar2,
38 p_appl_top_id in number,
39 p_object_location in varchar2,
40 p_object_name in varchar2,
41 p_object_version in varchar2)
42 return varchar2;
43
44 procedure mark_patch_succ(p_patch_run_id in NUMBER ,
45 p_appl_top_id in number,
46 p_release_name in varchar2,
47 p_flag in varchar2,
48 p_reason_text in varchar2);
49
50 procedure mark_bug_succ(p_patch_run_id in NUMBER ,
51 p_appl_top_id in number,
52 p_release_name in varchar2,
53 p_bug_number in varchar2,
54 p_flag in varchar2,
55 p_reason_text in varchar2);
56
57 procedure set_patch_status(p_release_name in varchar2,
58 p_appl_top_id in number,
59 p_bug_number in varchar2,
60 p_bug_status in varchar2);
61
62 function getAppltopID(p_appl_top_name in varchar2,
63 p_app_sys_name in varchar2,
64 p_appl_top_type in varchar2)
65 return number;
66
67 /*****************************************************************************
68 Compare passed versions of files to determine which is greater,
69 the one requested by caller or the one in database.
70
71 Returns:
72 Returns TRUE if p_version_indb >= p_version.
73 *****************************************************************************/
74 function compare_versions(p_version in varchar2,
75 p_version_indb in varchar2)
76 return boolean;
77
78 end ad_patch;