[Home] [Help]
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).
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'.
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
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: --
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
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: