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_TECH_SUMMARY dependencies on PER_RI_CONFIG_TECH_SUMMARY

Line 1: PACKAGE BODY per_ri_config_tech_summary AS

1: PACKAGE BODY per_ri_config_tech_summary AS
2: /* $Header: perricts.pkb 120.16 2012/01/19 09:57:47 rpahune ship $*/
3:
4: g_config_effective_date date := TRUNC(TO_DATE('1951/01/01', 'YYYY/MM/DD'));
5: g_config_effective_end_date date := TRUNC(TO_DATE('4712/12/31', 'YYYY/MM/DD'));

Line 6: g_package varchar2(30) := 'per_ri_config_tech_summary.';

2: /* $Header: perricts.pkb 120.16 2012/01/19 09:57:47 rpahune ship $*/
3:
4: g_config_effective_date date := TRUNC(TO_DATE('1951/01/01', 'YYYY/MM/DD'));
5: g_config_effective_end_date date := TRUNC(TO_DATE('4712/12/31', 'YYYY/MM/DD'));
6: g_package varchar2(30) := 'per_ri_config_tech_summary.';
7:
8:
9: FUNCTION get_clob_locator(p_table_name in varchar2)
10: return clob IS

Line 12: l_clob_rec per_ri_config_tech_summary.l_clob_rec_type;

8:
9: FUNCTION get_clob_locator(p_table_name in varchar2)
10: return clob IS
11:
12: l_clob_rec per_ri_config_tech_summary.l_clob_rec_type;
13: l_xmldoc_loc clob;
14: l_proc varchar2(73) := g_package || 'get_clob_locator';
15:
16: BEGIN

Line 34: FUNCTION get_business_grp_sql (p_business_grp_tab in out nocopy per_ri_config_tech_summary.bg_tab)

30: when others then
31: null;
32: END get_clob_locator;
33:
34: FUNCTION get_business_grp_sql (p_business_grp_tab in out nocopy per_ri_config_tech_summary.bg_tab)
35: return clob IS
36:
37: l_bg_clob clob;
38: l_ret_bg_clob clob;

Line 129: FUNCTION get_org_sql ( p_org_ent_tab in out nocopy per_ri_config_tech_summary.org_ent_tab

125: return l_ret_bg_clob;
126: END get_business_grp_sql;
127:
128:
129: FUNCTION get_org_sql ( p_org_ent_tab in out nocopy per_ri_config_tech_summary.org_ent_tab
130: ,p_org_oc_tab in out nocopy per_ri_config_tech_summary.org_oc_tab
131: ,p_org_le_tab in out nocopy per_ri_config_tech_summary.org_le_tab)
132: return clob IS
133:

Line 130: ,p_org_oc_tab in out nocopy per_ri_config_tech_summary.org_oc_tab

126: END get_business_grp_sql;
127:
128:
129: FUNCTION get_org_sql ( p_org_ent_tab in out nocopy per_ri_config_tech_summary.org_ent_tab
130: ,p_org_oc_tab in out nocopy per_ri_config_tech_summary.org_oc_tab
131: ,p_org_le_tab in out nocopy per_ri_config_tech_summary.org_le_tab)
132: return clob IS
133:
134: l_org_clob clob;

Line 131: ,p_org_le_tab in out nocopy per_ri_config_tech_summary.org_le_tab)

127:
128:
129: FUNCTION get_org_sql ( p_org_ent_tab in out nocopy per_ri_config_tech_summary.org_ent_tab
130: ,p_org_oc_tab in out nocopy per_ri_config_tech_summary.org_oc_tab
131: ,p_org_le_tab in out nocopy per_ri_config_tech_summary.org_le_tab)
132: return clob IS
133:
134: l_org_clob clob;
135: l_ret_org_clob clob;

Line 219: FUNCTION get_org_class_sql ( p_org_ent_class_tab in out nocopy per_ri_config_tech_summary.org_ent_class_tab

215: l_ret_org_clob := fetch_clob(l_org_clob,'Organization','Organizations');
216: return l_ret_org_clob;
217: end get_org_sql;
218:
219: FUNCTION get_org_class_sql ( p_org_ent_class_tab in out nocopy per_ri_config_tech_summary.org_ent_class_tab
220: ,p_org_oc_class_tab in out nocopy per_ri_config_tech_summary.org_oc_class_tab
221: ,p_org_le_class_tab in out nocopy per_ri_config_tech_summary.org_le_class_tab)
222: return clob IS
223:

Line 220: ,p_org_oc_class_tab in out nocopy per_ri_config_tech_summary.org_oc_class_tab

216: return l_ret_org_clob;
217: end get_org_sql;
218:
219: FUNCTION get_org_class_sql ( p_org_ent_class_tab in out nocopy per_ri_config_tech_summary.org_ent_class_tab
220: ,p_org_oc_class_tab in out nocopy per_ri_config_tech_summary.org_oc_class_tab
221: ,p_org_le_class_tab in out nocopy per_ri_config_tech_summary.org_le_class_tab)
222: return clob IS
223:
224: l_org_class_clob clob;

Line 221: ,p_org_le_class_tab in out nocopy per_ri_config_tech_summary.org_le_class_tab)

217: end get_org_sql;
218:
219: FUNCTION get_org_class_sql ( p_org_ent_class_tab in out nocopy per_ri_config_tech_summary.org_ent_class_tab
220: ,p_org_oc_class_tab in out nocopy per_ri_config_tech_summary.org_oc_class_tab
221: ,p_org_le_class_tab in out nocopy per_ri_config_tech_summary.org_le_class_tab)
222: return clob IS
223:
224: l_org_class_clob clob;
225: l_ret_org_class_clob clob;

Line 325: FUNCTION get_org_class_sql_for_pv ( p_org_ent_tab in per_ri_config_tech_summary.org_ent_tab

321: return l_ret_org_class_clob;
322:
323: END get_org_class_sql;
324:
325: FUNCTION get_org_class_sql_for_pv ( p_org_ent_tab in per_ri_config_tech_summary.org_ent_tab
326: ,p_org_oc_tab in per_ri_config_tech_summary.org_oc_tab
327: ,p_org_le_tab in per_ri_config_tech_summary.org_le_tab
328: ,p_org_ent_class_tab in per_ri_config_tech_summary.org_ent_class_tab
329: ,p_org_oc_class_tab in per_ri_config_tech_summary.org_oc_class_tab

Line 326: ,p_org_oc_tab in per_ri_config_tech_summary.org_oc_tab

322:
323: END get_org_class_sql;
324:
325: FUNCTION get_org_class_sql_for_pv ( p_org_ent_tab in per_ri_config_tech_summary.org_ent_tab
326: ,p_org_oc_tab in per_ri_config_tech_summary.org_oc_tab
327: ,p_org_le_tab in per_ri_config_tech_summary.org_le_tab
328: ,p_org_ent_class_tab in per_ri_config_tech_summary.org_ent_class_tab
329: ,p_org_oc_class_tab in per_ri_config_tech_summary.org_oc_class_tab
330: ,p_org_le_class_tab in per_ri_config_tech_summary.org_le_class_tab)

Line 327: ,p_org_le_tab in per_ri_config_tech_summary.org_le_tab

323: END get_org_class_sql;
324:
325: FUNCTION get_org_class_sql_for_pv ( p_org_ent_tab in per_ri_config_tech_summary.org_ent_tab
326: ,p_org_oc_tab in per_ri_config_tech_summary.org_oc_tab
327: ,p_org_le_tab in per_ri_config_tech_summary.org_le_tab
328: ,p_org_ent_class_tab in per_ri_config_tech_summary.org_ent_class_tab
329: ,p_org_oc_class_tab in per_ri_config_tech_summary.org_oc_class_tab
330: ,p_org_le_class_tab in per_ri_config_tech_summary.org_le_class_tab)
331: return clob IS

Line 328: ,p_org_ent_class_tab in per_ri_config_tech_summary.org_ent_class_tab

324:
325: FUNCTION get_org_class_sql_for_pv ( p_org_ent_tab in per_ri_config_tech_summary.org_ent_tab
326: ,p_org_oc_tab in per_ri_config_tech_summary.org_oc_tab
327: ,p_org_le_tab in per_ri_config_tech_summary.org_le_tab
328: ,p_org_ent_class_tab in per_ri_config_tech_summary.org_ent_class_tab
329: ,p_org_oc_class_tab in per_ri_config_tech_summary.org_oc_class_tab
330: ,p_org_le_class_tab in per_ri_config_tech_summary.org_le_class_tab)
331: return clob IS
332:

Line 329: ,p_org_oc_class_tab in per_ri_config_tech_summary.org_oc_class_tab

325: FUNCTION get_org_class_sql_for_pv ( p_org_ent_tab in per_ri_config_tech_summary.org_ent_tab
326: ,p_org_oc_tab in per_ri_config_tech_summary.org_oc_tab
327: ,p_org_le_tab in per_ri_config_tech_summary.org_le_tab
328: ,p_org_ent_class_tab in per_ri_config_tech_summary.org_ent_class_tab
329: ,p_org_oc_class_tab in per_ri_config_tech_summary.org_oc_class_tab
330: ,p_org_le_class_tab in per_ri_config_tech_summary.org_le_class_tab)
331: return clob IS
332:
333: l_org_class_clob_for_pv clob;

Line 330: ,p_org_le_class_tab in per_ri_config_tech_summary.org_le_class_tab)

326: ,p_org_oc_tab in per_ri_config_tech_summary.org_oc_tab
327: ,p_org_le_tab in per_ri_config_tech_summary.org_le_tab
328: ,p_org_ent_class_tab in per_ri_config_tech_summary.org_ent_class_tab
329: ,p_org_oc_class_tab in per_ri_config_tech_summary.org_oc_class_tab
330: ,p_org_le_class_tab in per_ri_config_tech_summary.org_le_class_tab)
331: return clob IS
332:
333: l_org_class_clob_for_pv clob;
334: l_org_class_append_clob_for_pv clob;

