APPS.OZF_DENORM_QUERIES_PKG dependencies on FND_GLOBAL

Line 255: --insert into jl_temp values(sysdate,l_user_id,FND_GLOBAL.CONC_LOGIN_ID,'I',l_DENORM_QUERY_id);

251: close c_get_denorm_id;
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,

Line 269: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,

265: X_CREATION_DATE => SYSDATE,
266: X_CREATED_BY => l_user_id,
267: X_LAST_UPDATE_DATE => SYSDATE,
268: X_LAST_UPDATED_BY => l_user_id,
269: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
270: X_SEEDED_FLAG => X_SEEDED_FLAG,
271: X_SQL_VALIDATION_1 => X_SQL_VALIDATION_1,
272: X_SQL_VALIDATION_2 => X_SQL_VALIDATION_2,
273: X_SQL_VALIDATION_3 => X_SQL_VALIDATION_3,

Line 293: --insert into jl_temp values(sysdate,l_user_id,FND_GLOBAL.CONC_LOGIN_ID,'U',l_DENORM_QUERY_id);

289:
290: --OPEN c_db_luby_id;
291: --FETCH c_db_luby_id INTO l_db_luby_id;
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,

Line 306: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,

302: X_CONDITION_NAME_COLUMN => X_CONDITION_NAME_COLUMN,
303: X_ACTIVE_FLAG => X_ACTIVE_FLAG,
304: X_LAST_UPDATE_DATE => SYSDATE,
305: X_LAST_UPDATED_BY => l_user_id,
306: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
307: X_SEEDED_FLAG => X_SEEDED_FLAG,
308: X_SQL_VALIDATION_1 => X_SQL_VALIDATION_1,
309: X_SQL_VALIDATION_2 => X_SQL_VALIDATION_2,
310: X_SQL_VALIDATION_3 => X_SQL_VALIDATION_3,