14: -- ----------------------------------------------------------------------------
15: Procedure synchronize_index(p_mode in varchar2)
16: is
17: l_proc varchar2(72) := g_package||'synchronize_index';
18: l_hr_username fnd_oracle_userid.oracle_username%TYPE :=null ;
19: cursor csr_user is
20: select oracle_username
21: from fnd_oracle_userid
22: where oracle_id = 800;
17: l_proc varchar2(72) := g_package||'synchronize_index';
18: l_hr_username fnd_oracle_userid.oracle_username%TYPE :=null ;
19: cursor csr_user is
20: select oracle_username
21: from fnd_oracle_userid
22: where oracle_id = 800;
23: begin
24: hr_utility.set_location('Entering:'|| l_proc, 10);
25: open csr_user;