[Home] [Help]
PACKAGE: APPS.OKL_BKT_PVT
Source
1 PACKAGE OKL_BKT_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSBKTS.pls 115.5 2002/02/05 12:15:12 pkm ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE bkt_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 ibc_id NUMBER := OKC_API.G_MISS_NUM,
9 version OKL_BUCKETS.VERSION%TYPE := OKC_API.G_MISS_CHAR,
10 loss_rate NUMBER := OKC_API.G_MISS_NUM,
11 object_version_number NUMBER := OKC_API.G_MISS_NUM,
12 comments OKL_BUCKETS.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
13 program_id NUMBER := OKC_API.G_MISS_NUM,
14 request_id NUMBER := OKC_API.G_MISS_NUM,
15 program_application_id NUMBER := OKC_API.G_MISS_NUM,
16 program_update_date OKL_BUCKETS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17 start_date OKL_BUCKETS.START_DATE%TYPE := OKC_API.G_MISS_DATE,
18 end_date OKL_BUCKETS.END_DATE%TYPE := OKC_API.G_MISS_DATE,
19 created_by NUMBER := OKC_API.G_MISS_NUM,
20 creation_date OKL_BUCKETS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
21 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
22 last_update_date OKL_BUCKETS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
23 last_update_login NUMBER := OKC_API.G_MISS_NUM);
24 g_miss_bkt_rec bkt_rec_type;
25 TYPE bkt_tbl_type IS TABLE OF bkt_rec_type
26 INDEX BY BINARY_INTEGER;
27 TYPE bktv_rec_type IS RECORD (
28 id NUMBER := OKC_API.G_MISS_NUM,
29 object_version_number NUMBER := OKC_API.G_MISS_NUM,
30 ibc_id NUMBER := OKC_API.G_MISS_NUM,
31 version OKL_BUCKETS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
32 comments OKL_BUCKETS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
33 loss_rate NUMBER := OKC_API.G_MISS_NUM,
34 program_id NUMBER := OKC_API.G_MISS_NUM,
35 request_id NUMBER := OKC_API.G_MISS_NUM,
36 program_application_id NUMBER := OKC_API.G_MISS_NUM,
37 program_update_date OKL_BUCKETS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
38 start_date OKL_BUCKETS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
39 end_date OKL_BUCKETS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
40 created_by NUMBER := OKC_API.G_MISS_NUM,
41 creation_date OKL_BUCKETS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
42 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
43 last_update_date OKL_BUCKETS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
44 last_update_login NUMBER := OKC_API.G_MISS_NUM);
45 g_miss_bktv_rec bktv_rec_type;
46 TYPE bktv_tbl_type IS TABLE OF bktv_rec_type
47 INDEX BY BINARY_INTEGER;
48 ---------------------------------------------------------------------------
49 -- GLOBAL MESSAGE CONSTANTS
50 ---------------------------------------------------------------------------
51 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
52 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
53 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
54 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
55 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
56 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
57 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
58 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
59 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
60 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
61 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
62 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
63 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
64 G_UNQS CONSTANT VARCHAR2(200) := 'OKL_BKT_ELEMENT_NOT_UNIQUE';
65 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
66 ---------------------------------------------------------------------------
67 -- GLOBAL EXCEPTION
68 ---------------------------------------------------------------------------
69 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
70 ---------------------------------------------------------------------------
71 -- GLOBAL VARIABLES
72 ---------------------------------------------------------------------------
73 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_BKT_PVT';
74 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
75 ---------------------------------------------------------------------------
76 -- Procedures and Functions
77 ---------------------------------------------------------------------------
78
79 PROCEDURE qc;
80 PROCEDURE change_version;
81 PROCEDURE api_copy;
82 PROCEDURE insert_row(
83 p_api_version IN NUMBER,
84 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_msg_data OUT NOCOPY VARCHAR2,
88 p_bktv_rec IN bktv_rec_type,
89 x_bktv_rec OUT NOCOPY bktv_rec_type);
90
91 PROCEDURE insert_row(
92 p_api_version IN NUMBER,
93 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
94 x_return_status OUT NOCOPY VARCHAR2,
95 x_msg_count OUT NOCOPY NUMBER,
96 x_msg_data OUT NOCOPY VARCHAR2,
97 p_bktv_tbl IN bktv_tbl_type,
98 x_bktv_tbl OUT NOCOPY bktv_tbl_type);
99
100 PROCEDURE lock_row(
101 p_api_version IN NUMBER,
102 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2,
106 p_bktv_rec IN bktv_rec_type);
107
108 PROCEDURE lock_row(
109 p_api_version IN NUMBER,
110 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
111 x_return_status OUT NOCOPY VARCHAR2,
112 x_msg_count OUT NOCOPY NUMBER,
113 x_msg_data OUT NOCOPY VARCHAR2,
114 p_bktv_tbl IN bktv_tbl_type);
115
116 PROCEDURE update_row(
117 p_api_version IN NUMBER,
118 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
119 x_return_status OUT NOCOPY VARCHAR2,
120 x_msg_count OUT NOCOPY NUMBER,
121 x_msg_data OUT NOCOPY VARCHAR2,
122 p_bktv_rec IN bktv_rec_type,
123 x_bktv_rec OUT NOCOPY bktv_rec_type);
124
125 PROCEDURE update_row(
126 p_api_version IN NUMBER,
127 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
128 x_return_status OUT NOCOPY VARCHAR2,
129 x_msg_count OUT NOCOPY NUMBER,
130 x_msg_data OUT NOCOPY VARCHAR2,
131 p_bktv_tbl IN bktv_tbl_type,
132 x_bktv_tbl OUT NOCOPY bktv_tbl_type);
133
134 PROCEDURE delete_row(
135 p_api_version IN NUMBER,
136 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139 x_msg_data OUT NOCOPY VARCHAR2,
140 p_bktv_rec IN bktv_rec_type);
141
142 PROCEDURE delete_row(
143 p_api_version IN NUMBER,
144 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
145 x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_count OUT NOCOPY NUMBER,
147 x_msg_data OUT NOCOPY VARCHAR2,
148 p_bktv_tbl IN bktv_tbl_type);
149
150 PROCEDURE validate_row(
151 p_api_version IN NUMBER,
152 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
153 x_return_status OUT NOCOPY VARCHAR2,
154 x_msg_count OUT NOCOPY NUMBER,
155 x_msg_data OUT NOCOPY VARCHAR2,
156 p_bktv_rec IN bktv_rec_type);
157
158 PROCEDURE validate_row(
159 p_api_version IN NUMBER,
160 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2,
164 p_bktv_tbl IN bktv_tbl_type);
165
166 END OKL_BKT_PVT;