32: numvalue Wf_Engine.NumTabTyp;
33: --
34: BEGIN
35: l_proc:= 'per_ckl_fyi_notifications.start_wf_process';
36: hr_utility.set_location('Entering: '|| l_proc, 10);
37: --
38: l_item_type := 'HRCKLFYI';
39: l_item_key := 'ChecklistTask:'||p_task_id||':'||CURRENT_TIMESTAMP;
40: l_process := 'CHECKLISTNOTIFIERPROCESS';
112: );
113: --
114: COMMIT;
115: --
116: hr_utility.set_location('Leaving: '|| l_proc, 20);
117: --
118: EXCEPTION
119: --
120: WHEN OTHERS THEN
118: EXCEPTION
119: --
120: WHEN OTHERS THEN
121: --
122: hr_utility.set_location('Leaving: '|| l_proc, 30);
123: hr_utility.set_location(SQLERRM, 35);
124: RAISE;
125: END start_wf_process;
126: --
119: --
120: WHEN OTHERS THEN
121: --
122: hr_utility.set_location('Leaving: '|| l_proc, 30);
123: hr_utility.set_location(SQLERRM, 35);
124: RAISE;
125: END start_wf_process;
126: --
127: PROCEDURE which_notification(itemtype IN VARCHAR2
134: l_proc VARCHAR2(50);
135: --
136: BEGIN
137: l_proc:= 'per_ckl_fyi_notifications.which_notification';
138: hr_utility.set_location('Entering: '|| l_proc, 10);
139: --
140: IF funcmode = 'RUN' THEN
141: resultout := Wf_Engine.GetItemAttrText(itemtype => itemtype
142: ,itemkey => itemkey
144: ,ignore_notfound => FALSE
145: );
146: END IF;
147: --
148: hr_utility.set_location('Leaving: '|| l_proc, 20);
149: --
150: EXCEPTION
151: --
152: WHEN OTHERS THEN
150: EXCEPTION
151: --
152: WHEN OTHERS THEN
153: --
154: hr_utility.set_location('Leaving: '|| l_proc, 30);
155: hr_utility.set_location(SQLERRM, 35);
156: RAISE;
157: END which_notification;
158: --
151: --
152: WHEN OTHERS THEN
153: --
154: hr_utility.set_location('Leaving: '|| l_proc, 30);
155: hr_utility.set_location(SQLERRM, 35);
156: RAISE;
157: END which_notification;
158: --
159: END per_ckl_fyi_notifications;