33: BEGIN
34: hr_utility.set_location('Entering:'|| l_proc, 10);
35:
36: l_user_name := upper(per_ri_config_utilities.return_config_entity_name_pre
37: (per_ri_config_main.g_configuration_user_name));
38:
39: hr_utility.trace('l_user_name = ' || l_user_name);
40: open csr_find_user(l_user_name);
41: fetch csr_find_user into l_user_id;
43: if NOT (p_technical_summary_mode) then
44: if csr_find_user%NOTFOUND then
45: fnd_user_pkg.createuser(
46: x_user_name => upper(per_ri_config_utilities.return_config_entity_name_pre
47: (per_ri_config_main.g_configuration_user_name)),
48:
49: x_start_date => per_ri_config_fnd_def_entity.g_config_effective_date,
50: x_owner => 'CUST',
51: x_unencrypted_password => 'welcome' );
50: x_owner => 'CUST',
51: x_unencrypted_password => 'welcome' );
52:
53: l_log_message := 'Created User ' || upper(per_ri_config_utilities.return_config_entity_name_pre
54: (per_ri_config_main.g_configuration_user_name));
55: per_ri_config_utilities.write_log(p_message => l_log_message);
56: hr_utility.set_location(l_proc, 20);
57: else
58: l_log_message := 'User Already Existing ';
60: hr_utility.set_location(l_proc, 30);
61: end if;
62: else
63: p_user_tab(l_users_count).user_name := upper(per_ri_config_utilities.return_config_entity_name_pre
64: (per_ri_config_main.g_configuration_user_name));
65: p_user_tab(l_users_count).start_date := per_ri_config_fnd_def_entity.g_config_effective_date;
66: p_user_tab(l_users_count).description := null;
67:
68: l_users_count := l_users_count + 1;
374: if NOT (p_technical_summary_mode) then
375: -- Attach System Administrator
376: fnd_User_resp_groups_api.load_row(
377: x_user_name => upper(per_ri_config_utilities.return_config_entity_name_pre
378: (per_ri_config_main.g_configuration_user_name)),
379: x_resp_key => 'SYSTEM_ADMINISTRATOR',
380: x_app_short_name => 'SYSADMIN',
381: x_security_group => 'STANDARD',
382: x_owner => 'SEED',
381: x_security_group => 'STANDARD',
382: x_owner => 'SEED',
383: x_start_date => l_start_date,
384: x_end_date => l_end_date,
385: x_description => per_ri_config_main.g_description_string);
386: else
387: p_resp_tab(l_resp_count).user_name := upper(per_ri_config_utilities.return_config_entity_name_pre
388: (per_ri_config_main.g_configuration_user_name));
389: p_resp_tab(l_resp_count).resp_key := per_ri_config_utilities.get_responsibility_name('SYSTEM_ADMINISTRATOR');
384: x_end_date => l_end_date,
385: x_description => per_ri_config_main.g_description_string);
386: else
387: p_resp_tab(l_resp_count).user_name := upper(per_ri_config_utilities.return_config_entity_name_pre
388: (per_ri_config_main.g_configuration_user_name));
389: p_resp_tab(l_resp_count).resp_key := per_ri_config_utilities.get_responsibility_name('SYSTEM_ADMINISTRATOR');
390: p_resp_tab(l_resp_count).app_short_name := 'SYSADMIN';
391: p_resp_tab(l_resp_count).security_group := 'STANDARD';
392: p_resp_tab(l_resp_count).owner := 'SEED';
391: p_resp_tab(l_resp_count).security_group := 'STANDARD';
392: p_resp_tab(l_resp_count).owner := 'SEED';
393: p_resp_tab(l_resp_count).start_date := l_start_date;
394: p_resp_tab(l_resp_count).end_date := l_end_date;
395: p_resp_tab(l_resp_count).description := per_ri_config_main.g_description_string;
396:
397: l_resp_count := l_resp_count + 1 ;
398: end if;
399:
404: -- Attach APPLICATION IMPLEMENTATION for iSetup
405: if NOT (p_technical_summary_mode) then
406: fnd_User_resp_groups_api.load_row(
407: x_user_name => upper(per_ri_config_utilities.return_config_entity_name_pre
408: (per_ri_config_main.g_configuration_user_name)),
409: x_resp_key => 'APPLICATION IMPLEMENTATION',
410: x_app_short_name => 'AZ',
411: x_security_group => 'STANDARD',
412: x_owner => 'SEED',
411: x_security_group => 'STANDARD',
412: x_owner => 'SEED',
413: x_start_date => l_start_date,
414: x_end_date => l_end_date,
415: x_description => per_ri_config_main.g_description_string);
416: else
417: p_resp_tab(l_resp_count).user_name := upper(per_ri_config_utilities.return_config_entity_name_pre
418: (per_ri_config_main.g_configuration_user_name));
419: p_resp_tab(l_resp_count).resp_key := per_ri_config_utilities.get_responsibility_name('APPLICATION IMPLEMENTATION');
414: x_end_date => l_end_date,
415: x_description => per_ri_config_main.g_description_string);
416: else
417: p_resp_tab(l_resp_count).user_name := upper(per_ri_config_utilities.return_config_entity_name_pre
418: (per_ri_config_main.g_configuration_user_name));
419: p_resp_tab(l_resp_count).resp_key := per_ri_config_utilities.get_responsibility_name('APPLICATION IMPLEMENTATION');
420: p_resp_tab(l_resp_count).app_short_name := 'AZ';
421: p_resp_tab(l_resp_count).security_group := 'STANDARD';
422: p_resp_tab(l_resp_count).owner := 'SEED';
421: p_resp_tab(l_resp_count).security_group := 'STANDARD';
422: p_resp_tab(l_resp_count).owner := 'SEED';
423: p_resp_tab(l_resp_count).start_date := l_start_date;
424: p_resp_tab(l_resp_count).end_date := l_end_date;
425: p_resp_tab(l_resp_count).description := per_ri_config_main.g_description_string;
426:
427: l_resp_count := l_resp_count + 1 ;
428:
429: end if;
435: -- Bugfix 4219794
436: if NOT (p_technical_summary_mode) then
437: fnd_User_resp_groups_api.load_row(
438: x_user_name => upper(per_ri_config_utilities.return_config_entity_name_pre
439: (per_ri_config_main.g_configuration_user_name)),
440: x_resp_key => 'FNDWF_USER_WEB_NEW',
441: x_app_short_name => 'FND',
442: x_security_group => 'STANDARD',
443: x_owner => 'SEED',
442: x_security_group => 'STANDARD',
443: x_owner => 'SEED',
444: x_start_date => l_start_date,
445: x_end_date => l_end_date,
446: x_description => per_ri_config_main.g_description_string);
447: else
448: p_resp_tab(l_resp_count).user_name := upper(per_ri_config_utilities.return_config_entity_name_pre
449: (per_ri_config_main.g_configuration_user_name));
450: p_resp_tab(l_resp_count).resp_key := per_ri_config_utilities.get_responsibility_name('FNDWF_USER_WEB_NEW');
445: x_end_date => l_end_date,
446: x_description => per_ri_config_main.g_description_string);
447: else
448: p_resp_tab(l_resp_count).user_name := upper(per_ri_config_utilities.return_config_entity_name_pre
449: (per_ri_config_main.g_configuration_user_name));
450: p_resp_tab(l_resp_count).resp_key := per_ri_config_utilities.get_responsibility_name('FNDWF_USER_WEB_NEW');
451: p_resp_tab(l_resp_count).app_short_name := 'FND';
452: p_resp_tab(l_resp_count).security_group := 'STANDARD';
453: p_resp_tab(l_resp_count).owner := 'SEED';
452: p_resp_tab(l_resp_count).security_group := 'STANDARD';
453: p_resp_tab(l_resp_count).owner := 'SEED';
454: p_resp_tab(l_resp_count).start_date := l_start_date;
455: p_resp_tab(l_resp_count).end_date := l_end_date;
456: p_resp_tab(l_resp_count).description := per_ri_config_main.g_description_string;
457:
458: l_resp_count := l_resp_count + 1 ;
459:
460: end if;
465: -- Attach AZ_ISETUP
466: if NOT (p_technical_summary_mode) then
467: fnd_User_resp_groups_api.load_row(
468: x_user_name => upper(per_ri_config_utilities.return_config_entity_name_pre
469: (per_ri_config_main.g_configuration_user_name)),
470: x_resp_key => 'AZ_ISETUP',
471: x_app_short_name => 'AZ',
472: x_security_group => 'STANDARD',
473: x_owner => 'SEED',
472: x_security_group => 'STANDARD',
473: x_owner => 'SEED',
474: x_start_date => l_start_date,
475: x_end_date => l_end_date,
476: x_description => per_ri_config_main.g_description_string);
477: else
478: p_resp_tab(l_resp_count).user_name := upper(per_ri_config_utilities.return_config_entity_name_pre
479: (per_ri_config_main.g_configuration_user_name));
480: p_resp_tab(l_resp_count).resp_key := per_ri_config_utilities.get_responsibility_name('AZ_ISETUP');
475: x_end_date => l_end_date,
476: x_description => per_ri_config_main.g_description_string);
477: else
478: p_resp_tab(l_resp_count).user_name := upper(per_ri_config_utilities.return_config_entity_name_pre
479: (per_ri_config_main.g_configuration_user_name));
480: p_resp_tab(l_resp_count).resp_key := per_ri_config_utilities.get_responsibility_name('AZ_ISETUP');
481: p_resp_tab(l_resp_count).app_short_name := 'AZ';
482: p_resp_tab(l_resp_count).security_group := 'STANDARD';
483: p_resp_tab(l_resp_count).owner := 'SEED';
482: p_resp_tab(l_resp_count).security_group := 'STANDARD';
483: p_resp_tab(l_resp_count).owner := 'SEED';
484: p_resp_tab(l_resp_count).start_date := l_start_date;
485: p_resp_tab(l_resp_count).end_date := l_end_date;
486: p_resp_tab(l_resp_count).description := per_ri_config_main.g_description_string;
487:
488: l_resp_count := l_resp_count + 1 ;
489:
490: end if;
495: -- Attach HRMS_RI_WORKBENCH
496: if NOT (p_technical_summary_mode) then
497: fnd_User_resp_groups_api.load_row(
498: x_user_name => upper(per_ri_config_utilities.return_config_entity_name_pre
499: (per_ri_config_main.g_configuration_user_name)),
500: x_resp_key => 'HRMS_RI_WORKBENCH',
501: x_app_short_name => 'PER',
502: x_security_group => 'STANDARD',
503: x_owner => 'SEED',
502: x_security_group => 'STANDARD',
503: x_owner => 'SEED',
504: x_start_date => l_start_date,
505: x_end_date => l_end_date,
506: x_description => per_ri_config_main.g_description_string);
507: else
508: p_resp_tab(l_resp_count).user_name := upper(per_ri_config_utilities.return_config_entity_name_pre
509: (per_ri_config_main.g_configuration_user_name));
510: p_resp_tab(l_resp_count).resp_key := per_ri_config_utilities.get_responsibility_name('HRMS_RI_WORKBENCH');
505: x_end_date => l_end_date,
506: x_description => per_ri_config_main.g_description_string);
507: else
508: p_resp_tab(l_resp_count).user_name := upper(per_ri_config_utilities.return_config_entity_name_pre
509: (per_ri_config_main.g_configuration_user_name));
510: p_resp_tab(l_resp_count).resp_key := per_ri_config_utilities.get_responsibility_name('HRMS_RI_WORKBENCH');
511: p_resp_tab(l_resp_count).app_short_name := 'PER';
512: p_resp_tab(l_resp_count).security_group := 'STANDARD';
513: p_resp_tab(l_resp_count).owner := 'SEED';
512: p_resp_tab(l_resp_count).security_group := 'STANDARD';
513: p_resp_tab(l_resp_count).owner := 'SEED';
514: p_resp_tab(l_resp_count).start_date := l_start_date;
515: p_resp_tab(l_resp_count).end_date := l_end_date;
516: p_resp_tab(l_resp_count).description := per_ri_config_main.g_description_string;
517:
518: l_resp_count := l_resp_count + 1 ;
519:
520: end if;
555: if l_self_service and p_technical_summary_mode then
556:
557: -- EMPLOYEE_DIRECT_ACCESS_V4
558: p_resp_tab(l_resp_count).user_name := upper(per_ri_config_utilities.return_config_entity_name_pre
559: (per_ri_config_main.g_configuration_user_name));
560: p_resp_tab(l_resp_count).resp_key := per_ri_config_utilities.get_responsibility_name('EMPLOYEE_DIRECT_ACCESS_V4.0');
561: p_resp_tab(l_resp_count).app_short_name := 'PER';
562: p_resp_tab(l_resp_count).security_group := 'STANDARD';
563: p_resp_tab(l_resp_count).owner := 'SEED';
562: p_resp_tab(l_resp_count).security_group := 'STANDARD';
563: p_resp_tab(l_resp_count).owner := 'SEED';
564: p_resp_tab(l_resp_count).start_date := l_start_date;
565: p_resp_tab(l_resp_count).end_date := l_end_date;
566: p_resp_tab(l_resp_count).description := per_ri_config_main.g_description_string;
567:
568: l_resp_count := l_resp_count + 1 ;
569:
570: -- LINE_MANAGER_ACCESS_V4
568: l_resp_count := l_resp_count + 1 ;
569:
570: -- LINE_MANAGER_ACCESS_V4
571: p_resp_tab(l_resp_count).user_name := upper(per_ri_config_utilities.return_config_entity_name_pre
572: (per_ri_config_main.g_configuration_user_name));
573: p_resp_tab(l_resp_count).resp_key := per_ri_config_utilities.get_responsibility_name('LINE_MANAGER_ACCESS_V4.0');
574: p_resp_tab(l_resp_count).app_short_name := 'PER';
575: p_resp_tab(l_resp_count).security_group := 'STANDARD';
576: p_resp_tab(l_resp_count).owner := 'SEED';
575: p_resp_tab(l_resp_count).security_group := 'STANDARD';
576: p_resp_tab(l_resp_count).owner := 'SEED';
577: p_resp_tab(l_resp_count).start_date := l_start_date;
578: p_resp_tab(l_resp_count).end_date := l_end_date;
579: p_resp_tab(l_resp_count).description := per_ri_config_main.g_description_string;
580:
581: l_resp_count := l_resp_count + 1 ;
582: end if;
583: