1 package OKE_FUNDING_PUB AUTHID CURRENT_USER as
2 /* $Header: OKEPKFDS.pls 120.0.12020000.2 2012/09/25 06:52:42 skuchima ship $ */
3
4 --
5 -- Package constants
6 --
7
8 G_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
9 G_PKG_NAME CONSTANT VARCHAR2(40) := 'OKE_FUNDING_PUB';
10 G_PRODUCT_CODE CONSTANT VARCHAR2(3) := 'OKE';
11 G_APP_NAME CONSTANT VARCHAR2(3) := OKE_API.G_APP_NAME;
12 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
13 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
14 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKE_CONTRACTS_UNEXPECTED_ERROR';
15 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
16
17 SUBTYPE funding_rec_in_type IS OKE_FUNDSOURCE_PVT.funding_rec_in_type;
18 SUBTYPE funding_rec_out_type IS OKE_FUNDSOURCE_PVT.funding_rec_out_type;
19
20 SUBTYPE allocation_rec_in_type IS OKE_ALLOCATION_PVT.allocation_rec_in_type;
21 SUBTYPE allocation_rec_out_type IS OKE_ALLOCATION_PVT.allocation_rec_out_type;
22
23 SUBTYPE allocation_in_tbl_type IS OKE_ALLOCATION_PVT.allocation_in_tbl_type;
24 SUBTYPE allocation_out_tbl_type IS OKE_ALLOCATION_PVT.allocation_out_tbl_type;
25
26
27 --
28 -- Procedure: create_funding
29 --
30 -- Description: create funding records in OKE and agreement records in PA if agreement_flag is true
31 --
32 --
33
34 PROCEDURE create_funding(p_api_version IN NUMBER ,
35 p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
36 p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
37 x_return_status OUT NOCOPY VARCHAR2 ,
38 x_msg_count OUT NOCOPY NUMBER ,
39 x_msg_data OUT NOCOPY VARCHAR2 ,
40 p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,
41 p_agreement_type IN VARCHAR2 ,
42 p_receivables_term_id IN NUMBER default null , /*skuchima bug 14344021*/
43 p_funding_in_rec IN FUNDING_REC_IN_TYPE ,
44 x_funding_out_rec OUT NOCOPY FUNDING_REC_OUT_TYPE ,
45 p_allocation_in_tbl IN ALLOCATION_IN_TBL_TYPE ,
46 x_allocation_out_tbl OUT NOCOPY ALLOCATION_OUT_TBL_TYPE
47 );
48
49
50 --
51 -- Procedure: update_funding
52 --
53 -- Description: update funding records in OKE and agreement records in PA if agreement_flag is true
54 --
55 --
56
57 PROCEDURE update_funding(p_api_version IN NUMBER ,
58 p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
59 p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
60 x_return_status OUT NOCOPY VARCHAR2 ,
61 x_msg_count OUT NOCOPY NUMBER ,
62 x_msg_data OUT NOCOPY VARCHAR2 ,
63 p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,
64 p_agreement_type IN VARCHAR2 ,
65 p_receivables_term_id IN NUMBER default null , /*skuchima bug 14344021*/
66 p_funding_in_rec IN FUNDING_REC_IN_TYPE ,
67 x_funding_out_rec OUT NOCOPY FUNDING_REC_OUT_TYPE ,
68 p_allocation_in_tbl IN ALLOCATION_IN_TBL_TYPE ,
69 x_allocation_out_tbl OUT NOCOPY ALLOCATION_OUT_TBL_TYPE
70 );
71
72 --
73 -- Procedure: delete_funding
74 --
75 -- Description: delete funding records in OKE and agreement records in PA
76 --
77 --
78
79 PROCEDURE delete_funding(p_api_version IN NUMBER ,
80 p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
81 p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
82 x_return_status OUT NOCOPY VARCHAR2 ,
83 x_msg_count OUT NOCOPY NUMBER ,
84 x_msg_data OUT NOCOPY VARCHAR2 ,
85 p_funding_source_id IN NUMBER
86 -- p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE
87 );
88
89
90 --
91 -- Procedure: add_allocation
92 --
93 -- Description: create funding allocation records in OKE and project funding records in PA if agreement_flag is true
94 --
95 --
96
97 PROCEDURE add_allocation(p_api_version IN NUMBER ,
98 p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
99 p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
100 x_return_status OUT NOCOPY VARCHAR2 ,
101 x_msg_count OUT NOCOPY NUMBER ,
102 x_msg_data OUT NOCOPY VARCHAR2 ,
103 p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,
104 p_allocation_in_rec IN ALLOCATION_REC_IN_TYPE ,
105 x_allocation_out_rec OUT NOCOPY ALLOCATION_REC_OUT_TYPE
106 );
107
108
109 --
110 -- Procedure: update_allocation
111 --
112 -- Description: update funding allocation records in OKE and project funding records in PA if agreement_flag is true
113 --
114 --
115
116 PROCEDURE update_allocation(p_api_version IN NUMBER ,
117 p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
118 p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
119 x_return_status OUT NOCOPY VARCHAR2 ,
120 x_msg_count OUT NOCOPY NUMBER ,
121 x_msg_data OUT NOCOPY VARCHAR2 ,
122 p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,
123 p_allocation_in_rec IN ALLOCATION_REC_IN_TYPE ,
124 x_allocation_out_rec OUT NOCOPY ALLOCATION_REC_OUT_TYPE
125 );
126
127
128 --
129 -- Procedure: delete_allocation
130 --
131 -- Description: delete funding records in OKE and project funding records in PA
132 --
133 --
134
135 PROCEDURE delete_allocation(p_api_version IN NUMBER ,
136 p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
137 p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
138 x_return_status OUT NOCOPY VARCHAR2 ,
139 x_msg_count OUT NOCOPY NUMBER ,
140 x_msg_data OUT NOCOPY VARCHAR2 ,
141 p_fund_allocation_id IN NUMBER
142 -- p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE
143 );
144
145
146 --
147 -- Procedure: create_pa_oke_funding
148 --
149 -- Description: create funding records in OKE based on existing agreement records in PA
150 --
151 --
152
153 PROCEDURE create_pa_oke_funding(p_api_version IN NUMBER ,
154 p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
155 p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
156 x_return_status OUT NOCOPY VARCHAR2 ,
157 x_msg_count OUT NOCOPY NUMBER ,
158 x_msg_data OUT NOCOPY VARCHAR2 ,
159 x_funding_source_id OUT NOCOPY NUMBER ,
160 --p_source_currency IN VARCHAR2 ,
161 p_agreement_id IN NUMBER ,
162 p_party_id IN NUMBER ,
163 p_pool_party_id IN NUMBER ,
164 p_object_id IN NUMBER ,
165 --p_pa_conversion_type IN VARCHAR2 ,
166 --p_pa_conversion_date IN DATE ,
167 --p_pa_conversion_rate IN NUMBER ,
168 p_oke_conversion_type IN VARCHAR2 ,
169 p_oke_conversion_date IN DATE ,
170 p_oke_conversion_rate IN NUMBER
171 );
172
173 end OKE_FUNDING_PUB;