[Home] [Help]
PACKAGE: APPS.OKC_CRJ_PVT
Source
1 Package OKC_CRJ_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCSCRJS.pls 120.0 2005/05/26 09:55:15 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE crj_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 cle_id NUMBER := OKC_API.G_MISS_NUM,
9 chr_id NUMBER := OKC_API.G_MISS_NUM,
10 rty_code OKC_K_REL_OBJS.RTY_CODE%TYPE := OKC_API.G_MISS_CHAR,
11 object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
12 object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
13 jtot_object1_id NUMBER := OKC_API.G_MISS_NUM,
14 jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
15 object_version_number NUMBER := OKC_API.G_MISS_NUM,
16 created_by NUMBER := OKC_API.G_MISS_NUM,
17 creation_date OKC_K_REL_OBJS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19 last_update_date OKC_K_REL_OBJS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20 last_update_login NUMBER := OKC_API.G_MISS_NUM,
21 attribute_category OKC_K_REL_OBJS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
22 attribute1 OKC_K_REL_OBJS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
23 attribute2 OKC_K_REL_OBJS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
24 attribute3 OKC_K_REL_OBJS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
25 attribute4 OKC_K_REL_OBJS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
26 attribute5 OKC_K_REL_OBJS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
27 attribute6 OKC_K_REL_OBJS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
28 attribute7 OKC_K_REL_OBJS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
29 attribute8 OKC_K_REL_OBJS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
30 attribute9 OKC_K_REL_OBJS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
31 attribute10 OKC_K_REL_OBJS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
32 attribute11 OKC_K_REL_OBJS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
33 attribute12 OKC_K_REL_OBJS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
34 attribute13 OKC_K_REL_OBJS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
35 attribute14 OKC_K_REL_OBJS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
36 attribute15 OKC_K_REL_OBJS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
37 g_miss_crj_rec crj_rec_type;
38 TYPE crj_tbl_type IS TABLE OF crj_rec_type
39 INDEX BY BINARY_INTEGER;
40 TYPE crjv_rec_type IS RECORD (
41 id NUMBER := OKC_API.G_MISS_NUM,
42 object_version_number NUMBER := OKC_API.G_MISS_NUM,
43 cle_id NUMBER := OKC_API.G_MISS_NUM,
44 chr_id NUMBER := OKC_API.G_MISS_NUM,
45 rty_code OKC_K_REL_OBJS.RTY_CODE%TYPE := OKC_API.G_MISS_CHAR,
46 object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
47 object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
48 jtot_object1_id NUMBER := OKC_API.G_MISS_NUM,
49 jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
50 attribute_category OKC_K_REL_OBJS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
51 attribute1 OKC_K_REL_OBJS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
52 attribute2 OKC_K_REL_OBJS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
53 attribute3 OKC_K_REL_OBJS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
54 attribute4 OKC_K_REL_OBJS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
55 attribute5 OKC_K_REL_OBJS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
56 attribute6 OKC_K_REL_OBJS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
57 attribute7 OKC_K_REL_OBJS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
58 attribute8 OKC_K_REL_OBJS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
59 attribute9 OKC_K_REL_OBJS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
60 attribute10 OKC_K_REL_OBJS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
61 attribute11 OKC_K_REL_OBJS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
62 attribute12 OKC_K_REL_OBJS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
63 attribute13 OKC_K_REL_OBJS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
64 attribute14 OKC_K_REL_OBJS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
65 attribute15 OKC_K_REL_OBJS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
66 created_by NUMBER := OKC_API.G_MISS_NUM,
67 creation_date OKC_K_REL_OBJS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
68 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
69 last_update_date OKC_K_REL_OBJS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
70 last_update_login NUMBER := OKC_API.G_MISS_NUM);
71 g_miss_crjv_rec crjv_rec_type;
72 TYPE crjv_tbl_type IS TABLE OF crjv_rec_type
73 INDEX BY BINARY_INTEGER;
74 ---------------------------------------------------------------------------
75 -- GLOBAL MESSAGE CONSTANTS
76 ---------------------------------------------------------------------------
77 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
78 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
79 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
80 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
81 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
82 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
83 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
84 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
85 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
86 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
87 ---------------------------------------------------------------------------
88 -- GLOBAL VARIABLES
89 ---------------------------------------------------------------------------
90 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CRJ_PVT';
91 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
92 ---------------------------------------------------------------------------
93 -- Procedures and Functions
94 ---------------------------------------------------------------------------
95
96 PROCEDURE qc;
97 PROCEDURE change_version;
98 PROCEDURE api_copy;
99 PROCEDURE insert_row(
100 p_api_version IN NUMBER,
101 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_msg_count OUT NOCOPY NUMBER,
104 x_msg_data OUT NOCOPY VARCHAR2,
105 p_crjv_rec IN crjv_rec_type,
106 x_crjv_rec OUT NOCOPY crjv_rec_type);
107
108 PROCEDURE insert_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_crjv_tbl IN crjv_tbl_type,
115 x_crjv_tbl OUT NOCOPY crjv_tbl_type);
116
117 PROCEDURE lock_row(
118 p_api_version IN NUMBER,
119 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_msg_count OUT NOCOPY NUMBER,
122 x_msg_data OUT NOCOPY VARCHAR2,
123 p_crjv_rec IN crjv_rec_type);
124
125 PROCEDURE lock_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_crjv_tbl IN crjv_tbl_type);
132
133 PROCEDURE update_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_crjv_rec IN crjv_rec_type,
140 x_crjv_rec OUT NOCOPY crjv_rec_type);
141
142 PROCEDURE update_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_crjv_tbl IN crjv_tbl_type,
149 x_crjv_tbl OUT NOCOPY crjv_tbl_type);
150
151 PROCEDURE delete_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_crjv_rec IN crjv_rec_type);
158
159 PROCEDURE delete_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_crjv_tbl IN crjv_tbl_type);
166
167 PROCEDURE validate_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_crjv_rec IN crjv_rec_type);
174
175 PROCEDURE validate_row(
176 p_api_version IN NUMBER,
177 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
178 x_return_status OUT NOCOPY VARCHAR2,
179 x_msg_count OUT NOCOPY NUMBER,
180 x_msg_data OUT NOCOPY VARCHAR2,
181 p_crjv_tbl IN crjv_tbl_type);
182
183 PROCEDURE quote_is_renewal
184 (
185 p_api_version IN NUMBER
186 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
187 ,x_return_status OUT NOCOPY VARCHAR2
188 ,x_msg_count OUT NOCOPY NUMBER
189 ,x_msg_data OUT NOCOPY VARCHAR2
190 ,p_crjv_rec IN crjv_rec_type
191 ,x_true_false out nocopy boolean
192 );
193
194 PROCEDURE order_is_renewal
195 (
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_crjv_rec IN crjv_rec_type
202 ,x_true_false out nocopy boolean
203 );
204
205 PROCEDURE quote_is_subject
206 (
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_crjv_rec IN crjv_rec_type
213 ,x_true_false out nocopy boolean
214 );
215
216 PROCEDURE order_is_subject
217 (
218 p_api_version IN NUMBER
219 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
220 ,x_return_status OUT NOCOPY VARCHAR2
221 ,x_msg_count OUT NOCOPY NUMBER
222 ,x_msg_data OUT NOCOPY VARCHAR2
223 ,p_crjv_rec IN crjv_rec_type
224 ,x_true_false out nocopy boolean
225 );
226
227 PROCEDURE quote_contract_is_ordered
228 (
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_crjv_rec IN crjv_rec_type
235 ,x_true_false out nocopy boolean
236 );
237
238 PROCEDURE GET_OBJ_FROM_JTFV
239 (
240 p_object_code IN VARCHAR2
241 ,p_id1 IN NUMBER
242 ,p_id2 IN VARCHAR2
243 ,x_true_false out nocopy boolean
244 );
245
246 PROCEDURE valid_rec_unique
247 (
248 p_crjv_rec IN crjv_rec_type
249 ,p_api IN varchar2
250 ,x_return_status OUT NOCOPY VARCHAR2
251 );
252
253 PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,p_crjv_tbl crjv_tbl_type);
254 END OKC_CRJ_PVT;