1 package AR_CONS_BILL_CYCLE_PKG as
2 /* $Header: ARCBILCS.pls 120.1 2006/05/23 16:17:58 jypandey noship $ */
3 procedure INSERT_ROW (
4 X_ROWID IN OUT NOCOPY VARCHAR2,
5 X_BILLING_CYCLE_ID IN NUMBER,
6 X_BILL_CYCLE_TYPE IN VARCHAR2,
7 X_CYCLE_NAME IN VARCHAR2,
8 X_DESCRIPTION IN VARCHAR2,
9 X_CYCLE_FREQUENCY IN VARCHAR2,
10 X_START_DATE IN DATE,
11 X_LAST_DAY IN VARCHAR2,
12 X_DAY_1 IN VARCHAR2,
13 X_DAY_2 IN VARCHAR2,
14 X_DAY_3 IN VARCHAR2,
15 X_DAY_4 IN VARCHAR2,
16 X_DAY_5 IN VARCHAR2,
17 X_DAY_6 IN VARCHAR2,
18 X_DAY_7 IN VARCHAR2,
19 X_DAY_8 IN VARCHAR2,
20 X_DAY_9 IN VARCHAR2,
21 X_DAY_10 IN VARCHAR2,
22 X_DAY_11 IN VARCHAR2,
23 X_DAY_12 IN VARCHAR2,
24 X_DAY_13 IN VARCHAR2,
25 X_DAY_14 IN VARCHAR2,
26 X_DAY_15 IN VARCHAR2,
27 X_DAY_16 IN VARCHAR2,
28 X_DAY_17 IN VARCHAR2,
29 X_DAY_18 IN VARCHAR2,
30 X_DAY_19 IN VARCHAR2,
31 X_DAY_20 IN VARCHAR2,
32 X_DAY_21 IN VARCHAR2,
33 X_DAY_22 IN VARCHAR2,
34 X_DAY_23 IN VARCHAR2,
35 X_DAY_24 IN VARCHAR2,
36 X_DAY_25 IN VARCHAR2,
37 X_DAY_26 IN VARCHAR2,
38 X_DAY_27 IN VARCHAR2,
39 X_DAY_28 IN VARCHAR2,
40 X_DAY_29 IN VARCHAR2,
41 X_DAY_30 IN VARCHAR2,
42 X_DAY_31 IN VARCHAR2,
43 X_DAY_MONDAY IN VARCHAR2,
44 X_DAY_TUESDAY IN VARCHAR2,
45 X_DAY_WEDNESDAY IN VARCHAR2,
46 X_DAY_THURSDAY IN VARCHAR2,
47 X_DAY_FRIDAY IN VARCHAR2,
48 X_DAY_SATURDAY IN VARCHAR2,
49 X_DAY_SUNDAY IN VARCHAR2,
50 X_SKIP_WEEKENDS IN VARCHAR2,
51 X_SKIP_HOLIDAYS IN VARCHAR2,
52 X_REPEAT_DAILY IN NUMBER,
53 X_REPEAT_WEEKLY IN NUMBER,
54 X_REPEAT_MONTHLY IN NUMBER,
55 X_DAY_TYPE IN VARCHAR2,
56 X_CREATED_BY IN NUMBER,
57 X_CREATION_DATE IN DATE,
58 X_LAST_UPDATE_LOGIN IN NUMBER,
59 X_LAST_UPDATE_DATE IN DATE,
60 X_LAST_UPDATED_BY IN NUMBER,
61 X_OBJECT_VERSION_NUMBER IN NUMBER
62 );
63
64 procedure UPDATE_ROW (
65 X_BILLING_CYCLE_ID IN NUMBER,
66 X_BILL_CYCLE_TYPE IN VARCHAR2,
67 X_CYCLE_NAME IN VARCHAR2,
68 X_DESCRIPTION IN VARCHAR2,
69 X_CYCLE_FREQUENCY IN VARCHAR2,
70 X_START_DATE IN DATE,
71 X_LAST_DAY IN VARCHAR2,
72 X_DAY_1 IN VARCHAR2,
73 X_DAY_2 IN VARCHAR2,
74 X_DAY_3 IN VARCHAR2,
75 X_DAY_4 IN VARCHAR2,
76 X_DAY_5 IN VARCHAR2,
77 X_DAY_6 IN VARCHAR2,
78 X_DAY_7 IN VARCHAR2,
79 X_DAY_8 IN VARCHAR2,
80 X_DAY_9 IN VARCHAR2,
81 X_DAY_10 IN VARCHAR2,
82 X_DAY_11 IN VARCHAR2,
83 X_DAY_12 IN VARCHAR2,
84 X_DAY_13 IN VARCHAR2,
85 X_DAY_14 IN VARCHAR2,
86 X_DAY_15 IN VARCHAR2,
87 X_DAY_16 IN VARCHAR2,
88 X_DAY_17 IN VARCHAR2,
89 X_DAY_18 IN VARCHAR2,
90 X_DAY_19 IN VARCHAR2,
91 X_DAY_20 IN VARCHAR2,
92 X_DAY_21 IN VARCHAR2,
93 X_DAY_22 IN VARCHAR2,
94 X_DAY_23 IN VARCHAR2,
95 X_DAY_24 IN VARCHAR2,
96 X_DAY_25 IN VARCHAR2,
97 X_DAY_26 IN VARCHAR2,
98 X_DAY_27 IN VARCHAR2,
99 X_DAY_28 IN VARCHAR2,
100 X_DAY_29 IN VARCHAR2,
101 X_DAY_30 IN VARCHAR2,
102 X_DAY_31 IN VARCHAR2,
103 X_DAY_MONDAY IN VARCHAR2,
104 X_DAY_TUESDAY IN VARCHAR2,
105 X_DAY_WEDNESDAY IN VARCHAR2,
106 X_DAY_THURSDAY IN VARCHAR2,
107 X_DAY_FRIDAY IN VARCHAR2,
108 X_DAY_SATURDAY IN VARCHAR2,
109 X_DAY_SUNDAY IN VARCHAR2,
110 X_SKIP_WEEKENDS IN VARCHAR2,
111 X_SKIP_HOLIDAYS IN VARCHAR2,
112 X_REPEAT_DAILY IN NUMBER,
113 X_REPEAT_WEEKLY IN NUMBER,
114 X_REPEAT_MONTHLY IN NUMBER,
115 X_DAY_TYPE IN VARCHAR2,
116 X_LAST_UPDATE_LOGIN IN NUMBER,
117 X_LAST_UPDATE_DATE IN DATE,
118 X_LAST_UPDATED_BY IN NUMBER,
119 X_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER
120 );
121
122 procedure DELETE_ROW (
123 X_BILLING_CYCLE_ID IN NUMBER
124 );
125
126 procedure LOCK_ROW (
127 X_BILLING_CYCLE_ID IN NUMBER,
128 X_CYCLE_NAME IN VARCHAR2,
129 X_DESCRIPTION IN VARCHAR2,
130 X_CYCLE_FREQUENCY IN VARCHAR2,
131 X_START_DATE IN DATE,
132 X_LAST_DAY IN VARCHAR2,
133 X_DAY_1 IN VARCHAR2,
134 X_DAY_2 IN VARCHAR2,
135 X_DAY_3 IN VARCHAR2,
136 X_DAY_4 IN VARCHAR2,
137 X_DAY_5 IN VARCHAR2,
138 X_DAY_6 IN VARCHAR2,
139 X_DAY_7 IN VARCHAR2,
140 X_DAY_8 IN VARCHAR2,
141 X_DAY_9 IN VARCHAR2,
142 X_DAY_10 IN VARCHAR2,
143 X_DAY_11 IN VARCHAR2,
144 X_DAY_12 IN VARCHAR2,
145 X_DAY_13 IN VARCHAR2,
146 X_DAY_14 IN VARCHAR2,
147 X_DAY_15 IN VARCHAR2,
148 X_DAY_16 IN VARCHAR2,
149 X_DAY_17 IN VARCHAR2,
150 X_DAY_18 IN VARCHAR2,
151 X_DAY_19 IN VARCHAR2,
152 X_DAY_20 IN VARCHAR2,
153 X_DAY_21 IN VARCHAR2,
154 X_DAY_22 IN VARCHAR2,
155 X_DAY_23 IN VARCHAR2,
156 X_DAY_24 IN VARCHAR2,
157 X_DAY_25 IN VARCHAR2,
158 X_DAY_26 IN VARCHAR2,
159 X_DAY_27 IN VARCHAR2,
160 X_DAY_28 IN VARCHAR2,
161 X_DAY_29 IN VARCHAR2,
162 X_DAY_30 IN VARCHAR2,
163 X_DAY_31 IN VARCHAR2,
164 X_DAY_MONDAY IN VARCHAR2,
165 X_DAY_TUESDAY IN VARCHAR2,
166 X_DAY_WEDNESDAY IN VARCHAR2,
167 X_DAY_THURSDAY IN VARCHAR2,
168 X_DAY_FRIDAY IN VARCHAR2,
169 X_DAY_SATURDAY IN VARCHAR2,
170 X_DAY_SUNDAY IN VARCHAR2,
171 X_SKIP_WEEKENDS IN VARCHAR2,
172 X_SKIP_HOLIDAYS IN VARCHAR2,
173 X_REPEAT_DAILY IN NUMBER,
174 X_REPEAT_WEEKLY IN NUMBER,
175 X_REPEAT_MONTHLY IN NUMBER,
176 X_DAY_TYPE IN VARCHAR2
177 );
178 procedure ADD_LANGUAGE;
179
180 procedure TRANSLATE_ROW (
181 X_BILLING_CYCLE_ID in NUMBER,
182 X_CYCLE_NAME in VARCHAR2,
183 X_DESCRIPTION in VARCHAR2,
184 X_OWNER in VARCHAR2
185 );
186
187 procedure LOAD_ROW (
188 X_BILLING_CYCLE_ID in NUMBER,
189 X_BILL_CYCLE_TYPE IN VARCHAR2,
190 X_CYCLE_NAME IN VARCHAR2,
191 X_DESCRIPTION IN VARCHAR2,
192 X_CYCLE_FREQUENCY IN VARCHAR2,
193 X_START_DATE IN DATE,
194 X_LAST_DAY IN VARCHAR2,
195 X_DAY_1 IN VARCHAR2,
196 X_DAY_2 IN VARCHAR2,
197 X_DAY_3 IN VARCHAR2,
198 X_DAY_4 IN VARCHAR2,
199 X_DAY_5 IN VARCHAR2,
200 X_DAY_6 IN VARCHAR2,
201 X_DAY_7 IN VARCHAR2,
202 X_DAY_8 IN VARCHAR2,
203 X_DAY_9 IN VARCHAR2,
204 X_DAY_10 IN VARCHAR2,
205 X_DAY_11 IN VARCHAR2,
206 X_DAY_12 IN VARCHAR2,
207 X_DAY_13 IN VARCHAR2,
208 X_DAY_14 IN VARCHAR2,
209 X_DAY_15 IN VARCHAR2,
210 X_DAY_16 IN VARCHAR2,
211 X_DAY_17 IN VARCHAR2,
212 X_DAY_18 IN VARCHAR2,
213 X_DAY_19 IN VARCHAR2,
214 X_DAY_20 IN VARCHAR2,
215 X_DAY_21 IN VARCHAR2,
216 X_DAY_22 IN VARCHAR2,
217 X_DAY_23 IN VARCHAR2,
218 X_DAY_24 IN VARCHAR2,
219 X_DAY_25 IN VARCHAR2,
220 X_DAY_26 IN VARCHAR2,
221 X_DAY_27 IN VARCHAR2,
222 X_DAY_28 IN VARCHAR2,
223 X_DAY_29 IN VARCHAR2,
224 X_DAY_30 IN VARCHAR2,
225 X_DAY_31 IN VARCHAR2,
226 X_DAY_MONDAY IN VARCHAR2,
227 X_DAY_TUESDAY IN VARCHAR2,
228 X_DAY_WEDNESDAY IN VARCHAR2,
229 X_DAY_THURSDAY IN VARCHAR2,
230 X_DAY_FRIDAY IN VARCHAR2,
231 X_DAY_SATURDAY IN VARCHAR2,
232 X_DAY_SUNDAY IN VARCHAR2,
233 X_SKIP_WEEKENDS IN VARCHAR2,
234 X_SKIP_HOLIDAYS IN VARCHAR2,
235 X_REPEAT_DAILY IN NUMBER,
236 X_REPEAT_WEEKLY IN NUMBER,
237 X_REPEAT_MONTHLY IN NUMBER,
238 X_DAY_TYPE IN VARCHAR2,
239 X_OWNER IN VARCHAR2
240 );
241
242 END AR_CONS_BILL_CYCLE_PKG;