APPS.BNE_INTEGRATORS_PKG dependencies on BNE_INTEGRATORS_B

Line 38: cursor C is select ROWID from BNE_INTEGRATORS_B

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

Line 43: insert into BNE_INTEGRATORS_B (

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

Line 199: from BNE_INTEGRATORS_B

195: SESSION_PARAM_LIST_APP_ID,
196: SESSION_PARAM_LIST_CODE,
197: DISPLAY_FLAG,
198: SOURCE
199: from BNE_INTEGRATORS_B
200: where APPLICATION_ID = X_APPLICATION_ID
201: and INTEGRATOR_CODE = X_INTEGRATOR_CODE
202: for update of APPLICATION_ID nowait;
203: recinfo c%rowtype;

Line 320: update BNE_INTEGRATORS_B set

316: X_DISPLAY_FLAG in VARCHAR2,
317: X_SOURCE in VARCHAR2
318: ) is
319: begin
320: update BNE_INTEGRATORS_B set
321: ENABLED_FLAG = X_ENABLED_FLAG,
322: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
323: UPLOAD_PARAM_LIST_APP_ID = X_UPLOAD_PARAM_LIST_APP_ID,
324: UPLOAD_PARAM_LIST_CODE = X_UPLOAD_PARAM_LIST_CODE,

Line 382: delete from BNE_INTEGRATORS_B

378: if (sql%notfound) then
379: raise no_data_found;
380: end if;
381:
382: delete from BNE_INTEGRATORS_B
383: where APPLICATION_ID = X_APPLICATION_ID
384: and INTEGRATOR_CODE = X_INTEGRATOR_CODE;
385:
386: if (sql%notfound) then

Line 397: from BNE_INTEGRATORS_B B

393: begin
394: delete from BNE_INTEGRATORS_TL T
395: where not exists
396: (select NULL
397: from BNE_INTEGRATORS_B B
398: where B.APPLICATION_ID = T.APPLICATION_ID
399: and B.INTEGRATOR_CODE = T.INTEGRATOR_CODE
400: );
401:

Line 616: from BNE_INTEGRATORS_B

612: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
613: begin
614: select LAST_UPDATED_BY, LAST_UPDATE_DATE
615: into db_luby, db_ludate
616: from BNE_INTEGRATORS_B
617: where APPLICATION_ID = l_app_id
618: and INTEGRATOR_CODE = x_integrator_code;
619:
620: -- Test for customization and version