1 PACKAGE IEX_WF_BAN_STATUS_PUB AUTHID CURRENT_USER AS
2 /* $Header: iexwfbss.pls 120.1.12020000.4 2013/01/31 14:02:24 ehuh ship $ */
3
4 -- PROCEDURE start workflow
5 -- DESCRIPTION This procedure is called to start collections Bankruptcy Status Approval workflow
6 -- AUTHOR chewang 2/26/2002 created
7
8 Function get_bankruptcy_status (p_party_id IN NUMBER,
9 p_cust_account_id IN NUMBER,
10 p_date IN DATE) RETURN VARCHAR2;
11
12 Function get_TurnInvOff (p_party_id IN NUMBER,
13 p_cust_account_id IN NUMBER,
14 p_date IN DATE) RETURN VARCHAR2;
15
16
17 PROCEDURE start_workflow
18 (p_api_version IN NUMBER := 1.0,
19 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
20 p_commit IN VARCHAR2 := FND_API.G_FALSE,
21 p_user_id IN NUMBER,
22 p_delinquency_id IN NUMBER,
23 p_party_id IN NUMBER,
24 p_bankruptcy_id IN NUMBER, --Added for bug 7661724 gnramasa 8th Jan 09
25 x_return_status OUT NOCOPY VARCHAR2,
26 x_msg_count OUT NOCOPY NUMBER,
27 x_msg_data OUT NOCOPY VARCHAR2);
28
29 PROCEDURE update_approval_status(
30 itemtype IN VARCHAR2,
31 itemkey IN VARCHAR2,
32 actid IN NUMBER,
33 funcmode IN VARCHAR2,
34 result OUT NOCOPY VARCHAR2);
35
36 procedure update_rejection_status(
37 itemtype IN VARCHAR2,
38 itemkey IN VARCHAR2,
39 actid IN NUMBER,
40 funcmode IN VARCHAR2,
41 result OUT NOCOPY VARCHAR2);
42
43 PROCEDURE set_no_contact_in_tca(
44 itemtype IN VARCHAR2,
45 itemkey IN VARCHAR2,
46 actid IN NUMBER,
47 funcmode IN VARCHAR2,
48 result OUT NOCOPY VARCHAR2);
49
50 procedure turnoff_collection_profile(
51 itemtype IN VARCHAR2,
52 itemkey IN VARCHAR2,
53 actid IN NUMBER,
54 funcmode IN VARCHAR2,
55 result OUT NOCOPY VARCHAR2);
56
57 PROCEDURE turnoff_collections(
58 itemtype IN VARCHAR2,
59 itemkey IN VARCHAR2,
60 actid IN NUMBER,
61 funcmode IN VARCHAR2,
62 result OUT NOCOPY VARCHAR2);
63
64 PROCEDURE no_turnoff_collections(
65 itemtype IN VARCHAR2,
66 itemkey IN VARCHAR2,
67 actid IN NUMBER,
68 funcmode IN VARCHAR2,
69 result OUT NOCOPY VARCHAR2);
70
71 procedure create_strategy(
72 p_api_version IN NUMBER := 1.0,
73 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
74 p_commit IN VARCHAR2 := FND_API.G_FALSE,
75 p_delinquency_id IN NUMBER,
76 p_bankruptcy_id IN NUMBER,
77 p_party_id IN NUMBER,
78 x_return_status OUT NOCOPY VARCHAR2,
79 x_msg_count OUT NOCOPY NUMBER,
80 x_msg_data OUT NOCOPY VARCHAR2);
81
82 --Start bug 7661724 gnramasa 8th Jan 09
83 procedure cancel_strategy_and_workflow(
84 p_party_id IN NUMBER,
85 p_bankruptcy_id IN NUMBER,
86 p_disposition_code IN VARCHAR2);
87 --End bug 7661724 gnramasa 8th Jan 09
88
89 /**
90 * check whether the to send a notification -- bug 15951096
91 **/
92 procedure NOTIFY_CHECK(
93 itemtype in varchar2,
94 itemkey in varchar2,
95 actid in number,
96 funcmode in varchar2,
97 result out NOCOPY varchar2);
98
99
100 END IEX_WF_BAN_STATUS_PUB;