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;
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 := '';
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:
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;
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:
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
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 := '';
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:
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;
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;
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:
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 := '';
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:
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;
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:
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
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 := '';
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:
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;
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:
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
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 := '';
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:
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;
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:
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
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 := '';
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:
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;
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:
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
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 := '';
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:
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;
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:
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
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 := '';
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:
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;
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:
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
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 := '';
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:
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;
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:
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
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 := '';
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:
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;
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:
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
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 := '';
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:
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;
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:
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
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 := '';
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:
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;
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:
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
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 := '';
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:
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;
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:
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
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 := '';
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:
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;
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:
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
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 := '';
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:
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;
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:
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
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 := '';
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:
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;
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:
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
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