eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.WSH_FC_INTERFACE_PKG dependencies on STANDARD

Line 438: l_standard_uom VARCHAR2(3) := NULL;

434: IS
435:
436:
437: l_container_quantity NUMBER := 0;
438: l_standard_uom VARCHAR2(3) := NULL;
439: l_quantity_in_st_uom NUMBER := 0;
440: l_counter NUMBER := 0;
441: l_cost_factor VARCHAR2(8) := NULL;
442: i NUMBER := 0;

Line 536: l_standard_uom := NULL;

532: END IF;
533: --
534:
535: IF (l_cost_factor = 'WEIGHT') THEN
536: l_standard_uom := NULL;
537: FOR i in 1 .. p_Relevant_Info_Tab.count LOOP
538: IF p_Relevant_Info_Tab(i).container_id = p_container_id AND
539: p_Relevant_Info_Tab(i).shipped_quantity <> 0 THEN
540: IF l_standard_uom is NULL THEN

Line 540: IF l_standard_uom is NULL THEN

536: l_standard_uom := NULL;
537: FOR i in 1 .. p_Relevant_Info_Tab.count LOOP
538: IF p_Relevant_Info_Tab(i).container_id = p_container_id AND
539: p_Relevant_Info_Tab(i).shipped_quantity <> 0 THEN
540: IF l_standard_uom is NULL THEN
541: l_standard_uom := p_Relevant_Info_Tab(i).weight_uom_code;
542: END IF;
543: -- need to convert weight to same uom to do calculation
544: --

Line 541: l_standard_uom := p_Relevant_Info_Tab(i).weight_uom_code;

537: FOR i in 1 .. p_Relevant_Info_Tab.count LOOP
538: IF p_Relevant_Info_Tab(i).container_id = p_container_id AND
539: p_Relevant_Info_Tab(i).shipped_quantity <> 0 THEN
540: IF l_standard_uom is NULL THEN
541: l_standard_uom := p_Relevant_Info_Tab(i).weight_uom_code;
542: END IF;
543: -- need to convert weight to same uom to do calculation
544: --
545: -- Debug Statements

Line 554: to_uom => l_standard_uom,

550: --
551:
552: l_quantity_in_st_uom := WSH_WV_UTILS.convert_uom(
553: from_uom => p_Relevant_Info_Tab(i).weight_uom_code,
554: to_uom => l_standard_uom,
555: quantity => p_Relevant_Info_Tab(i).net_weight,
556: item_id => p_Relevant_Info_Tab(i).inventory_item_id);
557:
558: l_counter := l_counter + 1;

Line 564: x_Cost_Breakdown(l_counter).uom := l_standard_uom;

560: x_Cost_Breakdown(l_counter).container_id := p_Relevant_Info_Tab(i).container_id;
561: x_Cost_Breakdown(l_counter).delivery_id := p_Relevant_Info_Tab(i).delivery_id;
562: x_Cost_Breakdown(l_counter).stop_id := p_Relevant_Info_Tab(i).stop_id;
563: x_Cost_Breakdown(l_counter).quantity := l_quantity_in_st_uom;
564: x_Cost_Breakdown(l_counter).uom := l_standard_uom;
565: --
566: -- Debug Statements
567: --
568: IF l_debug_on THEN

Line 582: l_standard_uom := NULL;

578:
579: END IF;
580: END LOOP;
581: ELSIF (l_cost_factor = 'VOLUME') THEN
582: l_standard_uom := NULL;
583: FOR i in 1 .. p_Relevant_Info_Tab.count LOOP
584: IF p_Relevant_Info_Tab(i).container_id = p_container_id AND
585: p_Relevant_Info_Tab(i).shipped_quantity <> 0 THEN
586: IF l_standard_uom is NULL THEN

Line 586: IF l_standard_uom is NULL THEN

582: l_standard_uom := NULL;
583: FOR i in 1 .. p_Relevant_Info_Tab.count LOOP
584: IF p_Relevant_Info_Tab(i).container_id = p_container_id AND
585: p_Relevant_Info_Tab(i).shipped_quantity <> 0 THEN
586: IF l_standard_uom is NULL THEN
587: l_standard_uom := p_Relevant_Info_Tab(i).volume_uom_code;
588: END IF;
589: -- need to convert weight to same uom to do calculation
590: --

Line 587: l_standard_uom := p_Relevant_Info_Tab(i).volume_uom_code;

583: FOR i in 1 .. p_Relevant_Info_Tab.count LOOP
584: IF p_Relevant_Info_Tab(i).container_id = p_container_id AND
585: p_Relevant_Info_Tab(i).shipped_quantity <> 0 THEN
586: IF l_standard_uom is NULL THEN
587: l_standard_uom := p_Relevant_Info_Tab(i).volume_uom_code;
588: END IF;
589: -- need to convert weight to same uom to do calculation
590: --
591: -- Debug Statements

Line 599: to_uom => l_standard_uom,

595: END IF;
596: --
597: l_quantity_in_st_uom := WSH_WV_UTILS.convert_uom(
598: from_uom => p_Relevant_Info_Tab(i).volume_uom_code,
599: to_uom => l_standard_uom,
600: quantity => p_Relevant_Info_Tab(i).volume,
601: item_id => p_Relevant_Info_Tab(i).inventory_item_id);
602:
603: l_counter := l_counter + 1;

Line 609: x_Cost_Breakdown(l_counter).uom := l_standard_uom;

605: x_Cost_Breakdown(l_counter).container_id := p_Relevant_Info_Tab(i).container_id;
606: x_Cost_Breakdown(l_counter).delivery_id := p_Relevant_Info_Tab(i).delivery_id;
607: x_Cost_Breakdown(l_counter).stop_id := p_Relevant_Info_Tab(i).stop_id;
608: x_Cost_Breakdown(l_counter).quantity := l_quantity_in_st_uom;
609: x_Cost_Breakdown(l_counter).uom := l_standard_uom;
610: --
611: -- Debug Statements
612: --
613: IF l_debug_on THEN

Line 626: l_standard_uom := NULL;

622: l_container_quantity := l_container_quantity + l_quantity_in_st_uom;
623: END IF;
624: END LOOP;
625: ELSE
626: l_standard_uom := NULL;
627: FOR i in 1 .. p_Relevant_Info_Tab.count LOOP
628: IF p_Relevant_Info_Tab(i).container_id = p_container_id AND
629: p_Relevant_Info_Tab(i).shipped_quantity <> 0 THEN
630: -- shipped quantity

Line 631: IF l_standard_uom is NULL THEN

627: FOR i in 1 .. p_Relevant_Info_Tab.count LOOP
628: IF p_Relevant_Info_Tab(i).container_id = p_container_id AND
629: p_Relevant_Info_Tab(i).shipped_quantity <> 0 THEN
630: -- shipped quantity
631: IF l_standard_uom is NULL THEN
632: l_standard_uom := p_Relevant_Info_Tab(i).requested_quantity_uom;
633: END IF;
634: -- need to convert weight to same uom to do calculation
635: --

Line 632: l_standard_uom := p_Relevant_Info_Tab(i).requested_quantity_uom;

628: IF p_Relevant_Info_Tab(i).container_id = p_container_id AND
629: p_Relevant_Info_Tab(i).shipped_quantity <> 0 THEN
630: -- shipped quantity
631: IF l_standard_uom is NULL THEN
632: l_standard_uom := p_Relevant_Info_Tab(i).requested_quantity_uom;
633: END IF;
634: -- need to convert weight to same uom to do calculation
635: --
636: -- Debug Statements

Line 644: to_uom => l_standard_uom,

640: END IF;
641: -- 3935583, add item_id parameter
642: l_quantity_in_st_uom := WSH_WV_UTILS.convert_uom(
643: from_uom => p_Relevant_Info_Tab(i).requested_quantity_uom,
644: to_uom => l_standard_uom,
645: quantity => p_Relevant_Info_Tab(i).shipped_quantity,
646: item_id => p_Relevant_Info_Tab(i).inventory_item_id);
647:
648: l_counter := l_counter + 1;

Line 654: x_Cost_Breakdown(l_counter).uom := l_standard_uom;

650: x_Cost_Breakdown(l_counter).container_id := p_Relevant_Info_Tab(i).container_id;
651: x_Cost_Breakdown(l_counter).delivery_id := p_Relevant_Info_Tab(i).delivery_id;
652: x_Cost_Breakdown(l_counter).stop_id := p_Relevant_Info_Tab(i).stop_id;
653: x_Cost_Breakdown(l_counter).quantity := l_quantity_in_st_uom;
654: x_Cost_Breakdown(l_counter).uom := l_standard_uom;
655: --
656: -- Debug Statements
657: --
658: IF l_debug_on THEN

Line 735: l_standard_uom VARCHAR2(3) := NULL;

731: ) RETURN NUMBER
732: IS
733:
734: l_delivery_quantity NUMBER := 0;
735: l_standard_uom VARCHAR2(3) := NULL;
736: l_quantity_in_st_uom NUMBER := 0;
737: l_counter NUMBER := 0;
738: l_cost_factor VARCHAR2(8) := NULL;
739: i NUMBER := 0;

Line 834: l_standard_uom := NULL;

830: END IF;
831: --
832:
833: IF (l_cost_factor = 'WEIGHT') THEN
834: l_standard_uom := NULL;
835: FOR i in 1 .. p_Relevant_Info_Tab.count LOOP
836: IF p_Relevant_Info_Tab(i).delivery_id = p_delivery_id AND
837: p_Relevant_Info_Tab(i).shipped_quantity <> 0 THEN
838: IF l_standard_uom is NULL THEN

Line 838: IF l_standard_uom is NULL THEN

834: l_standard_uom := NULL;
835: FOR i in 1 .. p_Relevant_Info_Tab.count LOOP
836: IF p_Relevant_Info_Tab(i).delivery_id = p_delivery_id AND
837: p_Relevant_Info_Tab(i).shipped_quantity <> 0 THEN
838: IF l_standard_uom is NULL THEN
839: l_standard_uom := p_Relevant_Info_Tab(i).weight_uom_code;
840: END IF;
841: -- need to convert weight to same uom to do calculation
842: --

Line 839: l_standard_uom := p_Relevant_Info_Tab(i).weight_uom_code;

835: FOR i in 1 .. p_Relevant_Info_Tab.count LOOP
836: IF p_Relevant_Info_Tab(i).delivery_id = p_delivery_id AND
837: p_Relevant_Info_Tab(i).shipped_quantity <> 0 THEN
838: IF l_standard_uom is NULL THEN
839: l_standard_uom := p_Relevant_Info_Tab(i).weight_uom_code;
840: END IF;
841: -- need to convert weight to same uom to do calculation
842: --
843: -- Debug Statements

Line 851: to_uom => l_standard_uom,

847: END IF;
848: -- bug 3935583 , passed value to item_id parameter
849: l_quantity_in_st_uom := WSH_WV_UTILS.convert_uom(
850: from_uom => p_Relevant_Info_Tab(i).weight_uom_code,
851: to_uom => l_standard_uom,
852: quantity => p_Relevant_Info_Tab(i).net_weight,
853: item_id => p_Relevant_Info_Tab(i).inventory_item_id);
854:
855: l_counter := l_counter + 1;

Line 860: x_Cost_Breakdown(l_counter).uom := l_standard_uom;

856: x_Cost_Breakdown(l_counter).delivery_detail_id := p_Relevant_Info_Tab(i).delivery_detail_id;
857: x_Cost_Breakdown(l_counter).delivery_id := p_Relevant_Info_Tab(i).delivery_id;
858: x_Cost_Breakdown(l_counter).stop_id := p_Relevant_Info_Tab(i).stop_id;
859: x_Cost_Breakdown(l_counter).quantity := l_quantity_in_st_uom;
860: x_Cost_Breakdown(l_counter).uom := l_standard_uom;
861: --
862: -- Debug Statements
863: --
864: IF l_debug_on THEN

Line 878: l_standard_uom := NULL;

874:
875: END IF;
876: END LOOP;
877: ELSIF (l_cost_factor = 'VOLUME') THEN
878: l_standard_uom := NULL;
879: FOR i in 1 .. p_Relevant_Info_Tab.count LOOP
880: IF p_Relevant_Info_Tab(i).delivery_id = p_delivery_id AND
881: p_Relevant_Info_Tab(i).shipped_quantity <> 0 THEN
882: IF l_standard_uom is NULL THEN

Line 882: IF l_standard_uom is NULL THEN

