1 PACKAGE Jtf_Msite_Resp_Pvt AUTHID CURRENT_USER AS
2 /* $Header: JTFVMRSS.pls 115.2 2002/02/14 05:49:41 appldev ship $ */
3
4 PROCEDURE Create_Msite_Resp
5 (
6 p_api_version IN NUMBER,
7 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8 p_commit IN VARCHAR2 := FND_API.G_FALSE,
9 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10 p_msite_id IN NUMBER,
11 p_responsibility_id IN NUMBER,
12 p_application_id IN NUMBER,
13 p_start_date_active IN DATE,
14 p_end_date_active IN DATE := FND_API.G_MISS_DATE,
15 p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
16 p_display_name IN VARCHAR2,
17 x_msite_resp_id OUT NUMBER,
18 x_return_status OUT VARCHAR2,
19 x_msg_count OUT NUMBER,
20 x_msg_data OUT VARCHAR2
21 );
22
23 PROCEDURE Update_Msite_Resp
24 (
25 p_api_version IN NUMBER,
26 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
27 p_commit IN VARCHAR2 := FND_API.G_FALSE,
28 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
29 p_msite_resp_id IN NUMBER := FND_API.G_MISS_NUM,
30 p_object_version_number IN NUMBER,
31 p_msite_id IN NUMBER := FND_API.G_MISS_NUM,
32 p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
33 p_application_id IN NUMBER := FND_API.G_MISS_NUM,
34 p_start_date_active IN DATE := FND_API.G_MISS_DATE,
35 p_end_date_active IN DATE := FND_API.G_MISS_DATE,
36 p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
37 p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
38 x_return_status OUT VARCHAR2,
39 x_msg_count OUT NUMBER,
40 x_msg_data OUT VARCHAR2
41 );
42
43 PROCEDURE Delete_Msite_Resp
44 (
45 p_api_version IN NUMBER,
46 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
47 p_commit IN VARCHAR2 := FND_API.G_FALSE,
48 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
49 p_msite_resp_id IN NUMBER := FND_API.G_MISS_NUM,
50 p_msite_id IN NUMBER := FND_API.G_MISS_NUM,
51 p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
52 p_application_id IN NUMBER := FND_API.G_MISS_NUM,
53 x_return_status OUT VARCHAR2,
54 x_msg_count OUT NUMBER,
55 x_msg_data OUT VARCHAR2
56 );
57
58 END Jtf_Msite_Resp_Pvt;