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 33: l_session ghr_history_api.g_session_var_type;

29: AND p_effective_date between effective_start_date AND effective_end_date;
30:
31: l_assignment_id per_assignments_f.assignment_id%type;
32: l_asg_ei_data per_assignment_extra_info%rowtype;
33: l_session ghr_history_api.g_session_var_type;
34: l_session1 ghr_history_api.g_session_var_type;
35: --End Bug 5923620
36:
37: l_pei_id per_people_extra_info.person_extra_info_id%type;

Line 34: l_session1 ghr_history_api.g_session_var_type;

30:
31: l_assignment_id per_assignments_f.assignment_id%type;
32: l_asg_ei_data per_assignment_extra_info%rowtype;
33: l_session ghr_history_api.g_session_var_type;
34: l_session1 ghr_history_api.g_session_var_type;
35: --End Bug 5923620
36:
37: l_pei_id per_people_extra_info.person_extra_info_id%type;
38: l_rei_rec ghr_pa_request_extra_info%rowtype ;

Line 370: ghr_history_api.get_g_session_var(l_session);

366: --Begin Bug 5923620
367: IF l_from_poid = l_to_poid THEN
368:
369: IF l_first_noa_code = '002' THEN
370: ghr_history_api.get_g_session_var(l_session);
371: l_session1 := l_session;
372: l_session.noa_id_correct := NULL;
373: ghr_history_api.reinit_g_session_var;
374: ghr_history_api.set_g_session_var(l_session);

Line 373: ghr_history_api.reinit_g_session_var;

369: IF l_first_noa_code = '002' THEN
370: ghr_history_api.get_g_session_var(l_session);
371: l_session1 := l_session;
372: l_session.noa_id_correct := NULL;
373: ghr_history_api.reinit_g_session_var;
374: ghr_history_api.set_g_session_var(l_session);
375: ghr_history_fetch.fetch_asgei
376: (p_assignment_id => l_assignment_id,
377: p_information_type => 'GHR_US_ASG_NON_SF52',

Line 374: ghr_history_api.set_g_session_var(l_session);

370: ghr_history_api.get_g_session_var(l_session);
371: l_session1 := l_session;
372: l_session.noa_id_correct := NULL;
373: ghr_history_api.reinit_g_session_var;
374: ghr_history_api.set_g_session_var(l_session);
375: ghr_history_fetch.fetch_asgei
376: (p_assignment_id => l_assignment_id,
377: p_information_type => 'GHR_US_ASG_NON_SF52',
378: p_date_effective => p_effective_date-1,

Line 381: ghr_history_api.reinit_g_session_var;

377: p_information_type => 'GHR_US_ASG_NON_SF52',
378: p_date_effective => p_effective_date-1,
379: p_asg_ei_data => l_asg_ei_data );
380:
381: ghr_history_api.reinit_g_session_var;
382: ghr_history_api.set_g_session_var(l_session1);
383: ELSE
384: ghr_history_fetch.fetch_asgei
385: (p_assignment_id => l_assignment_id,

Line 382: ghr_history_api.set_g_session_var(l_session1);

378: p_date_effective => p_effective_date-1,
379: p_asg_ei_data => l_asg_ei_data );
380:
381: ghr_history_api.reinit_g_session_var;
382: ghr_history_api.set_g_session_var(l_session1);
383: ELSE
384: ghr_history_fetch.fetch_asgei
385: (p_assignment_id => l_assignment_id,
386: p_information_type => 'GHR_US_ASG_NON_SF52',

Line 740: l_session ghr_history_api.g_session_var_type;

736: l_to_position_id ghr_pa_requests.to_position_id%type;
737: l_second_noa_code ghr_pa_requests.second_noa_code%type;
738: l_from_poid ghr_pa_requests.personnel_office_id%type;
739: l_to_poid ghr_pa_requests.personnel_office_id%type;
740: l_session ghr_history_api.g_session_var_type;
741: l_session1 ghr_history_api.g_session_var_type;
742:
743: CURSOR c_pa_req_2noa_dtls is
744: SELECT second_noa_code

Line 741: l_session1 ghr_history_api.g_session_var_type;

737: l_second_noa_code ghr_pa_requests.second_noa_code%type;
738: l_from_poid ghr_pa_requests.personnel_office_id%type;
739: l_to_poid ghr_pa_requests.personnel_office_id%type;
740: l_session ghr_history_api.g_session_var_type;
741: l_session1 ghr_history_api.g_session_var_type;
742:
743: CURSOR c_pa_req_2noa_dtls is
744: SELECT second_noa_code
745: FROM ghr_pa_requests

Line 2329: ghr_history_api.get_g_session_var(l_session);

2325: l_to_poid := l_pos_ei_data.poei_information3;
2326: l_pos_ei_data := NULL;
2327: IF l_from_poid = l_to_poid THEN
2328: IF l_noa_family_code = 'CORRECT' THEN
2329: ghr_history_api.get_g_session_var(l_session);
2330: l_session1 := l_session;
2331: l_session.noa_id_correct := NULL;
2332: ghr_history_api.reinit_g_session_var;
2333: ghr_history_api.set_g_session_var(l_session);

Line 2332: ghr_history_api.reinit_g_session_var;

2328: IF l_noa_family_code = 'CORRECT' THEN
2329: ghr_history_api.get_g_session_var(l_session);
2330: l_session1 := l_session;
2331: l_session.noa_id_correct := NULL;
2332: ghr_history_api.reinit_g_session_var;
2333: ghr_history_api.set_g_session_var(l_session);
2334: ghr_history_fetch.fetch_asgei
2335: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
2336: p_information_type => 'GHR_US_ASG_NON_SF52',

Line 2333: ghr_history_api.set_g_session_var(l_session);

2329: ghr_history_api.get_g_session_var(l_session);
2330: l_session1 := l_session;
2331: l_session.noa_id_correct := NULL;
2332: ghr_history_api.reinit_g_session_var;
2333: ghr_history_api.set_g_session_var(l_session);
2334: ghr_history_fetch.fetch_asgei
2335: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
2336: p_information_type => 'GHR_US_ASG_NON_SF52',
2337: p_date_effective => p_effective_date-1,

Line 2339: ghr_history_api.reinit_g_session_var;

2335: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
2336: p_information_type => 'GHR_US_ASG_NON_SF52',
2337: p_date_effective => p_effective_date-1,
2338: p_asg_ei_data => l_asg_ei_data );
2339: ghr_history_api.reinit_g_session_var;
2340: ghr_history_api.set_g_session_var(l_session1);
2341: ELSE
2342: ghr_history_fetch.fetch_asgei
2343: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),

Line 2340: ghr_history_api.set_g_session_var(l_session1);

2336: p_information_type => 'GHR_US_ASG_NON_SF52',
2337: p_date_effective => p_effective_date-1,
2338: p_asg_ei_data => l_asg_ei_data );
2339: ghr_history_api.reinit_g_session_var;
2340: ghr_history_api.set_g_session_var(l_session1);
2341: ELSE
2342: ghr_history_fetch.fetch_asgei
2343: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
2344: p_information_type => 'GHR_US_ASG_NON_SF52',

Line 2561: ghr_history_api.get_g_session_var(l_session);

2557: l_pos_ei_data := NULL;
2558: IF l_from_poid = l_to_poid THEN
2559: IF nvl(l_noa_family_code,'C') = 'CORRECT' THEN
2560:
2561: ghr_history_api.get_g_session_var(l_session);
2562: l_session1 := l_session;
2563: l_session.noa_id_correct := NULL;
2564: ghr_history_api.reinit_g_session_var;
2565: ghr_history_api.set_g_session_var(l_session);

Line 2564: ghr_history_api.reinit_g_session_var;

2560:
2561: ghr_history_api.get_g_session_var(l_session);
2562: l_session1 := l_session;
2563: l_session.noa_id_correct := NULL;
2564: ghr_history_api.reinit_g_session_var;
2565: ghr_history_api.set_g_session_var(l_session);
2566: ghr_history_fetch.fetch_asgei
2567: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
2568: p_information_type => 'GHR_US_ASG_NON_SF52',

Line 2565: ghr_history_api.set_g_session_var(l_session);

2561: ghr_history_api.get_g_session_var(l_session);
2562: l_session1 := l_session;
2563: l_session.noa_id_correct := NULL;
2564: ghr_history_api.reinit_g_session_var;
2565: ghr_history_api.set_g_session_var(l_session);
2566: ghr_history_fetch.fetch_asgei
2567: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
2568: p_information_type => 'GHR_US_ASG_NON_SF52',
2569: p_date_effective => p_effective_date-1,

Line 2572: ghr_history_api.reinit_g_session_var;

2568: p_information_type => 'GHR_US_ASG_NON_SF52',
2569: p_date_effective => p_effective_date-1,
2570: p_asg_ei_data => l_asg_ei_data
2571: );
2572: ghr_history_api.reinit_g_session_var;
2573: ghr_history_api.set_g_session_var(l_session1);
2574: ELSE
2575: ghr_history_fetch.fetch_asgei
2576: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),

Line 2573: ghr_history_api.set_g_session_var(l_session1);

2569: p_date_effective => p_effective_date-1,
2570: p_asg_ei_data => l_asg_ei_data
2571: );
2572: ghr_history_api.reinit_g_session_var;
2573: ghr_history_api.set_g_session_var(l_session1);
2574: ELSE
2575: ghr_history_fetch.fetch_asgei
2576: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
2577: p_information_type => 'GHR_US_ASG_NON_SF52',

Line 4069: ghr_history_api.get_g_session_var(l_session);

4065: END IF;
4066: /*End - Bug 6129752*/
4067: IF l_from_poid = l_to_poid THEN
4068: IF l_noa_family_code = 'CORRECT' THEN
4069: ghr_history_api.get_g_session_var(l_session);
4070: l_session1 := l_session;
4071: l_session.noa_id_correct := NULL;
4072: ghr_history_api.reinit_g_session_var;
4073: ghr_history_api.set_g_session_var(l_session);

Line 4072: ghr_history_api.reinit_g_session_var;

4068: IF l_noa_family_code = 'CORRECT' THEN
4069: ghr_history_api.get_g_session_var(l_session);
4070: l_session1 := l_session;
4071: l_session.noa_id_correct := NULL;
4072: ghr_history_api.reinit_g_session_var;
4073: ghr_history_api.set_g_session_var(l_session);
4074: ghr_history_fetch.fetch_asgei
4075: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
4076: p_information_type => 'GHR_US_ASG_NON_SF52',

Line 4073: ghr_history_api.set_g_session_var(l_session);

4069: ghr_history_api.get_g_session_var(l_session);
4070: l_session1 := l_session;
4071: l_session.noa_id_correct := NULL;
4072: ghr_history_api.reinit_g_session_var;
4073: ghr_history_api.set_g_session_var(l_session);
4074: ghr_history_fetch.fetch_asgei
4075: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
4076: p_information_type => 'GHR_US_ASG_NON_SF52',
4077: p_date_effective => p_effective_date-1,

Line 4080: ghr_history_api.reinit_g_session_var;

4076: p_information_type => 'GHR_US_ASG_NON_SF52',
4077: p_date_effective => p_effective_date-1,
4078: p_asg_ei_data => l_asg_ei_data
4079: );
4080: ghr_history_api.reinit_g_session_var;
4081: ghr_history_api.set_g_session_var(l_session1);
4082: ELSE
4083: ghr_history_fetch.fetch_asgei
4084: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),

Line 4081: ghr_history_api.set_g_session_var(l_session1);

4077: p_date_effective => p_effective_date-1,
4078: p_asg_ei_data => l_asg_ei_data
4079: );
4080: ghr_history_api.reinit_g_session_var;
4081: ghr_history_api.set_g_session_var(l_session1);
4082: ELSE
4083: ghr_history_fetch.fetch_asgei
4084: (p_assignment_id => NVL(l_assignment_id,p_assignment_id),
4085: p_information_type => 'GHR_US_ASG_NON_SF52',