[Home] [Help]
3802: cursor csr_get_responsibility (cp_territory_code in varchar2
3803: ,cp_responsibility_application in varchar2) IS
3804: select distinct resp.responsibility_key,
3805: apps.application_short_name
3806: from fnd_application apps,
3807: fnd_responsibility resp,
3808: per_ri_config_responsibility con,
3809: per_ri_config_country_v cont
3810: where apps.application_id = resp.application_id
3830: l_proc varchar2(72) := g_package || 'create_hrms_responsibility';
3831: l_error_message varchar2(360);
3832: l_country_code per_ri_config_information.config_information1%type;
3833: l_product_name per_ri_config_information.config_information1%type;
3834: l_fnd_application_short_name varchar2(30);
3835:
3836: l_country_code_global per_ri_config_information.config_information1%type;
3837: l_responsibility_key varchar2(60);
3838: l_application_short_name per_ri_config_information.configuration_code%type;
3982: open csr_get_responsibility(l_country_code
3983: ,l_assign_determined_resp);
3984: loop
3985: fetch csr_get_responsibility into l_responsibility_key
3986: ,l_fnd_application_short_name;
3987:
3988: exit when csr_get_responsibility%NOTFOUND;
3989:
3990: hr_utility.trace('l_country_code : ' || l_country_code);
3988: exit when csr_get_responsibility%NOTFOUND;
3989:
3990: hr_utility.trace('l_country_code : ' || l_country_code);
3991: hr_utility.trace('l_responsibility_key : ' || l_responsibility_key);
3992: hr_utility.trace('l_fnd_application_short_name : ' || l_fnd_application_short_name);
3993:
3994: -- Security Group Removal Changes
3995: -- This is taken care by security_profile_assignment creation
3996: --assign responsibility
3996: --assign responsibility
3997: /* fnd_user_resp_groups_api.load_row(
3998: x_user_name => l_configuration_user_name,
3999: x_resp_key => l_responsibility_key,
4000: x_app_short_name => l_fnd_application_short_name,
4001: x_security_group => 'STANDARD',
4002: x_owner => 'SEED',
4003: x_start_date => l_start_date,
4004: x_end_date => l_end_date,
4002: x_owner => 'SEED',
4003: x_start_date => l_start_date,
4004: x_end_date => l_end_date,
4005: x_description => per_ri_config_main.g_description_string);
4006: hr_utility.trace('Assigned Responsibility:' || l_responsibility_key || ':' || l_fnd_application_short_name);
4007: */
4008: -- get business group name for given country code
4009: l_business_group_name_main := per_ri_config_utilities.get_enterprise_short_name
4010: (p_configuration_code => p_configuration_code)
4243: --
4244: -- Set ENABLE_SECURITY_GROUPS all all HRMS application
4245: --
4246: for rec in ( select application_id
4247: from fnd_application
4248: where hr_general.chk_application_id(application_id) = 'TRUE'
4249: Order by Application_short_name)
4250: loop
4251:
4296:
4297: cursor csr_get_resp_key_app (cp_responsibility_key in varchar2) IS
4298: select apps.application_short_name
4299: from fnd_responsibility resp,
4300: fnd_application apps
4301: where apps.application_id = resp.application_id
4302: and resp.responsibility_key = cp_responsibility_key;
4303:
4304: l_application_short_name fnd_application.application_short_name%type;
4300: fnd_application apps
4301: where apps.application_id = resp.application_id
4302: and resp.responsibility_key = cp_responsibility_key;
4303:
4304: l_application_short_name fnd_application.application_short_name%type;
4305: l_hr_user_type varchar2(30);
4306: l_product_name varchar2(30);
4307:
4308: l_hr boolean default TRUE;
4393:
4394: cursor csr_get_resp_key_app (cp_responsibility_key in varchar2) IS
4395: select apps.application_short_name,resp.responsibility_id
4396: from fnd_responsibility resp,
4397: fnd_application apps
4398: where apps.application_id = resp.application_id
4399: and resp.responsibility_key = cp_responsibility_key;
4400:
4401: cursor csr_bg_id (cp_business_group_name in varchar2) IS
4412: select product_name
4413: from per_ri_config_prod_selection_v
4414: where configuration_code = cp_configuration_code;
4415:
4416: l_application_short_name fnd_application.application_short_name%type;
4417: l_hr_user_type varchar2(30);
4418: l_product_name varchar2(30);
4419:
4420: l_bg_id varchar2(30);