DBA Data[Home] [Help]

APPS.QP_RQT_UTIL dependencies on QP_GLOBALS

Line 19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

15: , x_RQT_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_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_RQT_rec.attribute1,p_old_RQT_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_RQT_rec.attribute1,p_old_RQT_rec.attribute1)
33: THEN
34: l_index := l_index + 1;
35: l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_ATTRIBUTE1;
36: END IF;

Line 38: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute10,p_old_RQT_rec.attribute10)

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

Line 44: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute11,p_old_RQT_rec.attribute11)

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

Line 50: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute12,p_old_RQT_rec.attribute12)

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

Line 56: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute13,p_old_RQT_rec.attribute13)

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

Line 62: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute14,p_old_RQT_rec.attribute14)

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

Line 68: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute15,p_old_RQT_rec.attribute15)

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

Line 74: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute2,p_old_RQT_rec.attribute2)

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

Line 80: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute3,p_old_RQT_rec.attribute3)

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

Line 86: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute4,p_old_RQT_rec.attribute4)

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

Line 92: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute5,p_old_RQT_rec.attribute5)

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

Line 98: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute6,p_old_RQT_rec.attribute6)

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

Line 104: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute7,p_old_RQT_rec.attribute7)

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

Line 110: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute8,p_old_RQT_rec.attribute8)

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

Line 116: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute9,p_old_RQT_rec.attribute9)

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

Line 122: IF NOT QP_GLOBALS.Equal(p_RQT_rec.context,p_old_RQT_rec.context)

118: l_index := l_index + 1;
119: l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_ATTRIBUTE9;
120: END IF;
121:
122: IF NOT QP_GLOBALS.Equal(p_RQT_rec.context,p_old_RQT_rec.context)
123: THEN
124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_CONTEXT;
126: END IF;

Line 128: IF NOT QP_GLOBALS.Equal(p_RQT_rec.created_by,p_old_RQT_rec.created_by)

124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_CONTEXT;
126: END IF;
127:
128: IF NOT QP_GLOBALS.Equal(p_RQT_rec.created_by,p_old_RQT_rec.created_by)
129: THEN
130: l_index := l_index + 1;
131: l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_CREATED_BY;
132: END IF;

Line 134: IF NOT QP_GLOBALS.Equal(p_RQT_rec.creation_date,p_old_RQT_rec.creation_date)

130: l_index := l_index + 1;
131: l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_CREATED_BY;
132: END IF;
133:
134: IF NOT QP_GLOBALS.Equal(p_RQT_rec.creation_date,p_old_RQT_rec.creation_date)
135: THEN
136: l_index := l_index + 1;
137: l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_CREATION_DATE;
138: END IF;

Line 140: IF NOT QP_GLOBALS.Equal(p_RQT_rec.enabled_flag,p_old_RQT_rec.enabled_flag)

136: l_index := l_index + 1;
137: l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_CREATION_DATE;
138: END IF;
139:
140: IF NOT QP_GLOBALS.Equal(p_RQT_rec.enabled_flag,p_old_RQT_rec.enabled_flag)
141: THEN
142: l_index := l_index + 1;
143: l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_ENABLED;
144: END IF;

Line 146: IF NOT QP_GLOBALS.Equal(p_RQT_rec.last_updated_by,p_old_RQT_rec.last_updated_by)

142: l_index := l_index + 1;
143: l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_ENABLED;
144: END IF;
145:
146: IF NOT QP_GLOBALS.Equal(p_RQT_rec.last_updated_by,p_old_RQT_rec.last_updated_by)
147: THEN
148: l_index := l_index + 1;
149: l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_LAST_UPDATED_BY;
150: END IF;

Line 152: IF NOT QP_GLOBALS.Equal(p_RQT_rec.last_update_date,p_old_RQT_rec.last_update_date)

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

Line 158: IF NOT QP_GLOBALS.Equal(p_RQT_rec.last_update_login,p_old_RQT_rec.last_update_login)

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

Line 164: IF NOT QP_GLOBALS.Equal(p_RQT_rec.line_level_global_struct,p_old_RQT_rec.line_level_global_struct)

160: l_index := l_index + 1;
161: l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_LAST_UPDATE_LOGIN;
162: END IF;
163:
164: IF NOT QP_GLOBALS.Equal(p_RQT_rec.line_level_global_struct,p_old_RQT_rec.line_level_global_struct)
165: THEN
166: l_index := l_index + 1;
167: l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_LINE_LEVEL_GLOBAL_STRUCT;
168: END IF;

Line 170: IF NOT QP_GLOBALS.Equal(p_RQT_rec.line_level_view_name,p_old_RQT_rec.line_level_view_name)

166: l_index := l_index + 1;
167: l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_LINE_LEVEL_GLOBAL_STRUCT;
168: END IF;
169:
170: IF NOT QP_GLOBALS.Equal(p_RQT_rec.line_level_view_name,p_old_RQT_rec.line_level_view_name)
171: THEN
172: l_index := l_index + 1;
173: l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_LINE_LEVEL_VIEW_NAME;
174: END IF;

Line 176: IF NOT QP_GLOBALS.Equal(p_RQT_rec.order_level_global_struct,p_old_RQT_rec.order_level_global_struct)

172: l_index := l_index + 1;
173: l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_LINE_LEVEL_VIEW_NAME;
174: END IF;
175:
176: IF NOT QP_GLOBALS.Equal(p_RQT_rec.order_level_global_struct,p_old_RQT_rec.order_level_global_struct)
177: THEN
178: l_index := l_index + 1;
179: l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_ORDER_LEVEL_GLOBAL_STRUCT;
180: END IF;

Line 182: IF NOT QP_GLOBALS.Equal(p_RQT_rec.order_level_view_name,p_old_RQT_rec.order_level_view_name)

178: l_index := l_index + 1;
179: l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_ORDER_LEVEL_GLOBAL_STRUCT;
180: END IF;
181:
182: IF NOT QP_GLOBALS.Equal(p_RQT_rec.order_level_view_name,p_old_RQT_rec.order_level_view_name)
183: THEN
184: l_index := l_index + 1;
185: l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_ORDER_LEVEL_VIEW_NAME;
186: END IF;

Line 188: IF NOT QP_GLOBALS.Equal(p_RQT_rec.program_application_id,p_old_RQT_rec.program_application_id)

184: l_index := l_index + 1;
185: l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_ORDER_LEVEL_VIEW_NAME;
186: END IF;
187:
188: IF NOT QP_GLOBALS.Equal(p_RQT_rec.program_application_id,p_old_RQT_rec.program_application_id)
189: THEN
190: l_index := l_index + 1;
191: l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_PROGRAM_APPLICATION;
192: END IF;

Line 194: IF NOT QP_GLOBALS.Equal(p_RQT_rec.program_id,p_old_RQT_rec.program_id)

190: l_index := l_index + 1;
191: l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_PROGRAM_APPLICATION;
192: END IF;
193:
194: IF NOT QP_GLOBALS.Equal(p_RQT_rec.program_id,p_old_RQT_rec.program_id)
195: THEN
196: l_index := l_index + 1;
197: l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_PROGRAM;
198: END IF;

Line 200: IF NOT QP_GLOBALS.Equal(p_RQT_rec.program_update_date,p_old_RQT_rec.program_update_date)

196: l_index := l_index + 1;
197: l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_PROGRAM;
198: END IF;
199:
200: IF NOT QP_GLOBALS.Equal(p_RQT_rec.program_update_date,p_old_RQT_rec.program_update_date)
201: THEN
202: l_index := l_index + 1;
203: l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_PROGRAM_UPDATE_DATE;
204: END IF;

Line 206: IF NOT QP_GLOBALS.Equal(p_RQT_rec.pte_code,p_old_RQT_rec.pte_code)

202: l_index := l_index + 1;
203: l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_PROGRAM_UPDATE_DATE;
204: END IF;
205:
206: IF NOT QP_GLOBALS.Equal(p_RQT_rec.pte_code,p_old_RQT_rec.pte_code)
207: THEN
208: l_index := l_index + 1;
209: l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_PTE;
210: END IF;

Line 212: IF NOT QP_GLOBALS.Equal(p_RQT_rec.request_type_code,p_old_RQT_rec.request_type_code)

208: l_index := l_index + 1;
209: l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_PTE;
210: END IF;
211:
212: IF NOT QP_GLOBALS.Equal(p_RQT_rec.request_type_code,p_old_RQT_rec.request_type_code)
213: THEN
214: l_index := l_index + 1;
215: l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_REQUEST_TYPE;
216: END IF;

Line 218: IF NOT QP_GLOBALS.Equal(p_RQT_rec.request_type_desc,p_old_RQT_rec.request_type_desc)

214: l_index := l_index + 1;
215: l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_REQUEST_TYPE;
216: END IF;
217:
218: IF NOT QP_GLOBALS.Equal(p_RQT_rec.request_type_desc,p_old_RQT_rec.request_type_desc)
219: THEN
220: l_index := l_index + 1;
221: l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_REQUEST_TYPE_DESC;
222: END IF;

Line 224: IF NOT QP_GLOBALS.Equal(p_RQT_rec.row_id,p_old_RQT_rec.row_id)

220: l_index := l_index + 1;
221: l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_REQUEST_TYPE_DESC;
222: END IF;
223:
224: IF NOT QP_GLOBALS.Equal(p_RQT_rec.row_id,p_old_RQT_rec.row_id)
225: THEN
226: l_index := l_index + 1;
227: l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_ROW;
228: END IF;

Line 348: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute1,p_old_RQT_rec.attribute1)

344: -- Load out record
345:
346: x_RQT_rec := p_RQT_rec;
347:
348: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute1,p_old_RQT_rec.attribute1)
349: THEN
350: NULL;
351: END IF;
352:

Line 353: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute10,p_old_RQT_rec.attribute10)

349: THEN
350: NULL;
351: END IF;
352:
353: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute10,p_old_RQT_rec.attribute10)
354: THEN
355: NULL;
356: END IF;
357:

Line 358: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute11,p_old_RQT_rec.attribute11)

354: THEN
355: NULL;
356: END IF;
357:
358: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute11,p_old_RQT_rec.attribute11)
359: THEN
360: NULL;
361: END IF;
362:

Line 363: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute12,p_old_RQT_rec.attribute12)

359: THEN
360: NULL;
361: END IF;
362:
363: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute12,p_old_RQT_rec.attribute12)
364: THEN
365: NULL;
366: END IF;
367:

Line 368: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute13,p_old_RQT_rec.attribute13)

364: THEN
365: NULL;
366: END IF;
367:
368: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute13,p_old_RQT_rec.attribute13)
369: THEN
370: NULL;
371: END IF;
372:

Line 373: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute14,p_old_RQT_rec.attribute14)

369: THEN
370: NULL;
371: END IF;
372:
373: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute14,p_old_RQT_rec.attribute14)
374: THEN
375: NULL;
376: END IF;
377:

Line 378: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute15,p_old_RQT_rec.attribute15)

374: THEN
375: NULL;
376: END IF;
377:
378: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute15,p_old_RQT_rec.attribute15)
379: THEN
380: NULL;
381: END IF;
382:

Line 383: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute2,p_old_RQT_rec.attribute2)

