1 PACKAGE okl_subsidy_pool_wf AUTHID CURRENT_USER AS
2 /* $Header: OKLRSWFS.pls 120.1 2005/10/30 03:17:26 appldev noship $ */
3
4 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
5 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SUBSIDY_POOL_WF';
6 G_API_TYPE CONSTANT VARCHAR2(200) := '_PVT';
7
8 PROCEDURE check_approval_process(itemtype IN VARCHAR2
9 ,itemkey IN VARCHAR2
10 ,actid IN NUMBER
11 ,funcmode IN VARCHAR2
12 ,resultout OUT NOCOPY VARCHAR2);
13
14 PROCEDURE update_pool_approval_status(itemtype IN VARCHAR2
15 ,itemkey IN VARCHAR2
16 ,actid IN NUMBER
17 ,funcmode IN VARCHAR2
18 ,resultout OUT NOCOPY VARCHAR2);
19
20 PROCEDURE update_line_approval_status(itemtype IN VARCHAR2
21 ,itemkey IN VARCHAR2
22 ,actid IN NUMBER
23 ,funcmode IN VARCHAR2
24 ,resultout OUT NOCOPY VARCHAR2);
25
26 PROCEDURE get_subsidy_pool_approver (itemtype IN VARCHAR2
27 ,itemkey IN VARCHAR2
28 ,actid IN NUMBER
29 ,funcmode IN VARCHAR2
30 ,resultout OUT NOCOPY VARCHAR2);
31
32 PROCEDURE get_pool_msg_doc(document_id IN VARCHAR2,
33 display_type IN VARCHAR2,
34 document IN OUT nocopy VARCHAR2,
35 document_type IN OUT nocopy VARCHAR2);
36
37 PROCEDURE get_pool_line_msg_doc(document_id IN VARCHAR2,
38 display_type IN VARCHAR2,
39 document IN OUT nocopy VARCHAR2,
40 document_type IN OUT nocopy VARCHAR2);
41
42
43 PROCEDURE set_msg_attributes (itemtype IN VARCHAR2
44 ,itemkey IN VARCHAR2
45 ,actid IN NUMBER
46 ,funcmode IN VARCHAR2
47 ,resultout OUT NOCOPY VARCHAR2);
48
49 PROCEDURE process_pool_ame (itemtype IN VARCHAR2
50 ,itemkey IN VARCHAR2
51 ,actid IN NUMBER
52 ,funcmode IN VARCHAR2
53 ,resultout OUT NOCOPY VARCHAR2);
54
55 PROCEDURE process_pool_line_ame(itemtype IN VARCHAR2
56 ,itemkey IN VARCHAR2
57 ,actid IN NUMBER
58 ,funcmode IN VARCHAR2
59 ,resultout OUT NOCOPY VARCHAR2);
60
61 PROCEDURE raise_pool_event_approval(p_api_version IN NUMBER
62 ,p_init_msg_list IN VARCHAR2
63 ,x_return_status OUT NOCOPY VARCHAR2
64 ,x_msg_count OUT NOCOPY NUMBER
65 ,x_msg_data OUT NOCOPY VARCHAR2
66 ,p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE);
67
68 PROCEDURE raise_budget_event_approval(p_api_version IN NUMBER
69 ,p_init_msg_list IN VARCHAR2
70 ,x_return_status OUT NOCOPY VARCHAR2
71 ,x_msg_count OUT NOCOPY NUMBER
72 ,x_msg_data OUT NOCOPY VARCHAR2
73 ,p_subsidy_pool_budget_id IN okl_subsidy_pool_budgets_b.id%TYPE);
74
75 END okl_subsidy_pool_wf;