1: PACKAGE WSH_MAPPING_DATA AUTHID CURRENT_USER AS
2: /* $Header: WSHMAPDS.pls 120.1.12010000.5 2010/02/25 16:10:12 sankarun ship $ */
3:
4: C_SDEBUG CONSTANT NUMBER := wsh_debug_sv.C_LEVEL1;
5: C_DEBUG CONSTANT NUMBER := wsh_debug_sv.C_LEVEL2;
6:
7:
8: PROCEDURE Get_Delivery_Info ( p_delivery_id IN NUMBER,
1: PACKAGE WSH_MAPPING_DATA AUTHID CURRENT_USER AS
2: /* $Header: WSHMAPDS.pls 120.1.12010000.5 2010/02/25 16:10:12 sankarun ship $ */
3:
4: C_SDEBUG CONSTANT NUMBER := wsh_debug_sv.C_LEVEL1;
5: C_DEBUG CONSTANT NUMBER := wsh_debug_sv.C_LEVEL2;
6:
7:
8: PROCEDURE Get_Delivery_Info ( p_delivery_id IN NUMBER,
9: p_document_type IN VARCHAR2,