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_METRICS_ALL

Line 308: ozf_act_metrics_all m

304: , 'DD-MM-YYYY'
305: ) derived_end_date
306: */
307: FROM ozf_funds_all_b f,
308: ozf_act_metrics_all m
309: WHERE m.activity_metric_id = p_alloc_id
310: AND m.arc_act_metric_used_by = 'FUND'
311: AND m.act_metric_used_by_id = f.fund_id ;
312:

Line 718: l_fund_id ozf_act_metrics_all.act_metric_used_by_id%TYPE;

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;
722: l_start_node ozf_act_metrics_all.start_node%TYPE;

Line 719: l_alloc_amount ozf_act_metrics_all.func_actual_value%TYPE;

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;
722: l_start_node ozf_act_metrics_all.start_node%TYPE;
723: l_from_level ozf_act_metrics_all.from_level%TYPE;

Line 720: l_hierarchy_id ozf_act_metrics_all.hierarchy_id%TYPE;

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;
722: l_start_node ozf_act_metrics_all.start_node%TYPE;
723: l_from_level ozf_act_metrics_all.from_level%TYPE;
724: l_to_level ozf_act_metrics_all.to_level%TYPE;

Line 721: l_hierarchy_type ozf_act_metrics_all.hierarchy_type%TYPE;

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;
722: l_start_node ozf_act_metrics_all.start_node%TYPE;
723: l_from_level ozf_act_metrics_all.from_level%TYPE;
724: l_to_level ozf_act_metrics_all.to_level%TYPE;
725: l_from_date ozf_act_metrics_all.from_date%TYPE;

Line 722: l_start_node ozf_act_metrics_all.start_node%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;
722: l_start_node ozf_act_metrics_all.start_node%TYPE;
723: l_from_level ozf_act_metrics_all.from_level%TYPE;
724: l_to_level ozf_act_metrics_all.to_level%TYPE;
725: l_from_date ozf_act_metrics_all.from_date%TYPE;
726: l_to_date ozf_act_metrics_all.to_date%TYPE;

Line 723: l_from_level ozf_act_metrics_all.from_level%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;
722: l_start_node ozf_act_metrics_all.start_node%TYPE;
723: l_from_level ozf_act_metrics_all.from_level%TYPE;
724: l_to_level ozf_act_metrics_all.to_level%TYPE;
725: l_from_date ozf_act_metrics_all.from_date%TYPE;
726: l_to_date ozf_act_metrics_all.to_date%TYPE;
727: l_status_code ozf_act_metrics_all.status_code%TYPE;

Line 724: l_to_level ozf_act_metrics_all.to_level%TYPE;

720: l_hierarchy_id ozf_act_metrics_all.hierarchy_id%TYPE;
721: l_hierarchy_type ozf_act_metrics_all.hierarchy_type%TYPE;
722: l_start_node ozf_act_metrics_all.start_node%TYPE;
723: l_from_level ozf_act_metrics_all.from_level%TYPE;
724: l_to_level ozf_act_metrics_all.to_level%TYPE;
725: l_from_date ozf_act_metrics_all.from_date%TYPE;
726: l_to_date ozf_act_metrics_all.to_date%TYPE;
727: l_status_code ozf_act_metrics_all.status_code%TYPE;
728: l_method_code ozf_act_metrics_all.method_code%TYPE;

Line 725: l_from_date ozf_act_metrics_all.from_date%TYPE;

721: l_hierarchy_type ozf_act_metrics_all.hierarchy_type%TYPE;
722: l_start_node ozf_act_metrics_all.start_node%TYPE;
723: l_from_level ozf_act_metrics_all.from_level%TYPE;
724: l_to_level ozf_act_metrics_all.to_level%TYPE;
725: l_from_date ozf_act_metrics_all.from_date%TYPE;
726: l_to_date ozf_act_metrics_all.to_date%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;

Line 726: l_to_date ozf_act_metrics_all.to_date%TYPE;

722: l_start_node ozf_act_metrics_all.start_node%TYPE;
723: l_from_level ozf_act_metrics_all.from_level%TYPE;
724: l_to_level ozf_act_metrics_all.to_level%TYPE;
725: l_from_date ozf_act_metrics_all.from_date%TYPE;
726: l_to_date ozf_act_metrics_all.to_date%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;

Line 727: l_status_code ozf_act_metrics_all.status_code%TYPE;

723: l_from_level ozf_act_metrics_all.from_level%TYPE;
724: l_to_level ozf_act_metrics_all.to_level%TYPE;
725: l_from_date ozf_act_metrics_all.from_date%TYPE;
726: l_to_date ozf_act_metrics_all.to_date%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;

Line 728: l_method_code ozf_act_metrics_all.method_code%TYPE;

724: l_to_level ozf_act_metrics_all.to_level%TYPE;
725: l_from_date ozf_act_metrics_all.from_date%TYPE;
726: l_to_date ozf_act_metrics_all.to_date%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;

Line 729: l_basis_year ozf_act_metrics_all.basis_year%TYPE;

725: l_from_date ozf_act_metrics_all.from_date%TYPE;
726: l_to_date ozf_act_metrics_all.to_date%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:

Line 730: l_ex_start_node ozf_act_metrics_all.ex_start_node%TYPE;

726: l_to_date ozf_act_metrics_all.to_date%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

Line 738: FROM ozf_act_metrics_all

734: CURSOR c_get_alloc_details IS
735: SELECT act_metric_used_by_id, func_actual_value,
736: hierarchy_id, hierarchy_type, start_node, from_level, NVL(to_level, g_max_end_level),
737: from_date, to_date, status_code, method_code, basis_year, ex_start_node
738: FROM ozf_act_metrics_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

Line 1299: -- p_alloc_id allocation id in ozf_act_metrics_all table --

1295: -- update node status as 'ACTIVE' or 'PLANNED' --
1296: -- send notification to child budget owner --
1297: ----------------------------------------------------------------------------------------
1298: ---------------------------------PARAMETERS---------------------------------------------
1299: -- p_alloc_id allocation id in ozf_act_metrics_all table --
1300: -- p_alloc_status new allocation status, either 'PLANNED' or 'ACTIVE' --
1301: ----------------------------------------------------------------------------------------
1302: Procedure publish_allocation(p_api_version IN NUMBER,
1303: p_init_msg_list IN VARCHAR2,

Line 1355: FROM ozf_act_metrics_all

1351: l_fund_meaning VARCHAR2(240) := NULL;
1352:
1353: CURSOR c_get_metric_info IS
1354: SELECT act_metric_used_by_id, from_date, to_date, action_code
1355: FROM ozf_act_metrics_all
1356: WHERE activity_metric_id = p_alloc_id;
1357:
1358: CURSOR c_get_fund_info(p_fund_id NUMBER) IS
1359: SELECT fu.owner, fu.start_date_active, fu.currency_code_tc, fu.fund_type,

Line 1763: FROM ozf_act_metrics_all

1759: x_msg_data OUT NOCOPY VARCHAR2)
1760: IS
1761: CURSOR c_get_alloc_info IS
1762: SELECT from_level
1763: FROM ozf_act_metrics_all
1764: WHERE activity_metric_id = p_alloc_id;
1765:
1766: CURSOR c_get_worksheetfacts IS
1767: SELECT fact.activity_metric_fact_id, fact.object_version_number

Line 2130: -- p_alloc_id allocation id in ozf_act_metrics_all table --

2126: -- since I'm traversing the hierarchy, it's not necessary to do the following check any more:
2127: -- Sum(this node and its sibling's allocation amount) <= --
2128: -- parent allocation amount - holdback amount --
2129: ---------------------------------PARAMETERS---------------------------------------------
2130: -- p_alloc_id allocation id in ozf_act_metrics_all table --
2131: ----------------------------------------------------------------------------------------
2132: Procedure validate_worksheet(p_api_version IN NUMBER,
2133: p_init_msg_list IN VARCHAR2,
2134: p_commit IN VARCHAR2,

Line 2151: FROM ozf_act_metrics_all

2147: l_alloc_status_code VARCHAR2(30);
2148:
2149: CURSOR c_get_alloc_info IS
2150: SELECT act_metric_used_by_id, from_level, status_code
2151: FROM ozf_act_metrics_all
2152: WHERE activity_metric_id = p_alloc_id;
2153:
2154: CURSOR c_get_worksheetfacts IS
2155: SELECT fact.activity_metric_fact_id, fact.hierarchy_id, fact.hierarchy_type

Line 2265: -- p_alloc_id allocation id in ozf_act_metrics_all table --

2261: -- if base percentage is null in table, set base percentage
2262: -- cascade is allowed for recommended amount change only --
2263: ----------------------------------------------------------------------------------------
2264: ---------------------------------PARAMETERS---------------------------------------------
2265: -- p_alloc_id allocation id in ozf_act_metrics_all table --
2266: -- p_fact_table table of fact records to be changed --
2267: -- required fields are: activity_metric_fact_id, object_version_number, --
2268: -- recommend_total_amount, recommend_hb_amount, --
2269: -- node_id, level_depth --

Line 2302: FROM ozf_act_metrics_all

2298: l_new_visited_node_set node_table_type;
2299:
2300: CURSOR c_get_alloc_info IS
2301: SELECT status_code, start_node, func_actual_value, act_metric_used_by_id, action_code
2302: FROM ozf_act_metrics_all
2303: WHERE activity_metric_id = p_alloc_id;
2304:
2305: CURSOR c_get_fund_info(l_fact_id IN NUMBER) IS
2306: SELECT fund_id, object_version_number

Line 2706: -- p_alloc_id allocation id in ozf_act_metrics_all table --

2702: -- and create active budget transfer record from root to top level --
2703: -- send notification to child budget owner --
2704: ----------------------------------------------------------------------------------------
2705: ---------------------------------PARAMETERS---------------------------------------------
2706: -- p_alloc_id allocation id in ozf_act_metrics_all table --
2707: ----------------------------------------------------------------------------------------
2708: Procedure activate_allocation(p_api_version IN NUMBER := 1.0,
2709: p_alloc_id IN NUMBER,
2710: p_alloc_obj_ver IN NUMBER,

Line 2733: l_ex_start_node ozf_act_metrics_all.ex_start_node%TYPE;

2729: l_notif_body VARCHAR2(4000);
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

Line 2738: FROM ozf_act_metrics_all

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
2739: WHERE activity_metric_id = p_alloc_id;
2740:
2741: CURSOR c_get_fund_info(p_fund_id NUMBER) IS
2742: SELECT fu.status_code, fu.fund_type

Line 2900: -- p_alloc_id allocation id in ozf_act_metrics_all table --

2896: -- if already published, notify child budget owners of cancellation --
2897: -- if CREATE_NEW_BUDGET, mark all children budget as CANCELLED --
2898: ----------------------------------------------------------------------------------------
2899: ---------------------------------PARAMETERS---------------------------------------------
2900: -- p_alloc_id allocation id in ozf_act_metrics_all table --
2901: ----------------------------------------------------------------------------------------
2902: Procedure cancel_allocation(p_api_version IN NUMBER := 1.0,
2903: p_alloc_id IN NUMBER,
2904: p_alloc_obj_ver IN NUMBER,

Line 2930: FROM ozf_act_metrics_all

2926: l_temp_status VARCHAR2(1);
2927:
2928: CURSOR c_get_metric_info IS
2929: SELECT created_by, status_code, action_code, act_metric_used_by_id
2930: FROM ozf_act_metrics_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

Line 3135: FROM ozf_act_metrics_all

3131: l_valid_change BOOLEAN;
3132:
3133: CURSOR c_get_alloc_status IS
3134: SELECT status_code
3135: FROM ozf_act_metrics_all
3136: WHERE activity_metric_id = p_alloc_id;
3137: BEGIN
3138: SAVEPOINT update_alloc_status_sp;
3139: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3258: FROM ozf_act_metrics_all

3254: l_request_hb NUMBER;
3255:
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:

Line 3458: FROM ozf_act_metrics_all

3454: CURSOR c_get_alloc_budget_owner(p_lalloc_id NUMBER) IS
3455: SELECT owner, currency_code_tc
3456: FROM ozf_funds_all_b
3457: WHERE fund_id = (SELECT act_metric_used_by_id
3458: FROM ozf_act_metrics_all
3459: WHERE activity_metric_id = p_lalloc_id
3460: AND arc_act_metric_used_by = 'FUND');
3461:
3462: BEGIN