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,
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,
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,
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,
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' ,
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,
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,
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,
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,
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',
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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);
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,
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,
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,
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,