APPS.FLM_KANBAN_PLANNING_UTIL dependencies on FLM_KANBAN_CONFIG_PARAMS

Line 1227: l_start_date := l_end_date - nvl(flm_kanban_config_params.get_demand_range_days(p_org_id),30);

1223: l_start_date Date;
1224: l_range number;
1225: Begin
1226:
1227: l_start_date := l_end_date - nvl(flm_kanban_config_params.get_demand_range_days(p_org_id),30);
1228: l_range := nvl(trunc(l_end_date - l_start_date),0);
1229:
1230: SELECT ( SUM(KANBAN_SIZE) / decode(l_range,0,1,l_range) )
1231: into l_actual_demand

Line 1248: l_start_date := l_end_date - nvl(flm_kanban_config_params.get_lt_range_days(p_org_id),30);

1244: l_end_date Date := sysdate;
1245: l_start_date Date;
1246: Begin
1247:
1248: l_start_date := l_end_date - nvl(flm_kanban_config_params.get_lt_range_days(p_org_id),30);
1249:
1250: SELECT ( SUM(LEAD_TIME) / decode(count(1),0,1,count(1)) )
1251: into l_act_lead_time
1252: FROM FLM_EKB_ACT_SNAPSHOT