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'
287:
288:
289:
290: PROCEDURE PostChangeCIStatus (
291: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
292: ,p_commit IN VARCHAR2 := FND_API.g_false
293: ,p_validate_only IN VARCHAR2 := FND_API.g_true
294: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
295: ,p_ci_id in number
288:
289:
290: PROCEDURE PostChangeCIStatus (
291: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
292: ,p_commit IN VARCHAR2 := FND_API.g_false
293: ,p_validate_only IN VARCHAR2 := FND_API.g_true
294: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
295: ,p_ci_id in number
296: ,p_curr_status in varchar2
289:
290: PROCEDURE PostChangeCIStatus (
291: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
292: ,p_commit IN VARCHAR2 := FND_API.g_false
293: ,p_validate_only IN VARCHAR2 := FND_API.g_true
294: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
295: ,p_ci_id in number
296: ,p_curr_status in varchar2
297: ,p_new_status in varchar2
290: PROCEDURE PostChangeCIStatus (
291: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
292: ,p_commit IN VARCHAR2 := FND_API.g_false
293: ,p_validate_only IN VARCHAR2 := FND_API.g_true
294: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
295: ,p_ci_id in number
296: ,p_curr_status in varchar2
297: ,p_new_status in varchar2
298: ,p_start_wf in VARCHAR2