APPS.PQP_PERASGADD_RIW dependencies on DT_API

Line 2072: Dt_Api.Find_DT_Upd_Modes

2068: fetch csr_per into l_cur_per_rec;
2069: close csr_per;
2070: hr_utility.set_location(' l_cur_per_rec: ' || l_cur_per_rec.person_id, 20);
2071:
2072: Dt_Api.Find_DT_Upd_Modes
2073: (p_effective_date => g_per_rec.start_date
2074: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
2075: ,p_base_key_column => 'PERSON_ID'
2076: ,p_base_key_value => l_cur_per_rec.person_id

Line 2462: Dt_Api.Find_DT_Upd_Modes

2458: g_asg_rec.soft_coding_keyflex_id, 40);
2459: --
2460: -- Get the datetrack mode based on the effective date passed
2461: --
2462: Dt_Api.Find_DT_Upd_Modes
2463: (p_effective_date => p_effective_date
2464: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'
2465: ,p_base_key_column => 'ASSIGNMENT_ID'
2466: ,p_base_key_value => g_asg_rec.assignment_id

Line 2618: Dt_Api.Find_DT_Upd_Modes

2614: ,p_effective_end_date => l_UpdEmpAsg_out.effective_end_date
2615: );
2616: end if;
2617:
2618: Dt_Api.Find_DT_Upd_Modes
2619: (p_effective_date => p_effective_date
2620: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'
2621: ,p_base_key_column => 'ASSIGNMENT_ID'
2622: ,p_base_key_value => g_asg_rec.assignment_id

Line 2946: Dt_Api.Find_DT_Upd_Modes

2942: g_asg_rec.soft_coding_keyflex_id, 40);
2943: --
2944: -- Get the datetrack mode based on the effective date passed
2945: --
2946: Dt_Api.Find_DT_Upd_Modes
2947: (p_effective_date => p_effective_date
2948: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'
2949: ,p_base_key_column => 'ASSIGNMENT_ID'
2950: ,p_base_key_value => g_asg_rec.assignment_id

Line 3286: Dt_Api.Find_DT_Upd_Modes

3282: close csr_scl;
3283: hr_utility.set_location(' soft_coding_keyflex_id: ' ||
3284: g_asg_rec.soft_coding_keyflex_id, 40);
3285:
3286: Dt_Api.Find_DT_Upd_Modes
3287: (p_effective_date => p_effective_date
3288: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'
3289: ,p_base_key_column => 'ASSIGNMENT_ID'
3290: ,p_base_key_value => g_asg_rec.assignment_id

Line 3657: Dt_Api.Find_DT_Upd_Modes

3653: ,c_effective_date => g_per_rec.start_date);
3654: fetch csr_per into l_cur_per_rec;
3655: close csr_per;
3656: hr_utility.set_location(' l_cur_per_rec: ' || l_cur_per_rec.person_id, 20);
3657: Dt_Api.Find_DT_Upd_Modes
3658: (p_effective_date => g_per_rec.start_date
3659: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
3660: ,p_base_key_column => 'PERSON_ID'
3661: ,p_base_key_value => l_cur_per_rec.person_id

Line 5020: Dt_Api.Find_DT_Upd_Modes

5016: close csr_per;
5017:
5018: hr_utility.set_location(' l_cur_per_rec: ' || l_cur_per_rec.person_id, 20);
5019:
5020: Dt_Api.Find_DT_Upd_Modes
5021: (p_effective_date => p_effective_date
5022: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
5023: ,p_base_key_column => 'PERSON_ID'
5024: ,p_base_key_value => l_cur_per_rec.person_id

Line 5358: Dt_Api.Find_DT_Upd_Modes -- Accepted.

5354: -- Means the Applicant Assignment is not accepted, so update the applicant
5355: -- as accepted as of the hire date.
5356: hr_utility.set_location(' Asg Id NOT Accepted : ' || p_assignment_id, 40);
5357: if l_diff_date = 1 then -- Means The Applicant Assignment is to be corrected to
5358: Dt_Api.Find_DT_Upd_Modes -- Accepted.
5359: (p_effective_date => l_perasg_rec.effective_start_date
5360: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'
5361: ,p_base_key_column => 'ASSIGNMENT_ID'
5362: ,p_base_key_value => p_assignment_id

Line 5369: Dt_Api.Find_DT_Upd_Modes

5365: ,p_update_override => l_dt_upd_override
5366: ,p_update_change_insert => l_upd_chg_ins
5367: );
5368: else
5369: Dt_Api.Find_DT_Upd_Modes
5370: (p_effective_date => p_hire_date
5371: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'
5372: ,p_base_key_column => 'ASSIGNMENT_ID'
5373: ,p_base_key_value => p_assignment_id

Line 5469: Dt_Api.Find_DT_Upd_Modes

5465: l_hire_all_accepted_asgs := 'N';
5466: end if;
5467:
5468: -- Now get the date-track mode to update the person as an employee
5469: Dt_Api.Find_DT_Upd_Modes
5470: (p_effective_date => l_effective_date
5471: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
5472: ,p_base_key_column => 'PERSON_ID'
5473: ,p_base_key_value => l_cur_per_rec.person_id

Line 5655: Dt_Api.Find_DT_Upd_Modes

5651: fetch csr_per into l_cur_per_rec;
5652: close csr_per;
5653: hr_utility.set_location(' l_cur_per_rec: ' || l_cur_per_rec.person_id, 20);
5654:
5655: Dt_Api.Find_DT_Upd_Modes
5656: (p_effective_date => p_hire_date
5657: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
5658: ,p_base_key_column => 'PERSON_ID'
5659: ,p_base_key_value => l_cur_per_rec.person_id

Line 7230: Dt_Api.Find_DT_Upd_Modes

7226: g_asg_rec.business_group_id := l_asg_rec.business_group_id;
7227: g_asg_rec.assignment_id := l_asg_rec.assignment_id;
7228: --g_asg_rec.assignment_status_type_id := l_asg_rec.assignment_status_type_id;
7229:
7230: Dt_Api.Find_DT_Upd_Modes
7231: (p_effective_date => p_effective_date
7232: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'
7233: ,p_base_key_column => 'ASSIGNMENT_ID'
7234: ,p_base_key_value => g_asg_rec.assignment_id