DBA Data[Home] [Help]

APPS.PQP_VEH_ALLOC_EXTRA_INFO_API dependencies on PQP_VEH_ALLOC_EXTRA_INFO

Line 1: Package Body PQP_VEH_ALLOC_EXTRA_INFO_API as

1: Package Body PQP_VEH_ALLOC_EXTRA_INFO_API as
2: /* $Header: pqvaiapi.pkb 120.0.12010000.2 2008/08/08 07:17:43 ubhat ship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' PQP_VEH_ALLOC_EXTRA_INFO_API.';

2: /* $Header: pqvaiapi.pkb 120.0.12010000.2 2008/08/08 07:17:43 ubhat ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' PQP_VEH_ALLOC_EXTRA_INFO_API.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |--------------------< CREATE_VEH_ALLOC_EXTRA_INFO >--------------------|
10: -- ----------------------------------------------------------------------------

Line 100: pqp_veh_alloc_extra_info_bk1.create_veh_alloc_extra_info_b

96: --
97: -- Call Before Process User Hook
98: --
99: begin
100: pqp_veh_alloc_extra_info_bk1.create_veh_alloc_extra_info_b
101: ( p_vehicle_allocation_id =>p_vehicle_allocation_id
102: ,p_information_type =>p_information_type
103: ,p_vaei_attribute_category =>p_vaei_attribute_category
104: ,p_vaei_attribute1 =>p_vaei_attribute1

Line 163: (p_module_name => 'PQP_VEH_ALLOC_EXTRA_INFO_API'

159: );
160: exception
161: when hr_api.cannot_find_prog_unit then
162: hr_api.cannot_find_prog_unit_error
163: (p_module_name => 'PQP_VEH_ALLOC_EXTRA_INFO_API'
164: ,p_hook_type => 'BP'
165: );
166: end;
167: --

Line 244: pqp_veh_alloc_extra_info_bk1.create_veh_alloc_extra_info_a

240: --
241: -- Call After Process User Hook
242: --
243: begin
244: pqp_veh_alloc_extra_info_bk1.create_veh_alloc_extra_info_a
245: ( p_vehicle_allocation_id =>p_vehicle_allocation_id
246: ,p_information_type =>p_information_type
247: ,p_vaei_attribute_category =>p_vaei_attribute_category
248: ,p_vaei_attribute1 =>p_vaei_attribute1

Line 309: (p_module_name => 'PQP_VEH_ALLOC_EXTRA_INFO_API'

305: );
306: exception
307: when hr_api.cannot_find_prog_unit then
308: hr_api.cannot_find_prog_unit_error
309: (p_module_name => 'PQP_VEH_ALLOC_EXTRA_INFO_API'
310: ,p_hook_type => 'AP'
311: );
312: end;
313: --

Line 446: pqp_veh_alloc_extra_info_bk2.update_veh_alloc_extra_info_b

442: --
443: -- Call Before Process User Hook
444: --
445: begin
446: pqp_veh_alloc_extra_info_bk2.update_veh_alloc_extra_info_b
447: ( p_veh_alloc_extra_info_id =>p_veh_alloc_extra_info_id
448: ,p_object_version_number =>p_object_version_number
449: ,p_vehicle_allocation_id =>p_vehicle_allocation_id
450: ,p_information_type =>p_information_type

Line 511: (p_module_name => 'PQP_VEH_ALLOC_EXTRA_INFO_API'

507: );
508: exception
509: when hr_api.cannot_find_prog_unit then
510: hr_api.cannot_find_prog_unit_error
511: (p_module_name => 'PQP_VEH_ALLOC_EXTRA_INFO_API'
512: ,p_hook_type => 'BP'
513: );
514: end;
515: --

Line 592: pqp_veh_alloc_extra_info_bk2.update_veh_alloc_extra_info_a

588: --
589: -- Call After Process User Hook
590: --
591: begin
592: pqp_veh_alloc_extra_info_bk2.update_veh_alloc_extra_info_a
593: ( p_veh_alloc_extra_info_id => p_veh_alloc_extra_info_id
594: ,p_object_version_number =>p_object_version_number
595: ,p_vehicle_allocation_id =>p_vehicle_allocation_id
596: ,p_information_type =>p_information_type

Line 657: (p_module_name => 'PQP_VEH_ALLOC_EXTRA_INFO_API'

653: );
654: exception
655: when hr_api.cannot_find_prog_unit then
656: hr_api.cannot_find_prog_unit_error
657: (p_module_name => 'PQP_VEH_ALLOC_EXTRA_INFO_API'
658: ,p_hook_type => 'AP'
659: );
660: end;
661: --

Line 710: from pqp_veh_alloc_extra_info vae

706: )
707: is
708: cursor csr_veh_id (c_veh_alloc_extra_info_id in number) is
709: select vae.vehicle_allocation_id
710: from pqp_veh_alloc_extra_info vae
711: where vae.veh_alloc_extra_info_id = c_veh_alloc_extra_info_id;
712:
713: l_vehicle_allocation_id number;
714: l_effective_date date;

Line 738: pqp_veh_alloc_extra_info_bk3.delete_veh_alloc_extra_info_b

734: --
735: -- Call Before Process User Hook
736: --
737: begin
738: pqp_veh_alloc_extra_info_bk3.delete_veh_alloc_extra_info_b
739: (p_veh_alloc_extra_info_id => p_veh_alloc_extra_info_id
740: ,p_vehicle_allocation_id => l_vehicle_allocation_id
741: ,p_object_version_number =>p_object_version_number
742: );

Line 746: (p_module_name => 'PQP_VEH_ALLOC_EXTRA_INFO_API'

742: );
743: exception
744: when hr_api.cannot_find_prog_unit then
745: hr_api.cannot_find_prog_unit_error
746: (p_module_name => 'PQP_VEH_ALLOC_EXTRA_INFO_API'
747: ,p_hook_type => 'BP'
748: );
749: end;
750: --

Line 765: pqp_veh_alloc_extra_info_bk3.delete_veh_alloc_extra_info_a

761: --
762: -- Call After Process User Hook
763: --
764: begin
765: pqp_veh_alloc_extra_info_bk3.delete_veh_alloc_extra_info_a
766: (p_veh_alloc_extra_info_id => p_veh_alloc_extra_info_id
767: ,p_vehicle_allocation_id => l_vehicle_allocation_id
768: ,p_object_version_number =>p_object_version_number
769: );

Line 773: (p_module_name => 'PQP_VEH_ALLOC_EXTRA_INFO_API'

769: );
770: exception
771: when hr_api.cannot_find_prog_unit then
772: hr_api.cannot_find_prog_unit_error
773: (p_module_name => 'PQP_VEH_ALLOC_EXTRA_INFO_API'
774: ,p_hook_type => 'AP'
775: );
776: end;
777: --

Line 813: end PQP_VEH_ALLOC_EXTRA_INFO_API;

809: --
810: hr_utility.set_location(' Leaving:'||l_proc, 90);
811: raise;
812: end delete_veh_alloc_extra_info;
813: end PQP_VEH_ALLOC_EXTRA_INFO_API;