3:
4: PROCEDURE Create_Msite_Prty_Accss
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_party_id IN NUMBER,
4: PROCEDURE Create_Msite_Prty_Accss
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_party_id IN NUMBER,
12: p_start_date_active IN DATE,
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_party_id IN NUMBER,
12: p_start_date_active IN DATE,
13: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
9: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10: p_msite_id IN NUMBER,
11: p_party_id IN NUMBER,
12: p_start_date_active IN DATE,
13: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
14: x_msite_prty_accss_id OUT NUMBER,
15: x_return_status OUT VARCHAR2,
16: x_msg_count OUT NUMBER,
17: x_msg_data OUT VARCHAR2
19:
20: PROCEDURE Update_Msite_Prty_Accss
21: (
22: p_api_version IN NUMBER,
23: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
24: p_commit IN VARCHAR2 := FND_API.G_FALSE,
25: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
26: p_msite_prty_accss_id IN NUMBER := FND_API.G_MISS_NUM,
27: p_object_version_number IN NUMBER,
20: PROCEDURE Update_Msite_Prty_Accss
21: (
22: p_api_version IN NUMBER,
23: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
24: p_commit IN VARCHAR2 := FND_API.G_FALSE,
25: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
26: p_msite_prty_accss_id IN NUMBER := FND_API.G_MISS_NUM,
27: p_object_version_number IN NUMBER,
28: p_msite_id IN NUMBER := FND_API.G_MISS_NUM,
21: (
22: p_api_version IN NUMBER,
23: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
24: p_commit IN VARCHAR2 := FND_API.G_FALSE,
25: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
26: p_msite_prty_accss_id IN NUMBER := FND_API.G_MISS_NUM,
27: p_object_version_number IN NUMBER,
28: p_msite_id IN NUMBER := FND_API.G_MISS_NUM,
29: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
22: p_api_version IN NUMBER,
23: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
24: p_commit IN VARCHAR2 := FND_API.G_FALSE,
25: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
26: p_msite_prty_accss_id IN NUMBER := FND_API.G_MISS_NUM,
27: p_object_version_number IN NUMBER,
28: p_msite_id IN NUMBER := FND_API.G_MISS_NUM,
29: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
30: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
24: p_commit IN VARCHAR2 := FND_API.G_FALSE,
25: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
26: p_msite_prty_accss_id IN NUMBER := FND_API.G_MISS_NUM,
27: p_object_version_number IN NUMBER,
28: p_msite_id IN NUMBER := FND_API.G_MISS_NUM,
29: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
30: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
31: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
32: x_return_status OUT VARCHAR2,
25: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
26: p_msite_prty_accss_id IN NUMBER := FND_API.G_MISS_NUM,
27: p_object_version_number IN NUMBER,
28: p_msite_id IN NUMBER := FND_API.G_MISS_NUM,
29: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
30: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
31: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
32: x_return_status OUT VARCHAR2,
33: x_msg_count OUT NUMBER,
26: p_msite_prty_accss_id IN NUMBER := FND_API.G_MISS_NUM,
27: p_object_version_number IN NUMBER,
28: p_msite_id IN NUMBER := FND_API.G_MISS_NUM,
29: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
30: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
31: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
32: x_return_status OUT VARCHAR2,
33: x_msg_count OUT NUMBER,
34: x_msg_data OUT VARCHAR2
27: p_object_version_number IN NUMBER,
28: p_msite_id IN NUMBER := FND_API.G_MISS_NUM,
29: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
30: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
31: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
32: x_return_status OUT VARCHAR2,
33: x_msg_count OUT NUMBER,
34: x_msg_data OUT VARCHAR2
35: );
36:
37: PROCEDURE Delete_Msite_Prty_Accss
38: (
39: p_api_version IN NUMBER,
40: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
41: p_commit IN VARCHAR2 := FND_API.G_FALSE,
42: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
43: p_msite_prty_accss_id IN NUMBER := FND_API.G_MISS_NUM,
44: p_msite_id IN NUMBER := FND_API.G_MISS_NUM,
37: PROCEDURE Delete_Msite_Prty_Accss
38: (
39: p_api_version IN NUMBER,
40: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
41: p_commit IN VARCHAR2 := FND_API.G_FALSE,
42: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
43: p_msite_prty_accss_id IN NUMBER := FND_API.G_MISS_NUM,
44: p_msite_id IN NUMBER := FND_API.G_MISS_NUM,
45: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
38: (
39: p_api_version IN NUMBER,
40: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
41: p_commit IN VARCHAR2 := FND_API.G_FALSE,
42: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
43: p_msite_prty_accss_id IN NUMBER := FND_API.G_MISS_NUM,
44: p_msite_id IN NUMBER := FND_API.G_MISS_NUM,
45: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
46: x_return_status OUT VARCHAR2,
39: p_api_version IN NUMBER,
40: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
41: p_commit IN VARCHAR2 := FND_API.G_FALSE,
42: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
43: p_msite_prty_accss_id IN NUMBER := FND_API.G_MISS_NUM,
44: p_msite_id IN NUMBER := FND_API.G_MISS_NUM,
45: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
46: x_return_status OUT VARCHAR2,
47: x_msg_count OUT NUMBER,
40: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
41: p_commit IN VARCHAR2 := FND_API.G_FALSE,
42: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
43: p_msite_prty_accss_id IN NUMBER := FND_API.G_MISS_NUM,
44: p_msite_id IN NUMBER := FND_API.G_MISS_NUM,
45: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
46: x_return_status OUT VARCHAR2,
47: x_msg_count OUT NUMBER,
48: x_msg_data OUT VARCHAR2
41: p_commit IN VARCHAR2 := FND_API.G_FALSE,
42: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
43: p_msite_prty_accss_id IN NUMBER := FND_API.G_MISS_NUM,
44: p_msite_id IN NUMBER := FND_API.G_MISS_NUM,
45: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
46: x_return_status OUT VARCHAR2,
47: x_msg_count OUT NUMBER,
48: x_msg_data OUT VARCHAR2
49: );