APPS.BNE_PARAM_LIST_ITEMS_PKG dependencies on BNE_PARAM_LIST_ITEMS

Line 1: package body BNE_PARAM_LIST_ITEMS_PKG as

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

Line 27: cursor C is select ROWID from BNE_PARAM_LIST_ITEMS

23: X_LAST_UPDATE_DATE in DATE,
24: X_LAST_UPDATED_BY in NUMBER,
25: X_LAST_UPDATE_LOGIN in NUMBER
26: ) is
27: cursor C is select ROWID from BNE_PARAM_LIST_ITEMS
28: where APPLICATION_ID = X_APPLICATION_ID
29: and PARAM_LIST_CODE = X_PARAM_LIST_CODE
30: and SEQUENCE_NUM = X_SEQUENCE_NUM
31: ;

Line 33: insert into BNE_PARAM_LIST_ITEMS (

29: and PARAM_LIST_CODE = X_PARAM_LIST_CODE
30: and SEQUENCE_NUM = X_SEQUENCE_NUM
31: ;
32: begin
33: insert into BNE_PARAM_LIST_ITEMS (
34: APPLICATION_ID,
35: PARAM_LIST_CODE,
36: SEQUENCE_NUM,
37: OBJECT_VERSION_NUMBER,

Line 117: from BNE_PARAM_LIST_ITEMS

113: BOOLEAN_VALUE_FLAG,
114: FORMULA_VALUE,
115: DESC_VALUE,
116: PARAM_NAME
117: from BNE_PARAM_LIST_ITEMS
118: where APPLICATION_ID = X_APPLICATION_ID
119: and PARAM_LIST_CODE = X_PARAM_LIST_CODE
120: and SEQUENCE_NUM = X_SEQUENCE_NUM
121: for update of APPLICATION_ID nowait;

Line 178: update BNE_PARAM_LIST_ITEMS set

174: X_LAST_UPDATED_BY in NUMBER,
175: X_LAST_UPDATE_LOGIN in NUMBER
176: ) is
177: begin
178: update BNE_PARAM_LIST_ITEMS set
179: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
180: PARAM_DEFN_APP_ID = X_PARAM_DEFN_APP_ID,
181: PARAM_DEFN_CODE = X_PARAM_DEFN_CODE,
182: ATTRIBUTE_APP_ID = X_ATTRIBUTE_APP_ID,

Line 210: delete from BNE_PARAM_LIST_ITEMS

206: X_PARAM_LIST_CODE in VARCHAR2,
207: X_SEQUENCE_NUM in NUMBER
208: ) is
209: begin
210: delete from BNE_PARAM_LIST_ITEMS
211: where APPLICATION_ID = X_APPLICATION_ID
212: and PARAM_LIST_CODE = X_PARAM_LIST_CODE
213: and SEQUENCE_NUM = X_SEQUENCE_NUM;
214:

Line 230: -- DESCRIPTION: Load a row into the BNE_PARAM_LIST_ITEMS entity. --

226:
227: --------------------------------------------------------------------------------
228: -- PROCEDURE: LOAD_ROW --
229: -- --
230: -- DESCRIPTION: Load a row into the BNE_PARAM_LIST_ITEMS entity. --
231: -- This proc is called from the apps loader. --
232: -- --
233: -- SEE: http://www-apps.us.oracle.com/atg/plans/r115/fndloadqr.txt --
234: -- --

Line 296: from BNE_PARAM_LIST_ITEMS

292: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
293: begin
294: select LAST_UPDATED_BY, LAST_UPDATE_DATE
295: into db_luby, db_ludate
296: from BNE_PARAM_LIST_ITEMS
297: where APPLICATION_ID = l_app_id
298: and PARAM_LIST_CODE = x_param_list_code
299: and SEQUENCE_NUM = x_sequence_num;
300:

Line 305: BNE_PARAM_LIST_ITEMS_PKG.Update_Row(

301: -- Test for customization and version
302: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
303: db_ludate, x_custom_mode)) then
304: -- Update existing row
305: BNE_PARAM_LIST_ITEMS_PKG.Update_Row(
306: X_APPLICATION_ID => l_app_id,
307: X_PARAM_LIST_CODE => x_param_list_code,
308: X_SEQUENCE_NUM => x_sequence_num,
309: X_OBJECT_VERSION_NUMBER => x_object_version_number,

Line 329: BNE_PARAM_LIST_ITEMS_PKG.Insert_Row(

325: end if;
326: exception
327: when no_data_found then
328: -- Record doesn't exist - insert in all cases
329: BNE_PARAM_LIST_ITEMS_PKG.Insert_Row(
330: X_ROWID => l_row_id,
331: X_APPLICATION_ID => l_app_id,
332: X_PARAM_LIST_CODE => x_param_list_code,
333: X_SEQUENCE_NUM => x_sequence_num,

Line 356: end BNE_PARAM_LIST_ITEMS_PKG;

352: end;
353: end LOAD_ROW;
354:
355:
356: end BNE_PARAM_LIST_ITEMS_PKG;