DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_SS_PKG dependencies on PAY_JP_ISDF_ENTRY_V

Line 2708: from pay_jp_isdf_entry_v

2704: --
2705: cursor csr_entry
2706: is
2707: select *
2708: from pay_jp_isdf_entry_v
2709: where assignment_action_id = l_assact_rec.assignment_action_id
2710: and action_context_type = 'AAP'
2711: and action_information_category = 'JP_ISDF_ENTRY'
2712: and status <> 'D';

Line 3331: p_rec in out nocopy pay_jp_isdf_entry_v%rowtype,

3327: -- -------------------------------------------------------------------------
3328: -- transfer_entry
3329: -- -------------------------------------------------------------------------
3330: procedure transfer_entry(
3331: p_rec in out nocopy pay_jp_isdf_entry_v%rowtype,
3332: p_effective_date in date,
3333: p_expire_after_transfer in varchar2)
3334: is
3335: --

Line 3347: l_ins_datetrack_update_mode pay_jp_isdf_entry_v.ins_datetrack_update_mode%type;

3343: l_is_element_link_id number;
3344: --
3345: l_ins_element_entry_id number;
3346: l_ins_ee_object_version_number number;
3347: l_ins_datetrack_update_mode pay_jp_isdf_entry_v.ins_datetrack_update_mode%type;
3348: l_is_element_entry_id number;
3349: l_is_ee_object_version_number number;
3350: l_is_datetrack_update_mode pay_jp_isdf_entry_v.is_datetrack_update_mode%type;
3351: l_status pay_jp_isdf_entry_v.status%type;

Line 3350: l_is_datetrack_update_mode pay_jp_isdf_entry_v.is_datetrack_update_mode%type;

3346: l_ins_ee_object_version_number number;
3347: l_ins_datetrack_update_mode pay_jp_isdf_entry_v.ins_datetrack_update_mode%type;
3348: l_is_element_entry_id number;
3349: l_is_ee_object_version_number number;
3350: l_is_datetrack_update_mode pay_jp_isdf_entry_v.is_datetrack_update_mode%type;
3351: l_status pay_jp_isdf_entry_v.status%type;
3352: --
3353: l_entry_rec pay_jp_isdf_archive_pkg.t_entry_rec;
3354: --

Line 3351: l_status pay_jp_isdf_entry_v.status%type;

3347: l_ins_datetrack_update_mode pay_jp_isdf_entry_v.ins_datetrack_update_mode%type;
3348: l_is_element_entry_id number;
3349: l_is_ee_object_version_number number;
3350: l_is_datetrack_update_mode pay_jp_isdf_entry_v.is_datetrack_update_mode%type;
3351: l_status pay_jp_isdf_entry_v.status%type;
3352: --
3353: l_entry_rec pay_jp_isdf_archive_pkg.t_entry_rec;
3354: --
3355: cursor csr_pact

Line 4387: from pay_jp_isdf_entry_v

4383: --
4384: cursor csr_entry
4385: is
4386: select *
4387: from pay_jp_isdf_entry_v
4388: where assignment_action_id = l_assact_rec.assignment_action_id
4389: and status <> 'D'
4390: for update nowait;
4391: --

Line 4656: from pay_jp_isdf_entry_v

4652: --
4653: cursor csr_entry
4654: is
4655: select *
4656: from pay_jp_isdf_entry_v
4657: where assignment_action_id = l_assact_rec.assignment_action_id
4658: for update nowait;
4659: --
4660: l_csr_entry csr_entry%rowtype;