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_ACT_METRIC_FACTS_ALL

Line 731: l_fact_id ozf_act_metric_facts_all.activity_metric_fact_id%TYPE;

727: l_status_code ozf_act_metrics_all.status_code%TYPE;
728: l_method_code ozf_act_metrics_all.method_code%TYPE;
729: l_basis_year ozf_act_metrics_all.basis_year%TYPE;
730: l_ex_start_node ozf_act_metrics_all.ex_start_node%TYPE;
731: l_fact_id ozf_act_metric_facts_all.activity_metric_fact_id%TYPE;
732: l_worksheet_tbl worksheet_table_type;
733:
734: CURSOR c_get_alloc_details IS
735: SELECT act_metric_used_by_id, func_actual_value,

Line 743: FROM ozf_act_metric_facts_all

739: WHERE activity_metric_id = p_alloc_id;
740:
741: CURSOR c_get_parent_fact_id(p_node_id NUMBER, p_level_depth NUMBER) IS
742: SELECT activity_metric_fact_id
743: FROM ozf_act_metric_facts_all
744: WHERE activity_metric_id = p_alloc_id
745: AND node_id = p_node_id
746: AND level_depth = p_level_depth;
747:

Line 1379: FROM ozf_act_metric_facts_all

1375: CURSOR c_get_worksheet_info(p_fund_id NUMBER) IS
1376: SELECT activity_metric_fact_id, object_version_number,
1377: hierarchy_id, hierarchy_type, level_depth, node_id, previous_fact_id,
1378: recommend_total_amount, recommend_hb_amount, fact_type
1379: FROM ozf_act_metric_facts_all
1380: WHERE act_metric_used_by_id = p_fund_id
1381: AND arc_act_metric_used_by = 'FUND'
1382: AND activity_metric_id = p_alloc_id
1383: AND status_code = 'NEW'

Line 1771: FROM ozf_act_metric_facts_all fact

1767: SELECT fact.activity_metric_fact_id, fact.object_version_number
1768: , fact.level_depth, fact.previous_fact_id
1769: , fact.recommend_total_amount, fact.recommend_hb_amount
1770: , fact.base_total_pct, fact.base_hb_pct
1771: FROM ozf_act_metric_facts_all fact
1772: WHERE fact.activity_metric_id = p_alloc_id
1773: ORDER BY fact.level_depth asc;
1774:
1775: CURSOR c_get_alloc_down(p_parent_fact_id NUMBER) IS

Line 1777: FROM ozf_act_metric_facts_all

1773: ORDER BY fact.level_depth asc;
1774:
1775: CURSOR c_get_alloc_down(p_parent_fact_id NUMBER) IS
1776: SELECT recommend_total_amount - NVL(recommend_hb_amount, 0)
1777: FROM ozf_act_metric_facts_all
1778: WHERE activity_metric_fact_id = p_parent_fact_id;
1779:
1780: l_alloc_from_level NUMBER;
1781: l_parent_alloc_down NUMBER;

Line 1956: FROM ozf_act_metric_facts_all

1952:
1953: CURSOR c_get_subtree_root IS
1954: SELECT previous_fact_id, recommend_total_amount, recommend_hb_amount,
1955: act_metric_used_by_id
1956: FROM ozf_act_metric_facts_all
1957: WHERE activity_metric_fact_id = p_start_fact_id;
1958:
1959: -- get allocation amount summary of this node's children
1960: CURSOR c_get_child_sum(p_parent_fact_id NUMBER) IS

Line 1964: FROM ozf_act_metric_facts_all fact

1960: CURSOR c_get_child_sum(p_parent_fact_id NUMBER) IS
1961: --01/19/2004 kdass fixed bug 3371034
1962: --SELECT SUM(NVL(recommend_total_amount, 0))
1963: SELECT TRUNC(SUM(NVL(recommend_total_amount, 0)))
1964: FROM ozf_act_metric_facts_all fact
1965: WHERE activity_metric_id = p_alloc_id
1966: AND previous_fact_id = p_parent_fact_id;
1967:
1968: CURSOR c_get_node_info(p_fact_id NUMBER) IS

Line 1970: FROM ozf_act_metric_facts_all fact

1966: AND previous_fact_id = p_parent_fact_id;
1967:
1968: CURSOR c_get_node_info(p_fact_id NUMBER) IS
1969: SELECT hierarchy_id, hierarchy_type, node_id
1970: FROM ozf_act_metric_facts_all fact
1971: WHERE activity_metric_fact_id = p_fact_id;
1972:
1973: CURSOR c_get_subtree_worksheet IS
1974: SELECT activity_metric_fact_id, object_version_number,

Line 1977: FROM ozf_act_metric_facts_all

