APPS.FEM_WEBADI_MEMBER_UTILS_PVT dependencies on BNE_INTERFACES_B

Line 2483: FROM BNE_INTERFACES_B

2479:
2480: BEGIN
2481: SELECT 'Y'
2482: INTO l_existed_flag
2483: FROM BNE_INTERFACES_B
2484: WHERE APPLICATION_ID = 274
2485: AND INTERFACE_CODE = l_interface_code;
2486: EXCEPTION
2487: WHEN NO_DATA_FOUND THEN NULL;

Line 2496: FROM BNE_INTERFACES_B

2492: IF (l_existed_flag IS NULL) THEN
2493:
2494: SELECT NVL(MAX(UPLOAD_ORDER), 0) + 1
2495: INTO l_order_seq
2496: FROM BNE_INTERFACES_B
2497: WHERE APPLICATION_ID = 274
2498: AND INTEGRATOR_APP_ID = 274
2499: AND INTEGRATOR_CODE = l_integrator_code;
2500:

Line 2505: INSERT INTO BNE_INTERFACES_B

2501: IF SQL%NOTFOUND THEN
2502: RAISE NO_DATA_FOUND;
2503: END IF;
2504:
2505: INSERT INTO BNE_INTERFACES_B
2506: (APPLICATION_ID,
2507: INTERFACE_CODE,
2508: OBJECT_VERSION_NUMBER,
2509: INTEGRATOR_APP_ID,

Line 6129: SELECT interface_code FROM bne_interfaces_b WHERE integrator_code = 'FEM_DIM_MEMBER_INTG'

6125: CURSOR dimintg_lyts_csr IS
6126: SELECT layout_code FROM bne_layouts_b WHERE integrator_code = 'FEM_DIM_MEMBER_INTG';
6127:
6128: CURSOR dimintg_intfs_csr IS
6129: SELECT interface_code FROM bne_interfaces_b WHERE integrator_code = 'FEM_DIM_MEMBER_INTG'
6130: AND interface_code <> 'FEM_DIM_MEMBER_HEADER_INTF';
6131:
6132: BEGIN
6133:

Line 6207: DELETE FROM bne_interfaces_b WHERE integrator_code = 'FEM_DIM_MEMBER_INTG'

6203: LOOP
6204: DELETE FROM bne_interfaces_tl WHERE interface_code = dimintg_intfs_csr_rec.interface_code;
6205: END LOOP;
6206:
6207: DELETE FROM bne_interfaces_b WHERE integrator_code = 'FEM_DIM_MEMBER_INTG'
6208: AND interface_code <> 'FEM_DIM_MEMBER_HEADER_INTF';
6209:
6210: FEM_ENGINES_PKG.User_Message (
6211: p_app_name => 'FEM'