DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_DML_PKG dependencies on PAY_JP_ISDF_LIFE_PENS_V

Line 278: p_rec out nocopy pay_jp_isdf_life_pens_v%rowtype)

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

Line 289: from pay_jp_isdf_life_pens_v

285: end if;
286: --
287: select *
288: into p_rec
289: from pay_jp_isdf_life_pens_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 1514: l_rec pay_jp_isdf_life_pens_v%rowtype;

1510: p_beneficiary_name in varchar2,
1511: p_beneficiary_relship in varchar2,
1512: p_annual_prem in number)
1513: is
1514: l_rec pay_jp_isdf_life_pens_v%rowtype;
1515: l_proc varchar2(80) := c_package||'update_life_pens';
1516: begin
1517: --
1518: if g_debug then

Line 1556: l_rec pay_jp_isdf_life_pens_v%rowtype;

1552: procedure delete_life_pens(
1553: p_action_information_id in number,
1554: p_object_version_number in number)
1555: is
1556: l_rec pay_jp_isdf_life_pens_v%rowtype;
1557: l_proc varchar2(80) := c_package||'delete_life_pens';
1558: begin
1559: --
1560: if g_debug then