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 ;