1: PACKAGE BODY QP_Modifier_List_Util AS
2: /* $Header: QPXUMLHB.pls 120.4 2006/04/19 11:14:30 rnayani noship $ */
3:
4: -- Global constant holding the package name
5:
2: /* $Header: QPXUMLHB.pls 120.4 2006/04/19 11:14:30 rnayani noship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Modifier_List_Util';
7:
8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr
34:
35: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute1,p_old_MODIFIER_LIST_rec.attribute1)
36: THEN
37: l_index := l_index + 1;
38: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE1;
39: END IF;
40:
41: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute10,p_old_MODIFIER_LIST_rec.attribute10)
42: THEN
40:
41: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute10,p_old_MODIFIER_LIST_rec.attribute10)
42: THEN
43: l_index := l_index + 1;
44: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE10;
45: END IF;
46:
47: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute11,p_old_MODIFIER_LIST_rec.attribute11)
48: THEN
46:
47: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute11,p_old_MODIFIER_LIST_rec.attribute11)
48: THEN
49: l_index := l_index + 1;
50: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE11;
51: END IF;
52:
53: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute12,p_old_MODIFIER_LIST_rec.attribute12)
54: THEN
52:
53: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute12,p_old_MODIFIER_LIST_rec.attribute12)
54: THEN
55: l_index := l_index + 1;
56: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE12;
57: END IF;
58:
59: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute13,p_old_MODIFIER_LIST_rec.attribute13)
60: THEN
58:
59: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute13,p_old_MODIFIER_LIST_rec.attribute13)
60: THEN
61: l_index := l_index + 1;
62: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE13;
63: END IF;
64:
65: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute14,p_old_MODIFIER_LIST_rec.attribute14)
66: THEN
64:
65: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute14,p_old_MODIFIER_LIST_rec.attribute14)
66: THEN
67: l_index := l_index + 1;
68: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE14;
69: END IF;
70:
71: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute15,p_old_MODIFIER_LIST_rec.attribute15)
72: THEN
70:
71: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute15,p_old_MODIFIER_LIST_rec.attribute15)
72: THEN
73: l_index := l_index + 1;
74: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE15;
75: END IF;
76:
77: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute2,p_old_MODIFIER_LIST_rec.attribute2)
78: THEN
76:
77: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute2,p_old_MODIFIER_LIST_rec.attribute2)
78: THEN
79: l_index := l_index + 1;
80: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE2;
81: END IF;
82:
83: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute3,p_old_MODIFIER_LIST_rec.attribute3)
84: THEN
82:
83: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute3,p_old_MODIFIER_LIST_rec.attribute3)
84: THEN
85: l_index := l_index + 1;
86: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE3;
87: END IF;
88:
89: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute4,p_old_MODIFIER_LIST_rec.attribute4)
90: THEN
88:
89: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute4,p_old_MODIFIER_LIST_rec.attribute4)
90: THEN
91: l_index := l_index + 1;
92: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE4;
93: END IF;
94:
95: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute5,p_old_MODIFIER_LIST_rec.attribute5)
96: THEN
94:
95: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute5,p_old_MODIFIER_LIST_rec.attribute5)
96: THEN
97: l_index := l_index + 1;
98: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE5;
99: END IF;
100:
101: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute6,p_old_MODIFIER_LIST_rec.attribute6)
102: THEN
100:
101: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute6,p_old_MODIFIER_LIST_rec.attribute6)
102: THEN
103: l_index := l_index + 1;
104: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE6;
105: END IF;
106:
107: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute7,p_old_MODIFIER_LIST_rec.attribute7)
108: THEN
106:
107: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute7,p_old_MODIFIER_LIST_rec.attribute7)
108: THEN
109: l_index := l_index + 1;
110: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE7;
111: END IF;
112:
113: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute8,p_old_MODIFIER_LIST_rec.attribute8)
114: THEN
112:
113: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute8,p_old_MODIFIER_LIST_rec.attribute8)
114: THEN
115: l_index := l_index + 1;
116: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE8;
117: END IF;
118:
119: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute9,p_old_MODIFIER_LIST_rec.attribute9)
120: THEN
118:
119: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.attribute9,p_old_MODIFIER_LIST_rec.attribute9)
120: THEN
121: l_index := l_index + 1;
122: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE9;
123: END IF;
124:
125: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.automatic_flag,p_old_MODIFIER_LIST_rec.automatic_flag)
126: THEN
124:
125: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.automatic_flag,p_old_MODIFIER_LIST_rec.automatic_flag)
126: THEN
127: l_index := l_index + 1;
128: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_AUTOMATIC;
129: END IF;
130:
131: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.comments,p_old_MODIFIER_LIST_rec.comments)
132: THEN
130:
131: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.comments,p_old_MODIFIER_LIST_rec.comments)
132: THEN
133: l_index := l_index + 1;
134: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_COMMENTS;
135: END IF;
136:
137: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.context,p_old_MODIFIER_LIST_rec.context)
138: THEN
136:
137: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.context,p_old_MODIFIER_LIST_rec.context)
138: THEN
139: l_index := l_index + 1;
140: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_CONTEXT;
141: END IF;
142:
143: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.created_by,p_old_MODIFIER_LIST_rec.created_by)
144: THEN
142:
143: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.created_by,p_old_MODIFIER_LIST_rec.created_by)
144: THEN
145: l_index := l_index + 1;
146: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_CREATED_BY;
147: END IF;
148:
149: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.creation_date,p_old_MODIFIER_LIST_rec.creation_date)
150: THEN
148:
149: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.creation_date,p_old_MODIFIER_LIST_rec.creation_date)
150: THEN
151: l_index := l_index + 1;
152: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_CREATION_DATE;
153: END IF;
154:
155: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.currency_code,p_old_MODIFIER_LIST_rec.currency_code)
156: THEN
154:
155: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.currency_code,p_old_MODIFIER_LIST_rec.currency_code)
156: THEN
157: l_index := l_index + 1;
158: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_CURRENCY;
159: END IF;
160:
161: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.discount_lines_flag,p_old_MODIFIER_LIST_rec.discount_lines_flag)
162: THEN
160:
161: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.discount_lines_flag,p_old_MODIFIER_LIST_rec.discount_lines_flag)
162: THEN
163: l_index := l_index + 1;
164: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_DISCOUNT_LINES;
165: END IF;
166:
167: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active,p_old_MODIFIER_LIST_rec.end_date_active)
168: THEN
166:
167: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active,p_old_MODIFIER_LIST_rec.end_date_active)
168: THEN
169: l_index := l_index + 1;
170: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_END_DATE_ACTIVE;
171: END IF;
172:
173: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.freight_terms_code,p_old_MODIFIER_LIST_rec.freight_terms_code)
174: THEN
172:
173: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.freight_terms_code,p_old_MODIFIER_LIST_rec.freight_terms_code)
174: THEN
175: l_index := l_index + 1;
176: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_FREIGHT_TERMS;
177: END IF;
178:
179: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.gsa_indicator,p_old_MODIFIER_LIST_rec.gsa_indicator)
180: THEN
178:
179: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.gsa_indicator,p_old_MODIFIER_LIST_rec.gsa_indicator)
180: THEN
181: l_index := l_index + 1;
182: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_GSA_INDICATOR;
183: END IF;
184:
185: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_updated_by,p_old_MODIFIER_LIST_rec.last_updated_by)
186: THEN
184:
185: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_updated_by,p_old_MODIFIER_LIST_rec.last_updated_by)
186: THEN
187: l_index := l_index + 1;
188: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LAST_UPDATED_BY;
189: END IF;
190:
191: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_date,p_old_MODIFIER_LIST_rec.last_update_date)
192: THEN
190:
191: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_date,p_old_MODIFIER_LIST_rec.last_update_date)
192: THEN
193: l_index := l_index + 1;
194: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LAST_UPDATE_DATE;
195: END IF;
196:
197: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_login,p_old_MODIFIER_LIST_rec.last_update_login)
198: THEN
196:
197: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.last_update_login,p_old_MODIFIER_LIST_rec.last_update_login)
198: THEN
199: l_index := l_index + 1;
200: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LAST_UPDATE_LOGIN;
201: END IF;
202:
203: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_header_id,p_old_MODIFIER_LIST_rec.list_header_id)
204: THEN
202:
203: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_header_id,p_old_MODIFIER_LIST_rec.list_header_id)
204: THEN
205: l_index := l_index + 1;
206: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LIST_HEADER;
207: END IF;
208:
209: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_type_code,p_old_MODIFIER_LIST_rec.list_type_code)
210: THEN
208:
209: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.list_type_code,p_old_MODIFIER_LIST_rec.list_type_code)
210: THEN
211: l_index := l_index + 1;
212: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LIST_TYPE;
213: END IF;
214:
215: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_application_id,p_old_MODIFIER_LIST_rec.program_application_id)
216: THEN
214:
215: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_application_id,p_old_MODIFIER_LIST_rec.program_application_id)
216: THEN
217: l_index := l_index + 1;
218: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PROGRAM_APPLICATION;
219: END IF;
220:
221: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_id,p_old_MODIFIER_LIST_rec.program_id)
222: THEN
220:
221: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_id,p_old_MODIFIER_LIST_rec.program_id)
222: THEN
223: l_index := l_index + 1;
224: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PROGRAM;
225: END IF;
226:
227: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_update_date,p_old_MODIFIER_LIST_rec.program_update_date)
228: THEN
226:
227: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.program_update_date,p_old_MODIFIER_LIST_rec.program_update_date)
228: THEN
229: l_index := l_index + 1;
230: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PROGRAM_UPDATE_DATE;
231: END IF;
232:
233: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.prorate_flag,p_old_MODIFIER_LIST_rec.prorate_flag)
234: THEN
232:
233: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.prorate_flag,p_old_MODIFIER_LIST_rec.prorate_flag)
234: THEN
235: l_index := l_index + 1;
236: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PRORATE;
237: END IF;
238:
239: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.request_id,p_old_MODIFIER_LIST_rec.request_id)
240: THEN
238:
239: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.request_id,p_old_MODIFIER_LIST_rec.request_id)
240: THEN
241: l_index := l_index + 1;
242: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_REQUEST;
243: END IF;
244:
245: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.rounding_factor,p_old_MODIFIER_LIST_rec.rounding_factor)
246: THEN
244:
245: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.rounding_factor,p_old_MODIFIER_LIST_rec.rounding_factor)
246: THEN
247: l_index := l_index + 1;
248: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ROUNDING_FACTOR;
249: END IF;
250:
251: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ship_method_code,p_old_MODIFIER_LIST_rec.ship_method_code)
252: THEN
250:
251: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ship_method_code,p_old_MODIFIER_LIST_rec.ship_method_code)
252: THEN
253: l_index := l_index + 1;
254: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_SHIP_METHOD;
255: END IF;
256:
257: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active,p_old_MODIFIER_LIST_rec.start_date_active)
258: THEN
256:
257: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active,p_old_MODIFIER_LIST_rec.start_date_active)
258: THEN
259: l_index := l_index + 1;
260: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_START_DATE_ACTIVE;
261: END IF;
262:
263: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.terms_id,p_old_MODIFIER_LIST_rec.terms_id)
264: THEN
262:
263: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.terms_id,p_old_MODIFIER_LIST_rec.terms_id)
264: THEN
265: l_index := l_index + 1;
266: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_TERMS;
267: END IF;
268:
269: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.source_system_code,p_old_MODIFIER_LIST_rec.source_system_code)
270: THEN
268:
269: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.source_system_code,p_old_MODIFIER_LIST_rec.source_system_code)
270: THEN
271: l_index := l_index + 1;
272: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_SOURCE_SYSTEM_CODE;
273: END IF;
274:
275: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.pte_code,p_old_MODIFIER_LIST_rec.pte_code)
276: THEN
274:
275: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.pte_code,p_old_MODIFIER_LIST_rec.pte_code)
276: THEN
277: l_index := l_index + 1;
278: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PTE_CODE;
279: END IF;
280:
281: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_flag,p_old_MODIFIER_LIST_rec.active_flag)
282: THEN
280:
281: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_flag,p_old_MODIFIER_LIST_rec.active_flag)
282: THEN
283: l_index := l_index + 1;
284: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ACTIVE_FLAG;
285: END IF;
286:
287: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.parent_list_header_id,p_old_MODIFIER_LIST_rec.parent_list_header_id)
288: THEN
286:
287: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.parent_list_header_id,p_old_MODIFIER_LIST_rec.parent_list_header_id)
288: THEN
289: l_index := l_index + 1;
290: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PARENT_LIST_HEADER_ID;
291: END IF;
292:
293: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_first,p_old_MODIFIER_LIST_rec.start_date_active_first)
294: THEN
292:
293: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_first,p_old_MODIFIER_LIST_rec.start_date_active_first)
294: THEN
295: l_index := l_index + 1;
296: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_START_DATE_ACTIVE_FIRST;
297: END IF;
298:
299: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_first,p_old_MODIFIER_LIST_rec.end_date_active_first)
300: THEN
298:
299: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_first,p_old_MODIFIER_LIST_rec.end_date_active_first)
300: THEN
301: l_index := l_index + 1;
302: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_END_DATE_ACTIVE_FIRST;
303: END IF;
304:
305: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_first_type,p_old_MODIFIER_LIST_rec.active_date_first_type)
306: THEN
304:
305: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_first_type,p_old_MODIFIER_LIST_rec.active_date_first_type)
306: THEN
307: l_index := l_index + 1;
308: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ACTIVE_DATE_FIRST_TYPE;
309: END IF;
310:
311: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_second,p_old_MODIFIER_LIST_rec.start_date_active_second)
312: THEN
310:
311: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.start_date_active_second,p_old_MODIFIER_LIST_rec.start_date_active_second)
312: THEN
313: l_index := l_index + 1;
314: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_START_DATE_ACTIVE_SECOND;
315: END IF;
316:
317: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.global_flag,p_old_MODIFIER_LIST_rec.global_flag)
318: THEN
316:
317: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.global_flag,p_old_MODIFIER_LIST_rec.global_flag)
318: THEN
319: l_index := l_index + 1;
320: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_GLOBAL_FLAG;
321: END IF;
322:
323:
324: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_second,p_old_MODIFIER_LIST_rec.end_date_active_second)
323:
324: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.end_date_active_second,p_old_MODIFIER_LIST_rec.end_date_active_second)
325: THEN
326: l_index := l_index + 1;
327: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_END_DATE_ACTIVE_SECOND;
328: END IF;
329:
330: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_second_type,p_old_MODIFIER_LIST_rec.active_date_second_type)
331: THEN
329:
330: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.active_date_second_type,p_old_MODIFIER_LIST_rec.active_date_second_type)
331: THEN
332: l_index := l_index + 1;
333: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ACTIVE_DATE_SECOND_TYPE;
334: END IF;
335:
336: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ask_for_flag,p_old_MODIFIER_LIST_rec.ask_for_flag)
337: THEN
335:
336: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.ask_for_flag,p_old_MODIFIER_LIST_rec.ask_for_flag)
337: THEN
338: l_index := l_index + 1;
339: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ASK_FOR;
340: END IF;
341:
342: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.name,p_old_MODIFIER_LIST_rec.name)
343: THEN
341:
342: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.name,p_old_MODIFIER_LIST_rec.name)
343: THEN
344: l_index := l_index + 1;
345: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_NAME;
346: END IF;
347:
348: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.description,p_old_MODIFIER_LIST_rec.description)
349: THEN
347:
348: IF NOT QP_GLOBALS.Equal(p_MODIFIER_LIST_rec.description,p_old_MODIFIER_LIST_rec.description)
349: THEN
350: l_index := l_index + 1;
351: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_DESCRIPTION;
352: END IF;
353:
354: -- Blanket Pricing
355: IF NOT QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.list_source_code, p_old_MODIFIER_LIST_rec.list_source_code)
354: -- Blanket Pricing
355: IF NOT QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.list_source_code, p_old_MODIFIER_LIST_rec.list_source_code)
356: THEN
357: l_index := l_index + 1;
358: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LIST_SOURCE_CODE;
359: END IF;
360:
361: IF NOT QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.orig_system_header_ref, p_old_MODIFIER_LIST_rec.orig_system_header_ref)
362: THEN
360:
361: IF NOT QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.orig_system_header_ref, p_old_MODIFIER_LIST_rec.orig_system_header_ref)
362: THEN
363: l_index := l_index + 1;
364: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ORIG_SYSTEM_HEADER_REF;
365: END IF;
366:
367: IF NOT QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.shareable_flag,p_old_MODIFIER_LIST_rec.shareable_flag)
368: THEN
366:
367: IF NOT QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.shareable_flag,p_old_MODIFIER_LIST_rec.shareable_flag)
368: THEN
369: l_index := l_index + 1;
370: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_SHAREABLE_FLAG;
371: END IF;
372:
373: --added for MOAC
374: IF NOT QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.org_id,p_old_MODIFIER_LIST_rec.org_id)
373: --added for MOAC
374: IF NOT QP_GLOBALS.Equal (p_MODIFIER_LIST_rec.org_id,p_old_MODIFIER_LIST_rec.org_id)
375: THEN
376: l_index := l_index + 1;
377: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ORG_ID;
378: END IF;
379:
380: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
381: l_index := l_index + 1;
378: END IF;
379:
380: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
381: l_index := l_index + 1;
382: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE1;
383: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
384: l_index := l_index + 1;
385: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE10;
386: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
381: l_index := l_index + 1;
382: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE1;
383: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
384: l_index := l_index + 1;
385: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE10;
386: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
387: l_index := l_index + 1;
388: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE11;
389: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
384: l_index := l_index + 1;
385: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE10;
386: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
387: l_index := l_index + 1;
388: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE11;
389: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
390: l_index := l_index + 1;
391: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE12;
392: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
387: l_index := l_index + 1;
388: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE11;
389: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
390: l_index := l_index + 1;
391: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE12;
392: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
393: l_index := l_index + 1;
394: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE13;
395: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
390: l_index := l_index + 1;
391: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE12;
392: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
393: l_index := l_index + 1;
394: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE13;
395: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
396: l_index := l_index + 1;
397: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE14;
398: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
393: l_index := l_index + 1;
394: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE13;
395: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
396: l_index := l_index + 1;
397: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE14;
398: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
399: l_index := l_index + 1;
400: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE15;
401: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
396: l_index := l_index + 1;
397: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE14;
398: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
399: l_index := l_index + 1;
400: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE15;
401: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
402: l_index := l_index + 1;
403: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE2;
404: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
399: l_index := l_index + 1;
400: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE15;
401: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
402: l_index := l_index + 1;
403: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE2;
404: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
405: l_index := l_index + 1;
406: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE3;
407: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
402: l_index := l_index + 1;
403: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE2;
404: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
405: l_index := l_index + 1;
406: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE3;
407: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
408: l_index := l_index + 1;
409: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE4;
410: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
405: l_index := l_index + 1;
406: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE3;
407: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
408: l_index := l_index + 1;
409: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE4;
410: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
411: l_index := l_index + 1;
412: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE5;
413: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
408: l_index := l_index + 1;
409: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE4;
410: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
411: l_index := l_index + 1;
412: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE5;
413: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
414: l_index := l_index + 1;
415: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE6;
416: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
411: l_index := l_index + 1;
412: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE5;
413: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
414: l_index := l_index + 1;
415: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE6;
416: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
417: l_index := l_index + 1;
418: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE7;
419: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
414: l_index := l_index + 1;
415: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE6;
416: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
417: l_index := l_index + 1;
418: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE7;
419: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
420: l_index := l_index + 1;
421: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE8;
422: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
417: l_index := l_index + 1;
418: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE7;
419: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
420: l_index := l_index + 1;
421: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE8;
422: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
423: l_index := l_index + 1;
424: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE9;
425: ELSIF p_attr_id = G_AUTOMATIC THEN
420: l_index := l_index + 1;
421: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE8;
422: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
423: l_index := l_index + 1;
424: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE9;
425: ELSIF p_attr_id = G_AUTOMATIC THEN
426: l_index := l_index + 1;
427: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_AUTOMATIC;
428: ELSIF p_attr_id = G_COMMENTS THEN
423: l_index := l_index + 1;
424: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ATTRIBUTE9;
425: ELSIF p_attr_id = G_AUTOMATIC THEN
426: l_index := l_index + 1;
427: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_AUTOMATIC;
428: ELSIF p_attr_id = G_COMMENTS THEN
429: l_index := l_index + 1;
430: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_COMMENTS;
431: ELSIF p_attr_id = G_CONTEXT THEN
426: l_index := l_index + 1;
427: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_AUTOMATIC;
428: ELSIF p_attr_id = G_COMMENTS THEN
429: l_index := l_index + 1;
430: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_COMMENTS;
431: ELSIF p_attr_id = G_CONTEXT THEN
432: l_index := l_index + 1;
433: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_CONTEXT;
434: ELSIF p_attr_id = G_CREATED_BY THEN
429: l_index := l_index + 1;
430: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_COMMENTS;
431: ELSIF p_attr_id = G_CONTEXT THEN
432: l_index := l_index + 1;
433: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_CONTEXT;
434: ELSIF p_attr_id = G_CREATED_BY THEN
435: l_index := l_index + 1;
436: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_CREATED_BY;
437: ELSIF p_attr_id = G_CREATION_DATE THEN
432: l_index := l_index + 1;
433: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_CONTEXT;
434: ELSIF p_attr_id = G_CREATED_BY THEN
435: l_index := l_index + 1;
436: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_CREATED_BY;
437: ELSIF p_attr_id = G_CREATION_DATE THEN
438: l_index := l_index + 1;
439: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_CREATION_DATE;
440: ELSIF p_attr_id = G_CURRENCY THEN
435: l_index := l_index + 1;
436: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_CREATED_BY;
437: ELSIF p_attr_id = G_CREATION_DATE THEN
438: l_index := l_index + 1;
439: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_CREATION_DATE;
440: ELSIF p_attr_id = G_CURRENCY THEN
441: l_index := l_index + 1;
442: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_CURRENCY;
443: ELSIF p_attr_id = G_DISCOUNT_LINES THEN
438: l_index := l_index + 1;
439: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_CREATION_DATE;
440: ELSIF p_attr_id = G_CURRENCY THEN
441: l_index := l_index + 1;
442: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_CURRENCY;
443: ELSIF p_attr_id = G_DISCOUNT_LINES THEN
444: l_index := l_index + 1;
445: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_DISCOUNT_LINES;
446: ELSIF p_attr_id = G_END_DATE_ACTIVE THEN
441: l_index := l_index + 1;
442: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_CURRENCY;
443: ELSIF p_attr_id = G_DISCOUNT_LINES THEN
444: l_index := l_index + 1;
445: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_DISCOUNT_LINES;
446: ELSIF p_attr_id = G_END_DATE_ACTIVE THEN
447: l_index := l_index + 1;
448: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_END_DATE_ACTIVE;
449: ELSIF p_attr_id = G_FREIGHT_TERMS THEN
444: l_index := l_index + 1;
445: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_DISCOUNT_LINES;
446: ELSIF p_attr_id = G_END_DATE_ACTIVE THEN
447: l_index := l_index + 1;
448: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_END_DATE_ACTIVE;
449: ELSIF p_attr_id = G_FREIGHT_TERMS THEN
450: l_index := l_index + 1;
451: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_FREIGHT_TERMS;
452: ELSIF p_attr_id = G_GSA_INDICATOR THEN
447: l_index := l_index + 1;
448: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_END_DATE_ACTIVE;
449: ELSIF p_attr_id = G_FREIGHT_TERMS THEN
450: l_index := l_index + 1;
451: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_FREIGHT_TERMS;
452: ELSIF p_attr_id = G_GSA_INDICATOR THEN
453: l_index := l_index + 1;
454: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_GSA_INDICATOR;
455: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
450: l_index := l_index + 1;
451: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_FREIGHT_TERMS;
452: ELSIF p_attr_id = G_GSA_INDICATOR THEN
453: l_index := l_index + 1;
454: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_GSA_INDICATOR;
455: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
456: l_index := l_index + 1;
457: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LAST_UPDATED_BY;
458: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
453: l_index := l_index + 1;
454: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_GSA_INDICATOR;
455: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
456: l_index := l_index + 1;
457: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LAST_UPDATED_BY;
458: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
459: l_index := l_index + 1;
460: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LAST_UPDATE_DATE;
461: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
456: l_index := l_index + 1;
457: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LAST_UPDATED_BY;
458: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
459: l_index := l_index + 1;
460: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LAST_UPDATE_DATE;
461: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
462: l_index := l_index + 1;
463: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LAST_UPDATE_LOGIN;
464: ELSIF p_attr_id = G_LIST_HEADER THEN
459: l_index := l_index + 1;
460: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LAST_UPDATE_DATE;
461: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
462: l_index := l_index + 1;
463: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LAST_UPDATE_LOGIN;
464: ELSIF p_attr_id = G_LIST_HEADER THEN
465: l_index := l_index + 1;
466: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LIST_HEADER;
467: ELSIF p_attr_id = G_LIST_TYPE THEN
462: l_index := l_index + 1;
463: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LAST_UPDATE_LOGIN;
464: ELSIF p_attr_id = G_LIST_HEADER THEN
465: l_index := l_index + 1;
466: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LIST_HEADER;
467: ELSIF p_attr_id = G_LIST_TYPE THEN
468: l_index := l_index + 1;
469: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LIST_TYPE;
470: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
465: l_index := l_index + 1;
466: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LIST_HEADER;
467: ELSIF p_attr_id = G_LIST_TYPE THEN
468: l_index := l_index + 1;
469: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LIST_TYPE;
470: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
471: l_index := l_index + 1;
472: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PROGRAM_APPLICATION;
473: ELSIF p_attr_id = G_PROGRAM THEN
468: l_index := l_index + 1;
469: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LIST_TYPE;
470: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
471: l_index := l_index + 1;
472: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PROGRAM_APPLICATION;
473: ELSIF p_attr_id = G_PROGRAM THEN
474: l_index := l_index + 1;
475: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PROGRAM;
476: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
471: l_index := l_index + 1;
472: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PROGRAM_APPLICATION;
473: ELSIF p_attr_id = G_PROGRAM THEN
474: l_index := l_index + 1;
475: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PROGRAM;
476: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
477: l_index := l_index + 1;
478: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PROGRAM_UPDATE_DATE;
479: ELSIF p_attr_id = G_PRORATE THEN
474: l_index := l_index + 1;
475: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PROGRAM;
476: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
477: l_index := l_index + 1;
478: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PROGRAM_UPDATE_DATE;
479: ELSIF p_attr_id = G_PRORATE THEN
480: l_index := l_index + 1;
481: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PRORATE;
482: ELSIF p_attr_id = G_REQUEST THEN
477: l_index := l_index + 1;
478: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PROGRAM_UPDATE_DATE;
479: ELSIF p_attr_id = G_PRORATE THEN
480: l_index := l_index + 1;
481: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PRORATE;
482: ELSIF p_attr_id = G_REQUEST THEN
483: l_index := l_index + 1;
484: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_REQUEST;
485: ELSIF p_attr_id = G_ROUNDING_FACTOR THEN
480: l_index := l_index + 1;
481: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PRORATE;
482: ELSIF p_attr_id = G_REQUEST THEN
483: l_index := l_index + 1;
484: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_REQUEST;
485: ELSIF p_attr_id = G_ROUNDING_FACTOR THEN
486: l_index := l_index + 1;
487: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ROUNDING_FACTOR;
488: ELSIF p_attr_id = G_SHIP_METHOD THEN
483: l_index := l_index + 1;
484: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_REQUEST;
485: ELSIF p_attr_id = G_ROUNDING_FACTOR THEN
486: l_index := l_index + 1;
487: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ROUNDING_FACTOR;
488: ELSIF p_attr_id = G_SHIP_METHOD THEN
489: l_index := l_index + 1;
490: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_SHIP_METHOD;
491: ELSIF p_attr_id = G_START_DATE_ACTIVE THEN
486: l_index := l_index + 1;
487: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ROUNDING_FACTOR;
488: ELSIF p_attr_id = G_SHIP_METHOD THEN
489: l_index := l_index + 1;
490: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_SHIP_METHOD;
491: ELSIF p_attr_id = G_START_DATE_ACTIVE THEN
492: l_index := l_index + 1;
493: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_START_DATE_ACTIVE;
494: ELSIF p_attr_id = G_TERMS THEN
489: l_index := l_index + 1;
490: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_SHIP_METHOD;
491: ELSIF p_attr_id = G_START_DATE_ACTIVE THEN
492: l_index := l_index + 1;
493: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_START_DATE_ACTIVE;
494: ELSIF p_attr_id = G_TERMS THEN
495: l_index := l_index + 1;
496: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_TERMS;
497: ELSIF p_attr_id = G_SOURCE_SYSTEM_CODE THEN
492: l_index := l_index + 1;
493: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_START_DATE_ACTIVE;
494: ELSIF p_attr_id = G_TERMS THEN
495: l_index := l_index + 1;
496: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_TERMS;
497: ELSIF p_attr_id = G_SOURCE_SYSTEM_CODE THEN
498: l_index := l_index + 1;
499: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_SOURCE_SYSTEM_CODE;
500: ELSIF p_attr_id = G_PTE_CODE THEN
495: l_index := l_index + 1;
496: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_TERMS;
497: ELSIF p_attr_id = G_SOURCE_SYSTEM_CODE THEN
498: l_index := l_index + 1;
499: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_SOURCE_SYSTEM_CODE;
500: ELSIF p_attr_id = G_PTE_CODE THEN
501: l_index := l_index + 1;
502: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PTE_CODE;
503: ELSIF p_attr_id = G_ACTIVE_FLAG THEN
498: l_index := l_index + 1;
499: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_SOURCE_SYSTEM_CODE;
500: ELSIF p_attr_id = G_PTE_CODE THEN
501: l_index := l_index + 1;
502: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PTE_CODE;
503: ELSIF p_attr_id = G_ACTIVE_FLAG THEN
504: l_index := l_index + 1;
505: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ACTIVE_FLAG;
506: ELSIF p_attr_id = G_PARENT_LIST_HEADER_ID THEN
501: l_index := l_index + 1;
502: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PTE_CODE;
503: ELSIF p_attr_id = G_ACTIVE_FLAG THEN
504: l_index := l_index + 1;
505: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ACTIVE_FLAG;
506: ELSIF p_attr_id = G_PARENT_LIST_HEADER_ID THEN
507: l_index := l_index + 1;
508: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PARENT_LIST_HEADER_ID;
509: ELSIF p_attr_id = G_START_DATE_ACTIVE_FIRST THEN
504: l_index := l_index + 1;
505: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ACTIVE_FLAG;
506: ELSIF p_attr_id = G_PARENT_LIST_HEADER_ID THEN
507: l_index := l_index + 1;
508: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PARENT_LIST_HEADER_ID;
509: ELSIF p_attr_id = G_START_DATE_ACTIVE_FIRST THEN
510: l_index := l_index + 1;
511: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_START_DATE_ACTIVE_FIRST;
512: ELSIF p_attr_id = G_END_DATE_ACTIVE_FIRST THEN
507: l_index := l_index + 1;
508: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_PARENT_LIST_HEADER_ID;
509: ELSIF p_attr_id = G_START_DATE_ACTIVE_FIRST THEN
510: l_index := l_index + 1;
511: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_START_DATE_ACTIVE_FIRST;
512: ELSIF p_attr_id = G_END_DATE_ACTIVE_FIRST THEN
513: l_index := l_index + 1;
514: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_END_DATE_ACTIVE_FIRST;
515: ELSIF p_attr_id = G_ACTIVE_DATE_FIRST_TYPE THEN
510: l_index := l_index + 1;
511: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_START_DATE_ACTIVE_FIRST;
512: ELSIF p_attr_id = G_END_DATE_ACTIVE_FIRST THEN
513: l_index := l_index + 1;
514: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_END_DATE_ACTIVE_FIRST;
515: ELSIF p_attr_id = G_ACTIVE_DATE_FIRST_TYPE THEN
516: l_index := l_index + 1;
517: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ACTIVE_DATE_FIRST_TYPE;
518: ELSIF p_attr_id = G_START_DATE_ACTIVE_SECOND THEN
513: l_index := l_index + 1;
514: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_END_DATE_ACTIVE_FIRST;
515: ELSIF p_attr_id = G_ACTIVE_DATE_FIRST_TYPE THEN
516: l_index := l_index + 1;
517: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ACTIVE_DATE_FIRST_TYPE;
518: ELSIF p_attr_id = G_START_DATE_ACTIVE_SECOND THEN
519: l_index := l_index + 1;
520: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_START_DATE_ACTIVE_SECOND;
521: ELSIF p_attr_id = G_GLOBAL_FLAG THEN
516: l_index := l_index + 1;
517: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ACTIVE_DATE_FIRST_TYPE;
518: ELSIF p_attr_id = G_START_DATE_ACTIVE_SECOND THEN
519: l_index := l_index + 1;
520: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_START_DATE_ACTIVE_SECOND;
521: ELSIF p_attr_id = G_GLOBAL_FLAG THEN
522: l_index := l_index + 1;
523: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_GLOBAL_FLAG;
524: ELSIF p_attr_id = G_END_DATE_ACTIVE_SECOND THEN
519: l_index := l_index + 1;
520: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_START_DATE_ACTIVE_SECOND;
521: ELSIF p_attr_id = G_GLOBAL_FLAG THEN
522: l_index := l_index + 1;
523: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_GLOBAL_FLAG;
524: ELSIF p_attr_id = G_END_DATE_ACTIVE_SECOND THEN
525: l_index := l_index + 1;
526: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_END_DATE_ACTIVE_SECOND;
527: ELSIF p_attr_id = G_ACTIVE_DATE_SECOND_TYPE THEN
522: l_index := l_index + 1;
523: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_GLOBAL_FLAG;
524: ELSIF p_attr_id = G_END_DATE_ACTIVE_SECOND THEN
525: l_index := l_index + 1;
526: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_END_DATE_ACTIVE_SECOND;
527: ELSIF p_attr_id = G_ACTIVE_DATE_SECOND_TYPE THEN
528: l_index := l_index + 1;
529: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ACTIVE_DATE_SECOND_TYPE;
530: ELSIF p_attr_id = G_ASK_FOR THEN
525: l_index := l_index + 1;
526: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_END_DATE_ACTIVE_SECOND;
527: ELSIF p_attr_id = G_ACTIVE_DATE_SECOND_TYPE THEN
528: l_index := l_index + 1;
529: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ACTIVE_DATE_SECOND_TYPE;
530: ELSIF p_attr_id = G_ASK_FOR THEN
531: l_index := l_index + 1;
532: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ASK_FOR;
533: ELSIF p_attr_id = G_NAME THEN
528: l_index := l_index + 1;
529: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ACTIVE_DATE_SECOND_TYPE;
530: ELSIF p_attr_id = G_ASK_FOR THEN
531: l_index := l_index + 1;
532: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ASK_FOR;
533: ELSIF p_attr_id = G_NAME THEN
534: l_index := l_index + 1;
535: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_NAME;
536: ELSIF p_attr_id = G_DESCRIPTION THEN
531: l_index := l_index + 1;
532: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ASK_FOR;
533: ELSIF p_attr_id = G_NAME THEN
534: l_index := l_index + 1;
535: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_NAME;
536: ELSIF p_attr_id = G_DESCRIPTION THEN
537: l_index := l_index + 1;
538: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_DESCRIPTION;
539: -- Blanket pricing
534: l_index := l_index + 1;
535: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_NAME;
536: ELSIF p_attr_id = G_DESCRIPTION THEN
537: l_index := l_index + 1;
538: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_DESCRIPTION;
539: -- Blanket pricing
540: ELSIF p_attr_id = G_LIST_SOURCE_CODE THEN
541: l_index := l_index + 1;
542: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LIST_SOURCE_CODE;
538: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_DESCRIPTION;
539: -- Blanket pricing
540: ELSIF p_attr_id = G_LIST_SOURCE_CODE THEN
541: l_index := l_index + 1;
542: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LIST_SOURCE_CODE;
543: ELSIF p_attr_id = G_ORIG_SYSTEM_HEADER_REF THEN
544: l_index := l_index + 1;
545: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ORIG_SYSTEM_HEADER_REF;
546: ELSIF p_attr_id = G_SHAREABLE_FLAG THEN
541: l_index := l_index + 1;
542: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_LIST_SOURCE_CODE;
543: ELSIF p_attr_id = G_ORIG_SYSTEM_HEADER_REF THEN
544: l_index := l_index + 1;
545: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ORIG_SYSTEM_HEADER_REF;
546: ELSIF p_attr_id = G_SHAREABLE_FLAG THEN
547: l_index := l_index + 1;
548: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_SHAREABLE_FLAG;
549: --added for MOAC
544: l_index := l_index + 1;
545: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ORIG_SYSTEM_HEADER_REF;
546: ELSIF p_attr_id = G_SHAREABLE_FLAG THEN
547: l_index := l_index + 1;
548: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_SHAREABLE_FLAG;
549: --added for MOAC
550: ELSIF p_attr_id = G_ORG_ID THEN
551: l_index := l_index + 1;
552: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ORG_ID;
548: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_SHAREABLE_FLAG;
549: --added for MOAC
550: ELSIF p_attr_id = G_ORG_ID THEN
551: l_index := l_index + 1;
552: l_src_attr_tbl(l_index) := QP_MODIFIER_LIST_UTIL.G_ORG_ID;
553: END IF;
554: oe_debug_pub.add('END clear_dependent_attr in QPXUMLHB');
555:
556: END Clear_Dependent_Attr;
3076: return(null);
3077:
3078: END Get_Segment_Level_for_Group;
3079:
3080: END QP_Modifier_List_Util;