1 PACKAGE OKL_STRY_CALL_CO_PUB AUTHID CURRENT_USER as
2 /* $Header: OKLPCWFS.pls 120.1 2005/07/18 06:21:02 asawanka noship $ */
3
4
5 wf_yes varchar2(1) := 'Y';
6 wf_no varchar2(1) := 'N';
7
8
9
10 /**
11 * send an email thru fulfilment
12 * right now the okl fulfilment api supports email
13 * only
14 **/
15 procedure send_fulfilment(
16 itemtype in varchar2,
17 itemkey in varchar2,
18 actid in number,
19 funcmode in varchar2,
20 result out nocopy varchar2);
21
22 /** send signal to the main work flow that the custom work flow is over and
23 * also updates the work item
24 **/
25
26 procedure wf_send_signal(
27 itemtype in varchar2,
28 itemkey in varchar2,
29 actid in number,
30 funcmode in varchar2,
31 result out nocopy varchar2);
32
33 /**
34 get the most delinquent contract from a
35 case based on the no of days due
36 */
37
38 PROCEDURE get_delinquent_contract(
39 p_case_id IN NUMBER,
40 x_contract_id OUT NOCOPY NUMBER,
41 x_days OUT NOCOPY NUMBER) ;
42
43
44 /**
45 checks if vendor approval is required to call customer
46 **/
47 PROCEDURE get_vendorapproval_flag(itemtype in varchar2,
48 itemkey in varchar2,
49 actid in number,
50 funcmode in varchar2,
51 result out nocopy varchar2);
52
53 /**
54 checks for notification rule
55 **/
56
57 PROCEDURE get_notification_flag(itemtype in varchar2,
58 itemkey in varchar2,
59 actid in number,
60 funcmode in varchar2,
61 result out nocopy varchar2);
62 /**
63 checks if no of days past due is greater than the
64 the actual past due
65 **/
66
67 PROCEDURE check_days_past_due(itemtype in varchar2,
68 itemkey in varchar2,
69 actid in number,
70 funcmode in varchar2,
71 result out nocopy varchar2);
72 /*returns vendor information*/
73 PROCEDURE get_vendor_info(p_case_number in varchar2,
74 x_vendor_id out nocopy number,
75 x_vendor_name out nocopy varchar2,
76 x_vendor_email out nocopy varchar2,
77 x_return_status out nocopy varchar2);
78
79 ---------------------------------------------------------------------------
80 -- PROCEDURE Days to take notice of assignment for Syndicated Account?
81 ---------------------------------------------------------------------------
82 PROCEDURE check_days_for_syn_acct(itemtype in varchar2,
83 itemkey in varchar2,
84 actid in number,
85 funcmode in varchar2,
86 result out nocopy varchar2) ;
87
88
89 ---------------------------------------------------------------------------
90 -- PROCEDURE lessor_VISIT_FLAG -'Lessor allowed to visit customer?'
91 ---------------------------------------------------------------------------
92 PROCEDURE get_lessor_flag(itemtype in varchar2,
93 itemkey in varchar2,
94 actid in number,
95 funcmode in varchar2,
96 result out nocopy varchar2) ;
97 ---------------------------------------------------------------------------
98 -- PROCEDURE Customer_VISIT_FLAG - 'Vendor allowed to visit customer?'
99 ---------------------------------------------------------------------------
100 PROCEDURE get_Customer_flag(itemtype in varchar2,
101 itemkey in varchar2,
102 actid in number,
103 funcmode in varchar2,
104 result out nocopy varchar2);
105 ---------------------------------------------------------------------------
106 -- PROCEDURE Vendor_Customer_VISIT_FLAG - 'Vendor approval required to visit customer?'
107 ---------------------------------------------------------------------------
108 PROCEDURE get_Vendor_approval_flag(itemtype in varchar2,
109 itemkey in varchar2,
110 actid in number,
111 funcmode in varchar2,
112 result out nocopy varchar2);
113 --------------------------------------------------------------------------
114 -- PROCEDURE Vend_Cust_NOTIFY Vendor notification required prior to customer visit?
115 ---------------------------------------------------------------------------
116 PROCEDURE get_Vend_Cust_NOTIFY_flag(itemtype in varchar2,
117 itemkey in varchar2,
118 actid in number,
119 funcmode in varchar2,
120 result out nocopy varchar2);
121
122
123
124
125
126 END OKL_STRY_CALL_CO_PUB;