DBA Data[Home] [Help]

APPS.OZF_CUST_FACTS_PVT dependencies on OZF_TIME_API_PVT

Line 1228: ozf_time_api_pvt.get_period_name(ent_period_id, 32) period_name,

1224: p_current_year_sales IN NUMBER ) AS
1225:
1226: CURSOR period_name_csr IS
1227: SELECT ent_period_id,
1228: ozf_time_api_pvt.get_period_name(ent_period_id, 32) period_name,
1229: ent_qtr_id,
1230: ozf_time_api_pvt.get_period_name(ent_qtr_id, 64) qtr_name,
1231: ent_year_id,
1232: ozf_time_api_pvt.get_period_name(ent_year_id, 128) year_name

Line 1230: ozf_time_api_pvt.get_period_name(ent_qtr_id, 64) qtr_name,

1226: CURSOR period_name_csr IS
1227: SELECT ent_period_id,
1228: ozf_time_api_pvt.get_period_name(ent_period_id, 32) period_name,
1229: ent_qtr_id,
1230: ozf_time_api_pvt.get_period_name(ent_qtr_id, 64) qtr_name,
1231: ent_year_id,
1232: ozf_time_api_pvt.get_period_name(ent_year_id, 128) year_name
1233: FROM ozf_time_day
1234: WHERE report_date = p_report_date;

Line 1232: ozf_time_api_pvt.get_period_name(ent_year_id, 128) year_name

1228: ozf_time_api_pvt.get_period_name(ent_period_id, 32) period_name,
1229: ent_qtr_id,
1230: ozf_time_api_pvt.get_period_name(ent_qtr_id, 64) qtr_name,
1231: ent_year_id,
1232: ozf_time_api_pvt.get_period_name(ent_year_id, 128) year_name
1233: FROM ozf_time_day
1234: WHERE report_date = p_report_date;
1235:
1236: l_kpi_rec_count NUMBER;