APPS.BNE_DUPLICATES_UTILS dependencies on BNE_DUP_INTERFACE_COLS

Line 340: FROM BNE_DUP_INTERFACE_COLS

336: l_interface_col_seq_num := GET_INTERFACE_COL(p_interface_app_id, p_interface_code, p_interface_col_name);
337:
338: BEGIN
339: SELECT OBJECT_VERSION_NUMBER INTO l_object_version_number
340: FROM BNE_DUP_INTERFACE_COLS
341: WHERE INTERFACE_APP_ID = p_interface_app_id
342: AND INTERFACE_CODE = p_interface_code
343: AND DUP_PROFILE_APP_ID = p_dup_profile_app_id
344: AND DUP_PROFILE_CODE = p_dup_profile_code

Line 354: BNE_DUP_INTERFACE_COLS_PKG.UPDATE_ROW(

350: END IF;
351: END;
352:
353: IF l_object_version_number > 0 THEN
354: BNE_DUP_INTERFACE_COLS_PKG.UPDATE_ROW(
355: X_INTERFACE_APP_ID => p_interface_app_id,
356: X_INTERFACE_CODE => p_interface_code,
357: X_DUP_PROFILE_APP_ID => p_dup_profile_app_id,
358: X_DUP_PROFILE_CODE => p_dup_profile_code,

Line 366: BNE_DUP_INTERFACE_COLS_PKG.INSERT_ROW(

362: X_LAST_UPDATED_BY => p_user_id,
363: X_LAST_UPDATE_LOGIN => 0,
364: X_LAST_UPDATE_DATE => SYSDATE);
365: ELSE
366: BNE_DUP_INTERFACE_COLS_PKG.INSERT_ROW(
367: X_ROWID => l_rowid,
368: X_INTERFACE_APP_ID => p_interface_app_id,
369: X_INTERFACE_CODE => p_interface_code,
370: X_DUP_PROFILE_APP_ID => p_dup_profile_app_id,

Line 407: DELETE FROM BNE_DUP_INTERFACE_COLS

403: IS
404: BEGIN
405: VALIDATE_DUP_PROFILE_KEY(p_dup_profile_app_id, p_dup_profile_code);
406:
407: DELETE FROM BNE_DUP_INTERFACE_COLS
408: WHERE DUP_PROFILE_APP_ID = p_dup_profile_app_id
409: AND DUP_PROFILE_CODE = p_dup_profile_code;
410:
411: DELETE FROM BNE_DUP_INTERFACE_PROFILES