Line 516: FUNCTION get_locations_sql (p_location_tab in out nocopy per_ri_config_tech_summary.location_tab)

512:
513: return l_org_class_append_clob_for_pv;
514: END get_org_class_sql_for_pv;
515:
516: FUNCTION get_locations_sql (p_location_tab in out nocopy per_ri_config_tech_summary.location_tab)
517: return clob IS
518:
519: l_user_column_name varchar2(200);
520: l_proc varchar2(72) := g_package || 'get_locations_sql';

Line 638: FUNCTION get_user_sql (p_user_tab in out nocopy per_ri_config_tech_summary.user_tab)

634: return l_ret_location_clob;
635:
636: END get_locations_sql;
637:
638: FUNCTION get_user_sql (p_user_tab in out nocopy per_ri_config_tech_summary.user_tab)
639: return clob IS
640:
641: l_user_column_name varchar2(200);
642: l_proc varchar2(72) := g_package || 'get_user_sql';

Line 678: p_resp_tab in out nocopy per_ri_config_tech_summary.resp_tab

674: END get_user_sql;
675:
676:
677: FUNCTION get_resp_sql (
678: p_resp_tab in out nocopy per_ri_config_tech_summary.resp_tab
679: ,p_hrms_resp_tab in out nocopy per_ri_config_tech_summary.hrms_resp_tab
680: ,p_hrms_misc_resp_tab in out nocopy per_ri_config_tech_summary.hrms_resp_tab
681: )
682: return clob IS

Line 679: ,p_hrms_resp_tab in out nocopy per_ri_config_tech_summary.hrms_resp_tab

675:
676:
677: FUNCTION get_resp_sql (
678: p_resp_tab in out nocopy per_ri_config_tech_summary.resp_tab
679: ,p_hrms_resp_tab in out nocopy per_ri_config_tech_summary.hrms_resp_tab
680: ,p_hrms_misc_resp_tab in out nocopy per_ri_config_tech_summary.hrms_resp_tab
681: )
682: return clob IS
683:

Line 680: ,p_hrms_misc_resp_tab in out nocopy per_ri_config_tech_summary.hrms_resp_tab

676:
677: FUNCTION get_resp_sql (
678: p_resp_tab in out nocopy per_ri_config_tech_summary.resp_tab
679: ,p_hrms_resp_tab in out nocopy per_ri_config_tech_summary.hrms_resp_tab
680: ,p_hrms_misc_resp_tab in out nocopy per_ri_config_tech_summary.hrms_resp_tab
681: )
682: return clob IS
683:
684: l_user_column_name varchar2(200);

Line 780: p_profile_tab in out nocopy per_ri_config_tech_summary.profile_tab,

776: END get_resp_sql;
777:
778: --For site level profiles.
779: FUNCTION get_profile_sql (
780: p_profile_tab in out nocopy per_ri_config_tech_summary.profile_tab,
781: p_profile_dpe_ent_tab in out nocopy per_ri_config_tech_summary.profile_dpe_ent_tab
782: )
783: return clob IS
784:

Line 781: p_profile_dpe_ent_tab in out nocopy per_ri_config_tech_summary.profile_dpe_ent_tab

777:
778: --For site level profiles.
779: FUNCTION get_profile_sql (
780: p_profile_tab in out nocopy per_ri_config_tech_summary.profile_tab,
781: p_profile_dpe_ent_tab in out nocopy per_ri_config_tech_summary.profile_dpe_ent_tab
782: )
783: return clob IS
784:
785: l_user_column_name varchar2(200);

Line 878: p_profile_apps_tab in out nocopy per_ri_config_tech_summary.profile_apps_tab

874:
875:
876:
877: FUNCTION get_profile_apps_sql (
878: p_profile_apps_tab in out nocopy per_ri_config_tech_summary.profile_apps_tab
879: )
880: return clob IS
881:
882: l_user_column_name varchar2(200);

Line 934: p_profile_resp_tab in out nocopy per_ri_config_tech_summary.profile_resp_tab

930:
931: END get_profile_apps_sql;
932:
933: FUNCTION get_profile_resp_sql (
934: p_profile_resp_tab in out nocopy per_ri_config_tech_summary.profile_resp_tab
935: )
936: return clob IS
937:
938: l_user_column_name varchar2(200);

Line 999: p_kf_job_tab in out nocopy per_ri_config_tech_summary.kf_job_tab,

