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