DBA Data[Home] [Help]

APPS.GHR_ELT_TO_BEN_PKG dependencies on GHR_HISTORY_API

Line 2230: l_session_var ghr_history_api.g_session_var_type;

2226: and b.name = 'Status Date'
2227: and e.assignment_id = l_assignment_id ;
2228:
2229:
2230: l_session_var ghr_history_api.g_session_var_type;
2231: l_sess_date DATE;
2232: l_session_id number;
2233: l_peopleei_data per_people_extra_info%rowtype;
2234:

Line 2385: ghr_history_api.reinit_g_session_var;

2381:
2382: END; --B2
2383: BEGIN --B4
2384:
2385: ghr_history_api.reinit_g_session_var;
2386: l_session_var.person_id := l_person_id;
2387: l_session_var.assignment_id := l_assignment_id;
2388: l_session_var.program_name := 'core';
2389: l_session_var.date_effective := trunc(l_calculated_date);

Line 2391: ghr_history_api.set_g_session_var (l_session_var);

2387: l_session_var.assignment_id := l_assignment_id;
2388: l_session_var.program_name := 'core';
2389: l_session_var.date_effective := trunc(l_calculated_date);
2390: l_session_var.fire_trigger := 'Y';
2391: ghr_history_api.set_g_session_var (l_session_var);
2392:
2393: select userenv('sessionid') INTO l_session_id from dual;
2394: open get_sess_date;
2395: fetch get_sess_date into l_sess_date;

Line 2491: ghr_history_api.post_update_process;

2487:
2488:
2489:
2490: ghr_api.g_api_dml := TRUE;
2491: ghr_history_api.post_update_process;
2492: ghr_history_api.reinit_g_session_var;
2493: ghr_api.g_api_dml := FALSE;
2494:
2495: IF (l_agency_effective_date <= fnd_date.canonical_to_date(l_agncy_contrib_elig_date)

Line 2492: ghr_history_api.reinit_g_session_var;

2488:
2489:
2490: ghr_api.g_api_dml := TRUE;
2491: ghr_history_api.post_update_process;
2492: ghr_history_api.reinit_g_session_var;
2493: ghr_api.g_api_dml := FALSE;
2494:
2495: IF (l_agency_effective_date <= fnd_date.canonical_to_date(l_agncy_contrib_elig_date)
2496: AND fnd_date.canonical_to_date(l_agncy_contrib_elig_date) < SYSDATE)

Line 2535: ghr_history_api.reinit_g_session_var;

2531: ' Assignment ' || to_char(l_assignment_id) ||
2532: ' SQLERR ' || SQLERRM,
2533: p_log_date => sysdate);
2534:
2535: ghr_history_api.reinit_g_session_var;
2536: ghr_api.g_api_dml := FALSE;
2537:
2538: END;--B4
2539: END IF;--l_retirement_plan IN('K','L', 'M