APPS.FA_RSVLDG_REP_INS_PKG dependencies on FND_PROFILE

Line 122: -- fnd_profile.get('CONC_REQUEST_ID', l_request_id); bug 9235908

118:
119: --==================================================
120: --OPEN LOAD WORKER CURSOR HERE.
121: --==================================================
122: -- fnd_profile.get('CONC_REQUEST_ID', l_request_id); bug 9235908
123: -- request_id will be passed from report directly instead of
124: -- getting its value from profile option.
125: l_request_id := request_id;
126:

Line 142: If (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'N' ) then

138: Exit when Launch_worker%notfound;
139:
140: -- run only if CRL not installed
141:
142: If (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'N' ) then
143:
144: If bonus_count > 0 then
145:
146: if (h_reporting_flag = 'R') then

Line 707: elsif (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y' ) then

703:
704: End if;
705:
706: -- run only if CRL installed
707: elsif (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y' ) then
708:
709: -- Insert Non-Group Details
710: if (h_reporting_flag = 'R') then
711: INSERT INTO FA_RESERVE_LEDGER_GT