170: -- x_row_id := l_x_CURR_LISTS_rec.row_id; -- Commented by Sunil
171:
172: -- Load display out parameters if any
173:
174: l_CURR_LISTS_val_rec := QP_Curr_Lists_Util.Get_Values
175: ( p_CURR_LISTS_rec => l_x_CURR_LISTS_rec
176: );
177: x_base_currency := l_CURR_LISTS_val_rec.base_currency;
178: x_currency_header := l_CURR_LISTS_val_rec.currency_header;
342: -- oe_debug_pub.add('DB_FLAG:'|| l_CURR_LISTS_rec.db_flag );
343:
344: l_old_CURR_LISTS_rec := l_CURR_LISTS_rec;
345:
346: IF p_attr_id = QP_Curr_Lists_Util.G_BASE_CURRENCY THEN
347: l_CURR_LISTS_rec.base_currency_code := p_attr_value;
348: ELSIF p_attr_id = QP_Curr_Lists_Util.G_CURRENCY_HEADER THEN
349: l_CURR_LISTS_rec.currency_header_id := TO_NUMBER(p_attr_value);
350: ELSIF p_attr_id = QP_Curr_Lists_Util.G_DESCRIPTION THEN
344: l_old_CURR_LISTS_rec := l_CURR_LISTS_rec;
345:
346: IF p_attr_id = QP_Curr_Lists_Util.G_BASE_CURRENCY THEN
347: l_CURR_LISTS_rec.base_currency_code := p_attr_value;
348: ELSIF p_attr_id = QP_Curr_Lists_Util.G_CURRENCY_HEADER THEN
349: l_CURR_LISTS_rec.currency_header_id := TO_NUMBER(p_attr_value);
350: ELSIF p_attr_id = QP_Curr_Lists_Util.G_DESCRIPTION THEN
351: l_CURR_LISTS_rec.description := p_attr_value;
352: ELSIF p_attr_id = QP_Curr_Lists_Util.G_NAME THEN
346: IF p_attr_id = QP_Curr_Lists_Util.G_BASE_CURRENCY THEN
347: l_CURR_LISTS_rec.base_currency_code := p_attr_value;
348: ELSIF p_attr_id = QP_Curr_Lists_Util.G_CURRENCY_HEADER THEN
349: l_CURR_LISTS_rec.currency_header_id := TO_NUMBER(p_attr_value);
350: ELSIF p_attr_id = QP_Curr_Lists_Util.G_DESCRIPTION THEN
351: l_CURR_LISTS_rec.description := p_attr_value;
352: ELSIF p_attr_id = QP_Curr_Lists_Util.G_NAME THEN
353: l_CURR_LISTS_rec.name := p_attr_value;
354: ELSIF p_attr_id = QP_Curr_Lists_Util.G_base_rounding_factor THEN
348: ELSIF p_attr_id = QP_Curr_Lists_Util.G_CURRENCY_HEADER THEN
349: l_CURR_LISTS_rec.currency_header_id := TO_NUMBER(p_attr_value);
350: ELSIF p_attr_id = QP_Curr_Lists_Util.G_DESCRIPTION THEN
351: l_CURR_LISTS_rec.description := p_attr_value;
352: ELSIF p_attr_id = QP_Curr_Lists_Util.G_NAME THEN
353: l_CURR_LISTS_rec.name := p_attr_value;
354: ELSIF p_attr_id = QP_Curr_Lists_Util.G_base_rounding_factor THEN
355: l_CURR_LISTS_rec.base_rounding_factor := TO_NUMBER(p_attr_value);
356: ELSIF p_attr_id = QP_Curr_Lists_Util.G_base_markup_operator THEN
350: ELSIF p_attr_id = QP_Curr_Lists_Util.G_DESCRIPTION THEN
351: l_CURR_LISTS_rec.description := p_attr_value;
352: ELSIF p_attr_id = QP_Curr_Lists_Util.G_NAME THEN
353: l_CURR_LISTS_rec.name := p_attr_value;
354: ELSIF p_attr_id = QP_Curr_Lists_Util.G_base_rounding_factor THEN
355: l_CURR_LISTS_rec.base_rounding_factor := TO_NUMBER(p_attr_value);
356: ELSIF p_attr_id = QP_Curr_Lists_Util.G_base_markup_operator THEN
357: l_CURR_LISTS_rec.base_markup_operator := p_attr_value;
358: ELSIF p_attr_id = QP_Curr_Lists_Util.G_base_markup_value THEN
352: ELSIF p_attr_id = QP_Curr_Lists_Util.G_NAME THEN
353: l_CURR_LISTS_rec.name := p_attr_value;
354: ELSIF p_attr_id = QP_Curr_Lists_Util.G_base_rounding_factor THEN
355: l_CURR_LISTS_rec.base_rounding_factor := TO_NUMBER(p_attr_value);
356: ELSIF p_attr_id = QP_Curr_Lists_Util.G_base_markup_operator THEN
357: l_CURR_LISTS_rec.base_markup_operator := p_attr_value;
358: ELSIF p_attr_id = QP_Curr_Lists_Util.G_base_markup_value THEN
359: -- oe_debug_pub.add('Assigning Base Markup Value');
360: l_CURR_LISTS_rec.base_markup_value := TO_NUMBER(p_attr_value);
354: ELSIF p_attr_id = QP_Curr_Lists_Util.G_base_rounding_factor THEN
355: l_CURR_LISTS_rec.base_rounding_factor := TO_NUMBER(p_attr_value);
356: ELSIF p_attr_id = QP_Curr_Lists_Util.G_base_markup_operator THEN
357: l_CURR_LISTS_rec.base_markup_operator := p_attr_value;
358: ELSIF p_attr_id = QP_Curr_Lists_Util.G_base_markup_value THEN
359: -- oe_debug_pub.add('Assigning Base Markup Value');
360: l_CURR_LISTS_rec.base_markup_value := TO_NUMBER(p_attr_value);
361: ELSIF p_attr_id = QP_Curr_Lists_Util.G_base_markup_formula THEN
362: l_CURR_LISTS_rec.base_markup_formula_id := TO_NUMBER(p_attr_value);
357: l_CURR_LISTS_rec.base_markup_operator := p_attr_value;
358: ELSIF p_attr_id = QP_Curr_Lists_Util.G_base_markup_value THEN
359: -- oe_debug_pub.add('Assigning Base Markup Value');
360: l_CURR_LISTS_rec.base_markup_value := TO_NUMBER(p_attr_value);
361: ELSIF p_attr_id = QP_Curr_Lists_Util.G_base_markup_formula THEN
362: l_CURR_LISTS_rec.base_markup_formula_id := TO_NUMBER(p_attr_value);
363: -- ELSIF p_attr_id = QP_Curr_Lists_Util.G_ROW THEN
364: -- l_CURR_LISTS_rec.row_idELSIF
365: ELSIF p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE1
359: -- oe_debug_pub.add('Assigning Base Markup Value');
360: l_CURR_LISTS_rec.base_markup_value := TO_NUMBER(p_attr_value);
361: ELSIF p_attr_id = QP_Curr_Lists_Util.G_base_markup_formula THEN
362: l_CURR_LISTS_rec.base_markup_formula_id := TO_NUMBER(p_attr_value);
363: -- ELSIF p_attr_id = QP_Curr_Lists_Util.G_ROW THEN
364: -- l_CURR_LISTS_rec.row_idELSIF
365: ELSIF p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE1
366: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE10
367: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE11
361: ELSIF p_attr_id = QP_Curr_Lists_Util.G_base_markup_formula THEN
362: l_CURR_LISTS_rec.base_markup_formula_id := TO_NUMBER(p_attr_value);
363: -- ELSIF p_attr_id = QP_Curr_Lists_Util.G_ROW THEN
364: -- l_CURR_LISTS_rec.row_idELSIF
365: ELSIF p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE1
366: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE10
367: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE11
368: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE12
369: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE13
362: l_CURR_LISTS_rec.base_markup_formula_id := TO_NUMBER(p_attr_value);
363: -- ELSIF p_attr_id = QP_Curr_Lists_Util.G_ROW THEN
364: -- l_CURR_LISTS_rec.row_idELSIF
365: ELSIF p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE1
366: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE10
367: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE11
368: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE12
369: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE13
370: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE14
363: -- ELSIF p_attr_id = QP_Curr_Lists_Util.G_ROW THEN
364: -- l_CURR_LISTS_rec.row_idELSIF
365: ELSIF p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE1
366: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE10
367: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE11
368: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE12
369: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE13
370: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE14
371: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE15
364: -- l_CURR_LISTS_rec.row_idELSIF
365: ELSIF p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE1
366: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE10
367: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE11
368: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE12
369: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE13
370: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE14
371: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE15
372: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE2
365: ELSIF p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE1
366: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE10
367: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE11
368: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE12
369: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE13
370: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE14
371: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE15
372: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE2
373: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE3
366: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE10
367: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE11
368: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE12
369: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE13
370: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE14
371: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE15
372: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE2
373: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE3
374: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE4
367: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE11
368: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE12
369: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE13
370: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE14
371: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE15
372: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE2
373: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE3
374: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE4
375: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE5
368: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE12
369: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE13
370: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE14
371: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE15
372: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE2
373: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE3
374: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE4
375: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE5
376: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE6
369: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE13
370: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE14
371: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE15
372: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE2
373: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE3
374: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE4
375: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE5
376: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE6
377: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE7
370: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE14
371: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE15
372: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE2
373: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE3
374: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE4
375: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE5
376: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE6
377: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE7
378: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE8
371: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE15
372: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE2
373: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE3
374: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE4
375: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE5
376: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE6
377: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE7
378: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE8
379: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE9
372: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE2
373: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE3
374: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE4
375: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE5
376: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE6
377: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE7
378: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE8
379: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE9
380: OR p_attr_id = QP_Curr_Lists_Util.G_CONTEXT
373: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE3
374: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE4
375: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE5
376: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE6
377: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE7
378: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE8
379: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE9
380: OR p_attr_id = QP_Curr_Lists_Util.G_CONTEXT
381: THEN
374: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE4
375: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE5
376: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE6
377: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE7
378: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE8
379: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE9
380: OR p_attr_id = QP_Curr_Lists_Util.G_CONTEXT
381: THEN
382:
375: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE5
376: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE6
377: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE7
378: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE8
379: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE9
380: OR p_attr_id = QP_Curr_Lists_Util.G_CONTEXT
381: THEN
382:
383: l_CURR_LISTS_rec.attribute1 := p_attribute1;
376: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE6
377: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE7
378: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE8
379: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE9
380: OR p_attr_id = QP_Curr_Lists_Util.G_CONTEXT
381: THEN
382:
383: l_CURR_LISTS_rec.attribute1 := p_attribute1;
384: l_CURR_LISTS_rec.attribute10 := p_attribute10;
484:
485: -- oe_debug_pub.add('%%Inside F- Change_Attribute; CHECK-POINT-1');
486: -- Load display out parameters if any
487:
488: l_CURR_LISTS_val_rec := QP_Curr_Lists_Util.Get_Values
489: ( p_CURR_LISTS_rec => l_x_CURR_LISTS_rec
490: , p_old_CURR_LISTS_rec => l_CURR_LISTS_rec
491: );
492:
1417: -- oe_debug_pub.add('Inside QPXFCURB.Get_CURR_LISTS; g_CURR_LISTS_rec.description :'||g_CURR_LISTS_rec.description);
1418: IF p_currency_header_id <> g_CURR_LISTS_rec.currency_header_id
1419: THEN
1420:
1421: -- oe_debug_pub.add('BEFORE CALLING QP_Curr_Lists_Util.Query_Row');
1422: -- Query row from DB
1423:
1424: g_CURR_LISTS_rec := QP_Curr_Lists_Util.Query_Row
1425: ( p_currency_header_id => p_currency_header_id
1420:
1421: -- oe_debug_pub.add('BEFORE CALLING QP_Curr_Lists_Util.Query_Row');
1422: -- Query row from DB
1423:
1424: g_CURR_LISTS_rec := QP_Curr_Lists_Util.Query_Row
1425: ( p_currency_header_id => p_currency_header_id
1426: );
1427:
1428: g_CURR_LISTS_rec.db_flag := FND_API.G_TRUE;