PACKAGE: APPS.IEX_WF_DEL_CUR_STATUS_NOTE_PUB

Source

1 PACKAGE IEX_WF_DEL_CUR_STATUS_NOTE_PUB AS
2 /* $Header: iexwfcns.pls 120.0 2004/01/24 03:31:05 appldev noship $ */
3 
4 -- PROCEDURE start workflow
5 -- DESCRIPTION	This procedure is called to collections workflow to notify owner and
6 --              manager if a delinquency is closed(Current)
7 -- AUTHOR	chewang 2/26/2002 created
8 
9 PROCEDURE start_workflow
10            (p_api_version       IN NUMBER := 1.0,
11             p_init_msg_list     IN VARCHAR2 := FND_API.G_FALSE,
12             p_commit         	IN VARCHAR2 := FND_API.G_FALSE,
13             p_delinquency_ids   IN IEX_UTILITIES.t_del_id,
14             x_return_status     OUT NOCOPY VARCHAR2,
15             x_msg_count      	OUT NOCOPY NUMBER,
16             x_msg_data      	OUT NOCOPY VARCHAR2);
17 
18 PROCEDURE select_notice(
19             itemtype            IN VARCHAR2,
20             itemkey             IN VARCHAR2,
21             actid               IN NUMBER,
22             funcmode            IN VARCHAR2,
23             result              OUT NOCOPY VARCHAR2);
24 
25 PROCEDURE select_resource_info(
26           p_delinquency_id      IN NUMBER);
27 
28 p_wf_item_NUMBER_NAME 	wf_engine.NameTabTyp	;
29 p_wf_item_NUMBER_VALUE	wf_engine.NumTabTyp	;
30 p_wf_item_TEXT_NAME	wf_engine.NameTabTyp	;
31 p_wf_item_TEXT_VALUE	wf_engine.TextTabTyp	;
32 
33 TYPE DEL_NOTIFICATION_CUR	IS	REF CURSOR	;
34 
35 PROCEDURE SEND_NOTIFICATION( 	p_itemtype			varchar2			,
36 					p_itemkey			varchar2			,
37 					p_wf_item_NUMBER_NAME 	wf_engine.NameTabTyp	,
38 					p_wf_item_NUMBER_VALUE	wf_engine.NumTabTyp	,
39 					p_wf_item_TEXT_NAME	wf_engine.NameTabTyp	,
40 					p_wf_item_TEXT_VALUE	wf_engine.TextTabTyp	,
41 					l_return_status		OUT NOCOPY 	varchar2		,
42 					l_result			OUT NOCOPY 	varchar2 		) ;
43 
44 
45 -- PROCEDURE MAIN	;
46 
47 END IEX_WF_DEL_CUR_STATUS_NOTE_PUB;
48