DBA Data[Home] [Help]

PACKAGE: APPS.OKC_CONTRACT_APPROVAL_PVT

Source


1 package OKC_CONTRACT_APPROVAL_PVT AUTHID CURRENT_USER as
2 /* $Header: OKCRCAPS.pls 120.3.12000000.1 2007/01/17 11:22:44 appldev ship $ */
3 
4 PROCEDURE continue_k_process
5 (
6  p_api_version    IN         NUMBER,
7  p_init_msg_list  IN         VARCHAR2 ,
8  x_return_status  OUT NOCOPY VARCHAR2,
9  x_msg_count      OUT NOCOPY NUMBER,
10  x_msg_data       OUT NOCOPY VARCHAR2,
11  p_contract_id    IN         NUMBER,
12  p_wf_item_key    IN         VARCHAR2,
13  p_called_from    IN         VARCHAR2
14  );
15 
16   -- public procedure declarations
17   -- for use by OKC_CONTRACT_APPROVAL_PUB public PL/SQL API
18 procedure k_approval_start(
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_contract_id       IN  number,
25                     p_process_id        IN  number,
26                     p_do_commit         IN  VARCHAR2 default OKC_API.G_TRUE,
27                     p_access_level      IN  VARCHAR2 default 'N',
28                     p_user_id           IN  NUMBER default null,
29                     p_resp_id           IN  NUMBER default null,
30                     p_resp_appl_id      IN  NUMBER default null,
31                     p_security_group_id IN  NUMBER default null
32 			);
33 function wf_monitor_url(
34 				p_contract_id IN number,
35 				p_process_id IN number,
36 				p_mode IN varchar2 default 'USER'
37 		    ) return varchar2;
38 procedure k_approval_stop(
39 				p_api_version	IN	NUMBER,
40                   	p_init_msg_list	IN	VARCHAR2 default OKC_API.G_FALSE,
41                         x_return_status	OUT NOCOPY	VARCHAR2,
42                         x_msg_count	OUT NOCOPY	NUMBER,
43                         x_msg_data	OUT NOCOPY	VARCHAR2,
44 				p_contract_id number,
45 				p_do_commit IN VARCHAR2 default OKC_API.G_TRUE
46 			);
47 
48   -- public utilities declarations
49   -- for use by Contract Approval Process Developers
50 procedure wf_copy_env(	p_item_type varchar2,
51 				p_item_key varchar2);
52 function  k_accesible(
53 			p_contract_id IN number,
54 			p_user_id IN number,
55 			p_level IN varchar2 default 'R'
56 		     ) return varchar2;
57 procedure k_approved(
58 			p_contract_id IN number,
59 			p_date_approved IN date default sysdate,
60                   x_return_status	OUT NOCOPY	VARCHAR2
61 		    );
62 procedure k_erase_approved(
63 			p_contract_id IN number,
64                   x_return_status	OUT NOCOPY	VARCHAR2
65 		    );
66 procedure k_signed(
67 			p_contract_id        IN        number,
68 			p_date_signed        IN        date     default sysdate,
69 			p_complete_k_prcs    IN        VARCHAR2 default 'Y',
70                x_return_status	OUT NOCOPY VARCHAR2
71 		    );
72 procedure activate_template(
73 			p_contract_id   IN number,
74          x_return_status OUT NOCOPY	VARCHAR2);
75 end OKC_CONTRACT_APPROVAL_PVT;