1 PACKAGE aml_monitor_wf AUTHID CURRENT_USER AS
2 /* $Header: amlldmns.pls 115.11 2003/09/09 23:50:52 swkhanna ship $ */
3
4
5
6 /*-------------------------------------------------------------------------*
7 |
8 | PRIVATE DATATYPES
9 |
10 *-------------------------------------------------------------------------*/
11 TYPE NUMBER_TABLE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
12 TYPE FLAG_TABLE IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
13
14
15 g_item_type VARCHAR2(30) := 'ASXSLASW';
16
17
18 /*-------------------------------------------------------------------------*
19 |
20 | PUBLIC APIS
21 |
22 *-------------------------------------------------------------------------*/
23
24
25 -- PROCEDURE GetMonitors
26 --
27 -- DESCRIPTION Retrieves eligible monitors
28 --
29 -- IN
30 -- itemtype - type of the current item
31 -- itemkey - key of the current item
32 -- actid - process activity instance id
33 -- funcmode - function execution mode. Set by the engine as either 'RUN',
34 -- 'CANCEL', or 'TIMEOUT'
35 -- OUT
36 -- result
37 -- - COMPLETE[:<result>]
38 -- activity has completed with the indicated result
39 -- - WAITING
40 -- activity is waiting for additional transitions
41 -- - DEFERED
42 -- execution should be defered to background
43 -- - NOTIFIED[:<notification_id>:<assigned_user>]
44 -- activity has notified an external entity that this
45 -- step must be performed. A call to wf_engine.CompleteActivty
46 -- will signal when this step is complete. Optional
47 -- return of notification ID and assigned user.
48 -- - ERROR[:<error_code>]
49 -- function encountered an error.
50 -- None
51
52
53
54
55 PROCEDURE LAUNCH_MONITOR (
56 P_Api_Version_Number IN NUMBER,
57 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
58 p_commit IN VARCHAR2 := FND_API.G_FALSE,
59 P_Sales_Lead_Id IN NUMBER,
60 P_Changed_From_stage IN VARCHAR2 ,
61 P_Lead_Action IN VARCHAR2 ,
62 P_Attribute_Changed IN VARCHAR2 ,
63 X_Return_Status OUT NOCOPY VARCHAR2,
64 X_Msg_Count OUT NOCOPY NUMBER,
65 X_Msg_Data OUT NOCOPY VARCHAR2
66 );
67
68 PROCEDURE Get_Monitor_Details(
69 itemtype IN VARCHAR2,
70 itemkey IN VARCHAR2,
71 actid IN NUMBER,
72 funcmode IN VARCHAR2,
73 result OUT NOCOPY VARCHAR2 ) ;
74
75 PROCEDURE Owner_Needed (
76 itemtype IN VARCHAR2,
77 itemkey IN VARCHAR2,
78 actid IN NUMBER,
79 funcmode IN VARCHAR2,
80 result OUT NOCOPY VARCHAR2 ) ;
81
82 PROCEDURE Timeout_Defined (
83 itemtype IN VARCHAR2,
84 itemkey IN VARCHAR2,
85 actid IN NUMBER,
86 funcmode IN VARCHAR2,
87 result OUT NOCOPY VARCHAR2 );
88
89 PROCEDURE SET_NOTIFY_ATTRIBUTES (
90 itemtype IN VARCHAR2,
91 itemkey IN VARCHAR2,
92 actid IN NUMBER,
93 funcmode IN VARCHAR2,
94 result OUT NOCOPY VARCHAR2 );
95
96 PROCEDURE LOG_ACTION (
97 itemtype IN VARCHAR2,
98 itemkey IN VARCHAR2,
99 actid IN NUMBER,
100 funcmode IN VARCHAR2,
101 result OUT NOCOPY VARCHAR2 );
102
103 PROCEDURE CHK_MAX_REMINDERS (
104 itemtype IN VARCHAR2,
105 itemkey IN VARCHAR2,
106 actid IN NUMBER,
107 funcmode IN VARCHAR2,
108 result OUT NOCOPY VARCHAR2 );
109
110 PROCEDURE SET_REMINDER_ATTRIBUTES (
111 itemtype IN VARCHAR2,
112 itemkey IN VARCHAR2,
113 actid IN NUMBER,
114 funcmode IN VARCHAR2,
115 result OUT NOCOPY VARCHAR2 );
116
117 PROCEDURE Set_Timeout (
118 itemtype IN VARCHAR2,
119 itemkey IN VARCHAR2,
120 actid IN NUMBER,
121 funcmode IN VARCHAR2,
122 result OUT NOCOPY VARCHAR2 );
123
124 PROCEDURE Chk_Max_Reroutes (
125 itemtype IN VARCHAR2,
126 itemkey IN VARCHAR2,
127 actid IN NUMBER,
128 funcmode IN VARCHAR2,
129 result OUT NOCOPY VARCHAR2 );
130
131 /*******************************/
132 PROCEDURE INCREMENT_CURR_REMINDER (
133 itemtype IN VARCHAR2,
134 itemkey IN VARCHAR2,
135 actid IN NUMBER,
136 funcmode IN VARCHAR2,
137 result OUT NOCOPY VARCHAR2 );
138
139 /*******************************/
140 PROCEDURE INCREMENT_CURR_REROUTES (
141 itemtype IN VARCHAR2,
142 itemkey IN VARCHAR2,
143 actid IN NUMBER,
144 funcmode IN VARCHAR2,
145 result OUT NOCOPY VARCHAR2 ) ;
146
147 /*******************************/
148 -- API: CHK_TIMELAG_CONDITION_TRUE
149 /*******************************/
150 PROCEDURE CHK_TIMELAG_CONDITION_TRUE (
151 itemtype IN VARCHAR2,
152 itemkey IN VARCHAR2,
153 actid IN NUMBER,
154 funcmode IN VARCHAR2,
155 result OUT NOCOPY VARCHAR2 );
156
157 /*******************************/
158 -- API: SET_DEFAULT_RESOURCE
159 /*******************************/
160 PROCEDURE SET_DEFAULT_RESOURCE (
161 itemtype IN VARCHAR2,
162 itemkey IN VARCHAR2,
163 actid IN NUMBER,
164 funcmode IN VARCHAR2,
165 result OUT NOCOPY VARCHAR2 );
166
167
168 PROCEDURE CHK_RESTART_REQD (
169 itemtype IN VARCHAR2,
170 itemkey IN VARCHAR2,
171 actid IN NUMBER,
172 funcmode IN VARCHAR2,
173 result OUT NOCOPY VARCHAR2 );
174
175 PROCEDURE SET_RESTART_ATTR (
176 itemtype IN VARCHAR2,
177 itemkey IN VARCHAR2,
178 actid IN NUMBER,
179 funcmode IN VARCHAR2,
180 result OUT NOCOPY VARCHAR2 );
181
182
183 procedure set_timelag
184 (p_start_date in date,
185 p_timeout in out NOCOPY number,
186 x_due_date out NOCOPY date,
187 x_total_timeout out NOCOPY number);
188
189
190 Procedure get_lead_owner
191 ( itemtype IN VARCHAR2,
192 itemkey IN VARCHAR2);
193
194
195 END AML_MONITOR_WF ;