APPS.BNE_STORED_SQL_PKG dependencies on BNE_STORED_SQL

Line 1: package body BNE_STORED_SQL_PKG as

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

Line 18: cursor C is select ROWID from BNE_STORED_SQL

14: X_LAST_UPDATE_LOGIN in NUMBER,
15: X_QUERY_APP_ID in NUMBER,
16: X_QUERY_CODE in VARCHAR2
17: ) is
18: cursor C is select ROWID from BNE_STORED_SQL
19: where APPLICATION_ID = X_APPLICATION_ID
20: and CONTENT_CODE = X_CONTENT_CODE
21: ;
22: begin

Line 23: insert into BNE_STORED_SQL (

19: where APPLICATION_ID = X_APPLICATION_ID
20: and CONTENT_CODE = X_CONTENT_CODE
21: ;
22: begin
23: insert into BNE_STORED_SQL (
24: LAST_UPDATED_BY,
25: LAST_UPDATE_LOGIN,
26: LAST_UPDATE_DATE,
27: QUERY,

Line 72: from BNE_STORED_SQL

68: QUERY,
69: OBJECT_VERSION_NUMBER,
70: QUERY_APP_ID,
71: QUERY_CODE
72: from BNE_STORED_SQL
73: where APPLICATION_ID = X_APPLICATION_ID
74: and CONTENT_CODE = X_CONTENT_CODE
75: for update of APPLICATION_ID nowait;
76: begin

Line 106: update BNE_STORED_SQL set

102: X_QUERY_APP_ID in NUMBER,
103: X_QUERY_CODE in VARCHAR2
104: ) is
105: begin
106: update BNE_STORED_SQL set
107: QUERY = X_QUERY,
108: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
109: CONTENT_CODE = X_CONTENT_CODE,
110: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 128: delete from BNE_STORED_SQL

124: X_APPLICATION_ID in NUMBER,
125: X_CONTENT_CODE in VARCHAR2
126: ) is
127: begin
128: delete from BNE_STORED_SQL
129: where APPLICATION_ID = X_APPLICATION_ID
130: and CONTENT_CODE = X_CONTENT_CODE;
131:
132: if (sql%notfound) then

Line 147: -- DESCRIPTION: Load a row into the BNE_STORED_SQL entity. --

143:
144: --------------------------------------------------------------------------------
145: -- PROCEDURE: LOAD_ROW --
146: -- --
147: -- DESCRIPTION: Load a row into the BNE_STORED_SQL entity. --
148: -- This proc is called from the apps loader. --
149: -- --
150: -- SEE: http://www-apps.us.oracle.com/atg/plans/r115/fndloadqr.txt --
151: -- --

Line 189: from BNE_STORED_SQL

185: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
186: begin
187: select LAST_UPDATED_BY, LAST_UPDATE_DATE
188: into db_luby, db_ludate
189: from BNE_STORED_SQL
190: where APPLICATION_ID = l_app_id
191: and CONTENT_CODE = x_content_code;
192:
193: -- Test for customization and version

Line 197: BNE_STORED_SQL_PKG.Update_Row(

193: -- Test for customization and version
194: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
195: db_ludate, x_custom_mode)) then
196: -- Update existing row
197: BNE_STORED_SQL_PKG.Update_Row(
198: X_APPLICATION_ID => l_app_id,
199: X_CONTENT_CODE => x_content_code,
200: X_QUERY => x_query,
201: X_OBJECT_VERSION_NUMBER => x_object_version_number,

Line 212: BNE_STORED_SQL_PKG.Insert_Row(

208: end if;
209: exception
210: when no_data_found then
211: -- Record doesn't exist - insert in all cases
212: BNE_STORED_SQL_PKG.Insert_Row(
213: X_ROWID => l_row_id,
214: X_APPLICATION_ID => l_app_id,
215: X_CONTENT_CODE => x_content_code,
216: X_QUERY => x_query,

Line 229: end BNE_STORED_SQL_PKG;

225: );
226: end;
227: end LOAD_ROW;
228:
229: end BNE_STORED_SQL_PKG;