eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_DATA_PUMP dependencies on HR_PUMP_BATCH_HEADERS

Line 208: , hr_pump_batch_headers pbh

204: , p_batch_status
205: , p_business_group_name
206: , p_atomic_linked_calls
207: from per_business_groups_perf grp
208: , hr_pump_batch_headers pbh
209: where pbh.batch_id = p_batch_id
210: and grp.name (+) = pbh.business_group_name
211: for update of pbh.batch_status
212: ;

Line 256: update hr_pump_batch_headers h

252: else
253: --
254: -- Set the header status to processing.
255: --
256: update hr_pump_batch_headers h
257: set h.batch_status = 'P'
258: where h.batch_id = p_batch_id;
259: --
260: commit;

Line 277: l_batch_name hr_pump_batch_headers.batch_name%type;

273: procedure header_read
274: (p_batch_id in number
275: ,p_atomic_linked_calls out nocopy boolean
276: ) is
277: l_batch_name hr_pump_batch_headers.batch_name%type;
278: l_business_group_id number;
279: l_business_group_name hr_pump_batch_headers.batch_name%type;
280: l_security_group_id number;
281: l_batch_status hr_pump_batch_headers.batch_status%type;

Line 279: l_business_group_name hr_pump_batch_headers.batch_name%type;

275: ,p_atomic_linked_calls out nocopy boolean
276: ) is
277: l_batch_name hr_pump_batch_headers.batch_name%type;
278: l_business_group_id number;
279: l_business_group_name hr_pump_batch_headers.batch_name%type;
280: l_security_group_id number;
281: l_batch_status hr_pump_batch_headers.batch_status%type;
282: l_atomic_linked_calls hr_pump_batch_headers.atomic_linked_calls%type;
283: begin

Line 281: l_batch_status hr_pump_batch_headers.batch_status%type;

277: l_batch_name hr_pump_batch_headers.batch_name%type;
278: l_business_group_id number;
279: l_business_group_name hr_pump_batch_headers.batch_name%type;
280: l_security_group_id number;
281: l_batch_status hr_pump_batch_headers.batch_status%type;
282: l_atomic_linked_calls hr_pump_batch_headers.atomic_linked_calls%type;
283: begin
284: --
285: header_core

Line 282: l_atomic_linked_calls hr_pump_batch_headers.atomic_linked_calls%type;

278: l_business_group_id number;
279: l_business_group_name hr_pump_batch_headers.batch_name%type;
280: l_security_group_id number;
281: l_batch_status hr_pump_batch_headers.batch_status%type;
282: l_atomic_linked_calls hr_pump_batch_headers.atomic_linked_calls%type;
283: begin
284: --
285: header_core
286: (p_batch_id => p_batch_id

Line 764: update hr_pump_batch_headers pbh

760: end if;
761:
762: -- Update the appropriate status
763: if(p_type = 'BATCH_HEADER' and not p_processing) then
764: update hr_pump_batch_headers pbh
765: set pbh.batch_status = 'E'
766: where pbh.batch_id = p_id;
767: elsif (p_type <> 'BATCH_HEADER') then
768: update hr_pump_batch_lines pbl

Line 970: l_bg_name hr_pump_batch_headers.business_group_name%type;

966: p_env out nocopy master_env_r,
967: p_batch_status out nocopy varchar2
968: ) is
969: l_found boolean;
970: l_bg_name hr_pump_batch_headers.business_group_name%type;
971: l_batch_name hr_pump_batch_headers.batch_name%type;
972: begin
973: -- Give some defaults for the startup info.
974: p_env.business_group_id := null;

Line 971: l_batch_name hr_pump_batch_headers.batch_name%type;

967: p_batch_status out nocopy varchar2
968: ) is
969: l_found boolean;
970: l_bg_name hr_pump_batch_headers.business_group_name%type;
971: l_batch_name hr_pump_batch_headers.batch_name%type;
972: begin
973: -- Give some defaults for the startup info.
974: p_env.business_group_id := null;
975: p_env.security_group_id := null;

Line 1672: -- values (from HR_PUMP_BATCH_HEADERS).

1668: else
1669: --
1670: -- Either BUSINESS_GROUP_NAME IS NULL or a match has been
1671: -- made. In the former case, override with the passed-in
1672: -- values (from HR_PUMP_BATCH_HEADERS).
1673: --
1674: l_bus_group_id :=
1675: nvl(c1rec.business_group_id, p_business_group_id);
1676: l_sec_group_id :=

Line 1944: -- Get any further required information from HR_PUMP_BATCH_HEADERS.

1940: else
1941: l_validate := false;
1942: end if;
1943:
1944: -- Get any further required information from HR_PUMP_BATCH_HEADERS.
1945: header_read
1946: (p_batch_id => p_batch_id
1947: ,p_atomic_linked_calls => l_atomic_calls
1948: );

Line 2016: hr_pump_batch_headers pbh

2012: select hpr.rowid,
2013: hpr.starting_process_sequence,
2014: hpr.ending_process_sequence
2015: from hr_pump_ranges hpr,
2016: hr_pump_batch_headers pbh
2017: where hpr.batch_id = p_batch_id
2018: and hpr.range_status = 'U'
2019: and pbh.batch_id = hpr.batch_id
2020: and pbh.batch_status <> 'E'

Line 2033: hr_pump_batch_headers pbh

2029: select hpr.rowid,
2030: hpr.starting_process_sequence,
2031: hpr.ending_process_sequence
2032: from hr_pump_ranges hpr,
2033: hr_pump_batch_headers pbh
2034: where hpr.batch_id = p_batch_id
2035: and hpr.range_status = 'U'
2036: and pbh.batch_id = hpr.batch_id
2037: and pbh.batch_status <> 'E'

Line 2091: from hr_pump_batch_headers pbh

2087:
2088: -- Attempt to lock the row.
2089: select pbh.batch_status
2090: into l_batch_status
2091: from hr_pump_batch_headers pbh
2092: where pbh.batch_id = p_batch_id
2093: for update of pbh.batch_status;
2094:
2095: -- Check the current status.

Line 2108: update hr_pump_batch_headers pbh

2104: where hpr.batch_id = p_batch_id;
2105:
2106: if(l_range_count = 0) then
2107: -- We are the last, so update the batch status.
2108: update hr_pump_batch_headers pbh
2109: set pbh.batch_status = 'C'
2110: where pbh.batch_id = p_batch_id;
2111: end if;
2112: end if;

Line 2503: l_business_group_name hr_pump_batch_headers.business_group_name%type;

2499: ,p_error_message out nocopy varchar2
2500: ) is
2501: l_work_to_do boolean;
2502: l_status varchar2(32);
2503: l_business_group_name hr_pump_batch_headers.business_group_name%type;
2504: l_batch_name hr_pump_batch_headers.batch_name%type;
2505: l_business_group_id number;
2506: l_security_group_id number;
2507: l_message fnd_new_messages.message_text%type;

Line 2504: l_batch_name hr_pump_batch_headers.batch_name%type;

2500: ) is
2501: l_work_to_do boolean;
2502: l_status varchar2(32);
2503: l_business_group_name hr_pump_batch_headers.business_group_name%type;
2504: l_batch_name hr_pump_batch_headers.batch_name%type;
2505: l_business_group_id number;
2506: l_security_group_id number;
2507: l_message fnd_new_messages.message_text%type;
2508: l_count number;

Line 2675: hr_data_pump.message('HR_PUMP_BATCH_HEADERS');

2671:
2672: ------------------------------------------------------------
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

Line 2692: from hr_pump_batch_headers

2688: ;
2689:
2690: if l_count = 0 then
2691: delete
2692: from hr_pump_batch_headers
2693: where batch_id = p_batch_id
2694: ;
2695: else
2696: update hr_pump_batch_headers

Line 2696: update hr_pump_batch_headers

2692: from hr_pump_batch_headers
2693: where batch_id = p_batch_id
2694: ;
2695: else
2696: update hr_pump_batch_headers
2697: set batch_status = 'C'
2698: where batch_id = p_batch_id;
2699: end if;
2700: else

Line 2701: update hr_pump_batch_headers

2697: set batch_status = 'C'
2698: where batch_id = p_batch_id;
2699: end if;
2700: else
2701: update hr_pump_batch_headers
2702: set batch_status = 'C'
2703: where batch_id = p_batch_id;
2704: end if;
2705: --

Line 2736: update hr_pump_batch_headers

2732:
2733: --
2734: -- Reset the batch header.
2735: --
2736: update hr_pump_batch_headers
2737: set batch_status = 'E'
2738: where batch_id = p_batch_id;
2739: --
2740: commit;

Line 2777: from hr_pump_batch_headers h

2773: (p_lower_bound in number
2774: ,p_upper_bound in number
2775: ) is
2776: select h.batch_id
2777: from hr_pump_batch_headers h
2778: where h.batch_id between
2779: p_lower_bound and p_upper_bound
2780: and h.batch_status <> 'P'
2781: ;

Line 2969: -- Find the maximum and minimum BATCH_ID from HR_PUMP_BATCH_HEADERS. The

2965: l_max number;
2966: l_lower number;
2967: l_upper number;
2968: --
2969: -- Find the maximum and minimum BATCH_ID from HR_PUMP_BATCH_HEADERS. The
2970: -- queries utilise the INDEX FULL SCAN (MIN/MAX) optimization.
2971: --
2972: cursor csr_bh_minmax is
2973: select A.maximum

Line 2975: from (select max(batch_id) maximum from hr_pump_batch_headers) A

2971: --
2972: cursor csr_bh_minmax is
2973: select A.maximum
2974: , B.minimum
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.

Line 2976: , (select min(batch_id) minimum from hr_pump_batch_headers) B

2972: cursor csr_bh_minmax is
2973: select A.maximum
2974: , B.minimum
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