1 PACKAGE IEM_WFSTARTPROCESS_PUB AUTHID CURRENT_USER as
2 /* $Header: iempwfss.pls 120.1 2005/09/19 13:52:04 appldev ship $*/
3 -- Global Variables
4
5 TYPE t_queuerecord is record(
6 msg_id number,
7 user_name varchar2(60)
8 );
9 TYPE t_queue_table is TABLE OF t_queuerecord
10 INDEX BY BINARY_INTEGER;
11 -- *****************************************************
12 -- Start of Comments
13 -- Package name : IEM_WFSTARTPROCESS_PUB
14 -- Purpose : Public Package. Start the Workflow procss
15 -- History : rtripath 02/04/00
16 -- NOTE :
17
18 -- API name : CallWorkflow
19 -- Type : Public
20 -- Function : This API invoke the Workflow process for mail preprocessing
21 -- Pre-reqs : None.
22 -- Parameters :
23 -- IN
24 -- p_api_version IN NUMBER Required
25 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
26 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
27 -- p_workflowProcess in varchar2 :=FND_API.G_MISS_CHAR,
28 -- p_Item_Type in varchar2 :=FND_API.G_MISS_CHAR,
29 -- OUT
30 -- x_return_status OUT VARCHAR2
31 -- x_msg_count OUT NUMBER
32 -- x_msg_data OUT VARCHAR2
33 --
34 -- Version : 1.0
35 -- Notes :
36 --
37 -- End of comments
38 -- **********************************************************
39 PROCEDURE CallWorkflow(p_api_version_number IN NUMBER,
40 p_init_msg_list IN VARCHAR2 ,
41 p_commit IN VARCHAR2 ,
42 p_workflowProcess in varchar2 ,
43 p_Item_Type in varchar2 ,
44 itemkey in number,
45 p_itemuserkey in varchar2,
46 p_queue_opt in varchar2:='FOREVER',
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_msg_count OUT NOCOPY NUMBER,
49 x_msg_data OUT NOCOPY VARCHAR2
50 );
51 PROCEDURE LaunchProcess(ERRBUF OUT NOCOPY VARCHAR2,
52 ERRRET OUT NOCOPY VARCHAR2,
53 p_api_version_number IN NUMBER,
54 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
55 p_commit IN VARCHAR2 := FND_API.G_FALSE,
56 p_workflowProcess in varchar2 :=null,
57 p_Item_Type in varchar2 :=null,
58 p_qopt in varchar2:='FOREVER',
59 p_counter in number
60 );
61 PROCEDURE ProcessRetry(ERRBUF OUT NOCOPY VARCHAR2,
62 ERRRET OUT NOCOPY VARCHAR2,
63 p_api_version_number in number,
64 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
65 p_commit IN VARCHAR2 := FND_API.G_TRUE,
66 p_workflowProcess in varchar2 :=null,
67 p_Item_Type in varchar2 :=null);
68
69 PROCEDURE StopWorkflow(ERRBUF OUT NOCOPY VARCHAR2,
70 ERRRET OUT NOCOPY VARCHAR2,
71 p_api_version_number IN NUMBER,
72 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
73 p_commit IN VARCHAR2 := FND_API.G_TRUE
74 );
75 PROCEDURE PurgeWorkflow(ERRBUF OUT NOCOPY VARCHAR2,
76 ERRRET OUT NOCOPY VARCHAR2,
77 p_api_version_number IN NUMBER,
78 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
79 p_commit IN VARCHAR2 := FND_API.G_TRUE,
80 p_item_type IN VARCHAR2:='IEM_MAIL',
81 p_end_date IN varchar2
82 );
83 END IEM_WFSTARTPROCESS_PUB;