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_TFL_API_BUS dependencies on OTA_TFL_API_BUS

Line 1: Package Body ota_tfl_api_bus as

1: Package Body ota_tfl_api_bus as
2: /* $Header: ottfl01t.pkb 120.0 2005/05/29 07:41:43 appldev noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' ota_tfl_api_bus.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' ota_tfl_api_bus.'; -- Global package name
9: --
10: -- ----------------------------------------------------------------------------
11: -- |---------------------------< insert_validate >----------------------------|
12: -- ----------------------------------------------------------------------------

Line 31: ota_tfl_api_business_rules.get_finance_header

27: --
28: hr_utility.set_location('Entering:'||l_proc, 5);
29: --
30: --
31: ota_tfl_api_business_rules.get_finance_header
32: (p_rec.finance_header_id
33: ,l_tfh_type
34: ,l_tfh_customer_id
35: ,l_tfh_vendor_id

Line 42: ota_tfl_api_business_rules.check_finance_header

38: ,l_tfh_superseded_flag
39: ,l_tfh_cancelled_flag);
40: --
41: -- General checks on the Finance Header
42: ota_tfl_api_business_rules.check_finance_header
43: (l_tfh_type
44: ,l_tfh_superseded_flag
45: ,l_tfh_transfer_status
46: ,l_tfh_cancelled_flag

Line 51: ota_tfl_api_business_rules.check_unique_finance_line

47: ,TRUE
48: ,TRUE);
49: --
50: if p_transaction_type <> 'COPY' then
51: ota_tfl_api_business_rules.check_unique_finance_line
52: (p_rec.finance_line_id
53: ,p_rec.line_type
54: ,p_rec.booking_id
55: ,p_rec.resource_booking_id

Line 59: ota_tfl_api_business_rules.check_type_constraints (

55: ,p_rec.resource_booking_id
56: ,p_rec.resource_allocation_id);
57: end if;
58: --
59: ota_tfl_api_business_rules.check_type_constraints (
60: p_finance_line_type => p_rec.line_type
61: ,p_finance_header_id => p_rec.finance_header_id
62: ,p_booking_id => p_rec.booking_id
63: ,p_booking_deal_id => p_rec.booking_deal_id

Line 68: ota_tfl_api_business_rules.Check_currency_code

64: ,p_resource_booking_id => p_rec.resource_booking_id
65: ,p_resource_allocation_id => p_rec.resource_allocation_id
66: );
67: --
68: ota_tfl_api_business_rules.Check_currency_code
69: (
70: p_finance_line_type => p_rec.line_type
71: ,p_finance_header_id => p_rec.finance_header_id
72: ,p_booking_id => p_rec.booking_id

Line 78: ota_tfl_api_business_rules2.set_all_amounts

74: ,p_resource_allocation_id => p_rec.resource_allocation_id
75: ,p_resource_booking_id => p_rec.resource_booking_id
76: );
77: --
78: ota_tfl_api_business_rules2.set_all_amounts
79: ( p_finance_line_type => p_rec.line_type
80: , p_activity_version_id => null
81: , p_event_id => null
82: , p_booking_id => p_rec.booking_id

Line 91: ota_tfl_api_business_rules.check_type_and_amounts

87: , p_standard_amount => p_rec.standard_amount
88: , p_money_amount => p_rec.money_amount
89: , p_unitary_amount => p_rec.unitary_amount );
90: --
91: ota_tfl_api_business_rules.check_type_and_amounts
92: ( p_finance_line_type => p_rec.line_type
93: , p_standard_amount => p_rec.standard_amount
94: , p_money_amount => p_rec.money_amount
95: , p_unitary_amount => p_rec.unitary_amount

Line 101: ota_tfl_api_business_rules.get_date_raised

97: , p_finance_header_id => p_rec.finance_header_id
98: );
99: --
100: hr_utility.trace('Date Raised '||to_char(p_rec.date_raised,'DD-MON-YYYY'));
101: ota_tfl_api_business_rules.get_date_raised
102: ( p_rec.finance_header_id
103: , p_rec.date_raised );
104: --
105: ota_tfl_api_business_rules.get_next_sequence_number

Line 105: ota_tfl_api_business_rules.get_next_sequence_number

101: ota_tfl_api_business_rules.get_date_raised
102: ( p_rec.finance_header_id
103: , p_rec.date_raised );
104: --
105: ota_tfl_api_business_rules.get_next_sequence_number
106: ( p_rec.finance_header_id
107: , p_rec.sequence_number );
108: --
109: --

Line 198: ota_tfl_api_business_rules.get_finance_header

194: p_unitary_amount := p_rec.unitary_amount;
195: p_date_raised := p_rec.date_raised;
196: p_sequence_number:= p_rec.sequence_number;
197: --
198: ota_tfl_api_business_rules.get_finance_header
199: (p_rec.finance_header_id
200: ,l_tfh_type
201: ,l_tfh_customer_id
202: ,l_tfh_vendor_id

Line 209: ota_tfl_api_business_rules.check_finance_header

205: ,l_tfh_superseded_flag
206: ,l_tfh_cancelled_flag);
207: --
208: -- General checks on the Finance Header
209: ota_tfl_api_business_rules.check_finance_header
210: (l_tfh_type
211: ,l_tfh_superseded_flag
212: ,l_tfh_transfer_status
213: ,l_tfh_cancelled_flag

Line 230: ota_tfl_api_business_rules.check_update_cancelled_flag

226: fnd_message.raise_error;
227: end if;
228: end if;
229: /*
230: ota_tfl_api_business_rules.check_update_cancelled_flag
231: ( p_rec.cancelled_flag );
232: */
233: --
234: ota_tfl_api_business_rules.check_update_attributes(p_rec.transfer_status);

Line 234: ota_tfl_api_business_rules.check_update_attributes(p_rec.transfer_status);

230: ota_tfl_api_business_rules.check_update_cancelled_flag
231: ( p_rec.cancelled_flag );
232: */
233: --
234: ota_tfl_api_business_rules.check_update_attributes(p_rec.transfer_status);
235: --
236: if p_transaction_type = 'CANCEL_LINE' then
237: return;
238: end if;

Line 258: ota_tfl_api_business_rules.check_unique_finance_line

254: p_rec.cancelled_flag = 'N')
255: or l_booking_id_changed
256: or l_resource_booking_id_changed
257: or l_resource_alloc_id_changed then
258: ota_tfl_api_business_rules.check_unique_finance_line
259: (p_rec.finance_line_id
260: ,p_rec.line_type
261: ,p_rec.booking_id
262: ,p_rec.resource_booking_id

Line 266: ota_tfl_api_business_rules.check_type_constraints (

262: ,p_rec.resource_booking_id
263: ,p_rec.resource_allocation_id);
264: end if;
265:
266: ota_tfl_api_business_rules.check_type_constraints (
267: p_finance_line_type => p_rec.line_type
268: ,p_finance_header_id => p_rec.finance_header_id
269: ,p_booking_id => p_rec.booking_id
270: ,p_booking_deal_id => p_rec.booking_deal_id

Line 275: ota_tfl_api_business_rules.Check_currency_code

271: ,p_resource_booking_id => p_rec.resource_booking_id
272: ,p_resource_allocation_id => p_rec.resource_allocation_id
273: );
274: --
275: ota_tfl_api_business_rules.Check_currency_code
276: (
277: p_finance_line_type => p_rec.line_type
278: ,p_finance_header_id => p_rec.finance_header_id
279: ,p_booking_id => p_rec.booking_id

Line 286: ota_tfl_api_business_rules.get_date_raised

282: ,p_resource_booking_id => p_rec.resource_booking_id
283: );
284: --
285: If p_date_raised is null Then
286: ota_tfl_api_business_rules.get_date_raised
287: ( p_rec.finance_header_id
288: , p_date_raised );
289: End if;
290: --

Line 292: ota_tfl_api_business_rules.get_next_sequence_number

288: , p_date_raised );
289: End if;
290: --
291: IF p_sequence_number is null Then
292: ota_tfl_api_business_rules.get_next_sequence_number
293: ( p_rec.finance_header_id
294: , p_sequence_number );
295: --
296: Elsif l_sequence_number_changed Then

Line 298: ota_tfl_api_business_rules.get_next_sequence_number

294: , p_sequence_number );
295: --
296: Elsif l_sequence_number_changed Then
297: If l_finance_header_id_changed Then
298: ota_tfl_api_business_rules.get_next_sequence_number
299: ( p_rec.finance_header_id
300: , p_sequence_number );
301: Else
302: ota_tfl_api_business_rules.check_sequence_number

Line 302: ota_tfl_api_business_rules.check_sequence_number

298: ota_tfl_api_business_rules.get_next_sequence_number
299: ( p_rec.finance_header_id
300: , p_sequence_number );
301: Else
302: ota_tfl_api_business_rules.check_sequence_number
303: ( p_rec.finance_header_id
304: , p_sequence_number );
305: End if;
306: --

Line 309: ota_tfl_api_business_rules.get_next_sequence_number

305: End if;
306: --
307: Else
308: If l_finance_header_id_changed Then
309: ota_tfl_api_business_rules.get_next_sequence_number
310: ( p_rec.finance_header_id
311: , p_sequence_number );
312: End if;
313: End if;

Line 322: ota_tfl_api_business_rules2.set_all_amounts (

318: l_resource_booking_id_changed OR
319: l_standard_amount_changed OR
320: p_money_amount is null Then
321: --
322: ota_tfl_api_business_rules2.set_all_amounts (
323: p_finance_line_type => p_rec.line_type
324: , p_activity_version_id => null
325: , p_event_id => null
326: , p_booking_id => p_rec.booking_id

Line 337: ota_tfl_api_business_rules.check_type_and_amounts

333: , p_unitary_amount => p_rec.unitary_amount );
334: --
335: End if;
336: --
337: ota_tfl_api_business_rules.check_type_and_amounts
338: ( p_finance_line_type => p_rec.line_type
339: , p_standard_amount => p_rec.standard_amount
340: , p_money_amount => p_rec.money_amount
341: , p_unitary_amount => p_rec.unitary_amount

Line 526: end ota_tfl_api_bus;

522: --
523: End return_legislation_code;
524:
525:
526: end ota_tfl_api_bus;