APPS.BNE_USER_SETTINGS_PKG dependencies on BNE_USER_SETTINGS

Line 1: package body BNE_USER_SETTINGS_PKG as

1: package body BNE_USER_SETTINGS_PKG as
2: /* $Header: bneusersetb.pls 120.2 2005/06/29 03:41:12 dvayro noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 16: cursor C is select ROWID from BNE_USER_SETTINGS

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_USER_SETTINGS
17: where USER_ID = X_USER_ID
18: and SETTING_GROUP = X_SETTING_GROUP
19: and SETTING_NAME = X_SETTING_NAME
20: ;

Line 22: insert into BNE_USER_SETTINGS (

18: and SETTING_GROUP = X_SETTING_GROUP
19: and SETTING_NAME = X_SETTING_NAME
20: ;
21: begin
22: insert into BNE_USER_SETTINGS (
23: USER_ID,
24: SETTING_GROUP,
25: SETTING_NAME,
26: SETTING_VALUE,

Line 62: from BNE_USER_SETTINGS

58: X_SETTING_VALUE in VARCHAR2
59: ) is
60: cursor c1 is select
61: SETTING_VALUE
62: from BNE_USER_SETTINGS
63: where USER_ID = X_USER_ID
64: and SETTING_GROUP = X_SETTING_GROUP
65: and SETTING_NAME = X_SETTING_NAME
66: for update of USER_ID nowait;

Line 90: update BNE_USER_SETTINGS set

86: X_LAST_UPDATED_BY in NUMBER,
87: X_LAST_UPDATE_LOGIN in NUMBER
88: ) is
89: begin
90: update BNE_USER_SETTINGS set
91: SETTING_VALUE = X_SETTING_VALUE,
92: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
93: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
94: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 110: delete from BNE_USER_SETTINGS

106: X_SETTING_GROUP in VARCHAR2,
107: X_SETTING_NAME in VARCHAR2
108: ) is
109: begin
110: delete from BNE_USER_SETTINGS
111: where USER_ID = X_USER_ID
112: and SETTING_GROUP = X_SETTING_GROUP
113: and SETTING_NAME = X_SETTING_NAME;
114:

Line 130: -- DESCRIPTION: Load a row into the BNE_USER_SETTINGS entity. --

126:
127: --------------------------------------------------------------------------------
128: -- PROCEDURE: LOAD_ROW --
129: -- --
130: -- DESCRIPTION: Load a row into the BNE_USER_SETTINGS entity. --
131: -- This proc is called from the apps loader. --
132: -- --
133: -- SEE: http://www-apps.us.oracle.com/atg/plans/r115/fndloadqr.txt --
134: -- --

Line 171: from BNE_USER_SETTINGS

167: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
168: begin
169: select LAST_UPDATED_BY, LAST_UPDATE_DATE
170: into db_luby, db_ludate
171: from BNE_USER_SETTINGS
172: where USER_ID = l_user_id
173: and SETTING_GROUP = x_setting_group
174: and SETTING_NAME = x_setting_name;
175:

Line 180: BNE_USER_SETTINGS_PKG.Update_Row(

176: -- Test for customization and version
177: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
178: db_ludate, x_custom_mode)) then
179: -- Update existing row
180: BNE_USER_SETTINGS_PKG.Update_Row(
181: X_USER_ID => l_user_id,
182: X_SETTING_GROUP => x_setting_group,
183: X_SETTING_NAME => x_setting_name,
184: X_SETTING_VALUE => x_setting_value,

Line 193: BNE_USER_SETTINGS_PKG.Insert_Row(

189: end if;
190: exception
191: when no_data_found then
192: -- Record doesn't exist - insert in all cases
193: BNE_USER_SETTINGS_PKG.Insert_Row(
194: X_ROWID => l_row_id,
195: X_USER_ID => l_user_id,
196: X_SETTING_GROUP => x_setting_group,
197: X_SETTING_NAME => x_setting_name,

Line 208: end BNE_USER_SETTINGS_PKG;

204: );
205: end;
206: end LOAD_ROW;
207:
208: end BNE_USER_SETTINGS_PKG;