219: IF (action_type = 'ApproveFinish' OR action_type = 'Finish')
220: THEN
221:
222: ln_notification_id :=
223: wf_notification.send (ROLE => to_role,
224: msg_type => 'HRWPM',
225: msg_name => 'HR_WPM_MGR_TO_EMP_APPROVE',
226: callback => NULL,
227: CONTEXT => NULL,
227: CONTEXT => NULL,
228: send_comment => NULL,
229: priority => 50
230: );
231: wf_notification.setattrtext (ln_notification_id, 'MGR_NAME', from_name);
232: wf_notification.setattrtext (ln_notification_id, 'SCORECARD_NAME',
233: l_sc_info.scorecard_name);
234:
235: ELSIF action_type = 'Reject'
228: send_comment => NULL,
229: priority => 50
230: );
231: wf_notification.setattrtext (ln_notification_id, 'MGR_NAME', from_name);
232: wf_notification.setattrtext (ln_notification_id, 'SCORECARD_NAME',
233: l_sc_info.scorecard_name);
234:
235: ELSIF action_type = 'Reject'
236: THEN
235: ELSIF action_type = 'Reject'
236: THEN
237:
238: ln_notification_id :=
239: wf_notification.send (ROLE => to_role,
240: msg_type => 'HRWPM',
241: msg_name => 'HR_WPM_MGR_TO_EMP_REJECT',
242: callback => NULL,
243: CONTEXT => NULL,
243: CONTEXT => NULL,
244: send_comment => NULL,
245: priority => 50
246: );
247: wf_notification.setattrtext (ln_notification_id, 'MGR_NAME', from_name);
248: wf_notification.setattrtext (ln_notification_id, 'SCORECARD_NAME',
249: l_sc_info.scorecard_name);
250:
251: -- 5570064 Changes Transfer from Java Layer Start
244: send_comment => NULL,
245: priority => 50
246: );
247: wf_notification.setattrtext (ln_notification_id, 'MGR_NAME', from_name);
248: wf_notification.setattrtext (ln_notification_id, 'SCORECARD_NAME',
249: l_sc_info.scorecard_name);
250:
251: -- 5570064 Changes Transfer from Java Layer Start
252: ELSIF action_type = 'Transfer'
260:
261: --Block uncommented for Bug#13881019
262:
263: ln_notification_id :=
264: wf_notification.send (ROLE => to_role,
265: msg_type => 'HRWPM',
266: msg_name => 'HR_WPM_MGR_TO_EMP_TRNSF',
267: callback => NULL,
268: CONTEXT => NULL,
268: CONTEXT => NULL,
269: send_comment => NULL,
270: priority => 50
271: );
272: wf_notification.setattrtext (ln_notification_id, 'MGR_NAME', from_name);
273: wf_notification.setattrtext (ln_notification_id, 'SCORECARD_NAME',
274: l_sc_info.scorecard_name);
275:
276:
269: send_comment => NULL,
270: priority => 50
271: );
272: wf_notification.setattrtext (ln_notification_id, 'MGR_NAME', from_name);
273: wf_notification.setattrtext (ln_notification_id, 'SCORECARD_NAME',
274: l_sc_info.scorecard_name);
275:
276:
277: -- 5570064 Changes Transfer from Java Layer End
279: ELSIF action_type = 'RequestAction'
280: THEN
281:
282: ln_notification_id :=
283: wf_notification.send (ROLE => to_role,
284: msg_type => 'HRWPM',
285: msg_name => 'HR_WPM_NTF_REQUEST_ACTION',
286: callback => NULL,
287: CONTEXT => NULL,
287: CONTEXT => NULL,
288: send_comment => NULL,
289: priority => 50
290: );
291: wf_notification.setattrtext (ln_notification_id, 'MGR_NAME', from_name);
292: wf_notification.setattrtext (ln_notification_id, 'SCORECARD_NAME',
293: l_sc_info.scorecard_name);
294: END IF;
295:
288: send_comment => NULL,
289: priority => 50
290: );
291: wf_notification.setattrtext (ln_notification_id, 'MGR_NAME', from_name);
292: wf_notification.setattrtext (ln_notification_id, 'SCORECARD_NAME',
293: l_sc_info.scorecard_name);
294: END IF;
295:
296: tlnt_mgmt_rel_apps_fn := 'HR_WPM_MGR_REL_APPS_SS';
296: tlnt_mgmt_rel_apps_fn := 'HR_WPM_MGR_REL_APPS_SS';
297: ELSIF (to_or_from_mgr_ntf = 'EMP_TO_MGR')
298: THEN
299: ln_notification_id :=
300: wf_notification.send (ROLE => to_role,
301: msg_type => 'HRWPM',
302: msg_name => 'HR_WPM_EMP_TO_MGR_APR',
303: callback => NULL,
304: CONTEXT => NULL,
304: CONTEXT => NULL,
305: send_comment => NULL,
306: priority => 50
307: );
308: wf_notification.setattrtext (ln_notification_id, 'EMP_NAME', from_name);
309: wf_notification.setattrtext (ln_notification_id, 'SCORECARD_NAME',
310: l_sc_info.scorecard_name);
311: tlnt_mgmt_rel_apps_fn := 'HR_WPM_EMP_REL_APPS_SS';
312: END IF;
305: send_comment => NULL,
306: priority => 50
307: );
308: wf_notification.setattrtext (ln_notification_id, 'EMP_NAME', from_name);
309: wf_notification.setattrtext (ln_notification_id, 'SCORECARD_NAME',
310: l_sc_info.scorecard_name);
311: tlnt_mgmt_rel_apps_fn := 'HR_WPM_EMP_REL_APPS_SS';
312: END IF;
313:
321: Condition check on notification attributes removed to send notification while
322: transfering scorecard using Set Objectives Action -- Bug#13881019
323: */
324:
325: wf_notification.setattrtext(ln_notification_id,'HR_WPM_SC_REASON', reason);
326:
327: wf_notification.setattrtext (ln_notification_id, '#FROM_ROLE', from_role);
328: --wf_notification.setattrtext (ln_notification_id, '#WFM_FROM', from_name);
329: wf_notification.setattrtext (ln_notification_id, 'HR_WPM_SC_ID', score_card_id);
323: */
324:
325: wf_notification.setattrtext(ln_notification_id,'HR_WPM_SC_REASON', reason);
326:
327: wf_notification.setattrtext (ln_notification_id, '#FROM_ROLE', from_role);
328: --wf_notification.setattrtext (ln_notification_id, '#WFM_FROM', from_name);
329: wf_notification.setattrtext (ln_notification_id, 'HR_WPM_SC_ID', score_card_id);
330: wf_notification.setattrtext (ln_notification_id, 'WHICH_NTF', to_or_from_mgr_ntf);
331: wf_notification.setattrtext (ln_notification_id, 'HR_FROM_WF', 'WF');
324:
325: wf_notification.setattrtext(ln_notification_id,'HR_WPM_SC_REASON', reason);
326:
327: wf_notification.setattrtext (ln_notification_id, '#FROM_ROLE', from_role);
328: --wf_notification.setattrtext (ln_notification_id, '#WFM_FROM', from_name);
329: wf_notification.setattrtext (ln_notification_id, 'HR_WPM_SC_ID', score_card_id);
330: wf_notification.setattrtext (ln_notification_id, 'WHICH_NTF', to_or_from_mgr_ntf);
331: wf_notification.setattrtext (ln_notification_id, 'HR_FROM_WF', 'WF');
332: wf_notification.setattrtext (ln_notification_id, 'HR_PLAN_ID', l_sc_info.plan_id);
325: wf_notification.setattrtext(ln_notification_id,'HR_WPM_SC_REASON', reason);
326:
327: wf_notification.setattrtext (ln_notification_id, '#FROM_ROLE', from_role);
328: --wf_notification.setattrtext (ln_notification_id, '#WFM_FROM', from_name);
329: wf_notification.setattrtext (ln_notification_id, 'HR_WPM_SC_ID', score_card_id);
330: wf_notification.setattrtext (ln_notification_id, 'WHICH_NTF', to_or_from_mgr_ntf);
331: wf_notification.setattrtext (ln_notification_id, 'HR_FROM_WF', 'WF');
332: wf_notification.setattrtext (ln_notification_id, 'HR_PLAN_ID', l_sc_info.plan_id);
333: wf_notification.setattrtext (ln_notification_id, 'HR_ACTION_TYPE', to_or_from_mgr_ntf);
326:
327: wf_notification.setattrtext (ln_notification_id, '#FROM_ROLE', from_role);
328: --wf_notification.setattrtext (ln_notification_id, '#WFM_FROM', from_name);
329: wf_notification.setattrtext (ln_notification_id, 'HR_WPM_SC_ID', score_card_id);
330: wf_notification.setattrtext (ln_notification_id, 'WHICH_NTF', to_or_from_mgr_ntf);
331: wf_notification.setattrtext (ln_notification_id, 'HR_FROM_WF', 'WF');
332: wf_notification.setattrtext (ln_notification_id, 'HR_PLAN_ID', l_sc_info.plan_id);
333: wf_notification.setattrtext (ln_notification_id, 'HR_ACTION_TYPE', to_or_from_mgr_ntf);
334:
327: wf_notification.setattrtext (ln_notification_id, '#FROM_ROLE', from_role);
328: --wf_notification.setattrtext (ln_notification_id, '#WFM_FROM', from_name);
329: wf_notification.setattrtext (ln_notification_id, 'HR_WPM_SC_ID', score_card_id);
330: wf_notification.setattrtext (ln_notification_id, 'WHICH_NTF', to_or_from_mgr_ntf);
331: wf_notification.setattrtext (ln_notification_id, 'HR_FROM_WF', 'WF');
332: wf_notification.setattrtext (ln_notification_id, 'HR_PLAN_ID', l_sc_info.plan_id);
333: wf_notification.setattrtext (ln_notification_id, 'HR_ACTION_TYPE', to_or_from_mgr_ntf);
334:
335: -- END IF;
328: --wf_notification.setattrtext (ln_notification_id, '#WFM_FROM', from_name);
329: wf_notification.setattrtext (ln_notification_id, 'HR_WPM_SC_ID', score_card_id);
330: wf_notification.setattrtext (ln_notification_id, 'WHICH_NTF', to_or_from_mgr_ntf);
331: wf_notification.setattrtext (ln_notification_id, 'HR_FROM_WF', 'WF');
332: wf_notification.setattrtext (ln_notification_id, 'HR_PLAN_ID', l_sc_info.plan_id);
333: wf_notification.setattrtext (ln_notification_id, 'HR_ACTION_TYPE', to_or_from_mgr_ntf);
334:
335: -- END IF;
336: END IF;
329: wf_notification.setattrtext (ln_notification_id, 'HR_WPM_SC_ID', score_card_id);
330: wf_notification.setattrtext (ln_notification_id, 'WHICH_NTF', to_or_from_mgr_ntf);
331: wf_notification.setattrtext (ln_notification_id, 'HR_FROM_WF', 'WF');
332: wf_notification.setattrtext (ln_notification_id, 'HR_PLAN_ID', l_sc_info.plan_id);
333: wf_notification.setattrtext (ln_notification_id, 'HR_ACTION_TYPE', to_or_from_mgr_ntf);
334:
335: -- END IF;
336: END IF;
337: -- Bug 7580480 Fix start