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 || ' : ' ;
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:
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
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
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 );
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);
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);
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:
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
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
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 );