DBA Data[Home] [Help]

APPS.GHR_DS_JAN99_PKG dependencies on HR_UTILITY

Line 364: hr_utility.set_location('UPDATE_MODE : ' || l_datetrack_update_mode,2);

360: l_datetrack_update_mode := 'CORRECTION';
361: End if;
362: End if;
363: --End if;
364: hr_utility.set_location('UPDATE_MODE : ' || l_datetrack_update_mode,2);
365: for c_full_name_rec in c_full_name loop
366: l_full_name := c_full_name_rec.full_name;
367: end loop;
368: l_log_text := 'In Assignments - Employee Name : ' || l_full_name || ' : ' ;

Line 371: hr_utility.set_location('asg id ' || l_assignment_id,1);

367: end loop;
368: l_log_text := 'In Assignments - Employee Name : ' || l_full_name || ' : ' ;
369: l_log_text := l_log_text || ' Assignment Id : ' || to_char(l_assignment_id) || ' - ';
370:
371: hr_utility.set_location('asg id ' || l_assignment_id,1);
372: hr_utility.set_location('ed ' || l_effective_date,1);
373: hr_utility.set_location('ead ' || l_assign_effective_date,1);
374: hr_utility.set_location('OVN ' || l_object_version_number,1);
375:

Line 372: hr_utility.set_location('ed ' || l_effective_date,1);

368: l_log_text := 'In Assignments - Employee Name : ' || l_full_name || ' : ' ;
369: l_log_text := l_log_text || ' Assignment Id : ' || to_char(l_assignment_id) || ' - ';
370:
371: hr_utility.set_location('asg id ' || l_assignment_id,1);
372: hr_utility.set_location('ed ' || l_effective_date,1);
373: hr_utility.set_location('ead ' || l_assign_effective_date,1);
374: hr_utility.set_location('OVN ' || l_object_version_number,1);
375:
376: ---- Update Assignment - New Location in Date track as of 01-JAN-1999

Line 373: hr_utility.set_location('ead ' || l_assign_effective_date,1);

369: l_log_text := l_log_text || ' Assignment Id : ' || to_char(l_assignment_id) || ' - ';
370:
371: hr_utility.set_location('asg id ' || l_assignment_id,1);
372: hr_utility.set_location('ed ' || l_effective_date,1);
373: hr_utility.set_location('ead ' || l_assign_effective_date,1);
374: hr_utility.set_location('OVN ' || l_object_version_number,1);
375:
376: ---- Update Assignment - New Location in Date track as of 01-JAN-1999
377: ghr_session.set_session_var_for_core

Line 374: hr_utility.set_location('OVN ' || l_object_version_number,1);

370:
371: hr_utility.set_location('asg id ' || l_assignment_id,1);
372: hr_utility.set_location('ed ' || l_effective_date,1);
373: hr_utility.set_location('ead ' || l_assign_effective_date,1);
374: hr_utility.set_location('OVN ' || l_object_version_number,1);
375:
376: ---- Update Assignment - New Location in Date track as of 01-JAN-1999
377: ghr_session.set_session_var_for_core
378: (p_effective_date => l_assign_effective_date );

Line 473: hr_utility.set_location('UPDATE_MODE Position : ' || l_datetrack_update_mode,2);

469: l_datetrack_update_mode := 'CORRECTION';
470: End if;
471: End if;
472: --End if;
473: hr_utility.set_location('UPDATE_MODE Position : ' || l_datetrack_update_mode,2);
474: ----
475: hr_utility.set_location('pos id ' || l_position_id,1);
476: hr_utility.set_location('ed ' || l_effective_date,1);
477: hr_utility.set_location('esd ' || l_effective_start_date,1);

Line 475: hr_utility.set_location('pos id ' || l_position_id,1);

471: End if;
472: --End if;
473: hr_utility.set_location('UPDATE_MODE Position : ' || l_datetrack_update_mode,2);
474: ----
475: hr_utility.set_location('pos id ' || l_position_id,1);
476: hr_utility.set_location('ed ' || l_effective_date,1);
477: hr_utility.set_location('esd ' || l_effective_start_date,1);
478: hr_utility.set_location('ead ' || l_assign_effective_date,1);
479: hr_utility.set_location('OVN ' || l_object_version_number,1);

Line 476: hr_utility.set_location('ed ' || l_effective_date,1);

472: --End if;
473: hr_utility.set_location('UPDATE_MODE Position : ' || l_datetrack_update_mode,2);
474: ----
475: hr_utility.set_location('pos id ' || l_position_id,1);
476: hr_utility.set_location('ed ' || l_effective_date,1);
477: hr_utility.set_location('esd ' || l_effective_start_date,1);
478: hr_utility.set_location('ead ' || l_assign_effective_date,1);
479: hr_utility.set_location('OVN ' || l_object_version_number,1);
480:

Line 477: hr_utility.set_location('esd ' || l_effective_start_date,1);

473: hr_utility.set_location('UPDATE_MODE Position : ' || l_datetrack_update_mode,2);
474: ----
475: hr_utility.set_location('pos id ' || l_position_id,1);
476: hr_utility.set_location('ed ' || l_effective_date,1);
477: hr_utility.set_location('esd ' || l_effective_start_date,1);
478: hr_utility.set_location('ead ' || l_assign_effective_date,1);
479: hr_utility.set_location('OVN ' || l_object_version_number,1);
480:
481: begin

Line 478: hr_utility.set_location('ead ' || l_assign_effective_date,1);

474: ----
475: hr_utility.set_location('pos id ' || l_position_id,1);
476: hr_utility.set_location('ed ' || l_effective_date,1);
477: hr_utility.set_location('esd ' || l_effective_start_date,1);
478: hr_utility.set_location('ead ' || l_assign_effective_date,1);
479: hr_utility.set_location('OVN ' || l_object_version_number,1);
480:
481: begin
482: ghr_session.set_session_var_for_core

Line 479: hr_utility.set_location('OVN ' || l_object_version_number,1);

475: hr_utility.set_location('pos id ' || l_position_id,1);
476: hr_utility.set_location('ed ' || l_effective_date,1);
477: hr_utility.set_location('esd ' || l_effective_start_date,1);
478: hr_utility.set_location('ead ' || l_assign_effective_date,1);
479: hr_utility.set_location('OVN ' || l_object_version_number,1);
480:
481: begin
482: ghr_session.set_session_var_for_core
483: (p_effective_date => l_effective_date );