eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_OE_FORM_PRICE_BREAK dependencies on OE_PRICE_BREAK_UTIL

Line 222: l_Price_Break_val_rec := OE_Price_Break_Util.Get_Values

218: x_unit_code := l_x_Price_Break_rec.unit_code;
219:
220: -- Load display out parameters if any
221:
222: l_Price_Break_val_rec := OE_Price_Break_Util.Get_Values
223: ( p_Price_Break_rec => l_x_Price_Break_rec
224: );
225: x_discount_line := l_Price_Break_val_rec.discount_line;
226: x_method_type := l_Price_Break_val_rec.method_type;

Line 403: IF p_attr_id = OE_Price_Break_Util.G_AMOUNT THEN

399: );
400:
401: l_old_Price_Break_rec := l_Price_Break_rec;
402:
403: IF p_attr_id = OE_Price_Break_Util.G_AMOUNT THEN
404: l_Price_Break_rec.amount := TO_NUMBER(p_attr_value);
405: ELSIF p_attr_id = OE_Price_Break_Util.G_DISCOUNT_LINE THEN
406: l_Price_Break_rec.discount_line_id := TO_NUMBER(p_attr_value);
407: ELSIF p_attr_id = OE_Price_Break_Util.G_END_DATE_ACTIVE THEN

Line 405: ELSIF p_attr_id = OE_Price_Break_Util.G_DISCOUNT_LINE THEN

401: l_old_Price_Break_rec := l_Price_Break_rec;
402:
403: IF p_attr_id = OE_Price_Break_Util.G_AMOUNT THEN
404: l_Price_Break_rec.amount := TO_NUMBER(p_attr_value);
405: ELSIF p_attr_id = OE_Price_Break_Util.G_DISCOUNT_LINE THEN
406: l_Price_Break_rec.discount_line_id := TO_NUMBER(p_attr_value);
407: ELSIF p_attr_id = OE_Price_Break_Util.G_END_DATE_ACTIVE THEN
408: l_Price_Break_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
409: ELSIF p_attr_id = OE_Price_Break_Util.G_METHOD_TYPE THEN

Line 407: ELSIF p_attr_id = OE_Price_Break_Util.G_END_DATE_ACTIVE THEN

403: IF p_attr_id = OE_Price_Break_Util.G_AMOUNT THEN
404: l_Price_Break_rec.amount := TO_NUMBER(p_attr_value);
405: ELSIF p_attr_id = OE_Price_Break_Util.G_DISCOUNT_LINE THEN
406: l_Price_Break_rec.discount_line_id := TO_NUMBER(p_attr_value);
407: ELSIF p_attr_id = OE_Price_Break_Util.G_END_DATE_ACTIVE THEN
408: l_Price_Break_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
409: ELSIF p_attr_id = OE_Price_Break_Util.G_METHOD_TYPE THEN
410: l_Price_Break_rec.method_type_code := p_attr_value;
411: ELSIF p_attr_id = OE_Price_Break_Util.G_PERCENT THEN

Line 409: ELSIF p_attr_id = OE_Price_Break_Util.G_METHOD_TYPE THEN

405: ELSIF p_attr_id = OE_Price_Break_Util.G_DISCOUNT_LINE THEN
406: l_Price_Break_rec.discount_line_id := TO_NUMBER(p_attr_value);
407: ELSIF p_attr_id = OE_Price_Break_Util.G_END_DATE_ACTIVE THEN
408: l_Price_Break_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
409: ELSIF p_attr_id = OE_Price_Break_Util.G_METHOD_TYPE THEN
410: l_Price_Break_rec.method_type_code := p_attr_value;
411: ELSIF p_attr_id = OE_Price_Break_Util.G_PERCENT THEN
412: l_Price_Break_rec.percent := TO_NUMBER(p_attr_value);
413: ELSIF p_attr_id = OE_Price_Break_Util.G_PRICE THEN

Line 411: ELSIF p_attr_id = OE_Price_Break_Util.G_PERCENT THEN

407: ELSIF p_attr_id = OE_Price_Break_Util.G_END_DATE_ACTIVE THEN
408: l_Price_Break_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
409: ELSIF p_attr_id = OE_Price_Break_Util.G_METHOD_TYPE THEN
410: l_Price_Break_rec.method_type_code := p_attr_value;
411: ELSIF p_attr_id = OE_Price_Break_Util.G_PERCENT THEN
412: l_Price_Break_rec.percent := TO_NUMBER(p_attr_value);
413: ELSIF p_attr_id = OE_Price_Break_Util.G_PRICE THEN
414: l_Price_Break_rec.price := TO_NUMBER(p_attr_value);
415: ELSIF p_attr_id = OE_Price_Break_Util.G_PRICE_BREAK_HIGH THEN

