1: PACKAGE PA_OBJECT_DIST_LISTS_PVT AUTHID CURRENT_USER AS
2: /* $Header: PATODLVS.pls 120.1 2005/08/19 17:04:41 mwasowic noship $ */
3: procedure CREATE_OBJECT_DIST_LIST (
4: p_api_version IN NUMBER := 1.0,
5: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
6: p_commit IN VARCHAR2 := FND_API.g_false,
7: p_validate_only IN VARCHAR2 := FND_API.g_true,
8: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
9: P_LIST_ID in NUMBER,
2: /* $Header: PATODLVS.pls 120.1 2005/08/19 17:04:41 mwasowic noship $ */
3: procedure CREATE_OBJECT_DIST_LIST (
4: p_api_version IN NUMBER := 1.0,
5: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
6: p_commit IN VARCHAR2 := FND_API.g_false,
7: p_validate_only IN VARCHAR2 := FND_API.g_true,
8: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
9: P_LIST_ID in NUMBER,
10: P_OBJECT_TYPE in VARCHAR2,
3: procedure CREATE_OBJECT_DIST_LIST (
4: p_api_version IN NUMBER := 1.0,
5: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
6: p_commit IN VARCHAR2 := FND_API.g_false,
7: p_validate_only IN VARCHAR2 := FND_API.g_true,
8: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
9: P_LIST_ID in NUMBER,
10: P_OBJECT_TYPE in VARCHAR2,
11: P_OBJECT_ID in VARCHAR2,
4: p_api_version IN NUMBER := 1.0,
5: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
6: p_commit IN VARCHAR2 := FND_API.g_false,
7: p_validate_only IN VARCHAR2 := FND_API.g_true,
8: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
9: P_LIST_ID in NUMBER,
10: P_OBJECT_TYPE in VARCHAR2,
11: P_OBJECT_ID in VARCHAR2,
12: P_RECORD_VERSION_NUMBER in NUMBER := 1,
21: ) ;
22:
23: procedure UPDATE_OBJECT_DIST_LIST (
24: p_api_version IN NUMBER := 1.0,
25: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
26: p_commit IN VARCHAR2 := FND_API.g_false,
27: p_validate_only IN VARCHAR2 := FND_API.g_true,
28: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
29: P_LIST_ID in NUMBER,
22:
23: procedure UPDATE_OBJECT_DIST_LIST (
24: p_api_version IN NUMBER := 1.0,
25: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
26: p_commit IN VARCHAR2 := FND_API.g_false,
27: p_validate_only IN VARCHAR2 := FND_API.g_true,
28: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
29: P_LIST_ID in NUMBER,
30: P_OBJECT_TYPE in VARCHAR2,
23: procedure UPDATE_OBJECT_DIST_LIST (
24: p_api_version IN NUMBER := 1.0,
25: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
26: p_commit IN VARCHAR2 := FND_API.g_false,
27: p_validate_only IN VARCHAR2 := FND_API.g_true,
28: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
29: P_LIST_ID in NUMBER,
30: P_OBJECT_TYPE in VARCHAR2,
31: P_OBJECT_ID in VARCHAR2,
24: p_api_version IN NUMBER := 1.0,
25: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
26: p_commit IN VARCHAR2 := FND_API.g_false,
27: p_validate_only IN VARCHAR2 := FND_API.g_true,
28: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
29: P_LIST_ID in NUMBER,
30: P_OBJECT_TYPE in VARCHAR2,
31: P_OBJECT_ID in VARCHAR2,
32: P_RECORD_VERSION_NUMBER in NUMBER,
39: ) ;
40:
41: procedure DELETE_OBJECT_DIST_LIST (
42: p_api_version IN NUMBER := 1.0,
43: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
44: p_commit IN VARCHAR2 := FND_API.g_false,
45: p_validate_only IN VARCHAR2 := FND_API.g_true,
46: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
47: P_LIST_ID in NUMBER,
40:
41: procedure DELETE_OBJECT_DIST_LIST (
42: p_api_version IN NUMBER := 1.0,
43: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
44: p_commit IN VARCHAR2 := FND_API.g_false,
45: p_validate_only IN VARCHAR2 := FND_API.g_true,
46: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
47: P_LIST_ID in NUMBER,
48: P_OBJECT_TYPE in VARCHAR2,
41: procedure DELETE_OBJECT_DIST_LIST (
42: p_api_version IN NUMBER := 1.0,
43: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
44: p_commit IN VARCHAR2 := FND_API.g_false,
45: p_validate_only IN VARCHAR2 := FND_API.g_true,
46: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
47: P_LIST_ID in NUMBER,
48: P_OBJECT_TYPE in VARCHAR2,
49: P_OBJECT_ID in VARCHAR2,
42: p_api_version IN NUMBER := 1.0,
43: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
44: p_commit IN VARCHAR2 := FND_API.g_false,
45: p_validate_only IN VARCHAR2 := FND_API.g_true,
46: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
47: P_LIST_ID in NUMBER,
48: P_OBJECT_TYPE in VARCHAR2,
49: P_OBJECT_ID in VARCHAR2,
50: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
53: ) ;
54:
55: procedure DELETE_ASSOC_DIST_LISTS (
56: p_api_version IN NUMBER := 1.0,
57: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
58: p_commit IN VARCHAR2 := FND_API.g_false,
59: p_validate_only IN VARCHAR2 := FND_API.g_true,
60: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
61: P_OBJECT_TYPE in VARCHAR2,
54:
55: procedure DELETE_ASSOC_DIST_LISTS (
56: p_api_version IN NUMBER := 1.0,
57: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
58: p_commit IN VARCHAR2 := FND_API.g_false,
59: p_validate_only IN VARCHAR2 := FND_API.g_true,
60: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
61: P_OBJECT_TYPE in VARCHAR2,
62: P_OBJECT_ID in VARCHAR2,
55: procedure DELETE_ASSOC_DIST_LISTS (
56: p_api_version IN NUMBER := 1.0,
57: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
58: p_commit IN VARCHAR2 := FND_API.g_false,
59: p_validate_only IN VARCHAR2 := FND_API.g_true,
60: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
61: P_OBJECT_TYPE in VARCHAR2,
62: P_OBJECT_ID in VARCHAR2,
63: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
56: p_api_version IN NUMBER := 1.0,
57: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
58: p_commit IN VARCHAR2 := FND_API.g_false,
59: p_validate_only IN VARCHAR2 := FND_API.g_true,
60: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
61: P_OBJECT_TYPE in VARCHAR2,
62: P_OBJECT_ID in VARCHAR2,
63: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
64: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895