[Home] [Help]
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;