APPS.BNE_PERF_SETS_PKG dependencies on BNE_PERF_SETS_B

Line 16: cursor C is select ROWID from BNE_PERF_SETS_B

12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: cursor C is select ROWID from BNE_PERF_SETS_B
17: where SET_CODE = X_SET_CODE
18: ;
19: begin
20: insert into BNE_PERF_SETS_B (

Line 20: insert into BNE_PERF_SETS_B (

16: cursor C is select ROWID from BNE_PERF_SETS_B
17: where SET_CODE = X_SET_CODE
18: ;
19: begin
20: insert into BNE_PERF_SETS_B (
21: SET_CODE,
22: OBJECT_VERSION_NUMBER,
23: ENABLED_FLAG,
24: CREATION_DATE,

Line 87: from BNE_PERF_SETS_B

83: ) is
84: cursor c is select
85: OBJECT_VERSION_NUMBER,
86: ENABLED_FLAG
87: from BNE_PERF_SETS_B
88: where SET_CODE = X_SET_CODE
89: for update of SET_CODE nowait;
90: recinfo c%rowtype;
91:

Line 141: update BNE_PERF_SETS_B set

137: X_LAST_UPDATED_BY in NUMBER,
138: X_LAST_UPDATE_LOGIN in NUMBER
139: ) is
140: begin
141: update BNE_PERF_SETS_B set
142: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
143: ENABLED_FLAG = X_ENABLED_FLAG,
144: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
145: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 178: delete from BNE_PERF_SETS_B

174: if (sql%notfound) then
175: raise no_data_found;
176: end if;
177:
178: delete from BNE_PERF_SETS_B
179: where SET_CODE = X_SET_CODE;
180:
181: if (sql%notfound) then
182: raise no_data_found;

Line 192: from BNE_PERF_SETS_B B

188: begin
189: delete from BNE_PERF_SETS_TL T
190: where not exists
191: (select NULL
192: from BNE_PERF_SETS_B B
193: where B.SET_CODE = T.SET_CODE
194: );
195:
196: update BNE_PERF_SETS_TL T set (

Line 341: from BNE_PERF_SETS_B

337: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
338: begin
339: select LAST_UPDATED_BY, LAST_UPDATE_DATE
340: into db_luby, db_ludate
341: from BNE_PERF_SETS_B
342: where SET_CODE = x_set_code;
343:
344: -- Test for customization and version
345: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,