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_IE_BAL_UPLOAD dependencies on HR_UTILITY

Line 246: -- HR_UTILITY.trace_on(null,'BIK');

242: --------------------------------------------------------------------------------------
243: begin -- Expiry_Date - Main --
244: --------------------------------------------------------------------------------------
245: -- What is the start date of the assignment? All loading must come after this date.
246: -- HR_UTILITY.trace_on(null,'BIK');
247: open csr_asg_itd_start(p_assignment_id, p_upload_date);
248: fetch csr_asg_itd_start into l_asg_itd_start_date;
249: close csr_asg_itd_start;
250: hr_utility.trace('l_asg_itd_start_date' || to_char(l_asg_itd_start_date,'DD-MON-YYYY'));

Line 250: hr_utility.trace('l_asg_itd_start_date' || to_char(l_asg_itd_start_date,'DD-MON-YYYY'));

246: -- HR_UTILITY.trace_on(null,'BIK');
247: open csr_asg_itd_start(p_assignment_id, p_upload_date);
248: fetch csr_asg_itd_start into l_asg_itd_start_date;
249: close csr_asg_itd_start;
250: hr_utility.trace('l_asg_itd_start_date' || to_char(l_asg_itd_start_date,'DD-MON-YYYY'));
251: -- Return the date on which the dimension expires.
252: if substr(p_dimension_name, 31, 4) = 'USER' then
253: -- User balance
254: select

Line 291: hr_utility.trace('l_start_date' || to_char(l_start_date,'DD-MON-YYYY'));

287: -- calculate the the payroll start date
288: open csr_payroll_start_date(p_assignment_id, p_upload_date);
289: fetch csr_payroll_start_date into l_start_date;
290: close csr_payroll_start_date;
291: hr_utility.trace('l_start_date' || to_char(l_start_date,'DD-MON-YYYY'));
292: -- calculate the tac year start date for the upload process
293: l_tax_year := to_date(l_leg_start || to_char(p_upload_date,'YYYY'),'DD/MM/YYYY');
294: hr_utility.trace('l_tax_year' || to_char(l_tax_year,'DD-MON-YYYY'));
295: -- calculate the expiry date

Line 294: hr_utility.trace('l_tax_year' || to_char(l_tax_year,'DD-MON-YYYY'));

290: close csr_payroll_start_date;
291: hr_utility.trace('l_start_date' || to_char(l_start_date,'DD-MON-YYYY'));
292: -- calculate the tac year start date for the upload process
293: l_tax_year := to_date(l_leg_start || to_char(p_upload_date,'YYYY'),'DD/MM/YYYY');
294: hr_utility.trace('l_tax_year' || to_char(l_tax_year,'DD-MON-YYYY'));
295: -- calculate the expiry date
296: l_expiry_date := greatest(l_start_date, l_asg_itd_start_date,
297: l_tax_year );
298: hr_utility.trace('l_expiry_date ' || to_char(l_expiry_date,'DD-MON-YYYY'));

Line 298: hr_utility.trace('l_expiry_date ' || to_char(l_expiry_date,'DD-MON-YYYY'));

294: hr_utility.trace('l_tax_year' || to_char(l_tax_year,'DD-MON-YYYY'));
295: -- calculate the expiry date
296: l_expiry_date := greatest(l_start_date, l_asg_itd_start_date,
297: l_tax_year );
298: hr_utility.trace('l_expiry_date ' || to_char(l_expiry_date,'DD-MON-YYYY'));
299: elsif p_dimension_name in ('_ASG_QTD') then
300: -- calculate the qtr start date
301: l_qtr_start_date := trunc(p_upload_date,'Q');
302: -- calculate the the payroll start date

Line 306: hr_utility.trace('l_start_date' || to_char(l_start_date,'DD-MON-YYYY'));

302: -- calculate the the payroll start date
303: open csr_payroll_start_date(p_assignment_id, p_upload_date);
304: fetch csr_payroll_start_date into l_start_date;
305: close csr_payroll_start_date;
306: hr_utility.trace('l_start_date' || to_char(l_start_date,'DD-MON-YYYY'));
307: -- calculate the expiry date
308: l_expiry_date := greatest(l_start_date, l_asg_itd_start_date,
309: l_qtr_start_date );
310: hr_utility.trace('l_expiry_date ' || to_char(l_expiry_date,'DD-MON-YYYY'));

Line 310: hr_utility.trace('l_expiry_date ' || to_char(l_expiry_date,'DD-MON-YYYY'));

