[Home] [Help]
PACKAGE: APPS.OKL_PROCESS_BUCKETS_PVT
Source
1 PACKAGE OKL_PROCESS_BUCKETS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRBUKS.pls 115.1 2002/02/06 20:31:25 pkm ship $ */
3
4 SUBTYPE bktv_rec_type IS OKL_BUCKETS_PUB.bktv_rec_type;
5 SUBTYPE bktv_tbl_type IS OKL_BUCKETS_PUB.bktv_tbl_type;
6
7 ---------------------------------------------------------------------------
8 -- GLOBAL VARIABLES
9 ---------------------------------------------------------------------------
10 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
11 G_VERSION_OVERLAPS CONSTANT VARCHAR2(200) := 'OKL_VERSION_OVERLAPS';
12 G_DATES_MISMATCH CONSTANT VARCHAR2(200) := 'OKL_DATES_MISMATCH';
13 G_PAST_RECORDS CONSTANT VARCHAR2(200) := 'OKL_PAST_RECORDS';
14 G_START_DATE CONSTANT VARCHAR2(200) := 'OKL_START_DATE';
15 G_END_DATE CONSTANT VARCHAR2(200) := 'OKL_END_DATE';
16 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
17 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
18 G_TABLE_TOKEN CONSTANT VARCHAR2(100) := 'OKL_TABLE_NAME';
19 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
20 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
21 G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;
22
23 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
24 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_PROCESS_BUCKETS_PVT';
25
26 G_INIT_VERSION CONSTANT NUMBER := 1.0;
27 G_VERSION_MAJOR_INCREMENT CONSTANT NUMBER := 1.0;
28 G_VERSION_MINOR_INCREMENT CONSTANT NUMBER := 0.1;
29 G_VERSION_FORMAT CONSTANT VARCHAR2(100) := 'FM999.0999';
30
31 G_EXCEPTION_HALT_PROCESSING EXCEPTION;
32
33 PROCEDURE create_buckets(
34 p_api_version IN NUMBER,
35 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2,
39 p_bktv_rec IN bktv_rec_type,
40 x_bktv_rec OUT NOCOPY bktv_rec_type);
41
42 PROCEDURE create_buckets(
43 p_api_version IN NUMBER,
44 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_msg_count OUT NOCOPY NUMBER,
47 x_msg_data OUT NOCOPY VARCHAR2,
48 p_bktv_tbl IN bktv_tbl_type,
49 x_bktv_tbl OUT NOCOPY bktv_tbl_type);
50
51
52 PROCEDURE update_buckets(
53 p_api_version IN NUMBER,
54 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2,
58 p_bktv_rec IN bktv_rec_type,
59 x_bktv_rec OUT NOCOPY bktv_rec_type);
60
61 PROCEDURE update_buckets(
62 p_api_version IN NUMBER,
63 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2,
67 p_bktv_tbl IN bktv_tbl_type,
68 x_bktv_tbl OUT NOCOPY bktv_tbl_type);
69
70 PROCEDURE delete_buckets(
71 p_api_version IN NUMBER,
72 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2,
76 p_bktv_rec IN bktv_rec_type);
77
78 PROCEDURE delete_buckets(
79 p_api_version IN NUMBER,
80 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2,
84 p_bktv_tbl IN bktv_tbl_type);
85
86
87 END OKL_PROCESS_BUCKETS_PVT;