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 dependencies on HR_PERSON_FLEX_LOGIC

Line 676: and formula_type_id = HR_PERSON_FLEX_LOGIC.GetFormulaTypeID('Oracle Payroll');

672: from ff_formulas_f
673: where p_business_group_id = business_group_id+0
674: and trunc(sysdate) between effective_start_date and effective_end_date
675: and formula_name = 'HR_PERSON_TYPE'
676: and formula_type_id = HR_PERSON_FLEX_LOGIC.GetFormulaTypeID('Oracle Payroll');
677:
678: cursor c_get_tmplt_PerType_formula is
679: select formula_id
680: from ff_formulas_f

Line 684: and formula_type_id = HR_PERSON_FLEX_LOGIC.GetFormulaTypeID('Oracle Payroll');

680: from ff_formulas_f
681: where business_group_id+0 is null
682: and trunc(sysdate) between effective_start_date and effective_end_date
683: and formula_name = 'HR_PERSON_TYPE_TEMPLATE'
684: and formula_type_id = HR_PERSON_FLEX_LOGIC.GetFormulaTypeID('Oracle Payroll');
685:
686: cursor c_get_term_formula
687: (p_business_group_id NUMBER )
688: is

Line 694: and formula_type_id = HR_PERSON_FLEX_LOGIC.GetFormulaTypeID('Oracle Payroll');

690: from ff_formulas_f
691: where business_group_id+0 = p_business_group_id
692: and trunc(sysdate) between effective_start_date and effective_end_date
693: and formula_name = 'HR_MOVE_TYPE'
694: and formula_type_id = HR_PERSON_FLEX_LOGIC.GetFormulaTypeID('Oracle Payroll');
695:
696: cursor c_get_tmplt_term_formula is
697: select formula_id
698: from ff_formulas_f

Line 702: and formula_type_id = HR_PERSON_FLEX_LOGIC.GetFormulaTypeID('Oracle Payroll');

698: from ff_formulas_f
699: where business_group_id+0 is null
700: and trunc(sysdate) between effective_start_date and effective_end_date
701: and formula_name = 'HR_MOVE_TYPE_TEMPLATE'
702: and formula_type_id = HR_PERSON_FLEX_LOGIC.GetFormulaTypeID('Oracle Payroll');
703: */
704: cursor c_get_ABV_formula
705: ( p_business_group_id NUMBER )
706: is

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

708: from ff_formulas_f
709: where p_business_group_id = business_group_id+0
710: and trunc(sysdate) between effective_start_date and effective_end_date
711: and formula_name = 'BUDGET_'||p_budget
712: and formula_type_id = HR_PERSON_FLEX_LOGIC.GetFormulaTypeID('Quickpaint');
713:
714:
715: cursor c_get_tmplt_ABV_formula is
716: select formula_id

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

