eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_CF_UPG_UTL_PKG dependencies on FND_PROFILE_OPTION_VALUES

Line 10: FROM fnd_profile_options a, fnd_profile_option_values b

6: b.level_id,
7: b.level_value,
8: b.level_value_application_id,
9: b.profile_option_value
10: FROM fnd_profile_options a, fnd_profile_option_values b
11: where a.profile_option_name = p_profile_option_name
12: and a.profile_option_id = b.profile_option_id
13: and a.application_id = b.application_id
14: order by b.level_id;

Line 38: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;

34: p_siteProfilesTable IN OUT NOCOPY ProfileTable)
35: RETURN BOOLEAN
36: IS
37:
38: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
39: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
40: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
41: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
42: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

Line 39: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;

35: RETURN BOOLEAN
36: IS
37:
38: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
39: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
40: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
41: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
42: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
43:

Line 40: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;

36: IS
37:
38: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
39: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
40: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
41: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
42: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
43:
44: l_upgrade_required BOOLEAN := FALSE;

Line 41: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;

37:
38: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
39: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
40: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
41: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
42: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
43:
44: l_upgrade_required BOOLEAN := FALSE;
45:

Line 42: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

38: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
39: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
40: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
41: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
42: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
43:
44: l_upgrade_required BOOLEAN := FALSE;
45:
46: BEGIN

Line 123: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;

119: p_siteProfilesTable IN OUT NOCOPY ProfileTable)
120: RETURN BOOLEAN
121: IS
122:
123: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
124: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
125: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
126: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
127: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

Line 124: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;

120: RETURN BOOLEAN
121: IS
122:
123: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
124: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
125: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
126: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
127: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
128:

Line 125: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;

121: IS
122:
123: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
124: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
125: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
126: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
127: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
128:
129: l_upgrade_required BOOLEAN := FALSE;

Line 126: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;

122:
123: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
124: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
125: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
126: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
127: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
128:
129: l_upgrade_required BOOLEAN := FALSE;
130: l_count NUMBER := 0;

Line 127: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

123: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
124: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
125: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
126: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
127: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
128:
129: l_upgrade_required BOOLEAN := FALSE;
130: l_count NUMBER := 0;
131:

Line 225: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;

221: p_siteProfilesTable IN OUT NOCOPY ProfileTable)
222: RETURN BOOLEAN
223: IS
224:
225: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
226: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
227: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
228: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
229: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

Line 226: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;

222: RETURN BOOLEAN
223: IS
224:
225: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
226: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
227: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
228: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
229: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
230:

Line 227: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;

223: IS
224:
225: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
226: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
227: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
228: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
229: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
230:
231: l_upgrade_required BOOLEAN := FALSE;

Line 228: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;

224:
225: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
226: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
227: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
228: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
229: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
230:
231: l_upgrade_required BOOLEAN := FALSE;
232:

Line 229: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

225: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
226: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
227: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
228: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
229: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
230:
231: l_upgrade_required BOOLEAN := FALSE;
232:
233: BEGIN

Line 306: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;

302: p_siteProfilesTable IN OUT NOCOPY ProfileTable)
303: RETURN BOOLEAN
304: IS
305:
306: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
307: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
308: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
309: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
310: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

Line 307: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;

303: RETURN BOOLEAN
304: IS
305:
306: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
307: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
308: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
309: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
310: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
311:

Line 308: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;

304: IS
305:
306: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
307: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
308: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
309: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
310: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
311:
312: l_upgrade_required BOOLEAN := FALSE;

Line 309: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;

305:
306: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
307: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
308: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
309: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
310: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
311:
312: l_upgrade_required BOOLEAN := FALSE;
313:

Line 310: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

306: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
307: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
308: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
309: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
310: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
311:
312: l_upgrade_required BOOLEAN := FALSE;
313:
314: BEGIN

Line 387: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;

383: p_siteProfilesTable IN OUT NOCOPY ProfileTable)
384: RETURN BOOLEAN
385: IS
386:
387: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
388: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
389: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
390: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
391: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

Line 388: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;

384: RETURN BOOLEAN
385: IS
386:
387: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
388: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
389: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
390: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
391: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
392:

Line 389: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;

385: IS
386:
387: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
388: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
389: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
390: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
391: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
392:
393: l_upgrade_required BOOLEAN := FALSE;

Line 390: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;

386:
387: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
388: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
389: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
390: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
391: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
392:
393: l_upgrade_required BOOLEAN := FALSE;
394:

Line 391: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

387: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
388: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
389: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
390: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
391: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
392:
393: l_upgrade_required BOOLEAN := FALSE;
394:
395: BEGIN

Line 468: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;

464: p_siteProfilesTable IN OUT NOCOPY ProfileTable)
465: RETURN BOOLEAN
466: IS
467:
468: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
469: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
470: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
471: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
472: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

Line 469: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;

465: RETURN BOOLEAN
466: IS
467:
468: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
469: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
470: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
471: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
472: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
473:

