APPS.PAY_JP_ISDF_DML_PKG dependencies on PAY_JP_ISDF_SPOUSE_V

Line 519: p_rec out nocopy pay_jp_isdf_spouse_v%rowtype)

515: -- -------------------------------------------------------------------------
516: procedure lock_spouse(
517: p_action_information_id in number,
518: p_object_version_number in number,
519: p_rec out nocopy pay_jp_isdf_spouse_v%rowtype)
520: is
521: l_proc varchar2(80) := c_package||'lock_spouse';
522: begin
523: --

Line 530: from pay_jp_isdf_spouse_v

526: end if;
527: --
528: select *
529: into p_rec
530: from pay_jp_isdf_spouse_v
531: where action_information_id = p_action_information_id
532: for update nowait;
533: --
534: if p_rec.object_version_number <> p_object_version_number then

Line 2571: l_rec pay_jp_isdf_spouse_v%rowtype;

2567: p_widow_type in varchar2,
2568: p_spouse_dct_exclude in varchar2,
2569: p_spouse_income_entry in number)
2570: is
2571: l_rec pay_jp_isdf_spouse_v%rowtype;
2572: l_proc varchar2(80) := c_package||'update_spouse';
2573: begin
2574: --
2575: if g_debug then

Line 2618: l_rec pay_jp_isdf_spouse_v%rowtype;

2614: procedure delete_spouse(
2615: p_action_information_id in number,
2616: p_object_version_number in number)
2617: is
2618: l_rec pay_jp_isdf_spouse_v%rowtype;
2619: l_proc varchar2(80) := c_package||'delete_spouse';
2620: begin
2621: --
2622: if g_debug then