DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_DML_PKG dependencies on PAY_JP_ISDF_SPOUSE_INC_V

Line 559: p_rec out nocopy pay_jp_isdf_spouse_inc_v%rowtype)

555: -- -------------------------------------------------------------------------
556: procedure lock_spouse_inc(
557: p_action_information_id in number,
558: p_object_version_number in number,
559: p_rec out nocopy pay_jp_isdf_spouse_inc_v%rowtype)
560: is
561: l_proc varchar2(80) := c_package||'lock_spouse_inc';
562: begin
563: --

Line 570: from pay_jp_isdf_spouse_inc_v

566: end if;
567: --
568: select *
569: into p_rec
570: from pay_jp_isdf_spouse_inc_v
571: where action_information_id = p_action_information_id
572: for update nowait;
573: --
574: if p_rec.object_version_number <> p_object_version_number then

Line 2777: l_rec pay_jp_isdf_spouse_inc_v%rowtype;

2773: p_sp_other_income_exp_dct in number,
2774: p_sp_other_income_exp_temp in number,
2775: p_sp_other_income_exp_temp_exp in number)
2776: is
2777: l_rec pay_jp_isdf_spouse_inc_v%rowtype;
2778: l_proc varchar2(80) := c_package||'update_spouse_inc';
2779: begin
2780: --
2781: if g_debug then

Line 2828: l_rec pay_jp_isdf_spouse_inc_v%rowtype;

2824: procedure delete_spouse_inc(
2825: p_action_information_id in number,
2826: p_object_version_number in number)
2827: is
2828: l_rec pay_jp_isdf_spouse_inc_v%rowtype;
2829: l_proc varchar2(80) := c_package||'delete_spouse_inc';
2830: begin
2831: --
2832: if g_debug then