DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_DML_PKG dependencies on PAY_JP_ISDF_CARE_MED_V

Line 318: p_rec out nocopy pay_jp_isdf_care_med_v%rowtype)

314: -- -------------------------------------------------------------------------
315: procedure lock_care_med(
316: p_action_information_id in number,
317: p_object_version_number in number,
318: p_rec out nocopy pay_jp_isdf_care_med_v%rowtype)
319: is
320: l_proc varchar2(80) := c_package||'lock_care_med';
321: begin
322: --

Line 329: from pay_jp_isdf_care_med_v

325: end if;
326: --
327: select *
328: into p_rec
329: from pay_jp_isdf_care_med_v
330: where action_information_id = p_action_information_id
331: for update nowait;
332: --
333: if p_rec.object_version_number <> p_object_version_number then

Line 1728: l_rec pay_jp_isdf_care_med_v%rowtype;

1724: p_beneficiary_relship in varchar2,
1725: p_annual_prem in number,
1726: p_ins_old_new in varchar2)
1727: is
1728: l_rec pay_jp_isdf_care_med_v%rowtype;
1729: l_proc varchar2(80) := c_package||'update_care_med';
1730: begin
1731: --
1732: if g_debug then

Line 1770: l_rec pay_jp_isdf_care_med_v%rowtype;

1766: procedure delete_care_med(
1767: p_action_information_id in number,
1768: p_object_version_number in number)
1769: is
1770: l_rec pay_jp_isdf_care_med_v%rowtype;
1771: l_proc varchar2(80) := c_package||'delete_care_med';
1772: begin
1773: --
1774: if g_debug then