APPS.BNE_MAPPINGS_PKG dependencies on BNE_MAPPINGS_B

Line 21: cursor C is select ROWID from BNE_MAPPINGS_B

17: X_LAST_UPDATE_DATE in DATE,
18: X_LAST_UPDATED_BY in NUMBER,
19: X_LAST_UPDATE_LOGIN in NUMBER
20: ) is
21: cursor C is select ROWID from BNE_MAPPINGS_B
22: where APPLICATION_ID = X_APPLICATION_ID
23: and MAPPING_CODE = X_MAPPING_CODE
24: ;
25: begin

Line 26: insert into BNE_MAPPINGS_B (

22: where APPLICATION_ID = X_APPLICATION_ID
23: and MAPPING_CODE = X_MAPPING_CODE
24: ;
25: begin
26: insert into BNE_MAPPINGS_B (
27: MAPPING_CODE,
28: OBJECT_VERSION_NUMBER,
29: INTEGRATOR_APP_ID,
30: INTEGRATOR_CODE,

Line 115: from BNE_MAPPINGS_B

111: INTEGRATOR_CODE,
112: REPORTING_FLAG,
113: REPORTING_INTERFACE_APP_ID,
114: REPORTING_INTERFACE_CODE
115: from BNE_MAPPINGS_B
116: where APPLICATION_ID = X_APPLICATION_ID
117: and MAPPING_CODE = X_MAPPING_CODE
118: for update of APPLICATION_ID nowait;
119: recinfo c%rowtype;

Line 182: update BNE_MAPPINGS_B set

178: X_LAST_UPDATED_BY in NUMBER,
179: X_LAST_UPDATE_LOGIN in NUMBER
180: ) is
181: begin
182: update BNE_MAPPINGS_B set
183: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
184: INTEGRATOR_APP_ID = X_INTEGRATOR_APP_ID,
185: INTEGRATOR_CODE = X_INTEGRATOR_CODE,
186: REPORTING_FLAG = X_REPORTING_FLAG,

Line 227: delete from BNE_MAPPINGS_B

223: if (sql%notfound) then
224: raise no_data_found;
225: end if;
226:
227: delete from BNE_MAPPINGS_B
228: where APPLICATION_ID = X_APPLICATION_ID
229: and MAPPING_CODE = X_MAPPING_CODE;
230:
231: if (sql%notfound) then

Line 242: from BNE_MAPPINGS_B B

238: begin
239: delete from BNE_MAPPINGS_TL T
240: where not exists
241: (select NULL
242: from BNE_MAPPINGS_B B
243: where B.APPLICATION_ID = T.APPLICATION_ID
244: and B.MAPPING_CODE = T.MAPPING_CODE
245: );
246:

Line 420: from BNE_MAPPINGS_B

416: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
417: begin
418: select LAST_UPDATED_BY, LAST_UPDATE_DATE
419: into db_luby, db_ludate
420: from BNE_MAPPINGS_B
421: where APPLICATION_ID = l_app_id
422: and MAPPING_CODE = x_mapping_code;
423:
424: -- Test for customization and version