APPS.POR_LOAD_HR_DATA dependencies on POR_LOCATION_LOADER_VALUES

Line 144: FROM por_location_loader_values ORDER BY last_update_date ASC;

140: address_style,address_line_1, address_line_2,address_line_3,
141: city,state,county,postal_code,country,telephone,fax,ship_to_location,
142: ship_to_flag,bill_to_flag,receiving_to_flag,office_site,
143: internal_site,inventory_Org,tax_name
144: FROM por_location_loader_values ORDER BY last_update_date ASC;
145:
146: BEGIN
147:
148: OPEN c_locations;

Line 186: UPDATE por_location_loader_values

182: x_inv_org => l_inventory_Org,
183: x_tax_name => l_tax_name);
184:
185:
186: UPDATE por_location_loader_values
187: SET loader_status = 'complete'
188: WHERE location_code = l_location_code;
189:
190:

Line 203: UPDATE por_location_loader_values

199: ELSE
200: ERROR_STACK.PUSHMESSAGE(hr_utility.get_message(),'ICX');
201: END IF;
202:
203: UPDATE por_location_loader_values
204: SET loader_status = 'failure'
205: WHERE location_code = l_location_code;
206:
207: END;