eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_RI_CONFIG_FND_HR_ENTITY dependencies on PER_RI_CONFIG_TECH_SUMMARY

Line 20: per_ri_config_tech_summary.kf_job_no_rv_tab

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

Line 22: per_ri_config_tech_summary.kf_job_no_rv_seg_tab) 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,

Line 38: l_kf_job_no_rv_tab per_ri_config_tech_summary.kf_job_no_rv_tab;

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;

Line 40: l_kf_job_no_rv_seg_tab per_ri_config_tech_summary.kf_job_no_rv_seg_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:

Line 42: l_kf_job_no_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;

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;

Line 363: per_ri_config_tech_summary.kf_pos_no_rv_tab

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

Line 365: per_ri_config_tech_summary.kf_pos_no_rv_seg_tab) 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,

Line 388: l_kf_pos_no_rv_tab per_ri_config_tech_summary.kf_pos_no_rv_tab;

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;

Line 390: l_kf_pos_no_rv_seg_tab per_ri_config_tech_summary.kf_pos_no_rv_seg_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:

Line 392: l_kf_pos_no_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;

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;

Line 1003: per_ri_config_tech_summary.kf_grd_no_rv_tab

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

Line 1005: per_ri_config_tech_summary.kf_grd_no_rv_seg_tab) 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,

Line 1021: l_kf_grd_no_rv_tab per_ri_config_tech_summary.kf_grd_no_rv_tab;

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:

Line 1024: l_kf_grd_no_rv_seg_tab per_ri_config_tech_summary.kf_grd_no_rv_seg_tab;

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:

Line 1026: l_kf_grd_no_rv_valueset_tab per_ri_config_tech_summary.valueset_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:
1029: l_grade_segment_name per_ri_config_information.config_information1%type;
1030: l_grade_segment_type per_ri_config_information.config_information1%type;

Line 1294: per_ri_config_tech_summary.kf_job_rv_tab

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

Line 1296: per_ri_config_tech_summary.kf_job_rv_seg_tab) 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, rv.REG_VARIANCE_COUNTRY_CODE

Line 1321: l_kf_job_rv_tab per_ri_config_tech_summary.kf_job_rv_tab;

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:

Line 1324: l_kf_job_rv_seg_tab per_ri_config_tech_summary.kf_job_rv_tab;

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:

Line 1329: l_kf_job_rv_valueset_tab per_ri_config_tech_summary.valueset_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:
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;

Line 1505: per_ri_config_tech_summary.kf_pos_rv_tab

1501:
1502: PROCEDURE create_positions_rv_keyflex (p_configuration_code in varchar2
1503: ,p_technical_summary_mode in boolean default FALSE
1504: ,p_kf_pos_rv_tab in out nocopy
1505: per_ri_config_tech_summary.kf_pos_rv_tab
1506: ,p_kf_pos_rv_seg_tab in out nocopy
1507: per_ri_config_tech_summary.kf_pos_rv_seg_tab) IS
1508:
1509: cursor csr_config_positions_rv (cp_configuration_code in varchar2) IS

Line 1507: per_ri_config_tech_summary.kf_pos_rv_seg_tab) IS

1503: ,p_technical_summary_mode in boolean default FALSE
1504: ,p_kf_pos_rv_tab in out nocopy
1505: per_ri_config_tech_summary.kf_pos_rv_tab
1506: ,p_kf_pos_rv_seg_tab in out nocopy
1507: per_ri_config_tech_summary.kf_pos_rv_seg_tab) IS
1508:
1509: cursor csr_config_positions_rv (cp_configuration_code in varchar2) IS
1510: select distinct per_ri_config_utilities.return_config_entity_name(regional_variance_name),
1511: regional_variance_name, REG_VARIANCE_COUNTRY_CODE

Line 1531: l_kf_pos_rv_tab per_ri_config_tech_summary.kf_pos_rv_tab;

1527:
1528: l_proc varchar2(72) := g_package || 'create_positions_rv_keyflex';
1529: l_error_message varchar2(360);
1530: l_kf_pos_rv_count number(8) := 0;
1531: l_kf_pos_rv_tab per_ri_config_tech_summary.kf_pos_rv_tab;
1532:
1533: l_kf_pos_rv_seg_count number(8) := 0;
1534: l_kf_pos_rv_seg_tab per_ri_config_tech_summary.kf_pos_rv_tab;
1535:

Line 1534: l_kf_pos_rv_seg_tab per_ri_config_tech_summary.kf_pos_rv_tab;

1530: l_kf_pos_rv_count number(8) := 0;
1531: l_kf_pos_rv_tab per_ri_config_tech_summary.kf_pos_rv_tab;
1532:
1533: l_kf_pos_rv_seg_count number(8) := 0;
1534: l_kf_pos_rv_seg_tab per_ri_config_tech_summary.kf_pos_rv_tab;
1535:
1536: l_kf_pos_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
1537: l_value_set_tab_count number(9) := 1;
1538:

Line 1536: l_kf_pos_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;

1532:
1533: l_kf_pos_rv_seg_count number(8) := 0;
1534: l_kf_pos_rv_seg_tab per_ri_config_tech_summary.kf_pos_rv_tab;
1535:
1536: l_kf_pos_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
1537: l_value_set_tab_count number(9) := 1;
1538:
1539: l_positions_rv_name per_ri_config_information.config_information1%type;
1540: l_positions_rv_name_orig per_ri_config_information.config_information1%type;

Line 1714: per_ri_config_tech_summary.kf_grd_rv_tab

1710:
1711: PROCEDURE create_grades_rv_keyflex (p_configuration_code in varchar2
1712: ,p_technical_summary_mode in boolean default FALSE
1713: ,p_kf_grd_rv_tab in out nocopy
1714: per_ri_config_tech_summary.kf_grd_rv_tab
1715: ,p_kf_grd_rv_seg_tab in out nocopy
1716: per_ri_config_tech_summary.kf_grd_rv_seg_tab) IS
1717:
1718: cursor csr_config_grade_rv (cp_configuration_code in varchar2) IS

Line 1716: per_ri_config_tech_summary.kf_grd_rv_seg_tab) IS

1712: ,p_technical_summary_mode in boolean default FALSE
1713: ,p_kf_grd_rv_tab in out nocopy
1714: per_ri_config_tech_summary.kf_grd_rv_tab
1715: ,p_kf_grd_rv_seg_tab in out nocopy
1716: per_ri_config_tech_summary.kf_grd_rv_seg_tab) IS
1717:
1718: cursor csr_config_grade_rv (cp_configuration_code in varchar2) IS
1719: select distinct per_ri_config_utilities.return_config_entity_name(regional_variance_name),
1720: regional_variance_name, REG_VARIANCE_COUNTRY_CODE

Line 1738: l_kf_grd_rv_tab per_ri_config_tech_summary.kf_grd_rv_tab;

1734: l_proc varchar2(72) := g_package || 'create_grades_rv_keyflex';
1735: l_error_message varchar2(360);
1736:
1737: l_kf_grd_rv_count number(8) := 0;
1738: l_kf_grd_rv_tab per_ri_config_tech_summary.kf_grd_rv_tab;
1739: l_kf_grd_rv_seg_count number(8) := 0;
1740: l_kf_grd_rv_seg_tab per_ri_config_tech_summary.kf_grd_rv_tab;
1741:
1742: l_kf_grd_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;

Line 1740: l_kf_grd_rv_seg_tab per_ri_config_tech_summary.kf_grd_rv_tab;

1736:
1737: l_kf_grd_rv_count number(8) := 0;
1738: l_kf_grd_rv_tab per_ri_config_tech_summary.kf_grd_rv_tab;
1739: l_kf_grd_rv_seg_count number(8) := 0;
1740: l_kf_grd_rv_seg_tab per_ri_config_tech_summary.kf_grd_rv_tab;
1741:
1742: l_kf_grd_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
1743: l_value_set_tab_count number(9) := 1;
1744:

Line 1742: l_kf_grd_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;

1738: l_kf_grd_rv_tab per_ri_config_tech_summary.kf_grd_rv_tab;
1739: l_kf_grd_rv_seg_count number(8) := 0;
1740: l_kf_grd_rv_seg_tab per_ri_config_tech_summary.kf_grd_rv_tab;
1741:
1742: l_kf_grd_rv_valueset_tab per_ri_config_tech_summary.valueset_tab;
1743: l_value_set_tab_count number(9) := 1;
1744:
1745: l_grade_rv_name per_ri_config_information.config_information1%type;
1746: l_grade_rv_name_orig per_ri_config_information.config_information1%type;

Line 1917: per_ri_config_tech_summary.kf_grp_tab

1913: -------------------------------------------------------------------------- */
1914: PROCEDURE create_global_grp_cmp_cost_kf (p_configuration_code in varchar2
1915: ,p_technical_summary_mode in boolean default FALSE
1916: ,p_kf_grp_tab in out nocopy
1917: per_ri_config_tech_summary.kf_grp_tab
1918: ,p_kf_cmp_tab in out nocopy
1919: per_ri_config_tech_summary.kf_cmp_tab
1920: ,p_kf_cost_tab in out nocopy
1921: per_ri_config_tech_summary.kf_cost_tab

Line 1919: per_ri_config_tech_summary.kf_cmp_tab

1915: ,p_technical_summary_mode in boolean default FALSE
1916: ,p_kf_grp_tab in out nocopy
1917: per_ri_config_tech_summary.kf_grp_tab
1918: ,p_kf_cmp_tab in out nocopy
1919: per_ri_config_tech_summary.kf_cmp_tab
1920: ,p_kf_cost_tab in out nocopy
1921: per_ri_config_tech_summary.kf_cost_tab
1922: ,p_kf_grp_seg_tab in out nocopy
1923: per_ri_config_tech_summary.kf_grp_seg_tab

Line 1921: per_ri_config_tech_summary.kf_cost_tab

1917: per_ri_config_tech_summary.kf_grp_tab
1918: ,p_kf_cmp_tab in out nocopy
1919: per_ri_config_tech_summary.kf_cmp_tab
1920: ,p_kf_cost_tab in out nocopy
1921: per_ri_config_tech_summary.kf_cost_tab
1922: ,p_kf_grp_seg_tab in out nocopy
1923: per_ri_config_tech_summary.kf_grp_seg_tab
1924: ,p_kf_cmp_seg_tab in out nocopy
1925: per_ri_config_tech_summary.kf_cmp_seg_tab

Line 1923: per_ri_config_tech_summary.kf_grp_seg_tab

1919: per_ri_config_tech_summary.kf_cmp_tab
1920: ,p_kf_cost_tab in out nocopy
1921: per_ri_config_tech_summary.kf_cost_tab
1922: ,p_kf_grp_seg_tab in out nocopy
1923: per_ri_config_tech_summary.kf_grp_seg_tab
1924: ,p_kf_cmp_seg_tab in out nocopy
1925: per_ri_config_tech_summary.kf_cmp_seg_tab
1926: ,p_kf_cost_seg_tab in out nocopy
1927: per_ri_config_tech_summary.kf_cost_seg_tab) IS

Line 1925: per_ri_config_tech_summary.kf_cmp_seg_tab

1921: per_ri_config_tech_summary.kf_cost_tab
1922: ,p_kf_grp_seg_tab in out nocopy
1923: per_ri_config_tech_summary.kf_grp_seg_tab
1924: ,p_kf_cmp_seg_tab in out nocopy
1925: per_ri_config_tech_summary.kf_cmp_seg_tab
1926: ,p_kf_cost_seg_tab in out nocopy
1927: per_ri_config_tech_summary.kf_cost_seg_tab) IS
1928:
1929: l_kf_grp_tab per_ri_config_tech_summary.kf_grp_tab;

Line 1927: per_ri_config_tech_summary.kf_cost_seg_tab) IS

1923: per_ri_config_tech_summary.kf_grp_seg_tab
1924: ,p_kf_cmp_seg_tab in out nocopy
1925: per_ri_config_tech_summary.kf_cmp_seg_tab
1926: ,p_kf_cost_seg_tab in out nocopy
1927: per_ri_config_tech_summary.kf_cost_seg_tab) IS
1928:
1929: l_kf_grp_tab per_ri_config_tech_summary.kf_grp_tab;
1930: l_kf_cmp_tab per_ri_config_tech_summary.kf_cmp_tab;
1931: l_kf_cost_tab per_ri_config_tech_summary.kf_cost_tab;

Line 1929: l_kf_grp_tab per_ri_config_tech_summary.kf_grp_tab;

1925: per_ri_config_tech_summary.kf_cmp_seg_tab
1926: ,p_kf_cost_seg_tab in out nocopy
1927: per_ri_config_tech_summary.kf_cost_seg_tab) IS
1928:
1929: l_kf_grp_tab per_ri_config_tech_summary.kf_grp_tab;
1930: l_kf_cmp_tab per_ri_config_tech_summary.kf_cmp_tab;
1931: l_kf_cost_tab per_ri_config_tech_summary.kf_cost_tab;
1932:
1933: l_kf_grp_seg_tab per_ri_config_tech_summary.kf_grp_seg_tab;

Line 1930: l_kf_cmp_tab per_ri_config_tech_summary.kf_cmp_tab;

1926: ,p_kf_cost_seg_tab in out nocopy
1927: per_ri_config_tech_summary.kf_cost_seg_tab) IS
1928:
1929: l_kf_grp_tab per_ri_config_tech_summary.kf_grp_tab;
1930: l_kf_cmp_tab per_ri_config_tech_summary.kf_cmp_tab;
1931: l_kf_cost_tab per_ri_config_tech_summary.kf_cost_tab;
1932:
1933: l_kf_grp_seg_tab per_ri_config_tech_summary.kf_grp_seg_tab;
1934: l_kf_cmp_seg_tab per_ri_config_tech_summary.kf_cmp_seg_tab;

Line 1931: l_kf_cost_tab per_ri_config_tech_summary.kf_cost_tab;

1927: per_ri_config_tech_summary.kf_cost_seg_tab) IS
1928:
1929: l_kf_grp_tab per_ri_config_tech_summary.kf_grp_tab;
1930: l_kf_cmp_tab per_ri_config_tech_summary.kf_cmp_tab;
1931: l_kf_cost_tab per_ri_config_tech_summary.kf_cost_tab;
1932:
1933: l_kf_grp_seg_tab per_ri_config_tech_summary.kf_grp_seg_tab;
1934: l_kf_cmp_seg_tab per_ri_config_tech_summary.kf_cmp_seg_tab;
1935: l_kf_cost_seg_tab per_ri_config_tech_summary.kf_cost_seg_tab;

Line 1933: l_kf_grp_seg_tab per_ri_config_tech_summary.kf_grp_seg_tab;

1929: l_kf_grp_tab per_ri_config_tech_summary.kf_grp_tab;
1930: l_kf_cmp_tab per_ri_config_tech_summary.kf_cmp_tab;
1931: l_kf_cost_tab per_ri_config_tech_summary.kf_cost_tab;
1932:
1933: l_kf_grp_seg_tab per_ri_config_tech_summary.kf_grp_seg_tab;
1934: l_kf_cmp_seg_tab per_ri_config_tech_summary.kf_cmp_seg_tab;
1935: l_kf_cost_seg_tab per_ri_config_tech_summary.kf_cost_seg_tab;
1936:
1937: l_kf_grp_valueset_tab per_ri_config_tech_summary.valueset_tab;

Line 1934: l_kf_cmp_seg_tab per_ri_config_tech_summary.kf_cmp_seg_tab;

1930: l_kf_cmp_tab per_ri_config_tech_summary.kf_cmp_tab;
1931: l_kf_cost_tab per_ri_config_tech_summary.kf_cost_tab;
1932:
1933: l_kf_grp_seg_tab per_ri_config_tech_summary.kf_grp_seg_tab;
1934: l_kf_cmp_seg_tab per_ri_config_tech_summary.kf_cmp_seg_tab;
1935: l_kf_cost_seg_tab per_ri_config_tech_summary.kf_cost_seg_tab;
1936:
1937: l_kf_grp_valueset_tab per_ri_config_tech_summary.valueset_tab;
1938: l_kf_cmp_valueset_tab per_ri_config_tech_summary.valueset_tab;

Line 1935: l_kf_cost_seg_tab per_ri_config_tech_summary.kf_cost_seg_tab;

1931: l_kf_cost_tab per_ri_config_tech_summary.kf_cost_tab;
1932:
1933: l_kf_grp_seg_tab per_ri_config_tech_summary.kf_grp_seg_tab;
1934: l_kf_cmp_seg_tab per_ri_config_tech_summary.kf_cmp_seg_tab;
1935: l_kf_cost_seg_tab per_ri_config_tech_summary.kf_cost_seg_tab;
1936:
1937: l_kf_grp_valueset_tab per_ri_config_tech_summary.valueset_tab;
1938: l_kf_cmp_valueset_tab per_ri_config_tech_summary.valueset_tab;
1939: l_kf_cost_valueset_tab per_ri_config_tech_summary.valueset_tab;

Line 1937: l_kf_grp_valueset_tab per_ri_config_tech_summary.valueset_tab;

1933: l_kf_grp_seg_tab per_ri_config_tech_summary.kf_grp_seg_tab;
1934: l_kf_cmp_seg_tab per_ri_config_tech_summary.kf_cmp_seg_tab;
1935: l_kf_cost_seg_tab per_ri_config_tech_summary.kf_cost_seg_tab;
1936:
1937: l_kf_grp_valueset_tab per_ri_config_tech_summary.valueset_tab;
1938: l_kf_cmp_valueset_tab per_ri_config_tech_summary.valueset_tab;
1939: l_kf_cost_valueset_tab per_ri_config_tech_summary.valueset_tab;
1940: l_value_set_tab_count number(9) := 1;
1941:

Line 1938: l_kf_cmp_valueset_tab per_ri_config_tech_summary.valueset_tab;

1934: l_kf_cmp_seg_tab per_ri_config_tech_summary.kf_cmp_seg_tab;
1935: l_kf_cost_seg_tab per_ri_config_tech_summary.kf_cost_seg_tab;
1936:
1937: l_kf_grp_valueset_tab per_ri_config_tech_summary.valueset_tab;
1938: l_kf_cmp_valueset_tab per_ri_config_tech_summary.valueset_tab;
1939: l_kf_cost_valueset_tab per_ri_config_tech_summary.valueset_tab;
1940: l_value_set_tab_count number(9) := 1;
1941:
1942: l_proc varchar2(72) := g_package || 'create_global_grp_cmp_cost_kf';

Line 1939: l_kf_cost_valueset_tab per_ri_config_tech_summary.valueset_tab;

1935: l_kf_cost_seg_tab per_ri_config_tech_summary.kf_cost_seg_tab;
1936:
1937: l_kf_grp_valueset_tab per_ri_config_tech_summary.valueset_tab;
1938: l_kf_cmp_valueset_tab per_ri_config_tech_summary.valueset_tab;
1939: l_kf_cost_valueset_tab per_ri_config_tech_summary.valueset_tab;
1940: l_value_set_tab_count number(9) := 1;
1941:
1942: l_proc varchar2(72) := g_package || 'create_global_grp_cmp_cost_kf';
1943: l_error_message varchar2(360);

Line 2390: per_ri_config_tech_summary.kf_job_tab

2386:
2387: PROCEDURE create_global_job_pos_kf (p_configuration_code in varchar2
2388: ,p_technical_summary_mode in boolean default FALSE
2389: ,p_kf_job_tab in out nocopy
2390: per_ri_config_tech_summary.kf_job_tab
2391: ,p_kf_pos_tab in out nocopy
2392: per_ri_config_tech_summary.kf_pos_tab
2393: ,p_kf_job_seg_tab in out nocopy
2394: per_ri_config_tech_summary.kf_job_seg_tab

Line 2392: per_ri_config_tech_summary.kf_pos_tab

2388: ,p_technical_summary_mode in boolean default FALSE
2389: ,p_kf_job_tab in out nocopy
2390: per_ri_config_tech_summary.kf_job_tab
2391: ,p_kf_pos_tab in out nocopy
2392: per_ri_config_tech_summary.kf_pos_tab
2393: ,p_kf_job_seg_tab in out nocopy
2394: per_ri_config_tech_summary.kf_job_seg_tab
2395: ,p_kf_pos_seg_tab in out nocopy
2396: per_ri_config_tech_summary.kf_pos_seg_tab) IS

Line 2394: per_ri_config_tech_summary.kf_job_seg_tab

2390: per_ri_config_tech_summary.kf_job_tab
2391: ,p_kf_pos_tab in out nocopy
2392: per_ri_config_tech_summary.kf_pos_tab
2393: ,p_kf_job_seg_tab in out nocopy
2394: per_ri_config_tech_summary.kf_job_seg_tab
2395: ,p_kf_pos_seg_tab in out nocopy
2396: per_ri_config_tech_summary.kf_pos_seg_tab) IS
2397:
2398: l_proc varchar2(72) := g_package || 'create_global_job_pos_kf';

Line 2396: per_ri_config_tech_summary.kf_pos_seg_tab) IS

2392: per_ri_config_tech_summary.kf_pos_tab
2393: ,p_kf_job_seg_tab in out nocopy
2394: per_ri_config_tech_summary.kf_job_seg_tab
2395: ,p_kf_pos_seg_tab in out nocopy
2396: per_ri_config_tech_summary.kf_pos_seg_tab) IS
2397:
2398: l_proc varchar2(72) := g_package || 'create_global_job_pos_kf';
2399: l_configuration_code per_ri_config_information.configuration_code%type;
2400: l_jobs_fk_number number(9);

Line 2409: l_kf_job_tab per_ri_config_tech_summary.kf_job_tab;

2405: l_job_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
2406: l_pos_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
2407: l_enterprise_primary_industry per_ri_config_information.config_information1%type;
2408:
2409: l_kf_job_tab per_ri_config_tech_summary.kf_job_tab;
2410: l_kf_pos_tab per_ri_config_tech_summary.kf_pos_tab;
2411: l_kf_job_count number(8) :=0;
2412: l_kf_pos_count number(8) :=0;
2413:

Line 2410: l_kf_pos_tab per_ri_config_tech_summary.kf_pos_tab;

2406: l_pos_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
2407: l_enterprise_primary_industry per_ri_config_information.config_information1%type;
2408:
2409: l_kf_job_tab per_ri_config_tech_summary.kf_job_tab;
2410: l_kf_pos_tab per_ri_config_tech_summary.kf_pos_tab;
2411: l_kf_job_count number(8) :=0;
2412: l_kf_pos_count number(8) :=0;
2413:
2414: l_kf_job_seg_tab per_ri_config_tech_summary.kf_job_seg_tab;

Line 2414: l_kf_job_seg_tab per_ri_config_tech_summary.kf_job_seg_tab;

2410: l_kf_pos_tab per_ri_config_tech_summary.kf_pos_tab;
2411: l_kf_job_count number(8) :=0;
2412: l_kf_pos_count number(8) :=0;
2413:
2414: l_kf_job_seg_tab per_ri_config_tech_summary.kf_job_seg_tab;
2415: l_kf_pos_seg_tab per_ri_config_tech_summary.kf_pos_seg_tab;
2416: l_kf_job_seg_count number(8) :=0;
2417: l_kf_pos_seg_count number(8) :=0;
2418:

Line 2415: l_kf_pos_seg_tab per_ri_config_tech_summary.kf_pos_seg_tab;

2411: l_kf_job_count number(8) :=0;
2412: l_kf_pos_count number(8) :=0;
2413:
2414: l_kf_job_seg_tab per_ri_config_tech_summary.kf_job_seg_tab;
2415: l_kf_pos_seg_tab per_ri_config_tech_summary.kf_pos_seg_tab;
2416: l_kf_job_seg_count number(8) :=0;
2417: l_kf_pos_seg_count number(8) :=0;
2418:
2419: l_kf_job_valueset_tab per_ri_config_tech_summary.valueset_tab;

Line 2419: l_kf_job_valueset_tab per_ri_config_tech_summary.valueset_tab;

2415: l_kf_pos_seg_tab per_ri_config_tech_summary.kf_pos_seg_tab;
2416: l_kf_job_seg_count number(8) :=0;
2417: l_kf_pos_seg_count number(8) :=0;
2418:
2419: l_kf_job_valueset_tab per_ri_config_tech_summary.valueset_tab;
2420: l_kf_pos_valueset_tab per_ri_config_tech_summary.valueset_tab;
2421: l_value_set_tab_count number(9) := 1;
2422:
2423: l_log_message varchar2(360);

Line 2420: l_kf_pos_valueset_tab per_ri_config_tech_summary.valueset_tab;

2416: l_kf_job_seg_count number(8) :=0;
2417: l_kf_pos_seg_count number(8) :=0;
2418:
2419: l_kf_job_valueset_tab per_ri_config_tech_summary.valueset_tab;
2420: l_kf_pos_valueset_tab per_ri_config_tech_summary.valueset_tab;
2421: l_value_set_tab_count number(9) := 1;
2422:
2423: l_log_message varchar2(360);
2424: l_error_message varchar2(360);

Line 2984: per_ri_config_tech_summary.kf_pos_tab

2980:
2981: PROCEDURE create_global_pos_kf (p_configuration_code in varchar2
2982: ,p_technical_summary_mode in boolean default FALSE
2983: ,p_kf_pos_tab in out nocopy
2984: per_ri_config_tech_summary.kf_pos_tab
2985: ,p_kf_pos_seg_tab in out nocopy
2986: per_ri_config_tech_summary.kf_pos_seg_tab) IS
2987:
2988: l_proc varchar2(72) := g_package || 'create_global_pos_kf';

