APPS.OTA_OM_TDB_WAITLIST_API dependencies on FND_PROFILE

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

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

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

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

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

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