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_ACTMETRICFACT_PVT

Line 717: l_fact_rec Ozf_Actmetricfact_Pvt.act_metric_fact_rec_type;

713: ) IS
714: l_api_version CONSTANT NUMBER := 1.0;
715: l_api_name CONSTANT VARCHAR2(30) := 'create_alloc_hierarchy';
716: l_return_status VARCHAR2(2);
717: l_fact_rec Ozf_Actmetricfact_Pvt.act_metric_fact_rec_type;
718: l_fund_id ozf_act_metrics_all.act_metric_used_by_id%TYPE;
719: l_alloc_amount ozf_act_metrics_all.func_actual_value%TYPE;
720: l_hierarchy_id ozf_act_metrics_all.hierarchy_id%TYPE;
721: l_hierarchy_type ozf_act_metrics_all.hierarchy_type%TYPE;

Line 830: OZF_ActMetricFact_PVT.Create_ActMetricFact

826: l_fact_rec.fact_type := 'EXCLUDE';
827: END IF;
828:
829: -- write fact record to table
830: OZF_ActMetricFact_PVT.Create_ActMetricFact
831: ( p_api_version => p_api_version
832: , x_return_status => l_return_status
833: , x_msg_count => x_msg_count
834: , x_msg_data => x_msg_data

Line 1348: l_metric_fact_rec ozf_actmetricfact_Pvt.act_metric_fact_rec_type;

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;
1352:

Line 1451: ozf_actmetricfact_pvt.init_actmetricfact_rec(l_metric_fact_rec);

1447:
1448: l_index := 1;
1449: FOR l_worksheet_rec IN c_get_worksheet_info(l_fund_id) LOOP
1450: -- dbms_output.put_line(l_full_name || 'index=' || l_index);
1451: ozf_actmetricfact_pvt.init_actmetricfact_rec(l_metric_fact_rec);
1452: IF (l_alloc_action_code = 'TRANSFER_TO_BUDGET') THEN
1453: -- add onto existing budget
1454: l_child_fund_id := l_worksheet_rec.node_id;
1455: OPEN c_get_fund_owner(l_child_fund_id);

Line 1591: ozf_actmetricfact_Pvt.Update_ActMetricFact( p_api_version => p_api_version

1587: l_metric_fact_rec.actual_total_amount := l_worksheet_rec.recommend_total_amount;
1588: l_metric_fact_rec.actual_hb_amount := NVL(l_worksheet_rec.recommend_hb_amount, 0);
1589: l_metric_fact_rec.approval_date := sysdate;
1590: END IF;
1591: ozf_actmetricfact_Pvt.Update_ActMetricFact( p_api_version => p_api_version
1592: , p_init_msg_list => FND_API.G_FALSE
1593: , p_commit => FND_API.G_FALSE
1594: , p_validation_level => p_validation_level
1595: , x_return_status => l_return_status

Line 1785: l_fact_rec ozf_actmetricfact_Pvt.act_metric_fact_rec_type;

1781: l_parent_alloc_down NUMBER;
1782: l_new_total_pct NUMBER;
1783: l_new_hb_pct NUMBER;
1784: l_return_status VARCHAR2(2);
1785: l_fact_rec ozf_actmetricfact_Pvt.act_metric_fact_rec_type;
1786:
1787: BEGIN
1788: x_return_status := fnd_api.g_ret_sts_success;
1789:

Line 1819: Ozf_Actmetricfact_Pvt.Init_ActMetricFact_Rec(x_fact_rec => l_fact_rec);

1815: l_new_total_pct <> worksheet_rec.base_total_pct OR
1816: (l_new_hb_pct IS NOT NULL AND worksheet_rec.base_hb_pct IS NULL) OR
1817: (l_new_hb_pct IS NULL AND worksheet_rec.base_hb_pct IS NOT NULL) OR
1818: l_new_hb_pct <> worksheet_rec.base_hb_pct THEN
1819: Ozf_Actmetricfact_Pvt.Init_ActMetricFact_Rec(x_fact_rec => l_fact_rec);
1820: l_fact_rec.activity_metric_fact_id := worksheet_rec.activity_metric_fact_id;
1821: l_fact_rec.object_version_number := worksheet_rec.object_version_number;
1822: l_fact_rec.base_total_pct := l_new_total_pct;
1823: l_fact_rec.base_hb_pct := l_new_hb_pct;

Line 1825: ozf_actmetricfact_Pvt.update_actmetricfact(

1821: l_fact_rec.object_version_number := worksheet_rec.object_version_number;
1822: l_fact_rec.base_total_pct := l_new_total_pct;
1823: l_fact_rec.base_hb_pct := l_new_hb_pct;
1824: -- update table ozf_act_metric_facts
1825: ozf_actmetricfact_Pvt.update_actmetricfact(
1826: p_api_version => p_api_version,
1827: p_init_msg_list => fnd_api.g_false,
1828: p_commit => fnd_api.g_false,
1829: p_validation_level => fnd_api.g_valid_level_full,

Line 1948: l_fact_rec ozf_actmetricfact_Pvt.act_metric_fact_rec_type;

1944: l_hierarchy_id NUMBER;
1945: l_hierarchy_type VARCHAR2(30);
1946: l_node_id NUMBER;
1947: l_index NUMBER;
1948: l_fact_rec ozf_actmetricfact_Pvt.act_metric_fact_rec_type;
1949: l_fund_rec ozf_funds_pvt.fund_rec_type;
1950: l_node_info node_info_type;
1951: l_visited_node_set node_table_type;
1952:

Line 2050: Ozf_Actmetricfact_Pvt.Init_ActMetricFact_Rec(x_fact_rec => l_fact_rec);

2046:
2047: -- cascade changes
2048: l_index := 0;
2049: FOR worksheet_rec IN c_get_subtree_worksheet LOOP
2050: Ozf_Actmetricfact_Pvt.Init_ActMetricFact_Rec(x_fact_rec => l_fact_rec);
2051: l_fact_rec.activity_metric_fact_id := worksheet_rec.activity_metric_fact_id;
2052: l_fact_rec.object_version_number := worksheet_rec.object_version_number;
2053: OPEN c_get_allocdown_amount(worksheet_rec.previous_fact_id);
2054: FETCH c_get_allocdown_amount INTO l_parent_amount;

Line 2058: ozf_actmetricfact_Pvt.update_actmetricfact(

2054: FETCH c_get_allocdown_amount INTO l_parent_amount;
2055: CLOSE c_get_allocdown_amount;
2056: l_fact_rec.recommend_total_amount := l_parent_amount * worksheet_rec.base_total_pct / 100;
2057: l_fact_rec.recommend_hb_amount := l_fact_rec.recommend_total_amount * worksheet_rec.base_hb_pct / 100;
2058: ozf_actmetricfact_Pvt.update_actmetricfact(
2059: p_api_version => p_api_version,
2060: p_init_msg_list => fnd_api.g_false,
2061: p_commit => fnd_api.g_false,
2062: p_validation_level => fnd_api.g_valid_level_full,

Line 2294: l_fact_rec ozf_actmetricfact_Pvt.act_metric_fact_rec_type;

2290: l_alloc_action_code VARCHAR2(30);
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;

Line 2398: ozf_actmetricfact_Pvt.update_actmetricfact(

2394: END IF; -- IF l_alloc_amount <> p_fact_table(l_index).recommend_total_amount THEN
2395: END IF; -- IF p_fact_table(l_index).node_id = l_alloc_start_node THEN
2396:
2397: -- update table ozf_act_metric_facts
2398: ozf_actmetricfact_Pvt.update_actmetricfact(
2399: p_api_version => p_api_version,
2400: p_init_msg_list => fnd_api.g_false,
2401: p_commit => fnd_api.g_false,
2402: p_validation_level => fnd_api.g_valid_level_full,

Line 2567: l_metric_fact_rec ozf_actmetricfact_Pvt.act_metric_fact_rec_type;

2563: l_notif_body VARCHAR2(4000);
2564: l_return_id NUMBER;
2565: l_tmp_id NUMBER;
2566: l_tmp_char VARCHAR2(1);
2567: l_metric_fact_rec ozf_actmetricfact_Pvt.act_metric_fact_rec_type;
2568: l_fund_rec ozf_funds_pvt.fund_rec_type;
2569: l_fund_type VARCHAR2(30) := NULL;
2570: l_fund_meaning VARCHAR2(240) := NULL;
2571: l_temp_status VARCHAR2(1);

Line 2583: ozf_actmetricfact_pvt.init_actmetricfact_rec(l_metric_fact_rec);

2579: AND fact.arc_act_metric_used_by = 'FUND';
2580:
2581: BEGIN
2582: -- update child node status as ACTIVE
2583: ozf_actmetricfact_pvt.init_actmetricfact_rec(l_metric_fact_rec);
2584: l_metric_fact_rec.activity_metric_fact_id := p_child_fact_id;
2585: l_metric_fact_rec.object_version_number := p_child_fact_obj_ver;
2586: l_metric_fact_rec.status_code := 'ACTIVE';
2587: -- set actual_total_amount, actual_hb_amount, approval_date

Line 2591: ozf_actmetricfact_Pvt.Update_ActMetricFact( p_api_version => p_api_version

2587: -- set actual_total_amount, actual_hb_amount, approval_date
2588: l_metric_fact_rec.actual_total_amount := p_approved_total;
2589: l_metric_fact_rec.actual_hb_amount := NVL(p_approved_hb, 0);
2590: l_metric_fact_rec.approval_date := sysdate;
2591: ozf_actmetricfact_Pvt.Update_ActMetricFact( p_api_version => p_api_version
2592: , p_init_msg_list => fnd_api.g_true
2593: , p_commit => fnd_api.g_false
2594: , p_validation_level => fnd_api.g_valid_level_full
2595: , p_act_metric_fact_rec => l_metric_fact_rec

Line 2921: l_metric_fact_rec ozf_actmetricfact_Pvt.act_metric_fact_rec_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;
2925: l_fund_meaning VARCHAR2(240) := NULL;

Line 3009: ozf_actmetricfact_pvt.init_actmetricfact_rec(l_metric_fact_rec);

3005: END IF;
3006:
3007: FOR fact_rec IN c_get_all_facts LOOP
3008: -- update child fact status as CANCELLED
3009: ozf_actmetricfact_pvt.init_actmetricfact_rec(l_metric_fact_rec);
3010: l_metric_fact_rec.activity_metric_fact_id := fact_rec.activity_metric_fact_id;
3011: l_metric_fact_rec.object_version_number := fact_rec.object_version_number;
3012: l_metric_fact_rec.status_code := 'CANCELLED';
3013: ozf_actmetricfact_Pvt.Update_ActMetricFact( p_api_version => p_api_version

Line 3013: ozf_actmetricfact_Pvt.Update_ActMetricFact( p_api_version => p_api_version

3009: ozf_actmetricfact_pvt.init_actmetricfact_rec(l_metric_fact_rec);
3010: l_metric_fact_rec.activity_metric_fact_id := fact_rec.activity_metric_fact_id;
3011: l_metric_fact_rec.object_version_number := fact_rec.object_version_number;
3012: l_metric_fact_rec.status_code := 'CANCELLED';
3013: ozf_actmetricfact_Pvt.Update_ActMetricFact( p_api_version => p_api_version
3014: , p_init_msg_list => fnd_api.g_true
3015: , p_commit => fnd_api.g_false
3016: , p_validation_level => fnd_api.g_valid_level_full
3017: , p_act_metric_fact_rec => l_metric_fact_rec

Line 3434: l_fact_rec Ozf_Actmetricfact_Pvt.act_metric_fact_rec_type;

3430: l_return_status VARCHAR2(2);
3431: l_notif_subject VARCHAR2(400);
3432: l_notif_body VARCHAR2(4000);
3433: l_return_id NUMBER;
3434: l_fact_rec Ozf_Actmetricfact_Pvt.act_metric_fact_rec_type;
3435: l_fund_type VARCHAR2(30) := NULL;
3436: l_fund_meaning VARCHAR2(240) := NULL;
3437: l_temp_status VARCHAR2(1);
3438:

Line 3487: Ozf_Actmetricfact_Pvt.Init_ActMetricFact_Rec(x_fact_rec => l_fact_rec);

3483: RAISE FND_API.G_EXC_ERROR;
3484: END IF;
3485:
3486: -- update this node allocation status as 'SUBMITTED'
3487: Ozf_Actmetricfact_Pvt.Init_ActMetricFact_Rec(x_fact_rec => l_fact_rec);
3488: l_fact_rec.activity_metric_fact_id := p_fact_id;
3489: l_fact_rec.object_version_number := p_fact_obj_ver;
3490: l_fact_rec.status_code := 'SUBMITTED';
3491: -- update table ozf_act_metric_facts

Line 3492: ozf_actmetricfact_Pvt.update_actmetricfact(

3488: l_fact_rec.activity_metric_fact_id := p_fact_id;
3489: l_fact_rec.object_version_number := p_fact_obj_ver;
3490: l_fact_rec.status_code := 'SUBMITTED';
3491: -- update table ozf_act_metric_facts
3492: ozf_actmetricfact_Pvt.update_actmetricfact(
3493: p_api_version => p_api_version,
3494: p_init_msg_list => fnd_api.g_false,
3495: p_commit => fnd_api.g_false,
3496: p_validation_level => fnd_api.g_valid_level_full,

Line 3626: l_fact_rec Ozf_Actmetricfact_Pvt.act_metric_fact_rec_type;

3622: l_return_status VARCHAR2(2);
3623: l_notif_subject VARCHAR2(400);
3624: l_notif_body VARCHAR2(4000);
3625: l_return_id NUMBER;
3626: l_fact_rec Ozf_Actmetricfact_Pvt.act_metric_fact_rec_type;
3627: l_fund_type VARCHAR2(30) := NULL;
3628: l_fund_meaning VARCHAR2(240) := NULL;
3629: l_temp_status VARCHAR2(1);
3630:

Line 3667: Ozf_Actmetricfact_Pvt.Init_ActMetricFact_Rec(x_fact_rec => l_fact_rec);

3663: CLOSE c_get_fact_info;
3664:
3665: -- do nothing if user rejects an already rejected/active node
3666: IF l_fact_old_status <> 'REJECTED' AND l_fact_old_status <> 'ACTIVE' THEN
3667: Ozf_Actmetricfact_Pvt.Init_ActMetricFact_Rec(x_fact_rec => l_fact_rec);
3668: l_fact_rec.activity_metric_fact_id := p_factid_table(i).fact_id;
3669: l_fact_rec.object_version_number := p_factid_table(i).fact_obj_ver;
3670: l_fact_rec.status_code := 'REJECTED';
3671: -- update table ozf_act_metric_facts

Line 3672: ozf_actmetricfact_Pvt.update_actmetricfact(

3668: l_fact_rec.activity_metric_fact_id := p_factid_table(i).fact_id;
3669: l_fact_rec.object_version_number := p_factid_table(i).fact_obj_ver;
3670: l_fact_rec.status_code := 'REJECTED';
3671: -- update table ozf_act_metric_facts
3672: ozf_actmetricfact_Pvt.update_actmetricfact(
3673: p_api_version => p_api_version,
3674: p_init_msg_list => fnd_api.g_false,
3675: p_commit => fnd_api.g_false,
3676: p_validation_level => fnd_api.g_valid_level_full,