APPS.BNE_FLEX_OVERRIDES_PKG dependencies on BNE_FLEX_OVERRIDES

Line 1: package body BNE_FLEX_OVERRIDES_PKG as

1: package body BNE_FLEX_OVERRIDES_PKG as
2: /* $Header: bneflexoverb.pls 120.2 2005/06/29 03:39:58 dvayro noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 16: cursor C is select ROWID from BNE_FLEX_OVERRIDES

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_FLEX_OVERRIDES
17: where OA_FLEX_APPLICATION_ID = X_OA_FLEX_APPLICATION_ID
18: and OA_FLEX_CODE = X_OA_FLEX_CODE
19: and OA_FLEX_NUM = X_OA_FLEX_NUM
20: ;

Line 22: insert into BNE_FLEX_OVERRIDES (

18: and OA_FLEX_CODE = X_OA_FLEX_CODE
19: and OA_FLEX_NUM = X_OA_FLEX_NUM
20: ;
21: begin
22: insert into BNE_FLEX_OVERRIDES (
23: OA_FLEX_APPLICATION_ID,
24: OA_FLEX_CODE,
25: OA_FLEX_NUM,
26: OBJECT_VERSION_NUMBER,

Line 62: from BNE_FLEX_OVERRIDES

58: X_OBJECT_VERSION_NUMBER in NUMBER
59: ) is
60: cursor c1 is select
61: OBJECT_VERSION_NUMBER
62: from BNE_FLEX_OVERRIDES
63: where OA_FLEX_APPLICATION_ID = X_OA_FLEX_APPLICATION_ID
64: and OA_FLEX_CODE = X_OA_FLEX_CODE
65: and OA_FLEX_NUM = X_OA_FLEX_NUM
66: for update of OA_FLEX_APPLICATION_ID nowait;

Line 90: update BNE_FLEX_OVERRIDES set

86: X_LAST_UPDATED_BY in NUMBER,
87: X_LAST_UPDATE_LOGIN in NUMBER
88: ) is
89: begin
90: update BNE_FLEX_OVERRIDES set
91: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
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 111: delete from BNE_FLEX_OVERRIDES

107: X_OA_FLEX_CODE in VARCHAR2,
108: X_OA_FLEX_NUM in NUMBER
109: ) is
110: begin
111: delete from BNE_FLEX_OVERRIDES
112: where OA_FLEX_APPLICATION_ID = X_OA_FLEX_APPLICATION_ID
113: and OA_FLEX_CODE = X_OA_FLEX_CODE
114: and OA_FLEX_NUM = X_OA_FLEX_NUM;
115:

Line 132: -- DESCRIPTION: Load a row into the BNE_FLEX_OVERRIDES entity. --

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

Line 170: from BNE_FLEX_OVERRIDES

166: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
167: begin
168: select LAST_UPDATED_BY, LAST_UPDATE_DATE
169: into db_luby, db_ludate
170: from BNE_FLEX_OVERRIDES
171: where OA_FLEX_APPLICATION_ID = l_app_id
172: and OA_FLEX_CODE = x_oa_flex_code
173: and OA_FLEX_NUM = x_oa_flex_num
174: ;

Line 180: BNE_FLEX_OVERRIDES_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_FLEX_OVERRIDES_PKG.Update_Row(
181: X_OA_FLEX_APPLICATION_ID => l_app_id,
182: X_OA_FLEX_CODE => x_oa_flex_code,
183: X_OA_FLEX_NUM => x_oa_flex_num,
184: X_OBJECT_VERSION_NUMBER => x_object_version_number,

Line 193: BNE_FLEX_OVERRIDES_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_FLEX_OVERRIDES_PKG.Insert_Row(
194: X_ROWID => l_row_id,
195: X_OA_FLEX_APPLICATION_ID => l_app_id,
196: X_OA_FLEX_CODE => x_oa_flex_code,
197: X_OA_FLEX_NUM => x_oa_flex_num,

Line 208: end BNE_FLEX_OVERRIDES_PKG;

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