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
815: p_object_version_number in out nocopy number,
816: p_postal_code in varchar2,
817: p_address in varchar2)
818: is
819: l_rec pay_jp_isdf_emp_v%rowtype;
820: l_proc varchar2(80) := c_package||'update_emp';
821: begin
822: --
823: if g_debug then