1973: CURSOR c_get_subtree_worksheet IS
1974: SELECT activity_metric_fact_id, object_version_number,
1975: previous_fact_id, recommend_total_amount, recommend_hb_amount,
1976: base_total_pct, base_hb_pct
1977: FROM ozf_act_metric_facts_all
1978: CONNECT BY prior activity_metric_fact_id = previous_fact_id
1979: START WITH previous_fact_id = p_start_fact_id
1980: ORDER BY level_depth;
1981:

Line 1984: FROM ozf_act_metric_facts_all

1980: ORDER BY level_depth;
1981:
1982: CURSOR c_get_allocdown_amount(p_fact_id NUMBER) IS
1983: SELECT recommend_total_amount - NVL(recommend_hb_amount, 0)
1984: FROM ozf_act_metric_facts_all
1985: WHERE activity_metric_fact_id = p_fact_id;
1986:
1987: CURSOR c_get_fund_info(l_fact_id IN NUMBER) IS
1988: SELECT fund_id, object_version_number

Line 1991: FROM ozf_act_metric_facts_all

1987: CURSOR c_get_fund_info(l_fact_id IN NUMBER) IS
1988: SELECT fund_id, object_version_number
1989: FROM ozf_funds_all_b
1990: WHERE fund_id = (SELECT act_metric_used_by_id
1991: FROM ozf_act_metric_facts_all
1992: WHERE activity_metric_fact_id = l_fact_id);
1993:
1994: BEGIN
1995: x_return_status := fnd_api.g_ret_sts_success;

Line 2158: FROM ozf_act_metric_facts_all fact

2154: CURSOR c_get_worksheetfacts IS
2155: SELECT fact.activity_metric_fact_id, fact.hierarchy_id, fact.hierarchy_type
2156: , fact.node_id, fact.level_depth
2157: , fact.recommend_total_amount, fact.recommend_hb_amount
2158: FROM ozf_act_metric_facts_all fact
2159: WHERE fact.activity_metric_id = p_alloc_id
2160: ORDER BY fact.level_depth, fact.node_id asc;
2161:
2162: -- get allocation amount summary of this node's children

Line 2167: FROM ozf_act_metric_facts_all fact

2163: CURSOR c_get_child_sum(p_parent_fact_id NUMBER) IS
2164: --01/19/2004 kdass fixed bug 3371034
2165: --SELECT SUM(NVL(recommend_total_amount, 0))
2166: SELECT TRUNC(SUM(NVL(recommend_total_amount, 0)))
2167: FROM ozf_act_metric_facts_all fact
2168: WHERE activity_metric_id = p_alloc_id
2169: AND previous_fact_id = p_parent_fact_id;
2170:
2171: BEGIN

Line 2309: FROM ozf_act_metric_facts_all

2305: CURSOR c_get_fund_info(l_fact_id IN NUMBER) IS
2306: SELECT fund_id, object_version_number
2307: FROM ozf_funds_all_b
2308: WHERE fund_id = (SELECT act_metric_used_by_id
2309: FROM ozf_act_metric_facts_all
2310: WHERE activity_metric_fact_id = l_fact_id);
2311: BEGIN
2312: SAVEPOINT update_worksheet_amount_sp;
2313:

Line 2576: FROM ozf_funds_all_vl fund, ozf_act_metric_facts_all fact

2572:
2573: CURSOR c_get_child_info IS
2574: SELECT fund.fund_id, fund.object_version_number, fund.owner, fund.short_name, fund.currency_code_tc
2575: , fact.request_total_amount, fund.fund_type
2576: FROM ozf_funds_all_vl fund, ozf_act_metric_facts_all fact
2577: WHERE fund.fund_id = fact.act_metric_used_by_id
2578: AND fact.activity_metric_fact_id = p_child_fact_id
2579: AND fact.arc_act_metric_used_by = 'FUND';
2580:

Line 2749: FROM ozf_act_metric_facts_all m

2745:
2746: CURSOR c_get_alloc_topnode IS
2747: SELECT m.activity_metric_fact_id, m.object_version_number
2748: , m.recommend_total_amount, m.recommend_hb_amount
2749: FROM ozf_act_metric_facts_all m
2750: WHERE activity_metric_id = p_alloc_id
2751: AND previous_fact_id IS NULL;
2752:
2753: CURSOR c_get_alloc_toplevels(p_previous_fact_id IN NUMBER) IS

Line 2756: FROM ozf_act_metric_facts_all m

2752:
2753: CURSOR c_get_alloc_toplevels(p_previous_fact_id IN NUMBER) IS
2754: SELECT m.activity_metric_fact_id, m.object_version_number
2755: , m.recommend_total_amount, m.recommend_hb_amount
2756: FROM ozf_act_metric_facts_all m
2757: WHERE activity_metric_id = p_alloc_id
2758: AND previous_fact_id = p_previous_fact_id;
2759:
2760: BEGIN

