PACKAGE: APPS.WIP_BIS_ALERTS

Source

1 package WIP_BIS_ALERTS AUTHID CURRENT_USER as
2 /* $Header: wipbials.pls 115.7 2002/11/28 19:16:22 rmahidha ship $ */
3 
4 procedure post_actual_to_bis (
5   trgt_short_name IN VARCHAR2,
6   period_set_name IN VARCHAR2,
7   period_name     IN VARCHAR2,
8   org_id          IN NUMBER,
9   actual          IN NUMBER);
10 
11 procedure get_last_comp_period (
12   func              IN VARCHAR2,
13   prd_set_name      IN VARCHAR2,
14   prd_type          IN VARCHAR2,
15   prd_name          OUT NOCOPY VARCHAR2,
16   prd_start_date    OUT NOCOPY DATE,
17   prd_end_date      OUT NOCOPY DATE);
18 
19 procedure get_actual(
20   func          IN VARCHAR2,
21   prd_set_name  IN VARCHAR2,
22   prd_name      IN VARCHAR2,
23   org_id        IN NUMBER,
24   actual        OUT NOCOPY NUMBER);
25 
26 procedure get_target(
27   trgt_table         IN VARCHAR2,
28   prd_set_name       IN VARCHAR2,
29   prd_name           IN VARCHAR2,
30   org_id             IN  NUMBER,
31   target             OUT NOCOPY NUMBER,
32   l_wf_process       OUT NOCOPY VARCHAR2,
33   l_role             OUT NOCOPY VARCHAR2,
34   l_role_id          OUT NOCOPY NUMBER);
35 
36 procedure alert_check(func IN VARCHAR2);
37 
38 procedure WIP_Strt_Wf_Process (
39     p_subject               Varchar2
40    ,p_period                Varchar2
41    ,p_legal_entity          Varchar2
42    ,p_org                   Varchar2
43    ,p_wf_process            Varchar2
44    ,p_role                  Varchar2
45    ,p_actual                Varchar2
46    ,p_target                Varchar2
47    ,p_report_name1          Varchar2
48    ,p_report_param1         Varchar2
49    ,p_responsibility_id     NUMBER
50    ,x_return_status         OUT NOCOPY Varchar2);
51 
52 end WIP_BIS_ALERTS;