[Home] [Help]
PACKAGE: APPS.OKC_PAV_PVT
Source
1 Package OKC_PAV_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCSPAVS.pls 120.0 2005/05/26 09:56:21 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE pav_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 flex_title OKC_PRICE_ATT_VALUES.FLEX_TITLE%TYPE := OKC_API.G_MISS_CHAR,
9 pricing_context OKC_PRICE_ATT_VALUES.PRICING_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
10 pricing_attribute1 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
11 chr_id NUMBER := OKC_API.G_MISS_NUM,
12 pricing_attribute2 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
13 cle_id NUMBER := OKC_API.G_MISS_NUM,
14 pricing_attribute3 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
15 pricing_attribute4 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
16 pricing_attribute5 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
17 pricing_attribute6 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
18 pricing_attribute7 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
19 pricing_attribute8 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
20 pricing_attribute9 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
21 pricing_attribute10 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
22 pricing_attribute11 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
23 pricing_attribute12 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
24 pricing_attribute13 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
25 pricing_attribute14 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
26 pricing_attribute15 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
27 pricing_attribute16 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE16%TYPE := OKC_API.G_MISS_CHAR,
28 pricing_attribute17 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE17%TYPE := OKC_API.G_MISS_CHAR,
29 pricing_attribute18 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE18%TYPE := OKC_API.G_MISS_CHAR,
30 pricing_attribute19 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE19%TYPE := OKC_API.G_MISS_CHAR,
31 pricing_attribute20 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE20%TYPE := OKC_API.G_MISS_CHAR,
32 pricing_attribute21 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE21%TYPE := OKC_API.G_MISS_CHAR,
33 pricing_attribute22 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE22%TYPE := OKC_API.G_MISS_CHAR,
34 pricing_attribute23 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE23%TYPE := OKC_API.G_MISS_CHAR,
35 pricing_attribute24 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE24%TYPE := OKC_API.G_MISS_CHAR,
36 pricing_attribute25 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE25%TYPE := OKC_API.G_MISS_CHAR,
37 pricing_attribute26 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE26%TYPE := OKC_API.G_MISS_CHAR,
38 pricing_attribute27 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE27%TYPE := OKC_API.G_MISS_CHAR,
39 pricing_attribute28 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE28%TYPE := OKC_API.G_MISS_CHAR,
40 pricing_attribute29 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE29%TYPE := OKC_API.G_MISS_CHAR,
41 pricing_attribute30 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE30%TYPE := OKC_API.G_MISS_CHAR,
42 pricing_attribute31 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE31%TYPE := OKC_API.G_MISS_CHAR,
43 pricing_attribute32 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE32%TYPE := OKC_API.G_MISS_CHAR,
44 pricing_attribute33 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE33%TYPE := OKC_API.G_MISS_CHAR,
45 pricing_attribute34 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE34%TYPE := OKC_API.G_MISS_CHAR,
46 pricing_attribute35 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE35%TYPE := OKC_API.G_MISS_CHAR,
47 pricing_attribute36 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE36%TYPE := OKC_API.G_MISS_CHAR,
48 pricing_attribute37 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE37%TYPE := OKC_API.G_MISS_CHAR,
49 pricing_attribute38 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE38%TYPE := OKC_API.G_MISS_CHAR,
50 pricing_attribute39 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE39%TYPE := OKC_API.G_MISS_CHAR,
51 pricing_attribute40 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE40%TYPE := OKC_API.G_MISS_CHAR,
52 pricing_attribute41 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE41%TYPE := OKC_API.G_MISS_CHAR,
53 pricing_attribute42 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE42%TYPE := OKC_API.G_MISS_CHAR,
54 pricing_attribute43 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE43%TYPE := OKC_API.G_MISS_CHAR,
55 pricing_attribute44 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE44%TYPE := OKC_API.G_MISS_CHAR,
56 pricing_attribute45 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE45%TYPE := OKC_API.G_MISS_CHAR,
57 pricing_attribute46 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE46%TYPE := OKC_API.G_MISS_CHAR,
58 pricing_attribute47 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE47%TYPE := OKC_API.G_MISS_CHAR,
59 pricing_attribute48 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE48%TYPE := OKC_API.G_MISS_CHAR,
60 pricing_attribute49 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE49%TYPE := OKC_API.G_MISS_CHAR,
61 pricing_attribute50 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE50%TYPE := OKC_API.G_MISS_CHAR,
62 pricing_attribute51 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE51%TYPE := OKC_API.G_MISS_CHAR,
63 pricing_attribute52 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE52%TYPE := OKC_API.G_MISS_CHAR,
64 pricing_attribute53 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE53%TYPE := OKC_API.G_MISS_CHAR,
65 pricing_attribute54 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE54%TYPE := OKC_API.G_MISS_CHAR,
66 pricing_attribute55 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE55%TYPE := OKC_API.G_MISS_CHAR,
67 pricing_attribute56 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE56%TYPE := OKC_API.G_MISS_CHAR,
68 pricing_attribute57 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE57%TYPE := OKC_API.G_MISS_CHAR,
69 pricing_attribute58 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE58%TYPE := OKC_API.G_MISS_CHAR,
70 pricing_attribute59 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE59%TYPE := OKC_API.G_MISS_CHAR,
71 pricing_attribute60 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE60%TYPE := OKC_API.G_MISS_CHAR,
72 pricing_attribute61 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE61%TYPE := OKC_API.G_MISS_CHAR,
73 pricing_attribute62 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE62%TYPE := OKC_API.G_MISS_CHAR,
74 pricing_attribute63 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE63%TYPE := OKC_API.G_MISS_CHAR,
75 pricing_attribute64 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE64%TYPE := OKC_API.G_MISS_CHAR,
76 pricing_attribute65 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE65%TYPE := OKC_API.G_MISS_CHAR,
77 pricing_attribute66 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE66%TYPE := OKC_API.G_MISS_CHAR,
78 pricing_attribute67 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE67%TYPE := OKC_API.G_MISS_CHAR,
79 pricing_attribute68 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE68%TYPE := OKC_API.G_MISS_CHAR,
80 pricing_attribute69 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE69%TYPE := OKC_API.G_MISS_CHAR,
81 pricing_attribute70 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE70%TYPE := OKC_API.G_MISS_CHAR,
82 pricing_attribute71 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE71%TYPE := OKC_API.G_MISS_CHAR,
83 pricing_attribute72 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE72%TYPE := OKC_API.G_MISS_CHAR,
84 pricing_attribute73 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE73%TYPE := OKC_API.G_MISS_CHAR,
85 pricing_attribute74 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE74%TYPE := OKC_API.G_MISS_CHAR,
86 pricing_attribute75 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE75%TYPE := OKC_API.G_MISS_CHAR,
87 pricing_attribute76 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE76%TYPE := OKC_API.G_MISS_CHAR,
88 pricing_attribute77 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE77%TYPE := OKC_API.G_MISS_CHAR,
89 pricing_attribute78 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE78%TYPE := OKC_API.G_MISS_CHAR,
90 pricing_attribute79 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE79%TYPE := OKC_API.G_MISS_CHAR,
91 pricing_attribute80 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE80%TYPE := OKC_API.G_MISS_CHAR,
92 pricing_attribute81 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE81%TYPE := OKC_API.G_MISS_CHAR,
93 pricing_attribute82 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE82%TYPE := OKC_API.G_MISS_CHAR,
94 pricing_attribute83 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE83%TYPE := OKC_API.G_MISS_CHAR,
95 pricing_attribute84 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE84%TYPE := OKC_API.G_MISS_CHAR,
96 pricing_attribute85 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE85%TYPE := OKC_API.G_MISS_CHAR,
97 pricing_attribute86 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE86%TYPE := OKC_API.G_MISS_CHAR,
98 pricing_attribute87 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE87%TYPE := OKC_API.G_MISS_CHAR,
99 pricing_attribute88 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE88%TYPE := OKC_API.G_MISS_CHAR,
100 pricing_attribute89 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE89%TYPE := OKC_API.G_MISS_CHAR,
101 pricing_attribute90 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE90%TYPE := OKC_API.G_MISS_CHAR,
102 pricing_attribute91 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE91%TYPE := OKC_API.G_MISS_CHAR,
103 pricing_attribute92 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE92%TYPE := OKC_API.G_MISS_CHAR,
104 pricing_attribute93 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE93%TYPE := OKC_API.G_MISS_CHAR,
105 pricing_attribute94 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE94%TYPE := OKC_API.G_MISS_CHAR,
106 pricing_attribute95 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE95%TYPE := OKC_API.G_MISS_CHAR,
107 pricing_attribute96 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE96%TYPE := OKC_API.G_MISS_CHAR,
108 pricing_attribute97 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE97%TYPE := OKC_API.G_MISS_CHAR,
109 pricing_attribute98 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE98%TYPE := OKC_API.G_MISS_CHAR,
110 pricing_attribute99 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE99%TYPE := OKC_API.G_MISS_CHAR,
111 pricing_attribute100 OKC_PRICE_ATT_VALUES.PRICING_ATTRIBUTE100%TYPE := OKC_API.G_MISS_CHAR,
112 qualifier_context OKC_PRICE_ATT_VALUES.QUALIFIER_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
113 qualifier_attribute1 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
114 qualifier_attribute2 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
115 created_by NUMBER := OKC_API.G_MISS_NUM,
116 qualifier_attribute3 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
117 creation_date OKC_PRICE_ATT_VALUES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
118 qualifier_attribute4 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
119 qualifier_attribute5 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
120 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
121 qualifier_attribute6 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
122 last_update_date OKC_PRICE_ATT_VALUES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
123 qualifier_attribute7 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
124 qualifier_attribute8 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
125 qualifier_attribute9 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
126 qualifier_attribute10 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
127 qualifier_attribute11 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
128 qualifier_attribute12 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
129 qualifier_attribute13 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
130 qualifier_attribute14 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
131 qualifier_attribute15 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
132 qualifier_attribute16 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE16%TYPE := OKC_API.G_MISS_CHAR,
133 qualifier_attribute17 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE17%TYPE := OKC_API.G_MISS_CHAR,
134 qualifier_attribute18 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE18%TYPE := OKC_API.G_MISS_CHAR,
135 qualifier_attribute19 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE19%TYPE := OKC_API.G_MISS_CHAR,
136 qualifier_attribute20 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE20%TYPE := OKC_API.G_MISS_CHAR,
137 qualifier_attribute21 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE21%TYPE := OKC_API.G_MISS_CHAR,
138 qualifier_attribute22 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE22%TYPE := OKC_API.G_MISS_CHAR,
139 qualifier_attribute23 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE23%TYPE := OKC_API.G_MISS_CHAR,
140 qualifier_attribute24 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE24%TYPE := OKC_API.G_MISS_CHAR,
141 qualifier_attribute25 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE25%TYPE := OKC_API.G_MISS_CHAR,
142 qualifier_attribute26 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE26%TYPE := OKC_API.G_MISS_CHAR,
143 qualifier_attribute27 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE27%TYPE := OKC_API.G_MISS_CHAR,
144 qualifier_attribute28 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE28%TYPE := OKC_API.G_MISS_CHAR,
145 qualifier_attribute29 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE29%TYPE := OKC_API.G_MISS_CHAR,
146 qualifier_attribute30 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE30%TYPE := OKC_API.G_MISS_CHAR,
147 qualifier_attribute31 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE31%TYPE := OKC_API.G_MISS_CHAR,
148 qualifier_attribute32 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE32%TYPE := OKC_API.G_MISS_CHAR,
149 qualifier_attribute33 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE33%TYPE := OKC_API.G_MISS_CHAR,
150 qualifier_attribute34 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE34%TYPE := OKC_API.G_MISS_CHAR,
151 qualifier_attribute35 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE35%TYPE := OKC_API.G_MISS_CHAR,
152 qualifier_attribute36 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE36%TYPE := OKC_API.G_MISS_CHAR,
153 qualifier_attribute37 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE37%TYPE := OKC_API.G_MISS_CHAR,
154 qualifier_attribute38 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE38%TYPE := OKC_API.G_MISS_CHAR,
155 qualifier_attribute39 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE39%TYPE := OKC_API.G_MISS_CHAR,
156 qualifier_attribute40 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE40%TYPE := OKC_API.G_MISS_CHAR,
157 qualifier_attribute41 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE41%TYPE := OKC_API.G_MISS_CHAR,
158 qualifier_attribute42 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE42%TYPE := OKC_API.G_MISS_CHAR,
159 qualifier_attribute43 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE43%TYPE := OKC_API.G_MISS_CHAR,
160 qualifier_attribute44 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE44%TYPE := OKC_API.G_MISS_CHAR,
161 qualifier_attribute45 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE45%TYPE := OKC_API.G_MISS_CHAR,
162 qualifier_attribute46 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE46%TYPE := OKC_API.G_MISS_CHAR,
163 qualifier_attribute47 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE47%TYPE := OKC_API.G_MISS_CHAR,
164 qualifier_attribute48 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE48%TYPE := OKC_API.G_MISS_CHAR,
165 qualifier_attribute49 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE49%TYPE := OKC_API.G_MISS_CHAR,
166 qualifier_attribute50 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE50%TYPE := OKC_API.G_MISS_CHAR,
167 qualifier_attribute51 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE51%TYPE := OKC_API.G_MISS_CHAR,
168 qualifier_attribute52 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE52%TYPE := OKC_API.G_MISS_CHAR,
169 qualifier_attribute53 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE53%TYPE := OKC_API.G_MISS_CHAR,
170 qualifier_attribute54 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE54%TYPE := OKC_API.G_MISS_CHAR,
171 qualifier_attribute55 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE55%TYPE := OKC_API.G_MISS_CHAR,
172 qualifier_attribute56 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE56%TYPE := OKC_API.G_MISS_CHAR,
173 qualifier_attribute57 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE57%TYPE := OKC_API.G_MISS_CHAR,
174 qualifier_attribute58 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE58%TYPE := OKC_API.G_MISS_CHAR,
175 qualifier_attribute59 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE59%TYPE := OKC_API.G_MISS_CHAR,
176 qualifier_attribute60 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE60%TYPE := OKC_API.G_MISS_CHAR,
177 qualifier_attribute61 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE61%TYPE := OKC_API.G_MISS_CHAR,
178 qualifier_attribute62 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE62%TYPE := OKC_API.G_MISS_CHAR,
179 qualifier_attribute63 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE63%TYPE := OKC_API.G_MISS_CHAR,
180 qualifier_attribute64 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE64%TYPE := OKC_API.G_MISS_CHAR,
181 qualifier_attribute65 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE65%TYPE := OKC_API.G_MISS_CHAR,
182 qualifier_attribute66 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE66%TYPE := OKC_API.G_MISS_CHAR,
183 qualifier_attribute67 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE67%TYPE := OKC_API.G_MISS_CHAR,
184 qualifier_attribute68 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE68%TYPE := OKC_API.G_MISS_CHAR,
185 qualifier_attribute69 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE69%TYPE := OKC_API.G_MISS_CHAR,
186 qualifier_attribute70 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE70%TYPE := OKC_API.G_MISS_CHAR,
187 qualifier_attribute71 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE71%TYPE := OKC_API.G_MISS_CHAR,
188 qualifier_attribute72 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE72%TYPE := OKC_API.G_MISS_CHAR,
189 qualifier_attribute73 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE73%TYPE := OKC_API.G_MISS_CHAR,
190 qualifier_attribute74 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE74%TYPE := OKC_API.G_MISS_CHAR,
191 qualifier_attribute75 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE75%TYPE := OKC_API.G_MISS_CHAR,
192 qualifier_attribute76 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE76%TYPE := OKC_API.G_MISS_CHAR,
193 qualifier_attribute77 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE77%TYPE := OKC_API.G_MISS_CHAR,
194 qualifier_attribute78 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE78%TYPE := OKC_API.G_MISS_CHAR,
195 qualifier_attribute79 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE79%TYPE := OKC_API.G_MISS_CHAR,
196 qualifier_attribute80 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE80%TYPE := OKC_API.G_MISS_CHAR,
197 qualifier_attribute81 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE81%TYPE := OKC_API.G_MISS_CHAR,
198 qualifier_attribute82 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE82%TYPE := OKC_API.G_MISS_CHAR,
199 qualifier_attribute83 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE83%TYPE := OKC_API.G_MISS_CHAR,
200 qualifier_attribute84 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE84%TYPE := OKC_API.G_MISS_CHAR,
201 qualifier_attribute85 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE85%TYPE := OKC_API.G_MISS_CHAR,
202 qualifier_attribute86 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE86%TYPE := OKC_API.G_MISS_CHAR,
203 qualifier_attribute87 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE87%TYPE := OKC_API.G_MISS_CHAR,
204 qualifier_attribute88 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE88%TYPE := OKC_API.G_MISS_CHAR,
205 qualifier_attribute89 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE89%TYPE := OKC_API.G_MISS_CHAR,
206 qualifier_attribute90 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE90%TYPE := OKC_API.G_MISS_CHAR,
207 qualifier_attribute91 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE91%TYPE := OKC_API.G_MISS_CHAR,
208 qualifier_attribute92 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE92%TYPE := OKC_API.G_MISS_CHAR,
209 qualifier_attribute93 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE93%TYPE := OKC_API.G_MISS_CHAR,
210 qualifier_attribute94 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE94%TYPE := OKC_API.G_MISS_CHAR,
211 qualifier_attribute95 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE95%TYPE := OKC_API.G_MISS_CHAR,
212 qualifier_attribute96 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE96%TYPE := OKC_API.G_MISS_CHAR,
213 qualifier_attribute97 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE97%TYPE := OKC_API.G_MISS_CHAR,
214 qualifier_attribute98 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE98%TYPE := OKC_API.G_MISS_CHAR,
215 qualifier_attribute99 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE99%TYPE := OKC_API.G_MISS_CHAR,
216 qualifier_attribute100 OKC_PRICE_ATT_VALUES.QUALIFIER_ATTRIBUTE100%TYPE := OKC_API.G_MISS_CHAR,
217 last_update_login NUMBER := OKC_API.G_MISS_NUM,
218 program_application_id NUMBER := OKC_API.G_MISS_NUM,
219 program_id NUMBER := OKC_API.G_MISS_NUM,
220 program_update_date OKC_PRICE_ATT_VALUES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
221 request_id NUMBER := OKC_API.G_MISS_NUM,
222 object_version_number NUMBER := OKC_API.G_MISS_NUM);
223 g_miss_pav_rec pav_rec_type;
224 TYPE pav_tbl_type IS TABLE OF pav_rec_type
225 INDEX BY BINARY_INTEGER;
226 TYPE pavv_rec_type IS RECORD (
227 id NUMBER := OKC_API.G_MISS_NUM,
228 chr_id NUMBER := OKC_API.G_MISS_NUM,
229 cle_id NUMBER := OKC_API.G_MISS_NUM,
230 flex_title OKC_PRICE_ATT_VALUES_V.FLEX_TITLE%TYPE := OKC_API.G_MISS_CHAR,
231 pricing_context OKC_PRICE_ATT_VALUES_V.PRICING_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
232 pricing_attribute1 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
233 pricing_attribute2 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
234 pricing_attribute3 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
235 pricing_attribute4 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
236 pricing_attribute5 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
237 pricing_attribute6 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
238 pricing_attribute7 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
239 pricing_attribute8 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
240 pricing_attribute9 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
241 pricing_attribute10 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
242 pricing_attribute11 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
243 pricing_attribute12 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
244 pricing_attribute13 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
245 pricing_attribute14 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
246 pricing_attribute15 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
247 pricing_attribute16 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE16%TYPE := OKC_API.G_MISS_CHAR,
248 pricing_attribute17 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE17%TYPE := OKC_API.G_MISS_CHAR,
249 pricing_attribute18 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE18%TYPE := OKC_API.G_MISS_CHAR,
250 pricing_attribute19 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE19%TYPE := OKC_API.G_MISS_CHAR,
251 pricing_attribute20 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE20%TYPE := OKC_API.G_MISS_CHAR,
252 pricing_attribute21 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE21%TYPE := OKC_API.G_MISS_CHAR,
253 pricing_attribute22 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE22%TYPE := OKC_API.G_MISS_CHAR,
254 pricing_attribute23 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE23%TYPE := OKC_API.G_MISS_CHAR,
255 pricing_attribute24 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE24%TYPE := OKC_API.G_MISS_CHAR,
256 pricing_attribute25 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE25%TYPE := OKC_API.G_MISS_CHAR,
257 pricing_attribute26 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE26%TYPE := OKC_API.G_MISS_CHAR,
258 pricing_attribute27 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE27%TYPE := OKC_API.G_MISS_CHAR,
259 pricing_attribute28 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE28%TYPE := OKC_API.G_MISS_CHAR,
260 pricing_attribute29 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE29%TYPE := OKC_API.G_MISS_CHAR,
261 pricing_attribute30 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE30%TYPE := OKC_API.G_MISS_CHAR,
262 pricing_attribute31 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE31%TYPE := OKC_API.G_MISS_CHAR,
263 pricing_attribute32 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE32%TYPE := OKC_API.G_MISS_CHAR,
264 pricing_attribute33 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE33%TYPE := OKC_API.G_MISS_CHAR,
265 pricing_attribute34 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE34%TYPE := OKC_API.G_MISS_CHAR,
266 pricing_attribute35 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE35%TYPE := OKC_API.G_MISS_CHAR,
267 pricing_attribute36 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE36%TYPE := OKC_API.G_MISS_CHAR,
268 pricing_attribute37 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE37%TYPE := OKC_API.G_MISS_CHAR,
269 pricing_attribute38 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE38%TYPE := OKC_API.G_MISS_CHAR,
270 pricing_attribute39 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE39%TYPE := OKC_API.G_MISS_CHAR,
271 pricing_attribute40 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE40%TYPE := OKC_API.G_MISS_CHAR,
272 pricing_attribute41 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE41%TYPE := OKC_API.G_MISS_CHAR,
273 pricing_attribute42 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE42%TYPE := OKC_API.G_MISS_CHAR,
274 pricing_attribute43 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE43%TYPE := OKC_API.G_MISS_CHAR,
275 pricing_attribute44 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE44%TYPE := OKC_API.G_MISS_CHAR,
276 pricing_attribute45 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE45%TYPE := OKC_API.G_MISS_CHAR,
277 pricing_attribute46 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE46%TYPE := OKC_API.G_MISS_CHAR,
278 pricing_attribute47 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE47%TYPE := OKC_API.G_MISS_CHAR,
279 pricing_attribute48 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE48%TYPE := OKC_API.G_MISS_CHAR,
280 pricing_attribute49 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE49%TYPE := OKC_API.G_MISS_CHAR,
281 pricing_attribute50 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE50%TYPE := OKC_API.G_MISS_CHAR,
282 pricing_attribute51 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE51%TYPE := OKC_API.G_MISS_CHAR,
283 pricing_attribute52 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE52%TYPE := OKC_API.G_MISS_CHAR,
284 pricing_attribute53 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE53%TYPE := OKC_API.G_MISS_CHAR,
285 pricing_attribute54 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE54%TYPE := OKC_API.G_MISS_CHAR,
286 pricing_attribute55 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE55%TYPE := OKC_API.G_MISS_CHAR,
287 pricing_attribute56 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE56%TYPE := OKC_API.G_MISS_CHAR,
288 pricing_attribute57 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE57%TYPE := OKC_API.G_MISS_CHAR,
289 pricing_attribute58 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE58%TYPE := OKC_API.G_MISS_CHAR,
290 pricing_attribute59 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE59%TYPE := OKC_API.G_MISS_CHAR,
291 pricing_attribute60 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE60%TYPE := OKC_API.G_MISS_CHAR,
292 pricing_attribute61 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE61%TYPE := OKC_API.G_MISS_CHAR,
293 pricing_attribute62 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE62%TYPE := OKC_API.G_MISS_CHAR,
294 pricing_attribute63 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE63%TYPE := OKC_API.G_MISS_CHAR,
295 pricing_attribute64 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE64%TYPE := OKC_API.G_MISS_CHAR,
296 pricing_attribute65 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE65%TYPE := OKC_API.G_MISS_CHAR,
297 pricing_attribute66 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE66%TYPE := OKC_API.G_MISS_CHAR,
298 pricing_attribute67 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE67%TYPE := OKC_API.G_MISS_CHAR,
299 pricing_attribute68 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE68%TYPE := OKC_API.G_MISS_CHAR,
300 pricing_attribute69 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE69%TYPE := OKC_API.G_MISS_CHAR,
301 pricing_attribute70 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE70%TYPE := OKC_API.G_MISS_CHAR,
302 pricing_attribute71 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE71%TYPE := OKC_API.G_MISS_CHAR,
303 pricing_attribute72 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE72%TYPE := OKC_API.G_MISS_CHAR,
304 pricing_attribute73 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE73%TYPE := OKC_API.G_MISS_CHAR,
305 pricing_attribute74 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE74%TYPE := OKC_API.G_MISS_CHAR,
306 pricing_attribute75 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE75%TYPE := OKC_API.G_MISS_CHAR,
307 pricing_attribute76 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE76%TYPE := OKC_API.G_MISS_CHAR,
308 pricing_attribute77 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE77%TYPE := OKC_API.G_MISS_CHAR,
309 pricing_attribute78 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE78%TYPE := OKC_API.G_MISS_CHAR,
310 pricing_attribute79 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE79%TYPE := OKC_API.G_MISS_CHAR,
311 pricing_attribute80 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE80%TYPE := OKC_API.G_MISS_CHAR,
312 pricing_attribute81 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE81%TYPE := OKC_API.G_MISS_CHAR,
313 pricing_attribute82 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE82%TYPE := OKC_API.G_MISS_CHAR,
314 pricing_attribute83 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE83%TYPE := OKC_API.G_MISS_CHAR,
315 pricing_attribute84 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE84%TYPE := OKC_API.G_MISS_CHAR,
316 pricing_attribute85 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE85%TYPE := OKC_API.G_MISS_CHAR,
317 pricing_attribute86 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE86%TYPE := OKC_API.G_MISS_CHAR,
318 pricing_attribute87 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE87%TYPE := OKC_API.G_MISS_CHAR,
319 pricing_attribute88 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE88%TYPE := OKC_API.G_MISS_CHAR,
320 pricing_attribute89 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE89%TYPE := OKC_API.G_MISS_CHAR,
321 pricing_attribute90 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE90%TYPE := OKC_API.G_MISS_CHAR,
322 pricing_attribute91 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE91%TYPE := OKC_API.G_MISS_CHAR,
323 pricing_attribute92 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE92%TYPE := OKC_API.G_MISS_CHAR,
324 pricing_attribute93 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE93%TYPE := OKC_API.G_MISS_CHAR,
325 pricing_attribute94 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE94%TYPE := OKC_API.G_MISS_CHAR,
326 pricing_attribute95 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE95%TYPE := OKC_API.G_MISS_CHAR,
327 pricing_attribute96 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE96%TYPE := OKC_API.G_MISS_CHAR,
328 pricing_attribute97 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE97%TYPE := OKC_API.G_MISS_CHAR,
329 pricing_attribute98 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE98%TYPE := OKC_API.G_MISS_CHAR,
330 pricing_attribute99 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE99%TYPE := OKC_API.G_MISS_CHAR,
331 pricing_attribute100 OKC_PRICE_ATT_VALUES_V.PRICING_ATTRIBUTE100%TYPE := OKC_API.G_MISS_CHAR,
332 qualifier_context OKC_PRICE_ATT_VALUES_V.QUALIFIER_CONTEXT%TYPE := OKC_API.G_MISS_CHAR,
333 qualifier_attribute1 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
334 qualifier_attribute2 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
335 qualifier_attribute3 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
336 qualifier_attribute4 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
337 qualifier_attribute5 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
338 qualifier_attribute6 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
339 qualifier_attribute7 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
340 qualifier_attribute8 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
341 qualifier_attribute9 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
342 qualifier_attribute10 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
343 qualifier_attribute11 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
344 qualifier_attribute12 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
345 qualifier_attribute13 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
346 qualifier_attribute14 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
347 qualifier_attribute15 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
348 qualifier_attribute16 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE16%TYPE := OKC_API.G_MISS_CHAR,
349 qualifier_attribute17 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE17%TYPE := OKC_API.G_MISS_CHAR,
350 qualifier_attribute18 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE18%TYPE := OKC_API.G_MISS_CHAR,
351 qualifier_attribute19 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE19%TYPE := OKC_API.G_MISS_CHAR,
352 qualifier_attribute20 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE20%TYPE := OKC_API.G_MISS_CHAR,
353 qualifier_attribute21 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE21%TYPE := OKC_API.G_MISS_CHAR,
354 qualifier_attribute22 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE22%TYPE := OKC_API.G_MISS_CHAR,
355 qualifier_attribute23 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE23%TYPE := OKC_API.G_MISS_CHAR,
356 qualifier_attribute24 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE24%TYPE := OKC_API.G_MISS_CHAR,
357 qualifier_attribute25 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE25%TYPE := OKC_API.G_MISS_CHAR,
358 qualifier_attribute26 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE26%TYPE := OKC_API.G_MISS_CHAR,
359 qualifier_attribute27 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE27%TYPE := OKC_API.G_MISS_CHAR,
360 qualifier_attribute28 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE28%TYPE := OKC_API.G_MISS_CHAR,
361 qualifier_attribute29 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE29%TYPE := OKC_API.G_MISS_CHAR,
362 qualifier_attribute30 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE30%TYPE := OKC_API.G_MISS_CHAR,
363 qualifier_attribute31 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE31%TYPE := OKC_API.G_MISS_CHAR,
364 qualifier_attribute32 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE32%TYPE := OKC_API.G_MISS_CHAR,
365 qualifier_attribute33 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE33%TYPE := OKC_API.G_MISS_CHAR,
366 qualifier_attribute34 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE34%TYPE := OKC_API.G_MISS_CHAR,
367 qualifier_attribute35 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE35%TYPE := OKC_API.G_MISS_CHAR,
368 qualifier_attribute36 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE36%TYPE := OKC_API.G_MISS_CHAR,
369 qualifier_attribute37 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE37%TYPE := OKC_API.G_MISS_CHAR,
370 qualifier_attribute38 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE38%TYPE := OKC_API.G_MISS_CHAR,
371 qualifier_attribute39 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE39%TYPE := OKC_API.G_MISS_CHAR,
372 qualifier_attribute40 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE40%TYPE := OKC_API.G_MISS_CHAR,
373 qualifier_attribute41 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE41%TYPE := OKC_API.G_MISS_CHAR,
374 qualifier_attribute42 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE42%TYPE := OKC_API.G_MISS_CHAR,
375 qualifier_attribute43 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE43%TYPE := OKC_API.G_MISS_CHAR,
376 qualifier_attribute44 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE44%TYPE := OKC_API.G_MISS_CHAR,
377 qualifier_attribute45 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE45%TYPE := OKC_API.G_MISS_CHAR,
378 qualifier_attribute46 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE46%TYPE := OKC_API.G_MISS_CHAR,
379 qualifier_attribute47 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE47%TYPE := OKC_API.G_MISS_CHAR,
380 qualifier_attribute48 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE48%TYPE := OKC_API.G_MISS_CHAR,
381 qualifier_attribute49 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE49%TYPE := OKC_API.G_MISS_CHAR,
382 qualifier_attribute50 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE50%TYPE := OKC_API.G_MISS_CHAR,
383 qualifier_attribute51 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE51%TYPE := OKC_API.G_MISS_CHAR,
384 qualifier_attribute52 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE52%TYPE := OKC_API.G_MISS_CHAR,
385 qualifier_attribute53 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE53%TYPE := OKC_API.G_MISS_CHAR,
386 qualifier_attribute54 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE54%TYPE := OKC_API.G_MISS_CHAR,
387 qualifier_attribute55 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE55%TYPE := OKC_API.G_MISS_CHAR,
388 qualifier_attribute56 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE56%TYPE := OKC_API.G_MISS_CHAR,
389 qualifier_attribute57 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE57%TYPE := OKC_API.G_MISS_CHAR,
390 qualifier_attribute58 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE58%TYPE := OKC_API.G_MISS_CHAR,
391 qualifier_attribute59 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE59%TYPE := OKC_API.G_MISS_CHAR,
392 qualifier_attribute60 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE60%TYPE := OKC_API.G_MISS_CHAR,
393 qualifier_attribute61 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE61%TYPE := OKC_API.G_MISS_CHAR,
394 qualifier_attribute62 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE62%TYPE := OKC_API.G_MISS_CHAR,
395 qualifier_attribute63 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE63%TYPE := OKC_API.G_MISS_CHAR,
396 qualifier_attribute64 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE64%TYPE := OKC_API.G_MISS_CHAR,
397 qualifier_attribute65 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE65%TYPE := OKC_API.G_MISS_CHAR,
398 qualifier_attribute66 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE66%TYPE := OKC_API.G_MISS_CHAR,
399 qualifier_attribute67 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE67%TYPE := OKC_API.G_MISS_CHAR,
400 qualifier_attribute68 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE68%TYPE := OKC_API.G_MISS_CHAR,
401 qualifier_attribute69 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE69%TYPE := OKC_API.G_MISS_CHAR,
402 qualifier_attribute70 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE70%TYPE := OKC_API.G_MISS_CHAR,
403 qualifier_attribute71 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE71%TYPE := OKC_API.G_MISS_CHAR,
404 qualifier_attribute72 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE72%TYPE := OKC_API.G_MISS_CHAR,
405 qualifier_attribute73 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE73%TYPE := OKC_API.G_MISS_CHAR,
406 qualifier_attribute74 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE74%TYPE := OKC_API.G_MISS_CHAR,
407 qualifier_attribute75 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE75%TYPE := OKC_API.G_MISS_CHAR,
408 qualifier_attribute76 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE76%TYPE := OKC_API.G_MISS_CHAR,
409 qualifier_attribute77 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE77%TYPE := OKC_API.G_MISS_CHAR,
410 qualifier_attribute78 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE78%TYPE := OKC_API.G_MISS_CHAR,
411 qualifier_attribute79 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE79%TYPE := OKC_API.G_MISS_CHAR,
412 qualifier_attribute80 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE80%TYPE := OKC_API.G_MISS_CHAR,
413 qualifier_attribute81 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE81%TYPE := OKC_API.G_MISS_CHAR,
414 qualifier_attribute82 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE82%TYPE := OKC_API.G_MISS_CHAR,
415 qualifier_attribute83 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE83%TYPE := OKC_API.G_MISS_CHAR,
416 qualifier_attribute84 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE84%TYPE := OKC_API.G_MISS_CHAR,
417 qualifier_attribute85 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE85%TYPE := OKC_API.G_MISS_CHAR,
418 qualifier_attribute86 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE86%TYPE := OKC_API.G_MISS_CHAR,
419 qualifier_attribute87 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE87%TYPE := OKC_API.G_MISS_CHAR,
420 qualifier_attribute88 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE88%TYPE := OKC_API.G_MISS_CHAR,
421 qualifier_attribute89 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE89%TYPE := OKC_API.G_MISS_CHAR,
422 qualifier_attribute90 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE90%TYPE := OKC_API.G_MISS_CHAR,
423 qualifier_attribute91 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE91%TYPE := OKC_API.G_MISS_CHAR,
424 qualifier_attribute92 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE92%TYPE := OKC_API.G_MISS_CHAR,
425 qualifier_attribute93 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE93%TYPE := OKC_API.G_MISS_CHAR,
426 qualifier_attribute94 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE94%TYPE := OKC_API.G_MISS_CHAR,
427 qualifier_attribute95 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE95%TYPE := OKC_API.G_MISS_CHAR,
428 qualifier_attribute96 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE96%TYPE := OKC_API.G_MISS_CHAR,
429 qualifier_attribute97 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE97%TYPE := OKC_API.G_MISS_CHAR,
430 qualifier_attribute98 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE98%TYPE := OKC_API.G_MISS_CHAR,
431 qualifier_attribute99 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE99%TYPE := OKC_API.G_MISS_CHAR,
432 qualifier_attribute100 OKC_PRICE_ATT_VALUES_V.QUALIFIER_ATTRIBUTE100%TYPE := OKC_API.G_MISS_CHAR,
433 created_by NUMBER := OKC_API.G_MISS_NUM,
434 creation_date OKC_PRICE_ATT_VALUES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
435 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
436 last_update_date OKC_PRICE_ATT_VALUES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
437 last_update_login NUMBER := OKC_API.G_MISS_NUM,
438 program_application_id NUMBER := OKC_API.G_MISS_NUM,
439 program_id NUMBER := OKC_API.G_MISS_NUM,
440 program_update_date OKC_PRICE_ATT_VALUES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
441 request_id NUMBER := OKC_API.G_MISS_NUM,
442 object_version_number NUMBER := OKC_API.G_MISS_NUM);
443 g_miss_pavv_rec pavv_rec_type;
444 TYPE pavv_tbl_type IS TABLE OF pavv_rec_type
445 INDEX BY BINARY_INTEGER;
446 ---------------------------------------------------------------------------
447 -- GLOBAL MESSAGE CONSTANTS
448 ---------------------------------------------------------------------------
449 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
450 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
451 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
452 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
453 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
454 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
455 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
456 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
457 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
458 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
459 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
460 G_FOREIGN_KEY_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_FK_ERROR';
461 G_UNIQUE_KEY_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNIQUE_KEY_ERROR';
462 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
463 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
464 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UPPERCASE_REQD';
465
466 ---------------------------------------------------------------------------
467 -- GLOBAL EXCEPTION
468 ---------------------------------------------------------------------------
469 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
470 ---------------------------------------------------------------------------
471 -- GLOBAL VARIABLES
472 ---------------------------------------------------------------------------
473 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_PAV_PVT';
474 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
475 ---------------------------------------------------------------------------
476 -- Procedures and Functions
477 ---------------------------------------------------------------------------
478
479 PROCEDURE qc;
480 PROCEDURE change_version;
481 PROCEDURE api_copy;
482 PROCEDURE insert_row(
483 p_api_version IN NUMBER,
484 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
485 x_return_status OUT NOCOPY VARCHAR2,
486 x_msg_count OUT NOCOPY NUMBER,
487 x_msg_data OUT NOCOPY VARCHAR2,
488 p_pavv_rec IN pavv_rec_type,
489 x_pavv_rec OUT NOCOPY pavv_rec_type);
490
491 PROCEDURE insert_row(
492 p_api_version IN NUMBER,
493 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
494 x_return_status OUT NOCOPY VARCHAR2,
495 x_msg_count OUT NOCOPY NUMBER,
496 x_msg_data OUT NOCOPY VARCHAR2,
497 p_pavv_tbl IN pavv_tbl_type,
498 x_pavv_tbl OUT NOCOPY pavv_tbl_type);
499
500 PROCEDURE lock_row(
501 p_api_version IN NUMBER,
502 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
503 x_return_status OUT NOCOPY VARCHAR2,
504 x_msg_count OUT NOCOPY NUMBER,
505 x_msg_data OUT NOCOPY VARCHAR2,
506 p_pavv_rec IN pavv_rec_type);
507
508 PROCEDURE lock_row(
509 p_api_version IN NUMBER,
510 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
511 x_return_status OUT NOCOPY VARCHAR2,
512 x_msg_count OUT NOCOPY NUMBER,
513 x_msg_data OUT NOCOPY VARCHAR2,
514 p_pavv_tbl IN pavv_tbl_type);
515
516 PROCEDURE update_row(
517 p_api_version IN NUMBER,
518 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
519 x_return_status OUT NOCOPY VARCHAR2,
520 x_msg_count OUT NOCOPY NUMBER,
521 x_msg_data OUT NOCOPY VARCHAR2,
522 p_pavv_rec IN pavv_rec_type,
523 x_pavv_rec OUT NOCOPY pavv_rec_type);
524
525 PROCEDURE update_row(
526 p_api_version IN NUMBER,
527 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
528 x_return_status OUT NOCOPY VARCHAR2,
529 x_msg_count OUT NOCOPY NUMBER,
530 x_msg_data OUT NOCOPY VARCHAR2,
531 p_pavv_tbl IN pavv_tbl_type,
532 x_pavv_tbl OUT NOCOPY pavv_tbl_type);
533
534 PROCEDURE delete_row(
535 p_api_version IN NUMBER,
536 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
537 x_return_status OUT NOCOPY VARCHAR2,
538 x_msg_count OUT NOCOPY NUMBER,
539 x_msg_data OUT NOCOPY VARCHAR2,
540 p_pavv_rec IN pavv_rec_type);
541
542 PROCEDURE delete_row(
543 p_api_version IN NUMBER,
544 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
545 x_return_status OUT NOCOPY VARCHAR2,
546 x_msg_count OUT NOCOPY NUMBER,
547 x_msg_data OUT NOCOPY VARCHAR2,
548 p_pavv_tbl IN pavv_tbl_type);
549
550 PROCEDURE validate_row(
551 p_api_version IN NUMBER,
552 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
553 x_return_status OUT NOCOPY VARCHAR2,
554 x_msg_count OUT NOCOPY NUMBER,
555 x_msg_data OUT NOCOPY VARCHAR2,
556 p_pavv_rec IN pavv_rec_type);
557
558 PROCEDURE validate_row(
559 p_api_version IN NUMBER,
560 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
561 x_return_status OUT NOCOPY VARCHAR2,
562 x_msg_count OUT NOCOPY NUMBER,
563 x_msg_data OUT NOCOPY VARCHAR2,
564 p_pavv_tbl IN pavv_tbl_type);
565
566 PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,p_pavv_tbl pavv_tbl_type);
567
568 FUNCTION create_version(
569 p_chr_id IN NUMBER,
570 p_major_version IN NUMBER) RETURN VARCHAR2;
571
572 FUNCTION restore_version(
573 p_chr_id IN NUMBER,
574 p_major_version IN NUMBER) RETURN VARCHAR2;
575
576
577
578 END OKC_PAV_PVT;