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.GHR_HISTORY_FETCH dependencies on GHR_HISTORY_API

Line 1126: p_table_name => ghr_history_api.g_peop_table,

1122: close per_people_f_cursor;
1123: hr_utility.set_location( l_proc, 25);
1124: else
1125: Fetch_hist_data(
1126: p_table_name => ghr_history_api.g_peop_table,
1127: p_information1 => p_person_id,
1128: p_date_effective => p_date_effective,
1129: p_altered_pa_request_id => p_altered_pa_request_id,
1130: p_noa_id_corrected => p_noa_id_corrected,

Line 1192: p_table_name => ghr_history_api.g_asgnei_table,

1188: close per_asgei_rowid_cursor;
1189: hr_utility.set_location( l_proc, 15);
1190: else
1191: Fetch_hist_data(
1192: p_table_name => ghr_history_api.g_asgnei_table,
1193: p_information1 => p_assignment_extra_info_id,
1194: p_date_effective => p_date_effective,
1195: p_altered_pa_request_id => p_altered_pa_request_id,
1196: p_noa_id_corrected => p_noa_id_corrected,

Line 1264: p_table_name => ghr_history_api.g_posnei_table,

1260: hr_utility.set_location( l_proc || 'noa_id_corrected: ' || p_noa_id_corrected, 215);
1261: hr_utility.set_location( l_proc || 'position_extra_info_id: ' || p_position_extra_info_id, 215);
1262:
1263: Fetch_hist_data(
1264: p_table_name => ghr_history_api.g_posnei_table,
1265: p_information1 => p_position_extra_info_id,
1266: p_date_effective => p_date_effective,
1267: p_altered_pa_request_id => p_altered_pa_request_id,
1268: p_noa_id_corrected => p_noa_id_corrected,

Line 1354: p_table_name => ghr_history_api.g_asgn_table,

1350: close per_assignment_f_cursor;
1351: hr_utility.set_location( l_proc, 25);
1352: else
1353: Fetch_hist_data(
1354: p_table_name => ghr_history_api.g_asgn_table,
1355: p_information1 => p_assignment_id,
1356: p_date_effective => p_date_effective,
1357: p_altered_pa_request_id => p_altered_pa_request_id,
1358: p_noa_id_corrected => p_noa_id_corrected,

Line 1442: p_table_name => ghr_history_api.g_eleent_table,

1438: close pay_e_entry_f_cursor;
1439: else
1440: hr_utility.set_location( l_proc, 25);
1441: Fetch_hist_data(
1442: p_table_name => ghr_history_api.g_eleent_table,
1443: p_information1 => p_element_entry_id,
1444: p_date_effective => p_date_effective,
1445: p_altered_pa_request_id => p_altered_pa_request_id,
1446: p_noa_id_corrected => p_noa_id_corrected,

Line 1519: p_table_name => ghr_history_api.g_peopei_table,

1515: close per_peopleei_rowid_cursor;
1516: hr_utility.set_location( l_proc, 15);
1517: else
1518: Fetch_hist_data(
1519: p_table_name => ghr_history_api.g_peopei_table,
1520: p_information1 => p_person_extra_info_id,
1521: p_date_effective => p_date_effective,
1522: p_altered_pa_request_id => p_altered_pa_request_id,
1523: p_noa_id_corrected => p_noa_id_corrected,

Line 1564: l_session ghr_history_api.g_session_var_type;

1560: l_proc varchar2(72) := 'Fetch_Asgei (2)';
1561: l_asg_ei_data ghr_assignment_extra_info_h_v%rowtype;
1562: l_pa_history_id ghr_pa_history.pa_history_id%type;
1563: l_max_effective_date date;
1564: l_session ghr_history_api.g_session_var_type;
1565: l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;
1566: l_result varchar2(20);
1567: cursor c_extra_info_id is
1568: select aei.assignment_extra_info_id

Line 1579: ghr_history_api.get_g_session_var(l_session);

1575: l_extra_info_id := extra_info.assignment_extra_info_id;
1576: End loop;
1577: If l_extra_info_id is not null then
1578: hr_utility.set_location(l_proc,10);
1579: ghr_history_api.get_g_session_var(l_session);
1580: ghr_history_fetch.fetch_asgei ( p_assignment_extra_info_id => l_extra_info_id,
1581: p_date_effective => p_date_effective,
1582: p_altered_pa_request_id => l_session.altered_pa_request_id,
1583: p_noa_id_corrected => l_session.noa_id_correct,

Line 1603: l_session ghr_history_api.g_session_var_type;

1599: l_proc varchar2(72) := 'Fetch_peoplei (2)';
1600: l_per_ei_data ghr_people_extra_info_h_v%rowtype;
1601: l_pa_history_id ghr_pa_history.pa_history_id%type;
1602: l_max_effective_date date;
1603: l_session ghr_history_api.g_session_var_type;
1604: l_extra_info_id per_people_extra_info.person_extra_info_id%type;
1605: l_result varchar2(20);
1606: cursor c_extra_info_id is
1607: select pei.person_extra_info_id

Line 1618: ghr_history_api.get_g_session_var(l_session);

1614: l_extra_info_id := extra_info.person_extra_info_id;
1615: End loop;
1616: If l_extra_info_id is not null then
1617: hr_utility.set_location(l_proc,10);
1618: ghr_history_api.get_g_session_var(l_session);
1619: ghr_history_fetch.fetch_peopleei ( p_person_extra_info_id => l_extra_info_id,
1620: p_date_effective => p_date_effective,
1621: p_altered_pa_request_id => l_session.altered_pa_request_id,
1622: p_noa_id_corrected => l_session.noa_id_correct,

Line 1642: l_session ghr_history_api.g_session_var_type;

1638: l_proc varchar2(72) := 'Fetch_positionei (2)';
1639: l_pos_ei_data ghr_position_extra_info_h_v%rowtype;
1640: l_pa_history_id ghr_pa_history.pa_history_id%type;
1641: l_max_effective_date date;
1642: l_session ghr_history_api.g_session_var_type;
1643: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
1644: l_result varchar2(20);
1645:
1646:

Line 1663: ghr_history_api.get_g_session_var(l_session);

1659: l_extra_info_id := extra_info.position_extra_info_id;
1660: end loop;
1661: If l_extra_info_id is not null then
1662: hr_utility.set_location(l_proc,10);
1663: ghr_history_api.get_g_session_var(l_session);
1664: ghr_history_fetch.fetch_positionei(p_position_extra_info_id => l_extra_info_id,
1665: p_date_effective => p_date_effective,
1666: p_altered_pa_request_id => l_session.altered_pa_request_id,
1667: p_noa_id_corrected => l_session.noa_id_correct,

Line 1691: p_table_name => ghr_history_api.g_eleevl_table,

1687: l_element_entval_data pay_element_entry_values_f%rowtype;
1688: BEGIN
1689: hr_utility.set_location( l_proc, 20);
1690: fetch_for_date_eff(
1691: p_table_name => ghr_history_api.g_eleevl_table,
1692: p_information1 => p_element_entry_value_id,
1693: p_date_effective => p_date_effective,
1694: p_hist_data => l_hist_data,
1695: p_result_code => p_result_code);

Line 1765: p_table_name => ghr_history_api.g_eleevl_table,

1761: close pay_e_entry_value_f_cursor;
1762: else
1763: hr_utility.set_location( l_proc, 25);
1764: Fetch_hist_data(
1765: p_table_name => ghr_history_api.g_eleevl_table,
1766: p_information1 => p_element_entry_value_id,
1767: p_date_effective => p_date_effective,
1768: p_altered_pa_request_id => p_altered_pa_request_id,
1769: p_noa_id_corrected => p_noa_id_corrected,

Line 1799: l_session ghr_history_api.g_session_var_type;

1795: p_screen_entry_value out nocopy pay_element_entry_values_f.screen_entry_value%type
1796: )
1797: is
1798: l_proc varchar2(72) := 'fetch_element_entry_value';
1799: l_session ghr_history_api.g_session_var_type;
1800: l_element_entry_value_id pay_element_entry_values.element_entry_value_id%type;
1801: l_result varchar2(15);
1802: l_element_entry_data pay_element_entry_values_f%rowtype;
1803: l_object_version_number pay_element_entries_f.object_version_number%type;

Line 1855: ghr_history_api.get_g_session_var(l_session);

1851:
1852: begin
1853: hr_utility.set_location('Entering ' || l_proc,5);
1854: -- Initialization
1855: ghr_history_api.get_g_session_var(l_session);
1856: ll_effective_date := p_date_effective;
1857: -- Pick the business group id and also pay basis for later use
1858: For BG_rec in Cur_BG(p_assignment_id,ll_effective_date)
1859: Loop

Line 1958: l_session ghr_history_api.g_session_var_type;

1954: -- ,p_multiple_error_flag out nocopy varchar2
1955:
1956:
1957: l_proc varchar2(72) := 'fetch_element_info_cor';
1958: l_session ghr_history_api.g_session_var_type;
1959: l_element_entry_id pay_element_entries_f.element_entry_id%type;
1960: l_input_value_id pay_input_values_f.input_value_id%type;
1961: l_pa_request_id ghr_pa_requests.pa_request_id%type;
1962: l_processing_type pay_element_types_f.processing_type%type;

Line 2069: ghr_history_api.get_g_session_var(l_session);

2065: l_new_element_name VARCHAR2(80);
2066: --
2067: begin
2068: hr_utility.set_location('Entering:'||l_proc, 1);
2069: ghr_history_api.get_g_session_var(l_session);
2070: -- Pick pay basis from PAR
2071:
2072: For BG_rec in Cur_BG(p_assignment_id,p_effective_date)
2073: Loop

Line 2110: -- ghr_history_api.get_g_session_var(l_session);

2106: --
2107: --
2108: hr_utility.trace('NEW ELE NAME- ghhisfet.pkb is '||l_new_element_name);
2109: -- commenting this and using the same above
2110: -- ghr_history_api.get_g_session_var(l_session);
2111: l_input_value_id := Null;
2112: l_element_entry_id := Null;
2113: --
2114: hr_utility.set_location('Element - CORRECTION ' ,1);

Line 2262: p_table_name => ghr_history_api.g_addres_table,

2258: hr_utility.set_location( l_proc, 15);
2259: else
2260:
2261: Fetch_hist_data(
2262: p_table_name => ghr_history_api.g_addres_table,
2263: p_information1 => p_address_id,
2264: p_date_effective => p_date_effective,
2265: p_altered_pa_request_id => p_altered_pa_request_id,
2266: p_noa_id_corrected => p_noa_id_corrected,

Line 2327: p_table_name => ghr_history_api.g_perana_table,

2323: hr_utility.set_location( l_proc, 15);
2324: else
2325:
2326: Fetch_hist_data(
2327: p_table_name => ghr_history_api.g_perana_table,
2328: p_information1 => p_person_analysis_id,
2329: p_date_effective => p_date_effective,
2330: p_altered_pa_request_id => p_altered_pa_request_id,
2331: p_noa_id_corrected => p_noa_id_corrected,

Line 2566: p_table_name => ghr_history_api.g_posn_table,

2562: hr_utility.set_location( l_proc || 'noa_id_corrected: ' || p_noa_id_corrected, 215);
2563: hr_utility.set_location( l_proc || 'position_id: ' || p_position_id, 215);
2564:
2565: Fetch_hist_data(
2566: p_table_name => ghr_history_api.g_posn_table,
2567: p_information1 => p_position_id,
2568: p_date_effective => p_date_effective,
2569: p_altered_pa_request_id => p_altered_pa_request_id,
2570: p_noa_id_corrected => p_noa_id_corrected,

Line 2912: l_session ghr_history_api.g_session_var_type;

2908: is
2909: l_proc varchar2(72) := 'return_special_information ';
2910: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
2911: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;
2912: l_session ghr_history_api.g_session_var_type;
2913: l_person_analysis_id per_person_analyses.person_analysis_id%type;
2914: l_pa_request_id ghr_pa_requests.pa_request_id%type;
2915:
2916: Cursor c_flex_num is

Line 2995: ghr_history_api.get_g_session_var(l_session);

2991:
2992: BEGIN
2993:
2994: -- get g_session_var
2995: ghr_history_api.get_g_session_var(l_session);
2996: FOR flex_num IN c_flex_num LOOP
2997: l_id_flex_num := flex_num.id_flex_num;
2998: END LOOP;
2999: