[Home] [Help]
PACKAGE: APPS.PA_OBJECT_DIST_LISTS_PVT
Source
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,
10 P_OBJECT_TYPE in VARCHAR2,
11 P_OBJECT_ID in VARCHAR2,
12 P_RECORD_VERSION_NUMBER in NUMBER := 1,
13 P_CREATED_BY in NUMBER default fnd_global.user_id,
14 P_CREATION_DATE in DATE default sysdate,
15 P_LAST_UPDATED_BY in NUMBER default fnd_global.user_id,
16 P_LAST_UPDATE_DATE in DATE default sysdate,
17 P_LAST_UPDATE_LOGIN in NUMBER default fnd_global.user_id,
18 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
19 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
20 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
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,
30 P_OBJECT_TYPE in VARCHAR2,
31 P_OBJECT_ID in VARCHAR2,
32 P_RECORD_VERSION_NUMBER in NUMBER,
33 P_LAST_UPDATED_BY in NUMBER default fnd_global.user_id,
34 P_LAST_UPDATE_DATE in DATE default sysdate,
35 P_LAST_UPDATE_LOGIN in NUMBER default fnd_global.user_id,
36 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
37 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
38 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
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,
48 P_OBJECT_TYPE in VARCHAR2,
49 P_OBJECT_ID in VARCHAR2,
50 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
51 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
52 x_msg_data 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,
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
65 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
66 ) ;
67
68 END PA_OBJECT_DIST_LISTS_PVT;