3911: AND link_value = c_link_value;
3912:
3913: l_dp_crt_cnt_rec hrdpv_create_contact%ROWTYPE;
3914:
3915: -- Cursor to get previous data from hrdpv_update_contact_relations
3916: CURSOR csr_get_update_cnt_data (c_batch_id IN Number
3917: ,c_link_value IN Number) IS
3918: SELECT *
3919: FROM hrdpv_update_contact_relations
3915: -- Cursor to get previous data from hrdpv_update_contact_relations
3916: CURSOR csr_get_update_cnt_data (c_batch_id IN Number
3917: ,c_link_value IN Number) IS
3918: SELECT *
3919: FROM hrdpv_update_contact_relations
3920: WHERE batch_id = c_batch_id
3921: AND link_value = c_link_value;
3922:
3923: l_dp_upd_cnt_rec hrdpv_update_contact_relations%ROWTYPE;
3919: FROM hrdpv_update_contact_relations
3920: WHERE batch_id = c_batch_id
3921: AND link_value = c_link_value;
3922:
3923: l_dp_upd_cnt_rec hrdpv_update_contact_relations%ROWTYPE;
3924:
3925: l_proc_name CONSTANT Varchar2(150):= g_pkg ||'HR_DataPumpErr';
3926:
3927: l_dp_mode Varchar2(10);