Line 2986: per_ri_config_tech_summary.kf_pos_seg_tab) IS

2982: ,p_technical_summary_mode in boolean default FALSE
2983: ,p_kf_pos_tab in out nocopy
2984: per_ri_config_tech_summary.kf_pos_tab
2985: ,p_kf_pos_seg_tab in out nocopy
2986: per_ri_config_tech_summary.kf_pos_seg_tab) IS
2987:
2988: l_proc varchar2(72) := g_package || 'create_global_pos_kf';
2989: l_configuration_code per_ri_config_information.configuration_code%type;
2990: l_position_fk_number number(9);

Line 2999: l_kf_pos_tab per_ri_config_tech_summary.kf_pos_tab;

2995: l_enterprise_primary_industry per_ri_config_information.config_information1%type;
2996: l_log_message varchar2(360);
2997: l_error_message varchar2(360);
2998:
2999: l_kf_pos_tab per_ri_config_tech_summary.kf_pos_tab;
3000: l_kf_pos_count number(8) :=0;
3001: l_kf_pos_seg_tab per_ri_config_tech_summary.kf_pos_seg_tab;
3002: l_kf_pos_seg_count number(8) :=0;
3003:

Line 3001: l_kf_pos_seg_tab per_ri_config_tech_summary.kf_pos_seg_tab;

2997: l_error_message varchar2(360);
2998:
2999: l_kf_pos_tab per_ri_config_tech_summary.kf_pos_tab;
3000: l_kf_pos_count number(8) :=0;
3001: l_kf_pos_seg_tab per_ri_config_tech_summary.kf_pos_seg_tab;
3002: l_kf_pos_seg_count number(8) :=0;
3003:
3004: l_kf_pos_valueset_tab per_ri_config_tech_summary.valueset_tab;
3005: l_value_set_tab_count number(9) := 1;

Line 3004: l_kf_pos_valueset_tab per_ri_config_tech_summary.valueset_tab;

3000: l_kf_pos_count number(8) :=0;
3001: l_kf_pos_seg_tab per_ri_config_tech_summary.kf_pos_seg_tab;
3002: l_kf_pos_seg_count number(8) :=0;
3003:
3004: l_kf_pos_valueset_tab per_ri_config_tech_summary.valueset_tab;
3005: l_value_set_tab_count number(9) := 1;
3006:
3007:
3008: BEGIN

Line 3399: per_ri_config_tech_summary.kf_grd_tab

3395: -------------------------------------------------------------------------- */
3396: PROCEDURE create_global_grd_kf (p_configuration_code in varchar2
3397: ,p_technical_summary_mode in boolean default FALSE
3398: ,p_kf_grd_tab in out nocopy
3399: per_ri_config_tech_summary.kf_grd_tab
3400: ,p_kf_grd_seg_tab in out nocopy
3401: per_ri_config_tech_summary.kf_grd_seg_tab) IS
3402:
3403: l_proc varchar2(72) := g_package || 'create_global_grd_kf';

Line 3401: per_ri_config_tech_summary.kf_grd_seg_tab) IS

3397: ,p_technical_summary_mode in boolean default FALSE
3398: ,p_kf_grd_tab in out nocopy
3399: per_ri_config_tech_summary.kf_grd_tab
3400: ,p_kf_grd_seg_tab in out nocopy
3401: per_ri_config_tech_summary.kf_grd_seg_tab) IS
3402:
3403: l_proc varchar2(72) := g_package || 'create_global_grd_kf';
3404: l_log_message varchar2(360);
3405: l_kf_grd_tab per_ri_config_tech_summary.kf_grd_tab;

Line 3405: l_kf_grd_tab per_ri_config_tech_summary.kf_grd_tab;

3401: per_ri_config_tech_summary.kf_grd_seg_tab) IS
3402:
3403: l_proc varchar2(72) := g_package || 'create_global_grd_kf';
3404: l_log_message varchar2(360);
3405: l_kf_grd_tab per_ri_config_tech_summary.kf_grd_tab;
3406: l_kf_grd_count number(8) := 0;
3407: l_error_message varchar2(360);
3408: l_kf_grd_seg_tab per_ri_config_tech_summary.kf_grd_seg_tab;
3409: l_kf_grd_seg_count number(8) := 0;

