APPS.BNE_PARAM_OVERRIDES_PKG dependencies on BNE_PARAM_OVERRIDES

Line 1: package body BNE_PARAM_OVERRIDES_PKG as

1: package body BNE_PARAM_OVERRIDES_PKG as
2: /* $Header: bneparamovb.pls 120.2 2005/06/29 03:40:30 dvayro noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 26: cursor C is select ROWID from BNE_PARAM_OVERRIDES

22: X_LAST_UPDATE_DATE in DATE,
23: X_LAST_UPDATED_BY in NUMBER,
24: X_LAST_UPDATE_LOGIN in NUMBER
25: ) is
26: cursor C is select ROWID from BNE_PARAM_OVERRIDES
27: where APPLICATION_ID = X_APPLICATION_ID
28: and PARAM_DEFN_CODE = X_PARAM_DEFN_CODE
29: and LVL = X_LVL
30: and OVERRIDE_ID = X_OVERRIDE_ID

Line 33: insert into BNE_PARAM_OVERRIDES (

29: and LVL = X_LVL
30: and OVERRIDE_ID = X_OVERRIDE_ID
31: ;
32: begin
33: insert into BNE_PARAM_OVERRIDES (
34: APPLICATION_ID,
35: PARAM_DEFN_CODE,
36: LVL,
37: OVERRIDE_ID,

Line 112: from BNE_PARAM_OVERRIDES

108: DEFAULT_BOOLEAN_FLAG,
109: DEFAULT_FORMULA,
110: DESC_VALUE,
111: DEFAULT_STRING
112: from BNE_PARAM_OVERRIDES
113: where APPLICATION_ID = X_APPLICATION_ID
114: and PARAM_DEFN_CODE = X_PARAM_DEFN_CODE
115: and LVL = X_LVL
116: and OVERRIDE_ID = X_OVERRIDE_ID

Line 169: update BNE_PARAM_OVERRIDES set

165: X_LAST_UPDATED_BY in NUMBER,
166: X_LAST_UPDATE_LOGIN in NUMBER
167: ) is
168: begin
169: update BNE_PARAM_OVERRIDES set
170: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
171: REQUIRED_FLAG = X_REQUIRED_FLAG,
172: VISIBLE_FLAG = X_VISIBLE_FLAG,
173: USER_MODIFYABLE_FLAG = X_USER_MODIFYABLE_FLAG,

Line 200: delete from BNE_PARAM_OVERRIDES

196: X_LVL in NUMBER,
197: X_OVERRIDE_ID in NUMBER
198: ) is
199: begin
200: delete from BNE_PARAM_OVERRIDES
201: where APPLICATION_ID = X_APPLICATION_ID
202: and PARAM_DEFN_CODE = X_PARAM_DEFN_CODE
203: and LVL = X_LVL
204: and OVERRIDE_ID = X_OVERRIDE_ID;

Line 282: from BNE_PARAM_OVERRIDES

278: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
279: begin
280: select LAST_UPDATED_BY, LAST_UPDATE_DATE
281: into db_luby, db_ludate
282: from BNE_PARAM_OVERRIDES
283: where APPLICATION_ID = l_app_id
284: and PARAM_DEFN_CODE = x_param_defn_code
285: and LVL = x_lvl
286: and OVERRIDE_ID = x_override_id;

Line 292: BNE_PARAM_OVERRIDES_PKG.Update_Row(

288: -- Test for customization and version
289: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
290: db_ludate, x_custom_mode)) then
291: -- Update existing row
292: BNE_PARAM_OVERRIDES_PKG.Update_Row(
293: X_APPLICATION_ID => l_app_id,
294: X_PARAM_DEFN_CODE => x_param_defn_code,
295: X_LVL => x_lvl,
296: X_OVERRIDE_ID => x_override_id,

Line 315: BNE_PARAM_OVERRIDES_PKG.Insert_Row(

311: end if;
312: exception
313: when no_data_found then
314: -- Record doesn't exist - insert in all cases
315: BNE_PARAM_OVERRIDES_PKG.Insert_Row(
316: X_ROWID => l_row_id,
317: X_APPLICATION_ID => l_app_id,
318: X_PARAM_DEFN_CODE => x_param_defn_code,
319: X_LVL => x_lvl,

Line 342: end BNE_PARAM_OVERRIDES_PKG;

338: end LOAD_ROW;
339:
340:
341:
342: end BNE_PARAM_OVERRIDES_PKG;