[Home] [Help]
PACKAGE: APPS.OKS_PBR_PVT
Source
1 PACKAGE OKS_PBR_PVT AS
2 /* $Header: OKSSPBRS.pls 120.0 2005/05/27 15:27:03 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKS_PRICE_BREAKS_V Record Spec
7 TYPE pbrv_rec_type IS RECORD (
8 id NUMBER := OKC_API.G_MISS_NUM
9 ,bsl_id NUMBER := OKC_API.G_MISS_NUM
10 ,bcl_id NUMBER := OKC_API.G_MISS_NUM
11 ,cle_id NUMBER := OKC_API.G_MISS_NUM
12 ,chr_id NUMBER := OKC_API.G_MISS_NUM
13 ,line_detail_index NUMBER := OKC_API.G_MISS_NUM
14 ,line_index NUMBER := OKC_API.G_MISS_NUM
15 ,pricing_context OKS_PRICE_BREAKS_V.PRICING_CONTEXT%TYPE := OKC_API.G_MISS_CHAR
16 ,pricing_method OKS_PRICE_BREAKS_V.PRICING_METHOD%TYPE := OKC_API.G_MISS_CHAR
17 ,quantity_from NUMBER := OKC_API.G_MISS_NUM
18 ,quantity_to NUMBER := OKC_API.G_MISS_NUM
19 ,quantity NUMBER := OKC_API.G_MISS_NUM
20 ,break_uom OKS_PRICE_BREAKS_V.BREAK_UOM%TYPE := OKC_API.G_MISS_CHAR
21 ,prorate OKS_PRICE_BREAKS_V.PRORATE%TYPE := OKC_API.G_MISS_CHAR
22 ,unit_price NUMBER := OKC_API.G_MISS_NUM
23 ,amount NUMBER := OKC_API.G_MISS_NUM
24 ,price_list_id NUMBER := OKC_API.G_MISS_NUM
25 ,validated_flag OKS_PRICE_BREAKS_V.VALIDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR
26 ,status_code OKS_PRICE_BREAKS_V.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
27 ,status_text OKS_PRICE_BREAKS_V.STATUS_TEXT%TYPE := OKC_API.G_MISS_CHAR
28 ,lock_flag OKS_PRICE_BREAKS_V.LOCK_FLAG%TYPE := OKC_API.G_MISS_CHAR
29 ,locked_price_list_id NUMBER := OKC_API.G_MISS_NUM
30 ,locked_price_list_line_id NUMBER := OKC_API.G_MISS_NUM
31 ,price_list_line_id NUMBER := OKC_API.G_MISS_NUM
32 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
33 ,created_by NUMBER := OKC_API.G_MISS_NUM
34 ,creation_date OKS_PRICE_BREAKS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
35 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
36 ,last_update_date OKS_PRICE_BREAKS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
37 ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
38 G_MISS_pbrv_rec pbrv_rec_type;
39 TYPE pbrv_tbl_type IS TABLE OF pbrv_rec_type
40 INDEX BY BINARY_INTEGER;
41 -- OKS_PRICE_BREAKS Record Spec
42 TYPE pbr_rec_type IS RECORD (
43 id NUMBER := OKC_API.G_MISS_NUM
44 ,bsl_id NUMBER := OKC_API.G_MISS_NUM
45 ,bcl_id NUMBER := OKC_API.G_MISS_NUM
46 ,cle_id NUMBER := OKC_API.G_MISS_NUM
47 ,chr_id NUMBER := OKC_API.G_MISS_NUM
48 ,line_detail_index NUMBER := OKC_API.G_MISS_NUM
49 ,line_index NUMBER := OKC_API.G_MISS_NUM
50 ,pricing_context OKS_PRICE_BREAKS.PRICING_CONTEXT%TYPE := OKC_API.G_MISS_CHAR
51 ,pricing_method OKS_PRICE_BREAKS.PRICING_METHOD%TYPE := OKC_API.G_MISS_CHAR
52 ,quantity_from NUMBER := OKC_API.G_MISS_NUM
53 ,quantity_to NUMBER := OKC_API.G_MISS_NUM
54 ,quantity NUMBER := OKC_API.G_MISS_NUM
55 ,break_uom OKS_PRICE_BREAKS.BREAK_UOM%TYPE := OKC_API.G_MISS_CHAR
56 ,prorate OKS_PRICE_BREAKS.PRORATE%TYPE := OKC_API.G_MISS_CHAR
57 ,unit_price NUMBER := OKC_API.G_MISS_NUM
58 ,amount NUMBER := OKC_API.G_MISS_NUM
59 ,price_list_id NUMBER := OKC_API.G_MISS_NUM
60 ,validated_flag OKS_PRICE_BREAKS.VALIDATED_FLAG%TYPE := OKC_API.G_MISS_CHAR
61 ,status_code OKS_PRICE_BREAKS.STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR
62 ,status_text OKS_PRICE_BREAKS.STATUS_TEXT%TYPE := OKC_API.G_MISS_CHAR
63 ,lock_flag OKS_PRICE_BREAKS.LOCK_FLAG%TYPE := OKC_API.G_MISS_CHAR
64 ,locked_price_list_id NUMBER := OKC_API.G_MISS_NUM
65 ,locked_price_list_line_id NUMBER := OKC_API.G_MISS_NUM
66 ,price_list_line_id NUMBER := OKC_API.G_MISS_NUM
67 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
68 ,created_by NUMBER := OKC_API.G_MISS_NUM
69 ,creation_date OKS_PRICE_BREAKS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
70 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
71 ,last_update_date OKS_PRICE_BREAKS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
72 ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
73 G_MISS_pbr_rec pbr_rec_type;
74 TYPE pbr_tbl_type IS TABLE OF pbr_rec_type
75 INDEX BY BINARY_INTEGER;
76 ---------------------------------------------------------------------------
77 -- GLOBAL MESSAGE CONSTANTS
78 ---------------------------------------------------------------------------
79 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
80 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
81 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
82 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
83 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
84 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
85 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
86 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
87 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
88 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
89 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
90 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
91 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
92
93 ---------------------------------------------------------------------------
94 -- GLOBAL EXCEPTIONS
95 ---------------------------------------------------------------------------
96 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
97
98 ---------------------------------------------------------------------------
99 -- GLOBAL VARIABLES
100 ---------------------------------------------------------------------------
101 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_PBR_PVT';
102 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
103 ---------------------------------------------------------------------------
104 -- Procedures and Functions
105 ---------------------------------------------------------------------------
106
107 PROCEDURE qc;
108 PROCEDURE change_version;
109 PROCEDURE api_copy;
110 PROCEDURE insert_row(
111 p_api_version IN NUMBER,
112 p_init_msg_list IN VARCHAR2,
113 x_return_status OUT NOCOPY VARCHAR2,
114 x_msg_count OUT NOCOPY NUMBER,
115 x_msg_data OUT NOCOPY VARCHAR2,
116 p_pbrv_rec IN pbrv_rec_type,
117 x_pbrv_rec OUT NOCOPY pbrv_rec_type);
118 PROCEDURE insert_row(
119 p_api_version IN NUMBER,
120 p_init_msg_list IN VARCHAR2,
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER,
123 x_msg_data OUT NOCOPY VARCHAR2,
124 p_pbrv_tbl IN pbrv_tbl_type,
125 x_pbrv_tbl OUT NOCOPY pbrv_tbl_type,
126 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
127 PROCEDURE insert_row(
128 p_api_version IN NUMBER,
129 p_init_msg_list IN VARCHAR2,
130 x_return_status OUT NOCOPY VARCHAR2,
131 x_msg_count OUT NOCOPY NUMBER,
132 x_msg_data OUT NOCOPY VARCHAR2,
133 p_pbrv_tbl IN pbrv_tbl_type,
134 x_pbrv_tbl OUT NOCOPY pbrv_tbl_type);
135 PROCEDURE lock_row(
136 p_api_version IN NUMBER,
137 p_init_msg_list IN VARCHAR2,
138 x_return_status OUT NOCOPY VARCHAR2,
139 x_msg_count OUT NOCOPY NUMBER,
140 x_msg_data OUT NOCOPY VARCHAR2,
141 p_pbrv_rec IN pbrv_rec_type);
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_pbrv_tbl IN pbrv_tbl_type,
149 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
150 PROCEDURE lock_row(
151 p_api_version IN NUMBER,
152 p_init_msg_list IN VARCHAR2,
153 x_return_status OUT NOCOPY VARCHAR2,
154 x_msg_count OUT NOCOPY NUMBER,
155 x_msg_data OUT NOCOPY VARCHAR2,
156 p_pbrv_tbl IN pbrv_tbl_type);
157 PROCEDURE update_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_pbrv_rec IN pbrv_rec_type,
164 x_pbrv_rec OUT NOCOPY pbrv_rec_type);
165 PROCEDURE update_row(
166 p_api_version IN NUMBER,
167 p_init_msg_list IN VARCHAR2,
168 x_return_status OUT NOCOPY VARCHAR2,
169 x_msg_count OUT NOCOPY NUMBER,
170 x_msg_data OUT NOCOPY VARCHAR2,
171 p_pbrv_tbl IN pbrv_tbl_type,
172 x_pbrv_tbl OUT NOCOPY pbrv_tbl_type,
173 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
174 PROCEDURE update_row(
175 p_api_version IN NUMBER,
176 p_init_msg_list IN VARCHAR2,
177 x_return_status OUT NOCOPY VARCHAR2,
178 x_msg_count OUT NOCOPY NUMBER,
179 x_msg_data OUT NOCOPY VARCHAR2,
180 p_pbrv_tbl IN pbrv_tbl_type,
181 x_pbrv_tbl OUT NOCOPY pbrv_tbl_type);
182 PROCEDURE delete_row(
183 p_api_version IN NUMBER,
184 p_init_msg_list IN VARCHAR2,
185 x_return_status OUT NOCOPY VARCHAR2,
186 x_msg_count OUT NOCOPY NUMBER,
187 x_msg_data OUT NOCOPY VARCHAR2,
188 p_pbrv_rec IN pbrv_rec_type);
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_pbrv_tbl IN pbrv_tbl_type,
196 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
197 PROCEDURE delete_row(
198 p_api_version IN NUMBER,
199 p_init_msg_list IN VARCHAR2,
200 x_return_status OUT NOCOPY VARCHAR2,
201 x_msg_count OUT NOCOPY NUMBER,
202 x_msg_data OUT NOCOPY VARCHAR2,
203 p_pbrv_tbl IN pbrv_tbl_type);
204 PROCEDURE validate_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_pbrv_rec IN pbrv_rec_type);
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_pbrv_tbl IN pbrv_tbl_type,
218 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
219 PROCEDURE validate_row(
220 p_api_version IN NUMBER,
221 p_init_msg_list IN VARCHAR2,
222 x_return_status OUT NOCOPY VARCHAR2,
223 x_msg_count OUT NOCOPY NUMBER,
224 x_msg_data OUT NOCOPY VARCHAR2,
225 p_pbrv_tbl IN pbrv_tbl_type);
226 END OKS_PBR_PVT;