Line 470: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;

466: IS
467:
468: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
469: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
470: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
471: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
472: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
473:
474: l_upgrade_required BOOLEAN := FALSE;

Line 471: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;

467:
468: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
469: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
470: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
471: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
472: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
473:
474: l_upgrade_required BOOLEAN := FALSE;
475:

Line 472: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

468: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
469: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
470: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
471: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
472: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
473:
474: l_upgrade_required BOOLEAN := FALSE;
475:
476: BEGIN

Line 550: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;

546: p_siteProfilesTable IN OUT NOCOPY ProfileTable)
547: RETURN BOOLEAN
548: IS
549:
550: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
551: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
552: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
553: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
554: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

Line 551: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;

547: RETURN BOOLEAN
548: IS
549:
550: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
551: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
552: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
553: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
554: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
555:

Line 552: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;

548: IS
549:
550: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
551: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
552: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
553: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
554: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
555:
556: l_upgrade_required BOOLEAN := FALSE;

Line 553: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;

549:
550: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
551: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
552: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
553: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
554: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
555:
556: l_upgrade_required BOOLEAN := FALSE;
557:

Line 554: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

550: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
551: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
552: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
553: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
554: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
555:
556: l_upgrade_required BOOLEAN := FALSE;
557:
558: BEGIN

Line 632: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;

628: p_siteProfilesTable IN OUT NOCOPY ProfileTable)
629: RETURN BOOLEAN
630: IS
631:
632: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
633: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
634: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
635: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
636: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

Line 633: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;

629: RETURN BOOLEAN
630: IS
631:
632: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
633: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
634: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
635: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
636: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
637:

Line 634: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;

630: IS
631:
632: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
633: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
634: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
635: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
636: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
637:
638: l_upgrade_required BOOLEAN := FALSE;

Line 635: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;

631:
632: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
633: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
634: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
635: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
636: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
637:
638: l_upgrade_required BOOLEAN := FALSE;
639:

Line 636: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

632: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
633: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
634: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
635: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
636: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
637:
638: l_upgrade_required BOOLEAN := FALSE;
639:
640: BEGIN

Line 716: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;

712: p_siteProfilesTable IN OUT NOCOPY ProfileTable)
713: RETURN BOOLEAN
714: IS
715:
716: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
717: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
718: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
719: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
720: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

Line 717: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;

713: RETURN BOOLEAN
714: IS
715:
716: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
717: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
718: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
719: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
720: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
721:

Line 718: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;

714: IS
715:
716: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
717: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
718: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
719: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
720: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
721:
722: l_upgrade_required BOOLEAN := FALSE;

Line 719: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;

715:
716: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
717: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
718: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
719: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
720: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
721:
722: l_upgrade_required BOOLEAN := FALSE;
723:

Line 720: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

716: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
717: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
718: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
719: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
720: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
721:
722: l_upgrade_required BOOLEAN := FALSE;
723:
724: BEGIN

Line 800: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;

796: p_siteProfilesTable IN OUT NOCOPY ProfileTable)
797: RETURN BOOLEAN
798: IS
799:
800: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
801: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
802: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
803: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
804: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

Line 801: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;

797: RETURN BOOLEAN
798: IS
799:
800: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
801: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
802: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
803: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
804: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
805:

Line 802: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;

798: IS
799:
800: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
801: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
802: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
803: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
804: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
805:
806: l_upgrade_required BOOLEAN := FALSE;

Line 803: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;

799:
800: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
801: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
802: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
803: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
804: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
805:
806: l_upgrade_required BOOLEAN := FALSE;
807:

Line 804: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

800: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
801: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
802: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
803: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
804: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
805:
806: l_upgrade_required BOOLEAN := FALSE;
807:
808: BEGIN

Line 885: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;

881: p_siteProfilesTable IN OUT NOCOPY ProfileTable)
882: RETURN BOOLEAN
883: IS
884:
885: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
886: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
887: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
888: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
889: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

Line 886: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;

882: RETURN BOOLEAN
883: IS
884:
885: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
886: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
887: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
888: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
889: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
890:

Line 887: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;

883: IS
884:
885: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
886: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
887: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
888: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
889: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
890:
891: l_upgrade_required BOOLEAN := FALSE;

Line 888: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;

884:
885: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
886: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
887: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
888: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
889: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
890:
891: l_upgrade_required BOOLEAN := FALSE;
892:

Line 889: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

885: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
886: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
887: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
888: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
889: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
890:
891: l_upgrade_required BOOLEAN := FALSE;
892:
893: BEGIN

Line 969: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;

965: p_siteProfilesTable IN OUT NOCOPY ProfileTable)
966: RETURN BOOLEAN
967: IS
968:
969: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
970: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
971: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
972: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
973: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

Line 970: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;

966: RETURN BOOLEAN
967: IS
968:
969: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
970: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
971: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
972: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
973: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
974:

Line 971: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;

