40: l_proc varchar2(61) := g_package||':'||'set_role_to_send_ntfn';
41:
42: begin
43: --
44: --hr_utility.set_location(l_proc || ' Entering ',10);
45: --
46: for role_rec in c1 loop
47: --hr_utility.set_location('checking people for role '||role_rec.role_name,20);
48: for user_in_role in c2(role_rec.role_id) loop
43: --
44: --hr_utility.set_location(l_proc || ' Entering ',10);
45: --
46: for role_rec in c1 loop
47: --hr_utility.set_location('checking people for role '||role_rec.role_name,20);
48: for user_in_role in c2(role_rec.role_id) loop
49: --hr_utility.set_location('user '||user_in_role.user_name||' has this role ',20);
50: --6773021
51: wf_engine.SetItemAttrText(itemtype => itemtype
45: --
46: for role_rec in c1 loop
47: --hr_utility.set_location('checking people for role '||role_rec.role_name,20);
48: for user_in_role in c2(role_rec.role_id) loop
49: --hr_utility.set_location('user '||user_in_role.user_name||' has this role ',20);
50: --6773021
51: wf_engine.SetItemAttrText(itemtype => itemtype
52: ,itemkey => itemkey
53: ,aname => 'RECEIVER_NAME'
54: ,avalue => role_rec.role_name);
55: end loop;
56: end loop;
57: --
58: --hr_utility.set_location(l_proc || ' Exiting ',100);
59: --
60: result := 'COMPLETE:';
61: --
62: exception
82: l_param varchar2(2000);
83: --
84: begin
85: --
86: hr_utility.set_location('Entering'||l_proc,10);
87: --
88: l_url := wf_engine.GetItemAttrText(
89: itemtype => p_item_type,
90: itemkey => p_item_key,
96: aname => 'PROCESS_NAME');
97: --
98: l_url := l_url||'&'||'pItemType='||p_item_type||'&'||'pItemKey='||p_item_key||'&'||'pProcessName='||l_process_name||'&'||'pFromNtfn='||p_from_ntfn;
99: --
100: hr_utility.set_location('Leaving'||l_proc,10);
101: --
102: wf_engine.SetItemAttrText(itemtype => p_item_type
103: ,itemkey => p_item_key
104: ,aname => 'NTFN_LINK_TO_REVIEW'