APPS.OTA_TFL_API_BUSINESS_RULES dependencies on OTA_EVENTS

Line 1062: v_header_currency_code ota_events.currency_code%type;

1058: ,p_resource_allocation_id in number
1059: ,p_resource_booking_id in number
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: --

Line 1063: v_line_currency_code ota_events.currency_code%type;

1059: ,p_resource_booking_id in number
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

Line 1075: , ota_events evt

1071: --
1072: cursor sel_event_currency is
1073: select evt.currency_code
1074: from ota_delegate_bookings tdb
1075: , ota_events evt
1076: where tdb.booking_id = p_booking_id
1077: and evt.event_id = tdb.event_id;
1078: --
1079: cursor sel_price_list_currency is

Line 1090: , ota_events evt

1086: cursor sel_resource_alloc_currency is
1087: select evt.currency_code
1088: from ota_resource_allocations tra
1089: , ota_delegate_bookings tdb
1090: , ota_events evt
1091: where tra.resource_allocation_id = p_resource_allocation_id
1092: and tdb.booking_id = tra.booking_id
1093: and evt.event_id = tdb.event_id;
1094: --

Line 1105: , ota_events evt

1101:
1102: /* select decode(evt.event_id,'',v_header_currency_code
1103: ,evt.currency_code)
1104: from ota_resource_bookings trb
1105: , ota_events evt
1106: where trb.resource_booking_id = p_resource_booking_id
1107: and evt.event_id(+) = trb.event_id;*/
1108: --
1109: Begin

Line 1236: v_line_currency_code ota_events.currency_code%type;

1232: ,p_resource_booking_id in number
1233: ,p_currency_code out nocopy varchar2
1234: ) is
1235: --
1236: v_line_currency_code ota_events.currency_code%type;
1237: v_proc varchar2(72) := g_package||'get_currency_code';
1238: --
1239: cursor sel_event_currency is
1240: select evt.currency_code

Line 1242: , ota_events evt

1238: --
1239: cursor sel_event_currency is
1240: select evt.currency_code
1241: from ota_delegate_bookings tdb
1242: , ota_events evt
1243: where tdb.booking_id = p_booking_id
1244: and evt.event_id = tdb.event_id;
1245: --
1246: cursor sel_price_list_currency is

Line 1257: , ota_events evt

1253: cursor sel_resource_alloc_currency is
1254: select evt.currency_code
1255: from ota_resource_allocations tra
1256: , ota_delegate_bookings tdb
1257: , ota_events evt
1258: where tra.resource_allocation_id = p_resource_allocation_id
1259: and tdb.booking_id = tra.booking_id
1260: and evt.event_id = tdb.event_id;
1261: --

Line 1265: , ota_events evt

1261: --
1262: cursor sel_resource_book_currency is
1263: select evt.currency_code
1264: from ota_resource_bookings trb
1265: , ota_events evt
1266: where trb.resource_booking_id = p_resource_booking_id
1267: and evt.event_id = trb.event_id;
1268: --
1269: Begin