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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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,
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,
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,
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,
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,
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
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,
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,
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,
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,
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,
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,
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