DBA Data[Home] [Help]

APPS.PER_RI_CONFIG_UTILITIES dependencies on PER_RI_CONFIG_TECH_SUMMARY

Line 2097: per_ri_config_tech_summary.int_hrms_setup_tab) IS

2093: ,retcode out nocopy number
2094: ,p_country_tab in per_ri_config_datapump_entity.country_tab
2095: ,p_technical_summary_mode in boolean default FALSE
2096: ,p_int_hrms_setup_tab in out nocopy
2097: per_ri_config_tech_summary.int_hrms_setup_tab) IS
2098:
2099: l_proc varchar2(72) := g_package || 'submit_int_payroll_request';
2100: l_log_message varchar2(360);
2101: l_int_hrms_setup_count number(8) := 0;

Line 2102: l_int_hrms_setup_tab per_ri_config_tech_summary.int_hrms_setup_tab;

2098:
2099: l_proc varchar2(72) := g_package || 'submit_int_payroll_request';
2100: l_log_message varchar2(360);
2101: l_int_hrms_setup_count number(8) := 0;
2102: l_int_hrms_setup_tab per_ri_config_tech_summary.int_hrms_setup_tab;
2103: l_request_id number(9);
2104: l_legislation_code varchar2(30);
2105: l_currency_code varchar2(30);
2106: l_tax_start_date date;

Line 2670: ,p_hrms_misc_resp_tab in out nocopy per_ri_config_tech_summary.hrms_misc_resp_tab) IS

2666:
2667: PROCEDURE assign_misc_responsibility
2668: (p_configuration_code in varchar2
2669: ,p_technical_summary_mode in boolean default FALSE
2670: ,p_hrms_misc_resp_tab in out nocopy per_ri_config_tech_summary.hrms_misc_resp_tab) IS
2671:
2672: l_proc varchar2(72) := g_package || 'assign_misc_responsibility';
2673: l_log_message varchar2(360);
2674: l_error_message varchar2(360);

Line 2890: per_ri_config_tech_summary.valueset_tab) IS

2886: ,p_segment_name in varchar2
2887: ,p_segment_number in varchar2
2888: ,p_fed_seg_attribute in varchar2 default 'N'
2889: ,p_valueset_tab in out nocopy
2890: per_ri_config_tech_summary.valueset_tab) IS
2891:
2892: l_proc varchar2(72) := g_package || 'create_valueset_ts_data';
2893: l_error_message varchar2(360);
2894: l_log_message varchar2(360);

Line 3002: in out nocopy per_ri_config_tech_summary.hrms_resp_tab

2998: ,p_security_profile_tab in per_ri_config_fnd_hr_entity.security_profile_tab
2999: ,p_int_bg_resp_tab in per_ri_config_fnd_hr_entity.int_bg_resp_tab
3000: ,p_technical_summary_mode in boolean default FALSE
3001: ,p_hrms_resp_main_tab
3002: in out nocopy per_ri_config_tech_summary.hrms_resp_tab
3003: ,p_more_profile_resp_tab
3004: in out nocopy per_ri_config_tech_summary.profile_resp_tab
3005: ,p_more_int_profile_resp_tab
3006: in out nocopy per_ri_config_tech_summary.profile_resp_tab) IS

Line 3004: in out nocopy per_ri_config_tech_summary.profile_resp_tab

3000: ,p_technical_summary_mode in boolean default FALSE
3001: ,p_hrms_resp_main_tab
3002: in out nocopy per_ri_config_tech_summary.hrms_resp_tab
3003: ,p_more_profile_resp_tab
3004: in out nocopy per_ri_config_tech_summary.profile_resp_tab
3005: ,p_more_int_profile_resp_tab
3006: in out nocopy per_ri_config_tech_summary.profile_resp_tab) IS
3007:
3008: l_security_profile_name per_business_groups.name%type;

Line 3006: in out nocopy per_ri_config_tech_summary.profile_resp_tab) IS

3002: in out nocopy per_ri_config_tech_summary.hrms_resp_tab
3003: ,p_more_profile_resp_tab
3004: in out nocopy per_ri_config_tech_summary.profile_resp_tab
3005: ,p_more_int_profile_resp_tab
3006: in out nocopy per_ri_config_tech_summary.profile_resp_tab) IS
3007:
3008: l_security_profile_name per_business_groups.name%type;
3009: l_responsibility_key fnd_responsibility_vl.responsibility_name%type;
3010: l_ovn number(9);

Line 3011: l_hrms_resp_profile_resp_tab per_ri_config_tech_summary.profile_resp_tab;

