APPS.BNE_INTERFACES_PKG dependencies on BNE_INTERFACES_B

Line 24: cursor C is select ROWID from BNE_INTERFACES_B

20: X_LAST_UPDATE_DATE in DATE,
21: X_LAST_UPDATED_BY in NUMBER,
22: X_LAST_UPDATE_LOGIN in NUMBER
23: ) is
24: cursor C is select ROWID from BNE_INTERFACES_B
25: where APPLICATION_ID = X_APPLICATION_ID
26: and INTERFACE_CODE = X_INTERFACE_CODE
27: ;
28: begin

Line 29: insert into BNE_INTERFACES_B (

25: where APPLICATION_ID = X_APPLICATION_ID
26: and INTERFACE_CODE = X_INTERFACE_CODE
27: ;
28: begin
29: insert into BNE_INTERFACES_B (
30: INTERFACE_NAME,
31: UPLOAD_TYPE,
32: UPLOAD_OBJ_NAME,
33: APPLICATION_ID,

Line 130: from BNE_INTERFACES_B

126: INTEGRATOR_CODE,
127: UPLOAD_PARAM_LIST_APP_ID,
128: UPLOAD_PARAM_LIST_CODE,
129: UPLOAD_ORDER
130: from BNE_INTERFACES_B
131: where APPLICATION_ID = X_APPLICATION_ID
132: and INTERFACE_CODE = X_INTERFACE_CODE
133: for update of APPLICATION_ID nowait;
134: recinfo c%rowtype;

Line 205: update BNE_INTERFACES_B set

201: X_LAST_UPDATED_BY in NUMBER,
202: X_LAST_UPDATE_LOGIN in NUMBER
203: ) is
204: begin
205: update BNE_INTERFACES_B set
206: INTERFACE_NAME = X_INTERFACE_NAME,
207: UPLOAD_TYPE = X_UPLOAD_TYPE,
208: UPLOAD_OBJ_NAME = X_UPLOAD_OBJ_NAME,
209: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,

Line 253: delete from BNE_INTERFACES_B

249: if (sql%notfound) then
250: raise no_data_found;
251: end if;
252:
253: delete from BNE_INTERFACES_B
254: where APPLICATION_ID = X_APPLICATION_ID
255: and INTERFACE_CODE = X_INTERFACE_CODE;
256:
257: if (sql%notfound) then

Line 268: from BNE_INTERFACES_B B

264: begin
265: delete from BNE_INTERFACES_TL T
266: where not exists
267: (select NULL
268: from BNE_INTERFACES_B B
269: where B.APPLICATION_ID = T.APPLICATION_ID
270: and B.INTERFACE_CODE = T.INTERFACE_CODE
271: );
272:

Line 449: from BNE_INTERFACES_B

445: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
446: begin
447: select LAST_UPDATED_BY, LAST_UPDATE_DATE
448: into db_luby, db_ludate
449: from BNE_INTERFACES_B
450: where APPLICATION_ID = l_app_id
451: and INTERFACE_CODE = x_interface_code;
452:
453: -- Test for customization and version