APPS.PQP_VRE_DEL dependencies on PQP_VEH_REPOS_EXTRA_INFO

Line 242: from pqp_veh_repos_extra_info pve

238: cursor c_get_id (cp_vehicle_repository_id number)
239: is
240: select pve.veh_repos_extra_info_id
241: ,pve.object_version_number
242: from pqp_veh_repos_extra_info pve
243: where pve.vehicle_repository_id = cp_vehicle_repository_id;
244:
245: --
246: BEGIN

Line 257: -- Delete the rows from the table pqp_veh_repos_extra_info when the

253: ,p_validation_start_date => p_validation_start_date
254: ,p_validation_end_date => p_validation_end_date
255: );
256: --
257: -- Delete the rows from the table pqp_veh_repos_extra_info when the
258: -- vehicle is being purged from vehicle rep. table.
259: --
260: If p_datetrack_mode ='ZAP' Then
261: For vri_rec in c_get_id (p_rec.vehicle_repository_id)

Line 263: pqp_veh_repos_extra_info_api.delete_veh_repos_extra_info

259: --
260: If p_datetrack_mode ='ZAP' Then
261: For vri_rec in c_get_id (p_rec.vehicle_repository_id)
262: Loop
263: pqp_veh_repos_extra_info_api.delete_veh_repos_extra_info
264: (p_veh_repos_extra_info_id => vri_rec.veh_repos_extra_info_id
265: ,p_object_version_number => vri_rec.object_version_number
266: );
267: End Loop;