1 PACKAGE IEX_WF_DEL_REQ_SERVICE_PUB AUTHID CURRENT_USER AS
2 /* $Header: iexwfdss.pls 120.0 2004/01/24 03:31:16 appldev noship $ */
3
4 -- PROCEDURE start workflow
5 -- DESCRIPTION This procedure is called to start collections Delinquent Request Service Hold 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_del_type IN VARCHAR2,
15 p_repossession_id IN NUMBER,
16 p_litigation_id IN NUMBER,
17 p_writeoff_id IN NUMBER,
18 p_bankruptcy_id IN NUMBER,
19 x_return_status OUT NOCOPY VARCHAR2,
20 x_msg_count OUT NOCOPY NUMBER,
21 x_msg_data OUT NOCOPY VARCHAR2);
22
23 PROCEDURE update_approval_status(
24 itemtype IN VARCHAR2,
25 itemkey IN VARCHAR2,
26 actid IN NUMBER,
27 funcmode IN VARCHAR2,
28 result OUT NOCOPY VARCHAR2);
29
30
31 procedure update_rejection_status(
32 itemtype IN VARCHAR2,
33 itemkey IN VARCHAR2,
34 actid IN NUMBER,
35 funcmode IN VARCHAR2,
36 result OUT NOCOPY VARCHAR2);
37
38 procedure select_type(
39 itemtype IN VARCHAR2,
40 itemkey IN VARCHAR2,
41 actid IN NUMBER,
42 funcmode IN VARCHAR2,
43 result OUT NOCOPY VARCHAR2);
44
45 END IEX_WF_DEL_REQ_SERVICE_PUB;