[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE dt_insert_dml
(p_rec IN out nocopy pqp_vre_shd.g_rec_type
,p_effective_date IN DATE
,p_datetrack_mode IN VARCHAR2
,p_validation_start_date IN DATE
,p_validation_end_date IN DATE
) IS
-- Cursor to select 'old' created AOL who column values
--
CURSOR C_Sel1 IS
SELECT t.created_by,
t.creation_date
FROM pqp_vehicle_repository_f t
WHERE t.vehicle_repository_id = p_rec.vehicle_repository_id
AND t.effective_start_date =
pqp_vre_shd.g_old_rec.effective_start_date
AND t.effective_end_date = (p_validation_start_date - 1);
l_proc varchar2(72) := g_package||'dt_insert_dml';
l_last_update_date pqp_vehicle_repository_f.last_update_date%TYPE;
l_last_updated_by pqp_vehicle_repository_f.last_updated_by%TYPE;
l_last_update_login pqp_vehicle_repository_f.last_update_login%TYPE;
IF (p_datetrack_mode <> hr_api.g_insert) THEN
hr_utility.set_location(l_proc, 10);
l_last_update_date := sysdate;
l_last_updated_by := fnd_global.user_id;
l_last_update_login := fnd_global.login_id;
INSERT INTO pqp_vehicle_repository_f
(vehicle_repository_id
,effective_start_date
,effective_end_date
,registration_number
,vehicle_type
,vehicle_id_number
,business_group_id
,make
,model
,initial_registration
,last_registration_renew_date
,engine_capacity_in_cc
,fuel_type
,currency_code
,list_price
,accessory_value_at_startdate
,accessory_value_added_later
,market_value_classic_car
,fiscal_ratings
,fiscal_ratings_uom
,vehicle_provider
,vehicle_ownership
,shared_vehicle
,vehicle_status
,vehicle_inactivity_reason
,asset_number
,lease_contract_number
,lease_contract_expiry_date
,taxation_method
,fleet_info
,fleet_transfer_date
,object_version_number
,color
,seating_capacity
,weight
,weight_uom
,model_year
,insurance_number
,insurance_expiry_date
,comments
,vre_attribute_category
,vre_attribute1
,vre_attribute2
,vre_attribute3
,vre_attribute4
,vre_attribute5
,vre_attribute6
,vre_attribute7
,vre_attribute8
,vre_attribute9
,vre_attribute10
,vre_attribute11
,vre_attribute12
,vre_attribute13
,vre_attribute14
,vre_attribute15
,vre_attribute16
,vre_attribute17
,vre_attribute18
,vre_attribute19
,vre_attribute20
,vre_information_category
,vre_information1
,vre_information2
,vre_information3
,vre_information4
,vre_information5
,vre_information6
,vre_information7
,vre_information8
,vre_information9
,vre_information10
,vre_information11
,vre_information12
,vre_information13
,vre_information14
,vre_information15
,vre_information16
,vre_information17
,vre_information18
,vre_information19
,vre_information20
,created_by
,creation_date
,last_update_date
,last_updated_by
,last_update_login
)
VALUES
(p_rec.vehicle_repository_id
,p_rec.effective_start_date
,p_rec.effective_end_date
,p_rec.registration_number
,p_rec.vehicle_type
,p_rec.vehicle_id_number
,p_rec.business_group_id
,p_rec.make
,p_rec.model
,p_rec.initial_registration
,p_rec.last_registration_renew_date
,p_rec.engine_capacity_in_cc
,p_rec.fuel_type
,p_rec.currency_code
,p_rec.list_price
,p_rec.accessory_value_at_startdate
,p_rec.accessory_value_added_later
,p_rec.market_value_classic_car
,p_rec.fiscal_ratings
,p_rec.fiscal_ratings_uom
,p_rec.vehicle_provider
,p_rec.vehicle_ownership
,p_rec.shared_vehicle
,p_rec.vehicle_status
,p_rec.vehicle_inactivity_reason
,p_rec.asset_number
,p_rec.lease_contract_number
,p_rec.lease_contract_expiry_date
,p_rec.taxation_method
,p_rec.fleet_info
,p_rec.fleet_transfer_date
,p_rec.object_version_number
,p_rec.color
,p_rec.seating_capacity
,p_rec.weight
,p_rec.weight_uom
,p_rec.model_year
,p_rec.insurance_number
,p_rec.insurance_expiry_date
,p_rec.comments
,p_rec.vre_attribute_category
,p_rec.vre_attribute1
,p_rec.vre_attribute2
,p_rec.vre_attribute3
,p_rec.vre_attribute4
,p_rec.vre_attribute5
,p_rec.vre_attribute6
,p_rec.vre_attribute7
,p_rec.vre_attribute8
,p_rec.vre_attribute9
,p_rec.vre_attribute10
,p_rec.vre_attribute11
,p_rec.vre_attribute12
,p_rec.vre_attribute13
,p_rec.vre_attribute14
,p_rec.vre_attribute15
,p_rec.vre_attribute16
,p_rec.vre_attribute17
,p_rec.vre_attribute18
,p_rec.vre_attribute19
,p_rec.vre_attribute20
,p_rec.vre_information_category
,p_rec.vre_information1
,p_rec.vre_information2
,p_rec.vre_information3
,p_rec.vre_information4
,p_rec.vre_information5
,p_rec.vre_information6
,p_rec.vre_information7
,p_rec.vre_information8
,p_rec.vre_information9
,p_rec.vre_information10
,p_rec.vre_information11
,p_rec.vre_information12
,p_rec.vre_information13
,p_rec.vre_information14
,p_rec.vre_information15
,p_rec.vre_information16
,p_rec.vre_information17
,p_rec.vre_information18
,p_rec.vre_information19
,p_rec.vre_information20
,l_created_by
,l_creation_date
,l_last_update_date
,l_last_updated_by
,l_last_update_login
);
END dt_insert_dml;
PROCEDURE insert_dml
(p_rec IN OUT NOCOPY pqp_vre_shd.g_rec_type
,p_effective_date IN DATE
,p_datetrack_mode IN VARCHAR2
,p_validation_start_date IN DATE
,p_validation_end_date IN DATE
) IS
--
l_proc varchar2(72) := g_package||'insert_dml';
pqp_vre_ins.dt_insert_dml
(p_rec => p_rec
,p_effective_date => p_effective_date
,p_datetrack_mode => p_datetrack_mode
,p_validation_start_date => p_validation_start_date
,p_validation_end_date => p_validation_end_date
);
END insert_dml;
PROCEDURE pre_insert
(p_rec IN OUT NOCOPY pqp_vre_shd.g_rec_type
,p_effective_date IN DATE
,p_datetrack_mode IN VARCHAR2
,p_validation_start_date IN DATE
,p_validation_end_date IN DATE
) IS
--
Cursor C_Sel1 is select pqp_vehicle_repository_s.nextval from sys.dual;
SELECT NULL
FROM pqp_vehicle_repository_f
WHERE vehicle_repository_id =
pqp_vre_ins.g_vehicle_repository_id_i;
l_proc VARCHAR2(72) := g_package||'pre_insert';
END pre_insert;
PROCEDURE post_insert
(p_rec IN pqp_vre_shd.g_rec_type
,p_effective_date IN DATE
,p_datetrack_mode IN VARCHAR2
,p_validation_start_date IN DATE
,p_validation_end_date IN DATE
) IS
--
l_proc VARCHAR2(72) := g_package||'post_insert';
pqp_vre_rki.after_insert
(p_effective_date => p_effective_date
,p_validation_start_date => p_validation_start_date
,p_validation_end_date => p_validation_end_date
,p_vehicle_repository_id => p_rec.vehicle_repository_id
,p_effective_start_date => p_rec.effective_start_date
,p_effective_end_date => p_rec.effective_end_date
,p_registration_number => p_rec.registration_number
,p_vehicle_type => p_rec.vehicle_type
,p_vehicle_id_number => p_rec.vehicle_id_number
,p_business_group_id => p_rec.business_group_id
,p_make => p_rec.make
,p_model => p_rec.model
,p_initial_registration => p_rec.initial_registration
,p_last_registration_renew_date => p_rec.last_registration_renew_date
,p_engine_capacity_in_cc => p_rec.engine_capacity_in_cc
,p_fuel_type => p_rec.fuel_type
,p_currency_code => p_rec.currency_code
,p_list_price => p_rec.list_price
,p_accessory_value_at_startdate => p_rec.accessory_value_at_startdate
,p_accessory_value_added_later => p_rec.accessory_value_added_later
,p_market_value_classic_car => p_rec.market_value_classic_car
,p_fiscal_ratings => p_rec.fiscal_ratings
,p_fiscal_ratings_uom => p_rec.fiscal_ratings_uom
,p_vehicle_provider => p_rec.vehicle_provider
,p_vehicle_ownership => p_rec.vehicle_ownership
,p_shared_vehicle => p_rec.shared_vehicle
,p_vehicle_status => p_rec.vehicle_status
,p_vehicle_inactivity_reason => p_rec.vehicle_inactivity_reason
,p_asset_number => p_rec.asset_number
,p_lease_contract_number => p_rec.lease_contract_number
,p_lease_contract_expiry_date => p_rec.lease_contract_expiry_date
,p_taxation_method => p_rec.taxation_method
,p_fleet_info => p_rec.fleet_info
,p_fleet_transfer_date => p_rec.fleet_transfer_date
,p_object_version_number => p_rec.object_version_number
,p_color => p_rec.color
,p_seating_capacity => p_rec.seating_capacity
,p_weight => p_rec.weight
,p_weight_uom => p_rec.weight_uom
,p_model_year => p_rec.model_year
,p_insurance_number => p_rec.insurance_number
,p_insurance_expiry_date => p_rec.insurance_expiry_date
,p_comments => p_rec.comments
,p_vre_attribute_category => p_rec.vre_attribute_category
,p_vre_attribute1 => p_rec.vre_attribute1
,p_vre_attribute2 => p_rec.vre_attribute2
,p_vre_attribute3 => p_rec.vre_attribute3
,p_vre_attribute4 => p_rec.vre_attribute4
,p_vre_attribute5 => p_rec.vre_attribute5
,p_vre_attribute6 => p_rec.vre_attribute6
,p_vre_attribute7 => p_rec.vre_attribute7
,p_vre_attribute8 => p_rec.vre_attribute8
,p_vre_attribute9 => p_rec.vre_attribute9
,p_vre_attribute10 => p_rec.vre_attribute10
,p_vre_attribute11 => p_rec.vre_attribute11
,p_vre_attribute12 => p_rec.vre_attribute12
,p_vre_attribute13 => p_rec.vre_attribute13
,p_vre_attribute14 => p_rec.vre_attribute14
,p_vre_attribute15 => p_rec.vre_attribute15
,p_vre_attribute16 => p_rec.vre_attribute16
,p_vre_attribute17 => p_rec.vre_attribute17
,p_vre_attribute18 => p_rec.vre_attribute18
,p_vre_attribute19 => p_rec.vre_attribute19
,p_vre_attribute20 => p_rec.vre_attribute20
,p_vre_information_category => p_rec.vre_information_category
,p_vre_information1 => p_rec.vre_information1
,p_vre_information2 => p_rec.vre_information2
,p_vre_information3 => p_rec.vre_information3
,p_vre_information4 => p_rec.vre_information4
,p_vre_information5 => p_rec.vre_information5
,p_vre_information6 => p_rec.vre_information6
,p_vre_information7 => p_rec.vre_information7
,p_vre_information8 => p_rec.vre_information8
,p_vre_information9 => p_rec.vre_information9
,p_vre_information10 => p_rec.vre_information10
,p_vre_information11 => p_rec.vre_information11
,p_vre_information12 => p_rec.vre_information12
,p_vre_information13 => p_rec.vre_information13
,p_vre_information14 => p_rec.vre_information14
,p_vre_information15 => p_rec.vre_information15
,p_vre_information16 => p_rec.vre_information16
,p_vre_information17 => p_rec.vre_information17
,p_vre_information18 => p_rec.vre_information18
,p_vre_information19 => p_rec.vre_information19
,p_vre_information20 => p_rec.vre_information20
);
END post_insert;
l_datetrack_mode varchar2(30) := hr_api.g_insert;
pqp_vre_bus.insert_validate
(p_rec => p_rec
,p_effective_date => p_effective_date
,p_datetrack_mode => l_datetrack_mode
,p_validation_start_date => l_validation_start_date
,p_validation_end_date => l_validation_end_date
);
pqp_vre_ins.pre_insert
(p_rec => p_rec
,p_effective_date => p_effective_date
,p_datetrack_mode => l_datetrack_mode
,p_validation_start_date => l_validation_start_date
,p_validation_end_date => l_validation_end_date
);
pqp_vre_ins.insert_dml
(p_rec => p_rec
,p_effective_date => p_effective_date
,p_datetrack_mode => l_datetrack_mode
,p_validation_start_date => l_validation_start_date
,p_validation_end_date => l_validation_end_date
);
pqp_vre_ins.post_insert
(p_rec => p_rec
,p_effective_date => p_effective_date
,p_datetrack_mode => l_datetrack_mode
,p_validation_start_date => l_validation_start_date
,p_validation_end_date => l_validation_end_date
);