967: IS
968:
969: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
970: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
971: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
972: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
973: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
974:
975: l_upgrade_required BOOLEAN := FALSE;

Line 972: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;

968:
969: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
970: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
971: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
972: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
973: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
974:
975: l_upgrade_required BOOLEAN := FALSE;
976:

Line 973: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

969: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
970: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
971: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
972: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
973: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
974:
975: l_upgrade_required BOOLEAN := FALSE;
976:
977: BEGIN

Line 1049: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;

1045: p_siteProfilesTable IN OUT NOCOPY ProfileTable)
1046: RETURN BOOLEAN
1047: IS
1048:
1049: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
1050: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
1051: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
1052: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
1053: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

Line 1050: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;

1046: RETURN BOOLEAN
1047: IS
1048:
1049: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
1050: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
1051: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
1052: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
1053: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1054:

Line 1051: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;

1047: IS
1048:
1049: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
1050: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
1051: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
1052: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
1053: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1054:
1055: l_upgrade_required BOOLEAN := FALSE;

Line 1052: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;

1048:
1049: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
1050: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
1051: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
1052: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
1053: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1054:
1055: l_upgrade_required BOOLEAN := FALSE;
1056:

Line 1053: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

1049: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
1050: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
1051: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
1052: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
1053: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1054:
1055: l_upgrade_required BOOLEAN := FALSE;
1056:
1057: BEGIN

Line 1132: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;

1128: p_siteProfilesTable IN OUT NOCOPY ProfileTable)
1129: RETURN BOOLEAN
1130: IS
1131:
1132: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
1133: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
1134: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
1135: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
1136: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

Line 1133: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;

1129: RETURN BOOLEAN
1130: IS
1131:
1132: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
1133: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
1134: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
1135: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
1136: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1137:

Line 1134: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;

1130: IS
1131:
1132: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
1133: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
1134: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
1135: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
1136: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1137:
1138: l_upgrade_required BOOLEAN := FALSE;

Line 1135: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;

1131:
1132: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
1133: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
1134: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
1135: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
1136: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1137:
1138: l_upgrade_required BOOLEAN := FALSE;
1139:

Line 1136: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

1132: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
1133: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
1134: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
1135: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
1136: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1137:
1138: l_upgrade_required BOOLEAN := FALSE;
1139:
1140: BEGIN

Line 1213: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;

1209: p_siteProfilesTable IN OUT NOCOPY ProfileTable)
1210: RETURN BOOLEAN
1211: IS
1212:
1213: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
1214: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
1215: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
1216: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
1217: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

Line 1214: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;

1210: RETURN BOOLEAN
1211: IS
1212:
1213: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
1214: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
1215: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
1216: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
1217: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1218:

Line 1215: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;

1211: IS
1212:
1213: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
1214: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
1215: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
1216: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
1217: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1218:
1219: l_upgrade_required BOOLEAN := FALSE;

Line 1216: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;

1212:
1213: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
1214: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
1215: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
1216: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
1217: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1218:
1219: l_upgrade_required BOOLEAN := FALSE;
1220:

Line 1217: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

1213: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
1214: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
1215: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
1216: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
1217: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1218:
1219: l_upgrade_required BOOLEAN := FALSE;
1220:
1221: BEGIN

Line 1293: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;

1289: p_siteProfilesTable IN OUT NOCOPY ProfileTable)
1290: RETURN BOOLEAN
1291: IS
1292:
1293: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
1294: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
1295: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
1296: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
1297: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

Line 1294: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;

1290: RETURN BOOLEAN
1291: IS
1292:
1293: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
1294: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
1295: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
1296: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
1297: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1298:

Line 1295: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;

1291: IS
1292:
1293: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
1294: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
1295: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
1296: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
1297: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1298:
1299: l_upgrade_required BOOLEAN := FALSE;

Line 1296: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;

1292:
1293: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
1294: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
1295: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
1296: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
1297: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1298:
1299: l_upgrade_required BOOLEAN := FALSE;
1300:

Line 1297: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';

1293: l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
1294: l_level_id FND_PROFILE_OPTION_VALUES.level_id%TYPE := 0;
1295: l_level_value FND_PROFILE_OPTION_VALUES.level_value%TYPE := 0;
1296: l_level_value_appl_id FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE := 0;
1297: l_profile_option_value FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE := '';
1298:
1299: l_upgrade_required BOOLEAN := FALSE;
1300:
1301: BEGIN

Line 2623: FROM fnd_profile_options a, fnd_profile_option_values b

2619: FUNCTION configProfileCustomized RETURN BOOLEAN IS
2620:
2621: CURSOR l_cur IS
2622: SELECT b.last_updated_by
2623: FROM fnd_profile_options a, fnd_profile_option_values b
2624: WHERE a.profile_option_id = b.profile_option_id
2625: AND a.profile_option_name = 'IBU_REGION_FIELD_CONFIG_OPTION'
2626: AND B.LEVEL_ID = 10001
2627: AND A.APPLICATION_ID = 672