218:
219: cursor Next_Informed_csr is
220: select role, name from -- here should be your view
221: ------------------------------------------------------
222: (select 1 num, l_approver role, '' name from dual
223: where l_approver is not NULL
224: union all
225: select 2 num, l_initiator role, '' name from dual
226: where not exists
221: ------------------------------------------------------
222: (select 1 num, l_approver role, '' name from dual
223: where l_approver is not NULL
224: union all
225: select 2 num, l_initiator role, '' name from dual
226: where not exists
227: (select 1 from wf_user_roles
228: where user_name=l_initiator
229: and USER_ORIG_SYSTEM IN ('PER','FND_USR')
233: ------------------------------------------------------
234: where (p_current is NULL
235: or num > (select num from -- same view
236: ------------------------------------------------------
237: (select 1 num, l_approver role, '' name from dual
238: where l_approver is not NULL
239: union all
240: select 2 num, l_initiator role, '' name from dual
241: where not exists
236: ------------------------------------------------------
237: (select 1 num, l_approver role, '' name from dual
238: where l_approver is not NULL
239: union all
240: select 2 num, l_initiator role, '' name from dual
241: where not exists
242: (select 1 from wf_user_roles
243: where user_name=l_initiator
244: and USER_ORIG_SYSTEM IN ('PER','FND_USR')
2123: l_api_version NUMBER :=1.0 ;
2124: l_session_id number;
2125: CURSOR csr_session_id IS
2126: SELECT userenv('sessionid')
2127: FROM dual;
2128: --
2129: begin
2130: mo_global.init('OKC');
2131: --