APPS.FEM_WEBADI_TABLES_UTILS_PVT dependencies on BNE_INTERFACES_B

Line 390: where exists(select interface_code from bne_interfaces_b where

386: -------------------- creating an interface if its not available for the P_TABLE_NAME
387:
388: begin
389: select 'Y' into l_interface_exists from dual
390: where exists(select interface_code from bne_interfaces_b where
391: interface_code = l_object_code || '_INTF');
392: exception
393: when NO_DATA_FOUND then null;
394: end;

Line 400: FROM BNE_INTERFACES_B

396: if(l_interface_exists is null) then
397:
398: SELECT NVL(MAX(UPLOAD_ORDER), 0) + 1
399: INTO l_order_seq
400: FROM BNE_INTERFACES_B
401: WHERE APPLICATION_ID = 274
402: AND INTEGRATOR_APP_ID = 274
403: AND INTEGRATOR_CODE = P_TABLE_NAME || '_INTG';
404:

Line 411: INSERT INTO BNE_INTERFACES_B

407: END IF;
408:
409: ---- Create the interface in the BNE_INTERFACE_B table
410:
411: INSERT INTO BNE_INTERFACES_B
412: (APPLICATION_ID,
413: INTERFACE_CODE,
414: OBJECT_VERSION_NUMBER,
415: INTEGRATOR_APP_ID,

Line 2865: delete from bne_interfaces_b where application_id = 274

2861:
2862: delete from bne_mappings_b where application_id = 274
2863: and mapping_code not in ('FEM_BALANCES_MAP');
2864:
2865: delete from bne_interfaces_b where application_id = 274
2866: and interface_code not in ('FEM_BALANCES_INTF');
2867:
2868: delete from bne_interfaces_tl where application_id = 274
2869: and interface_code not in ('FEM_BALANCES_INTF');