DBA Data[Home] [Help]

APPS.HR_SESSION_UTILITIES dependencies on PER_PEOPLE_F

Line 9: g_loggedin_user per_people_f%ROWTYPE;

5: -- ----------------------------------------------------------------------------
6: g_today DATE;
7: g_today_txt VARCHAR2 (200);
8: g_today_set BOOLEAN;
9: g_loggedin_user per_people_f%ROWTYPE;
10: l_val_person_id per_people_f.person_id%TYPE;
11: g_do_process BOOLEAN;
12: --2721758
13: g_debug boolean := hr_utility.debug_enabled;

Line 10: l_val_person_id per_people_f.person_id%TYPE;

6: g_today DATE;
7: g_today_txt VARCHAR2 (200);
8: g_today_set BOOLEAN;
9: g_loggedin_user per_people_f%ROWTYPE;
10: l_val_person_id per_people_f.person_id%TYPE;
11: g_do_process BOOLEAN;
12: --2721758
13: g_debug boolean := hr_utility.debug_enabled;
14: -- ----------------------------------------------------------------------------

Line 18: RETURN per_people_f%ROWTYPE

14: -- ----------------------------------------------------------------------------
15: -- |--< Get_LoggedIn_User >---------------------------------------------------|
16: -- ----------------------------------------------------------------------------
17: FUNCTION Get_LoggedIn_User
18: RETURN per_people_f%ROWTYPE
19: IS
20: l_person_id per_people_f.person_id%TYPE;
21: --
22: l_proc VARCHAR2 (72) ;

Line 20: l_person_id per_people_f.person_id%TYPE;

16: -- ----------------------------------------------------------------------------
17: FUNCTION Get_LoggedIn_User
18: RETURN per_people_f%ROWTYPE
19: IS
20: l_person_id per_people_f.person_id%TYPE;
21: --
22: l_proc VARCHAR2 (72) ;
23: BEGIN
24: g_debug := hr_utility.debug_enabled;

Line 141: l_person_id per_people_f.person_id%type;

137: -- removes the fnd session row created by insert_session_row
138: -- ------------------------------------------------------------------------
139: PROCEDURE remove_session_row
140: IS
141: l_person_id per_people_f.person_id%type;
142: --
143: l_proc VARCHAR2 (72) := g_package || ' remove_session_row';
144: BEGIN
145: g_debug := hr_utility.debug_enabled;

Line 231: l_person_id per_people_f.person_id%type;

227: ,p_icx_update in boolean default true -- 10/15/97 Changed
228: ,p_icx_commit in boolean default false) IS -- 10/15/97 Changed
229: --
230: l_web_username varchar2(80) default null;
231: l_person_id per_people_f.person_id%type;
232: l_proc VARCHAR2 (72) ;
233: BEGIN
234:
235: IF g_debug THEN

Line 281: l_person_id per_people_f.person_id%type;

277: l_web_user_id number;
278: l_web_username varchar2(80) default null;
279:
280: l_cookie owa_cookie.cookie;
281: l_person_id per_people_f.person_id%type;
282: l_hr_installation_status fnd_product_installations.status%TYPE
283: DEFAULT NULL;
284: --
285: --