eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_LOC_BUS dependencies on HR_LOCATIONS

Line 23: (p_location_id IN hr_locations.location_id%TYPE

19: -- |----------------------< return_legislation_code >--------------------|
20: -- -----------------------------------------------------------------------
21: --
22: FUNCTION return_legislation_code
23: (p_location_id IN hr_locations.location_id%TYPE
24: ) RETURN VARCHAR2 IS
25: --
26: -- Declare local variables
27: --

Line 38: FROM hr_locations_all

34: -- legislation code.
35: --
36: cursor csr_bus_grp_id IS
37: SELECT business_group_id
38: FROM hr_locations_all
39: WHERE location_id = p_location_id;
40: --
41: -- Cursor to find legislation code. l_business_group_id
42: -- is set using csr_bus_grp_id (above).

Line 133: -- i) Check SHIP_TO_LOCATION_ID is valid within the HR_LOCATIONS_ALL table,

129: -- Process Logic:
130: --
131: -- Only perform validation if SHIP_TO_LOCATION_ID is not NULL.
132: --
133: -- i) Check SHIP_TO_LOCATION_ID is valid within the HR_LOCATIONS_ALL table,
134: -- and its SHIP_TO_SITE_FLAG is 'Y'
135: --
136: -- ii) If SHIP_TO_LOCATION_ID references a location other LOCATION_ID,
137: -- ensure that the current location's SHIP_TO_SITE_FLAG is 'N'.

Line 169: ( p_location_id IN hr_locations.location_id%TYPE,

165: --
166: -- {End Of Comments}
167: --
168: PROCEDURE chk_ship_to_loc_id_and_flag
169: ( p_location_id IN hr_locations.location_id%TYPE,
170: p_ship_to_location_id IN OUT NOCOPY hr_locations.ship_to_location_id%TYPE,
171: p_ship_to_site_flag IN hr_locations.ship_to_site_flag%TYPE,
172: p_inactive_date IN hr_locations.inactive_date%TYPE,
173: p_business_group_id IN hr_locations.business_group_id%TYPE,

Line 170: p_ship_to_location_id IN OUT NOCOPY hr_locations.ship_to_location_id%TYPE,

166: -- {End Of Comments}
167: --
168: PROCEDURE chk_ship_to_loc_id_and_flag
169: ( p_location_id IN hr_locations.location_id%TYPE,
170: p_ship_to_location_id IN OUT NOCOPY hr_locations.ship_to_location_id%TYPE,
171: p_ship_to_site_flag IN hr_locations.ship_to_site_flag%TYPE,
172: p_inactive_date IN hr_locations.inactive_date%TYPE,
173: p_business_group_id IN hr_locations.business_group_id%TYPE,
174: p_effective_date IN DATE )

Line 171: p_ship_to_site_flag IN hr_locations.ship_to_site_flag%TYPE,

167: --
168: PROCEDURE chk_ship_to_loc_id_and_flag
169: ( p_location_id IN hr_locations.location_id%TYPE,
170: p_ship_to_location_id IN OUT NOCOPY hr_locations.ship_to_location_id%TYPE,
171: p_ship_to_site_flag IN hr_locations.ship_to_site_flag%TYPE,
172: p_inactive_date IN hr_locations.inactive_date%TYPE,
173: p_business_group_id IN hr_locations.business_group_id%TYPE,
174: p_effective_date IN DATE )
175: IS

Line 172: p_inactive_date IN hr_locations.inactive_date%TYPE,

168: PROCEDURE chk_ship_to_loc_id_and_flag
169: ( p_location_id IN hr_locations.location_id%TYPE,
170: p_ship_to_location_id IN OUT NOCOPY hr_locations.ship_to_location_id%TYPE,
171: p_ship_to_site_flag IN hr_locations.ship_to_site_flag%TYPE,
172: p_inactive_date IN hr_locations.inactive_date%TYPE,
173: p_business_group_id IN hr_locations.business_group_id%TYPE,
174: p_effective_date IN DATE )
175: IS
176: --

Line 173: p_business_group_id IN hr_locations.business_group_id%TYPE,

169: ( p_location_id IN hr_locations.location_id%TYPE,
170: p_ship_to_location_id IN OUT NOCOPY hr_locations.ship_to_location_id%TYPE,
171: p_ship_to_site_flag IN hr_locations.ship_to_site_flag%TYPE,
172: p_inactive_date IN hr_locations.inactive_date%TYPE,
173: p_business_group_id IN hr_locations.business_group_id%TYPE,
174: p_effective_date IN DATE )
175: IS
176: --
177: l_exists VARCHAR2(1);

Line 183: FROM hr_locations_all

179: --
180: cursor csr_valid_ship_to_loc IS
181: --
182: SELECT NULL
183: FROM hr_locations_all
184: WHERE location_id = p_ship_to_location_id
185: AND ship_to_site_flag = 'Y'
186: AND nvl(inactive_date, hr_api.g_eot) >= p_effective_date
187: AND ( p_business_group_id IS NULL

Line 196: -- valid location on HR_LOCATIONS_ALL

192: hr_utility.set_location('Entering:'|| l_proc, 10);
193:
194: --
195: -- Check that the ship to location ID is linked to a
196: -- valid location on HR_LOCATIONS_ALL
197: --
198: hr_utility.set_location(l_proc, 20);
199: --
200: --

Line 339: ( p_ship_to_site_flag IN OUT NOCOPY hr_locations.ship_to_site_flag%TYPE,

335: --
336: -- {End Of Comments}
337: --
338: PROCEDURE chk_receiving_site_flag
339: ( p_ship_to_site_flag IN OUT NOCOPY hr_locations.ship_to_site_flag%TYPE,
340: p_receiving_site_flag IN OUT NOCOPY hr_locations.receiving_site_flag%TYPE )
341: IS
342: --
343: l_proc VARCHAR2(72) := g_package||'chk_receiving_site_flag';

Line 340: p_receiving_site_flag IN OUT NOCOPY hr_locations.receiving_site_flag%TYPE )

336: -- {End Of Comments}
337: --
338: PROCEDURE chk_receiving_site_flag
339: ( p_ship_to_site_flag IN OUT NOCOPY hr_locations.ship_to_site_flag%TYPE,
340: p_receiving_site_flag IN OUT NOCOPY hr_locations.receiving_site_flag%TYPE )
341: IS
342: --
343: l_proc VARCHAR2(72) := g_package||'chk_receiving_site_flag';
344: --

Line 393: ( p_designated_receiver_id IN hr_locations.designated_receiver_id%TYPE,

389: --
390: -- {End Of Comments}
391: --
392: PROCEDURE chk_designated_receiver_id
393: ( p_designated_receiver_id IN hr_locations.designated_receiver_id%TYPE,
394: p_location_id IN hr_locations.location_id%TYPE,
395: p_business_group_id IN hr_locations.business_group_id%TYPE,
396: p_effective_date IN DATE
397: )

Line 394: p_location_id IN hr_locations.location_id%TYPE,

390: -- {End Of Comments}
391: --
392: PROCEDURE chk_designated_receiver_id
393: ( p_designated_receiver_id IN hr_locations.designated_receiver_id%TYPE,
394: p_location_id IN hr_locations.location_id%TYPE,
395: p_business_group_id IN hr_locations.business_group_id%TYPE,
396: p_effective_date IN DATE
397: )
398: IS

Line 395: p_business_group_id IN hr_locations.business_group_id%TYPE,

391: --
392: PROCEDURE chk_designated_receiver_id
393: ( p_designated_receiver_id IN hr_locations.designated_receiver_id%TYPE,
394: p_location_id IN hr_locations.location_id%TYPE,
395: p_business_group_id IN hr_locations.business_group_id%TYPE,
396: p_effective_date IN DATE
397: )
398: IS
399: --

Line 480: (p_inactive_date IN hr_locations.inactive_date%TYPE,

476: --
477: -- {End Of Comments}
478: --
479: PROCEDURE chk_inactive_date
480: (p_inactive_date IN hr_locations.inactive_date%TYPE,
481: p_effective_date IN DATE,
482: p_location_id IN hr_locations.location_id%TYPE)
483: IS
484: --

Line 482: p_location_id IN hr_locations.location_id%TYPE)

478: --
479: PROCEDURE chk_inactive_date
480: (p_inactive_date IN hr_locations.inactive_date%TYPE,
481: p_effective_date IN DATE,
482: p_location_id IN hr_locations.location_id%TYPE)
483: IS
484: --
485: l_proc VARCHAR2(72) := g_package||'chk_inactive_date';
486: --

Line 535: ( p_inventory_organization_id IN hr_locations.inventory_organization_id%TYPE,

531: --
532: -- {End Of Comments}
533: --
534: PROCEDURE chk_inventory_organization_id
535: ( p_inventory_organization_id IN hr_locations.inventory_organization_id%TYPE,
536: p_effective_date IN DATE,
537: p_location_id IN hr_locations.location_id%TYPE,
538: p_operating_unit_id IN NUMBER)
539: IS

Line 537: p_location_id IN hr_locations.location_id%TYPE,

533: --
534: PROCEDURE chk_inventory_organization_id
535: ( p_inventory_organization_id IN hr_locations.inventory_organization_id%TYPE,
536: p_effective_date IN DATE,
537: p_location_id IN hr_locations.location_id%TYPE,
538: p_operating_unit_id IN NUMBER)
539: IS
540: l_proc VARCHAR2(72) := g_package||'chk_inventory_organization_id';
541: l_exists VARCHAR2(1);

Line 644: ( p_tax_name IN hr_locations.tax_name%TYPE,

640: --
641: -- {End Of Comments}
642: --
643: PROCEDURE chk_tax_name
644: ( p_tax_name IN hr_locations.tax_name%TYPE,
645: p_effective_date IN DATE,
646: p_location_id IN hr_locations.location_id%TYPE)
647: IS
648: l_proc VARCHAR2(72) := g_package||'chk_tax_name';

Line 646: p_location_id IN hr_locations.location_id%TYPE)

642: --
643: PROCEDURE chk_tax_name
644: ( p_tax_name IN hr_locations.tax_name%TYPE,
645: p_effective_date IN DATE,
646: p_location_id IN hr_locations.location_id%TYPE)
647: IS
648: l_proc VARCHAR2(72) := g_package||'chk_tax_name';
649: l_exists VARCHAR2(1);
650: --

Line 739: (p_style IN hr_locations.style%TYPE,

735: --
736: -- {End Of Comments}
737: --
738: PROCEDURE chk_style
739: (p_style IN hr_locations.style%TYPE,
740: p_location_id IN hr_locations.location_id%TYPE )
741: IS
742: --
743: l_proc VARCHAR2(72) := g_package||'chk_style';

Line 740: p_location_id IN hr_locations.location_id%TYPE )

736: -- {End Of Comments}
737: --
738: PROCEDURE chk_style
739: (p_style IN hr_locations.style%TYPE,
740: p_location_id IN hr_locations.location_id%TYPE )
741: IS
742: --
743: l_proc VARCHAR2(72) := g_package||'chk_style';
744: l_exists VARCHAR2(1);

Line 821: (p_timezone_code IN hr_locations.timezone_code%TYPE)

817: --
818: -- {End Of Comments}
819: --
820: PROCEDURE chk_timezone
821: (p_timezone_code IN hr_locations.timezone_code%TYPE)
822: IS
823: --
824: l_proc VARCHAR2(72) := g_package||'chk_timezone';
825: l_exists VARCHAR2(1);

Line 873: -- - Checks that the following tables do not reference the hr_locations_all

869: --------------------------------------------------------------------------------
870: --
871: --
872: -- Description
873: -- - Checks that the following tables do not reference the hr_locations_all
874: -- row
875: --
876: -- per_all_assigments_f
877: -- pay_wc_funds

Line 905: ( p_location_id IN hr_locations.location_id%TYPE ) IS

901: -- Internal Development Use Only.
902: --
903: --
904: PROCEDURE chk_del_location
905: ( p_location_id IN hr_locations.location_id%TYPE ) IS
906: --
907: l_proc VARCHAR2(72):= g_package||'chk_del_location';
908: l_exists VARCHAR2(1);
909: l_location_id hr_locations.location_id%TYPE;

Line 909: l_location_id hr_locations.location_id%TYPE;

905: ( p_location_id IN hr_locations.location_id%TYPE ) IS
906: --
907: l_proc VARCHAR2(72):= g_package||'chk_del_location';
908: l_exists VARCHAR2(1);
909: l_location_id hr_locations.location_id%TYPE;
910: l_location_code hr_locations.location_code%TYPE;
911: --
912: --
913: -- Define a cursor for each table in HRMS that contains a location id column.

Line 910: l_location_code hr_locations.location_code%TYPE;

906: --
907: l_proc VARCHAR2(72):= g_package||'chk_del_location';
908: l_exists VARCHAR2(1);
909: l_location_id hr_locations.location_id%TYPE;
910: l_location_code hr_locations.location_code%TYPE;
911: --
912: --
913: -- Define a cursor for each table in HRMS that contains a location id column.
914: --

Line 968: from HR_LOCATIONS_ALL

964:
965: --- Fix For Bug 7644045 Starts ---
966: cursor csr_legal_location_flag is
967: select NULL
968: from HR_LOCATIONS_ALL
969: where location_id = p_location_id
970: and LEGAL_ADDRESS_FLAG ='Y';
971: --- Fix For Bug 7644045 Ends ---
972:

Line 1321: -- HR_LOCATIONS - flexible address DDF

1317: END IF;
1318: --
1319: hr_utility.set_location(l_proc, 20);
1320: --
1321: -- HR_LOCATIONS - flexible address DDF
1322: -- ===================================
1323: --
1324: IF nvl(hr_loc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1325: nvl(p_rec.attribute_category, hr_api.g_varchar2) OR

Line 1376: ,p_descflex_name => 'HR_LOCATIONS'

1372: -- b) During insert.
1373: --
1374: hr_dflex_utility.ins_or_upd_descflex_attribs
1375: (p_appl_short_name => 'PER'
1376: ,p_descflex_name => 'HR_LOCATIONS'
1377: ,p_attribute_category => p_rec.attribute_category
1378: ,p_attribute1_name => 'ATTRIBUTE1'
1379: ,p_attribute1_value => p_rec.attribute1
1380: ,p_attribute2_name => 'ATTRIBUTE2'

Line 1423: -- JG_HR_LOCATIONS - global localizations DDF

1419: END IF;
1420: --
1421: hr_utility.set_location(l_proc, 30);
1422: --
1423: -- JG_HR_LOCATIONS - global localizations DDF
1424: -- ==========================================
1425: --
1426: IF nvl(hr_loc_shd.g_old_rec.global_attribute_category, hr_api.g_varchar2) <>
1427: nvl(p_rec.global_attribute_category, hr_api.g_varchar2) OR

Line 1478: ,p_descflex_name => 'JG_HR_LOCATIONS'

1474: -- b) During insert.
1475: --
1476: hr_dflex_utility.ins_or_upd_descflex_attribs
1477: (p_appl_short_name => 'JG'
1478: ,p_descflex_name => 'JG_HR_LOCATIONS'
1479: ,p_attribute_category => p_rec.global_attribute_category
1480: ,p_attribute1_name => 'GLOBAL_ATTRIBUTE1'
1481: ,p_attribute1_value => p_rec.global_attribute1
1482: ,p_attribute2_name => 'GLOBAL_ATTRIBUTE2'