64:
65: l_jp_rv_defined boolean default FALSE;
66: l_grd_rv_defined boolean default FALSE;
67: l_country_tab per_ri_config_datapump_entity.country_tab;
68: l_security_profile_tab per_ri_config_fnd_hr_entity.security_profile_tab;
69: l_int_bg_resp_tab per_ri_config_fnd_hr_entity.int_bg_resp_tab;
70:
71: l_errbuf_msg varchar2(240);
72: l_retcode_msg number(15);
65: l_jp_rv_defined boolean default FALSE;
66: l_grd_rv_defined boolean default FALSE;
67: l_country_tab per_ri_config_datapump_entity.country_tab;
68: l_security_profile_tab per_ri_config_fnd_hr_entity.security_profile_tab;
69: l_int_bg_resp_tab per_ri_config_fnd_hr_entity.int_bg_resp_tab;
70:
71: l_errbuf_msg varchar2(240);
72: l_retcode_msg number(15);
73: l_fresh_installed boolean;
243:
244: --
245: -- set aplication level profile options
246: --
247: per_ri_config_fnd_hr_entity.create_application_level_resp
248: (p_configuration_code => p_configuration_code
249: ,p_technical_summary_mode => p_technical_summary_mode
250: ,p_profile_apps_tab => l_profile_apps_tab);
251:
252: hr_utility.set_location(l_proc, 50);
253: --
254: -- add hrms responsibilities to created user.
255: --
256: per_ri_config_fnd_hr_entity.create_hrms_responsibility
257: (p_configuration_code => p_configuration_code
258: ,p_security_profile_tab => l_security_profile_tab
259: ,p_technical_summary_mode => p_technical_summary_mode
260: ,p_hrms_resp_tab => l_hrms_resp_tab);
275:
276: --
277: -- always create default PEA, GRP and COST KF
278: --
279: per_ri_config_fnd_hr_entity.create_global_grp_cmp_cost_kf
280: (p_configuration_code => p_configuration_code
281: ,p_technical_summary_mode => p_technical_summary_mode
282: ,p_kf_grp_tab => l_kf_grp_tab
283: ,p_kf_cmp_tab => l_kf_cmp_tab
298: hr_utility.trace('Jobs/Positions NOT defined');
299: --
300: -- create global jobs and positions
301: --
302: per_ri_config_fnd_hr_entity.create_global_job_pos_kf
303: (p_configuration_code => p_configuration_code
304: ,p_technical_summary_mode => p_technical_summary_mode
305: ,p_kf_job_tab => l_kf_job_tab
306: ,p_kf_pos_tab => l_kf_pos_tab
317: hr_utility.trace('Positions NOT defined');
318: --
319: -- create global positions
320: --
321: per_ri_config_fnd_hr_entity.create_global_pos_kf
322: (p_configuration_code => p_configuration_code
323: ,p_technical_summary_mode => p_technical_summary_mode
324: ,p_kf_pos_tab => l_kf_pos_tab
325: ,p_kf_pos_seg_tab => l_kf_pos_seg_tab
331: hr_utility.trace('Grades NOT defined');
332: --
333: -- create global grades
334: --
335: per_ri_config_fnd_hr_entity.create_global_grd_kf
336: (p_configuration_code => p_configuration_code
337: ,p_technical_summary_mode => p_technical_summary_mode
338: ,p_kf_grd_tab => l_kf_grd_tab
339: ,p_kf_grd_seg_tab => l_kf_grd_seg_tab
346: hr_utility.trace('Jobs defined');
347: --
348: -- create jobs with no rvs
349: --
350: per_ri_config_fnd_hr_entity.create_jobs_no_rv_keyflex
351: (p_configuration_code => p_configuration_code
352: ,p_technical_summary_mode => p_technical_summary_mode
353: ,p_kf_job_no_rv_tab => l_kf_job_no_rv_tab
354: ,p_kf_job_no_rv_seg_tab => l_kf_job_no_rv_seg_tab
355: );
356: hr_utility.set_location(l_proc, 100);
357: -- create jobs with rvs
358: --
359: per_ri_config_fnd_hr_entity.create_jobs_rv_keyflex
360: (p_configuration_code => p_configuration_code
361: ,p_technical_summary_mode => p_technical_summary_mode
362: ,p_kf_job_rv_tab => l_kf_job_rv_tab
363: ,p_kf_job_rv_seg_tab => l_kf_job_rv_seg_tab
370: hr_utility.trace('Positions IS defined');
371: --
372: -- create positions with no rvs
373: --
374: per_ri_config_fnd_hr_entity.create_positions_no_rv_keyflex
375: (p_configuration_code => p_configuration_code
376: ,p_technical_summary_mode => p_technical_summary_mode
377: ,p_kf_pos_no_rv_tab => l_kf_pos_no_rv_tab
378: ,p_kf_pos_no_rv_seg_tab => l_kf_pos_no_rv_seg_tab
380: hr_utility.set_location(l_proc, 120);
381: --
382: -- create positions with rvs
383: --
384: per_ri_config_fnd_hr_entity.create_positions_rv_keyflex
385: (p_configuration_code => p_configuration_code
386: ,p_technical_summary_mode => p_technical_summary_mode
387: ,p_kf_pos_rv_tab => l_kf_pos_rv_tab
388: ,p_kf_pos_rv_seg_tab => l_kf_pos_rv_seg_tab
395: hr_utility.trace('Grades IS defined');
396: --
397: -- create grades with no rvs
398: --
399: per_ri_config_fnd_hr_entity.create_grades_no_rv_keyflex
400: (p_configuration_code => p_configuration_code
401: ,p_technical_summary_mode => p_technical_summary_mode
402: ,p_kf_grd_no_rv_tab => l_kf_grd_no_rv_tab
403: ,p_kf_grd_no_rv_seg_tab => l_kf_grd_no_rv_seg_tab
405: hr_utility.set_location(l_proc, 140);
406: --
407: -- create grades with rvs
408: --
409: per_ri_config_fnd_hr_entity.create_grades_rv_keyflex
410: (p_configuration_code => p_configuration_code
411: ,p_technical_summary_mode => p_technical_summary_mode
412: ,p_kf_grd_rv_tab => l_kf_grd_rv_tab
413: ,p_kf_grd_rv_seg_tab => l_kf_grd_rv_seg_tab
716:
717: l_jp_rv_defined boolean default FALSE;
718: l_grd_rv_defined boolean default FALSE;
719: l_country_tab per_ri_config_datapump_entity.country_tab;
720: l_security_profile_tab per_ri_config_fnd_hr_entity.security_profile_tab;
721: l_int_bg_resp_tab per_ri_config_fnd_hr_entity.int_bg_resp_tab;
722:
723: l_errbuf_msg varchar2(240);
724: l_retcode_msg number(15);
717: l_jp_rv_defined boolean default FALSE;
718: l_grd_rv_defined boolean default FALSE;
719: l_country_tab per_ri_config_datapump_entity.country_tab;
720: l_security_profile_tab per_ri_config_fnd_hr_entity.security_profile_tab;
721: l_int_bg_resp_tab per_ri_config_fnd_hr_entity.int_bg_resp_tab;
722:
723: l_errbuf_msg varchar2(240);
724: l_retcode_msg number(15);
725: l_fresh_installed boolean;
916:
917: --
918: -- set aplication level profile options
919: --
920: per_ri_config_fnd_hr_entity.create_application_level_resp
921: (p_configuration_code => p_configuration_code
922: ,p_technical_summary_mode => l_technical_summary_mode
923: ,p_profile_apps_tab => l_profile_apps_tab);
924: hr_utility.set_location(l_proc, 50);
924: hr_utility.set_location(l_proc, 50);
925: --
926: -- add hrms responsibilities to created user.
927: --
928: per_ri_config_fnd_hr_entity.create_hrms_responsibility
929: (p_configuration_code => p_configuration_code
930: ,p_security_profile_tab => l_security_profile_tab
931: ,p_technical_summary_mode => l_technical_summary_mode
932: ,p_hrms_resp_tab => l_hrms_resp_tab);
946:
947: --
948: -- always create default PEA, GRP and COST KF
949: --
950: per_ri_config_fnd_hr_entity.create_global_grp_cmp_cost_kf
951: (p_configuration_code => p_configuration_code
952: ,p_technical_summary_mode => l_technical_summary_mode
953: ,p_kf_grp_tab => l_kf_grp_tab
954: ,p_kf_cmp_tab => l_kf_cmp_tab
970: hr_utility.trace('Jobs/Positions NOT defined');
971: --
972: -- create global jobs and positions
973: --
974: per_ri_config_fnd_hr_entity.create_global_job_pos_kf
975: (p_configuration_code => p_configuration_code
976: ,p_technical_summary_mode => l_technical_summary_mode
977: ,p_kf_job_tab => l_kf_job_tab
978: ,p_kf_pos_tab => l_kf_pos_tab
989: hr_utility.trace('Positions NOT defined');
990: --
991: -- create global positions
992: --
993: per_ri_config_fnd_hr_entity.create_global_pos_kf
994: (p_configuration_code => p_configuration_code
995: ,p_technical_summary_mode => l_technical_summary_mode
996: ,p_kf_pos_tab => l_kf_pos_tab
997: ,p_kf_pos_seg_tab => l_kf_pos_seg_tab
1003: hr_utility.trace('Grades NOT defined');
1004: --
1005: -- create global grades
1006: --
1007: per_ri_config_fnd_hr_entity.create_global_grd_kf
1008: (p_configuration_code => p_configuration_code
1009: ,p_technical_summary_mode => l_technical_summary_mode
1010: ,p_kf_grd_tab => l_kf_grd_tab
1011: ,p_kf_grd_seg_tab => l_kf_grd_seg_tab
1018: hr_utility.trace('Jobs defined');
1019: --
1020: -- create jobs with no rvs
1021: --
1022: per_ri_config_fnd_hr_entity.create_jobs_no_rv_keyflex
1023: (p_configuration_code => p_configuration_code
1024: ,p_technical_summary_mode => l_technical_summary_mode
1025: ,p_kf_job_no_rv_tab => l_kf_job_no_rv_tab
1026: ,p_kf_job_no_rv_seg_tab => l_kf_job_no_rv_seg_tab
1027: );
1028: hr_utility.set_location(l_proc, 100);
1029: -- create jobs with rvs
1030: --
1031: per_ri_config_fnd_hr_entity.create_jobs_rv_keyflex
1032: (p_configuration_code => p_configuration_code
1033: ,p_technical_summary_mode => l_technical_summary_mode
1034: ,p_kf_job_rv_tab => l_kf_job_rv_tab
1035: ,p_kf_job_rv_seg_tab => l_kf_job_rv_seg_tab
1042: hr_utility.trace('Positions IS defined');
1043: --
1044: -- create positions with no rvs
1045: --
1046: per_ri_config_fnd_hr_entity.create_positions_no_rv_keyflex
1047: (p_configuration_code => p_configuration_code
1048: ,p_technical_summary_mode => l_technical_summary_mode
1049: ,p_kf_pos_no_rv_tab => l_kf_pos_no_rv_tab
1050: ,p_kf_pos_no_rv_seg_tab => l_kf_pos_no_rv_seg_tab
1052: hr_utility.set_location(l_proc, 120);
1053: --
1054: -- create positions with rvs
1055: --
1056: per_ri_config_fnd_hr_entity.create_positions_rv_keyflex
1057: (p_configuration_code => p_configuration_code
1058: ,p_technical_summary_mode => l_technical_summary_mode
1059: ,p_kf_pos_rv_tab => l_kf_pos_rv_tab
1060: ,p_kf_pos_rv_seg_tab => l_kf_pos_rv_seg_tab
1068: hr_utility.trace('Grades IS defined');
1069: --
1070: -- create grades with no rvs
1071: --
1072: per_ri_config_fnd_hr_entity.create_grades_no_rv_keyflex
1073: (p_configuration_code => p_configuration_code
1074: ,p_technical_summary_mode => l_technical_summary_mode
1075: ,p_kf_grd_no_rv_tab => l_kf_grd_no_rv_tab
1076: ,p_kf_grd_no_rv_seg_tab => l_kf_grd_no_rv_seg_tab
1078: hr_utility.set_location(l_proc, 140);
1079: --
1080: -- create grades with rvs
1081: --
1082: per_ri_config_fnd_hr_entity.create_grades_rv_keyflex
1083: (p_configuration_code => p_configuration_code
1084: ,p_technical_summary_mode => l_technical_summary_mode
1085: ,p_kf_grd_rv_tab => l_kf_grd_rv_tab
1086: ,p_kf_grd_rv_seg_tab => l_kf_grd_rv_seg_tab