PACKAGE: APPS.PO_WF_UTIL_PKG

Source

1 PACKAGE PO_WF_UTIL_PKG AUTHID CURRENT_USER AS
2 /* $Header: POXWUTLS.pls 120.2.12020000.2 2013/02/10 15:49:42 vegajula 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 -- PO AME Project
18 G_ITEM_TYPE wf_items.item_type%TYPE;
19 G_ITEM_KEY wf_items.item_key%TYPE;
20 
21 procedure SetItemAttrText(itemtype in varchar2,
22                           itemkey in varchar2,
23                           aname in varchar2,
24                           avalue in varchar2);
25 
26 -- PO AME Project
27 procedure SetItemAttrText(aname in varchar2,
28                           avalue in varchar2);
29 
30 procedure SetItemAttrNumber(itemtype in varchar2,
31                             itemkey in varchar2,
32                             aname in varchar2,
33                             avalue in number);
34 
35 -- PO AME Project
36 procedure SetItemAttrNumber(aname in varchar2,
37                             avalue in number);
38 
39 procedure SetItemAttrDate(itemtype in varchar2,
40                           itemkey in varchar2,
41                           aname in varchar2,
42                           avalue in date);
43 
44 procedure SetItemAttrDocument(itemtype in varchar2,
45                               itemkey in varchar2,
46                               aname in varchar2,
47                               documentid in varchar2);
48 
49 
50 function GetItemAttrText(itemtype in varchar2,
51                          itemkey in varchar2,
52                          aname in varchar2)
53 return varchar2;
54 
55 -- PO AME Project
56 function GetItemAttrText(aname in varchar2)
57 return varchar2;
58 
59 function GetItemAttrNumber(itemtype in varchar2,
60                            itemkey in varchar2,
61                            aname in varchar2)
62 return number;
63 
64 -- PO AME Project
65 function GetItemAttrNumber(aname in varchar2)
66 return number;
67 
68 function GetItemAttrDate (itemtype in varchar2,
69                           itemkey in varchar2,
70                           aname in varchar2)
71 return date;
72 
73 Function GetItemAttrDocument(itemtype in varchar2,
74                               itemkey in varchar2,
75                               aname in varchar2)
76 RETURN VARCHAR2;
77 
78 function GetActivityAttrText(itemtype in varchar2,
79                              itemkey in varchar2,
80                              actid in number,
81                              aname in varchar2)
82 return varchar2;
83 
84 function GetActivityAttrNumber(itemtype in varchar2,
85                                itemkey in varchar2,
86                                actid in number,
87                                aname in varchar2)
88 return number;
89 
90 
91 function GetActivityAttrDate(itemtype in varchar2,
92                              itemkey in varchar2,
93                              actid in number,
94                              aname in varchar2)
95 return date;
96 
97 
98 -- bug5075361 START
99 PROCEDURE clear_wf_cache;
100 -- bug5075361 END
101 
102 -- bug 4720152
103 function GetWorkflowErrorMessage
104  return varchar2;
105 -- bug 4720152
106 
107 end PO_WF_UTIL_PKG;