306: hr_utility.trace('l_start_date' || to_char(l_start_date,'DD-MON-YYYY'));
307: -- calculate the expiry date
308: l_expiry_date := greatest(l_start_date, l_asg_itd_start_date,
309: l_qtr_start_date );
310: hr_utility.trace('l_expiry_date ' || to_char(l_expiry_date,'DD-MON-YYYY'));
311: elsif p_dimension_name in ('_PAYMENTS','_ASG_ITD') then
312: -- Calculate expiry date for _PAYMENTS and '_ASG_ITD' dimensions.
313: l_expiry_date := l_asg_itd_start_date;
314: elsif p_dimension_name in ('_ELEMENT_ITD','_ELEMENT_YTD') then

Line 330: HR_UTILITY.trace('l_expiry_date ' || to_char(l_expiry_date,'dd-mon-yyyy'));

326: fetch csr_period_start into l_start_date;
327: close csr_period_start;
328:
329: l_expiry_date := greatest(l_ele_itd_start_date,l_asg_itd_start_date,l_start_date);
330: HR_UTILITY.trace('l_expiry_date ' || to_char(l_expiry_date,'dd-mon-yyyy'));
331: --
332: end if;
333: -- HR_UTILITY.TRACE_OFF;
334: return nvl(l_expiry_date,END_OF_TIME);

Line 333: -- HR_UTILITY.TRACE_OFF;

329: l_expiry_date := greatest(l_ele_itd_start_date,l_asg_itd_start_date,l_start_date);
330: HR_UTILITY.trace('l_expiry_date ' || to_char(l_expiry_date,'dd-mon-yyyy'));
331: --
332: end if;
333: -- HR_UTILITY.TRACE_OFF;
334: return nvl(l_expiry_date,END_OF_TIME);
335: exception
336: when no_data_found then
337: l_expiry_date := END_OF_TIME;

Line 357: -- hr_utility.trace_on(null,'BIK');

353: (
354: p_dimension_name varchar2
355: ) return number is
356: begin
357: -- hr_utility.trace_on(null,'BIK');
358: hr_utility.trace('Entering pay_ie_bal_upload.is_supported stub');
359: -- Bug 2933807 - Added _ELEMENT_ITD Dimension
360: -- See if the dimension is supported.
361: if p_dimension_name in

Line 358: hr_utility.trace('Entering pay_ie_bal_upload.is_supported stub');

354: p_dimension_name varchar2
355: ) return number is
356: begin
357: -- hr_utility.trace_on(null,'BIK');
358: hr_utility.trace('Entering pay_ie_bal_upload.is_supported stub');
359: -- Bug 2933807 - Added _ELEMENT_ITD Dimension
360: -- See if the dimension is supported.
361: if p_dimension_name in
362: (

Line 384: hr_utility.trace('Exiting pay_ie_bal_upload.is_supported stub');

380: return 1;
381: else
382: return 0;
383: end if;
384: hr_utility.trace('Exiting pay_ie_bal_upload.is_supported stub');
385: end is_supported;
386: -----------------------------------------------------------------------------
387: -- NAME
388: -- include_adjustment

Line 437: hr_utility.trace('Entering pay_ie_bal_upload.include_adjustment stub');

433: l_source_text varchar2(10);
434: l_return Number := 1;--True
435: l_original_entry_id Number;
436: Begin
437: hr_utility.trace('Entering pay_ie_bal_upload.include_adjustment stub');
438: Open csr_bal_adj_source_text(p_test_batch_line_id,p_batch_line_id);
439: FETCH csr_bal_adj_source_text INTO l_source_text;
440: IF csr_bal_adj_source_text%NOTFOUND THEN
441: l_return := 0; -- false

Line 455: hr_utility.trace('Exiting pay_ie_bal_upload.include_adjustment l_return:' ||l_return );

451: l_return := 0; -- false
452: End If;
453: Close csr_bal_adj_orig_entry_id;
454: End if;
455: hr_utility.trace('Exiting pay_ie_bal_upload.include_adjustment l_return:' ||l_return );
456: Return l_return;
457: End include_adjustment;
458: -----------------------------------------------------------------------------
459: -- NAME

Line 474: hr_utility.trace('Entering pay_ie_bal_upload.validate_batch_lines stub');

470: (
471: p_batch_id number
472: ) is
473: begin
474: hr_utility.trace('Entering pay_ie_bal_upload.validate_batch_lines stub');
475: hr_utility.trace('Exiting pay_ie_bal_upload.validate_batch_lines stub');
476: end validate_batch_lines;
477: end pay_ie_bal_upload;

Line 475: hr_utility.trace('Exiting pay_ie_bal_upload.validate_batch_lines stub');

471: p_batch_id number
472: ) is
473: begin
474: hr_utility.trace('Entering pay_ie_bal_upload.validate_batch_lines stub');
475: hr_utility.trace('Exiting pay_ie_bal_upload.validate_batch_lines stub');
476: end validate_batch_lines;
477: end pay_ie_bal_upload;