214: x_wh_update_date := l_x_header_scredit_tbl(1).wh_update_date;
215:
216: -- Load display out NOCOPY parameters if any
217:
218: l_Header_Scredit_val_rec := OE_Header_Scredit_Util.Get_Values
219: ( p_Header_Scredit_rec => l_x_Header_Scredit_tbl(1)
220: );
221: x_salesrep := l_Header_Scredit_val_rec.salesrep;
222: x_sales_credit_type := l_Header_Scredit_val_rec.sales_credit_type;
435: );
436:
437: l_x_old_Header_Scredit_tbl(1) := l_x_Header_Scredit_tbl(1);
438:
439: IF p_attr_id = OE_Header_Scredit_Util.G_DW_UPDATE_ADVICE THEN
440: l_x_header_scredit_tbl(1).dw_update_advice_flag := p_attr_value;
441: ELSIF p_attr_id = OE_Header_Scredit_Util.G_HEADER THEN
442: l_x_header_scredit_tbl(1).header_id := TO_NUMBER(p_attr_value);
443: ELSIF p_attr_id = OE_Header_Scredit_Util.G_LINE THEN
437: l_x_old_Header_Scredit_tbl(1) := l_x_Header_Scredit_tbl(1);
438:
439: IF p_attr_id = OE_Header_Scredit_Util.G_DW_UPDATE_ADVICE THEN
440: l_x_header_scredit_tbl(1).dw_update_advice_flag := p_attr_value;
441: ELSIF p_attr_id = OE_Header_Scredit_Util.G_HEADER THEN
442: l_x_header_scredit_tbl(1).header_id := TO_NUMBER(p_attr_value);
443: ELSIF p_attr_id = OE_Header_Scredit_Util.G_LINE THEN
444: l_x_header_scredit_tbl(1).line_id := TO_NUMBER(p_attr_value);
445: ELSIF p_attr_id = OE_Header_Scredit_Util.G_PERCENT THEN
439: IF p_attr_id = OE_Header_Scredit_Util.G_DW_UPDATE_ADVICE THEN
440: l_x_header_scredit_tbl(1).dw_update_advice_flag := p_attr_value;
441: ELSIF p_attr_id = OE_Header_Scredit_Util.G_HEADER THEN
442: l_x_header_scredit_tbl(1).header_id := TO_NUMBER(p_attr_value);
443: ELSIF p_attr_id = OE_Header_Scredit_Util.G_LINE THEN
444: l_x_header_scredit_tbl(1).line_id := TO_NUMBER(p_attr_value);
445: ELSIF p_attr_id = OE_Header_Scredit_Util.G_PERCENT THEN
446: IF l_debug_level > 0 THEN
447: oe_debug_pub.add( 'ENTER PERCENT ' || P_ATTR_VALUE ) ;
441: ELSIF p_attr_id = OE_Header_Scredit_Util.G_HEADER THEN
442: l_x_header_scredit_tbl(1).header_id := TO_NUMBER(p_attr_value);
443: ELSIF p_attr_id = OE_Header_Scredit_Util.G_LINE THEN
444: l_x_header_scredit_tbl(1).line_id := TO_NUMBER(p_attr_value);
445: ELSIF p_attr_id = OE_Header_Scredit_Util.G_PERCENT THEN
446: IF l_debug_level > 0 THEN
447: oe_debug_pub.add( 'ENTER PERCENT ' || P_ATTR_VALUE ) ;
448: END IF;
449: l_x_header_scredit_tbl(1).percent := TO_NUMBER(p_attr_value);
446: IF l_debug_level > 0 THEN
447: oe_debug_pub.add( 'ENTER PERCENT ' || P_ATTR_VALUE ) ;
448: END IF;
449: l_x_header_scredit_tbl(1).percent := TO_NUMBER(p_attr_value);
450: ELSIF p_attr_id = OE_Header_Scredit_Util.G_SALESREP THEN
451: l_x_header_scredit_tbl(1).salesrep_id := TO_NUMBER(p_attr_value);
452: ELSIF p_attr_id = OE_Header_Scredit_Util.G_SALES_CREDIT_TYPE THEN
453: l_x_header_scredit_tbl(1).sales_credit_type_id := TO_NUMBER(p_attr_value);
454: IF l_debug_level > 0 THEN
448: END IF;
449: l_x_header_scredit_tbl(1).percent := TO_NUMBER(p_attr_value);
450: ELSIF p_attr_id = OE_Header_Scredit_Util.G_SALESREP THEN
451: l_x_header_scredit_tbl(1).salesrep_id := TO_NUMBER(p_attr_value);
452: ELSIF p_attr_id = OE_Header_Scredit_Util.G_SALES_CREDIT_TYPE THEN
453: l_x_header_scredit_tbl(1).sales_credit_type_id := TO_NUMBER(p_attr_value);
454: IF l_debug_level > 0 THEN
455: oe_debug_pub.add( 'ENTER CREDIT TYPE ' || P_ATTR_VALUE ) ;
456: END IF;
453: l_x_header_scredit_tbl(1).sales_credit_type_id := TO_NUMBER(p_attr_value);
454: IF l_debug_level > 0 THEN
455: oe_debug_pub.add( 'ENTER CREDIT TYPE ' || P_ATTR_VALUE ) ;
456: END IF;
457: ELSIF p_attr_id = OE_Header_Scredit_Util.G_SALES_CREDIT THEN
458: l_x_header_scredit_tbl(1).sales_credit_id := TO_NUMBER(p_attr_value);
459: ELSIF p_attr_id = OE_Header_Scredit_Util.G_WH_UPDATE_DATE THEN
460: l_x_header_scredit_tbl(1).wh_update_date := TO_DATE(p_attr_value,'YYYY/MM/DD');
461: --SG {
455: oe_debug_pub.add( 'ENTER CREDIT TYPE ' || P_ATTR_VALUE ) ;
456: END IF;
457: ELSIF p_attr_id = OE_Header_Scredit_Util.G_SALES_CREDIT THEN
458: l_x_header_scredit_tbl(1).sales_credit_id := TO_NUMBER(p_attr_value);
459: ELSIF p_attr_id = OE_Header_Scredit_Util.G_WH_UPDATE_DATE THEN
460: l_x_header_scredit_tbl(1).wh_update_date := TO_DATE(p_attr_value,'YYYY/MM/DD');
461: --SG {
462: ELSIF p_attr_id = OE_Header_Scredit_Util.G_SALES_GROUP_ID THEN
463: l_x_header_scredit_tbl(1).sales_group_id := TO_NUMBER(p_attr_value);
458: l_x_header_scredit_tbl(1).sales_credit_id := TO_NUMBER(p_attr_value);
459: ELSIF p_attr_id = OE_Header_Scredit_Util.G_WH_UPDATE_DATE THEN
460: l_x_header_scredit_tbl(1).wh_update_date := TO_DATE(p_attr_value,'YYYY/MM/DD');
461: --SG {
462: ELSIF p_attr_id = OE_Header_Scredit_Util.G_SALES_GROUP_ID THEN
463: l_x_header_scredit_tbl(1).sales_group_id := TO_NUMBER(p_attr_value);
464: ELSIF p_attr_id = OE_Header_Scredit_Util.G_SALES_GROUP_UPDATED_FLAG THEN
465: l_x_header_scredit_tbl(1).sales_group_updated_flag := p_attr_value;
466: --SG }
460: l_x_header_scredit_tbl(1).wh_update_date := TO_DATE(p_attr_value,'YYYY/MM/DD');
461: --SG {
462: ELSIF p_attr_id = OE_Header_Scredit_Util.G_SALES_GROUP_ID THEN
463: l_x_header_scredit_tbl(1).sales_group_id := TO_NUMBER(p_attr_value);
464: ELSIF p_attr_id = OE_Header_Scredit_Util.G_SALES_GROUP_UPDATED_FLAG THEN
465: l_x_header_scredit_tbl(1).sales_group_updated_flag := p_attr_value;
466: --SG }
467: ELSIF p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE1
468: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE10
463: l_x_header_scredit_tbl(1).sales_group_id := TO_NUMBER(p_attr_value);
464: ELSIF p_attr_id = OE_Header_Scredit_Util.G_SALES_GROUP_UPDATED_FLAG THEN
465: l_x_header_scredit_tbl(1).sales_group_updated_flag := p_attr_value;
466: --SG }
467: ELSIF p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE1
468: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE10
469: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE11
470: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE12
471: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE13
464: ELSIF p_attr_id = OE_Header_Scredit_Util.G_SALES_GROUP_UPDATED_FLAG THEN
465: l_x_header_scredit_tbl(1).sales_group_updated_flag := p_attr_value;
466: --SG }
467: ELSIF p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE1
468: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE10
469: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE11
470: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE12
471: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE13
472: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE14
465: l_x_header_scredit_tbl(1).sales_group_updated_flag := p_attr_value;
466: --SG }
467: ELSIF p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE1
468: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE10
469: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE11
470: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE12
471: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE13
472: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE14
473: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE15
466: --SG }
467: ELSIF p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE1
468: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE10
469: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE11
470: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE12
471: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE13
472: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE14
473: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE15
474: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE2
467: ELSIF p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE1
468: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE10
469: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE11
470: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE12
471: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE13
472: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE14
473: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE15
474: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE2
475: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE3
468: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE10
469: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE11
470: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE12
471: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE13
472: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE14
473: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE15
474: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE2
475: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE3
476: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE4
469: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE11
470: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE12
471: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE13
472: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE14
473: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE15
474: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE2
475: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE3
476: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE4
477: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE5
470: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE12
471: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE13
472: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE14
473: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE15
474: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE2
475: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE3
476: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE4
477: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE5
478: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE6
471: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE13
472: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE14
473: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE15
474: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE2
475: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE3
476: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE4
477: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE5
478: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE6
479: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE7
472: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE14
473: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE15
474: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE2
475: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE3
476: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE4
477: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE5
478: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE6
479: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE7
480: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE8
473: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE15
474: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE2
475: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE3
476: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE4
477: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE5
478: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE6
479: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE7
480: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE8
481: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE9
474: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE2
475: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE3
476: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE4
477: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE5
478: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE6
479: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE7
480: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE8
481: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE9
482: OR p_attr_id = OE_Header_Scredit_Util.G_CONTEXT
475: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE3
476: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE4
477: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE5
478: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE6
479: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE7
480: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE8
481: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE9
482: OR p_attr_id = OE_Header_Scredit_Util.G_CONTEXT
483: THEN
476: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE4
477: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE5
478: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE6
479: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE7
480: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE8
481: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE9
482: OR p_attr_id = OE_Header_Scredit_Util.G_CONTEXT
483: THEN
484:
477: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE5
478: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE6
479: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE7
480: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE8
481: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE9
482: OR p_attr_id = OE_Header_Scredit_Util.G_CONTEXT
483: THEN
484:
485: l_x_header_scredit_tbl(1).attribute1 := p_attribute1;
478: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE6
479: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE7
480: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE8
481: OR p_attr_id = OE_Header_Scredit_Util.G_ATTRIBUTE9
482: OR p_attr_id = OE_Header_Scredit_Util.G_CONTEXT
483: THEN
484:
485: l_x_header_scredit_tbl(1).attribute1 := p_attribute1;
486: l_x_header_scredit_tbl(1).attribute10 := p_attribute10;
580: --SG}
581:
582: -- Load display out NOCOPY parameters if any
583:
584: l_Header_Scredit_val_rec := OE_Header_Scredit_Util.Get_Values
585: ( p_Header_Scredit_rec => l_x_Header_Scredit_tbl(1)
586: , p_old_Header_Scredit_rec => l_Header_Scredit_rec
587: );
588:
1403: l_x_Header_Scredit_rec.lock_control := p_lock_control;
1404:
1405: -- Call oe_headers_scredits_util.lock_row instead of OE_Order_PVT.Lock_order
1406:
1407: OE_Header_Scredit_Util.Lock_Row
1408: ( x_return_status => l_return_status
1409: , p_x_header_Scredit_rec => l_x_header_Scredit_rec );
1410: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1411:
1509: THEN
1510:
1511: -- Query row from DB
1512:
1513: OE_Header_Scredit_Util.Query_Row
1514: ( p_sales_credit_id => p_sales_credit_id
1515: , x_header_scredit_rec => g_Header_Scredit_rec
1516: );
1517:
1562: --SG{
1563: Procedure Get_Values(p_header_scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type
1564: ,x_header_scredit_val_rec OUT NOCOPY OE_Order_PUB.Header_Scredit_Val_Rec_Type) AS
1565: BEGIN
1566: x_header_scredit_val_rec:=OE_Header_Scredit_Util.Get_Values(p_header_scredit_rec);
1567: END;
1568: --SG}
1569:
1570: END OE_OE_Form_Header_Scredit;