[Home] [Help]
114: is
115: --
116: cursor csr_tpl is
117: select 1
118: from ota_price_lists
119: where name = p_name
120: and business_group_id = p_business_group_id
121: and (p_price_list_id is null or price_list_id <> p_price_list_id);
122: --
407: --*** If p_tpl_id is null, it's an INSERT, otherwise it's an update.
408: --
409: cursor csr_default_price_list is
410: select 1
411: from ota_price_lists
412: where business_group_id = p_business_group_id
413: and default_flag = 'Y'
414: and currency_code = p_currency_code
415: and p_start_date <= nvl(end_date,p_start_date)
453: )
454: return boolean is
455:
456: --*** Returns true if Price list'new start date <= Price list entries'min start date
457: --*** This function must be called before updating ota_price_lists
458: --*** Start_dates are mandatory in price lists and price list entries
459: ----------------
460: cursor csr_ple_min_startdate is
461: select min(start_date)
501: )
502: return boolean is
503:
504: --*** Returns true if Price list'new start date <= booking deals'min start date
505: --*** This function must be called before updating ota_price_lists
506: --*** Start_dates are mandatory in price lists and booking deals
507: ----------------
508: cursor csr_tbd_min_startdate is
509: select min(start_date)
545: )
546: return boolean is
547: --
548: --*** Returns true if Price list's new end date >= Price list entries' max end date
549: --*** This function must be called before updating ota_price_lists
550: --*** end dates may be null
551: --
552: cursor csr_ple_max_enddate is
553: select max(nvl(end_date,g_end_of_time))
599: )
600: return boolean is
601: --
602: --*** Returns true if Price list's new end date >= booking deals' max end date
603: --*** This function must be called before updating ota_price_lists
604: --*** end dates may be null
605: -------------------
606: cursor csr_tbd_max_enddate is
607: select max(nvl(end_date,g_end_of_time))
835: tpl_information7,tpl_information8,tpl_information9,tpl_information10,
836: tpl_information11,tpl_information12,tpl_information13,tpl_information14,
837: tpl_information15,tpl_information16,tpl_information17,tpl_information18,
838: tpl_information19,tpl_information20
839: from ota_price_lists
840: where price_list_id = p_old_tpl_id;
841: --
842: l_tpl_found boolean;
843: l_dates_difference number;