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_H2PI_PERSON_UPLOAD dependencies on PER_ADDRESSES

Line 1296: FROM per_addresses adr

1292: SELECT address_id,
1293: object_version_number,
1294: date_from,
1295: date_to
1296: FROM per_addresses adr
1297: WHERE adr.person_id = p_per_id;
1298:
1299: l_proc VARCHAR2(72) := g_package||'delete_address';
1300:

Line 1303: l_person_id per_addresses.person_id%TYPE;

1299: l_proc VARCHAR2(72) := g_package||'delete_address';
1300:
1301: l_encoded_message VARCHAR2(200);
1302:
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;

Line 1304: l_ud_address_id per_addresses.address_id%TYPE;

1300:
1301: l_encoded_message VARCHAR2(200);
1302:
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:

Line 1305: l_ud_date_from per_addresses.date_from%TYPE;

1301: l_encoded_message VARCHAR2(200);
1302:
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

Line 1306: l_ud_date_to per_addresses.date_to%TYPE;

1302:
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);

Line 1321: (p_table_name => 'PER_ADDRESSES',

1317:
1318: FOR v_ed_adr IN csr_ed_addresses(l_person_id) LOOP
1319: hr_utility.set_location(l_proc, 20);
1320: l_ud_address_id := hr_h2pi_map.get_from_id
1321: (p_table_name => 'PER_ADDRESSES',
1322: p_to_id => v_ed_adr.address_id);
1323:
1324: IF l_ud_address_id <> -1 THEN
1325: hr_utility.set_location(l_proc, 30);

Line 1340: WHERE table_name = 'PER_ADDRESSES'

1336: (p_address_id => v_ed_adr.address_id,
1337: p_object_version_number => v_ed_adr.object_version_number);
1338:
1339: DELETE FROM hr_h2pi_id_mapping
1340: WHERE table_name = 'PER_ADDRESSES'
1341: AND to_id = v_ed_adr.address_id
1342: AND to_business_group_id = hr_h2pi_upload.g_to_business_group_id;
1343:
1344: END IF;

Line 1380: FROM per_addresses adr

1376: AND adr.client_id = p_from_client_id;
1377:
1378: CURSOR csr_ed_address (p_adr_id NUMBER) IS
1379: SELECT object_version_number
1380: FROM per_addresses adr
1381: WHERE adr.address_id = p_adr_id;
1382:
1383: l_proc VARCHAR2(72) := g_package||'upload_address';
1384:

Line 1387: l_person_id per_addresses.person_id%TYPE;

1383: l_proc VARCHAR2(72) := g_package||'upload_address';
1384:
1385: l_encoded_message VARCHAR2(200);
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;

Line 1388: l_address_id per_addresses.address_id%TYPE;

1384:
1385: l_encoded_message VARCHAR2(200);
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;

Line 1389: l_ovn per_addresses.object_version_number%TYPE;

1385: l_encoded_message VARCHAR2(200);
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:

Line 1392: l_date_from per_addresses.date_from%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
1395: hr_utility.set_location('Entering:'|| l_proc, 10);
1396:

Line 1407: (p_table_name => 'PER_ADDRESSES',

1403: p_report_error => TRUE);
1404:
1405: hr_utility.set_location(l_proc, 20);
1406: l_address_id := hr_h2pi_map.get_to_id
1407: (p_table_name => 'PER_ADDRESSES',
1408: p_from_id => v_ud_adr.address_id);
1409:
1410: IF l_address_id = -1 THEN
1411: hr_utility.set_location(l_proc, 30);

Line 1477: (p_table_name => 'PER_ADDRESSES',

1473: );
1474:
1475: hr_utility.set_location(l_proc, 40);
1476: hr_h2pi_map.create_id_mapping
1477: (p_table_name => 'PER_ADDRESSES',
1478: p_from_id => v_ud_adr.address_id,
1479: p_to_id => l_address_id);
1480: END IF;
1481: ELSE