eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_HEAD_COUNT_SUMMARY dependencies on HR_PERSON_FLEX_LOGIC

Line 321: and formula_type_id = HR_PERSON_FLEX_LOGIC.GetFormulaTypeID('Quickpaint');

317: from ff_formulas_f
318: where p_business_group_id = business_group_id+0
319: and trunc(sysdate) between effective_start_date and effective_end_date
320: and formula_name = 'BUDGET_'||p_budget
321: and formula_type_id = HR_PERSON_FLEX_LOGIC.GetFormulaTypeID('Quickpaint');
322:
323:
324: cursor c_get_tmplt_ABV_formula is
325: select formula_id

Line 330: and formula_type_id = HR_PERSON_FLEX_LOGIC.GetFormulaTypeID('Quickpaint');

326: from ff_formulas_f
327: where business_group_id+0 is null
328: and trunc(sysdate) between effective_start_date and effective_end_date
329: and formula_name = 'TEMPLATE_'||p_budget
330: and formula_type_id = HR_PERSON_FLEX_LOGIC.GetFormulaTypeID('Quickpaint');
331:
332: l_ABV_formula_id number;
333: l_ABV number;
334: l_jobcatg varchar2(1);

Line 523: l_abv := HR_PERSON_FLEX_LOGIC.GetABV

519:
520: l_jobcatg := NULL;
521: l_abv := NULL;
522:
523: l_abv := HR_PERSON_FLEX_LOGIC.GetABV
524: ( p_ABV_formula_id => l_ABV_formula_id
525: , p_ABV => p_budget
526: , p_assignment_id => asg_start_rec.assignment_id
527: , p_effective_date => asg_start_rec.effective_start_date

Line 533: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory

529:
530: hr_utility.set_location('l_abv='||l_abv,300);
531:
532:
533: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
534: (asg_start_rec.job_id
535: ,p_job_category);
536:
537: if l_jobcatg = 'Y'

Line 598: l_abv := HR_PERSON_FLEX_LOGIC.GetABV

594:
595: l_jobcatg := NULL;
596: l_abv := NULL;
597:
598: l_abv := HR_PERSON_FLEX_LOGIC.GetABV
599: ( p_ABV_formula_id => l_ABV_formula_id
600: , p_ABV => p_budget
601: , p_assignment_id => asg_end_rec.assignment_id
602: , p_effective_date => asg_end_rec.effective_start_date

Line 608: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory

604:
605:
606: hr_utility.set_location('l_abv='||l_abv,380);
607:
608: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
609: (asg_end_rec.job_id
610: ,p_job_category);
611:
612: if l_jobcatg = 'Y'

Line 695: l_abv := HR_PERSON_FLEX_LOGIC.GetABV

691: l_jobcatg := NULL;
692: l_abv := NULL;
693:
694: hr_utility.set_location('asg_rec.assignment_id='||asg_rec.assignment_id,490);
695: l_abv := HR_PERSON_FLEX_LOGIC.GetABV
696: ( p_ABV_formula_id => l_ABV_formula_id
697: , p_ABV => p_budget
698: , p_assignment_id => asg_rec.assignment_id
699: , p_effective_date => asg_rec.effective_start_date

Line 703: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory

699: , p_effective_date => asg_rec.effective_start_date
700: , p_session_date => trunc(sysdate) );
701:
702:
703: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
704: (asg_rec.job_id
705: ,p_job_category);
706:
707: HR_PERSON_FLEX_LOGIC.GetMovementCategory(

Line 707: HR_PERSON_FLEX_LOGIC.GetMovementCategory(

703: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
704: (asg_rec.job_id
705: ,p_job_category);
706:
707: HR_PERSON_FLEX_LOGIC.GetMovementCategory(
708: p_organization_id => org_rec.organization_id2
709: ,p_assignment_id => asg_rec.assignment_id
710: ,p_period_start_date => P_DATE_FROM
711: ,p_period_end_date => P_DATE_TO

Line 761: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory

757:
758: hr_utility.set_location('Organization ID2 = '||org_rec.organization_id2,530);
759:
760: l_jobcatg := NULL;
761: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
762: (term_rec.job_id
763: ,p_job_category);
764:
765: hr_utility.set_location('Job Categ = '||l_jobcatg,540);

Line 815: l_abv := HR_PERSON_FLEX_LOGIC.GetABV

811:
812: l_jobcatg := NULL;
813: l_abv := NULL;
814:
815: l_abv := HR_PERSON_FLEX_LOGIC.GetABV
816: ( p_ABV_formula_id => l_ABV_formula_id
817: , p_ABV => p_budget
818: , p_assignment_id => asg_start_rec.assignment_id
819: , p_effective_date => asg_start_rec.effective_start_date

Line 825: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory

821:
822: hr_utility.set_location('l_abv='||l_abv,600);
823:
824:
825: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
826: (asg_start_rec.job_id
827: ,p_job_category);
828:
829: if l_jobcatg = 'Y'

Line 861: l_abv := HR_PERSON_FLEX_LOGIC.GetABV

857:
858: l_jobcatg := NULL;
859: l_abv := NULL;
860:
861: l_abv := HR_PERSON_FLEX_LOGIC.GetABV
862: ( p_ABV_formula_id => l_ABV_formula_id
863: , p_ABV => p_budget
864: , p_assignment_id => asg_end_rec.assignment_id
865: , p_effective_date => asg_end_rec.effective_start_date

Line 871: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory

867:
868: hr_utility.set_location('l_abv='||l_abv,620);
869:
870:
871: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
872: (asg_end_rec.job_id
873: ,p_job_category);
874:
875: if l_jobcatg = 'Y'

Line 905: l_abv := HR_PERSON_FLEX_LOGIC.GetABV

901: l_abv := NULL;
902:
903: hr_utility.set_location('asg_rec.assignment_id='||asg_rec.assignment_id,630);
904:
905: l_abv := HR_PERSON_FLEX_LOGIC.GetABV
906: ( p_ABV_formula_id => l_ABV_formula_id
907: , p_ABV => p_budget
908: , p_assignment_id => asg_rec.assignment_id
909: , p_effective_date => asg_rec.effective_start_date

Line 913: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory

909: , p_effective_date => asg_rec.effective_start_date
910: , p_session_date => trunc(sysdate) );
911:
912:
913: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
914: (asg_rec.job_id
915: ,p_job_category);
916:
917: HR_PERSON_FLEX_LOGIC.GetMovementCategory(

Line 917: HR_PERSON_FLEX_LOGIC.GetMovementCategory(

913: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
914: (asg_rec.job_id
915: ,p_job_category);
916:
917: HR_PERSON_FLEX_LOGIC.GetMovementCategory(
918: p_organization_id => P_TOP_ORGANIZATION_ID
919: ,p_assignment_id => asg_rec.assignment_id
920: ,p_period_start_date => P_REPORT_DATE_FROM
921: ,p_period_end_date => P_REPORT_DATE_TO

Line 961: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory

957:
958: loop -- get_terminations
959:
960: l_jobcatg := NULL;
961: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
962: (term_rec.job_id
963: ,p_job_category);
964:
965: hr_utility.set_location('Job Categ = '||l_jobcatg,650);