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_ATTRS_UTIL dependencies on QP_GLOBALS

Line 19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

15: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_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_ATTRS_rec.attribute1,p_old_LIMIT_ATTRS_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_ATTRS_rec.attribute1,p_old_LIMIT_ATTRS_rec.attribute1)
33: THEN
34: l_index := l_index + 1;
35: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_ATTRIBUTE1;
36: END IF;

Line 38: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute10,p_old_LIMIT_ATTRS_rec.attribute10)

34: l_index := l_index + 1;
35: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_ATTRIBUTE1;
36: END IF;
37:
38: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute10,p_old_LIMIT_ATTRS_rec.attribute10)
39: THEN
40: l_index := l_index + 1;
41: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_ATTRIBUTE10;
42: END IF;

Line 44: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute11,p_old_LIMIT_ATTRS_rec.attribute11)

40: l_index := l_index + 1;
41: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_ATTRIBUTE10;
42: END IF;
43:
44: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute11,p_old_LIMIT_ATTRS_rec.attribute11)
45: THEN
46: l_index := l_index + 1;
47: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_ATTRIBUTE11;
48: END IF;

Line 50: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute12,p_old_LIMIT_ATTRS_rec.attribute12)

46: l_index := l_index + 1;
47: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_ATTRIBUTE11;
48: END IF;
49:
50: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute12,p_old_LIMIT_ATTRS_rec.attribute12)
51: THEN
52: l_index := l_index + 1;
53: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_ATTRIBUTE12;
54: END IF;

Line 56: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute13,p_old_LIMIT_ATTRS_rec.attribute13)

52: l_index := l_index + 1;
53: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_ATTRIBUTE12;
54: END IF;
55:
56: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute13,p_old_LIMIT_ATTRS_rec.attribute13)
57: THEN
58: l_index := l_index + 1;
59: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_ATTRIBUTE13;
60: END IF;

Line 62: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute14,p_old_LIMIT_ATTRS_rec.attribute14)

58: l_index := l_index + 1;
59: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_ATTRIBUTE13;
60: END IF;
61:
62: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute14,p_old_LIMIT_ATTRS_rec.attribute14)
63: THEN
64: l_index := l_index + 1;
65: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_ATTRIBUTE14;
66: END IF;

Line 68: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute15,p_old_LIMIT_ATTRS_rec.attribute15)

64: l_index := l_index + 1;
65: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_ATTRIBUTE14;
66: END IF;
67:
68: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute15,p_old_LIMIT_ATTRS_rec.attribute15)
69: THEN
70: l_index := l_index + 1;
71: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_ATTRIBUTE15;
72: END IF;

Line 74: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute2,p_old_LIMIT_ATTRS_rec.attribute2)

70: l_index := l_index + 1;
71: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_ATTRIBUTE15;
72: END IF;
73:
74: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute2,p_old_LIMIT_ATTRS_rec.attribute2)
75: THEN
76: l_index := l_index + 1;
77: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_ATTRIBUTE2;
78: END IF;

Line 80: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute3,p_old_LIMIT_ATTRS_rec.attribute3)

76: l_index := l_index + 1;
77: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_ATTRIBUTE2;
78: END IF;
79:
80: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute3,p_old_LIMIT_ATTRS_rec.attribute3)
81: THEN
82: l_index := l_index + 1;
83: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_ATTRIBUTE3;
84: END IF;

Line 86: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute4,p_old_LIMIT_ATTRS_rec.attribute4)

82: l_index := l_index + 1;
83: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_ATTRIBUTE3;
84: END IF;
85:
86: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute4,p_old_LIMIT_ATTRS_rec.attribute4)
87: THEN
88: l_index := l_index + 1;
89: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_ATTRIBUTE4;
90: END IF;

Line 92: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute5,p_old_LIMIT_ATTRS_rec.attribute5)

88: l_index := l_index + 1;
89: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_ATTRIBUTE4;
90: END IF;
91:
92: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute5,p_old_LIMIT_ATTRS_rec.attribute5)
93: THEN
94: l_index := l_index + 1;
95: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_ATTRIBUTE5;
96: END IF;

Line 98: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute6,p_old_LIMIT_ATTRS_rec.attribute6)

94: l_index := l_index + 1;
95: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_ATTRIBUTE5;
96: END IF;
97:
98: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute6,p_old_LIMIT_ATTRS_rec.attribute6)
99: THEN
100: l_index := l_index + 1;
101: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_ATTRIBUTE6;
102: END IF;

Line 104: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute7,p_old_LIMIT_ATTRS_rec.attribute7)

100: l_index := l_index + 1;
101: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_ATTRIBUTE6;
102: END IF;
103:
104: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute7,p_old_LIMIT_ATTRS_rec.attribute7)
105: THEN
106: l_index := l_index + 1;
107: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_ATTRIBUTE7;
108: END IF;

Line 110: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute8,p_old_LIMIT_ATTRS_rec.attribute8)

106: l_index := l_index + 1;
107: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_ATTRIBUTE7;
108: END IF;
109:
110: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute8,p_old_LIMIT_ATTRS_rec.attribute8)
111: THEN
112: l_index := l_index + 1;
113: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_ATTRIBUTE8;
114: END IF;

Line 116: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute9,p_old_LIMIT_ATTRS_rec.attribute9)

112: l_index := l_index + 1;
113: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_ATTRIBUTE8;
114: END IF;
115:
116: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute9,p_old_LIMIT_ATTRS_rec.attribute9)
117: THEN
118: l_index := l_index + 1;
119: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_ATTRIBUTE9;
120: END IF;

Line 122: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.comparison_operator_code,p_old_LIMIT_ATTRS_rec.comparison_operator_code)

118: l_index := l_index + 1;
119: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_ATTRIBUTE9;
120: END IF;
121:
122: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.comparison_operator_code,p_old_LIMIT_ATTRS_rec.comparison_operator_code)
123: THEN
124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_COMPARISON_OPERATOR;
126: END IF;

Line 128: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.context,p_old_LIMIT_ATTRS_rec.context)

124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_COMPARISON_OPERATOR;
126: END IF;
127:
128: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.context,p_old_LIMIT_ATTRS_rec.context)
129: THEN
130: l_index := l_index + 1;
131: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_CONTEXT;
132: END IF;

Line 134: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.created_by,p_old_LIMIT_ATTRS_rec.created_by)

130: l_index := l_index + 1;
131: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_CONTEXT;
132: END IF;
133:
134: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.created_by,p_old_LIMIT_ATTRS_rec.created_by)
135: THEN
136: l_index := l_index + 1;
137: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_CREATED_BY;
138: END IF;

Line 140: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.creation_date,p_old_LIMIT_ATTRS_rec.creation_date)

136: l_index := l_index + 1;
137: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_CREATED_BY;
138: END IF;
139:
140: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.creation_date,p_old_LIMIT_ATTRS_rec.creation_date)
141: THEN
142: l_index := l_index + 1;
143: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_CREATION_DATE;
144: END IF;

Line 146: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_updated_by,p_old_LIMIT_ATTRS_rec.last_updated_by)

142: l_index := l_index + 1;
143: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_CREATION_DATE;
144: END IF;
145:
146: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_updated_by,p_old_LIMIT_ATTRS_rec.last_updated_by)
147: THEN
148: l_index := l_index + 1;
149: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_LAST_UPDATED_BY;
150: END IF;

Line 152: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_update_date,p_old_LIMIT_ATTRS_rec.last_update_date)

148: l_index := l_index + 1;
149: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_LAST_UPDATED_BY;
150: END IF;
151:
152: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_update_date,p_old_LIMIT_ATTRS_rec.last_update_date)
153: THEN
154: l_index := l_index + 1;
155: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_LAST_UPDATE_DATE;
156: END IF;

Line 158: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_update_login,p_old_LIMIT_ATTRS_rec.last_update_login)

154: l_index := l_index + 1;
155: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_LAST_UPDATE_DATE;
156: END IF;
157:
158: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_update_login,p_old_LIMIT_ATTRS_rec.last_update_login)
159: THEN
160: l_index := l_index + 1;
161: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_LAST_UPDATE_LOGIN;
162: END IF;

Line 164: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute,p_old_LIMIT_ATTRS_rec.limit_attribute)

160: l_index := l_index + 1;
161: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_LAST_UPDATE_LOGIN;
162: END IF;
163:
164: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute,p_old_LIMIT_ATTRS_rec.limit_attribute)
165: THEN
166: l_index := l_index + 1;
167: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_LIMIT_ATTRIBUTE;
168: END IF;

Line 170: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_context,p_old_LIMIT_ATTRS_rec.limit_attribute_context)

166: l_index := l_index + 1;
167: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_LIMIT_ATTRIBUTE;
168: END IF;
169:
170: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_context,p_old_LIMIT_ATTRS_rec.limit_attribute_context)
171: THEN
172: l_index := l_index + 1;
173: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_LIMIT_ATTRIBUTE_CONTEXT;
174: END IF;

Line 176: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_id,p_old_LIMIT_ATTRS_rec.limit_attribute_id)

172: l_index := l_index + 1;
173: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_LIMIT_ATTRIBUTE_CONTEXT;
174: END IF;
175:
176: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_id,p_old_LIMIT_ATTRS_rec.limit_attribute_id)
177: THEN
178: l_index := l_index + 1;
179: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_LIMIT_ATTRIBUTE;
180: END IF;

Line 183: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_type,p_old_LIMIT_ATTRS_rec.limit_attribute_type)

179: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_LIMIT_ATTRIBUTE;
180: END IF;
181:
182:
183: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_type,p_old_LIMIT_ATTRS_rec.limit_attribute_type)
184: THEN
185: l_index := l_index + 1;
186: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_LIMIT_ATTRIBUTE_TYPE;
187: END IF;

Line 189: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attr_datatype,p_old_LIMIT_ATTRS_rec.limit_attr_datatype)

185: l_index := l_index + 1;
186: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_LIMIT_ATTRIBUTE_TYPE;
187: END IF;
188:
189: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attr_datatype,p_old_LIMIT_ATTRS_rec.limit_attr_datatype)
190: THEN
191: l_index := l_index + 1;
192: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_LIMIT_ATTR_DATATYPE;
193: END IF;

Line 195: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attr_value,p_old_LIMIT_ATTRS_rec.limit_attr_value)

191: l_index := l_index + 1;
192: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_LIMIT_ATTR_DATATYPE;
193: END IF;
194:
195: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attr_value,p_old_LIMIT_ATTRS_rec.limit_attr_value)
196: THEN
197: l_index := l_index + 1;
198: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_LIMIT_ATTR_VALUE;
199: END IF;

Line 201: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_id,p_old_LIMIT_ATTRS_rec.limit_id)

197: l_index := l_index + 1;
198: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_LIMIT_ATTR_VALUE;
199: END IF;
200:
201: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_id,p_old_LIMIT_ATTRS_rec.limit_id)
202: THEN
203: l_index := l_index + 1;
204: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_LIMIT;
205: END IF;

Line 207: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.program_application_id,p_old_LIMIT_ATTRS_rec.program_application_id)

203: l_index := l_index + 1;
204: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_LIMIT;
205: END IF;
206:
207: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.program_application_id,p_old_LIMIT_ATTRS_rec.program_application_id)
208: THEN
209: l_index := l_index + 1;
210: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_PROGRAM_APPLICATION;
211: END IF;

Line 213: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.program_id,p_old_LIMIT_ATTRS_rec.program_id)

209: l_index := l_index + 1;
210: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_PROGRAM_APPLICATION;
211: END IF;
212:
213: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.program_id,p_old_LIMIT_ATTRS_rec.program_id)
214: THEN
215: l_index := l_index + 1;
216: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_PROGRAM;
217: END IF;

Line 219: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.program_update_date,p_old_LIMIT_ATTRS_rec.program_update_date)

215: l_index := l_index + 1;
216: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_PROGRAM;
217: END IF;
218:
219: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.program_update_date,p_old_LIMIT_ATTRS_rec.program_update_date)
220: THEN
221: l_index := l_index + 1;
222: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_PROGRAM_UPDATE_DATE;
223: END IF;

Line 225: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.request_id,p_old_LIMIT_ATTRS_rec.request_id)

221: l_index := l_index + 1;
222: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_PROGRAM_UPDATE_DATE;
223: END IF;
224:
225: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.request_id,p_old_LIMIT_ATTRS_rec.request_id)
226: THEN
227: l_index := l_index + 1;
228: l_src_attr_tbl(l_index) := QP_LIMIT_ATTRS_UTIL.G_REQUEST;
229: END IF;

Line 350: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute1,p_old_LIMIT_ATTRS_rec.attribute1)

346: -- Load out record
347:
348: x_LIMIT_ATTRS_rec := p_LIMIT_ATTRS_rec;
349:
350: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute1,p_old_LIMIT_ATTRS_rec.attribute1)
351: THEN
352: NULL;
353: END IF;
354:

Line 355: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute10,p_old_LIMIT_ATTRS_rec.attribute10)

351: THEN
352: NULL;
353: END IF;
354:
355: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute10,p_old_LIMIT_ATTRS_rec.attribute10)
356: THEN
357: NULL;
358: END IF;
359:

Line 360: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute11,p_old_LIMIT_ATTRS_rec.attribute11)

356: THEN
357: NULL;
358: END IF;
359:
360: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute11,p_old_LIMIT_ATTRS_rec.attribute11)
361: THEN
362: NULL;
363: END IF;
364:

Line 365: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute12,p_old_LIMIT_ATTRS_rec.attribute12)

361: THEN
362: NULL;
363: END IF;
364:
365: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute12,p_old_LIMIT_ATTRS_rec.attribute12)
366: THEN
367: NULL;
368: END IF;
369:

Line 370: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute13,p_old_LIMIT_ATTRS_rec.attribute13)

366: THEN
367: NULL;
368: END IF;
369:
370: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute13,p_old_LIMIT_ATTRS_rec.attribute13)
371: THEN
372: NULL;
373: END IF;
374:

Line 375: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute14,p_old_LIMIT_ATTRS_rec.attribute14)

371: THEN
372: NULL;
373: END IF;
374:
375: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute14,p_old_LIMIT_ATTRS_rec.attribute14)
376: THEN
377: NULL;
378: END IF;
379:

Line 380: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute15,p_old_LIMIT_ATTRS_rec.attribute15)

376: THEN
377: NULL;
378: END IF;
379:
380: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute15,p_old_LIMIT_ATTRS_rec.attribute15)
381: THEN
382: NULL;
383: END IF;
384:

