[Home] [Help]
PACKAGE BODY: APPS.OKS_SUBSCRIPTION_PUB
Source
1 PACKAGE BODY OKS_SUBSCRIPTION_PUB As
2 /* $Header: OKSPSUBB.pls 120.0 2005/05/25 18:02:08 appldev noship $*/
3
4 Procedure create_default_schedule
5 ( p_api_version IN NUMBER,
6 p_init_msg_list IN VARCHAR2,
7 x_return_status OUT NOCOPY VARCHAR2,
8 x_msg_count OUT NOCOPY Number,
9 x_msg_data OUT NOCOPY VARCHAR2,
10 p_cle_id IN NUMBER,
11 p_intent IN VARCHAR2
12 ) IS
13 Begin
14 OKS_SUBSCRIPTION_PVT.create_default_schedule
15 ( p_api_version => p_api_version,
16 p_init_msg_list => p_init_msg_list,
17 x_return_status => x_return_status,
18 x_msg_count => x_msg_count,
19 x_msg_data => x_msg_data,
20 p_cle_id => p_cle_id,
21 p_intent => p_intent
22 );
23 End create_default_schedule;
24
25 Procedure recreate_schedule
26 ( p_api_version IN NUMBER,
27 p_init_msg_list IN VARCHAR2,
28 x_return_status OUT NOCOPY VARCHAR2,
29 x_msg_count OUT NOCOPY Number,
30 x_msg_data OUT NOCOPY VARCHAR2,
31 p_cle_id IN NUMBER,
32 p_intent IN VARCHAR2,
33 x_quantity OUT NOCOPY NUMBER
34 ) IS
35 Begin
36 OKS_SUBSCRIPTION_PVT.recreate_schedule
37 ( p_api_version => p_api_version,
38 p_init_msg_list => p_init_msg_list,
39 x_return_status => x_return_status,
40 x_msg_count => x_msg_count,
41 x_msg_data => x_msg_data,
42 p_cle_id => p_cle_id,
43 p_intent => p_intent,
44 x_quantity => x_quantity
45 );
46 End recreate_schedule;
47
48 Procedure recreate_instance
49 ( p_api_version IN NUMBER,
50 p_init_msg_list IN VARCHAR2,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY Number,
53 x_msg_data OUT NOCOPY VARCHAR2,
54 p_cle_id IN NUMBER,
55 p_custacct_id IN NUMBER
56 ) IS
57 Begin
58 OKS_SUBSCRIPTION_PVT.recreate_instance
59 ( p_api_version => p_api_version,
60 p_init_msg_list => p_init_msg_list,
61 x_return_status => x_return_status,
62 x_msg_count => x_msg_count,
63 x_msg_data => x_msg_data,
64 p_cle_id => p_cle_id,
65 p_custacct_id => p_custacct_id
66 );
67 End recreate_instance;
68
69 Procedure copy_subscription
70 ( p_api_version IN NUMBER,
71 p_init_msg_list IN VARCHAR2,
72 x_return_status OUT NOCOPY VARCHAR2,
73 x_msg_count OUT NOCOPY NUMBER,
74 x_msg_data OUT NOCOPY VARCHAR2,
75 p_source_cle_id IN NUMBER,
76 p_target_cle_id IN NUMBER,
77 p_intent IN VARCHAR2
78 ) IS
79 Begin
80 OKS_SUBSCRIPTION_PVT.copy_subscription
81 ( p_api_version => p_api_version,
82 p_init_msg_list => p_init_msg_list,
83 x_return_status => x_return_status,
84 x_msg_count => x_msg_count,
85 x_msg_data => x_msg_data,
86 p_source_cle_id => p_source_cle_id,
87 p_target_cle_id => p_target_cle_id,
88 p_intent => p_intent
89 );
90 End copy_subscription;
91
92 Procedure undo_subscription
93 ( p_api_version IN NUMBER,
94 p_init_msg_list IN VARCHAR2,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY Number,
97 x_msg_data OUT NOCOPY VARCHAR2,
98 p_cle_id IN NUMBER
99 ) IS
100 Begin
101 OKS_SUBSCRIPTION_PVT.undo_subscription
102 ( p_api_version => p_api_version,
103 p_init_msg_list => p_init_msg_list,
104 x_return_status => x_return_status,
105 x_msg_count => x_msg_count,
106 x_msg_data => x_msg_data,
107 p_cle_id => p_cle_id
108 );
109 End undo_subscription;
110
111 Procedure validate_pattern
112 ( p_api_version IN NUMBER,
113 p_init_msg_list IN VARCHAR2,
114 x_return_status OUT NOCOPY VARCHAR2,
115 x_msg_count OUT NOCOPY Number,
116 x_msg_data OUT NOCOPY VARCHAR2,
117 p_instring IN VARCHAR2,
118 p_lowval IN NUMBER,
119 p_highval IN NUMBER,
120 x_outstring OUT NOCOPY VARCHAR2,
121 x_outtab OUT NOCOPY rangetab
122 ) IS
123 Begin
124 OKS_SUBSCRIPTION_PVT.validate_pattern
125 ( p_api_version => p_api_version,
126 p_init_msg_list => p_init_msg_list,
127 x_return_status => x_return_status,
128 x_msg_count => x_msg_count,
129 x_msg_data => x_msg_data,
130 p_instring => p_instring,
131 p_lowval => p_lowval,
132 p_highval => p_highval,
133 x_outstring => x_outstring,
134 x_outtab => x_outtab
135 );
136 End validate_pattern;
137
138 Procedure get_subs_qty
139 ( p_cle_id IN NUMBER,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_quantity OUT NOCOPY NUMBER,
142 x_uom_code OUT NOCOPY VARCHAR2
143 ) IS
144 Begin
145 OKS_SUBSCRIPTION_PVT.get_subs_qty
146 ( p_cle_id => p_cle_id,
147 x_return_status => x_return_status,
148 x_quantity => x_quantity,
149 x_uom_code => x_uom_code
150 );
151 End get_subs_qty;
152
153 Procedure stretch_effectivity
154 ( p_start_date IN DATE,
155 p_end_date IN DATE,
156 p_frequency IN VARCHAR2,
157 x_new_start_dt OUT NOCOPY DATE,
158 x_new_end_dt OUT NOCOPY DATE
159 )IS
160 Begin
161 OKS_SUBSCRIPTION_PVT.stretch_effectivity
162 ( p_start_date => p_start_date,
163 p_end_date => p_end_date,
164 p_frequency => p_frequency,
165 x_new_start_dt => x_new_start_dt,
166 x_new_end_dt => x_new_end_dt
167 );
168 End stretch_effectivity;
169
170 Function subs_termn_amount
171 ( p_cle_id IN NUMBER,
172 p_termn_date IN DATE
173 ) Return NUMBER IS
174 Begin
175 Return OKS_SUBSCRIPTION_PVT.subs_termn_amount
176 ( p_cle_id => p_cle_id,
177 p_termn_date => p_termn_date
178 );
179 End subs_termn_amount;
180
181 Function is_subs_tangible
182 ( p_cle_id IN NUMBER
183 ) Return BOOLEAN IS
184 Begin
185 Return OKS_SUBSCRIPTION_PVT.is_subs_tangible
186 ( p_cle_id => p_cle_id
187 );
188 End is_subs_tangible;
189
190 Function map_freq_uom
191 ( p_frequency IN VARCHAR2
192 ) Return VARCHAR2 IS
193 Begin
194 Return OKS_SUBSCRIPTION_PVT.map_freq_uom
195 ( p_frequency => p_frequency
196 );
197 End map_freq_uom;
198
199 Procedure db_commit Is
200 Begin
201 Commit;
202 End db_commit;
203
204 END OKS_SUBSCRIPTION_PUB;
205