APPS.FND_PROFILE dependencies on FND_CACHE_VERSIONS_PKG

Line 171: FND_CACHE_VERSIONS_PKG.get_values;

167: **
168: ** This change will introduce a slight performance hit but should not
169: ** be as severe as the performance levels that bug 3901095 had.
170: */
171: FND_CACHE_VERSIONS_PKG.get_values;
172:
173: /*
174: ** Add cache(s) entries in FND_CACHE_VERSIONS if one does not exist.
175: ** If a cache exists however, we will check to see if there has been any

Line 178: if (FND_CACHE_VERSIONS_PKG.check_version(USER_CACHE,USER_CACHE_VERSION)

174: ** Add cache(s) entries in FND_CACHE_VERSIONS if one does not exist.
175: ** If a cache exists however, we will check to see if there has been any
176: ** changes within that profile level to refresh it (delete it).
177: */
178: if (FND_CACHE_VERSIONS_PKG.check_version(USER_CACHE,USER_CACHE_VERSION)
179: = FALSE) then
180: if (USER_CACHE_VERSION = -1) then
181: FND_CACHE_VERSIONS_PKG.add_cache_name(USER_CACHE);
182: USER_CACHE_VERSION := 0;

Line 181: FND_CACHE_VERSIONS_PKG.add_cache_name(USER_CACHE);

177: */
178: if (FND_CACHE_VERSIONS_PKG.check_version(USER_CACHE,USER_CACHE_VERSION)
179: = FALSE) then
180: if (USER_CACHE_VERSION = -1) then
181: FND_CACHE_VERSIONS_PKG.add_cache_name(USER_CACHE);
182: USER_CACHE_VERSION := 0;
183: else
184: USER_NAME_TAB.DELETE();
185: USER_VAL_TAB.DELETE();

