DBA Data[Home] [Help]

PACKAGE: APPS.PO_WF_UTIL_PKG

Source


1 PACKAGE PO_WF_UTIL_PKG AS
2 /* $Header: POXWUTLS.pls 120.1.12000000.2 2007/04/23 08:11:07 rakchakr ship $ */
3  /*=======================================================================+
4  | FILENAME
5  |  POXWUTLS.pls
6  |
7  | DESCRIPTION
8  |   PL/SQL spec for package:  PO_WF_UTIL_PKG
9  |
10  |   This package is a wrapper package to set and get workflow attributes
11  |   with exception catched.
12  |
13  | NOTES
14  | CREATE
15  | MODIFIED
16  *=====================================================================*/
17 
18 procedure SetItemAttrText(itemtype in varchar2,
19                           itemkey in varchar2,
20                           aname in varchar2,
21                           avalue in varchar2);
22 
23 procedure SetItemAttrNumber(itemtype in varchar2,
24                             itemkey in varchar2,
25                             aname in varchar2,
26                             avalue in number);
27 
28 procedure SetItemAttrDate(itemtype in varchar2,
29                           itemkey in varchar2,
30                           aname in varchar2,
31                           avalue in date);
32 
33 procedure SetItemAttrDocument(itemtype in varchar2,
34                               itemkey in varchar2,
35                               aname in varchar2,
36                               documentid in varchar2);
37 
38 
39 function GetItemAttrText(itemtype in varchar2,
40                          itemkey in varchar2,
41                          aname in varchar2)
42 return varchar2;
43 
44 function GetItemAttrNumber(itemtype in varchar2,
45                            itemkey in varchar2,
46                            aname in varchar2)
47 return number;
48 
49 function GetItemAttrDate (itemtype in varchar2,
50                           itemkey in varchar2,
51                           aname in varchar2)
52 return date;
53 
54 Function GetItemAttrDocument(itemtype in varchar2,
55                               itemkey in varchar2,
56                               aname in varchar2)
57 RETURN VARCHAR2;
58 
59 function GetActivityAttrText(itemtype in varchar2,
60                              itemkey in varchar2,
61                              actid in number,
62                              aname in varchar2)
63 return varchar2;
64 
65 function GetActivityAttrNumber(itemtype in varchar2,
66                                itemkey in varchar2,
67                                actid in number,
68                                aname in varchar2)
69 return number;
70 
71 
72 function GetActivityAttrDate(itemtype in varchar2,
73                              itemkey in varchar2,
74                              actid in number,
75                              aname in varchar2)
76 return date;
77 
78 
79 -- bug5075361 START
80 PROCEDURE clear_wf_cache;
81 -- bug5075361 END
82 
83 -- bug 4720152
84 function GetWorkflowErrorMessage
85  return varchar2;
86 -- bug 4720152
87 
88 end PO_WF_UTIL_PKG;