APPS.BNE_PERF_STATISTICS_PKG dependencies on BNE_PERF_STATISTICS_B

Line 15: cursor C is select ROWID from BNE_PERF_STATISTICS_B

11: X_LAST_UPDATE_DATE in DATE,
12: X_LAST_UPDATED_BY in NUMBER,
13: X_LAST_UPDATE_LOGIN in NUMBER
14: ) is
15: cursor C is select ROWID from BNE_PERF_STATISTICS_B
16: where STATISTIC_CODE = X_STATISTIC_CODE
17: ;
18: begin
19: insert into BNE_PERF_STATISTICS_B (

Line 19: insert into BNE_PERF_STATISTICS_B (

15: cursor C is select ROWID from BNE_PERF_STATISTICS_B
16: where STATISTIC_CODE = X_STATISTIC_CODE
17: ;
18: begin
19: insert into BNE_PERF_STATISTICS_B (
20: STATISTIC_CODE,
21: OBJECT_VERSION_NUMBER,
22: CREATION_DATE,
23: CREATED_BY,

Line 82: from BNE_PERF_STATISTICS_B

78: X_USER_NAME in VARCHAR2
79: ) is
80: cursor c is select
81: OBJECT_VERSION_NUMBER
82: from BNE_PERF_STATISTICS_B
83: where STATISTIC_CODE = X_STATISTIC_CODE
84: for update of STATISTIC_CODE nowait;
85: recinfo c%rowtype;
86:

Line 134: update BNE_PERF_STATISTICS_B set

130: X_LAST_UPDATED_BY in NUMBER,
131: X_LAST_UPDATE_LOGIN in NUMBER
132: ) is
133: begin
134: update BNE_PERF_STATISTICS_B set
135: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
136: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
137: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
138: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 170: delete from BNE_PERF_STATISTICS_B

166: if (sql%notfound) then
167: raise no_data_found;
168: end if;
169:
170: delete from BNE_PERF_STATISTICS_B
171: where STATISTIC_CODE = X_STATISTIC_CODE;
172:
173: if (sql%notfound) then
174: raise no_data_found;

Line 184: from BNE_PERF_STATISTICS_B B

180: begin
181: delete from BNE_PERF_STATISTICS_TL T
182: where not exists
183: (select NULL
184: from BNE_PERF_STATISTICS_B B
185: where B.STATISTIC_CODE = T.STATISTIC_CODE
186: );
187:
188: update BNE_PERF_STATISTICS_TL T set (

Line 332: from BNE_PERF_STATISTICS_B

328: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
329: begin
330: select LAST_UPDATED_BY, LAST_UPDATE_DATE
331: into db_luby, db_ludate
332: from BNE_PERF_STATISTICS_B
333: where STATISTIC_CODE = x_statistic_code;
334:
335: -- Test for customization and version
336: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,