APPS.BNE_DUPLICATES_UTILS dependencies on BNE_INTERFACE_KEY_COLS

Line 195: FROM BNE_INTERFACE_KEY_COLS

191: BEGIN
192: l_interface_col_seq_num := GET_INTERFACE_COL(p_application_id, p_interface_code, p_interface_col_name);
193:
194: SELECT NVL((MAX(SEQUENCE_NUM) + 1), 1) INTO l_sequence_num
195: FROM BNE_INTERFACE_KEY_COLS
196: WHERE INTERFACE_APP_ID = p_application_id
197: AND INTERFACE_CODE = p_interface_code;
198:
199: BNE_INTERFACE_KEY_COLS_PKG.INSERT_ROW(

Line 199: BNE_INTERFACE_KEY_COLS_PKG.INSERT_ROW(

195: FROM BNE_INTERFACE_KEY_COLS
196: WHERE INTERFACE_APP_ID = p_application_id
197: AND INTERFACE_CODE = p_interface_code;
198:
199: BNE_INTERFACE_KEY_COLS_PKG.INSERT_ROW(
200: X_ROWID => l_rowid,
201: X_APPLICATION_ID => p_application_id,
202: X_KEY_CODE => p_interface_code||'_U1',
203: X_SEQUENCE_NUM => l_sequence_num,

Line 442: DELETE FROM BNE_INTERFACE_KEY_COLS

438: IS
439: BEGIN
440: VALIDATE_INTERFACE_KEY(p_interface_app_id, p_interface_code);
441:
442: DELETE FROM BNE_INTERFACE_KEY_COLS
443: WHERE INTERFACE_APP_ID = p_interface_app_id
444: AND INTERFACE_CODE = p_interface_code;
445:
446: DELETE FROM BNE_INTERFACE_KEYS