APPS.OZF_QUOTA_ALLOCATIONS_PVT dependencies on OZF_ACT_METRICS_ALL

Line 317: SELECT start_period_name, end_period_name, product_spread_time_id FROM ozf_act_metrics_all

313: l_fact_id c_fact_id%rowtype;
314:
315: CURSOR C_extra_fields (p_alloc_id NUMBER)
316: IS
317: SELECT start_period_name, end_period_name, product_spread_time_id FROM ozf_act_metrics_all
318: WHERE activity_metric_id = p_alloc_id;
319:
320: l_start_period_name VARCHAR2(30);
321: l_end_period_name VARCHAR2(30);

Line 480: SELECT status_code,object_version_number FROM ozf_act_metrics_all

476: SELECT activity_metric_fact_id , activity_metric_id FROM ozf_act_metric_facts_all
477: WHERE activity_metric_id = p_alloc_id;
478:
479: CURSOR c_alloc_dtls(p_alloc_id NUMBER) IS
480: SELECT status_code,object_version_number FROM ozf_act_metrics_all
481: WHERE activity_metric_id = p_alloc_id;
482:
483: l_alloc_dtls c_alloc_dtls%rowtype;
484: l_facts c_facts%rowtype;

Line 644: from ozf_act_metrics_all

640: l_api_name CONSTANT VARCHAR2(30) := 'cancel_alloc_hfq';
641:
642: CURSOR c_alloc_header_ids(p_quota_id NUMBER) IS
643: select activity_metric_id
644: from ozf_act_metrics_all
645: where arc_act_metric_used_by = 'FUND'
646: and act_metric_used_by_id = p_quota_id;
647:
648: CURSOR c_alloc_metric_used_by_id(p_alloc_id NUMBER) IS

Line 669: update ozf_act_metrics_all

665: SAVEPOINT cancel_alloc_hfq_sp;
666: x_return_status := FND_API.G_RET_STS_SUCCESS;
667:
668: --Get all the allocation header records for the fund_id and update the status_code to CANCELLED
669: update ozf_act_metrics_all
670: set status_code = 'CANCELLED'
671: where arc_act_metric_used_by = 'FUND'
672: and act_metric_used_by_id = p_quota_id;
673: