15: , x_CURR_DETAILS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_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
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:
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_CURR_DETAILS_rec.attribute1,p_old_CURR_DETAILS_rec.attribute1)
33: THEN
34: l_index := l_index + 1;
35: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE1;
36: END IF;
34: l_index := l_index + 1;
35: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE1;
36: END IF;
37:
38: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute10,p_old_CURR_DETAILS_rec.attribute10)
39: THEN
40: l_index := l_index + 1;
41: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE10;
42: END IF;
40: l_index := l_index + 1;
41: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE10;
42: END IF;
43:
44: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute11,p_old_CURR_DETAILS_rec.attribute11)
45: THEN
46: l_index := l_index + 1;
47: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE11;
48: END IF;
46: l_index := l_index + 1;
47: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE11;
48: END IF;
49:
50: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute12,p_old_CURR_DETAILS_rec.attribute12)
51: THEN
52: l_index := l_index + 1;
53: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE12;
54: END IF;
52: l_index := l_index + 1;
53: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE12;
54: END IF;
55:
56: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute13,p_old_CURR_DETAILS_rec.attribute13)
57: THEN
58: l_index := l_index + 1;
59: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE13;
60: END IF;
58: l_index := l_index + 1;
59: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE13;
60: END IF;
61:
62: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute14,p_old_CURR_DETAILS_rec.attribute14)
63: THEN
64: l_index := l_index + 1;
65: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE14;
66: END IF;
64: l_index := l_index + 1;
65: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE14;
66: END IF;
67:
68: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute15,p_old_CURR_DETAILS_rec.attribute15)
69: THEN
70: l_index := l_index + 1;
71: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE15;
72: END IF;
70: l_index := l_index + 1;
71: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE15;
72: END IF;
73:
74: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute2,p_old_CURR_DETAILS_rec.attribute2)
75: THEN
76: l_index := l_index + 1;
77: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE2;
78: END IF;
76: l_index := l_index + 1;
77: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE2;
78: END IF;
79:
80: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute3,p_old_CURR_DETAILS_rec.attribute3)
81: THEN
82: l_index := l_index + 1;
83: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE3;
84: END IF;
82: l_index := l_index + 1;
83: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE3;
84: END IF;
85:
86: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute4,p_old_CURR_DETAILS_rec.attribute4)
87: THEN
88: l_index := l_index + 1;
89: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE4;
90: END IF;
88: l_index := l_index + 1;
89: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE4;
90: END IF;
91:
92: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute5,p_old_CURR_DETAILS_rec.attribute5)
93: THEN
94: l_index := l_index + 1;
95: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE5;
96: END IF;
94: l_index := l_index + 1;
95: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE5;
96: END IF;
97:
98: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute6,p_old_CURR_DETAILS_rec.attribute6)
99: THEN
100: l_index := l_index + 1;
101: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE6;
102: END IF;
100: l_index := l_index + 1;
101: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE6;
102: END IF;
103:
104: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute7,p_old_CURR_DETAILS_rec.attribute7)
105: THEN
106: l_index := l_index + 1;
107: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE7;
108: END IF;
106: l_index := l_index + 1;
107: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE7;
108: END IF;
109:
110: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute8,p_old_CURR_DETAILS_rec.attribute8)
111: THEN
112: l_index := l_index + 1;
113: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE8;
114: END IF;
112: l_index := l_index + 1;
113: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE8;
114: END IF;
115:
116: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute9,p_old_CURR_DETAILS_rec.attribute9)
117: THEN
118: l_index := l_index + 1;
119: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE9;
120: END IF;
118: l_index := l_index + 1;
119: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ATTRIBUTE9;
120: END IF;
121:
122: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.context,p_old_CURR_DETAILS_rec.context)
123: THEN
124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONTEXT;
126: END IF;
124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONTEXT;
126: END IF;
127:
128: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date,p_old_CURR_DETAILS_rec.conversion_date)
129: THEN
130: l_index := l_index + 1;
131: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_DATE;
132: END IF;
130: l_index := l_index + 1;
131: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_DATE;
132: END IF;
133:
134: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date_type,p_old_CURR_DETAILS_rec.conversion_date_type)
135: THEN
136: l_index := l_index + 1;
137: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_DATE_TYPE;
138: END IF;
137: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_DATE_TYPE;
138: END IF;
139:
140: /*
141: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_method,p_old_CURR_DETAILS_rec.conversion_method)
142: THEN
143: l_index := l_index + 1;
144: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_METHOD;
145: END IF;
144: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_METHOD;
145: END IF;
146: */
147:
148: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_type,p_old_CURR_DETAILS_rec.conversion_type)
149: THEN
150: l_index := l_index + 1;
151: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_TYPE;
152: END IF;
150: l_index := l_index + 1;
151: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CONVERSION_TYPE;
152: END IF;
153:
154: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.created_by,p_old_CURR_DETAILS_rec.created_by)
155: THEN
156: l_index := l_index + 1;
157: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CREATED_BY;
158: END IF;
156: l_index := l_index + 1;
157: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CREATED_BY;
158: END IF;
159:
160: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.creation_date,p_old_CURR_DETAILS_rec.creation_date)
161: THEN
162: l_index := l_index + 1;
163: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CREATION_DATE;
164: END IF;
162: l_index := l_index + 1;
163: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CREATION_DATE;
164: END IF;
165:
166: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_detail_id,p_old_CURR_DETAILS_rec.currency_detail_id)
167: THEN
168: l_index := l_index + 1;
169: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURRENCY_DETAIL;
170: END IF;
168: l_index := l_index + 1;
169: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURRENCY_DETAIL;
170: END IF;
171:
172: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_header_id,p_old_CURR_DETAILS_rec.currency_header_id)
173: THEN
174: l_index := l_index + 1;
175: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURRENCY_HEADER;
176: END IF;
174: l_index := l_index + 1;
175: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURRENCY_HEADER;
176: END IF;
177:
178: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.end_date_active,p_old_CURR_DETAILS_rec.end_date_active)
179: THEN
180: l_index := l_index + 1;
181: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_END_DATE_ACTIVE;
182: END IF;
180: l_index := l_index + 1;
181: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_END_DATE_ACTIVE;
182: END IF;
183:
184: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.fixed_value,p_old_CURR_DETAILS_rec.fixed_value)
185: THEN
186: l_index := l_index + 1;
187: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_FIXED_VALUE;
188: END IF;
186: l_index := l_index + 1;
187: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_FIXED_VALUE;
188: END IF;
189:
190: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_updated_by,p_old_CURR_DETAILS_rec.last_updated_by)
191: THEN
192: l_index := l_index + 1;
193: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_LAST_UPDATED_BY;
194: END IF;
192: l_index := l_index + 1;
193: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_LAST_UPDATED_BY;
194: END IF;
195:
196: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_date,p_old_CURR_DETAILS_rec.last_update_date)
197: THEN
198: l_index := l_index + 1;
199: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_LAST_UPDATE_DATE;
200: END IF;
198: l_index := l_index + 1;
199: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_LAST_UPDATE_DATE;
200: END IF;
201:
202: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_login,p_old_CURR_DETAILS_rec.last_update_login)
203: THEN
204: l_index := l_index + 1;
205: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_LAST_UPDATE_LOGIN;
206: END IF;
204: l_index := l_index + 1;
205: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_LAST_UPDATE_LOGIN;
206: END IF;
207:
208: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_formula_id,p_old_CURR_DETAILS_rec.markup_formula_id)
209: THEN
210: l_index := l_index + 1;
211: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_MARKUP_FORMULA;
212: END IF;
210: l_index := l_index + 1;
211: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_MARKUP_FORMULA;
212: END IF;
213:
214: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_operator,p_old_CURR_DETAILS_rec.markup_operator)
215: THEN
216: l_index := l_index + 1;
217: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_MARKUP_OPERATOR;
218: END IF;
216: l_index := l_index + 1;
217: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_MARKUP_OPERATOR;
218: END IF;
219:
220: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_value,p_old_CURR_DETAILS_rec.markup_value)
221: THEN
222: l_index := l_index + 1;
223: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_MARKUP_VALUE;
224: END IF;
222: l_index := l_index + 1;
223: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_MARKUP_VALUE;
224: END IF;
225:
226: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.price_formula_id,p_old_CURR_DETAILS_rec.price_formula_id)
227: THEN
228: l_index := l_index + 1;
229: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PRICE_FORMULA;
230: END IF;
228: l_index := l_index + 1;
229: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PRICE_FORMULA;
230: END IF;
231:
232: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_application_id,p_old_CURR_DETAILS_rec.program_application_id)
233: THEN
234: l_index := l_index + 1;
235: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PROGRAM_APPLICATION;
236: END IF;
234: l_index := l_index + 1;
235: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PROGRAM_APPLICATION;
236: END IF;
237:
238: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_id,p_old_CURR_DETAILS_rec.program_id)
239: THEN
240: l_index := l_index + 1;
241: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PROGRAM;
242: END IF;
240: l_index := l_index + 1;
241: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PROGRAM;
242: END IF;
243:
244: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_update_date,p_old_CURR_DETAILS_rec.program_update_date)
245: THEN
246: l_index := l_index + 1;
247: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PROGRAM_UPDATE_DATE;
248: END IF;
246: l_index := l_index + 1;
247: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PROGRAM_UPDATE_DATE;
248: END IF;
249:
250: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.request_id,p_old_CURR_DETAILS_rec.request_id)
251: THEN
252: l_index := l_index + 1;
253: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_REQUEST;
254: END IF;
252: l_index := l_index + 1;
253: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_REQUEST;
254: END IF;
255:
256: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.rounding_factor,p_old_CURR_DETAILS_rec.rounding_factor)
257: THEN
258: l_index := l_index + 1;
259: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ROUNDING_FACTOR;
260: END IF;
258: l_index := l_index + 1;
259: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_ROUNDING_FACTOR;
260: END IF;
261:
262: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.selling_rounding_factor,
263: p_old_CURR_DETAILS_rec.selling_rounding_factor)
264: THEN
265: l_index := l_index + 1;
266: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_SELLING_ROUNDING_FACTOR;
265: l_index := l_index + 1;
266: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_SELLING_ROUNDING_FACTOR;
267: END IF;
268:
269: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.start_date_active,p_old_CURR_DETAILS_rec.start_date_active)
270: THEN
271: l_index := l_index + 1;
272: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_START_DATE_ACTIVE;
273: END IF;
271: l_index := l_index + 1;
272: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_START_DATE_ACTIVE;
273: END IF;
274:
275: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.to_currency_code,p_old_CURR_DETAILS_rec.to_currency_code)
276: THEN
277: l_index := l_index + 1;
278: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_TO_CURRENCY;
279: END IF;
277: l_index := l_index + 1;
278: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_TO_CURRENCY;
279: END IF;
280:
281: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_type,p_old_CURR_DETAILS_rec.curr_attribute_type)
282: THEN
283: l_index := l_index + 1;
284: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE_TYPE;
285: END IF;
283: l_index := l_index + 1;
284: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE_TYPE;
285: END IF;
286:
287: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_context,p_old_CURR_DETAILS_rec.curr_attribute_context)
288: THEN
289: l_index := l_index + 1;
290: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE_CONTEXT;
291: END IF;
289: l_index := l_index + 1;
290: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE_CONTEXT;
291: END IF;
292:
293: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute,p_old_CURR_DETAILS_rec.curr_attribute)
294: THEN
295: l_index := l_index + 1;
296: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE;
297: END IF;
295: l_index := l_index + 1;
296: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE;
297: END IF;
298:
299: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_value,p_old_CURR_DETAILS_rec.curr_attribute_value)
300: THEN
301: l_index := l_index + 1;
302: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE_VALUE;
303: END IF;
301: l_index := l_index + 1;
302: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_CURR_ATTRIBUTE_VALUE;
303: END IF;
304:
305: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.precedence,p_old_CURR_DETAILS_rec.precedence)
306: THEN
307: l_index := l_index + 1;
308: l_src_attr_tbl(l_index) := QP_CURR_DETAILS_UTIL.G_PRECEDENCE;
309: END IF;
465: -- Load out NOCOPY record
466:
467: x_CURR_DETAILS_rec := p_CURR_DETAILS_rec;
468:
469: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute1,p_old_CURR_DETAILS_rec.attribute1)
470: THEN
471: NULL;
472: END IF;
473:
470: THEN
471: NULL;
472: END IF;
473:
474: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute10,p_old_CURR_DETAILS_rec.attribute10)
475: THEN
476: NULL;
477: END IF;
478:
475: THEN
476: NULL;
477: END IF;
478:
479: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute11,p_old_CURR_DETAILS_rec.attribute11)
480: THEN
481: NULL;
482: END IF;
483:
480: THEN
481: NULL;
482: END IF;
483:
484: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute12,p_old_CURR_DETAILS_rec.attribute12)
485: THEN
486: NULL;
487: END IF;
488:
485: THEN
486: NULL;
487: END IF;
488:
489: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute13,p_old_CURR_DETAILS_rec.attribute13)
490: THEN
491: NULL;
492: END IF;
493:
490: THEN
491: NULL;
492: END IF;
493:
494: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute14,p_old_CURR_DETAILS_rec.attribute14)
495: THEN
496: NULL;
497: END IF;
498:
495: THEN
496: NULL;
497: END IF;
498:
499: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute15,p_old_CURR_DETAILS_rec.attribute15)
500: THEN
501: NULL;
502: END IF;
503:
500: THEN
501: NULL;
502: END IF;
503:
504: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute2,p_old_CURR_DETAILS_rec.attribute2)
505: THEN
506: NULL;
507: END IF;
508:
505: THEN
506: NULL;
507: END IF;
508:
509: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute3,p_old_CURR_DETAILS_rec.attribute3)
510: THEN
511: NULL;
512: END IF;
513:
510: THEN
511: NULL;
512: END IF;
513:
514: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute4,p_old_CURR_DETAILS_rec.attribute4)
515: THEN
516: NULL;
517: END IF;
518:
515: THEN
516: NULL;
517: END IF;
518:
519: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute5,p_old_CURR_DETAILS_rec.attribute5)
520: THEN
521: NULL;
522: END IF;
523:
520: THEN
521: NULL;
522: END IF;
523:
524: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute6,p_old_CURR_DETAILS_rec.attribute6)
525: THEN
526: NULL;
527: END IF;
528:
525: THEN
526: NULL;
527: END IF;
528:
529: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute7,p_old_CURR_DETAILS_rec.attribute7)
530: THEN
531: NULL;
532: END IF;
533:
530: THEN
531: NULL;
532: END IF;
533:
534: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute8,p_old_CURR_DETAILS_rec.attribute8)
535: THEN
536: NULL;
537: END IF;
538:
535: THEN
536: NULL;
537: END IF;
538:
539: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute9,p_old_CURR_DETAILS_rec.attribute9)
540: THEN
541: NULL;
542: END IF;
543:
540: THEN
541: NULL;
542: END IF;
543:
544: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.context,p_old_CURR_DETAILS_rec.context)
545: THEN
546: NULL;
547: END IF;
548:
545: THEN
546: NULL;
547: END IF;
548:
549: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date,p_old_CURR_DETAILS_rec.conversion_date)
550: THEN
551: NULL;
552: END IF;
553:
550: THEN
551: NULL;
552: END IF;
553:
554: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date_type,p_old_CURR_DETAILS_rec.conversion_date_type)
555: THEN
556: NULL;
557: END IF;
558:
556: NULL;
557: END IF;
558:
559: /*
560: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_method,p_old_CURR_DETAILS_rec.conversion_method)
561: THEN
562: NULL;
563: END IF;
564: */
562: NULL;
563: END IF;
564: */
565:
566: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_type,p_old_CURR_DETAILS_rec.conversion_type)
567: THEN
568: NULL;
569: END IF;
570:
567: THEN
568: NULL;
569: END IF;
570:
571: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.created_by,p_old_CURR_DETAILS_rec.created_by)
572: THEN
573: NULL;
574: END IF;
575:
572: THEN
573: NULL;
574: END IF;
575:
576: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.creation_date,p_old_CURR_DETAILS_rec.creation_date)
577: THEN
578: NULL;
579: END IF;
580:
577: THEN
578: NULL;
579: END IF;
580:
581: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_detail_id,p_old_CURR_DETAILS_rec.currency_detail_id)
582: THEN
583: NULL;
584: END IF;
585:
582: THEN
583: NULL;
584: END IF;
585:
586: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_header_id,p_old_CURR_DETAILS_rec.currency_header_id)
587: THEN
588: NULL;
589: END IF;
590:
587: THEN
588: NULL;
589: END IF;
590:
591: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.end_date_active,p_old_CURR_DETAILS_rec.end_date_active)
592: THEN
593: NULL;
594: END IF;
595:
592: THEN
593: NULL;
594: END IF;
595:
596: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.fixed_value,p_old_CURR_DETAILS_rec.fixed_value)
597: THEN
598: NULL;
599: END IF;
600:
597: THEN
598: NULL;
599: END IF;
600:
601: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_updated_by,p_old_CURR_DETAILS_rec.last_updated_by)
602: THEN
603: NULL;
604: END IF;
605:
602: THEN
603: NULL;
604: END IF;
605:
606: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_date,p_old_CURR_DETAILS_rec.last_update_date)
607: THEN
608: NULL;
609: END IF;
610:
607: THEN
608: NULL;
609: END IF;
610:
611: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_login,p_old_CURR_DETAILS_rec.last_update_login)
612: THEN
613: NULL;
614: END IF;
615:
612: THEN
613: NULL;
614: END IF;
615:
616: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_formula_id,p_old_CURR_DETAILS_rec.markup_formula_id)
617: THEN
618: NULL;
619: END IF;
620:
617: THEN
618: NULL;
619: END IF;
620:
621: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_operator,p_old_CURR_DETAILS_rec.markup_operator)
622: THEN
623: NULL;
624: END IF;
625:
622: THEN
623: NULL;
624: END IF;
625:
626: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_value,p_old_CURR_DETAILS_rec.markup_value)
627: THEN
628: NULL;
629: END IF;
630:
627: THEN
628: NULL;
629: END IF;
630:
631: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.price_formula_id,p_old_CURR_DETAILS_rec.price_formula_id)
632: THEN
633: NULL;
634: END IF;
635:
632: THEN
633: NULL;
634: END IF;
635:
636: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_application_id,p_old_CURR_DETAILS_rec.program_application_id)
637: THEN
638: NULL;
639: END IF;
640:
637: THEN
638: NULL;
639: END IF;
640:
641: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_id,p_old_CURR_DETAILS_rec.program_id)
642: THEN
643: NULL;
644: END IF;
645:
642: THEN
643: NULL;
644: END IF;
645:
646: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_update_date,p_old_CURR_DETAILS_rec.program_update_date)
647: THEN
648: NULL;
649: END IF;
650:
647: THEN
648: NULL;
649: END IF;
650:
651: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.request_id,p_old_CURR_DETAILS_rec.request_id)
652: THEN
653: NULL;
654: END IF;
655:
652: THEN
653: NULL;
654: END IF;
655:
656: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.rounding_factor,p_old_CURR_DETAILS_rec.rounding_factor)
657: THEN
658: NULL;
659: END IF;
660:
657: THEN
658: NULL;
659: END IF;
660:
661: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.selling_rounding_factor,
662: p_old_CURR_DETAILS_rec.selling_rounding_factor)
663: THEN
664: oe_debug_pub.add('Logging a request to validate unique selling rounding factor');
665:
663: THEN
664: oe_debug_pub.add('Logging a request to validate unique selling rounding factor');
665:
666: qp_delayed_requests_PVT.log_request(
667: p_entity_code => QP_GLOBALS.G_ENTITY_CURR_DETAILS,
668: p_entity_id => p_CURR_DETAILS_rec.currency_header_id,
669: p_param1 => p_CURR_DETAILS_rec.to_currency_code,
670: p_request_unique_key1 => p_CURR_DETAILS_rec.to_currency_code,
671: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_CURR_DETAILS,
667: p_entity_code => QP_GLOBALS.G_ENTITY_CURR_DETAILS,
668: p_entity_id => p_CURR_DETAILS_rec.currency_header_id,
669: p_param1 => p_CURR_DETAILS_rec.to_currency_code,
670: p_request_unique_key1 => p_CURR_DETAILS_rec.to_currency_code,
671: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_CURR_DETAILS,
672: p_requesting_entity_id => p_CURR_DETAILS_rec.currency_header_id,
673: p_request_type =>QP_GLOBALS.G_VALIDATE_SELLING_ROUNDING,
674: x_return_status => l_return_status);
675: END IF;
669: p_param1 => p_CURR_DETAILS_rec.to_currency_code,
670: p_request_unique_key1 => p_CURR_DETAILS_rec.to_currency_code,
671: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_CURR_DETAILS,
672: p_requesting_entity_id => p_CURR_DETAILS_rec.currency_header_id,
673: p_request_type =>QP_GLOBALS.G_VALIDATE_SELLING_ROUNDING,
674: x_return_status => l_return_status);
675: END IF;
676:
677: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.start_date_active,p_old_CURR_DETAILS_rec.start_date_active)
673: p_request_type =>QP_GLOBALS.G_VALIDATE_SELLING_ROUNDING,
674: x_return_status => l_return_status);
675: END IF;
676:
677: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.start_date_active,p_old_CURR_DETAILS_rec.start_date_active)
678: THEN
679: NULL;
680: END IF;
681:
678: THEN
679: NULL;
680: END IF;
681:
682: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.to_currency_code,p_old_CURR_DETAILS_rec.to_currency_code)
683: THEN
684: NULL;
685: END IF;
686:
683: THEN
684: NULL;
685: END IF;
686:
687: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_type,p_old_CURR_DETAILS_rec.curr_attribute_type)
688: THEN
689: NULL;
690: END IF;
691:
688: THEN
689: NULL;
690: END IF;
691:
692: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_context,p_old_CURR_DETAILS_rec.curr_attribute_context)
693: THEN
694: NULL;
695: END IF;
696:
693: THEN
694: NULL;
695: END IF;
696:
697: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute,p_old_CURR_DETAILS_rec.curr_attribute)
698: THEN
699: NULL;
700: END IF;
701:
698: THEN
699: NULL;
700: END IF;
701:
702: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_value,p_old_CURR_DETAILS_rec.curr_attribute_value)
703: THEN
704: NULL;
705: END IF;
706:
703: THEN
704: NULL;
705: END IF;
706:
707: IF NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.precedence,p_old_CURR_DETAILS_rec.precedence)
708: THEN
709: NULL;
710: END IF;
711:
1664: FOR UPDATE NOWAIT;
1665:
1666: -- Row locked. Compare IN attributes to DB attributes.
1667:
1668: IF QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute1,
1669: l_CURR_DETAILS_rec.attribute1)
1670: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute10,
1671: l_CURR_DETAILS_rec.attribute10)
1672: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute11,
1666: -- Row locked. Compare IN attributes to DB attributes.
1667:
1668: IF QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute1,
1669: l_CURR_DETAILS_rec.attribute1)
1670: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute10,
1671: l_CURR_DETAILS_rec.attribute10)
1672: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute11,
1673: l_CURR_DETAILS_rec.attribute11)
1674: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute12,
1668: IF QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute1,
1669: l_CURR_DETAILS_rec.attribute1)
1670: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute10,
1671: l_CURR_DETAILS_rec.attribute10)
1672: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute11,
1673: l_CURR_DETAILS_rec.attribute11)
1674: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute12,
1675: l_CURR_DETAILS_rec.attribute12)
1676: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute13,
1670: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute10,
1671: l_CURR_DETAILS_rec.attribute10)
1672: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute11,
1673: l_CURR_DETAILS_rec.attribute11)
1674: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute12,
1675: l_CURR_DETAILS_rec.attribute12)
1676: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute13,
1677: l_CURR_DETAILS_rec.attribute13)
1678: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute14,
1672: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute11,
1673: l_CURR_DETAILS_rec.attribute11)
1674: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute12,
1675: l_CURR_DETAILS_rec.attribute12)
1676: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute13,
1677: l_CURR_DETAILS_rec.attribute13)
1678: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute14,
1679: l_CURR_DETAILS_rec.attribute14)
1680: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute15,
1674: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute12,
1675: l_CURR_DETAILS_rec.attribute12)
1676: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute13,
1677: l_CURR_DETAILS_rec.attribute13)
1678: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute14,
1679: l_CURR_DETAILS_rec.attribute14)
1680: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute15,
1681: l_CURR_DETAILS_rec.attribute15)
1682: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute2,
1676: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute13,
1677: l_CURR_DETAILS_rec.attribute13)
1678: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute14,
1679: l_CURR_DETAILS_rec.attribute14)
1680: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute15,
1681: l_CURR_DETAILS_rec.attribute15)
1682: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute2,
1683: l_CURR_DETAILS_rec.attribute2)
1684: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute3,
1678: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute14,
1679: l_CURR_DETAILS_rec.attribute14)
1680: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute15,
1681: l_CURR_DETAILS_rec.attribute15)
1682: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute2,
1683: l_CURR_DETAILS_rec.attribute2)
1684: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute3,
1685: l_CURR_DETAILS_rec.attribute3)
1686: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute4,
1680: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute15,
1681: l_CURR_DETAILS_rec.attribute15)
1682: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute2,
1683: l_CURR_DETAILS_rec.attribute2)
1684: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute3,
1685: l_CURR_DETAILS_rec.attribute3)
1686: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute4,
1687: l_CURR_DETAILS_rec.attribute4)
1688: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute5,
1682: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute2,
1683: l_CURR_DETAILS_rec.attribute2)
1684: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute3,
1685: l_CURR_DETAILS_rec.attribute3)
1686: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute4,
1687: l_CURR_DETAILS_rec.attribute4)
1688: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute5,
1689: l_CURR_DETAILS_rec.attribute5)
1690: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute6,
1684: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute3,
1685: l_CURR_DETAILS_rec.attribute3)
1686: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute4,
1687: l_CURR_DETAILS_rec.attribute4)
1688: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute5,
1689: l_CURR_DETAILS_rec.attribute5)
1690: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute6,
1691: l_CURR_DETAILS_rec.attribute6)
1692: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute7,
1686: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute4,
1687: l_CURR_DETAILS_rec.attribute4)
1688: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute5,
1689: l_CURR_DETAILS_rec.attribute5)
1690: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute6,
1691: l_CURR_DETAILS_rec.attribute6)
1692: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute7,
1693: l_CURR_DETAILS_rec.attribute7)
1694: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute8,
1688: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute5,
1689: l_CURR_DETAILS_rec.attribute5)
1690: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute6,
1691: l_CURR_DETAILS_rec.attribute6)
1692: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute7,
1693: l_CURR_DETAILS_rec.attribute7)
1694: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute8,
1695: l_CURR_DETAILS_rec.attribute8)
1696: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute9,
1690: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute6,
1691: l_CURR_DETAILS_rec.attribute6)
1692: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute7,
1693: l_CURR_DETAILS_rec.attribute7)
1694: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute8,
1695: l_CURR_DETAILS_rec.attribute8)
1696: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute9,
1697: l_CURR_DETAILS_rec.attribute9)
1698: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.context,
1692: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute7,
1693: l_CURR_DETAILS_rec.attribute7)
1694: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute8,
1695: l_CURR_DETAILS_rec.attribute8)
1696: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute9,
1697: l_CURR_DETAILS_rec.attribute9)
1698: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.context,
1699: l_CURR_DETAILS_rec.context)
1700: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date,
1694: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute8,
1695: l_CURR_DETAILS_rec.attribute8)
1696: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute9,
1697: l_CURR_DETAILS_rec.attribute9)
1698: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.context,
1699: l_CURR_DETAILS_rec.context)
1700: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date,
1701: l_CURR_DETAILS_rec.conversion_date)
1702: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date_type,
1696: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.attribute9,
1697: l_CURR_DETAILS_rec.attribute9)
1698: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.context,
1699: l_CURR_DETAILS_rec.context)
1700: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date,
1701: l_CURR_DETAILS_rec.conversion_date)
1702: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date_type,
1703: l_CURR_DETAILS_rec.conversion_date_type)
1704: -- AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_method,
1698: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.context,
1699: l_CURR_DETAILS_rec.context)
1700: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date,
1701: l_CURR_DETAILS_rec.conversion_date)
1702: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date_type,
1703: l_CURR_DETAILS_rec.conversion_date_type)
1704: -- AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_method,
1705: -- l_CURR_DETAILS_rec.conversion_method)
1706: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_type,
1700: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date,
1701: l_CURR_DETAILS_rec.conversion_date)
1702: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date_type,
1703: l_CURR_DETAILS_rec.conversion_date_type)
1704: -- AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_method,
1705: -- l_CURR_DETAILS_rec.conversion_method)
1706: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_type,
1707: l_CURR_DETAILS_rec.conversion_type)
1708: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.created_by,
1702: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_date_type,
1703: l_CURR_DETAILS_rec.conversion_date_type)
1704: -- AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_method,
1705: -- l_CURR_DETAILS_rec.conversion_method)
1706: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_type,
1707: l_CURR_DETAILS_rec.conversion_type)
1708: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.created_by,
1709: l_CURR_DETAILS_rec.created_by)
1710: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.creation_date,
1704: -- AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_method,
1705: -- l_CURR_DETAILS_rec.conversion_method)
1706: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_type,
1707: l_CURR_DETAILS_rec.conversion_type)
1708: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.created_by,
1709: l_CURR_DETAILS_rec.created_by)
1710: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.creation_date,
1711: l_CURR_DETAILS_rec.creation_date)
1712: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_detail_id,
1706: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.conversion_type,
1707: l_CURR_DETAILS_rec.conversion_type)
1708: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.created_by,
1709: l_CURR_DETAILS_rec.created_by)
1710: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.creation_date,
1711: l_CURR_DETAILS_rec.creation_date)
1712: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_detail_id,
1713: l_CURR_DETAILS_rec.currency_detail_id)
1714: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_header_id,
1708: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.created_by,
1709: l_CURR_DETAILS_rec.created_by)
1710: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.creation_date,
1711: l_CURR_DETAILS_rec.creation_date)
1712: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_detail_id,
1713: l_CURR_DETAILS_rec.currency_detail_id)
1714: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_header_id,
1715: l_CURR_DETAILS_rec.currency_header_id)
1716: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.end_date_active,
1710: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.creation_date,
1711: l_CURR_DETAILS_rec.creation_date)
1712: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_detail_id,
1713: l_CURR_DETAILS_rec.currency_detail_id)
1714: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_header_id,
1715: l_CURR_DETAILS_rec.currency_header_id)
1716: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.end_date_active,
1717: l_CURR_DETAILS_rec.end_date_active)
1718: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.fixed_value,
1712: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_detail_id,
1713: l_CURR_DETAILS_rec.currency_detail_id)
1714: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_header_id,
1715: l_CURR_DETAILS_rec.currency_header_id)
1716: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.end_date_active,
1717: l_CURR_DETAILS_rec.end_date_active)
1718: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.fixed_value,
1719: l_CURR_DETAILS_rec.fixed_value)
1720: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_updated_by,
1714: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_header_id,
1715: l_CURR_DETAILS_rec.currency_header_id)
1716: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.end_date_active,
1717: l_CURR_DETAILS_rec.end_date_active)
1718: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.fixed_value,
1719: l_CURR_DETAILS_rec.fixed_value)
1720: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_updated_by,
1721: l_CURR_DETAILS_rec.last_updated_by)
1722: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_date,
1716: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.end_date_active,
1717: l_CURR_DETAILS_rec.end_date_active)
1718: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.fixed_value,
1719: l_CURR_DETAILS_rec.fixed_value)
1720: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_updated_by,
1721: l_CURR_DETAILS_rec.last_updated_by)
1722: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_date,
1723: l_CURR_DETAILS_rec.last_update_date)
1724: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_login,
1718: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.fixed_value,
1719: l_CURR_DETAILS_rec.fixed_value)
1720: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_updated_by,
1721: l_CURR_DETAILS_rec.last_updated_by)
1722: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_date,
1723: l_CURR_DETAILS_rec.last_update_date)
1724: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_login,
1725: l_CURR_DETAILS_rec.last_update_login)
1726: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_formula_id,
1720: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_updated_by,
1721: l_CURR_DETAILS_rec.last_updated_by)
1722: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_date,
1723: l_CURR_DETAILS_rec.last_update_date)
1724: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_login,
1725: l_CURR_DETAILS_rec.last_update_login)
1726: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_formula_id,
1727: l_CURR_DETAILS_rec.markup_formula_id)
1728: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_operator,
1722: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_date,
1723: l_CURR_DETAILS_rec.last_update_date)
1724: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_login,
1725: l_CURR_DETAILS_rec.last_update_login)
1726: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_formula_id,
1727: l_CURR_DETAILS_rec.markup_formula_id)
1728: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_operator,
1729: l_CURR_DETAILS_rec.markup_operator)
1730: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_value,
1724: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.last_update_login,
1725: l_CURR_DETAILS_rec.last_update_login)
1726: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_formula_id,
1727: l_CURR_DETAILS_rec.markup_formula_id)
1728: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_operator,
1729: l_CURR_DETAILS_rec.markup_operator)
1730: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_value,
1731: l_CURR_DETAILS_rec.markup_value)
1732: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.price_formula_id,
1726: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_formula_id,
1727: l_CURR_DETAILS_rec.markup_formula_id)
1728: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_operator,
1729: l_CURR_DETAILS_rec.markup_operator)
1730: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_value,
1731: l_CURR_DETAILS_rec.markup_value)
1732: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.price_formula_id,
1733: l_CURR_DETAILS_rec.price_formula_id)
1734: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_application_id,
1728: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_operator,
1729: l_CURR_DETAILS_rec.markup_operator)
1730: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_value,
1731: l_CURR_DETAILS_rec.markup_value)
1732: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.price_formula_id,
1733: l_CURR_DETAILS_rec.price_formula_id)
1734: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_application_id,
1735: l_CURR_DETAILS_rec.program_application_id)
1736: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_id,
1730: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_value,
1731: l_CURR_DETAILS_rec.markup_value)
1732: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.price_formula_id,
1733: l_CURR_DETAILS_rec.price_formula_id)
1734: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_application_id,
1735: l_CURR_DETAILS_rec.program_application_id)
1736: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_id,
1737: l_CURR_DETAILS_rec.program_id)
1738: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_update_date,
1732: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.price_formula_id,
1733: l_CURR_DETAILS_rec.price_formula_id)
1734: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_application_id,
1735: l_CURR_DETAILS_rec.program_application_id)
1736: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_id,
1737: l_CURR_DETAILS_rec.program_id)
1738: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_update_date,
1739: l_CURR_DETAILS_rec.program_update_date)
1740: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.request_id,
1734: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_application_id,
1735: l_CURR_DETAILS_rec.program_application_id)
1736: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_id,
1737: l_CURR_DETAILS_rec.program_id)
1738: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_update_date,
1739: l_CURR_DETAILS_rec.program_update_date)
1740: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.request_id,
1741: l_CURR_DETAILS_rec.request_id)
1742: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.rounding_factor,
1736: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_id,
1737: l_CURR_DETAILS_rec.program_id)
1738: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_update_date,
1739: l_CURR_DETAILS_rec.program_update_date)
1740: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.request_id,
1741: l_CURR_DETAILS_rec.request_id)
1742: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.rounding_factor,
1743: l_CURR_DETAILS_rec.rounding_factor)
1744: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.selling_rounding_factor,
1738: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.program_update_date,
1739: l_CURR_DETAILS_rec.program_update_date)
1740: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.request_id,
1741: l_CURR_DETAILS_rec.request_id)
1742: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.rounding_factor,
1743: l_CURR_DETAILS_rec.rounding_factor)
1744: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.selling_rounding_factor,
1745: l_CURR_DETAILS_rec.selling_rounding_factor)
1746: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.start_date_active,
1740: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.request_id,
1741: l_CURR_DETAILS_rec.request_id)
1742: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.rounding_factor,
1743: l_CURR_DETAILS_rec.rounding_factor)
1744: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.selling_rounding_factor,
1745: l_CURR_DETAILS_rec.selling_rounding_factor)
1746: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.start_date_active,
1747: l_CURR_DETAILS_rec.start_date_active)
1748: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.to_currency_code,
1742: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.rounding_factor,
1743: l_CURR_DETAILS_rec.rounding_factor)
1744: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.selling_rounding_factor,
1745: l_CURR_DETAILS_rec.selling_rounding_factor)
1746: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.start_date_active,
1747: l_CURR_DETAILS_rec.start_date_active)
1748: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.to_currency_code,
1749: l_CURR_DETAILS_rec.to_currency_code)
1750: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_type,
1744: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.selling_rounding_factor,
1745: l_CURR_DETAILS_rec.selling_rounding_factor)
1746: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.start_date_active,
1747: l_CURR_DETAILS_rec.start_date_active)
1748: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.to_currency_code,
1749: l_CURR_DETAILS_rec.to_currency_code)
1750: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_type,
1751: l_CURR_DETAILS_rec.curr_attribute_type)
1752: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_context,
1746: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.start_date_active,
1747: l_CURR_DETAILS_rec.start_date_active)
1748: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.to_currency_code,
1749: l_CURR_DETAILS_rec.to_currency_code)
1750: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_type,
1751: l_CURR_DETAILS_rec.curr_attribute_type)
1752: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_context,
1753: l_CURR_DETAILS_rec.curr_attribute_context)
1754: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute,
1748: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.to_currency_code,
1749: l_CURR_DETAILS_rec.to_currency_code)
1750: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_type,
1751: l_CURR_DETAILS_rec.curr_attribute_type)
1752: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_context,
1753: l_CURR_DETAILS_rec.curr_attribute_context)
1754: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute,
1755: l_CURR_DETAILS_rec.curr_attribute)
1756: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_value,
1750: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_type,
1751: l_CURR_DETAILS_rec.curr_attribute_type)
1752: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_context,
1753: l_CURR_DETAILS_rec.curr_attribute_context)
1754: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute,
1755: l_CURR_DETAILS_rec.curr_attribute)
1756: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_value,
1757: l_CURR_DETAILS_rec.curr_attribute_value)
1758: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.precedence,
1752: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_context,
1753: l_CURR_DETAILS_rec.curr_attribute_context)
1754: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute,
1755: l_CURR_DETAILS_rec.curr_attribute)
1756: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_value,
1757: l_CURR_DETAILS_rec.curr_attribute_value)
1758: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.precedence,
1759: l_CURR_DETAILS_rec.precedence)
1760: THEN
1754: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute,
1755: l_CURR_DETAILS_rec.curr_attribute)
1756: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.curr_attribute_value,
1757: l_CURR_DETAILS_rec.curr_attribute_value)
1758: AND QP_GLOBALS.Equal(p_CURR_DETAILS_rec.precedence,
1759: l_CURR_DETAILS_rec.precedence)
1760: THEN
1761:
1762: -- Row has not changed. Set out parameter.
1838: BEGIN
1839:
1840: IF p_CURR_DETAILS_rec.currency_detail_id IS NOT NULL AND
1841: p_CURR_DETAILS_rec.currency_detail_id <> FND_API.G_MISS_NUM AND
1842: NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_detail_id,
1843: p_old_CURR_DETAILS_rec.currency_detail_id)
1844: THEN
1845: l_CURR_DETAILS_val_rec.currency_detail := QP_Id_To_Value.Currency_Detail
1846: ( p_currency_detail_id => p_CURR_DETAILS_rec.currency_detail_id
1848: END IF;
1849:
1850: IF p_CURR_DETAILS_rec.currency_header_id IS NOT NULL AND
1851: p_CURR_DETAILS_rec.currency_header_id <> FND_API.G_MISS_NUM AND
1852: NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_header_id,
1853: p_old_CURR_DETAILS_rec.currency_header_id)
1854: THEN
1855: l_CURR_DETAILS_val_rec.currency_header := QP_Id_To_Value.Currency_Header
1856: ( p_currency_header_id => p_CURR_DETAILS_rec.currency_header_id
1858: END IF;
1859:
1860: IF p_CURR_DETAILS_rec.markup_formula_id IS NOT NULL AND
1861: p_CURR_DETAILS_rec.markup_formula_id <> FND_API.G_MISS_NUM AND
1862: NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_formula_id,
1863: p_old_CURR_DETAILS_rec.markup_formula_id)
1864: THEN
1865: l_CURR_DETAILS_val_rec.markup_formula := QP_Id_To_Value.Markup_Formula
1866: ( p_markup_formula_id => p_CURR_DETAILS_rec.markup_formula_id
1868: END IF;
1869:
1870: IF p_CURR_DETAILS_rec.price_formula_id IS NOT NULL AND
1871: p_CURR_DETAILS_rec.price_formula_id <> FND_API.G_MISS_NUM AND
1872: NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.price_formula_id,
1873: p_old_CURR_DETAILS_rec.price_formula_id)
1874: THEN
1875: l_CURR_DETAILS_val_rec.price_formula := QP_Id_To_Value.Price_Formula
1876: ( p_price_formula_id => p_CURR_DETAILS_rec.price_formula_id
1878: END IF;
1879:
1880: IF p_CURR_DETAILS_rec.to_currency_code IS NOT NULL AND
1881: p_CURR_DETAILS_rec.to_currency_code <> FND_API.G_MISS_CHAR AND
1882: NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.to_currency_code,
1883: p_old_CURR_DETAILS_rec.to_currency_code)
1884: THEN
1885: l_CURR_DETAILS_val_rec.to_currency := QP_Id_To_Value.To_Currency
1886: ( p_to_currency_code => p_CURR_DETAILS_rec.to_currency_code