[Home] [Help]
PACKAGE: APPS.OKS_BSD_PVT
Source
1 Package OKS_BSD_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKSSBSDS.pls 120.1 2006/09/19 18:51:25 hvaladip noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE bsd_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 bsl_id NUMBER := OKC_API.G_MISS_NUM,
9 bsl_id_averaged NUMBER := OKC_API.G_MISS_NUM,
10 bsd_id NUMBER := OKC_API.G_MISS_NUM,
11 bsd_id_applied NUMBER := OKC_API.G_MISS_NUM,
12 ccr_id NUMBER := OKC_API.G_MISS_NUM,
13 cgr_id NUMBER := OKC_API.G_MISS_NUM,
14 start_reading NUMBER := OKC_API.G_MISS_NUM,
15 end_reading NUMBER := OKC_API.G_MISS_NUM,
16 base_reading NUMBER := OKC_API.G_MISS_NUM,
17 estimated_quantity NUMBER := OKC_API.G_MISS_NUM,
18 unit_of_measure OKS_BILL_SUB_LINE_DTLS.UNIT_OF_MEASURE%TYPE := OKC_API.G_MISS_CHAR,
19 amcv_yn OKS_BILL_SUB_LINE_DTLS.AMCV_YN%TYPE := OKC_API.G_MISS_CHAR,
20 result NUMBER := OKC_API.G_MISS_NUM,
21 amount NUMBER := OKC_API.G_MISS_NUM,
22 object_version_number NUMBER := OKC_API.G_MISS_NUM,
23 created_by NUMBER := OKC_API.G_MISS_NUM,
24 creation_date OKS_BILL_SUB_LINE_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
25 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
26 last_update_date OKS_BILL_SUB_LINE_DTLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
27 fixed NUMBER := OKC_API.G_MISS_NUM,
28 actual NUMBER := OKC_API.G_MISS_NUM,
29 default_default NUMBER := OKC_API.G_MISS_NUM,
30 adjustment_level NUMBER := OKC_API.G_MISS_NUM,
31 adjustment_minimum NUMBER := OKC_API.G_MISS_NUM,
32 last_update_login NUMBER := OKC_API.G_MISS_NUM,
33 attribute_category OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
34 attribute1 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
35 attribute2 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
36 attribute3 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
37 attribute4 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
38 attribute5 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
39 attribute6 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
40 attribute7 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
41 attribute8 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
42 attribute9 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
43 attribute10 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
44 attribute11 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
45 attribute12 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
46 attribute13 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
47 attribute14 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
48 attribute15 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
49 g_miss_bsd_rec bsd_rec_type;
50 TYPE bsd_tbl_type IS TABLE OF bsd_rec_type
51 INDEX BY BINARY_INTEGER;
52 TYPE bsdv_rec_type IS RECORD (
53 id NUMBER := OKC_API.G_MISS_NUM,
54 object_version_number NUMBER := OKC_API.G_MISS_NUM,
55 bsl_id NUMBER := OKC_API.G_MISS_NUM,
56 bsl_id_averaged NUMBER := OKC_API.G_MISS_NUM,
57 bsd_id NUMBER := OKC_API.G_MISS_NUM,
58 bsd_id_applied NUMBER := OKC_API.G_MISS_NUM,
59 ccr_id NUMBER := OKC_API.G_MISS_NUM,
60 cgr_id NUMBER := OKC_API.G_MISS_NUM,
61 start_reading NUMBER := OKC_API.G_MISS_NUM,
62 end_reading NUMBER := OKC_API.G_MISS_NUM,
63 base_reading NUMBER := OKC_API.G_MISS_NUM,
64 estimated_quantity NUMBER := OKC_API.G_MISS_NUM,
65 unit_of_measure OKS_BILL_SUBLINE_DTLS_V.UNIT_OF_MEASURE%TYPE := OKC_API.G_MISS_CHAR,
66 fixed NUMBER := OKC_API.G_MISS_NUM,
67 actual NUMBER := OKC_API.G_MISS_NUM,
68 default_default NUMBER := OKC_API.G_MISS_NUM,
69 amcv_yn OKS_BILL_SUBLINE_DTLS_V.AMCV_YN%TYPE := OKC_API.G_MISS_CHAR,
70 adjustment_level NUMBER := OKC_API.G_MISS_NUM,
74 attribute_category OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
71 adjustment_minimum NUMBER := OKC_API.G_MISS_NUM,
72 result NUMBER := OKC_API.G_MISS_NUM,
73 amount NUMBER := OKC_API.G_MISS_NUM,
75 attribute1 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
76 attribute2 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
77 attribute3 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
78 attribute4 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
79 attribute5 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
80 attribute6 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
81 attribute7 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
82 attribute8 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
83 attribute9 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
84 attribute10 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
85 attribute11 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
86 attribute12 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
87 attribute13 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
88 attribute14 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
89 attribute15 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
90 created_by NUMBER := OKC_API.G_MISS_NUM,
91 creation_date OKS_BILL_SUBLINE_DTLS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
92 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
93 last_update_date OKS_BILL_SUBLINE_DTLS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
94 last_update_login NUMBER := OKC_API.G_MISS_NUM);
95 g_miss_bsdv_rec bsdv_rec_type;
96 TYPE bsdv_tbl_type IS TABLE OF bsdv_rec_type
97 INDEX BY BINARY_INTEGER;
98 ---------------------------------------------------------------------------
99 -- GLOBAL MESSAGE CONSTANTS
100 ---------------------------------------------------------------------------
101 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
102 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
103 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
104 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
105 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
106 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
107 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
108 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
109 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
110 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
111 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_CONTRACTS_UNEXPECTED_ERROR';
112 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
113 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
114
115
116 ---------------------------------------------------------------------------
117 -- GLOBAL EXCEPTIONS
118 ---------------------------------------------------------------------------
119 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
120
121 ---------------------------------------------------------------------------
122 -- GLOBAL VARIABLES
123 ---------------------------------------------------------------------------
124 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_BSD_PVT';
125 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
126 ---------------------------------------------------------------------------
127 -- Procedures and Functions
128 ---------------------------------------------------------------------------
129
130 PROCEDURE qc;
131 PROCEDURE change_version;
132 PROCEDURE api_copy;
133 PROCEDURE insert_row(
134 p_api_version IN NUMBER,
135 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
136 x_return_status OUT NOCOPY VARCHAR2,
137 x_msg_count OUT NOCOPY NUMBER,
138 x_msg_data OUT NOCOPY VARCHAR2,
139 p_bsdv_rec IN bsdv_rec_type,
140 x_bsdv_rec OUT NOCOPY bsdv_rec_type);
141
142 PROCEDURE insert_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_bsdv_tbl IN bsdv_tbl_type,
149 x_bsdv_tbl OUT NOCOPY bsdv_tbl_type);
150
151 PROCEDURE lock_row(
152 p_api_version IN NUMBER,
153 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
154 x_return_status OUT NOCOPY VARCHAR2,
155 x_msg_count OUT NOCOPY NUMBER,
156 x_msg_data OUT NOCOPY VARCHAR2,
157 p_bsdv_rec IN bsdv_rec_type);
158
159 PROCEDURE lock_row(
160 p_api_version IN NUMBER,
161 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
162 x_return_status OUT NOCOPY VARCHAR2,
163 x_msg_count OUT NOCOPY NUMBER,
164 x_msg_data OUT NOCOPY VARCHAR2,
165 p_bsdv_tbl IN bsdv_tbl_type);
166
167 PROCEDURE update_row(
168 p_api_version IN NUMBER,
169 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
170 x_return_status OUT NOCOPY VARCHAR2,
171 x_msg_count OUT NOCOPY NUMBER,
172 x_msg_data OUT NOCOPY VARCHAR2,
173 p_bsdv_rec IN bsdv_rec_type,
174 x_bsdv_rec OUT NOCOPY bsdv_rec_type);
175
176 PROCEDURE update_row(
177 p_api_version IN NUMBER,
178 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
179 x_return_status OUT NOCOPY VARCHAR2,
180 x_msg_count OUT NOCOPY NUMBER,
181 x_msg_data OUT NOCOPY VARCHAR2,
182 p_bsdv_tbl IN bsdv_tbl_type,
183 x_bsdv_tbl OUT NOCOPY bsdv_tbl_type);
184
185 PROCEDURE delete_row(
186 p_api_version IN NUMBER,
187 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
188 x_return_status OUT NOCOPY VARCHAR2,
189 x_msg_count OUT NOCOPY NUMBER,
190 x_msg_data OUT NOCOPY VARCHAR2,
191 p_bsdv_rec IN bsdv_rec_type);
192
193 PROCEDURE delete_row(
194 p_api_version IN NUMBER,
195 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
196 x_return_status OUT NOCOPY VARCHAR2,
197 x_msg_count OUT NOCOPY NUMBER,
198 x_msg_data OUT NOCOPY VARCHAR2,
199 p_bsdv_tbl IN bsdv_tbl_type);
200
201 PROCEDURE validate_row(
202 p_api_version IN NUMBER,
203 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
204 x_return_status OUT NOCOPY VARCHAR2,
205 x_msg_count OUT NOCOPY NUMBER,
206 x_msg_data OUT NOCOPY VARCHAR2,
207 p_bsdv_rec IN bsdv_rec_type);
208
209 PROCEDURE validate_row(
210 p_api_version IN NUMBER,
211 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
212 x_return_status OUT NOCOPY VARCHAR2,
213 x_msg_count OUT NOCOPY NUMBER,
214 x_msg_data OUT NOCOPY VARCHAR2,
215 p_bsdv_tbl IN bsdv_tbl_type);
216
217 END OKS_BSD_PVT;