eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_TBD_API dependencies on OTA_FINANCE_LINES

Line 320: from ota_finance_lines a

316: l_proc varchar2(72) := g_package||'check_dates_conflict';
317: --
318: cursor c_check_enrollments is
319: select nvl(count(a.booking_deal_id),0)
320: from ota_finance_lines a
321: where p_booking_deal_id = booking_deal_id
322: and cancelled_flag = 'N';
323: --
324: -- Cursor to check how many records will come back if date changes

Line 329: from ota_finance_lines a,

325: -- applied
326: --
327: cursor c_check_date_change is
328: select nvl(count(a.booking_deal_id),0)
329: from ota_finance_lines a,
330: ota_delegate_bookings b,
331: ota_events c
332: where a.booking_deal_id = p_booking_deal_id
333: and a.booking_id = b.booking_id

Line 390: from OTA_FINANCE_LINES TFL

386: --
387: cursor C1 is
388: select sum (TFL.UNITARY_AMOUNT),
389: sum (TFL.MONEY_AMOUNT)
390: from OTA_FINANCE_LINES TFL
391: where TFL.BOOKING_DEAL_ID (+) = P_BOOKING_DEAL_ID
392: and ( (TFL.CANCELLED_FLAG is null)
393: or (TFL.CANCELLED_FLAG = 'N' ))
394: and TFL.LINE_TYPE = P_LINE_TYPE;

Line 414: -- Function returns the purchased amount from OTA_FINANCE_LINES for the

410: -- ----------------------------------------------------------------------------
411: -- -----------------------------< TFL_PURCHASED >------------------------------
412: -- ----------------------------------------------------------------------------
413: --
414: -- Function returns the purchased amount from OTA_FINANCE_LINES for the
415: -- BOOKING_DEAL_ID supplied in uniTs or Money as requested.
416: --
417: function TFL_PURCHASED (
418: P_BOOKING_DEAL_ID in number,

Line 434: -- Function returns the outstanding balance from OTA_FINANCE_LINES for the

430: -- ----------------------------------------------------------------------------
431: -- -----------------------------< TFL_BALANCE >--------------------------------
432: -- ----------------------------------------------------------------------------
433: --
434: -- Function returns the outstanding balance from OTA_FINANCE_LINES for the
435: -- BOOKING_DEAL_ID supplied in uniTs or Money as requested.
436: --
437: function TFL_BALANCE (
438: P_BOOKING_DEAL_ID in number,

Line 458: -- Returns 'TRUE' if OTA_FINANCE_LINES exist for the BOOKING_DEAL_ID,

454: -- ----------------------------------------------------------------------------
455: -- -------------------------------< TFL_FLAG >---------------------------------
456: -- ----------------------------------------------------------------------------
457: --
458: -- Returns 'TRUE' if OTA_FINANCE_LINES exist for the BOOKING_DEAL_ID,
459: -- or null if not present.
460: --
461: function TFL_FLAG (
462: P_BOOKING_DEAL_ID in number

Line 469: from OTA_FINANCE_LINES TFL

465: W_FLAG varchar2 (4);
466: --
467: cursor C1 is
468: select 'TRUE'
469: from OTA_FINANCE_LINES TFL
470: where TFL.BOOKING_DEAL_ID (+) = P_BOOKING_DEAL_ID
471: and ( (TFL.CANCELLED_FLAG is null)
472: or (TFL.CANCELLED_FLAG = 'N' ));
473: --

Line 1040: from OTA_FINANCE_LINES TFL

1036: W_LINES varchar2 (3);
1037: --
1038: cursor C1 is
1039: select 'YES'
1040: from OTA_FINANCE_LINES TFL
1041: where TFL.BOOKING_DEAL_ID = P_BOOKING_DEAL_ID;
1042: --
1043: begin
1044: --