1: PACKAGE BODY QP_Limit_Balances_Util AS
2: /* $Header: QPXULMBB.pls 120.1 2005/06/10 02:17:54 appldev $ */
3:
4: -- Global constant holding the package name
5:
2: /* $Header: QPXULMBB.pls 120.1 2005/06/10 02:17:54 appldev $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Limit_Balances_Util';
7:
8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr
31:
32: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute1,p_old_LIMIT_BALANCES_rec.attribute1)
33: THEN
34: l_index := l_index + 1;
35: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE1;
36: END IF;
37:
38: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute10,p_old_LIMIT_BALANCES_rec.attribute10)
39: THEN
37:
38: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute10,p_old_LIMIT_BALANCES_rec.attribute10)
39: THEN
40: l_index := l_index + 1;
41: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE10;
42: END IF;
43:
44: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute11,p_old_LIMIT_BALANCES_rec.attribute11)
45: THEN
43:
44: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute11,p_old_LIMIT_BALANCES_rec.attribute11)
45: THEN
46: l_index := l_index + 1;
47: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE11;
48: END IF;
49:
50: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute12,p_old_LIMIT_BALANCES_rec.attribute12)
51: THEN
49:
50: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute12,p_old_LIMIT_BALANCES_rec.attribute12)
51: THEN
52: l_index := l_index + 1;
53: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE12;
54: END IF;
55:
56: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute13,p_old_LIMIT_BALANCES_rec.attribute13)
57: THEN
55:
56: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute13,p_old_LIMIT_BALANCES_rec.attribute13)
57: THEN
58: l_index := l_index + 1;
59: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE13;
60: END IF;
61:
62: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute14,p_old_LIMIT_BALANCES_rec.attribute14)
63: THEN
61:
62: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute14,p_old_LIMIT_BALANCES_rec.attribute14)
63: THEN
64: l_index := l_index + 1;
65: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE14;
66: END IF;
67:
68: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute15,p_old_LIMIT_BALANCES_rec.attribute15)
69: THEN
67:
68: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute15,p_old_LIMIT_BALANCES_rec.attribute15)
69: THEN
70: l_index := l_index + 1;
71: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE15;
72: END IF;
73:
74: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute2,p_old_LIMIT_BALANCES_rec.attribute2)
75: THEN
73:
74: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute2,p_old_LIMIT_BALANCES_rec.attribute2)
75: THEN
76: l_index := l_index + 1;
77: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE2;
78: END IF;
79:
80: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute3,p_old_LIMIT_BALANCES_rec.attribute3)
81: THEN
79:
80: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute3,p_old_LIMIT_BALANCES_rec.attribute3)
81: THEN
82: l_index := l_index + 1;
83: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE3;
84: END IF;
85:
86: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute4,p_old_LIMIT_BALANCES_rec.attribute4)
87: THEN
85:
86: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute4,p_old_LIMIT_BALANCES_rec.attribute4)
87: THEN
88: l_index := l_index + 1;
89: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE4;
90: END IF;
91:
92: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute5,p_old_LIMIT_BALANCES_rec.attribute5)
93: THEN
91:
92: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute5,p_old_LIMIT_BALANCES_rec.attribute5)
93: THEN
94: l_index := l_index + 1;
95: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE5;
96: END IF;
97:
98: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute6,p_old_LIMIT_BALANCES_rec.attribute6)
99: THEN
97:
98: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute6,p_old_LIMIT_BALANCES_rec.attribute6)
99: THEN
100: l_index := l_index + 1;
101: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE6;
102: END IF;
103:
104: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute7,p_old_LIMIT_BALANCES_rec.attribute7)
105: THEN
103:
104: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute7,p_old_LIMIT_BALANCES_rec.attribute7)
105: THEN
106: l_index := l_index + 1;
107: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE7;
108: END IF;
109:
110: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute8,p_old_LIMIT_BALANCES_rec.attribute8)
111: THEN
109:
110: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute8,p_old_LIMIT_BALANCES_rec.attribute8)
111: THEN
112: l_index := l_index + 1;
113: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE8;
114: END IF;
115:
116: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute9,p_old_LIMIT_BALANCES_rec.attribute9)
117: THEN
115:
116: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute9,p_old_LIMIT_BALANCES_rec.attribute9)
117: THEN
118: l_index := l_index + 1;
119: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE9;
120: END IF;
121:
122: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.available_amount,p_old_LIMIT_BALANCES_rec.available_amount)
123: THEN
121:
122: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.available_amount,p_old_LIMIT_BALANCES_rec.available_amount)
123: THEN
124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_AVAILABLE_AMOUNT;
126: END IF;
127:
128: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.consumed_amount,p_old_LIMIT_BALANCES_rec.consumed_amount)
129: THEN
127:
128: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.consumed_amount,p_old_LIMIT_BALANCES_rec.consumed_amount)
129: THEN
130: l_index := l_index + 1;
131: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CONSUMED_AMOUNT;
132: END IF;
133:
134: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.context,p_old_LIMIT_BALANCES_rec.context)
135: THEN
133:
134: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.context,p_old_LIMIT_BALANCES_rec.context)
135: THEN
136: l_index := l_index + 1;
137: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CONTEXT;
138: END IF;
139:
140: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.created_by,p_old_LIMIT_BALANCES_rec.created_by)
141: THEN
139:
140: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.created_by,p_old_LIMIT_BALANCES_rec.created_by)
141: THEN
142: l_index := l_index + 1;
143: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CREATED_BY;
144: END IF;
145:
146: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.creation_date,p_old_LIMIT_BALANCES_rec.creation_date)
147: THEN
145:
146: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.creation_date,p_old_LIMIT_BALANCES_rec.creation_date)
147: THEN
148: l_index := l_index + 1;
149: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CREATION_DATE;
150: END IF;
151:
152: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_updated_by,p_old_LIMIT_BALANCES_rec.last_updated_by)
153: THEN
151:
152: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_updated_by,p_old_LIMIT_BALANCES_rec.last_updated_by)
153: THEN
154: l_index := l_index + 1;
155: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATED_BY;
156: END IF;
157:
158: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_update_date,p_old_LIMIT_BALANCES_rec.last_update_date)
159: THEN
157:
158: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_update_date,p_old_LIMIT_BALANCES_rec.last_update_date)
159: THEN
160: l_index := l_index + 1;
161: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATE_DATE;
162: END IF;
163:
164: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_update_login,p_old_LIMIT_BALANCES_rec.last_update_login)
165: THEN
163:
164: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_update_login,p_old_LIMIT_BALANCES_rec.last_update_login)
165: THEN
166: l_index := l_index + 1;
167: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATE_LOGIN;
168: END IF;
169:
170: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.limit_balance_id,p_old_LIMIT_BALANCES_rec.limit_balance_id)
171: THEN
169:
170: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.limit_balance_id,p_old_LIMIT_BALANCES_rec.limit_balance_id)
171: THEN
172: l_index := l_index + 1;
173: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LIMIT_BALANCE;
174: END IF;
175:
176: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.limit_id,p_old_LIMIT_BALANCES_rec.limit_id)
177: THEN
175:
176: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.limit_id,p_old_LIMIT_BALANCES_rec.limit_id)
177: THEN
178: l_index := l_index + 1;
179: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LIMIT;
180: END IF;
181:
182: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_application_id,p_old_LIMIT_BALANCES_rec.program_application_id)
183: THEN
181:
182: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_application_id,p_old_LIMIT_BALANCES_rec.program_application_id)
183: THEN
184: l_index := l_index + 1;
185: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM_APPLICATION;
186: END IF;
187:
188: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_id,p_old_LIMIT_BALANCES_rec.program_id)
189: THEN
187:
188: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_id,p_old_LIMIT_BALANCES_rec.program_id)
189: THEN
190: l_index := l_index + 1;
191: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM;
192: END IF;
193:
194: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_update_date,p_old_LIMIT_BALANCES_rec.program_update_date)
195: THEN
193:
194: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_update_date,p_old_LIMIT_BALANCES_rec.program_update_date)
195: THEN
196: l_index := l_index + 1;
197: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM_UPDATE_DATE;
198: END IF;
199:
200: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.request_id,p_old_LIMIT_BALANCES_rec.request_id)
201: THEN
199:
200: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.request_id,p_old_LIMIT_BALANCES_rec.request_id)
201: THEN
202: l_index := l_index + 1;
203: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_REQUEST;
204: END IF;
205:
206: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.reserved_amount,p_old_LIMIT_BALANCES_rec.reserved_amount)
207: THEN
205:
206: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.reserved_amount,p_old_LIMIT_BALANCES_rec.reserved_amount)
207: THEN
208: l_index := l_index + 1;
209: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_RESERVED_AMOUNT;
210: END IF;
211:
212: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_type,p_old_LIMIT_BALANCES_rec.multival_attr1_type)
213: THEN
211:
212: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_type,p_old_LIMIT_BALANCES_rec.multival_attr1_type)
213: THEN
214: l_index := l_index + 1;
215: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_TYPE;
216: END IF;
217:
218: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_context,p_old_LIMIT_BALANCES_rec.multival_attr1_context)
219: THEN
217:
218: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_context,p_old_LIMIT_BALANCES_rec.multival_attr1_context)
219: THEN
220: l_index := l_index + 1;
221: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_CONTEXT;
222: END IF;
223:
224: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attribute1,p_old_LIMIT_BALANCES_rec.multival_attribute1)
225: THEN
223:
224: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attribute1,p_old_LIMIT_BALANCES_rec.multival_attribute1)
225: THEN
226: l_index := l_index + 1;
227: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTRIBUTE1;
228: END IF;
229:
230: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_value,p_old_LIMIT_BALANCES_rec.multival_attr1_value)
231: THEN
229:
230: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_value,p_old_LIMIT_BALANCES_rec.multival_attr1_value)
231: THEN
232: l_index := l_index + 1;
233: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_VALUE;
234: END IF;
235:
236: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_datatype,p_old_LIMIT_BALANCES_rec.multival_attr1_datatype)
237: THEN
235:
236: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_datatype,p_old_LIMIT_BALANCES_rec.multival_attr1_datatype)
237: THEN
238: l_index := l_index + 1;
239: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_DATATYPE;
240: END IF;
241:
242: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_type,p_old_LIMIT_BALANCES_rec.multival_attr2_type)
243: THEN
241:
242: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_type,p_old_LIMIT_BALANCES_rec.multival_attr2_type)
243: THEN
244: l_index := l_index + 1;
245: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_TYPE;
246: END IF;
247:
248: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_context,p_old_LIMIT_BALANCES_rec.multival_attr2_context)
249: THEN
247:
248: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_context,p_old_LIMIT_BALANCES_rec.multival_attr2_context)
249: THEN
250: l_index := l_index + 1;
251: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_CONTEXT;
252: END IF;
253:
254: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attribute2,p_old_LIMIT_BALANCES_rec.multival_attribute2)
255: THEN
253:
254: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attribute2,p_old_LIMIT_BALANCES_rec.multival_attribute2)
255: THEN
256: l_index := l_index + 1;
257: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTRIBUTE2;
258: END IF;
259:
260: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_value,p_old_LIMIT_BALANCES_rec.multival_attr2_value)
261: THEN
259:
260: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_value,p_old_LIMIT_BALANCES_rec.multival_attr2_value)
261: THEN
262: l_index := l_index + 1;
263: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_VALUE;
264: END IF;
265:
266: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_datatype,p_old_LIMIT_BALANCES_rec.multival_attr2_datatype)
267: THEN
265:
266: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_datatype,p_old_LIMIT_BALANCES_rec.multival_attr2_datatype)
267: THEN
268: l_index := l_index + 1;
269: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_DATATYPE;
270: END IF;
271:
272: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attr_context,p_old_LIMIT_BALANCES_rec.organization_attr_context)
273: THEN
271:
272: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attr_context,p_old_LIMIT_BALANCES_rec.organization_attr_context)
273: THEN
274: l_index := l_index + 1;
275: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ORGANIZATION_ATTR_CONTEXT;
276: END IF;
277:
278: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attribute,p_old_LIMIT_BALANCES_rec.organization_attribute)
279: THEN
277:
278: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attribute,p_old_LIMIT_BALANCES_rec.organization_attribute)
279: THEN
280: l_index := l_index + 1;
281: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ORGANIZATION_ATTRIBUTE;
282: END IF;
283:
284: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attr_value,p_old_LIMIT_BALANCES_rec.organization_attr_value)
285: THEN
283:
284: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attr_value,p_old_LIMIT_BALANCES_rec.organization_attr_value)
285: THEN
286: l_index := l_index + 1;
287: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ORGANIZATION_ATTR_VALUE;
288: END IF;
289:
290: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
291: l_index := l_index + 1;
288: END IF;
289:
290: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
291: l_index := l_index + 1;
292: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE1;
293: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
294: l_index := l_index + 1;
295: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE10;
296: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
291: l_index := l_index + 1;
292: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE1;
293: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
294: l_index := l_index + 1;
295: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE10;
296: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
297: l_index := l_index + 1;
298: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE11;
299: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
294: l_index := l_index + 1;
295: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE10;
296: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
297: l_index := l_index + 1;
298: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE11;
299: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
300: l_index := l_index + 1;
301: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE12;
302: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
297: l_index := l_index + 1;
298: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE11;
299: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
300: l_index := l_index + 1;
301: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE12;
302: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
303: l_index := l_index + 1;
304: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE13;
305: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
300: l_index := l_index + 1;
301: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE12;
302: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
303: l_index := l_index + 1;
304: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE13;
305: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
306: l_index := l_index + 1;
307: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE14;
308: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
303: l_index := l_index + 1;
304: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE13;
305: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
306: l_index := l_index + 1;
307: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE14;
308: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
309: l_index := l_index + 1;
310: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE15;
311: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
306: l_index := l_index + 1;
307: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE14;
308: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
309: l_index := l_index + 1;
310: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE15;
311: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
312: l_index := l_index + 1;
313: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE2;
314: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
309: l_index := l_index + 1;
310: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE15;
311: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
312: l_index := l_index + 1;
313: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE2;
314: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
315: l_index := l_index + 1;
316: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE3;
317: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
312: l_index := l_index + 1;
313: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE2;
314: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
315: l_index := l_index + 1;
316: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE3;
317: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
318: l_index := l_index + 1;
319: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE4;
320: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
315: l_index := l_index + 1;
316: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE3;
317: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
318: l_index := l_index + 1;
319: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE4;
320: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
321: l_index := l_index + 1;
322: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE5;
323: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
318: l_index := l_index + 1;
319: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE4;
320: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
321: l_index := l_index + 1;
322: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE5;
323: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
324: l_index := l_index + 1;
325: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE6;
326: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
321: l_index := l_index + 1;
322: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE5;
323: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
324: l_index := l_index + 1;
325: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE6;
326: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
327: l_index := l_index + 1;
328: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE7;
329: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
324: l_index := l_index + 1;
325: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE6;
326: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
327: l_index := l_index + 1;
328: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE7;
329: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
330: l_index := l_index + 1;
331: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE8;
332: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
327: l_index := l_index + 1;
328: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE7;
329: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
330: l_index := l_index + 1;
331: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE8;
332: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
333: l_index := l_index + 1;
334: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE9;
335: ELSIF p_attr_id = G_AVAILABLE_AMOUNT THEN
330: l_index := l_index + 1;
331: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE8;
332: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
333: l_index := l_index + 1;
334: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE9;
335: ELSIF p_attr_id = G_AVAILABLE_AMOUNT THEN
336: l_index := l_index + 1;
337: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_AVAILABLE_AMOUNT;
338: ELSIF p_attr_id = G_CONSUMED_AMOUNT THEN
333: l_index := l_index + 1;
334: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE9;
335: ELSIF p_attr_id = G_AVAILABLE_AMOUNT THEN
336: l_index := l_index + 1;
337: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_AVAILABLE_AMOUNT;
338: ELSIF p_attr_id = G_CONSUMED_AMOUNT THEN
339: l_index := l_index + 1;
340: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CONSUMED_AMOUNT;
341: ELSIF p_attr_id = G_CONTEXT THEN
336: l_index := l_index + 1;
337: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_AVAILABLE_AMOUNT;
338: ELSIF p_attr_id = G_CONSUMED_AMOUNT THEN
339: l_index := l_index + 1;
340: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CONSUMED_AMOUNT;
341: ELSIF p_attr_id = G_CONTEXT THEN
342: l_index := l_index + 1;
343: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CONTEXT;
344: ELSIF p_attr_id = G_CREATED_BY THEN
339: l_index := l_index + 1;
340: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CONSUMED_AMOUNT;
341: ELSIF p_attr_id = G_CONTEXT THEN
342: l_index := l_index + 1;
343: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CONTEXT;
344: ELSIF p_attr_id = G_CREATED_BY THEN
345: l_index := l_index + 1;
346: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CREATED_BY;
347: ELSIF p_attr_id = G_CREATION_DATE THEN
342: l_index := l_index + 1;
343: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CONTEXT;
344: ELSIF p_attr_id = G_CREATED_BY THEN
345: l_index := l_index + 1;
346: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CREATED_BY;
347: ELSIF p_attr_id = G_CREATION_DATE THEN
348: l_index := l_index + 1;
349: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CREATION_DATE;
350: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
345: l_index := l_index + 1;
346: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CREATED_BY;
347: ELSIF p_attr_id = G_CREATION_DATE THEN
348: l_index := l_index + 1;
349: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CREATION_DATE;
350: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
351: l_index := l_index + 1;
352: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATED_BY;
353: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
348: l_index := l_index + 1;
349: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CREATION_DATE;
350: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
351: l_index := l_index + 1;
352: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATED_BY;
353: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
354: l_index := l_index + 1;
355: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATE_DATE;
356: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
351: l_index := l_index + 1;
352: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATED_BY;
353: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
354: l_index := l_index + 1;
355: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATE_DATE;
356: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
357: l_index := l_index + 1;
358: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATE_LOGIN;
359: ELSIF p_attr_id = G_LIMIT_BALANCE THEN
354: l_index := l_index + 1;
355: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATE_DATE;
356: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
357: l_index := l_index + 1;
358: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATE_LOGIN;
359: ELSIF p_attr_id = G_LIMIT_BALANCE THEN
360: l_index := l_index + 1;
361: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LIMIT_BALANCE;
362: ELSIF p_attr_id = G_LIMIT THEN
357: l_index := l_index + 1;
358: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATE_LOGIN;
359: ELSIF p_attr_id = G_LIMIT_BALANCE THEN
360: l_index := l_index + 1;
361: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LIMIT_BALANCE;
362: ELSIF p_attr_id = G_LIMIT THEN
363: l_index := l_index + 1;
364: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LIMIT;
365: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
360: l_index := l_index + 1;
361: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LIMIT_BALANCE;
362: ELSIF p_attr_id = G_LIMIT THEN
363: l_index := l_index + 1;
364: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LIMIT;
365: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
366: l_index := l_index + 1;
367: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM_APPLICATION;
368: ELSIF p_attr_id = G_PROGRAM THEN
363: l_index := l_index + 1;
364: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LIMIT;
365: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
366: l_index := l_index + 1;
367: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM_APPLICATION;
368: ELSIF p_attr_id = G_PROGRAM THEN
369: l_index := l_index + 1;
370: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM;
371: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
366: l_index := l_index + 1;
367: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM_APPLICATION;
368: ELSIF p_attr_id = G_PROGRAM THEN
369: l_index := l_index + 1;
370: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM;
371: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
372: l_index := l_index + 1;
373: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM_UPDATE_DATE;
374: ELSIF p_attr_id = G_REQUEST THEN
369: l_index := l_index + 1;
370: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM;
371: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
372: l_index := l_index + 1;
373: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM_UPDATE_DATE;
374: ELSIF p_attr_id = G_REQUEST THEN
375: l_index := l_index + 1;
376: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_REQUEST;
377: ELSIF p_attr_id = G_RESERVED_AMOUNT THEN
372: l_index := l_index + 1;
373: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM_UPDATE_DATE;
374: ELSIF p_attr_id = G_REQUEST THEN
375: l_index := l_index + 1;
376: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_REQUEST;
377: ELSIF p_attr_id = G_RESERVED_AMOUNT THEN
378: l_index := l_index + 1;
379: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_RESERVED_AMOUNT;
380: ELSIF p_attr_id = G_MULTIVAL_ATTR1_TYPE THEN
375: l_index := l_index + 1;
376: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_REQUEST;
377: ELSIF p_attr_id = G_RESERVED_AMOUNT THEN
378: l_index := l_index + 1;
379: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_RESERVED_AMOUNT;
380: ELSIF p_attr_id = G_MULTIVAL_ATTR1_TYPE THEN
381: l_index := l_index + 1;
382: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_TYPE;
383: ELSIF p_attr_id = G_MULTIVAL_ATTR1_CONTEXT THEN
378: l_index := l_index + 1;
379: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_RESERVED_AMOUNT;
380: ELSIF p_attr_id = G_MULTIVAL_ATTR1_TYPE THEN
381: l_index := l_index + 1;
382: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_TYPE;
383: ELSIF p_attr_id = G_MULTIVAL_ATTR1_CONTEXT THEN
384: l_index := l_index + 1;
385: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_CONTEXT;
386: ELSIF p_attr_id = G_MULTIVAL_ATTRIBUTE1 THEN
381: l_index := l_index + 1;
382: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_TYPE;
383: ELSIF p_attr_id = G_MULTIVAL_ATTR1_CONTEXT THEN
384: l_index := l_index + 1;
385: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_CONTEXT;
386: ELSIF p_attr_id = G_MULTIVAL_ATTRIBUTE1 THEN
387: l_index := l_index + 1;
388: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTRIBUTE1;
389: ELSIF p_attr_id = G_MULTIVAL_ATTR1_VALUE THEN
384: l_index := l_index + 1;
385: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_CONTEXT;
386: ELSIF p_attr_id = G_MULTIVAL_ATTRIBUTE1 THEN
387: l_index := l_index + 1;
388: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTRIBUTE1;
389: ELSIF p_attr_id = G_MULTIVAL_ATTR1_VALUE THEN
390: l_index := l_index + 1;
391: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_VALUE;
392: ELSIF p_attr_id = G_MULTIVAL_ATTR1_DATATYPE THEN
387: l_index := l_index + 1;
388: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTRIBUTE1;
389: ELSIF p_attr_id = G_MULTIVAL_ATTR1_VALUE THEN
390: l_index := l_index + 1;
391: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_VALUE;
392: ELSIF p_attr_id = G_MULTIVAL_ATTR1_DATATYPE THEN
393: l_index := l_index + 1;
394: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_DATATYPE;
395: ELSIF p_attr_id = G_MULTIVAL_ATTR2_TYPE THEN
390: l_index := l_index + 1;
391: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_VALUE;
392: ELSIF p_attr_id = G_MULTIVAL_ATTR1_DATATYPE THEN
393: l_index := l_index + 1;
394: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_DATATYPE;
395: ELSIF p_attr_id = G_MULTIVAL_ATTR2_TYPE THEN
396: l_index := l_index + 1;
397: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_TYPE;
398: ELSIF p_attr_id = G_MULTIVAL_ATTR2_CONTEXT THEN
393: l_index := l_index + 1;
394: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_DATATYPE;
395: ELSIF p_attr_id = G_MULTIVAL_ATTR2_TYPE THEN
396: l_index := l_index + 1;
397: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_TYPE;
398: ELSIF p_attr_id = G_MULTIVAL_ATTR2_CONTEXT THEN
399: l_index := l_index + 1;
400: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_CONTEXT;
401: ELSIF p_attr_id = G_MULTIVAL_ATTRIBUTE2 THEN
396: l_index := l_index + 1;
397: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_TYPE;
398: ELSIF p_attr_id = G_MULTIVAL_ATTR2_CONTEXT THEN
399: l_index := l_index + 1;
400: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_CONTEXT;
401: ELSIF p_attr_id = G_MULTIVAL_ATTRIBUTE2 THEN
402: l_index := l_index + 1;
403: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTRIBUTE2;
404: ELSIF p_attr_id = G_MULTIVAL_ATTR2_VALUE THEN
399: l_index := l_index + 1;
400: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_CONTEXT;
401: ELSIF p_attr_id = G_MULTIVAL_ATTRIBUTE2 THEN
402: l_index := l_index + 1;
403: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTRIBUTE2;
404: ELSIF p_attr_id = G_MULTIVAL_ATTR2_VALUE THEN
405: l_index := l_index + 1;
406: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_VALUE;
407: ELSIF p_attr_id = G_MULTIVAL_ATTR2_DATATYPE THEN
402: l_index := l_index + 1;
403: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTRIBUTE2;
404: ELSIF p_attr_id = G_MULTIVAL_ATTR2_VALUE THEN
405: l_index := l_index + 1;
406: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_VALUE;
407: ELSIF p_attr_id = G_MULTIVAL_ATTR2_DATATYPE THEN
408: l_index := l_index + 1;
409: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_DATATYPE;
410: ELSIF p_attr_id = G_ORGANIZATION_ATTR_CONTEXT THEN
405: l_index := l_index + 1;
406: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_VALUE;
407: ELSIF p_attr_id = G_MULTIVAL_ATTR2_DATATYPE THEN
408: l_index := l_index + 1;
409: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_DATATYPE;
410: ELSIF p_attr_id = G_ORGANIZATION_ATTR_CONTEXT THEN
411: l_index := l_index + 1;
412: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ORGANIZATION_ATTR_CONTEXT;
413: ELSIF p_attr_id = G_ORGANIZATION_ATTRIBUTE THEN
408: l_index := l_index + 1;
409: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_DATATYPE;
410: ELSIF p_attr_id = G_ORGANIZATION_ATTR_CONTEXT THEN
411: l_index := l_index + 1;
412: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ORGANIZATION_ATTR_CONTEXT;
413: ELSIF p_attr_id = G_ORGANIZATION_ATTRIBUTE THEN
414: l_index := l_index + 1;
415: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ORGANIZATION_ATTRIBUTE;
416: ELSIF p_attr_id = G_ORGANIZATION_ATTR_VALUE THEN
411: l_index := l_index + 1;
412: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ORGANIZATION_ATTR_CONTEXT;
413: ELSIF p_attr_id = G_ORGANIZATION_ATTRIBUTE THEN
414: l_index := l_index + 1;
415: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ORGANIZATION_ATTRIBUTE;
416: ELSIF p_attr_id = G_ORGANIZATION_ATTR_VALUE THEN
417: l_index := l_index + 1;
418: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ORGANIZATION_ATTR_VALUE;
419: END IF;
414: l_index := l_index + 1;
415: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ORGANIZATION_ATTRIBUTE;
416: ELSIF p_attr_id = G_ORGANIZATION_ATTR_VALUE THEN
417: l_index := l_index + 1;
418: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ORGANIZATION_ATTR_VALUE;
419: END IF;
420:
421: END Clear_Dependent_Attr;
422:
1039: WHERE a.limit_id=p_LIMIT_BALANCES_rec.limit_id
1040: AND b.list_header_id=a.list_header_id;
1041:
1042:
1043: UPDATE QP_LIMIT_BALANCES
1044: SET ATTRIBUTE1 = p_LIMIT_BALANCES_rec.attribute1
1045: , ATTRIBUTE10 = p_LIMIT_BALANCES_rec.attribute10
1046: , ATTRIBUTE11 = p_LIMIT_BALANCES_rec.attribute11
1047: , ATTRIBUTE12 = p_LIMIT_BALANCES_rec.attribute12
1149: FROM QP_LIMITS a,QP_LIST_HEADERS_B b
1150: WHERE a.limit_id=p_LIMIT_BALANCES_rec.limit_id
1151: AND b.list_header_id=a.list_header_id;
1152:
1153: INSERT INTO QP_LIMIT_BALANCES
1154: ( ATTRIBUTE1
1155: , ATTRIBUTE10
1156: , ATTRIBUTE11
1157: , ATTRIBUTE12
1293: )
1294: IS
1295: BEGIN
1296:
1297: DELETE FROM QP_LIMIT_BALANCES
1298: WHERE LIMIT_BALANCE_ID = p_limit_balance_id
1299: ;
1300:
1301:
1387: , MULTIVAL_ATTR2_DATATYPE
1388: , ORGANIZATION_ATTR_CONTEXT
1389: , ORGANIZATION_ATTRIBUTE
1390: , ORGANIZATION_ATTR_VALUE
1391: FROM QP_LIMIT_BALANCES
1392: WHERE ( LIMIT_BALANCE_ID = p_limit_balance_id
1393: )
1394: OR ( LIMIT_ID = p_limit_id
1395: );
1606: , l_LIMIT_BALANCES_rec.multival_attr2_datatype
1607: , l_LIMIT_BALANCES_rec.organization_attr_context
1608: , l_LIMIT_BALANCES_rec.organization_attribute
1609: , l_LIMIT_BALANCES_rec.organization_attr_value
1610: FROM QP_LIMIT_BALANCES
1611: WHERE LIMIT_BALANCE_ID = p_LIMIT_BALANCES_rec.limit_balance_id
1612: FOR UPDATE NOWAIT;
1613:
1614: -- Row locked. Compare IN attributes to DB attributes.
1885: RETURN l_LIMIT_BALANCES_rec;
1886:
1887: END Get_Ids;
1888:
1889: END QP_Limit_Balances_Util;