DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_DML_PKG dependencies on PAY_JP_ISDF_SOCIAL_V

Line 358: p_rec out nocopy pay_jp_isdf_social_v%rowtype)

354: -- -------------------------------------------------------------------------
355: procedure lock_social(
356: p_action_information_id in number,
357: p_object_version_number in number,
358: p_rec out nocopy pay_jp_isdf_social_v%rowtype)
359: is
360: l_proc varchar2(80) := c_package||'lock_social';
361: begin
362: --

Line 369: from pay_jp_isdf_social_v

365: end if;
366: --
367: select *
368: into p_rec
369: from pay_jp_isdf_social_v
370: where action_information_id = p_action_information_id
371: for update nowait;
372: --
373: if p_rec.object_version_number <> p_object_version_number then

Line 1852: l_rec pay_jp_isdf_social_v%rowtype;

1848: p_beneficiary_relship in varchar2,
1849: p_annual_prem in number,
1850: p_national_pens_flag in varchar2)
1851: is
1852: l_rec pay_jp_isdf_social_v%rowtype;
1853: l_proc varchar2(80) := c_package||'update_social';
1854: begin
1855: --
1856: if g_debug then

Line 1892: l_rec pay_jp_isdf_social_v%rowtype;

1888: procedure delete_social(
1889: p_action_information_id in number,
1890: p_object_version_number in number)
1891: is
1892: l_rec pay_jp_isdf_social_v%rowtype;
1893: l_proc varchar2(80) := c_package||'delete_social';
1894: begin
1895: --
1896: if g_debug then