[Home] [Help]
449: is
450: --
451: Cursor csr_uom is
452: Select system_type_cd
453: From per_shared_types
454: Where shared_type_id = p_unit_of_measure_id
455: AND lookup_type = 'BUDGET_MEASUREMENT_TYPE';
456: --
457: l_proc varchar2(72) := g_package||'Validate_unit_of_measure';
456: --
457: l_proc varchar2(72) := g_package||'Validate_unit_of_measure';
458: Begin
459: hr_utility.set_location('Entering:'||l_proc, 5);
460: -- Check if the unit of measure exists in per_shared_types
461: Open csr_uom;
462: Fetch csr_uom into p_unit_of_measure_desc;
463: If csr_uom%notfound then
464: Close csr_uom;
1636: RETURN NUMBER
1637: is
1638:
1639: --
1640: l_unit_of_measure per_shared_types.system_type_cd%type;
1641: l_actuals number := 0;
1642: --
1643: l_proc varchar2(72) := g_package ||'get_assignment_actuals';
1644: --
1645: Begin
1646: --
1647: hr_utility.set_location('Entering :'||l_proc,5);
1648: --
1649: -- Check if input unit of measure is valid in per_shared_types.
1650: --
1651: Validate_unit_of_measure(p_unit_of_measure_id => p_unit_of_measure_id,
1652: p_unit_of_measure_desc => l_unit_of_measure);
1653: --
1784: l_budget_id pqh_budgets.budget_id%type := NULL;
1785: l_budget_version_id pqh_budget_versions.budget_version_id%type;
1786: --
1787:
1788: l_unit_of_measure per_shared_types.system_type_cd%type;
1789: --
1790: --
1791: l_proc varchar2(72) := g_package||'get_assignment_commitment';
1792: --
1829: End if;
1830: --
1831: End if;
1832: --
1833: -- Validate if the unit of measure is valid in per_shared_types
1834: -- Also , check if the unit has been budgeted for in the budget.
1835: --
1836: Validate_unit_of_measure(p_unit_of_measure_id => p_unit_of_measure_id,
1837: p_unit_of_measure_desc => l_unit_of_measure);
1936: l_last_actuals_date per_time_periods.end_date%type;
1937: --
1938: l_budget_id pqh_budgets.budget_id%type := NULL;
1939: --
1940: l_unit_of_measure per_shared_types.system_type_cd%type;
1941: --
1942: l_assignment_actuals number := 0;
1943: l_assignment_commitment number := 0;
1944: l_assignment_total number := 0;
2343: l_last_actuals_date per_time_periods.end_date%type;
2344: --
2345: l_budget_id pqh_budgets.budget_id%type := NULL;
2346: --
2347: l_unit_of_measure per_shared_types.system_type_cd%type;
2348: --
2349: l_assignment_actuals number := 0;
2350: l_assignment_commitment number := 0;
2351: l_assignment_total number := 0;
2618: l_last_actuals_date per_time_periods.end_date%type;
2619: --
2620: l_budget_id pqh_budgets.budget_id%type := NULL;
2621: --
2622: l_unit_of_measure per_shared_types.system_type_cd%type;
2623: --
2624: l_assignment_actuals number := 0;
2625: l_assignment_commitment number := 0;
2626: l_assignment_total number := 0;
3186: l_budget_actuals number;
3187: l_position_id pqh_budget_details.position_id%type;
3188: --
3189: l_budget_id pqh_budgets.budget_id%type := NULL;
3190: l_unit_of_measure per_shared_types.system_type_cd%type;
3191: --
3192: Cursor csr_positions_in_bdgt is
3193: Select Position_id
3194: From pqh_budget_details bdt,pqh_budget_versions bvr
3206: --
3207: Validate_budget(p_budget_version_id => p_budget_version_id,
3208: p_budget_id => l_budget_id);
3209: --
3210: -- Check if the input unit of measure is valid in per_shared_types.
3211: -- Also , check if the uom has been budgeted for in the budget.
3212: --
3213: Validate_unit_of_measure(p_unit_of_measure_id => p_unit_of_measure_id,
3214: p_unit_of_measure_desc => l_unit_of_measure);
3262: l_budget_commitment number;
3263: l_position_id pqh_budget_details.position_id%type;
3264: --
3265: l_budget_id pqh_budgets.budget_id%type := NULL;
3266: l_unit_of_measure per_shared_types.system_type_cd%type;
3267: --
3268:
3269: Cursor csr_positions_in_bdgt is
3270: Select Position_id
3283: --
3284: Validate_budget(p_budget_version_id => p_budget_version_id,
3285: p_budget_id => l_budget_id);
3286: --
3287: -- Check if the input unit of measure is valid in per_shared_types.
3288: -- Also , check if the uom has been budgeted for in the budget.
3289: --
3290: Validate_unit_of_measure(p_unit_of_measure_id => p_unit_of_measure_id,
3291: p_unit_of_measure_desc => l_unit_of_measure);
3348: l_grade_id pqh_budget_details.position_id%type;
3349: l_organization_id pqh_budget_details.position_id%type;
3350: --
3351: l_budget_id pqh_budgets.budget_id%type := NULL;
3352: l_unit_of_measure per_shared_types.system_type_cd%type;
3353: --
3354:
3355: Cursor csr_positions_in_bdgt is
3356: Select Position_id
3395: --
3396: Validate_budget(p_budget_version_id => p_budget_version_id,
3397: p_budget_id => l_budget_id);
3398: --
3399: -- Check if the input unit of measure is valid in per_shared_types.
3400: -- Also , check if the uom has been budgeted for in the budget.
3401: --
3402: Validate_unit_of_measure(p_unit_of_measure_id => p_unit_of_measure_id,
3403: p_unit_of_measure_desc => l_unit_of_measure);
3571: l_grade_id pqh_budget_details.position_id%type;
3572: l_organization_id pqh_budget_details.position_id%type;
3573: --
3574: l_budget_id pqh_budgets.budget_id%type := NULL;
3575: l_unit_of_measure per_shared_types.system_type_cd%type;
3576: --
3577:
3578: Cursor csr_positions_in_bdgt is
3579: Select Position_id
3618: --
3619: Validate_budget(p_budget_version_id => p_budget_version_id,
3620: p_budget_id => l_budget_id);
3621: --
3622: -- Check if the input unit of measure is valid in per_shared_types.
3623: -- Also , check if the uom has been budgeted for in the budget.
3624: --
3625: Validate_unit_of_measure(p_unit_of_measure_id => p_unit_of_measure_id,
3626: p_unit_of_measure_desc => l_unit_of_measure);
3867: l_last_actuals_date per_time_periods.end_date%type;
3868: --
3869: l_budget_id pqh_budgets.budget_id%type := NULL;
3870: --
3871: l_unit_of_measure per_shared_types.system_type_cd%type;
3872: --
3873: l_assignment_actuals number := 0;
3874: l_assignment_commitment number := 0;
3875: l_assignment_total number := 0;