DBA Data[Home] [Help]

APPS.ARP_BAL_UTIL dependencies on ARPCURR

Line 1070: THEN l_base_line_original := arpcurr.functional_amount(

1066: IF ( p_currency_mode <> 'E' )
1067: THEN
1068:
1069: IF ( l_line_original IS NOT NULL )
1070: THEN l_base_line_original := arpcurr.functional_amount(
1071: l_line_original,
1072: l_base_curr_code,
1073: l_exchange_rate,
1074: l_base_precision,

Line 1084: THEN l_base_line_remaining := arpcurr.functional_amount(

1080: /* Bug 5877375 added NVL to l_cm_refunds */
1081: l_line_remaining := l_line_remaining + NVL(l_cm_refunds,0);
1082:
1083: IF ( l_line_remaining IS NOT NULL )
1084: THEN l_base_line_remaining := arpcurr.functional_amount(
1085: l_line_remaining,
1086: l_base_curr_code,
1087: l_exchange_rate,
1088: l_base_precision,

Line 1094: THEN l_base_tax_original := arpcurr.functional_amount(

1090: END IF;
1091:
1092:
1093: IF ( l_tax_original IS NOT NULL )
1094: THEN l_base_tax_original := arpcurr.functional_amount(
1095: l_tax_original,
1096: l_base_curr_code,
1097: l_exchange_rate,
1098: l_base_precision,

Line 1103: THEN l_base_tax_remaining := arpcurr.functional_amount(

1099: l_base_min_acc_unit);
1100: END IF;
1101:
1102: IF ( l_tax_remaining IS NOT NULL )
1103: THEN l_base_tax_remaining := arpcurr.functional_amount(
1104: l_tax_remaining,
1105: l_base_curr_code,
1106: l_exchange_rate,
1107: l_base_precision,

Line 1112: THEN l_base_freight_original := arpcurr.functional_amount(

1108: l_base_min_acc_unit);
1109: END IF;
1110:
1111: IF ( l_freight_original IS NOT NULL )
1112: THEN l_base_freight_original := arpcurr.functional_amount(
1113: l_freight_original,
1114: l_base_curr_code,
1115: l_exchange_rate,
1116: l_base_precision,

Line 1121: THEN l_base_freight_remaining := arpcurr.functional_amount(

1117: l_base_min_acc_unit);
1118: END IF;
1119:
1120: IF ( l_freight_remaining IS NOT NULL )
1121: THEN l_base_freight_remaining := arpcurr.functional_amount(
1122: l_freight_remaining,
1123: l_base_curr_code,
1124: l_exchange_rate,
1125: l_base_precision,

Line 1130: THEN l_base_charges_original := arpcurr.functional_amount(

1126: l_base_min_acc_unit);
1127: END IF;
1128:
1129: IF ( l_charges_original IS NOT NULL )
1130: THEN l_base_charges_original := arpcurr.functional_amount(
1131: l_charges_original,
1132: l_base_curr_code,
1133: l_exchange_rate,
1134: l_base_precision,

Line 1139: THEN l_base_charges_remaining := arpcurr.functional_amount(

1135: l_base_min_acc_unit);
1136: END IF;
1137:
1138: IF ( l_charges_remaining IS NOT NULL )
1139: THEN l_base_charges_remaining := arpcurr.functional_amount(
1140: l_charges_remaining,
1141: l_base_curr_code,
1142: l_exchange_rate,
1143: l_base_precision,

Line 1149: THEN l_base_line_receipts := arpcurr.functional_amount(

1145: END IF;
1146:
1147:
1148: IF ( l_line_receipts IS NOT NULL )
1149: THEN l_base_line_receipts := arpcurr.functional_amount(
1150: l_line_receipts,
1151: l_base_curr_code,
1152: l_exchange_rate,
1153: l_base_precision,

Line 1158: THEN l_base_tax_receipts := arpcurr.functional_amount(

1154: l_base_min_acc_unit);
1155: END IF;
1156:
1157: IF ( l_tax_receipts IS NOT NULL )
1158: THEN l_base_tax_receipts := arpcurr.functional_amount(
1159: l_tax_receipts,
1160: l_base_curr_code,
1161: l_exchange_rate,
1162: l_base_precision,

Line 1167: THEN l_base_freight_receipts := arpcurr.functional_amount(

1163: l_base_min_acc_unit);
1164: END IF;
1165:
1166: IF ( l_freight_receipts IS NOT NULL )
1167: THEN l_base_freight_receipts := arpcurr.functional_amount(
1168: l_freight_receipts,
1169: l_base_curr_code,
1170: l_exchange_rate,
1171: l_base_precision,

Line 1176: THEN l_base_charges_receipts := arpcurr.functional_amount(

1172: l_base_min_acc_unit);
1173: END IF;
1174:
1175: IF ( l_charges_receipts IS NOT NULL )
1176: THEN l_base_charges_receipts := arpcurr.functional_amount(
1177: l_charges_receipts,
1178: l_base_curr_code,
1179: l_exchange_rate,
1180: l_base_precision,

Line 1186: THEN l_base_line_credits := arpcurr.functional_amount(

1182: END IF;
1183:
1184:
1185: IF ( l_line_credits IS NOT NULL )
1186: THEN l_base_line_credits := arpcurr.functional_amount(
1187: l_line_credits,
1188: l_base_curr_code,
1189: l_exchange_rate,
1190: l_base_precision,

Line 1195: THEN l_base_tax_credits := arpcurr.functional_amount(

1191: l_base_min_acc_unit);
1192: END IF;
1193:
1194: IF ( l_tax_credits IS NOT NULL )
1195: THEN l_base_tax_credits := arpcurr.functional_amount(
1196: l_tax_credits,
1197: l_base_curr_code,
1198: l_exchange_rate,
1199: l_base_precision,

Line 1204: THEN l_base_freight_credits := arpcurr.functional_amount(

1200: l_base_min_acc_unit);
1201: END IF;
1202:
1203: IF ( l_freight_credits IS NOT NULL )
1204: THEN l_base_freight_credits := arpcurr.functional_amount(
1205: l_freight_credits,
1206: l_base_curr_code,
1207: l_exchange_rate,
1208: l_base_precision,

Line 1213: THEN l_base_line_adjustments := arpcurr.functional_amount(

1209: l_base_min_acc_unit);
1210: END IF;
1211:
1212: IF ( l_line_adjustments IS NOT NULL )
1213: THEN l_base_line_adjustments := arpcurr.functional_amount(
1214: l_line_adjustments,
1215: l_base_curr_code,
1216: l_exchange_rate,
1217: l_base_precision,

Line 1223: THEN l_base_aline_adjustments := arpcurr.functional_amount(

1219: END IF;
1220:
1221: /* Bug 1373449 */
1222: IF ( l_aline_adjustments IS NOT NULL )
1223: THEN l_base_aline_adjustments := arpcurr.functional_amount(
1224: l_aline_adjustments,
1225: l_base_curr_code,
1226: l_exchange_rate,
1227: l_base_precision,

Line 1232: THEN l_base_tax_adjustments := arpcurr.functional_amount(

1228: l_base_min_acc_unit);
1229: END IF;
1230:
1231: IF ( l_tax_adjustments IS NOT NULL )
1232: THEN l_base_tax_adjustments := arpcurr.functional_amount(
1233: l_tax_adjustments,
1234: l_base_curr_code,
1235: l_exchange_rate,
1236: l_base_precision,

Line 1242: THEN l_base_atax_adjustments := arpcurr.functional_amount(

1238: END IF;
1239:
1240: /* Bug 1373449 */
1241: IF ( l_atax_adjustments IS NOT NULL )
1242: THEN l_base_atax_adjustments := arpcurr.functional_amount(
1243: l_atax_adjustments,
1244: l_base_curr_code,
1245: l_exchange_rate,
1246: l_base_precision,

Line 1251: THEN l_base_freight_adjustments := arpcurr.functional_amount(

1247: l_base_min_acc_unit);
1248: END IF;
1249:
1250: IF ( l_freight_adjustments IS NOT NULL )
1251: THEN l_base_freight_adjustments := arpcurr.functional_amount(
1252: l_freight_adjustments,
1253: l_base_curr_code,
1254: l_exchange_rate,
1255: l_base_precision,

Line 1261: THEN l_base_afreight_adjustments := arpcurr.functional_amount(

1257: END IF;
1258:
1259: /* Bug 1373449 */
1260: IF ( l_afreight_adjustments IS NOT NULL )
1261: THEN l_base_afreight_adjustments := arpcurr.functional_amount(
1262: l_afreight_adjustments,
1263: l_base_curr_code,
1264: l_exchange_rate,
1265: l_base_precision,

Line 1270: THEN l_base_charges_adjustments := arpcurr.functional_amount(

1266: l_base_min_acc_unit);
1267: END IF;
1268:
1269: IF ( l_charges_adjustments IS NOT NULL )
1270: THEN l_base_charges_adjustments := arpcurr.functional_amount(
1271: l_charges_adjustments,
1272: l_base_curr_code,
1273: l_exchange_rate,
1274: l_base_precision,

Line 1280: THEN l_base_acharges_adjustments := arpcurr.functional_amount(

1276: END IF;
1277:
1278: /* Bug 1373449 */
1279: IF ( l_acharges_adjustments IS NOT NULL )
1280: THEN l_base_acharges_adjustments := arpcurr.functional_amount(
1281: l_acharges_adjustments,
1282: l_base_curr_code,
1283: l_exchange_rate,
1284: l_base_precision,

Line 1306: l_base_line_adjustments := arpcurr.Currround(

1302: l_run_adj_tot := 0;
1303: l_base_run_adj_tot := 0;
1304:
1305: l_run_adj_tot := l_run_adj_tot + l_line_adjustments;
1306: l_base_line_adjustments := arpcurr.Currround(
1307: (l_run_adj_tot/l_total_adjustments)*
1308: l_base_total_adjustments ,l_base_curr_code) -
1309: l_base_run_adj_tot;
1310: l_base_run_adj_tot := l_base_run_adj_tot + l_base_line_adjustments;

Line 1313: l_base_tax_adjustments := arpcurr.Currround(

1309: l_base_run_adj_tot;
1310: l_base_run_adj_tot := l_base_run_adj_tot + l_base_line_adjustments;
1311:
1312: l_run_adj_tot := l_run_adj_tot + l_tax_adjustments;
1313: l_base_tax_adjustments := arpcurr.Currround(
1314: (l_run_adj_tot/l_total_adjustments)*
1315: l_base_total_adjustments ,l_base_curr_code) -
1316: l_base_run_adj_tot;
1317: l_base_run_adj_tot := l_base_run_adj_tot + l_base_tax_adjustments;

Line 1320: l_base_freight_adjustments := arpcurr.Currround(

1316: l_base_run_adj_tot;
1317: l_base_run_adj_tot := l_base_run_adj_tot + l_base_tax_adjustments;
1318:
1319: l_run_adj_tot := l_run_adj_tot + l_freight_adjustments;
1320: l_base_freight_adjustments := arpcurr.Currround(
1321: (l_run_adj_tot/l_total_adjustments)*
1322: l_base_total_adjustments ,l_base_curr_code) -
1323: l_base_run_adj_tot;
1324: l_base_run_adj_tot := l_base_run_adj_tot + l_base_freight_adjustments;

Line 1327: l_base_charges_adjustments := arpcurr.Currround(

1323: l_base_run_adj_tot;
1324: l_base_run_adj_tot := l_base_run_adj_tot + l_base_freight_adjustments;
1325:
1326: l_run_adj_tot := l_run_adj_tot + l_charges_adjustments;
1327: l_base_charges_adjustments := arpcurr.Currround(
1328: (l_run_adj_tot/l_total_adjustments)*
1329: l_base_total_adjustments ,l_base_curr_code) -
1330: l_base_run_adj_tot;
1331: l_base_run_adj_tot := l_base_run_adj_tot + l_base_charges_adjustments;

Line 1447: THEN l_base_line_discount := arpcurr.functional_amount(

1443: THEN
1444:
1445:
1446: IF ( l_line_discount IS NOT NULL )
1447: THEN l_base_line_discount := arpcurr.functional_amount(
1448: l_line_discount,
1449: l_base_curr_code,
1450: l_exchange_rate,
1451: l_base_precision,

Line 1457: THEN l_base_tax_discount := arpcurr.functional_amount(

1453: END IF;
1454:
1455:
1456: IF ( l_tax_discount IS NOT NULL )
1457: THEN l_base_tax_discount := arpcurr.functional_amount(
1458: l_tax_discount,
1459: l_base_curr_code,
1460: l_exchange_rate,
1461: l_base_precision,

Line 1467: THEN l_base_freight_discount := arpcurr.functional_amount(

1463: END IF;
1464:
1465:
1466: IF ( l_freight_discount IS NOT NULL )
1467: THEN l_base_freight_discount := arpcurr.functional_amount(
1468: l_freight_discount,
1469: l_base_curr_code,
1470: l_exchange_rate,
1471: l_base_precision,

Line 1476: THEN l_base_charges_discount := arpcurr.functional_amount(

1472: l_base_min_acc_unit);
1473: END IF;
1474:
1475: IF ( l_charges_discount IS NOT NULL )
1476: THEN l_base_charges_discount := arpcurr.functional_amount(
1477: l_charges_discount,
1478: l_base_curr_code,
1479: l_exchange_rate,
1480: l_base_precision,

Line 2074: arpcurr.CurrRound(

2070: END IF; -- end Guarantee case
2071:
2072:
2073: RETURN(
2074: arpcurr.CurrRound(
2075: GREATEST(
2076: l_commitment_bal,
2077: 0
2078: ),

Line 2709: l_base_line_original := arpcurr.functional_amount(

2705: + l_base_freight_adjustments; /*Bug6821893*/
2706:
2707: -- get functional currencies.
2708: IF ( l_line_original IS NOT NULL ) THEN
2709: l_base_line_original := arpcurr.functional_amount(
2710: l_line_original,
2711: l_base_curr_code,
2712: p_exchange_rate,
2713: l_base_precision,

Line 2718: l_base_tax_original := arpcurr.functional_amount(

2714: l_base_min_acc_unit);
2715: END IF;
2716:
2717: IF ( l_tax_original IS NOT NULL ) THEN
2718: l_base_tax_original := arpcurr.functional_amount(
2719: l_tax_original,
2720: l_base_curr_code,
2721: p_exchange_rate,
2722: l_base_precision,

Line 2727: l_base_freight_original := arpcurr.functional_amount(

2723: l_base_min_acc_unit);
2724: END IF;
2725:
2726: IF ( l_freight_original IS NOT NULL ) THEN
2727: l_base_freight_original := arpcurr.functional_amount(
2728: l_freight_original,
2729: l_base_curr_code,
2730: p_exchange_rate,
2731: l_base_precision,

Line 2742: l_base_tax_receipts := arpcurr.functional_amount(

2738: l_base_freight_original;
2739: END IF;
2740:
2741: IF (l_tax_receipts IS NOT NULL ) THEN
2742: l_base_tax_receipts := arpcurr.functional_amount(
2743: l_tax_receipts,
2744: l_base_curr_code,
2745: p_exchange_rate,
2746: l_base_precision,

Line 2751: l_base_charges_receipts := arpcurr.functional_amount(

2747: l_base_min_acc_unit);
2748: END IF;
2749:
2750: IF (l_charges_receipts IS NOT NULL ) THEN
2751: l_base_charges_receipts := arpcurr.functional_amount(
2752: l_charges_receipts,
2753: l_base_curr_code,
2754: p_exchange_rate,
2755: l_base_precision,

Line 2767: l_base_freight_discount := arpcurr.functional_amount(

2763: l_base_charges_receipts;
2764: END IF;
2765:
2766: IF (l_freight_discount IS NOT NULL ) THEN
2767: l_base_freight_discount := arpcurr.functional_amount(
2768: l_freight_discount,
2769: l_base_curr_code,
2770: p_exchange_rate,
2771: l_base_precision,