DBA Data[Home] [Help]

APPS.PQP_VEH_REPOS_EXTRA_INFO_API dependencies on PQP_VEH_REPOS_EXTRA_INFO

Line 1: Package Body PQP_VEH_REPOS_EXTRA_INFO_API as

1: Package Body PQP_VEH_REPOS_EXTRA_INFO_API as
2: /* $Header: pqvriapi.pkb 120.0.12010000.2 2008/08/08 07:23:34 ubhat ship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pqvriapi.pkb 120.0.12010000.2 2008/08/08 07:23:34 ubhat ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' PQP_VEH_REPOS_EXTRA_INFO_API.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |--------------------< CREATE_VEH_REPOS_EXTRA_INFO >--------------------|
10: -- ----------------------------------------------------------------------------

Line 100: pqp_veh_repos_extra_info_bk1.create_veh_repos_extra_info_b

96: --
97: -- Call Before Process User Hook
98: --
99: begin
100: pqp_veh_repos_extra_info_bk1.create_veh_repos_extra_info_b
101: ( p_vehicle_repository_id =>p_vehicle_repository_id
102: ,p_information_type =>p_information_type
103: ,p_vrei_attribute_category =>p_vrei_attribute_category
104: ,p_vrei_attribute1 =>p_vrei_attribute1

Line 163: (p_module_name => 'PQP_VEH_REPOS_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_REPOS_EXTRA_INFO_API'
164: ,p_hook_type => 'BP'
165: );
166: end;
167: --

Line 244: pqp_veh_repos_extra_info_bk1.create_veh_repos_extra_info_a

240: --
241: -- Call After Process User Hook
242: --
243: begin
244: pqp_veh_repos_extra_info_bk1.create_veh_repos_extra_info_a
245: ( p_vehicle_repository_id =>p_vehicle_repository_id
246: ,p_information_type =>p_information_type
247: ,p_vrei_attribute_category =>p_vrei_attribute_category
248: ,p_vrei_attribute1 =>p_vrei_attribute1

Line 309: (p_module_name => 'PQP_VEH_REPOS_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_REPOS_EXTRA_INFO_API'
310: ,p_hook_type => 'AP'
311: );
312: end;
313: --

Line 446: pqp_veh_repos_extra_info_bk2.update_veh_repos_extra_info_b

442: --
443: -- Call Before Process User Hook
444: --
445: begin
446: pqp_veh_repos_extra_info_bk2.update_veh_repos_extra_info_b
447: ( p_veh_repos_extra_info_id =>p_veh_repos_extra_info_id
448: ,p_object_version_number =>p_object_version_number
449: ,p_vehicle_repository_id =>p_vehicle_repository_id
450: ,p_information_type =>p_information_type

Line 511: (p_module_name => 'PQP_VEH_REPOS_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_REPOS_EXTRA_INFO_API'
512: ,p_hook_type => 'BP'
513: );
514: end;
515: --

Line 592: pqp_veh_repos_extra_info_bk2.update_veh_repos_extra_info_a

588: --
589: -- Call After Process User Hook
590: --
591: begin
592: pqp_veh_repos_extra_info_bk2.update_veh_repos_extra_info_a
593: ( p_veh_repos_extra_info_id => p_veh_repos_extra_info_id
594: ,p_object_version_number =>p_object_version_number
595: ,p_vehicle_repository_id =>p_vehicle_repository_id
596: ,p_information_type =>p_information_type

Line 657: (p_module_name => 'PQP_VEH_REPOS_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_REPOS_EXTRA_INFO_API'
658: ,p_hook_type => 'AP'
659: );
660: end;
661: --

Line 710: from pqp_veh_repos_extra_info vre

706: )
707: is
708: cursor csr_vr_id(c_veh_repos_extra_info_id in number) is
709: select vre.vehicle_repository_id
710: from pqp_veh_repos_extra_info vre
711: where vre.veh_repos_extra_info_id = c_veh_repos_extra_info_id;
712:
713: l_vehicle_repository_id number;
714: l_effective_date date;

Line 737: pqp_veh_repos_extra_info_bk3.delete_veh_repos_extra_info_b

733: --
734: -- Call Before Process User Hook
735: --
736: begin
737: pqp_veh_repos_extra_info_bk3.delete_veh_repos_extra_info_b
738: (p_veh_repos_extra_info_id => p_veh_repos_extra_info_id
739: ,p_vehicle_repository_id => l_vehicle_repository_id
740: ,p_object_version_number =>p_object_version_number
741: );

Line 745: (p_module_name => 'PQP_VEH_REPOS_EXTRA_INFO_API'

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

Line 764: pqp_veh_repos_extra_info_bk3.delete_veh_repos_extra_info_a

760: --
761: -- Call After Process User Hook
762: --
763: begin
764: pqp_veh_repos_extra_info_bk3.delete_veh_repos_extra_info_a
765: (p_veh_repos_extra_info_id => p_veh_repos_extra_info_id
766: ,p_vehicle_repository_id => l_vehicle_repository_id
767: ,p_object_version_number => p_object_version_number
768: );

Line 772: (p_module_name => 'PQP_VEH_REPOS_EXTRA_INFO_API'

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

Line 812: end PQP_VEH_REPOS_EXTRA_INFO_API;

808: --
809: hr_utility.set_location(' Leaving:'||l_proc, 90);
810: raise;
811: end delete_veh_repos_extra_info;
812: end PQP_VEH_REPOS_EXTRA_INFO_API;