15: , x_LIMIT_BALANCES_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;
19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
20: l_dep_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
21: BEGIN
22:
23: -- Load out record
16: )
17: IS
18: l_index NUMBER := 0;
19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
20: l_dep_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
21: BEGIN
22:
23: -- Load out record
24:
28: -- every changed attribute clear its dependent fields.
29:
30: IF p_attr_id = FND_API.G_MISS_NUM THEN
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;
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
40: l_index := l_index + 1;
41: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE10;
42: END IF;
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
46: l_index := l_index + 1;
47: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE11;
48: END IF;
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
52: l_index := l_index + 1;
53: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE12;
54: END IF;
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
58: l_index := l_index + 1;
59: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE13;
60: END IF;
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
64: l_index := l_index + 1;
65: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE14;
66: END IF;
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
70: l_index := l_index + 1;
71: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE15;
72: END IF;
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
76: l_index := l_index + 1;
77: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE2;
78: END IF;
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
82: l_index := l_index + 1;
83: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE3;
84: END IF;
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
88: l_index := l_index + 1;
89: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE4;
90: END IF;
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
94: l_index := l_index + 1;
95: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE5;
96: END IF;
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
100: l_index := l_index + 1;
101: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE6;
102: END IF;
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
106: l_index := l_index + 1;
107: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE7;
108: END IF;
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
112: l_index := l_index + 1;
113: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE8;
114: END IF;
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
118: l_index := l_index + 1;
119: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE9;
120: END IF;
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
124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_AVAILABLE_AMOUNT;
126: END IF;
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
130: l_index := l_index + 1;
131: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CONSUMED_AMOUNT;
132: END IF;
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
136: l_index := l_index + 1;
137: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CONTEXT;
138: END IF;
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
142: l_index := l_index + 1;
143: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CREATED_BY;
144: END IF;
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
148: l_index := l_index + 1;
149: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CREATION_DATE;
150: END IF;
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
154: l_index := l_index + 1;
155: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATED_BY;
156: END IF;
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
160: l_index := l_index + 1;
161: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATE_DATE;
162: END IF;
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
166: l_index := l_index + 1;
167: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATE_LOGIN;
168: END IF;
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
172: l_index := l_index + 1;
173: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LIMIT_BALANCE;
174: END IF;
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
178: l_index := l_index + 1;
179: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LIMIT;
180: END IF;
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
184: l_index := l_index + 1;
185: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM_APPLICATION;
186: END IF;
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
190: l_index := l_index + 1;
191: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM;
192: END IF;
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
196: l_index := l_index + 1;
197: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM_UPDATE_DATE;
198: END IF;
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
202: l_index := l_index + 1;
203: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_REQUEST;
204: END IF;
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
208: l_index := l_index + 1;
209: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_RESERVED_AMOUNT;
210: END IF;
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
214: l_index := l_index + 1;
215: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_TYPE;
216: END IF;
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
220: l_index := l_index + 1;
221: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_CONTEXT;
222: END IF;
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
226: l_index := l_index + 1;
227: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTRIBUTE1;
228: END IF;
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
232: l_index := l_index + 1;
233: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_VALUE;
234: END IF;
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
238: l_index := l_index + 1;
239: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_DATATYPE;
240: END IF;
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
244: l_index := l_index + 1;
245: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_TYPE;
246: END IF;
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
250: l_index := l_index + 1;
251: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_CONTEXT;
252: END IF;
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
256: l_index := l_index + 1;
257: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTRIBUTE2;
258: END IF;
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
262: l_index := l_index + 1;
263: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_VALUE;
264: END IF;
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
268: l_index := l_index + 1;
269: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_DATATYPE;
270: END IF;
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
274: l_index := l_index + 1;
275: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ORGANIZATION_ATTR_CONTEXT;
276: END IF;
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
280: l_index := l_index + 1;
281: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ORGANIZATION_ATTRIBUTE;
282: END IF;
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
286: l_index := l_index + 1;
287: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ORGANIZATION_ATTR_VALUE;
288: END IF;
434: -- Load out record
435:
436: x_LIMIT_BALANCES_rec := p_LIMIT_BALANCES_rec;
437:
438: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute1,p_old_LIMIT_BALANCES_rec.attribute1)
439: THEN
440: NULL;
441: END IF;
442:
439: THEN
440: NULL;
441: END IF;
442:
443: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute10,p_old_LIMIT_BALANCES_rec.attribute10)
444: THEN
445: NULL;
446: END IF;
447:
444: THEN
445: NULL;
446: END IF;
447:
448: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute11,p_old_LIMIT_BALANCES_rec.attribute11)
449: THEN
450: NULL;
451: END IF;
452:
449: THEN
450: NULL;
451: END IF;
452:
453: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute12,p_old_LIMIT_BALANCES_rec.attribute12)
454: THEN
455: NULL;
456: END IF;
457:
454: THEN
455: NULL;
456: END IF;
457:
458: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute13,p_old_LIMIT_BALANCES_rec.attribute13)
459: THEN
460: NULL;
461: END IF;
462:
459: THEN
460: NULL;
461: END IF;
462:
463: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute14,p_old_LIMIT_BALANCES_rec.attribute14)
464: THEN
465: NULL;
466: END IF;
467:
464: THEN
465: NULL;
466: END IF;
467:
468: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute15,p_old_LIMIT_BALANCES_rec.attribute15)
469: THEN
470: NULL;
471: END IF;
472:
469: THEN
470: NULL;
471: END IF;
472:
473: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute2,p_old_LIMIT_BALANCES_rec.attribute2)
474: THEN
475: NULL;
476: END IF;
477:
474: THEN
475: NULL;
476: END IF;
477:
478: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute3,p_old_LIMIT_BALANCES_rec.attribute3)
479: THEN
480: NULL;
481: END IF;
482:
479: THEN
480: NULL;
481: END IF;
482:
483: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute4,p_old_LIMIT_BALANCES_rec.attribute4)
484: THEN
485: NULL;
486: END IF;
487:
484: THEN
485: NULL;
486: END IF;
487:
488: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute5,p_old_LIMIT_BALANCES_rec.attribute5)
489: THEN
490: NULL;
491: END IF;
492:
489: THEN
490: NULL;
491: END IF;
492:
493: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute6,p_old_LIMIT_BALANCES_rec.attribute6)
494: THEN
495: NULL;
496: END IF;
497:
494: THEN
495: NULL;
496: END IF;
497:
498: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute7,p_old_LIMIT_BALANCES_rec.attribute7)
499: THEN
500: NULL;
501: END IF;
502:
499: THEN
500: NULL;
501: END IF;
502:
503: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute8,p_old_LIMIT_BALANCES_rec.attribute8)
504: THEN
505: NULL;
506: END IF;
507:
504: THEN
505: NULL;
506: END IF;
507:
508: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute9,p_old_LIMIT_BALANCES_rec.attribute9)
509: THEN
510: NULL;
511: END IF;
512:
509: THEN
510: NULL;
511: END IF;
512:
513: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.available_amount,p_old_LIMIT_BALANCES_rec.available_amount)
514: THEN
515: NULL;
516: END IF;
517:
514: THEN
515: NULL;
516: END IF;
517:
518: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.consumed_amount,p_old_LIMIT_BALANCES_rec.consumed_amount)
519: THEN
520: NULL;
521: END IF;
522:
519: THEN
520: NULL;
521: END IF;
522:
523: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.context,p_old_LIMIT_BALANCES_rec.context)
524: THEN
525: NULL;
526: END IF;
527:
524: THEN
525: NULL;
526: END IF;
527:
528: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.created_by,p_old_LIMIT_BALANCES_rec.created_by)
529: THEN
530: NULL;
531: END IF;
532:
529: THEN
530: NULL;
531: END IF;
532:
533: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.creation_date,p_old_LIMIT_BALANCES_rec.creation_date)
534: THEN
535: NULL;
536: END IF;
537:
534: THEN
535: NULL;
536: END IF;
537:
538: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_updated_by,p_old_LIMIT_BALANCES_rec.last_updated_by)
539: THEN
540: NULL;
541: END IF;
542:
539: THEN
540: NULL;
541: END IF;
542:
543: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_update_date,p_old_LIMIT_BALANCES_rec.last_update_date)
544: THEN
545: NULL;
546: END IF;
547:
544: THEN
545: NULL;
546: END IF;
547:
548: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_update_login,p_old_LIMIT_BALANCES_rec.last_update_login)
549: THEN
550: NULL;
551: END IF;
552:
549: THEN
550: NULL;
551: END IF;
552:
553: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.limit_balance_id,p_old_LIMIT_BALANCES_rec.limit_balance_id)
554: THEN
555: NULL;
556: END IF;
557:
554: THEN
555: NULL;
556: END IF;
557:
558: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.limit_id,p_old_LIMIT_BALANCES_rec.limit_id)
559: THEN
560: NULL;
561: END IF;
562:
559: THEN
560: NULL;
561: END IF;
562:
563: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_application_id,p_old_LIMIT_BALANCES_rec.program_application_id)
564: THEN
565: NULL;
566: END IF;
567:
564: THEN
565: NULL;
566: END IF;
567:
568: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_id,p_old_LIMIT_BALANCES_rec.program_id)
569: THEN
570: NULL;
571: END IF;
572:
569: THEN
570: NULL;
571: END IF;
572:
573: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_update_date,p_old_LIMIT_BALANCES_rec.program_update_date)
574: THEN
575: NULL;
576: END IF;
577:
574: THEN
575: NULL;
576: END IF;
577:
578: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.request_id,p_old_LIMIT_BALANCES_rec.request_id)
579: THEN
580: NULL;
581: END IF;
582:
579: THEN
580: NULL;
581: END IF;
582:
583: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.reserved_amount,p_old_LIMIT_BALANCES_rec.reserved_amount)
584: THEN
585: NULL;
586: END IF;
587:
584: THEN
585: NULL;
586: END IF;
587:
588: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_type,p_old_LIMIT_BALANCES_rec.multival_attr1_type)
589: THEN
590: NULL;
591: END IF;
592:
589: THEN
590: NULL;
591: END IF;
592:
593: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_context,p_old_LIMIT_BALANCES_rec.multival_attr1_context)
594: THEN
595: NULL;
596: END IF;
597:
594: THEN
595: NULL;
596: END IF;
597:
598: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attribute1,p_old_LIMIT_BALANCES_rec.multival_attribute1)
599: THEN
600: NULL;
601: END IF;
602:
599: THEN
600: NULL;
601: END IF;
602:
603: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_value,p_old_LIMIT_BALANCES_rec.multival_attr1_value)
604: THEN
605: NULL;
606: END IF;
607:
604: THEN
605: NULL;
606: END IF;
607:
608: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_datatype,p_old_LIMIT_BALANCES_rec.multival_attr1_datatype)
609: THEN
610: NULL;
611: END IF;
612:
609: THEN
610: NULL;
611: END IF;
612:
613: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_type,p_old_LIMIT_BALANCES_rec.multival_attr2_type)
614: THEN
615: NULL;
616: END IF;
617:
614: THEN
615: NULL;
616: END IF;
617:
618: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_context,p_old_LIMIT_BALANCES_rec.multival_attr2_context)
619: THEN
620: NULL;
621: END IF;
622:
619: THEN
620: NULL;
621: END IF;
622:
623: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attribute2,p_old_LIMIT_BALANCES_rec.multival_attribute2)
624: THEN
625: NULL;
626: END IF;
627:
624: THEN
625: NULL;
626: END IF;
627:
628: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_value,p_old_LIMIT_BALANCES_rec.multival_attr2_value)
629: THEN
630: NULL;
631: END IF;
632:
629: THEN
630: NULL;
631: END IF;
632:
633: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_datatype,p_old_LIMIT_BALANCES_rec.multival_attr2_datatype)
634: THEN
635: NULL;
636: END IF;
637:
634: THEN
635: NULL;
636: END IF;
637:
638: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attr_context,p_old_LIMIT_BALANCES_rec.organization_attr_context)
639: THEN
640: NULL;
641: END IF;
642:
639: THEN
640: NULL;
641: END IF;
642:
643: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attribute,p_old_LIMIT_BALANCES_rec.organization_attribute)
644: THEN
645: NULL;
646: END IF;
647:
644: THEN
645: NULL;
646: END IF;
647:
648: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attr_value,p_old_LIMIT_BALANCES_rec.organization_attr_value)
649: THEN
650: NULL;
651: END IF;
652:
1612: FOR UPDATE NOWAIT;
1613:
1614: -- Row locked. Compare IN attributes to DB attributes.
1615:
1616: IF QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute1,
1617: l_LIMIT_BALANCES_rec.attribute1)
1618: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute10,
1619: l_LIMIT_BALANCES_rec.attribute10)
1620: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute11,
1614: -- Row locked. Compare IN attributes to DB attributes.
1615:
1616: IF QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute1,
1617: l_LIMIT_BALANCES_rec.attribute1)
1618: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute10,
1619: l_LIMIT_BALANCES_rec.attribute10)
1620: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute11,
1621: l_LIMIT_BALANCES_rec.attribute11)
1622: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute12,
1616: IF QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute1,
1617: l_LIMIT_BALANCES_rec.attribute1)
1618: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute10,
1619: l_LIMIT_BALANCES_rec.attribute10)
1620: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute11,
1621: l_LIMIT_BALANCES_rec.attribute11)
1622: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute12,
1623: l_LIMIT_BALANCES_rec.attribute12)
1624: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute13,
1618: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute10,
1619: l_LIMIT_BALANCES_rec.attribute10)
1620: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute11,
1621: l_LIMIT_BALANCES_rec.attribute11)
1622: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute12,
1623: l_LIMIT_BALANCES_rec.attribute12)
1624: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute13,
1625: l_LIMIT_BALANCES_rec.attribute13)
1626: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute14,
1620: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute11,
1621: l_LIMIT_BALANCES_rec.attribute11)
1622: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute12,
1623: l_LIMIT_BALANCES_rec.attribute12)
1624: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute13,
1625: l_LIMIT_BALANCES_rec.attribute13)
1626: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute14,
1627: l_LIMIT_BALANCES_rec.attribute14)
1628: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute15,
1622: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute12,
1623: l_LIMIT_BALANCES_rec.attribute12)
1624: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute13,
1625: l_LIMIT_BALANCES_rec.attribute13)
1626: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute14,
1627: l_LIMIT_BALANCES_rec.attribute14)
1628: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute15,
1629: l_LIMIT_BALANCES_rec.attribute15)
1630: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute2,
1624: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute13,
1625: l_LIMIT_BALANCES_rec.attribute13)
1626: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute14,
1627: l_LIMIT_BALANCES_rec.attribute14)
1628: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute15,
1629: l_LIMIT_BALANCES_rec.attribute15)
1630: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute2,
1631: l_LIMIT_BALANCES_rec.attribute2)
1632: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute3,
1626: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute14,
1627: l_LIMIT_BALANCES_rec.attribute14)
1628: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute15,
1629: l_LIMIT_BALANCES_rec.attribute15)
1630: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute2,
1631: l_LIMIT_BALANCES_rec.attribute2)
1632: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute3,
1633: l_LIMIT_BALANCES_rec.attribute3)
1634: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute4,
1628: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute15,
1629: l_LIMIT_BALANCES_rec.attribute15)
1630: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute2,
1631: l_LIMIT_BALANCES_rec.attribute2)
1632: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute3,
1633: l_LIMIT_BALANCES_rec.attribute3)
1634: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute4,
1635: l_LIMIT_BALANCES_rec.attribute4)
1636: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute5,
1630: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute2,
1631: l_LIMIT_BALANCES_rec.attribute2)
1632: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute3,
1633: l_LIMIT_BALANCES_rec.attribute3)
1634: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute4,
1635: l_LIMIT_BALANCES_rec.attribute4)
1636: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute5,
1637: l_LIMIT_BALANCES_rec.attribute5)
1638: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute6,
1632: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute3,
1633: l_LIMIT_BALANCES_rec.attribute3)
1634: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute4,
1635: l_LIMIT_BALANCES_rec.attribute4)
1636: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute5,
1637: l_LIMIT_BALANCES_rec.attribute5)
1638: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute6,
1639: l_LIMIT_BALANCES_rec.attribute6)
1640: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute7,
1634: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute4,
1635: l_LIMIT_BALANCES_rec.attribute4)
1636: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute5,
1637: l_LIMIT_BALANCES_rec.attribute5)
1638: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute6,
1639: l_LIMIT_BALANCES_rec.attribute6)
1640: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute7,
1641: l_LIMIT_BALANCES_rec.attribute7)
1642: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute8,
1636: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute5,
1637: l_LIMIT_BALANCES_rec.attribute5)
1638: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute6,
1639: l_LIMIT_BALANCES_rec.attribute6)
1640: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute7,
1641: l_LIMIT_BALANCES_rec.attribute7)
1642: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute8,
1643: l_LIMIT_BALANCES_rec.attribute8)
1644: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute9,
1638: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute6,
1639: l_LIMIT_BALANCES_rec.attribute6)
1640: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute7,
1641: l_LIMIT_BALANCES_rec.attribute7)
1642: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute8,
1643: l_LIMIT_BALANCES_rec.attribute8)
1644: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute9,
1645: l_LIMIT_BALANCES_rec.attribute9)
1646: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.available_amount,
1640: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute7,
1641: l_LIMIT_BALANCES_rec.attribute7)
1642: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute8,
1643: l_LIMIT_BALANCES_rec.attribute8)
1644: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute9,
1645: l_LIMIT_BALANCES_rec.attribute9)
1646: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.available_amount,
1647: l_LIMIT_BALANCES_rec.available_amount)
1648: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.consumed_amount,
1642: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute8,
1643: l_LIMIT_BALANCES_rec.attribute8)
1644: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute9,
1645: l_LIMIT_BALANCES_rec.attribute9)
1646: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.available_amount,
1647: l_LIMIT_BALANCES_rec.available_amount)
1648: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.consumed_amount,
1649: l_LIMIT_BALANCES_rec.consumed_amount)
1650: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.context,
1644: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute9,
1645: l_LIMIT_BALANCES_rec.attribute9)
1646: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.available_amount,
1647: l_LIMIT_BALANCES_rec.available_amount)
1648: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.consumed_amount,
1649: l_LIMIT_BALANCES_rec.consumed_amount)
1650: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.context,
1651: l_LIMIT_BALANCES_rec.context)
1652: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.created_by,
1646: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.available_amount,
1647: l_LIMIT_BALANCES_rec.available_amount)
1648: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.consumed_amount,
1649: l_LIMIT_BALANCES_rec.consumed_amount)
1650: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.context,
1651: l_LIMIT_BALANCES_rec.context)
1652: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.created_by,
1653: l_LIMIT_BALANCES_rec.created_by)
1654: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.creation_date,
1648: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.consumed_amount,
1649: l_LIMIT_BALANCES_rec.consumed_amount)
1650: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.context,
1651: l_LIMIT_BALANCES_rec.context)
1652: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.created_by,
1653: l_LIMIT_BALANCES_rec.created_by)
1654: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.creation_date,
1655: l_LIMIT_BALANCES_rec.creation_date)
1656: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_updated_by,
1650: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.context,
1651: l_LIMIT_BALANCES_rec.context)
1652: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.created_by,
1653: l_LIMIT_BALANCES_rec.created_by)
1654: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.creation_date,
1655: l_LIMIT_BALANCES_rec.creation_date)
1656: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_updated_by,
1657: l_LIMIT_BALANCES_rec.last_updated_by)
1658: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_update_date,
1652: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.created_by,
1653: l_LIMIT_BALANCES_rec.created_by)
1654: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.creation_date,
1655: l_LIMIT_BALANCES_rec.creation_date)
1656: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_updated_by,
1657: l_LIMIT_BALANCES_rec.last_updated_by)
1658: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_update_date,
1659: l_LIMIT_BALANCES_rec.last_update_date)
1660: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_update_login,
1654: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.creation_date,
1655: l_LIMIT_BALANCES_rec.creation_date)
1656: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_updated_by,
1657: l_LIMIT_BALANCES_rec.last_updated_by)
1658: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_update_date,
1659: l_LIMIT_BALANCES_rec.last_update_date)
1660: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_update_login,
1661: l_LIMIT_BALANCES_rec.last_update_login)
1662: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.limit_balance_id,
1656: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_updated_by,
1657: l_LIMIT_BALANCES_rec.last_updated_by)
1658: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_update_date,
1659: l_LIMIT_BALANCES_rec.last_update_date)
1660: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_update_login,
1661: l_LIMIT_BALANCES_rec.last_update_login)
1662: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.limit_balance_id,
1663: l_LIMIT_BALANCES_rec.limit_balance_id)
1664: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.limit_id,
1658: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_update_date,
1659: l_LIMIT_BALANCES_rec.last_update_date)
1660: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_update_login,
1661: l_LIMIT_BALANCES_rec.last_update_login)
1662: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.limit_balance_id,
1663: l_LIMIT_BALANCES_rec.limit_balance_id)
1664: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.limit_id,
1665: l_LIMIT_BALANCES_rec.limit_id)
1666: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_application_id,
1660: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_update_login,
1661: l_LIMIT_BALANCES_rec.last_update_login)
1662: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.limit_balance_id,
1663: l_LIMIT_BALANCES_rec.limit_balance_id)
1664: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.limit_id,
1665: l_LIMIT_BALANCES_rec.limit_id)
1666: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_application_id,
1667: l_LIMIT_BALANCES_rec.program_application_id)
1668: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_id,
1662: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.limit_balance_id,
1663: l_LIMIT_BALANCES_rec.limit_balance_id)
1664: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.limit_id,
1665: l_LIMIT_BALANCES_rec.limit_id)
1666: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_application_id,
1667: l_LIMIT_BALANCES_rec.program_application_id)
1668: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_id,
1669: l_LIMIT_BALANCES_rec.program_id)
1670: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_update_date,
1664: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.limit_id,
1665: l_LIMIT_BALANCES_rec.limit_id)
1666: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_application_id,
1667: l_LIMIT_BALANCES_rec.program_application_id)
1668: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_id,
1669: l_LIMIT_BALANCES_rec.program_id)
1670: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_update_date,
1671: l_LIMIT_BALANCES_rec.program_update_date)
1672: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.request_id,
1666: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_application_id,
1667: l_LIMIT_BALANCES_rec.program_application_id)
1668: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_id,
1669: l_LIMIT_BALANCES_rec.program_id)
1670: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_update_date,
1671: l_LIMIT_BALANCES_rec.program_update_date)
1672: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.request_id,
1673: l_LIMIT_BALANCES_rec.request_id)
1674: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.reserved_amount,
1668: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_id,
1669: l_LIMIT_BALANCES_rec.program_id)
1670: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_update_date,
1671: l_LIMIT_BALANCES_rec.program_update_date)
1672: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.request_id,
1673: l_LIMIT_BALANCES_rec.request_id)
1674: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.reserved_amount,
1675: l_LIMIT_BALANCES_rec.reserved_amount)
1676: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_type,
1670: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_update_date,
1671: l_LIMIT_BALANCES_rec.program_update_date)
1672: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.request_id,
1673: l_LIMIT_BALANCES_rec.request_id)
1674: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.reserved_amount,
1675: l_LIMIT_BALANCES_rec.reserved_amount)
1676: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_type,
1677: l_LIMIT_BALANCES_rec.multival_attr1_type)
1678: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_context,
1672: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.request_id,
1673: l_LIMIT_BALANCES_rec.request_id)
1674: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.reserved_amount,
1675: l_LIMIT_BALANCES_rec.reserved_amount)
1676: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_type,
1677: l_LIMIT_BALANCES_rec.multival_attr1_type)
1678: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_context,
1679: l_LIMIT_BALANCES_rec.multival_attr1_context)
1680: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attribute1,
1674: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.reserved_amount,
1675: l_LIMIT_BALANCES_rec.reserved_amount)
1676: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_type,
1677: l_LIMIT_BALANCES_rec.multival_attr1_type)
1678: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_context,
1679: l_LIMIT_BALANCES_rec.multival_attr1_context)
1680: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attribute1,
1681: l_LIMIT_BALANCES_rec.multival_attribute1)
1682: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_value,
1676: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_type,
1677: l_LIMIT_BALANCES_rec.multival_attr1_type)
1678: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_context,
1679: l_LIMIT_BALANCES_rec.multival_attr1_context)
1680: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attribute1,
1681: l_LIMIT_BALANCES_rec.multival_attribute1)
1682: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_value,
1683: l_LIMIT_BALANCES_rec.multival_attr1_value)
1684: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_datatype,
1678: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_context,
1679: l_LIMIT_BALANCES_rec.multival_attr1_context)
1680: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attribute1,
1681: l_LIMIT_BALANCES_rec.multival_attribute1)
1682: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_value,
1683: l_LIMIT_BALANCES_rec.multival_attr1_value)
1684: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_datatype,
1685: l_LIMIT_BALANCES_rec.multival_attr1_datatype)
1686: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_type,
1680: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attribute1,
1681: l_LIMIT_BALANCES_rec.multival_attribute1)
1682: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_value,
1683: l_LIMIT_BALANCES_rec.multival_attr1_value)
1684: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_datatype,
1685: l_LIMIT_BALANCES_rec.multival_attr1_datatype)
1686: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_type,
1687: l_LIMIT_BALANCES_rec.multival_attr2_type)
1688: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_context,
1682: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_value,
1683: l_LIMIT_BALANCES_rec.multival_attr1_value)
1684: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_datatype,
1685: l_LIMIT_BALANCES_rec.multival_attr1_datatype)
1686: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_type,
1687: l_LIMIT_BALANCES_rec.multival_attr2_type)
1688: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_context,
1689: l_LIMIT_BALANCES_rec.multival_attr2_context)
1690: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attribute2,
1684: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_datatype,
1685: l_LIMIT_BALANCES_rec.multival_attr1_datatype)
1686: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_type,
1687: l_LIMIT_BALANCES_rec.multival_attr2_type)
1688: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_context,
1689: l_LIMIT_BALANCES_rec.multival_attr2_context)
1690: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attribute2,
1691: l_LIMIT_BALANCES_rec.multival_attribute2)
1692: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_value,
1686: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_type,
1687: l_LIMIT_BALANCES_rec.multival_attr2_type)
1688: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_context,
1689: l_LIMIT_BALANCES_rec.multival_attr2_context)
1690: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attribute2,
1691: l_LIMIT_BALANCES_rec.multival_attribute2)
1692: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_value,
1693: l_LIMIT_BALANCES_rec.multival_attr2_value)
1694: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_datatype,
1688: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_context,
1689: l_LIMIT_BALANCES_rec.multival_attr2_context)
1690: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attribute2,
1691: l_LIMIT_BALANCES_rec.multival_attribute2)
1692: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_value,
1693: l_LIMIT_BALANCES_rec.multival_attr2_value)
1694: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_datatype,
1695: l_LIMIT_BALANCES_rec.multival_attr2_datatype)
1696: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attr_context,
1690: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attribute2,
1691: l_LIMIT_BALANCES_rec.multival_attribute2)
1692: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_value,
1693: l_LIMIT_BALANCES_rec.multival_attr2_value)
1694: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_datatype,
1695: l_LIMIT_BALANCES_rec.multival_attr2_datatype)
1696: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attr_context,
1697: l_LIMIT_BALANCES_rec.organization_attr_context)
1698: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attribute,
1692: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_value,
1693: l_LIMIT_BALANCES_rec.multival_attr2_value)
1694: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_datatype,
1695: l_LIMIT_BALANCES_rec.multival_attr2_datatype)
1696: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attr_context,
1697: l_LIMIT_BALANCES_rec.organization_attr_context)
1698: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attribute,
1699: l_LIMIT_BALANCES_rec.organization_attribute)
1700: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attr_value,
1694: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_datatype,
1695: l_LIMIT_BALANCES_rec.multival_attr2_datatype)
1696: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attr_context,
1697: l_LIMIT_BALANCES_rec.organization_attr_context)
1698: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attribute,
1699: l_LIMIT_BALANCES_rec.organization_attribute)
1700: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attr_value,
1701: l_LIMIT_BALANCES_rec.organization_attr_value)
1702: THEN
1696: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attr_context,
1697: l_LIMIT_BALANCES_rec.organization_attr_context)
1698: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attribute,
1699: l_LIMIT_BALANCES_rec.organization_attribute)
1700: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attr_value,
1701: l_LIMIT_BALANCES_rec.organization_attr_value)
1702: THEN
1703:
1704: -- Row has not changed. Set out parameter.
1780: BEGIN
1781:
1782: IF p_LIMIT_BALANCES_rec.limit_balance_id IS NOT NULL AND
1783: p_LIMIT_BALANCES_rec.limit_balance_id <> FND_API.G_MISS_NUM AND
1784: NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.limit_balance_id,
1785: p_old_LIMIT_BALANCES_rec.limit_balance_id)
1786: THEN
1787: l_LIMIT_BALANCES_val_rec.limit_balance := QP_Id_To_Value.Limit_Balance
1788: ( p_limit_balance_id => p_LIMIT_BALANCES_rec.limit_balance_id
1790: END IF;
1791:
1792: IF p_LIMIT_BALANCES_rec.limit_id IS NOT NULL AND
1793: p_LIMIT_BALANCES_rec.limit_id <> FND_API.G_MISS_NUM AND
1794: NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.limit_id,
1795: p_old_LIMIT_BALANCES_rec.limit_id)
1796: THEN
1797: l_LIMIT_BALANCES_val_rec.limit := QP_Id_To_Value.Limit
1798: ( p_limit_id => p_LIMIT_BALANCES_rec.limit_id