APPS.HR_H2PI_PERSON_UPLOAD dependencies on HR_H2PI_EMPLOYEES

Line 253: DELETE FROM hr_h2pi_employees

249: PROCEDURE remove_staging_table_data (p_from_client_id NUMBER) IS
250:
251: BEGIN
252:
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

Line 391: FROM hr_h2pi_employees

387: PROCEDURE upload_person_level (p_from_client_id NUMBER) IS
388:
389: CURSOR csr_people (p_bg_id NUMBER) IS
390: SELECT DISTINCT person_id
391: FROM hr_h2pi_employees
392: WHERE (status IS NULL OR status <> 'C')
393: AND client_id = p_bg_id
394: UNION
395: SELECT DISTINCT person_id

Line 457: FROM HR_H2PI_EMPLOYEES

453: effective_start_date eff_date,
454: 1 ord,
455: 'upload_person' fn_name,
456: DECODE(last_upd_date, g_eot, 1, 2) sub_order
457: FROM HR_H2PI_EMPLOYEES
458: WHERE (status IS NULL OR status <> 'C')
459: AND person_id = p_per_id
460: AND client_id = p_from_client_id
461: UNION

Line 682: FROM hr_h2pi_employees per

678:
679: CURSOR csr_ud_person (p_per_id NUMBER,
680: p_esd DATE) IS
681: SELECT *
682: FROM hr_h2pi_employees per
683: WHERE per.person_id = p_per_id
684: AND per.client_id = p_from_client_id
685: AND per.effective_start_date = p_esd;
686:

Line 692: FROM hr_h2pi_employees_v per

688: p_esd DATE) IS
689: SELECT per.person_type,
690: per.effective_start_date,
691: per.effective_end_date
692: FROM hr_h2pi_employees_v per
693: WHERE per.person_id = p_per_id
694: AND p_esd BETWEEN per.effective_start_date
695: AND per.effective_end_date;
696:

Line 710: v_ud_per hr_h2pi_employees%ROWTYPE;

706: l_encoded_message VARCHAR2(200);
707:
708: l_proc VARCHAR2(72) := g_package||'upload_person';
709:
710: v_ud_per hr_h2pi_employees%ROWTYPE;
711:
712: l_ud_person_id per_all_people_f.person_id%TYPE;
713: l_ud_assignment_id per_all_assignments_f.assignment_id%TYPE;
714: l_ud_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;

Line 911: p_table_name => 'HR_H2PI_EMPLOYEES',

907: CLOSE csr_ed_person;
908: ROLLBACK;
909: hr_h2pi_error.data_error
910: (p_from_id => l_person_id,
911: p_table_name => 'HR_H2PI_EMPLOYEES',
912: p_message_level => 'FATAL',
913: p_message_name => 'HR_289240_MAPPING_ID_INVALID');
914: COMMIT;
915: RAISE MAPPING_ID_INVALID;

Line 1146: UPDATE hr_h2pi_employees per

1142: END IF;
1143: END IF;
1144:
1145: hr_utility.set_location(l_proc, 170);
1146: UPDATE hr_h2pi_employees per
1147: SET status = 'C'
1148: WHERE per.person_id = v_ud_per.person_id
1149: AND per.client_id = p_from_client_id
1150: AND per.effective_start_date = v_ud_per.effective_start_date

Line 1165: p_table_name => 'HR_H2PI_EMPLOYEES',

1161: l_encoded_message := fnd_message.get_encoded;
1162: hr_utility.set_location(l_encoded_message, 200);
1163: hr_h2pi_error.data_error
1164: (p_from_id => v_ud_per.person_id,
1165: p_table_name => 'HR_H2PI_EMPLOYEES',
1166: p_message_level => 'FATAL',
1167: p_message_text => l_encoded_message);
1168: COMMIT;
1169: RAISE;

Line 1711: l_dummy_person_type hr_h2pi_employees_v.person_type%TYPE;

1707: l_emp_state_tax_rule_id hr_h2pi_state_tax_rules.emp_state_tax_rule_id%TYPE;
1708: l_emp_county_tax_rule_id hr_h2pi_county_tax_rules.emp_county_tax_rule_id%TYPE;
1709: l_emp_city_tax_rule_id hr_h2pi_city_tax_rules.emp_city_tax_rule_id%TYPE;
1710:
1711: l_dummy_person_type hr_h2pi_employees_v.person_type%TYPE;
1712: l_future_term_flag BOOLEAN := FALSE;
1713:
1714: BEGIN
1715: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 2015: FROM hr_h2pi_employees_v

2011:
2012: BEGIN
2013: SELECT DISTINCT person_type
2014: INTO l_dummy_person_type
2015: FROM hr_h2pi_employees_v
2016: WHERE person_id = l_person_id
2017: AND effective_start_date < v_ud_asg.effective_end_date
2018: AND effective_end_date > v_ud_asg.effective_start_date;
2019: EXCEPTION

Line 2798: p_table_name => 'HR_H2PI_EMPLOYEES',

2794: l_payee_type := null;
2795: l_payee_id := null;
2796: hr_h2pi_error.data_error
2797: (p_from_id => v_ud_ppm.payee_id,
2798: p_table_name => 'HR_H2PI_EMPLOYEES',
2799: p_message_level => 'FATAL',
2800: p_message_name => 'HR_289240_MAPPING_ID_INVALID');
2801: ELSE
2802: l_payee_type := v_ud_ppm.payee_type;