APPS.PQP_PERASGADD_RIW dependencies on DT_API

Line 1970: Dt_Api.Find_DT_Upd_Modes

1966: fetch csr_per into l_cur_per_rec;
1967: close csr_per;
1968: hr_utility.set_location(' l_cur_per_rec: ' || l_cur_per_rec.person_id, 20);
1969:
1970: Dt_Api.Find_DT_Upd_Modes
1971: (p_effective_date => g_per_rec.start_date
1972: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
1973: ,p_base_key_column => 'PERSON_ID'
1974: ,p_base_key_value => l_cur_per_rec.person_id

Line 2357: Dt_Api.Find_DT_Upd_Modes

2353: g_asg_rec.soft_coding_keyflex_id, 40);
2354: --
2355: -- Get the datetrack mode based on the effective date passed
2356: --
2357: Dt_Api.Find_DT_Upd_Modes
2358: (p_effective_date => p_effective_date
2359: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'
2360: ,p_base_key_column => 'ASSIGNMENT_ID'
2361: ,p_base_key_value => g_asg_rec.assignment_id

Line 2690: Dt_Api.Find_DT_Upd_Modes

2686: g_asg_rec.soft_coding_keyflex_id, 40);
2687: --
2688: -- Get the datetrack mode based on the effective date passed
2689: --
2690: Dt_Api.Find_DT_Upd_Modes
2691: (p_effective_date => p_effective_date
2692: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'
2693: ,p_base_key_column => 'ASSIGNMENT_ID'
2694: ,p_base_key_value => g_asg_rec.assignment_id

Line 3030: Dt_Api.Find_DT_Upd_Modes

3026: close csr_scl;
3027: hr_utility.set_location(' soft_coding_keyflex_id: ' ||
3028: g_asg_rec.soft_coding_keyflex_id, 40);
3029:
3030: Dt_Api.Find_DT_Upd_Modes
3031: (p_effective_date => p_effective_date
3032: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'
3033: ,p_base_key_column => 'ASSIGNMENT_ID'
3034: ,p_base_key_value => g_asg_rec.assignment_id

Line 3322: Dt_Api.Find_DT_Upd_Modes

3318: ,c_effective_date => g_per_rec.start_date);
3319: fetch csr_per into l_cur_per_rec;
3320: close csr_per;
3321: hr_utility.set_location(' l_cur_per_rec: ' || l_cur_per_rec.person_id, 20);
3322: Dt_Api.Find_DT_Upd_Modes
3323: (p_effective_date => g_per_rec.start_date
3324: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
3325: ,p_base_key_column => 'PERSON_ID'
3326: ,p_base_key_value => l_cur_per_rec.person_id

Line 4685: Dt_Api.Find_DT_Upd_Modes

4681: close csr_per;
4682:
4683: hr_utility.set_location(' l_cur_per_rec: ' || l_cur_per_rec.person_id, 20);
4684:
4685: Dt_Api.Find_DT_Upd_Modes
4686: (p_effective_date => p_effective_date
4687: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
4688: ,p_base_key_column => 'PERSON_ID'
4689: ,p_base_key_value => l_cur_per_rec.person_id

Line 5022: Dt_Api.Find_DT_Upd_Modes -- Accepted.

5018: -- Means the Applicant Assignment is not accepted, so update the applicant
5019: -- as accepted as of the hire date.
5020: hr_utility.set_location(' Asg Id NOT Accepted : ' || p_assignment_id, 40);
5021: if l_diff_date = 1 then -- Means The Applicant Assignment is to be corrected to
5022: Dt_Api.Find_DT_Upd_Modes -- Accepted.
5023: (p_effective_date => l_perasg_rec.effective_start_date
5024: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'
5025: ,p_base_key_column => 'ASSIGNMENT_ID'
5026: ,p_base_key_value => p_assignment_id

Line 5033: Dt_Api.Find_DT_Upd_Modes

5029: ,p_update_override => l_dt_upd_override
5030: ,p_update_change_insert => l_upd_chg_ins
5031: );
5032: else
5033: Dt_Api.Find_DT_Upd_Modes
5034: (p_effective_date => p_hire_date
5035: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'
5036: ,p_base_key_column => 'ASSIGNMENT_ID'
5037: ,p_base_key_value => p_assignment_id

Line 5133: Dt_Api.Find_DT_Upd_Modes

5129: l_hire_all_accepted_asgs := 'N';
5130: end if;
5131:
5132: -- Now get the date-track mode to update the person as an employee
5133: Dt_Api.Find_DT_Upd_Modes
5134: (p_effective_date => l_effective_date
5135: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
5136: ,p_base_key_column => 'PERSON_ID'
5137: ,p_base_key_value => l_cur_per_rec.person_id

Line 5319: Dt_Api.Find_DT_Upd_Modes

5315: fetch csr_per into l_cur_per_rec;
5316: close csr_per;
5317: hr_utility.set_location(' l_cur_per_rec: ' || l_cur_per_rec.person_id, 20);
5318:
5319: Dt_Api.Find_DT_Upd_Modes
5320: (p_effective_date => p_hire_date
5321: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
5322: ,p_base_key_column => 'PERSON_ID'
5323: ,p_base_key_value => l_cur_per_rec.person_id

Line 6825: Dt_Api.Find_DT_Upd_Modes

6821: g_asg_rec.business_group_id := l_asg_rec.business_group_id;
6822: g_asg_rec.assignment_id := l_asg_rec.assignment_id;
6823: g_asg_rec.assignment_status_type_id := l_asg_rec.assignment_status_type_id;
6824:
6825: Dt_Api.Find_DT_Upd_Modes
6826: (p_effective_date => p_effective_date
6827: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'
6828: ,p_base_key_column => 'ASSIGNMENT_ID'
6829: ,p_base_key_value => g_asg_rec.assignment_id