365: WSH_DEBUG_SV.log(l_module_name,' l_currency_code ',l_currency_code);
366: END IF;
367:
368:
369: l_approved_amount :=GL_CURRENCY_API.convert_amount (
370: x_from_currency => l_currency_code,
371: x_to_currency => g_currency_code,
372: x_conversion_date => sysdate,
373: x_amount => l_approved_amount);
390: WSH_DEBUG_SV.log(l_module_name,' l_currency_code ',l_currency_code);
391: END IF;
392:
393:
394: l_total_amount := GL_CURRENCY_API.convert_amount (
395: x_from_currency => l_currency_code,
396: x_to_currency => g_currency_code,
397: x_conversion_date => sysdate,
398: x_amount => l_total_amount);
415: WSH_DEBUG_SV.log(l_module_name,' l_currency_code ',l_currency_code);
416: END IF;
417:
418:
419: l_dleg_header_amount := GL_CURRENCY_API.convert_amount (
420: x_from_currency => l_currency_code,
421: x_to_currency => g_currency_code,
422: x_conversion_date => sysdate,
423: x_amount => l_dleg_header_amount);
486: WSH_DEBUG_SV.log(l_module_name,' l_detail_amount ',l_detail_amount);
487: WSH_DEBUG_SV.log(l_module_name,' l_currency_code ',l_currency_code);
488: END IF;
489:
490: l_detail_amount := GL_CURRENCY_API.convert_amount (
491: x_from_currency => l_currency_code,
492: x_to_currency => g_currency_code,
493: x_conversion_date => sysdate,
494: x_amount => l_detail_amount);
809: FETCH C_TOTAL_SUMMARY_AMT INTO l_cal_dleg_amount,l_currency_code;
810: CLOSE C_TOTAL_SUMMARY_AMT;
811:
812: -- Convert currency
813: l_cal_dleg_amount := GL_CURRENCY_API.convert_amount (
814: x_from_currency => l_currency_code,
815: x_to_currency => g_currency_code,
816: x_conversion_date => sysdate,
817: x_amount => l_cal_dleg_amount);
830: IF (l_cal_detail_amount <> 0)
831: THEN
832:
833: -- Convert delivery detail amount
834: l_cal_detail_amount := GL_CURRENCY_API.convert_amount (
835: x_from_currency => l_currency_code,
836: x_to_currency => g_currency_code,
837: x_conversion_date => sysdate,
838: x_amount => l_cal_detail_amount);
841: IF (l_total_dleg_approved_amount <> 0)
842: THEN
843:
844: -- Convert invoice amount
845: l_total_dleg_approved_amount := GL_CURRENCY_API.convert_amount (
846: x_from_currency => l_currency_code,
847: x_to_currency => g_currency_code,
848: x_conversion_date => sysdate,
849: x_amount => l_total_dleg_approved_amount);
873: WSH_DEBUG_SV.log(l_module_name,' l_currency_code ',l_currency_code);
874: END IF;
875:
876:
877: l_cal_commodity_amount := GL_CURRENCY_API.convert_amount (
878: x_from_currency => l_currency_code,
879: x_to_currency => g_currency_code,
880: x_conversion_date => sysdate,
881: x_amount => l_cal_commodity_amount);
899: WSH_DEBUG_SV.log(l_module_name,' l_currency_code ',l_currency_code);
900: END IF;
901:
902:
903: l_cal_detail_amount := GL_CURRENCY_API.convert_amount (
904: x_from_currency => l_currency_code,
905: x_to_currency => g_currency_code,
906: x_conversion_date => sysdate,
907: x_amount => l_cal_detail_amount);
928: WSH_DEBUG_SV.log(l_module_name,' l_currency_code ',l_currency_code);
929: END IF;
930:
931:
932: l_total_commd_approved_amount := GL_CURRENCY_API.convert_amount (
933: x_from_currency => l_currency_code,
934: x_to_currency => g_currency_code,
935: x_conversion_date => sysdate,
936: x_amount => l_total_commd_approved_amount);
968: WSH_DEBUG_SV.log(l_module_name,' l_currency_code ',l_currency_code);
969: END IF;
970:
971:
972: l_cal_detail_discount := GL_CURRENCY_API.convert_amount (
973: x_from_currency => l_currency_code,
974: x_to_currency => g_currency_code,
975: x_conversion_date => sysdate,
976: x_amount => l_cal_detail_discount);
997:
998: IF (l_cal_dleg_discount <> 0)
999: THEN
1000:
1001: l_cal_dleg_discount := GL_CURRENCY_API.convert_amount (
1002: x_from_currency => l_currency_code,
1003: x_to_currency => g_currency_code,
1004: x_conversion_date => sysdate,
1005: x_amount => l_cal_dleg_discount);
1029:
1030: IF (l_total_dleg_approved_discount <> 0)
1031: THEN
1032:
1033: l_total_dleg_approved_discount := GL_CURRENCY_API.convert_amount (
1034: x_from_currency => l_currency_code,
1035: x_to_currency => g_currency_code,
1036: x_conversion_date => sysdate,
1037: x_amount => l_total_dleg_approved_discount);
1069:
1070: IF (l_cal_detail_charge <> 0)
1071: THEN
1072:
1073: l_cal_detail_charge := GL_CURRENCY_API.convert_amount (
1074: x_from_currency => l_currency_code,
1075: x_to_currency => g_currency_code,
1076: x_conversion_date => sysdate,
1077: x_amount => l_cal_detail_charge);
1100:
1101: IF (l_cal_dleg_charge <> 0)
1102: THEN
1103:
1104: l_cal_dleg_charge := GL_CURRENCY_API.convert_amount (
1105: x_from_currency => l_currency_code,
1106: x_to_currency => g_currency_code,
1107: x_conversion_date => sysdate,
1108: x_amount => l_cal_dleg_charge);
1130:
1131: IF (l_total_dleg_approved_charge <> 0)
1132: THEN
1133:
1134: l_total_dleg_approved_charge := GL_CURRENCY_API.convert_amount (
1135: x_from_currency => l_currency_code,
1136: x_to_currency => g_currency_code,
1137: x_conversion_date => sysdate,
1138: x_amount => l_total_dleg_approved_charge);