APPS.HR_H2PI_BG_UPLOAD dependencies on HR_H2PI_LOCATIONS

Line 134: FROM hr_h2pi_locations

130: PROCEDURE upload_location (p_from_client_id NUMBER) IS
131:
132: CURSOR csr_locations (p_bg_id NUMBER) IS
133: SELECT *
134: FROM hr_h2pi_locations
135: WHERE client_id = p_bg_id
136: AND (status IS NULL OR status <> 'C');
137:
138: l_ud_loc hr_h2pi_locations%ROWTYPE;

Line 138: l_ud_loc hr_h2pi_locations%ROWTYPE;

134: FROM hr_h2pi_locations
135: WHERE client_id = p_bg_id
136: AND (status IS NULL OR status <> 'C');
137:
138: l_ud_loc hr_h2pi_locations%ROWTYPE;
139: l_location_id NUMBER(15);
140: l_ovn NUMBER(9);
141: l_encoded_message VARCHAR2(200);
142:

Line 287: UPDATE hr_h2pi_locations

283:
284: END IF;
285:
286: hr_utility.set_location(l_proc, 70);
287: UPDATE hr_h2pi_locations
288: SET status = 'C'
289: WHERE location_id = v_ud_loc.location_id
290: AND client_id = p_from_client_id;
291:

Line 300: p_table_name => 'HR_H2PI_LOCATIONS',

296: ROLLBACK;
297: hr_utility.set_location(l_proc, 80);
298: hr_h2pi_error.data_error
299: (p_from_id => l_location_id,
300: p_table_name => 'HR_H2PI_LOCATIONS',
301: p_message_level => 'FATAL',
302: p_message_name => 'HR_289240_MAPPING_ID_INVALID');
303: WHEN APP_EXCEPTIONS.APPLICATION_EXCEPTION THEN
304: ROLLBACK;

Line 309: p_table_name => 'HR_H2PI_LOCATIONS',

305: hr_utility.set_location(l_proc, 90);
306: l_encoded_message := fnd_message.get_encoded;
307: hr_h2pi_error.data_error
308: (p_from_id => v_ud_loc.location_id,
309: p_table_name => 'HR_H2PI_LOCATIONS',
310: p_message_level => 'FATAL',
311: p_message_text => l_encoded_message);
312: END;
313: