[Home] [Help]
PACKAGE: APPS.OKS_COD_PVT
Source
1 PACKAGE OKS_COD_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKSRCODS.pls 120.1 2006/05/26 22:29:23 jvarghes noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKS_K_ORDER_DETAILS_V Record Spec
7 TYPE codv_rec_type IS RECORD (
8 id NUMBER := OKC_API.G_MISS_NUM
9 ,cod_id NUMBER := OKC_API.G_MISS_NUM
10 ,apply_all_yn OKS_K_ORDER_DETAILS_V.APPLY_ALL_YN%TYPE := OKC_API.G_MISS_CHAR
11 ,line_renewal_type OKS_K_ORDER_DETAILS_V.LINE_RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
12 ,renewal_type OKS_K_ORDER_DETAILS_V.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
13 ,po_required_yn OKS_K_ORDER_DETAILS_V.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR
14 ,renewal_pricing_type OKS_K_ORDER_DETAILS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
15 ,markup_percent NUMBER := OKC_API.G_MISS_NUM
16 ,link_order_header_id NUMBER := OKC_API.G_MISS_NUM
17 ,end_date OKS_K_ORDER_DETAILS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
18 ,cod_type OKS_K_ORDER_DETAILS_V.COD_TYPE%TYPE := OKC_API.G_MISS_CHAR
19 ,order_line_id1 OKS_K_ORDER_DETAILS_V.ORDER_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
20 ,order_line_id2 OKS_K_ORDER_DETAILS_V.ORDER_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
21 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
22 ,created_by NUMBER := OKC_API.G_MISS_NUM
23 ,creation_date OKS_K_ORDER_DETAILS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
24 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
25 ,last_update_date OKS_K_ORDER_DETAILS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
26 ,link_ord_line_id1 OKS_K_ORDER_DETAILS_V.LINK_ORD_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
27 ,link_ord_line_id2 OKS_K_ORDER_DETAILS_V.LINK_ORD_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
28 ,link_chr_id NUMBER := OKC_API.G_MISS_NUM
29 ,link_cle_id NUMBER := OKC_API.G_MISS_NUM
30 ,price_list_id1 OKS_K_ORDER_DETAILS_V.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR
31 ,price_list_id2 OKS_K_ORDER_DETAILS_V.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR
32 ,chr_id NUMBER := OKC_API.G_MISS_NUM
33 ,cle_id NUMBER := OKC_API.G_MISS_NUM
34 ,contact_id NUMBER := OKC_API.G_MISS_NUM
35 ,site_id NUMBER := OKC_API.G_MISS_NUM
36 ,email_id NUMBER := OKC_API.G_MISS_NUM
37 ,phone_id NUMBER := OKC_API.G_MISS_NUM
38 ,fax_id NUMBER := OKC_API.G_MISS_NUM
39 ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM
40 ,RENEWAL_APPROVAL_FLAG OKS_K_ORDER_DETAILS_V.RENEWAL_APPROVAL_FLAG%TYPE := OKC_API.G_MISS_CHAR);
41
42 G_MISS_codv_rec codv_rec_type;
43
44 TYPE codv_tbl_type IS TABLE OF codv_rec_type
45 INDEX BY BINARY_INTEGER;
46 -- OKS_K_ORDER_DETAILS Record Spec
47 TYPE cod_rec_type IS RECORD (
48 id NUMBER := OKC_API.G_MISS_NUM
49 ,cod_type OKS_K_ORDER_DETAILS.COD_TYPE%TYPE := OKC_API.G_MISS_CHAR
50 ,link_order_header_id NUMBER := OKC_API.G_MISS_NUM
51 ,order_line_id1 OKS_K_ORDER_DETAILS.ORDER_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
52 ,order_line_id2 OKS_K_ORDER_DETAILS.ORDER_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
53 ,apply_all_yn OKS_K_ORDER_DETAILS.APPLY_ALL_YN%TYPE := OKC_API.G_MISS_CHAR
54 ,renewal_type OKS_K_ORDER_DETAILS.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
55 ,line_renewal_type OKS_K_ORDER_DETAILS.LINE_RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR
56 ,end_date OKS_K_ORDER_DETAILS.END_DATE%TYPE := OKC_API.G_MISS_DATE
57 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
58 ,created_by NUMBER := OKC_API.G_MISS_NUM
59 ,creation_date OKS_K_ORDER_DETAILS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
60 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
61 ,last_update_date OKS_K_ORDER_DETAILS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
62 ,po_required_yn OKS_K_ORDER_DETAILS.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR
63 ,renewal_pricing_type OKS_K_ORDER_DETAILS.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
64 ,markup_percent NUMBER := OKC_API.G_MISS_NUM
65 ,price_list_id1 OKS_K_ORDER_DETAILS.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR
66 ,price_list_id2 OKS_K_ORDER_DETAILS.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR
67 ,link_ord_line_id1 OKS_K_ORDER_DETAILS.LINK_ORD_LINE_ID1%TYPE := OKC_API.G_MISS_CHAR
68 ,link_ord_line_id2 OKS_K_ORDER_DETAILS.LINK_ORD_LINE_ID2%TYPE := OKC_API.G_MISS_CHAR
69 ,link_chr_id NUMBER := OKC_API.G_MISS_NUM
70 ,link_cle_id NUMBER := OKC_API.G_MISS_NUM
71 ,chr_id NUMBER := OKC_API.G_MISS_NUM
72 ,cle_id NUMBER := OKC_API.G_MISS_NUM
73 ,cod_id NUMBER := OKC_API.G_MISS_NUM
74 ,contact_id NUMBER := OKC_API.G_MISS_NUM
75 ,site_id NUMBER := OKC_API.G_MISS_NUM
76 ,email_id NUMBER := OKC_API.G_MISS_NUM
77 ,phone_id NUMBER := OKC_API.G_MISS_NUM
78 ,fax_id NUMBER := OKC_API.G_MISS_NUM
79 ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM
80 ,RENEWAL_APPROVAL_FLAG OKS_K_ORDER_DETAILS_V.RENEWAL_APPROVAL_FLAG%TYPE := OKC_API.G_MISS_CHAR);
81
82 G_MISS_cod_rec cod_rec_type;
83 TYPE cod_tbl_type IS TABLE OF cod_rec_type
84 INDEX BY BINARY_INTEGER;
85 ---------------------------------------------------------------------------
86 -- GLOBAL MESSAGE CONSTANTS
87 ---------------------------------------------------------------------------
88 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
89 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
90 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
91 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
92 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
93 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
94 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
95 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
96 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
97 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
98 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
99 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
100 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
101
102 ---------------------------------------------------------------------------
103 -- GLOBAL EXCEPTIONS
104 ---------------------------------------------------------------------------
105 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
106
107 ---------------------------------------------------------------------------
108 -- GLOBAL VARIABLES
109 ---------------------------------------------------------------------------
110 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_COD_PVT';
111 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
112 ---------------------------------------------------------------------------
113 -- Procedures and Functions
114 ---------------------------------------------------------------------------
115
116 PROCEDURE qc;
117 PROCEDURE change_version;
118 PROCEDURE api_copy;
119 PROCEDURE insert_row(
120 p_api_version IN NUMBER,
121 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
122 x_return_status OUT NOCOPY VARCHAR2,
123 x_msg_count OUT NOCOPY NUMBER,
124 x_msg_data OUT NOCOPY VARCHAR2,
125 p_codv_rec IN codv_rec_type,
126 x_codv_rec OUT NOCOPY codv_rec_type);
127 PROCEDURE insert_row(
128 p_api_version IN NUMBER,
129 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
130 x_return_status OUT NOCOPY VARCHAR2,
131 x_msg_count OUT NOCOPY NUMBER,
132 x_msg_data OUT NOCOPY VARCHAR2,
133 p_codv_tbl IN codv_tbl_type,
134 x_codv_tbl OUT NOCOPY codv_tbl_type,
135 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
136 PROCEDURE insert_row(
137 p_api_version IN NUMBER,
138 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
139 x_return_status OUT NOCOPY VARCHAR2,
140 x_msg_count OUT NOCOPY NUMBER,
141 x_msg_data OUT NOCOPY VARCHAR2,
142 p_codv_tbl IN codv_tbl_type,
143 x_codv_tbl OUT NOCOPY codv_tbl_type);
144 PROCEDURE lock_row(
145 p_api_version IN NUMBER,
146 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
147 x_return_status OUT NOCOPY VARCHAR2,
148 x_msg_count OUT NOCOPY NUMBER,
149 x_msg_data OUT NOCOPY VARCHAR2,
150 p_codv_rec IN codv_rec_type);
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_codv_tbl IN codv_tbl_type,
158 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
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_codv_tbl IN codv_tbl_type);
166 PROCEDURE update_row(
167 p_api_version IN NUMBER,
168 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
169 x_return_status OUT NOCOPY VARCHAR2,
170 x_msg_count OUT NOCOPY NUMBER,
171 x_msg_data OUT NOCOPY VARCHAR2,
172 p_codv_rec IN codv_rec_type,
173 x_codv_rec OUT NOCOPY codv_rec_type);
174 PROCEDURE update_row(
175 p_api_version IN NUMBER,
176 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
177 x_return_status OUT NOCOPY VARCHAR2,
178 x_msg_count OUT NOCOPY NUMBER,
179 x_msg_data OUT NOCOPY VARCHAR2,
180 p_codv_tbl IN codv_tbl_type,
181 x_codv_tbl OUT NOCOPY codv_tbl_type,
182 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
183 PROCEDURE update_row(
184 p_api_version IN NUMBER,
185 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
186 x_return_status OUT NOCOPY VARCHAR2,
187 x_msg_count OUT NOCOPY NUMBER,
188 x_msg_data OUT NOCOPY VARCHAR2,
189 p_codv_tbl IN codv_tbl_type,
190 x_codv_tbl OUT NOCOPY codv_tbl_type);
191 PROCEDURE delete_row(
192 p_api_version IN NUMBER,
193 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
194 x_return_status OUT NOCOPY VARCHAR2,
195 x_msg_count OUT NOCOPY NUMBER,
196 x_msg_data OUT NOCOPY VARCHAR2,
197 p_codv_rec IN codv_rec_type);
198 PROCEDURE delete_row(
199 p_api_version IN NUMBER,
200 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
201 x_return_status OUT NOCOPY VARCHAR2,
202 x_msg_count OUT NOCOPY NUMBER,
203 x_msg_data OUT NOCOPY VARCHAR2,
204 p_codv_tbl IN codv_tbl_type,
205 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
206 PROCEDURE delete_row(
207 p_api_version IN NUMBER,
208 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
209 x_return_status OUT NOCOPY VARCHAR2,
210 x_msg_count OUT NOCOPY NUMBER,
211 x_msg_data OUT NOCOPY VARCHAR2,
212 p_codv_tbl IN codv_tbl_type);
213 PROCEDURE validate_row(
214 p_api_version IN NUMBER,
215 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
216 x_return_status OUT NOCOPY VARCHAR2,
217 x_msg_count OUT NOCOPY NUMBER,
218 x_msg_data OUT NOCOPY VARCHAR2,
219 p_codv_rec IN codv_rec_type);
220 PROCEDURE validate_row(
221 p_api_version IN NUMBER,
222 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
223 x_return_status OUT NOCOPY VARCHAR2,
224 x_msg_count OUT NOCOPY NUMBER,
225 x_msg_data OUT NOCOPY VARCHAR2,
226 p_codv_tbl IN codv_tbl_type,
227 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
228 PROCEDURE validate_row(
229 p_api_version IN NUMBER,
230 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
231 x_return_status OUT NOCOPY VARCHAR2,
232 x_msg_count OUT NOCOPY NUMBER,
233 x_msg_data OUT NOCOPY VARCHAR2,
234 p_codv_tbl IN codv_tbl_type);
235 END OKS_COD_PVT;