eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_FUND_ALLOCATIONS_PVT dependencies on OZF_ACTMETRIC_PVT

Line 1347: l_metric_rec ozf_actmetric_pvt.act_metric_rec_type;

1343: l_notif_subject VARCHAR2(400);
1344: l_notif_body VARCHAR2(4000);
1345: l_node_info node_info_type;
1346: l_fund_rec ozf_funds_pvt.fund_rec_type;
1347: l_metric_rec ozf_actmetric_pvt.act_metric_rec_type;
1348: l_metric_fact_rec ozf_actmetricfact_Pvt.act_metric_fact_rec_type;
1349: l_fund_id_table fundIdTableType;
1350: l_temp_status VARCHAR2(1);
1351: l_fund_meaning VARCHAR2(240) := NULL;

Line 1644: Ozf_Actmetric_Pvt.Init_ActMetric_Rec(l_metric_rec);

1640:
1641: END LOOP;
1642:
1643: /* set allocation as 'PLANNED' or 'ACTIVE' */
1644: Ozf_Actmetric_Pvt.Init_ActMetric_Rec(l_metric_rec);
1645: l_metric_rec.activity_metric_id := p_alloc_id;
1646: l_metric_rec.status_code := l_alloc_status;
1647: l_metric_rec.object_version_number := p_alloc_obj_ver;
1648: IF l_alloc_status = 'ACTIVE' THEN

Line 1657: Ozf_Actmetric_Pvt.update_Actmetric( p_api_version => p_api_version

1653: /* it is important not to do some validation since allocation amount already deducted from fund,
1654: so validation will fail. should < jtf_plsql_api.G_VALID_LEVEL_RECORD CONSTANT NUMBER:= 80.
1655: set to 70 here.
1656: */
1657: Ozf_Actmetric_Pvt.update_Actmetric( p_api_version => p_api_version
1658: , p_init_msg_list => FND_API.G_FALSE
1659: , p_commit => FND_API.G_FALSE
1660: , p_validation_level => 70
1661: , x_return_status => l_return_status

Line 2295: l_metric_rec Ozf_Actmetric_Pvt.act_metric_rec_type;

2291: l_parent_amount NUMBER;
2292: l_not_visited_flag BOOLEAN := true;
2293: l_sorted_fact_ids factLevelTableType;
2294: l_fact_rec ozf_actmetricfact_Pvt.act_metric_fact_rec_type;
2295: l_metric_rec Ozf_Actmetric_Pvt.act_metric_rec_type;
2296: l_fund_rec ozf_funds_pvt.fund_rec_type;
2297: l_visited_node_set node_table_type;
2298: l_new_visited_node_set node_table_type;
2299:

Line 2372: Ozf_Actmetric_Pvt.Init_ActMetric_Rec(l_metric_rec);

2368: END IF;
2369:
2370: IF l_alloc_amount <> p_fact_table(l_index).recommend_total_amount THEN
2371: -- top level's total amount is changed, need to update metric record
2372: Ozf_Actmetric_Pvt.Init_ActMetric_Rec(l_metric_rec);
2373: l_metric_rec.activity_metric_id := p_alloc_id;
2374: l_metric_rec.object_version_number := p_alloc_obj_ver;
2375: l_metric_rec.func_actual_value := p_fact_table(l_index).recommend_total_amount;
2376:

Line 2381: Ozf_Actmetric_Pvt.update_Actmetric( p_api_version => p_api_version

2377: /* it is important not to do some validation since allocation amount already deducted from fund,
2378: so validation will fail. should < jtf_plsql_api.G_VALID_LEVEL_RECORD CONSTANT NUMBER:= 80.
2379: set to 70 here.
2380: */
2381: Ozf_Actmetric_Pvt.update_Actmetric( p_api_version => p_api_version
2382: , p_init_msg_list => FND_API.G_FALSE
2383: , p_commit => FND_API.G_FALSE
2384: , p_validation_level => 70
2385: , x_return_status => l_return_status

Line 2734: l_metric_rec ozf_actmetric_pvt.act_metric_rec_type;

2730: l_return_id NUMBER;
2731: l_tmp_id NUMBER;
2732: l_tmp_char VARCHAR2(1);
2733: l_ex_start_node ozf_act_metrics_all.ex_start_node%TYPE;
2734: l_metric_rec ozf_actmetric_pvt.act_metric_rec_type;
2735:
2736: CURSOR c_get_metric_info IS
2737: SELECT act_metric_used_by_id, created_by, status_code, action_code, ex_start_node
2738: FROM ozf_act_metrics_all

Line 2815: Ozf_Actmetric_Pvt.Init_ActMetric_Rec(l_metric_rec);

2811: RAISE FND_API.G_EXC_ERROR;
2812: END IF;
2813:
2814: /* allocation status 'PLANNED' -> 'ACTIVE' */
2815: Ozf_Actmetric_Pvt.Init_ActMetric_Rec(l_metric_rec);
2816: l_metric_rec.activity_metric_id := p_alloc_id;
2817: l_metric_rec.status_code := 'ACTIVE';
2818: l_metric_rec.object_version_number := p_alloc_obj_ver;
2819: l_metric_rec.act_metric_date := sysdate;

Line 2820: Ozf_Actmetric_Pvt.update_Actmetric( p_api_version => p_api_version

2816: l_metric_rec.activity_metric_id := p_alloc_id;
2817: l_metric_rec.status_code := 'ACTIVE';
2818: l_metric_rec.object_version_number := p_alloc_obj_ver;
2819: l_metric_rec.act_metric_date := sysdate;
2820: Ozf_Actmetric_Pvt.update_Actmetric( p_api_version => p_api_version
2821: , p_init_msg_list => fnd_api.g_false
2822: , p_commit => fnd_api.g_false
2823: , p_validation_level => fnd_api.g_valid_level_full
2824: , x_return_status => x_return_status

Line 2920: l_metric_rec ozf_actmetric_pvt.act_metric_rec_type;

2916: l_fund_name ozf_funds_all_tl.short_name%TYPE;
2917: l_notif_subject VARCHAR2(400);
2918: l_notif_body VARCHAR2(4000);
2919: l_return_id NUMBER;
2920: l_metric_rec ozf_actmetric_pvt.act_metric_rec_type;
2921: l_metric_fact_rec ozf_actmetricfact_Pvt.act_metric_fact_rec_type;
2922: l_fund_rec ozf_funds_pvt.fund_rec_type;
2923: l_fund_type VARCHAR2(30) := NULL;
2924: l_root_fund_type VARCHAR2(30) := NULL;

Line 2988: Ozf_Actmetric_Pvt.Init_ActMetric_Rec(l_metric_rec);

2984: RAISE FND_API.G_EXC_ERROR;
2985: END IF;
2986:
2987: /* allocation status 'NEW' or 'PLANNED' -> 'CANCELLED' */
2988: Ozf_Actmetric_Pvt.Init_ActMetric_Rec(l_metric_rec);
2989: l_metric_rec.activity_metric_id := p_alloc_id;
2990: l_metric_rec.status_code := 'CANCELLED';
2991: l_metric_rec.object_version_number := p_alloc_obj_ver;
2992: l_metric_rec.act_metric_date := sysdate;

Line 2993: Ozf_Actmetric_Pvt.update_Actmetric( p_api_version => p_api_version

2989: l_metric_rec.activity_metric_id := p_alloc_id;
2990: l_metric_rec.status_code := 'CANCELLED';
2991: l_metric_rec.object_version_number := p_alloc_obj_ver;
2992: l_metric_rec.act_metric_date := sysdate;
2993: Ozf_Actmetric_Pvt.update_Actmetric( p_api_version => p_api_version
2994: , p_init_msg_list => fnd_api.g_false
2995: , p_commit => fnd_api.g_false
2996: , p_validation_level => fnd_api.g_valid_level_full
2997: , x_return_status => x_return_status