[Home] [Help]
PACKAGE: APPS.OKL_OPT_RUL_TMP_PVT
Source
1 Package Okl_Opt_Rul_Tmp_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLRRTMS.pls 115.1 2002/02/25 17:08:32 pkm ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 /*
7 TYPE rul_rec_type IS RECORD (
8 id NUMBER := Okc_Api.G_MISS_NUM,
9 rgp_id NUMBER := Okc_Api.G_MISS_NUM,
10 object1_id1 OKC_RULES_B.OBJECT1_ID1%TYPE := Okc_Api.G_MISS_CHAR,
11 object2_id1 OKC_RULES_B.OBJECT2_ID1%TYPE := Okc_Api.G_MISS_CHAR,
12 object3_id1 OKC_RULES_B.OBJECT3_ID1%TYPE := Okc_Api.G_MISS_CHAR,
13 object1_id2 OKC_RULES_B.OBJECT1_ID2%TYPE := Okc_Api.G_MISS_CHAR,
14 object2_id2 OKC_RULES_B.OBJECT2_ID2%TYPE := Okc_Api.G_MISS_CHAR,
15 object3_id2 OKC_RULES_B.OBJECT3_ID2%TYPE := Okc_Api.G_MISS_CHAR,
16 jtot_object1_code OKC_RULES_B.JTOT_OBJECT1_CODE%TYPE := Okc_Api.G_MISS_CHAR,
17 jtot_object2_code OKC_RULES_B.JTOT_OBJECT2_CODE%TYPE := Okc_Api.G_MISS_CHAR,
18 jtot_object3_code OKC_RULES_B.JTOT_OBJECT3_CODE%TYPE := Okc_Api.G_MISS_CHAR,
19 dnz_chr_id NUMBER := Okc_Api.G_MISS_NUM,
20 std_template_yn OKC_RULES_B.STD_TEMPLATE_YN%TYPE := Okc_Api.G_MISS_CHAR,
21 warn_yn OKC_RULES_B.WARN_YN%TYPE := Okc_Api.G_MISS_CHAR,
22 priority NUMBER := Okc_Api.G_MISS_NUM,
23 object_version_number NUMBER := Okc_Api.G_MISS_NUM,
24 created_by NUMBER := Okc_Api.G_MISS_NUM,
25 creation_date OKC_RULES_B.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
26 last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
27 last_update_date OKC_RULES_B.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
28 last_update_login NUMBER := Okc_Api.G_MISS_NUM,
29 attribute_category OKC_RULES_B.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
30 attribute1 OKC_RULES_B.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
31 attribute2 OKC_RULES_B.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
32 attribute3 OKC_RULES_B.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
33 attribute4 OKC_RULES_B.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
34 attribute5 OKC_RULES_B.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
35 attribute6 OKC_RULES_B.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
36 attribute7 OKC_RULES_B.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
37 attribute8 OKC_RULES_B.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
38 attribute9 OKC_RULES_B.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
39 attribute10 OKC_RULES_B.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
40 attribute11 OKC_RULES_B.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
41 attribute12 OKC_RULES_B.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
42 attribute13 OKC_RULES_B.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
43 attribute14 OKC_RULES_B.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
44 attribute15 OKC_RULES_B.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
45 rule_information_category OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
46 rule_information1 OKC_RULES_B.RULE_INFORMATION1%TYPE := Okc_Api.G_MISS_CHAR,
47 rule_information2 OKC_RULES_B.RULE_INFORMATION2%TYPE := Okc_Api.G_MISS_CHAR,
48 rule_information3 OKC_RULES_B.RULE_INFORMATION3%TYPE := Okc_Api.G_MISS_CHAR,
49 rule_information4 OKC_RULES_B.RULE_INFORMATION4%TYPE := Okc_Api.G_MISS_CHAR,
50 rule_information5 OKC_RULES_B.RULE_INFORMATION5%TYPE := Okc_Api.G_MISS_CHAR,
51 rule_information6 OKC_RULES_B.RULE_INFORMATION6%TYPE := Okc_Api.G_MISS_CHAR,
52 rule_information7 OKC_RULES_B.RULE_INFORMATION7%TYPE := Okc_Api.G_MISS_CHAR,
53 rule_information8 OKC_RULES_B.RULE_INFORMATION8%TYPE := Okc_Api.G_MISS_CHAR,
54 rule_information9 OKC_RULES_B.RULE_INFORMATION9%TYPE := Okc_Api.G_MISS_CHAR,
55 rule_information10 OKC_RULES_B.RULE_INFORMATION10%TYPE := Okc_Api.G_MISS_CHAR,
56 rule_information11 OKC_RULES_B.RULE_INFORMATION11%TYPE := Okc_Api.G_MISS_CHAR,
57 rule_information12 OKC_RULES_B.RULE_INFORMATION12%TYPE := Okc_Api.G_MISS_CHAR,
58 rule_information13 OKC_RULES_B.RULE_INFORMATION13%TYPE := Okc_Api.G_MISS_CHAR,
59 rule_information14 OKC_RULES_B.RULE_INFORMATION14%TYPE := Okc_Api.G_MISS_CHAR,
60 rule_information15 OKC_RULES_B.RULE_INFORMATION15%TYPE := Okc_Api.G_MISS_CHAR,
61 template_yn OKC_RULES_B.TEMPLATE_YN%TYPE := Okc_Api.G_MISS_CHAR,
62 ans_set_jtot_object_code OKC_RULES_B.ans_set_jtot_object_code%TYPE := Okc_Api.G_MISS_CHAR,
63 ans_set_jtot_object_id1 OKC_RULES_B.ans_set_jtot_object_id1%TYPE := Okc_Api.G_MISS_CHAR,
64 ans_set_jtot_object_id2 OKC_RULES_B.ans_set_jtot_object_id2%TYPE := Okc_Api.G_MISS_CHAR,
65 display_sequence NUMBER:= Okc_Api.G_MISS_NUM
66 );
67 g_miss_rul_rec rul_rec_type;
68 TYPE rul_tbl_type IS TABLE OF rul_rec_type
69 INDEX BY BINARY_INTEGER;
70 TYPE okc_rules_tl_rec_type IS RECORD (
71 id NUMBER := Okc_Api.G_MISS_NUM,
72 LANGUAGE OKC_RULES_TL.LANGUAGE%TYPE := Okc_Api.G_MISS_CHAR,
73 source_lang OKC_RULES_TL.SOURCE_LANG%TYPE := Okc_Api.G_MISS_CHAR,
74 sfwt_flag OKC_RULES_TL.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
75 comments OKC_RULES_TL.COMMENTS%TYPE := Okc_Api.G_MISS_CHAR,
76 text OKC_RULES_TL.TEXT%TYPE := NULL,
77 created_by NUMBER := Okc_Api.G_MISS_NUM,
78 creation_date OKC_RULES_TL.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
79 last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
80 last_update_date OKC_RULES_TL.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
81 last_update_login NUMBER := Okc_Api.G_MISS_NUM);
82 g_miss_okc_rules_tl_rec okc_rules_tl_rec_type;
83 TYPE okc_rules_tl_tbl_type IS TABLE OF okc_rules_tl_rec_type
84 INDEX BY BINARY_INTEGER;
85 TYPE rulv_rec_type IS RECORD (
86 id NUMBER := Okc_Api.G_MISS_NUM,
87 object_version_number NUMBER := Okc_Api.G_MISS_NUM,
88 sfwt_flag OKC_RULES_V.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
89 object1_id1 OKC_RULES_V.OBJECT1_ID1%TYPE := Okc_Api.G_MISS_CHAR,
90 object2_id1 OKC_RULES_V.OBJECT2_ID1%TYPE := Okc_Api.G_MISS_CHAR,
91 object3_id1 OKC_RULES_V.OBJECT3_ID1%TYPE := Okc_Api.G_MISS_CHAR,
92 object1_id2 OKC_RULES_V.OBJECT1_ID2%TYPE := Okc_Api.G_MISS_CHAR,
93 object2_id2 OKC_RULES_V.OBJECT2_ID2%TYPE := Okc_Api.G_MISS_CHAR,
94 object3_id2 OKC_RULES_V.OBJECT3_ID2%TYPE := Okc_Api.G_MISS_CHAR,
95 jtot_object1_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE := Okc_Api.G_MISS_CHAR,
96 jtot_object2_code OKC_RULES_V.JTOT_OBJECT2_CODE%TYPE := Okc_Api.G_MISS_CHAR,
97 jtot_object3_code OKC_RULES_V.JTOT_OBJECT3_CODE%TYPE := Okc_Api.G_MISS_CHAR,
98 dnz_chr_id NUMBER := Okc_Api.G_MISS_NUM,
99 rgp_id NUMBER := Okc_Api.G_MISS_NUM,
100 priority NUMBER := Okc_Api.G_MISS_NUM,
101 std_template_yn OKC_RULES_V.STD_TEMPLATE_YN%TYPE := Okc_Api.G_MISS_CHAR,
102 comments OKC_RULES_V.COMMENTS%TYPE := Okc_Api.G_MISS_CHAR,
103 warn_yn OKC_RULES_V.WARN_YN%TYPE := Okc_Api.G_MISS_CHAR,
104 attribute_category OKC_RULES_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
105 attribute1 OKC_RULES_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
106 attribute2 OKC_RULES_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
107 attribute3 OKC_RULES_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
108 attribute4 OKC_RULES_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
109 attribute5 OKC_RULES_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
110 attribute6 OKC_RULES_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
111 attribute7 OKC_RULES_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
112 attribute8 OKC_RULES_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
113 attribute9 OKC_RULES_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
114 attribute10 OKC_RULES_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
115 attribute11 OKC_RULES_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
116 attribute12 OKC_RULES_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
117 attribute13 OKC_RULES_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
118 attribute14 OKC_RULES_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
119 attribute15 OKC_RULES_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
120 created_by NUMBER := Okc_Api.G_MISS_NUM,
121 creation_date OKC_RULES_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
122 last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
123 last_update_date OKC_RULES_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
124 last_update_login NUMBER := Okc_Api.G_MISS_NUM,
125 text OKC_RULES_V.TEXT%TYPE := NULL,
126 rule_information_category OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
127 rule_information1 OKC_RULES_V.RULE_INFORMATION1%TYPE := Okc_Api.G_MISS_CHAR,
128 rule_information2 OKC_RULES_V.RULE_INFORMATION2%TYPE := Okc_Api.G_MISS_CHAR,
129 rule_information3 OKC_RULES_V.RULE_INFORMATION3%TYPE := Okc_Api.G_MISS_CHAR,
130 rule_information4 OKC_RULES_V.RULE_INFORMATION4%TYPE := Okc_Api.G_MISS_CHAR,
131 rule_information5 OKC_RULES_V.RULE_INFORMATION5%TYPE := Okc_Api.G_MISS_CHAR,
132 rule_information6 OKC_RULES_V.RULE_INFORMATION6%TYPE := Okc_Api.G_MISS_CHAR,
133 rule_information7 OKC_RULES_V.RULE_INFORMATION7%TYPE := Okc_Api.G_MISS_CHAR,
134 rule_information8 OKC_RULES_V.RULE_INFORMATION8%TYPE := Okc_Api.G_MISS_CHAR,
135 rule_information9 OKC_RULES_V.RULE_INFORMATION9%TYPE := Okc_Api.G_MISS_CHAR,
136 rule_information10 OKC_RULES_V.RULE_INFORMATION10%TYPE := Okc_Api.G_MISS_CHAR,
137 rule_information11 OKC_RULES_V.RULE_INFORMATION11%TYPE := Okc_Api.G_MISS_CHAR,
138 rule_information12 OKC_RULES_V.RULE_INFORMATION12%TYPE := Okc_Api.G_MISS_CHAR,
139 rule_information13 OKC_RULES_V.RULE_INFORMATION13%TYPE := Okc_Api.G_MISS_CHAR,
140 rule_information14 OKC_RULES_V.RULE_INFORMATION14%TYPE := Okc_Api.G_MISS_CHAR,
141 rule_information15 OKC_RULES_V.RULE_INFORMATION15%TYPE := Okc_Api.G_MISS_CHAR,
142 template_yn OKC_RULES_B.TEMPLATE_YN%TYPE := Okc_Api.G_MISS_CHAR,
143 ans_set_jtot_object_code OKC_RULES_B.ans_set_jtot_object_code%TYPE := Okc_Api.G_MISS_CHAR,
144 ans_set_jtot_object_id1 OKC_RULES_B.ans_set_jtot_object_id1%TYPE := Okc_Api.G_MISS_CHAR,
145 ans_set_jtot_object_id2 OKC_RULES_B.ans_set_jtot_object_id2%TYPE := Okc_Api.G_MISS_CHAR,
146 display_sequence NUMBER:= Okc_Api.G_MISS_NUM
147 );
148 g_miss_rulv_rec rulv_rec_type;
149 TYPE rulv_tbl_type IS TABLE OF rulv_rec_type
150 INDEX BY BINARY_INTEGER;
151 */
152
153 SUBTYPE ovtv_rec_type IS Okl_Ovt_Pvt.ovtv_rec_type;
154 SUBTYPE rgrv_rec_type IS Okl_Rgrp_Rules_Process_Pvt.rgr_rec_type;
155 SUBTYPE rgrv_tbl_type IS Okl_Rgrp_Rules_Process_Pvt.rgr_tbl_type;
156
157 SUBTYPE rulv_rec_type IS Okc_Rul_Pvt.rulv_rec_type;
158
159 ---------------------------------------------------------------------------
160 -- GLOBAL MESSAGE CONSTANTS
161 ---------------------------------------------------------------------------
162 G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
163 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
164 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
165 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
166 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
167 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
168 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
169 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
170 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
171 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
172
173 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
174 G_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_TABLE_NAME';
175 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
176 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
177 G_UNQS CONSTANT VARCHAR2(200) := 'OKL_NOT_UNIQUE';
178
179 ---------------------------------------------------------------------------
180 -- GLOBAL EXCEPTION
181 ---------------------------------------------------------------------------
182 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
183 G_ITEM_NOT_FOUND_ERROR EXCEPTION;
184 ---------------------------------------------------------------------------
185 -- GLOBAL VARIABLES
186 ---------------------------------------------------------------------------
187 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_OVD_PVT';
188 G_APP_NAME CONSTANT VARCHAR2(3) := Okc_Api.G_APP_NAME;
189 G_LOOKUP_TYPE CONSTANT VARCHAR2(50) := 'OKL_OPTION_VALUE_RULE_FLAG';
190 G_INTENT_TYPE CONSTANT VARCHAR2(50) := 'OKL_INTENT_TYPE';
191 ---------------------------------------------------------------------------
192 -- Procedures and Functions
193 ---------------------------------------------------------------------------
194
195 PROCEDURE insert_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_ovd_id IN NUMBER,
202 p_rgrv_rec IN rgrv_rec_type,
203 x_rgrv_rec OUT NOCOPY rgrv_rec_type);
204
205 PROCEDURE insert_row(
206 p_api_version IN NUMBER,
207 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
208 x_return_status OUT NOCOPY VARCHAR2,
209 x_msg_count OUT NOCOPY NUMBER,
210 x_msg_data OUT NOCOPY VARCHAR2,
211 p_ovd_id IN NUMBER,
212 p_rgrv_tbl IN rgrv_tbl_type,
213 x_rgrv_tbl OUT NOCOPY rgrv_tbl_type);
214
215 PROCEDURE update_row(
216 p_api_version IN NUMBER,
217 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
218 x_return_status OUT NOCOPY VARCHAR2,
219 x_msg_count OUT NOCOPY NUMBER,
220 x_msg_data OUT NOCOPY VARCHAR2,
221 p_rgrv_rec IN rgrv_rec_type,
222 x_rgrv_rec OUT NOCOPY rgrv_rec_type);
223
224 PROCEDURE update_row(
225 p_api_version IN NUMBER,
226 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
227 x_return_status OUT NOCOPY VARCHAR2,
228 x_msg_count OUT NOCOPY NUMBER,
229 x_msg_data OUT NOCOPY VARCHAR2,
230 p_rgrv_tbl IN rgrv_tbl_type,
231 x_rgrv_tbl OUT NOCOPY rgrv_tbl_type);
232
233 PROCEDURE delete_row(
234 p_api_version IN NUMBER,
235 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
236 x_return_status OUT NOCOPY VARCHAR2,
237 x_msg_count OUT NOCOPY NUMBER,
238 x_msg_data OUT NOCOPY VARCHAR2,
239 p_rgrv_rec IN rgrv_rec_type);
240
241 PROCEDURE delete_row(
242 p_api_version IN NUMBER,
243 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
244 x_return_status OUT NOCOPY VARCHAR2,
245 x_msg_count OUT NOCOPY NUMBER,
246 x_msg_data OUT NOCOPY VARCHAR2,
247 p_rgrv_tbl IN rgrv_tbl_type);
248
249 END Okl_Opt_Rul_Tmp_Pvt;