93:
94:
95: begin
96:
97: hr_utility.trace('In: ' || l_fn_name) ;
98: hr_utility.trace(' p_upload_date => ' || to_char(p_upload_date,'dd Mon yyyy')) ;
99: hr_utility.trace(' p_dimension_name => ' || p_dimension_name) ;
100: hr_utility.trace(' p_assignment_id => ' || to_char(p_assignment_id)) ;
101: hr_utility.trace(' p_original_entry_id => ' || to_char(p_original_entry_id)) ;
94:
95: begin
96:
97: hr_utility.trace('In: ' || l_fn_name) ;
98: hr_utility.trace(' p_upload_date => ' || to_char(p_upload_date,'dd Mon yyyy')) ;
99: hr_utility.trace(' p_dimension_name => ' || p_dimension_name) ;
100: hr_utility.trace(' p_assignment_id => ' || to_char(p_assignment_id)) ;
101: hr_utility.trace(' p_original_entry_id => ' || to_char(p_original_entry_id)) ;
102:
95: begin
96:
97: hr_utility.trace('In: ' || l_fn_name) ;
98: hr_utility.trace(' p_upload_date => ' || to_char(p_upload_date,'dd Mon yyyy')) ;
99: hr_utility.trace(' p_dimension_name => ' || p_dimension_name) ;
100: hr_utility.trace(' p_assignment_id => ' || to_char(p_assignment_id)) ;
101: hr_utility.trace(' p_original_entry_id => ' || to_char(p_original_entry_id)) ;
102:
103: -- get assignment details
96:
97: hr_utility.trace('In: ' || l_fn_name) ;
98: hr_utility.trace(' p_upload_date => ' || to_char(p_upload_date,'dd Mon yyyy')) ;
99: hr_utility.trace(' p_dimension_name => ' || p_dimension_name) ;
100: hr_utility.trace(' p_assignment_id => ' || to_char(p_assignment_id)) ;
101: hr_utility.trace(' p_original_entry_id => ' || to_char(p_original_entry_id)) ;
102:
103: -- get assignment details
104: open c_assignment(p_assignment_id, p_upload_date);
97: hr_utility.trace('In: ' || l_fn_name) ;
98: hr_utility.trace(' p_upload_date => ' || to_char(p_upload_date,'dd Mon yyyy')) ;
99: hr_utility.trace(' p_dimension_name => ' || p_dimension_name) ;
100: hr_utility.trace(' p_assignment_id => ' || to_char(p_assignment_id)) ;
101: hr_utility.trace(' p_original_entry_id => ' || to_char(p_original_entry_id)) ;
102:
103: -- get assignment details
104: open c_assignment(p_assignment_id, p_upload_date);
105: fetch c_assignment
226: if l_expiry_date is null then
227: raise e_bad_expiry_date ;
228: end if;
229:
230: hr_utility.trace(l_fn_name || ' return: ' || to_char(l_expiry_date,'dd Mon yyyy')) ;
231: hr_utility.trace('Out: ' || l_fn_name) ;
232: return l_expiry_date;
233:
234: exception
227: raise e_bad_expiry_date ;
228: end if;
229:
230: hr_utility.trace(l_fn_name || ' return: ' || to_char(l_expiry_date,'dd Mon yyyy')) ;
231: hr_utility.trace('Out: ' || l_fn_name) ;
232: return l_expiry_date;
233:
234: exception
235: -- when e_bad_expiry_date then
236: -- l_expiry_date := g_end_of_time;
237: -- return l_expiry_date;
238: when others then
239: l_expiry_date := g_end_of_time;
240: hr_utility.trace(l_fn_name || ' return: ' || to_char(l_expiry_date,'dd Mon yyyy')) ;
241: hr_utility.trace('Out: ' || l_fn_name) ;
242: return l_expiry_date;
243:
244: end expiry_date;
237: -- return l_expiry_date;
238: when others then
239: l_expiry_date := g_end_of_time;
240: hr_utility.trace(l_fn_name || ' return: ' || to_char(l_expiry_date,'dd Mon yyyy')) ;
241: hr_utility.trace('Out: ' || l_fn_name) ;
242: return l_expiry_date;
243:
244: end expiry_date;
245:
261: return number is
262: l_proc constant varchar2(72) := g_package||'is_supported';
263: begin
264:
265: hr_utility.trace('Entering '||l_proc);
266:
267: -- see if the dimension is supported.
268:
269: /* Bug 4516174 - Added support for LE level dimensions */
287: ,'_ASG_LE_TD'
288: ,'_ASG_LE_YTD'
289: )
290: then
291: hr_utility.trace('Exiting '||l_proc);
292: return 1;
293: else
294: hr_utility.trace('Exiting '||l_proc);
295: return 0;
290: then
291: hr_utility.trace('Exiting '||l_proc);
292: return 1;
293: else
294: hr_utility.trace('Exiting '||l_proc);
295: return 0;
296: end if;
297:
298: end is_supported;
392: CLOSE csr_get_tested_adjustments;
393:
394: -- Does the balance adjustment effect the new balance
395:
396: hr_utility.trace('balance_type_id = '||TO_CHAR(p_balance_type_id));
397: hr_utility.trace('tax_unit_id = '||TO_CHAR(l_tax_unit_id));
398: hr_utility.trace('original_entry_id = '||TO_CHAR(p_original_entry_id));
399: hr_utility.trace('BA tax_unit_id = '||TO_CHAR(l_adj_tax_unit_id));
400: hr_utility.trace('BA original_entry_id = '||TO_CHAR(l_adj_orig_entry_id));
393:
394: -- Does the balance adjustment effect the new balance
395:
396: hr_utility.trace('balance_type_id = '||TO_CHAR(p_balance_type_id));
397: hr_utility.trace('tax_unit_id = '||TO_CHAR(l_tax_unit_id));
398: hr_utility.trace('original_entry_id = '||TO_CHAR(p_original_entry_id));
399: hr_utility.trace('BA tax_unit_id = '||TO_CHAR(l_adj_tax_unit_id));
400: hr_utility.trace('BA original_entry_id = '||TO_CHAR(l_adj_orig_entry_id));
401:
394: -- Does the balance adjustment effect the new balance
395:
396: hr_utility.trace('balance_type_id = '||TO_CHAR(p_balance_type_id));
397: hr_utility.trace('tax_unit_id = '||TO_CHAR(l_tax_unit_id));
398: hr_utility.trace('original_entry_id = '||TO_CHAR(p_original_entry_id));
399: hr_utility.trace('BA tax_unit_id = '||TO_CHAR(l_adj_tax_unit_id));
400: hr_utility.trace('BA original_entry_id = '||TO_CHAR(l_adj_orig_entry_id));
401:
402:
395:
396: hr_utility.trace('balance_type_id = '||TO_CHAR(p_balance_type_id));
397: hr_utility.trace('tax_unit_id = '||TO_CHAR(l_tax_unit_id));
398: hr_utility.trace('original_entry_id = '||TO_CHAR(p_original_entry_id));
399: hr_utility.trace('BA tax_unit_id = '||TO_CHAR(l_adj_tax_unit_id));
400: hr_utility.trace('BA original_entry_id = '||TO_CHAR(l_adj_orig_entry_id));
401:
402:
403: OPEN csr_is_included(p_balance_type_id
396: hr_utility.trace('balance_type_id = '||TO_CHAR(p_balance_type_id));
397: hr_utility.trace('tax_unit_id = '||TO_CHAR(l_tax_unit_id));
398: hr_utility.trace('original_entry_id = '||TO_CHAR(p_original_entry_id));
399: hr_utility.trace('BA tax_unit_id = '||TO_CHAR(l_adj_tax_unit_id));
400: hr_utility.trace('BA original_entry_id = '||TO_CHAR(l_adj_orig_entry_id));
401:
402:
403: OPEN csr_is_included(p_balance_type_id
404: ,l_tax_unit_id
450:
451: procedure validate_batch_lines( p_batch_id number ) is
452: begin
453:
454: hr_utility.trace('Entering '||g_package||'validate_batch_lines');
455:
456: hr_utility.trace('Exiting '||g_package||'validate_batch_lines');
457:
458: end validate_batch_lines;
452: begin
453:
454: hr_utility.trace('Entering '||g_package||'validate_batch_lines');
455:
456: hr_utility.trace('Exiting '||g_package||'validate_batch_lines');
457:
458: end validate_batch_lines;
459:
460: end pay_au_bal_upload;