APPS.HR_H2PI_PERSON_UPLOAD dependencies on HR_H2PI_ADDRESSES

Line 257: DELETE FROM hr_h2pi_addresses

253: DELETE FROM hr_h2pi_employees
254: WHERE client_id = p_from_client_id
255: AND status = 'C';
256:
257: DELETE FROM hr_h2pi_addresses
258: WHERE client_id = p_from_client_id
259: AND status = 'C';
260:
261: DELETE FROM hr_h2pi_assignments

Line 396: FROM hr_h2pi_addresses

392: WHERE (status IS NULL OR status <> 'C')
393: AND client_id = p_bg_id
394: UNION
395: SELECT DISTINCT person_id
396: FROM hr_h2pi_addresses
397: WHERE (status IS NULL OR status <> 'C')
398: AND client_id = p_bg_id
399: UNION
400: SELECT DISTINCT person_id

Line 467: FROM HR_H2PI_ADDRESSES

463: date_from eff_date,
464: 2 ord,
465: 'upload_address' fn_name,
466: DECODE(last_upd_date, g_eot, 1, 2) sub_order
467: FROM HR_H2PI_ADDRESSES
468: WHERE (status IS NULL OR status <> 'C')
469: AND person_id = p_per_id
470: AND client_id = p_from_client_id
471: UNION

Line 1286: FROM hr_h2pi_addresses adr

1282: CURSOR csr_ud_address (p_adr_id NUMBER) IS
1283: SELECT address_id,
1284: date_from,
1285: date_to
1286: FROM hr_h2pi_addresses adr
1287: WHERE adr.address_id = p_adr_id
1288: AND adr.client_id = p_from_client_id
1289: AND (adr.status IS NULL OR adr.status <> 'C');
1290:

Line 1307: v_ed_adr hr_h2pi_addresses%ROWTYPE;

1303: l_person_id per_addresses.person_id%TYPE;
1304: l_ud_address_id per_addresses.address_id%TYPE;
1305: l_ud_date_from per_addresses.date_from%TYPE;
1306: l_ud_date_to per_addresses.date_to%TYPE;
1307: v_ed_adr hr_h2pi_addresses%ROWTYPE;
1308:
1309: BEGIN
1310: hr_utility.set_location('Entering:'|| l_proc, 10);
1311:

Line 1359: p_table_name => 'HR_H2PI_ADDRESSES',

1355: hr_utility.set_location(l_proc, 60);
1356: l_encoded_message := fnd_message.get_encoded;
1357: hr_h2pi_error.data_error
1358: (p_from_id => l_ud_address_id,
1359: p_table_name => 'HR_H2PI_ADDRESSES',
1360: p_message_level => 'FATAL',
1361: p_message_text => l_encoded_message);
1362: COMMIT;
1363: RAISE;

Line 1374: FROM hr_h2pi_addresses adr

1370: p_effective_start_date DATE) IS
1371:
1372: CURSOR csr_ud_address (p_adr_id NUMBER) IS
1373: SELECT *
1374: FROM hr_h2pi_addresses adr
1375: WHERE adr.address_id = p_adr_id
1376: AND adr.client_id = p_from_client_id;
1377:
1378: CURSOR csr_ed_address (p_adr_id NUMBER) IS

Line 1390: v_ud_adr hr_h2pi_addresses%ROWTYPE;

1386:
1387: l_person_id per_addresses.person_id%TYPE;
1388: l_address_id per_addresses.address_id%TYPE;
1389: l_ovn per_addresses.object_version_number%TYPE;
1390: v_ud_adr hr_h2pi_addresses%ROWTYPE;
1391: l_per_start_date per_all_people_f.effective_start_date%TYPE;
1392: l_date_from per_addresses.date_from%TYPE;
1393:
1394: BEGIN

Line 1492: p_table_name => 'HR_H2PI_ADDRESSES',

1488: ROLLBACK;
1489: hr_utility.set_location(l_proc, 70);
1490: hr_h2pi_error.data_error
1491: (p_from_id => l_address_id,
1492: p_table_name => 'HR_H2PI_ADDRESSES',
1493: p_message_level => 'FATAL',
1494: p_message_name => 'HR_289240_MAPPING_ID_INVALID');
1495: COMMIT;
1496: RAISE MAPPING_ID_INVALID;

Line 1550: UPDATE hr_h2pi_addresses adr

1546: );
1547: END IF;
1548:
1549: hr_utility.set_location(l_proc, 90);
1550: UPDATE hr_h2pi_addresses adr
1551: SET status = 'C'
1552: WHERE adr.address_id = v_ud_adr.address_id
1553: AND adr.client_id = p_from_client_id;
1554: CLOSE csr_ud_address;

Line 1566: p_table_name => 'HR_H2PI_ADDRESSES',

1562: hr_utility.set_location(l_proc, 110);
1563: l_encoded_message := fnd_message.get_encoded;
1564: hr_h2pi_error.data_error
1565: (p_from_id => v_ud_adr.address_id,
1566: p_table_name => 'HR_H2PI_ADDRESSES',
1567: p_message_level => 'FATAL',
1568: p_message_text => l_encoded_message);
1569: COMMIT;
1570: RAISE;