[Home] [Help]
346: l_api_name varchar2(50) := 'GET_NEXT_APPROVER';
347: l_progress VARCHAR2(500) := '000';
348:
349: l_next_approver_id NUMBER;
350: l_next_approver_user_name fnd_user.user_name%TYPE;
351: l_next_approver_disp_name wf_users.display_name%TYPE;
352: l_orig_system wf_users.orig_system%TYPE := 'PER';
353: l_sequence_num NUMBER;
354: l_approver_type VARCHAR2(30);
353: l_sequence_num NUMBER;
354: l_approver_type VARCHAR2(30);
355:
356: l_doc_string varchar2(200);
357: l_preparer_user_name fnd_user.user_name%TYPE;
358: l_org_id number;
359:
360: l_next_approver ame_util.approverRecord;
361: l_insertion_type VARCHAR2(30);
441: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
442: END IF;
443: end if;
444:
445: -- Check whether Position Hierarchy or Employee-Sup Hierarchy setup or FND users.
446: if (g_next_approvers(l_approver_index).orig_system = 'PER') then
447: l_next_approver_id := g_next_approvers(l_approver_index).orig_system_id;
448: elsif (g_next_approvers(l_approver_index).orig_system = 'POS') then
449:
472: g_next_approvers(l_approver_index).orig_system = 'FND_USR') then
473:
474: SELECT employee_id
475: into l_next_approver_id
476: FROM fnd_user
477: WHERE user_id = g_next_approvers(l_approver_index).orig_system_id
478: and trunc(sysdate) between start_date and nvl(end_date, sysdate+1);
479: end if;
480:
585: --
586: -- IN
587: -- suppid - itemkey for workflow (SuppRegId)
588: -- OUT
589: -- user_id - user_id in fnd_user
590: -- user_name - user_name in fnd_user
591: -- user_firstname - the first name of this user
592: -- user_lastname - the last name of this user
593: -- status - S/E
586: -- IN
587: -- suppid - itemkey for workflow (SuppRegId)
588: -- OUT
589: -- user_id - user_id in fnd_user
590: -- user_name - user_name in fnd_user
591: -- user_firstname - the first name of this user
592: -- user_lastname - the last name of this user
593: -- status - S/E
594: -------------------------------------------------------------------------------
641: then
642: begin
643: SELECT fu.user_id, fu.user_name, hp.person_first_name, hp.person_last_name
644: into user_id, user_name, user_firstname, user_lastname
645: FROM fnd_user fu, hz_parties hp
646: WHERE fu.user_name = wf_approver
647: and fu.person_party_id = hp.party_id(+)
648: and rownum = 1;
649: exception
1476: END;
1477:
1478: elsif (l_orig_system = 'FND' OR l_orig_system = 'FND_USR' ) then
1479:
1480: -- FND User Record.
1481: if g_fnd_debug = 'Y' then
1482: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1483: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'FND User Record ...');
1484: END IF;
1479:
1480: -- FND User Record.
1481: if g_fnd_debug = 'Y' then
1482: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1483: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'FND User Record ...');
1484: END IF;
1485: end if;
1486:
1487: SELECT employee_id into l_person_id
1484: END IF;
1485: end if;
1486:
1487: SELECT employee_id into l_person_id
1488: FROM fnd_user
1489: WHERE user_id = l_orig_system_id
1490: and trunc(sysdate) between start_date and nvl(end_date, sysdate+1);
1491:
1492: l_full_name := approverList(i).display_name;
1713: then
1714: begin
1715: SELECT hp.person_first_name, hp.person_last_name
1716: into user_firstname, user_lastname
1717: FROM fnd_user fu, hz_parties hp
1718: WHERE fu.user_name = wf_approver
1719: and fu.person_party_id = hp.party_id(+)
1720: and rownum = 1;
1721: