APPS.BNE_INTEGRATORS_PKG dependencies on BNE_INTEGRATORS_B

Line 37: cursor C is select ROWID from BNE_INTEGRATORS_B

33: X_SESSION_PARAM_LIST_APP_ID in NUMBER,
34: X_SESSION_PARAM_LIST_CODE in VARCHAR2,
35: X_DISPLAY_FLAG in VARCHAR2
36: ) is
37: cursor C is select ROWID from BNE_INTEGRATORS_B
38: where APPLICATION_ID = X_APPLICATION_ID
39: and INTEGRATOR_CODE = X_INTEGRATOR_CODE
40: ;
41: begin

Line 42: insert into BNE_INTEGRATORS_B (

38: where APPLICATION_ID = X_APPLICATION_ID
39: and INTEGRATOR_CODE = X_INTEGRATOR_CODE
40: ;
41: begin
42: insert into BNE_INTEGRATORS_B (
43: ENABLED_FLAG,
44: OBJECT_VERSION_NUMBER,
45: UPLOAD_PARAM_LIST_APP_ID,
46: UPLOAD_PARAM_LIST_CODE,

Line 194: from BNE_INTEGRATORS_B

190: SESSION_CONFIG_CLASS,
191: SESSION_PARAM_LIST_APP_ID,
192: SESSION_PARAM_LIST_CODE,
193: DISPLAY_FLAG
194: from BNE_INTEGRATORS_B
195: where APPLICATION_ID = X_APPLICATION_ID
196: and INTEGRATOR_CODE = X_INTEGRATOR_CODE
197: for update of APPLICATION_ID nowait;
198: recinfo c%rowtype;

Line 312: update BNE_INTEGRATORS_B set

308: X_SESSION_PARAM_LIST_CODE in VARCHAR2,
309: X_DISPLAY_FLAG in VARCHAR2
310: ) is
311: begin
312: update BNE_INTEGRATORS_B set
313: ENABLED_FLAG = X_ENABLED_FLAG,
314: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
315: UPLOAD_PARAM_LIST_APP_ID = X_UPLOAD_PARAM_LIST_APP_ID,
316: UPLOAD_PARAM_LIST_CODE = X_UPLOAD_PARAM_LIST_CODE,

Line 373: delete from BNE_INTEGRATORS_B

369: if (sql%notfound) then
370: raise no_data_found;
371: end if;
372:
373: delete from BNE_INTEGRATORS_B
374: where APPLICATION_ID = X_APPLICATION_ID
375: and INTEGRATOR_CODE = X_INTEGRATOR_CODE;
376:
377: if (sql%notfound) then

Line 388: from BNE_INTEGRATORS_B B

384: begin
385: delete from BNE_INTEGRATORS_TL T
386: where not exists
387: (select NULL
388: from BNE_INTEGRATORS_B B
389: where B.APPLICATION_ID = T.APPLICATION_ID
390: and B.INTEGRATOR_CODE = T.INTEGRATOR_CODE
391: );
392:

Line 607: from BNE_INTEGRATORS_B

603: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
604: begin
605: select LAST_UPDATED_BY, LAST_UPDATE_DATE
606: into db_luby, db_ludate
607: from BNE_INTEGRATORS_B
608: where APPLICATION_ID = l_app_id
609: and INTEGRATOR_CODE = x_integrator_code;
610:
611: -- Test for customization and version