APPS.BNE_QUERIES_PKG dependencies on BNE_QUERIES_B

Line 19: cursor C is select ROWID from BNE_QUERIES_B

15: X_LAST_UPDATE_LOGIN in NUMBER,
16: X_DIRECTIVE_APP_ID in NUMBER DEFAULT NULL,
17: X_DIRECTIVE_CODE in VARCHAR2 DEFAULT NULL
18: ) is
19: cursor C is select ROWID from BNE_QUERIES_B
20: where APPLICATION_ID = X_APPLICATION_ID
21: and QUERY_CODE = X_QUERY_CODE
22: ;
23: begin

Line 24: insert into BNE_QUERIES_B (

20: where APPLICATION_ID = X_APPLICATION_ID
21: and QUERY_CODE = X_QUERY_CODE
22: ;
23: begin
24: insert into BNE_QUERIES_B (
25: APPLICATION_ID,
26: QUERY_CODE,
27: OBJECT_VERSION_NUMBER,
28: QUERY_CLASS,

Line 105: from BNE_QUERIES_B

101: OBJECT_VERSION_NUMBER,
102: QUERY_CLASS,
103: DIRECTIVE_APP_ID,
104: DIRECTIVE_CODE
105: from BNE_QUERIES_B
106: where APPLICATION_ID = X_APPLICATION_ID
107: and QUERY_CODE = X_QUERY_CODE
108: for update of APPLICATION_ID nowait;
109: recinfo c%rowtype;

Line 169: update BNE_QUERIES_B set

165: X_DIRECTIVE_APP_ID in NUMBER DEFAULT NULL,
166: X_DIRECTIVE_CODE in VARCHAR2 DEFAULT NULL
167: ) is
168: begin
169: update BNE_QUERIES_B set
170: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
171: QUERY_CLASS = X_QUERY_CLASS,
172: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
173: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 212: delete from BNE_QUERIES_B

208: if (sql%notfound) then
209: raise no_data_found;
210: end if;
211:
212: delete from BNE_QUERIES_B
213: where APPLICATION_ID = X_APPLICATION_ID
214: and QUERY_CODE = X_QUERY_CODE;
215:
216: if (sql%notfound) then

Line 227: from BNE_QUERIES_B B

223: begin
224: delete from BNE_QUERIES_TL T
225: where not exists
226: (select NULL
227: from BNE_QUERIES_B B
228: where B.APPLICATION_ID = T.APPLICATION_ID
229: and B.QUERY_CODE = T.QUERY_CODE
230: );
231:

Line 404: from BNE_QUERIES_B

400: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
401: begin
402: select LAST_UPDATED_BY, LAST_UPDATE_DATE
403: into db_luby, db_ludate
404: from BNE_QUERIES_B
405: where APPLICATION_ID = l_app_id
406: and QUERY_CODE = x_query_code;
407:
408: -- Test for customization and version