[Home] [Help]
291: -- End of Bug fixes 4216001 and 4216029
292:
293:
294: INSERT INTO fnd_sessions(SESSION_ID, EFFECTIVE_DATE)
295: VALUES(userenv('SESSIONID'),fnd_date.canonical_to_date(p_effective_date)) ;
296:
297: hr_utility.set_location('p_file_name '||p_file_name,1);
298: hr_utility.set_location('p_effective_date '||p_effective_date,1);
299: hr_utility.set_location('p_business_group_id '||p_business_group_id,1 );
320:
321: l_batch_id := hr_pump_utils.create_batch_header
322: (p_batch_name => p_batch_name,
323: p_business_group_name => l_bg_name,
324: p_reference => substr(p_reference||'('||fnd_date.date_to_displaydt(SYSDATE)||')',1,30));
325:
326: hr_utility.set_location ( ' Batch ID = ' || l_batch_id, 40);
327: -- Loop over the file, reading in each line. GET_LINE will
328: -- raise NO_DATA_FOUND when it is done, so we use that as the
576: CLOSE csr_get_user_key;
577: hr_utility.set_location ( ' User Key added ' , 80);
578: hr_utility.set_location ( ' l_effective_start_date:' || to_char(l_effective_start_date), 90);
579: hr_utility.set_location ( ' l_effective_end_date:' || to_char(l_effective_end_date), 90);
580: hr_utility.set_location ( ' p_effective_date:' || to_char(fnd_date.canonical_to_date(p_effective_date)), 90);
581: hr_utility.set_location ( ' c_end_of_time:' || to_char(c_end_of_time), 90);
582:
583: -- Define Datetrack Updation Mode
584: IF(l_effective_start_date = to_date(l_effective_date,'yyyymmdd')) THEN
597: hrdpp_update_element_entry.insert_batch_lines
598: (p_batch_id => l_batch_id
599: ,p_data_pump_business_grp_name => l_bg_name
600: ,P_DATETRACK_UPDATE_MODE => l_datetrack_update_mode
601: ,P_EFFECTIVE_DATE => fnd_date.canonical_to_date(l_effective_date)
602: ,P_ENTRY_VALUE1 => l_entry_value1
603: ,P_ENTRY_VALUE2 => l_entry_value2
604: ,P_ENTRY_VALUE3 => l_entry_value3
605: ,P_ENTRY_VALUE4 => l_entry_value4
676: -- Bug fix 4215700
677: hrdpp_create_element_entry.insert_batch_lines
678: (p_batch_id => l_batch_id
679: ,p_data_pump_business_grp_name => l_bg_name
680: ,P_EFFECTIVE_DATE => fnd_date.canonical_to_date(l_effective_date)
681: ,P_ENTRY_TYPE => 'E'
682: ,P_CREATOR_TYPE => 'F'
683: ,P_ENTRY_VALUE1 => l_entry_value1
684: ,P_ENTRY_VALUE2 => l_entry_value2