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_LINE_SCREDIT dependencies on OE_LINE_SCREDIT_UTIL

Line 222: l_Line_Scredit_val_rec := OE_Line_Scredit_Util.Get_Values

218: x_wh_update_date := l_x_Line_Scredit_rec.wh_update_date;
219:
220: -- Load display out parameters if any
221:
222: l_Line_Scredit_val_rec := OE_Line_Scredit_Util.Get_Values
223: ( p_Line_Scredit_rec => l_x_Line_Scredit_rec
224: );
225: x_sales_credit_type := l_Line_Scredit_val_rec.sales_credit_type;
226:

Line 445: IF p_attr_id = OE_Line_Scredit_Util.G_DW_UPDATE_ADVICE THEN

441: );
442:
443: l_old_Line_Scredit_rec := l_Line_Scredit_rec;
444:
445: IF p_attr_id = OE_Line_Scredit_Util.G_DW_UPDATE_ADVICE THEN
446: l_Line_Scredit_rec.dw_update_advice_flag := p_attr_value;
447: ELSIF p_attr_id = OE_Line_Scredit_Util.G_HEADER THEN
448: l_Line_Scredit_rec.header_id := TO_NUMBER(p_attr_value);
449: ELSIF p_attr_id = OE_Line_Scredit_Util.G_LINE THEN

Line 447: ELSIF p_attr_id = OE_Line_Scredit_Util.G_HEADER THEN

443: l_old_Line_Scredit_rec := l_Line_Scredit_rec;
444:
445: IF p_attr_id = OE_Line_Scredit_Util.G_DW_UPDATE_ADVICE THEN
446: l_Line_Scredit_rec.dw_update_advice_flag := p_attr_value;
447: ELSIF p_attr_id = OE_Line_Scredit_Util.G_HEADER THEN
448: l_Line_Scredit_rec.header_id := TO_NUMBER(p_attr_value);
449: ELSIF p_attr_id = OE_Line_Scredit_Util.G_LINE THEN
450: l_Line_Scredit_rec.line_id := TO_NUMBER(p_attr_value);
451: ELSIF p_attr_id = OE_Line_Scredit_Util.G_PERCENT THEN

Line 449: ELSIF p_attr_id = OE_Line_Scredit_Util.G_LINE THEN

445: IF p_attr_id = OE_Line_Scredit_Util.G_DW_UPDATE_ADVICE THEN
446: l_Line_Scredit_rec.dw_update_advice_flag := p_attr_value;
447: ELSIF p_attr_id = OE_Line_Scredit_Util.G_HEADER THEN
448: l_Line_Scredit_rec.header_id := TO_NUMBER(p_attr_value);
449: ELSIF p_attr_id = OE_Line_Scredit_Util.G_LINE THEN
450: l_Line_Scredit_rec.line_id := TO_NUMBER(p_attr_value);
451: ELSIF p_attr_id = OE_Line_Scredit_Util.G_PERCENT THEN
452: l_Line_Scredit_rec.percent := TO_NUMBER(p_attr_value);
453: ELSIF p_attr_id = OE_Line_Scredit_Util.G_SALESREP THEN

Line 451: ELSIF p_attr_id = OE_Line_Scredit_Util.G_PERCENT THEN

447: ELSIF p_attr_id = OE_Line_Scredit_Util.G_HEADER THEN
448: l_Line_Scredit_rec.header_id := TO_NUMBER(p_attr_value);
449: ELSIF p_attr_id = OE_Line_Scredit_Util.G_LINE THEN
450: l_Line_Scredit_rec.line_id := TO_NUMBER(p_attr_value);
451: ELSIF p_attr_id = OE_Line_Scredit_Util.G_PERCENT THEN
452: l_Line_Scredit_rec.percent := TO_NUMBER(p_attr_value);
453: ELSIF p_attr_id = OE_Line_Scredit_Util.G_SALESREP THEN
454: l_Line_Scredit_rec.salesrep_id := TO_NUMBER(p_attr_value);
455: ELSIF p_attr_id = OE_Line_Scredit_Util.G_sales_credit_type THEN

Line 453: ELSIF p_attr_id = OE_Line_Scredit_Util.G_SALESREP THEN

449: ELSIF p_attr_id = OE_Line_Scredit_Util.G_LINE THEN
450: l_Line_Scredit_rec.line_id := TO_NUMBER(p_attr_value);
451: ELSIF p_attr_id = OE_Line_Scredit_Util.G_PERCENT THEN
452: l_Line_Scredit_rec.percent := TO_NUMBER(p_attr_value);
453: ELSIF p_attr_id = OE_Line_Scredit_Util.G_SALESREP THEN
454: l_Line_Scredit_rec.salesrep_id := TO_NUMBER(p_attr_value);
455: ELSIF p_attr_id = OE_Line_Scredit_Util.G_sales_credit_type THEN
456: l_Line_Scredit_rec.sales_credit_type_id := TO_NUMBER(p_attr_value);
457: ELSIF p_attr_id = OE_Line_Scredit_Util.G_SALES_CREDIT THEN

