[Home] [Help]
PACKAGE BODY: APPS.IGW_WORKFLOW
Source
1 package body igw_workflow as
2 --$Header: igwwfrob.pls 120.7 2005/09/12 21:06:26 vmedikon ship $
3 ----------- procedure start_workflow ------------------------------
4 procedure start_workflow(p_proposal_id in number,
5 p_run_id in number) is
6
7
8
9
10 begin
11
12 null;
13
14 end start_workflow;
15
16
17 ----------- procedure select_persons_to_notify -----------------------------
18 procedure select_persons_to_notify(itemtype in varchar2,
19 itemkey in varchar2,
20 actid in number,
21 funcmode in varchar2,
22 result out nocopy varchar2) is
23
24 cursor get_notification_role is
25 select distinct
26 ppms.wf_role_name
27 from igw_prop_maps ppm,
28 igw_prop_map_stops ppms
29 where ppm.prop_map_id = ppms.prop_map_id
30 and ppm.run_id = to_number(itemkey)
31 and ppm.map_type = 'N'
32 and ppms.submission_date is null;
33
34 l_wf_role_name varchar2(100);
35
36 begin
37
38 null;
39
40 end select_persons_to_notify;
41
42 ----------- procedure select_approver -----------------------------
43 procedure select_approver(itemtype in varchar2,
44 itemkey in varchar2,
45 actid in number,
46 funcmode in varchar2,
47 result out nocopy varchar2) is
48
49 begin
50 null;
51 end select_approver;
52
53
54
55 ----------- procedure update_approval_status -----------------------------
56 procedure disable_reassign(itemtype in varchar2,
57 itemkey in varchar2,
58 actid in number,
59 funcmode in varchar2,
60 result out nocopy varchar2) is
61
62 begin
63 null;
64
65 end disable_reassign;
66
67 ----------- procedure expire_role -----------------------------
68 procedure expire_role(itemkey in varchar2) is
69
70
71 begin
72
73 null;
74
75 end expire_role;
76
77
78 ----------- procedure update_approval_status -----------------------------
79 procedure update_approval_status(itemtype in varchar2,
80 itemkey in varchar2,
81 actid in number,
82 funcmode in varchar2,
83 result out nocopy varchar2) is
84
85
86
87 begin
88
89
90 null;
91 end update_approval_status;
92
93
94
95 ----------- procedure delete_approval_roles -----------------------------
96 procedure delete_approval_roles(l_proposal_id in number) is
97
98
99
100
101 begin
102
103 null;
104 end delete_approval_roles;
105
106
107 ----------- procedure update_rejection_status -----------------------------
108 procedure update_rejection_status(itemtype in varchar2,
109 itemkey in varchar2,
110 actid in number,
111 funcmode in varchar2,
112 result out nocopy varchar2) is
113
114 cursor select_responder(l_forward_to_username varchar2) is
115 select wn.responder,wna.text_value
116 from wf_notification_attributes wna,
117 wf_notifications wn
118 where wn.notification_id = wna.notification_id
119 and wna.name = 'NOTE'
120 and wn.recipient_role = l_forward_to_username
121 and wn.responder is not null
122 and wn.message_name = 'NOTIFY_APPROVER';
123
124 l_responder varchar2(100);
125 l_text_value varchar2(2000);
126 l_proposal_id number(15);
127 l_forward_to_username varchar2(100);
128
129 begin
130
131
132 null;
133 end update_rejection_status;
134
135
136 ----------- procedure last_approver -----------------------------
137 procedure last_approver(itemtype in varchar2,
138 itemkey in varchar2,
139 actid in number,
140 funcmode in varchar2,
141 result out nocopy varchar2) is
142
143
144 l_proposal_id number(15);
145
146 begin
147
148 null;
149 end last_approver;
150 end igw_workflow;