220: ) is
221: ---------------
222: v_proc varchar2(72) := g_package||'check_booking_deal';
223: v_book_deal_customer_id OTA_BOOKING_DEALS.CUSTOMER_ID%type;
224: v_finance_customer_id OTA_FINANCE_HEADERS.CUSTOMER_ID%type;
225: v_receivable_type OTA_FINANCE_HEADERS.RECEIVABLE_TYPE%type;
226: v_deal_type OTA_BOOKING_DEALS.TYPE%type;
227: v_number_of_places number;
228: v_limit_each_event_flag varchar2(1);
221: ---------------
222: v_proc varchar2(72) := g_package||'check_booking_deal';
223: v_book_deal_customer_id OTA_BOOKING_DEALS.CUSTOMER_ID%type;
224: v_finance_customer_id OTA_FINANCE_HEADERS.CUSTOMER_ID%type;
225: v_receivable_type OTA_FINANCE_HEADERS.RECEIVABLE_TYPE%type;
226: v_deal_type OTA_BOOKING_DEALS.TYPE%type;
227: v_number_of_places number;
228: v_limit_each_event_flag varchar2(1);
229: --
228: v_limit_each_event_flag varchar2(1);
229: --
230: cursor csr_tfh is
231: select customer_id,receivable_type
232: from ota_finance_headers
233: where finance_header_id = p_finance_header_id;
234: --
235: cursor csr_tbd is
236: select customer_id,type,number_of_places,limit_each_event_flag
292: and tsr.supplied_resource_id = trb.supplied_resource_id;
293: --
294: cursor sel_finance_vendor is
295: select tfh.vendor_id
296: from ota_finance_headers tfh
297: where tfh.finance_header_id = p_finance_header_id;
298: --
299: Begin
300: --
380: and tdb.booking_id = tra.booking_id;
381: --
382: cursor sel_finance_customer is
383: select tfh.customer_id
384: from ota_finance_headers tfh
385: where tfh.finance_header_id = p_finance_header_id;
386: --
387: Begin
388: --
475: where tdb.booking_id = p_booking_id;
476: --
477: cursor sel_finance_customer is
478: select tfh.customer_id
479: from ota_finance_headers tfh
480: where tfh.finance_header_id = p_finance_header_id;
481: --
482: Begin
483: --
635: ) is
636: --
637: Cursor csr_type IS
638: select type
639: from OTA_FINANCE_HEADERS
640: where finance_header_id = p_finance_header_id;
641: ---------------------
642: v_type varchar2(30);
643: begin
731: ) is
732: --
733: CURSOR csr_header_type IS
734: SELECT type
735: FROM ota_finance_headers
736: WHERE finance_header_id = p_finance_header_id;
737: --
738: v_proc varchar2(72) := g_package||'check_enrollment_attributes';
739: --
977: v_proc varchar2(72) := g_package||'get_date_raised';
978: --
979: cursor sel_date_raised is
980: select tfh.date_raised
981: from ota_finance_headers tfh
982: where tfh.finance_header_id = p_finance_header_id;
983: --
984: Begin
985: --
1060: ) is
1061: --
1062: v_header_currency_code ota_events.currency_code%type;
1063: v_line_currency_code ota_events.currency_code%type;
1064: v_type ota_finance_headers.type%type;
1065: v_proc varchar2(72) := g_package||'check_currency_code';
1066: --
1067: cursor sel_finance_currency is
1068: select tfh.currency_code,tfh.type
1065: v_proc varchar2(72) := g_package||'check_currency_code';
1066: --
1067: cursor sel_finance_currency is
1068: select tfh.currency_code,tfh.type
1069: from ota_finance_headers tfh
1070: where tfh.finance_header_id = p_finance_header_id;
1071: --
1072: cursor sel_event_currency is
1073: select evt.currency_code
1374: ) is
1375: -----------------
1376: cursor csr_tfh is
1377: select tfh.type,tfh.receivable_type
1378: from ota_finance_headers tfh
1379: where tfh.finance_header_id = p_finance_header_id;
1380: --
1381: v_proc varchar2(72) := g_package||'check_line_type';
1382: --
1484: , vendor_id
1485: , receivable_type
1486: , transfer_status
1487: , cancelled_flag
1488: from ota_finance_headers
1489: where finance_header_id = p_finance_header_id;
1490: --
1491: cursor get_superseding_header is
1492: select 'Y'
1489: where finance_header_id = p_finance_header_id;
1490: --
1491: cursor get_superseding_header is
1492: select 'Y'
1493: from ota_finance_headers
1494: where superceding_header_id = p_finance_header_id;
1495: --
1496: begin
1497: hr_utility.set_location('Entering:'||l_proc, 5);