DBA Data[Home] [Help]

APPS.PQH_FR_ASSIGNMENT_API dependencies on PQH_FR_ASSIGNMENT_CHK

Line 302: PQH_FR_ASSIGNMENT_CHK.chk_primary_affectation(p_person_id, p_effective_date,l_admin_career_id);

298: -- else Position details will be copied to Affecation details
299: --
300: if (p_primary_affectation = 'Y') then
301: hr_utility.set_location(' Admin career id '|| to_char(l_admin_career_id),10);
302: PQH_FR_ASSIGNMENT_CHK.chk_primary_affectation(p_person_id, p_effective_date,l_admin_career_id);
303: l_position_id := null;
304: else
305: l_position_id := p_position_id;
306: end if;

Line 309: pqh_fr_assignment_chk.chk_situation(p_person_id,p_effective_date);

305: l_position_id := p_position_id;
306: end if;
307:
308: l_identifier := p_identifier;
309: pqh_fr_assignment_chk.chk_situation(p_person_id,p_effective_date);
310: pqh_fr_assignment_chk.chk_percent_affected(p_percent_effected, p_person_id, p_effective_date );
311: pqh_fr_assignment_chk.chk_position(p_position_id,p_person_id,p_effective_date);
312: pqh_fr_assignment_chk.chk_Identifier(l_identifier);
313: pqh_fr_assignment_chk.chk_type(p_affectation_type,p_person_id,p_effective_date,p_position_id);

Line 310: pqh_fr_assignment_chk.chk_percent_affected(p_percent_effected, p_person_id, p_effective_date );

306: end if;
307:
308: l_identifier := p_identifier;
309: pqh_fr_assignment_chk.chk_situation(p_person_id,p_effective_date);
310: pqh_fr_assignment_chk.chk_percent_affected(p_percent_effected, p_person_id, p_effective_date );
311: pqh_fr_assignment_chk.chk_position(p_position_id,p_person_id,p_effective_date);
312: pqh_fr_assignment_chk.chk_Identifier(l_identifier);
313: pqh_fr_assignment_chk.chk_type(p_affectation_type,p_person_id,p_effective_date,p_position_id);
314:

Line 311: pqh_fr_assignment_chk.chk_position(p_position_id,p_person_id,p_effective_date);

307:
308: l_identifier := p_identifier;
309: pqh_fr_assignment_chk.chk_situation(p_person_id,p_effective_date);
310: pqh_fr_assignment_chk.chk_percent_affected(p_percent_effected, p_person_id, p_effective_date );
311: pqh_fr_assignment_chk.chk_position(p_position_id,p_person_id,p_effective_date);
312: pqh_fr_assignment_chk.chk_Identifier(l_identifier);
313: pqh_fr_assignment_chk.chk_type(p_affectation_type,p_person_id,p_effective_date,p_position_id);
314:
315: If (pqh_fr_utility.is_worker_employee(p_person_id,p_effective_date)) Then

Line 312: pqh_fr_assignment_chk.chk_Identifier(l_identifier);

308: l_identifier := p_identifier;
309: pqh_fr_assignment_chk.chk_situation(p_person_id,p_effective_date);
310: pqh_fr_assignment_chk.chk_percent_affected(p_percent_effected, p_person_id, p_effective_date );
311: pqh_fr_assignment_chk.chk_position(p_position_id,p_person_id,p_effective_date);
312: pqh_fr_assignment_chk.chk_Identifier(l_identifier);
313: pqh_fr_assignment_chk.chk_type(p_affectation_type,p_person_id,p_effective_date,p_position_id);
314:
315: If (pqh_fr_utility.is_worker_employee(p_person_id,p_effective_date)) Then
316: --

Line 313: pqh_fr_assignment_chk.chk_type(p_affectation_type,p_person_id,p_effective_date,p_position_id);

309: pqh_fr_assignment_chk.chk_situation(p_person_id,p_effective_date);
310: pqh_fr_assignment_chk.chk_percent_affected(p_percent_effected, p_person_id, p_effective_date );
311: pqh_fr_assignment_chk.chk_position(p_position_id,p_person_id,p_effective_date);
312: pqh_fr_assignment_chk.chk_Identifier(l_identifier);
313: pqh_fr_assignment_chk.chk_type(p_affectation_type,p_person_id,p_effective_date,p_position_id);
314:
315: If (pqh_fr_utility.is_worker_employee(p_person_id,p_effective_date)) Then
316: --
317: hr_assignment_api.create_secondary_emp_asg(

Line 589: pqh_fr_assignment_chk.chk_percent_affected(p_percent_effected,p_person_id,p_effective_date,p_assignment_id);

585:
586:
587: hr_utility.set_location(' Primary Affectation Old :'||l_old_primary_affectation||'New '||p_primary_affectation,10);
588:
589: pqh_fr_assignment_chk.chk_percent_affected(p_percent_effected,p_person_id,p_effective_date,p_assignment_id);
590: pqh_fr_assignment_chk.chk_position(p_position_id,p_person_id,p_effective_date);
591: pqh_fr_assignment_chk.chk_type(p_affectation_type,p_person_id,p_effective_date,p_position_id);
592:
593: l_normal_hours := l_normal_hours * p_percent_effected/100;

Line 590: pqh_fr_assignment_chk.chk_position(p_position_id,p_person_id,p_effective_date);

586:
587: hr_utility.set_location(' Primary Affectation Old :'||l_old_primary_affectation||'New '||p_primary_affectation,10);
588:
589: pqh_fr_assignment_chk.chk_percent_affected(p_percent_effected,p_person_id,p_effective_date,p_assignment_id);
590: pqh_fr_assignment_chk.chk_position(p_position_id,p_person_id,p_effective_date);
591: pqh_fr_assignment_chk.chk_type(p_affectation_type,p_person_id,p_effective_date,p_position_id);
592:
593: l_normal_hours := l_normal_hours * p_percent_effected/100;
594:

Line 591: pqh_fr_assignment_chk.chk_type(p_affectation_type,p_person_id,p_effective_date,p_position_id);

587: hr_utility.set_location(' Primary Affectation Old :'||l_old_primary_affectation||'New '||p_primary_affectation,10);
588:
589: pqh_fr_assignment_chk.chk_percent_affected(p_percent_effected,p_person_id,p_effective_date,p_assignment_id);
590: pqh_fr_assignment_chk.chk_position(p_position_id,p_person_id,p_effective_date);
591: pqh_fr_assignment_chk.chk_type(p_affectation_type,p_person_id,p_effective_date,p_position_id);
592:
593: l_normal_hours := l_normal_hours * p_percent_effected/100;
594:
595: If (l_old_primary_affectation='Y' and p_primary_affectation = 'Y') Then

Line 853: PQH_FR_ASSIGNMENT_CHK.chk_primary_affectation(p_person_id, p_effective_date,l_admin_career_id);

849:
850: ElsIf (l_old_primary_affectation='N' and p_primary_affectation = 'Y') Then
851:
852: --
853: PQH_FR_ASSIGNMENT_CHK.chk_primary_affectation(p_person_id, p_effective_date,l_admin_career_id);
854:
855: If pqh_fr_utility.is_worker_employee(p_person_id,p_effective_date) Then
856: --
857: hr_assignment_api.update_emp_asg_criteria

Line 2257: pqh_fr_assignment_chk.chk_situation(l_person_id,p_effective_date);

2253: Open assign_percent_affected ;
2254: fetch assign_percent_affected into l_percent_affected;
2255: Close assign_percent_affected;
2256:
2257: pqh_fr_assignment_chk.chk_situation(l_person_id,p_effective_date);
2258: pqh_fr_assignment_chk.chk_percent_affected(l_percent_affected, l_person_id, p_effective_date);
2259:
2260:
2261: If (pqh_fr_utility.is_worker_employee(l_person_id,p_effective_date)) Then

Line 2258: pqh_fr_assignment_chk.chk_percent_affected(l_percent_affected, l_person_id, p_effective_date);

2254: fetch assign_percent_affected into l_percent_affected;
2255: Close assign_percent_affected;
2256:
2257: pqh_fr_assignment_chk.chk_situation(l_person_id,p_effective_date);
2258: pqh_fr_assignment_chk.chk_percent_affected(l_percent_affected, l_person_id, p_effective_date);
2259:
2260:
2261: If (pqh_fr_utility.is_worker_employee(l_person_id,p_effective_date)) Then
2262: --