2: /* $Header: OKCRCHKS.pls 120.0 2005/05/26 09:28:40 appldev noship $ */
3:
4: procedure change_approval_start(
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
7: x_return_status OUT NOCOPY VARCHAR2,
8: x_msg_count OUT NOCOPY NUMBER,
9: x_msg_data OUT NOCOPY VARCHAR2,
10: p_change_request_id IN number,
7: x_return_status OUT NOCOPY VARCHAR2,
8: x_msg_count OUT NOCOPY NUMBER,
9: x_msg_data OUT NOCOPY VARCHAR2,
10: p_change_request_id IN number,
11: p_do_commit IN VARCHAR2 default OKC_API.G_TRUE
12: );
13: function wf_monitor_url(
14: p_change_request_id IN number,
15: p_process_id IN number,
16: p_mode IN varchar2 default 'USER'
17: ) return varchar2;
18: procedure change_approval_stop(
19: p_api_version IN NUMBER,
20: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
21: x_return_status OUT NOCOPY VARCHAR2,
22: x_msg_count OUT NOCOPY NUMBER,
23: x_msg_data OUT NOCOPY VARCHAR2,
24: p_change_request_id IN number,
21: x_return_status OUT NOCOPY VARCHAR2,
22: x_msg_count OUT NOCOPY NUMBER,
23: x_msg_data OUT NOCOPY VARCHAR2,
24: p_change_request_id IN number,
25: p_do_commit IN VARCHAR2 default OKC_API.G_TRUE
26: );
27: procedure change_get_key(
28: p_api_version IN NUMBER,
29: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
25: p_do_commit IN VARCHAR2 default OKC_API.G_TRUE
26: );
27: procedure change_get_key(
28: p_api_version IN NUMBER,
29: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
30: x_return_status OUT NOCOPY VARCHAR2,
31: x_msg_count OUT NOCOPY NUMBER,
32: x_msg_data OUT NOCOPY VARCHAR2,
33: p_change_request_id IN number,
30: x_return_status OUT NOCOPY VARCHAR2,
31: x_msg_count OUT NOCOPY NUMBER,
32: x_msg_data OUT NOCOPY VARCHAR2,
33: p_change_request_id IN number,
34: p_do_commit IN VARCHAR2 default OKC_API.G_TRUE
35: );
36: procedure change_put_key(
37: p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
34: p_do_commit IN VARCHAR2 default OKC_API.G_TRUE
35: );
36: procedure change_put_key(
37: p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
39: x_return_status OUT NOCOPY VARCHAR2,
40: x_msg_count OUT NOCOPY NUMBER,
41: x_msg_data OUT NOCOPY VARCHAR2,
42: p_change_request_id IN number,
41: x_msg_data OUT NOCOPY VARCHAR2,
42: p_change_request_id IN number,
43: p_datetime_applied IN date default sysdate,
44: p_k_version IN VARCHAR2,
45: p_do_commit IN VARCHAR2 default OKC_API.G_TRUE
46: );
47: -- for wf development
48: procedure change_request_approved(
49: p_change_request_id IN number,