APPS.PQP_HROSS_INTEGRATION dependencies on DT_API

Line 458: Dt_Api.Find_DT_Upd_Modes

454: RETURN;
455: END IF;
456: CLOSE csr_tax;
457:
458: Dt_Api.Find_DT_Upd_Modes
459: (p_effective_date => p_effective_date
460: ,p_base_table_name => 'PAY_US_EMP_FED_TAX_RULES_F'
461: ,p_base_key_column => 'EMP_FED_TAX_RULE_ID'
462: ,p_base_key_value => l_fed_rec.emp_fed_tax_rule_id

Line 656: Dt_Api.Find_DT_Upd_Modes

652: CLOSE csr_scl;
653: hr_utility.set_location(' soft_coding_keyflex_id: ' ||
654: l_asg_rec.soft_coding_keyflex_id, 40);
655:
656: Dt_Api.Find_DT_Upd_Modes
657: (p_effective_date => p_effective_date
658: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'
659: ,p_base_key_column => 'ASSIGNMENT_ID'
660: ,p_base_key_value => l_asg_rec.assignment_id

Line 1176: Dt_Api.Find_DT_Upd_Modes

1172: IF l_accp_asg_count < 1 THEN
1173: -- Means the Applicant Assignment is not accepted, so update the applicant
1174: -- as accepted as of the hire date.
1175: hr_utility.set_location(' Asg Id NOT Accepted : ' || p_assignment_id, 40);
1176: Dt_Api.Find_DT_Upd_Modes
1177: (p_effective_date => p_hire_date
1178: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'
1179: ,p_base_key_column => 'ASSIGNMENT_ID'
1180: ,p_base_key_value => p_assignment_id

Line 1275: Dt_Api.Find_DT_Upd_Modes

1271: l_hire_all_accepted_asgs := 'N';
1272: END IF;
1273:
1274: -- Now get the date-track mode to update the person as an employee
1275: Dt_Api.Find_DT_Upd_Modes
1276: (p_effective_date => l_effective_date
1277: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
1278: ,p_base_key_column => 'PERSON_ID'
1279: ,p_base_key_value => l_cur_per_rec.person_id

Line 1641: Dt_Api.Find_DT_Upd_Modes

1637: FETCH csr_per INTO l_cur_per_rec;
1638: CLOSE csr_per;
1639: hr_utility.set_location(' l_cur_per_rec: ' || l_cur_per_rec.person_id, 20);
1640:
1641: Dt_Api.Find_DT_Upd_Modes
1642: (p_effective_date => p_hire_date
1643: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
1644: ,p_base_key_column => 'PERSON_ID'
1645: ,p_base_key_value => l_cur_per_rec.person_id

Line 1982: Dt_Api.Find_DT_Upd_Modes

1978: ,c_effective_date => p_rehire_date);
1979: FETCH csr_per INTO l_cur_per_rec;
1980: CLOSE csr_per;
1981: hr_utility.set_location(' l_cur_asg_rec: ' || l_cur_per_rec.person_id, 20);
1982: Dt_Api.Find_DT_Upd_Modes
1983: (p_effective_date => p_rehire_date
1984: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
1985: ,p_base_key_column => 'PERSON_ID'
1986: ,p_base_key_value => l_cur_per_rec.person_id

Line 2932: Dt_Api.Find_DT_Upd_Modes

2928: ,c_effective_date => l_per_rec.START_DATE);
2929: FETCH csr_per INTO l_cur_per_rec;
2930: CLOSE csr_per;
2931:
2932: Dt_Api.Find_DT_Upd_Modes
2933: (p_effective_date => l_per_rec.START_DATE
2934: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
2935: ,p_base_key_column => 'PERSON_ID'
2936: ,p_base_key_value => l_cur_per_rec.person_id

Line 3439: -- Dt_Api.Find_DT_Upd_Modes

3435:
3436: -- hr_utility.set_location(' l_cur_asg_rec: '||
3437: -- l_asg_rec.assignment_id, 6);
3438:
3439: -- Dt_Api.Find_DT_Upd_Modes
3440: -- (p_effective_date => l_per_rec.start_date
3441: -- ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'
3442: -- ,p_base_key_column => 'ASSIGNMENT_ID'
3443: -- ,p_base_key_value => l_asg_rec.assignment_id

Line 4941: Dt_Api.Find_DT_Upd_Modes

4937: CLOSE csr_per;
4938:
4939: hr_utility.set_location(' l_cur_per_rec: ' || l_cur_per_rec.person_id, 20);
4940:
4941: Dt_Api.Find_DT_Upd_Modes
4942: (p_effective_date => p_effective_date
4943: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
4944: ,p_base_key_column => 'PERSON_ID'
4945: ,p_base_key_value => l_cur_per_rec.person_id