DBA Data[Home] [Help]

APPS.PQP_GENERIC_EIT_SS dependencies on PQP_VEH_ALLOC_EXTRA_INFO

Line 35: FROM pqp_veh_alloc_extra_info pvaei

31:
32: CURSOR c_get_ovn_alloc
33: IS
34: SELECT pvaei.object_version_number
35: FROM pqp_veh_alloc_extra_info pvaei
36: WHERE pvaei.veh_alloc_extra_info_id = p_extra_info_id
37: AND pvaei.vehicle_allocation_id=p_key_id;
38:
39: l_ovn pqp_veh_alloc_extra_info.object_version_number%TYPE;

Line 39: l_ovn pqp_veh_alloc_extra_info.object_version_number%TYPE;

35: FROM pqp_veh_alloc_extra_info pvaei
36: WHERE pvaei.veh_alloc_extra_info_id = p_extra_info_id
37: AND pvaei.vehicle_allocation_id=p_key_id;
38:
39: l_ovn pqp_veh_alloc_extra_info.object_version_number%TYPE;
40: BEGIN
41: IF p_eit_type='REPOSITORY' THEN
42: OPEN c_get_ovn_rep;
43: FETCH c_get_ovn_rep INTO l_ovn;

Line 232: pqp_veh_alloc_extra_info_api.create_veh_alloc_extra_info

228: ,p_object_version_number => p_object_version_number
229: );
230:
231: ELSIF p_eit_type= 'ALLOCATION' THEN
232: pqp_veh_alloc_extra_info_api.create_veh_alloc_extra_info
233: (p_validate => false
234: ,p_vehicle_allocation_id => p_eit_type_id
235: ,p_information_type => p_information_type
236: ,p_vaei_attribute_category => p_attribute_category

Line 367: pqp_veh_alloc_extra_info_api.update_veh_alloc_extra_info

363: ( p_eit_type => p_eit_type
364: ,p_extra_info_id => p_extra_info_id
365: ,p_key_id => p_eit_type_id
366: );
367: pqp_veh_alloc_extra_info_api.update_veh_alloc_extra_info
368: (p_validate => false
369: ,p_veh_alloc_extra_info_id => p_extra_info_id
370: ,p_object_version_number => l_object_version_number
371: ,p_vehicle_allocation_id => p_eit_type_id

Line 447: pqp_veh_alloc_extra_info_api.delete_veh_alloc_extra_info

443: ( p_eit_type => p_eit_type
444: ,p_extra_info_id => p_extra_info_id
445: ,p_key_id => p_eit_type_id
446: );
447: pqp_veh_alloc_extra_info_api.delete_veh_alloc_extra_info
448: (p_validate => false
449: ,p_veh_alloc_extra_info_id => p_extra_info_id
450: ,p_object_version_number => l_object_version_number
451: );