APPS.BNE_PARAM_LISTS_PKG dependencies on BNE_PARAM_LISTS_B

Line 24: cursor C is select ROWID from BNE_PARAM_LISTS_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_PARAM_LISTS_B
25: where APPLICATION_ID = X_APPLICATION_ID
26: and PARAM_LIST_CODE = X_PARAM_LIST_CODE
27: ;
28: begin

Line 29: insert into BNE_PARAM_LISTS_B (

25: where APPLICATION_ID = X_APPLICATION_ID
26: and PARAM_LIST_CODE = X_PARAM_LIST_CODE
27: ;
28: begin
29: insert into BNE_PARAM_LISTS_B (
30: APPLICATION_ID,
31: PARAM_LIST_CODE,
32: OBJECT_VERSION_NUMBER,
33: PERSISTENT_FLAG,

Line 127: from BNE_PARAM_LISTS_B

123: COMMENTS,
124: ATTRIBUTE_APP_ID,
125: ATTRIBUTE_CODE,
126: LIST_RESOLVER
127: from BNE_PARAM_LISTS_B
128: where APPLICATION_ID = X_APPLICATION_ID
129: and PARAM_LIST_CODE = X_PARAM_LIST_CODE
130: for update of APPLICATION_ID nowait;
131: recinfo c%rowtype;

Line 208: update BNE_PARAM_LISTS_B set

204: X_LAST_UPDATED_BY in NUMBER,
205: X_LAST_UPDATE_LOGIN in NUMBER
206: ) is
207: begin
208: update BNE_PARAM_LISTS_B set
209: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
210: PERSISTENT_FLAG = X_PERSISTENT_FLAG,
211: COMMENTS = X_COMMENTS,
212: ATTRIBUTE_APP_ID = X_ATTRIBUTE_APP_ID,

Line 256: delete from BNE_PARAM_LISTS_B

252: if (sql%notfound) then
253: raise no_data_found;
254: end if;
255:
256: delete from BNE_PARAM_LISTS_B
257: where APPLICATION_ID = X_APPLICATION_ID
258: and PARAM_LIST_CODE = X_PARAM_LIST_CODE;
259:
260: if (sql%notfound) then

Line 271: from BNE_PARAM_LISTS_B B

267: begin
268: delete from BNE_PARAM_LISTS_TL T
269: where not exists
270: (select NULL
271: from BNE_PARAM_LISTS_B B
272: where B.APPLICATION_ID = T.APPLICATION_ID
273: and B.PARAM_LIST_CODE = T.PARAM_LIST_CODE
274: );
275:

Line 477: from BNE_PARAM_LISTS_B

473: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
474: begin
475: select LAST_UPDATED_BY, LAST_UPDATE_DATE
476: into db_luby, db_ludate
477: from BNE_PARAM_LISTS_B
478: where APPLICATION_ID = l_app_id
479: and PARAM_LIST_CODE = x_param_list_code;
480:
481: -- Test for customization and version