APPS.PAY_JP_ISDF_DML_PKG dependencies on PAY_JP_ISDF_LIFE_GEN_V

Line 238: p_rec out nocopy pay_jp_isdf_life_gen_v%rowtype)

234: -- -------------------------------------------------------------------------
235: procedure lock_life_gen(
236: p_action_information_id in number,
237: p_object_version_number in number,
238: p_rec out nocopy pay_jp_isdf_life_gen_v%rowtype)
239: is
240: l_proc varchar2(80) := c_package||'lock_life_gen';
241: begin
242: --

Line 249: from pay_jp_isdf_life_gen_v

245: end if;
246: --
247: select *
248: into p_rec
249: from pay_jp_isdf_life_gen_v
250: where action_information_id = p_action_information_id
251: for update nowait;
252: --
253: if p_rec.object_version_number <> p_object_version_number then

Line 1339: l_rec pay_jp_isdf_life_gen_v%rowtype;

1335: p_beneficiary_name in varchar2,
1336: p_beneficiary_relship in varchar2,
1337: p_annual_prem in number)
1338: is
1339: l_rec pay_jp_isdf_life_gen_v%rowtype;
1340: l_proc varchar2(80) := c_package||'update_life_gen';
1341: begin
1342: --
1343: if g_debug then

Line 1380: l_rec pay_jp_isdf_life_gen_v%rowtype;

1376: procedure delete_life_gen(
1377: p_action_information_id in number,
1378: p_object_version_number in number)
1379: is
1380: l_rec pay_jp_isdf_life_gen_v%rowtype;
1381: l_proc varchar2(80) := c_package||'delete_life_gen';
1382: begin
1383: --
1384: if g_debug then