1 package WF_UTIL AUTHID CURRENT_USER as
2 /* $Header: WFUTILS.pls 120.5 2005/10/28 11:25:15 dlam ship $ */
3 --------------------------------------------------------------------------
4 /*
5 ** call_me_later - Executes your callback at the specified future date,
6 ** passing in the specified parameter list.
7 **
8 ** It does this by embedding the information into the
9 ** standard oracle.apps.wf.callback.delay event and
10 ** placing it on the deferred queue,
11 **
12 ** The callback parameter must be fully described as
13 ** <package>.<routine> and your routine must have the
14 ** following spec:
15 **
16 ** PROCEDURE callback(p_parameters in wf_parameter_list_t default null);
17 **
18 ** Include any parameters you think your callback will
19 ** need to do its job.
20 */
21 PROCEDURE call_me_later(p_callback in varchar2,
22 p_when in date,
23 p_parameters in wf_parameter_list_t default null);
24 --------------------------------------------------------------------------
25 /*
26 ** call_me_later_rf - Implements the rule-function for the standard
27 ** subscription on the oracle.apps.wf.callback.delay
28 ** event. This rule-function is responsibile for
29 ** calling the callback, passing in your parameter info.
30 */
31 FUNCTION call_me_later_rf(p_subscription_guid in raw,
32 p_event in out nocopy wf_event_t) return varchar2;
33 --------------------------------------------------------------------------
34 end WF_UTIL;