Line 455: ELSIF p_attr_id = OE_Line_Scredit_Util.G_sales_credit_type THEN

451: ELSIF p_attr_id = OE_Line_Scredit_Util.G_PERCENT THEN
452: l_Line_Scredit_rec.percent := TO_NUMBER(p_attr_value);
453: ELSIF p_attr_id = OE_Line_Scredit_Util.G_SALESREP THEN
454: l_Line_Scredit_rec.salesrep_id := TO_NUMBER(p_attr_value);
455: ELSIF p_attr_id = OE_Line_Scredit_Util.G_sales_credit_type THEN
456: l_Line_Scredit_rec.sales_credit_type_id := TO_NUMBER(p_attr_value);
457: ELSIF p_attr_id = OE_Line_Scredit_Util.G_SALES_CREDIT THEN
458: l_Line_Scredit_rec.sales_credit_id := TO_NUMBER(p_attr_value);
459: ELSIF p_attr_id = OE_Line_Scredit_Util.G_WH_UPDATE_DATE THEN

Line 457: ELSIF p_attr_id = OE_Line_Scredit_Util.G_SALES_CREDIT THEN

453: ELSIF p_attr_id = OE_Line_Scredit_Util.G_SALESREP THEN
454: l_Line_Scredit_rec.salesrep_id := TO_NUMBER(p_attr_value);
455: ELSIF p_attr_id = OE_Line_Scredit_Util.G_sales_credit_type THEN
456: l_Line_Scredit_rec.sales_credit_type_id := TO_NUMBER(p_attr_value);
457: ELSIF p_attr_id = OE_Line_Scredit_Util.G_SALES_CREDIT THEN
458: l_Line_Scredit_rec.sales_credit_id := TO_NUMBER(p_attr_value);
459: ELSIF p_attr_id = OE_Line_Scredit_Util.G_WH_UPDATE_DATE THEN
460: l_Line_Scredit_rec.wh_update_date := TO_DATE(p_attr_value,'YYYY/MM/DD');
461: --SG {

Line 459: ELSIF p_attr_id = OE_Line_Scredit_Util.G_WH_UPDATE_DATE THEN

455: ELSIF p_attr_id = OE_Line_Scredit_Util.G_sales_credit_type THEN
456: l_Line_Scredit_rec.sales_credit_type_id := TO_NUMBER(p_attr_value);
457: ELSIF p_attr_id = OE_Line_Scredit_Util.G_SALES_CREDIT THEN
458: l_Line_Scredit_rec.sales_credit_id := TO_NUMBER(p_attr_value);
459: ELSIF p_attr_id = OE_Line_Scredit_Util.G_WH_UPDATE_DATE THEN
460: l_Line_Scredit_rec.wh_update_date := TO_DATE(p_attr_value,'YYYY/MM/DD');
461: --SG {
462: ELSIF p_attr_id = OE_Line_Scredit_Util.G_SALES_GROUP_ID THEN
463: l_line_scredit_rec.sales_group_id := TO_NUMBER(p_attr_value);

Line 462: ELSIF p_attr_id = OE_Line_Scredit_Util.G_SALES_GROUP_ID THEN

458: l_Line_Scredit_rec.sales_credit_id := TO_NUMBER(p_attr_value);
459: ELSIF p_attr_id = OE_Line_Scredit_Util.G_WH_UPDATE_DATE THEN
460: l_Line_Scredit_rec.wh_update_date := TO_DATE(p_attr_value,'YYYY/MM/DD');
461: --SG {
462: ELSIF p_attr_id = OE_Line_Scredit_Util.G_SALES_GROUP_ID THEN
463: l_line_scredit_rec.sales_group_id := TO_NUMBER(p_attr_value);
464: ELSIF p_attr_id = OE_Line_Scredit_Util.G_SALES_GROUP_UPDATED_FLAG THEN
465: l_line_scredit_rec.sales_group_updated_flag := p_attr_value;
466: --SG }

Line 464: ELSIF p_attr_id = OE_Line_Scredit_Util.G_SALES_GROUP_UPDATED_FLAG THEN

460: l_Line_Scredit_rec.wh_update_date := TO_DATE(p_attr_value,'YYYY/MM/DD');
461: --SG {
462: ELSIF p_attr_id = OE_Line_Scredit_Util.G_SALES_GROUP_ID THEN
463: l_line_scredit_rec.sales_group_id := TO_NUMBER(p_attr_value);
464: ELSIF p_attr_id = OE_Line_Scredit_Util.G_SALES_GROUP_UPDATED_FLAG THEN
465: l_line_scredit_rec.sales_group_updated_flag := p_attr_value;
466: --SG }
467: ELSIF p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE1
468: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE10

Line 467: ELSIF p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE1

463: l_line_scredit_rec.sales_group_id := TO_NUMBER(p_attr_value);
464: ELSIF p_attr_id = OE_Line_Scredit_Util.G_SALES_GROUP_UPDATED_FLAG THEN
465: l_line_scredit_rec.sales_group_updated_flag := p_attr_value;
466: --SG }
467: ELSIF p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE1
468: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE10
469: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE11
470: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE12
471: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE13

Line 468: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE10

464: ELSIF p_attr_id = OE_Line_Scredit_Util.G_SALES_GROUP_UPDATED_FLAG THEN
465: l_line_scredit_rec.sales_group_updated_flag := p_attr_value;
466: --SG }
467: ELSIF p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE1
468: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE10
469: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE11
470: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE12
471: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE13
472: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE14

Line 469: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE11

465: l_line_scredit_rec.sales_group_updated_flag := p_attr_value;
466: --SG }
467: ELSIF p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE1
468: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE10
469: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE11
470: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE12
471: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE13
472: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE14
473: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE2

Line 470: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE12

466: --SG }
467: ELSIF p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE1
468: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE10
469: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE11
470: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE12
471: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE13
472: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE14
473: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE2
474: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE3

Line 471: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE13

467: ELSIF p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE1
468: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE10
469: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE11
470: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE12
471: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE13
472: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE14
473: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE2
474: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE3
475: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE4

Line 472: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE14

468: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE10
469: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE11
470: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE12
471: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE13
472: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE14
473: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE2
474: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE3
475: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE4
476: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE5

Line 473: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE2

469: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE11
470: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE12
471: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE13
472: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE14
473: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE2
474: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE3
475: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE4
476: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE5
477: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE6

Line 474: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE3

470: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE12
471: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE13
472: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE14
473: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE2
474: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE3
475: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE4
476: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE5
477: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE6
478: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE7

Line 475: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE4

471: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE13
472: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE14
473: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE2
474: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE3
475: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE4
476: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE5
477: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE6
478: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE7
479: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE8

Line 476: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE5

472: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE14
473: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE2
474: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE3
475: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE4
476: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE5
477: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE6
478: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE7
479: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE8
480: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE9

Line 477: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE6

473: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE2
474: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE3
475: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE4
476: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE5
477: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE6
478: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE7
479: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE8
480: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE9
481: OR p_attr_id = OE_Line_Scredit_Util.G_CONTEXT

Line 478: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE7

474: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE3
475: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE4
476: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE5
477: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE6
478: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE7
479: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE8
480: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE9
481: OR p_attr_id = OE_Line_Scredit_Util.G_CONTEXT
482: THEN

Line 479: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE8

475: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE4
476: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE5
477: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE6
478: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE7
479: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE8
480: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE9
481: OR p_attr_id = OE_Line_Scredit_Util.G_CONTEXT
482: THEN
483:

Line 480: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE9

476: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE5
477: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE6
478: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE7
479: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE8
480: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE9
481: OR p_attr_id = OE_Line_Scredit_Util.G_CONTEXT
482: THEN
483:
484: l_Line_Scredit_rec.attribute1 := p_attribute1;

Line 481: OR p_attr_id = OE_Line_Scredit_Util.G_CONTEXT

477: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE6
478: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE7
479: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE8
480: OR p_attr_id = OE_Line_Scredit_Util.G_ATTRIBUTE9
481: OR p_attr_id = OE_Line_Scredit_Util.G_CONTEXT
482: THEN
483:
484: l_Line_Scredit_rec.attribute1 := p_attribute1;
485: l_Line_Scredit_rec.attribute10 := p_attribute10;

Line 588: l_Line_Scredit_val_rec := OE_Line_Scredit_Util.Get_Values

584: --SG}
585:
586: -- Load display out parameters if any
587:
588: l_Line_Scredit_val_rec := OE_Line_Scredit_Util.Get_Values
589: ( p_Line_Scredit_rec => l_x_Line_Scredit_rec
590: , p_old_Line_Scredit_rec => l_Line_Scredit_rec
591: );
592:

Line 1425: OE_Line_Scredit_Util.Lock_Row

1421:
1422:
1423: -- Call oe_line_scredits_util instead of OE_Order_PVT.Lock_order
1424:
1425: OE_Line_Scredit_Util.Lock_Row
1426: ( x_return_status => l_return_status
1427: , p_x_Line_Scredit_rec => l_x_Line_Scredit_rec );
1428:
1429: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 1533: OE_Line_Scredit_Util.Query_Row

1529: THEN
1530:
1531: -- Query row from DB
1532:
1533: OE_Line_Scredit_Util.Query_Row
1534: ( p_sales_credit_id => p_sales_credit_id
1535: , x_line_scredit_rec => g_Line_Scredit_rec
1536: );
1537: