DBA Data[Home] [Help]

APPS.WSH_WV_PVT dependencies on WSH_WVX_PVT

Line 602: wsh_wvx_pvt.ato_weight_volume(source,

598: v.volume);
599: END LOOP;
600:
601: FOR a IN dpw_loose_ato(departure_id) LOOP
602: wsh_wvx_pvt.ato_weight_volume(source,
603: a.ato_line_id,
604: a.qty,
605: master_weight_uom,
606: ato_weight,

Line 616: wsh_wvx_pvt.ato_weight_volume('BO',

612: END LOOP;
613:
614: FOR a IN dpw_bo_loose_ato(departure_id,
615: master_weight_uom, master_volume_uom) LOOP
616: wsh_wvx_pvt.ato_weight_volume('BO',
617: a.ato_line_id,
618: a.qty,
619: a.weight_uom,
620: ato_weight,

Line 647: wsh_wvx_pvt.ato_weight_volume(source,

643: END LOOP;
644:
645: FOR a IN sc_loose_ato(departure_id,
646: master_weight_uom, master_volume_uom, wv_mode) LOOP
647: wsh_wvx_pvt.ato_weight_volume(source,
648: a.ato_line_id,
649: a.qty,
650: a.weight_uom,
651: ato_weight,

Line 1119: wsh_wvx_pvt.ato_weight_volume(source,

1115: volume := volume + WSH_WV_PVT.convert_uom(v.uom, master_uom, v.volume);
1116: END LOOP;
1117:
1118: FOR a IN dpw_unpacked_ato(delivery_id) LOOP
1119: wsh_wvx_pvt.ato_weight_volume(source,
1120: a.ato_line_id,
1121: a.qty,
1122: NULL,
1123: ato_weight,

Line 1131: wsh_wvx_pvt.ato_weight_volume('BO',

1127: volume := volume + ato_volume;
1128: END LOOP;
1129:
1130: FOR a IN dpw_unpacked_bo_ato(delivery_id) LOOP
1131: wsh_wvx_pvt.ato_weight_volume('BO',
1132: a.ato_line_id,
1133: a.qty,
1134: NULL,
1135: ato_weight,

Line 1155: wsh_wvx_pvt.ato_weight_volume(source,

1151: volume := volume + WSH_WV_PVT.convert_uom(v.uom, master_uom, v.volume);
1152: END LOOP;
1153:
1154: FOR a IN sc_unpacked_ato(delivery_id, wv_mode) LOOP
1155: wsh_wvx_pvt.ato_weight_volume(source,
1156: a.ato_line_id,
1157: a.qty,
1158: NULL,
1159: ato_weight,

Line 1327: wsh_wvx_pvt.ato_weight_volume(source,

1323: + WSH_WV_PVT.convert_uom(nw.uom, master_uom, nw.weight);
1324: END LOOP;
1325:
1326: FOR a IN ato(delivery_id) LOOP
1327: wsh_wvx_pvt.ato_weight_volume(source,
1328: a.ato_line_id,
1329: a.qty,
1330: master_uom,
1331: ato_weight,

Line 1339: wsh_wvx_pvt.ato_weight_volume('BO',

1335: gross_weight := gross_weight + ato_weight;
1336: END LOOP;
1337:
1338: FOR a IN bo_ato(delivery_id) LOOP
1339: wsh_wvx_pvt.ato_weight_volume('BO',
1340: a.ato_line_id,
1341: a.qty,
1342: master_uom,
1343: ato_weight,

Line 1511: RETURN wsh_wvx_pvt.x_containers_load_check(

1507: status IN OUT NUMBER)
1508: RETURN BOOLEAN
1509: IS
1510: BEGIN
1511: RETURN wsh_wvx_pvt.x_containers_load_check(
1512: delivery_id,
1513: pack_mode,
1514: status);
1515: END containers_load_check;

Line 1758: wsh_wvx_pvt.ato_weight_volume('SC',

1754: contents.weight);
1755: END LOOP;
1756:
1757: FOR a IN packed_ato(delivery_id, container.id, wv_mode) LOOP
1758: wsh_wvx_pvt.ato_weight_volume('SC',
1759: a.ato_line_id,
1760: a.qty,
1761: master_uom,
1762: ato_weight,

Line 1903: wsh_wvx_pvt.ato_weight_volume('SC',

1899: + WSH_WV_PVT.convert_uom(ti.uom, master_uom, ti.weight);
1900: END LOOP;
1901:
1902: FOR a IN unpacked_ato(delivery_id, wv_mode) LOOP
1903: wsh_wvx_pvt.ato_weight_volume('SC',
1904: a.ato_line_id,
1905: a.qty,
1906: master_uom,
1907: ato_weight,

Line 2213: return wsh_wvx_pvt.x_order_net_wt_in_delivery(

2209: delivery_id IN NUMBER,
2210: weight_uom IN VARCHAR2)
2211: RETURN NUMBER IS
2212: BEGIN
2213: return wsh_wvx_pvt.x_order_net_wt_in_delivery(
2214: order_number => order_number,
2215: order_type_id => order_type_id,
2216: delivery_id => delivery_id,
2217: weight_uom => weight_uom);