DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_DML_PKG dependencies on PAY_JP_ISDF_LIFE_GEN_V

Line 278: p_rec out nocopy pay_jp_isdf_life_gen_v%rowtype)

274: -- -------------------------------------------------------------------------
275: procedure lock_life_gen(
276: p_action_information_id in number,
277: p_object_version_number in number,
278: p_rec out nocopy pay_jp_isdf_life_gen_v%rowtype)
279: is
280: l_proc varchar2(80) := c_package||'lock_life_gen';
281: begin
282: --

Line 289: from pay_jp_isdf_life_gen_v

285: end if;
286: --
287: select *
288: into p_rec
289: from pay_jp_isdf_life_gen_v
290: where action_information_id = p_action_information_id
291: for update nowait;
292: --
293: if p_rec.object_version_number <> p_object_version_number then

Line 1551: l_rec pay_jp_isdf_life_gen_v%rowtype;

1547: p_beneficiary_relship in varchar2,
1548: p_annual_prem in number,
1549: p_ins_old_new in varchar2)
1550: is
1551: l_rec pay_jp_isdf_life_gen_v%rowtype;
1552: l_proc varchar2(80) := c_package||'update_life_gen';
1553: begin
1554: --
1555: if g_debug then

Line 1593: l_rec pay_jp_isdf_life_gen_v%rowtype;

1589: procedure delete_life_gen(
1590: p_action_information_id in number,
1591: p_object_version_number in number)
1592: is
1593: l_rec pay_jp_isdf_life_gen_v%rowtype;
1594: l_proc varchar2(80) := c_package||'delete_life_gen';
1595: begin
1596: --
1597: if g_debug then