Line 3408: l_kf_grd_seg_tab per_ri_config_tech_summary.kf_grd_seg_tab;

3404: l_log_message varchar2(360);
3405: l_kf_grd_tab per_ri_config_tech_summary.kf_grd_tab;
3406: l_kf_grd_count number(8) := 0;
3407: l_error_message varchar2(360);
3408: l_kf_grd_seg_tab per_ri_config_tech_summary.kf_grd_seg_tab;
3409: l_kf_grd_seg_count number(8) := 0;
3410:
3411: l_configuration_code per_ri_config_information.configuration_code%type;
3412: l_grade_number number(9);

Line 3414: l_kf_grd_valueset_tab per_ri_config_tech_summary.valueset_tab;

3410:
3411: l_configuration_code per_ri_config_information.configuration_code%type;
3412: l_grade_number number(9);
3413:
3414: l_kf_grd_valueset_tab per_ri_config_tech_summary.valueset_tab;
3415: l_value_set_tab_count number(9) := 1;
3416:
3417: l_enterprise_short_name per_ri_config_information.configuration_code%type;
3418:

Line 3775: ,p_hrms_resp_tab in out nocopy per_ri_config_tech_summary.hrms_resp_tab) IS

3771:
3772: PROCEDURE create_hrms_responsibility (p_configuration_code in varchar2
3773: ,p_security_profile_tab in out nocopy security_profile_tab
3774: ,p_technical_summary_mode in boolean default FALSE
3775: ,p_hrms_resp_tab in out nocopy per_ri_config_tech_summary.hrms_resp_tab) IS
3776:
3777: cursor csr_get_country (cp_configuration_code in varchar2) IS
3778: select country_code
3779: from per_ri_config_country_v

Line 3861: l_hrms_bgsgut_profile_resp_tab per_ri_config_tech_summary.profile_resp_tab;

3857:
3858: l_configuration_user_name fnd_user.user_name%type;
3859:
3860: l_hrms_resp_count number(9) := 0;
3861: l_hrms_bgsgut_profile_resp_tab per_ri_config_tech_summary.profile_resp_tab;
3862: l_profile_resp_main_tab per_ri_config_tech_summary.profile_resp_tab;
3863:
3864: BEGIN
3865:

Line 3862: l_profile_resp_main_tab per_ri_config_tech_summary.profile_resp_tab;

3858: l_configuration_user_name fnd_user.user_name%type;
3859:
3860: l_hrms_resp_count number(9) := 0;
3861: l_hrms_bgsgut_profile_resp_tab per_ri_config_tech_summary.profile_resp_tab;
3862: l_profile_resp_main_tab per_ri_config_tech_summary.profile_resp_tab;
3863:
3864: BEGIN
3865:
3866: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 4187: per_ri_config_tech_summary.profile_apps_tab) IS

4183: -------------------------------------------------------------------------- */
4184: PROCEDURE create_application_level_resp(p_configuration_code in varchar2
4185: ,p_technical_summary_mode in boolean default FALSE
4186: ,p_profile_apps_tab in out nocopy
4187: per_ri_config_tech_summary.profile_apps_tab) IS
4188:
4189:
4190: cursor csr_get_product (cp_configuration_code in varchar2) IS
4191: select product_name

Line 4289: per_ri_config_tech_summary.profile_resp_tab) IS

4285: PROCEDURE create_resp_level_profile(p_configuration_code in varchar2
4286: ,p_responsibility_key in varchar2
4287: ,p_technical_summary_mode in boolean default FALSE
4288: ,p_profile_resp_tab in out nocopy
4289: per_ri_config_tech_summary.profile_resp_tab) IS
4290:
4291:
4292: cursor csr_get_product (cp_configuration_code in varchar2) IS
4293: select product_name

Line 4391: per_ri_config_tech_summary.profile_resp_tab) IS

4387: ,p_responsibility_key in varchar2
4388: ,p_business_group_name in varchar2
4389: ,p_technical_summary_mode in boolean default FALSE
4390: ,p_bg_sg_ut_profile_resp_tab in out nocopy
4391: per_ri_config_tech_summary.profile_resp_tab) IS
4392:
4393:
4394: cursor csr_get_resp_key_app (cp_responsibility_key in varchar2) IS
4395: select apps.application_short_name,resp.responsibility_id