1 PACKAGE EDR_TEMPLATE_SUBS AS
2 /* $Header: EDRTMPSS.pls 120.0.12000000.1 2007/01/18 05:55:50 appldev ship $ */
3
4 -- EDR_TEMPLATE_SUBS.UPLOAD_TEMPLATE
5 -- This procedure is a post process function called from RTFUPLOAF Workflow process.
6 -- It gets the name of file being approved and converts it to XSLFO if it is EDR_EREC_TEMPLATE
7 -- and File Extension is RTF.
8
9 -- P_ITEMTYPE The internal name for the item type. Item types are
10 -- defined in the Oracle Workflow Builder.
11
12 -- P_ITEMKEY A string that represents a primary key generated
13 -- by the workflow-enabled application for the item
14 -- type. The string uniquely identifies the item within
15 -- an item type.
16
17 -- P_ACTID The ID number of the activity from which this
18 -- procedure is called.
19
20 -- P_FUNCMODE The execution mode of the activity. If the activity is
21 -- a function activity, the mode is either RUN or
22 -- CANCEL. If the activity is a notification activity,
23 -- with a postnotification function, then the mode
24 -- can be RESPOND, FORWARD, TRANSFER,
25 -- TIMEOUT, or RUN.
26
27 -- P_RESULTOUT If a result type is specified in the Activities
28 -- properties page for the activity in the Oracle
29 -- Workflow Builder, this parameter represents the
30 -- expected result that is returned when the
31 -- procedure completes. The possible results are:
32 -- COMPLETE:<result_code> activity completes
33 -- with the indicated result code. The result code
34 -- must match one of the result codes specified in the
35 -- result type of the function activity.
36 -- WAITING-activity is pending, waiting on
37 -- another activity to complete before it completes.
38 -- An example is the Standard AND activity.
39 -- DEFERRED:<date>activity is deferred to a
40 -- background engine for execution until a given date.
41 -- <date> must be of the format:
42 -- to_char(<date_string>, wf_engine.date_format)
43 -- NOTIFIED:<notification_id>:<assigned_user>-a
44 -- n external entity is notified that an action must be
45 -- performed. A notification ID and an assigned user
46 -- can optionally be returned with this result. Note
47 -- that the external entity must call CompleteActivity( )
48 -- to inform the Workflow Engine when the action
49 -- completes.
50 -- ERROR:<error_code>-activity encounters an
51 -- error and returns the indicated error code.
52
53 PROCEDURE UPLOAD_TEMPLATE
54 (
55 P_ITEMTYPE VARCHAR2,
56 P_ITEMKEY VARCHAR2,
57 P_ACTID NUMBER,
58 P_FUNCMODE VARCHAR2,
59 P_RESULTOUT OUT NOCOPY VARCHAR2
60 );
61
62 END EDR_TEMPLATE_SUBS;