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 1194: p_table_name => ghr_history_api.g_peop_table,

1190: close per_people_f_cursor;
1191: hr_utility.set_location( l_proc, 25);
1192: else
1193: Fetch_hist_data(
1194: p_table_name => ghr_history_api.g_peop_table,
1195: p_information1 => p_person_id,
1196: p_date_effective => p_date_effective,
1197: p_altered_pa_request_id => p_altered_pa_request_id,
1198: p_noa_id_corrected => p_noa_id_corrected,

Line 1260: p_table_name => ghr_history_api.g_asgnei_table,

1256: close per_asgei_rowid_cursor;
1257: hr_utility.set_location( l_proc, 15);
1258: else
1259: Fetch_hist_data(
1260: p_table_name => ghr_history_api.g_asgnei_table,
1261: p_information1 => p_assignment_extra_info_id,
1262: p_date_effective => p_date_effective,
1263: p_altered_pa_request_id => p_altered_pa_request_id,
1264: p_noa_id_corrected => p_noa_id_corrected,

Line 1332: p_table_name => ghr_history_api.g_posnei_table,

1328: hr_utility.set_location( l_proc || 'noa_id_corrected: ' || p_noa_id_corrected, 215);
1329: hr_utility.set_location( l_proc || 'position_extra_info_id: ' || p_position_extra_info_id, 215);
1330:
1331: Fetch_hist_data(
1332: p_table_name => ghr_history_api.g_posnei_table,
1333: p_information1 => p_position_extra_info_id,
1334: p_date_effective => p_date_effective,
1335: p_altered_pa_request_id => p_altered_pa_request_id,
1336: p_noa_id_corrected => p_noa_id_corrected,

Line 1424: p_table_name => ghr_history_api.g_asgn_table,

1420: close per_assignment_f_cursor;
1421: hr_utility.set_location( l_proc, 25);
1422: else
1423: Fetch_hist_data(
1424: p_table_name => ghr_history_api.g_asgn_table,
1425: p_information1 => p_assignment_id,
1426: p_date_effective => p_date_effective,
1427: p_altered_pa_request_id => p_altered_pa_request_id,
1428: p_noa_id_corrected => p_noa_id_corrected,

Line 1512: p_table_name => ghr_history_api.g_eleent_table,

1508: close pay_e_entry_f_cursor;
1509: else
1510: hr_utility.set_location( l_proc, 25);
1511: Fetch_hist_data(
1512: p_table_name => ghr_history_api.g_eleent_table,
1513: p_information1 => p_element_entry_id,
1514: p_date_effective => p_date_effective,
1515: p_altered_pa_request_id => p_altered_pa_request_id,
1516: p_noa_id_corrected => p_noa_id_corrected,

Line 1589: p_table_name => ghr_history_api.g_peopei_table,

1585: close per_peopleei_rowid_cursor;
1586: hr_utility.set_location( l_proc, 15);
1587: else
1588: Fetch_hist_data(
1589: p_table_name => ghr_history_api.g_peopei_table,
1590: p_information1 => p_person_extra_info_id,
1591: p_date_effective => p_date_effective,
1592: p_altered_pa_request_id => p_altered_pa_request_id,
1593: p_noa_id_corrected => p_noa_id_corrected,

Line 1634: l_session ghr_history_api.g_session_var_type;

1630: l_proc varchar2(72) := 'Fetch_Asgei (2)';
1631: l_asg_ei_data ghr_assignment_extra_info_h_v%rowtype;
1632: l_pa_history_id ghr_pa_history.pa_history_id%type;
1633: l_max_effective_date date;
1634: l_session ghr_history_api.g_session_var_type;
1635: l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;
1636: l_result varchar2(20);
1637: cursor c_extra_info_id is
1638: select aei.assignment_extra_info_id

Line 1674: ghr_history_api.get_g_session_var(l_session);

1670: End loop;
1671: END IF;
1672: If l_extra_info_id is not null then
1673: hr_utility.set_location(l_proc,10);
1674: ghr_history_api.get_g_session_var(l_session);
1675: ghr_history_fetch.fetch_asgei ( p_assignment_extra_info_id => l_extra_info_id,
1676: p_date_effective => p_date_effective,
1677: p_altered_pa_request_id => l_session.altered_pa_request_id,
1678: p_noa_id_corrected => l_session.noa_id_correct,

Line 1698: l_session ghr_history_api.g_session_var_type;

1694: l_proc varchar2(72) := 'Fetch_peoplei (2)';
1695: l_per_ei_data ghr_people_extra_info_h_v%rowtype;
1696: l_pa_history_id ghr_pa_history.pa_history_id%type;
1697: l_max_effective_date date;
1698: l_session ghr_history_api.g_session_var_type;
1699: l_extra_info_id per_people_extra_info.person_extra_info_id%type;
1700: l_result varchar2(20);
1701: cursor c_extra_info_id is
1702: select pei.person_extra_info_id

Line 1713: ghr_history_api.get_g_session_var(l_session);

1709: l_extra_info_id := extra_info.person_extra_info_id;
1710: End loop;
1711: If l_extra_info_id is not null then
1712: hr_utility.set_location(l_proc,10);
1713: ghr_history_api.get_g_session_var(l_session);
1714: ghr_history_fetch.fetch_peopleei ( p_person_extra_info_id => l_extra_info_id,
1715: p_date_effective => p_date_effective,
1716: p_altered_pa_request_id => l_session.altered_pa_request_id,
1717: p_noa_id_corrected => l_session.noa_id_correct,

Line 1737: l_session ghr_history_api.g_session_var_type;

1733: l_proc varchar2(72) := 'Fetch_positionei (2)';
1734: l_pos_ei_data ghr_position_extra_info_h_v%rowtype;
1735: l_pa_history_id ghr_pa_history.pa_history_id%type;
1736: l_max_effective_date date;
1737: l_session ghr_history_api.g_session_var_type;
1738: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
1739: l_result varchar2(20);
1740:
1741:

Line 1758: ghr_history_api.get_g_session_var(l_session);

1754: l_extra_info_id := extra_info.position_extra_info_id;
1755: end loop;
1756: If l_extra_info_id is not null then
1757: hr_utility.set_location(l_proc,10);
1758: ghr_history_api.get_g_session_var(l_session);
1759: ghr_history_fetch.fetch_positionei(p_position_extra_info_id => l_extra_info_id,
1760: p_date_effective => p_date_effective,
1761: p_altered_pa_request_id => l_session.altered_pa_request_id,
1762: p_noa_id_corrected => l_session.noa_id_correct,

Line 1791: p_table_name => ghr_history_api.g_eleevl_table,

1787: l_element_entval_data pay_element_entry_values_f%rowtype;
1788: BEGIN
1789: hr_utility.set_location( l_proc, 20);
1790: fetch_for_date_eff(
1791: p_table_name => ghr_history_api.g_eleevl_table,
1792: p_information1 => p_element_entry_value_id,
1793: p_date_effective => p_date_effective,
1794: p_hist_data => l_hist_data,
1795: p_result_code => p_result_code);

Line 1865: p_table_name => ghr_history_api.g_eleevl_table,

1861: close pay_e_entry_value_f_cursor;
1862: else
1863: hr_utility.set_location( l_proc, 25);
1864: Fetch_hist_data(
1865: p_table_name => ghr_history_api.g_eleevl_table,
1866: p_information1 => p_element_entry_value_id,
1867: p_date_effective => p_date_effective,
1868: p_altered_pa_request_id => p_altered_pa_request_id,
1869: p_noa_id_corrected => p_noa_id_corrected,

Line 1899: l_session ghr_history_api.g_session_var_type;

1895: p_screen_entry_value out nocopy pay_element_entry_values_f.screen_entry_value%type
1896: )
1897: is
1898: l_proc varchar2(72) := 'fetch_element_entry_value';
1899: l_session ghr_history_api.g_session_var_type;
1900: l_element_entry_value_id pay_element_entry_values.element_entry_value_id%type;
1901: l_result varchar2(15);
1902: l_element_entry_data pay_element_entry_values_f%rowtype;
1903: l_object_version_number pay_element_entries_f.object_version_number%type;

Line 1955: ghr_history_api.get_g_session_var(l_session);

1951:
1952: begin
1953: hr_utility.set_location('Entering ' || l_proc,5);
1954: -- Initialization
1955: ghr_history_api.get_g_session_var(l_session);
1956: ll_effective_date := p_date_effective;
1957: -- Pick the business group id and also pay basis for later use
1958: For BG_rec in Cur_BG(p_assignment_id,ll_effective_date)
1959: Loop

Line 2058: l_session ghr_history_api.g_session_var_type;

2054: -- ,p_multiple_error_flag out nocopy varchar2
2055:
2056:
2057: l_proc varchar2(72) := 'fetch_element_info_cor';
2058: l_session ghr_history_api.g_session_var_type;
2059: l_element_entry_id pay_element_entries_f.element_entry_id%type;
2060: l_input_value_id pay_input_values_f.input_value_id%type;
2061: l_pa_request_id ghr_pa_requests.pa_request_id%type;
2062: l_processing_type pay_element_types_f.processing_type%type;

Line 2169: ghr_history_api.get_g_session_var(l_session);

2165: l_new_element_name VARCHAR2(80);
2166: --
2167: begin
2168: hr_utility.set_location('Entering:'||l_proc, 1);
2169: ghr_history_api.get_g_session_var(l_session);
2170: -- Pick pay basis from PAR
2171:
2172: For BG_rec in Cur_BG(p_assignment_id,p_effective_date)
2173: Loop

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

2206: --
2207: --
2208: hr_utility.trace('NEW ELE NAME- ghhisfet.pkb is '||l_new_element_name);
2209: -- commenting this and using the same above
2210: -- ghr_history_api.get_g_session_var(l_session);
2211: l_input_value_id := Null;
2212: l_element_entry_id := Null;
2213: --
2214: hr_utility.set_location('Element - CORRECTION ' ,1);

Line 2362: p_table_name => ghr_history_api.g_addres_table,

2358: hr_utility.set_location( l_proc, 15);
2359: else
2360:
2361: Fetch_hist_data(
2362: p_table_name => ghr_history_api.g_addres_table,
2363: p_information1 => p_address_id,
2364: p_date_effective => p_date_effective,
2365: p_altered_pa_request_id => p_altered_pa_request_id,
2366: p_noa_id_corrected => p_noa_id_corrected,

Line 2427: p_table_name => ghr_history_api.g_perana_table,

2423: hr_utility.set_location( l_proc, 15);
2424: else
2425:
2426: Fetch_hist_data(
2427: p_table_name => ghr_history_api.g_perana_table,
2428: p_information1 => p_person_analysis_id,
2429: p_date_effective => p_date_effective,
2430: p_altered_pa_request_id => p_altered_pa_request_id,
2431: p_noa_id_corrected => p_noa_id_corrected,

Line 2666: p_table_name => ghr_history_api.g_posn_table,

2662: hr_utility.set_location( l_proc || 'noa_id_corrected: ' || p_noa_id_corrected, 215);
2663: hr_utility.set_location( l_proc || 'position_id: ' || p_position_id, 215);
2664:
2665: Fetch_hist_data(
2666: p_table_name => ghr_history_api.g_posn_table,
2667: p_information1 => p_position_id,
2668: p_date_effective => p_date_effective,
2669: p_altered_pa_request_id => p_altered_pa_request_id,
2670: p_noa_id_corrected => p_noa_id_corrected,

Line 3012: l_session ghr_history_api.g_session_var_type;

3008: is
3009: l_proc varchar2(72) := 'return_special_information ';
3010: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
3011: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;
3012: l_session ghr_history_api.g_session_var_type;
3013: l_person_analysis_id per_person_analyses.person_analysis_id%type;
3014: l_pa_request_id ghr_pa_requests.pa_request_id%type;
3015:
3016: Cursor c_flex_num is

Line 3095: ghr_history_api.get_g_session_var(l_session);

3091:
3092: BEGIN
3093:
3094: -- get g_session_var
3095: ghr_history_api.get_g_session_var(l_session);
3096: FOR flex_num IN c_flex_num LOOP
3097: l_id_flex_num := flex_num.id_flex_num;
3098: END LOOP;
3099: