655: Open csr_emp_details;
656: Fetch csr_emp_details Into l_last_name, l_first_name, l_full_name, l_email_address;
657: Close csr_emp_details;
658:
659: hr_user_acct_utility.g_fnd_user_rec.user_name := l_first_name||'.'||l_last_name;
660: hr_user_acct_utility.g_fnd_user_rec.password := 'Welcome';
661: hr_user_acct_utility.g_fnd_user_rec.email_address := l_email_address;
662: hr_user_acct_utility.g_fnd_user_rec.password_date := p_hire_date;
663: hr_user_acct_utility.g_fnd_user_rec.employee_id := p_person_id;
656: Fetch csr_emp_details Into l_last_name, l_first_name, l_full_name, l_email_address;
657: Close csr_emp_details;
658:
659: hr_user_acct_utility.g_fnd_user_rec.user_name := l_first_name||'.'||l_last_name;
660: hr_user_acct_utility.g_fnd_user_rec.password := 'Welcome';
661: hr_user_acct_utility.g_fnd_user_rec.email_address := l_email_address;
662: hr_user_acct_utility.g_fnd_user_rec.password_date := p_hire_date;
663: hr_user_acct_utility.g_fnd_user_rec.employee_id := p_person_id;
664:
657: Close csr_emp_details;
658:
659: hr_user_acct_utility.g_fnd_user_rec.user_name := l_first_name||'.'||l_last_name;
660: hr_user_acct_utility.g_fnd_user_rec.password := 'Welcome';
661: hr_user_acct_utility.g_fnd_user_rec.email_address := l_email_address;
662: hr_user_acct_utility.g_fnd_user_rec.password_date := p_hire_date;
663: hr_user_acct_utility.g_fnd_user_rec.employee_id := p_person_id;
664:
665: Open csr_responsibility_details;
658:
659: hr_user_acct_utility.g_fnd_user_rec.user_name := l_first_name||'.'||l_last_name;
660: hr_user_acct_utility.g_fnd_user_rec.password := 'Welcome';
661: hr_user_acct_utility.g_fnd_user_rec.email_address := l_email_address;
662: hr_user_acct_utility.g_fnd_user_rec.password_date := p_hire_date;
663: hr_user_acct_utility.g_fnd_user_rec.employee_id := p_person_id;
664:
665: Open csr_responsibility_details;
666: Fetch csr_responsibility_details Into l_application_id, l_responsibility_id;
659: hr_user_acct_utility.g_fnd_user_rec.user_name := l_first_name||'.'||l_last_name;
660: hr_user_acct_utility.g_fnd_user_rec.password := 'Welcome';
661: hr_user_acct_utility.g_fnd_user_rec.email_address := l_email_address;
662: hr_user_acct_utility.g_fnd_user_rec.password_date := p_hire_date;
663: hr_user_acct_utility.g_fnd_user_rec.employee_id := p_person_id;
664:
665: Open csr_responsibility_details;
666: Fetch csr_responsibility_details Into l_application_id, l_responsibility_id;
667: Close csr_responsibility_details;
665: Open csr_responsibility_details;
666: Fetch csr_responsibility_details Into l_application_id, l_responsibility_id;
667: Close csr_responsibility_details;
668:
669: hr_user_acct_utility.g_fnd_resp_tbl(1).existing_resp_id := l_responsibility_id;
670: hr_user_acct_utility.g_fnd_resp_tbl(1).existing_resp_key := 'EMPLOYEE_DIRECT_ACCESS_V4.0';
671: hr_user_acct_utility.g_fnd_resp_tbl(1).existing_resp_app_id := l_application_id;
672: hr_user_acct_utility.g_fnd_resp_tbl(1).sec_group_id := 0;
673: hr_user_acct_utility.g_fnd_resp_tbl(1).sec_profile_id := 0;
666: Fetch csr_responsibility_details Into l_application_id, l_responsibility_id;
667: Close csr_responsibility_details;
668:
669: hr_user_acct_utility.g_fnd_resp_tbl(1).existing_resp_id := l_responsibility_id;
670: hr_user_acct_utility.g_fnd_resp_tbl(1).existing_resp_key := 'EMPLOYEE_DIRECT_ACCESS_V4.0';
671: hr_user_acct_utility.g_fnd_resp_tbl(1).existing_resp_app_id := l_application_id;
672: hr_user_acct_utility.g_fnd_resp_tbl(1).sec_group_id := 0;
673: hr_user_acct_utility.g_fnd_resp_tbl(1).sec_profile_id := 0;
674: hr_user_acct_utility.g_fnd_resp_tbl(1).user_resp_start_date := p_hire_date;
667: Close csr_responsibility_details;
668:
669: hr_user_acct_utility.g_fnd_resp_tbl(1).existing_resp_id := l_responsibility_id;
670: hr_user_acct_utility.g_fnd_resp_tbl(1).existing_resp_key := 'EMPLOYEE_DIRECT_ACCESS_V4.0';
671: hr_user_acct_utility.g_fnd_resp_tbl(1).existing_resp_app_id := l_application_id;
672: hr_user_acct_utility.g_fnd_resp_tbl(1).sec_group_id := 0;
673: hr_user_acct_utility.g_fnd_resp_tbl(1).sec_profile_id := 0;
674: hr_user_acct_utility.g_fnd_resp_tbl(1).user_resp_start_date := p_hire_date;
675:
668:
669: hr_user_acct_utility.g_fnd_resp_tbl(1).existing_resp_id := l_responsibility_id;
670: hr_user_acct_utility.g_fnd_resp_tbl(1).existing_resp_key := 'EMPLOYEE_DIRECT_ACCESS_V4.0';
671: hr_user_acct_utility.g_fnd_resp_tbl(1).existing_resp_app_id := l_application_id;
672: hr_user_acct_utility.g_fnd_resp_tbl(1).sec_group_id := 0;
673: hr_user_acct_utility.g_fnd_resp_tbl(1).sec_profile_id := 0;
674: hr_user_acct_utility.g_fnd_resp_tbl(1).user_resp_start_date := p_hire_date;
675:
676: End set_user_acct_details;
669: hr_user_acct_utility.g_fnd_resp_tbl(1).existing_resp_id := l_responsibility_id;
670: hr_user_acct_utility.g_fnd_resp_tbl(1).existing_resp_key := 'EMPLOYEE_DIRECT_ACCESS_V4.0';
671: hr_user_acct_utility.g_fnd_resp_tbl(1).existing_resp_app_id := l_application_id;
672: hr_user_acct_utility.g_fnd_resp_tbl(1).sec_group_id := 0;
673: hr_user_acct_utility.g_fnd_resp_tbl(1).sec_profile_id := 0;
674: hr_user_acct_utility.g_fnd_resp_tbl(1).user_resp_start_date := p_hire_date;
675:
676: End set_user_acct_details;
677:
670: hr_user_acct_utility.g_fnd_resp_tbl(1).existing_resp_key := 'EMPLOYEE_DIRECT_ACCESS_V4.0';
671: hr_user_acct_utility.g_fnd_resp_tbl(1).existing_resp_app_id := l_application_id;
672: hr_user_acct_utility.g_fnd_resp_tbl(1).sec_group_id := 0;
673: hr_user_acct_utility.g_fnd_resp_tbl(1).sec_profile_id := 0;
674: hr_user_acct_utility.g_fnd_resp_tbl(1).user_resp_start_date := p_hire_date;
675:
676: End set_user_acct_details;
677:
678: End per_ri_create_crp_employee;