DBA Data[Home] [Help]

APPS.AMS_ACTMETRIC_PVT dependencies on OZF_FUND_ADJUSTMENT_PVT

Line 2223: l_cost_table OZF_Fund_Adjustment_Pvt.cost_tbl_type;

2219: -- SELECT metric_calculation_type
2220: -- FROM ams_metrics_all_b
2221: -- WHERE metric_id = l_metric_id;
2222: l_calc_type VARCHAR2(10);
2223: l_cost_table OZF_Fund_Adjustment_Pvt.cost_tbl_type;
2224: l_cost_rec OZF_Fund_Adjustment_Pvt.cost_rec_type;
2225:
2226: BEGIN
2227:

Line 2224: l_cost_rec OZF_Fund_Adjustment_Pvt.cost_rec_type;

2220: -- FROM ams_metrics_all_b
2221: -- WHERE metric_id = l_metric_id;
2222: l_calc_type VARCHAR2(10);
2223: l_cost_table OZF_Fund_Adjustment_Pvt.cost_tbl_type;
2224: l_cost_rec OZF_Fund_Adjustment_Pvt.cost_rec_type;
2225:
2226: BEGIN
2227:
2228:

Line 2380: OZF_Fund_Adjustment_Pvt.create_budget_amt_utilized(

2376: l_cost_rec.cost_amount := l_actmet_rec.trans_actual_value;
2377: l_cost_rec.cost_desc := '';
2378: l_cost_rec.cost_curr := l_actmet_rec.transaction_currency_code;
2379: l_cost_table(1) := l_cost_rec;
2380: OZF_Fund_Adjustment_Pvt.create_budget_amt_utilized(
2381: p_budget_used_by_id => l_actmet_rec.act_metric_used_by_id,
2382: p_budget_used_by_type => l_actmet_rec.arc_act_metric_used_by,
2383: p_currency => l_actmet_rec.transaction_currency_code,
2384: p_cost_tbl => l_cost_table,

Line 5487: l_cost_table OZF_Fund_Adjustment_Pvt.cost_tbl_type;

5483: ('FUNCTION', 'MANUAL')
5484: AND metric_category = 901) -- Costs only
5485: FOR UPDATE OF published_flag NOWAIT;
5486:
5487: l_cost_table OZF_Fund_Adjustment_Pvt.cost_tbl_type;
5488: l_cost_rec OZF_Fund_Adjustment_Pvt.cost_rec_type;
5489: l_func_currency VARCHAR2(30);
5490:
5491: BEGIN

Line 5488: l_cost_rec OZF_Fund_Adjustment_Pvt.cost_rec_type;

5484: AND metric_category = 901) -- Costs only
5485: FOR UPDATE OF published_flag NOWAIT;
5486:
5487: l_cost_table OZF_Fund_Adjustment_Pvt.cost_tbl_type;
5488: l_cost_rec OZF_Fund_Adjustment_Pvt.cost_rec_type;
5489: l_func_currency VARCHAR2(30);
5490:
5491: BEGIN
5492: IF (AMS_DEBUG_HIGH_ON) THEN

Line 5550: OZF_Fund_Adjustment_Pvt.create_budget_amt_utilized(

5546: END LOOP;
5547: CLOSE c_get_post_metrics;
5548:
5549: IF l_cost_table.COUNT > 0 THEN
5550: OZF_Fund_Adjustment_Pvt.create_budget_amt_utilized(
5551: p_budget_used_by_id => p_obj_id,
5552: p_budget_used_by_type => p_obj_type,
5553: p_currency => l_func_currency,
5554: p_cost_tbl => l_cost_table,