APPS.BNE_COMPONENTS_PKG dependencies on BNE_COMPONENTS_B

Line 19: cursor C is select ROWID from BNE_COMPONENTS_B

15: X_LAST_UPDATE_DATE in DATE,
16: X_LAST_UPDATED_BY in NUMBER,
17: X_LAST_UPDATE_LOGIN in NUMBER
18: ) is
19: cursor C is select ROWID from BNE_COMPONENTS_B
20: where APPLICATION_ID = X_APPLICATION_ID
21: and COMPONENT_CODE = X_COMPONENT_CODE
22: ;
23: begin

Line 24: insert into BNE_COMPONENTS_B (

20: where APPLICATION_ID = X_APPLICATION_ID
21: and COMPONENT_CODE = X_COMPONENT_CODE
22: ;
23: begin
24: insert into BNE_COMPONENTS_B (
25: COMPONENT_CODE,
26: OBJECT_VERSION_NUMBER,
27: COMPONENT_JAVA_CLASS,
28: PARAM_LIST_APP_ID,

Line 105: from BNE_COMPONENTS_B

101: OBJECT_VERSION_NUMBER,
102: COMPONENT_JAVA_CLASS,
103: PARAM_LIST_APP_ID,
104: PARAM_LIST_CODE
105: from BNE_COMPONENTS_B
106: where APPLICATION_ID = X_APPLICATION_ID
107: and COMPONENT_CODE = X_COMPONENT_CODE
108: for update of APPLICATION_ID nowait;
109: recinfo c%rowtype;

Line 168: update BNE_COMPONENTS_B set

164: X_LAST_UPDATED_BY in NUMBER,
165: X_LAST_UPDATE_LOGIN in NUMBER
166: ) is
167: begin
168: update BNE_COMPONENTS_B set
169: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
170: COMPONENT_JAVA_CLASS = X_COMPONENT_JAVA_CLASS,
171: PARAM_LIST_APP_ID = X_PARAM_LIST_APP_ID,
172: PARAM_LIST_CODE = X_PARAM_LIST_CODE,

Line 211: delete from BNE_COMPONENTS_B

207: if (sql%notfound) then
208: raise no_data_found;
209: end if;
210:
211: delete from BNE_COMPONENTS_B
212: where APPLICATION_ID = X_APPLICATION_ID
213: and COMPONENT_CODE = X_COMPONENT_CODE;
214:
215: if (sql%notfound) then

Line 226: from BNE_COMPONENTS_B B

222: begin
223: delete from BNE_COMPONENTS_TL T
224: where not exists
225: (select NULL
226: from BNE_COMPONENTS_B B
227: where B.APPLICATION_ID = T.APPLICATION_ID
228: and B.COMPONENT_CODE = T.COMPONENT_CODE
229: );
230:

Line 335: from BNE_COMPONENTS_B

331: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
332: begin
333: select LAST_UPDATED_BY, LAST_UPDATE_DATE
334: into db_luby, db_ludate
335: from BNE_COMPONENTS_B
336: where APPLICATION_ID = l_app_id
337: and COMPONENT_CODE = x_component_code;
338:
339: -- Test for customization and version