DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_SS_PKG dependencies on PAY_JP_ISDF_ENTRY_V

Line 3320: from pay_jp_isdf_entry_v

3316: --
3317: cursor csr_entry
3318: is
3319: select *
3320: from pay_jp_isdf_entry_v
3321: where assignment_action_id = l_assact_rec.assignment_action_id
3322: and action_context_type = 'AAP'
3323: and action_information_category = 'JP_ISDF_ENTRY'
3324: and status <> 'D';

Line 3998: p_rec in out nocopy pay_jp_isdf_entry_v%rowtype,

3994: -- -------------------------------------------------------------------------
3995: -- transfer_entry
3996: -- -------------------------------------------------------------------------
3997: procedure transfer_entry(
3998: p_rec in out nocopy pay_jp_isdf_entry_v%rowtype,
3999: p_effective_date in date,
4000: p_expire_after_transfer in varchar2)
4001: is
4002: --

Line 4014: l_ins_datetrack_update_mode pay_jp_isdf_entry_v.ins_datetrack_update_mode%type;

4010: l_is_element_link_id number;
4011: --
4012: l_ins_element_entry_id number;
4013: l_ins_ee_object_version_number number;
4014: l_ins_datetrack_update_mode pay_jp_isdf_entry_v.ins_datetrack_update_mode%type;
4015: l_is_element_entry_id number;
4016: l_is_ee_object_version_number number;
4017: l_is_datetrack_update_mode pay_jp_isdf_entry_v.is_datetrack_update_mode%type;
4018: l_status pay_jp_isdf_entry_v.status%type;

Line 4017: l_is_datetrack_update_mode pay_jp_isdf_entry_v.is_datetrack_update_mode%type;

4013: l_ins_ee_object_version_number number;
4014: l_ins_datetrack_update_mode pay_jp_isdf_entry_v.ins_datetrack_update_mode%type;
4015: l_is_element_entry_id number;
4016: l_is_ee_object_version_number number;
4017: l_is_datetrack_update_mode pay_jp_isdf_entry_v.is_datetrack_update_mode%type;
4018: l_status pay_jp_isdf_entry_v.status%type;
4019: --
4020: l_entry_rec pay_jp_isdf_archive_pkg.t_entry_rec;
4021: --

Line 4018: l_status pay_jp_isdf_entry_v.status%type;

4014: l_ins_datetrack_update_mode pay_jp_isdf_entry_v.ins_datetrack_update_mode%type;
4015: l_is_element_entry_id number;
4016: l_is_ee_object_version_number number;
4017: l_is_datetrack_update_mode pay_jp_isdf_entry_v.is_datetrack_update_mode%type;
4018: l_status pay_jp_isdf_entry_v.status%type;
4019: --
4020: l_entry_rec pay_jp_isdf_archive_pkg.t_entry_rec;
4021: --
4022: cursor csr_pact

Line 5277: from pay_jp_isdf_entry_v

5273: --
5274: cursor csr_entry
5275: is
5276: select *
5277: from pay_jp_isdf_entry_v
5278: where assignment_action_id = l_assact_rec.assignment_action_id
5279: and status <> 'D'
5280: for update nowait;
5281: --

Line 5582: from pay_jp_isdf_entry_v

5578: --
5579: cursor csr_entry
5580: is
5581: select *
5582: from pay_jp_isdf_entry_v
5583: where assignment_action_id = l_assact_rec.assignment_action_id
5584: for update nowait;
5585: --
5586: l_csr_entry csr_entry%rowtype;