DBA Data[Home] [Help]

PACKAGE: APPS.WMS_PURGE_PVT

Source


1 PACKAGE WMS_PURGE_PVT AUTHID CURRENT_USER AS
2 /* $Header: WMSPURGS.pls 120.4 2006/08/10 11:13:08 bradha ship $*/
3 
4 PROCEDURE Check_Purge_LPNs (
5   p_api_version     IN         NUMBER
6 , p_init_msg_list   IN         VARCHAR2 := fnd_api.g_false
7 , p_commit          IN         VARCHAR2 := fnd_api.g_false
8 , x_return_status   OUT NOCOPY VARCHAR2
9 , x_msg_count       OUT NOCOPY NUMBER
10 , x_msg_data        OUT NOCOPY VARCHAR2
11 , p_caller          IN         VARCHAR2
12 , p_lock_flag       IN         VARCHAR2
13 , p_lpn_id_table    IN OUT NOCOPY WMS_DATA_TYPE_DEFINITIONS_PUB.NumberTableType
14 );
15 
16 PROCEDURE Purge_LPNs (
17   p_api_version     IN         NUMBER
18 , p_init_msg_list   IN         VARCHAR2 := fnd_api.g_false
19 , p_commit          IN         VARCHAR2 := fnd_api.g_false
20 , x_return_status   OUT NOCOPY VARCHAR2
21 , x_msg_count       OUT NOCOPY NUMBER
22 , x_msg_data        OUT NOCOPY VARCHAR2
23 , p_caller          IN         VARCHAR2
24 , p_lpn_id_table    IN         WMS_DATA_TYPE_DEFINITIONS_PUB.NumberTableType
25 , p_purge_count     IN OUT NOCOPY WMS_DATA_TYPE_DEFINITIONS_PUB.NumberTableType
26 );
27 
28 PROCEDURE purge_wms(
29                     	x_errbuf        OUT NOCOPY VARCHAR2,
30 			x_retcode      	OUT NOCOPY NUMBER,
31 			p_purge_date 	IN      VARCHAR2, -- Bug Fix 4496028
32 			p_orgid         IN      NUMBER,
33 			p_purge_name 	IN      VARCHAR2,
34                         p_purge_age     IN      NUMBER,
35                         p_purge_type    IN      NUMBER );
36 end WMS_PURGE_PVT;