Line 385: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute2,p_old_LIMIT_ATTRS_rec.attribute2)

381: THEN
382: NULL;
383: END IF;
384:
385: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute2,p_old_LIMIT_ATTRS_rec.attribute2)
386: THEN
387: NULL;
388: END IF;
389:

Line 390: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute3,p_old_LIMIT_ATTRS_rec.attribute3)

386: THEN
387: NULL;
388: END IF;
389:
390: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute3,p_old_LIMIT_ATTRS_rec.attribute3)
391: THEN
392: NULL;
393: END IF;
394:

Line 395: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute4,p_old_LIMIT_ATTRS_rec.attribute4)

391: THEN
392: NULL;
393: END IF;
394:
395: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute4,p_old_LIMIT_ATTRS_rec.attribute4)
396: THEN
397: NULL;
398: END IF;
399:

Line 400: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute5,p_old_LIMIT_ATTRS_rec.attribute5)

396: THEN
397: NULL;
398: END IF;
399:
400: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute5,p_old_LIMIT_ATTRS_rec.attribute5)
401: THEN
402: NULL;
403: END IF;
404:

Line 405: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute6,p_old_LIMIT_ATTRS_rec.attribute6)

401: THEN
402: NULL;
403: END IF;
404:
405: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute6,p_old_LIMIT_ATTRS_rec.attribute6)
406: THEN
407: NULL;
408: END IF;
409:

Line 410: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute7,p_old_LIMIT_ATTRS_rec.attribute7)

406: THEN
407: NULL;
408: END IF;
409:
410: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute7,p_old_LIMIT_ATTRS_rec.attribute7)
411: THEN
412: NULL;
413: END IF;
414:

Line 415: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute8,p_old_LIMIT_ATTRS_rec.attribute8)

411: THEN
412: NULL;
413: END IF;
414:
415: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute8,p_old_LIMIT_ATTRS_rec.attribute8)
416: THEN
417: NULL;
418: END IF;
419:

Line 420: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute9,p_old_LIMIT_ATTRS_rec.attribute9)

416: THEN
417: NULL;
418: END IF;
419:
420: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute9,p_old_LIMIT_ATTRS_rec.attribute9)
421: THEN
422: NULL;
423: END IF;
424:

Line 425: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.comparison_operator_code,p_old_LIMIT_ATTRS_rec.comparison_operator_code)

421: THEN
422: NULL;
423: END IF;
424:
425: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.comparison_operator_code,p_old_LIMIT_ATTRS_rec.comparison_operator_code)
426: THEN
427: NULL;
428: END IF;
429:

Line 430: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.context,p_old_LIMIT_ATTRS_rec.context)

426: THEN
427: NULL;
428: END IF;
429:
430: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.context,p_old_LIMIT_ATTRS_rec.context)
431: THEN
432: NULL;
433: END IF;
434:

Line 435: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.created_by,p_old_LIMIT_ATTRS_rec.created_by)

431: THEN
432: NULL;
433: END IF;
434:
435: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.created_by,p_old_LIMIT_ATTRS_rec.created_by)
436: THEN
437: NULL;
438: END IF;
439:

Line 440: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.creation_date,p_old_LIMIT_ATTRS_rec.creation_date)

436: THEN
437: NULL;
438: END IF;
439:
440: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.creation_date,p_old_LIMIT_ATTRS_rec.creation_date)
441: THEN
442: NULL;
443: END IF;
444:

Line 445: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_updated_by,p_old_LIMIT_ATTRS_rec.last_updated_by)

441: THEN
442: NULL;
443: END IF;
444:
445: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_updated_by,p_old_LIMIT_ATTRS_rec.last_updated_by)
446: THEN
447: NULL;
448: END IF;
449:

Line 450: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_update_date,p_old_LIMIT_ATTRS_rec.last_update_date)

446: THEN
447: NULL;
448: END IF;
449:
450: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_update_date,p_old_LIMIT_ATTRS_rec.last_update_date)
451: THEN
452: NULL;
453: END IF;
454:

Line 455: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_update_login,p_old_LIMIT_ATTRS_rec.last_update_login)

451: THEN
452: NULL;
453: END IF;
454:
455: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_update_login,p_old_LIMIT_ATTRS_rec.last_update_login)
456: THEN
457: NULL;
458: END IF;
459:

Line 460: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute,p_old_LIMIT_ATTRS_rec.limit_attribute)

456: THEN
457: NULL;
458: END IF;
459:
460: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute,p_old_LIMIT_ATTRS_rec.limit_attribute)
461: THEN
462: NULL;
463: END IF;
464:

Line 465: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_context,p_old_LIMIT_ATTRS_rec.limit_attribute_context)

461: THEN
462: NULL;
463: END IF;
464:
465: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_context,p_old_LIMIT_ATTRS_rec.limit_attribute_context)
466: THEN
467: NULL;
468: END IF;
469:

Line 470: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_id,p_old_LIMIT_ATTRS_rec.limit_attribute_id)

466: THEN
467: NULL;
468: END IF;
469:
470: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_id,p_old_LIMIT_ATTRS_rec.limit_attribute_id)
471: THEN
472: NULL;
473: END IF;
474:

Line 475: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_type,p_old_LIMIT_ATTRS_rec.limit_attribute_type)

471: THEN
472: NULL;
473: END IF;
474:
475: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_type,p_old_LIMIT_ATTRS_rec.limit_attribute_type)
476: THEN
477: NULL;
478: END IF;
479:

Line 480: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attr_datatype,p_old_LIMIT_ATTRS_rec.limit_attr_datatype)

476: THEN
477: NULL;
478: END IF;
479:
480: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attr_datatype,p_old_LIMIT_ATTRS_rec.limit_attr_datatype)
481: THEN
482: NULL;
483: END IF;
484:

Line 485: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attr_value,p_old_LIMIT_ATTRS_rec.limit_attr_value)

481: THEN
482: NULL;
483: END IF;
484:
485: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attr_value,p_old_LIMIT_ATTRS_rec.limit_attr_value)
486: THEN
487: NULL;
488: END IF;
489:

Line 490: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_id,p_old_LIMIT_ATTRS_rec.limit_id)

486: THEN
487: NULL;
488: END IF;
489:
490: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_id,p_old_LIMIT_ATTRS_rec.limit_id)
491: THEN
492: NULL;
493: END IF;
494:

Line 495: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.program_application_id,p_old_LIMIT_ATTRS_rec.program_application_id)

491: THEN
492: NULL;
493: END IF;
494:
495: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.program_application_id,p_old_LIMIT_ATTRS_rec.program_application_id)
496: THEN
497: NULL;
498: END IF;
499:

Line 500: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.program_id,p_old_LIMIT_ATTRS_rec.program_id)

496: THEN
497: NULL;
498: END IF;
499:
500: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.program_id,p_old_LIMIT_ATTRS_rec.program_id)
501: THEN
502: NULL;
503: END IF;
504:

Line 505: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.program_update_date,p_old_LIMIT_ATTRS_rec.program_update_date)

501: THEN
502: NULL;
503: END IF;
504:
505: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.program_update_date,p_old_LIMIT_ATTRS_rec.program_update_date)
506: THEN
507: NULL;
508: END IF;
509:

Line 510: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.request_id,p_old_LIMIT_ATTRS_rec.request_id)

506: THEN
507: NULL;
508: END IF;
509:
510: IF NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.request_id,p_old_LIMIT_ATTRS_rec.request_id)
511: THEN
512: NULL;
513: END IF;
514:

Line 1300: IF QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute1,

1296: FOR UPDATE NOWAIT;
1297:
1298: -- Row locked. Compare IN attributes to DB attributes.
1299:
1300: IF QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute1,
1301: l_LIMIT_ATTRS_rec.attribute1)
1302: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute10,
1303: l_LIMIT_ATTRS_rec.attribute10)
1304: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute11,

Line 1302: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute10,

1298: -- Row locked. Compare IN attributes to DB attributes.
1299:
1300: IF QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute1,
1301: l_LIMIT_ATTRS_rec.attribute1)
1302: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute10,
1303: l_LIMIT_ATTRS_rec.attribute10)
1304: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute11,
1305: l_LIMIT_ATTRS_rec.attribute11)
1306: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute12,

Line 1304: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute11,

1300: IF QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute1,
1301: l_LIMIT_ATTRS_rec.attribute1)
1302: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute10,
1303: l_LIMIT_ATTRS_rec.attribute10)
1304: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute11,
1305: l_LIMIT_ATTRS_rec.attribute11)
1306: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute12,
1307: l_LIMIT_ATTRS_rec.attribute12)
1308: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute13,

Line 1306: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute12,

1302: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute10,
1303: l_LIMIT_ATTRS_rec.attribute10)
1304: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute11,
1305: l_LIMIT_ATTRS_rec.attribute11)
1306: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute12,
1307: l_LIMIT_ATTRS_rec.attribute12)
1308: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute13,
1309: l_LIMIT_ATTRS_rec.attribute13)
1310: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute14,

Line 1308: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute13,

1304: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute11,
1305: l_LIMIT_ATTRS_rec.attribute11)
1306: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute12,
1307: l_LIMIT_ATTRS_rec.attribute12)
1308: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute13,
1309: l_LIMIT_ATTRS_rec.attribute13)
1310: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute14,
1311: l_LIMIT_ATTRS_rec.attribute14)
1312: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute15,

Line 1310: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute14,

1306: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute12,
1307: l_LIMIT_ATTRS_rec.attribute12)
1308: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute13,
1309: l_LIMIT_ATTRS_rec.attribute13)
1310: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute14,
1311: l_LIMIT_ATTRS_rec.attribute14)
1312: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute15,
1313: l_LIMIT_ATTRS_rec.attribute15)
1314: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute2,

Line 1312: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute15,

1308: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute13,
1309: l_LIMIT_ATTRS_rec.attribute13)
1310: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute14,
1311: l_LIMIT_ATTRS_rec.attribute14)
1312: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute15,
1313: l_LIMIT_ATTRS_rec.attribute15)
1314: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute2,
1315: l_LIMIT_ATTRS_rec.attribute2)
1316: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute3,

Line 1314: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute2,

1310: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute14,
1311: l_LIMIT_ATTRS_rec.attribute14)
1312: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute15,
1313: l_LIMIT_ATTRS_rec.attribute15)
1314: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute2,
1315: l_LIMIT_ATTRS_rec.attribute2)
1316: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute3,
1317: l_LIMIT_ATTRS_rec.attribute3)
1318: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute4,

Line 1316: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute3,

1312: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute15,
1313: l_LIMIT_ATTRS_rec.attribute15)
1314: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute2,
1315: l_LIMIT_ATTRS_rec.attribute2)
1316: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute3,
1317: l_LIMIT_ATTRS_rec.attribute3)
1318: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute4,
1319: l_LIMIT_ATTRS_rec.attribute4)
1320: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute5,

Line 1318: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute4,

1314: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute2,
1315: l_LIMIT_ATTRS_rec.attribute2)
1316: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute3,
1317: l_LIMIT_ATTRS_rec.attribute3)
1318: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute4,
1319: l_LIMIT_ATTRS_rec.attribute4)
1320: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute5,
1321: l_LIMIT_ATTRS_rec.attribute5)
1322: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute6,

Line 1320: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute5,

1316: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute3,
1317: l_LIMIT_ATTRS_rec.attribute3)
1318: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute4,
1319: l_LIMIT_ATTRS_rec.attribute4)
1320: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute5,
1321: l_LIMIT_ATTRS_rec.attribute5)
1322: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute6,
1323: l_LIMIT_ATTRS_rec.attribute6)
1324: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute7,

Line 1322: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute6,

1318: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute4,
1319: l_LIMIT_ATTRS_rec.attribute4)
1320: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute5,
1321: l_LIMIT_ATTRS_rec.attribute5)
1322: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute6,
1323: l_LIMIT_ATTRS_rec.attribute6)
1324: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute7,
1325: l_LIMIT_ATTRS_rec.attribute7)
1326: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute8,

Line 1324: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute7,

1320: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute5,
1321: l_LIMIT_ATTRS_rec.attribute5)
1322: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute6,
1323: l_LIMIT_ATTRS_rec.attribute6)
1324: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute7,
1325: l_LIMIT_ATTRS_rec.attribute7)
1326: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute8,
1327: l_LIMIT_ATTRS_rec.attribute8)
1328: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute9,

Line 1326: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute8,

1322: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute6,
1323: l_LIMIT_ATTRS_rec.attribute6)
1324: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute7,
1325: l_LIMIT_ATTRS_rec.attribute7)
1326: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute8,
1327: l_LIMIT_ATTRS_rec.attribute8)
1328: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute9,
1329: l_LIMIT_ATTRS_rec.attribute9)
1330: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.comparison_operator_code,

Line 1328: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute9,

1324: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute7,
1325: l_LIMIT_ATTRS_rec.attribute7)
1326: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute8,
1327: l_LIMIT_ATTRS_rec.attribute8)
1328: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute9,
1329: l_LIMIT_ATTRS_rec.attribute9)
1330: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.comparison_operator_code,
1331: l_LIMIT_ATTRS_rec.comparison_operator_code)
1332: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.context,

Line 1330: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.comparison_operator_code,

1326: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute8,
1327: l_LIMIT_ATTRS_rec.attribute8)
1328: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute9,
1329: l_LIMIT_ATTRS_rec.attribute9)
1330: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.comparison_operator_code,
1331: l_LIMIT_ATTRS_rec.comparison_operator_code)
1332: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.context,
1333: l_LIMIT_ATTRS_rec.context)
1334: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.created_by,

Line 1332: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.context,

1328: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.attribute9,
1329: l_LIMIT_ATTRS_rec.attribute9)
1330: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.comparison_operator_code,
1331: l_LIMIT_ATTRS_rec.comparison_operator_code)
1332: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.context,
1333: l_LIMIT_ATTRS_rec.context)
1334: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.created_by,
1335: l_LIMIT_ATTRS_rec.created_by)
1336: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.creation_date,

Line 1334: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.created_by,

1330: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.comparison_operator_code,
1331: l_LIMIT_ATTRS_rec.comparison_operator_code)
1332: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.context,
1333: l_LIMIT_ATTRS_rec.context)
1334: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.created_by,
1335: l_LIMIT_ATTRS_rec.created_by)
1336: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.creation_date,
1337: l_LIMIT_ATTRS_rec.creation_date)
1338: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_updated_by,