995: END get_profile_resp_sql;
996:
997: FUNCTION get_keyflex_structure_sql
998: (
999: p_kf_job_tab in out nocopy per_ri_config_tech_summary.kf_job_tab,
1000: p_kf_job_rv_tab in out nocopy per_ri_config_tech_summary.kf_job_rv_tab,
1001: p_kf_job_no_rv_tab in out nocopy per_ri_config_tech_summary.kf_job_no_rv_tab,
1002: p_kf_pos_tab in out nocopy per_ri_config_tech_summary.kf_pos_tab,
1003: p_kf_pos_rv_tab in out nocopy per_ri_config_tech_summary.kf_pos_rv_tab,

Line 1000: p_kf_job_rv_tab in out nocopy per_ri_config_tech_summary.kf_job_rv_tab,

996:
997: FUNCTION get_keyflex_structure_sql
998: (
999: p_kf_job_tab in out nocopy per_ri_config_tech_summary.kf_job_tab,
1000: p_kf_job_rv_tab in out nocopy per_ri_config_tech_summary.kf_job_rv_tab,
1001: p_kf_job_no_rv_tab in out nocopy per_ri_config_tech_summary.kf_job_no_rv_tab,
1002: p_kf_pos_tab in out nocopy per_ri_config_tech_summary.kf_pos_tab,
1003: p_kf_pos_rv_tab in out nocopy per_ri_config_tech_summary.kf_pos_rv_tab,
1004: p_kf_pos_no_rv_tab in out nocopy per_ri_config_tech_summary.kf_pos_no_rv_tab,

Line 1001: p_kf_job_no_rv_tab in out nocopy per_ri_config_tech_summary.kf_job_no_rv_tab,

997: FUNCTION get_keyflex_structure_sql
998: (
999: p_kf_job_tab in out nocopy per_ri_config_tech_summary.kf_job_tab,
1000: p_kf_job_rv_tab in out nocopy per_ri_config_tech_summary.kf_job_rv_tab,
1001: p_kf_job_no_rv_tab in out nocopy per_ri_config_tech_summary.kf_job_no_rv_tab,
1002: p_kf_pos_tab in out nocopy per_ri_config_tech_summary.kf_pos_tab,
1003: p_kf_pos_rv_tab in out nocopy per_ri_config_tech_summary.kf_pos_rv_tab,
1004: p_kf_pos_no_rv_tab in out nocopy per_ri_config_tech_summary.kf_pos_no_rv_tab,
1005: p_kf_grd_tab in out nocopy per_ri_config_tech_summary.kf_grd_tab,

Line 1002: p_kf_pos_tab in out nocopy per_ri_config_tech_summary.kf_pos_tab,

998: (
999: p_kf_job_tab in out nocopy per_ri_config_tech_summary.kf_job_tab,
1000: p_kf_job_rv_tab in out nocopy per_ri_config_tech_summary.kf_job_rv_tab,
1001: p_kf_job_no_rv_tab in out nocopy per_ri_config_tech_summary.kf_job_no_rv_tab,
1002: p_kf_pos_tab in out nocopy per_ri_config_tech_summary.kf_pos_tab,
1003: p_kf_pos_rv_tab in out nocopy per_ri_config_tech_summary.kf_pos_rv_tab,
1004: p_kf_pos_no_rv_tab in out nocopy per_ri_config_tech_summary.kf_pos_no_rv_tab,
1005: p_kf_grd_tab in out nocopy per_ri_config_tech_summary.kf_grd_tab,
1006: p_kf_grd_rv_tab in out nocopy per_ri_config_tech_summary.kf_grd_rv_tab,

Line 1003: p_kf_pos_rv_tab in out nocopy per_ri_config_tech_summary.kf_pos_rv_tab,

999: p_kf_job_tab in out nocopy per_ri_config_tech_summary.kf_job_tab,
1000: p_kf_job_rv_tab in out nocopy per_ri_config_tech_summary.kf_job_rv_tab,
1001: p_kf_job_no_rv_tab in out nocopy per_ri_config_tech_summary.kf_job_no_rv_tab,
1002: p_kf_pos_tab in out nocopy per_ri_config_tech_summary.kf_pos_tab,
1003: p_kf_pos_rv_tab in out nocopy per_ri_config_tech_summary.kf_pos_rv_tab,
1004: p_kf_pos_no_rv_tab in out nocopy per_ri_config_tech_summary.kf_pos_no_rv_tab,
1005: p_kf_grd_tab in out nocopy per_ri_config_tech_summary.kf_grd_tab,
1006: p_kf_grd_rv_tab in out nocopy per_ri_config_tech_summary.kf_grd_rv_tab,
1007: p_kf_grd_no_rv_tab in out nocopy per_ri_config_tech_summary.kf_grd_no_rv_tab,

Line 1004: p_kf_pos_no_rv_tab in out nocopy per_ri_config_tech_summary.kf_pos_no_rv_tab,

1000: p_kf_job_rv_tab in out nocopy per_ri_config_tech_summary.kf_job_rv_tab,
1001: p_kf_job_no_rv_tab in out nocopy per_ri_config_tech_summary.kf_job_no_rv_tab,
1002: p_kf_pos_tab in out nocopy per_ri_config_tech_summary.kf_pos_tab,
1003: p_kf_pos_rv_tab in out nocopy per_ri_config_tech_summary.kf_pos_rv_tab,
1004: p_kf_pos_no_rv_tab in out nocopy per_ri_config_tech_summary.kf_pos_no_rv_tab,
1005: p_kf_grd_tab in out nocopy per_ri_config_tech_summary.kf_grd_tab,
1006: p_kf_grd_rv_tab in out nocopy per_ri_config_tech_summary.kf_grd_rv_tab,
1007: p_kf_grd_no_rv_tab in out nocopy per_ri_config_tech_summary.kf_grd_no_rv_tab,
1008: p_kf_cmp_tab in out nocopy per_ri_config_tech_summary.kf_cmp_tab,

Line 1005: p_kf_grd_tab in out nocopy per_ri_config_tech_summary.kf_grd_tab,

1001: p_kf_job_no_rv_tab in out nocopy per_ri_config_tech_summary.kf_job_no_rv_tab,
1002: p_kf_pos_tab in out nocopy per_ri_config_tech_summary.kf_pos_tab,
1003: p_kf_pos_rv_tab in out nocopy per_ri_config_tech_summary.kf_pos_rv_tab,
1004: p_kf_pos_no_rv_tab in out nocopy per_ri_config_tech_summary.kf_pos_no_rv_tab,
1005: p_kf_grd_tab in out nocopy per_ri_config_tech_summary.kf_grd_tab,
1006: p_kf_grd_rv_tab in out nocopy per_ri_config_tech_summary.kf_grd_rv_tab,
1007: p_kf_grd_no_rv_tab in out nocopy per_ri_config_tech_summary.kf_grd_no_rv_tab,
1008: p_kf_cmp_tab in out nocopy per_ri_config_tech_summary.kf_cmp_tab,
1009: p_kf_grp_tab in out nocopy per_ri_config_tech_summary.kf_grp_tab,

Line 1006: p_kf_grd_rv_tab in out nocopy per_ri_config_tech_summary.kf_grd_rv_tab,

1002: p_kf_pos_tab in out nocopy per_ri_config_tech_summary.kf_pos_tab,
1003: p_kf_pos_rv_tab in out nocopy per_ri_config_tech_summary.kf_pos_rv_tab,
1004: p_kf_pos_no_rv_tab in out nocopy per_ri_config_tech_summary.kf_pos_no_rv_tab,
1005: p_kf_grd_tab in out nocopy per_ri_config_tech_summary.kf_grd_tab,
1006: p_kf_grd_rv_tab in out nocopy per_ri_config_tech_summary.kf_grd_rv_tab,
1007: p_kf_grd_no_rv_tab in out nocopy per_ri_config_tech_summary.kf_grd_no_rv_tab,
1008: p_kf_cmp_tab in out nocopy per_ri_config_tech_summary.kf_cmp_tab,
1009: p_kf_grp_tab in out nocopy per_ri_config_tech_summary.kf_grp_tab,
1010: p_kf_cost_tab in out nocopy per_ri_config_tech_summary.kf_cost_tab,

Line 1007: p_kf_grd_no_rv_tab in out nocopy per_ri_config_tech_summary.kf_grd_no_rv_tab,

1003: p_kf_pos_rv_tab in out nocopy per_ri_config_tech_summary.kf_pos_rv_tab,
1004: p_kf_pos_no_rv_tab in out nocopy per_ri_config_tech_summary.kf_pos_no_rv_tab,
1005: p_kf_grd_tab in out nocopy per_ri_config_tech_summary.kf_grd_tab,
1006: p_kf_grd_rv_tab in out nocopy per_ri_config_tech_summary.kf_grd_rv_tab,
1007: p_kf_grd_no_rv_tab in out nocopy per_ri_config_tech_summary.kf_grd_no_rv_tab,
1008: p_kf_cmp_tab in out nocopy per_ri_config_tech_summary.kf_cmp_tab,
1009: p_kf_grp_tab in out nocopy per_ri_config_tech_summary.kf_grp_tab,
1010: p_kf_cost_tab in out nocopy per_ri_config_tech_summary.kf_cost_tab,
1011: p_kf_job_str_clob out nocopy clob,

Line 1008: p_kf_cmp_tab in out nocopy per_ri_config_tech_summary.kf_cmp_tab,

1004: p_kf_pos_no_rv_tab in out nocopy per_ri_config_tech_summary.kf_pos_no_rv_tab,
1005: p_kf_grd_tab in out nocopy per_ri_config_tech_summary.kf_grd_tab,
1006: p_kf_grd_rv_tab in out nocopy per_ri_config_tech_summary.kf_grd_rv_tab,
1007: p_kf_grd_no_rv_tab in out nocopy per_ri_config_tech_summary.kf_grd_no_rv_tab,
1008: p_kf_cmp_tab in out nocopy per_ri_config_tech_summary.kf_cmp_tab,
1009: p_kf_grp_tab in out nocopy per_ri_config_tech_summary.kf_grp_tab,
1010: p_kf_cost_tab in out nocopy per_ri_config_tech_summary.kf_cost_tab,
1011: p_kf_job_str_clob out nocopy clob,
1012: p_kf_job_rv_str_clob out nocopy clob,

Line 1009: p_kf_grp_tab in out nocopy per_ri_config_tech_summary.kf_grp_tab,

1005: p_kf_grd_tab in out nocopy per_ri_config_tech_summary.kf_grd_tab,
1006: p_kf_grd_rv_tab in out nocopy per_ri_config_tech_summary.kf_grd_rv_tab,
1007: p_kf_grd_no_rv_tab in out nocopy per_ri_config_tech_summary.kf_grd_no_rv_tab,
1008: p_kf_cmp_tab in out nocopy per_ri_config_tech_summary.kf_cmp_tab,
1009: p_kf_grp_tab in out nocopy per_ri_config_tech_summary.kf_grp_tab,
1010: p_kf_cost_tab in out nocopy per_ri_config_tech_summary.kf_cost_tab,
1011: p_kf_job_str_clob out nocopy clob,
1012: p_kf_job_rv_str_clob out nocopy clob,
1013: p_kf_job_no_rv_str_clob out nocopy clob,

Line 1010: p_kf_cost_tab in out nocopy per_ri_config_tech_summary.kf_cost_tab,

1006: p_kf_grd_rv_tab in out nocopy per_ri_config_tech_summary.kf_grd_rv_tab,
1007: p_kf_grd_no_rv_tab in out nocopy per_ri_config_tech_summary.kf_grd_no_rv_tab,
1008: p_kf_cmp_tab in out nocopy per_ri_config_tech_summary.kf_cmp_tab,
1009: p_kf_grp_tab in out nocopy per_ri_config_tech_summary.kf_grp_tab,
1010: p_kf_cost_tab in out nocopy per_ri_config_tech_summary.kf_cost_tab,
1011: p_kf_job_str_clob out nocopy clob,
1012: p_kf_job_rv_str_clob out nocopy clob,
1013: p_kf_job_no_rv_str_clob out nocopy clob,
1014: p_kf_pos_str_clob out nocopy clob,

Line 1401: p_kf_job_seg_tab in out nocopy per_ri_config_tech_summary.kf_job_seg_tab,

1397:
1398:
1399: FUNCTION get_keyflex_segment_sql
1400: (
1401: p_kf_job_seg_tab in out nocopy per_ri_config_tech_summary.kf_job_seg_tab,
1402: p_kf_job_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_job_rv_seg_tab,
1403: p_kf_job_no_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_job_no_rv_seg_tab,
1404: p_kf_pos_seg_tab in out nocopy per_ri_config_tech_summary.kf_pos_seg_tab,
1405: p_kf_pos_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_pos_rv_seg_tab,

Line 1402: p_kf_job_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_job_rv_seg_tab,

1398:
1399: FUNCTION get_keyflex_segment_sql
1400: (
1401: p_kf_job_seg_tab in out nocopy per_ri_config_tech_summary.kf_job_seg_tab,
1402: p_kf_job_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_job_rv_seg_tab,
1403: p_kf_job_no_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_job_no_rv_seg_tab,
1404: p_kf_pos_seg_tab in out nocopy per_ri_config_tech_summary.kf_pos_seg_tab,
1405: p_kf_pos_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_pos_rv_seg_tab,
1406: p_kf_pos_no_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_pos_no_rv_seg_tab,

Line 1403: p_kf_job_no_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_job_no_rv_seg_tab,

1399: FUNCTION get_keyflex_segment_sql
1400: (
1401: p_kf_job_seg_tab in out nocopy per_ri_config_tech_summary.kf_job_seg_tab,
1402: p_kf_job_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_job_rv_seg_tab,
1403: p_kf_job_no_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_job_no_rv_seg_tab,
1404: p_kf_pos_seg_tab in out nocopy per_ri_config_tech_summary.kf_pos_seg_tab,
1405: p_kf_pos_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_pos_rv_seg_tab,
1406: p_kf_pos_no_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_pos_no_rv_seg_tab,
1407: p_kf_grd_seg_tab in out nocopy per_ri_config_tech_summary.kf_grd_seg_tab,

Line 1404: p_kf_pos_seg_tab in out nocopy per_ri_config_tech_summary.kf_pos_seg_tab,

1400: (
1401: p_kf_job_seg_tab in out nocopy per_ri_config_tech_summary.kf_job_seg_tab,
1402: p_kf_job_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_job_rv_seg_tab,
1403: p_kf_job_no_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_job_no_rv_seg_tab,
1404: p_kf_pos_seg_tab in out nocopy per_ri_config_tech_summary.kf_pos_seg_tab,
1405: p_kf_pos_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_pos_rv_seg_tab,
1406: p_kf_pos_no_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_pos_no_rv_seg_tab,
1407: p_kf_grd_seg_tab in out nocopy per_ri_config_tech_summary.kf_grd_seg_tab,
1408: p_kf_grd_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_grd_rv_seg_tab,

Line 1405: p_kf_pos_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_pos_rv_seg_tab,

1401: p_kf_job_seg_tab in out nocopy per_ri_config_tech_summary.kf_job_seg_tab,
1402: p_kf_job_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_job_rv_seg_tab,
1403: p_kf_job_no_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_job_no_rv_seg_tab,
1404: p_kf_pos_seg_tab in out nocopy per_ri_config_tech_summary.kf_pos_seg_tab,
1405: p_kf_pos_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_pos_rv_seg_tab,
1406: p_kf_pos_no_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_pos_no_rv_seg_tab,
1407: p_kf_grd_seg_tab in out nocopy per_ri_config_tech_summary.kf_grd_seg_tab,
1408: p_kf_grd_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_grd_rv_seg_tab,
1409: p_kf_grd_no_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_grd_no_rv_seg_tab,

Line 1406: p_kf_pos_no_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_pos_no_rv_seg_tab,

1402: p_kf_job_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_job_rv_seg_tab,
1403: p_kf_job_no_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_job_no_rv_seg_tab,
1404: p_kf_pos_seg_tab in out nocopy per_ri_config_tech_summary.kf_pos_seg_tab,
1405: p_kf_pos_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_pos_rv_seg_tab,
1406: p_kf_pos_no_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_pos_no_rv_seg_tab,
1407: p_kf_grd_seg_tab in out nocopy per_ri_config_tech_summary.kf_grd_seg_tab,
1408: p_kf_grd_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_grd_rv_seg_tab,
1409: p_kf_grd_no_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_grd_no_rv_seg_tab,
1410: p_kf_grp_seg_tab in out nocopy per_ri_config_tech_summary.kf_grp_seg_tab,

Line 1407: p_kf_grd_seg_tab in out nocopy per_ri_config_tech_summary.kf_grd_seg_tab,

1403: p_kf_job_no_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_job_no_rv_seg_tab,
1404: p_kf_pos_seg_tab in out nocopy per_ri_config_tech_summary.kf_pos_seg_tab,
1405: p_kf_pos_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_pos_rv_seg_tab,
1406: p_kf_pos_no_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_pos_no_rv_seg_tab,
1407: p_kf_grd_seg_tab in out nocopy per_ri_config_tech_summary.kf_grd_seg_tab,
1408: p_kf_grd_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_grd_rv_seg_tab,
1409: p_kf_grd_no_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_grd_no_rv_seg_tab,
1410: p_kf_grp_seg_tab in out nocopy per_ri_config_tech_summary.kf_grp_seg_tab,
1411: p_kf_cmp_seg_tab in out nocopy per_ri_config_tech_summary.kf_cmp_seg_tab,

Line 1408: p_kf_grd_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_grd_rv_seg_tab,

1404: p_kf_pos_seg_tab in out nocopy per_ri_config_tech_summary.kf_pos_seg_tab,
1405: p_kf_pos_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_pos_rv_seg_tab,
1406: p_kf_pos_no_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_pos_no_rv_seg_tab,
1407: p_kf_grd_seg_tab in out nocopy per_ri_config_tech_summary.kf_grd_seg_tab,
1408: p_kf_grd_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_grd_rv_seg_tab,
1409: p_kf_grd_no_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_grd_no_rv_seg_tab,
1410: p_kf_grp_seg_tab in out nocopy per_ri_config_tech_summary.kf_grp_seg_tab,
1411: p_kf_cmp_seg_tab in out nocopy per_ri_config_tech_summary.kf_cmp_seg_tab,
1412: p_kf_cost_seg_tab in out nocopy per_ri_config_tech_summary.kf_cost_seg_tab,

Line 1409: p_kf_grd_no_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_grd_no_rv_seg_tab,

1405: p_kf_pos_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_pos_rv_seg_tab,
1406: p_kf_pos_no_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_pos_no_rv_seg_tab,
1407: p_kf_grd_seg_tab in out nocopy per_ri_config_tech_summary.kf_grd_seg_tab,
1408: p_kf_grd_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_grd_rv_seg_tab,
1409: p_kf_grd_no_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_grd_no_rv_seg_tab,
1410: p_kf_grp_seg_tab in out nocopy per_ri_config_tech_summary.kf_grp_seg_tab,
1411: p_kf_cmp_seg_tab in out nocopy per_ri_config_tech_summary.kf_cmp_seg_tab,
1412: p_kf_cost_seg_tab in out nocopy per_ri_config_tech_summary.kf_cost_seg_tab,
1413: p_kf_job_seg_clob out nocopy clob,

Line 1410: p_kf_grp_seg_tab in out nocopy per_ri_config_tech_summary.kf_grp_seg_tab,

1406: p_kf_pos_no_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_pos_no_rv_seg_tab,
1407: p_kf_grd_seg_tab in out nocopy per_ri_config_tech_summary.kf_grd_seg_tab,
1408: p_kf_grd_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_grd_rv_seg_tab,
1409: p_kf_grd_no_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_grd_no_rv_seg_tab,
1410: p_kf_grp_seg_tab in out nocopy per_ri_config_tech_summary.kf_grp_seg_tab,
1411: p_kf_cmp_seg_tab in out nocopy per_ri_config_tech_summary.kf_cmp_seg_tab,
1412: p_kf_cost_seg_tab in out nocopy per_ri_config_tech_summary.kf_cost_seg_tab,
1413: p_kf_job_seg_clob out nocopy clob,
1414: p_kf_job_rv_seg_clob out nocopy clob,

Line 1411: p_kf_cmp_seg_tab in out nocopy per_ri_config_tech_summary.kf_cmp_seg_tab,

1407: p_kf_grd_seg_tab in out nocopy per_ri_config_tech_summary.kf_grd_seg_tab,
1408: p_kf_grd_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_grd_rv_seg_tab,
1409: p_kf_grd_no_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_grd_no_rv_seg_tab,
1410: p_kf_grp_seg_tab in out nocopy per_ri_config_tech_summary.kf_grp_seg_tab,
1411: p_kf_cmp_seg_tab in out nocopy per_ri_config_tech_summary.kf_cmp_seg_tab,
1412: p_kf_cost_seg_tab in out nocopy per_ri_config_tech_summary.kf_cost_seg_tab,
1413: p_kf_job_seg_clob out nocopy clob,
1414: p_kf_job_rv_seg_clob out nocopy clob,
1415: p_kf_job_no_rv_seg_clob out nocopy clob,

Line 1412: p_kf_cost_seg_tab in out nocopy per_ri_config_tech_summary.kf_cost_seg_tab,

1408: p_kf_grd_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_grd_rv_seg_tab,
1409: p_kf_grd_no_rv_seg_tab in out nocopy per_ri_config_tech_summary.kf_grd_no_rv_seg_tab,
1410: p_kf_grp_seg_tab in out nocopy per_ri_config_tech_summary.kf_grp_seg_tab,
1411: p_kf_cmp_seg_tab in out nocopy per_ri_config_tech_summary.kf_cmp_seg_tab,
1412: p_kf_cost_seg_tab in out nocopy per_ri_config_tech_summary.kf_cost_seg_tab,
1413: p_kf_job_seg_clob out nocopy clob,
1414: p_kf_job_rv_seg_clob out nocopy clob,
1415: p_kf_job_no_rv_seg_clob out nocopy clob,
1416: p_kf_pos_seg_clob out nocopy clob,

Line 2136: FUNCTION get_keyflex_str_seg_sql_for_pv (p_kf_job_tab in per_ri_config_tech_summary.kf_job_tab,

2132: return l_ret_kf_seg_clob;
2133:
2134: END get_keyflex_segment_sql;
2135:
2136: FUNCTION get_keyflex_str_seg_sql_for_pv (p_kf_job_tab in per_ri_config_tech_summary.kf_job_tab,
2137: p_kf_job_rv_tab in per_ri_config_tech_summary.kf_job_rv_tab,
2138: p_kf_job_no_rv_tab in per_ri_config_tech_summary.kf_job_no_rv_tab,
2139: p_kf_pos_tab in per_ri_config_tech_summary.kf_pos_tab,
2140: p_kf_pos_rv_tab in per_ri_config_tech_summary.kf_pos_rv_tab,

Line 2137: p_kf_job_rv_tab in per_ri_config_tech_summary.kf_job_rv_tab,

2133:
2134: END get_keyflex_segment_sql;
2135:
2136: FUNCTION get_keyflex_str_seg_sql_for_pv (p_kf_job_tab in per_ri_config_tech_summary.kf_job_tab,
2137: p_kf_job_rv_tab in per_ri_config_tech_summary.kf_job_rv_tab,
2138: p_kf_job_no_rv_tab in per_ri_config_tech_summary.kf_job_no_rv_tab,
2139: p_kf_pos_tab in per_ri_config_tech_summary.kf_pos_tab,
2140: p_kf_pos_rv_tab in per_ri_config_tech_summary.kf_pos_rv_tab,
2141: p_kf_pos_no_rv_tab in per_ri_config_tech_summary.kf_pos_no_rv_tab,

Line 2138: p_kf_job_no_rv_tab in per_ri_config_tech_summary.kf_job_no_rv_tab,

2134: END get_keyflex_segment_sql;
2135:
2136: FUNCTION get_keyflex_str_seg_sql_for_pv (p_kf_job_tab in per_ri_config_tech_summary.kf_job_tab,
2137: p_kf_job_rv_tab in per_ri_config_tech_summary.kf_job_rv_tab,
2138: p_kf_job_no_rv_tab in per_ri_config_tech_summary.kf_job_no_rv_tab,
2139: p_kf_pos_tab in per_ri_config_tech_summary.kf_pos_tab,
2140: p_kf_pos_rv_tab in per_ri_config_tech_summary.kf_pos_rv_tab,
2141: p_kf_pos_no_rv_tab in per_ri_config_tech_summary.kf_pos_no_rv_tab,
2142: p_kf_grd_tab in per_ri_config_tech_summary.kf_grd_tab,

Line 2139: p_kf_pos_tab in per_ri_config_tech_summary.kf_pos_tab,

2135:
2136: FUNCTION get_keyflex_str_seg_sql_for_pv (p_kf_job_tab in per_ri_config_tech_summary.kf_job_tab,
2137: p_kf_job_rv_tab in per_ri_config_tech_summary.kf_job_rv_tab,
2138: p_kf_job_no_rv_tab in per_ri_config_tech_summary.kf_job_no_rv_tab,
2139: p_kf_pos_tab in per_ri_config_tech_summary.kf_pos_tab,
2140: p_kf_pos_rv_tab in per_ri_config_tech_summary.kf_pos_rv_tab,
2141: p_kf_pos_no_rv_tab in per_ri_config_tech_summary.kf_pos_no_rv_tab,
2142: p_kf_grd_tab in per_ri_config_tech_summary.kf_grd_tab,
2143: p_kf_grd_rv_tab in per_ri_config_tech_summary.kf_grd_rv_tab,

Line 2140: p_kf_pos_rv_tab in per_ri_config_tech_summary.kf_pos_rv_tab,

2136: FUNCTION get_keyflex_str_seg_sql_for_pv (p_kf_job_tab in per_ri_config_tech_summary.kf_job_tab,
2137: p_kf_job_rv_tab in per_ri_config_tech_summary.kf_job_rv_tab,
2138: p_kf_job_no_rv_tab in per_ri_config_tech_summary.kf_job_no_rv_tab,
2139: p_kf_pos_tab in per_ri_config_tech_summary.kf_pos_tab,
2140: p_kf_pos_rv_tab in per_ri_config_tech_summary.kf_pos_rv_tab,
2141: p_kf_pos_no_rv_tab in per_ri_config_tech_summary.kf_pos_no_rv_tab,
2142: p_kf_grd_tab in per_ri_config_tech_summary.kf_grd_tab,
2143: p_kf_grd_rv_tab in per_ri_config_tech_summary.kf_grd_rv_tab,
2144: p_kf_grd_no_rv_tab in per_ri_config_tech_summary.kf_grd_no_rv_tab,

Line 2141: p_kf_pos_no_rv_tab in per_ri_config_tech_summary.kf_pos_no_rv_tab,

2137: p_kf_job_rv_tab in per_ri_config_tech_summary.kf_job_rv_tab,
2138: p_kf_job_no_rv_tab in per_ri_config_tech_summary.kf_job_no_rv_tab,
2139: p_kf_pos_tab in per_ri_config_tech_summary.kf_pos_tab,
2140: p_kf_pos_rv_tab in per_ri_config_tech_summary.kf_pos_rv_tab,
2141: p_kf_pos_no_rv_tab in per_ri_config_tech_summary.kf_pos_no_rv_tab,
2142: p_kf_grd_tab in per_ri_config_tech_summary.kf_grd_tab,
2143: p_kf_grd_rv_tab in per_ri_config_tech_summary.kf_grd_rv_tab,
2144: p_kf_grd_no_rv_tab in per_ri_config_tech_summary.kf_grd_no_rv_tab,
2145: p_kf_cmp_tab in per_ri_config_tech_summary.kf_cmp_tab,

Line 2142: p_kf_grd_tab in per_ri_config_tech_summary.kf_grd_tab,

2138: p_kf_job_no_rv_tab in per_ri_config_tech_summary.kf_job_no_rv_tab,
2139: p_kf_pos_tab in per_ri_config_tech_summary.kf_pos_tab,
2140: p_kf_pos_rv_tab in per_ri_config_tech_summary.kf_pos_rv_tab,
2141: p_kf_pos_no_rv_tab in per_ri_config_tech_summary.kf_pos_no_rv_tab,
2142: p_kf_grd_tab in per_ri_config_tech_summary.kf_grd_tab,
2143: p_kf_grd_rv_tab in per_ri_config_tech_summary.kf_grd_rv_tab,
2144: p_kf_grd_no_rv_tab in per_ri_config_tech_summary.kf_grd_no_rv_tab,
2145: p_kf_cmp_tab in per_ri_config_tech_summary.kf_cmp_tab,
2146: p_kf_grp_tab in per_ri_config_tech_summary.kf_grp_tab,

Line 2143: p_kf_grd_rv_tab in per_ri_config_tech_summary.kf_grd_rv_tab,

2139: p_kf_pos_tab in per_ri_config_tech_summary.kf_pos_tab,
2140: p_kf_pos_rv_tab in per_ri_config_tech_summary.kf_pos_rv_tab,
2141: p_kf_pos_no_rv_tab in per_ri_config_tech_summary.kf_pos_no_rv_tab,
2142: p_kf_grd_tab in per_ri_config_tech_summary.kf_grd_tab,
2143: p_kf_grd_rv_tab in per_ri_config_tech_summary.kf_grd_rv_tab,
2144: p_kf_grd_no_rv_tab in per_ri_config_tech_summary.kf_grd_no_rv_tab,
2145: p_kf_cmp_tab in per_ri_config_tech_summary.kf_cmp_tab,
2146: p_kf_grp_tab in per_ri_config_tech_summary.kf_grp_tab,
2147: p_kf_cost_tab in per_ri_config_tech_summary.kf_cost_tab,

Line 2144: p_kf_grd_no_rv_tab in per_ri_config_tech_summary.kf_grd_no_rv_tab,

2140: p_kf_pos_rv_tab in per_ri_config_tech_summary.kf_pos_rv_tab,
2141: p_kf_pos_no_rv_tab in per_ri_config_tech_summary.kf_pos_no_rv_tab,
2142: p_kf_grd_tab in per_ri_config_tech_summary.kf_grd_tab,
2143: p_kf_grd_rv_tab in per_ri_config_tech_summary.kf_grd_rv_tab,
2144: p_kf_grd_no_rv_tab in per_ri_config_tech_summary.kf_grd_no_rv_tab,
2145: p_kf_cmp_tab in per_ri_config_tech_summary.kf_cmp_tab,
2146: p_kf_grp_tab in per_ri_config_tech_summary.kf_grp_tab,
2147: p_kf_cost_tab in per_ri_config_tech_summary.kf_cost_tab,
2148: p_kf_job_seg_tab in per_ri_config_tech_summary.kf_job_seg_tab,

Line 2145: p_kf_cmp_tab in per_ri_config_tech_summary.kf_cmp_tab,

2141: p_kf_pos_no_rv_tab in per_ri_config_tech_summary.kf_pos_no_rv_tab,
2142: p_kf_grd_tab in per_ri_config_tech_summary.kf_grd_tab,
2143: p_kf_grd_rv_tab in per_ri_config_tech_summary.kf_grd_rv_tab,
2144: p_kf_grd_no_rv_tab in per_ri_config_tech_summary.kf_grd_no_rv_tab,
2145: p_kf_cmp_tab in per_ri_config_tech_summary.kf_cmp_tab,
2146: p_kf_grp_tab in per_ri_config_tech_summary.kf_grp_tab,
2147: p_kf_cost_tab in per_ri_config_tech_summary.kf_cost_tab,
2148: p_kf_job_seg_tab in per_ri_config_tech_summary.kf_job_seg_tab,
2149: p_kf_job_rv_seg_tab in per_ri_config_tech_summary.kf_job_rv_seg_tab,

Line 2146: p_kf_grp_tab in per_ri_config_tech_summary.kf_grp_tab,

2142: p_kf_grd_tab in per_ri_config_tech_summary.kf_grd_tab,
2143: p_kf_grd_rv_tab in per_ri_config_tech_summary.kf_grd_rv_tab,
2144: p_kf_grd_no_rv_tab in per_ri_config_tech_summary.kf_grd_no_rv_tab,
2145: p_kf_cmp_tab in per_ri_config_tech_summary.kf_cmp_tab,
2146: p_kf_grp_tab in per_ri_config_tech_summary.kf_grp_tab,
2147: p_kf_cost_tab in per_ri_config_tech_summary.kf_cost_tab,
2148: p_kf_job_seg_tab in per_ri_config_tech_summary.kf_job_seg_tab,
2149: p_kf_job_rv_seg_tab in per_ri_config_tech_summary.kf_job_rv_seg_tab,
2150: p_kf_job_no_rv_seg_tab in per_ri_config_tech_summary.kf_job_no_rv_seg_tab,

Line 2147: p_kf_cost_tab in per_ri_config_tech_summary.kf_cost_tab,

2143: p_kf_grd_rv_tab in per_ri_config_tech_summary.kf_grd_rv_tab,
2144: p_kf_grd_no_rv_tab in per_ri_config_tech_summary.kf_grd_no_rv_tab,
2145: p_kf_cmp_tab in per_ri_config_tech_summary.kf_cmp_tab,
2146: p_kf_grp_tab in per_ri_config_tech_summary.kf_grp_tab,
2147: p_kf_cost_tab in per_ri_config_tech_summary.kf_cost_tab,
2148: p_kf_job_seg_tab in per_ri_config_tech_summary.kf_job_seg_tab,
2149: p_kf_job_rv_seg_tab in per_ri_config_tech_summary.kf_job_rv_seg_tab,
2150: p_kf_job_no_rv_seg_tab in per_ri_config_tech_summary.kf_job_no_rv_seg_tab,
2151: p_kf_pos_seg_tab in per_ri_config_tech_summary.kf_pos_seg_tab,

Line 2148: p_kf_job_seg_tab in per_ri_config_tech_summary.kf_job_seg_tab,

2144: p_kf_grd_no_rv_tab in per_ri_config_tech_summary.kf_grd_no_rv_tab,
2145: p_kf_cmp_tab in per_ri_config_tech_summary.kf_cmp_tab,
2146: p_kf_grp_tab in per_ri_config_tech_summary.kf_grp_tab,
2147: p_kf_cost_tab in per_ri_config_tech_summary.kf_cost_tab,
2148: p_kf_job_seg_tab in per_ri_config_tech_summary.kf_job_seg_tab,
2149: p_kf_job_rv_seg_tab in per_ri_config_tech_summary.kf_job_rv_seg_tab,
2150: p_kf_job_no_rv_seg_tab in per_ri_config_tech_summary.kf_job_no_rv_seg_tab,
2151: p_kf_pos_seg_tab in per_ri_config_tech_summary.kf_pos_seg_tab,
2152: p_kf_pos_rv_seg_tab in per_ri_config_tech_summary.kf_pos_rv_seg_tab,

Line 2149: p_kf_job_rv_seg_tab in per_ri_config_tech_summary.kf_job_rv_seg_tab,

2145: p_kf_cmp_tab in per_ri_config_tech_summary.kf_cmp_tab,
2146: p_kf_grp_tab in per_ri_config_tech_summary.kf_grp_tab,
2147: p_kf_cost_tab in per_ri_config_tech_summary.kf_cost_tab,
2148: p_kf_job_seg_tab in per_ri_config_tech_summary.kf_job_seg_tab,
2149: p_kf_job_rv_seg_tab in per_ri_config_tech_summary.kf_job_rv_seg_tab,
2150: p_kf_job_no_rv_seg_tab in per_ri_config_tech_summary.kf_job_no_rv_seg_tab,
2151: p_kf_pos_seg_tab in per_ri_config_tech_summary.kf_pos_seg_tab,
2152: p_kf_pos_rv_seg_tab in per_ri_config_tech_summary.kf_pos_rv_seg_tab,
2153: p_kf_pos_no_rv_seg_tab in per_ri_config_tech_summary.kf_pos_no_rv_seg_tab,

Line 2150: p_kf_job_no_rv_seg_tab in per_ri_config_tech_summary.kf_job_no_rv_seg_tab,

2146: p_kf_grp_tab in per_ri_config_tech_summary.kf_grp_tab,
2147: p_kf_cost_tab in per_ri_config_tech_summary.kf_cost_tab,
2148: p_kf_job_seg_tab in per_ri_config_tech_summary.kf_job_seg_tab,
2149: p_kf_job_rv_seg_tab in per_ri_config_tech_summary.kf_job_rv_seg_tab,
2150: p_kf_job_no_rv_seg_tab in per_ri_config_tech_summary.kf_job_no_rv_seg_tab,
2151: p_kf_pos_seg_tab in per_ri_config_tech_summary.kf_pos_seg_tab,
2152: p_kf_pos_rv_seg_tab in per_ri_config_tech_summary.kf_pos_rv_seg_tab,
2153: p_kf_pos_no_rv_seg_tab in per_ri_config_tech_summary.kf_pos_no_rv_seg_tab,
2154: p_kf_grd_seg_tab in per_ri_config_tech_summary.kf_grd_seg_tab,

Line 2151: p_kf_pos_seg_tab in per_ri_config_tech_summary.kf_pos_seg_tab,

2147: p_kf_cost_tab in per_ri_config_tech_summary.kf_cost_tab,
2148: p_kf_job_seg_tab in per_ri_config_tech_summary.kf_job_seg_tab,
2149: p_kf_job_rv_seg_tab in per_ri_config_tech_summary.kf_job_rv_seg_tab,
2150: p_kf_job_no_rv_seg_tab in per_ri_config_tech_summary.kf_job_no_rv_seg_tab,
2151: p_kf_pos_seg_tab in per_ri_config_tech_summary.kf_pos_seg_tab,
2152: p_kf_pos_rv_seg_tab in per_ri_config_tech_summary.kf_pos_rv_seg_tab,
2153: p_kf_pos_no_rv_seg_tab in per_ri_config_tech_summary.kf_pos_no_rv_seg_tab,
2154: p_kf_grd_seg_tab in per_ri_config_tech_summary.kf_grd_seg_tab,
2155: p_kf_grd_rv_seg_tab in per_ri_config_tech_summary.kf_grd_rv_seg_tab,

Line 2152: p_kf_pos_rv_seg_tab in per_ri_config_tech_summary.kf_pos_rv_seg_tab,

2148: p_kf_job_seg_tab in per_ri_config_tech_summary.kf_job_seg_tab,
2149: p_kf_job_rv_seg_tab in per_ri_config_tech_summary.kf_job_rv_seg_tab,
2150: p_kf_job_no_rv_seg_tab in per_ri_config_tech_summary.kf_job_no_rv_seg_tab,
2151: p_kf_pos_seg_tab in per_ri_config_tech_summary.kf_pos_seg_tab,
2152: p_kf_pos_rv_seg_tab in per_ri_config_tech_summary.kf_pos_rv_seg_tab,
2153: p_kf_pos_no_rv_seg_tab in per_ri_config_tech_summary.kf_pos_no_rv_seg_tab,
2154: p_kf_grd_seg_tab in per_ri_config_tech_summary.kf_grd_seg_tab,
2155: p_kf_grd_rv_seg_tab in per_ri_config_tech_summary.kf_grd_rv_seg_tab,
2156: p_kf_grd_no_rv_seg_tab in per_ri_config_tech_summary.kf_grd_no_rv_seg_tab,

Line 2153: p_kf_pos_no_rv_seg_tab in per_ri_config_tech_summary.kf_pos_no_rv_seg_tab,

2149: p_kf_job_rv_seg_tab in per_ri_config_tech_summary.kf_job_rv_seg_tab,
2150: p_kf_job_no_rv_seg_tab in per_ri_config_tech_summary.kf_job_no_rv_seg_tab,
2151: p_kf_pos_seg_tab in per_ri_config_tech_summary.kf_pos_seg_tab,
2152: p_kf_pos_rv_seg_tab in per_ri_config_tech_summary.kf_pos_rv_seg_tab,
2153: p_kf_pos_no_rv_seg_tab in per_ri_config_tech_summary.kf_pos_no_rv_seg_tab,
2154: p_kf_grd_seg_tab in per_ri_config_tech_summary.kf_grd_seg_tab,
2155: p_kf_grd_rv_seg_tab in per_ri_config_tech_summary.kf_grd_rv_seg_tab,
2156: p_kf_grd_no_rv_seg_tab in per_ri_config_tech_summary.kf_grd_no_rv_seg_tab,
2157: p_kf_grp_seg_tab in per_ri_config_tech_summary.kf_grp_seg_tab,

Line 2154: p_kf_grd_seg_tab in per_ri_config_tech_summary.kf_grd_seg_tab,

2150: p_kf_job_no_rv_seg_tab in per_ri_config_tech_summary.kf_job_no_rv_seg_tab,
2151: p_kf_pos_seg_tab in per_ri_config_tech_summary.kf_pos_seg_tab,
2152: p_kf_pos_rv_seg_tab in per_ri_config_tech_summary.kf_pos_rv_seg_tab,
2153: p_kf_pos_no_rv_seg_tab in per_ri_config_tech_summary.kf_pos_no_rv_seg_tab,
2154: p_kf_grd_seg_tab in per_ri_config_tech_summary.kf_grd_seg_tab,
2155: p_kf_grd_rv_seg_tab in per_ri_config_tech_summary.kf_grd_rv_seg_tab,
2156: p_kf_grd_no_rv_seg_tab in per_ri_config_tech_summary.kf_grd_no_rv_seg_tab,
2157: p_kf_grp_seg_tab in per_ri_config_tech_summary.kf_grp_seg_tab,
2158: p_kf_cmp_seg_tab in per_ri_config_tech_summary.kf_cmp_seg_tab,

Line 2155: p_kf_grd_rv_seg_tab in per_ri_config_tech_summary.kf_grd_rv_seg_tab,

2151: p_kf_pos_seg_tab in per_ri_config_tech_summary.kf_pos_seg_tab,
2152: p_kf_pos_rv_seg_tab in per_ri_config_tech_summary.kf_pos_rv_seg_tab,
2153: p_kf_pos_no_rv_seg_tab in per_ri_config_tech_summary.kf_pos_no_rv_seg_tab,
2154: p_kf_grd_seg_tab in per_ri_config_tech_summary.kf_grd_seg_tab,
2155: p_kf_grd_rv_seg_tab in per_ri_config_tech_summary.kf_grd_rv_seg_tab,
2156: p_kf_grd_no_rv_seg_tab in per_ri_config_tech_summary.kf_grd_no_rv_seg_tab,
2157: p_kf_grp_seg_tab in per_ri_config_tech_summary.kf_grp_seg_tab,
2158: p_kf_cmp_seg_tab in per_ri_config_tech_summary.kf_cmp_seg_tab,
2159: p_kf_cost_seg_tab in per_ri_config_tech_summary.kf_cost_seg_tab)

Line 2156: p_kf_grd_no_rv_seg_tab in per_ri_config_tech_summary.kf_grd_no_rv_seg_tab,

2152: p_kf_pos_rv_seg_tab in per_ri_config_tech_summary.kf_pos_rv_seg_tab,
2153: p_kf_pos_no_rv_seg_tab in per_ri_config_tech_summary.kf_pos_no_rv_seg_tab,
2154: p_kf_grd_seg_tab in per_ri_config_tech_summary.kf_grd_seg_tab,
2155: p_kf_grd_rv_seg_tab in per_ri_config_tech_summary.kf_grd_rv_seg_tab,
2156: p_kf_grd_no_rv_seg_tab in per_ri_config_tech_summary.kf_grd_no_rv_seg_tab,
2157: p_kf_grp_seg_tab in per_ri_config_tech_summary.kf_grp_seg_tab,
2158: p_kf_cmp_seg_tab in per_ri_config_tech_summary.kf_cmp_seg_tab,
2159: p_kf_cost_seg_tab in per_ri_config_tech_summary.kf_cost_seg_tab)
2160: return clob IS

Line 2157: p_kf_grp_seg_tab in per_ri_config_tech_summary.kf_grp_seg_tab,

2153: p_kf_pos_no_rv_seg_tab in per_ri_config_tech_summary.kf_pos_no_rv_seg_tab,
2154: p_kf_grd_seg_tab in per_ri_config_tech_summary.kf_grd_seg_tab,
2155: p_kf_grd_rv_seg_tab in per_ri_config_tech_summary.kf_grd_rv_seg_tab,
2156: p_kf_grd_no_rv_seg_tab in per_ri_config_tech_summary.kf_grd_no_rv_seg_tab,
2157: p_kf_grp_seg_tab in per_ri_config_tech_summary.kf_grp_seg_tab,
2158: p_kf_cmp_seg_tab in per_ri_config_tech_summary.kf_cmp_seg_tab,
2159: p_kf_cost_seg_tab in per_ri_config_tech_summary.kf_cost_seg_tab)
2160: return clob IS
2161: l_str_seg_append_clob_for_pv clob;

Line 2158: p_kf_cmp_seg_tab in per_ri_config_tech_summary.kf_cmp_seg_tab,

2154: p_kf_grd_seg_tab in per_ri_config_tech_summary.kf_grd_seg_tab,
2155: p_kf_grd_rv_seg_tab in per_ri_config_tech_summary.kf_grd_rv_seg_tab,
2156: p_kf_grd_no_rv_seg_tab in per_ri_config_tech_summary.kf_grd_no_rv_seg_tab,
2157: p_kf_grp_seg_tab in per_ri_config_tech_summary.kf_grp_seg_tab,
2158: p_kf_cmp_seg_tab in per_ri_config_tech_summary.kf_cmp_seg_tab,
2159: p_kf_cost_seg_tab in per_ri_config_tech_summary.kf_cost_seg_tab)
2160: return clob IS
2161: l_str_seg_append_clob_for_pv clob;
2162: l_proc varchar2(200) := 'get_keyflex_str_seg_sql_for_pv';

Line 2159: p_kf_cost_seg_tab in per_ri_config_tech_summary.kf_cost_seg_tab)

2155: p_kf_grd_rv_seg_tab in per_ri_config_tech_summary.kf_grd_rv_seg_tab,
2156: p_kf_grd_no_rv_seg_tab in per_ri_config_tech_summary.kf_grd_no_rv_seg_tab,
2157: p_kf_grp_seg_tab in per_ri_config_tech_summary.kf_grp_seg_tab,
2158: p_kf_cmp_seg_tab in per_ri_config_tech_summary.kf_cmp_seg_tab,
2159: p_kf_cost_seg_tab in per_ri_config_tech_summary.kf_cost_seg_tab)
2160: return clob IS
2161: l_str_seg_append_clob_for_pv clob;
2162: l_proc varchar2(200) := 'get_keyflex_str_seg_sql_for_pv';
2163: l_structure_tab per_ri_config_tech_summary.kf_structure_tab;

Line 2163: l_structure_tab per_ri_config_tech_summary.kf_structure_tab;

2159: p_kf_cost_seg_tab in per_ri_config_tech_summary.kf_cost_seg_tab)
2160: return clob IS
2161: l_str_seg_append_clob_for_pv clob;
2162: l_proc varchar2(200) := 'get_keyflex_str_seg_sql_for_pv';
2163: l_structure_tab per_ri_config_tech_summary.kf_structure_tab;
2164: l_segment_tab per_ri_config_tech_summary.kf_segment_tab;
2165:
2166:
2167:

Line 2164: l_segment_tab per_ri_config_tech_summary.kf_segment_tab;

2160: return clob IS
2161: l_str_seg_append_clob_for_pv clob;
2162: l_proc varchar2(200) := 'get_keyflex_str_seg_sql_for_pv';
2163: l_structure_tab per_ri_config_tech_summary.kf_structure_tab;
2164: l_segment_tab per_ri_config_tech_summary.kf_segment_tab;
2165:
2166:
2167:
2168: BEGIN

Line 2759: ( p_kf_structure_tab in per_ri_config_tech_summary.kf_structure_tab,

2755:
2756: END get_keyflex_str_seg_sql_for_pv;
2757:
2758: FUNCTION get_keyflex_str_seg_dat_for_pv
2759: ( p_kf_structure_tab in per_ri_config_tech_summary.kf_structure_tab,
2760: p_kf_segment_tab in per_ri_config_tech_summary.kf_segment_tab,
2761: p_keyflex_name in varchar2
2762: ) return clob IS
2763:

Line 2760: p_kf_segment_tab in per_ri_config_tech_summary.kf_segment_tab,

2756: END get_keyflex_str_seg_sql_for_pv;
2757:
2758: FUNCTION get_keyflex_str_seg_dat_for_pv
2759: ( p_kf_structure_tab in per_ri_config_tech_summary.kf_structure_tab,
2760: p_kf_segment_tab in per_ri_config_tech_summary.kf_segment_tab,
2761: p_keyflex_name in varchar2
2762: ) return clob IS
2763:
2764: l_str_seg_append_clob_for_pv clob;

Line 3055: p_int_hrms_setup_tab in out nocopy per_ri_config_tech_summary.int_hrms_setup_tab

3051:
3052:
3053:
3054: FUNCTION get_int_hrms_setup_sql (
3055: p_int_hrms_setup_tab in out nocopy per_ri_config_tech_summary.int_hrms_setup_tab
3056: )
3057: return clob IS
3058:
3059:

Line 3117: p_security_profile_tab in out nocopy per_ri_config_tech_summary.sg_tab

3113: return l_ret_kf_int_hr_clob;
3114: END get_int_hrms_setup_sql;
3115:
3116: FUNCTION get_security_profile_sql (
3117: p_security_profile_tab in out nocopy per_ri_config_tech_summary.sg_tab
3118: )
3119: return clob IS
3120:
3121: l_proc varchar2(72) := g_package || ' get_security_profile_sql';

Line 3172: p_org_hierarchy_tab in out nocopy per_ri_config_tech_summary.org_hierarchy_tab

3168: END get_security_profile_sql;
3169:
3170:
3171: FUNCTION get_org_hierarchy_sql (
3172: p_org_hierarchy_tab in out nocopy per_ri_config_tech_summary.org_hierarchy_tab
3173: )
3174: return clob IS
3175:
3176: l_proc varchar2(72) := g_package || ' get_org_hierarchy_sql';

Line 3214: p_org_hierarchy_ele_oc_tab in out nocopy per_ri_config_tech_summary.org_hierarchy_ele_oc_tab

3210:
3211: END get_org_hierarchy_sql;
3212:
3213: FUNCTION get_org_hierarchy_ele_sql (
3214: p_org_hierarchy_ele_oc_tab in out nocopy per_ri_config_tech_summary.org_hierarchy_ele_oc_tab
3215: ,p_org_hierarchy_ele_le_tab in out nocopy per_ri_config_tech_summary.org_hierarchy_ele_le_tab
3216: )
3217: return clob IS
3218: l_proc varchar2(72) := g_package || ' get_org_hierarchy_ele_sql';

Line 3215: ,p_org_hierarchy_ele_le_tab in out nocopy per_ri_config_tech_summary.org_hierarchy_ele_le_tab

3211: END get_org_hierarchy_sql;
3212:
3213: FUNCTION get_org_hierarchy_ele_sql (
3214: p_org_hierarchy_ele_oc_tab in out nocopy per_ri_config_tech_summary.org_hierarchy_ele_oc_tab
3215: ,p_org_hierarchy_ele_le_tab in out nocopy per_ri_config_tech_summary.org_hierarchy_ele_le_tab
3216: )
3217: return clob IS
3218: l_proc varchar2(72) := g_package || ' get_org_hierarchy_ele_sql';
3219: i number(8) := 0;

Line 3272: p_org_hierarchy_ele_oc_tab in out nocopy per_ri_config_tech_summary.org_hierarchy_ele_oc_tab

3268:
3269: END get_org_hierarchy_ele_sql;
3270:
3271: FUNCTION get_org_hier_ele_sql_for_pv (
3272: p_org_hierarchy_ele_oc_tab in out nocopy per_ri_config_tech_summary.org_hierarchy_ele_oc_tab
3273: ,p_org_hierarchy_ele_le_tab in out nocopy per_ri_config_tech_summary.org_hierarchy_ele_le_tab
3274: )
3275: return clob IS
3276: l_proc varchar2(72) := g_package || ' get_org_hierarchy_ele_sql_for_pv';

Line 3273: ,p_org_hierarchy_ele_le_tab in out nocopy per_ri_config_tech_summary.org_hierarchy_ele_le_tab

3269: END get_org_hierarchy_ele_sql;
3270:
3271: FUNCTION get_org_hier_ele_sql_for_pv (
3272: p_org_hierarchy_ele_oc_tab in out nocopy per_ri_config_tech_summary.org_hierarchy_ele_oc_tab
3273: ,p_org_hierarchy_ele_le_tab in out nocopy per_ri_config_tech_summary.org_hierarchy_ele_le_tab
3274: )
3275: return clob IS
3276: l_proc varchar2(72) := g_package || ' get_org_hierarchy_ele_sql_for_pv';
3277: i number(8) := 0;

Line 3364: p_post_install_tab in out nocopy per_ri_config_tech_summary.post_install_tab

3360: END get_org_hier_ele_sql_for_pv;
3361:
3362:
3363: FUNCTION get_post_install_sql (
3364: p_post_install_tab in out nocopy per_ri_config_tech_summary.post_install_tab
3365: )
3366: return clob IS
3367: l_proc varchar2(72) := g_package || 'get_post_install_sql';
3368: i number(8) := 0;

Line 3459: END per_ri_config_tech_summary;

3455: hr_utility.set_location('Leaving ' || l_proc,20);
3456: return l_ret_in_clob;
3457: END fetch_clob;
3458:
3459: END per_ri_config_tech_summary;