15: l_proc varchar2(72) := g_package || 'get_wb_item_status';
16: l_setu_task_status varchar2(60);
17:
18: BEGIN
19: hr_utility.set_location('Entering:' || l_proc,10);
20:
21: if p_workbench_item_type = 'FUNCTIONAL_AREA' then
22: return '/OA_MEDIA/takeaction_enabled.gif';
23: else
22: return '/OA_MEDIA/takeaction_enabled.gif';
23: else
24: return NULL;
25: end if;
26: hr_utility.set_location('Leaving:' || l_proc,20);
27:
28: EXCEPTION
29: when others then
30: hr_utility.set_location(l_proc,30);
26: hr_utility.set_location('Leaving:' || l_proc,20);
27:
28: EXCEPTION
29: when others then
30: hr_utility.set_location(l_proc,30);
31: fnd_message.raise_error;
32: END;
33:
34: --------------------------------------------------------------------
66: l_not_started varchar2(1):= 'N';
67: l_not_applicable varchar2(1):= 'N';
68:
69: BEGIN
70: hr_utility.set_location('Entering:' || l_proc,10);
71:
72: --------------------------------------------------------------------
73: -- If any task is 'In Progress' then the main status will also be
74: -- In Progress'.
135: else
136: l_workbench_item_status_image := '/OA_MEDIA/notapplicableind_status.gif';
137:
138: end if;
139: hr_utility.set_location('Leaving:' || l_proc,20);
140: return l_workbench_item_status_image;
141: else
142: hr_utility.set_location('Leaving:' || l_proc,30);
143: return null;
138: end if;
139: hr_utility.set_location('Leaving:' || l_proc,20);
140: return l_workbench_item_status_image;
141: else
142: hr_utility.set_location('Leaving:' || l_proc,30);
143: return null;
144: end if;
145: EXCEPTION
146: when others then
143: return null;
144: end if;
145: EXCEPTION
146: when others then
147: hr_utility.set_location(l_proc,40);
148: fnd_message.raise_error;
149: END;
150:
151: function get_item_notes_image (p_workbench_item_code in varchar2
155: l_proc varchar2(72) := g_package || 'get_wb_item_status';
156: l_item_status varchar2(60);
157:
158: BEGIN
159: hr_utility.set_location('Entering:' || l_proc,10);
160:
161: if p_workbench_item_type = 'FUNCTIONAL_AREA' then
162: return '/OA_MEDIA/attachments_toggleattach.gif';
163: else
164: return NULL;
165: end if;
166: EXCEPTION
167: when others then
168: hr_utility.set_location(l_proc,30);
169: fnd_message.raise_error;
170: END get_item_notes_image;
171:
172: ----
182: l_proc varchar2(72) := g_package || 'get_item_last_modified_date';
183: l_item_last_modified_date varchar2(60);
184:
185: BEGIN
186: hr_utility.set_location('Entering:' || l_proc,10);
187:
188: open csr_modified_date(p_workbench_item_code);
189: fetch csr_modified_date into l_item_last_modified_date;
190: close csr_modified_date;