3007:
3008: l_security_profile_name per_business_groups.name%type;
3009: l_responsibility_key fnd_responsibility_vl.responsibility_name%type;
3010: l_ovn number(9);
3011: l_hrms_resp_profile_resp_tab per_ri_config_tech_summary.profile_resp_tab;
3012: l_int_resp_profile_resp_tab per_ri_config_tech_summary.profile_resp_tab;
3013: l_proc varchar2(72) := g_package || 'create_more_hrms_resps';
3014: l_log_message varchar2(360);
3015: l_error_message varchar2(360);

Line 3012: l_int_resp_profile_resp_tab per_ri_config_tech_summary.profile_resp_tab;

3008: l_security_profile_name per_business_groups.name%type;
3009: l_responsibility_key fnd_responsibility_vl.responsibility_name%type;
3010: l_ovn number(9);
3011: l_hrms_resp_profile_resp_tab per_ri_config_tech_summary.profile_resp_tab;
3012: l_int_resp_profile_resp_tab per_ri_config_tech_summary.profile_resp_tab;
3013: l_proc varchar2(72) := g_package || 'create_more_hrms_resps';
3014: l_log_message varchar2(360);
3015: l_error_message varchar2(360);
3016: l_main_bgsgut_profile_resp_tab per_ri_config_tech_summary.profile_resp_tab;

Line 3016: l_main_bgsgut_profile_resp_tab per_ri_config_tech_summary.profile_resp_tab;

3012: l_int_resp_profile_resp_tab per_ri_config_tech_summary.profile_resp_tab;
3013: l_proc varchar2(72) := g_package || 'create_more_hrms_resps';
3014: l_log_message varchar2(360);
3015: l_error_message varchar2(360);
3016: l_main_bgsgut_profile_resp_tab per_ri_config_tech_summary.profile_resp_tab;
3017: l_int_bgsgut_profile_resp_tab per_ri_config_tech_summary.profile_resp_tab;
3018:
3019: l_main_bgsgut_profile_resp_ct number(8) := 0;
3020: l_int_bgsgut_profile_resp_ct number(8) := 0;

Line 3017: l_int_bgsgut_profile_resp_tab per_ri_config_tech_summary.profile_resp_tab;

3013: l_proc varchar2(72) := g_package || 'create_more_hrms_resps';
3014: l_log_message varchar2(360);
3015: l_error_message varchar2(360);
3016: l_main_bgsgut_profile_resp_tab per_ri_config_tech_summary.profile_resp_tab;
3017: l_int_bgsgut_profile_resp_tab per_ri_config_tech_summary.profile_resp_tab;
3018:
3019: l_main_bgsgut_profile_resp_ct number(8) := 0;
3020: l_int_bgsgut_profile_resp_ct number(8) := 0;
3021: l_profile_resp_temp_count number(9) := 1;

Line 3025: l_hrms_resp_one_tab per_ri_config_tech_summary.hrms_resp_tab;

3021: l_profile_resp_temp_count number(9) := 1;
3022: l_more_profile_resp_tab_count number(9) := 0;
3023: l_hrms_resp_main_count number(9) := 0;
3024:
3025: l_hrms_resp_one_tab per_ri_config_tech_summary.hrms_resp_tab;
3026:
3027: BEGIN
3028:
3029: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 3350: per_ri_config_tech_summary.profile_resp_tab

3346: ,p_security_profile_name in varchar2
3347: ,p_responsibility_key in varchar2
3348: ,p_technical_summary_mode in boolean default FALSE
3349: ,p_bg_sg_ut_profile_resp_tab in out nocopy
3350: per_ri_config_tech_summary.profile_resp_tab
3351: ,p_hrms_resp_one_tab in out nocopy
3352: per_ri_config_tech_summary.hrms_resp_tab) IS
3353:
3354: cursor csr_user IS

Line 3352: per_ri_config_tech_summary.hrms_resp_tab) IS

3348: ,p_technical_summary_mode in boolean default FALSE
3349: ,p_bg_sg_ut_profile_resp_tab in out nocopy
3350: per_ri_config_tech_summary.profile_resp_tab
3351: ,p_hrms_resp_one_tab in out nocopy
3352: per_ri_config_tech_summary.hrms_resp_tab) IS
3353:
3354: cursor csr_user IS
3355: select user_name
3356: from fnd_user

Line 3414: l_bg_sg_ut_profile_resp_tab per_ri_config_tech_summary.profile_resp_tab;

3410: l_proc varchar2(72) := g_package || 'create_resp_and_profile';
3411: l_log_message varchar2(360);
3412: l_error_message varchar2(360);
3413:
3414: l_bg_sg_ut_profile_resp_tab per_ri_config_tech_summary.profile_resp_tab;
3415: l_new_app_short_name fnd_application.application_short_name%type;
3416: l_new_resp_key fnd_responsibility_vl.responsibility_name%type;
3417: l_new_responsibility_id fnd_responsibility.responsibility_id%type;
3418: l_new_responsibility_name fnd_responsibility_tl.responsibility_name%type;