[Home] [Help]
16: -------------------------------------------------------------------------- */
17: PROCEDURE create_jobs_no_rv_keyflex (p_configuration_code in varchar2
18: ,p_technical_summary_mode in boolean default FALSE
19: ,p_kf_job_no_rv_tab in out nocopy
20: per_ri_config_tech_summary.kf_job_no_rv_tab
21: ,p_kf_job_no_rv_seg_tab in out nocopy
22: per_ri_config_tech_summary.kf_job_no_rv_seg_tab) IS
23:
24: cursor csr_config_job_no_rv (cp_configuration_code in varchar2) IS
18: ,p_technical_summary_mode in boolean default FALSE
19: ,p_kf_job_no_rv_tab in out nocopy
20: per_ri_config_tech_summary.kf_job_no_rv_tab
21: ,p_kf_job_no_rv_seg_tab in out nocopy
22: per_ri_config_tech_summary.kf_job_no_rv_seg_tab) IS
23:
24: cursor csr_config_job_no_rv (cp_configuration_code in varchar2) IS
25: select job_segment_name,
26: job_segment_type,
34: l_proc varchar2(72) := g_package || 'create_jobs_no_rv_keyflex';
35: l_log_message varchar2(360);
36: l_error_message varchar2(360);
37: l_kf_job_no_rv_count number(8) := 0;
38: l_kf_job_no_rv_tab per_ri_config_tech_summary.kf_job_no_rv_tab;
39: l_kf_job_no_rv_seg_count number(8) := 0;
40: l_kf_job_no_rv_seg_tab per_ri_config_tech_summary.kf_job_no_rv_seg_tab;
41:
42: l_kf_job_no_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
36: l_error_message varchar2(360);
37: l_kf_job_no_rv_count number(8) := 0;
38: l_kf_job_no_rv_tab per_ri_config_tech_summary.kf_job_no_rv_tab;
39: l_kf_job_no_rv_seg_count number(8) := 0;
40: l_kf_job_no_rv_seg_tab per_ri_config_tech_summary.kf_job_no_rv_seg_tab;
41:
42: l_kf_job_no_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
43: l_value_set_tab_count number(9) := 1;
44:
38: l_kf_job_no_rv_tab per_ri_config_tech_summary.kf_job_no_rv_tab;
39: l_kf_job_no_rv_seg_count number(8) := 0;
40: l_kf_job_no_rv_seg_tab per_ri_config_tech_summary.kf_job_no_rv_seg_tab;
41:
42: l_kf_job_no_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
43: l_value_set_tab_count number(9) := 1;
44:
45: l_job_segment_name per_ri_config_information.config_information1%type;
46: l_job_segment_type per_ri_config_information.config_information1%type;
359: -------------------------------------------------------------------------- */
360: PROCEDURE create_positions_no_rv_keyflex (p_configuration_code in varchar2
361: ,p_technical_summary_mode in boolean default FALSE
362: ,p_kf_pos_no_rv_tab in out nocopy
363: per_ri_config_tech_summary.kf_pos_no_rv_tab
364: ,p_kf_pos_no_rv_seg_tab in out nocopy
365: per_ri_config_tech_summary.kf_pos_no_rv_seg_tab) IS
366:
367: cursor csr_config_position_no_rv (cp_configuration_code in varchar2) IS
361: ,p_technical_summary_mode in boolean default FALSE
362: ,p_kf_pos_no_rv_tab in out nocopy
363: per_ri_config_tech_summary.kf_pos_no_rv_tab
364: ,p_kf_pos_no_rv_seg_tab in out nocopy
365: per_ri_config_tech_summary.kf_pos_no_rv_seg_tab) IS
366:
367: cursor csr_config_position_no_rv (cp_configuration_code in varchar2) IS
368: select position_segment_name,
369: position_segment_type,
384: l_log_message varchar2(360);
385: l_error_message varchar2(360);
386:
387: l_kf_pos_no_rv_count number(8) := 0;
388: l_kf_pos_no_rv_tab per_ri_config_tech_summary.kf_pos_no_rv_tab;
389: l_kf_pos_no_rv_seg_count number(8) := 0;
390: l_kf_pos_no_rv_seg_tab per_ri_config_tech_summary.kf_pos_no_rv_seg_tab;
391:
392: l_kf_pos_no_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
386:
387: l_kf_pos_no_rv_count number(8) := 0;
388: l_kf_pos_no_rv_tab per_ri_config_tech_summary.kf_pos_no_rv_tab;
389: l_kf_pos_no_rv_seg_count number(8) := 0;
390: l_kf_pos_no_rv_seg_tab per_ri_config_tech_summary.kf_pos_no_rv_seg_tab;
391:
392: l_kf_pos_no_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
393: l_value_set_tab_count number(9) := 1;
394:
388: l_kf_pos_no_rv_tab per_ri_config_tech_summary.kf_pos_no_rv_tab;
389: l_kf_pos_no_rv_seg_count number(8) := 0;
390: l_kf_pos_no_rv_seg_tab per_ri_config_tech_summary.kf_pos_no_rv_seg_tab;
391:
392: l_kf_pos_no_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
393: l_value_set_tab_count number(9) := 1;
394:
395: l_pos_segment_name per_ri_config_information.config_information1%type;
396: l_pos_segment_type per_ri_config_information.config_information1%type;
999: -------------------------------------------------------------------------- */
1000: PROCEDURE create_grades_no_rv_keyflex (p_configuration_code in varchar2
1001: ,p_technical_summary_mode in boolean default FALSE
1002: ,p_kf_grd_no_rv_tab in out nocopy
1003: per_ri_config_tech_summary.kf_grd_no_rv_tab
1004: ,p_kf_grd_no_rv_seg_tab in out nocopy
1005: per_ri_config_tech_summary.kf_grd_no_rv_seg_tab) IS
1006:
1007: cursor csr_config_grade_no_rv (cp_configuration_code in varchar2) IS
1001: ,p_technical_summary_mode in boolean default FALSE
1002: ,p_kf_grd_no_rv_tab in out nocopy
1003: per_ri_config_tech_summary.kf_grd_no_rv_tab
1004: ,p_kf_grd_no_rv_seg_tab in out nocopy
1005: per_ri_config_tech_summary.kf_grd_no_rv_seg_tab) IS
1006:
1007: cursor csr_config_grade_no_rv (cp_configuration_code in varchar2) IS
1008: select grade_segment_name,
1009: grade_segment_type,
1017: l_proc varchar2(72) := g_package || 'create_grades_no_rv_keyflex';
1018: l_log_message varchar2(360);
1019: l_error_message varchar2(360);
1020: l_kf_grd_no_rv_count number(8) := 0;
1021: l_kf_grd_no_rv_tab per_ri_config_tech_summary.kf_grd_no_rv_tab;
1022:
1023: l_kf_grd_no_rv_seg_count number(8) := 0;
1024: l_kf_grd_no_rv_seg_tab per_ri_config_tech_summary.kf_grd_no_rv_seg_tab;
1025:
1020: l_kf_grd_no_rv_count number(8) := 0;
1021: l_kf_grd_no_rv_tab per_ri_config_tech_summary.kf_grd_no_rv_tab;
1022:
1023: l_kf_grd_no_rv_seg_count number(8) := 0;
1024: l_kf_grd_no_rv_seg_tab per_ri_config_tech_summary.kf_grd_no_rv_seg_tab;
1025:
1026: l_kf_grd_no_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
1027: l_value_set_tab_count number(9) := 1;
1028:
1022:
1023: l_kf_grd_no_rv_seg_count number(8) := 0;
1024: l_kf_grd_no_rv_seg_tab per_ri_config_tech_summary.kf_grd_no_rv_seg_tab;
1025:
1026: l_kf_grd_no_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
1027: l_value_set_tab_count number(9) := 1;
1028:
1029: l_grade_segment_name per_ri_config_information.config_information1%type;
1030: l_grade_segment_type per_ri_config_information.config_information1%type;
1290: -------------------------------------------------------------------------- */
1291: PROCEDURE create_jobs_rv_keyflex (p_configuration_code in varchar2
1292: ,p_technical_summary_mode in boolean default FALSE
1293: ,p_kf_job_rv_tab in out nocopy
1294: per_ri_config_tech_summary.kf_job_rv_tab
1295: ,p_kf_job_rv_seg_tab in out nocopy
1296: per_ri_config_tech_summary.kf_job_rv_seg_tab) IS
1297:
1298: cursor csr_config_jobs_rv (cp_configuration_code in varchar2) IS
1292: ,p_technical_summary_mode in boolean default FALSE
1293: ,p_kf_job_rv_tab in out nocopy
1294: per_ri_config_tech_summary.kf_job_rv_tab
1295: ,p_kf_job_rv_seg_tab in out nocopy
1296: per_ri_config_tech_summary.kf_job_rv_seg_tab) IS
1297:
1298: cursor csr_config_jobs_rv (cp_configuration_code in varchar2) IS
1299: select distinct per_ri_config_utilities.return_config_entity_name(rv.regional_variance_name),
1300: rv.regional_variance_name
1317:
1318: l_proc varchar2(72) := g_package || 'create_jobs_rv_keyflex';
1319: l_error_message varchar2(360);
1320: l_kf_job_rv_count number(8) := 0;
1321: l_kf_job_rv_tab per_ri_config_tech_summary.kf_job_rv_tab;
1322:
1323: l_kf_job_rv_seg_count number(8) := 0;
1324: l_kf_job_rv_seg_tab per_ri_config_tech_summary.kf_job_rv_tab;
1325:
1320: l_kf_job_rv_count number(8) := 0;
1321: l_kf_job_rv_tab per_ri_config_tech_summary.kf_job_rv_tab;
1322:
1323: l_kf_job_rv_seg_count number(8) := 0;
1324: l_kf_job_rv_seg_tab per_ri_config_tech_summary.kf_job_rv_tab;
1325:
1326: l_jobs_rv_name per_ri_config_information.config_information1%type;
1327: l_jobs_rv_name_orig per_ri_config_information.config_information1%type;
1328:
1325:
1326: l_jobs_rv_name per_ri_config_information.config_information1%type;
1327: l_jobs_rv_name_orig per_ri_config_information.config_information1%type;
1328:
1329: l_kf_job_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
1330: l_value_set_tab_count number(9) := 1;
1331:
1332: l_rv_jobs_segment_type per_ri_config_information.config_information1%type;
1333: l_rv_jobs_segment_name per_ri_config_information.config_information1%type;
1481:
1482: PROCEDURE create_positions_rv_keyflex (p_configuration_code in varchar2
1483: ,p_technical_summary_mode in boolean default FALSE
1484: ,p_kf_pos_rv_tab in out nocopy
1485: per_ri_config_tech_summary.kf_pos_rv_tab
1486: ,p_kf_pos_rv_seg_tab in out nocopy
1487: per_ri_config_tech_summary.kf_pos_rv_seg_tab) IS
1488:
1489: cursor csr_config_positions_rv (cp_configuration_code in varchar2) IS
1483: ,p_technical_summary_mode in boolean default FALSE
1484: ,p_kf_pos_rv_tab in out nocopy
1485: per_ri_config_tech_summary.kf_pos_rv_tab
1486: ,p_kf_pos_rv_seg_tab in out nocopy
1487: per_ri_config_tech_summary.kf_pos_rv_seg_tab) IS
1488:
1489: cursor csr_config_positions_rv (cp_configuration_code in varchar2) IS
1490: select distinct per_ri_config_utilities.return_config_entity_name(regional_variance_name),
1491: regional_variance_name
1507:
1508: l_proc varchar2(72) := g_package || 'create_positions_rv_keyflex';
1509: l_error_message varchar2(360);
1510: l_kf_pos_rv_count number(8) := 0;
1511: l_kf_pos_rv_tab per_ri_config_tech_summary.kf_pos_rv_tab;
1512:
1513: l_kf_pos_rv_seg_count number(8) := 0;
1514: l_kf_pos_rv_seg_tab per_ri_config_tech_summary.kf_pos_rv_tab;
1515:
1510: l_kf_pos_rv_count number(8) := 0;
1511: l_kf_pos_rv_tab per_ri_config_tech_summary.kf_pos_rv_tab;
1512:
1513: l_kf_pos_rv_seg_count number(8) := 0;
1514: l_kf_pos_rv_seg_tab per_ri_config_tech_summary.kf_pos_rv_tab;
1515:
1516: l_kf_pos_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
1517: l_value_set_tab_count number(9) := 1;
1518:
1512:
1513: l_kf_pos_rv_seg_count number(8) := 0;
1514: l_kf_pos_rv_seg_tab per_ri_config_tech_summary.kf_pos_rv_tab;
1515:
1516: l_kf_pos_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
1517: l_value_set_tab_count number(9) := 1;
1518:
1519: l_positions_rv_name per_ri_config_information.config_information1%type;
1520: l_positions_rv_name_orig per_ri_config_information.config_information1%type;
1670:
1671: PROCEDURE create_grades_rv_keyflex (p_configuration_code in varchar2
1672: ,p_technical_summary_mode in boolean default FALSE
1673: ,p_kf_grd_rv_tab in out nocopy
1674: per_ri_config_tech_summary.kf_grd_rv_tab
1675: ,p_kf_grd_rv_seg_tab in out nocopy
1676: per_ri_config_tech_summary.kf_grd_rv_seg_tab) IS
1677:
1678: cursor csr_config_grade_rv (cp_configuration_code in varchar2) IS
1672: ,p_technical_summary_mode in boolean default FALSE
1673: ,p_kf_grd_rv_tab in out nocopy
1674: per_ri_config_tech_summary.kf_grd_rv_tab
1675: ,p_kf_grd_rv_seg_tab in out nocopy
1676: per_ri_config_tech_summary.kf_grd_rv_seg_tab) IS
1677:
1678: cursor csr_config_grade_rv (cp_configuration_code in varchar2) IS
1679: select distinct per_ri_config_utilities.return_config_entity_name(regional_variance_name),
1680: regional_variance_name
1694: l_proc varchar2(72) := g_package || 'create_grades_rv_keyflex';
1695: l_error_message varchar2(360);
1696:
1697: l_kf_grd_rv_count number(8) := 0;
1698: l_kf_grd_rv_tab per_ri_config_tech_summary.kf_grd_rv_tab;
1699: l_kf_grd_rv_seg_count number(8) := 0;
1700: l_kf_grd_rv_seg_tab per_ri_config_tech_summary.kf_grd_rv_tab;
1701:
1702: l_kf_grd_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
1696:
1697: l_kf_grd_rv_count number(8) := 0;
1698: l_kf_grd_rv_tab per_ri_config_tech_summary.kf_grd_rv_tab;
1699: l_kf_grd_rv_seg_count number(8) := 0;
1700: l_kf_grd_rv_seg_tab per_ri_config_tech_summary.kf_grd_rv_tab;
1701:
1702: l_kf_grd_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
1703: l_value_set_tab_count number(9) := 1;
1704:
1698: l_kf_grd_rv_tab per_ri_config_tech_summary.kf_grd_rv_tab;
1699: l_kf_grd_rv_seg_count number(8) := 0;
1700: l_kf_grd_rv_seg_tab per_ri_config_tech_summary.kf_grd_rv_tab;
1701:
1702: l_kf_grd_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
1703: l_value_set_tab_count number(9) := 1;
1704:
1705: l_grade_rv_name per_ri_config_information.config_information1%type;
1706: l_grade_rv_name_orig per_ri_config_information.config_information1%type;
1853: -------------------------------------------------------------------------- */
1854: PROCEDURE create_global_grp_cmp_cost_kf (p_configuration_code in varchar2
1855: ,p_technical_summary_mode in boolean default FALSE
1856: ,p_kf_grp_tab in out nocopy
1857: per_ri_config_tech_summary.kf_grp_tab
1858: ,p_kf_cmp_tab in out nocopy
1859: per_ri_config_tech_summary.kf_cmp_tab
1860: ,p_kf_cost_tab in out nocopy
1861: per_ri_config_tech_summary.kf_cost_tab
1855: ,p_technical_summary_mode in boolean default FALSE
1856: ,p_kf_grp_tab in out nocopy
1857: per_ri_config_tech_summary.kf_grp_tab
1858: ,p_kf_cmp_tab in out nocopy
1859: per_ri_config_tech_summary.kf_cmp_tab
1860: ,p_kf_cost_tab in out nocopy
1861: per_ri_config_tech_summary.kf_cost_tab
1862: ,p_kf_grp_seg_tab in out nocopy
1863: per_ri_config_tech_summary.kf_grp_seg_tab
1857: per_ri_config_tech_summary.kf_grp_tab
1858: ,p_kf_cmp_tab in out nocopy
1859: per_ri_config_tech_summary.kf_cmp_tab
1860: ,p_kf_cost_tab in out nocopy
1861: per_ri_config_tech_summary.kf_cost_tab
1862: ,p_kf_grp_seg_tab in out nocopy
1863: per_ri_config_tech_summary.kf_grp_seg_tab
1864: ,p_kf_cmp_seg_tab in out nocopy
1865: per_ri_config_tech_summary.kf_cmp_seg_tab
1859: per_ri_config_tech_summary.kf_cmp_tab
1860: ,p_kf_cost_tab in out nocopy
1861: per_ri_config_tech_summary.kf_cost_tab
1862: ,p_kf_grp_seg_tab in out nocopy
1863: per_ri_config_tech_summary.kf_grp_seg_tab
1864: ,p_kf_cmp_seg_tab in out nocopy
1865: per_ri_config_tech_summary.kf_cmp_seg_tab
1866: ,p_kf_cost_seg_tab in out nocopy
1867: per_ri_config_tech_summary.kf_cost_seg_tab) IS
1861: per_ri_config_tech_summary.kf_cost_tab
1862: ,p_kf_grp_seg_tab in out nocopy
1863: per_ri_config_tech_summary.kf_grp_seg_tab
1864: ,p_kf_cmp_seg_tab in out nocopy
1865: per_ri_config_tech_summary.kf_cmp_seg_tab
1866: ,p_kf_cost_seg_tab in out nocopy
1867: per_ri_config_tech_summary.kf_cost_seg_tab) IS
1868:
1869: l_kf_grp_tab per_ri_config_tech_summary.kf_grp_tab;
1863: per_ri_config_tech_summary.kf_grp_seg_tab
1864: ,p_kf_cmp_seg_tab in out nocopy
1865: per_ri_config_tech_summary.kf_cmp_seg_tab
1866: ,p_kf_cost_seg_tab in out nocopy
1867: per_ri_config_tech_summary.kf_cost_seg_tab) IS
1868:
1869: l_kf_grp_tab per_ri_config_tech_summary.kf_grp_tab;
1870: l_kf_cmp_tab per_ri_config_tech_summary.kf_cmp_tab;
1871: l_kf_cost_tab per_ri_config_tech_summary.kf_cost_tab;
1865: per_ri_config_tech_summary.kf_cmp_seg_tab
1866: ,p_kf_cost_seg_tab in out nocopy
1867: per_ri_config_tech_summary.kf_cost_seg_tab) IS
1868:
1869: l_kf_grp_tab per_ri_config_tech_summary.kf_grp_tab;
1870: l_kf_cmp_tab per_ri_config_tech_summary.kf_cmp_tab;
1871: l_kf_cost_tab per_ri_config_tech_summary.kf_cost_tab;
1872:
1873: l_kf_grp_seg_tab per_ri_config_tech_summary.kf_grp_seg_tab;
1866: ,p_kf_cost_seg_tab in out nocopy
1867: per_ri_config_tech_summary.kf_cost_seg_tab) IS
1868:
1869: l_kf_grp_tab per_ri_config_tech_summary.kf_grp_tab;
1870: l_kf_cmp_tab per_ri_config_tech_summary.kf_cmp_tab;
1871: l_kf_cost_tab per_ri_config_tech_summary.kf_cost_tab;
1872:
1873: l_kf_grp_seg_tab per_ri_config_tech_summary.kf_grp_seg_tab;
1874: l_kf_cmp_seg_tab per_ri_config_tech_summary.kf_cmp_seg_tab;
1867: per_ri_config_tech_summary.kf_cost_seg_tab) IS
1868:
1869: l_kf_grp_tab per_ri_config_tech_summary.kf_grp_tab;
1870: l_kf_cmp_tab per_ri_config_tech_summary.kf_cmp_tab;
1871: l_kf_cost_tab per_ri_config_tech_summary.kf_cost_tab;
1872:
1873: l_kf_grp_seg_tab per_ri_config_tech_summary.kf_grp_seg_tab;
1874: l_kf_cmp_seg_tab per_ri_config_tech_summary.kf_cmp_seg_tab;
1875: l_kf_cost_seg_tab per_ri_config_tech_summary.kf_cost_seg_tab;
1869: l_kf_grp_tab per_ri_config_tech_summary.kf_grp_tab;
1870: l_kf_cmp_tab per_ri_config_tech_summary.kf_cmp_tab;
1871: l_kf_cost_tab per_ri_config_tech_summary.kf_cost_tab;
1872:
1873: l_kf_grp_seg_tab per_ri_config_tech_summary.kf_grp_seg_tab;
1874: l_kf_cmp_seg_tab per_ri_config_tech_summary.kf_cmp_seg_tab;
1875: l_kf_cost_seg_tab per_ri_config_tech_summary.kf_cost_seg_tab;
1876:
1877: l_kf_grp_valueset_tab per_ri_config_tech_summary.valueset_tab;
1870: l_kf_cmp_tab per_ri_config_tech_summary.kf_cmp_tab;
1871: l_kf_cost_tab per_ri_config_tech_summary.kf_cost_tab;
1872:
1873: l_kf_grp_seg_tab per_ri_config_tech_summary.kf_grp_seg_tab;
1874: l_kf_cmp_seg_tab per_ri_config_tech_summary.kf_cmp_seg_tab;
1875: l_kf_cost_seg_tab per_ri_config_tech_summary.kf_cost_seg_tab;
1876:
1877: l_kf_grp_valueset_tab per_ri_config_tech_summary.valueset_tab;
1878: l_kf_cmp_valueset_tab per_ri_config_tech_summary.valueset_tab;
1871: l_kf_cost_tab per_ri_config_tech_summary.kf_cost_tab;
1872:
1873: l_kf_grp_seg_tab per_ri_config_tech_summary.kf_grp_seg_tab;
1874: l_kf_cmp_seg_tab per_ri_config_tech_summary.kf_cmp_seg_tab;
1875: l_kf_cost_seg_tab per_ri_config_tech_summary.kf_cost_seg_tab;
1876:
1877: l_kf_grp_valueset_tab per_ri_config_tech_summary.valueset_tab;
1878: l_kf_cmp_valueset_tab per_ri_config_tech_summary.valueset_tab;
1879: l_kf_cost_valueset_tab per_ri_config_tech_summary.valueset_tab;
1873: l_kf_grp_seg_tab per_ri_config_tech_summary.kf_grp_seg_tab;
1874: l_kf_cmp_seg_tab per_ri_config_tech_summary.kf_cmp_seg_tab;
1875: l_kf_cost_seg_tab per_ri_config_tech_summary.kf_cost_seg_tab;
1876:
1877: l_kf_grp_valueset_tab per_ri_config_tech_summary.valueset_tab;
1878: l_kf_cmp_valueset_tab per_ri_config_tech_summary.valueset_tab;
1879: l_kf_cost_valueset_tab per_ri_config_tech_summary.valueset_tab;
1880: l_value_set_tab_count number(9) := 1;
1881:
1874: l_kf_cmp_seg_tab per_ri_config_tech_summary.kf_cmp_seg_tab;
1875: l_kf_cost_seg_tab per_ri_config_tech_summary.kf_cost_seg_tab;
1876:
1877: l_kf_grp_valueset_tab per_ri_config_tech_summary.valueset_tab;
1878: l_kf_cmp_valueset_tab per_ri_config_tech_summary.valueset_tab;
1879: l_kf_cost_valueset_tab per_ri_config_tech_summary.valueset_tab;
1880: l_value_set_tab_count number(9) := 1;
1881:
1882: l_proc varchar2(72) := g_package || 'create_global_grp_cmp_cost_kf';
1875: l_kf_cost_seg_tab per_ri_config_tech_summary.kf_cost_seg_tab;
1876:
1877: l_kf_grp_valueset_tab per_ri_config_tech_summary.valueset_tab;
1878: l_kf_cmp_valueset_tab per_ri_config_tech_summary.valueset_tab;
1879: l_kf_cost_valueset_tab per_ri_config_tech_summary.valueset_tab;
1880: l_value_set_tab_count number(9) := 1;
1881:
1882: l_proc varchar2(72) := g_package || 'create_global_grp_cmp_cost_kf';
1883: l_error_message varchar2(360);
2326:
2327: PROCEDURE create_global_job_pos_kf (p_configuration_code in varchar2
2328: ,p_technical_summary_mode in boolean default FALSE
2329: ,p_kf_job_tab in out nocopy
2330: per_ri_config_tech_summary.kf_job_tab
2331: ,p_kf_pos_tab in out nocopy
2332: per_ri_config_tech_summary.kf_pos_tab
2333: ,p_kf_job_seg_tab in out nocopy
2334: per_ri_config_tech_summary.kf_job_seg_tab
2328: ,p_technical_summary_mode in boolean default FALSE
2329: ,p_kf_job_tab in out nocopy
2330: per_ri_config_tech_summary.kf_job_tab
2331: ,p_kf_pos_tab in out nocopy
2332: per_ri_config_tech_summary.kf_pos_tab
2333: ,p_kf_job_seg_tab in out nocopy
2334: per_ri_config_tech_summary.kf_job_seg_tab
2335: ,p_kf_pos_seg_tab in out nocopy
2336: per_ri_config_tech_summary.kf_pos_seg_tab) IS
2330: per_ri_config_tech_summary.kf_job_tab
2331: ,p_kf_pos_tab in out nocopy
2332: per_ri_config_tech_summary.kf_pos_tab
2333: ,p_kf_job_seg_tab in out nocopy
2334: per_ri_config_tech_summary.kf_job_seg_tab
2335: ,p_kf_pos_seg_tab in out nocopy
2336: per_ri_config_tech_summary.kf_pos_seg_tab) IS
2337:
2338: l_proc varchar2(72) := g_package || 'create_global_job_pos_kf';
2332: per_ri_config_tech_summary.kf_pos_tab
2333: ,p_kf_job_seg_tab in out nocopy
2334: per_ri_config_tech_summary.kf_job_seg_tab
2335: ,p_kf_pos_seg_tab in out nocopy
2336: per_ri_config_tech_summary.kf_pos_seg_tab) IS
2337:
2338: l_proc varchar2(72) := g_package || 'create_global_job_pos_kf';
2339: l_configuration_code per_ri_config_information.configuration_code%type;
2340: l_jobs_fk_number number(9);
2345: l_job_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
2346: l_pos_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
2347: l_enterprise_primary_industry per_ri_config_information.config_information1%type;
2348:
2349: l_kf_job_tab per_ri_config_tech_summary.kf_job_tab;
2350: l_kf_pos_tab per_ri_config_tech_summary.kf_pos_tab;
2351: l_kf_job_count number(8) :=0;
2352: l_kf_pos_count number(8) :=0;
2353:
2346: l_pos_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
2347: l_enterprise_primary_industry per_ri_config_information.config_information1%type;
2348:
2349: l_kf_job_tab per_ri_config_tech_summary.kf_job_tab;
2350: l_kf_pos_tab per_ri_config_tech_summary.kf_pos_tab;
2351: l_kf_job_count number(8) :=0;
2352: l_kf_pos_count number(8) :=0;
2353:
2354: l_kf_job_seg_tab per_ri_config_tech_summary.kf_job_seg_tab;
2350: l_kf_pos_tab per_ri_config_tech_summary.kf_pos_tab;
2351: l_kf_job_count number(8) :=0;
2352: l_kf_pos_count number(8) :=0;
2353:
2354: l_kf_job_seg_tab per_ri_config_tech_summary.kf_job_seg_tab;
2355: l_kf_pos_seg_tab per_ri_config_tech_summary.kf_pos_seg_tab;
2356: l_kf_job_seg_count number(8) :=0;
2357: l_kf_pos_seg_count number(8) :=0;
2358:
2351: l_kf_job_count number(8) :=0;
2352: l_kf_pos_count number(8) :=0;
2353:
2354: l_kf_job_seg_tab per_ri_config_tech_summary.kf_job_seg_tab;
2355: l_kf_pos_seg_tab per_ri_config_tech_summary.kf_pos_seg_tab;
2356: l_kf_job_seg_count number(8) :=0;
2357: l_kf_pos_seg_count number(8) :=0;
2358:
2359: l_kf_job_valueset_tab per_ri_config_tech_summary.valueset_tab;
2355: l_kf_pos_seg_tab per_ri_config_tech_summary.kf_pos_seg_tab;
2356: l_kf_job_seg_count number(8) :=0;
2357: l_kf_pos_seg_count number(8) :=0;
2358:
2359: l_kf_job_valueset_tab per_ri_config_tech_summary.valueset_tab;
2360: l_kf_pos_valueset_tab per_ri_config_tech_summary.valueset_tab;
2361: l_value_set_tab_count number(9) := 1;
2362:
2363: l_log_message varchar2(360);
2356: l_kf_job_seg_count number(8) :=0;
2357: l_kf_pos_seg_count number(8) :=0;
2358:
2359: l_kf_job_valueset_tab per_ri_config_tech_summary.valueset_tab;
2360: l_kf_pos_valueset_tab per_ri_config_tech_summary.valueset_tab;
2361: l_value_set_tab_count number(9) := 1;
2362:
2363: l_log_message varchar2(360);
2364: l_error_message varchar2(360);
2920:
2921: PROCEDURE create_global_pos_kf (p_configuration_code in varchar2
2922: ,p_technical_summary_mode in boolean default FALSE
2923: ,p_kf_pos_tab in out nocopy
2924: per_ri_config_tech_summary.kf_pos_tab
2925: ,p_kf_pos_seg_tab in out nocopy
2926: per_ri_config_tech_summary.kf_pos_seg_tab) IS
2927:
2928: l_proc varchar2(72) := g_package || 'create_global_pos_kf';
2922: ,p_technical_summary_mode in boolean default FALSE
2923: ,p_kf_pos_tab in out nocopy
2924: per_ri_config_tech_summary.kf_pos_tab
2925: ,p_kf_pos_seg_tab in out nocopy
2926: per_ri_config_tech_summary.kf_pos_seg_tab) IS
2927:
2928: l_proc varchar2(72) := g_package || 'create_global_pos_kf';
2929: l_configuration_code per_ri_config_information.configuration_code%type;
2930: l_position_fk_number number(9);
2935: l_enterprise_primary_industry per_ri_config_information.config_information1%type;
2936: l_log_message varchar2(360);
2937: l_error_message varchar2(360);
2938:
2939: l_kf_pos_tab per_ri_config_tech_summary.kf_pos_tab;
2940: l_kf_pos_count number(8) :=0;
2941: l_kf_pos_seg_tab per_ri_config_tech_summary.kf_pos_seg_tab;
2942: l_kf_pos_seg_count number(8) :=0;
2943:
2937: l_error_message varchar2(360);
2938:
2939: l_kf_pos_tab per_ri_config_tech_summary.kf_pos_tab;
2940: l_kf_pos_count number(8) :=0;
2941: l_kf_pos_seg_tab per_ri_config_tech_summary.kf_pos_seg_tab;
2942: l_kf_pos_seg_count number(8) :=0;
2943:
2944: l_kf_pos_valueset_tab per_ri_config_tech_summary.valueset_tab;
2945: l_value_set_tab_count number(9) := 1;
2940: l_kf_pos_count number(8) :=0;
2941: l_kf_pos_seg_tab per_ri_config_tech_summary.kf_pos_seg_tab;
2942: l_kf_pos_seg_count number(8) :=0;
2943:
2944: l_kf_pos_valueset_tab per_ri_config_tech_summary.valueset_tab;
2945: l_value_set_tab_count number(9) := 1;
2946:
2947:
2948: BEGIN
3335: -------------------------------------------------------------------------- */
3336: PROCEDURE create_global_grd_kf (p_configuration_code in varchar2
3337: ,p_technical_summary_mode in boolean default FALSE
3338: ,p_kf_grd_tab in out nocopy
3339: per_ri_config_tech_summary.kf_grd_tab
3340: ,p_kf_grd_seg_tab in out nocopy
3341: per_ri_config_tech_summary.kf_grd_seg_tab) IS
3342:
3343: l_proc varchar2(72) := g_package || 'create_global_grd_kf';
3337: ,p_technical_summary_mode in boolean default FALSE
3338: ,p_kf_grd_tab in out nocopy
3339: per_ri_config_tech_summary.kf_grd_tab
3340: ,p_kf_grd_seg_tab in out nocopy
3341: per_ri_config_tech_summary.kf_grd_seg_tab) IS
3342:
3343: l_proc varchar2(72) := g_package || 'create_global_grd_kf';
3344: l_log_message varchar2(360);
3345: l_kf_grd_tab per_ri_config_tech_summary.kf_grd_tab;
3341: per_ri_config_tech_summary.kf_grd_seg_tab) IS
3342:
3343: l_proc varchar2(72) := g_package || 'create_global_grd_kf';
3344: l_log_message varchar2(360);
3345: l_kf_grd_tab per_ri_config_tech_summary.kf_grd_tab;
3346: l_kf_grd_count number(8) := 0;
3347: l_error_message varchar2(360);
3348: l_kf_grd_seg_tab per_ri_config_tech_summary.kf_grd_seg_tab;
3349: l_kf_grd_seg_count number(8) := 0;
3344: l_log_message varchar2(360);
3345: l_kf_grd_tab per_ri_config_tech_summary.kf_grd_tab;
3346: l_kf_grd_count number(8) := 0;
3347: l_error_message varchar2(360);
3348: l_kf_grd_seg_tab per_ri_config_tech_summary.kf_grd_seg_tab;
3349: l_kf_grd_seg_count number(8) := 0;
3350:
3351: l_configuration_code per_ri_config_information.configuration_code%type;
3352: l_grade_number number(9);
3350:
3351: l_configuration_code per_ri_config_information.configuration_code%type;
3352: l_grade_number number(9);
3353:
3354: l_kf_grd_valueset_tab per_ri_config_tech_summary.valueset_tab;
3355: l_value_set_tab_count number(9) := 1;
3356:
3357: l_enterprise_short_name per_ri_config_information.configuration_code%type;
3358:
3711:
3712: PROCEDURE create_hrms_responsibility (p_configuration_code in varchar2
3713: ,p_security_profile_tab in out nocopy security_profile_tab
3714: ,p_technical_summary_mode in boolean default FALSE
3715: ,p_hrms_resp_tab in out nocopy per_ri_config_tech_summary.hrms_resp_tab) IS
3716:
3717: cursor csr_get_country (cp_configuration_code in varchar2) IS
3718: select country_code
3719: from per_ri_config_country_v
3797:
3798: l_configuration_user_name fnd_user.user_name%type;
3799:
3800: l_hrms_resp_count number(9) := 0;
3801: l_hrms_bgsgut_profile_resp_tab per_ri_config_tech_summary.profile_resp_tab;
3802: l_profile_resp_main_tab per_ri_config_tech_summary.profile_resp_tab;
3803:
3804: BEGIN
3805:
3798: l_configuration_user_name fnd_user.user_name%type;
3799:
3800: l_hrms_resp_count number(9) := 0;
3801: l_hrms_bgsgut_profile_resp_tab per_ri_config_tech_summary.profile_resp_tab;
3802: l_profile_resp_main_tab per_ri_config_tech_summary.profile_resp_tab;
3803:
3804: BEGIN
3805:
3806: hr_utility.set_location('Entering:'|| l_proc, 10);
4123: -------------------------------------------------------------------------- */
4124: PROCEDURE create_application_level_resp(p_configuration_code in varchar2
4125: ,p_technical_summary_mode in boolean default FALSE
4126: ,p_profile_apps_tab in out nocopy
4127: per_ri_config_tech_summary.profile_apps_tab) IS
4128:
4129:
4130: cursor csr_get_product (cp_configuration_code in varchar2) IS
4131: select product_name
4225: PROCEDURE create_resp_level_profile(p_configuration_code in varchar2
4226: ,p_responsibility_key in varchar2
4227: ,p_technical_summary_mode in boolean default FALSE
4228: ,p_profile_resp_tab in out nocopy
4229: per_ri_config_tech_summary.profile_resp_tab) IS
4230:
4231:
4232: cursor csr_get_product (cp_configuration_code in varchar2) IS
4233: select product_name
4327: ,p_responsibility_key in varchar2
4328: ,p_business_group_name in varchar2
4329: ,p_technical_summary_mode in boolean default FALSE
4330: ,p_bg_sg_ut_profile_resp_tab in out nocopy
4331: per_ri_config_tech_summary.profile_resp_tab) IS
4332:
4333:
4334: cursor csr_get_resp_key_app (cp_responsibility_key in varchar2) IS
4335: select apps.application_short_name,resp.responsibility_id