1 package PA_CI_ACTIONS_PVT AUTHID CURRENT_USER as
2 /* $Header: PACIACVS.pls 120.0 2005/06/03 13:52:45 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,
12 P_TYPE_CODE in VARCHAR2,
13 P_ASSIGNED_TO in NUMBER,
14 P_DATE_REQUIRED in DATE,
15 P_SIGN_OFF_REQUIRED_FLAG in VARCHAR2,
16 P_COMMENT_TEXT in VARCHAR2,
17 P_SOURCE_CI_ACTION_ID in NUMBER default NULL,
18 P_CREATED_BY in NUMBER default fnd_global.user_id,
19 P_CREATION_DATE in DATE default sysdate,
20 P_LAST_UPDATED_BY in NUMBER default fnd_global.user_id,
21 P_LAST_UPDATE_DATE in DATE default sysdate,
22 P_LAST_UPDATE_LOGIN in NUMBER default fnd_global.user_id,
23 x_return_status OUT NOCOPY VARCHAR2,
24 x_msg_count OUT NOCOPY NUMBER,
25 x_msg_data OUT NOCOPY VARCHAR2
26 );
27
28 PROCEDURE CLOSE_CI_ACTION
29 ( p_api_version IN NUMBER := 1.0,
30 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
31 p_commit IN VARCHAR2 := FND_API.g_false,
32 p_validate_only IN VARCHAR2 := FND_API.g_true,
33 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
34 P_calling_context IN VARCHAR2 default 'CLOSE' ,
35 P_CI_ACTION_ID in NUMBER,
36 P_SIGN_OFF_FLAG in VARCHAR2,
37 P_RECORD_VERSION_NUMBER in NUMBER,
38 P_COMMENT_TEXT in VARCHAR2,
39 P_LAST_UPDATED_BY in NUMBER default fnd_global.user_id,
40 P_LAST_UPDATE_DATE in DATE default sysdate,
41 P_LAST_UPDATE_LOGIN in NUMBER default fnd_global.user_id,
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_msg_count OUT NOCOPY NUMBER,
44 x_msg_data OUT NOCOPY VARCHAR2
45 );
46
47 PROCEDURE REASSIGN_CI_ACTION (
48 p_api_version IN NUMBER := 1.0,
49 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
50 p_commit IN VARCHAR2 := FND_API.g_false,
51 p_validate_only IN VARCHAR2 := FND_API.g_true,
52 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
53 P_CI_ACTION_ID in NUMBER,
54 P_SIGN_OFF_FLAG in VARCHAR2 := 'N',
55 P_RECORD_VERSION_NUMBER in NUMBER,
56 P_ASSIGNED_TO in NUMBER,
57 P_DATE_REQUIRED in DATE,
58 P_COMMENT_TEXT in VARCHAR2,
59 P_CLOSURE_COMMENT in VARCHAR2,
60 P_CREATED_BY in NUMBER default fnd_global.user_id,
61 P_CREATION_DATE in DATE default sysdate,
62 P_LAST_UPDATED_BY in NUMBER default fnd_global.user_id,
63 P_LAST_UPDATE_DATE in DATE default sysdate,
64 P_LAST_UPDATE_LOGIN in NUMBER default fnd_global.user_id,
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2
68 );
69
70
71 PROCEDURE ADD_CI_COMMENT(
72 p_api_version IN NUMBER := 1.0,
73 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
74 p_commit IN VARCHAR2 := FND_API.g_false,
75 p_validate_only IN VARCHAR2 := FND_API.g_true,
76 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
77 p_ci_comment_id out NOCOPY NUMBER,
78 p_ci_id IN NUMBER,
79 p_type_code IN VARCHAR2,
80 p_comment_text IN VARCHAR2,
81 p_ci_action_id IN NUMBER,
82 P_CREATED_BY in NUMBER default fnd_global.user_id,
83 P_CREATION_DATE in DATE default sysdate,
84 P_LAST_UPDATED_BY in NUMBER default fnd_global.user_id,
85 P_LAST_UPDATE_DATE in DATE default sysdate,
86 P_LAST_UPDATE_LOGIN in NUMBER default fnd_global.user_id,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2);
90
91 PROCEDURE UPDATE_CI_COMMENT(
92 p_api_version IN NUMBER := 1.0,
93 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
94 p_commit IN VARCHAR2 := FND_API.g_false,
95 p_validate_only IN VARCHAR2 := FND_API.g_true,
96 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
97 p_ci_comment_id IN NUMBER,
98 p_comment_text IN VARCHAR2,
99 p_record_version_number IN NUMBER,
100 P_LAST_UPDATED_BY in NUMBER default fnd_global.user_id,
101 P_LAST_UPDATE_DATE in DATE default sysdate,
102 P_LAST_UPDATE_LOGIN in NUMBER default fnd_global.user_id,
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2);
106
107 PROCEDURE CANCEL_CI_ACTION (
108 p_api_version IN NUMBER := 1.0,
109 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
110 p_commit IN VARCHAR2 := FND_API.g_false,
111 p_validate_only IN VARCHAR2 := FND_API.g_true,
112 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
113 P_CI_ACTION_ID in NUMBER,
114 P_RECORD_VERSION_NUMBER in NUMBER,
115 P_CANCEL_COMMENT in VARCHAR2,
116 P_LAST_UPDATED_BY in NUMBER default fnd_global.user_id,
117 P_LAST_UPDATE_DATE in DATE default sysdate,
118 P_LAST_UPDATE_LOGIN in NUMBER default fnd_global.user_id,
119 x_return_status OUT NOCOPY VARCHAR2,
120 x_msg_count OUT NOCOPY NUMBER,
121 x_msg_data OUT NOCOPY VARCHAR2
122 );
123
124 PROCEDURE DELETE_ALL_ACTIONS(
125 p_api_version IN NUMBER := 1.0,
126 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
127 p_commit IN VARCHAR2 := FND_API.g_false,
128 p_validate_only IN VARCHAR2 := FND_API.g_true,
129 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
130 p_ci_id IN NUMBER,
131 x_return_status OUT NOCOPY VARCHAR2,
132 x_msg_count OUT NOCOPY NUMBER,
133 x_msg_data OUT NOCOPY VARCHAR2);
134
135 PROCEDURE CANCEL_ALL_ACTIONS(
136 p_api_version IN NUMBER := 1.0,
137 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
138 p_commit IN VARCHAR2 := FND_API.g_false,
139 p_validate_only IN VARCHAR2 := FND_API.g_true,
140 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
141 p_ci_id IN NUMBER,
142 p_cancel_comment IN VARCHAR2 := NULL,
143 P_CREATED_BY in NUMBER default fnd_global.user_id,
144 P_CREATION_DATE in DATE default sysdate,
145 P_LAST_UPDATED_BY in NUMBER default fnd_global.user_id,
146 P_LAST_UPDATE_DATE in DATE default sysdate,
147 P_LAST_UPDATE_LOGIN in NUMBER default fnd_global.user_id,
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_msg_count OUT NOCOPY NUMBER,
150 x_msg_data OUT NOCOPY VARCHAR2);
151
152 END PA_CI_ACTIONS_PVT; -- Package Specification PA_CI_ACTIONS_PVT
153
[Home] [Help]