878: l_standard_uom := NULL;
879: FOR i in 1 .. p_Relevant_Info_Tab.count LOOP
880: IF p_Relevant_Info_Tab(i).delivery_id = p_delivery_id AND
881: p_Relevant_Info_Tab(i).shipped_quantity <> 0 THEN
882: IF l_standard_uom is NULL THEN
883: l_standard_uom := p_Relevant_Info_Tab(i).volume_uom_code;
884: END IF;
885: -- need to convert weight to same uom to do calculation
886: --

Line 883: l_standard_uom := p_Relevant_Info_Tab(i).volume_uom_code;

879: FOR i in 1 .. p_Relevant_Info_Tab.count LOOP
880: IF p_Relevant_Info_Tab(i).delivery_id = p_delivery_id AND
881: p_Relevant_Info_Tab(i).shipped_quantity <> 0 THEN
882: IF l_standard_uom is NULL THEN
883: l_standard_uom := p_Relevant_Info_Tab(i).volume_uom_code;
884: END IF;
885: -- need to convert weight to same uom to do calculation
886: --
887: -- Debug Statements

Line 895: to_uom => l_standard_uom,

891: END IF;
892: -- bug 3935583 , passed value to item_id parameter
893: l_quantity_in_st_uom := WSH_WV_UTILS.convert_uom(
894: from_uom => p_Relevant_Info_Tab(i).volume_uom_code,
895: to_uom => l_standard_uom,
896: quantity => p_Relevant_Info_Tab(i).volume,
897: item_id => p_Relevant_Info_Tab(i).inventory_item_id);
898: l_counter := l_counter + 1;
899: x_Cost_Breakdown(l_counter).delivery_detail_id := p_Relevant_Info_Tab(i).delivery_detail_id;

Line 903: x_Cost_Breakdown(l_counter).uom := l_standard_uom;

899: x_Cost_Breakdown(l_counter).delivery_detail_id := p_Relevant_Info_Tab(i).delivery_detail_id;
900: x_Cost_Breakdown(l_counter).delivery_id := p_Relevant_Info_Tab(i).delivery_id;
901: x_Cost_Breakdown(l_counter).stop_id := p_Relevant_Info_Tab(i).stop_id;
902: x_Cost_Breakdown(l_counter).quantity := l_quantity_in_st_uom;
903: x_Cost_Breakdown(l_counter).uom := l_standard_uom;
904: --
905: -- Debug Statements
906: --
907: IF l_debug_on THEN

Line 920: l_standard_uom := NULL;

916: l_delivery_quantity := l_delivery_quantity + l_quantity_in_st_uom;
917: END IF;
918: END LOOP;
919: ELSE
920: l_standard_uom := NULL;
921: FOR i in 1 .. p_Relevant_Info_Tab.count LOOP
922: IF p_Relevant_Info_Tab(i).delivery_id = p_delivery_id AND
923: p_Relevant_Info_Tab(i).shipped_quantity <> 0 THEN
924: -- shipped quantity

Line 925: IF l_standard_uom is NULL THEN

921: FOR i in 1 .. p_Relevant_Info_Tab.count LOOP
922: IF p_Relevant_Info_Tab(i).delivery_id = p_delivery_id AND
923: p_Relevant_Info_Tab(i).shipped_quantity <> 0 THEN
924: -- shipped quantity
925: IF l_standard_uom is NULL THEN
926: l_standard_uom := p_Relevant_Info_Tab(i).requested_quantity_uom;
927: END IF;
928: -- need to convert weight to same uom to do calculation
929: --

Line 926: l_standard_uom := p_Relevant_Info_Tab(i).requested_quantity_uom;

922: IF p_Relevant_Info_Tab(i).delivery_id = p_delivery_id AND
923: p_Relevant_Info_Tab(i).shipped_quantity <> 0 THEN
924: -- shipped quantity
925: IF l_standard_uom is NULL THEN
926: l_standard_uom := p_Relevant_Info_Tab(i).requested_quantity_uom;
927: END IF;
928: -- need to convert weight to same uom to do calculation
929: --
930: -- Debug Statements

Line 938: to_uom => l_standard_uom,

934: END IF;
935: -- bug 3935583, passed value to item_id
936: l_quantity_in_st_uom := WSH_WV_UTILS.convert_uom(
937: from_uom => p_Relevant_Info_Tab(i).requested_quantity_uom,
938: to_uom => l_standard_uom,
939: quantity => p_Relevant_Info_Tab(i).shipped_quantity,
940: item_id => p_Relevant_Info_Tab(i).inventory_item_id);
941: l_counter := l_counter + 1;
942: x_Cost_Breakdown(l_counter).delivery_detail_id := p_Relevant_Info_Tab(i).delivery_detail_id;

Line 946: x_Cost_Breakdown(l_counter).uom := l_standard_uom;

942: x_Cost_Breakdown(l_counter).delivery_detail_id := p_Relevant_Info_Tab(i).delivery_detail_id;
943: x_Cost_Breakdown(l_counter).delivery_id := p_Relevant_Info_Tab(i).delivery_id;
944: x_Cost_Breakdown(l_counter).stop_id := p_Relevant_Info_Tab(i).stop_id;
945: x_Cost_Breakdown(l_counter).quantity := l_quantity_in_st_uom;
946: x_Cost_Breakdown(l_counter).uom := l_standard_uom;
947: --
948: -- Debug Statements
949: --
950: IF l_debug_on THEN

Line 1025: l_standard_uom VARCHAR2(3) := NULL;

1021: ) RETURN NUMBER
1022: IS
1023:
1024: l_stop_quantity NUMBER := 0;
1025: l_standard_uom VARCHAR2(3) := NULL;
1026: l_quantity_in_st_uom NUMBER := 0;
1027: l_counter NUMBER := 0;
1028: l_cost_factor VARCHAR2(8) := NULL;
1029: i NUMBER := 0;

Line 1123: l_standard_uom := NULL;

1119: END IF;
1120: --
1121:
1122: IF (l_cost_factor = 'WEIGHT') THEN
1123: l_standard_uom := NULL;
1124: FOR i in 1 .. p_Relevant_Info_Tab.count LOOP
1125: IF p_Relevant_Info_Tab(i).stop_id = p_stop_id AND
1126: p_Relevant_Info_Tab(i).shipped_quantity <> 0 THEN
1127: IF l_standard_uom is NULL THEN

Line 1127: IF l_standard_uom is NULL THEN

1123: l_standard_uom := NULL;
1124: FOR i in 1 .. p_Relevant_Info_Tab.count LOOP
1125: IF p_Relevant_Info_Tab(i).stop_id = p_stop_id AND
1126: p_Relevant_Info_Tab(i).shipped_quantity <> 0 THEN
1127: IF l_standard_uom is NULL THEN
1128: l_standard_uom := p_Relevant_Info_Tab(i).weight_uom_code;
1129: END IF;
1130: -- need to convert weight to same uom to do calculation
1131: --

Line 1128: l_standard_uom := p_Relevant_Info_Tab(i).weight_uom_code;

1124: FOR i in 1 .. p_Relevant_Info_Tab.count LOOP
1125: IF p_Relevant_Info_Tab(i).stop_id = p_stop_id AND
1126: p_Relevant_Info_Tab(i).shipped_quantity <> 0 THEN
1127: IF l_standard_uom is NULL THEN
1128: l_standard_uom := p_Relevant_Info_Tab(i).weight_uom_code;
1129: END IF;
1130: -- need to convert weight to same uom to do calculation
1131: --
1132: -- Debug Statements

Line 1141: to_uom => l_standard_uom,

1137: --
1138: -- bug 3935583, passed value to item_id
1139: l_quantity_in_st_uom := WSH_WV_UTILS.convert_uom(
1140: from_uom => p_Relevant_Info_Tab(i).weight_uom_code,
1141: to_uom => l_standard_uom,
1142: quantity => p_Relevant_Info_Tab(i).net_weight,
1143: item_id => p_Relevant_Info_Tab(i).inventory_item_id);
1144: l_counter := l_counter + 1;
1145: x_Cost_Breakdown(l_counter).delivery_detail_id := p_Relevant_Info_Tab(i).delivery_detail_id;

Line 1149: x_Cost_Breakdown(l_counter).uom := l_standard_uom;

1145: x_Cost_Breakdown(l_counter).delivery_detail_id := p_Relevant_Info_Tab(i).delivery_detail_id;
1146: x_Cost_Breakdown(l_counter).delivery_id := p_Relevant_Info_Tab(i).delivery_id;
1147: x_Cost_Breakdown(l_counter).stop_id := p_Relevant_Info_Tab(i).stop_id;
1148: x_Cost_Breakdown(l_counter).quantity := l_quantity_in_st_uom;
1149: x_Cost_Breakdown(l_counter).uom := l_standard_uom;
1150: --
1151: -- Debug Statements
1152: --
1153: IF l_debug_on THEN

