8:
9: PROCEDURE Associate_Resps_To_MSite
10: (
11: p_api_version IN NUMBER,
12: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
13: p_commit IN VARCHAR2 := FND_API.G_FALSE,
14: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
15: p_msite_id IN NUMBER,
16: p_responsibility_ids IN JTF_NUMBER_TABLE,
9: PROCEDURE Associate_Resps_To_MSite
10: (
11: p_api_version IN NUMBER,
12: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
13: p_commit IN VARCHAR2 := FND_API.G_FALSE,
14: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
15: p_msite_id IN NUMBER,
16: p_responsibility_ids IN JTF_NUMBER_TABLE,
17: p_application_ids IN JTF_NUMBER_TABLE,
10: (
11: p_api_version IN NUMBER,
12: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
13: p_commit IN VARCHAR2 := FND_API.G_FALSE,
14: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
15: p_msite_id IN NUMBER,
16: p_responsibility_ids IN JTF_NUMBER_TABLE,
17: p_application_ids IN JTF_NUMBER_TABLE,
18: p_start_date_actives IN JTF_DATE_TABLE,
30:
31: PROCEDURE Update_Delete_Msite_Resps
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_ids IN JTF_NUMBER_TABLE,
38: p_object_version_numbers IN JTF_NUMBER_TABLE,
31: PROCEDURE Update_Delete_Msite_Resps
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_ids IN JTF_NUMBER_TABLE,
38: p_object_version_numbers IN JTF_NUMBER_TABLE,
39: p_start_date_actives IN JTF_DATE_TABLE,
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_ids IN JTF_NUMBER_TABLE,
38: p_object_version_numbers IN JTF_NUMBER_TABLE,
39: p_start_date_actives IN JTF_DATE_TABLE,
40: p_end_date_actives IN JTF_DATE_TABLE,
48:
49: PROCEDURE Update_Delete_Msite_Resps
50: (
51: p_api_version IN NUMBER,
52: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
53: p_commit IN VARCHAR2 := FND_API.G_FALSE,
54: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
55: p_msite_resp_ids IN JTF_NUMBER_TABLE,
56: p_msite_ids IN JTF_NUMBER_TABLE,
49: PROCEDURE Update_Delete_Msite_Resps
50: (
51: p_api_version IN NUMBER,
52: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
53: p_commit IN VARCHAR2 := FND_API.G_FALSE,
54: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
55: p_msite_resp_ids IN JTF_NUMBER_TABLE,
56: p_msite_ids IN JTF_NUMBER_TABLE,
57: p_responsibility_ids IN JTF_NUMBER_TABLE,
50: (
51: p_api_version IN NUMBER,
52: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
53: p_commit IN VARCHAR2 := FND_API.G_FALSE,
54: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
55: p_msite_resp_ids IN JTF_NUMBER_TABLE,
56: p_msite_ids IN JTF_NUMBER_TABLE,
57: p_responsibility_ids IN JTF_NUMBER_TABLE,
58: p_application_ids IN JTF_NUMBER_TABLE,
70:
71: PROCEDURE Load_MsiteResps_For_Msite
72: (
73: p_api_version IN NUMBER,
74: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
75: p_commit IN VARCHAR2 := FND_API.G_FALSE,
76: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
77: p_msite_id IN NUMBER,
78: p_application_id IN NUMBER,
71: PROCEDURE Load_MsiteResps_For_Msite
72: (
73: p_api_version IN NUMBER,
74: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
75: p_commit IN VARCHAR2 := FND_API.G_FALSE,
76: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
77: p_msite_id IN NUMBER,
78: p_application_id IN NUMBER,
79: x_msite_csr OUT NOCOPY MSITE_CSR,
72: (
73: p_api_version IN NUMBER,
74: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
75: p_commit IN VARCHAR2 := FND_API.G_FALSE,
76: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
77: p_msite_id IN NUMBER,
78: p_application_id IN NUMBER,
79: x_msite_csr OUT NOCOPY MSITE_CSR,
80: x_msite_resp_csr OUT NOCOPY MSITE_RESP_CSR,
85:
86: PROCEDURE Update_Msite_Resps
87: (
88: p_api_version IN NUMBER,
89: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
90: p_commit IN VARCHAR2 := FND_API.G_FALSE,
91: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92: p_msite_resp_ids IN JTF_NUMBER_TABLE,
93: p_object_version_numbers IN JTF_NUMBER_TABLE,
86: PROCEDURE Update_Msite_Resps
87: (
88: p_api_version IN NUMBER,
89: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
90: p_commit IN VARCHAR2 := FND_API.G_FALSE,
91: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92: p_msite_resp_ids IN JTF_NUMBER_TABLE,
93: p_object_version_numbers IN JTF_NUMBER_TABLE,
94: p_sort_orders IN JTF_NUMBER_TABLE,
87: (
88: p_api_version IN NUMBER,
89: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
90: p_commit IN VARCHAR2 := FND_API.G_FALSE,
91: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92: p_msite_resp_ids IN JTF_NUMBER_TABLE,
93: p_object_version_numbers IN JTF_NUMBER_TABLE,
94: p_sort_orders IN JTF_NUMBER_TABLE,
95: x_return_status OUT NOCOPY VARCHAR2,