[Home] [Help]
201: RETURN per_people_f%ROWTYPE IS
202:
203: -----------------------------------------------------------------------------
204: -- Fix Bug 1615428:
205: -- In testing WebDB stateful mode, we found that in WF Notification
206: -- responsibility, the Business Group Id profile option is never set for the WF
207: -- Notification responsibility. This will cause no record to return because
208: -- the cursor is using the per_people_f view instead of the base table. Changed
209: -- the cursor to use per_all_people_f base table because if a person id is
229: -- Fix Bug 1615428:
230: -- Intead of calling per_per_bus.return_legislation_code to derive the
231: -- legislation_code, we query legislation code here because per_per_bus api
232: -- uses per_people_f view instead of per_all_people_f base table. The view
233: -- will cause no rec found error when accessed from WF Notification
234: -- responsibility. In addition, per_per_bus.return_legislation_code function
235: -- uses two global variables in the package body: g_person_id and
236: -- g_legislation_code which may cause obscure error when running in WebDB
237: -- stateful mode.
1158: -- ensure the cookie exists
1159: IF l_cookie.num_vals > 0 THEN
1160: -- as the cookie does exist get the web username from
1161: -- the workflow system
1162: l_web_username := wf_notification.accesscheck
1163: (l_cookie.vals(l_cookie.num_vals));
1164: --
1165: -- getid with a parm of 9 returns the internal-contact-id,
1166: l_person_id := icx_sec.getID(n_param => 9);