DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_DML_PKG dependencies on PAY_JP_ISDF_SPOUSE_INC_V

Line 478: p_rec out nocopy pay_jp_isdf_spouse_inc_v%rowtype)

474: -- -------------------------------------------------------------------------
475: procedure lock_spouse_inc(
476: p_action_information_id in number,
477: p_object_version_number in number,
478: p_rec out nocopy pay_jp_isdf_spouse_inc_v%rowtype)
479: is
480: l_proc varchar2(80) := c_package||'lock_spouse_inc';
481: begin
482: --

Line 489: from pay_jp_isdf_spouse_inc_v

485: end if;
486: --
487: select *
488: into p_rec
489: from pay_jp_isdf_spouse_inc_v
490: where action_information_id = p_action_information_id
491: for update nowait;
492: --
493: if p_rec.object_version_number <> p_object_version_number then

Line 2381: l_rec pay_jp_isdf_spouse_inc_v%rowtype;

2377: p_sp_other_income_exp_dct in number,
2378: p_sp_other_income_exp_temp in number,
2379: p_sp_other_income_exp_temp_exp in number)
2380: is
2381: l_rec pay_jp_isdf_spouse_inc_v%rowtype;
2382: l_proc varchar2(80) := c_package||'update_spouse_inc';
2383: begin
2384: --
2385: if g_debug then

Line 2432: l_rec pay_jp_isdf_spouse_inc_v%rowtype;

2428: procedure delete_spouse_inc(
2429: p_action_information_id in number,
2430: p_object_version_number in number)
2431: is
2432: l_rec pay_jp_isdf_spouse_inc_v%rowtype;
2433: l_proc varchar2(80) := c_package||'delete_spouse_inc';
2434: begin
2435: --
2436: if g_debug then