1 PACKAGE Ibe_Msite_Resp_Pvt AUTHID CURRENT_USER AS
2 /* $Header: IBEVMRSS.pls 115.3 2003/09/02 21:35:54 jqu ship $ */
3
4 -- HISTORY
5 -- 12/13/02 SCHAK Modified for NOCOPY (Bug # 2691704) Changes.
6 -- 07/28/03 JQU
7 -- Modified procedures for addition of group_code column
8 -- *********************************************************************************
9
10 PROCEDURE Create_Msite_Resp
11 (
12 p_api_version IN NUMBER,
13 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14 p_commit IN VARCHAR2 := FND_API.G_FALSE,
15 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
16 p_msite_resp_id IN NUMBER := FND_API.G_MISS_NUM,
17 p_msite_id IN NUMBER,
18 p_responsibility_id IN NUMBER,
19 p_application_id IN NUMBER,
20 p_start_date_active IN DATE,
21 p_end_date_active IN DATE := FND_API.G_MISS_DATE,
22 p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
23 p_display_name IN VARCHAR2,
24 p_group_code IN VARCHAR2 default null,
25 x_msite_resp_id OUT NOCOPY NUMBER,
26 x_return_status OUT NOCOPY VARCHAR2,
27 x_msg_count OUT NOCOPY NUMBER,
28 x_msg_data OUT NOCOPY VARCHAR2
29 );
30
31 PROCEDURE Update_Msite_Resp
32 (
33 p_api_version IN NUMBER,
34 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
35 p_commit IN VARCHAR2 := FND_API.G_FALSE,
36 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
37 p_msite_resp_id IN NUMBER := FND_API.G_MISS_NUM,
38 p_object_version_number IN NUMBER,
39 p_msite_id IN NUMBER := FND_API.G_MISS_NUM,
40 p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
41 p_application_id IN NUMBER := FND_API.G_MISS_NUM,
42 p_start_date_active IN DATE := FND_API.G_MISS_DATE,
43 p_end_date_active IN DATE := FND_API.G_MISS_DATE,
44 p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
45 p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
46 p_group_code IN VARCHAR2 default null,
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_msg_count OUT NOCOPY NUMBER,
49 x_msg_data OUT NOCOPY VARCHAR2
50 );
51
52 PROCEDURE Delete_Msite_Resp
53 (
54 p_api_version IN NUMBER,
55 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
56 p_commit IN VARCHAR2 := FND_API.G_FALSE,
57 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
58 p_msite_resp_id IN NUMBER := FND_API.G_MISS_NUM,
59 p_msite_id IN NUMBER := FND_API.G_MISS_NUM,
60 p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
61 p_application_id IN NUMBER := FND_API.G_MISS_NUM,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2
65 );
66
67 PROCEDURE Delete_Msite_Resp_Group
68 (
69 p_api_version IN NUMBER,
70 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
71 p_commit IN VARCHAR2 := FND_API.G_FALSE,
72 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
73 p_msite_resp_id IN NUMBER := FND_API.G_MISS_NUM,
74 p_msite_id IN NUMBER := FND_API.G_MISS_NUM,
75 p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
76 p_application_id IN NUMBER := FND_API.G_MISS_NUM,
77 p_group_code IN VARCHAR2 default null,
78 x_return_status OUT NOCOPY VARCHAR2,
79 x_msg_count OUT NOCOPY NUMBER,
80 x_msg_data OUT NOCOPY VARCHAR2
81 );
82
83
84 END Ibe_Msite_Resp_Pvt;