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_LIMIT_BALANCES_UTIL

Line 1: PACKAGE BODY QP_Limit_Balances_Util AS

1: PACKAGE BODY QP_Limit_Balances_Util AS
2: /* $Header: QPXULMBB.pls 120.1 2005/06/10 02:17:54 appldev $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Limit_Balances_Util';

2: /* $Header: QPXULMBB.pls 120.1 2005/06/10 02:17:54 appldev $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Limit_Balances_Util';
7:
8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr

Line 35: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE1;

31:
32: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute1,p_old_LIMIT_BALANCES_rec.attribute1)
33: THEN
34: l_index := l_index + 1;
35: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE1;
36: END IF;
37:
38: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute10,p_old_LIMIT_BALANCES_rec.attribute10)
39: THEN

Line 41: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE10;

37:
38: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute10,p_old_LIMIT_BALANCES_rec.attribute10)
39: THEN
40: l_index := l_index + 1;
41: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE10;
42: END IF;
43:
44: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute11,p_old_LIMIT_BALANCES_rec.attribute11)
45: THEN

Line 47: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE11;

43:
44: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute11,p_old_LIMIT_BALANCES_rec.attribute11)
45: THEN
46: l_index := l_index + 1;
47: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE11;
48: END IF;
49:
50: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute12,p_old_LIMIT_BALANCES_rec.attribute12)
51: THEN

Line 53: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE12;

49:
50: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute12,p_old_LIMIT_BALANCES_rec.attribute12)
51: THEN
52: l_index := l_index + 1;
53: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE12;
54: END IF;
55:
56: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute13,p_old_LIMIT_BALANCES_rec.attribute13)
57: THEN

Line 59: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE13;

55:
56: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute13,p_old_LIMIT_BALANCES_rec.attribute13)
57: THEN
58: l_index := l_index + 1;
59: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE13;
60: END IF;
61:
62: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute14,p_old_LIMIT_BALANCES_rec.attribute14)
63: THEN

Line 65: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE14;

61:
62: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute14,p_old_LIMIT_BALANCES_rec.attribute14)
63: THEN
64: l_index := l_index + 1;
65: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE14;
66: END IF;
67:
68: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute15,p_old_LIMIT_BALANCES_rec.attribute15)
69: THEN

Line 71: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE15;

67:
68: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute15,p_old_LIMIT_BALANCES_rec.attribute15)
69: THEN
70: l_index := l_index + 1;
71: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE15;
72: END IF;
73:
74: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute2,p_old_LIMIT_BALANCES_rec.attribute2)
75: THEN

Line 77: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE2;

73:
74: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute2,p_old_LIMIT_BALANCES_rec.attribute2)
75: THEN
76: l_index := l_index + 1;
77: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE2;
78: END IF;
79:
80: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute3,p_old_LIMIT_BALANCES_rec.attribute3)
81: THEN

Line 83: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE3;

79:
80: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute3,p_old_LIMIT_BALANCES_rec.attribute3)
81: THEN
82: l_index := l_index + 1;
83: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE3;
84: END IF;
85:
86: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute4,p_old_LIMIT_BALANCES_rec.attribute4)
87: THEN

Line 89: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE4;

85:
86: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute4,p_old_LIMIT_BALANCES_rec.attribute4)
87: THEN
88: l_index := l_index + 1;
89: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE4;
90: END IF;
91:
92: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute5,p_old_LIMIT_BALANCES_rec.attribute5)
93: THEN

Line 95: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE5;

91:
92: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute5,p_old_LIMIT_BALANCES_rec.attribute5)
93: THEN
94: l_index := l_index + 1;
95: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE5;
96: END IF;
97:
98: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute6,p_old_LIMIT_BALANCES_rec.attribute6)
99: THEN

Line 101: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE6;

97:
98: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute6,p_old_LIMIT_BALANCES_rec.attribute6)
99: THEN
100: l_index := l_index + 1;
101: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE6;
102: END IF;
103:
104: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute7,p_old_LIMIT_BALANCES_rec.attribute7)
105: THEN

Line 107: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE7;

103:
104: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute7,p_old_LIMIT_BALANCES_rec.attribute7)
105: THEN
106: l_index := l_index + 1;
107: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE7;
108: END IF;
109:
110: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute8,p_old_LIMIT_BALANCES_rec.attribute8)
111: THEN

Line 113: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE8;

109:
110: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute8,p_old_LIMIT_BALANCES_rec.attribute8)
111: THEN
112: l_index := l_index + 1;
113: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE8;
114: END IF;
115:
116: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute9,p_old_LIMIT_BALANCES_rec.attribute9)
117: THEN

Line 119: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE9;

115:
116: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.attribute9,p_old_LIMIT_BALANCES_rec.attribute9)
117: THEN
118: l_index := l_index + 1;
119: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE9;
120: END IF;
121:
122: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.available_amount,p_old_LIMIT_BALANCES_rec.available_amount)
123: THEN

Line 125: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_AVAILABLE_AMOUNT;

121:
122: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.available_amount,p_old_LIMIT_BALANCES_rec.available_amount)
123: THEN
124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_AVAILABLE_AMOUNT;
126: END IF;
127:
128: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.consumed_amount,p_old_LIMIT_BALANCES_rec.consumed_amount)
129: THEN

Line 131: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CONSUMED_AMOUNT;

127:
128: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.consumed_amount,p_old_LIMIT_BALANCES_rec.consumed_amount)
129: THEN
130: l_index := l_index + 1;
131: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CONSUMED_AMOUNT;
132: END IF;
133:
134: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.context,p_old_LIMIT_BALANCES_rec.context)
135: THEN

Line 137: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CONTEXT;

133:
134: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.context,p_old_LIMIT_BALANCES_rec.context)
135: THEN
136: l_index := l_index + 1;
137: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CONTEXT;
138: END IF;
139:
140: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.created_by,p_old_LIMIT_BALANCES_rec.created_by)
141: THEN

Line 143: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CREATED_BY;

139:
140: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.created_by,p_old_LIMIT_BALANCES_rec.created_by)
141: THEN
142: l_index := l_index + 1;
143: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CREATED_BY;
144: END IF;
145:
146: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.creation_date,p_old_LIMIT_BALANCES_rec.creation_date)
147: THEN

Line 149: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CREATION_DATE;

145:
146: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.creation_date,p_old_LIMIT_BALANCES_rec.creation_date)
147: THEN
148: l_index := l_index + 1;
149: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CREATION_DATE;
150: END IF;
151:
152: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_updated_by,p_old_LIMIT_BALANCES_rec.last_updated_by)
153: THEN

Line 155: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATED_BY;

151:
152: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_updated_by,p_old_LIMIT_BALANCES_rec.last_updated_by)
153: THEN
154: l_index := l_index + 1;
155: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATED_BY;
156: END IF;
157:
158: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_update_date,p_old_LIMIT_BALANCES_rec.last_update_date)
159: THEN

Line 161: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATE_DATE;

157:
158: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_update_date,p_old_LIMIT_BALANCES_rec.last_update_date)
159: THEN
160: l_index := l_index + 1;
161: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATE_DATE;
162: END IF;
163:
164: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_update_login,p_old_LIMIT_BALANCES_rec.last_update_login)
165: THEN

Line 167: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATE_LOGIN;

163:
164: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.last_update_login,p_old_LIMIT_BALANCES_rec.last_update_login)
165: THEN
166: l_index := l_index + 1;
167: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATE_LOGIN;
168: END IF;
169:
170: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.limit_balance_id,p_old_LIMIT_BALANCES_rec.limit_balance_id)
171: THEN

Line 173: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LIMIT_BALANCE;

169:
170: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.limit_balance_id,p_old_LIMIT_BALANCES_rec.limit_balance_id)
171: THEN
172: l_index := l_index + 1;
173: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LIMIT_BALANCE;
174: END IF;
175:
176: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.limit_id,p_old_LIMIT_BALANCES_rec.limit_id)
177: THEN

Line 179: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LIMIT;

175:
176: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.limit_id,p_old_LIMIT_BALANCES_rec.limit_id)
177: THEN
178: l_index := l_index + 1;
179: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LIMIT;
180: END IF;
181:
182: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_application_id,p_old_LIMIT_BALANCES_rec.program_application_id)
183: THEN

Line 185: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM_APPLICATION;

181:
182: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_application_id,p_old_LIMIT_BALANCES_rec.program_application_id)
183: THEN
184: l_index := l_index + 1;
185: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM_APPLICATION;
186: END IF;
187:
188: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_id,p_old_LIMIT_BALANCES_rec.program_id)
189: THEN

Line 191: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM;

187:
188: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_id,p_old_LIMIT_BALANCES_rec.program_id)
189: THEN
190: l_index := l_index + 1;
191: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM;
192: END IF;
193:
194: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_update_date,p_old_LIMIT_BALANCES_rec.program_update_date)
195: THEN

Line 197: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM_UPDATE_DATE;

193:
194: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.program_update_date,p_old_LIMIT_BALANCES_rec.program_update_date)
195: THEN
196: l_index := l_index + 1;
197: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM_UPDATE_DATE;
198: END IF;
199:
200: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.request_id,p_old_LIMIT_BALANCES_rec.request_id)
201: THEN

Line 203: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_REQUEST;

199:
200: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.request_id,p_old_LIMIT_BALANCES_rec.request_id)
201: THEN
202: l_index := l_index + 1;
203: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_REQUEST;
204: END IF;
205:
206: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.reserved_amount,p_old_LIMIT_BALANCES_rec.reserved_amount)
207: THEN

Line 209: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_RESERVED_AMOUNT;

205:
206: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.reserved_amount,p_old_LIMIT_BALANCES_rec.reserved_amount)
207: THEN
208: l_index := l_index + 1;
209: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_RESERVED_AMOUNT;
210: END IF;
211:
212: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_type,p_old_LIMIT_BALANCES_rec.multival_attr1_type)
213: THEN

Line 215: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_TYPE;

211:
212: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_type,p_old_LIMIT_BALANCES_rec.multival_attr1_type)
213: THEN
214: l_index := l_index + 1;
215: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_TYPE;
216: END IF;
217:
218: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_context,p_old_LIMIT_BALANCES_rec.multival_attr1_context)
219: THEN

Line 221: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_CONTEXT;

217:
218: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_context,p_old_LIMIT_BALANCES_rec.multival_attr1_context)
219: THEN
220: l_index := l_index + 1;
221: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_CONTEXT;
222: END IF;
223:
224: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attribute1,p_old_LIMIT_BALANCES_rec.multival_attribute1)
225: THEN

Line 227: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTRIBUTE1;

223:
224: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attribute1,p_old_LIMIT_BALANCES_rec.multival_attribute1)
225: THEN
226: l_index := l_index + 1;
227: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTRIBUTE1;
228: END IF;
229:
230: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_value,p_old_LIMIT_BALANCES_rec.multival_attr1_value)
231: THEN

Line 233: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_VALUE;

229:
230: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_value,p_old_LIMIT_BALANCES_rec.multival_attr1_value)
231: THEN
232: l_index := l_index + 1;
233: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_VALUE;
234: END IF;
235:
236: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_datatype,p_old_LIMIT_BALANCES_rec.multival_attr1_datatype)
237: THEN

Line 239: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_DATATYPE;

235:
236: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr1_datatype,p_old_LIMIT_BALANCES_rec.multival_attr1_datatype)
237: THEN
238: l_index := l_index + 1;
239: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_DATATYPE;
240: END IF;
241:
242: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_type,p_old_LIMIT_BALANCES_rec.multival_attr2_type)
243: THEN

Line 245: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_TYPE;

241:
242: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_type,p_old_LIMIT_BALANCES_rec.multival_attr2_type)
243: THEN
244: l_index := l_index + 1;
245: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_TYPE;
246: END IF;
247:
248: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_context,p_old_LIMIT_BALANCES_rec.multival_attr2_context)
249: THEN

Line 251: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_CONTEXT;

247:
248: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_context,p_old_LIMIT_BALANCES_rec.multival_attr2_context)
249: THEN
250: l_index := l_index + 1;
251: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_CONTEXT;
252: END IF;
253:
254: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attribute2,p_old_LIMIT_BALANCES_rec.multival_attribute2)
255: THEN

Line 257: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTRIBUTE2;

253:
254: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attribute2,p_old_LIMIT_BALANCES_rec.multival_attribute2)
255: THEN
256: l_index := l_index + 1;
257: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTRIBUTE2;
258: END IF;
259:
260: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_value,p_old_LIMIT_BALANCES_rec.multival_attr2_value)
261: THEN

Line 263: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_VALUE;

259:
260: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_value,p_old_LIMIT_BALANCES_rec.multival_attr2_value)
261: THEN
262: l_index := l_index + 1;
263: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_VALUE;
264: END IF;
265:
266: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_datatype,p_old_LIMIT_BALANCES_rec.multival_attr2_datatype)
267: THEN

Line 269: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_DATATYPE;

265:
266: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.multival_attr2_datatype,p_old_LIMIT_BALANCES_rec.multival_attr2_datatype)
267: THEN
268: l_index := l_index + 1;
269: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_DATATYPE;
270: END IF;
271:
272: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attr_context,p_old_LIMIT_BALANCES_rec.organization_attr_context)
273: THEN

Line 275: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ORGANIZATION_ATTR_CONTEXT;

271:
272: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attr_context,p_old_LIMIT_BALANCES_rec.organization_attr_context)
273: THEN
274: l_index := l_index + 1;
275: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ORGANIZATION_ATTR_CONTEXT;
276: END IF;
277:
278: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attribute,p_old_LIMIT_BALANCES_rec.organization_attribute)
279: THEN

Line 281: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ORGANIZATION_ATTRIBUTE;

277:
278: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attribute,p_old_LIMIT_BALANCES_rec.organization_attribute)
279: THEN
280: l_index := l_index + 1;
281: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ORGANIZATION_ATTRIBUTE;
282: END IF;
283:
284: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attr_value,p_old_LIMIT_BALANCES_rec.organization_attr_value)
285: THEN

Line 287: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ORGANIZATION_ATTR_VALUE;

283:
284: IF NOT QP_GLOBALS.Equal(p_LIMIT_BALANCES_rec.organization_attr_value,p_old_LIMIT_BALANCES_rec.organization_attr_value)
285: THEN
286: l_index := l_index + 1;
287: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ORGANIZATION_ATTR_VALUE;
288: END IF;
289:
290: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
291: l_index := l_index + 1;

Line 292: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE1;

288: END IF;
289:
290: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
291: l_index := l_index + 1;
292: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE1;
293: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
294: l_index := l_index + 1;
295: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE10;
296: ELSIF p_attr_id = G_ATTRIBUTE11 THEN

Line 295: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE10;

291: l_index := l_index + 1;
292: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE1;
293: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
294: l_index := l_index + 1;
295: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE10;
296: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
297: l_index := l_index + 1;
298: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE11;
299: ELSIF p_attr_id = G_ATTRIBUTE12 THEN

Line 298: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE11;

294: l_index := l_index + 1;
295: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE10;
296: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
297: l_index := l_index + 1;
298: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE11;
299: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
300: l_index := l_index + 1;
301: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE12;
302: ELSIF p_attr_id = G_ATTRIBUTE13 THEN

Line 301: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE12;

297: l_index := l_index + 1;
298: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE11;
299: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
300: l_index := l_index + 1;
301: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE12;
302: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
303: l_index := l_index + 1;
304: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE13;
305: ELSIF p_attr_id = G_ATTRIBUTE14 THEN

Line 304: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE13;

300: l_index := l_index + 1;
301: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE12;
302: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
303: l_index := l_index + 1;
304: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE13;
305: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
306: l_index := l_index + 1;
307: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE14;
308: ELSIF p_attr_id = G_ATTRIBUTE15 THEN

Line 307: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE14;

303: l_index := l_index + 1;
304: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE13;
305: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
306: l_index := l_index + 1;
307: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE14;
308: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
309: l_index := l_index + 1;
310: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE15;
311: ELSIF p_attr_id = G_ATTRIBUTE2 THEN

Line 310: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE15;

306: l_index := l_index + 1;
307: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE14;
308: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
309: l_index := l_index + 1;
310: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE15;
311: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
312: l_index := l_index + 1;
313: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE2;
314: ELSIF p_attr_id = G_ATTRIBUTE3 THEN

Line 313: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE2;

309: l_index := l_index + 1;
310: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE15;
311: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
312: l_index := l_index + 1;
313: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE2;
314: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
315: l_index := l_index + 1;
316: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE3;
317: ELSIF p_attr_id = G_ATTRIBUTE4 THEN

Line 316: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE3;

312: l_index := l_index + 1;
313: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE2;
314: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
315: l_index := l_index + 1;
316: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE3;
317: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
318: l_index := l_index + 1;
319: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE4;
320: ELSIF p_attr_id = G_ATTRIBUTE5 THEN

Line 319: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE4;

315: l_index := l_index + 1;
316: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE3;
317: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
318: l_index := l_index + 1;
319: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE4;
320: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
321: l_index := l_index + 1;
322: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE5;
323: ELSIF p_attr_id = G_ATTRIBUTE6 THEN

Line 322: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE5;

318: l_index := l_index + 1;
319: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE4;
320: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
321: l_index := l_index + 1;
322: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE5;
323: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
324: l_index := l_index + 1;
325: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE6;
326: ELSIF p_attr_id = G_ATTRIBUTE7 THEN

Line 325: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE6;

321: l_index := l_index + 1;
322: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE5;
323: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
324: l_index := l_index + 1;
325: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE6;
326: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
327: l_index := l_index + 1;
328: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE7;
329: ELSIF p_attr_id = G_ATTRIBUTE8 THEN

Line 328: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE7;

324: l_index := l_index + 1;
325: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE6;
326: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
327: l_index := l_index + 1;
328: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE7;
329: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
330: l_index := l_index + 1;
331: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE8;
332: ELSIF p_attr_id = G_ATTRIBUTE9 THEN

Line 331: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE8;

327: l_index := l_index + 1;
328: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE7;
329: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
330: l_index := l_index + 1;
331: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE8;
332: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
333: l_index := l_index + 1;
334: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE9;
335: ELSIF p_attr_id = G_AVAILABLE_AMOUNT THEN

Line 334: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE9;

330: l_index := l_index + 1;
331: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE8;
332: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
333: l_index := l_index + 1;
334: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE9;
335: ELSIF p_attr_id = G_AVAILABLE_AMOUNT THEN
336: l_index := l_index + 1;
337: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_AVAILABLE_AMOUNT;
338: ELSIF p_attr_id = G_CONSUMED_AMOUNT THEN

Line 337: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_AVAILABLE_AMOUNT;

333: l_index := l_index + 1;
334: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ATTRIBUTE9;
335: ELSIF p_attr_id = G_AVAILABLE_AMOUNT THEN
336: l_index := l_index + 1;
337: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_AVAILABLE_AMOUNT;
338: ELSIF p_attr_id = G_CONSUMED_AMOUNT THEN
339: l_index := l_index + 1;
340: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CONSUMED_AMOUNT;
341: ELSIF p_attr_id = G_CONTEXT THEN

Line 340: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CONSUMED_AMOUNT;

336: l_index := l_index + 1;
337: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_AVAILABLE_AMOUNT;
338: ELSIF p_attr_id = G_CONSUMED_AMOUNT THEN
339: l_index := l_index + 1;
340: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CONSUMED_AMOUNT;
341: ELSIF p_attr_id = G_CONTEXT THEN
342: l_index := l_index + 1;
343: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CONTEXT;
344: ELSIF p_attr_id = G_CREATED_BY THEN

Line 343: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CONTEXT;

339: l_index := l_index + 1;
340: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CONSUMED_AMOUNT;
341: ELSIF p_attr_id = G_CONTEXT THEN
342: l_index := l_index + 1;
343: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CONTEXT;
344: ELSIF p_attr_id = G_CREATED_BY THEN
345: l_index := l_index + 1;
346: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CREATED_BY;
347: ELSIF p_attr_id = G_CREATION_DATE THEN

Line 346: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CREATED_BY;

342: l_index := l_index + 1;
343: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CONTEXT;
344: ELSIF p_attr_id = G_CREATED_BY THEN
345: l_index := l_index + 1;
346: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CREATED_BY;
347: ELSIF p_attr_id = G_CREATION_DATE THEN
348: l_index := l_index + 1;
349: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CREATION_DATE;
350: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN

Line 349: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CREATION_DATE;

345: l_index := l_index + 1;
346: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CREATED_BY;
347: ELSIF p_attr_id = G_CREATION_DATE THEN
348: l_index := l_index + 1;
349: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CREATION_DATE;
350: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
351: l_index := l_index + 1;
352: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATED_BY;
353: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN

Line 352: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATED_BY;

348: l_index := l_index + 1;
349: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_CREATION_DATE;
350: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
351: l_index := l_index + 1;
352: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATED_BY;
353: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
354: l_index := l_index + 1;
355: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATE_DATE;
356: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN

Line 355: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATE_DATE;

351: l_index := l_index + 1;
352: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATED_BY;
353: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
354: l_index := l_index + 1;
355: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATE_DATE;
356: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
357: l_index := l_index + 1;
358: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATE_LOGIN;
359: ELSIF p_attr_id = G_LIMIT_BALANCE THEN

Line 358: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATE_LOGIN;

354: l_index := l_index + 1;
355: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATE_DATE;
356: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
357: l_index := l_index + 1;
358: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATE_LOGIN;
359: ELSIF p_attr_id = G_LIMIT_BALANCE THEN
360: l_index := l_index + 1;
361: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LIMIT_BALANCE;
362: ELSIF p_attr_id = G_LIMIT THEN

Line 361: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LIMIT_BALANCE;

357: l_index := l_index + 1;
358: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LAST_UPDATE_LOGIN;
359: ELSIF p_attr_id = G_LIMIT_BALANCE THEN
360: l_index := l_index + 1;
361: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LIMIT_BALANCE;
362: ELSIF p_attr_id = G_LIMIT THEN
363: l_index := l_index + 1;
364: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LIMIT;
365: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN

Line 364: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LIMIT;

360: l_index := l_index + 1;
361: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LIMIT_BALANCE;
362: ELSIF p_attr_id = G_LIMIT THEN
363: l_index := l_index + 1;
364: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LIMIT;
365: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
366: l_index := l_index + 1;
367: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM_APPLICATION;
368: ELSIF p_attr_id = G_PROGRAM THEN

Line 367: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM_APPLICATION;

363: l_index := l_index + 1;
364: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_LIMIT;
365: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
366: l_index := l_index + 1;
367: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM_APPLICATION;
368: ELSIF p_attr_id = G_PROGRAM THEN
369: l_index := l_index + 1;
370: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM;
371: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN

Line 370: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM;

366: l_index := l_index + 1;
367: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM_APPLICATION;
368: ELSIF p_attr_id = G_PROGRAM THEN
369: l_index := l_index + 1;
370: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM;
371: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
372: l_index := l_index + 1;
373: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM_UPDATE_DATE;
374: ELSIF p_attr_id = G_REQUEST THEN

Line 373: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM_UPDATE_DATE;

369: l_index := l_index + 1;
370: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM;
371: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
372: l_index := l_index + 1;
373: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM_UPDATE_DATE;
374: ELSIF p_attr_id = G_REQUEST THEN
375: l_index := l_index + 1;
376: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_REQUEST;
377: ELSIF p_attr_id = G_RESERVED_AMOUNT THEN

Line 376: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_REQUEST;

372: l_index := l_index + 1;
373: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_PROGRAM_UPDATE_DATE;
374: ELSIF p_attr_id = G_REQUEST THEN
375: l_index := l_index + 1;
376: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_REQUEST;
377: ELSIF p_attr_id = G_RESERVED_AMOUNT THEN
378: l_index := l_index + 1;
379: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_RESERVED_AMOUNT;
380: ELSIF p_attr_id = G_MULTIVAL_ATTR1_TYPE THEN

Line 379: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_RESERVED_AMOUNT;

375: l_index := l_index + 1;
376: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_REQUEST;
377: ELSIF p_attr_id = G_RESERVED_AMOUNT THEN
378: l_index := l_index + 1;
379: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_RESERVED_AMOUNT;
380: ELSIF p_attr_id = G_MULTIVAL_ATTR1_TYPE THEN
381: l_index := l_index + 1;
382: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_TYPE;
383: ELSIF p_attr_id = G_MULTIVAL_ATTR1_CONTEXT THEN

Line 382: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_TYPE;

378: l_index := l_index + 1;
379: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_RESERVED_AMOUNT;
380: ELSIF p_attr_id = G_MULTIVAL_ATTR1_TYPE THEN
381: l_index := l_index + 1;
382: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_TYPE;
383: ELSIF p_attr_id = G_MULTIVAL_ATTR1_CONTEXT THEN
384: l_index := l_index + 1;
385: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_CONTEXT;
386: ELSIF p_attr_id = G_MULTIVAL_ATTRIBUTE1 THEN

Line 385: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_CONTEXT;

381: l_index := l_index + 1;
382: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_TYPE;
383: ELSIF p_attr_id = G_MULTIVAL_ATTR1_CONTEXT THEN
384: l_index := l_index + 1;
385: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_CONTEXT;
386: ELSIF p_attr_id = G_MULTIVAL_ATTRIBUTE1 THEN
387: l_index := l_index + 1;
388: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTRIBUTE1;
389: ELSIF p_attr_id = G_MULTIVAL_ATTR1_VALUE THEN

Line 388: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTRIBUTE1;

384: l_index := l_index + 1;
385: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_CONTEXT;
386: ELSIF p_attr_id = G_MULTIVAL_ATTRIBUTE1 THEN
387: l_index := l_index + 1;
388: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTRIBUTE1;
389: ELSIF p_attr_id = G_MULTIVAL_ATTR1_VALUE THEN
390: l_index := l_index + 1;
391: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_VALUE;
392: ELSIF p_attr_id = G_MULTIVAL_ATTR1_DATATYPE THEN

Line 391: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_VALUE;

387: l_index := l_index + 1;
388: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTRIBUTE1;
389: ELSIF p_attr_id = G_MULTIVAL_ATTR1_VALUE THEN
390: l_index := l_index + 1;
391: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_VALUE;
392: ELSIF p_attr_id = G_MULTIVAL_ATTR1_DATATYPE THEN
393: l_index := l_index + 1;
394: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_DATATYPE;
395: ELSIF p_attr_id = G_MULTIVAL_ATTR2_TYPE THEN

Line 394: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_DATATYPE;

390: l_index := l_index + 1;
391: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_VALUE;
392: ELSIF p_attr_id = G_MULTIVAL_ATTR1_DATATYPE THEN
393: l_index := l_index + 1;
394: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_DATATYPE;
395: ELSIF p_attr_id = G_MULTIVAL_ATTR2_TYPE THEN
396: l_index := l_index + 1;
397: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_TYPE;
398: ELSIF p_attr_id = G_MULTIVAL_ATTR2_CONTEXT THEN

Line 397: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_TYPE;

393: l_index := l_index + 1;
394: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR1_DATATYPE;
395: ELSIF p_attr_id = G_MULTIVAL_ATTR2_TYPE THEN
396: l_index := l_index + 1;
397: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_TYPE;
398: ELSIF p_attr_id = G_MULTIVAL_ATTR2_CONTEXT THEN
399: l_index := l_index + 1;
400: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_CONTEXT;
401: ELSIF p_attr_id = G_MULTIVAL_ATTRIBUTE2 THEN

Line 400: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_CONTEXT;

396: l_index := l_index + 1;
397: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_TYPE;
398: ELSIF p_attr_id = G_MULTIVAL_ATTR2_CONTEXT THEN
399: l_index := l_index + 1;
400: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_CONTEXT;
401: ELSIF p_attr_id = G_MULTIVAL_ATTRIBUTE2 THEN
402: l_index := l_index + 1;
403: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTRIBUTE2;
404: ELSIF p_attr_id = G_MULTIVAL_ATTR2_VALUE THEN

Line 403: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTRIBUTE2;

399: l_index := l_index + 1;
400: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_CONTEXT;
401: ELSIF p_attr_id = G_MULTIVAL_ATTRIBUTE2 THEN
402: l_index := l_index + 1;
403: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTRIBUTE2;
404: ELSIF p_attr_id = G_MULTIVAL_ATTR2_VALUE THEN
405: l_index := l_index + 1;
406: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_VALUE;
407: ELSIF p_attr_id = G_MULTIVAL_ATTR2_DATATYPE THEN

Line 406: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_VALUE;

402: l_index := l_index + 1;
403: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTRIBUTE2;
404: ELSIF p_attr_id = G_MULTIVAL_ATTR2_VALUE THEN
405: l_index := l_index + 1;
406: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_VALUE;
407: ELSIF p_attr_id = G_MULTIVAL_ATTR2_DATATYPE THEN
408: l_index := l_index + 1;
409: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_DATATYPE;
410: ELSIF p_attr_id = G_ORGANIZATION_ATTR_CONTEXT THEN

Line 409: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_DATATYPE;

405: l_index := l_index + 1;
406: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_VALUE;
407: ELSIF p_attr_id = G_MULTIVAL_ATTR2_DATATYPE THEN
408: l_index := l_index + 1;
409: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_DATATYPE;
410: ELSIF p_attr_id = G_ORGANIZATION_ATTR_CONTEXT THEN
411: l_index := l_index + 1;
412: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ORGANIZATION_ATTR_CONTEXT;
413: ELSIF p_attr_id = G_ORGANIZATION_ATTRIBUTE THEN

Line 412: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ORGANIZATION_ATTR_CONTEXT;

408: l_index := l_index + 1;
409: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_MULTIVAL_ATTR2_DATATYPE;
410: ELSIF p_attr_id = G_ORGANIZATION_ATTR_CONTEXT THEN
411: l_index := l_index + 1;
412: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ORGANIZATION_ATTR_CONTEXT;
413: ELSIF p_attr_id = G_ORGANIZATION_ATTRIBUTE THEN
414: l_index := l_index + 1;
415: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ORGANIZATION_ATTRIBUTE;
416: ELSIF p_attr_id = G_ORGANIZATION_ATTR_VALUE THEN

Line 415: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ORGANIZATION_ATTRIBUTE;

411: l_index := l_index + 1;
412: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ORGANIZATION_ATTR_CONTEXT;
413: ELSIF p_attr_id = G_ORGANIZATION_ATTRIBUTE THEN
414: l_index := l_index + 1;
415: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ORGANIZATION_ATTRIBUTE;
416: ELSIF p_attr_id = G_ORGANIZATION_ATTR_VALUE THEN
417: l_index := l_index + 1;
418: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ORGANIZATION_ATTR_VALUE;
419: END IF;

Line 418: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ORGANIZATION_ATTR_VALUE;

414: l_index := l_index + 1;
415: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ORGANIZATION_ATTRIBUTE;
416: ELSIF p_attr_id = G_ORGANIZATION_ATTR_VALUE THEN
417: l_index := l_index + 1;
418: l_src_attr_tbl(l_index) := QP_LIMIT_BALANCES_UTIL.G_ORGANIZATION_ATTR_VALUE;
419: END IF;
420:
421: END Clear_Dependent_Attr;
422:

Line 1889: END QP_Limit_Balances_Util;

1885: RETURN l_LIMIT_BALANCES_rec;
1886:
1887: END Get_Ids;
1888:
1889: END QP_Limit_Balances_Util;