[Home] [Help]
294: ,l_period_end_date) LOOP
295:
296: l_assignment_id := assignment_rec.assignment_id;
297:
298: l_actuals := HrFastAnswers.GetBudgetValue(
299: p_budget_metric_formula_id => p_formula_id
300: ,p_budget_metric => l_budget_type_code
301: ,p_assignment_id => l_assignment_id
302: ,p_effective_date => l_period_end_date
316: ,l_period_end_date) LOOP
317:
318: l_assignment_id := assignment_rec.assignment_id;
319:
320: l_actuals := HrFastAnswers.GetBudgetValue(
321: p_budget_metric_formula_id => p_formula_id
322: ,p_budget_metric => l_budget_type_code
323: ,p_assignment_id => l_assignment_id
324: ,p_effective_date => l_period_end_date
338: ) LOOP
339:
340: l_assignment_id := assignment_rec.assignment_id;
341:
342: l_actuals := HrFastAnswers.GetBudgetValue(
343: p_budget_metric_formula_id => p_formula_id
344: ,p_budget_metric => l_budget_type_code
345: ,p_assignment_id => l_assignment_id
346: ,p_effective_date => l_period_end_date
358: ,l_period_end_date) LOOP
359:
360: l_assignment_id := assignment_rec.assignment_id;
361:
362: l_actuals := HrFastAnswers.GetBudgetValue(
363: p_budget_metric_formula_id => p_formula_id
364: ,p_budget_metric => l_budget_type_code
365: ,p_assignment_id => l_assignment_id
366: ,p_effective_date => l_period_end_date
377: ,l_period_end_date) LOOP
378:
379: l_assignment_id := assignment_rec.assignment_id;
380:
381: l_actuals := HrFastAnswers.GetBudgetValue(
382: p_budget_metric_formula_id => p_formula_id
383: ,p_budget_metric => l_budget_type_code
384: ,p_assignment_id => l_assignment_id
385: ,p_effective_date => l_period_end_date
413: l_budget_value NUMBER;
414:
415: BEGIN
416:
417: l_budget_value := HrFastAnswers.GetBudgetValue
418: ( p_budget_metric_formula_id => p_budget_metric_formula_id
419: , p_budget_metric => p_budget_metric
420: , p_assignment_id => p_assignment_id
421: , p_effective_date => p_effective_date
423:
424: RETURN l_budget_value;
425:
426: EXCEPTION
427: WHEN hrfastanswers.ff_not_compiled THEN
428: RETURN g_no_valid_formula;
429:
430: WHEN hrfastanswers.ff_not_exist THEN
431: RETURN g_no_valid_formula;
426: EXCEPTION
427: WHEN hrfastanswers.ff_not_compiled THEN
428: RETURN g_no_valid_formula;
429:
430: WHEN hrfastanswers.ff_not_exist THEN
431: RETURN g_no_valid_formula;
432:
433: END get_asg_budget_value;
434:
660:
661: l_assignment_id := assignment_rec.assignment_id;
662:
663: BEGIN /* cbridge bug 1875197 */
664: l_actuals := HrFastAnswers.GetBudgetValue(
665: p_budget_metric_formula_id => p_formula_id
666: ,p_budget_metric => p_budget_metric
667: ,p_assignment_id => l_assignment_id
668: ,p_effective_date => l_period_end_date
690:
691: l_assignment_id := assignment_rec.assignment_id;
692:
693: BEGIN /* cbridge bug 1875197 */
694: l_actuals := HrFastAnswers.GetBudgetValue(
695: p_budget_metric_formula_id => p_formula_id
696: ,p_budget_metric => p_budget_metric
697: ,p_assignment_id => l_assignment_id
698: ,p_effective_date => l_period_end_date
719:
720: l_assignment_id := assignment_rec.assignment_id;
721:
722: BEGIN /* cbridge bug 1875197 */
723: l_actuals := HrFastAnswers.GetBudgetValue(
724: p_budget_metric_formula_id => p_formula_id
725: ,p_budget_metric => p_budget_metric
726: ,p_assignment_id => l_assignment_id
727: ,p_effective_date => l_period_end_date
747:
748: l_assignment_id := assignment_rec.assignment_id;
749:
750: BEGIN /* cbridge bug 1875197 */
751: l_actuals := HrFastAnswers.GetBudgetValue(
752: p_budget_metric_formula_id => p_formula_id
753: ,p_budget_metric => p_budget_metric
754: ,p_assignment_id => l_assignment_id
755: ,p_effective_date => l_period_end_date
774:
775: l_assignment_id := assignment_rec.assignment_id;
776:
777: BEGIN /* cbridge bug 1875197 */
778: l_actuals := HrFastAnswers.GetBudgetValue(
779: p_budget_metric_formula_id => p_formula_id
780: ,p_budget_metric => p_budget_metric
781: ,p_assignment_id => l_assignment_id
782: ,p_effective_date => l_period_end_date
1107:
1108: l_assignment_id := assignment_rec.assignment_id;
1109:
1110: BEGIN /* cbridge bug 1875197 */
1111: l_actuals := HrFastAnswers.GetBudgetValue(
1112: p_budget_metric_formula_id => p_formula_id
1113: ,p_budget_metric => p_budget_metric
1114: ,p_assignment_id => l_assignment_id
1115: ,p_effective_date => p_effective_date
1137:
1138: l_assignment_id := assignment_rec.assignment_id;
1139:
1140: BEGIN /* cbridge bug 1875197 */
1141: l_actuals := HrFastAnswers.GetBudgetValue(
1142: p_budget_metric_formula_id => p_formula_id
1143: ,p_budget_metric => p_budget_metric
1144: ,p_assignment_id => l_assignment_id
1145: ,p_effective_date => p_effective_date
1167: l_assignment_id := assignment_rec.assignment_id;
1168:
1169:
1170: BEGIN /* cbridge bug 1875197 */
1171: l_actuals := HrFastAnswers.GetBudgetValue(
1172: p_budget_metric_formula_id => p_formula_id
1173: ,p_budget_metric => p_budget_metric
1174: ,p_assignment_id => l_assignment_id
1175: ,p_effective_date => p_effective_date
1196:
1197: l_assignment_id := assignment_rec.assignment_id;
1198:
1199: BEGIN /* cbridge bug 1875197 */
1200: l_actuals := HrFastAnswers.GetBudgetValue(
1201: p_budget_metric_formula_id => p_formula_id
1202: ,p_budget_metric => p_budget_metric
1203: ,p_assignment_id => l_assignment_id
1204: ,p_effective_date => p_effective_date
1223:
1224: l_assignment_id := assignment_rec.assignment_id;
1225:
1226: BEGIN /* cbridge bug 1875197 */
1227: l_actuals := HrFastAnswers.GetBudgetValue(
1228: p_budget_metric_formula_id => p_formula_id
1229: ,p_budget_metric => p_budget_metric
1230: ,p_assignment_id => l_assignment_id
1231: ,p_effective_date => p_effective_date