DBA Data[Home] [Help]

PACKAGE: APPS.EDR_TEMPLATE_SUBS

Source


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;