APPS.PQP_RIW_LOCATION_WRAPPER dependencies on HR_LOCATIONS_ALL

Line 8: g_location_rec hr_locations_all%rowtype;

4: -- =============================================================================
5: -- ~ Package Body Global variables:
6: -- =============================================================================
7: g_package varchar2(33) := 'pqp_riw_location_wrapper.';
8: g_location_rec hr_locations_all%rowtype;
9: g_style varchar2(7);
10: --==========================================================================
11: --Default Record Values
12: --==========================================================================

Line 14: return hr_locations_all%rowtype is

10: --==========================================================================
11: --Default Record Values
12: --==========================================================================
13: function Default_Location_Rec
14: return hr_locations_all%rowtype is
15: l_proc_name constant varchar2(150) := g_package||'Default_Locations_Rec';
16: l_location_rec hr_locations_all%rowtype;
17: Begin
18: hr_utility.set_location('Entering Default Rec' , 25);

Line 16: l_location_rec hr_locations_all%rowtype;

12: --==========================================================================
13: function Default_Location_Rec
14: return hr_locations_all%rowtype is
15: l_proc_name constant varchar2(150) := g_package||'Default_Locations_Rec';
16: l_location_rec hr_locations_all%rowtype;
17: Begin
18: hr_utility.set_location('Entering Default Rec' , 25);
19:
20: l_location_rec.LOCATION_CODE := hr_api.g_varchar2;

Line 122: return hr_locations_all%rowtype is

118: -- Get_Record_Values:
119: -- =============================================================================
120: function Get_Record_Values
121: (p_interface_code in varchar2 default null)
122: return hr_locations_all%rowtype is
123:
124: cursor bne_cols(c_interface_code in varchar2) is
125: select lower(bic.interface_col_name) interface_col_name
126: from bne_interface_cols_b bic

Line 138: l_location_rec hr_locations_all%rowtype;

134: from bne_interface_cols_b bic
135: where bic.interface_code = c_interface_code
136: and bic.display_flag ='N';
137:
138: l_location_rec hr_locations_all%rowtype;
139: col_name varchar2(150);
140: l_proc_name constant varchar2(150) := g_package||'Get_Record_Values';
141:
142: Begin

Line 428: select location_id from hr_locations_all where location_code = c_location_code

424: ,p_global_flag IN VARCHAR2 DEFAULT NULL) IS
425:
426:
427: cursor c_location_rec(c_location_code in varchar2, c_business_group_id in number) is
428: select location_id from hr_locations_all where location_code = c_location_code
429: and business_group_id = c_business_group_id;
430:
431: l_location_id number;
432: l_object_version_number number;

Line 443: temp_rec hr_locations_all%rowtype;

439: l_proc varchar2(72) := g_package ||'PQP_RIW_LOCATION_WRAPPER';
440: l_migration_flag varchar2(10);
441: l_business_group_id number(10);
442:
443: temp_rec hr_locations_all%rowtype;
444:
445: begin
446: hr_utility.set_location('Entered PQP_RIW_LOCATION_WRAPPER.INSUPD_LOCATION', 5);
447:

Line 572: select style into g_style from hr_locations_all where location_id = l_location_id;

568: ,p_object_version_number => l_object_version_number
569: );
570: else
571:
572: select style into g_style from hr_locations_all where location_id = l_location_id;
573:
574: g_location_rec.location_code := p_location_code;
575: g_location_rec.description := p_description;
576: g_location_rec.timezone_code := p_timezone_code;

Line 657: hr_locations_all where location_id = l_location_id;

653:
654: temp_rec := Get_Record_Values(p_interface_code => p_interface_code);
655:
656: select object_version_number into l_object_version_number from
657: hr_locations_all where location_id = l_location_id;
658:
659: hr_location_api.update_location(
660: p_validate => false
661: ,p_effective_date => p_effective_date