717: from ff_formulas_f
718: where business_group_id+0 is null
719: and trunc(sysdate) between effective_start_date and effective_end_date
720: and formula_name = 'TEMPLATE_'||p_budget
721: and formula_type_id = HR_PERSON_FLEX_LOGIC.GetFormulaTypeID('Quickpaint');
722:
723: cursor c_get_all_orgs
724: (P_ORGANIZATION_STRUCTURE_ID NUMBER
725: ,P_TOP_ORGANIZATION_ID NUMBER

Line 831: l_cwk_profile := HR_PERSON_FLEX_LOGIC.HeadCountForCWK;

827:
828:
829: begin
830:
831: l_cwk_profile := HR_PERSON_FLEX_LOGIC.HeadCountForCWK;
832:
833: -- Look for User Defined HR_PERSON_TYPE Formula
834:
835: l_AsgWorkerType_formula_id := HR_PERSON_FLEX_LOGIC.GetFormulaID

Line 835: l_AsgWorkerType_formula_id := HR_PERSON_FLEX_LOGIC.GetFormulaID

831: l_cwk_profile := HR_PERSON_FLEX_LOGIC.HeadCountForCWK;
832:
833: -- Look for User Defined HR_PERSON_TYPE Formula
834:
835: l_AsgWorkerType_formula_id := HR_PERSON_FLEX_LOGIC.GetFormulaID
836: (p_business_group_id
837: ,'HR_PERSON_TYPE'
838: ,'Oracle Payroll');
839: /*

Line 930: HR_PERSON_FLEX_LOGIC.GetFormulaID

926:
927: -- Look for User Defined formula HR_MOVE_TYPE
928:
929: l_term_formula_id :=
930: HR_PERSON_FLEX_LOGIC.GetFormulaID
931: (p_business_group_id
932: ,'HR_MOVE_TYPE'
933: ,'Oracle Payroll');
934:

Line 937: HR_PERSON_FLEX_LOGIC.GetFormulaID

933: ,'Oracle Payroll');
934:
935:
936: l_cwk_term_formula_id :=
937: HR_PERSON_FLEX_LOGIC.GetFormulaID
938: (p_business_group_id
939: ,'HR_CWK_MOVE_TYPE'
940: ,'Oracle Payroll');
941:

Line 1086: l_abv := HR_PERSON_FLEX_LOGIC.GetABV

1082:
1083: l_jobcatg := NULL;
1084: l_abv := NULL;
1085:
1086: l_abv := HR_PERSON_FLEX_LOGIC.GetABV
1087: ( p_ABV_formula_id => l_ABV_formula_id
1088: , p_ABV => p_budget
1089: , p_assignment_id => asg_rec.assignment_id
1090: , p_effective_date => asg_rec.effective_start_date

Line 1094: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory

1090: , p_effective_date => asg_rec.effective_start_date
1091: , p_session_date => trunc(sysdate) );
1092:
1093:
1094: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
1095: (asg_rec.job_id
1096: ,p_job_category);
1097:
1098:

Line 1123: l_abv := HR_PERSON_FLEX_LOGIC.GetABV

1119:
1120: l_jobcatg := NULL;
1121: l_abv := NULL;
1122:
1123: l_abv := HR_PERSON_FLEX_LOGIC.GetABV
1124: ( p_ABV_formula_id => l_ABV_formula_id
1125: , p_ABV => p_budget
1126: , p_assignment_id => asg_rec.assignment_id
1127: , p_effective_date => asg_rec.effective_start_date

Line 1131: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory

1127: , p_effective_date => asg_rec.effective_start_date
1128: , p_session_date => trunc(sysdate) );
1129:
1130:
1131: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
1132: (asg_rec.job_id
1133: ,p_job_category);
1134:
1135:

Line 1145: HR_PERSON_FLEX_LOGIC.GetMovementCategory(

1141: end if;*/
1142:
1143: l_movement_category := NULL;
1144:
1145: HR_PERSON_FLEX_LOGIC.GetMovementCategory(
1146: p_organization_id => org_rec.organization_id
1147: ,p_assignment_id => asg_rec.assignment_id
1148: ,p_period_start_date => asg_rec.effective_end_date
1149: ,p_period_end_date => P_DATE_TO

Line 1204: l_abv := HR_PERSON_FLEX_LOGIC.GetABV

1200:
1201: l_jobcatg := NULL;
1202: l_abv := NULL;
1203:
1204: l_abv := HR_PERSON_FLEX_LOGIC.GetABV
1205: ( p_ABV_formula_id => l_ABV_formula_id
1206: , p_ABV => p_budget
1207: , p_assignment_id => asg_rec.assignment_id
1208: , p_effective_date => asg_rec.effective_start_date

Line 1212: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory

1208: , p_effective_date => asg_rec.effective_start_date
1209: , p_session_date => trunc(sysdate) );
1210:
1211:
1212: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
1213: (asg_rec.job_id
1214: ,p_job_category);
1215:
1216: if l_jobcatg = 'Y'

Line 1240: l_abv := HR_PERSON_FLEX_LOGIC.GetABV

1236:
1237: l_jobcatg := NULL;
1238: l_abv := NULL;
1239:
1240: l_abv := HR_PERSON_FLEX_LOGIC.GetABV
1241: ( p_ABV_formula_id => l_ABV_formula_id
1242: , p_ABV => p_budget
1243: , p_assignment_id => asg_rec.assignment_id
1244: , p_effective_date => asg_rec.effective_start_date

Line 1248: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory

1244: , p_effective_date => asg_rec.effective_start_date
1245: , p_session_date => trunc(sysdate) );
1246:
1247:
1248: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
1249: (asg_rec.job_id
1250: ,p_job_category);
1251:
1252: /* if l_jobcatg = 'Y'

Line 1259: HR_PERSON_FLEX_LOGIC.GetMovementCategory(

1255: else
1256: l_nonrev_end_val := l_nonrev_end_val + l_abv;
1257: end if;
1258: */
1259: HR_PERSON_FLEX_LOGIC.GetMovementCategory(
1260: p_organization_id => org_rec.organization_id
1261: ,p_assignment_id => asg_rec.assignment_id
1262: ,p_period_start_date => P_DATE_FROM
1263: ,p_period_end_date => asg_rec.effective_end_date

Line 1295: l_cur_nh := HR_PERSON_FLEX_LOGIC.GetCurNHNew

1291: end if;
1292:
1293: l_cur_nh := NULL;
1294:
1295: l_cur_nh := HR_PERSON_FLEX_LOGIC.GetCurNHNew
1296: ( p_organization_id => org_rec.organization_id
1297: , p_assignment_id => asg_rec.assignment_id
1298: , p_assignment_type => P_WORKER_TYPE
1299: , p_cur_date_from => l_cur_date_from

Line 1379: l_pertype := HR_PERSON_FLEX_LOGIC.GetAsgWorkerType

1375:
1376: if assgt_rec.assignment_type <> 'C' then
1377:
1378: l_pertype := NULL;
1379: l_pertype := HR_PERSON_FLEX_LOGIC.GetAsgWorkerType
1380: (p_AsgWorkerType_formula_id => l_AsgWorkerType_formula_id
1381: ,p_assignment_id => assgt_rec.assignment_id
1382: ,p_effective_date => assgt_rec.effective_start_date
1383: ,p_session_date => trunc(sysdate)

Line 1391: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory

1387:
1388: hr_utility.set_location('AsgWorkerType = '||l_pertype,280);
1389:
1390: l_jobcatg := NULL;
1391: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
1392: (assgt_rec.job_id
1393: ,p_job_category);
1394: l_abv := 0;
1395: l_abv := HR_PERSON_FLEX_LOGIC.GetABV

Line 1395: l_abv := HR_PERSON_FLEX_LOGIC.GetABV

1391: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
1392: (assgt_rec.job_id
1393: ,p_job_category);
1394: l_abv := 0;
1395: l_abv := HR_PERSON_FLEX_LOGIC.GetABV
1396: ( p_ABV_formula_id => l_ABV_formula_id
1397: , p_ABV => p_budget
1398: , p_assignment_id => assgt_rec.assignment_id
1399: , p_effective_date => assgt_rec.effective_start_date

Line 1503: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory

1499:
1500: loop -- get_open_offers
1501:
1502: l_jobcatg := NULL;
1503: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
1504: (appl_open_offers_rec.job_id
1505: ,p_job_category);
1506:
1507: if l_jobcatg = 'Y'

Line 1536: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory

1532:
1533: loop -- get_accepted_offers
1534:
1535: l_jobcatg := NULL;
1536: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
1537: (appl_accepted_offers_rec.job_id
1538: ,p_job_category);
1539:
1540: if l_jobcatg = 'Y'

Line 1566: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory

1562:
1563: loop -- get_requisitions
1564: l_jobcatg := NULL;
1565:
1566: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
1567: (vac_rec.job_id
1568: ,p_job_category);
1569:
1570: if vac_rec.budget_measurement_value <> 0

Line 1611: l_abv := HR_PERSON_FLEX_LOGIC.GetABV

1607:
1608: l_jobcatg := NULL;
1609: l_abv := NULL;
1610:
1611: l_abv := HR_PERSON_FLEX_LOGIC.GetABV
1612: ( p_ABV_formula_id => l_ABV_formula_id
1613: , p_ABV => p_budget
1614: , p_assignment_id => cur_term_rec.assignment_id
1615: , p_effective_date => cur_term_rec.actual_termination_date

Line 1619: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory

1615: , p_effective_date => cur_term_rec.actual_termination_date
1616: , p_session_date => trunc(sysdate) );
1617:
1618:
1619: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
1620: (cur_term_rec.job_id
1621: ,p_job_category);
1622:
1623: if l_jobcatg = 'Y'

Line 1659: l_termtype:= HR_PERSON_FLEX_LOGIC.GetTermType

1655:
1656: hr_utility.set_location('Leaving Reason = '||term_rec.leaving_reason,465);
1657:
1658: l_termtype:= NULL;
1659: l_termtype:= HR_PERSON_FLEX_LOGIC.GetTermType
1660: (p_term_formula_id => l_term_formula_id
1661: ,p_leaving_reason => term_rec.leaving_reason
1662: ,p_session_date => trunc(sysdate));
1663:

Line 1669: l_abv := HR_PERSON_FLEX_LOGIC.GetABV

1665:
1666: l_jobcatg := NULL;
1667: l_abv := NULL;
1668:
1669: l_abv := HR_PERSON_FLEX_LOGIC.GetABV
1670: ( p_ABV_formula_id => l_ABV_formula_id
1671: , p_ABV => p_budget
1672: , p_assignment_id => term_rec.assignment_id
1673: , p_effective_date => term_rec.actual_termination_date

Line 1676: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory

1672: , p_assignment_id => term_rec.assignment_id
1673: , p_effective_date => term_rec.actual_termination_date
1674: , p_session_date => trunc(sysdate) );
1675:
1676: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
1677: (term_rec.job_id
1678: ,p_job_category);
1679:
1680: hr_utility.set_location('Job Category = '||l_jobcatg,475);

Line 1750: l_abv := HR_PERSON_FLEX_LOGIC.GetABV

1746:
1747: l_jobcatg := NULL;
1748: l_abv := NULL;
1749:
1750: l_abv := HR_PERSON_FLEX_LOGIC.GetABV
1751: ( p_ABV_formula_id => l_ABV_formula_id
1752: , p_ABV => p_budget
1753: , p_assignment_id => cur_term_rec.assignment_id
1754: , p_effective_date => cur_term_rec.actual_termination_date

Line 1758: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory

1754: , p_effective_date => cur_term_rec.actual_termination_date
1755: , p_session_date => trunc(sysdate) );
1756:
1757:
1758: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
1759: (cur_term_rec.job_id
1760: ,p_job_category);
1761:
1762: if l_jobcatg = 'Y'

Line 1797: l_cwk_termtype := HR_PERSON_FLEX_LOGIC.GetTermType

1793: l_jobcatg := NULL;
1794: l_abv := NULL;
1795:
1796: l_cwk_termtype := NULL;
1797: l_cwk_termtype := HR_PERSON_FLEX_LOGIC.GetTermType
1798: (p_term_formula_id => l_cwk_term_formula_id
1799: ,p_leaving_reason => term_rec.termination_reason
1800: ,p_session_date => trunc(sysdate));
1801:

Line 1804: l_abv := HR_PERSON_FLEX_LOGIC.GetABV

1800: ,p_session_date => trunc(sysdate));
1801:
1802: hr_utility.set_location('Term Type = '||l_cwk_termtype,470);
1803:
1804: l_abv := HR_PERSON_FLEX_LOGIC.GetABV
1805: ( p_ABV_formula_id => l_ABV_formula_id
1806: , p_ABV => p_budget
1807: , p_assignment_id => term_rec.assignment_id
1808: , p_effective_date => term_rec.actual_termination_date

Line 1811: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory

1807: , p_assignment_id => term_rec.assignment_id
1808: , p_effective_date => term_rec.actual_termination_date
1809: , p_session_date => trunc(sysdate) );
1810:
1811: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
1812: (term_rec.job_id
1813: ,p_job_category);
1814:
1815: -- hr_utility.set_location('Job Categ = '||l_jobcatg,565);

Line 1931: l_abv := HR_PERSON_FLEX_LOGIC.GetABV

1927:
1928: l_jobcatg := NULL;
1929: l_abv := NULL;
1930:
1931: l_abv := HR_PERSON_FLEX_LOGIC.GetABV
1932: ( p_ABV_formula_id => l_ABV_formula_id
1933: , p_ABV => p_budget
1934: , p_assignment_id => asg_rec.assignment_id
1935: , p_effective_date => asg_rec.effective_start_date

Line 1943: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory

1939:
1940:
1941:
1942:
1943: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
1944: (asg_rec.job_id
1945: ,p_job_category);
1946:
1947: hr_utility.set_location('Top Org l_jobcatg = '||l_jobcatg,880);

Line 1972: l_abv := HR_PERSON_FLEX_LOGIC.GetABV

1968:
1969: l_jobcatg := NULL;
1970: l_abv := NULL;
1971:
1972: l_abv := HR_PERSON_FLEX_LOGIC.GetABV
1973: ( p_ABV_formula_id => l_ABV_formula_id
1974: , p_ABV => p_budget
1975: , p_assignment_id => asg_rec.assignment_id
1976: , p_effective_date => asg_rec.effective_start_date

Line 1984: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory

1980: hr_utility.set_location('Top Org Effective Start Date = '||to_char(asg_rec.effective_start_date,'DD/MM/YYYY'),850);
1981: hr_utility.set_location('Top Org Job ID = '||asg_rec.job_id,860);
1982: hr_utility.set_location('Top Org l_abv = '||l_abv,870);
1983:
1984: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
1985: (asg_rec.job_id
1986: ,p_job_category);
1987:
1988: hr_utility.set_location('Top Org l_jobcatg = '||l_jobcatg,880);

Line 1999: HR_PERSON_FLEX_LOGIC.GetMovementCategory(

1995: end if;
1996: */
1997: l_movement_category := NULL;
1998:
1999: HR_PERSON_FLEX_LOGIC.GetMovementCategory(
2000: p_organization_id => P_TOP_ORGANIZATION_ID
2001: ,p_assignment_id => asg_rec.assignment_id
2002: ,p_period_start_date => asg_rec.effective_end_date
2003: ,p_period_end_date => P_DATE_TO

Line 2057: l_abv := HR_PERSON_FLEX_LOGIC.GetABV

2053:
2054: l_jobcatg := NULL;
2055: l_abv := NULL;
2056:
2057: l_abv := HR_PERSON_FLEX_LOGIC.GetABV
2058: ( p_ABV_formula_id => l_ABV_formula_id
2059: , p_ABV => p_budget
2060: , p_assignment_id => asg_rec.assignment_id
2061: , p_effective_date => asg_rec.effective_start_date

Line 2065: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory

2061: , p_effective_date => asg_rec.effective_start_date
2062: , p_session_date => trunc(sysdate) );
2063:
2064:
2065: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
2066: (asg_rec.job_id
2067: ,p_job_category);
2068:
2069: if l_jobcatg = 'Y'

Line 2093: l_abv := HR_PERSON_FLEX_LOGIC.GetABV

2089:
2090: l_jobcatg := NULL;
2091: l_abv := NULL;
2092:
2093: l_abv := HR_PERSON_FLEX_LOGIC.GetABV
2094: ( p_ABV_formula_id => l_ABV_formula_id
2095: , p_ABV => p_budget
2096: , p_assignment_id => asg_rec.assignment_id
2097: , p_effective_date => asg_rec.effective_start_date

Line 2101: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory

2097: , p_effective_date => asg_rec.effective_start_date
2098: , p_session_date => trunc(sysdate) );
2099:
2100:
2101: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
2102: (asg_rec.job_id
2103: ,p_job_category);
2104: /*
2105: if l_jobcatg = 'Y'

Line 2112: HR_PERSON_FLEX_LOGIC.GetMovementCategory(

2108: else
2109: l_nonrev_end_val := l_nonrev_end_val + l_abv;
2110: end if;
2111: */
2112: HR_PERSON_FLEX_LOGIC.GetMovementCategory(
2113: p_organization_id => P_TOP_ORGANIZATION_ID
2114: ,p_assignment_id => asg_rec.assignment_id
2115: ,p_period_start_date => P_DATE_FROM
2116: ,p_period_end_date => asg_rec.effective_end_date

Line 2147: l_cur_nh := HR_PERSON_FLEX_LOGIC.GetCurNHNew

2143: end if;
2144:
2145: l_cur_nh := NULL;
2146:
2147: l_cur_nh := HR_PERSON_FLEX_LOGIC.GetCurNHNew
2148: ( p_organization_id => P_TOP_ORGANIZATION_ID
2149: , p_assignment_id => asg_rec.assignment_id
2150: , p_assignment_type => P_WORKER_TYPE
2151: , p_cur_date_from => l_cur_date_from

Line 2223: l_pertype := HR_PERSON_FLEX_LOGIC.GetAsgWorkerType

2219: hr_utility.set_location('assgt_rec.effective_start_date = '||to_char(assgt_rec.effective_start_date,'DD/MM/YYYY'),950);
2220:
2221: if assgt_rec.assignment_type <> 'C' then
2222: l_pertype := NULL;
2223: l_pertype := HR_PERSON_FLEX_LOGIC.GetAsgWorkerType
2224: (p_AsgWorkerType_formula_id => l_AsgWorkerType_formula_id
2225: ,p_assignment_id => assgt_rec.assignment_id
2226: ,p_effective_date => assgt_rec.effective_start_date
2227: ,p_session_date => trunc(sysdate)

Line 2234: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory

2230:
2231: hr_utility.set_location('Top Org AsgWorkerType = '||l_pertype,960);
2232:
2233: l_jobcatg := NULL;
2234: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
2235: (assgt_rec.job_id
2236: ,p_job_category);
2237: l_abv := 0;
2238: l_abv := HR_PERSON_FLEX_LOGIC.GetABV

Line 2238: l_abv := HR_PERSON_FLEX_LOGIC.GetABV

2234: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
2235: (assgt_rec.job_id
2236: ,p_job_category);
2237: l_abv := 0;
2238: l_abv := HR_PERSON_FLEX_LOGIC.GetABV
2239: ( p_ABV_formula_id => l_ABV_formula_id
2240: , p_ABV => p_budget
2241: , p_assignment_id => assgt_rec.assignment_id
2242: , p_effective_date => assgt_rec.effective_start_date

Line 2343: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory

2339:
2340: loop -- get_open_offers
2341:
2342: l_jobcatg := NULL;
2343: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
2344: (appl_open_offers_rec.job_id
2345: ,p_job_category);
2346:
2347: if l_jobcatg = 'Y'

Line 2378: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory

2374:
2375: loop -- get_accepted_offers
2376:
2377: l_jobcatg := NULL;
2378: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
2379: (appl_accepted_offers_rec.job_id
2380: ,p_job_category);
2381:
2382: if l_jobcatg = 'Y'

Line 2409: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory

2405: ,P_DATE_TO )
2406: loop
2407: l_jobcatg := NULL;
2408:
2409: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
2410: (vac_rec.job_id
2411: ,p_job_category);
2412:
2413: if vac_rec.budget_measurement_value <> 0

Line 2452: l_abv := HR_PERSON_FLEX_LOGIC.GetABV

2448:
2449: l_jobcatg := NULL;
2450: l_abv := NULL;
2451:
2452: l_abv := HR_PERSON_FLEX_LOGIC.GetABV
2453: ( p_ABV_formula_id => l_ABV_formula_id
2454: , p_ABV => p_budget
2455: , p_assignment_id => cur_term_rec.assignment_id
2456: , p_effective_date => cur_term_rec.actual_termination_date

Line 2460: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory

2456: , p_effective_date => cur_term_rec.actual_termination_date
2457: , p_session_date => trunc(sysdate) );
2458:
2459:
2460: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
2461: (cur_term_rec.job_id
2462: ,p_job_category);
2463:
2464: if l_jobcatg = 'Y'

Line 2494: l_termtype:= HR_PERSON_FLEX_LOGIC.GetTermType

2490:
2491: loop -- get_terminations
2492:
2493: l_termtype:= NULL;
2494: l_termtype:= HR_PERSON_FLEX_LOGIC.GetTermType
2495: (p_term_formula_id => l_term_formula_id
2496: ,p_leaving_reason => term_rec.leaving_reason
2497: ,p_session_date => trunc(sysdate));
2498:

Line 2504: l_abv := HR_PERSON_FLEX_LOGIC.GetABV

2500:
2501: l_jobcatg := NULL;
2502: l_abv := NULL;
2503:
2504: l_abv := HR_PERSON_FLEX_LOGIC.GetABV
2505: ( p_ABV_formula_id => l_ABV_formula_id
2506: , p_ABV => p_budget
2507: , p_assignment_id => term_rec.assignment_id
2508: , p_effective_date => term_rec.actual_termination_date

Line 2512: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory

2508: , p_effective_date => term_rec.actual_termination_date
2509: , p_session_date => trunc(sysdate) );
2510:
2511:
2512: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
2513: (term_rec.job_id
2514: ,p_job_category);
2515:
2516: hr_utility.set_location('Job Categ = '||l_jobcatg,410);

Line 2574: l_abv := HR_PERSON_FLEX_LOGIC.GetABV

2570:
2571: l_jobcatg := NULL;
2572: l_abv := NULL;
2573:
2574: l_abv := HR_PERSON_FLEX_LOGIC.GetABV
2575: ( p_ABV_formula_id => l_ABV_formula_id
2576: , p_ABV => p_budget
2577: , p_assignment_id => cur_term_rec.assignment_id
2578: , p_effective_date => cur_term_rec.actual_termination_date

Line 2582: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory

2578: , p_effective_date => cur_term_rec.actual_termination_date
2579: , p_session_date => trunc(sysdate) );
2580:
2581:
2582: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
2583: (cur_term_rec.job_id
2584: ,p_job_category);
2585:
2586: if l_jobcatg = 'Y'

Line 2619: l_cwk_termtype := HR_PERSON_FLEX_LOGIC.GetTermType

2615: l_jobcatg := NULL;
2616: l_abv := NULL;
2617:
2618: l_cwk_termtype := NULL;
2619: l_cwk_termtype := HR_PERSON_FLEX_LOGIC.GetTermType
2620: (p_term_formula_id => l_cwk_term_formula_id
2621: ,p_leaving_reason => term_rec.termination_reason
2622: ,p_session_date => trunc(sysdate));
2623:

Line 2624: l_abv := HR_PERSON_FLEX_LOGIC.GetABV

2620: (p_term_formula_id => l_cwk_term_formula_id
2621: ,p_leaving_reason => term_rec.termination_reason
2622: ,p_session_date => trunc(sysdate));
2623:
2624: l_abv := HR_PERSON_FLEX_LOGIC.GetABV
2625: ( p_ABV_formula_id => l_ABV_formula_id
2626: , p_ABV => p_budget
2627: , p_assignment_id => term_rec.assignment_id
2628: , p_effective_date => term_rec.actual_termination_date

Line 2632: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory

2628: , p_effective_date => term_rec.actual_termination_date
2629: , p_session_date => trunc(sysdate) );
2630:
2631:
2632: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
2633: (term_rec.job_id
2634: ,p_job_category);
2635:
2636: hr_utility.set_location('Job Categ = '||l_jobcatg,410);