1 PACKAGE WIP_BIS_YDSP_ALERT AUTHID CURRENT_USER AS
2 /* $Header: wipbiaqs.pls 115.7 2002/11/28 19:18:53 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 prod in varchar2,
32 item in varchar2,
33 actual in number,
34 target in number,
35 plan_id in number,
36 plan_name in varchar2,
37 wf in varchar2,
38 resp_id in number,
39 resp_name in varchar2,
40 org_level in number,
41 dimension1_level in number,
42 dimension2_level in number);
43
44 PROCEDURE CompareLevelTarget( target_level_id in number,
45 time_level in number,
46 org_level in number,
47 dimension1_level in number,
48 dimension2_level in number);
49
50 PROCEDURE WIP_Strt_Wf_Process(
51 p_subject IN varchar2,
52 p_sob IN varchar2,
53 p_le IN varchar2,
54 p_ou IN varchar2,
55 p_org IN varchar2,
56 p_area IN varchar2,
57 p_country IN varchar2,
58 p_prod_cat IN varchar2,
59 p_prod IN varchar2,
60 p_period IN varchar2,
61 p_target IN varchar2,
62 p_actual IN varchar2,
63 p_wf_process IN varchar2,
64 p_role IN varchar2,
65 p_resp_id IN number,
66 p_report_name IN varchar2,
67 p_report_param IN varchar2,
68 x_return_status OUT NOCOPY varchar2);
69
70 PROCEDURE Alert_Check;
71
72
73 END WIP_BIS_YDSP_ALERT;