APPS.OTA_OM_TDB_WAITLIST_API dependencies on FND_PROFILE

Line 184: l_status_type_id := fnd_profile.value('OTA_AUTO_WAITLIST_BOOKING_STATUS');

180: --
181: -- Process Logic
182: --
183:
184: l_status_type_id := fnd_profile.value('OTA_AUTO_WAITLIST_BOOKING_STATUS');
185:
186: if l_status_type_id is null then
187: --
188: --

Line 205: if fnd_profile.value('OTA_WAITLIST_SORT_CRITERIA') = 'BP' then

201: -- This will save on coding, as we will only require one loop to go
202: -- through the waitlist.
203: --
204:
205: if fnd_profile.value('OTA_WAITLIST_SORT_CRITERIA') = 'BP' then
206: --
207: FND_FILE.PUT_LINE(FND_FILE.LOG,'Auto waitlist processing, Waitlist Sort Criteria :' ||
208: fnd_profile.value('OTA_WAITLIST_SORT_CRITERIA') );
209: for l_waitlist_entry in c_priority_waitlist loop

Line 208: fnd_profile.value('OTA_WAITLIST_SORT_CRITERIA') );

204:
205: if fnd_profile.value('OTA_WAITLIST_SORT_CRITERIA') = 'BP' then
206: --
207: FND_FILE.PUT_LINE(FND_FILE.LOG,'Auto waitlist processing, Waitlist Sort Criteria :' ||
208: fnd_profile.value('OTA_WAITLIST_SORT_CRITERIA') );
209: for l_waitlist_entry in c_priority_waitlist loop
210: --
211:
212: t_waitlist_table(l_count).number_of_places := l_waitlist_entry.number_of_places;