7854: and link_value = c_link_value;
7855:
7856: l_dp_crt_cnt_rec hrdpv_create_contact%rowtype;
7857:
7858: -- Cursor to get previous data from hrdpv_update_contact_relations
7859: cursor csr_get_update_cnt_data (c_batch_id in number
7860: ,c_link_value in number) is
7861: select *
7862: from hrdpv_update_contact_relations
7858: -- Cursor to get previous data from hrdpv_update_contact_relations
7859: cursor csr_get_update_cnt_data (c_batch_id in number
7860: ,c_link_value in number) is
7861: select *
7862: from hrdpv_update_contact_relations
7863: where batch_id = c_batch_id
7864: and link_value = c_link_value;
7865:
7866: l_dp_upd_cnt_rec hrdpv_update_contact_relations%rowtype;
7862: from hrdpv_update_contact_relations
7863: where batch_id = c_batch_id
7864: and link_value = c_link_value;
7865:
7866: l_dp_upd_cnt_rec hrdpv_update_contact_relations%rowtype;
7867:
7868: l_proc_name constant varchar2(150):= g_pkg ||'HR_DataPumpErr';
7869:
7870: l_dp_mode varchar2(40);