Line 1167: l_standard_uom := NULL;

1163:
1164: END IF;
1165: END LOOP;
1166: ELSIF (l_cost_factor = 'VOLUME') THEN
1167: l_standard_uom := NULL;
1168: FOR i in 1 .. p_Relevant_Info_Tab.count LOOP
1169: IF p_Relevant_Info_Tab(i).stop_id = p_stop_id AND
1170: p_Relevant_Info_Tab(i).shipped_quantity <> 0 THEN
1171: IF l_standard_uom is NULL THEN

Line 1171: IF l_standard_uom is NULL THEN

1167: l_standard_uom := NULL;
1168: FOR i in 1 .. p_Relevant_Info_Tab.count LOOP
1169: IF p_Relevant_Info_Tab(i).stop_id = p_stop_id AND
1170: p_Relevant_Info_Tab(i).shipped_quantity <> 0 THEN
1171: IF l_standard_uom is NULL THEN
1172: l_standard_uom := p_Relevant_Info_Tab(i).volume_uom_code;
1173: END IF;
1174: -- need to convert weight to same uom to do calculation
1175: --

Line 1172: l_standard_uom := p_Relevant_Info_Tab(i).volume_uom_code;

1168: FOR i in 1 .. p_Relevant_Info_Tab.count LOOP
1169: IF p_Relevant_Info_Tab(i).stop_id = p_stop_id AND
1170: p_Relevant_Info_Tab(i).shipped_quantity <> 0 THEN
1171: IF l_standard_uom is NULL THEN
1172: l_standard_uom := p_Relevant_Info_Tab(i).volume_uom_code;
1173: END IF;
1174: -- need to convert weight to same uom to do calculation
1175: --
1176: -- Debug Statements

Line 1184: to_uom => l_standard_uom,

1180: END IF;
1181: -- 3935583 , passed value to item_id
1182: l_quantity_in_st_uom := WSH_WV_UTILS.convert_uom(
1183: from_uom => p_Relevant_Info_Tab(i).volume_uom_code,
1184: to_uom => l_standard_uom,
1185: quantity => p_Relevant_Info_Tab(i).volume,
1186: item_id => p_Relevant_Info_Tab(i).inventory_item_id);
1187: l_counter := l_counter + 1;
1188: x_Cost_Breakdown(l_counter).delivery_detail_id := p_Relevant_Info_Tab(i).delivery_detail_id;

Line 1192: x_Cost_Breakdown(l_counter).uom := l_standard_uom;

1188: x_Cost_Breakdown(l_counter).delivery_detail_id := p_Relevant_Info_Tab(i).delivery_detail_id;
1189: x_Cost_Breakdown(l_counter).delivery_id := p_Relevant_Info_Tab(i).delivery_id;
1190: x_Cost_Breakdown(l_counter).stop_id := p_Relevant_Info_Tab(i).stop_id;
1191: x_Cost_Breakdown(l_counter).quantity := l_quantity_in_st_uom;
1192: x_Cost_Breakdown(l_counter).uom := l_standard_uom;
1193: --
1194: -- Debug Statements
1195: --
1196: IF l_debug_on THEN

Line 1209: l_standard_uom := NULL;

1205: l_stop_quantity := l_stop_quantity + l_quantity_in_st_uom;
1206: END IF;
1207: END LOOP;
1208: ELSE
1209: l_standard_uom := NULL;
1210: FOR i in 1 .. p_Relevant_Info_Tab.count LOOP
1211: IF p_Relevant_Info_Tab(i).stop_id = p_stop_id AND
1212: p_Relevant_Info_Tab(i).shipped_quantity <> 0 THEN
1213: -- shipped quantity

Line 1214: IF l_standard_uom is NULL THEN

1210: FOR i in 1 .. p_Relevant_Info_Tab.count LOOP
1211: IF p_Relevant_Info_Tab(i).stop_id = p_stop_id AND
1212: p_Relevant_Info_Tab(i).shipped_quantity <> 0 THEN
1213: -- shipped quantity
1214: IF l_standard_uom is NULL THEN
1215: l_standard_uom := p_Relevant_Info_Tab(i).requested_quantity_uom;
1216: END IF;
1217: -- need to convert weight to same uom to do calculation
1218: --

