APPS.HR_DATA_PUMP dependencies on HR_PUMP_BATCH_LINE_USER_KEYS

Line 2436: hr_data_pump.message('HR_PUMP_BATCH_LINE_USER_KEYS:BATCH_LINE_ID IS NULL');

2432: ) is
2433: l_work_to_do boolean;
2434: l_message fnd_new_messages.message_text%type;
2435: begin
2436: hr_data_pump.message('HR_PUMP_BATCH_LINE_USER_KEYS:BATCH_LINE_ID IS NULL');
2437:
2438: p_error_message := null;
2439:
2440: l_work_to_do := true;

Line 2443: from hr_pump_batch_line_user_keys uk

2439:
2440: l_work_to_do := true;
2441: while l_work_to_do loop
2442: delete
2443: from hr_pump_batch_line_user_keys uk
2444: where uk.batch_line_id is null
2445: and uk.user_key_id between
2446: p_lower_bound and p_upper_bound
2447: and rownum <= p_chunk_size

Line 2540: hr_data_pump.message('HR_PUMP_BATCH_LINE_USER_KEYS');

2536:
2537: -----------------------------------------------------
2538: -- 2. Preserve or delete user keys for this batch. --
2539: -----------------------------------------------------
2540: hr_data_pump.message('HR_PUMP_BATCH_LINE_USER_KEYS');
2541:
2542: l_work_to_do := true;
2543: while l_work_to_do loop
2544: if p_preserve_user_keys then

Line 2545: update hr_pump_batch_line_user_keys uk

2541:
2542: l_work_to_do := true;
2543: while l_work_to_do loop
2544: if p_preserve_user_keys then
2545: update hr_pump_batch_line_user_keys uk
2546: set uk.batch_line_id = null
2547: where uk.batch_line_id in
2548: (
2549: select bl.batch_line_id

Line 2557: from hr_pump_batch_line_user_keys uk

2553: and rownum <= p_chunk_size
2554: ;
2555: else
2556: delete
2557: from hr_pump_batch_line_user_keys uk
2558: where uk.batch_line_id in
2559: (
2560: select l.batch_line_id
2561: from hr_pump_batch_lines l

Line 2979: -- Find maximum and minimum USER_KEY_ID from HR_PUMP_BATCH_LINE_USER_KEYS.

2975: from (select max(batch_id) maximum from hr_pump_batch_headers) A
2976: , (select min(batch_id) minimum from hr_pump_batch_headers) B
2977: ;
2978: --
2979: -- Find maximum and minimum USER_KEY_ID from HR_PUMP_BATCH_LINE_USER_KEYS.
2980: -- This is for case where BATCH_LINE_ID IS NULL but don't include
2981: -- BATCH_LINE_ID to avoid FULL TABLE SCAN.
2982: --
2983: cursor csr_uk_minmax is

Line 2986: from (select max(user_key_id) maximum from hr_pump_batch_line_user_keys) A

2982: --
2983: cursor csr_uk_minmax is
2984: select A.maximum
2985: , B.minimum
2986: from (select max(user_key_id) maximum from hr_pump_batch_line_user_keys) A
2987: , (select min(user_key_id) minimum from hr_pump_batch_line_user_keys) B
2988: ;
2989: begin
2990: --

Line 2987: , (select min(user_key_id) minimum from hr_pump_batch_line_user_keys) B

2983: cursor csr_uk_minmax is
2984: select A.maximum
2985: , B.minimum
2986: from (select max(user_key_id) maximum from hr_pump_batch_line_user_keys) A
2987: , (select min(user_key_id) minimum from hr_pump_batch_line_user_keys) B
2988: ;
2989: begin
2990: --
2991: -- Start by assuming success.