APPS.OZF_DENORM_QUERIES_PKG dependencies on OZF_DENORM_QUERIES

Line 1: package body OZF_DENORM_QUERIES_PKG as

1: package body OZF_DENORM_QUERIES_PKG as
2: /* $Header: ozflofdb.pls 120.0 2005/06/01 01:09:29 appldev noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID IN OUT NOCOPY VARCHAR2,

Line 30: cursor C is select ROWID from OZF_DENORM_QUERIES

26: X_SQL_VALIDATION_8 IN VARCHAR2,
27: X_OBJECT_VERSION_NUMBER IN NUMBER,
28: X_SECURITY_GROUP_ID IN NUMBER)
29: is
30: cursor C is select ROWID from OZF_DENORM_QUERIES
31: where DENORM_QUERY_ID = X_DENORM_QUERY_ID;
32: begin
33: insert into OZF_DENORM_QUERIES(
34: DENORM_QUERY_ID,

Line 33: insert into OZF_DENORM_QUERIES(

29: is
30: cursor C is select ROWID from OZF_DENORM_QUERIES
31: where DENORM_QUERY_ID = X_DENORM_QUERY_ID;
32: begin
33: insert into OZF_DENORM_QUERIES(
34: DENORM_QUERY_ID,
35: QUERY_FOR,
36: CONTEXT,
37: ATTRIBUTE,

Line 142: update OZF_DENORM_QUERIES set

138: X_OBJECT_VERSION_NUMBER IN NUMBER,
139: X_SECURITY_GROUP_ID IN NUMBER
140: ) is
141: begin
142: update OZF_DENORM_QUERIES set
143: QUERY_FOR = X_QUERY_FOR ,
144: CONTEXT = X_CONTEXT ,
145: ATTRIBUTE = X_ATTRIBUTE,
146: CONDITION_ID_COLUMN = X_CONDITION_ID_COLUMN,

Line 178: delete from OZF_DENORM_QUERIES

174: X_DENORM_QUERY_ID in NUMBER,
175: X_OBJECT_VERSION_NUMBER IN NUMBER
176: ) is
177: begin
178: delete from OZF_DENORM_QUERIES
179: where DENORM_QUERY_ID = X_DENORM_QUERY_ID
180: and object_version_number=X_OBJECT_VERSION_NUMBER;
181: if (sql%notfound) then
182: raise no_data_found;

Line 223: FROM ozf_denorm_queries

219: l_db_luby_id NUMBER;
220:
221: CURSOR c_db_luby_id IS
222: SELECT last_updated_by
223: FROM ozf_denorm_queries
224: WHERE denorm_query_id = X_DENORM_QUERY_ID;
225:
226:
227:

Line 230: from OZF_DENORM_QUERIES

226:
227:
228: cursor c_chk_denorm_exists is
229: select 'x'
230: from OZF_DENORM_QUERIES
231: where context= X_CONTEXT
232: AND attribute=X_ATTRIBUTE;
233:
234: cursor c_get_denorm_id is

Line 235: select OZF_DENORM_QUERIES_S.nextval

231: where context= X_CONTEXT
232: AND attribute=X_ATTRIBUTE;
233:
234: cursor c_get_denorm_id is
235: select OZF_DENORM_QUERIES_S.nextval
236: from dual;
237:
238: BEGIN
239:

Line 256: OZF_DENORM_QUERIES_PKG.INSERT_ROW(

252: ELSE
253: l_DENORM_QUERY_id := X_DENORM_QUERY_ID;
254: END IF;
255: --insert into jl_temp values(sysdate,l_user_id,FND_GLOBAL.CONC_LOGIN_ID,'I',l_DENORM_QUERY_id);
256: OZF_DENORM_QUERIES_PKG.INSERT_ROW(
257: X_ROWID => l_row_id,
258: X_DENORM_QUERY_ID => l_DENORM_QUERY_id,
259: X_QUERY_FOR => X_QUERY_FOR,
260: X_CONTEXT => X_CONTEXT,

Line 296: OZF_DENORM_QUERIES_PKG.UPDATE_ROW(

292: --CLOSE c_db_luby_id;
293: --insert into jl_temp values(sysdate,l_user_id,FND_GLOBAL.CONC_LOGIN_ID,'U',l_DENORM_QUERY_id);
294: --IF (l_db_luby_id IN (1,2,0) OR NVL(x_custom_mode,'PRESERVE') = 'FORCE') THEN
295: IF x_owner_name like 'ORACLE%' OR NVL(x_custom_mode,'PRESERVE') = 'FORCE' THEN
296: OZF_DENORM_QUERIES_PKG.UPDATE_ROW(
297: X_DENORM_QUERY_ID => l_denorm_query_id,
298: X_QUERY_FOR => X_QUERY_FOR,
299: X_CONTEXT => X_CONTEXT,
300: X_ATTRIBUTE => X_ATTRIBUTE,

Line 324: end OZF_DENORM_QUERIES_PKG;

320: END IF;
321: END LOAD_ROW;
322:
323:
324: end OZF_DENORM_QUERIES_PKG;