APPS.WSH_INTERFACE_MESSAGE_PKG dependencies on WSH_NEW_DEL_INTERFACE

Line 6: -- Purpose: Locking records in wsh_del_details_interface and wsh_new_del_interface

2: /* $Header: WSHINMSB.pls 120.0.12010000.1 2009/03/26 06:00:08 brana noship $ */
3:
4: /*==============================================================================
5: -- PROCEDURE: lock_record
6: -- Purpose: Locking records in wsh_del_details_interface and wsh_new_del_interface
7: -- Description: This procedure is called from Interface Message Correction Form
8: -- for locking the record in table wsh_del_details_interface
9: -- and wsh_new_del_interface
10: * ==============================================================================*/

Line 9: -- and wsh_new_del_interface

5: -- PROCEDURE: lock_record
6: -- Purpose: Locking records in wsh_del_details_interface and wsh_new_del_interface
7: -- Description: This procedure is called from Interface Message Correction Form
8: -- for locking the record in table wsh_del_details_interface
9: -- and wsh_new_del_interface
10: * ==============================================================================*/
11:
12: --
13: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_INTERFACE_MESSAGE_PKG';

Line 23: FROM wsh_new_del_interface

19:
20:
21: CURSOR l_lock_del_interface is
22: SELECT 1
23: FROM wsh_new_del_interface
24: WHERE delivery_interface_id = p_delivery_interface_id
25: FOR UPDATE NOWAIT;
26:
27: