1 PACKAGE IEX_WF_BAN_STATUS_PUB AUTHID CURRENT_USER AS
2 /* $Header: iexwfbss.pls 120.0.12010000.2 2009/01/09 02:35:03 gnramasa 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 PROCEDURE start_workflow
9 (p_api_version IN NUMBER := 1.0,
10 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
11 p_commit IN VARCHAR2 := FND_API.G_FALSE,
12 p_user_id IN NUMBER,
13 p_delinquency_id IN NUMBER,
14 p_party_id IN NUMBER,
15 p_bankruptcy_id IN NUMBER, --Added for bug 7661724 gnramasa 8th Jan 09
16 x_return_status OUT NOCOPY VARCHAR2,
17 x_msg_count OUT NOCOPY NUMBER,
18 x_msg_data OUT NOCOPY VARCHAR2);
19
20 PROCEDURE update_approval_status(
21 itemtype IN VARCHAR2,
22 itemkey IN VARCHAR2,
23 actid IN NUMBER,
24 funcmode IN VARCHAR2,
25 result OUT NOCOPY VARCHAR2);
26
27 procedure update_rejection_status(
28 itemtype IN VARCHAR2,
29 itemkey IN VARCHAR2,
30 actid IN NUMBER,
31 funcmode IN VARCHAR2,
32 result OUT NOCOPY VARCHAR2);
33
34 PROCEDURE set_no_contact_in_tca(
35 itemtype IN VARCHAR2,
36 itemkey IN VARCHAR2,
37 actid IN NUMBER,
38 funcmode IN VARCHAR2,
39 result OUT NOCOPY VARCHAR2);
40
41 procedure turnoff_collection_profile(
42 itemtype IN VARCHAR2,
43 itemkey IN VARCHAR2,
44 actid IN NUMBER,
45 funcmode IN VARCHAR2,
46 result OUT NOCOPY VARCHAR2);
47
48 PROCEDURE turnoff_collections(
49 itemtype IN VARCHAR2,
50 itemkey IN VARCHAR2,
51 actid IN NUMBER,
52 funcmode IN VARCHAR2,
53 result OUT NOCOPY VARCHAR2);
54
55 PROCEDURE no_turnoff_collections(
56 itemtype IN VARCHAR2,
57 itemkey IN VARCHAR2,
58 actid IN NUMBER,
59 funcmode IN VARCHAR2,
60 result OUT NOCOPY VARCHAR2);
61
62 procedure create_strategy(
63 p_api_version IN NUMBER := 1.0,
64 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
65 p_commit IN VARCHAR2 := FND_API.G_FALSE,
66 p_delinquency_id IN NUMBER,
67 p_bankruptcy_id IN NUMBER,
68 p_party_id IN NUMBER,
69 x_return_status OUT NOCOPY VARCHAR2,
70 x_msg_count OUT NOCOPY NUMBER,
71 x_msg_data OUT NOCOPY VARCHAR2);
72
73 --Start bug 7661724 gnramasa 8th Jan 09
74 procedure cancel_strategy_and_workflow(
75 p_party_id IN NUMBER,
76 p_bankruptcy_id IN NUMBER,
77 p_disposition_code IN VARCHAR2);
78 --End bug 7661724 gnramasa 8th Jan 09
79
80 END IEX_WF_BAN_STATUS_PUB;