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.PAY_BALANCE_UPLOAD dependencies on PAY_BALANCE_BATCH_HEADERS

Line 308: ,upload_date pay_balance_batch_headers.upload_date%type

304: --
305: type glbl_data_rec_type is record
306: (upload_mode varchar2(30)
307: ,purge_mode boolean
308: ,upload_date pay_balance_batch_headers.upload_date%type
309: ,batch_id pay_balance_batch_headers.batch_id%type
310: ,business_group_id pay_balance_batch_headers.business_group_id%type
311: ,legislation_code varchar2(30)
312: ,payroll_id pay_balance_batch_headers.payroll_id%type

Line 309: ,batch_id pay_balance_batch_headers.batch_id%type

305: type glbl_data_rec_type is record
306: (upload_mode varchar2(30)
307: ,purge_mode boolean
308: ,upload_date pay_balance_batch_headers.upload_date%type
309: ,batch_id pay_balance_batch_headers.batch_id%type
310: ,business_group_id pay_balance_batch_headers.business_group_id%type
311: ,legislation_code varchar2(30)
312: ,payroll_id pay_balance_batch_headers.payroll_id%type
313: ,consolidation_set_id pay_consolidation_sets.consolidation_set_id%type

Line 310: ,business_group_id pay_balance_batch_headers.business_group_id%type

306: (upload_mode varchar2(30)
307: ,purge_mode boolean
308: ,upload_date pay_balance_batch_headers.upload_date%type
309: ,batch_id pay_balance_batch_headers.batch_id%type
310: ,business_group_id pay_balance_batch_headers.business_group_id%type
311: ,legislation_code varchar2(30)
312: ,payroll_id pay_balance_batch_headers.payroll_id%type
313: ,consolidation_set_id pay_consolidation_sets.consolidation_set_id%type
314: ,assignment_id pay_balance_batch_lines.assignment_id%type

Line 312: ,payroll_id pay_balance_batch_headers.payroll_id%type

308: ,upload_date pay_balance_batch_headers.upload_date%type
309: ,batch_id pay_balance_batch_headers.batch_id%type
310: ,business_group_id pay_balance_batch_headers.business_group_id%type
311: ,legislation_code varchar2(30)
312: ,payroll_id pay_balance_batch_headers.payroll_id%type
313: ,consolidation_set_id pay_consolidation_sets.consolidation_set_id%type
314: ,assignment_id pay_balance_batch_lines.assignment_id%type
315: ,batch_header_status pay_balance_batch_headers.batch_status%type
316: ,batch_line_status pay_balance_batch_lines.batch_line_status%type

Line 315: ,batch_header_status pay_balance_batch_headers.batch_status%type

311: ,legislation_code varchar2(30)
312: ,payroll_id pay_balance_batch_headers.payroll_id%type
313: ,consolidation_set_id pay_consolidation_sets.consolidation_set_id%type
314: ,assignment_id pay_balance_batch_lines.assignment_id%type
315: ,batch_header_status pay_balance_batch_headers.batch_status%type
316: ,batch_line_status pay_balance_batch_lines.batch_line_status%type
317: ,chunk_size number(9)
318: ,jurisdiction_iv pay_input_values_f.name%type
319: ,include_adj_rule pay_legislation_rules.rule_mode%type

Line 466: from pay_balance_batch_headers BH

462: ,BL.tax_unit_id
463: ,BL.jurisdiction_code
464: ,BL.original_entry_id
465: ,BL.batch_line_status) expiry_date
466: from pay_balance_batch_headers BH
467: ,pay_balance_batch_lines BL
468: where BH.batch_id = p_batch_id
469: and BL.batch_id = BH.batch_id
470: and BL.assignment_id = p_assignment_id

Line 1301: from pay_balance_batch_headers BBH

1297: (
1298: p_batch_id number
1299: ) is
1300: select BBH.batch_id
1301: from pay_balance_batch_headers BBH
1302: where BBH.batch_id = p_batch_id
1303: for update nowait;
1304: --
1305: -- Holds the batch_id of the locked batch header.

Line 2536: from pay_balance_batch_headers BBH

2532: p_batch_id number
2533: ) is
2534: select BBH.batch_id
2535: ,trunc(BBH.upload_date) upload_date
2536: from pay_balance_batch_headers BBH
2537: where BBH.batch_id = p_batch_id
2538: for update nowait;
2539: --
2540: -- Retrieves the commit unit size held as an action parameter.

Line 2577: update pay_balance_batch_headers BBH

2573: --
2574: -- Set batch_status of batch header to 'L' to lock it.
2575: -- This is used to stop other threads attempting to process this batch.
2576: --
2577: update pay_balance_batch_headers BBH
2578: set BBH.batch_status = 'L'
2579: where BBH.batch_id = p_batch_id;
2580: --
2581: -- Initialise the global data structure.

Line 2703: update pay_balance_batch_headers BH

2699: --
2700: -- Set the status on the batch.
2701: --
2702: if csr_status%rowcount > 0 then
2703: update pay_balance_batch_headers BH
2704: set BH.batch_status = l_status
2705: where BH.batch_id = p_glbl_data_rec.batch_id;
2706: end if;
2707: close csr_status;

Line 2743: from pay_balance_batch_headers BBH

2739: (
2740: p_batch_id number
2741: ) is
2742: select *
2743: from pay_balance_batch_headers BBH
2744: where BBH.batch_id = p_batch_id
2745: for update;
2746: --
2747: -- Retrieves business group information NB. either the business_group_id or

Line 2937: update pay_balance_batch_headers BBH

2933: -- we need the batch_status to remain L-ocked until end of upload
2934: -- for this batch.
2935: --
2936: if l_batch_header_rec.batch_status = 'E' then
2937: update pay_balance_batch_headers BBH
2938: set BBH.business_group_id = l_batch_header_rec.business_group_id
2939: ,BBH.business_group_name = l_batch_header_rec.business_group_name
2940: ,BBH.payroll_id = l_batch_header_rec.payroll_id
2941: ,BBH.payroll_name = l_batch_header_rec.payroll_name

Line 2945: update pay_balance_batch_headers BBH

2941: ,BBH.payroll_name = l_batch_header_rec.payroll_name
2942: ,BBH.batch_status = l_batch_header_rec.batch_status
2943: where current of csr_batch_header;
2944: else
2945: update pay_balance_batch_headers BBH
2946: set BBH.business_group_id = l_batch_header_rec.business_group_id
2947: ,BBH.business_group_name = l_batch_header_rec.business_group_name
2948: ,BBH.payroll_id = l_batch_header_rec.payroll_id
2949: ,BBH.payroll_name = l_batch_header_rec.payroll_name

Line 5546: delete from pay_balance_batch_headers BBH

5542: where BBL.batch_id = p_glbl_data_rec.batch_id;
5543: --
5544: -- Delete the batch header.
5545: --
5546: delete from pay_balance_batch_headers BBH
5547: where BBH.batch_id = p_glbl_data_rec.batch_id;
5548: --
5549: hr_utility.trace('Exiting pay_balance_upload.purge_batch');
5550: --

Line 5658: pay_balance_batch_headers pbh

5654: select pbh.business_group_id,
5655: pbg.legislation_code,
5656: pbh.payroll_id
5657: from per_business_groups_perf pbg,
5658: pay_balance_batch_headers pbh
5659: where pbh.batch_id = p_batch_id
5660: and pbh.business_group_id = pbg.business_group_id;
5661: begin
5662: hr_utility.trace('Entering pay_balance_upload.load_latest_balances');

Line 5843: update pay_balance_batch_headers

5839: ,p_message_text => l_message
5840: ,p_message_token => null
5841: );
5842:
5843: update pay_balance_batch_headers
5844: set batch_status = 'E'
5845: where batch_id = l_glbl_data_rec.batch_id;
5846:
5847: when others then

Line 5860: update pay_balance_batch_headers

5856: ,p_message_text => l_message
5857: ,p_message_token => null
5858: );
5859:
5860: update pay_balance_batch_headers
5861: set batch_status = 'E'
5862: where batch_id = l_glbl_data_rec.batch_id;
5863:
5864: end validate_transfer_batch;

Line 5926: from pay_balance_batch_headers BBH

5922: -- by checking if batch header batch_status = 'L'.
5923: --
5924: select BBH.batch_status
5925: into l_batch_status
5926: from pay_balance_batch_headers BBH
5927: where BBH.batch_id = p_batch_id;
5928: --
5929: if l_batch_status = 'L' then
5930: --