[Home] [Help]
3742: cursor csr_get_responsibility (cp_territory_code in varchar2
3743: ,cp_responsibility_application in varchar2) IS
3744: select distinct resp.responsibility_key,
3745: apps.application_short_name
3746: from fnd_application apps,
3747: fnd_responsibility resp,
3748: per_ri_config_responsibility con,
3749: per_ri_config_country_v cont
3750: where apps.application_id = resp.application_id
3770: l_proc varchar2(72) := g_package || 'create_hrms_responsibility';
3771: l_error_message varchar2(360);
3772: l_country_code per_ri_config_information.config_information1%type;
3773: l_product_name per_ri_config_information.config_information1%type;
3774: l_fnd_application_short_name varchar2(30);
3775:
3776: l_country_code_global per_ri_config_information.config_information1%type;
3777: l_responsibility_key varchar2(60);
3778: l_application_short_name per_ri_config_information.configuration_code%type;
3922: open csr_get_responsibility(l_country_code
3923: ,l_assign_determined_resp);
3924: loop
3925: fetch csr_get_responsibility into l_responsibility_key
3926: ,l_fnd_application_short_name;
3927:
3928: exit when csr_get_responsibility%NOTFOUND;
3929:
3930: hr_utility.trace('l_country_code : ' || l_country_code);
3928: exit when csr_get_responsibility%NOTFOUND;
3929:
3930: hr_utility.trace('l_country_code : ' || l_country_code);
3931: hr_utility.trace('l_responsibility_key : ' || l_responsibility_key);
3932: hr_utility.trace('l_fnd_application_short_name : ' || l_fnd_application_short_name);
3933:
3934: -- Security Group Removal Changes
3935: -- This is taken care by security_profile_assignment creation
3936: --assign responsibility
3936: --assign responsibility
3937: /* fnd_user_resp_groups_api.load_row(
3938: x_user_name => l_configuration_user_name,
3939: x_resp_key => l_responsibility_key,
3940: x_app_short_name => l_fnd_application_short_name,
3941: x_security_group => 'STANDARD',
3942: x_owner => 'SEED',
3943: x_start_date => l_start_date,
3944: x_end_date => l_end_date,
3942: x_owner => 'SEED',
3943: x_start_date => l_start_date,
3944: x_end_date => l_end_date,
3945: x_description => per_ri_config_main.g_description_string);
3946: hr_utility.trace('Assigned Responsibility:' || l_responsibility_key || ':' || l_fnd_application_short_name);
3947: */
3948: -- get business group name for given country code
3949: l_business_group_name_main := per_ri_config_utilities.get_enterprise_short_name
3950: (p_configuration_code => p_configuration_code)
4183: --
4184: -- Set ENABLE_SECURITY_GROUPS all all HRMS application
4185: --
4186: for rec in ( select application_id
4187: from fnd_application
4188: where hr_general.chk_application_id(application_id) = 'TRUE'
4189: Order by Application_short_name)
4190: loop
4191:
4236:
4237: cursor csr_get_resp_key_app (cp_responsibility_key in varchar2) IS
4238: select apps.application_short_name
4239: from fnd_responsibility resp,
4240: fnd_application apps
4241: where apps.application_id = resp.application_id
4242: and resp.responsibility_key = cp_responsibility_key;
4243:
4244: l_application_short_name fnd_application.application_short_name%type;
4240: fnd_application apps
4241: where apps.application_id = resp.application_id
4242: and resp.responsibility_key = cp_responsibility_key;
4243:
4244: l_application_short_name fnd_application.application_short_name%type;
4245: l_hr_user_type varchar2(30);
4246: l_product_name varchar2(30);
4247:
4248: l_hr boolean default TRUE;
4333:
4334: cursor csr_get_resp_key_app (cp_responsibility_key in varchar2) IS
4335: select apps.application_short_name,resp.responsibility_id
4336: from fnd_responsibility resp,
4337: fnd_application apps
4338: where apps.application_id = resp.application_id
4339: and resp.responsibility_key = cp_responsibility_key;
4340:
4341: cursor csr_bg_id (cp_business_group_name in varchar2) IS
4352: select product_name
4353: from per_ri_config_prod_selection_v
4354: where configuration_code = cp_configuration_code;
4355:
4356: l_application_short_name fnd_application.application_short_name%type;
4357: l_hr_user_type varchar2(30);
4358: l_product_name varchar2(30);
4359:
4360: l_bg_id varchar2(30);