DBA Data[Home] [Help]

PACKAGE: APPS.IEX_DEL_SUB_PVT

Source


1 PACKAGE IEX_DEL_SUB_PVT AUTHID CURRENT_USER AS
2 /* $Header: iexpdlss.pls 120.0 2004/01/24 03:19:29 appldev noship $ */
3 
4   G_PKG_NAME     CONSTANT VARCHAR2(30) := 'IEX_DEL_SUB_PVT';
5   G_FILE_NAME    CONSTANT VARCHAR2(30) := 'iexpdlss.pls';
6 
7 
8   PROCEDURE Add_rec   (p_api_version         IN  NUMBER	,
9                        p_init_msg_list       IN  VARCHAR2 DEFAULT FND_API.G_FALSE,
10                        p_commit		   IN  VARCHAR2 DEFAULT FND_API.G_FALSE,
11                        p_validation_level    IN  NUMBER   DEFAULT FND_API.G_VALID_LEVEL_FULL,
12                        x_return_status       OUT NOCOPY VARCHAR2	,
13                        x_msg_count           OUT NOCOPY NUMBER	,
14                        x_msg_data            OUT NOCOPY VARCHAR2	,
15 			     p_source_module	   IN	 VARCHAR2	,
16 			     p_id_tbl		   IN  IEX_UTILITIES.t_numbers,
17                        p_del_id		   IN  Number	,
18                        p_object_code	   IN  Varchar2	,
19                        p_object_id	     	   IN  IEX_DEL_ASSETS.object_id%TYPE         	);
20 
21   PROCEDURE Add_All_rec(p_api_version        IN  NUMBER	,
22                        p_init_msg_list       IN  VARCHAR2 DEFAULT FND_API.G_FALSE,
23                        p_commit		   IN  VARCHAR2 DEFAULT FND_API.G_FALSE,
24                        p_validation_level    IN  NUMBER   DEFAULT FND_API.G_VALID_LEVEL_FULL,
25                        x_return_status       OUT NOCOPY VARCHAR2	,
26                        x_msg_count           OUT NOCOPY NUMBER	,
27                        x_msg_data            OUT NOCOPY VARCHAR2	,
28 			     p_source_module	   IN	 VARCHAR2	,
29                        p_del_id		   IN  Number	,
30                        p_object_code	   IN  Varchar2	,
31                        p_object_id	     	   IN  Number	);
32 
33   PROCEDURE Remove_rec(p_api_version         IN  NUMBER,
34                        p_init_msg_list       IN  VARCHAR2 DEFAULT FND_API.G_FALSE,
35                        p_commit		   IN  VARCHAR2 DEFAULT FND_API.G_FALSE,
36                        p_validation_level    IN  NUMBER   DEFAULT FND_API.G_VALID_LEVEL_FULL,
37                        x_return_status       OUT NOCOPY VARCHAR2,
38                        x_msg_count           OUT NOCOPY NUMBER,
39                        x_msg_data            OUT NOCOPY VARCHAR2,
40 			           p_source_module	   IN	 VARCHAR2,
41                        p_id_tbl	   	   IN  IEX_UTILITIES.t_numbers) ;
42 
43 
44    PROCEDURE Remove_All_rec(
45 			     p_api_version        IN  NUMBER	,
46                        p_init_msg_list      IN  VARCHAR2 DEFAULT FND_API.G_FALSE,
47                        p_commit		  IN  VARCHAR2 DEFAULT FND_API.G_FALSE,
48                        p_validation_level   IN  NUMBER   DEFAULT FND_API.G_VALID_LEVEL_FULL,
49                        x_return_status      OUT NOCOPY VARCHAR2	,
50                        x_msg_count          OUT NOCOPY NUMBER	,
51                        x_msg_data           OUT NOCOPY VARCHAR2	,
52 			     p_source_module	  IN	VARCHAR2	,
53                        p_del_id	   	  IN  Number 	) ;
54 
55    PROCEDURE Start_Workflow(
56 	  p_api_version         IN  NUMBER := 1.0,
57         p_init_msg_list       IN  VARCHAR2 DEFAULT FND_API.G_FALSE,
58         p_commit		      IN  VARCHAR2 DEFAULT FND_API.G_FALSE,
59         p_validation_level    IN  NUMBER   DEFAULT FND_API.G_VALID_LEVEL_FULL,
60         x_return_status       OUT NOCOPY VARCHAR2	,
61         x_msg_count           OUT NOCOPY NUMBER	,
62         x_msg_data            OUT NOCOPY VARCHAR2	,
63 	  p_user_id			IN  NUMBER		,
64 	  p_asset_info	      IN  VARCHAR2	,
65         p_asset_addl_info	IN  Varchar2 	,
66         p_delinquency_id      IN  Number    ) ;
67 
68   End IEX_DEL_SUB_PVT ;