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_TRAINING_SS dependencies on STANDARD

Line 1390: l_standard_price ota_events.standard_price%type;

1386: l_notification_text VARCHAR2(1000);
1387: l_business_group_name PER_BUSINESS_GROUPS.name%TYPE := null;
1388:
1389: l_business_group_id ota_events.business_group_id%type;
1390: l_standard_price ota_events.standard_price%type;
1391:
1392: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
1393: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
1394: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;

Line 1435: --Bug#2221320 hdshah standard price included.

1431: AND evt.organization_id = hao.organization_id (+); --Bug#2215026 (+) included.
1432:
1433:
1434:
1435: --Bug#2221320 hdshah standard price included.
1436: Cursor Get_Event_status is
1437: Select event_status, maximum_internal_attendees,nvl(price_basis,NULL),standard_price
1438: from OTA_EVENTS
1439: WHERE EVENT_ID = l_eventid;

Line 1437: Select event_status, maximum_internal_attendees,nvl(price_basis,NULL),standard_price

1433:
1434:
1435: --Bug#2221320 hdshah standard price included.
1436: Cursor Get_Event_status is
1437: Select event_status, maximum_internal_attendees,nvl(price_basis,NULL),standard_price
1438: from OTA_EVENTS
1439: WHERE EVENT_ID = l_eventid;
1440:
1441: CURSOR get_existing_internal IS

Line 1898: --Bug#2221320 hdshah l_standard_price included.

1894: l_course_end_date,
1895: l_business_group_id;
1896: CLOSE bg_to;
1897:
1898: --Bug#2221320 hdshah l_standard_price included.
1899: OPEN get_event_status;
1900: FETCH get_event_status into l_event_status, l_maximum_internal_attendees,l_price_basis,l_standard_price;
1901: CLOSE get_event_status;
1902:

Line 1900: FETCH get_event_status into l_event_status, l_maximum_internal_attendees,l_price_basis,l_standard_price;

1896: CLOSE bg_to;
1897:
1898: --Bug#2221320 hdshah l_standard_price included.
1899: OPEN get_event_status;
1900: FETCH get_event_status into l_event_status, l_maximum_internal_attendees,l_price_basis,l_standard_price;
1901: CLOSE get_event_status;
1902:
1903: OPEN get_existing_internal;
1904: FETCH get_existing_internal into l_existing_internal;

Line 2047: --Bug#2221320 hdshah p_currency_code, p_standard_amount, p_money_amount, p_unitary_amount, p_booking_deal_id,

2043: ,avalue => l_notification_text);
2044:
2045: result_object_version_number := fapi_object_version_number;
2046: result_finance_header_id := fapi_finance_header_id;
2047: --Bug#2221320 hdshah p_currency_code, p_standard_amount, p_money_amount, p_unitary_amount, p_booking_deal_id,
2048: -- p_booking_deal_type included and p_update_finance_line parameter changed from 'N' to 'Y'.
2049: --Bug#2215026 separate update_enrollment procedure call included for successful finance creation.
2050: ota_tdb_api_upd2.update_enrollment(
2051: p_booking_id => l_booking_id,

Line 2059: p_standard_amount => l_standard_price,

2055: p_tfl_object_version_number => result_object_version_number,
2056: -- p_update_finance_line => 'N',
2057: p_update_finance_line => 'Y',
2058: p_currency_code => l_event_currency_code,
2059: p_standard_amount => l_standard_price,
2060: p_money_amount => l_standard_price,
2061: p_unitary_amount => null,
2062: p_booking_deal_id => null,
2063: p_booking_deal_type => 'N',

Line 2060: p_money_amount => l_standard_price,

2056: -- p_update_finance_line => 'N',
2057: p_update_finance_line => 'Y',
2058: p_currency_code => l_event_currency_code,
2059: p_standard_amount => l_standard_price,
2060: p_money_amount => l_standard_price,
2061: p_unitary_amount => null,
2062: p_booking_deal_id => null,
2063: p_booking_deal_type => 'N',
2064: p_finance_header_id => result_finance_header_id,

Line 2127: --Bug#2221320 hdshah p_currency_code, p_standard_amount, p_money_amount, p_unitary_amount, p_booking_deal_id, p_booking_deal_type included.

2123: p_date_booking_placed => l_date_booking_placed);
2124:
2125: END IF;
2126: /*Bug#2215026 Two separate update_enrollment procedure calls included for successful and unsuccessful finance creation.
2127: --Bug#2221320 hdshah p_currency_code, p_standard_amount, p_money_amount, p_unitary_amount, p_booking_deal_id, p_booking_deal_type included.
2128: -- p_update_finance_line parameter changed from 'N' to 'Y'.
2129: ota_tdb_api_upd2.update_enrollment(
2130: p_booking_id => l_booking_id,
2131: p_event_id => l_eventid,

Line 2138: p_standard_amount => l_standard_price,

2134: p_tfl_object_version_number => result_object_version_number,
2135: -- p_update_finance_line => 'N',
2136: p_update_finance_line => 'Y',
2137: p_currency_code => l_event_currency_code,
2138: p_standard_amount => l_standard_price,
2139: p_money_amount => l_standard_price,
2140: p_unitary_amount => null,
2141: p_booking_deal_id => null,
2142: p_booking_deal_type => 'N',

Line 2139: p_money_amount => l_standard_price,

2135: -- p_update_finance_line => 'N',
2136: p_update_finance_line => 'Y',
2137: p_currency_code => l_event_currency_code,
2138: p_standard_amount => l_standard_price,
2139: p_money_amount => l_standard_price,
2140: p_unitary_amount => null,
2141: p_booking_deal_id => null,
2142: p_booking_deal_type => 'N',
2143: p_finance_header_id => result_finance_header_id,