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.OKS_BPE_PVT

Source


1 PACKAGE OKS_BPE_PVT AS
2 /* $Header: OKSSBPES.pls 120.0 2005/05/25 18:36:18 appldev noship $ */
3   ---------------------------------------------------------------------------
4   -- GLOBAL DATASTRUCTURES
5   ---------------------------------------------------------------------------
6   -- OKS_BILLING_PROFILES_V Record Spec
7   TYPE bpev_rec_type IS RECORD (
8      id                             NUMBER := OKC_API.G_MISS_NUM
9     ,object_version_number          NUMBER := OKC_API.G_MISS_NUM
10     ,sfwt_flag                      OKS_BILLING_PROFILES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
11     ,mda_code                       OKS_BILLING_PROFILES_V.MDA_CODE%TYPE := OKC_API.G_MISS_CHAR
12     ,owned_party_id1                OKS_BILLING_PROFILES_V.OWNED_PARTY_ID1%TYPE := OKC_API.G_MISS_CHAR
13     ,owned_party_id2                OKS_BILLING_PROFILES_V.OWNED_PARTY_ID2%TYPE := OKC_API.G_MISS_CHAR
14     ,dependent_cust_acct_id1        OKS_BILLING_PROFILES_V.DEPENDENT_CUST_ACCT_ID1%TYPE := OKC_API.G_MISS_CHAR
15     ,dependent_cust_acct_id2        OKS_BILLING_PROFILES_V.DEPENDENT_CUST_ACCT_ID2%TYPE := OKC_API.G_MISS_CHAR
16     ,bill_to_address_id1            OKS_BILLING_PROFILES_V.BILL_TO_ADDRESS_ID1%TYPE := OKC_API.G_MISS_CHAR
17     ,bill_to_address_id2            OKS_BILLING_PROFILES_V.BILL_TO_ADDRESS_ID2%TYPE := OKC_API.G_MISS_CHAR
18     ,uom_code_frequency             OKS_BILLING_PROFILES_V.UOM_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
19     ,tce_code_frequency             OKS_BILLING_PROFILES_V.TCE_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
20     ,uom_code_sec_offset            OKS_BILLING_PROFILES_V.UOM_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
21     ,tce_code_sec_offset            OKS_BILLING_PROFILES_V.TCE_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
22     ,uom_code_pri_offset            OKS_BILLING_PROFILES_V.UOM_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
23     ,tce_code_pri_offset            OKS_BILLING_PROFILES_V.TCE_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
24     ,profile_number                 OKS_BILLING_PROFILES_V.PROFILE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
25     ,summarised_yn                  OKS_BILLING_PROFILES_V.SUMMARISED_YN%TYPE := OKC_API.G_MISS_CHAR
26     ,reg_invoice_pri_offset         NUMBER := OKC_API.G_MISS_NUM
27     ,reg_invoice_sec_offset         NUMBER := OKC_API.G_MISS_NUM
28     ,first_billto_date              OKS_BILLING_PROFILES_V.FIRST_BILLTO_DATE%TYPE := OKC_API.G_MISS_DATE
29     ,first_invoice_date             OKS_BILLING_PROFILES_V.FIRST_INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE
30     ,message                        OKS_BILLING_PROFILES_V.MESSAGE%TYPE := OKC_API.G_MISS_CHAR
31     ,description                    OKS_BILLING_PROFILES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
32     ,instructions                   OKS_BILLING_PROFILES_V.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR
33     ,attribute_category             OKS_BILLING_PROFILES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
34     ,attribute1                     OKS_BILLING_PROFILES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
35     ,attribute2                     OKS_BILLING_PROFILES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
36     ,attribute3                     OKS_BILLING_PROFILES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
37     ,attribute4                     OKS_BILLING_PROFILES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
38     ,attribute5                     OKS_BILLING_PROFILES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
39     ,attribute6                     OKS_BILLING_PROFILES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
40     ,attribute7                     OKS_BILLING_PROFILES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
41     ,attribute8                     OKS_BILLING_PROFILES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
42     ,attribute9                     OKS_BILLING_PROFILES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
43     ,attribute10                    OKS_BILLING_PROFILES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
44     ,attribute11                    OKS_BILLING_PROFILES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
45     ,attribute12                    OKS_BILLING_PROFILES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
46     ,attribute13                    OKS_BILLING_PROFILES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
47     ,attribute14                    OKS_BILLING_PROFILES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
48     ,attribute15                    OKS_BILLING_PROFILES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
49     ,created_by                     NUMBER := OKC_API.G_MISS_NUM
50     ,creation_date                  OKS_BILLING_PROFILES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
51     ,last_updated_by                NUMBER := OKC_API.G_MISS_NUM
52     ,last_update_date               OKS_BILLING_PROFILES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
53     ,last_update_login              NUMBER := OKC_API.G_MISS_NUM
54     ,invoice_object1_id1            OKS_BILLING_PROFILES_V.INVOICE_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
55     ,invoice_object1_id2            OKS_BILLING_PROFILES_V.INVOICE_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
56     ,invoice_jtot_object1_code      OKS_BILLING_PROFILES_V.INVOICE_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
57     ,account_object1_id1            OKS_BILLING_PROFILES_V.ACCOUNT_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
58     ,account_object1_id2            OKS_BILLING_PROFILES_V.ACCOUNT_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
59     ,account_jtot_object1_code      OKS_BILLING_PROFILES_V.ACCOUNT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
60     ,billing_level                  OKS_BILLING_PROFILES_V.BILLING_LEVEL%TYPE := OKC_API.G_MISS_CHAR
61     ,billing_type                   OKS_BILLING_PROFILES_V.BILLING_TYPE%TYPE := OKC_API.G_MISS_CHAR
62     ,interval                       OKS_BILLING_PROFILES_V.INTERVAL%TYPE := OKC_API.G_MISS_CHAR
63     ,interface_offset               NUMBER := OKC_API.G_MISS_NUM
64     ,invoice_offset                 NUMBER := OKC_API.G_MISS_NUM);
65   G_MISS_bpev_rec                         bpev_rec_type;
66   TYPE bpev_tbl_type IS TABLE OF bpev_rec_type
67         INDEX BY BINARY_INTEGER;
68   -- OKS_BILLING_PROFILES_B Record Spec
69   TYPE bpe_rec_type IS RECORD (
70      id                             NUMBER := OKC_API.G_MISS_NUM
71     ,mda_code                       OKS_BILLING_PROFILES_B.MDA_CODE%TYPE := OKC_API.G_MISS_CHAR
72     ,owned_party_id1                OKS_BILLING_PROFILES_B.OWNED_PARTY_ID1%TYPE := OKC_API.G_MISS_CHAR
73     ,owned_party_id2                OKS_BILLING_PROFILES_B.OWNED_PARTY_ID2%TYPE := OKC_API.G_MISS_CHAR
74     ,dependent_cust_acct_id1        OKS_BILLING_PROFILES_B.DEPENDENT_CUST_ACCT_ID1%TYPE := OKC_API.G_MISS_CHAR
75     ,dependent_cust_acct_id2        OKS_BILLING_PROFILES_B.DEPENDENT_CUST_ACCT_ID2%TYPE := OKC_API.G_MISS_CHAR
76     ,bill_to_address_id1            OKS_BILLING_PROFILES_B.BILL_TO_ADDRESS_ID1%TYPE := OKC_API.G_MISS_CHAR
77     ,bill_to_address_id2            OKS_BILLING_PROFILES_B.BILL_TO_ADDRESS_ID2%TYPE := OKC_API.G_MISS_CHAR
78     ,uom_code_frequency             OKS_BILLING_PROFILES_B.UOM_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
79     ,tce_code_frequency             OKS_BILLING_PROFILES_B.TCE_CODE_FREQUENCY%TYPE := OKC_API.G_MISS_CHAR
80     ,uom_code_sec_offset            OKS_BILLING_PROFILES_B.UOM_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
81     ,tce_code_sec_offset            OKS_BILLING_PROFILES_B.TCE_CODE_SEC_OFFSET%TYPE := OKC_API.G_MISS_CHAR
82     ,uom_code_pri_offset            OKS_BILLING_PROFILES_B.UOM_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
83     ,tce_code_pri_offset            OKS_BILLING_PROFILES_B.TCE_CODE_PRI_OFFSET%TYPE := OKC_API.G_MISS_CHAR
84     ,profile_number                 OKS_BILLING_PROFILES_B.PROFILE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
85     ,summarised_yn                  OKS_BILLING_PROFILES_B.SUMMARISED_YN%TYPE := OKC_API.G_MISS_CHAR
86     ,reg_invoice_pri_offset         NUMBER := OKC_API.G_MISS_NUM
87     ,reg_invoice_sec_offset         NUMBER := OKC_API.G_MISS_NUM
88     ,first_billto_date              OKS_BILLING_PROFILES_B.FIRST_BILLTO_DATE%TYPE := OKC_API.G_MISS_DATE
89     ,first_invoice_date             OKS_BILLING_PROFILES_B.FIRST_INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE
90     ,object_version_number          NUMBER := OKC_API.G_MISS_NUM
91     ,created_by                     NUMBER := OKC_API.G_MISS_NUM
92     ,creation_date                  OKS_BILLING_PROFILES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
93     ,last_updated_by                NUMBER := OKC_API.G_MISS_NUM
94     ,last_update_date               OKS_BILLING_PROFILES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
95     ,last_update_login              NUMBER := OKC_API.G_MISS_NUM
96     ,attribute_category             OKS_BILLING_PROFILES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
97     ,attribute1                     OKS_BILLING_PROFILES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
98     ,attribute2                     OKS_BILLING_PROFILES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
99     ,attribute3                     OKS_BILLING_PROFILES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
100     ,attribute4                     OKS_BILLING_PROFILES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
101     ,attribute5                     OKS_BILLING_PROFILES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
102     ,attribute6                     OKS_BILLING_PROFILES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
103     ,attribute7                     OKS_BILLING_PROFILES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
104     ,attribute8                     OKS_BILLING_PROFILES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
105     ,attribute9                     OKS_BILLING_PROFILES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
106     ,attribute10                    OKS_BILLING_PROFILES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
107     ,attribute11                    OKS_BILLING_PROFILES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
108     ,attribute12                    OKS_BILLING_PROFILES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
109     ,attribute13                    OKS_BILLING_PROFILES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
110     ,attribute14                    OKS_BILLING_PROFILES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
111     ,attribute15                    OKS_BILLING_PROFILES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
112     ,invoice_object1_id1            OKS_BILLING_PROFILES_B.INVOICE_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
113     ,invoice_object1_id2            OKS_BILLING_PROFILES_B.INVOICE_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
114     ,invoice_jtot_object1_code      OKS_BILLING_PROFILES_B.INVOICE_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
115     ,account_object1_id1            OKS_BILLING_PROFILES_B.ACCOUNT_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
116     ,account_object1_id2            OKS_BILLING_PROFILES_B.ACCOUNT_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
117     ,account_jtot_object1_code      OKS_BILLING_PROFILES_B.ACCOUNT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
118     ,billing_level                  OKS_BILLING_PROFILES_B.BILLING_LEVEL%TYPE := OKC_API.G_MISS_CHAR
119     ,billing_type                   OKS_BILLING_PROFILES_B.BILLING_TYPE%TYPE := OKC_API.G_MISS_CHAR
120     ,interval                       OKS_BILLING_PROFILES_B.INTERVAL%TYPE := OKC_API.G_MISS_CHAR
121     ,interface_offset               NUMBER := OKC_API.G_MISS_NUM
122     ,invoice_offset                 NUMBER := OKC_API.G_MISS_NUM);
123   G_MISS_bpe_rec                          bpe_rec_type;
124   TYPE bpe_tbl_type IS TABLE OF bpe_rec_type
125         INDEX BY BINARY_INTEGER;
126   -- OKS_BILLING_PROFILES_TL Record Spec
127   TYPE bpt_rec_type IS RECORD (
128      id                             NUMBER := OKC_API.G_MISS_NUM
129     ,language                       OKS_BILLING_PROFILES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
130     ,source_lang                    OKS_BILLING_PROFILES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
131     ,sfwt_flag                      OKS_BILLING_PROFILES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
132     ,description                    OKS_BILLING_PROFILES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
133     ,instructions                   OKS_BILLING_PROFILES_TL.INSTRUCTIONS%TYPE := OKC_API.G_MISS_CHAR
134     ,message                        OKS_BILLING_PROFILES_TL.MESSAGE%TYPE := OKC_API.G_MISS_CHAR
135     ,created_by                     NUMBER := OKC_API.G_MISS_NUM
136     ,creation_date                  OKS_BILLING_PROFILES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
137     ,last_updated_by                NUMBER := OKC_API.G_MISS_NUM
138     ,last_update_date               OKS_BILLING_PROFILES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
139     ,last_update_login              NUMBER := OKC_API.G_MISS_NUM);
140   G_MISS_bpt_rec                          bpt_rec_type;
141   TYPE bpt_tbl_type IS TABLE OF bpt_rec_type
142         INDEX BY BINARY_INTEGER;
143   ---------------------------------------------------------------------------
144   -- GLOBAL MESSAGE CONSTANTS
145   ---------------------------------------------------------------------------
146   G_FND_APP                      CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
147   G_FORM_UNABLE_TO_RESERVE_REC   CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
148   G_FORM_RECORD_DELETED          CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
149   G_FORM_RECORD_CHANGED          CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
150   G_RECORD_LOGICALLY_DELETED     CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
151   G_REQUIRED_VALUE               CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
152   G_INVALID_VALUE                CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
153   G_COL_NAME_TOKEN               CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
154   G_PARENT_TABLE_TOKEN           CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
155   G_CHILD_TABLE_TOKEN            CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
156   G_UNEXPECTED_ERROR             CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
157   G_SQLCODE_TOKEN                CONSTANT VARCHAR2(200) := 'SQLcode';
158   G_SQLERRM_TOKEN                CONSTANT VARCHAR2(200) := 'SQLerrm';
159 
160   ---------------------------------------------------------------------------
161   -- GLOBAL EXCEPTIONS
162   ---------------------------------------------------------------------------
163   G_EXCEPTION_HALT_VALIDATION    EXCEPTION;
164 
165   ---------------------------------------------------------------------------
166   -- GLOBAL VARIABLES
167   ---------------------------------------------------------------------------
168   G_PKG_NAME                     CONSTANT VARCHAR2(200) := 'OKS_BPE_PVT';
169   G_APP_NAME                     CONSTANT VARCHAR2(3)   := OKC_API.G_APP_NAME;
170   ---------------------------------------------------------------------------
171   -- Procedures and Functions
172   ---------------------------------------------------------------------------
173 
174   PROCEDURE qc;
175   PROCEDURE change_version;
176   PROCEDURE api_copy;
177   PROCEDURE add_language;
178   PROCEDURE insert_row(
179     p_api_version                  IN NUMBER,
180     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
181     x_return_status                OUT NOCOPY VARCHAR2,
182     x_msg_count                    OUT NOCOPY NUMBER,
183     x_msg_data                     OUT NOCOPY VARCHAR2,
184     p_bpev_rec                     IN bpev_rec_type,
185     x_bpev_rec                     OUT NOCOPY bpev_rec_type);
186   PROCEDURE insert_row(
187     p_api_version                  IN NUMBER,
188     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
189     x_return_status                OUT NOCOPY VARCHAR2,
190     x_msg_count                    OUT NOCOPY NUMBER,
191     x_msg_data                     OUT NOCOPY VARCHAR2,
192     p_bpev_tbl                     IN bpev_tbl_type,
193     x_bpev_tbl                     OUT NOCOPY bpev_tbl_type,
194     px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
195   PROCEDURE insert_row(
196     p_api_version                  IN NUMBER,
197     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
198     x_return_status                OUT NOCOPY VARCHAR2,
199     x_msg_count                    OUT NOCOPY NUMBER,
200     x_msg_data                     OUT NOCOPY VARCHAR2,
201     p_bpev_tbl                     IN bpev_tbl_type,
202     x_bpev_tbl                     OUT NOCOPY bpev_tbl_type);
203   PROCEDURE lock_row(
204     p_api_version                  IN NUMBER,
205     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
206     x_return_status                OUT NOCOPY VARCHAR2,
207     x_msg_count                    OUT NOCOPY NUMBER,
208     x_msg_data                     OUT NOCOPY VARCHAR2,
209     p_bpev_rec                     IN bpev_rec_type);
210   PROCEDURE lock_row(
211     p_api_version                  IN NUMBER,
212     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
213     x_return_status                OUT NOCOPY VARCHAR2,
214     x_msg_count                    OUT NOCOPY NUMBER,
215     x_msg_data                     OUT NOCOPY VARCHAR2,
216     p_bpev_tbl                     IN bpev_tbl_type,
217     px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
218   PROCEDURE lock_row(
219     p_api_version                  IN NUMBER,
220     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
221     x_return_status                OUT NOCOPY VARCHAR2,
222     x_msg_count                    OUT NOCOPY NUMBER,
223     x_msg_data                     OUT NOCOPY VARCHAR2,
224     p_bpev_tbl                     IN bpev_tbl_type);
225   PROCEDURE update_row(
226     p_api_version                  IN NUMBER,
227     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
228     x_return_status                OUT NOCOPY VARCHAR2,
229     x_msg_count                    OUT NOCOPY NUMBER,
230     x_msg_data                     OUT NOCOPY VARCHAR2,
231     p_bpev_rec                     IN bpev_rec_type,
232     x_bpev_rec                     OUT NOCOPY bpev_rec_type);
233   PROCEDURE update_row(
234     p_api_version                  IN NUMBER,
235     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
236     x_return_status                OUT NOCOPY VARCHAR2,
237     x_msg_count                    OUT NOCOPY NUMBER,
238     x_msg_data                     OUT NOCOPY VARCHAR2,
239     p_bpev_tbl                     IN bpev_tbl_type,
240     x_bpev_tbl                     OUT NOCOPY bpev_tbl_type,
241     px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
242   PROCEDURE update_row(
243     p_api_version                  IN NUMBER,
244     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
245     x_return_status                OUT NOCOPY VARCHAR2,
246     x_msg_count                    OUT NOCOPY NUMBER,
247     x_msg_data                     OUT NOCOPY VARCHAR2,
248     p_bpev_tbl                     IN bpev_tbl_type,
249     x_bpev_tbl                     OUT NOCOPY bpev_tbl_type);
250   PROCEDURE delete_row(
251     p_api_version                  IN NUMBER,
252     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
253     x_return_status                OUT NOCOPY VARCHAR2,
254     x_msg_count                    OUT NOCOPY NUMBER,
255     x_msg_data                     OUT NOCOPY VARCHAR2,
256     p_bpev_rec                     IN bpev_rec_type);
257   PROCEDURE delete_row(
258     p_api_version                  IN NUMBER,
259     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
260     x_return_status                OUT NOCOPY VARCHAR2,
261     x_msg_count                    OUT NOCOPY NUMBER,
262     x_msg_data                     OUT NOCOPY VARCHAR2,
263     p_bpev_tbl                     IN bpev_tbl_type,
264     px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
265   PROCEDURE delete_row(
266     p_api_version                  IN NUMBER,
267     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
268     x_return_status                OUT NOCOPY VARCHAR2,
269     x_msg_count                    OUT NOCOPY NUMBER,
270     x_msg_data                     OUT NOCOPY VARCHAR2,
271     p_bpev_tbl                     IN bpev_tbl_type);
272   PROCEDURE validate_row(
273     p_api_version                  IN NUMBER,
274     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
275     x_return_status                OUT NOCOPY VARCHAR2,
276     x_msg_count                    OUT NOCOPY NUMBER,
277     x_msg_data                     OUT NOCOPY VARCHAR2,
278     p_bpev_rec                     IN bpev_rec_type);
279   PROCEDURE validate_row(
280     p_api_version                  IN NUMBER,
281     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
282     x_return_status                OUT NOCOPY VARCHAR2,
283     x_msg_count                    OUT NOCOPY NUMBER,
284     x_msg_data                     OUT NOCOPY VARCHAR2,
285     p_bpev_tbl                     IN bpev_tbl_type,
286     px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
287   PROCEDURE validate_row(
288     p_api_version                  IN NUMBER,
289     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
290     x_return_status                OUT NOCOPY VARCHAR2,
291     x_msg_count                    OUT NOCOPY NUMBER,
292     x_msg_data                     OUT NOCOPY VARCHAR2,
293     p_bpev_tbl                     IN bpev_tbl_type);
294 END OKS_BPE_PVT;