APPS.GHR_ELT_TO_BEN_PKG dependencies on FND_PROFILE

Line 67: l_parent_request_id := fnd_profile.VALUE('CONC_REQUEST_ID');

63: -- Initialization of variables.
64: l_batch_counter := 0;
65: l_batch_no := 1;
66: l_session_id := USERENV('SESSIONID');
67: l_parent_request_id := fnd_profile.VALUE('CONC_REQUEST_ID');
68: l_status := TRUE;
69: g_person_ids.DELETE;
70: g_proc_name := 'GHR_BEN_EIT_CREATION_'|| l_parent_request_id;
71: l_update_name := 'GHR_ELT_BEN_CONV';

Line 495: l_req := fnd_profile.VALUE ('CONC_REQUEST_ID');

491:
492:
493: --
494: --
495: l_req := fnd_profile.VALUE ('CONC_REQUEST_ID');
496: l_program_name := 'GHR_BEN_EIT_CREATION_'||l_req;
497: l_dummy := 'y';
498: -- Check whether the benefits information type is created or not.
499: Open c_eit_exists;

Line 706: l_req := fnd_profile.VALUE ('CONC_REQUEST_ID');

702: dut.effective_start_date and dut.effective_end_date;
703: l_duty_station_code ghr_duty_stations_v.duty_station_code%type;
704:
705: BEGIN
706: l_req := fnd_profile.VALUE ('CONC_REQUEST_ID');
707: l_program_name := 'GHR_HB_CNVR_'||l_req;
708: -------------------------------------------------------------------------
709: --Script for Health Plan changes
710: -------------------------------------------------------------------------

Line 2246: l_req := fnd_profile.VALUE ('CONC_REQUEST_ID');

2242: from per_people_extra_info
2243: where person_extra_info_id = cp_people_ei_id;
2244:
2245: BEGIN
2246: l_req := fnd_profile.VALUE ('CONC_REQUEST_ID');
2247: l_program_name := 'GHR_TSP_CONV_'||l_req;
2248: l_agency_effective_date := fnd_date.canonical_to_date(p_agency_effective_date);
2249: BEGIN --B1
2250: l_tsp_abv_agcy_rec_cnt:=0;