194: ( p_org_param_id
195: , p_start_date )
196: loop
197:
198: l_manpower_start := HrFastAnswers.GetBudgetValue
199: ( p_budget_metric_formula_id => l_formula_id
200: , p_budget_metric => p_budget_metric
201: , p_assignment_id => ass_rec.assignment_id
202: , p_effective_date => p_start_date
211: ( p_org_param_id
212: , p_end_date )
213: loop
214:
215: l_manpower_end := HrFastAnswers.GetBudgetValue
216: ( p_budget_metric_formula_id => l_formula_id
217: , p_budget_metric => p_budget_metric
218: , p_assignment_id => ass_rec.assignment_id
219: , p_effective_date => p_end_date
477: /* bug fix 1747233 03-MAY-2001 */
478: /* only call the fast formula if ass_rec.assignment_id exists on p_start_date */
479: if check_asg_is_active(ass_rec.assignment_id, p_start_date) then
480:
481: l_manpower_start := nvl( HrFastAnswers.GetBudgetValue
482: ( p_budget_metric_formula_id => l_formula_id
483: , p_budget_metric => p_budget_metric
484: , p_assignment_id => ass_rec.assignment_id
485: , p_effective_date => p_start_date
490: /* bug fix 1747233 03-MAY-2001 */
491: /* only call the fast formula if ass_rec.assignment_id exists on p_end_date */
492: if check_asg_is_active(ass_rec.assignment_id, p_end_date) then
493:
494: l_manpower_end := nvl( HrFastAnswers.GetBudgetValue
495: ( p_budget_metric_formula_id => l_formula_id
496: , p_budget_metric => p_budget_metric
497: , p_assignment_id => ass_rec.assignment_id
498: , p_effective_date => p_end_date
514: OrgPerfData(org_rec.organization_id).gains + l_manpower_end;
515:
516: elsif (ass_rec.loss = 1)
517: then
518: HRFastAnswers.GetAssignmentCategory
519: ( p_org_param_id
520: , ass_rec.assignment_id
521: , p_start_date+1
522: , p_end_date
710: ( p_budget_id
711: , p_report_date )
712: loop
713:
714: l_manpower_start := HrFastAnswers.GetBudgetValue
715: ( p_budget_metric_formula_id => l_formula_id
716: , p_budget_metric => l_budget_metric
717: , p_assignment_id => ass_rec.assignment_id
718: , p_effective_date => p_report_date
911: loop
912:
913: l_error := '3.1 check if fastformula exist and compiled';
914:
915: --hrfastanswers.checkfastformulacompiled(l_formula_id, l_budget_metric);
916:
917: l_error := '3.1, l_budget_metric= '|| l_budget_metric || ' l_formula_id = ' || l_formula_id;
918:
919: l_manpower_start := HrFastAnswers.GetBudgetValue
915: --hrfastanswers.checkfastformulacompiled(l_formula_id, l_budget_metric);
916:
917: l_error := '3.1, l_budget_metric= '|| l_budget_metric || ' l_formula_id = ' || l_formula_id;
918:
919: l_manpower_start := HrFastAnswers.GetBudgetValue
920: ( p_budget_metric_formula_id => l_formula_id
921: , p_budget_metric => l_budget_metric
922: , p_assignment_id => ass_rec.assignment_id
923: , p_effective_date => p_report_date