eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_LIMIT_BALANCES_UTIL dependencies on QP_GLOBALS

Line 19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

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

Line 20: l_dep_attr_tbl QP_GLOBALS.NUMBER_Tbl_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
24:

Line 32: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute1,p_old_LIMIT_BALANCES_rec.attribute1)

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;

Line 38: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute10,p_old_LIMIT_BALANCES_rec.attribute10)

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;

Line 44: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute11,p_old_LIMIT_BALANCES_rec.attribute11)

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;

Line 50: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute12,p_old_LIMIT_BALANCES_rec.attribute12)

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;

Line 56: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute13,p_old_LIMIT_BALANCES_rec.attribute13)

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;

Line 62: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute14,p_old_LIMIT_BALANCES_rec.attribute14)

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;

Line 68: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute15,p_old_LIMIT_BALANCES_rec.attribute15)

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;

Line 74: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute2,p_old_LIMIT_BALANCES_rec.attribute2)

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;

Line 80: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute3,p_old_LIMIT_BALANCES_rec.attribute3)

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;

Line 86: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute4,p_old_LIMIT_BALANCES_rec.attribute4)

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;

Line 92: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute5,p_old_LIMIT_BALANCES_rec.attribute5)

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;

Line 98: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute6,p_old_LIMIT_BALANCES_rec.attribute6)

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;

Line 104: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute7,p_old_LIMIT_BALANCES_rec.attribute7)

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;

Line 110: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute8,p_old_LIMIT_BALANCES_rec.attribute8)

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;

Line 116: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute9,p_old_LIMIT_BALANCES_rec.attribute9)

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;

Line 122: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.available_amount,p_old_LIMIT_BALANCES_rec.available_amount)

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;

Line 128: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.consumed_amount,p_old_LIMIT_BALANCES_rec.consumed_amount)

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;

Line 134: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.context,p_old_LIMIT_BALANCES_rec.context)

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;

Line 140: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.created_by,p_old_LIMIT_BALANCES_rec.created_by)

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;

Line 146: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.creation_date,p_old_LIMIT_BALANCES_rec.creation_date)

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;

Line 152: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_updated_by,p_old_LIMIT_BALANCES_rec.last_updated_by)

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;

Line 158: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_update_date,p_old_LIMIT_BALANCES_rec.last_update_date)

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;

Line 164: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_update_login,p_old_LIMIT_BALANCES_rec.last_update_login)

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;

Line 170: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.limit_balance_id,p_old_LIMIT_BALANCES_rec.limit_balance_id)

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;

Line 176: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.limit_id,p_old_LIMIT_BALANCES_rec.limit_id)

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;

Line 182: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_application_id,p_old_LIMIT_BALANCES_rec.program_application_id)

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;

Line 188: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_id,p_old_LIMIT_BALANCES_rec.program_id)

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;

Line 194: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_update_date,p_old_LIMIT_BALANCES_rec.program_update_date)

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;

Line 200: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.request_id,p_old_LIMIT_BALANCES_rec.request_id)

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;

Line 206: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.reserved_amount,p_old_LIMIT_BALANCES_rec.reserved_amount)

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;

Line 212: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_type,p_old_LIMIT_BALANCES_rec.multival_attr1_type)

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;

Line 218: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_context,p_old_LIMIT_BALANCES_rec.multival_attr1_context)

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;

Line 224: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attribute1,p_old_LIMIT_BALANCES_rec.multival_attribute1)

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;

Line 230: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_value,p_old_LIMIT_BALANCES_rec.multival_attr1_value)

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;

Line 236: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_datatype,p_old_LIMIT_BALANCES_rec.multival_attr1_datatype)

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;

Line 242: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_type,p_old_LIMIT_BALANCES_rec.multival_attr2_type)

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;

Line 248: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_context,p_old_LIMIT_BALANCES_rec.multival_attr2_context)

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;

Line 254: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attribute2,p_old_LIMIT_BALANCES_rec.multival_attribute2)

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;

Line 260: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_value,p_old_LIMIT_BALANCES_rec.multival_attr2_value)

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;

Line 266: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_datatype,p_old_LIMIT_BALANCES_rec.multival_attr2_datatype)

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;

Line 272: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attr_context,p_old_LIMIT_BALANCES_rec.organization_attr_context)

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;

Line 278: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attribute,p_old_LIMIT_BALANCES_rec.organization_attribute)

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;

Line 284: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attr_value,p_old_LIMIT_BALANCES_rec.organization_attr_value)

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;

Line 438: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute1,p_old_LIMIT_BALANCES_rec.attribute1)

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:

Line 443: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute10,p_old_LIMIT_BALANCES_rec.attribute10)

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:

Line 448: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute11,p_old_LIMIT_BALANCES_rec.attribute11)

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:

Line 453: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute12,p_old_LIMIT_BALANCES_rec.attribute12)

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:

Line 458: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute13,p_old_LIMIT_BALANCES_rec.attribute13)

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:

Line 463: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute14,p_old_LIMIT_BALANCES_rec.attribute14)

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:

Line 468: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute15,p_old_LIMIT_BALANCES_rec.attribute15)

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:

Line 473: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute2,p_old_LIMIT_BALANCES_rec.attribute2)

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:

Line 478: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute3,p_old_LIMIT_BALANCES_rec.attribute3)

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:

Line 483: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute4,p_old_LIMIT_BALANCES_rec.attribute4)

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:

Line 488: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute5,p_old_LIMIT_BALANCES_rec.attribute5)

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:

Line 493: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute6,p_old_LIMIT_BALANCES_rec.attribute6)

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:

Line 498: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute7,p_old_LIMIT_BALANCES_rec.attribute7)

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:

Line 503: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute8,p_old_LIMIT_BALANCES_rec.attribute8)

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:

Line 508: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute9,p_old_LIMIT_BALANCES_rec.attribute9)

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:

Line 513: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.available_amount,p_old_LIMIT_BALANCES_rec.available_amount)

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:

Line 518: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.consumed_amount,p_old_LIMIT_BALANCES_rec.consumed_amount)

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:

Line 523: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.context,p_old_LIMIT_BALANCES_rec.context)

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:

Line 528: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.created_by,p_old_LIMIT_BALANCES_rec.created_by)

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:

Line 533: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.creation_date,p_old_LIMIT_BALANCES_rec.creation_date)

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:

Line 538: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_updated_by,p_old_LIMIT_BALANCES_rec.last_updated_by)

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:

Line 543: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_update_date,p_old_LIMIT_BALANCES_rec.last_update_date)

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:

Line 548: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_update_login,p_old_LIMIT_BALANCES_rec.last_update_login)

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:

Line 553: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.limit_balance_id,p_old_LIMIT_BALANCES_rec.limit_balance_id)

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:

Line 558: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.limit_id,p_old_LIMIT_BALANCES_rec.limit_id)

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:

Line 563: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_application_id,p_old_LIMIT_BALANCES_rec.program_application_id)

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:

Line 568: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_id,p_old_LIMIT_BALANCES_rec.program_id)

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:

Line 573: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_update_date,p_old_LIMIT_BALANCES_rec.program_update_date)

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:

Line 578: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.request_id,p_old_LIMIT_BALANCES_rec.request_id)

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:

Line 583: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.reserved_amount,p_old_LIMIT_BALANCES_rec.reserved_amount)

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:

Line 588: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_type,p_old_LIMIT_BALANCES_rec.multival_attr1_type)

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:

Line 593: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_context,p_old_LIMIT_BALANCES_rec.multival_attr1_context)

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:

Line 598: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attribute1,p_old_LIMIT_BALANCES_rec.multival_attribute1)

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:

Line 603: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_value,p_old_LIMIT_BALANCES_rec.multival_attr1_value)

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:

Line 608: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_datatype,p_old_LIMIT_BALANCES_rec.multival_attr1_datatype)

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:

Line 613: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_type,p_old_LIMIT_BALANCES_rec.multival_attr2_type)

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:

Line 618: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_context,p_old_LIMIT_BALANCES_rec.multival_attr2_context)

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:

Line 623: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attribute2,p_old_LIMIT_BALANCES_rec.multival_attribute2)

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:

Line 628: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_value,p_old_LIMIT_BALANCES_rec.multival_attr2_value)

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:

Line 633: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_datatype,p_old_LIMIT_BALANCES_rec.multival_attr2_datatype)

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:

Line 638: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attr_context,p_old_LIMIT_BALANCES_rec.organization_attr_context)

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:

Line 643: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attribute,p_old_LIMIT_BALANCES_rec.organization_attribute)

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:

Line 648: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attr_value,p_old_LIMIT_BALANCES_rec.organization_attr_value)

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:

Line 1616: IF QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute1,

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,

Line 1618: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute10,

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,

Line 1620: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute11,

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,

Line 1622: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute12,

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,

Line 1624: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute13,

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,

Line 1626: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute14,

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,

Line 1628: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute15,

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,

Line 1630: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute2,

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,

Line 1632: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute3,

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,

Line 1634: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute4,

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,

Line 1636: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute5,

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,

Line 1638: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute6,

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,

Line 1640: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute7,

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,

Line 1642: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute8,

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,

Line 1644: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute9,

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,

Line 1646: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.available_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,

Line 1648: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.consumed_amount,

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,

Line 1650: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.context,

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,

Line 1652: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.created_by,

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,

Line 1654: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.creation_date,

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,

Line 1656: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_updated_by,

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,

Line 1658: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_update_date,

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,

Line 1660: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_update_login,

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,

Line 1662: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.limit_balance_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,

Line 1664: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.limit_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,

Line 1666: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_application_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,

Line 1668: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_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,
1671: l_LIMIT_BALANCES_rec.program_update_date)
1672: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.request_id,

Line 1670: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_update_date,

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,

Line 1672: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.request_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,
1675: l_LIMIT_BALANCES_rec.reserved_amount)
1676: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_type,

Line 1674: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.reserved_amount,

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,

Line 1676: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_type,

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,

Line 1678: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_context,

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,

Line 1680: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attribute1,

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,

Line 1682: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_value,

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,

Line 1684: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_datatype,

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,

Line 1686: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_type,

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,

Line 1688: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_context,

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,

Line 1690: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attribute2,

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,

Line 1692: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_value,

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,

Line 1694: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_datatype,

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,

Line 1696: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attr_context,

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,

Line 1698: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attribute,

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

Line 1700: AND QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attr_value,

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.

Line 1784: NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.limit_balance_id,

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

Line 1794: NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.limit_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