83: )
84: IS
85: CURSOR c_shared_obj(p_indicator NUMBER) IS
86: SELECT indicator
87: FROM bsc_kpis_b
88: WHERE source_indicator = p_indicator
89: AND share_flag = 2 -- shared objective.
90: AND prototype_flag <> 2;
91:
195: )
196: IS
197: CURSOR c_shared_obj(p_indicator NUMBER) IS
198: SELECT indicator
199: FROM bsc_kpis_b
200: WHERE source_indicator = p_indicator
201: AND share_flag = 2 -- shared objective.
202: AND prototype_flag <> 2;
203:
203:
204: l_kpi_measure_rec BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec;
205: l_kpi_measure_id NUMBER;
206: l_short_name VARCHAR2(30);
207: l_config_type BSC_KPIS_B.CONFIG_TYPE%TYPE;
208: BEGIN
209:
210: FND_MSG_PUB.Initialize;
211: x_return_status := FND_API.G_RET_STS_SUCCESS;
228: l_kpi_measure_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
229:
230: BEGIN
231: SELECT short_name,config_type into l_short_name,l_config_type
232: FROM bsc_kpis_b
233: WHERE indicator = p_objective_id;
234: EXCEPTION
235: WHEN OTHERS THEN
236: l_short_name := NULL;
334: )
335: IS
336: CURSOR c_shared_obj(p_indicator NUMBER) IS
337: SELECT indicator
338: FROM bsc_kpis_b
339: WHERE source_indicator = p_indicator
340: AND share_flag = 2 -- shared objective.
341: AND prototype_flag <> 2;
342:
445: )
446: IS
447: CURSOR c_shared_obj(p_indicator NUMBER) IS
448: SELECT indicator
449: FROM bsc_kpis_b
450: WHERE source_indicator = p_indicator
451: AND share_flag = 2 -- shared objective.
452: AND prototype_flag <> 2;
453:
554: )
555: IS
556: CURSOR c_shared_obj(p_indicator NUMBER) IS
557: SELECT indicator
558: FROM bsc_kpis_b
559: WHERE source_indicator = p_indicator
560: AND share_flag = 2 -- shared objective.
561: AND prototype_flag <> 2;
562: