APPS.BNE_MENUS_PKG dependencies on BNE_MENUS_B

Line 25: cursor C is select ROWID from BNE_MENUS_B

21: X_LAST_UPDATE_DATE in DATE,
22: X_LAST_UPDATED_BY in NUMBER,
23: X_LAST_UPDATE_LOGIN in NUMBER
24: ) is
25: cursor C is select ROWID from BNE_MENUS_B
26: where APPLICATION_ID = X_APPLICATION_ID
27: and MENU_CODE = X_MENU_CODE
28: ;
29: begin

Line 30: insert into BNE_MENUS_B (

26: where APPLICATION_ID = X_APPLICATION_ID
27: and MENU_CODE = X_MENU_CODE
28: ;
29: begin
30: insert into BNE_MENUS_B (
31: APPLICATION_ID,
32: MENU_CODE,
33: PARENT_APP_ID,
34: PARENT_CODE,

Line 135: from BNE_MENUS_B

131: ACCESS_POINT,
132: PARAM_LIST_APP_ID,
133: PARAM_LIST_CODE,
134: OBJECT_VERSION_NUMBER
135: from BNE_MENUS_B
136: where APPLICATION_ID = X_APPLICATION_ID
137: and MENU_CODE = X_MENU_CODE
138: for update of APPLICATION_ID nowait;
139: recinfo c%rowtype;

Line 217: update BNE_MENUS_B set

213: X_LAST_UPDATED_BY in NUMBER,
214: X_LAST_UPDATE_LOGIN in NUMBER
215: ) is
216: begin
217: update BNE_MENUS_B set
218: PARENT_APP_ID = X_PARENT_APP_ID,
219: PARENT_CODE = X_PARENT_CODE,
220: SEQUENCE_NUM = X_SEQUENCE_NUM,
221: INTEGRATOR_APP_ID = X_INTEGRATOR_APP_ID,

Line 266: delete from BNE_MENUS_B

262: if (sql%notfound) then
263: raise no_data_found;
264: end if;
265:
266: delete from BNE_MENUS_B
267: where APPLICATION_ID = X_APPLICATION_ID
268: and MENU_CODE = X_MENU_CODE;
269:
270: if (sql%notfound) then

Line 281: from BNE_MENUS_B B

277: begin
278: delete from BNE_MENUS_TL T
279: where not exists
280: (select NULL
281: from BNE_MENUS_B B
282: where B.APPLICATION_ID = T.APPLICATION_ID
283: and B.MENU_CODE = T.MENU_CODE
284: );
285:

Line 466: from BNE_MENUS_B

462: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
463: begin
464: select LAST_UPDATED_BY, LAST_UPDATE_DATE
465: into db_luby, db_ludate
466: from BNE_MENUS_B
467: where APPLICATION_ID = l_app_id
468: and MENU_CODE = x_menu_code;
469:
470: -- Test for customization and version