DBA Data[Home] [Help]

APPS.AMS_ACTMETRIC_PVT dependencies on OZF_FUND_ADJUSTMENT_PVT

Line 2215: l_cost_table OZF_Fund_Adjustment_Pvt.cost_tbl_type;

2211: -- SELECT metric_calculation_type
2212: -- FROM ams_metrics_all_b
2213: -- WHERE metric_id = l_metric_id;
2214: l_calc_type VARCHAR2(10);
2215: l_cost_table OZF_Fund_Adjustment_Pvt.cost_tbl_type;
2216: l_cost_rec OZF_Fund_Adjustment_Pvt.cost_rec_type;
2217:
2218: BEGIN
2219:

Line 2216: l_cost_rec OZF_Fund_Adjustment_Pvt.cost_rec_type;

2212: -- FROM ams_metrics_all_b
2213: -- WHERE metric_id = l_metric_id;
2214: l_calc_type VARCHAR2(10);
2215: l_cost_table OZF_Fund_Adjustment_Pvt.cost_tbl_type;
2216: l_cost_rec OZF_Fund_Adjustment_Pvt.cost_rec_type;
2217:
2218: BEGIN
2219:
2220:

Line 2372: OZF_Fund_Adjustment_Pvt.create_budget_amt_utilized(

2368: l_cost_rec.cost_amount := l_actmet_rec.trans_actual_value;
2369: l_cost_rec.cost_desc := '';
2370: l_cost_rec.cost_curr := l_actmet_rec.transaction_currency_code;
2371: l_cost_table(1) := l_cost_rec;
2372: OZF_Fund_Adjustment_Pvt.create_budget_amt_utilized(
2373: p_budget_used_by_id => l_actmet_rec.act_metric_used_by_id,
2374: p_budget_used_by_type => l_actmet_rec.arc_act_metric_used_by,
2375: p_currency => l_actmet_rec.transaction_currency_code,
2376: p_cost_tbl => l_cost_table,

Line 5479: l_cost_table OZF_Fund_Adjustment_Pvt.cost_tbl_type;

5475: ('FUNCTION', 'MANUAL')
5476: AND metric_category = 901) -- Costs only
5477: FOR UPDATE OF published_flag NOWAIT;
5478:
5479: l_cost_table OZF_Fund_Adjustment_Pvt.cost_tbl_type;
5480: l_cost_rec OZF_Fund_Adjustment_Pvt.cost_rec_type;
5481: l_func_currency VARCHAR2(30);
5482:
5483: BEGIN

Line 5480: l_cost_rec OZF_Fund_Adjustment_Pvt.cost_rec_type;

5476: AND metric_category = 901) -- Costs only
5477: FOR UPDATE OF published_flag NOWAIT;
5478:
5479: l_cost_table OZF_Fund_Adjustment_Pvt.cost_tbl_type;
5480: l_cost_rec OZF_Fund_Adjustment_Pvt.cost_rec_type;
5481: l_func_currency VARCHAR2(30);
5482:
5483: BEGIN
5484: IF (AMS_DEBUG_HIGH_ON) THEN

Line 5542: OZF_Fund_Adjustment_Pvt.create_budget_amt_utilized(

5538: END LOOP;
5539: CLOSE c_get_post_metrics;
5540:
5541: IF l_cost_table.COUNT > 0 THEN
5542: OZF_Fund_Adjustment_Pvt.create_budget_amt_utilized(
5543: p_budget_used_by_id => p_obj_id,
5544: p_budget_used_by_type => p_obj_type,
5545: p_currency => l_func_currency,
5546: p_cost_tbl => l_cost_table,