DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_DML_PKG dependencies on PAY_JP_ISDF_CALC_DCT_V

Line 198: p_rec out nocopy pay_jp_isdf_calc_dct_v%rowtype)

194: -- -------------------------------------------------------------------------
195: procedure lock_calc_dct(
196: p_action_information_id in number,
197: p_object_version_number in number,
198: p_rec out nocopy pay_jp_isdf_calc_dct_v%rowtype)
199: is
200: l_proc varchar2(80) := c_package||'lock_calc_dct';
201: begin
202: --

Line 209: from pay_jp_isdf_calc_dct_v

205: end if;
206: --
207: select *
208: into p_rec
209: from pay_jp_isdf_calc_dct_v
210: where action_information_id = p_action_information_id
211: for update nowait;
212: --
213: if p_rec.object_version_number <> p_object_version_number then

Line 238: p_rec out nocopy pay_jp_isdf_calc_dct_v2%rowtype)

234: -- -------------------------------------------------------------------------
235: procedure lock_calc_dct2(
236: p_action_information_id in number,
237: p_object_version_number in number,
238: p_rec out nocopy pay_jp_isdf_calc_dct_v2%rowtype)
239: is
240: l_proc varchar2(80) := c_package||'lock_calc_dct2';
241: begin
242: --

Line 249: from pay_jp_isdf_calc_dct_v2

245: end if;
246: --
247: select *
248: into p_rec
249: from pay_jp_isdf_calc_dct_v2
250: where action_information_id = p_action_information_id
251: for update nowait;
252: --
253: if p_rec.object_version_number <> p_object_version_number then

Line 1304: l_rec pay_jp_isdf_calc_dct_v%rowtype;

1300: p_life_pens_new_ins_prem in number,
1301: p_life_gen_new_ins_calc_prem in number,
1302: p_life_pens_new_ins_calc_prem in number)
1303: is
1304: l_rec pay_jp_isdf_calc_dct_v%rowtype;
1305: l_proc varchar2(80) := c_package||'update_calc_dct';
1306: begin
1307: --
1308: if g_debug then

Line 1423: l_rec pay_jp_isdf_calc_dct_v2%rowtype;

1419: p_status in varchar2,
1420: p_care_med_new_ins_prem in number,
1421: p_care_med_new_ins_calc_prem in number)
1422: is
1423: l_rec pay_jp_isdf_calc_dct_v2%rowtype;
1424: l_proc varchar2(80) := c_package||'update_calc_dct2';
1425: begin
1426: --
1427: if g_debug then