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 310: ,upload_date pay_balance_batch_headers.upload_date%type

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

Line 311: ,batch_id pay_balance_batch_headers.batch_id%type

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

Line 312: ,business_group_id pay_balance_batch_headers.business_group_id%type

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

Line 314: ,payroll_id pay_balance_batch_headers.payroll_id%type

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

Line 317: ,batch_header_status pay_balance_batch_headers.batch_status%type

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

Line 468: from pay_balance_batch_headers BH

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

Line 1303: from pay_balance_batch_headers BBH

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

Line 2829: from pay_balance_batch_headers BBH

2825: p_batch_id number
2826: ) is
2827: select BBH.batch_id
2828: ,trunc(BBH.upload_date) upload_date
2829: from pay_balance_batch_headers BBH
2830: where BBH.batch_id = p_batch_id
2831: for update nowait;
2832: --
2833: -- Retrieves the commit unit size held as an action parameter.

Line 2870: update pay_balance_batch_headers BBH

2866: --
2867: -- Set batch_status of batch header to 'L' to lock it.
2868: -- This is used to stop other threads attempting to process this batch.
2869: --
2870: update pay_balance_batch_headers BBH
2871: set BBH.batch_status = 'L'
2872: where BBH.batch_id = p_batch_id;
2873: --
2874: -- Initialise the global data structure.

Line 2996: update pay_balance_batch_headers BH

2992: --
2993: -- Set the status on the batch.
2994: --
2995: if csr_status%rowcount > 0 then
2996: update pay_balance_batch_headers BH
2997: set BH.batch_status = l_status
2998: where BH.batch_id = p_glbl_data_rec.batch_id;
2999: end if;
3000: close csr_status;

Line 3036: from pay_balance_batch_headers BBH

3032: (
3033: p_batch_id number
3034: ) is
3035: select *
3036: from pay_balance_batch_headers BBH
3037: where BBH.batch_id = p_batch_id
3038: for update;
3039: --
3040: -- Retrieves business group information NB. either the business_group_id or

Line 3230: update pay_balance_batch_headers BBH

3226: -- we need the batch_status to remain L-ocked until end of upload
3227: -- for this batch.
3228: --
3229: if l_batch_header_rec.batch_status = 'E' then
3230: update pay_balance_batch_headers BBH
3231: set BBH.business_group_id = l_batch_header_rec.business_group_id
3232: ,BBH.business_group_name = l_batch_header_rec.business_group_name
3233: ,BBH.payroll_id = l_batch_header_rec.payroll_id
3234: ,BBH.payroll_name = l_batch_header_rec.payroll_name

Line 3238: update pay_balance_batch_headers BBH

3234: ,BBH.payroll_name = l_batch_header_rec.payroll_name
3235: ,BBH.batch_status = l_batch_header_rec.batch_status
3236: where current of csr_batch_header;
3237: else
3238: update pay_balance_batch_headers BBH
3239: set BBH.business_group_id = l_batch_header_rec.business_group_id
3240: ,BBH.business_group_name = l_batch_header_rec.business_group_name
3241: ,BBH.payroll_id = l_batch_header_rec.payroll_id
3242: ,BBH.payroll_name = l_batch_header_rec.payroll_name

Line 5839: delete from pay_balance_batch_headers BBH

5835: where BBL.batch_id = p_glbl_data_rec.batch_id;
5836: --
5837: -- Delete the batch header.
5838: --
5839: delete from pay_balance_batch_headers BBH
5840: where BBH.batch_id = p_glbl_data_rec.batch_id;
5841: --
5842: hr_utility.trace('Exiting pay_balance_upload.purge_batch');
5843: --

Line 5951: pay_balance_batch_headers pbh

5947: select pbh.business_group_id,
5948: pbg.legislation_code,
5949: pbh.payroll_id
5950: from per_business_groups_perf pbg,
5951: pay_balance_batch_headers pbh
5952: where pbh.batch_id = p_batch_id
5953: and pbh.business_group_id = pbg.business_group_id;
5954: begin
5955: hr_utility.trace('Entering pay_balance_upload.load_latest_balances');

Line 6136: update pay_balance_batch_headers

6132: ,p_message_text => l_message
6133: ,p_message_token => null
6134: );
6135:
6136: update pay_balance_batch_headers
6137: set batch_status = 'E'
6138: where batch_id = l_glbl_data_rec.batch_id;
6139:
6140: when others then

Line 6153: update pay_balance_batch_headers

6149: ,p_message_text => l_message
6150: ,p_message_token => null
6151: );
6152:
6153: update pay_balance_batch_headers
6154: set batch_status = 'E'
6155: where batch_id = l_glbl_data_rec.batch_id;
6156:
6157: end validate_transfer_batch;

Line 6219: from pay_balance_batch_headers BBH

6215: -- by checking if batch header batch_status = 'L'.
6216: --
6217: select BBH.batch_status
6218: into l_batch_status
6219: from pay_balance_batch_headers BBH
6220: where BBH.batch_id = p_batch_id;
6221: --
6222: if l_batch_status = 'L' then
6223: --