APPS.BNE_SIMPLE_QUERY_PKG dependencies on BNE_SIMPLE_QUERY

Line 1: package body BNE_SIMPLE_QUERY_PKG as

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

Line 25: cursor C is select ROWID from BNE_SIMPLE_QUERY

21: X_LAST_UPDATE_DATE in DATE,
22: X_LAST_UPDATED_BY in NUMBER,
23: X_LAST_UPDATE_LOGIN in NUMBER
24: ) is
25: cursor C is select ROWID from BNE_SIMPLE_QUERY
26: where APPLICATION_ID = X_APPLICATION_ID
27: and QUERY_CODE = X_QUERY_CODE
28: ;
29: begin

Line 30: insert into BNE_SIMPLE_QUERY (

26: where APPLICATION_ID = X_APPLICATION_ID
27: and QUERY_CODE = X_QUERY_CODE
28: ;
29: begin
30: insert into BNE_SIMPLE_QUERY (
31: APPLICATION_ID,
32: QUERY_CODE,
33: OBJECT_VERSION_NUMBER,
34: ID_COL,

Line 107: from BNE_SIMPLE_QUERY

103: ADDITIONAL_COLS,
104: OBJECT_NAME,
105: ADDITIONAL_WHERE_CLAUSE,
106: ORDER_BY_CLAUSE
107: from BNE_SIMPLE_QUERY
108: where APPLICATION_ID = X_APPLICATION_ID
109: and QUERY_CODE = X_QUERY_CODE
110: for update of APPLICATION_ID nowait;
111: begin

Line 158: update BNE_SIMPLE_QUERY set

154: X_LAST_UPDATED_BY in NUMBER,
155: X_LAST_UPDATE_LOGIN in NUMBER
156: ) is
157: begin
158: update BNE_SIMPLE_QUERY set
159: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
160: ID_COL = X_ID_COL,
161: ID_COL_ALIAS = X_ID_COL_ALIAS,
162: MEANING_COL = X_MEANING_COL,

Line 186: delete from BNE_SIMPLE_QUERY

182: X_APPLICATION_ID in NUMBER,
183: X_QUERY_CODE in VARCHAR2
184: ) is
185: begin
186: delete from BNE_SIMPLE_QUERY
187: where APPLICATION_ID = X_APPLICATION_ID
188: and QUERY_CODE = X_QUERY_CODE;
189:
190: if (sql%notfound) then

Line 205: -- DESCRIPTION: Load a row into the BNE_SIMPLE_QUERY entity. --

201:
202: --------------------------------------------------------------------------------
203: -- PROCEDURE: LOAD_ROW --
204: -- --
205: -- DESCRIPTION: Load a row into the BNE_SIMPLE_QUERY entity. --
206: -- This proc is called from the apps loader. --
207: -- --
208: -- SEE: http://www-apps.us.oracle.com/atg/plans/r115/fndloadqr.txt --
209: -- --

Line 252: from BNE_SIMPLE_QUERY

248: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
249: begin
250: select LAST_UPDATED_BY, LAST_UPDATE_DATE
251: into db_luby, db_ludate
252: from BNE_SIMPLE_QUERY
253: where APPLICATION_ID = l_app_id
254: and QUERY_CODE = x_query_code;
255:
256: -- Test for customization and version

Line 260: BNE_SIMPLE_QUERY_PKG.Update_Row(

256: -- Test for customization and version
257: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
258: db_ludate, x_custom_mode)) then
259: -- Update existing row
260: BNE_SIMPLE_QUERY_PKG.Update_Row(
261: X_APPLICATION_ID => l_app_id,
262: X_QUERY_CODE => x_query_code,
263: X_OBJECT_VERSION_NUMBER => x_object_version_number,
264: X_ID_COL => x_id_col,

Line 283: BNE_SIMPLE_QUERY_PKG.Insert_Row(

279: end if;
280: exception
281: when no_data_found then
282: -- Record doesn't exist - insert in all cases
283: BNE_SIMPLE_QUERY_PKG.Insert_Row(
284: X_ROWID => l_row_id,
285: X_APPLICATION_ID => l_app_id,
286: X_QUERY_CODE => x_query_code,
287: X_OBJECT_VERSION_NUMBER => x_object_version_number,

Line 308: end BNE_SIMPLE_QUERY_PKG;

304: end;
305: end LOAD_ROW;
306:
307:
308: end BNE_SIMPLE_QUERY_PKG;