[Home] [Help]
52:
53: -- Cursor to FETCH user id FROM user name
54: CURSOR c_userid (p_username VARCHAR2) IS
55: SELECT user_id, employee_id
56: FROM fnd_user
57: WHERE user_name = p_username;
58:
59: --
60: --
679: l_hierarchy_version_id per_pos_structure_versions.pos_structure_version_id%TYPE;
680: l_hierarchy_id per_position_structures.position_structure_id%TYPE;
681: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
682: l_organization_id hr_all_positions_f.organization_id%TYPE;
683: l_current_user_name fnd_user.user_name%TYPE;
684:
685: cur_pos_not_found EXCEPTION ;
686: pos_hier_not_found EXCEPTION ;
687: pos_hier_ver_not_found EXCEPTION ;
699: hap.organization_id,
700: fu.user_name
701: FROM hr_all_positions_f hap,
702: per_all_assignments_f paa,
703: fnd_user fu ,
704: per_people_f p,
705: per_periods_of_service b
706: WHERE
707: fu.user_id = g_userid
1764: l_local_table Wf_Directory.Usertable;
1765: l_size NUMBER;
1766: l_list VARCHAR2(1000) := 'ALL';
1767:
1768: l_user_name fnd_user.user_name%TYPE;
1769:
1770: l_next_position per_positions.name%TYPE
1771: := Wf_Engine.GetItemAttrText( itemtype => itemtype,
1772: itemkey => itemkey,
1791: IS
1792: select fu.user_name user_name
1793: FROM hr_all_positions_f hap,
1794: per_all_assignments_f paa,
1795: fnd_user fu ,
1796: per_people_f p,
1797: per_periods_of_service b
1798: WHERE
1799: paa.person_id = p.person_id
2820: ( itemtype => itemtype,
2821: itemkey => itemkey,
2822: aname => 'USER_ID');
2823:
2824: CURSOR c_emp_id (p_user_id fnd_user.user_id%TYPE)
2825: IS
2826: SELECT employee_id
2827: FROM fnd_user
2828: WHERE user_id = p_user_id;
2823:
2824: CURSOR c_emp_id (p_user_id fnd_user.user_id%TYPE)
2825: IS
2826: SELECT employee_id
2827: FROM fnd_user
2828: WHERE user_id = p_user_id;
2829:
2830: BEGIN
2831: