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_NON_SF52_EXTRA_INFO dependencies on GHR_HISTORY_API

Line 25: l_session ghr_history_api.g_session_var_type;

21: AND p_effective_date between effective_start_date AND effective_end_date;
22:
23: l_assignment_id per_assignments_f.assignment_id%type;
24: l_asg_ei_data per_assignment_extra_info%rowtype;
25: l_session ghr_history_api.g_session_var_type;
26: l_session1 ghr_history_api.g_session_var_type;
27: --End Bug 5923620
28:
29: l_pei_id per_people_extra_info.person_extra_info_id%type;

Line 26: l_session1 ghr_history_api.g_session_var_type;

22:
23: l_assignment_id per_assignments_f.assignment_id%type;
24: l_asg_ei_data per_assignment_extra_info%rowtype;
25: l_session ghr_history_api.g_session_var_type;
26: l_session1 ghr_history_api.g_session_var_type;
27: --End Bug 5923620
28:
29: l_pei_id per_people_extra_info.person_extra_info_id%type;
30: l_rei_rec ghr_pa_request_extra_info%rowtype ;

Line 326: ghr_history_api.get_g_session_var(l_session);

322: l_to_poid := l_pos_ei_data.poei_information3;
323: --Begin Bug 5923620
324: IF l_from_poid = l_to_poid THEN
325: IF l_first_noa_code = '002' THEN
326: ghr_history_api.get_g_session_var(l_session);
327: l_session1 := l_session;
328: l_session.noa_id_correct := NULL;
329: ghr_history_api.reinit_g_session_var;
330: ghr_history_api.set_g_session_var(l_session);

Line 329: ghr_history_api.reinit_g_session_var;