379: THEN
380: NULL;
381: END IF;
382:
383: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute2,p_old_RQT_rec.attribute2)
384: THEN
385: NULL;
386: END IF;
387:

Line 388: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute3,p_old_RQT_rec.attribute3)

384: THEN
385: NULL;
386: END IF;
387:
388: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute3,p_old_RQT_rec.attribute3)
389: THEN
390: NULL;
391: END IF;
392:

Line 393: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute4,p_old_RQT_rec.attribute4)

389: THEN
390: NULL;
391: END IF;
392:
393: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute4,p_old_RQT_rec.attribute4)
394: THEN
395: NULL;
396: END IF;
397:

Line 398: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute5,p_old_RQT_rec.attribute5)

394: THEN
395: NULL;
396: END IF;
397:
398: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute5,p_old_RQT_rec.attribute5)
399: THEN
400: NULL;
401: END IF;
402:

Line 403: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute6,p_old_RQT_rec.attribute6)

399: THEN
400: NULL;
401: END IF;
402:
403: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute6,p_old_RQT_rec.attribute6)
404: THEN
405: NULL;
406: END IF;
407:

Line 408: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute7,p_old_RQT_rec.attribute7)

404: THEN
405: NULL;
406: END IF;
407:
408: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute7,p_old_RQT_rec.attribute7)
409: THEN
410: NULL;
411: END IF;
412:

Line 413: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute8,p_old_RQT_rec.attribute8)

409: THEN
410: NULL;
411: END IF;
412:
413: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute8,p_old_RQT_rec.attribute8)
414: THEN
415: NULL;
416: END IF;
417:

Line 418: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute9,p_old_RQT_rec.attribute9)

414: THEN
415: NULL;
416: END IF;
417:
418: IF NOT QP_GLOBALS.Equal(p_RQT_rec.attribute9,p_old_RQT_rec.attribute9)
419: THEN
420: NULL;
421: END IF;
422:

Line 423: IF NOT QP_GLOBALS.Equal(p_RQT_rec.context,p_old_RQT_rec.context)

419: THEN
420: NULL;
421: END IF;
422:
423: IF NOT QP_GLOBALS.Equal(p_RQT_rec.context,p_old_RQT_rec.context)
424: THEN
425: NULL;
426: END IF;
427:

Line 428: IF NOT QP_GLOBALS.Equal(p_RQT_rec.created_by,p_old_RQT_rec.created_by)

424: THEN
425: NULL;
426: END IF;
427:
428: IF NOT QP_GLOBALS.Equal(p_RQT_rec.created_by,p_old_RQT_rec.created_by)
429: THEN
430: NULL;
431: END IF;
432:

Line 433: IF NOT QP_GLOBALS.Equal(p_RQT_rec.creation_date,p_old_RQT_rec.creation_date)

429: THEN
430: NULL;
431: END IF;
432:
433: IF NOT QP_GLOBALS.Equal(p_RQT_rec.creation_date,p_old_RQT_rec.creation_date)
434: THEN
435: NULL;
436: END IF;
437:

Line 438: IF NOT QP_GLOBALS.Equal(p_RQT_rec.enabled_flag,p_old_RQT_rec.enabled_flag)

434: THEN
435: NULL;
436: END IF;
437:
438: IF NOT QP_GLOBALS.Equal(p_RQT_rec.enabled_flag,p_old_RQT_rec.enabled_flag)
439: THEN
440: NULL;
441: END IF;
442:

Line 443: IF NOT QP_GLOBALS.Equal(p_RQT_rec.last_updated_by,p_old_RQT_rec.last_updated_by)

439: THEN
440: NULL;
441: END IF;
442:
443: IF NOT QP_GLOBALS.Equal(p_RQT_rec.last_updated_by,p_old_RQT_rec.last_updated_by)
444: THEN
445: NULL;
446: END IF;
447:

Line 448: IF NOT QP_GLOBALS.Equal(p_RQT_rec.last_update_date,p_old_RQT_rec.last_update_date)

444: THEN
445: NULL;
446: END IF;
447:
448: IF NOT QP_GLOBALS.Equal(p_RQT_rec.last_update_date,p_old_RQT_rec.last_update_date)
449: THEN
450: NULL;
451: END IF;
452:

Line 453: IF NOT QP_GLOBALS.Equal(p_RQT_rec.last_update_login,p_old_RQT_rec.last_update_login)

449: THEN
450: NULL;
451: END IF;
452:
453: IF NOT QP_GLOBALS.Equal(p_RQT_rec.last_update_login,p_old_RQT_rec.last_update_login)
454: THEN
455: NULL;
456: END IF;
457:

Line 458: IF NOT QP_GLOBALS.Equal(p_RQT_rec.line_level_global_struct,p_old_RQT_rec.line_level_global_struct)

454: THEN
455: NULL;
456: END IF;
457:
458: IF NOT QP_GLOBALS.Equal(p_RQT_rec.line_level_global_struct,p_old_RQT_rec.line_level_global_struct)
459: THEN
460: NULL;
461: END IF;
462:

Line 463: IF NOT QP_GLOBALS.Equal(p_RQT_rec.line_level_view_name,p_old_RQT_rec.line_level_view_name)

459: THEN
460: NULL;
461: END IF;
462:
463: IF NOT QP_GLOBALS.Equal(p_RQT_rec.line_level_view_name,p_old_RQT_rec.line_level_view_name)
464: THEN
465: NULL;
466: END IF;
467:

Line 468: IF NOT QP_GLOBALS.Equal(p_RQT_rec.order_level_global_struct,p_old_RQT_rec.order_level_global_struct)

464: THEN
465: NULL;
466: END IF;
467:
468: IF NOT QP_GLOBALS.Equal(p_RQT_rec.order_level_global_struct,p_old_RQT_rec.order_level_global_struct)
469: THEN
470: NULL;
471: END IF;
472:

Line 473: IF NOT QP_GLOBALS.Equal(p_RQT_rec.order_level_view_name,p_old_RQT_rec.order_level_view_name)

469: THEN
470: NULL;
471: END IF;
472:
473: IF NOT QP_GLOBALS.Equal(p_RQT_rec.order_level_view_name,p_old_RQT_rec.order_level_view_name)
474: THEN
475: NULL;
476: END IF;
477:

Line 478: IF NOT QP_GLOBALS.Equal(p_RQT_rec.program_application_id,p_old_RQT_rec.program_application_id)

474: THEN
475: NULL;
476: END IF;
477:
478: IF NOT QP_GLOBALS.Equal(p_RQT_rec.program_application_id,p_old_RQT_rec.program_application_id)
479: THEN
480: NULL;
481: END IF;
482:

Line 483: IF NOT QP_GLOBALS.Equal(p_RQT_rec.program_id,p_old_RQT_rec.program_id)

479: THEN
480: NULL;
481: END IF;
482:
483: IF NOT QP_GLOBALS.Equal(p_RQT_rec.program_id,p_old_RQT_rec.program_id)
484: THEN
485: NULL;
486: END IF;
487:

Line 488: IF NOT QP_GLOBALS.Equal(p_RQT_rec.program_update_date,p_old_RQT_rec.program_update_date)

484: THEN
485: NULL;
486: END IF;
487:
488: IF NOT QP_GLOBALS.Equal(p_RQT_rec.program_update_date,p_old_RQT_rec.program_update_date)
489: THEN
490: NULL;
491: END IF;
492:

Line 493: IF NOT QP_GLOBALS.Equal(p_RQT_rec.pte_code,p_old_RQT_rec.pte_code)

489: THEN
490: NULL;
491: END IF;
492:
493: IF NOT QP_GLOBALS.Equal(p_RQT_rec.pte_code,p_old_RQT_rec.pte_code)
494: THEN
495: NULL;
496: END IF;
497:

Line 498: IF NOT QP_GLOBALS.Equal(p_RQT_rec.request_type_code,p_old_RQT_rec.request_type_code)

494: THEN
495: NULL;
496: END IF;
497:
498: IF NOT QP_GLOBALS.Equal(p_RQT_rec.request_type_code,p_old_RQT_rec.request_type_code)
499: THEN
500: NULL;
501: END IF;
502:

Line 503: IF NOT QP_GLOBALS.Equal(p_RQT_rec.request_type_desc,p_old_RQT_rec.request_type_desc)

499: THEN
500: NULL;
501: END IF;
502:
503: IF NOT QP_GLOBALS.Equal(p_RQT_rec.request_type_desc,p_old_RQT_rec.request_type_desc)
504: THEN
505: NULL;
506: END IF;
507:

Line 508: IF NOT QP_GLOBALS.Equal(p_RQT_rec.row_id,p_old_RQT_rec.row_id)

504: THEN
505: NULL;
506: END IF;
507:
508: IF NOT QP_GLOBALS.Equal(p_RQT_rec.row_id,p_old_RQT_rec.row_id)
509: THEN
510: NULL;
511: END IF;
512:

Line 1403: IF QP_GLOBALS.Equal(p_RQT_rec.attribute1,

1399: FOR UPDATE NOWAIT;
1400:
1401: -- Row locked. Compare IN attributes to DB attributes.
1402:
1403: IF QP_GLOBALS.Equal(p_RQT_rec.attribute1,
1404: l_RQT_rec.attribute1)
1405: AND QP_GLOBALS.Equal(p_RQT_rec.attribute10,
1406: l_RQT_rec.attribute10)
1407: AND QP_GLOBALS.Equal(p_RQT_rec.attribute11,

Line 1405: AND QP_GLOBALS.Equal(p_RQT_rec.attribute10,

1401: -- Row locked. Compare IN attributes to DB attributes.
1402:
1403: IF QP_GLOBALS.Equal(p_RQT_rec.attribute1,
1404: l_RQT_rec.attribute1)
1405: AND QP_GLOBALS.Equal(p_RQT_rec.attribute10,
1406: l_RQT_rec.attribute10)
1407: AND QP_GLOBALS.Equal(p_RQT_rec.attribute11,
1408: l_RQT_rec.attribute11)
1409: AND QP_GLOBALS.Equal(p_RQT_rec.attribute12,

Line 1407: AND QP_GLOBALS.Equal(p_RQT_rec.attribute11,

1403: IF QP_GLOBALS.Equal(p_RQT_rec.attribute1,
1404: l_RQT_rec.attribute1)
1405: AND QP_GLOBALS.Equal(p_RQT_rec.attribute10,
1406: l_RQT_rec.attribute10)
1407: AND QP_GLOBALS.Equal(p_RQT_rec.attribute11,
1408: l_RQT_rec.attribute11)
1409: AND QP_GLOBALS.Equal(p_RQT_rec.attribute12,
1410: l_RQT_rec.attribute12)
1411: AND QP_GLOBALS.Equal(p_RQT_rec.attribute13,

Line 1409: AND QP_GLOBALS.Equal(p_RQT_rec.attribute12,

1405: AND QP_GLOBALS.Equal(p_RQT_rec.attribute10,
1406: l_RQT_rec.attribute10)
1407: AND QP_GLOBALS.Equal(p_RQT_rec.attribute11,
1408: l_RQT_rec.attribute11)
1409: AND QP_GLOBALS.Equal(p_RQT_rec.attribute12,
1410: l_RQT_rec.attribute12)
1411: AND QP_GLOBALS.Equal(p_RQT_rec.attribute13,
1412: l_RQT_rec.attribute13)
1413: AND QP_GLOBALS.Equal(p_RQT_rec.attribute14,

Line 1411: AND QP_GLOBALS.Equal(p_RQT_rec.attribute13,

1407: AND QP_GLOBALS.Equal(p_RQT_rec.attribute11,
1408: l_RQT_rec.attribute11)
1409: AND QP_GLOBALS.Equal(p_RQT_rec.attribute12,
1410: l_RQT_rec.attribute12)
1411: AND QP_GLOBALS.Equal(p_RQT_rec.attribute13,
1412: l_RQT_rec.attribute13)
1413: AND QP_GLOBALS.Equal(p_RQT_rec.attribute14,
1414: l_RQT_rec.attribute14)
1415: AND QP_GLOBALS.Equal(p_RQT_rec.attribute15,

Line 1413: AND QP_GLOBALS.Equal(p_RQT_rec.attribute14,

1409: AND QP_GLOBALS.Equal(p_RQT_rec.attribute12,
1410: l_RQT_rec.attribute12)
1411: AND QP_GLOBALS.Equal(p_RQT_rec.attribute13,
1412: l_RQT_rec.attribute13)
1413: AND QP_GLOBALS.Equal(p_RQT_rec.attribute14,
1414: l_RQT_rec.attribute14)
1415: AND QP_GLOBALS.Equal(p_RQT_rec.attribute15,
1416: l_RQT_rec.attribute15)
1417: AND QP_GLOBALS.Equal(p_RQT_rec.attribute2,

Line 1415: AND QP_GLOBALS.Equal(p_RQT_rec.attribute15,

1411: AND QP_GLOBALS.Equal(p_RQT_rec.attribute13,
1412: l_RQT_rec.attribute13)
1413: AND QP_GLOBALS.Equal(p_RQT_rec.attribute14,
1414: l_RQT_rec.attribute14)
1415: AND QP_GLOBALS.Equal(p_RQT_rec.attribute15,
1416: l_RQT_rec.attribute15)
1417: AND QP_GLOBALS.Equal(p_RQT_rec.attribute2,
1418: l_RQT_rec.attribute2)
1419: AND QP_GLOBALS.Equal(p_RQT_rec.attribute3,

Line 1417: AND QP_GLOBALS.Equal(p_RQT_rec.attribute2,

1413: AND QP_GLOBALS.Equal(p_RQT_rec.attribute14,
1414: l_RQT_rec.attribute14)
1415: AND QP_GLOBALS.Equal(p_RQT_rec.attribute15,
1416: l_RQT_rec.attribute15)
1417: AND QP_GLOBALS.Equal(p_RQT_rec.attribute2,
1418: l_RQT_rec.attribute2)
1419: AND QP_GLOBALS.Equal(p_RQT_rec.attribute3,
1420: l_RQT_rec.attribute3)
1421: AND QP_GLOBALS.Equal(p_RQT_rec.attribute4,

Line 1419: AND QP_GLOBALS.Equal(p_RQT_rec.attribute3,

1415: AND QP_GLOBALS.Equal(p_RQT_rec.attribute15,
1416: l_RQT_rec.attribute15)
1417: AND QP_GLOBALS.Equal(p_RQT_rec.attribute2,
1418: l_RQT_rec.attribute2)
1419: AND QP_GLOBALS.Equal(p_RQT_rec.attribute3,
1420: l_RQT_rec.attribute3)
1421: AND QP_GLOBALS.Equal(p_RQT_rec.attribute4,
1422: l_RQT_rec.attribute4)
1423: AND QP_GLOBALS.Equal(p_RQT_rec.attribute5,

Line 1421: AND QP_GLOBALS.Equal(p_RQT_rec.attribute4,

1417: AND QP_GLOBALS.Equal(p_RQT_rec.attribute2,
1418: l_RQT_rec.attribute2)
1419: AND QP_GLOBALS.Equal(p_RQT_rec.attribute3,
1420: l_RQT_rec.attribute3)
1421: AND QP_GLOBALS.Equal(p_RQT_rec.attribute4,
1422: l_RQT_rec.attribute4)
1423: AND QP_GLOBALS.Equal(p_RQT_rec.attribute5,
1424: l_RQT_rec.attribute5)
1425: AND QP_GLOBALS.Equal(p_RQT_rec.attribute6,

Line 1423: AND QP_GLOBALS.Equal(p_RQT_rec.attribute5,

1419: AND QP_GLOBALS.Equal(p_RQT_rec.attribute3,
1420: l_RQT_rec.attribute3)
1421: AND QP_GLOBALS.Equal(p_RQT_rec.attribute4,
1422: l_RQT_rec.attribute4)
1423: AND QP_GLOBALS.Equal(p_RQT_rec.attribute5,
1424: l_RQT_rec.attribute5)
1425: AND QP_GLOBALS.Equal(p_RQT_rec.attribute6,
1426: l_RQT_rec.attribute6)
1427: AND QP_GLOBALS.Equal(p_RQT_rec.attribute7,

Line 1425: AND QP_GLOBALS.Equal(p_RQT_rec.attribute6,

1421: AND QP_GLOBALS.Equal(p_RQT_rec.attribute4,
1422: l_RQT_rec.attribute4)
1423: AND QP_GLOBALS.Equal(p_RQT_rec.attribute5,
1424: l_RQT_rec.attribute5)
1425: AND QP_GLOBALS.Equal(p_RQT_rec.attribute6,
1426: l_RQT_rec.attribute6)
1427: AND QP_GLOBALS.Equal(p_RQT_rec.attribute7,
1428: l_RQT_rec.attribute7)
1429: AND QP_GLOBALS.Equal(p_RQT_rec.attribute8,

Line 1427: AND QP_GLOBALS.Equal(p_RQT_rec.attribute7,

1423: AND QP_GLOBALS.Equal(p_RQT_rec.attribute5,
1424: l_RQT_rec.attribute5)
1425: AND QP_GLOBALS.Equal(p_RQT_rec.attribute6,
1426: l_RQT_rec.attribute6)
1427: AND QP_GLOBALS.Equal(p_RQT_rec.attribute7,
1428: l_RQT_rec.attribute7)
1429: AND QP_GLOBALS.Equal(p_RQT_rec.attribute8,
1430: l_RQT_rec.attribute8)
1431: AND QP_GLOBALS.Equal(p_RQT_rec.attribute9,

Line 1429: AND QP_GLOBALS.Equal(p_RQT_rec.attribute8,

1425: AND QP_GLOBALS.Equal(p_RQT_rec.attribute6,
1426: l_RQT_rec.attribute6)
1427: AND QP_GLOBALS.Equal(p_RQT_rec.attribute7,
1428: l_RQT_rec.attribute7)
1429: AND QP_GLOBALS.Equal(p_RQT_rec.attribute8,
1430: l_RQT_rec.attribute8)
1431: AND QP_GLOBALS.Equal(p_RQT_rec.attribute9,
1432: l_RQT_rec.attribute9)
1433: AND QP_GLOBALS.Equal(p_RQT_rec.context,

Line 1431: AND QP_GLOBALS.Equal(p_RQT_rec.attribute9,

1427: AND QP_GLOBALS.Equal(p_RQT_rec.attribute7,
1428: l_RQT_rec.attribute7)
1429: AND QP_GLOBALS.Equal(p_RQT_rec.attribute8,
1430: l_RQT_rec.attribute8)
1431: AND QP_GLOBALS.Equal(p_RQT_rec.attribute9,
1432: l_RQT_rec.attribute9)
1433: AND QP_GLOBALS.Equal(p_RQT_rec.context,
1434: l_RQT_rec.context)
1435: AND QP_GLOBALS.Equal(p_RQT_rec.created_by,

Line 1433: AND QP_GLOBALS.Equal(p_RQT_rec.context,

1429: AND QP_GLOBALS.Equal(p_RQT_rec.attribute8,
1430: l_RQT_rec.attribute8)
1431: AND QP_GLOBALS.Equal(p_RQT_rec.attribute9,
1432: l_RQT_rec.attribute9)
1433: AND QP_GLOBALS.Equal(p_RQT_rec.context,
1434: l_RQT_rec.context)
1435: AND QP_GLOBALS.Equal(p_RQT_rec.created_by,
1436: l_RQT_rec.created_by)
1437: AND QP_GLOBALS.Equal(p_RQT_rec.creation_date,

Line 1435: AND QP_GLOBALS.Equal(p_RQT_rec.created_by,

1431: AND QP_GLOBALS.Equal(p_RQT_rec.attribute9,
1432: l_RQT_rec.attribute9)
1433: AND QP_GLOBALS.Equal(p_RQT_rec.context,
1434: l_RQT_rec.context)
1435: AND QP_GLOBALS.Equal(p_RQT_rec.created_by,
1436: l_RQT_rec.created_by)
1437: AND QP_GLOBALS.Equal(p_RQT_rec.creation_date,
1438: l_RQT_rec.creation_date)
1439: AND QP_GLOBALS.Equal(p_RQT_rec.enabled_flag,

Line 1437: AND QP_GLOBALS.Equal(p_RQT_rec.creation_date,

1433: AND QP_GLOBALS.Equal(p_RQT_rec.context,
1434: l_RQT_rec.context)
1435: AND QP_GLOBALS.Equal(p_RQT_rec.created_by,
1436: l_RQT_rec.created_by)
1437: AND QP_GLOBALS.Equal(p_RQT_rec.creation_date,
1438: l_RQT_rec.creation_date)
1439: AND QP_GLOBALS.Equal(p_RQT_rec.enabled_flag,
1440: l_RQT_rec.enabled_flag)
1441: AND QP_GLOBALS.Equal(p_RQT_rec.last_updated_by,

Line 1439: AND QP_GLOBALS.Equal(p_RQT_rec.enabled_flag,

1435: AND QP_GLOBALS.Equal(p_RQT_rec.created_by,
1436: l_RQT_rec.created_by)
1437: AND QP_GLOBALS.Equal(p_RQT_rec.creation_date,
1438: l_RQT_rec.creation_date)
1439: AND QP_GLOBALS.Equal(p_RQT_rec.enabled_flag,
1440: l_RQT_rec.enabled_flag)
1441: AND QP_GLOBALS.Equal(p_RQT_rec.last_updated_by,
1442: l_RQT_rec.last_updated_by)
1443: AND QP_GLOBALS.Equal(p_RQT_rec.last_update_date,

Line 1441: AND QP_GLOBALS.Equal(p_RQT_rec.last_updated_by,

1437: AND QP_GLOBALS.Equal(p_RQT_rec.creation_date,
1438: l_RQT_rec.creation_date)
1439: AND QP_GLOBALS.Equal(p_RQT_rec.enabled_flag,
1440: l_RQT_rec.enabled_flag)
1441: AND QP_GLOBALS.Equal(p_RQT_rec.last_updated_by,
1442: l_RQT_rec.last_updated_by)
1443: AND QP_GLOBALS.Equal(p_RQT_rec.last_update_date,
1444: l_RQT_rec.last_update_date)
1445: AND QP_GLOBALS.Equal(p_RQT_rec.last_update_login,

Line 1443: AND QP_GLOBALS.Equal(p_RQT_rec.last_update_date,

1439: AND QP_GLOBALS.Equal(p_RQT_rec.enabled_flag,
1440: l_RQT_rec.enabled_flag)
1441: AND QP_GLOBALS.Equal(p_RQT_rec.last_updated_by,
1442: l_RQT_rec.last_updated_by)
1443: AND QP_GLOBALS.Equal(p_RQT_rec.last_update_date,
1444: l_RQT_rec.last_update_date)
1445: AND QP_GLOBALS.Equal(p_RQT_rec.last_update_login,
1446: l_RQT_rec.last_update_login)
1447: AND QP_GLOBALS.Equal(p_RQT_rec.line_level_global_struct,

Line 1445: AND QP_GLOBALS.Equal(p_RQT_rec.last_update_login,

1441: AND QP_GLOBALS.Equal(p_RQT_rec.last_updated_by,
1442: l_RQT_rec.last_updated_by)
1443: AND QP_GLOBALS.Equal(p_RQT_rec.last_update_date,
1444: l_RQT_rec.last_update_date)
1445: AND QP_GLOBALS.Equal(p_RQT_rec.last_update_login,
1446: l_RQT_rec.last_update_login)
1447: AND QP_GLOBALS.Equal(p_RQT_rec.line_level_global_struct,
1448: l_RQT_rec.line_level_global_struct)
1449: AND QP_GLOBALS.Equal(p_RQT_rec.line_level_view_name,

Line 1447: AND QP_GLOBALS.Equal(p_RQT_rec.line_level_global_struct,

1443: AND QP_GLOBALS.Equal(p_RQT_rec.last_update_date,
1444: l_RQT_rec.last_update_date)
1445: AND QP_GLOBALS.Equal(p_RQT_rec.last_update_login,
1446: l_RQT_rec.last_update_login)
1447: AND QP_GLOBALS.Equal(p_RQT_rec.line_level_global_struct,
1448: l_RQT_rec.line_level_global_struct)
1449: AND QP_GLOBALS.Equal(p_RQT_rec.line_level_view_name,
1450: l_RQT_rec.line_level_view_name)
1451: AND QP_GLOBALS.Equal(p_RQT_rec.order_level_global_struct,

Line 1449: AND QP_GLOBALS.Equal(p_RQT_rec.line_level_view_name,

1445: AND QP_GLOBALS.Equal(p_RQT_rec.last_update_login,
1446: l_RQT_rec.last_update_login)
1447: AND QP_GLOBALS.Equal(p_RQT_rec.line_level_global_struct,
1448: l_RQT_rec.line_level_global_struct)
1449: AND QP_GLOBALS.Equal(p_RQT_rec.line_level_view_name,
1450: l_RQT_rec.line_level_view_name)
1451: AND QP_GLOBALS.Equal(p_RQT_rec.order_level_global_struct,
1452: l_RQT_rec.order_level_global_struct)
1453: AND QP_GLOBALS.Equal(p_RQT_rec.order_level_view_name,

Line 1451: AND QP_GLOBALS.Equal(p_RQT_rec.order_level_global_struct,

1447: AND QP_GLOBALS.Equal(p_RQT_rec.line_level_global_struct,
1448: l_RQT_rec.line_level_global_struct)
1449: AND QP_GLOBALS.Equal(p_RQT_rec.line_level_view_name,
1450: l_RQT_rec.line_level_view_name)
1451: AND QP_GLOBALS.Equal(p_RQT_rec.order_level_global_struct,
1452: l_RQT_rec.order_level_global_struct)
1453: AND QP_GLOBALS.Equal(p_RQT_rec.order_level_view_name,
1454: l_RQT_rec.order_level_view_name)
1455: AND QP_GLOBALS.Equal(p_RQT_rec.program_application_id,

Line 1453: AND QP_GLOBALS.Equal(p_RQT_rec.order_level_view_name,

1449: AND QP_GLOBALS.Equal(p_RQT_rec.line_level_view_name,
1450: l_RQT_rec.line_level_view_name)
1451: AND QP_GLOBALS.Equal(p_RQT_rec.order_level_global_struct,
1452: l_RQT_rec.order_level_global_struct)
1453: AND QP_GLOBALS.Equal(p_RQT_rec.order_level_view_name,
1454: l_RQT_rec.order_level_view_name)
1455: AND QP_GLOBALS.Equal(p_RQT_rec.program_application_id,
1456: l_RQT_rec.program_application_id)
1457: AND QP_GLOBALS.Equal(p_RQT_rec.program_id,

Line 1455: AND QP_GLOBALS.Equal(p_RQT_rec.program_application_id,

1451: AND QP_GLOBALS.Equal(p_RQT_rec.order_level_global_struct,
1452: l_RQT_rec.order_level_global_struct)
1453: AND QP_GLOBALS.Equal(p_RQT_rec.order_level_view_name,
1454: l_RQT_rec.order_level_view_name)
1455: AND QP_GLOBALS.Equal(p_RQT_rec.program_application_id,
1456: l_RQT_rec.program_application_id)
1457: AND QP_GLOBALS.Equal(p_RQT_rec.program_id,
1458: l_RQT_rec.program_id)
1459: AND QP_GLOBALS.Equal(p_RQT_rec.program_update_date,

Line 1457: AND QP_GLOBALS.Equal(p_RQT_rec.program_id,

1453: AND QP_GLOBALS.Equal(p_RQT_rec.order_level_view_name,
1454: l_RQT_rec.order_level_view_name)
1455: AND QP_GLOBALS.Equal(p_RQT_rec.program_application_id,
1456: l_RQT_rec.program_application_id)
1457: AND QP_GLOBALS.Equal(p_RQT_rec.program_id,
1458: l_RQT_rec.program_id)
1459: AND QP_GLOBALS.Equal(p_RQT_rec.program_update_date,
1460: l_RQT_rec.program_update_date)
1461: AND QP_GLOBALS.Equal(p_RQT_rec.pte_code,

Line 1459: AND QP_GLOBALS.Equal(p_RQT_rec.program_update_date,

1455: AND QP_GLOBALS.Equal(p_RQT_rec.program_application_id,
1456: l_RQT_rec.program_application_id)
1457: AND QP_GLOBALS.Equal(p_RQT_rec.program_id,
1458: l_RQT_rec.program_id)
1459: AND QP_GLOBALS.Equal(p_RQT_rec.program_update_date,
1460: l_RQT_rec.program_update_date)
1461: AND QP_GLOBALS.Equal(p_RQT_rec.pte_code,
1462: l_RQT_rec.pte_code)
1463: AND QP_GLOBALS.Equal(p_RQT_rec.request_type_code,

Line 1461: AND QP_GLOBALS.Equal(p_RQT_rec.pte_code,

1457: AND QP_GLOBALS.Equal(p_RQT_rec.program_id,
1458: l_RQT_rec.program_id)
1459: AND QP_GLOBALS.Equal(p_RQT_rec.program_update_date,
1460: l_RQT_rec.program_update_date)
1461: AND QP_GLOBALS.Equal(p_RQT_rec.pte_code,
1462: l_RQT_rec.pte_code)
1463: AND QP_GLOBALS.Equal(p_RQT_rec.request_type_code,
1464: l_RQT_rec.request_type_code)
1465: AND QP_GLOBALS.Equal(p_RQT_rec.request_type_desc,

Line 1463: AND QP_GLOBALS.Equal(p_RQT_rec.request_type_code,

1459: AND QP_GLOBALS.Equal(p_RQT_rec.program_update_date,
1460: l_RQT_rec.program_update_date)
1461: AND QP_GLOBALS.Equal(p_RQT_rec.pte_code,
1462: l_RQT_rec.pte_code)
1463: AND QP_GLOBALS.Equal(p_RQT_rec.request_type_code,
1464: l_RQT_rec.request_type_code)
1465: AND QP_GLOBALS.Equal(p_RQT_rec.request_type_desc,
1466: l_RQT_rec.request_type_desc)
1467: --**AND QP_GLOBALS.Equal(p_RQT_rec.row_id,

Line 1465: AND QP_GLOBALS.Equal(p_RQT_rec.request_type_desc,

1461: AND QP_GLOBALS.Equal(p_RQT_rec.pte_code,
1462: l_RQT_rec.pte_code)
1463: AND QP_GLOBALS.Equal(p_RQT_rec.request_type_code,
1464: l_RQT_rec.request_type_code)
1465: AND QP_GLOBALS.Equal(p_RQT_rec.request_type_desc,
1466: l_RQT_rec.request_type_desc)
1467: --**AND QP_GLOBALS.Equal(p_RQT_rec.row_id,
1468: --** l_RQT_rec.row_id)
1469: THEN

Line 1467: --**AND QP_GLOBALS.Equal(p_RQT_rec.row_id,

1463: AND QP_GLOBALS.Equal(p_RQT_rec.request_type_code,
1464: l_RQT_rec.request_type_code)
1465: AND QP_GLOBALS.Equal(p_RQT_rec.request_type_desc,
1466: l_RQT_rec.request_type_desc)
1467: --**AND QP_GLOBALS.Equal(p_RQT_rec.row_id,
1468: --** l_RQT_rec.row_id)
1469: THEN
1470:
1471: -- Row has not changed. Set out parameter.

Line 1551: NOT QP_GLOBALS.Equal(p_RQT_rec.enabled_flag,

1547: BEGIN
1548:
1549: IF p_RQT_rec.enabled_flag IS NOT NULL AND
1550: p_RQT_rec.enabled_flag <> FND_API.G_MISS_CHAR AND
1551: NOT QP_GLOBALS.Equal(p_RQT_rec.enabled_flag,
1552: p_old_RQT_rec.enabled_flag)
1553: THEN
1554: l_RQT_val_rec.enabled := QP_Id_To_Value.Enabled
1555: ( p_enabled_flag => p_RQT_rec.enabled_flag

Line 1561: NOT QP_GLOBALS.Equal(p_RQT_rec.pte_code,

1557: END IF;
1558:
1559: IF p_RQT_rec.pte_code IS NOT NULL AND
1560: p_RQT_rec.pte_code <> FND_API.G_MISS_CHAR AND
1561: NOT QP_GLOBALS.Equal(p_RQT_rec.pte_code,
1562: p_old_RQT_rec.pte_code)
1563: THEN
1564: l_RQT_val_rec.pte := QP_Id_To_Value.Pte
1565: ( p_pte_code => p_RQT_rec.pte_code

Line 1571: NOT QP_GLOBALS.Equal(p_RQT_rec.request_type_code,

1567: END IF;
1568:
1569: IF p_RQT_rec.request_type_code IS NOT NULL AND
1570: p_RQT_rec.request_type_code <> FND_API.G_MISS_CHAR AND
1571: NOT QP_GLOBALS.Equal(p_RQT_rec.request_type_code,
1572: p_old_RQT_rec.request_type_code)
1573: THEN
1574: l_RQT_val_rec.request_type := QP_Id_To_Value.Request_Type
1575: ( p_request_type_code => p_RQT_rec.request_type_code

Line 1581: NOT QP_GLOBALS.Equal(p_RQT_rec.row_id,

1577: END IF;
1578:
1579: IF p_RQT_rec.row_id IS NOT NULL AND
1580: p_RQT_rec.row_id <> FND_API.G_MISS_CHAR AND
1581: NOT QP_GLOBALS.Equal(p_RQT_rec.row_id,
1582: p_old_RQT_rec.row_id)
1583: THEN
1584: l_RQT_val_rec.row := QP_Id_To_Value.Row
1585: ( p_row_id => p_RQT_rec.row_id