1 PACKAGE PA_CI_ACTIONS_PUB AUTHID CURRENT_USER AS
2 /* $Header: PACIACPS.pls 120.0 2005/06/03 13:30:35 appldev noship $ */
3
4 PROCEDURE CREATE_CI_ACTION (
5 p_api_version IN NUMBER := 1.0,
6 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
7 p_commit IN VARCHAR2 := FND_API.g_false,
8 p_validate_only IN VARCHAR2 := FND_API.g_true,
9 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
10 P_CI_ACTION_ID out NOCOPY NUMBER,
11 P_CI_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
12 P_TYPE_CODE in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
13 P_ASSIGNED_TO in NUMBER DEFAULT FND_API.G_MISS_NUM,
14 P_RESOURCE_TYPE_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
15 P_ASSIGNED_TO_NAME in VARCHAR DEFAULT FND_API.G_MISS_CHAR,
16 P_DATE_REQUIRED in DATE DEFAULT FND_API.G_MISS_DATE,
17 P_SIGN_OFF_REQUIRED_FLAG in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
18 P_COMMENT_TEXT in VARCHAR2,
19 P_SOURCE_CI_ACTION_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
20 P_CREATED_BY in NUMBER default fnd_global.user_id,
21 P_CREATION_DATE in DATE default sysdate,
22 P_LAST_UPDATED_BY in NUMBER default fnd_global.user_id,
23 P_LAST_UPDATE_DATE in DATE default sysdate,
24 P_LAST_UPDATE_LOGIN in NUMBER default fnd_global.user_id,
25 x_return_status OUT NOCOPY VARCHAR2,
26 x_msg_count OUT NOCOPY NUMBER,
27 x_msg_data OUT NOCOPY VARCHAR2
28 );
29 PROCEDURE CANCEL_CI_ACTION (
30 p_api_version IN NUMBER := 1.0,
31 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
32 p_commit IN VARCHAR2 := FND_API.g_false,
33 p_validate_only IN VARCHAR2 := FND_API.g_true,
34 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
35 P_CI_ACTION_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
36 P_RECORD_VERSION_NUMBER in NUMBER,
37 P_CANCEL_COMMENT in VARCHAR2,
38 P_LAST_UPDATED_BY in NUMBER default fnd_global.user_id,
39 P_LAST_UPDATE_DATE in DATE default sysdate,
40 P_LAST_UPDATE_LOGIN in NUMBER default fnd_global.user_id,
41 x_return_status OUT NOCOPY VARCHAR2,
42 x_msg_count OUT NOCOPY NUMBER,
43 x_msg_data OUT NOCOPY VARCHAR2);
44
45 PROCEDURE CLOSE_CI_ACTION (
46 p_api_version IN NUMBER := 1.0,
47 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
48 p_commit IN VARCHAR2 := FND_API.g_false,
49 p_validate_only IN VARCHAR2 := FND_API.g_true,
50 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
51 P_CI_ACTION_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
52 P_SIGN_OFF_FLAG in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
53 P_RECORD_VERSION_NUMBER in NUMBER DEFAULT FND_API.G_MISS_NUM,
54 P_COMMENT_TEXT in VARCHAR2,
55 P_LAST_UPDATED_BY in NUMBER default fnd_global.user_id,
56 P_LAST_UPDATE_DATE in DATE default sysdate,
57 P_LAST_UPDATE_LOGIN in NUMBER default fnd_global.user_id,
58 x_return_status OUT NOCOPY VARCHAR2,
59 x_msg_count OUT NOCOPY NUMBER,
60 x_msg_data OUT NOCOPY VARCHAR2
61 );
62
63 PROCEDURE REASSIGN_CI_ACTION (
64 p_api_version IN NUMBER := 1.0,
65 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
66 p_commit IN VARCHAR2 := FND_API.g_false,
67 p_validate_only IN VARCHAR2 := FND_API.g_true,
68 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
69 P_CI_ACTION_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
70 P_SIGN_OFF_FLAG in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
71 P_RECORD_VERSION_NUMBER in NUMBER DEFAULT FND_API.G_MISS_NUM,
72 P_RESOURCE_TYPE_ID in NUMBER DEFAULT FND_API.G_MISS_NUM,
73 P_ASSIGNED_TO in NUMBER DEFAULT FND_API.G_MISS_NUM,
74 P_ASSIGNED_TO_NAME in VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
75 P_DATE_REQUIRED in DATE DEFAULT FND_API.G_MISS_DATE,
76 P_COMMENT_TEXT in VARCHAR2,
77 P_CLOSURE_COMMENT in VARCHAR2,
78 P_CREATED_BY in NUMBER default fnd_global.user_id,
79 P_CREATION_DATE in DATE default sysdate,
80 P_LAST_UPDATED_BY in NUMBER default fnd_global.user_id,
81 P_LAST_UPDATE_DATE in DATE default sysdate,
82 P_LAST_UPDATE_LOGIN in NUMBER default fnd_global.user_id,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2
86 );
87
88 PROCEDURE ADD_CI_COMMENT(
89 p_api_version IN NUMBER := 1.0,
90 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
91 p_commit IN VARCHAR2 := FND_API.g_false,
92 p_validate_only IN VARCHAR2 := FND_API.g_true,
93 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
94 x_ci_comment_id out NOCOPY NUMBER,
95 p_ci_id IN NUMBER,
96 p_type_code IN VARCHAR2,
97 p_comment_text IN VARCHAR2,
98 p_ci_action_id IN NUMBER := null,
99 P_CREATED_BY in NUMBER default fnd_global.user_id,
100 P_CREATION_DATE in DATE default sysdate,
101 P_LAST_UPDATED_BY in NUMBER default fnd_global.user_id,
102 P_LAST_UPDATE_DATE in DATE default sysdate,
103 P_LAST_UPDATE_LOGIN in NUMBER default fnd_global.user_id,
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2);
107
108 PROCEDURE UPDATE_CI_COMMENT(
109 p_api_version IN NUMBER := 1.0,
110 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
111 p_commit IN VARCHAR2 := FND_API.g_false,
112 p_validate_only IN VARCHAR2 := FND_API.g_true,
113 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
114 p_ci_comment_id IN NUMBER,
115 p_comment_text IN VARCHAR2,
116 p_record_version_number IN NUMBER,
117 P_LAST_UPDATED_BY in NUMBER default fnd_global.user_id,
118 P_LAST_UPDATE_DATE in DATE default sysdate,
119 P_LAST_UPDATE_LOGIN in NUMBER default fnd_global.user_id,
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_msg_count OUT NOCOPY NUMBER,
122 x_msg_data OUT NOCOPY VARCHAR2);
123
124
125 END; -- Package Specification PA_CI_ACTIONS_PUB