eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.AR_CONS_BILL_CYCLE_PKG

Source


1 package AR_CONS_BILL_CYCLE_PKG AUTHID CURRENT_USER 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;