1 package ad_manual_step_object as
2 /* $Header: admsis.pls 120.4 2006/09/13 22:28:52 hxue noship $ */
3
4 --
5 -- Checks whether the manual step exists in history with the given
6 -- version and status.
7 --
8 function manual_step_hist_exists(p_step_key varchar2,
9 p_step_version varchar2,
10 p_status char)
11 return number;
12
13 --
14 -- Function that checks whether the manual steps is already applied in
15 -- this instance.
16 --
17 function is_step_already_done(p_step_key varchar2,
18 p_step_version varchar2)
19 return number;
20
21 --
22 -- Procedure that adds manual steps in to ad_manual_step_history table
23 -- with the given parameters.
24 --
25 procedure add_manual_step_history(p_patch_number varchar2,
26 p_step_key varchar2,
27 p_step_version varchar2,
28 p_step_text varchar2,
29 p_cond_code varchar2,
30 p_username varchar2,
31 p_status char);
32
33 --
34 -- Procedure that updates given manual steps as completed.
35 --
36 procedure update_step_as_completed(p_patch_number varchar2);
37
38 --
39 -- Function that checks whether the customer instance is on a
40 -- codelevel passed.
41 -- returns : 0, if the customer is not in that codelevel.
42 -- 1, if the customer is on or above the given codelevel
43 --
44 function is_on_codelevel (p_entity varchar2,
45 p_level varchar2)
46 return number;
47
48 --
49 -- Function that checks whether the customer instance is on a
50 -- baseline.
51 -- returns : 0, if the customer is not in that baseline
52 -- 1, if the customer is on or above the given baseline.
53 --
54 function is_on_baseline (p_entity varchar2,
55 p_baseline varchar2)
56 return number;
57
58 end ad_manual_step_object;