APPS.CN_UPGRADE_UTL_PKG dependencies on FND_PROFILE_OPTION_VALUES

Line 77: v_cn_upgrading_profile fnd_profile_option_values.profile_option_value%TYPE;

73: --| ---------------------------------------------------------------------+
74:
75: FUNCTION is_release_11510 RETURN NUMBER IS
76: l_result NUMBER := -1;
77: v_cn_upgrading_profile fnd_profile_option_values.profile_option_value%TYPE;
78: CURSOR c1 IS
79: SELECT profile_option_value
80: from fnd_profile_option_values
81: where profile_option_id =

Line 80: from fnd_profile_option_values

76: l_result NUMBER := -1;
77: v_cn_upgrading_profile fnd_profile_option_values.profile_option_value%TYPE;
78: CURSOR c1 IS
79: SELECT profile_option_value
80: from fnd_profile_option_values
81: where profile_option_id =
82: (select profile_option_id
83: from fnd_profile_options
84: where upper(profile_option_name) = 'CN_UPGRADING_FROM_RELEASE'

Line 129: v_cn_upgrading_profile fnd_profile_option_values.profile_option_value%TYPE;

125: --| ---------------------------------------------------------------------+
126:
127: FUNCTION is_release_115 RETURN NUMBER IS
128: l_result NUMBER := -1;
129: v_cn_upgrading_profile fnd_profile_option_values.profile_option_value%TYPE;
130: CURSOR c1 IS
131: SELECT profile_option_value
132: from fnd_profile_option_values
133: where profile_option_id =

Line 132: from fnd_profile_option_values

128: l_result NUMBER := -1;
129: v_cn_upgrading_profile fnd_profile_option_values.profile_option_value%TYPE;
130: CURSOR c1 IS
131: SELECT profile_option_value
132: from fnd_profile_option_values
133: where profile_option_id =
134: (select profile_option_id
135: from fnd_profile_options
136: where upper(profile_option_name) = 'CN_UPGRADING_FROM_RELEASE'

Line 181: v_cn_upgrading_profile fnd_profile_option_values.profile_option_value%TYPE;

177: --| ---------------------------------------------------------------------+
178:
179: FUNCTION is_release_107 RETURN NUMBER IS
180: l_result NUMBER := -1;
181: v_cn_upgrading_profile fnd_profile_option_values.profile_option_value%TYPE;
182: CURSOR c1 IS
183: SELECT profile_option_value
184: from fnd_profile_option_values
185: where profile_option_id =

Line 184: from fnd_profile_option_values

180: l_result NUMBER := -1;
181: v_cn_upgrading_profile fnd_profile_option_values.profile_option_value%TYPE;
182: CURSOR c1 IS
183: SELECT profile_option_value
184: from fnd_profile_option_values
185: where profile_option_id =
186: (select profile_option_id
187: from fnd_profile_options
188: where upper(profile_option_name) = 'CN_UPGRADING_FROM_RELEASE'

Line 233: v_cn_upgrading_profile fnd_profile_option_values.profile_option_value%TYPE;

229: --| ---------------------------------------------------------------------+
230:
231: FUNCTION is_release_110 RETURN NUMBER IS
232: l_result NUMBER := -1;
233: v_cn_upgrading_profile fnd_profile_option_values.profile_option_value%TYPE;
234: CURSOR c1 IS
235: SELECT profile_option_value
236: from fnd_profile_option_values
237: where profile_option_id =

Line 236: from fnd_profile_option_values

232: l_result NUMBER := -1;
233: v_cn_upgrading_profile fnd_profile_option_values.profile_option_value%TYPE;
234: CURSOR c1 IS
235: SELECT profile_option_value
236: from fnd_profile_option_values
237: where profile_option_id =
238: (select profile_option_id
239: from fnd_profile_options
240: where upper(profile_option_name) = 'CN_UPGRADING_FROM_RELEASE'

Line 285: v_cn_upgrading_profile fnd_profile_option_values.profile_option_value%TYPE;

281: --| ---------------------------------------------------------------------+
282:
283: FUNCTION is_release_3i RETURN NUMBER IS
284: l_result NUMBER := -1;
285: v_cn_upgrading_profile fnd_profile_option_values.profile_option_value%TYPE;
286: CURSOR c1 IS
287: SELECT profile_option_value
288: from fnd_profile_option_values
289: where profile_option_id =

Line 288: from fnd_profile_option_values

284: l_result NUMBER := -1;
285: v_cn_upgrading_profile fnd_profile_option_values.profile_option_value%TYPE;
286: CURSOR c1 IS
287: SELECT profile_option_value
288: from fnd_profile_option_values
289: where profile_option_id =
290: (select profile_option_id
291: from fnd_profile_options
292: where upper(profile_option_name) = 'CN_UPGRADING_FROM_RELEASE'

Line 330: v_cn_upgrading_profile fnd_profile_option_values.profile_option_value%TYPE;

326:
327:
328: FUNCTION is_release_120 RETURN NUMBER IS
329: l_result NUMBER := -1;
330: v_cn_upgrading_profile fnd_profile_option_values.profile_option_value%TYPE;
331: CURSOR c1 IS
332: SELECT profile_option_value
333: from fnd_profile_option_values
334: where profile_option_id =

Line 333: from fnd_profile_option_values

329: l_result NUMBER := -1;
330: v_cn_upgrading_profile fnd_profile_option_values.profile_option_value%TYPE;
331: CURSOR c1 IS
332: SELECT profile_option_value
333: from fnd_profile_option_values
334: where profile_option_id =
335: (select profile_option_id
336: from fnd_profile_options
337: where profile_option_name = 'CN_UPGRADING_FROM_RELEASE'

Line 372: v_cn_upgrading_profile fnd_profile_option_values.profile_option_value%TYPE;

368:
369:
370: FUNCTION is_release_121 RETURN NUMBER IS
371: l_result NUMBER := -1;
372: v_cn_upgrading_profile fnd_profile_option_values.profile_option_value%TYPE;
373: CURSOR c1 IS
374: SELECT profile_option_value
375: from fnd_profile_option_values
376: where profile_option_id =

Line 375: from fnd_profile_option_values

371: l_result NUMBER := -1;
372: v_cn_upgrading_profile fnd_profile_option_values.profile_option_value%TYPE;
373: CURSOR c1 IS
374: SELECT profile_option_value
375: from fnd_profile_option_values
376: where profile_option_id =
377: (select profile_option_id
378: from fnd_profile_options
379: where profile_option_name = 'CN_UPGRADING_FROM_RELEASE'