APPS.OZF_QUOTA_ALLOCATIONS_PVT dependencies on OZF_ACT_METRIC_FACTS_ALL

Line 139: --l_fact_id ozf_act_metric_facts_all.activity_metric_fact_id%type;

135: )
136: IS
137: l_api_version CONSTANT NUMBER := 1.0;
138: l_api_name CONSTANT VARCHAR2(30) := 'generate_product_spread';
139: --l_fact_id ozf_act_metric_facts_all.activity_metric_fact_id%type;
140:
141: CURSOR c_fact_id (p_alloc_id NUMBER)IS
142: SELECT activity_metric_fact_id , activity_metric_id FROM ozf_act_metric_facts_all
143: WHERE activity_metric_id = p_alloc_id;

Line 142: SELECT activity_metric_fact_id , activity_metric_id FROM ozf_act_metric_facts_all

138: l_api_name CONSTANT VARCHAR2(30) := 'generate_product_spread';
139: --l_fact_id ozf_act_metric_facts_all.activity_metric_fact_id%type;
140:
141: CURSOR c_fact_id (p_alloc_id NUMBER)IS
142: SELECT activity_metric_fact_id , activity_metric_id FROM ozf_act_metric_facts_all
143: WHERE activity_metric_id = p_alloc_id;
144:
145: l_fact_id c_fact_id%rowtype;
146: BEGIN

Line 311: SELECT activity_metric_fact_id , act_metric_used_by_id FROM ozf_act_metric_facts_all

307: IS
308: l_api_version CONSTANT NUMBER := 1.0;
309: l_api_name CONSTANT VARCHAR2(30) := 'allocate_target';
310: CURSOR c_fact_id (p_alloc_id NUMBER)IS
311: SELECT activity_metric_fact_id , act_metric_used_by_id FROM ozf_act_metric_facts_all
312: WHERE activity_metric_id = p_alloc_id;
313: l_fact_id c_fact_id%rowtype;
314:
315: CURSOR C_extra_fields (p_alloc_id NUMBER)

Line 371: SELECT activity_metric_fact_id , act_metric_used_by_id FROM ozf_act_metric_facts_all

367: l_api_version CONSTANT NUMBER := 1.0;
368: l_api_name CONSTANT VARCHAR2(30) := 'allocate_target';
369:
370: CURSOR c_fact_id (p_alloc_id NUMBER)IS
371: SELECT activity_metric_fact_id , act_metric_used_by_id FROM ozf_act_metric_facts_all
372: WHERE activity_metric_id = p_alloc_id;
373:
374: --Added by kvattiku Mar 15, 04
375: --Will be used to ensure that the ozf_allocation_engine_pvt.allocate_target is called only for leaf quota nodes

Line 476: SELECT activity_metric_fact_id , activity_metric_id FROM ozf_act_metric_facts_all

472: l_api_name CONSTANT VARCHAR2(30) := 'publish_allocation';
473: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
474:
475: CURSOR c_facts (p_alloc_id NUMBER) IS
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

Line 650: from ozf_act_metric_facts_all

646: and act_metric_used_by_id = p_quota_id;
647:
648: CURSOR c_alloc_metric_used_by_id(p_alloc_id NUMBER) IS
649: select act_metric_used_by_id
650: from ozf_act_metric_facts_all
651: where arc_act_metric_used_by = 'FUND'
652: and activity_metric_id = p_alloc_id;
653:
654: CURSOR c_user_status_id IS

Line 682: update ozf_act_metric_facts_all

678: for l_alloc_id in c_alloc_header_ids(p_quota_id)
679: loop
680:
681: --Get all the allocation fact records for a given allocation id and update their status_code to cancelled
682: update ozf_act_metric_facts_all
683: set status_code = 'CANCELLED'
684: where arc_act_metric_used_by = 'FUND'
685: and activity_metric_id = l_alloc_id.activity_metric_id;
686:

Line 699: select act_metric_used_by_id from ozf_act_metric_facts_all

695: set status_code = 'CANCELLED',
696: user_status_id = l_user_status_id
697: where fund_id in
698: (
699: select act_metric_used_by_id from ozf_act_metric_facts_all
700: where arc_act_metric_used_by = 'FUND'
701: and activity_metric_id = l_alloc_id.activity_metric_id
702: );
703: