DBA Data[Home] [Help]

APPS.QP_QP_FORM_CURR_LISTS dependencies on QP_CURR_LISTS_UTIL

Line 174: l_CURR_LISTS_val_rec := QP_Curr_Lists_Util.Get_Values

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;

Line 346: IF p_attr_id = QP_Curr_Lists_Util.G_BASE_CURRENCY THEN

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

Line 348: ELSIF p_attr_id = QP_Curr_Lists_Util.G_CURRENCY_HEADER 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

Line 350: ELSIF p_attr_id = QP_Curr_Lists_Util.G_DESCRIPTION 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

Line 352: ELSIF p_attr_id = QP_Curr_Lists_Util.G_NAME 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

Line 354: ELSIF p_attr_id = QP_Curr_Lists_Util.G_base_rounding_factor 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

Line 356: ELSIF p_attr_id = QP_Curr_Lists_Util.G_base_markup_operator 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);

Line 358: ELSIF p_attr_id = QP_Curr_Lists_Util.G_base_markup_value THEN

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);

Line 361: ELSIF p_attr_id = QP_Curr_Lists_Util.G_base_markup_formula 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);
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

Line 363: -- ELSIF p_attr_id = QP_Curr_Lists_Util.G_ROW 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
366: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE10
367: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE11

Line 365: ELSIF p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE1

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

Line 366: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE10

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

Line 367: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE11

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

Line 368: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE12

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

Line 369: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE13

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

Line 370: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE14

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

Line 371: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE15

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

Line 372: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE2

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

Line 373: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE3

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

Line 374: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE4

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

Line 375: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE5

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

Line 376: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE6

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

Line 377: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE7

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

Line 378: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE8

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:

Line 379: OR p_attr_id = QP_Curr_Lists_Util.G_ATTRIBUTE9

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;

Line 380: OR p_attr_id = QP_Curr_Lists_Util.G_CONTEXT

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;

Line 488: l_CURR_LISTS_val_rec := QP_Curr_Lists_Util.Get_Values

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:

Line 1421: -- oe_debug_pub.add('BEFORE CALLING QP_Curr_Lists_Util.Query_Row');

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

Line 1424: g_CURR_LISTS_rec := QP_Curr_Lists_Util.Query_Row

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;