DBA Data[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;