Line 1215: l_standard_uom := p_Relevant_Info_Tab(i).requested_quantity_uom;

1211: IF p_Relevant_Info_Tab(i).stop_id = p_stop_id AND
1212: p_Relevant_Info_Tab(i).shipped_quantity <> 0 THEN
1213: -- shipped quantity
1214: IF l_standard_uom is NULL THEN
1215: l_standard_uom := p_Relevant_Info_Tab(i).requested_quantity_uom;
1216: END IF;
1217: -- need to convert weight to same uom to do calculation
1218: --
1219: -- Debug Statements

Line 1227: to_uom => l_standard_uom,

1223: END IF;
1224: --
1225: l_quantity_in_st_uom := WSH_WV_UTILS.convert_uom(
1226: from_uom => p_Relevant_Info_Tab(i).requested_quantity_uom,
1227: to_uom => l_standard_uom,
1228: quantity => p_Relevant_Info_Tab(i).shipped_quantity,
1229: item_id => p_Relevant_Info_Tab(i).inventory_item_id);
1230: l_counter := l_counter + 1;
1231: x_Cost_Breakdown(l_counter).delivery_detail_id := p_Relevant_Info_Tab(i).delivery_detail_id;

Line 1235: x_Cost_Breakdown(l_counter).uom := l_standard_uom;

1231: x_Cost_Breakdown(l_counter).delivery_detail_id := p_Relevant_Info_Tab(i).delivery_detail_id;
1232: x_Cost_Breakdown(l_counter).delivery_id := p_Relevant_Info_Tab(i).delivery_id;
1233: x_Cost_Breakdown(l_counter).stop_id := p_Relevant_Info_Tab(i).stop_id;
1234: x_Cost_Breakdown(l_counter).quantity := l_quantity_in_st_uom;
1235: x_Cost_Breakdown(l_counter).uom := l_standard_uom;
1236: --
1237: -- Debug Statements
1238: --
1239: IF l_debug_on THEN

Line 3696: l_standard_uom VARCHAR2(3);

3692: l_amount NUMBER;
3693: l_uom VARCHAR2(3);
3694: l_unit NUMBER;
3695: l_unit_in_st_uom NUMBER;
3696: l_standard_uom VARCHAR2(3);
3697: l_total_units NUMBER := 0;
3698: l_distributed_charge NUMBER := 0;
3699: l_check NUMBER := 0;
3700: l_round_distributed_charge NUMBER := 0;

Line 3756: -- Fetch uom of the first detail as standard uom

3752: FROM wsh_delivery_details
3753: WHERE source_line_id = l_line_id and
3754: source_code = 'OE';
3755:
3756: -- Fetch uom of the first detail as standard uom
3757: OPEN C_Details_Assigned(l_line_id);
3758: FETCH C_Details_Assigned INTO l_detail_id;
3759: CLOSE C_Details_Assigned;
3760:

Line 3762: INTO l_standard_uom

3758: FETCH C_Details_Assigned INTO l_detail_id;
3759: CLOSE C_Details_Assigned;
3760:
3761: SELECT requested_quantity_uom
3762: INTO l_standard_uom
3763: FROM wsh_delivery_details
3764: WHERE delivery_detail_id = l_detail_id;
3765:
3766: OPEN C_Details_Assigned(l_line_id);

Line 3785: to_uom => l_standard_uom,

3781: END IF;
3782: -- 3935583
3783: l_unit_in_st_uom := WSH_WV_UTILS.convert_uom(
3784: from_uom => l_uom,
3785: to_uom => l_standard_uom,
3786: quantity => l_unit,
3787: item_id => l_inventory_item_id);
3788: l_total_units := l_total_units + l_unit_in_st_uom;
3789: END LOOP;

Line 3813: to_uom => l_standard_uom,

3809: --
3810: -- 3935583
3811: l_unit_in_st_uom := WSH_WV_UTILS.convert_uom(
3812: from_uom => l_uom,
3813: to_uom => l_standard_uom,
3814: quantity => l_unit,
3815: item_id => l_inventory_item_id);
3816:
3817: l_distributed_charge := l_amount * (l_unit_in_st_uom/l_total_units);