Line 413: ELSIF p_attr_id = OE_Price_Break_Util.G_PRICE THEN

409: ELSIF p_attr_id = OE_Price_Break_Util.G_METHOD_TYPE THEN
410: l_Price_Break_rec.method_type_code := p_attr_value;
411: ELSIF p_attr_id = OE_Price_Break_Util.G_PERCENT THEN
412: l_Price_Break_rec.percent := TO_NUMBER(p_attr_value);
413: ELSIF p_attr_id = OE_Price_Break_Util.G_PRICE THEN
414: l_Price_Break_rec.price := TO_NUMBER(p_attr_value);
415: ELSIF p_attr_id = OE_Price_Break_Util.G_PRICE_BREAK_HIGH THEN
416: l_Price_Break_rec.price_break_high := TO_NUMBER(p_attr_value);
417: ELSIF p_attr_id = OE_Price_Break_Util.G_PRICE_BREAK_LOW THEN

Line 415: ELSIF p_attr_id = OE_Price_Break_Util.G_PRICE_BREAK_HIGH THEN

411: ELSIF p_attr_id = OE_Price_Break_Util.G_PERCENT THEN
412: l_Price_Break_rec.percent := TO_NUMBER(p_attr_value);
413: ELSIF p_attr_id = OE_Price_Break_Util.G_PRICE THEN
414: l_Price_Break_rec.price := TO_NUMBER(p_attr_value);
415: ELSIF p_attr_id = OE_Price_Break_Util.G_PRICE_BREAK_HIGH THEN
416: l_Price_Break_rec.price_break_high := TO_NUMBER(p_attr_value);
417: ELSIF p_attr_id = OE_Price_Break_Util.G_PRICE_BREAK_LOW THEN
418: l_Price_Break_rec.price_break_low := TO_NUMBER(p_attr_value);
419: ELSIF p_attr_id = OE_Price_Break_Util.G_START_DATE_ACTIVE THEN

Line 417: ELSIF p_attr_id = OE_Price_Break_Util.G_PRICE_BREAK_LOW THEN

413: ELSIF p_attr_id = OE_Price_Break_Util.G_PRICE THEN
414: l_Price_Break_rec.price := TO_NUMBER(p_attr_value);
415: ELSIF p_attr_id = OE_Price_Break_Util.G_PRICE_BREAK_HIGH THEN
416: l_Price_Break_rec.price_break_high := TO_NUMBER(p_attr_value);
417: ELSIF p_attr_id = OE_Price_Break_Util.G_PRICE_BREAK_LOW THEN
418: l_Price_Break_rec.price_break_low := TO_NUMBER(p_attr_value);
419: ELSIF p_attr_id = OE_Price_Break_Util.G_START_DATE_ACTIVE THEN
420: l_Price_Break_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
421: ELSIF p_attr_id = OE_Price_Break_Util.G_UNIT THEN

Line 419: ELSIF p_attr_id = OE_Price_Break_Util.G_START_DATE_ACTIVE THEN

415: ELSIF p_attr_id = OE_Price_Break_Util.G_PRICE_BREAK_HIGH THEN
416: l_Price_Break_rec.price_break_high := TO_NUMBER(p_attr_value);
417: ELSIF p_attr_id = OE_Price_Break_Util.G_PRICE_BREAK_LOW THEN
418: l_Price_Break_rec.price_break_low := TO_NUMBER(p_attr_value);
419: ELSIF p_attr_id = OE_Price_Break_Util.G_START_DATE_ACTIVE THEN
420: l_Price_Break_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
421: ELSIF p_attr_id = OE_Price_Break_Util.G_UNIT THEN
422: l_Price_Break_rec.unit_code := p_attr_value;
423: ELSIF p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE1

Line 421: ELSIF p_attr_id = OE_Price_Break_Util.G_UNIT THEN

417: ELSIF p_attr_id = OE_Price_Break_Util.G_PRICE_BREAK_LOW THEN
418: l_Price_Break_rec.price_break_low := TO_NUMBER(p_attr_value);
419: ELSIF p_attr_id = OE_Price_Break_Util.G_START_DATE_ACTIVE THEN
420: l_Price_Break_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
421: ELSIF p_attr_id = OE_Price_Break_Util.G_UNIT THEN
422: l_Price_Break_rec.unit_code := p_attr_value;
423: ELSIF p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE1
424: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE10
425: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE12

Line 423: ELSIF p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE1

419: ELSIF p_attr_id = OE_Price_Break_Util.G_START_DATE_ACTIVE THEN
420: l_Price_Break_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
421: ELSIF p_attr_id = OE_Price_Break_Util.G_UNIT THEN
422: l_Price_Break_rec.unit_code := p_attr_value;
423: ELSIF p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE1
424: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE10
425: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE12
426: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE13
427: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE14

Line 424: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE10

420: l_Price_Break_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
421: ELSIF p_attr_id = OE_Price_Break_Util.G_UNIT THEN
422: l_Price_Break_rec.unit_code := p_attr_value;
423: ELSIF p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE1
424: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE10
425: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE12
426: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE13
427: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE14
428: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE15

Line 425: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE12

421: ELSIF p_attr_id = OE_Price_Break_Util.G_UNIT THEN
422: l_Price_Break_rec.unit_code := p_attr_value;
423: ELSIF p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE1
424: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE10
425: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE12
426: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE13
427: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE14
428: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE15
429: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE2

Line 426: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE13

422: l_Price_Break_rec.unit_code := p_attr_value;
423: ELSIF p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE1
424: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE10
425: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE12
426: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE13
427: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE14
428: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE15
429: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE2
430: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE3

Line 427: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE14

423: ELSIF p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE1
424: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE10
425: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE12
426: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE13
427: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE14
428: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE15
429: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE2
430: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE3
431: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE4

Line 428: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE15

424: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE10
425: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE12
426: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE13
427: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE14
428: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE15
429: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE2
430: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE3
431: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE4
432: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE5

Line 429: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE2

425: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE12
426: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE13
427: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE14
428: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE15
429: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE2
430: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE3
431: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE4
432: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE5
433: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE6

Line 430: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE3

426: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE13
427: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE14
428: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE15
429: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE2
430: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE3
431: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE4
432: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE5
433: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE6
434: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE7

Line 431: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE4

427: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE14
428: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE15
429: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE2
430: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE3
431: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE4
432: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE5
433: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE6
434: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE7
435: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE8

Line 432: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE5

428: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE15
429: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE2
430: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE3
431: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE4
432: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE5
433: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE6
434: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE7
435: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE8
436: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE9

Line 433: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE6

429: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE2
430: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE3
431: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE4
432: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE5
433: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE6
434: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE7
435: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE8
436: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE9
437: OR p_attr_id = OE_Price_Break_Util.G_CONTEXT

Line 434: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE7

430: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE3
431: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE4
432: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE5
433: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE6
434: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE7
435: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE8
436: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE9
437: OR p_attr_id = OE_Price_Break_Util.G_CONTEXT
438: THEN

Line 435: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE8

431: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE4
432: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE5
433: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE6
434: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE7
435: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE8
436: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE9
437: OR p_attr_id = OE_Price_Break_Util.G_CONTEXT
438: THEN
439:

Line 436: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE9

432: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE5
433: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE6
434: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE7
435: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE8
436: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE9
437: OR p_attr_id = OE_Price_Break_Util.G_CONTEXT
438: THEN
439:
440: l_Price_Break_rec.attribute1 := p_attribute1;

Line 437: OR p_attr_id = OE_Price_Break_Util.G_CONTEXT

433: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE6
434: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE7
435: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE8
436: OR p_attr_id = OE_Price_Break_Util.G_ATTRIBUTE9
437: OR p_attr_id = OE_Price_Break_Util.G_CONTEXT
438: THEN
439:
440: l_Price_Break_rec.attribute1 := p_attribute1;
441: l_Price_Break_rec.attribute10 := p_attribute10;

Line 553: l_Price_Break_val_rec := OE_Price_Break_Util.Get_Values

549: x_unit := FND_API.G_MISS_CHAR;
550:
551: -- Load display out parameters if any
552:
553: l_Price_Break_val_rec := OE_Price_Break_Util.Get_Values
554: ( p_Price_Break_rec => l_x_Price_Break_rec
555: , p_old_Price_Break_rec => l_Price_Break_rec
556: );
557:

Line 1631: g_Price_Break_rec := OE_Price_Break_Util.Query_Row

1627: IF p_discount_line_id <> g_Price_Break_rec.discount_line_id
1628: THEN
1629:
1630: -- Query row from DB
1631: g_Price_Break_rec := OE_Price_Break_Util.Query_Row
1632: ( p_discount_line_id => p_discount_line_id
1633: , p_method_type_code => p_method_type_code
1634: , p_price_break_high => p_price_break_high
1635: , p_price_break_low => p_price_break_low