Line 189: if (FND_CACHE_VERSIONS_PKG.check_version(RESP_CACHE,RESP_CACHE_VERSION)

185: USER_VAL_TAB.DELETE();
186: end if;
187: end if;
188:
189: if (FND_CACHE_VERSIONS_PKG.check_version(RESP_CACHE,RESP_CACHE_VERSION)
190: = FALSE) then
191: if (RESP_CACHE_VERSION = -1) then
192: FND_CACHE_VERSIONS_PKG.add_cache_name(RESP_CACHE);
193: RESP_CACHE_VERSION := 0;

Line 192: FND_CACHE_VERSIONS_PKG.add_cache_name(RESP_CACHE);

188:
189: if (FND_CACHE_VERSIONS_PKG.check_version(RESP_CACHE,RESP_CACHE_VERSION)
190: = FALSE) then
191: if (RESP_CACHE_VERSION = -1) then
192: FND_CACHE_VERSIONS_PKG.add_cache_name(RESP_CACHE);
193: RESP_CACHE_VERSION := 0;
194: else
195: RESP_NAME_TAB.DELETE();
196: RESP_VAL_TAB.DELETE();

Line 200: if (FND_CACHE_VERSIONS_PKG.check_version(APPL_CACHE,APPL_CACHE_VERSION)

196: RESP_VAL_TAB.DELETE();
197: end if;
198: end if;
199:
200: if (FND_CACHE_VERSIONS_PKG.check_version(APPL_CACHE,APPL_CACHE_VERSION)
201: = FALSE) then
202: if (APPL_CACHE_VERSION = -1) then
203: FND_CACHE_VERSIONS_PKG.add_cache_name(APPL_CACHE);
204: APPL_CACHE_VERSION := 0;

Line 203: FND_CACHE_VERSIONS_PKG.add_cache_name(APPL_CACHE);

199:
200: if (FND_CACHE_VERSIONS_PKG.check_version(APPL_CACHE,APPL_CACHE_VERSION)
201: = FALSE) then
202: if (APPL_CACHE_VERSION = -1) then
203: FND_CACHE_VERSIONS_PKG.add_cache_name(APPL_CACHE);
204: APPL_CACHE_VERSION := 0;
205: else
206: APPL_NAME_TAB.DELETE();
207: APPL_VAL_TAB.DELETE();

Line 211: if (FND_CACHE_VERSIONS_PKG.check_version(ORG_CACHE,ORG_CACHE_VERSION)

207: APPL_VAL_TAB.DELETE();
208: end if;
209: end if;
210:
211: if (FND_CACHE_VERSIONS_PKG.check_version(ORG_CACHE,ORG_CACHE_VERSION)
212: = FALSE) then
213: if (ORG_CACHE_VERSION = -1) then
214: FND_CACHE_VERSIONS_PKG.add_cache_name(ORG_CACHE);
215: ORG_CACHE_VERSION := 0;

Line 214: FND_CACHE_VERSIONS_PKG.add_cache_name(ORG_CACHE);

210:
211: if (FND_CACHE_VERSIONS_PKG.check_version(ORG_CACHE,ORG_CACHE_VERSION)
212: = FALSE) then
213: if (ORG_CACHE_VERSION = -1) then
214: FND_CACHE_VERSIONS_PKG.add_cache_name(ORG_CACHE);
215: ORG_CACHE_VERSION := 0;
216: else
217: ORG_NAME_TAB.DELETE();
218: ORG_VAL_TAB.DELETE();

Line 222: if (FND_CACHE_VERSIONS_PKG.check_version

218: ORG_VAL_TAB.DELETE();
219: end if;
220: end if;
221:
222: if (FND_CACHE_VERSIONS_PKG.check_version
223: (SERVER_CACHE, SERVER_CACHE_VERSION) = FALSE) then
224: if (SERVER_CACHE_VERSION = -1) then
225: FND_CACHE_VERSIONS_PKG.add_cache_name(SERVER_CACHE);
226: SERVER_CACHE_VERSION := 0;

Line 225: FND_CACHE_VERSIONS_PKG.add_cache_name(SERVER_CACHE);

221:
222: if (FND_CACHE_VERSIONS_PKG.check_version
223: (SERVER_CACHE, SERVER_CACHE_VERSION) = FALSE) then
224: if (SERVER_CACHE_VERSION = -1) then
225: FND_CACHE_VERSIONS_PKG.add_cache_name(SERVER_CACHE);
226: SERVER_CACHE_VERSION := 0;
227: else
228: SERVER_NAME_TAB.DELETE();
229: SERVER_VAL_TAB.DELETE();

Line 233: if (FND_CACHE_VERSIONS_PKG.check_version

229: SERVER_VAL_TAB.DELETE();
230: end if;
231: end if;
232:
233: if (FND_CACHE_VERSIONS_PKG.check_version
234: (SERVRESP_CACHE,SERVRESP_CACHE_VERSION) = FALSE) then
235: if (SERVRESP_CACHE_VERSION = -1) then
236: FND_CACHE_VERSIONS_PKG.add_cache_name(SERVRESP_CACHE);
237: SERVRESP_CACHE_VERSION := 0;

Line 236: FND_CACHE_VERSIONS_PKG.add_cache_name(SERVRESP_CACHE);

232:
233: if (FND_CACHE_VERSIONS_PKG.check_version
234: (SERVRESP_CACHE,SERVRESP_CACHE_VERSION) = FALSE) then
235: if (SERVRESP_CACHE_VERSION = -1) then
236: FND_CACHE_VERSIONS_PKG.add_cache_name(SERVRESP_CACHE);
237: SERVRESP_CACHE_VERSION := 0;
238: else
239: SERVRESP_NAME_TAB.DELETE();
240: SERVRESP_VAL_TAB.DELETE();

Line 244: if (FND_CACHE_VERSIONS_PKG.check_version(SITE_CACHE,SITE_CACHE_VERSION)

240: SERVRESP_VAL_TAB.DELETE();
241: end if;
242: end if;
243:
244: if (FND_CACHE_VERSIONS_PKG.check_version(SITE_CACHE,SITE_CACHE_VERSION)
245: = FALSE) then
246: if (SITE_CACHE_VERSION = -1) then
247: FND_CACHE_VERSIONS_PKG.add_cache_name(SITE_CACHE);
248: SITE_CACHE_VERSION := 0;

Line 247: FND_CACHE_VERSIONS_PKG.add_cache_name(SITE_CACHE);

243:
244: if (FND_CACHE_VERSIONS_PKG.check_version(SITE_CACHE,SITE_CACHE_VERSION)
245: = FALSE) then
246: if (SITE_CACHE_VERSION = -1) then
247: FND_CACHE_VERSIONS_PKG.add_cache_name(SITE_CACHE);
248: SITE_CACHE_VERSION := 0;
249: else
250: SITE_NAME_TAB.DELETE();
251: SITE_VAL_TAB.DELETE();

Line 4189: FND_CACHE_VERSIONS_PKG.bump_version(l_cache_name);

4185: return 'ERROR';
4186: end if;
4187:
4188: -- Bump cache version using the appropriate cache name
4189: FND_CACHE_VERSIONS_PKG.bump_version(l_cache_name);
4190: return 'SUCCESS';
4191:
4192: exception
4193: when others then