The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_update_date in date default null,
p_update_reason_code in varchar2 default null,
p_comments in varchar2 default null,
--
p_new_car_amount out nocopy number,
p_val_returned out nocopy number,
--
p_error_message out nocopy long
--
) is
--
l_formula_id number;
l_ev_rec_tbl(12).entry_value := fnd_date.date_to_canonical(p_update_date);
l_ev_rec_tbl(13).entry_value := p_update_reason_code;
p_action_type in varchar2, -- 'INSERT' or 'UPDATE' or 'DELETE'
p_effective_date in date default null,
p_date_track_option in varchar2 default null,
p_element_entry_id in number default null,
p_business_group_id in number default null,
p_assignment_id in number default null,
p_element_link_id in number default null,
p_entry_type in varchar2 default null,
p_object_version_number in number default null,
--
p_attribute_category in varchar2 default null,
p_attribute1 in varchar2 default null,
p_attribute2 in varchar2 default null,
p_attribute3 in varchar2 default null,
p_attribute4 in varchar2 default null,
p_attribute5 in varchar2 default null,
p_attribute6 in varchar2 default null,
p_attribute7 in varchar2 default null,
p_attribute8 in varchar2 default null,
p_attribute9 in varchar2 default null,
p_attribute10 in varchar2 default null,
p_attribute11 in varchar2 default null,
p_attribute12 in varchar2 default null,
p_attribute13 in varchar2 default null,
p_attribute14 in varchar2 default null,
p_attribute15 in varchar2 default null,
p_attribute16 in varchar2 default null,
p_attribute17 in varchar2 default null,
p_attribute18 in varchar2 default null,
p_attribute19 in varchar2 default null,
p_attribute20 in varchar2 default null,
--
p_input_value_id1 in number default null,
p_input_value_id2 in number default null,
p_input_value_id3 in number default null,
p_input_value_id4 in number default null,
p_input_value_id5 in number default null,
p_input_value_id6 in number default null,
p_input_value_id7 in number default null,
p_input_value_id8 in number default null,
p_input_value_id9 in number default null,
p_input_value_id10 in number default null,
p_input_value_id11 in number default null,
p_input_value_id12 in number default null,
p_input_value_id13 in number default null,
p_input_value_id14 in number default null,
p_input_value_id15 in number default null,
--
p_entry_value1 in varchar2 default null,
p_entry_value2 in varchar2 default null,
p_entry_value3 in varchar2 default null,
p_entry_value4 in varchar2 default null,
p_entry_value5 in varchar2 default null,
p_entry_value6 in varchar2 default null,
p_entry_value7 in varchar2 default null,
p_entry_value8 in varchar2 default null,
p_entry_value9 in varchar2 default null,
p_entry_value10 in varchar2 default null,
p_entry_value11 in varchar2 default null,
p_entry_value12 in varchar2 default null,
p_entry_value13 in varchar2 default null,
p_entry_value14 in varchar2 default null,
p_entry_value15 in varchar2 default null,
--
p_error_message out nocopy long
--
) is
--
l_date_format varchar2(10);
p_update_date in date default null,
p_update_reason_code in varchar2 default null,
p_comments in varchar2 default null,
--
p_error_message out nocopy long
--
) is
begin
--
set_transaction_step
(
--
p_item_type => p_item_type,
p_item_key => p_item_key,
p_activity_id => p_activity_id,
p_login_person_id => p_login_person_id,
--
p_commutation_type => 'TRAIN',
p_action_type => p_action_type,
p_effective_date => p_effective_date,
p_date_track_option => p_date_track_option,
p_element_entry_id => p_element_entry_id,
p_business_group_id => p_business_group_id,
p_assignment_id => p_assignment_id,
p_element_link_id => p_element_link_id,
p_entry_type => p_entry_type,
p_object_version_number => p_object_version_number,
--
p_attribute_category => p_attribute_category,
p_attribute1 => p_attribute1,
p_attribute2 => p_attribute2,
p_attribute3 => p_attribute3,
p_attribute4 => p_attribute4,
p_attribute5 => p_attribute5,
p_attribute6 => p_attribute6,
p_attribute7 => p_attribute7,
p_attribute8 => p_attribute8,
p_attribute9 => p_attribute9,
p_attribute10 => p_attribute10,
p_attribute11 => p_attribute11,
p_attribute12 => p_attribute12,
p_attribute13 => p_attribute13,
p_attribute14 => p_attribute14,
p_attribute15 => p_attribute15,
p_attribute16 => p_attribute16,
p_attribute17 => p_attribute17,
p_attribute18 => p_attribute18,
p_attribute19 => p_attribute19,
p_attribute20 => p_attribute20,
--
p_input_value_id1 => p_input_value_id1,
p_input_value_id2 => p_input_value_id2,
p_input_value_id3 => p_input_value_id3,
p_input_value_id4 => p_input_value_id4,
p_input_value_id5 => p_input_value_id5,
p_input_value_id6 => p_input_value_id6,
p_input_value_id7 => p_input_value_id7,
p_input_value_id8 => p_input_value_id8,
p_input_value_id9 => p_input_value_id9,
p_input_value_id10 => p_input_value_id10,
p_input_value_id11 => p_input_value_id11,
p_input_value_id12 => p_input_value_id12,
p_input_value_id13 => p_input_value_id13,
p_input_value_id14 => null,
p_input_value_id15 => null,
--
p_entry_value1 => p_means_code,
p_entry_value2 => p_departure_place,
p_entry_value3 => p_arrival_place,
p_entry_value4 => p_via,
p_entry_value5 => p_period_code,
p_entry_value6 => p_payment_option_code,
p_entry_value7 => fnd_number.number_to_canonical(p_amount),
p_entry_value8 => p_pay_start_month,
p_entry_value9 => p_pay_end_month,
p_entry_value10 => p_si_start_month_code,
p_entry_value11 => fnd_date.date_to_canonical(p_update_date),
p_entry_value12 => p_update_reason_code,
p_entry_value13 => p_comments,
p_entry_value14 => null,
p_entry_value15 => null,
--
p_error_message => p_error_message
--
);
p_update_date in date default null,
p_update_reason_code in varchar2 default null,
p_comments in varchar2 default null,
--
p_error_message out nocopy long
--
) is
begin
--
set_transaction_step
(
p_item_type => p_item_type,
p_item_key => p_item_key,
p_activity_id => p_activity_id,
p_login_person_id => p_login_person_id,
--
p_commutation_type => 'CAR',
p_action_type => p_action_type,
p_effective_date => p_effective_date,
p_date_track_option => p_date_track_option,
p_element_entry_id => p_element_entry_id,
p_business_group_id => p_business_group_id,
p_assignment_id => p_assignment_id,
p_element_link_id => p_element_link_id,
p_entry_type => p_entry_type,
p_object_version_number => p_object_version_number,
--
p_attribute_category => p_attribute_category,
p_attribute1 => p_attribute1,
p_attribute2 => p_attribute2,
p_attribute3 => p_attribute3,
p_attribute4 => p_attribute4,
p_attribute5 => p_attribute5,
p_attribute6 => p_attribute6,
p_attribute7 => p_attribute7,
p_attribute8 => p_attribute8,
p_attribute9 => p_attribute9,
p_attribute10 => p_attribute10,
p_attribute11 => p_attribute11,
p_attribute12 => p_attribute12,
p_attribute13 => p_attribute13,
p_attribute14 => p_attribute14,
p_attribute15 => p_attribute15,
p_attribute16 => p_attribute16,
p_attribute17 => p_attribute17,
p_attribute18 => p_attribute18,
p_attribute19 => p_attribute19,
p_attribute20 => p_attribute20,
--
p_input_value_id1 => p_input_value_id1,
p_input_value_id2 => p_input_value_id2,
p_input_value_id3 => p_input_value_id3,
p_input_value_id4 => p_input_value_id4,
p_input_value_id5 => p_input_value_id5,
p_input_value_id6 => p_input_value_id6,
p_input_value_id7 => p_input_value_id7,
p_input_value_id8 => p_input_value_id8,
p_input_value_id9 => p_input_value_id9,
p_input_value_id10 => p_input_value_id10,
p_input_value_id11 => p_input_value_id11,
p_input_value_id12 => p_input_value_id12,
p_input_value_id13 => p_input_value_id13,
p_input_value_id14 => p_input_value_id14,
p_input_value_id15 => null,
--
p_entry_value1 => p_means_code,
p_entry_value2 => fnd_number.number_to_canonical(p_vehicle_info_id),
p_entry_value3 => p_period_code,
p_entry_value4 => fnd_number.number_to_canonical(p_distance),
p_entry_value5 => p_fuel_cost_code,
p_entry_value6 => fnd_number.number_to_canonical(p_amount),
p_entry_value7 => fnd_number.number_to_canonical(p_parking_fees),
p_entry_value8 => fnd_number.number_to_canonical(p_equivalent_cost),
p_entry_value9 => p_pay_start_month,
p_entry_value10 => p_pay_end_month,
p_entry_value11 => p_si_start_month_code,
p_entry_value12 => fnd_date.date_to_canonical(p_update_date),
p_entry_value13 => p_update_reason_code,
p_entry_value14 => p_comments,
p_entry_value15 => null,
--
p_error_message => p_error_message
--
);
p_update_date in date default null,
p_update_reason_code in varchar2 default null,
p_comments in varchar2 default null,
--
p_error_message out nocopy long
--
)is
--
l_effective_start_date pay_element_entries_f.effective_start_date%type;
p_entry_value11 => fnd_date.date_to_displaydate(p_update_date),
p_entry_value12 => p_update_reason_code,
p_entry_value13 => p_comments,
p_entry_value14 => null,
p_entry_value15 => null,
--
p_effective_start_date => l_effective_start_date,
p_effective_end_date => l_effective_end_date,
p_element_entry_id => l_element_entry_id,
p_object_version_number => l_object_version_number,
--
p_create_warning => l_create_warning
--
);
procedure update_train_entry
(
p_validate in number default 0,
--
p_datetrack_update_mode in varchar2,
p_effective_date in date,
p_business_group_id in number,
p_element_entry_id in number,
p_object_version_number in out nocopy number,
--
p_attribute_category in varchar2 default null,
p_attribute1 in varchar2 default null,
p_attribute2 in varchar2 default null,
p_attribute3 in varchar2 default null,
p_attribute4 in varchar2 default null,
p_attribute5 in varchar2 default null,
p_attribute6 in varchar2 default null,
p_attribute7 in varchar2 default null,
p_attribute8 in varchar2 default null,
p_attribute9 in varchar2 default null,
p_attribute10 in varchar2 default null,
p_attribute11 in varchar2 default null,
p_attribute12 in varchar2 default null,
p_attribute13 in varchar2 default null,
p_attribute14 in varchar2 default null,
p_attribute15 in varchar2 default null,
p_attribute16 in varchar2 default null,
p_attribute17 in varchar2 default null,
p_attribute18 in varchar2 default null,
p_attribute19 in varchar2 default null,
p_attribute20 in varchar2 default null,
--
p_input_value_id1 in number default null,
p_input_value_id2 in number default null,
p_input_value_id3 in number default null,
p_input_value_id4 in number default null,
p_input_value_id5 in number default null,
p_input_value_id6 in number default null,
p_input_value_id7 in number default null,
p_input_value_id8 in number default null,
p_input_value_id9 in number default null,
p_input_value_id10 in number default null,
p_input_value_id11 in number default null,
p_input_value_id12 in number default null,
p_input_value_id13 in number default null,
--
p_means_code in varchar2 default null,
p_departure_place in varchar2 default null,
p_arrival_place in varchar2 default null,
p_via in varchar2 default null,
p_period_code in varchar2 default null,
p_payment_option_code in varchar2 default null,
p_amount in number default null,
p_pay_start_month in varchar2 default null,
p_pay_end_month in varchar2 default null,
p_si_start_month_code in varchar2 default null,
p_update_date in date default null,
p_update_reason_code in varchar2 default null,
p_comments in varchar2 default null,
--
p_error_message out nocopy long
--
)is
--
l_effective_start_date pay_element_entries_f.effective_start_date%type;
l_update_warning boolean;
pay_element_entry_api.update_element_entry
(
--
p_validate => hr_java_conv_util_ss.get_boolean(p_validate),
--
p_datetrack_update_mode => p_datetrack_update_mode,
p_effective_date => p_effective_date,
p_business_group_id => p_business_group_id,
p_element_entry_id => p_element_entry_id,
p_object_version_number => p_object_version_number,
--
p_attribute_category => p_attribute_category,
p_attribute1 => p_attribute1,
p_attribute2 => p_attribute2,
p_attribute3 => p_attribute3,
p_attribute4 => p_attribute4,
p_attribute5 => p_attribute5,
p_attribute6 => p_attribute6,
p_attribute7 => p_attribute7,
p_attribute8 => p_attribute8,
p_attribute9 => p_attribute9,
p_attribute10 => p_attribute10,
p_attribute11 => p_attribute11,
p_attribute12 => p_attribute12,
p_attribute13 => p_attribute13,
p_attribute14 => p_attribute14,
p_attribute15 => p_attribute15,
p_attribute16 => p_attribute16,
p_attribute17 => p_attribute17,
p_attribute18 => p_attribute18,
p_attribute19 => p_attribute19,
p_attribute20 => p_attribute20,
--
p_input_value_id1 => p_input_value_id1 ,
p_input_value_id2 => p_input_value_id2 ,
p_input_value_id3 => p_input_value_id3 ,
p_input_value_id4 => p_input_value_id4 ,
p_input_value_id5 => p_input_value_id5 ,
p_input_value_id6 => p_input_value_id6 ,
p_input_value_id7 => p_input_value_id7 ,
p_input_value_id8 => p_input_value_id8 ,
p_input_value_id9 => p_input_value_id9 ,
p_input_value_id10 => p_input_value_id10,
p_input_value_id11 => p_input_value_id11,
p_input_value_id12 => p_input_value_id12,
p_input_value_id13 => p_input_value_id13,
p_input_value_id14 => null,
p_input_value_id15 => null,
--
p_entry_value1 => p_means_code,
p_entry_value2 => p_departure_place,
p_entry_value3 => p_arrival_place,
p_entry_value4 => p_via,
p_entry_value5 => p_period_code,
p_entry_value6 => p_payment_option_code,
p_entry_value7 => fnd_number.number_to_canonical(p_amount),
p_entry_value8 => p_pay_start_month,
p_entry_value9 => p_pay_end_month,
p_entry_value10 => p_si_start_month_code,
-- canonical date format is not acceptable for this api
p_entry_value11 => fnd_date.date_to_displaydate(p_update_date),
p_entry_value12 => p_update_reason_code,
p_entry_value13 => p_comments,
p_entry_value14 => null,
p_entry_value15 => null,
--
p_effective_start_date => l_effective_start_date,
p_effective_end_date => l_effective_end_date,
--
p_update_warning => l_update_warning
--
);
end update_train_entry;
p_update_date in date default null,
p_update_reason_code in varchar2 default null,
p_comments in varchar2 default null,
--
p_error_message out nocopy long
--
)is
--
l_effective_start_date pay_element_entries_f.effective_start_date%type;
p_entry_value12 => fnd_date.date_to_displaydate(p_update_date),
p_entry_value13 => p_update_reason_code,
p_entry_value14 => p_comments,
p_entry_value15 => null,
--
p_effective_start_date => l_effective_start_date,
p_effective_end_date => l_effective_end_date,
p_element_entry_id => l_element_entry_id,
p_object_version_number => l_object_version_number,
--
p_create_warning => l_create_warning
--
);
procedure update_car_entry
(
--
p_validate in number default 0,
--
p_datetrack_update_mode in varchar2,
p_effective_date in date,
p_business_group_id in number,
p_element_entry_id in number,
p_object_version_number in out nocopy number,
--
p_attribute_category in varchar2 default null,
p_attribute1 in varchar2 default null,
p_attribute2 in varchar2 default null,
p_attribute3 in varchar2 default null,
p_attribute4 in varchar2 default null,
p_attribute5 in varchar2 default null,
p_attribute6 in varchar2 default null,
p_attribute7 in varchar2 default null,
p_attribute8 in varchar2 default null,
p_attribute9 in varchar2 default null,
p_attribute10 in varchar2 default null,
p_attribute11 in varchar2 default null,
p_attribute12 in varchar2 default null,
p_attribute13 in varchar2 default null,
p_attribute14 in varchar2 default null,
p_attribute15 in varchar2 default null,
p_attribute16 in varchar2 default null,
p_attribute17 in varchar2 default null,
p_attribute18 in varchar2 default null,
p_attribute19 in varchar2 default null,
p_attribute20 in varchar2 default null,
--
p_input_value_id1 in number default null,
p_input_value_id2 in number default null,
p_input_value_id3 in number default null,
p_input_value_id4 in number default null,
p_input_value_id5 in number default null,
p_input_value_id6 in number default null,
p_input_value_id7 in number default null,
p_input_value_id8 in number default null,
p_input_value_id9 in number default null,
p_input_value_id10 in number default null,
p_input_value_id11 in number default null,
p_input_value_id12 in number default null,
p_input_value_id13 in number default null,
p_input_value_id14 in number default null,
--
p_means_code in varchar2 default null,
p_vehicle_info_id in number default null,
p_period_code in varchar2 default null,
p_distance in number default null,
p_fuel_cost_code in varchar2 default null,
p_amount in number default null,
p_parking_fees in number default null,
p_equivalent_cost in number default null,
p_pay_start_month in varchar2 default null,
p_pay_end_month in varchar2 default null,
p_si_start_month_code in varchar2 default null,
p_update_date in date default null,
p_update_reason_code in varchar2 default null,
p_comments in varchar2 default null,
--
p_error_message out nocopy long
--
)is
--
l_effective_start_date pay_element_entries_f.effective_start_date%type;
l_update_warning boolean;
pay_element_entry_api.update_element_entry
(
--
p_validate => hr_java_conv_util_ss.get_boolean(p_validate),
--
p_datetrack_update_mode => p_datetrack_update_mode,
p_effective_date => p_effective_date,
p_business_group_id => p_business_group_id,
p_element_entry_id => p_element_entry_id,
p_object_version_number => p_object_version_number,
--
p_attribute_category => p_attribute_category,
p_attribute1 => p_attribute1,
p_attribute2 => p_attribute2,
p_attribute3 => p_attribute3,
p_attribute4 => p_attribute4,
p_attribute5 => p_attribute5,
p_attribute6 => p_attribute6,
p_attribute7 => p_attribute7,
p_attribute8 => p_attribute8,
p_attribute9 => p_attribute9,
p_attribute10 => p_attribute10,
p_attribute11 => p_attribute11,
p_attribute12 => p_attribute12,
p_attribute13 => p_attribute13,
p_attribute14 => p_attribute14,
p_attribute15 => p_attribute15,
p_attribute16 => p_attribute16,
p_attribute17 => p_attribute17,
p_attribute18 => p_attribute18,
p_attribute19 => p_attribute19,
p_attribute20 => p_attribute20,
--
p_input_value_id1 => p_input_value_id1 ,
p_input_value_id2 => p_input_value_id2 ,
p_input_value_id3 => p_input_value_id3 ,
p_input_value_id4 => p_input_value_id4 ,
p_input_value_id5 => p_input_value_id5 ,
p_input_value_id6 => p_input_value_id6 ,
p_input_value_id7 => p_input_value_id7 ,
p_input_value_id8 => p_input_value_id8 ,
p_input_value_id9 => p_input_value_id9 ,
p_input_value_id10 => p_input_value_id10,
p_input_value_id11 => p_input_value_id11,
p_input_value_id12 => p_input_value_id12,
p_input_value_id13 => p_input_value_id13,
p_input_value_id14 => p_input_value_id14,
p_input_value_id15 => null,
--
p_entry_value1 => p_means_code,
p_entry_value2 => fnd_number.number_to_canonical(p_vehicle_info_id),
p_entry_value3 => p_period_code,
p_entry_value4 => fnd_number.number_to_canonical(p_distance),
p_entry_value5 => p_fuel_cost_code,
p_entry_value6 => fnd_number.number_to_canonical(p_amount),
p_entry_value7 => fnd_number.number_to_canonical(p_parking_fees),
p_entry_value8 => fnd_number.number_to_canonical(p_equivalent_cost),
p_entry_value9 => p_pay_start_month,
p_entry_value10 => p_pay_end_month,
p_entry_value11 => p_si_start_month_code,
-- canonical date format is not acceptable for this api
p_entry_value12 => fnd_date.date_to_displaydate(p_update_date),
p_entry_value13 => p_update_reason_code,
p_entry_value14 => p_comments,
p_entry_value15 => null,
--
p_effective_start_date => l_effective_start_date,
p_effective_end_date => l_effective_end_date,
--
p_update_warning => l_update_warning
--
);
end update_car_entry;
procedure delete_entry
(
--
p_validate in number default 0,
--
p_datetrack_delete_mode in varchar2,
p_effective_date in date,
p_element_entry_id in number,
p_object_version_number in out nocopy number,
--
p_error_message out nocopy long
--
)is
--
l_effective_start_date pay_element_entries_f.effective_start_date%type;
pay_element_entry_api.delete_element_entry
(
--
p_validate => hr_java_conv_util_ss.get_boolean(p_validate),
--
p_datetrack_delete_mode => p_datetrack_delete_mode,
p_effective_date => p_effective_date,
p_element_entry_id => p_element_entry_id,
p_object_version_number => p_object_version_number,
--
p_effective_start_date => l_effective_start_date,
p_effective_end_date => l_effective_end_date,
--
p_delete_warning => l_warning
);
end delete_entry;
action_type varchar2(30), -- 'INSERT' or 'UPDATE' or 'DELETE'
effective_date date,
date_track_option varchar2(30),
--
element_entry_id pay_element_entries_f.element_entry_id%type,
business_group_id pay_element_links_f.business_group_id%type,
assignment_id pay_element_entries_f.assignment_id%type,
element_link_id pay_element_entries_f.element_link_id%type,
entry_type pay_element_entries_f.entry_type%type,
object_version_number pay_element_entries_f.object_version_number%type,
--
attribute_category pay_element_entries_f.attribute_category%type,
attribute1 pay_element_entries_f.attribute1%type,
attribute2 pay_element_entries_f.attribute2%type,
attribute3 pay_element_entries_f.attribute3%type,
attribute4 pay_element_entries_f.attribute4%type,
attribute5 pay_element_entries_f.attribute5%type,
attribute6 pay_element_entries_f.attribute6%type,
attribute7 pay_element_entries_f.attribute7%type,
attribute8 pay_element_entries_f.attribute8%type,
attribute9 pay_element_entries_f.attribute9%type,
attribute10 pay_element_entries_f.attribute10%type,
attribute11 pay_element_entries_f.attribute11%type,
attribute12 pay_element_entries_f.attribute12%type,
attribute13 pay_element_entries_f.attribute13%type,
attribute14 pay_element_entries_f.attribute14%type,
attribute15 pay_element_entries_f.attribute15%type,
attribute16 pay_element_entries_f.attribute16%type,
attribute17 pay_element_entries_f.attribute17%type,
attribute18 pay_element_entries_f.attribute18%type,
attribute19 pay_element_entries_f.attribute19%type,
attribute20 pay_element_entries_f.attribute20%type,
--
input_value_id1 pay_element_entry_values_f.input_value_id%type,
input_value_id2 pay_element_entry_values_f.input_value_id%type,
input_value_id3 pay_element_entry_values_f.input_value_id%type,
input_value_id4 pay_element_entry_values_f.input_value_id%type,
input_value_id5 pay_element_entry_values_f.input_value_id%type,
input_value_id6 pay_element_entry_values_f.input_value_id%type,
input_value_id7 pay_element_entry_values_f.input_value_id%type,
input_value_id8 pay_element_entry_values_f.input_value_id%type,
input_value_id9 pay_element_entry_values_f.input_value_id%type,
input_value_id10 pay_element_entry_values_f.input_value_id%type,
input_value_id11 pay_element_entry_values_f.input_value_id%type,
input_value_id12 pay_element_entry_values_f.input_value_id%type,
input_value_id13 pay_element_entry_values_f.input_value_id%type,
input_value_id14 pay_element_entry_values_f.input_value_id%type,
input_value_id15 pay_element_entry_values_f.input_value_id%type,
--
entry_value1 pay_element_entry_values_f.screen_entry_value%type,
entry_value2 pay_element_entry_values_f.screen_entry_value%type,
entry_value3 pay_element_entry_values_f.screen_entry_value%type,
entry_value4 pay_element_entry_values_f.screen_entry_value%type,
entry_value5 pay_element_entry_values_f.screen_entry_value%type,
entry_value6 pay_element_entry_values_f.screen_entry_value%type,
entry_value7 pay_element_entry_values_f.screen_entry_value%type,
entry_value8 pay_element_entry_values_f.screen_entry_value%type,
entry_value9 pay_element_entry_values_f.screen_entry_value%type,
entry_value10 pay_element_entry_values_f.screen_entry_value%type,
entry_value11 pay_element_entry_values_f.screen_entry_value%type,
entry_value12 pay_element_entry_values_f.screen_entry_value%type,
entry_value13 pay_element_entry_values_f.screen_entry_value%type,
entry_value14 pay_element_entry_values_f.screen_entry_value%type,
entry_value15 pay_element_entry_values_f.screen_entry_value%type
);
-- for update date input values
-- pay_element_entry_api.create_element_entry and update_element_entry don't accept canonical date format
-- canonical date format must be converted to display date format
-- if the api will be fixed in the future, following lines can be removed
if l_tran_rec.commutation_type = 'TRAIN' and l_tran_rec.entry_value11 is not null then
l_tran_rec.entry_value11 := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_tran_rec.entry_value11));
hr_util_misc_web.insert_session_row(l_tran_rec.effective_date);
if l_tran_rec.action_type = 'INSERT' then
--
pay_element_entry_api.create_element_entry
(
p_validate => p_validate,
p_effective_date => l_tran_rec.effective_date,
p_business_group_id => l_tran_rec.business_group_id,
p_assignment_id => l_tran_rec.assignment_id,
p_element_link_id => l_tran_rec.element_link_id,
p_entry_type => l_tran_rec.entry_type,
p_attribute_category => l_tran_rec.attribute_category,
p_attribute1 => l_tran_rec.attribute1,
p_attribute2 => l_tran_rec.attribute2,
p_attribute3 => l_tran_rec.attribute3,
p_attribute4 => l_tran_rec.attribute4,
p_attribute5 => l_tran_rec.attribute5,
p_attribute6 => l_tran_rec.attribute6,
p_attribute7 => l_tran_rec.attribute7,
p_attribute8 => l_tran_rec.attribute8,
p_attribute9 => l_tran_rec.attribute9,
p_attribute10 => l_tran_rec.attribute10,
p_attribute11 => l_tran_rec.attribute11,
p_attribute12 => l_tran_rec.attribute12,
p_attribute13 => l_tran_rec.attribute13,
p_attribute14 => l_tran_rec.attribute14,
p_attribute15 => l_tran_rec.attribute15,
p_attribute16 => l_tran_rec.attribute16,
p_attribute17 => l_tran_rec.attribute17,
p_attribute18 => l_tran_rec.attribute18,
p_attribute19 => l_tran_rec.attribute19,
p_attribute20 => l_tran_rec.attribute20,
p_input_value_id1 => l_tran_rec.input_value_id1,
p_input_value_id2 => l_tran_rec.input_value_id2,
p_input_value_id3 => l_tran_rec.input_value_id3,
p_input_value_id4 => l_tran_rec.input_value_id4,
p_input_value_id5 => l_tran_rec.input_value_id5,
p_input_value_id6 => l_tran_rec.input_value_id6,
p_input_value_id7 => l_tran_rec.input_value_id7,
p_input_value_id8 => l_tran_rec.input_value_id8,
p_input_value_id9 => l_tran_rec.input_value_id9,
p_input_value_id10 => l_tran_rec.input_value_id10,
p_input_value_id11 => l_tran_rec.input_value_id11,
p_input_value_id12 => l_tran_rec.input_value_id12,
p_input_value_id13 => l_tran_rec.input_value_id13,
p_input_value_id14 => l_tran_rec.input_value_id14,
p_input_value_id15 => l_tran_rec.input_value_id15,
p_entry_value1 => l_tran_rec.entry_value1,
p_entry_value2 => l_tran_rec.entry_value2,
p_entry_value3 => l_tran_rec.entry_value3,
p_entry_value4 => l_tran_rec.entry_value4,
p_entry_value5 => l_tran_rec.entry_value5,
p_entry_value6 => l_tran_rec.entry_value6,
p_entry_value7 => l_tran_rec.entry_value7,
p_entry_value8 => l_tran_rec.entry_value8,
p_entry_value9 => l_tran_rec.entry_value9,
p_entry_value10 => l_tran_rec.entry_value10,
p_entry_value11 => l_tran_rec.entry_value11,
p_entry_value12 => l_tran_rec.entry_value12,
p_entry_value13 => l_tran_rec.entry_value13,
p_entry_value14 => l_tran_rec.entry_value14,
p_entry_value15 => l_tran_rec.entry_value15,
p_effective_start_date => l_effective_start_date,
p_effective_end_date => l_effective_end_date,
p_element_entry_id => l_element_entry_id,
p_object_version_number => l_object_version_number,
p_create_warning => l_warning
);
elsif l_tran_rec.action_type = 'UPDATE' then
--
l_object_version_number := l_tran_rec.object_version_number;
pay_element_entry_api.update_element_entry
(
p_validate => p_validate,
p_datetrack_update_mode => l_tran_rec.date_track_option,
p_effective_date => l_tran_rec.effective_date,
p_business_group_id => l_tran_rec.business_group_id,
p_element_entry_id => l_tran_rec.element_entry_id,
p_object_version_number => l_object_version_number,
p_attribute_category => l_tran_rec.attribute_category,
p_attribute1 => l_tran_rec.attribute1,
p_attribute2 => l_tran_rec.attribute2,
p_attribute3 => l_tran_rec.attribute3,
p_attribute4 => l_tran_rec.attribute4,
p_attribute5 => l_tran_rec.attribute5,
p_attribute6 => l_tran_rec.attribute6,
p_attribute7 => l_tran_rec.attribute7,
p_attribute8 => l_tran_rec.attribute8,
p_attribute9 => l_tran_rec.attribute9,
p_attribute10 => l_tran_rec.attribute10,
p_attribute11 => l_tran_rec.attribute11,
p_attribute12 => l_tran_rec.attribute12,
p_attribute13 => l_tran_rec.attribute13,
p_attribute14 => l_tran_rec.attribute14,
p_attribute15 => l_tran_rec.attribute15,
p_attribute16 => l_tran_rec.attribute16,
p_attribute17 => l_tran_rec.attribute17,
p_attribute18 => l_tran_rec.attribute18,
p_attribute19 => l_tran_rec.attribute19,
p_attribute20 => l_tran_rec.attribute20,
p_input_value_id1 => l_tran_rec.input_value_id1,
p_input_value_id2 => l_tran_rec.input_value_id2,
p_input_value_id3 => l_tran_rec.input_value_id3,
p_input_value_id4 => l_tran_rec.input_value_id4,
p_input_value_id5 => l_tran_rec.input_value_id5,
p_input_value_id6 => l_tran_rec.input_value_id6,
p_input_value_id7 => l_tran_rec.input_value_id7,
p_input_value_id8 => l_tran_rec.input_value_id8,
p_input_value_id9 => l_tran_rec.input_value_id9,
p_input_value_id10 => l_tran_rec.input_value_id10,
p_input_value_id11 => l_tran_rec.input_value_id11,
p_input_value_id12 => l_tran_rec.input_value_id12,
p_input_value_id13 => l_tran_rec.input_value_id13,
p_input_value_id14 => l_tran_rec.input_value_id14,
p_input_value_id15 => l_tran_rec.input_value_id15,
p_entry_value1 => l_tran_rec.entry_value1,
p_entry_value2 => l_tran_rec.entry_value2,
p_entry_value3 => l_tran_rec.entry_value3,
p_entry_value4 => l_tran_rec.entry_value4,
p_entry_value5 => l_tran_rec.entry_value5,
p_entry_value6 => l_tran_rec.entry_value6,
p_entry_value7 => l_tran_rec.entry_value7,
p_entry_value8 => l_tran_rec.entry_value8,
p_entry_value9 => l_tran_rec.entry_value9,
p_entry_value10 => l_tran_rec.entry_value10,
p_entry_value11 => l_tran_rec.entry_value11,
p_entry_value12 => l_tran_rec.entry_value12,
p_entry_value13 => l_tran_rec.entry_value13,
p_entry_value14 => l_tran_rec.entry_value14,
p_entry_value15 => l_tran_rec.entry_value15,
p_effective_start_date => l_effective_start_date,
p_effective_end_date => l_effective_end_date,
p_update_warning => l_warning
);
elsif l_tran_rec.action_type = 'DELETE' then
--
l_object_version_number := l_tran_rec.object_version_number;
pay_element_entry_api.delete_element_entry
(
p_validate => p_validate,
p_datetrack_delete_mode => l_tran_rec.date_track_option,
p_effective_date => l_tran_rec.effective_date,
p_element_entry_id => l_tran_rec.element_entry_id,
p_object_version_number => l_object_version_number,
p_effective_start_date => l_effective_start_date,
p_effective_end_date => l_effective_end_date,
p_delete_warning => l_warning
);
select name,
datatype,
varchar2_value,
date_value,
number_value
from hr_api_transaction_values
where transaction_step_id = p_transaction_step_id;
g_txn_value_tbl.delete;