[Home] [Help]
PACKAGE: APPS.OKC_CONTRACT_APPROVAL_PUB
Source
1 package OKC_CONTRACT_APPROVAL_PUB AUTHID CURRENT_USER as
2 /* $Header: OKCPCAPS.pls 120.2 2005/12/05 18:13:18 skkoppul noship $ */
3
4 -- public procedure declarations
5 -- code for start/stop and monitor buttons in the form
6 procedure k_approval_start(
7 p_api_version IN NUMBER,
8 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
9 x_return_status OUT NOCOPY VARCHAR2,
10 x_msg_count OUT NOCOPY NUMBER,
11 x_msg_data OUT NOCOPY VARCHAR2,
12 p_contract_id IN number,
13 p_process_id IN number,
14 p_do_commit IN VARCHAR2 default OKC_API.G_TRUE,
15 p_access_level IN VARCHAR2 default 'N',
16 p_user_id IN NUMBER default null,
17 p_resp_id IN NUMBER default null,
18 p_resp_appl_id IN NUMBER default null,
19 p_security_group_id IN NUMBER default null
20 );
21 function wf_monitor_url(
22 p_contract_id IN number,
23 p_process_id IN number,
24 p_mode IN varchar2 default 'USER'
25 ) return varchar2;
26 procedure k_approval_stop(
27 p_api_version IN NUMBER,
28 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
29 x_return_status OUT NOCOPY VARCHAR2,
30 x_msg_count OUT NOCOPY NUMBER,
31 x_msg_data OUT NOCOPY VARCHAR2,
32 p_contract_id number,
33 p_do_commit IN VARCHAR2 default OKC_API.G_TRUE
34 );
35
36 -- public utilities declarations
37 -- for use by Contract Approval Process Developers
38 procedure wf_copy_env( p_item_type varchar2,
39 p_item_key varchar2);
40 function k_accesible(
41 p_contract_id IN number,
42 p_user_id IN number,
43 p_level IN varchar2 default 'R'
44 ) return varchar2;
45 procedure k_approved(
46 p_contract_id IN number,
47 p_date_approved IN date default sysdate,
48 x_return_status OUT NOCOPY VARCHAR2
49 );
50 procedure k_erase_approved(
51 p_contract_id IN number,
52 x_return_status OUT NOCOPY VARCHAR2
53 );
54 procedure k_signed(
55 p_contract_id IN number,
56 p_date_signed IN date default sysdate,
57 p_complete_k_prcs IN VARCHAR2 default 'Y',
58 x_return_status OUT NOCOPY VARCHAR2
59 );
60 procedure activate_template(
61 p_contract_id IN number,
62 x_return_status OUT NOCOPY VARCHAR2 );
63 end OKC_CONTRACT_APPROVAL_PUB;