Line 1336: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.creation_date,

1332: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.context,
1333: l_LIMIT_ATTRS_rec.context)
1334: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.created_by,
1335: l_LIMIT_ATTRS_rec.created_by)
1336: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.creation_date,
1337: l_LIMIT_ATTRS_rec.creation_date)
1338: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_updated_by,
1339: l_LIMIT_ATTRS_rec.last_updated_by)
1340: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_update_date,

Line 1338: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_updated_by,

1334: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.created_by,
1335: l_LIMIT_ATTRS_rec.created_by)
1336: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.creation_date,
1337: l_LIMIT_ATTRS_rec.creation_date)
1338: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_updated_by,
1339: l_LIMIT_ATTRS_rec.last_updated_by)
1340: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_update_date,
1341: l_LIMIT_ATTRS_rec.last_update_date)
1342: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_update_login,

Line 1340: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_update_date,

1336: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.creation_date,
1337: l_LIMIT_ATTRS_rec.creation_date)
1338: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_updated_by,
1339: l_LIMIT_ATTRS_rec.last_updated_by)
1340: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_update_date,
1341: l_LIMIT_ATTRS_rec.last_update_date)
1342: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_update_login,
1343: l_LIMIT_ATTRS_rec.last_update_login)
1344: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute,

Line 1342: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_update_login,

1338: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_updated_by,
1339: l_LIMIT_ATTRS_rec.last_updated_by)
1340: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_update_date,
1341: l_LIMIT_ATTRS_rec.last_update_date)
1342: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_update_login,
1343: l_LIMIT_ATTRS_rec.last_update_login)
1344: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute,
1345: l_LIMIT_ATTRS_rec.limit_attribute)
1346: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_context,

Line 1344: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute,

1340: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_update_date,
1341: l_LIMIT_ATTRS_rec.last_update_date)
1342: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_update_login,
1343: l_LIMIT_ATTRS_rec.last_update_login)
1344: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute,
1345: l_LIMIT_ATTRS_rec.limit_attribute)
1346: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_context,
1347: l_LIMIT_ATTRS_rec.limit_attribute_context)
1348: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_id,

Line 1346: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_context,

1342: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.last_update_login,
1343: l_LIMIT_ATTRS_rec.last_update_login)
1344: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute,
1345: l_LIMIT_ATTRS_rec.limit_attribute)
1346: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_context,
1347: l_LIMIT_ATTRS_rec.limit_attribute_context)
1348: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_id,
1349: l_LIMIT_ATTRS_rec.limit_attribute_id)
1350: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_type,

Line 1348: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_id,

1344: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute,
1345: l_LIMIT_ATTRS_rec.limit_attribute)
1346: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_context,
1347: l_LIMIT_ATTRS_rec.limit_attribute_context)
1348: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_id,
1349: l_LIMIT_ATTRS_rec.limit_attribute_id)
1350: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_type,
1351: l_LIMIT_ATTRS_rec.limit_attribute_type)
1352: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attr_datatype,

Line 1350: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_type,

1346: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_context,
1347: l_LIMIT_ATTRS_rec.limit_attribute_context)
1348: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_id,
1349: l_LIMIT_ATTRS_rec.limit_attribute_id)
1350: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_type,
1351: l_LIMIT_ATTRS_rec.limit_attribute_type)
1352: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attr_datatype,
1353: l_LIMIT_ATTRS_rec.limit_attr_datatype)
1354: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attr_value,

Line 1352: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attr_datatype,

1348: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_id,
1349: l_LIMIT_ATTRS_rec.limit_attribute_id)
1350: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_type,
1351: l_LIMIT_ATTRS_rec.limit_attribute_type)
1352: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attr_datatype,
1353: l_LIMIT_ATTRS_rec.limit_attr_datatype)
1354: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attr_value,
1355: l_LIMIT_ATTRS_rec.limit_attr_value)
1356: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_id,

Line 1354: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attr_value,

1350: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_type,
1351: l_LIMIT_ATTRS_rec.limit_attribute_type)
1352: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attr_datatype,
1353: l_LIMIT_ATTRS_rec.limit_attr_datatype)
1354: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attr_value,
1355: l_LIMIT_ATTRS_rec.limit_attr_value)
1356: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_id,
1357: l_LIMIT_ATTRS_rec.limit_id)
1358: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.program_application_id,

Line 1356: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_id,

1352: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attr_datatype,
1353: l_LIMIT_ATTRS_rec.limit_attr_datatype)
1354: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attr_value,
1355: l_LIMIT_ATTRS_rec.limit_attr_value)
1356: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_id,
1357: l_LIMIT_ATTRS_rec.limit_id)
1358: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.program_application_id,
1359: l_LIMIT_ATTRS_rec.program_application_id)
1360: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.program_id,

Line 1358: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.program_application_id,

1354: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attr_value,
1355: l_LIMIT_ATTRS_rec.limit_attr_value)
1356: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_id,
1357: l_LIMIT_ATTRS_rec.limit_id)
1358: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.program_application_id,
1359: l_LIMIT_ATTRS_rec.program_application_id)
1360: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.program_id,
1361: l_LIMIT_ATTRS_rec.program_id)
1362: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.program_update_date,

Line 1360: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.program_id,

1356: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_id,
1357: l_LIMIT_ATTRS_rec.limit_id)
1358: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.program_application_id,
1359: l_LIMIT_ATTRS_rec.program_application_id)
1360: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.program_id,
1361: l_LIMIT_ATTRS_rec.program_id)
1362: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.program_update_date,
1363: l_LIMIT_ATTRS_rec.program_update_date)
1364: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.request_id,

Line 1362: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.program_update_date,

1358: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.program_application_id,
1359: l_LIMIT_ATTRS_rec.program_application_id)
1360: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.program_id,
1361: l_LIMIT_ATTRS_rec.program_id)
1362: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.program_update_date,
1363: l_LIMIT_ATTRS_rec.program_update_date)
1364: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.request_id,
1365: l_LIMIT_ATTRS_rec.request_id)
1366: THEN

Line 1364: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.request_id,

1360: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.program_id,
1361: l_LIMIT_ATTRS_rec.program_id)
1362: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.program_update_date,
1363: l_LIMIT_ATTRS_rec.program_update_date)
1364: AND QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.request_id,
1365: l_LIMIT_ATTRS_rec.request_id)
1366: THEN
1367:
1368: -- Row has not changed. Set out parameter.

Line 1448: NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.comparison_operator_code,

1444: BEGIN
1445:
1446: IF p_LIMIT_ATTRS_rec.comparison_operator_code IS NOT NULL AND
1447: p_LIMIT_ATTRS_rec.comparison_operator_code <> FND_API.G_MISS_CHAR AND
1448: NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.comparison_operator_code,
1449: p_old_LIMIT_ATTRS_rec.comparison_operator_code)
1450: THEN
1451: l_LIMIT_ATTRS_val_rec.comparison_operator := QP_Id_To_Value.Comparison_Operator
1452: ( p_comparison_operator_code => p_LIMIT_ATTRS_rec.comparison_operator_code

Line 1458: NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_id,

1454: END IF;
1455:
1456: IF p_LIMIT_ATTRS_rec.limit_attribute_id IS NOT NULL AND
1457: p_LIMIT_ATTRS_rec.limit_attribute_id <> FND_API.G_MISS_NUM AND
1458: NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_attribute_id,
1459: p_old_LIMIT_ATTRS_rec.limit_attribute_id)
1460: THEN
1461: l_LIMIT_ATTRS_val_rec.limit_attribute := QP_Id_To_Value.Limit_Attribute
1462: ( p_limit_attribute_id => p_LIMIT_ATTRS_rec.limit_attribute_id

Line 1468: NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_id,

1464: END IF;
1465:
1466: IF p_LIMIT_ATTRS_rec.limit_id IS NOT NULL AND
1467: p_LIMIT_ATTRS_rec.limit_id <> FND_API.G_MISS_NUM AND
1468: NOT QP_GLOBALS.Equal(p_LIMIT_ATTRS_rec.limit_id,
1469: p_old_LIMIT_ATTRS_rec.limit_id)
1470: THEN
1471: l_LIMIT_ATTRS_val_rec.limit := QP_Id_To_Value.Limit
1472: ( p_limit_id => p_LIMIT_ATTRS_rec.limit_id

Line 1609: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1605:
1606:
1607: qp_delayed_requests_PVT.log_request
1608: (
1609: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1610: p_entity_id => p_LIMIT_ATTRS_rec.limit_id,
1611: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
1612: p_requesting_entity_id => p_LIMIT_ATTRS_rec.limit_id,
1613: p_request_type => QP_GLOBALS.G_UPDATE_LIMITS_COLUMNS,

Line 1611: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,

1607: qp_delayed_requests_PVT.log_request
1608: (
1609: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1610: p_entity_id => p_LIMIT_ATTRS_rec.limit_id,
1611: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
1612: p_requesting_entity_id => p_LIMIT_ATTRS_rec.limit_id,
1613: p_request_type => QP_GLOBALS.G_UPDATE_LIMITS_COLUMNS,
1614: x_return_status => l_return_status
1615: );

Line 1613: p_request_type => QP_GLOBALS.G_UPDATE_LIMITS_COLUMNS,

1609: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1610: p_entity_id => p_LIMIT_ATTRS_rec.limit_id,
1611: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
1612: p_requesting_entity_id => p_LIMIT_ATTRS_rec.limit_id,
1613: p_request_type => QP_GLOBALS.G_UPDATE_LIMITS_COLUMNS,
1614: x_return_status => l_return_status
1615: );
1616:
1617: x_LIMIT_ATTRS_rec := l_LIMIT_ATTRS_rec;