[Home] [Help]
241: ** Procedure SELECT_APPROVER is called by "Select Approver" activity in the
242: ** distribution adjustment workflow process.
243: ** By default, the supervisor is the approver.
244: ** If customization is needed, enter your code in
245: ** PSP_WF_ADJ_CUSTOM.select_approver_custom.
246: ****************************************************************************/
247: PROCEDURE select_approver(itemtype IN VARCHAR2,
248: itemkey IN VARCHAR2,
249: actid IN NUMBER,
273: ** person ID call get_supervisor():
274: ** l_supervisor_id := get_supervisor(l_person_id, assignment_number);
275: ** However, if the approver is not the employee's supervisor, we need
276: ** to customize the program to select the approver.
277: ** Customize code can be entered in psp_wf_adj_custom.select_approver_custom
278: ** procedure and returns the appropriate supervisior id.
279: **---------------------------------------------------------------------*/
280:
281: l_supervisor_id := get_supervisor(l_person_id, l_assignment_number);
289: --for customization purpose
290: -- two standard value person_id and assignment_number is passed
291: -- If more values are required user can get from workflow .
292: -- All internal names are given in the custom package.
293: psp_wf_adj_custom.select_approver_custom(itemtype,
294: itemkey,
295: actid,
296: funcmode,
297: l_person_id,
523: ** required and the value is set to N.
524: ** If the value is set to 'Y' then adjustment will directly be approved
525: ** and ready for S and T.
526: ** Customization code can be put in
527: ** psp_wf_adj_custom.omit_approval_custom.
528: **************************************************************************/
529: PROCEDURE omit_approval (itemtype IN VARCHAR2,
530: itemkey IN VARCHAR2,
531: actid IN NUMBER,
533: result OUT NOCOPY VARCHAR2)
534: IS
535: p_omit_approval VARCHAR2(1);
536: BEGIN
537: psp_wf_adj_custom.omit_approval_custom
538: (itemtype,
539: itemkey,
540: actid,
541: funcmode,
552: /****************************************************************************
553: ** This procedure record creator as approver in case of OMIT_APPROVAL returns Y
554: ** means approval is not required from approver. At present approver is creator.
555: ** If customization is required please enter your code in
556: ** psp_wf_adj_custom.record_creator_custom package.
557: ******************************************************************************/
558: PROCEDURE record_creator (itemtype IN VARCHAR2,
559: itemkey IN VARCHAR2,
560: actid IN NUMBER,
591: l_comments := wf_engine.GetItemAttrText(itemtype => itemtype,
592: itemkey => itemkey,
593: aname => 'NOTE');
594:
595: psp_wf_adj_custom.record_creator_custom(
596: itemtype,
597: itemkey,
598: actid,
599: funcmode,