DBA Data[Home] [Help]

APPS.OKS_BILL_MIGRATION dependencies on OKC_CURRENCY_API

Line 560: l_migration_req := OKC_CURRENCY_API.IS_EURO_CONVERSION_NEEDED(l_cont_rec.CURRENCY_CODE) ;

556: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('CONTRACT_LINE');
557: End ;
558:
559: -- Call OKC API to find the contract requires migration or not
560: l_migration_req := OKC_CURRENCY_API.IS_EURO_CONVERSION_NEEDED(l_cont_rec.CURRENCY_CODE) ;
561:
562:
563:
564: If l_migration_req = 'Y' then

Line 570: l_euro_code := OKC_CURRENCY_API.GET_EURO_CURRENCY_CODE(l_cont_rec.CURRENCY_CODE) ;

566: Open l_rule_info_csr(l_cont_rec.ID) ;
567: Fetch l_rule_info_csr into l_rule_info_rec ;
568:
569: -- Get Euro currency code
570: l_euro_code := OKC_CURRENCY_API.GET_EURO_CURRENCY_CODE(l_cont_rec.CURRENCY_CODE) ;
571: -- dbms_output.put_line('After Getting the Euro Curr for Contract '||l_euro_code) ;
572:
573: -- Update Euro currency code and Euro Amount for all bill cont lines with BTN ID Null
574: Open l_bill_lines_csr(l_cont_rec.ID) ;

Line 586: OKC_CURRENCY_API.CONVERT_AMOUNT ( p_FROM_CURRENCY => l_cont_rec.CURRENCY_CODE

582: -- and
583: If ( l_rule_info_rec.ConvType is Not Null
584: and l_rule_info_rec.ConvRate is Not Null )
585: then
586: OKC_CURRENCY_API.CONVERT_AMOUNT ( p_FROM_CURRENCY => l_cont_rec.CURRENCY_CODE
587: ,p_TO_CURRENCY => l_euro_code
588: ,p_CONVERSION_DATE => l_rule_info_rec.ConvDate
589: ,p_CONVERSION_TYPE => l_rule_info_rec.ConvType
590: ,p_AMOUNT => l_bill_line_rec.Amount