[Home] [Help]
PACKAGE: APPS.OKS_BRS_PVT
Source
1 PACKAGE OKS_BRS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKSSBRSS.pls 120.0 2005/05/25 18:11:16 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKS_BILLRATE_SCHEDULES_V Record Spec
7 TYPE OksBillrateSchedulesVRecType IS RECORD (
8 id NUMBER := OKC_API.G_MISS_NUM
9 ,cle_id NUMBER := OKC_API.G_MISS_NUM
10 ,bt_cle_id NUMBER := OKC_API.G_MISS_NUM
11 ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
12 ,start_hour NUMBER := OKC_API.G_MISS_NUM
13 ,start_minute NUMBER := OKC_API.G_MISS_NUM
14 ,end_hour NUMBER := OKC_API.G_MISS_NUM
15 ,end_minute NUMBER := OKC_API.G_MISS_NUM
16 ,monday_flag OKS_BILLRATE_SCHEDULES_V.MONDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
17 ,tuesday_flag OKS_BILLRATE_SCHEDULES_V.TUESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
18 ,wednesday_flag OKS_BILLRATE_SCHEDULES_V.WEDNESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
19 ,thursday_flag OKS_BILLRATE_SCHEDULES_V.THURSDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
20 ,friday_flag OKS_BILLRATE_SCHEDULES_V.FRIDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
21 ,saturday_flag OKS_BILLRATE_SCHEDULES_V.SATURDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
22 ,sunday_flag OKS_BILLRATE_SCHEDULES_V.SUNDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
23 ,object1_id1 OKS_BILLRATE_SCHEDULES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
24 ,object1_id2 OKS_BILLRATE_SCHEDULES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
25 ,jtot_object1_code OKS_BILLRATE_SCHEDULES_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
26 ,bill_rate_code OKS_BILLRATE_SCHEDULES_V.BILL_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
27 ,uom OKS_BILLRATE_SCHEDULES_V.UOM%TYPE := OKC_API.G_MISS_CHAR
28 ,flat_rate NUMBER := OKC_API.G_MISS_NUM
29 ,holiday_yn OKS_BILLRATE_SCHEDULES_V.HOLIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
30 ,percent_over_list_price NUMBER := OKC_API.G_MISS_NUM
31 ,program_application_id NUMBER := OKC_API.G_MISS_NUM
32 ,program_id NUMBER := OKC_API.G_MISS_NUM
33 ,program_update_date OKS_BILLRATE_SCHEDULES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
34 ,request_id NUMBER := OKC_API.G_MISS_NUM
35 ,created_by NUMBER := OKC_API.G_MISS_NUM
36 ,creation_date OKS_BILLRATE_SCHEDULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
37 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
38 ,last_update_date OKS_BILLRATE_SCHEDULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
39 ,last_update_login NUMBER := OKC_API.G_MISS_NUM
40 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
41 ,security_group_id NUMBER := OKC_API.G_MISS_NUM);
42 GMissOksBillrateSchedulesVRec OksBillrateSchedulesVRecType;
43 TYPE OksBillrateSchedulesVTblType IS TABLE OF OksBillrateSchedulesVRecType
44 INDEX BY BINARY_INTEGER;
45 -- OKS_BILLRATE_SCHEDULES Record Spec
46 TYPE OksBillrateSchedulesRecType IS RECORD (
47 id NUMBER := OKC_API.G_MISS_NUM
48 ,cle_id NUMBER := OKC_API.G_MISS_NUM
49 ,bt_cle_id NUMBER := OKC_API.G_MISS_NUM
50 ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
51 ,start_hour NUMBER := OKC_API.G_MISS_NUM
52 ,start_minute NUMBER := OKC_API.G_MISS_NUM
53 ,end_hour NUMBER := OKC_API.G_MISS_NUM
54 ,end_minute NUMBER := OKC_API.G_MISS_NUM
55 ,monday_flag OKS_BILLRATE_SCHEDULES.MONDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
56 ,tuesday_flag OKS_BILLRATE_SCHEDULES.TUESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
57 ,wednesday_flag OKS_BILLRATE_SCHEDULES.WEDNESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
58 ,thursday_flag OKS_BILLRATE_SCHEDULES.THURSDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
59 ,friday_flag OKS_BILLRATE_SCHEDULES.FRIDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
60 ,saturday_flag OKS_BILLRATE_SCHEDULES.SATURDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
61 ,sunday_flag OKS_BILLRATE_SCHEDULES.SUNDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
62 ,object1_id1 OKS_BILLRATE_SCHEDULES.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
63 ,object1_id2 OKS_BILLRATE_SCHEDULES.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
64 ,jtot_object1_code OKS_BILLRATE_SCHEDULES.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
65 ,bill_rate_code OKS_BILLRATE_SCHEDULES.BILL_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
66 ,flat_rate NUMBER := OKC_API.G_MISS_NUM
67 ,uom OKS_BILLRATE_SCHEDULES.UOM%TYPE := OKC_API.G_MISS_CHAR
68 ,holiday_yn OKS_BILLRATE_SCHEDULES.HOLIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
69 ,percent_over_list_price NUMBER := OKC_API.G_MISS_NUM
70 ,program_application_id NUMBER := OKC_API.G_MISS_NUM
71 ,program_id NUMBER := OKC_API.G_MISS_NUM
72 ,program_update_date OKS_BILLRATE_SCHEDULES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
73 ,request_id NUMBER := OKC_API.G_MISS_NUM
74 ,created_by NUMBER := OKC_API.G_MISS_NUM
75 ,creation_date OKS_BILLRATE_SCHEDULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
76 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
77 ,last_update_date OKS_BILLRATE_SCHEDULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
78 ,last_update_login NUMBER := OKC_API.G_MISS_NUM
79 ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
80 GMissOksBillrateSchedulesRec OksBillrateSchedulesRecType;
81 TYPE OksBillrateSchedulesTblType IS TABLE OF OksBillrateSchedulesRecType
82 INDEX BY BINARY_INTEGER;
83 ---------------------------------------------------------------------------
84 -- GLOBAL MESSAGE CONSTANTS
85 ---------------------------------------------------------------------------
86 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
87 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
88 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
89 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
90 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
91 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
92 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
93 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
94 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
95 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
96 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
97 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
98 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
99
100 ---------------------------------------------------------------------------
101 -- GLOBAL EXCEPTIONS
102 ---------------------------------------------------------------------------
103 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
104
105 ---------------------------------------------------------------------------
106 -- GLOBAL VARIABLES
107 ---------------------------------------------------------------------------
108 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_BRS_PVT';
109 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
110 ---------------------------------------------------------------------------
111 -- Procedures and Functions
112 ---------------------------------------------------------------------------
113
114 PROCEDURE qc;
115 PROCEDURE change_version;
116 PROCEDURE api_copy;
117 PROCEDURE insert_row(
118 p_api_version IN NUMBER,
119 p_init_msg_list IN VARCHAR2,
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_msg_count OUT NOCOPY NUMBER,
122 x_msg_data OUT NOCOPY VARCHAR2,
123 p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType,
124 x_oks_billrate_schedules_v_rec OUT NOCOPY OksBillrateSchedulesVRecType);
125 PROCEDURE insert_row(
126 p_api_version IN NUMBER,
127 p_init_msg_list IN VARCHAR2,
128 x_return_status OUT NOCOPY VARCHAR2,
129 x_msg_count OUT NOCOPY NUMBER,
130 x_msg_data OUT NOCOPY VARCHAR2,
131 p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,
132 x_oks_billrate_schedules_v_tbl OUT NOCOPY OksBillrateSchedulesVTblType,
133 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
134 PROCEDURE insert_row(
135 p_api_version IN NUMBER,
136 p_init_msg_list IN VARCHAR2,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139 x_msg_data OUT NOCOPY VARCHAR2,
140 p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,
141 x_oks_billrate_schedules_v_tbl OUT NOCOPY OksBillrateSchedulesVTblType);
142 PROCEDURE lock_row(
143 p_api_version IN NUMBER,
144 p_init_msg_list IN VARCHAR2,
145 x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_count OUT NOCOPY NUMBER,
147 x_msg_data OUT NOCOPY VARCHAR2,
148 p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType);
149 PROCEDURE lock_row(
150 p_api_version IN NUMBER,
151 p_init_msg_list IN VARCHAR2,
152 x_return_status OUT NOCOPY VARCHAR2,
153 x_msg_count OUT NOCOPY NUMBER,
154 x_msg_data OUT NOCOPY VARCHAR2,
155 p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,
156 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
157 PROCEDURE lock_row(
158 p_api_version IN NUMBER,
159 p_init_msg_list IN VARCHAR2,
160 x_return_status OUT NOCOPY VARCHAR2,
161 x_msg_count OUT NOCOPY NUMBER,
162 x_msg_data OUT NOCOPY VARCHAR2,
163 p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType);
164 PROCEDURE update_row(
165 p_api_version IN NUMBER,
166 p_init_msg_list IN VARCHAR2,
167 x_return_status OUT NOCOPY VARCHAR2,
168 x_msg_count OUT NOCOPY NUMBER,
169 x_msg_data OUT NOCOPY VARCHAR2,
170 p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType,
171 x_oks_billrate_schedules_v_rec OUT NOCOPY OksBillrateSchedulesVRecType);
172 PROCEDURE update_row(
173 p_api_version IN NUMBER,
174 p_init_msg_list IN VARCHAR2,
175 x_return_status OUT NOCOPY VARCHAR2,
176 x_msg_count OUT NOCOPY NUMBER,
177 x_msg_data OUT NOCOPY VARCHAR2,
178 p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,
179 x_oks_billrate_schedules_v_tbl OUT NOCOPY OksBillrateSchedulesVTblType,
180 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
181 PROCEDURE update_row(
182 p_api_version IN NUMBER,
183 p_init_msg_list IN VARCHAR2,
184 x_return_status OUT NOCOPY VARCHAR2,
185 x_msg_count OUT NOCOPY NUMBER,
186 x_msg_data OUT NOCOPY VARCHAR2,
187 p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,
188 x_oks_billrate_schedules_v_tbl OUT NOCOPY OksBillrateSchedulesVTblType);
189 PROCEDURE delete_row(
190 p_api_version IN NUMBER,
191 p_init_msg_list IN VARCHAR2,
192 x_return_status OUT NOCOPY VARCHAR2,
193 x_msg_count OUT NOCOPY NUMBER,
194 x_msg_data OUT NOCOPY VARCHAR2,
195 p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType);
196 PROCEDURE delete_row(
197 p_api_version IN NUMBER,
198 p_init_msg_list IN VARCHAR2,
199 x_return_status OUT NOCOPY VARCHAR2,
200 x_msg_count OUT NOCOPY NUMBER,
201 x_msg_data OUT NOCOPY VARCHAR2,
202 p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,
203 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
204 PROCEDURE delete_row(
205 p_api_version IN NUMBER,
206 p_init_msg_list IN VARCHAR2,
207 x_return_status OUT NOCOPY VARCHAR2,
208 x_msg_count OUT NOCOPY NUMBER,
209 x_msg_data OUT NOCOPY VARCHAR2,
210 p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType);
211 PROCEDURE validate_row(
212 p_api_version IN NUMBER,
213 p_init_msg_list IN VARCHAR2,
214 x_return_status OUT NOCOPY VARCHAR2,
215 x_msg_count OUT NOCOPY NUMBER,
216 x_msg_data OUT NOCOPY VARCHAR2,
217 p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType);
218 PROCEDURE validate_row(
219 p_api_version IN NUMBER,
220 p_init_msg_list IN VARCHAR2,
221 x_return_status OUT NOCOPY VARCHAR2,
222 x_msg_count OUT NOCOPY NUMBER,
223 x_msg_data OUT NOCOPY VARCHAR2,
224 p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,
225 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
226 PROCEDURE validate_row(
227 p_api_version IN NUMBER,
228 p_init_msg_list IN VARCHAR2,
229 x_return_status OUT NOCOPY VARCHAR2,
230 x_msg_count OUT NOCOPY NUMBER,
231 x_msg_data OUT NOCOPY VARCHAR2,
232 p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType);
233
234
235 FUNCTION Create_Version(
236 p_id IN NUMBER,
237 p_major_version IN NUMBER) RETURN VARCHAR2;
238
239 FUNCTION restore_version(
240 p_id IN NUMBER,
241 p_major_version IN NUMBER) RETURN VARCHAR2;
242
243
244
245
246 END OKS_BRS_PVT;