DBA Data[Home] [Help]

APPS.WSH_SC_DELIVERY_PVT dependencies on WSH_SC_PLD_PKG

Line 70: -- wsh_sc_pld_pkg (WShSCPDB.pls) is our guy to do this. He takes care

66:
67:
68: -- If a serial number range has been entered for the shipped quantity of the
69: -- item, then we need to explode the picking line details.
70: -- wsh_sc_pld_pkg (WShSCPDB.pls) is our guy to do this. He takes care
71: -- of exploding only those lines that need to be.
72:
73: WSH_SC_PLD_PKG.Close_Details(del_id);
74:

Line 73: WSH_SC_PLD_PKG.Close_Details(del_id);

69: -- item, then we need to explode the picking line details.
70: -- wsh_sc_pld_pkg (WShSCPDB.pls) is our guy to do this. He takes care
71: -- of exploding only those lines that need to be.
72:
73: WSH_SC_PLD_PKG.Close_Details(del_id);
74:
75: -- We are now ready to update the delivery status to closed
76: select sysdate into close_date from sys.dual;
77: UPDATE wsh_deliveries

Line 212: wsh_sc_pld_pkg.delete_from_msnt(del_id);

208: SET departure_id = dep_id
209: WHERE delivery_id = del_id;
210:
211: -- clear any serial number entered in MTL_SERIAL_NUMBERS_TEMP
212: wsh_sc_pld_pkg.delete_from_msnt(del_id);
213:
214:
215: -- if we come here with no errors then we are ready to return back to the client
216: -- with a value of 'True'