1 PACKAGE WIP_BIS_UTZ_ALERT AUTHID CURRENT_USER AS
2 /* $Header: wipbiuas.pls 115.8 2002/11/29 13:36:25 rmahidha ship $ */
3
4 PROCEDURE PostActual( target_level_id in number,
5 time_level_value in varchar2,
6 org_level_value in varchar2,
7 dimension1_level_value in varchar2,
8 dimension2_level_value in varchar2,
9 actual in number,
10 period_set_name in varchar2);
11
12 PROCEDURE PostLevelActuals( target_level_id in number,
13 time_level in number,
14 org_level in number,
15 dimension1_level in number,
16 dimension2_level in number);
17
18 PROCEDURE StartFlow( time_level_value in varchar2,
19 start_date in date,
20 end_date in date,
21 org_level_value in varchar2,
22 dimension1_level_value in varchar2,
23 dimension2_level_value in varchar2,
24 prod_id in number,
25 sob in varchar2,
26 le in varchar2,
27 ou in varchar2,
28 org in varchar2,
29 area in varchar2,
30 country in varchar2,
31 country_id IN VARCHAR2,
32 region IN VARCHAR2,
33 prod in varchar2,
34 item in varchar2,
35 actual in number,
36 target in number,
37 plan_id in number,
38 plan_name in varchar2,
39 wf in varchar2,
40 resp_id in number,
41 resp_name in varchar2,
42 org_level in number,
43 dimension1_level in number,
44 dimension2_level in number);
45
46 PROCEDURE CompareLevelTarget( target_level_id in number,
47 time_level in number,
48 org_level in number,
49 dimension1_level in number,
50 dimension2_level in number);
51
52 PROCEDURE WIP_Strt_Wf_Process(
53 p_subject IN varchar2,
54 p_sob IN varchar2,
55 p_le IN varchar2,
56 p_ou IN varchar2,
57 p_org IN varchar2,
58 p_area IN varchar2,
59 p_country IN varchar2,
60 p_region IN VARCHAR2,
61 p_prod_cat IN varchar2,
62 p_prod IN varchar2,
63 p_period IN varchar2,
64 p_target IN varchar2,
65 p_actual IN varchar2,
66 p_wf_process IN varchar2,
67 p_role IN varchar2,
68 p_resp_id IN number,
69 p_report_name IN varchar2,
70 p_report_param IN varchar2,
71 x_return_status OUT nocopy varchar2);
72
73 PROCEDURE Alert_Check;
74
75
76 END WIP_BIS_UTZ_ALERT;