1 PACKAGE FND_WF_EVENT AS
2 /* $Header: afwfeves.pls 120.2 2005/10/28 05:57:50 dbowles ship $ */
3
4
5 TYPE Param_Rec IS RECORD (Param_Name VARCHAR2(30)
6 ,Param_Value VARCHAR2(2000) );
7 TYPE Param_Table IS TABLE OF Param_Rec INDEX BY BINARY_INTEGER;
8
9 --
10 -- Get_Form_Function (PUBLIC)
11 -- Get the form Function for a specific Workflow Item Key and Item Type.
12 -- IN:
13 -- itemtype - item type
14 -- itemkey - item key
15 -- aname - attribute name
16 -- RETURNS
17 -- Form Function Name
18 Function Get_Form_Function(wf_item_type in varchar2,
19 wf_item_key in varchar2)
20 return varchar2;
21
22 -- Raise_Table(PRIVATE)
23 -- Raises a Workflow. This is to be called ONLY from Forms and is used ONLY
24 -- because of the lack of support of object types in Forms.
25 -- The Param Table is a PL/SQL table which can hold up to 100 parameters.
26 -- IN:
27 -- p_event_name - event name
28 -- p_event_key - event key
29 -- p_event_date - This is not being used here but is left for consistentcy with
30 -- other wf procedures. It MUST always be NULL
31 -- p_param_table - This IN/OUT PL/SQL table contains the parameters to pass to the wf.raise
32 -- p_number_params - This is the number of parameters in the above PL/SQL table
33 -- p_send_date - Send Date
34 -- NOTE
35 -- The PL/SQL Table has the following restrictions
36 -- -There must be consecutive rows in PL/SQL table starting with index 1
37 -- -An identical number of paramters must be returned from raise3 as are submitted to it.
38 Procedure raise_table (p_event_name in varchar2,
39 p_event_key in varchar2,
40 p_event_data in clob default NULL,
41 p_param_table in out NOCOPY Param_Table,
42 p_number_params in NUMBER,
43 p_send_date in date default NULL );
44
45 -- Get_Error_Name(PUBLIC)
46 -- Gets the Workflow Error Name
47 -- RETURNS
48 -- The Workflow Error Name
49 -- NOTE
50 -- This routine is to be used only from Forms.
51 -- It exists only because forms cannot fetch a package variable from a server-side package.
52
53 Function Get_Error_Name RETURN VARCHAR2;
54
55 -- Erase(PRIVATE)
56 -- Erases all traces of a workflow
57 -- NOTE
58 -- This routine is to be used only from Forms.
59 -- It is only here to isolate forms from WF changes.
60
61 Procedure erase(p_item_type in varchar2,
62 p_item_key in varchar2);
63
64
65 end fnd_wf_event;