PACKAGE: APPS.IEX_STRATEGY_WORK_PUB

Source

1 PACKAGE IEX_STRATEGY_WORK_PUB AUTHID CURRENT_USER as
2 /* $Header: iexpstms.pls 120.3 2005/12/06 13:50:40 schekuri ship $ */
3 
4 G_PKG_NAME  CONSTANT VARCHAR2(30):= 'IEX_STRATEGY_WORK';
5 
6 TYPE STRATEGY_Mailer_Rec_Type IS RECORD (
7             strategy_id     NUMBER := null
8     ,       delinquency_id  NUMBER := null
9     ,       template_id     NUMBER := null
10     ,       xdo_template_id NUMBER := null
11     ,       workitem_id    NUMBER := null
12     ,       user_id        NUMBER  :=null
13     ,       resp_id        NUMBER  :=null
14     ,       resp_appl_id   NUMBER  :=null
15     );
16 
17    G_MISS_STRATEGY_MAILER_REC          STRATEGY_Mailer_Rec_Type;
18 
19 /**
20  * send an email thru fulfilment
21  **/
22 procedure send_mail(
23                                       itemtype    in   varchar2,
24                                       itemkey     in   varchar2,
25                                       actid       in   number,
26                                       funcmode    in   varchar2,
27                                       result      out NOCOPY  varchar2);
28 
29 /**
30  * setup the workflow which call the mailer thru fulfilment
31  **/
32 procedure strategy_mailer(
33     p_api_version             IN  NUMBER ,
34     p_init_msg_list           IN  VARCHAR2 ,
35     p_commit                  IN  VARCHAR2 ,
36     p_strategy_mailer_rec     IN  STRATEGY_MAILER_REC_TYPE,
37     x_return_status           OUT NOCOPY VARCHAR2,
38     x_msg_count               OUT NOCOPY NUMBER,
39     x_msg_data                OUT NOCOPY VARCHAR2);
40 
41 
42 procedure populate_fulfillment_wait
43           ( p_delinquency_id IN NUMBER,
44             p_work_item_id IN NUMBER,
45             itemtype            IN   varchar2,
46             itemkey             IN   varchar2
47            ) ;
48 
49 procedure wf_send_signal(
50   itemtype    in   varchar2,
51   itemkey     in   varchar2,
52   actid       in   number,
53   funcmode    in   varchar2,
54   result      out NOCOPY  varchar2);
55 
56 procedure check_dunning(
57   itemtype    in   varchar2,
58   itemkey     in   varchar2,
59   actid       in   number,
60   funcmode    in   varchar2,
61   result      out NOCOPY  varchar2);
62 
63 procedure resend_fulfillment(
64 p_work_item_id IN NUMBER,
65 x_status out NOCOPY varchar2,
66 x_error_message out NOCOPY varchar2,
67 x_request_id out NOCOPY number
68 );
69 
70 --Start schekuri 02-Dec-2005 - bug#4506922
71 --added for the function WAIT_ON_HOLD_SIGNAL in workflow IEXSTFFM
72 procedure wait_on_hold_signal(
73                          itemtype    in   varchar2,
74                          itemkey     in   varchar2,
75                          actid       in   number,
76                          funcmode    in   varchar2,
77                          result      out nocopy  varchar2);
78 --end schekuri 02-Dec-2005 - bug#4506922
79 
80 end IEX_STRATEGY_WORK_PUB;