325: IF l_first_noa_code = '002' THEN
326: ghr_history_api.get_g_session_var(l_session);
327: l_session1 := l_session;
328: l_session.noa_id_correct := NULL;
329: ghr_history_api.reinit_g_session_var;
330: ghr_history_api.set_g_session_var(l_session);
331: ghr_history_fetch.fetch_asgei
332: (p_assignment_id => l_assignment_id,
333: p_information_type => 'GHR_US_ASG_NON_SF52',

Line 330: ghr_history_api.set_g_session_var(l_session);

326: ghr_history_api.get_g_session_var(l_session);
327: l_session1 := l_session;
328: l_session.noa_id_correct := NULL;
329: ghr_history_api.reinit_g_session_var;
330: ghr_history_api.set_g_session_var(l_session);
331: ghr_history_fetch.fetch_asgei
332: (p_assignment_id => l_assignment_id,
333: p_information_type => 'GHR_US_ASG_NON_SF52',
334: p_date_effective => p_effective_date-1,

Line 336: ghr_history_api.reinit_g_session_var;

332: (p_assignment_id => l_assignment_id,
333: p_information_type => 'GHR_US_ASG_NON_SF52',
334: p_date_effective => p_effective_date-1,
335: p_asg_ei_data => l_asg_ei_data );
336: ghr_history_api.reinit_g_session_var;
337: ghr_history_api.set_g_session_var(l_session1);
338: ELSE
339: ghr_history_fetch.fetch_asgei
340: (p_assignment_id => l_assignment_id,

Line 337: ghr_history_api.set_g_session_var(l_session1);

333: p_information_type => 'GHR_US_ASG_NON_SF52',
334: p_date_effective => p_effective_date-1,
335: p_asg_ei_data => l_asg_ei_data );
336: ghr_history_api.reinit_g_session_var;
337: ghr_history_api.set_g_session_var(l_session1);
338: ELSE
339: ghr_history_fetch.fetch_asgei
340: (p_assignment_id => l_assignment_id,
341: p_information_type => 'GHR_US_ASG_NON_SF52',

Line 678: l_session ghr_history_api.g_session_var_type;

674: l_to_position_id ghr_pa_requests.to_position_id%type;
675: l_second_noa_code ghr_pa_requests.second_noa_code%type;
676: l_from_poid ghr_pa_requests.personnel_office_id%type;
677: l_to_poid ghr_pa_requests.personnel_office_id%type;
678: l_session ghr_history_api.g_session_var_type;
679: l_session1 ghr_history_api.g_session_var_type;
680:
681: CURSOR c_pa_req_2noa_dtls is
682: SELECT second_noa_code

Line 679: l_session1 ghr_history_api.g_session_var_type;

675: l_second_noa_code ghr_pa_requests.second_noa_code%type;
676: l_from_poid ghr_pa_requests.personnel_office_id%type;
677: l_to_poid ghr_pa_requests.personnel_office_id%type;
678: l_session ghr_history_api.g_session_var_type;
679: l_session1 ghr_history_api.g_session_var_type;
680:
681: CURSOR c_pa_req_2noa_dtls is
682: SELECT second_noa_code
683: FROM ghr_pa_requests

Line 1949: ghr_history_api.get_g_session_var(l_session);

1945: l_to_poid := l_pos_ei_data.poei_information3;
1946: l_pos_ei_data := NULL;
1947: IF l_from_poid = l_to_poid THEN
1948: IF l_noa_family_code = 'CORRECT' THEN
1949: ghr_history_api.get_g_session_var(l_session);
1950: l_session1 := l_session;
1951: l_session.noa_id_correct := NULL;
1952: ghr_history_api.reinit_g_session_var;
1953: ghr_history_api.set_g_session_var(l_session);

Line 1952: ghr_history_api.reinit_g_session_var;

1948: IF l_noa_family_code = 'CORRECT' THEN
1949: ghr_history_api.get_g_session_var(l_session);
1950: l_session1 := l_session;
1951: l_session.noa_id_correct := NULL;
1952: ghr_history_api.reinit_g_session_var;
1953: ghr_history_api.set_g_session_var(l_session);
1954: ghr_history_fetch.fetch_asgei
1955: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
1956: p_information_type => 'GHR_US_ASG_NON_SF52',

Line 1953: ghr_history_api.set_g_session_var(l_session);

1949: ghr_history_api.get_g_session_var(l_session);
1950: l_session1 := l_session;
1951: l_session.noa_id_correct := NULL;
1952: ghr_history_api.reinit_g_session_var;
1953: ghr_history_api.set_g_session_var(l_session);
1954: ghr_history_fetch.fetch_asgei
1955: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
1956: p_information_type => 'GHR_US_ASG_NON_SF52',
1957: p_date_effective => p_effective_date-1,

Line 1959: ghr_history_api.reinit_g_session_var;

1955: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
1956: p_information_type => 'GHR_US_ASG_NON_SF52',
1957: p_date_effective => p_effective_date-1,
1958: p_asg_ei_data => l_asg_ei_data );
1959: ghr_history_api.reinit_g_session_var;
1960: ghr_history_api.set_g_session_var(l_session1);
1961: ELSE
1962: ghr_history_fetch.fetch_asgei
1963: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),

Line 1960: ghr_history_api.set_g_session_var(l_session1);

1956: p_information_type => 'GHR_US_ASG_NON_SF52',
1957: p_date_effective => p_effective_date-1,
1958: p_asg_ei_data => l_asg_ei_data );
1959: ghr_history_api.reinit_g_session_var;
1960: ghr_history_api.set_g_session_var(l_session1);
1961: ELSE
1962: ghr_history_fetch.fetch_asgei
1963: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
1964: p_information_type => 'GHR_US_ASG_NON_SF52',

Line 2131: ghr_history_api.get_g_session_var(l_session);

2127: l_pos_ei_data := NULL;
2128: IF l_from_poid = l_to_poid THEN
2129: IF nvl(l_noa_family_code,'C') = 'CORRECT' THEN
2130:
2131: ghr_history_api.get_g_session_var(l_session);
2132: l_session1 := l_session;
2133: l_session.noa_id_correct := NULL;
2134: ghr_history_api.reinit_g_session_var;
2135: ghr_history_api.set_g_session_var(l_session);

Line 2134: ghr_history_api.reinit_g_session_var;

2130:
2131: ghr_history_api.get_g_session_var(l_session);
2132: l_session1 := l_session;
2133: l_session.noa_id_correct := NULL;
2134: ghr_history_api.reinit_g_session_var;
2135: ghr_history_api.set_g_session_var(l_session);
2136: ghr_history_fetch.fetch_asgei
2137: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
2138: p_information_type => 'GHR_US_ASG_NON_SF52',

