DBA Data[Home] [Help]

APPS.BSC_UPDATE dependencies on BSC_TMP_BIG_IN_COND

Line 6309: FROM BSC_TMP_BIG_IN_COND

6305: FUNCTION Get_Indicator_List(x_number_array IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_number)
6306: RETURN NUMBER IS
6307: CURSOR cIndics is
6308: SELECT value_n
6309: FROM BSC_TMP_BIG_IN_COND
6310: WHERE session_id = -500 and variable_id = -500;
6311: indicator NUMBER;
6312: h_num_items NUMBER;
6313: BEGIN

Line 6323: DELETE BSC_TMP_BIG_IN_COND where session_id = -500 and variable_id = -500;

6319: x_number_array(h_num_items) := indicator;
6320: FETCH cIndics INTO indicator;
6321: END LOOP;
6322: CLOSE cIndics;
6323: DELETE BSC_TMP_BIG_IN_COND where session_id = -500 and variable_id = -500;
6324: RETURN h_num_items;
6325: END Get_Indicator_List;
6326:
6327: