87:
88: PROCEDURE checkandstartworkflow
89: (
90: p_api_version IN NUMBER := 1.0,
91: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
92: p_commit IN VARCHAR2 := FND_API.g_false,
93: p_validate_only IN VARCHAR2 := FND_API.g_true,
94: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
95:
88: PROCEDURE checkandstartworkflow
89: (
90: p_api_version IN NUMBER := 1.0,
91: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
92: p_commit IN VARCHAR2 := FND_API.g_false,
93: p_validate_only IN VARCHAR2 := FND_API.g_true,
94: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
95:
96: p_ci_id in NUMBER,
89: (
90: p_api_version IN NUMBER := 1.0,
91: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
92: p_commit IN VARCHAR2 := FND_API.g_false,
93: p_validate_only IN VARCHAR2 := FND_API.g_true,
94: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
95:
96: p_ci_id in NUMBER,
97: p_status_code IN VARCHAR2,
90: p_api_version IN NUMBER := 1.0,
91: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
92: p_commit IN VARCHAR2 := FND_API.g_false,
93: p_validate_only IN VARCHAR2 := FND_API.g_true,
94: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
95:
96: p_ci_id in NUMBER,
97: p_status_code IN VARCHAR2,
98:
148: ,p_system_status IN VARCHAR2 := NULL)
149: return VARCHAR2;
150:
151: PROCEDURE ChangeCIStatus (
152: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
153: ,p_commit IN VARCHAR2 := FND_API.g_false
154: ,p_validate_only IN VARCHAR2 := FND_API.g_true
155: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
156: ,p_ci_id in number
149: return VARCHAR2;
150:
151: PROCEDURE ChangeCIStatus (
152: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
153: ,p_commit IN VARCHAR2 := FND_API.g_false
154: ,p_validate_only IN VARCHAR2 := FND_API.g_true
155: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
156: ,p_ci_id in number
157: ,p_status in varchar2
150:
151: PROCEDURE ChangeCIStatus (
152: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
153: ,p_commit IN VARCHAR2 := FND_API.g_false
154: ,p_validate_only IN VARCHAR2 := FND_API.g_true
155: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
156: ,p_ci_id in number
157: ,p_status in varchar2
158: ,p_comment in VARCHAR2 := null
151: PROCEDURE ChangeCIStatus (
152: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
153: ,p_commit IN VARCHAR2 := FND_API.g_false
154: ,p_validate_only IN VARCHAR2 := FND_API.g_true
155: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
156: ,p_ci_id in number
157: ,p_status in varchar2
158: ,p_comment in VARCHAR2 := null
159: ,p_enforce_security in Varchar2 DEFAULT 'Y'
166:
167: PROCEDURE CancelWorkflow
168: (
169: p_api_version IN NUMBER := 1.0,
170: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
171: p_commit IN VARCHAR2 := FND_API.g_false,
172: p_validate_only IN VARCHAR2 := FND_API.g_true,
173: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
174:
167: PROCEDURE CancelWorkflow
168: (
169: p_api_version IN NUMBER := 1.0,
170: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
171: p_commit IN VARCHAR2 := FND_API.g_false,
172: p_validate_only IN VARCHAR2 := FND_API.g_true,
173: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
174:
175: p_ci_id in NUMBER,
168: (
169: p_api_version IN NUMBER := 1.0,
170: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
171: p_commit IN VARCHAR2 := FND_API.g_false,
172: p_validate_only IN VARCHAR2 := FND_API.g_true,
173: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
174:
175: p_ci_id in NUMBER,
176:
169: p_api_version IN NUMBER := 1.0,
170: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
171: p_commit IN VARCHAR2 := FND_API.g_false,
172: p_validate_only IN VARCHAR2 := FND_API.g_true,
173: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
174:
175: p_ci_id in NUMBER,
176:
177: x_msg_count out NOCOPY NUMBER,
267: ,x_msg_count OUT NOCOPY NUMBER
268: ,x_msg_data OUT NOCOPY VARCHAR2 );
269:
270: PROCEDURE ChangeCIStatusValidate (
271: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
272: ,p_commit IN VARCHAR2 := FND_API.g_false
273: ,p_validate_only IN VARCHAR2 := FND_API.g_true
274: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
275: ,p_ci_id IN NUMBER
268: ,x_msg_data OUT NOCOPY VARCHAR2 );
269:
270: PROCEDURE ChangeCIStatusValidate (
271: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
272: ,p_commit IN VARCHAR2 := FND_API.g_false
273: ,p_validate_only IN VARCHAR2 := FND_API.g_true
274: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
275: ,p_ci_id IN NUMBER
276: ,p_status IN VARCHAR2
269:
270: PROCEDURE ChangeCIStatusValidate (
271: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
272: ,p_commit IN VARCHAR2 := FND_API.g_false
273: ,p_validate_only IN VARCHAR2 := FND_API.g_true
274: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
275: ,p_ci_id IN NUMBER
276: ,p_status IN VARCHAR2
277: ,p_enforce_security IN VARCHAR2 DEFAULT 'Y'
270: PROCEDURE ChangeCIStatusValidate (
271: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
272: ,p_commit IN VARCHAR2 := FND_API.g_false
273: ,p_validate_only IN VARCHAR2 := FND_API.g_true
274: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
275: ,p_ci_id IN NUMBER
276: ,p_status IN VARCHAR2
277: ,p_enforce_security IN VARCHAR2 DEFAULT 'Y'
278: ,p_resolution_check IN VARCHAR2 DEFAULT 'UI'
286: ,x_msg_data OUT NOCOPY VARCHAR2 );
287:
288:
289: PROCEDURE PostChangeCIStatus (
290: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
291: ,p_commit IN VARCHAR2 := FND_API.g_false
292: ,p_validate_only IN VARCHAR2 := FND_API.g_true
293: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
294: ,p_ci_id in number
287:
288:
289: PROCEDURE PostChangeCIStatus (
290: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
291: ,p_commit IN VARCHAR2 := FND_API.g_false
292: ,p_validate_only IN VARCHAR2 := FND_API.g_true
293: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
294: ,p_ci_id in number
295: ,p_curr_status in varchar2
288:
289: PROCEDURE PostChangeCIStatus (
290: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
291: ,p_commit IN VARCHAR2 := FND_API.g_false
292: ,p_validate_only IN VARCHAR2 := FND_API.g_true
293: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
294: ,p_ci_id in number
295: ,p_curr_status in varchar2
296: ,p_new_status in varchar2
289: PROCEDURE PostChangeCIStatus (
290: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
291: ,p_commit IN VARCHAR2 := FND_API.g_false
292: ,p_validate_only IN VARCHAR2 := FND_API.g_true
293: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
294: ,p_ci_id in number
295: ,p_curr_status in varchar2
296: ,p_new_status in varchar2
297: ,p_start_wf in VARCHAR2
302: ,x_msg_data OUT NOCOPY VARCHAR2 );
303:
304: -- Bug#13683760 changes start.
305: PROCEDURE ChangeCIStatusWorking (
306: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
307: ,p_commit IN VARCHAR2 := FND_API.g_false
308: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
309: ,p_validate_only IN VARCHAR2 := FND_API.g_true
310: ,p_ci_id in number
303:
304: -- Bug#13683760 changes start.
305: PROCEDURE ChangeCIStatusWorking (
306: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
307: ,p_commit IN VARCHAR2 := FND_API.g_false
308: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
309: ,p_validate_only IN VARCHAR2 := FND_API.g_true
310: ,p_ci_id in number
311: ,p_status in varchar2
304: -- Bug#13683760 changes start.
305: PROCEDURE ChangeCIStatusWorking (
306: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
307: ,p_commit IN VARCHAR2 := FND_API.g_false
308: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
309: ,p_validate_only IN VARCHAR2 := FND_API.g_true
310: ,p_ci_id in number
311: ,p_status in varchar2
312: ,p_record_version_number IN NUMBER
305: PROCEDURE ChangeCIStatusWorking (
306: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
307: ,p_commit IN VARCHAR2 := FND_API.g_false
308: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
309: ,p_validate_only IN VARCHAR2 := FND_API.g_true
310: ,p_ci_id in number
311: ,p_status in varchar2
312: ,p_record_version_number IN NUMBER
313: ,x_return_status OUT NOCOPY VARCHAR2