DBA Data[Home] [Help]

APPS.PAY_JP_PROCESS_CMI_SS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 50

	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;
Line: 87

		l_ev_rec_tbl(12).entry_value := fnd_date.date_to_canonical(p_update_date);
Line: 88

		l_ev_rec_tbl(13).entry_value := p_update_reason_code;
Line: 159

	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);
Line: 651

	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
		--
	);
Line: 808

	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
		--
	);
Line: 955

	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;
Line: 1032

		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
		--
	);
Line: 1058

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;
Line: 1125

	l_update_warning        boolean;
Line: 1129

	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
		--
	);
Line: 1208

end update_train_entry;
Line: 1272

	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;
Line: 1350

		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
		--
	);
Line: 1375

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;
Line: 1445

	l_update_warning        boolean;
Line: 1449

	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
		--
	);
Line: 1528

end update_car_entry;
Line: 1533

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;
Line: 1554

	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
	);
Line: 1576

end delete_entry;
Line: 1601

		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
	);
Line: 1816

	-- 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));
Line: 1827

	hr_util_misc_web.insert_session_row(l_tran_rec.effective_date);
Line: 1829

	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
		);
Line: 1897

	elsif l_tran_rec.action_type = 'UPDATE' then
		--
		l_object_version_number := l_tran_rec.object_version_number;
Line: 1901

		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
		);
Line: 1965

	elsif l_tran_rec.action_type = 'DELETE' then
		--
		l_object_version_number := l_tran_rec.object_version_number;
Line: 1969

		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
		);
Line: 1996

  select name,
         datatype,
         varchar2_value,
         date_value,
         number_value
  from   hr_api_transaction_values
  where  transaction_step_id = p_transaction_step_id;
Line: 2015

    g_txn_value_tbl.delete;