Line 2135: ghr_history_api.set_g_session_var(l_session);

2131: ghr_history_api.get_g_session_var(l_session);
2132: l_session1 := l_session;
2133: l_session.noa_id_correct := NULL;
2134: ghr_history_api.reinit_g_session_var;
2135: ghr_history_api.set_g_session_var(l_session);
2136: ghr_history_fetch.fetch_asgei
2137: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
2138: p_information_type => 'GHR_US_ASG_NON_SF52',
2139: p_date_effective => p_effective_date-1,

Line 2142: ghr_history_api.reinit_g_session_var;

2138: p_information_type => 'GHR_US_ASG_NON_SF52',
2139: p_date_effective => p_effective_date-1,
2140: p_asg_ei_data => l_asg_ei_data
2141: );
2142: ghr_history_api.reinit_g_session_var;
2143: ghr_history_api.set_g_session_var(l_session1);
2144: ELSE
2145: ghr_history_fetch.fetch_asgei
2146: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),

Line 2143: ghr_history_api.set_g_session_var(l_session1);

2139: p_date_effective => p_effective_date-1,
2140: p_asg_ei_data => l_asg_ei_data
2141: );
2142: ghr_history_api.reinit_g_session_var;
2143: ghr_history_api.set_g_session_var(l_session1);
2144: ELSE
2145: ghr_history_fetch.fetch_asgei
2146: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
2147: p_information_type => 'GHR_US_ASG_NON_SF52',

Line 3351: ghr_history_api.get_g_session_var(l_session);

3347: END IF;
3348: /*End - Bug 6129752*/
3349: IF l_from_poid = l_to_poid THEN
3350: IF l_noa_family_code = 'CORRECT' THEN
3351: ghr_history_api.get_g_session_var(l_session);
3352: l_session1 := l_session;
3353: l_session.noa_id_correct := NULL;
3354: ghr_history_api.reinit_g_session_var;
3355: ghr_history_api.set_g_session_var(l_session);

Line 3354: ghr_history_api.reinit_g_session_var;

3350: IF l_noa_family_code = 'CORRECT' THEN
3351: ghr_history_api.get_g_session_var(l_session);
3352: l_session1 := l_session;
3353: l_session.noa_id_correct := NULL;
3354: ghr_history_api.reinit_g_session_var;
3355: ghr_history_api.set_g_session_var(l_session);
3356: ghr_history_fetch.fetch_asgei
3357: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
3358: p_information_type => 'GHR_US_ASG_NON_SF52',

Line 3355: ghr_history_api.set_g_session_var(l_session);

3351: ghr_history_api.get_g_session_var(l_session);
3352: l_session1 := l_session;
3353: l_session.noa_id_correct := NULL;
3354: ghr_history_api.reinit_g_session_var;
3355: ghr_history_api.set_g_session_var(l_session);
3356: ghr_history_fetch.fetch_asgei
3357: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
3358: p_information_type => 'GHR_US_ASG_NON_SF52',
3359: p_date_effective => p_effective_date-1,

Line 3362: ghr_history_api.reinit_g_session_var;

3358: p_information_type => 'GHR_US_ASG_NON_SF52',
3359: p_date_effective => p_effective_date-1,
3360: p_asg_ei_data => l_asg_ei_data
3361: );
3362: ghr_history_api.reinit_g_session_var;
3363: ghr_history_api.set_g_session_var(l_session1);
3364: ELSE
3365: ghr_history_fetch.fetch_asgei
3366: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),

Line 3363: ghr_history_api.set_g_session_var(l_session1);

3359: p_date_effective => p_effective_date-1,
3360: p_asg_ei_data => l_asg_ei_data
3361: );
3362: ghr_history_api.reinit_g_session_var;
3363: ghr_history_api.set_g_session_var(l_session1);
3364: ELSE
3365: ghr_history_fetch.fetch_asgei
3366: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
3367: p_information_type => 'GHR_US_ASG_NON_SF52',