[Home] [Help]
46: l_document_id NUMBER;
47: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
48: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
49: l_next_approver_id NUMBER;
50: l_next_approver_user_name fnd_user.user_name%TYPE;
51: l_next_approver_disp_name wf_users.display_name%TYPE;
52: l_orig_system wf_users.orig_system%TYPE := 'PER';
53: l_sequence_num NUMBER;
54: l_approver_type VARCHAR2(30);
53: l_sequence_num NUMBER;
54: l_approver_type VARCHAR2(30);
55:
56: l_doc_string varchar2(200);
57: l_preparer_user_name fnd_user.user_name%TYPE;
58: l_org_id number;
59:
60: l_next_approver ame_util.approverRecord;
61: l_insertion_type VARCHAR2(30);
243: t_varname Wf_Engine.NameTabTyp;
244: t_varval Wf_Engine.TextTabTyp;
245:
246: l_no_positionholder exception;
247: l_preparer_user_name fnd_user.user_name%TYPE;
248: l_doc_string varchar2(200);
249: l_start_block_activity varchar2(1);
250: l_approver_index NUMBER;
251: l_change_request_group_id NUMBER;
390: IF (g_po_wf_debug = 'Y') THEN
391: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
392: END IF;
393:
394: -- Check whether Position Hierarchy or Employee-Sup Hierarchy setup or FND users.
395: if (g_next_approvers(l_approver_index).orig_system = 'PER') then
396: l_next_approver_id := g_next_approvers(l_approver_index).orig_system_id;
397: elsif (g_next_approvers(l_approver_index).orig_system = 'POS') then
398:
436:
437: elsif (g_next_approvers(l_approver_index).orig_system = 'FND') then
438: SELECT employee_id
439: into l_next_approver_id
440: FROM fnd_user
441: WHERE user_id = g_next_approvers(l_approver_index).orig_system_id
442: and trunc(sysdate) between start_date and nvl(end_date, sysdate+1);
443: end if;
444: