114: -- -------------------------------------------------------------------------
115: procedure lock_emp(
116: p_action_information_id in number,
117: p_object_version_number in number,
118: p_rec out nocopy pay_jp_isdf_emp_v%rowtype)
119: is
120: l_proc varchar2(80) := c_package||'lock_emp';
121: begin
122: --
125: end if;
126: --
127: select *
128: into p_rec
129: from pay_jp_isdf_emp_v
130: where action_information_id = p_action_information_id
131: for update nowait;
132: --
133: if p_rec.object_version_number <> p_object_version_number then
896: p_object_version_number in out nocopy number,
897: p_postal_code in varchar2,
898: p_address in varchar2)
899: is
900: l_rec pay_jp_isdf_emp_v%rowtype;
901: l_proc varchar2(80) := c_package||'update_emp';
902: begin
903: --
904: if g_debug then