APPS.BNE_GRAPHS_PKG dependencies on BNE_GRAPHS_B

Line 25: cursor C is select ROWID from BNE_GRAPHS_B

21: X_LAST_UPDATED_BY in NUMBER,
22: X_LAST_UPDATE_LOGIN in NUMBER,
23: X_LAST_UPDATE_DATE in DATE
24: ) is
25: cursor C is select ROWID from BNE_GRAPHS_B
26: where APPLICATION_ID = X_APPLICATION_ID
27: and INTEGRATOR_CODE = X_INTEGRATOR_CODE
28: and SEQUENCE_NUM = X_SEQUENCE_NUM
29: ;

Line 31: insert into BNE_GRAPHS_B (

27: and INTEGRATOR_CODE = X_INTEGRATOR_CODE
28: and SEQUENCE_NUM = X_SEQUENCE_NUM
29: ;
30: begin
31: insert into BNE_GRAPHS_B (
32: APPLICATION_ID,
33: INTEGRATOR_CODE,
34: SEQUENCE_NUM,
35: OBJECT_VERSION_NUMBER,

Line 142: from BNE_GRAPHS_B

138: LAYOUT_CODE,
139: GRAPH_DIMENSION_CODE,
140: GRAPH_TYPE_CODE,
141: AUTO_GRAPH_FLAG
142: from BNE_GRAPHS_B
143: where APPLICATION_ID = X_APPLICATION_ID
144: and INTEGRATOR_CODE = X_INTEGRATOR_CODE
145: and SEQUENCE_NUM = X_SEQUENCE_NUM
146: for update of APPLICATION_ID nowait;

Line 228: update BNE_GRAPHS_B set

224: X_LAST_UPDATE_LOGIN in NUMBER,
225: X_LAST_UPDATE_DATE in DATE
226: ) is
227: begin
228: update BNE_GRAPHS_B set
229: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
230: LAYOUT_APP_ID = X_LAYOUT_APP_ID,
231: LAYOUT_CODE = X_LAYOUT_CODE,
232: GRAPH_DIMENSION_CODE = X_GRAPH_DIMENSION_CODE,

Line 280: delete from BNE_GRAPHS_B

276: if (sql%notfound) then
277: raise no_data_found;
278: end if;
279:
280: delete from BNE_GRAPHS_B
281: where APPLICATION_ID = X_APPLICATION_ID
282: and INTEGRATOR_CODE = X_INTEGRATOR_CODE
283: and SEQUENCE_NUM = X_SEQUENCE_NUM;
284:

Line 296: from BNE_GRAPHS_B B

292: begin
293: delete from BNE_GRAPHS_TL T
294: where not exists
295: (select NULL
296: from BNE_GRAPHS_B B
297: where B.APPLICATION_ID = T.APPLICATION_ID
298: and B.INTEGRATOR_CODE = T.INTEGRATOR_CODE
299: and B.SEQUENCE_NUM = T.SEQUENCE_NUM
300: );

Line 516: from BNE_GRAPHS_B

512: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
513: begin
514: select LAST_UPDATED_BY, LAST_UPDATE_DATE
515: into db_luby, db_ludate
516: from BNE_GRAPHS_B
517: where APPLICATION_ID = l_app_id
518: and INTEGRATOR_CODE = x_integrator_code
519: and SEQUENCE_NUM = x_sequence_num;
520: