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.BEN_ICD_ELEMENT_ENTRY_PKG dependencies on HR_API

Line 32: if(hr_api.g_update = p_datetrack_mode) then

28: if(next_row_exists is null) then
29: next_row_exists := 'N';
30: end if ;
31:
32: if(hr_api.g_update = p_datetrack_mode) then
33: if( p_effective_date < p_effective_start_date)then
34: -- throw an error.
35: --'Please check the effective date as the changes can not become effective before the record started.'
36: null;

Line 38: l_datetrack_mode:= hr_api.g_correction;

34: -- throw an error.
35: --'Please check the effective date as the changes can not become effective before the record started.'
36: null;
37: elsif(p_effective_date = p_effective_start_date)then
38: l_datetrack_mode:= hr_api.g_correction;
39: elsif(p_effective_date > p_effective_start_date and 'Y' = next_row_exists) then
40: l_datetrack_mode:=hr_api.g_update_change_insert;
41: else
42: l_datetrack_mode:= hr_api.g_update;

Line 40: l_datetrack_mode:=hr_api.g_update_change_insert;

36: null;
37: elsif(p_effective_date = p_effective_start_date)then
38: l_datetrack_mode:= hr_api.g_correction;
39: elsif(p_effective_date > p_effective_start_date and 'Y' = next_row_exists) then
40: l_datetrack_mode:=hr_api.g_update_change_insert;
41: else
42: l_datetrack_mode:= hr_api.g_update;
43: end if;
44: elsif(hr_api.g_delete = p_datetrack_mode) then

Line 42: l_datetrack_mode:= hr_api.g_update;

38: l_datetrack_mode:= hr_api.g_correction;
39: elsif(p_effective_date > p_effective_start_date and 'Y' = next_row_exists) then
40: l_datetrack_mode:=hr_api.g_update_change_insert;
41: else
42: l_datetrack_mode:= hr_api.g_update;
43: end if;
44: elsif(hr_api.g_delete = p_datetrack_mode) then
45: if( p_effective_date < p_effective_start_date)then
46: null;

Line 44: elsif(hr_api.g_delete = p_datetrack_mode) then

40: l_datetrack_mode:=hr_api.g_update_change_insert;
41: else
42: l_datetrack_mode:= hr_api.g_update;
43: end if;
44: elsif(hr_api.g_delete = p_datetrack_mode) then
45: if( p_effective_date < p_effective_start_date)then
46: null;
47: -- throw an error.
48: --'Please check the end date as the changes can not end before the record started.'

Line 50: l_datetrack_mode:= hr_api.g_zap;

46: null;
47: -- throw an error.
48: --'Please check the end date as the changes can not end before the record started.'
49: elsif(p_effective_date = p_effective_start_date) then
50: l_datetrack_mode:= hr_api.g_zap;
51: elsif(p_effective_date > p_effective_start_date and 'Y' = next_row_exists) then
52: l_datetrack_mode:= hr_api.g_future_change;
53: else
54: l_datetrack_mode:= hr_api.g_delete;

Line 52: l_datetrack_mode:= hr_api.g_future_change;

48: --'Please check the end date as the changes can not end before the record started.'
49: elsif(p_effective_date = p_effective_start_date) then
50: l_datetrack_mode:= hr_api.g_zap;
51: elsif(p_effective_date > p_effective_start_date and 'Y' = next_row_exists) then
52: l_datetrack_mode:= hr_api.g_future_change;
53: else
54: l_datetrack_mode:= hr_api.g_delete;
55: end if;
56: else

Line 54: l_datetrack_mode:= hr_api.g_delete;

50: l_datetrack_mode:= hr_api.g_zap;
51: elsif(p_effective_date > p_effective_start_date and 'Y' = next_row_exists) then
52: l_datetrack_mode:= hr_api.g_future_change;
53: else
54: l_datetrack_mode:= hr_api.g_delete;
55: end if;
56: else
57: -- this is insert dml_operation and should not happen.
58: l_datetrack_mode:= p_datetrack_mode;

Line 827: if(p_effective_end_date is not null and p_effective_end_date <> hr_api.g_eot) then

823: ,p_create_warning => l_create_warning
824: );
825:
826: -- try to end date the entry if it was entered on the page.
827: if(p_effective_end_date is not null and p_effective_end_date <> hr_api.g_eot) then
828: -- we need to call the delete for this record.
829: -- if this is a non recurring entry then the end date might be after the effective_end_date
830: -- of the record, we need not delete in that case.
831: if( p_effective_end_date < l_effective_end_date) then

Line 834: ,p_datetrack_delete_mode => hr_api.g_delete

830: -- of the record, we need not delete in that case.
831: if( p_effective_end_date < l_effective_end_date) then
832: pay_element_entry_api.delete_element_entry
833: (p_validate => false
834: ,p_datetrack_delete_mode => hr_api.g_delete
835: ,p_effective_date => p_effective_end_date
836: ,p_element_entry_id => l_element_entry_id
837: ,p_object_version_number => l_object_version_number
838: ,p_effective_start_date => l_effective_start_date

Line 954: from hr_api_transaction_steps hats

950: ) is
951: --
952: cursor c_txn_step(p_transaction_id number) is
953: select hats.transaction_step_id
954: from hr_api_transaction_steps hats
955: where hats.transaction_id = p_transaction_id
956: and hats.api_name = upper(g_package || 'process_api')
957: order by hats.transaction_step_id;
958: --

Line 1353: where transaction_id = (select transaction_id from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)

1349: --
1350: cursor c_icd_transaction is
1351: select *
1352: from ben_icd_transaction
1353: where transaction_id = (select transaction_id from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)
1354: order by dml_operation;
1355:
1356: l_proc varchar2(61) := 'process_api' ;
1357: l_validate number;