1 PACKAGE QPR_WKFL_UTIL AUTHID CURRENT_USER AS
2 /* $Header: QPRUWKFLS.pls 120.5 2008/05/28 12:06:13 bhuchand ship $ */
3
4 type char_type is table of varchar2(500) index by pls_integer;
5
6 procedure approve_deal(
7 item_type in varchar2,
8 itemkey in varchar2,
9 actid in number,
10 funcmode in varchar2,
11 resultout out nocopy varchar2);
12
13 procedure reject_deal(
14 item_type in varchar2,
15 itemkey in varchar2,
16 actid in number,
17 funcmode in varchar2,
18 resultout out nocopy varchar2);
19
20 procedure set_callback_nfn_details(item_type in varchar2,
21 itemkey in varchar2,
22 actid in number,
23 funcmode in varchar2,
24 resultout out nocopy varchar2);
25
26
27 procedure set_app_status_nfn_details(item_type in varchar2,
28 itemkey in varchar2,
29 actid in number,
30 funcmode in varchar2,
31 resultout out nocopy varchar2);
32
33 procedure show_deal_details(document_id in varchar2,
34 display_type in varchar2,
35 document in out nocopy varchar2,
36 document_type in out nocopy varchar2);
37
38 procedure attach_deal_details (
39 document_id in varchar2,
40 display_type in varchar2,
41 document in out nocopy clob,
42 document_type in out nocopy varchar2
43 );
44
45 procedure invoke_cb_nfn_process(p_response_id in number,
46 p_usr_list in char_type,
47 p_comments in varchar2,
48 retcode out nocopy number,
49 errbuf out nocopy varchar2);
50
51 procedure invoke_toapp_nfn_process(p_response_id in number,
52 p_fwd_to_user in varchar2,
53 retcode out nocopy number,
54 errbuf out nocopy varchar2);
55
56 procedure invoke_appstat_nfn_process(p_response_id in number,
57 p_usr_list in char_type,
58 p_comments in varchar2,
59 p_status in varchar2,
60 retcode out nocopy number,
61 errbuf out nocopy varchar2);
62
63 procedure complete_toapp_nfn_process(p_response_id in number,
64 p_current_user in varchar2,
65 p_status in varchar2,
66 retcode out nocopy number,
67 errbuf out nocopy varchar2);
68 procedure cancel_toapp_nfn_process(p_response_id in number,
69 p_usr_list in char_type,
70 retcode out nocopy number,
71 errbuf out nocopy varchar2);
72 END;
73