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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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,
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,
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,
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,
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,
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
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: );