[Home] [Help]
PACKAGE: APPS.OKS_CDT_PVT
Source
1 PACKAGE OKS_CDT_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKSRCDTS.pls 120.2 2005/07/21 04:39:05 parkumar noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE cdt_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 cdt_type OKS_K_DEFAULTS.CDT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
9 object_version_number NUMBER := OKC_API.G_MISS_NUM,
10 created_by NUMBER := OKC_API.G_MISS_NUM,
11 creation_date OKS_K_DEFAULTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13 last_update_date OKS_K_DEFAULTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14 segment_id1 OKS_K_DEFAULTS.SEGMENT_ID1%TYPE := OKC_API.G_MISS_CHAR,
15 segment_id2 OKS_K_DEFAULTS.SEGMENT_ID2%TYPE := OKC_API.G_MISS_CHAR,
16 jtot_object_code OKS_K_DEFAULTS.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
17 pdf_id NUMBER := OKC_API.G_MISS_NUM,
18 qcl_id NUMBER := OKC_API.G_MISS_NUM,
19 cgp_new_id NUMBER := OKC_API.G_MISS_NUM,
20 cgp_renew_id NUMBER := OKC_API.G_MISS_NUM,
21 price_list_id1 OKS_K_DEFAULTS.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR,
22 price_list_id2 OKS_K_DEFAULTS.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR,
23 renewal_type OKS_K_DEFAULTS.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
24 po_required_yn OKS_K_DEFAULTS.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
25 renewal_pricing_type OKS_K_DEFAULTS.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
26 markup_percent NUMBER := OKC_API.G_MISS_NUM,
27 start_date OKS_K_DEFAULTS.START_DATE%TYPE := OKC_API.G_MISS_DATE,
28 end_date OKS_K_DEFAULTS.END_DATE%TYPE := OKC_API.G_MISS_DATE,
29 --security_group_id NUMBER := OKC_API.G_MISS_NUM,
30 rle_code OKS_K_DEFAULTS.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
31 revenue_estimated_percent NUMBER := OKC_API.G_MISS_NUM,
32 revenue_estimated_duration NUMBER := OKC_API.G_MISS_NUM,
33 revenue_estimated_period OKS_K_DEFAULTS.REVENUE_ESTIMATED_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
34 template_set_id NUMBER := OKC_API.G_MISS_NUM,
35 THRESHOLD_CURRENCY OKS_K_DEFAULTS.THRESHOLD_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
36 THRESHOLD_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
37 EMAIL_ADDRESS OKS_K_DEFAULTS.EMAIL_ADDRESS%TYPE := OKC_API.G_MISS_CHAR,
38 BILLING_PROFILE_ID NUMBER := OKC_API.G_MISS_NUM,
39 USER_ID NUMBER := OKC_API.G_MISS_NUM,
40 THRESHOLD_ENABLED_YN OKS_K_DEFAULTS.THRESHOLD_ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
41 GRACE_PERIOD OKS_K_DEFAULTS.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
42 GRACE_DURATION NUMBER := OKC_API.G_MISS_NUM,
43 PAYMENT_TERMS_ID1 OKS_K_DEFAULTS.PAYMENT_TERMS_ID1%TYPE := OKC_API.G_MISS_CHAR,
44 PAYMENT_TERMS_ID2 OKS_K_DEFAULTS.PAYMENT_TERMS_ID2%TYPE := OKC_API.G_MISS_CHAR,
45 EVERGREEN_THRESHOLD_CURR OKS_K_DEFAULTS.EVERGREEN_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
46 EVERGREEN_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
47 PAYMENT_METHOD OKS_K_DEFAULTS.PAYMENT_METHOD%TYPE := OKC_API.G_MISS_CHAR,
48 PAYMENT_THRESHOLD_CURR OKS_K_DEFAULTS.PAYMENT_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
49 PAYMENT_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
50 INTERFACE_PRICE_BREAK OKS_K_DEFAULTS.INTERFACE_PRICE_BREAK%TYPE := OKC_API.G_MISS_CHAR,
51 CREDIT_AMOUNT OKS_K_DEFAULTS.CREDIT_AMOUNT%TYPE := OKC_API.G_MISS_CHAR,
52 -- R12 Data Model Changes 4485150 Start
53 BASE_CURRENCY OKS_K_DEFAULTS.BASE_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
54 APPROVAL_TYPE OKS_K_DEFAULTS.APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
55 EVERGREEN_APPROVAL_TYPE OKS_K_DEFAULTS.EVERGREEN_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
56 ONLINE_APPROVAL_TYPE OKS_K_DEFAULTS.ONLINE_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
57 PURCHASE_ORDER_FLAG OKS_K_DEFAULTS.PURCHASE_ORDER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
58 CREDIT_CARD_FLAG OKS_K_DEFAULTS.CREDIT_CARD_FLAG%TYPE := OKC_API.G_MISS_CHAR,
59 WIRE_FLAG OKS_K_DEFAULTS.WIRE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
60 COMMITMENT_NUMBER_FLAG OKS_K_DEFAULTS.COMMITMENT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
61 CHECK_FLAG OKS_K_DEFAULTS.CHECK_FLAG%TYPE := OKC_API.G_MISS_CHAR,
62 PERIOD_TYPE OKS_K_DEFAULTS.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63 PERIOD_START OKS_K_DEFAULTS.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR,
64 PRICE_UOM OKS_K_DEFAULTS.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR,
65 TEMPLATE_LANGUAGE OKS_K_DEFAULTS.TEMPLATE_LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
66 -- R12 Data Model Changes 4485150 End
70 TYPE cdt_tbl_type IS TABLE OF cdt_rec_type
67 );
68 g_miss_cdt_rec cdt_rec_type;
69
71 INDEX BY BINARY_INTEGER;
72 TYPE cdtv_rec_type IS RECORD (
73 id NUMBER := OKC_API.G_MISS_NUM,
74 cdt_type OKS_K_DEFAULTS_V.CDT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
75 object_version_number NUMBER := OKC_API.G_MISS_NUM,
76 created_by NUMBER := OKC_API.G_MISS_NUM,
77 creation_date OKS_K_DEFAULTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
78 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79 last_update_date OKS_K_DEFAULTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
80 segment_id1 OKS_K_DEFAULTS_V.SEGMENT_ID1%TYPE := OKC_API.G_MISS_CHAR,
81 segment_id2 OKS_K_DEFAULTS_V.SEGMENT_ID2%TYPE := OKC_API.G_MISS_CHAR,
82 jtot_object_code OKS_K_DEFAULTS_V.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
83 pdf_id NUMBER := OKC_API.G_MISS_NUM,
84 qcl_id NUMBER := OKC_API.G_MISS_NUM,
85 cgp_new_id NUMBER := OKC_API.G_MISS_NUM,
86 cgp_renew_id NUMBER := OKC_API.G_MISS_NUM,
87 price_list_id1 OKS_K_DEFAULTS_V.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR,
88 price_list_id2 OKS_K_DEFAULTS_V.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR,
89 renewal_type OKS_K_DEFAULTS_V.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
90 po_required_yn OKS_K_DEFAULTS_V.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
91 renewal_pricing_type OKS_K_DEFAULTS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
92 markup_percent NUMBER := OKC_API.G_MISS_NUM,
93 rle_code OKS_K_DEFAULTS_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
94 start_date OKS_K_DEFAULTS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
95 end_date OKS_K_DEFAULTS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
96 revenue_estimated_percent NUMBER := OKC_API.G_MISS_NUM,
97 revenue_estimated_duration NUMBER := OKC_API.G_MISS_NUM,
98 revenue_estimated_period OKS_K_DEFAULTS_V.REVENUE_ESTIMATED_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
99 template_set_id NUMBER := OKC_API.G_MISS_NUM,
100 THRESHOLD_CURRENCY OKS_K_DEFAULTS.THRESHOLD_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
101 THRESHOLD_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
102 EMAIL_ADDRESS OKS_K_DEFAULTS.EMAIL_ADDRESS%TYPE := OKC_API.G_MISS_CHAR,
103 BILLING_PROFILE_ID NUMBER := OKC_API.G_MISS_NUM,
104 USER_ID NUMBER := OKC_API.G_MISS_NUM,
105 THRESHOLD_ENABLED_YN OKS_K_DEFAULTS.THRESHOLD_ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
106 GRACE_PERIOD OKS_K_DEFAULTS.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
107 GRACE_DURATION NUMBER := OKC_API.G_MISS_NUM,
108 PAYMENT_TERMS_ID1 OKS_K_DEFAULTS.PAYMENT_TERMS_ID1%TYPE := OKC_API.G_MISS_CHAR,
109 PAYMENT_TERMS_ID2 OKS_K_DEFAULTS.PAYMENT_TERMS_ID2%TYPE := OKC_API.G_MISS_CHAR,
110 EVERGREEN_THRESHOLD_CURR OKS_K_DEFAULTS.EVERGREEN_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
111 EVERGREEN_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
112 PAYMENT_METHOD OKS_K_DEFAULTS.PAYMENT_METHOD%TYPE := OKC_API.G_MISS_CHAR,
113 PAYMENT_THRESHOLD_CURR OKS_K_DEFAULTS.PAYMENT_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
114 PAYMENT_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
115 INTERFACE_PRICE_BREAK OKS_K_DEFAULTS.INTERFACE_PRICE_BREAK %TYPE := OKC_API.G_MISS_CHAR,
116 CREDIT_AMOUNT OKS_K_DEFAULTS.CREDIT_AMOUNT %TYPE := OKC_API.G_MISS_CHAR,
117 -- R12 Data Model Changes 4485150 Start /* mmadhavi 4485150 : add other columns */
118 PERIOD_TYPE OKS_K_DEFAULTS.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
119 PERIOD_START OKS_K_DEFAULTS.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR,
120 PRICE_UOM OKS_K_DEFAULTS.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR,
121 BASE_CURRENCY OKS_K_DEFAULTS.BASE_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
122 APPROVAL_TYPE OKS_K_DEFAULTS.APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
123 EVERGREEN_APPROVAL_TYPE OKS_K_DEFAULTS.EVERGREEN_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
124 ONLINE_APPROVAL_TYPE OKS_K_DEFAULTS.ONLINE_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
125 PURCHASE_ORDER_FLAG OKS_K_DEFAULTS.PURCHASE_ORDER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
126 CREDIT_CARD_FLAG OKS_K_DEFAULTS.CREDIT_CARD_FLAG%TYPE := OKC_API.G_MISS_CHAR,
127 WIRE_FLAG OKS_K_DEFAULTS.WIRE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
128 COMMITMENT_NUMBER_FLAG OKS_K_DEFAULTS.COMMITMENT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
129 CHECK_FLAG OKS_K_DEFAULTS.CHECK_FLAG%TYPE := OKC_API.G_MISS_CHAR,
130 TEMPLATE_LANGUAGE OKS_K_DEFAULTS.TEMPLATE_LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
131 -- R12 Data Model Changes 4485150 End
132 );
133 g_miss_cdtv_rec cdtv_rec_type;
134 TYPE cdtv_tbl_type IS TABLE OF cdtv_rec_type
135 INDEX BY BINARY_INTEGER;
136 ---------------------------------------------------------------------------
137 -- GLOBAL MESSAGE CONSTANTS
138 ---------------------------------------------------------------------------
139 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
140 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
141 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
142 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
143 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
144 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
145 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
146 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
147 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
148 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
149 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_DEFAULTS_UNEXPECTED_ERROR';
150 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
151 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
152 ---------------------------------------------------------------------------
153 -- GLOBAL EXCEPTIONS
154 ---------------------------------------------------------------------------
155 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
156
157 ---------------------------------------------------------------------------
158 -- GLOBAL VARIABLES
159 ---------------------------------------------------------------------------
160 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_CDT_PVT';
161 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
162 ---------------------------------------------------------------------------
163 -- Procedures and Functions
164 ---------------------------------------------------------------------------
165
166 PROCEDURE qc;
167 PROCEDURE change_version;
168 PROCEDURE api_copy;
169 PROCEDURE insert_row(
170 p_api_version IN NUMBER,
171 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
172 x_return_status OUT NOCOPY VARCHAR2,
173 x_msg_count OUT NOCOPY NUMBER,
174 x_msg_data OUT NOCOPY VARCHAR2,
175 p_cdtv_rec IN cdtv_rec_type,
176 x_cdtv_rec OUT NOCOPY cdtv_rec_type);
177
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_cdtv_tbl IN cdtv_tbl_type,
185 x_cdtv_tbl OUT NOCOPY cdtv_tbl_type);
186
187 PROCEDURE lock_row(
188 p_api_version IN NUMBER,
189 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
190 x_return_status OUT NOCOPY VARCHAR2,
191 x_msg_count OUT NOCOPY NUMBER,
192 x_msg_data OUT NOCOPY VARCHAR2,
193 p_cdtv_rec IN cdtv_rec_type);
194
195 PROCEDURE lock_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_cdtv_tbl IN cdtv_tbl_type);
202
203 PROCEDURE update_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_cdtv_rec IN cdtv_rec_type,
210 x_cdtv_rec OUT NOCOPY cdtv_rec_type);
211
212 PROCEDURE update_row(
213 p_api_version IN NUMBER,
214 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
215 x_return_status OUT NOCOPY VARCHAR2,
216 x_msg_count OUT NOCOPY NUMBER,
217 x_msg_data OUT NOCOPY VARCHAR2,
218 p_cdtv_tbl IN cdtv_tbl_type,
219 x_cdtv_tbl OUT NOCOPY cdtv_tbl_type);
220
221 PROCEDURE delete_row(
222 p_api_version IN NUMBER,
223 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
224 x_return_status OUT NOCOPY VARCHAR2,
225 x_msg_count OUT NOCOPY NUMBER,
226 x_msg_data OUT NOCOPY VARCHAR2,
227 p_cdtv_rec IN cdtv_rec_type);
228
229 PROCEDURE delete_row(
230 p_api_version IN NUMBER,
231 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
232 x_return_status OUT NOCOPY VARCHAR2,
233 x_msg_count OUT NOCOPY NUMBER,
234 x_msg_data OUT NOCOPY VARCHAR2,
235 p_cdtv_tbl IN cdtv_tbl_type);
236
237 PROCEDURE validate_row(
238 p_api_version IN NUMBER,
239 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
240 x_return_status OUT NOCOPY VARCHAR2,
241 x_msg_count OUT NOCOPY NUMBER,
242 x_msg_data OUT NOCOPY VARCHAR2,
243 p_cdtv_rec IN cdtv_rec_type);
244
245 PROCEDURE validate_row(
246 p_api_version IN NUMBER,
247 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
248 x_return_status OUT NOCOPY VARCHAR2,
249 x_msg_count OUT NOCOPY NUMBER,
250 x_msg_data OUT NOCOPY VARCHAR2,
251 p_cdtv_tbl IN cdtv_tbl_type);
252
253 END OKS_CDT_PVT;