APPS.HR_DATA_PUMP dependencies on HR_PUMP_REQUESTS

Line 821: insert into hr_pump_requests (

817: if(l_request_id is null) then
818: l_request_id := 0;
819: end if;
820:
821: insert into hr_pump_requests (
822: batch_id,
823: request_id,
824: process_type)
825: values (p_batch_id,

Line 851: delete from hr_pump_requests hpr

847: if(l_request_id is null) then
848: l_request_id := 0;
849: end if;
850:
851: delete from hr_pump_requests hpr
852: where hpr.batch_id = p_batch_id
853: and hpr.request_id = l_request_id;
854:
855: end del_pump_request;

Line 2273: delete from hr_pump_requests hpr

2269: --
2270: if l_batch_status is not null and l_batch_status <> 'P' then
2271:
2272: -- Delete any existing pump request rows.
2273: delete from hr_pump_requests hpr
2274: where hpr.batch_id = p_batch_id;
2275:
2276: -- Insert a new pump request row.
2277: ins_pump_request(p_batch_id, 'MASTER');

Line 2677: delete from hr_pump_requests

2673: -- 6. Delete the batch header or update the batch status. --
2674: ------------------------------------------------------------
2675: hr_data_pump.message('HR_PUMP_BATCH_HEADERS');
2676:
2677: delete from hr_pump_requests
2678: where batch_id = p_batch_id;
2679: if p_delete_header then
2680:
2681: --