1584: End If;
1585: End If;
1586: End If;
1587:
1588: l_func_currency := okl_accounting_util.get_func_curr_code();
1589:
1590: --dbms_output.put_line('Func Curr: '||l_func_currency);
1591: --dbms_output.put_line('Trans Curr Code: '|| p_chrv_rec.currency_code);
1592: --dbms_output.put_line('Trans Curr Rate: '|| p_khrv_rec.currency_conversion_rate);
1665:
1666:
1667: ELSE -- conversion_type <> 'User'
1668:
1669: l_khrv_rec.currency_conversion_rate := okl_accounting_util.get_curr_con_rate(
1670: p_from_curr_code => l_chrv_rec.currency_code,
1671: p_to_curr_code => l_func_currency,
1672: p_con_date => l_khrv_rec.currency_conversion_date,
1673: p_con_type => l_khrv_rec.currency_conversion_type
5796: AND
5797: p_klev_rec.amount <> OKL_API.G_MISS_NUM) THEN
5798:
5799: l_conv_amount := NULL;
5800: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
5801: p_amount => p_klev_rec.amount,
5802: p_currency_code => l_currency_code
5803: );
5804:
5811: AND
5812: p_klev_rec.origination_income <> OKL_API.G_MISS_NUM) THEN
5813:
5814: l_conv_amount := NULL;
5815: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
5816: p_amount => p_klev_rec.origination_income,
5817: p_currency_code => l_currency_code
5818: );
5819:
5826: AND
5827: p_klev_rec.amount_stake<> OKL_API.G_MISS_NUM) THEN
5828:
5829: l_conv_amount := NULL;
5830: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
5831: p_amount => p_klev_rec.amount_stake,
5832: p_currency_code => l_currency_code
5833: );
5834:
5839: AND
5840: p_klev_rec.appraisal_value <> OKL_API.G_MISS_NUM) THEN
5841:
5842: l_conv_amount := NULL;
5843: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
5844: p_amount => p_klev_rec.appraisal_value,
5845: p_currency_code => l_currency_code
5846: );
5847:
5852: AND
5853: p_klev_rec.capital_amount <> OKL_API.G_MISS_NUM) THEN
5854:
5855: l_conv_amount := NULL;
5856: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
5857: p_amount => p_klev_rec.capital_amount,
5858: p_currency_code => l_currency_code
5859: );
5860:
5865: AND
5866: p_klev_rec.capital_reduction <> OKL_API.G_MISS_NUM) THEN
5867:
5868: l_conv_amount := NULL;
5869: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
5870: p_amount => p_klev_rec.capital_reduction,
5871: p_currency_code => l_currency_code
5872: );
5873:
5878: AND
5879: p_klev_rec.capitalized_interest <> OKL_API.G_MISS_NUM) THEN
5880:
5881: l_conv_amount := NULL;
5882: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
5883: p_amount => p_klev_rec.capitalized_interest,
5884: p_currency_code => l_currency_code
5885: );
5886:
5891: AND
5892: p_klev_rec.coverage <> OKL_API.G_MISS_NUM) THEN
5893:
5894: l_conv_amount := NULL;
5895: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
5896: p_amount => p_klev_rec.coverage,
5897: p_currency_code => l_currency_code
5898: );
5899:
5904: AND
5905: p_klev_rec.estimated_oec <> OKL_API.G_MISS_NUM) THEN
5906:
5907: l_conv_amount := NULL;
5908: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
5909: p_amount => p_klev_rec.estimated_oec,
5910: p_currency_code => l_currency_code
5911: );
5912:
5917: AND
5918: p_klev_rec.fee_charge <> OKL_API.G_MISS_NUM) THEN
5919:
5920: l_conv_amount := NULL;
5921: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
5922: p_amount => p_klev_rec.fee_charge,
5923: p_currency_code => l_currency_code
5924: );
5925:
5930: AND
5931: p_klev_rec.floor_amount <> OKL_API.G_MISS_NUM) THEN
5932:
5933: l_conv_amount := NULL;
5934: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
5935: p_amount => p_klev_rec.floor_amount,
5936: p_currency_code => l_currency_code
5937: );
5938:
5943: AND
5944: p_klev_rec.initial_direct_cost <> OKL_API.G_MISS_NUM) THEN
5945:
5946: l_conv_amount := NULL;
5947: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
5948: p_amount => p_klev_rec.initial_direct_cost,
5949: p_currency_code => l_currency_code
5950: );
5951:
5956: AND
5957: p_klev_rec.lao_amount <> OKL_API.G_MISS_NUM) THEN
5958:
5959: l_conv_amount := NULL;
5960: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
5961: p_amount => p_klev_rec.lao_amount,
5962: p_currency_code => p_clev_rec.currency_code
5963: );
5964:
5969: AND
5970: p_klev_rec.lrv_amount <> OKL_API.G_MISS_NUM) THEN
5971:
5972: l_conv_amount := NULL;
5973: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
5974: p_amount => p_klev_rec.lrv_amount,
5975: p_currency_code => l_currency_code
5976: );
5977:
5982: AND
5983: p_klev_rec.net_rentable <> OKL_API.G_MISS_NUM) THEN
5984:
5985: l_conv_amount := NULL;
5986: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
5987: p_amount => p_klev_rec.net_rentable,
5988: p_currency_code => l_currency_code
5989: );
5990:
5995: AND
5996: p_klev_rec.oec <> OKL_API.G_MISS_NUM) THEN
5997:
5998: l_conv_amount := NULL;
5999: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
6000: p_amount => p_klev_rec.oec,
6001: p_currency_code => l_currency_code
6002: );
6003:
6009: AND
6010: p_klev_rec.refinance_amount <> OKL_API.G_MISS_NUM) THEN
6011:
6012: l_conv_amount := NULL;
6013: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
6014: p_amount => p_klev_rec.refinance_amount,
6015: p_currency_code => l_currency_code
6016: );
6017:
6022: AND
6023: p_klev_rec.remarketed_amount <> OKL_API.G_MISS_NUM) THEN
6024:
6025: l_conv_amount := NULL;
6026: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
6027: p_amount => p_klev_rec.remarketed_amount,
6028: p_currency_code => l_currency_code
6029: );
6030:
6035: AND
6036: p_klev_rec.repurchased_amount <> OKL_API.G_MISS_NUM) THEN
6037:
6038: l_conv_amount := NULL;
6039: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
6040: p_amount => p_klev_rec.repurchased_amount,
6041: p_currency_code => l_currency_code
6042: );
6043:
6048: AND
6049: p_klev_rec.residual_grnty_amount <> OKL_API.G_MISS_NUM) THEN
6050:
6051: l_conv_amount := NULL;
6052: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
6053: p_amount => p_klev_rec.residual_grnty_amount,
6054: p_currency_code => l_currency_code
6055: );
6056:
6061: AND
6062: p_klev_rec.rvi_premium <> OKL_API.G_MISS_NUM) THEN
6063:
6064: l_conv_amount := NULL;
6065: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
6066: p_amount => p_klev_rec.rvi_premium,
6067: p_currency_code => l_currency_code
6068: );
6069:
6074: AND
6075: p_klev_rec.termination_purchase_amount <> OKL_API.G_MISS_NUM) THEN
6076:
6077: l_conv_amount := NULL;
6078: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
6079: p_amount => p_klev_rec.termination_purchase_amount,
6080: p_currency_code => l_currency_code
6081: );
6082:
6087: AND
6088: p_klev_rec.tracked_residual <> OKL_API.G_MISS_NUM) THEN
6089:
6090: l_conv_amount := NULL;
6091: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
6092: p_amount => p_klev_rec.tracked_residual,
6093: p_currency_code => l_currency_code
6094: );
6095:
6100: AND
6101: p_klev_rec.tradein_amount <> OKL_API.G_MISS_NUM) THEN
6102:
6103: l_conv_amount := NULL;
6104: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
6105: p_amount => p_klev_rec.tradein_amount,
6106: p_currency_code => l_currency_code
6107: );
6108:
6113: AND
6114: p_klev_rec.vendor_advance_paid <> OKL_API.G_MISS_NUM) THEN
6115:
6116: l_conv_amount := NULL;
6117: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
6118: p_amount => p_klev_rec.vendor_advance_paid,
6119: p_currency_code => l_currency_code
6120: );
6121:
6126: AND
6127: p_klev_rec.residual_value <> OKL_API.G_MISS_NUM) THEN
6128:
6129: l_conv_amount := NULL;
6130: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
6131: p_amount => p_klev_rec.residual_value,
6132: p_currency_code => l_currency_code
6133: );
6134:
6140: AND
6141: p_klev_rec.subsidy_override_amount <> OKL_API.G_MISS_NUM) THEN
6142:
6143: l_conv_amount := NULL;
6144: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
6145: p_amount => p_klev_rec.subsidy_override_amount,
6146: p_currency_code => l_currency_code
6147: );
6148:
6155: AND
6156: p_clev_rec.price_negotiated <> OKL_API.G_MISS_NUM) THEN
6157:
6158: l_conv_amount := NULL;
6159: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
6160: p_amount => p_clev_rec.price_negotiated,
6161: p_currency_code => l_currency_code
6162: );
6163:
6168: AND
6169: p_clev_rec.price_negotiated_renewed <> OKL_API.G_MISS_NUM) THEN
6170:
6171: l_conv_amount := NULL;
6172: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
6173: p_amount => p_clev_rec.price_negotiated_renewed,
6174: p_currency_code => l_currency_code
6175: );
6176:
6181: AND
6182: p_clev_rec.price_unit <> OKL_API.G_MISS_NUM) THEN
6183:
6184: l_conv_amount := NULL;
6185: l_conv_amount := okl_accounting_util.cross_currency_round_amount(
6186: p_amount => p_clev_rec.price_unit,
6187: p_currency_code => l_currency_code
6188: );
6189: