1 PACKAGE PSP_ER_WORKFLOW AUTHID CURRENT_USER as
2 /* $Header: PSPERWFS.pls 120.2.12020000.1 2012/06/28 06:56:57 appldev ship $ */
3
4 procedure start_initiator_wf( p_request_id in integer);
5
6
7 procedure init_approvals(itemtype in varchar2,
8 itemkey in varchar2,
9 actid in number,
10 funcmode in varchar2,
11 result out nocopy varchar2);
12
13 procedure fatal_err_occured(itemtype in varchar2,
14 itemkey in varchar2,
15 actid in number,
16 funcmode in varchar2,
17 result out nocopy varchar2);
18
19 procedure purge_er(itemtype in varchar2,
20 itemkey in varchar2,
21 actid in number,
22 funcmode in varchar2,
23 result out nocopy varchar2);
24
25 procedure get_next_approver(itemtype in varchar2,
26 itemkey in varchar2,
27 actid in number,
28 funcmode in varchar2,
29 result out nocopy varchar2);
30
31
32 procedure process_rejections(itemtype in varchar2,
33 itemkey in varchar2,
34 actid in number,
35 funcmode in varchar2,
36 result out nocopy varchar2);
37
38 procedure process_approvals(itemtype in varchar2,
39 itemkey in varchar2,
40 actid in number,
41 funcmode in varchar2,
42 result out nocopy varchar2);
43
44 procedure record_initiator_apprvl(itemtype in varchar2,
45 itemkey in varchar2,
46 actid in number,
47 funcmode in varchar2,
48 result out nocopy varchar2);
49
50 procedure record_initiator_rjct(itemtype in varchar2,
51 itemkey in varchar2,
52 actid in number,
53 funcmode in varchar2,
54 result out nocopy varchar2);
55
56 procedure approver_pdf_fail(itemtype in varchar2,
57 itemkey in varchar2,
58 actid in number,
59 funcmode in varchar2,
60 result out nocopy varchar2);
61
62 procedure initiator_response(itemtype in varchar2,
63 itemkey in varchar2,
64 actid in number,
65 funcmode in varchar2,
66 result out nocopy varchar2);
67
68 --- get and attach the same PDF for the next approver.
69 procedure get_pdf_for_apprvr(itemtype in varchar2,
70 itemkey in varchar2,
71 actid in number,
72 funcmode in varchar2,
73 result out nocopy varchar2);
74
75 procedure gen_modified_pdf(itemtype in varchar2,
76 itemkey in varchar2,
77 actid in number,
78 funcmode in varchar2,
79 result out nocopy varchar2);
80
81 procedure pyugen_er_workflow(pactid in number);
82
83 procedure update_receiver(itemtype in varchar2,
84 itemkey in varchar2,
85 actid in number,
86 funcmode in varchar2,
87 result out nocopy varchar2);
88 procedure update_approver(itemtype in varchar2,
89 itemkey in varchar2,
90 actid in number,
91 funcmode in varchar2,
92 result out nocopy varchar2);
93
94 procedure create_frp_role(itemtype in varchar2,
95 itemkey in varchar2,
96 actid in number,
97 funcmode in varchar2,
98 result out nocopy varchar2);
99
100 procedure pre_approved(itemtype in varchar2,
101 itemkey in varchar2,
102 actid in number,
103 funcmode in varchar2,
104 result out nocopy varchar2);
105
106 procedure update_initiator_message (itemtype IN varchar2,
107 itemkey IN varchar2,
108 actid IN number,
109 funcmode IN varchar2,
110 result OUT nocopy varchar2);
111
112 procedure preview_er (itemtype IN varchar2,
113 itemkey IN varchar2,
114 actid IN number,
115 funcmode IN varchar2,
116 result OUT nocopy varchar2);
117
118 procedure set_wf_admin(itemtype in varchar2,
119 itemkey in varchar2,
120 actid in number,
121 funcmode in varchar2,
122 result out nocopy varchar2);
123
124
125 procedure get_timeout_approver(itemtype in varchar2,
126 itemkey in varchar2,
127 actid in number,
128 funcmode in varchar2,
129
130 result out nocopy varchar2);
131 procedure approver_post_notify(itemtype in varchar2,
132 itemkey in varchar2,
133 actid in number,
134 funcmode in varchar2,
135 result out nocopy varchar2);
136 --Bug 7135471
137 FUNCTION item_attribute_exists
138 (p_item_type in wf_items.item_type%type,
139 p_item_key in wf_item_activity_statuses.item_key%type,
140 p_name in wf_item_attribute_values.name%type)
141 return boolean;
142
143 end;