[Home] [Help]
PACKAGE: APPS.OE_BIS_ALERTS
Source
1 package OE_BIS_ALERTS AUTHID CURRENT_USER AS
2 --$Header: OEXALRTS.pls 115.1 99/08/09 13:40:39 porting shi $
3
4 FUNCTION Calculate_Actual
5 (
6 p_set_of_books_id VARCHAR2,
7 p_sales_channel VARCHAR2,
8 p_prod_catg VARCHAR2,
9 p_area VARCHAR2,
10 p_period_set_Name VARCHAR2,
11 p_time_period VARCHAR2,
12 p_target_level_short_name VARCHAR2
13 )
14 RETURN NUMBER;
15
16 PROCEDURE Process_Alerts
17 ( p_target_level_short_name VARCHAR2,
18 p_time_period VARCHAR2
19 );
20
21 PROCEDURE PostActual( target_level_id in number,
22 org_level_value in varchar2,
23 time_level_value in varchar2,
24 dimension1_level_value in varchar2,
25 dimension2_level_value in varchar2,
26 dimension3_level_value in varchar2,
27 actual in number,
28 period_set_name in varchar2);
29
30 PROCEDURE oe_strt_wf_process(
31 p_exception_message IN varchar2,
32 p_subject IN varchar2,
33 p_sob IN varchar2,
34 p_area IN varchar2,
35 p_prod_cat IN varchar2,
36 p_sales_channel IN varchar2,
37 p_period IN varchar2,
38 p_target IN varchar2,
39 p_actual IN varchar2,
40 p_wf_process IN varchar2,
41 p_role IN varchar2,
42 p_resp_id IN number,
43 p_report_name IN varchar2,
44 p_report_param IN varchar2,
45 x_return_status OUT varchar2);
46
47 END OE_BIS_ALERTS;