Line 2935: FROM ozf_act_metric_facts_all

2931: WHERE activity_metric_id = p_alloc_id;
2932:
2933: CURSOR c_get_all_facts IS
2934: SELECT activity_metric_fact_id, object_version_number, act_metric_used_by_id
2935: FROM ozf_act_metric_facts_all
2936: WHERE activity_metric_id = p_alloc_id;
2937:
2938: CURSOR c_get_fund_info(p_fund_id NUMBER) IS
2939: SELECT object_version_number, owner, short_name, fund_type

Line 3260: FROM ozf_act_metric_facts_all

3256: CURSOR c_get_alloc_status(p_fact_id NUMBER) IS
3257: SELECT status_code, action_code, activity_metric_id
3258: FROM ozf_act_metrics_all
3259: WHERE activity_metric_id = (SELECT activity_metric_id
3260: FROM ozf_act_metric_facts_all
3261: WHERE activity_metric_fact_id = p_fact_id);
3262:
3263: CURSOR c_get_fact_status(p_fact_id NUMBER) IS
3264: SELECT status_code

Line 3265: FROM ozf_act_metric_facts_all

3261: WHERE activity_metric_fact_id = p_fact_id);
3262:
3263: CURSOR c_get_fact_status(p_fact_id NUMBER) IS
3264: SELECT status_code
3265: FROM ozf_act_metric_facts_all
3266: WHERE activity_metric_fact_id = p_fact_id;
3267:
3268: CURSOR c_get_one_level(p_fact_id NUMBER) IS
3269: SELECT status_code, act_metric_used_by_id, previous_fact_id

Line 3272: FROM ozf_act_metric_facts_all

3268: CURSOR c_get_one_level(p_fact_id NUMBER) IS
3269: SELECT status_code, act_metric_used_by_id, previous_fact_id
3270: , recommend_total_amount, recommend_hb_amount
3271: , request_total_amount, request_hb_amount
3272: FROM ozf_act_metric_facts_all
3273: WHERE activity_metric_fact_id = p_fact_id
3274: AND previous_fact_id = p_approver_factid; -- to guarantee it approves next level only
3275:
3276: CURSOR c_get_all_levels(p_fact_id NUMBER) IS

Line 3281: FROM ozf_act_metric_facts_all

3277: SELECT activity_metric_fact_id, object_version_number
3278: , status_code, act_metric_used_by_id, previous_fact_id
3279: , recommend_total_amount, recommend_hb_amount
3280: , request_total_amount, request_hb_amount
3281: FROM ozf_act_metric_facts_all
3282: CONNECT BY prior activity_metric_fact_id = previous_fact_id
3283: START WITH previous_fact_id = p_fact_id
3284: ORDER BY level_depth;
3285:

Line 3442: FROM ozf_act_metric_facts_all fact, ozf_funds_all_vl fund

3438:
3439: CURSOR c_get_fact_info IS
3440: SELECT fact.status_code, fact.previous_fact_id, fact.activity_metric_id
3441: , fact.request_total_amount, fact.request_hb_amount, fund.short_name, fund.fund_type
3442: FROM ozf_act_metric_facts_all fact, ozf_funds_all_vl fund
3443: WHERE fact.activity_metric_fact_id = p_fact_id
3444: AND fact.act_metric_used_by_id = fund.fund_id;
3445:
3446: CURSOR c_get_fact_budget_owner(p_lfact_id NUMBER) IS

Line 3450: FROM ozf_act_metric_facts_all

3446: CURSOR c_get_fact_budget_owner(p_lfact_id NUMBER) IS
3447: SELECT owner, currency_code_tc
3448: FROM ozf_funds_all_b
3449: WHERE fund_id = (SELECT act_metric_used_by_id
3450: FROM ozf_act_metric_facts_all
3451: WHERE activity_metric_fact_id = p_lfact_id
3452: AND arc_act_metric_used_by = 'FUND');
3453:
3454: CURSOR c_get_alloc_budget_owner(p_lalloc_id NUMBER) IS

Line 3635: FROM ozf_act_metric_facts_all fact, ozf_funds_all_vl fund

3631: CURSOR c_get_fact_info(p_fact_id NUMBER) IS
3632: SELECT fund.owner, fund.short_name, fund.currency_code_tc
3633: , fact.status_code, fact.request_total_amount, fact.request_hb_amount
3634: , fact.activity_metric_id, fund.fund_type
3635: FROM ozf_act_metric_facts_all fact, ozf_funds_all_vl fund
3636: WHERE fact.activity_metric_fact_id = p_fact_id
3637: AND fact.arc_act_metric_used_by = 'FUND'
3638: AND fact.act_metric_used_by_id = fund.fund_id;
3639: