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 492: l_req := fnd_profile.VALUE ('CONC_REQUEST_ID');

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

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

671: l_exists boolean := false;
672: l_check_date date;
673:
674: BEGIN
675: l_req := fnd_profile.VALUE ('CONC_REQUEST_ID');
676: l_program_name := 'GHR_HB_CNVR_'||l_req;
677: -------------------------------------------------------------------------
678: --Script for Health Plan changes
679: -------------------------------------------------------------------------