[Home] [Help]
46:
47: -- Cursor to FETCH user id FROM user name
48: CURSOR c_userid (p_username VARCHAR2) IS
49: SELECT user_id, employee_id
50: FROM fnd_user
51: WHERE user_name = p_username;
52:
53: --
54: --
664: l_hierarchy_version_id per_pos_structure_versions.pos_structure_version_id%TYPE;
665: l_hierarchy_id per_position_structures.position_structure_id%TYPE;
666: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
667: l_organization_id hr_all_positions_f.organization_id%TYPE;
668: l_current_user_name fnd_user.user_name%TYPE;
669:
670: cur_pos_not_found EXCEPTION ;
671: pos_hier_not_found EXCEPTION ;
672: pos_hier_ver_not_found EXCEPTION ;
684: hap.organization_id,
685: fu.user_name
686: FROM hr_all_positions_f hap,
687: per_all_assignments_f paa,
688: fnd_user fu ,
689: per_people_f p,
690: per_periods_of_service b
691: WHERE
692: fu.user_id = g_userid
1693: l_local_table Wf_Directory.Usertable;
1694: l_size NUMBER;
1695: l_list VARCHAR2(1000) := 'ALL';
1696:
1697: l_user_name fnd_user.user_name%TYPE;
1698:
1699: l_next_position per_positions.name%TYPE
1700: := Wf_Engine.GetItemAttrText( itemtype => itemtype,
1701: itemkey => itemkey,
1720: IS
1721: select fu.user_name user_name
1722: FROM hr_all_positions_f hap,
1723: per_all_assignments_f paa,
1724: fnd_user fu ,
1725: per_people_f p,
1726: per_periods_of_service b
1727: WHERE
1728: paa.person_id = p.person_id
2686: ( itemtype => itemtype,
2687: itemkey => itemkey,
2688: aname => 'USER_ID');
2689:
2690: CURSOR c_emp_id (p_user_id fnd_user.user_id%TYPE)
2691: IS
2692: SELECT employee_id
2693: FROM fnd_user
2694: WHERE user_id = p_user_id;
2689:
2690: CURSOR c_emp_id (p_user_id fnd_user.user_id%TYPE)
2691: IS
2692: SELECT employee_id
2693: FROM fnd_user
2694: WHERE user_id = p_user_id;
2695:
2696: BEGIN
2697: