APPS.OZF_CUST_FACTS_PVT dependencies on OZF_DASHB_DAILY_KPI

Line 1261: DELETE FROM ozf_dashb_daily_kpi

1257: ozf_utility_pvt.write_conc_log('Private API: ' || 'Insert_Kpi' || ' (-)') ;
1258:
1259: -- inanaiah: bug 4912723 - commented as deletion happens in refresh_kpi_info
1260: /*
1261: DELETE FROM ozf_dashb_daily_kpi
1262: WHERE report_date = p_report_date
1263: AND resource_id = p_resource_id;
1264: */
1265:

Line 1380: INSERT INTO ozf_dashb_daily_kpi(

1376: l_time_id := l_ent_year_id;
1377: --
1378: END IF;
1379:
1380: INSERT INTO ozf_dashb_daily_kpi(
1381: dashb_daily_kpi_id,
1382: report_date,
1383: resource_id,
1384: period_type_id,

Line 1389: VALUES (ozf_dashb_daily_kpi_s.nextval,

1385: time_id,
1386: sequence_number,
1387: kpi_name,
1388: kpi_value )
1389: VALUES (ozf_dashb_daily_kpi_s.nextval,
1390: p_report_date,
1391: p_resource_id,
1392: l_period_type_id,
1393: l_time_id,

Line 1606: -- will exist in ozf_dashb_daily_kpi and thus get populated into OZF_RES_CUST_PROD_FACTS.

1602: l_current_year_time_id;
1603: CLOSE period_time_id_csr;
1604:
1605: -- inanaiah: bug 4912723 - delete all the records otherwise target info for cancelled quotas
1606: -- will exist in ozf_dashb_daily_kpi and thus get populated into OZF_RES_CUST_PROD_FACTS.
1607: -- Removed the deletion based on report_date and resource_id in insert_kpi proc.
1608: DELETE FROM ozf_dashb_daily_kpi
1609: WHERE report_date = p_report_date;
1610:

Line 1608: DELETE FROM ozf_dashb_daily_kpi

1604:
1605: -- inanaiah: bug 4912723 - delete all the records otherwise target info for cancelled quotas
1606: -- will exist in ozf_dashb_daily_kpi and thus get populated into OZF_RES_CUST_PROD_FACTS.
1607: -- Removed the deletion based on report_date and resource_id in insert_kpi proc.
1608: DELETE FROM ozf_dashb_daily_kpi
1609: WHERE report_date = p_report_date;
1610:
1611: -- Process KPI for each resource
1612: FOR res IN active_resources_csr

Line 2320: ozf_dashb_daily_kpi kpi,

2316: -1 LAST_UPDATED_BY,
2317: -1 LAST_UPDATE_LOGIN
2318: FROM ozf_cust_daily_facts c,
2319: hz_cust_accounts x,
2320: ozf_dashb_daily_kpi kpi,
2321: (SELECT DISTINCT a.owner
2322: FROM ozf_funds_all_b a
2323: WHERE a.fund_type = 'QUOTA'
2324: AND a.status_code <> 'CANCELLED') fund

Line 2421: ozf_dashb_daily_kpi kpi,

2417: -1 LAST_UPDATED_BY,
2418: -1 LAST_UPDATE_LOGIN
2419: FROM ozf_cust_daily_facts c,
2420: hz_cust_accounts x,
2421: ozf_dashb_daily_kpi kpi,
2422: (SELECT DISTINCT a.owner
2423: FROM ozf_funds_all_b a
2424: WHERE a.fund_type = 'QUOTA'
2425: AND a.status_code <> 'CANCELLED') fund

Line 2522: ozf_dashb_daily_kpi kpi,

2518: -1 LAST_UPDATED_BY,
2519: -1 LAST_UPDATE_LOGIN
2520: FROM ozf_cust_daily_facts c,
2521: hz_cust_accounts x,
2522: ozf_dashb_daily_kpi kpi,
2523: (SELECT DISTINCT a.owner
2524: FROM ozf_funds_all_b a
2525: WHERE a.fund_type = 'QUOTA'
2526: AND a.status_code <> 'CANCELLED') fund

Line 2623: ozf_dashb_daily_kpi kpi,

2619: sysdate LAST_UPDATE_DATE,
2620: -1 LAST_UPDATED_BY,
2621: -1 LAST_UPDATE_LOGIN
2622: FROM ozf_cust_daily_facts c ,
2623: ozf_dashb_daily_kpi kpi,
2624: (SELECT DISTINCT a.owner
2625: FROM ozf_funds_all_b a
2626: WHERE a.fund_type = 'QUOTA'
2627: AND a.status_code <> 'CANCELLED') fund