APPS.BSC_MO_DB_PKG dependencies on BSC_TMP_BIG_IN_COND

Line 90: SELECT value_v, value_n order_index FROM BSC_TMP_BIG_IN_COND

86: wasAdded boolean ;
87: l_data_cols BSC_METADATA_OPTIMIZER_PKG.tab_clsDataField;
88: l_col BSC_METADATA_OPTIMIZER_PKG.clsDataField;
89: CURSOR cOrdered IS
90: SELECT value_v, value_n order_index FROM BSC_TMP_BIG_IN_COND
91: WHERE variable_id=10
92: AND session_id=USERENV('SESSIONID')
93: ORDER BY value_v;
94: l_dummy VARCHAR2(100);

Line 101: DELETE BSC_TMP_BIG_IN_COND WHERE variable_id = 10 AND session_id=USERENV('SESSIONID');

97: BEGIN
98: IF (p_data.count=0) THEN
99: return;
100: END IF;
101: DELETE BSC_TMP_BIG_IN_COND WHERE variable_id = 10 AND session_id=USERENV('SESSIONID');
102: l_ins := 'INSERT INTO BSC_TMP_BIG_IN_COND(variable_id, value_v, value_n, session_id) values (:1, :2, :3, :4)';
103: for i in p_data.first..p_data.last loop
104: execute immediate l_ins USING 10, upper(p_data(i).fieldName), i, USERENV('SESSIONID');
105: end loop;

Line 102: l_ins := 'INSERT INTO BSC_TMP_BIG_IN_COND(variable_id, value_v, value_n, session_id) values (:1, :2, :3, :4)';

98: IF (p_data.count=0) THEN
99: return;
100: END IF;
101: DELETE BSC_TMP_BIG_IN_COND WHERE variable_id = 10 AND session_id=USERENV('SESSIONID');
102: l_ins := 'INSERT INTO BSC_TMP_BIG_IN_COND(variable_id, value_v, value_n, session_id) values (:1, :2, :3, :4)';
103: for i in p_data.first..p_data.last loop
104: execute immediate l_ins USING 10, upper(p_data(i).fieldName), i, USERENV('SESSIONID');
105: end loop;
106: for i in cOrdered loop