66: , x_SEG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Rec_Type
67: )
68: IS
69: l_index NUMBER := 0;
70: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
71: l_dep_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
72: BEGIN
73:
74: -- Load out record
67: )
68: IS
69: l_index NUMBER := 0;
70: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
71: l_dep_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
72: BEGIN
73:
74: -- Load out record
75:
79: -- every changed attribute clear its dependent fields.
80:
81: IF p_attr_id = FND_API.G_MISS_NUM THEN
82:
83: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute1,p_old_SEG_rec.attribute1)
84: THEN
85: l_index := l_index + 1;
86: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE1;
87: END IF;
85: l_index := l_index + 1;
86: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE1;
87: END IF;
88:
89: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute10,p_old_SEG_rec.attribute10)
90: THEN
91: l_index := l_index + 1;
92: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE10;
93: END IF;
91: l_index := l_index + 1;
92: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE10;
93: END IF;
94:
95: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute11,p_old_SEG_rec.attribute11)
96: THEN
97: l_index := l_index + 1;
98: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE11;
99: END IF;
97: l_index := l_index + 1;
98: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE11;
99: END IF;
100:
101: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute12,p_old_SEG_rec.attribute12)
102: THEN
103: l_index := l_index + 1;
104: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE12;
105: END IF;
103: l_index := l_index + 1;
104: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE12;
105: END IF;
106:
107: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute13,p_old_SEG_rec.attribute13)
108: THEN
109: l_index := l_index + 1;
110: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE13;
111: END IF;
109: l_index := l_index + 1;
110: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE13;
111: END IF;
112:
113: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute14,p_old_SEG_rec.attribute14)
114: THEN
115: l_index := l_index + 1;
116: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE14;
117: END IF;
115: l_index := l_index + 1;
116: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE14;
117: END IF;
118:
119: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute15,p_old_SEG_rec.attribute15)
120: THEN
121: l_index := l_index + 1;
122: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE15;
123: END IF;
121: l_index := l_index + 1;
122: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE15;
123: END IF;
124:
125: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute2,p_old_SEG_rec.attribute2)
126: THEN
127: l_index := l_index + 1;
128: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE2;
129: END IF;
127: l_index := l_index + 1;
128: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE2;
129: END IF;
130:
131: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute3,p_old_SEG_rec.attribute3)
132: THEN
133: l_index := l_index + 1;
134: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE3;
135: END IF;
133: l_index := l_index + 1;
134: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE3;
135: END IF;
136:
137: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute4,p_old_SEG_rec.attribute4)
138: THEN
139: l_index := l_index + 1;
140: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE4;
141: END IF;
139: l_index := l_index + 1;
140: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE4;
141: END IF;
142:
143: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute5,p_old_SEG_rec.attribute5)
144: THEN
145: l_index := l_index + 1;
146: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE5;
147: END IF;
145: l_index := l_index + 1;
146: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE5;
147: END IF;
148:
149: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute6,p_old_SEG_rec.attribute6)
150: THEN
151: l_index := l_index + 1;
152: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE6;
153: END IF;
151: l_index := l_index + 1;
152: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE6;
153: END IF;
154:
155: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute7,p_old_SEG_rec.attribute7)
156: THEN
157: l_index := l_index + 1;
158: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE7;
159: END IF;
157: l_index := l_index + 1;
158: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE7;
159: END IF;
160:
161: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute8,p_old_SEG_rec.attribute8)
162: THEN
163: l_index := l_index + 1;
164: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE8;
165: END IF;
163: l_index := l_index + 1;
164: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE8;
165: END IF;
166:
167: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute9,p_old_SEG_rec.attribute9)
168: THEN
169: l_index := l_index + 1;
170: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE9;
171: END IF;
169: l_index := l_index + 1;
170: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE9;
171: END IF;
172:
173: IF NOT QP_GLOBALS.Equal(p_SEG_rec.availability_in_basic,p_old_SEG_rec.availability_in_basic)
174: THEN
175: l_index := l_index + 1;
176: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_AVAILABILITY_IN_BASIC;
177: END IF;
175: l_index := l_index + 1;
176: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_AVAILABILITY_IN_BASIC;
177: END IF;
178:
179: IF NOT QP_GLOBALS.Equal(p_SEG_rec.context,p_old_SEG_rec.context)
180: THEN
181: l_index := l_index + 1;
182: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_CONTEXT;
183: END IF;
181: l_index := l_index + 1;
182: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_CONTEXT;
183: END IF;
184:
185: IF NOT QP_GLOBALS.Equal(p_SEG_rec.created_by,p_old_SEG_rec.created_by)
186: THEN
187: l_index := l_index + 1;
188: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_CREATED_BY;
189: END IF;
187: l_index := l_index + 1;
188: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_CREATED_BY;
189: END IF;
190:
191: IF NOT QP_GLOBALS.Equal(p_SEG_rec.creation_date,p_old_SEG_rec.creation_date)
192: THEN
193: l_index := l_index + 1;
194: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_CREATION_DATE;
195: END IF;
193: l_index := l_index + 1;
194: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_CREATION_DATE;
195: END IF;
196:
197: IF NOT QP_GLOBALS.Equal(p_SEG_rec.last_updated_by,p_old_SEG_rec.last_updated_by)
198: THEN
199: l_index := l_index + 1;
200: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_LAST_UPDATED_BY;
201: END IF;
199: l_index := l_index + 1;
200: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_LAST_UPDATED_BY;
201: END IF;
202:
203: IF NOT QP_GLOBALS.Equal(p_SEG_rec.last_update_date,p_old_SEG_rec.last_update_date)
204: THEN
205: l_index := l_index + 1;
206: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_LAST_UPDATE_DATE;
207: END IF;
205: l_index := l_index + 1;
206: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_LAST_UPDATE_DATE;
207: END IF;
208:
209: IF NOT QP_GLOBALS.Equal(p_SEG_rec.last_update_login,p_old_SEG_rec.last_update_login)
210: THEN
211: l_index := l_index + 1;
212: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_LAST_UPDATE_LOGIN;
213: END IF;
211: l_index := l_index + 1;
212: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_LAST_UPDATE_LOGIN;
213: END IF;
214:
215: IF NOT QP_GLOBALS.Equal(p_SEG_rec.prc_context_id,p_old_SEG_rec.prc_context_id)
216: THEN
217: l_index := l_index + 1;
218: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PRC_CONTEXT;
219: END IF;
217: l_index := l_index + 1;
218: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PRC_CONTEXT;
219: END IF;
220:
221: IF NOT QP_GLOBALS.Equal(p_SEG_rec.program_application_id,p_old_SEG_rec.program_application_id)
222: THEN
223: l_index := l_index + 1;
224: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PROGRAM_APPLICATION;
225: END IF;
223: l_index := l_index + 1;
224: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PROGRAM_APPLICATION;
225: END IF;
226:
227: IF NOT QP_GLOBALS.Equal(p_SEG_rec.program_id,p_old_SEG_rec.program_id)
228: THEN
229: l_index := l_index + 1;
230: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PROGRAM;
231: END IF;
229: l_index := l_index + 1;
230: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PROGRAM;
231: END IF;
232:
233: IF NOT QP_GLOBALS.Equal(p_SEG_rec.program_update_date,p_old_SEG_rec.program_update_date)
234: THEN
235: l_index := l_index + 1;
236: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PROGRAM_UPDATE_DATE;
237: END IF;
235: l_index := l_index + 1;
236: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PROGRAM_UPDATE_DATE;
237: END IF;
238:
239: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_flag,p_old_SEG_rec.seeded_flag)
240: THEN
241: l_index := l_index + 1;
242: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED;
243: END IF;
241: l_index := l_index + 1;
242: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED;
243: END IF;
244:
245: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_format_type,p_old_SEG_rec.seeded_format_type)
246: THEN
247: l_index := l_index + 1;
248: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_FORMAT_TYPE;
249: END IF;
247: l_index := l_index + 1;
248: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_FORMAT_TYPE;
249: END IF;
250:
251: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_precedence,p_old_SEG_rec.seeded_precedence)
252: THEN
253: l_index := l_index + 1;
254: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_PRECEDENCE;
255: END IF;
254: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_PRECEDENCE;
255: END IF;
256:
257:
258: IF NOT QP_GLOBALS.Equal( p_SEG_rec.seeded_description,p_old_SEG_rec.seeded_description)
259: THEN
260: l_index := l_index + 1;
261: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_DESCRIPTION;
262: END IF;
260: l_index := l_index + 1;
261: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_DESCRIPTION;
262: END IF;
263:
264: IF NOT QP_GLOBALS.Equal( p_SEG_rec.user_description,p_old_SEG_rec.user_description)
265: THEN
266: l_index := l_index + 1;
267: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_DESCRIPTION;
268: END IF;
266: l_index := l_index + 1;
267: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_DESCRIPTION;
268: END IF;
269:
270: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_segment_name,p_old_SEG_rec.seeded_segment_name)
271: THEN
272: l_index := l_index + 1;
273: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_SEGMENT_NAME;
274: END IF;
272: l_index := l_index + 1;
273: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_SEGMENT_NAME;
274: END IF;
275:
276: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_valueset_id,p_old_SEG_rec.seeded_valueset_id)
277: THEN
278: l_index := l_index + 1;
279: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_VALUESET;
280: END IF;
278: l_index := l_index + 1;
279: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_VALUESET;
280: END IF;
281:
282: IF NOT QP_GLOBALS.Equal(p_SEG_rec.segment_code,p_old_SEG_rec.segment_code)
283: THEN
284: l_index := l_index + 1;
285: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEGMENT_code;
286: END IF;
284: l_index := l_index + 1;
285: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEGMENT_code;
286: END IF;
287:
288: IF NOT QP_GLOBALS.Equal(p_SEG_rec.segment_id,p_old_SEG_rec.segment_id)
289: THEN
290: l_index := l_index + 1;
291: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEGMENT;
292: END IF;
290: l_index := l_index + 1;
291: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEGMENT;
292: END IF;
293:
294: IF NOT QP_GLOBALS.Equal(p_SEG_rec.application_id,p_old_SEG_rec.application_id)
295: THEN
296: l_index := l_index + 1;
297: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_APPLICATION_ID;
298: END IF;
296: l_index := l_index + 1;
297: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_APPLICATION_ID;
298: END IF;
299:
300: IF NOT QP_GLOBALS.Equal(p_SEG_rec.segment_mapping_column,p_old_SEG_rec.segment_mapping_column)
301: THEN
302: l_index := l_index + 1;
303: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEGMENT_MAPPING_COLUMN;
304: END IF;
302: l_index := l_index + 1;
303: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEGMENT_MAPPING_COLUMN;
304: END IF;
305:
306: IF NOT QP_GLOBALS.Equal(p_SEG_rec.user_format_type,p_old_SEG_rec.user_format_type)
307: THEN
308: l_index := l_index + 1;
309: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_FORMAT_TYPE;
310: END IF;
308: l_index := l_index + 1;
309: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_FORMAT_TYPE;
310: END IF;
311:
312: IF NOT QP_GLOBALS.Equal(p_SEG_rec.user_precedence,p_old_SEG_rec.user_precedence)
313: THEN
314: l_index := l_index + 1;
315: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_PRECEDENCE;
316: END IF;
314: l_index := l_index + 1;
315: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_PRECEDENCE;
316: END IF;
317:
318: IF NOT QP_GLOBALS.Equal(p_SEG_rec.user_segment_name,p_old_SEG_rec.user_segment_name)
319: THEN
320: l_index := l_index + 1;
321: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_SEGMENT_NAME;
322: END IF;
320: l_index := l_index + 1;
321: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_SEGMENT_NAME;
322: END IF;
323:
324: IF NOT QP_GLOBALS.Equal(p_SEG_rec.user_valueset_id,p_old_SEG_rec.user_valueset_id)
325: THEN
326: l_index := l_index + 1;
327: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_VALUESET;
328: END IF;
326: l_index := l_index + 1;
327: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_VALUESET;
328: END IF;
329:
330: IF NOT QP_GLOBALS.Equal(p_SEG_rec.required_flag,p_old_SEG_rec.required_flag)
331: THEN
332: l_index := l_index + 1;
333: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_REQUIRED_FLAG;
334: END IF;
332: l_index := l_index + 1;
333: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_REQUIRED_FLAG;
334: END IF;
335: -- Added for TCA
336: IF NOT QP_GLOBALS.Equal(p_SEG_rec.party_hierarchy_enabled_flag,p_old_SEG_rec.party_hierarchy_enabled_flag)
337: THEN
338: l_index := l_index + 1;
339: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PARTY_HIERARCHY_ENABLED_FLAG;
340: END IF;
487: -- Load out record
488:
489: x_SEG_rec := p_SEG_rec;
490:
491: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute1,p_old_SEG_rec.attribute1)
492: THEN
493: NULL;
494: END IF;
495:
492: THEN
493: NULL;
494: END IF;
495:
496: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute10,p_old_SEG_rec.attribute10)
497: THEN
498: NULL;
499: END IF;
500:
497: THEN
498: NULL;
499: END IF;
500:
501: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute11,p_old_SEG_rec.attribute11)
502: THEN
503: NULL;
504: END IF;
505:
502: THEN
503: NULL;
504: END IF;
505:
506: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute12,p_old_SEG_rec.attribute12)
507: THEN
508: NULL;
509: END IF;
510:
507: THEN
508: NULL;
509: END IF;
510:
511: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute13,p_old_SEG_rec.attribute13)
512: THEN
513: NULL;
514: END IF;
515:
512: THEN
513: NULL;
514: END IF;
515:
516: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute14,p_old_SEG_rec.attribute14)
517: THEN
518: NULL;
519: END IF;
520:
517: THEN
518: NULL;
519: END IF;
520:
521: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute15,p_old_SEG_rec.attribute15)
522: THEN
523: NULL;
524: END IF;
525:
522: THEN
523: NULL;
524: END IF;
525:
526: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute2,p_old_SEG_rec.attribute2)
527: THEN
528: NULL;
529: END IF;
530:
527: THEN
528: NULL;
529: END IF;
530:
531: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute3,p_old_SEG_rec.attribute3)
532: THEN
533: NULL;
534: END IF;
535:
532: THEN
533: NULL;
534: END IF;
535:
536: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute4,p_old_SEG_rec.attribute4)
537: THEN
538: NULL;
539: END IF;
540:
537: THEN
538: NULL;
539: END IF;
540:
541: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute5,p_old_SEG_rec.attribute5)
542: THEN
543: NULL;
544: END IF;
545:
542: THEN
543: NULL;
544: END IF;
545:
546: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute6,p_old_SEG_rec.attribute6)
547: THEN
548: NULL;
549: END IF;
550:
547: THEN
548: NULL;
549: END IF;
550:
551: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute7,p_old_SEG_rec.attribute7)
552: THEN
553: NULL;
554: END IF;
555:
552: THEN
553: NULL;
554: END IF;
555:
556: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute8,p_old_SEG_rec.attribute8)
557: THEN
558: NULL;
559: END IF;
560:
557: THEN
558: NULL;
559: END IF;
560:
561: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute9,p_old_SEG_rec.attribute9)
562: THEN
563: NULL;
564: END IF;
565:
562: THEN
563: NULL;
564: END IF;
565:
566: IF NOT QP_GLOBALS.Equal(p_SEG_rec.availability_in_basic,p_old_SEG_rec.availability_in_basic)
567: THEN
568: NULL;
569: END IF;
570:
567: THEN
568: NULL;
569: END IF;
570:
571: IF NOT QP_GLOBALS.Equal(p_SEG_rec.context,p_old_SEG_rec.context)
572: THEN
573: NULL;
574: END IF;
575:
572: THEN
573: NULL;
574: END IF;
575:
576: IF NOT QP_GLOBALS.Equal(p_SEG_rec.created_by,p_old_SEG_rec.created_by)
577: THEN
578: NULL;
579: END IF;
580:
577: THEN
578: NULL;
579: END IF;
580:
581: IF NOT QP_GLOBALS.Equal(p_SEG_rec.creation_date,p_old_SEG_rec.creation_date)
582: THEN
583: NULL;
584: END IF;
585:
582: THEN
583: NULL;
584: END IF;
585:
586: IF NOT QP_GLOBALS.Equal(p_SEG_rec.last_updated_by,p_old_SEG_rec.last_updated_by)
587: THEN
588: NULL;
589: END IF;
590:
587: THEN
588: NULL;
589: END IF;
590:
591: IF NOT QP_GLOBALS.Equal(p_SEG_rec.last_update_date,p_old_SEG_rec.last_update_date)
592: THEN
593: NULL;
594: END IF;
595:
592: THEN
593: NULL;
594: END IF;
595:
596: IF NOT QP_GLOBALS.Equal(p_SEG_rec.last_update_login,p_old_SEG_rec.last_update_login)
597: THEN
598: NULL;
599: END IF;
600:
597: THEN
598: NULL;
599: END IF;
600:
601: IF NOT QP_GLOBALS.Equal(p_SEG_rec.prc_context_id,p_old_SEG_rec.prc_context_id)
602: THEN
603: NULL;
604: END IF;
605:
602: THEN
603: NULL;
604: END IF;
605:
606: IF NOT QP_GLOBALS.Equal(p_SEG_rec.program_application_id,p_old_SEG_rec.program_application_id)
607: THEN
608: NULL;
609: END IF;
610:
607: THEN
608: NULL;
609: END IF;
610:
611: IF NOT QP_GLOBALS.Equal(p_SEG_rec.program_id,p_old_SEG_rec.program_id)
612: THEN
613: NULL;
614: END IF;
615:
612: THEN
613: NULL;
614: END IF;
615:
616: IF NOT QP_GLOBALS.Equal(p_SEG_rec.program_update_date,p_old_SEG_rec.program_update_date)
617: THEN
618: NULL;
619: END IF;
620:
617: THEN
618: NULL;
619: END IF;
620:
621: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_flag,p_old_SEG_rec.seeded_flag)
622: THEN
623: NULL;
624: END IF;
625:
622: THEN
623: NULL;
624: END IF;
625:
626: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_format_type,p_old_SEG_rec.seeded_format_type)
627: THEN
628: NULL;
629: END IF;
630:
627: THEN
628: NULL;
629: END IF;
630:
631: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_precedence,p_old_SEG_rec.seeded_precedence)
632: THEN
633: NULL;
634: END IF;
635:
632: THEN
633: NULL;
634: END IF;
635:
636: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_segment_name,p_old_SEG_rec.seeded_segment_name)
637: THEN
638: NULL;
639: END IF;
640:
637: THEN
638: NULL;
639: END IF;
640:
641: IF NOT QP_GLOBALS.Equal( p_SEG_rec.seeded_description,p_old_SEG_rec.seeded_description)
642: THEN
643: NULL;
644: END IF;
645:
642: THEN
643: NULL;
644: END IF;
645:
646: IF NOT QP_GLOBALS.Equal( p_SEG_rec.user_description,p_old_SEG_rec.user_description)
647: THEN
648: NULL;
649: END IF;
650:
647: THEN
648: NULL;
649: END IF;
650:
651: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_valueset_id,p_old_SEG_rec.seeded_valueset_id)
652: THEN
653: NULL;
654: END IF;
655:
652: THEN
653: NULL;
654: END IF;
655:
656: IF NOT QP_GLOBALS.Equal(p_SEG_rec.segment_code,p_old_SEG_rec.segment_code)
657: THEN
658: NULL;
659: END IF;
660:
657: THEN
658: NULL;
659: END IF;
660:
661: IF NOT QP_GLOBALS.Equal(p_SEG_rec.segment_id,p_old_SEG_rec.segment_id)
662: THEN
663: NULL;
664: END IF;
665:
662: THEN
663: NULL;
664: END IF;
665:
666: IF NOT QP_GLOBALS.Equal(p_SEG_rec.application_id,p_old_SEG_rec.application_id)
667: THEN
668: NULL;
669: END IF;
670:
667: THEN
668: NULL;
669: END IF;
670:
671: IF NOT QP_GLOBALS.Equal(p_SEG_rec.segment_mapping_column,p_old_SEG_rec.segment_mapping_column)
672: THEN
673: NULL;
674: END IF;
675:
672: THEN
673: NULL;
674: END IF;
675:
676: IF NOT QP_GLOBALS.Equal(p_SEG_rec.user_format_type,p_old_SEG_rec.user_format_type)
677: THEN
678: NULL;
679: END IF;
680:
677: THEN
678: NULL;
679: END IF;
680:
681: IF NOT QP_GLOBALS.Equal(p_SEG_rec.user_precedence,p_old_SEG_rec.user_precedence)
682: THEN
683: NULL;
684: END IF;
685:
682: THEN
683: NULL;
684: END IF;
685:
686: IF NOT QP_GLOBALS.Equal(p_SEG_rec.user_segment_name,p_old_SEG_rec.user_segment_name)
687: THEN
688: NULL;
689: END IF;
690:
687: THEN
688: NULL;
689: END IF;
690:
691: IF NOT QP_GLOBALS.Equal(p_SEG_rec.user_valueset_id,p_old_SEG_rec.user_valueset_id)
692: THEN
693: NULL;
694: END IF;
695:
692: THEN
693: NULL;
694: END IF;
695:
696: IF NOT QP_GLOBALS.Equal(p_SEG_rec.required_flag,p_old_SEG_rec.required_flag)
697: THEN
698: NULL;
699: END IF;
700: --Added for TCA
697: THEN
698: NULL;
699: END IF;
700: --Added for TCA
701: IF NOT QP_GLOBALS.Equal(p_SEG_rec.party_hierarchy_enabled_flag,p_old_SEG_rec.party_hierarchy_enabled_flag)
702: THEN
703: NULL;
704: END IF;
705: END Apply_Attribute_Changes;
1783: FOR UPDATE NOWAIT;
1784:
1785: -- Row locked. Compare IN attributes to DB attributes.
1786:
1787: IF QP_GLOBALS.Equal(p_SEG_rec.attribute1,
1788: l_SEG_rec.attribute1)
1789: AND QP_GLOBALS.Equal(p_SEG_rec.attribute10,
1790: l_SEG_rec.attribute10)
1791: AND QP_GLOBALS.Equal(p_SEG_rec.attribute11,
1785: -- Row locked. Compare IN attributes to DB attributes.
1786:
1787: IF QP_GLOBALS.Equal(p_SEG_rec.attribute1,
1788: l_SEG_rec.attribute1)
1789: AND QP_GLOBALS.Equal(p_SEG_rec.attribute10,
1790: l_SEG_rec.attribute10)
1791: AND QP_GLOBALS.Equal(p_SEG_rec.attribute11,
1792: l_SEG_rec.attribute11)
1793: AND QP_GLOBALS.Equal(p_SEG_rec.attribute12,
1787: IF QP_GLOBALS.Equal(p_SEG_rec.attribute1,
1788: l_SEG_rec.attribute1)
1789: AND QP_GLOBALS.Equal(p_SEG_rec.attribute10,
1790: l_SEG_rec.attribute10)
1791: AND QP_GLOBALS.Equal(p_SEG_rec.attribute11,
1792: l_SEG_rec.attribute11)
1793: AND QP_GLOBALS.Equal(p_SEG_rec.attribute12,
1794: l_SEG_rec.attribute12)
1795: AND QP_GLOBALS.Equal(p_SEG_rec.attribute13,
1789: AND QP_GLOBALS.Equal(p_SEG_rec.attribute10,
1790: l_SEG_rec.attribute10)
1791: AND QP_GLOBALS.Equal(p_SEG_rec.attribute11,
1792: l_SEG_rec.attribute11)
1793: AND QP_GLOBALS.Equal(p_SEG_rec.attribute12,
1794: l_SEG_rec.attribute12)
1795: AND QP_GLOBALS.Equal(p_SEG_rec.attribute13,
1796: l_SEG_rec.attribute13)
1797: AND QP_GLOBALS.Equal(p_SEG_rec.attribute14,
1791: AND QP_GLOBALS.Equal(p_SEG_rec.attribute11,
1792: l_SEG_rec.attribute11)
1793: AND QP_GLOBALS.Equal(p_SEG_rec.attribute12,
1794: l_SEG_rec.attribute12)
1795: AND QP_GLOBALS.Equal(p_SEG_rec.attribute13,
1796: l_SEG_rec.attribute13)
1797: AND QP_GLOBALS.Equal(p_SEG_rec.attribute14,
1798: l_SEG_rec.attribute14)
1799: AND QP_GLOBALS.Equal(p_SEG_rec.attribute15,
1793: AND QP_GLOBALS.Equal(p_SEG_rec.attribute12,
1794: l_SEG_rec.attribute12)
1795: AND QP_GLOBALS.Equal(p_SEG_rec.attribute13,
1796: l_SEG_rec.attribute13)
1797: AND QP_GLOBALS.Equal(p_SEG_rec.attribute14,
1798: l_SEG_rec.attribute14)
1799: AND QP_GLOBALS.Equal(p_SEG_rec.attribute15,
1800: l_SEG_rec.attribute15)
1801: AND QP_GLOBALS.Equal(p_SEG_rec.attribute2,
1795: AND QP_GLOBALS.Equal(p_SEG_rec.attribute13,
1796: l_SEG_rec.attribute13)
1797: AND QP_GLOBALS.Equal(p_SEG_rec.attribute14,
1798: l_SEG_rec.attribute14)
1799: AND QP_GLOBALS.Equal(p_SEG_rec.attribute15,
1800: l_SEG_rec.attribute15)
1801: AND QP_GLOBALS.Equal(p_SEG_rec.attribute2,
1802: l_SEG_rec.attribute2)
1803: AND QP_GLOBALS.Equal(p_SEG_rec.attribute3,
1797: AND QP_GLOBALS.Equal(p_SEG_rec.attribute14,
1798: l_SEG_rec.attribute14)
1799: AND QP_GLOBALS.Equal(p_SEG_rec.attribute15,
1800: l_SEG_rec.attribute15)
1801: AND QP_GLOBALS.Equal(p_SEG_rec.attribute2,
1802: l_SEG_rec.attribute2)
1803: AND QP_GLOBALS.Equal(p_SEG_rec.attribute3,
1804: l_SEG_rec.attribute3)
1805: AND QP_GLOBALS.Equal(p_SEG_rec.attribute4,
1799: AND QP_GLOBALS.Equal(p_SEG_rec.attribute15,
1800: l_SEG_rec.attribute15)
1801: AND QP_GLOBALS.Equal(p_SEG_rec.attribute2,
1802: l_SEG_rec.attribute2)
1803: AND QP_GLOBALS.Equal(p_SEG_rec.attribute3,
1804: l_SEG_rec.attribute3)
1805: AND QP_GLOBALS.Equal(p_SEG_rec.attribute4,
1806: l_SEG_rec.attribute4)
1807: AND QP_GLOBALS.Equal(p_SEG_rec.attribute5,
1801: AND QP_GLOBALS.Equal(p_SEG_rec.attribute2,
1802: l_SEG_rec.attribute2)
1803: AND QP_GLOBALS.Equal(p_SEG_rec.attribute3,
1804: l_SEG_rec.attribute3)
1805: AND QP_GLOBALS.Equal(p_SEG_rec.attribute4,
1806: l_SEG_rec.attribute4)
1807: AND QP_GLOBALS.Equal(p_SEG_rec.attribute5,
1808: l_SEG_rec.attribute5)
1809: AND QP_GLOBALS.Equal(p_SEG_rec.attribute6,
1803: AND QP_GLOBALS.Equal(p_SEG_rec.attribute3,
1804: l_SEG_rec.attribute3)
1805: AND QP_GLOBALS.Equal(p_SEG_rec.attribute4,
1806: l_SEG_rec.attribute4)
1807: AND QP_GLOBALS.Equal(p_SEG_rec.attribute5,
1808: l_SEG_rec.attribute5)
1809: AND QP_GLOBALS.Equal(p_SEG_rec.attribute6,
1810: l_SEG_rec.attribute6)
1811: AND QP_GLOBALS.Equal(p_SEG_rec.attribute7,
1805: AND QP_GLOBALS.Equal(p_SEG_rec.attribute4,
1806: l_SEG_rec.attribute4)
1807: AND QP_GLOBALS.Equal(p_SEG_rec.attribute5,
1808: l_SEG_rec.attribute5)
1809: AND QP_GLOBALS.Equal(p_SEG_rec.attribute6,
1810: l_SEG_rec.attribute6)
1811: AND QP_GLOBALS.Equal(p_SEG_rec.attribute7,
1812: l_SEG_rec.attribute7)
1813: AND QP_GLOBALS.Equal(p_SEG_rec.attribute8,
1807: AND QP_GLOBALS.Equal(p_SEG_rec.attribute5,
1808: l_SEG_rec.attribute5)
1809: AND QP_GLOBALS.Equal(p_SEG_rec.attribute6,
1810: l_SEG_rec.attribute6)
1811: AND QP_GLOBALS.Equal(p_SEG_rec.attribute7,
1812: l_SEG_rec.attribute7)
1813: AND QP_GLOBALS.Equal(p_SEG_rec.attribute8,
1814: l_SEG_rec.attribute8)
1815: AND QP_GLOBALS.Equal(p_SEG_rec.attribute9,
1809: AND QP_GLOBALS.Equal(p_SEG_rec.attribute6,
1810: l_SEG_rec.attribute6)
1811: AND QP_GLOBALS.Equal(p_SEG_rec.attribute7,
1812: l_SEG_rec.attribute7)
1813: AND QP_GLOBALS.Equal(p_SEG_rec.attribute8,
1814: l_SEG_rec.attribute8)
1815: AND QP_GLOBALS.Equal(p_SEG_rec.attribute9,
1816: l_SEG_rec.attribute9)
1817: AND QP_GLOBALS.Equal(p_SEG_rec.availability_in_basic,
1811: AND QP_GLOBALS.Equal(p_SEG_rec.attribute7,
1812: l_SEG_rec.attribute7)
1813: AND QP_GLOBALS.Equal(p_SEG_rec.attribute8,
1814: l_SEG_rec.attribute8)
1815: AND QP_GLOBALS.Equal(p_SEG_rec.attribute9,
1816: l_SEG_rec.attribute9)
1817: AND QP_GLOBALS.Equal(p_SEG_rec.availability_in_basic,
1818: l_SEG_rec.availability_in_basic)
1819: AND QP_GLOBALS.Equal(p_SEG_rec.context,
1813: AND QP_GLOBALS.Equal(p_SEG_rec.attribute8,
1814: l_SEG_rec.attribute8)
1815: AND QP_GLOBALS.Equal(p_SEG_rec.attribute9,
1816: l_SEG_rec.attribute9)
1817: AND QP_GLOBALS.Equal(p_SEG_rec.availability_in_basic,
1818: l_SEG_rec.availability_in_basic)
1819: AND QP_GLOBALS.Equal(p_SEG_rec.context,
1820: l_SEG_rec.context)
1821: AND QP_GLOBALS.Equal(p_SEG_rec.created_by,
1815: AND QP_GLOBALS.Equal(p_SEG_rec.attribute9,
1816: l_SEG_rec.attribute9)
1817: AND QP_GLOBALS.Equal(p_SEG_rec.availability_in_basic,
1818: l_SEG_rec.availability_in_basic)
1819: AND QP_GLOBALS.Equal(p_SEG_rec.context,
1820: l_SEG_rec.context)
1821: AND QP_GLOBALS.Equal(p_SEG_rec.created_by,
1822: l_SEG_rec.created_by)
1823: AND QP_GLOBALS.Equal(p_SEG_rec.creation_date,
1817: AND QP_GLOBALS.Equal(p_SEG_rec.availability_in_basic,
1818: l_SEG_rec.availability_in_basic)
1819: AND QP_GLOBALS.Equal(p_SEG_rec.context,
1820: l_SEG_rec.context)
1821: AND QP_GLOBALS.Equal(p_SEG_rec.created_by,
1822: l_SEG_rec.created_by)
1823: AND QP_GLOBALS.Equal(p_SEG_rec.creation_date,
1824: l_SEG_rec.creation_date)
1825: AND QP_GLOBALS.Equal(p_SEG_rec.last_updated_by,
1819: AND QP_GLOBALS.Equal(p_SEG_rec.context,
1820: l_SEG_rec.context)
1821: AND QP_GLOBALS.Equal(p_SEG_rec.created_by,
1822: l_SEG_rec.created_by)
1823: AND QP_GLOBALS.Equal(p_SEG_rec.creation_date,
1824: l_SEG_rec.creation_date)
1825: AND QP_GLOBALS.Equal(p_SEG_rec.last_updated_by,
1826: l_SEG_rec.last_updated_by)
1827: AND QP_GLOBALS.Equal(p_SEG_rec.last_update_date,
1821: AND QP_GLOBALS.Equal(p_SEG_rec.created_by,
1822: l_SEG_rec.created_by)
1823: AND QP_GLOBALS.Equal(p_SEG_rec.creation_date,
1824: l_SEG_rec.creation_date)
1825: AND QP_GLOBALS.Equal(p_SEG_rec.last_updated_by,
1826: l_SEG_rec.last_updated_by)
1827: AND QP_GLOBALS.Equal(p_SEG_rec.last_update_date,
1828: l_SEG_rec.last_update_date)
1829: AND QP_GLOBALS.Equal(p_SEG_rec.last_update_login,
1823: AND QP_GLOBALS.Equal(p_SEG_rec.creation_date,
1824: l_SEG_rec.creation_date)
1825: AND QP_GLOBALS.Equal(p_SEG_rec.last_updated_by,
1826: l_SEG_rec.last_updated_by)
1827: AND QP_GLOBALS.Equal(p_SEG_rec.last_update_date,
1828: l_SEG_rec.last_update_date)
1829: AND QP_GLOBALS.Equal(p_SEG_rec.last_update_login,
1830: l_SEG_rec.last_update_login)
1831: AND QP_GLOBALS.Equal(p_SEG_rec.prc_context_id,
1825: AND QP_GLOBALS.Equal(p_SEG_rec.last_updated_by,
1826: l_SEG_rec.last_updated_by)
1827: AND QP_GLOBALS.Equal(p_SEG_rec.last_update_date,
1828: l_SEG_rec.last_update_date)
1829: AND QP_GLOBALS.Equal(p_SEG_rec.last_update_login,
1830: l_SEG_rec.last_update_login)
1831: AND QP_GLOBALS.Equal(p_SEG_rec.prc_context_id,
1832: l_SEG_rec.prc_context_id)
1833: AND QP_GLOBALS.Equal(p_SEG_rec.program_application_id,
1827: AND QP_GLOBALS.Equal(p_SEG_rec.last_update_date,
1828: l_SEG_rec.last_update_date)
1829: AND QP_GLOBALS.Equal(p_SEG_rec.last_update_login,
1830: l_SEG_rec.last_update_login)
1831: AND QP_GLOBALS.Equal(p_SEG_rec.prc_context_id,
1832: l_SEG_rec.prc_context_id)
1833: AND QP_GLOBALS.Equal(p_SEG_rec.program_application_id,
1834: l_SEG_rec.program_application_id)
1835: AND QP_GLOBALS.Equal(p_SEG_rec.program_id,
1829: AND QP_GLOBALS.Equal(p_SEG_rec.last_update_login,
1830: l_SEG_rec.last_update_login)
1831: AND QP_GLOBALS.Equal(p_SEG_rec.prc_context_id,
1832: l_SEG_rec.prc_context_id)
1833: AND QP_GLOBALS.Equal(p_SEG_rec.program_application_id,
1834: l_SEG_rec.program_application_id)
1835: AND QP_GLOBALS.Equal(p_SEG_rec.program_id,
1836: l_SEG_rec.program_id)
1837: AND QP_GLOBALS.Equal(p_SEG_rec.program_update_date,
1831: AND QP_GLOBALS.Equal(p_SEG_rec.prc_context_id,
1832: l_SEG_rec.prc_context_id)
1833: AND QP_GLOBALS.Equal(p_SEG_rec.program_application_id,
1834: l_SEG_rec.program_application_id)
1835: AND QP_GLOBALS.Equal(p_SEG_rec.program_id,
1836: l_SEG_rec.program_id)
1837: AND QP_GLOBALS.Equal(p_SEG_rec.program_update_date,
1838: l_SEG_rec.program_update_date)
1839: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_flag,
1833: AND QP_GLOBALS.Equal(p_SEG_rec.program_application_id,
1834: l_SEG_rec.program_application_id)
1835: AND QP_GLOBALS.Equal(p_SEG_rec.program_id,
1836: l_SEG_rec.program_id)
1837: AND QP_GLOBALS.Equal(p_SEG_rec.program_update_date,
1838: l_SEG_rec.program_update_date)
1839: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_flag,
1840: l_SEG_rec.seeded_flag)
1841: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_format_type,
1835: AND QP_GLOBALS.Equal(p_SEG_rec.program_id,
1836: l_SEG_rec.program_id)
1837: AND QP_GLOBALS.Equal(p_SEG_rec.program_update_date,
1838: l_SEG_rec.program_update_date)
1839: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_flag,
1840: l_SEG_rec.seeded_flag)
1841: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_format_type,
1842: l_SEG_rec.seeded_format_type)
1843: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_precedence,
1837: AND QP_GLOBALS.Equal(p_SEG_rec.program_update_date,
1838: l_SEG_rec.program_update_date)
1839: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_flag,
1840: l_SEG_rec.seeded_flag)
1841: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_format_type,
1842: l_SEG_rec.seeded_format_type)
1843: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_precedence,
1844: l_SEG_rec.seeded_precedence)
1845: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_segment_name,
1839: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_flag,
1840: l_SEG_rec.seeded_flag)
1841: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_format_type,
1842: l_SEG_rec.seeded_format_type)
1843: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_precedence,
1844: l_SEG_rec.seeded_precedence)
1845: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_segment_name,
1846: l_SEG_rec.seeded_segment_name)
1847: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_valueset_id,
1841: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_format_type,
1842: l_SEG_rec.seeded_format_type)
1843: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_precedence,
1844: l_SEG_rec.seeded_precedence)
1845: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_segment_name,
1846: l_SEG_rec.seeded_segment_name)
1847: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_valueset_id,
1848: l_SEG_rec.seeded_valueset_id)
1849: AND QP_GLOBALS.Equal(p_SEG_rec.segment_code,
1843: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_precedence,
1844: l_SEG_rec.seeded_precedence)
1845: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_segment_name,
1846: l_SEG_rec.seeded_segment_name)
1847: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_valueset_id,
1848: l_SEG_rec.seeded_valueset_id)
1849: AND QP_GLOBALS.Equal(p_SEG_rec.segment_code,
1850: l_SEG_rec.segment_code)
1851: AND QP_GLOBALS.Equal(p_SEG_rec.segment_id,
1845: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_segment_name,
1846: l_SEG_rec.seeded_segment_name)
1847: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_valueset_id,
1848: l_SEG_rec.seeded_valueset_id)
1849: AND QP_GLOBALS.Equal(p_SEG_rec.segment_code,
1850: l_SEG_rec.segment_code)
1851: AND QP_GLOBALS.Equal(p_SEG_rec.segment_id,
1852: l_SEG_rec.segment_id)
1853: AND QP_GLOBALS.Equal(p_SEG_rec.application_id,
1847: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_valueset_id,
1848: l_SEG_rec.seeded_valueset_id)
1849: AND QP_GLOBALS.Equal(p_SEG_rec.segment_code,
1850: l_SEG_rec.segment_code)
1851: AND QP_GLOBALS.Equal(p_SEG_rec.segment_id,
1852: l_SEG_rec.segment_id)
1853: AND QP_GLOBALS.Equal(p_SEG_rec.application_id,
1854: l_SEG_rec.application_id)
1855: AND QP_GLOBALS.Equal(p_SEG_rec.segment_mapping_column,
1849: AND QP_GLOBALS.Equal(p_SEG_rec.segment_code,
1850: l_SEG_rec.segment_code)
1851: AND QP_GLOBALS.Equal(p_SEG_rec.segment_id,
1852: l_SEG_rec.segment_id)
1853: AND QP_GLOBALS.Equal(p_SEG_rec.application_id,
1854: l_SEG_rec.application_id)
1855: AND QP_GLOBALS.Equal(p_SEG_rec.segment_mapping_column,
1856: l_SEG_rec.segment_mapping_column)
1857: AND QP_GLOBALS.Equal(p_SEG_rec.user_format_type,
1851: AND QP_GLOBALS.Equal(p_SEG_rec.segment_id,
1852: l_SEG_rec.segment_id)
1853: AND QP_GLOBALS.Equal(p_SEG_rec.application_id,
1854: l_SEG_rec.application_id)
1855: AND QP_GLOBALS.Equal(p_SEG_rec.segment_mapping_column,
1856: l_SEG_rec.segment_mapping_column)
1857: AND QP_GLOBALS.Equal(p_SEG_rec.user_format_type,
1858: l_SEG_rec.user_format_type)
1859: AND QP_GLOBALS.Equal(p_SEG_rec.user_precedence,
1853: AND QP_GLOBALS.Equal(p_SEG_rec.application_id,
1854: l_SEG_rec.application_id)
1855: AND QP_GLOBALS.Equal(p_SEG_rec.segment_mapping_column,
1856: l_SEG_rec.segment_mapping_column)
1857: AND QP_GLOBALS.Equal(p_SEG_rec.user_format_type,
1858: l_SEG_rec.user_format_type)
1859: AND QP_GLOBALS.Equal(p_SEG_rec.user_precedence,
1860: l_SEG_rec.user_precedence)
1861: AND QP_GLOBALS.Equal(p_SEG_rec.user_segment_name,
1855: AND QP_GLOBALS.Equal(p_SEG_rec.segment_mapping_column,
1856: l_SEG_rec.segment_mapping_column)
1857: AND QP_GLOBALS.Equal(p_SEG_rec.user_format_type,
1858: l_SEG_rec.user_format_type)
1859: AND QP_GLOBALS.Equal(p_SEG_rec.user_precedence,
1860: l_SEG_rec.user_precedence)
1861: AND QP_GLOBALS.Equal(p_SEG_rec.user_segment_name,
1862: l_SEG_rec.user_segment_name)
1863: AND QP_GLOBALS.Equal( p_SEG_rec.seeded_description,
1857: AND QP_GLOBALS.Equal(p_SEG_rec.user_format_type,
1858: l_SEG_rec.user_format_type)
1859: AND QP_GLOBALS.Equal(p_SEG_rec.user_precedence,
1860: l_SEG_rec.user_precedence)
1861: AND QP_GLOBALS.Equal(p_SEG_rec.user_segment_name,
1862: l_SEG_rec.user_segment_name)
1863: AND QP_GLOBALS.Equal( p_SEG_rec.seeded_description,
1864: l_SEG_rec.seeded_description)
1865: AND QP_GLOBALS.Equal( p_SEG_rec.user_description,
1859: AND QP_GLOBALS.Equal(p_SEG_rec.user_precedence,
1860: l_SEG_rec.user_precedence)
1861: AND QP_GLOBALS.Equal(p_SEG_rec.user_segment_name,
1862: l_SEG_rec.user_segment_name)
1863: AND QP_GLOBALS.Equal( p_SEG_rec.seeded_description,
1864: l_SEG_rec.seeded_description)
1865: AND QP_GLOBALS.Equal( p_SEG_rec.user_description,
1866: l_SEG_rec.user_description)
1867: AND QP_GLOBALS.Equal(p_SEG_rec.user_valueset_id,
1861: AND QP_GLOBALS.Equal(p_SEG_rec.user_segment_name,
1862: l_SEG_rec.user_segment_name)
1863: AND QP_GLOBALS.Equal( p_SEG_rec.seeded_description,
1864: l_SEG_rec.seeded_description)
1865: AND QP_GLOBALS.Equal( p_SEG_rec.user_description,
1866: l_SEG_rec.user_description)
1867: AND QP_GLOBALS.Equal(p_SEG_rec.user_valueset_id,
1868: l_SEG_rec.user_valueset_id)
1869: AND QP_GLOBALS.Equal(p_SEG_rec.required_flag,
1863: AND QP_GLOBALS.Equal( p_SEG_rec.seeded_description,
1864: l_SEG_rec.seeded_description)
1865: AND QP_GLOBALS.Equal( p_SEG_rec.user_description,
1866: l_SEG_rec.user_description)
1867: AND QP_GLOBALS.Equal(p_SEG_rec.user_valueset_id,
1868: l_SEG_rec.user_valueset_id)
1869: AND QP_GLOBALS.Equal(p_SEG_rec.required_flag,
1870: l_SEG_rec.required_flag)
1871: -- Added for TCA
1865: AND QP_GLOBALS.Equal( p_SEG_rec.user_description,
1866: l_SEG_rec.user_description)
1867: AND QP_GLOBALS.Equal(p_SEG_rec.user_valueset_id,
1868: l_SEG_rec.user_valueset_id)
1869: AND QP_GLOBALS.Equal(p_SEG_rec.required_flag,
1870: l_SEG_rec.required_flag)
1871: -- Added for TCA
1872: AND QP_GLOBALS.Equal(p_SEG_rec.party_hierarchy_enabled_flag,
1873: l_SEG_rec.party_hierarchy_enabled_flag)
1868: l_SEG_rec.user_valueset_id)
1869: AND QP_GLOBALS.Equal(p_SEG_rec.required_flag,
1870: l_SEG_rec.required_flag)
1871: -- Added for TCA
1872: AND QP_GLOBALS.Equal(p_SEG_rec.party_hierarchy_enabled_flag,
1873: l_SEG_rec.party_hierarchy_enabled_flag)
1874:
1875: THEN
1876: -- Row has not changed. Set out parameter.
1952: BEGIN
1953:
1954: IF p_SEG_rec.prc_context_id IS NOT NULL AND
1955: p_SEG_rec.prc_context_id <> FND_API.G_MISS_NUM AND
1956: NOT QP_GLOBALS.Equal(p_SEG_rec.prc_context_id,
1957: p_old_SEG_rec.prc_context_id)
1958: THEN
1959: l_SEG_val_rec.prc_context := QP_Id_To_Value.Prc_Context
1960: ( p_prc_context_id => p_SEG_rec.prc_context_id
1962: END IF;
1963:
1964: IF p_SEG_rec.seeded_flag IS NOT NULL AND
1965: p_SEG_rec.seeded_flag <> FND_API.G_MISS_CHAR AND
1966: NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_flag,
1967: p_old_SEG_rec.seeded_flag)
1968: THEN
1969: l_SEG_val_rec.seeded := QP_Id_To_Value.Seeded
1970: ( p_seeded_flag => p_SEG_rec.seeded_flag
1972: END IF;
1973:
1974: IF p_SEG_rec.seeded_valueset_id IS NOT NULL AND
1975: p_SEG_rec.seeded_valueset_id <> FND_API.G_MISS_NUM AND
1976: NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_valueset_id,
1977: p_old_SEG_rec.seeded_valueset_id)
1978: THEN
1979: l_SEG_val_rec.seeded_valueset := QP_Id_To_Value.Seeded_Valueset
1980: ( p_seeded_valueset_id => p_SEG_rec.seeded_valueset_id
1982: END IF;
1983:
1984: IF p_SEG_rec.segment_id IS NOT NULL AND
1985: p_SEG_rec.segment_id <> FND_API.G_MISS_NUM AND
1986: NOT QP_GLOBALS.Equal(p_SEG_rec.segment_id,
1987: p_old_SEG_rec.segment_id)
1988: THEN
1989: l_SEG_val_rec.segment := QP_Id_To_Value.Segment
1990: ( p_segment_id => p_SEG_rec.segment_id
1992: END IF;
1993:
1994: IF p_SEG_rec.user_valueset_id IS NOT NULL AND
1995: p_SEG_rec.user_valueset_id <> FND_API.G_MISS_NUM AND
1996: NOT QP_GLOBALS.Equal(p_SEG_rec.user_valueset_id,
1997: p_old_SEG_rec.user_valueset_id)
1998: THEN
1999: l_SEG_val_rec.user_valueset := QP_Id_To_Value.User_Valueset
2000: ( p_user_valueset_id => p_SEG_rec.user_valueset_id