[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;
1639: RETURN NUMBER
1640: is
1641:
1642: --
1643: l_unit_of_measure per_shared_types.system_type_cd%type;
1644: l_actuals number := 0;
1645: --
1646: l_proc varchar2(72) := g_package ||'get_assignment_actuals';
1647: --
1648: Begin
1649: --
1650: hr_utility.set_location('Entering :'||l_proc,5);
1651: --
1652: -- Check if input unit of measure is valid in per_shared_types.
1653: --
1654: Validate_unit_of_measure(p_unit_of_measure_id => p_unit_of_measure_id,
1655: p_unit_of_measure_desc => l_unit_of_measure);
1656: --
1787: l_budget_id pqh_budgets.budget_id%type := NULL;
1788: l_budget_version_id pqh_budget_versions.budget_version_id%type;
1789: --
1790:
1791: l_unit_of_measure per_shared_types.system_type_cd%type;
1792: --
1793: --
1794: l_proc varchar2(72) := g_package||'get_assignment_commitment';
1795: --
1832: End if;
1833: --
1834: End if;
1835: --
1836: -- Validate if the unit of measure is valid in per_shared_types
1837: -- Also , check if the unit has been budgeted for in the budget.
1838: --
1839: Validate_unit_of_measure(p_unit_of_measure_id => p_unit_of_measure_id,
1840: p_unit_of_measure_desc => l_unit_of_measure);
1939: l_last_actuals_date per_time_periods.end_date%type;
1940: --
1941: l_budget_id pqh_budgets.budget_id%type := NULL;
1942: --
1943: l_unit_of_measure per_shared_types.system_type_cd%type;
1944: --
1945: l_assignment_actuals number := 0;
1946: l_assignment_commitment number := 0;
1947: l_assignment_total number := 0;
2346: l_last_actuals_date per_time_periods.end_date%type;
2347: --
2348: l_budget_id pqh_budgets.budget_id%type := NULL;
2349: --
2350: l_unit_of_measure per_shared_types.system_type_cd%type;
2351: --
2352: l_assignment_actuals number := 0;
2353: l_assignment_commitment number := 0;
2354: l_assignment_total number := 0;
2621: l_last_actuals_date per_time_periods.end_date%type;
2622: --
2623: l_budget_id pqh_budgets.budget_id%type := NULL;
2624: --
2625: l_unit_of_measure per_shared_types.system_type_cd%type;
2626: --
2627: l_assignment_actuals number := 0;
2628: l_assignment_commitment number := 0;
2629: l_assignment_total number := 0;
3189: l_budget_actuals number;
3190: l_position_id pqh_budget_details.position_id%type;
3191: --
3192: l_budget_id pqh_budgets.budget_id%type := NULL;
3193: l_unit_of_measure per_shared_types.system_type_cd%type;
3194: --
3195: Cursor csr_positions_in_bdgt is
3196: Select Position_id
3197: From pqh_budget_details bdt,pqh_budget_versions bvr
3209: --
3210: Validate_budget(p_budget_version_id => p_budget_version_id,
3211: p_budget_id => l_budget_id);
3212: --
3213: -- Check if the input unit of measure is valid in per_shared_types.
3214: -- Also , check if the uom has been budgeted for in the budget.
3215: --
3216: Validate_unit_of_measure(p_unit_of_measure_id => p_unit_of_measure_id,
3217: p_unit_of_measure_desc => l_unit_of_measure);
3265: l_budget_commitment number;
3266: l_position_id pqh_budget_details.position_id%type;
3267: --
3268: l_budget_id pqh_budgets.budget_id%type := NULL;
3269: l_unit_of_measure per_shared_types.system_type_cd%type;
3270: --
3271:
3272: Cursor csr_positions_in_bdgt is
3273: Select Position_id
3286: --
3287: Validate_budget(p_budget_version_id => p_budget_version_id,
3288: p_budget_id => l_budget_id);
3289: --
3290: -- Check if the input unit of measure is valid in per_shared_types.
3291: -- Also , check if the uom has been budgeted for in the budget.
3292: --
3293: Validate_unit_of_measure(p_unit_of_measure_id => p_unit_of_measure_id,
3294: p_unit_of_measure_desc => l_unit_of_measure);
3351: l_grade_id pqh_budget_details.position_id%type;
3352: l_organization_id pqh_budget_details.position_id%type;
3353: --
3354: l_budget_id pqh_budgets.budget_id%type := NULL;
3355: l_unit_of_measure per_shared_types.system_type_cd%type;
3356: --
3357:
3358: Cursor csr_positions_in_bdgt is
3359: Select Position_id
3398: --
3399: Validate_budget(p_budget_version_id => p_budget_version_id,
3400: p_budget_id => l_budget_id);
3401: --
3402: -- Check if the input unit of measure is valid in per_shared_types.
3403: -- Also , check if the uom has been budgeted for in the budget.
3404: --
3405: Validate_unit_of_measure(p_unit_of_measure_id => p_unit_of_measure_id,
3406: p_unit_of_measure_desc => l_unit_of_measure);
3574: l_grade_id pqh_budget_details.position_id%type;
3575: l_organization_id pqh_budget_details.position_id%type;
3576: --
3577: l_budget_id pqh_budgets.budget_id%type := NULL;
3578: l_unit_of_measure per_shared_types.system_type_cd%type;
3579: --
3580:
3581: Cursor csr_positions_in_bdgt is
3582: Select Position_id
3621: --
3622: Validate_budget(p_budget_version_id => p_budget_version_id,
3623: p_budget_id => l_budget_id);
3624: --
3625: -- Check if the input unit of measure is valid in per_shared_types.
3626: -- Also , check if the uom has been budgeted for in the budget.
3627: --
3628: Validate_unit_of_measure(p_unit_of_measure_id => p_unit_of_measure_id,
3629: p_unit_of_measure_desc => l_unit_of_measure);
3870: l_last_actuals_date per_time_periods.end_date%type;
3871: --
3872: l_budget_id pqh_budgets.budget_id%type := NULL;
3873: --
3874: l_unit_of_measure per_shared_types.system_type_cd%type;
3875: --
3876: l_assignment_actuals number := 0;
3877: l_assignment_commitment number := 0;
3878: l_assignment_total number := 0;