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

Line 1135: l_standard_price ota_events.standard_price%type;

1131: l_notification_text VARCHAR2(1000);
1132: l_business_group_name PER_BUSINESS_GROUPS.name%TYPE := null;
1133:
1134: l_business_group_id ota_events.business_group_id%type;
1135: l_standard_price ota_events.standard_price%type;
1136:
1137: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
1138: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
1139: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;

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

1180:
1181: --variable l_eventid is replaced with l_event_id as it is passed to the cursor
1182:
1183:
1184: --Bug#2221320 hdshah standard price included.
1185: Cursor Get_Event_status is
1186: Select event_status, maximum_internal_attendees,nvl(price_basis,NULL),standard_price
1187: from OTA_EVENTS
1188: WHERE EVENT_ID = l_eventid;

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

1182:
1183:
1184: --Bug#2221320 hdshah standard price included.
1185: Cursor Get_Event_status is
1186: Select event_status, maximum_internal_attendees,nvl(price_basis,NULL),standard_price
1187: from OTA_EVENTS
1188: WHERE EVENT_ID = l_eventid;
1189:
1190: CURSOR get_existing_internal IS

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

1638: l_course_end_date,
1639: l_business_group_id;
1640: CLOSE bg_to;
1641:
1642: --Bug#2221320 hdshah l_standard_price included.
1643: OPEN get_event_status;
1644: FETCH get_event_status into l_event_status, l_maximum_internal_attendees,l_price_basis,l_standard_price;
1645: CLOSE get_event_status;
1646:

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

1640: CLOSE bg_to;
1641:
1642: --Bug#2221320 hdshah l_standard_price included.
1643: OPEN get_event_status;
1644: FETCH get_event_status into l_event_status, l_maximum_internal_attendees,l_price_basis,l_standard_price;
1645: CLOSE get_event_status;
1646:
1647: OPEN get_existing_internal;
1648: FETCH get_existing_internal into l_existing_internal;

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

1787: ,avalue => l_notification_text);
1788:
1789: result_object_version_number := fapi_object_version_number;
1790: result_finance_header_id := fapi_finance_header_id;
1791: --Bug#2221320 hdshah p_currency_code, p_standard_amount, p_money_amount, p_unitary_amount, p_booking_deal_id,
1792: -- p_booking_deal_type included and p_update_finance_line parameter changed from 'N' to 'Y'.
1793: --Bug#2215026 separate update_enrollment procedure call included for successful finance creation.
1794: ota_tdb_api_upd2.update_enrollment(
1795: p_booking_id => l_booking_id,

Line 1803: p_standard_amount => l_standard_price,

1799: p_tfl_object_version_number => result_object_version_number,
1800: -- p_update_finance_line => 'N',
1801: p_update_finance_line => 'Y',
1802: p_currency_code => l_event_currency_code,
1803: p_standard_amount => l_standard_price,
1804: p_money_amount => l_standard_price,
1805: p_unitary_amount => null,
1806: p_booking_deal_id => null,
1807: p_booking_deal_type => 'N',

Line 1804: p_money_amount => l_standard_price,

1800: -- p_update_finance_line => 'N',
1801: p_update_finance_line => 'Y',
1802: p_currency_code => l_event_currency_code,
1803: p_standard_amount => l_standard_price,
1804: p_money_amount => l_standard_price,
1805: p_unitary_amount => null,
1806: p_booking_deal_id => null,
1807: p_booking_deal_type => 'N',
1808: p_finance_header_id => result_finance_header_id,

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

1867: p_date_booking_placed => l_date_booking_placed);
1868:
1869: END IF;
1870: /*Bug#2215026 Two separate update_enrollment procedure calls included for successful and unsuccessful finance creation.
1871: --Bug#2221320 hdshah p_currency_code, p_standard_amount, p_money_amount, p_unitary_amount, p_booking_deal_id, p_booking_deal_type included.
1872: -- p_update_finance_line parameter changed from 'N' to 'Y'.
1873: ota_tdb_api_upd2.update_enrollment(
1874: p_booking_id => l_booking_id,
1875: p_event_id => l_eventid,

Line 1882: p_standard_amount => l_standard_price,

1878: p_tfl_object_version_number => result_object_version_number,
1879: -- p_update_finance_line => 'N',
1880: p_update_finance_line => 'Y',
1881: p_currency_code => l_event_currency_code,
1882: p_standard_amount => l_standard_price,
1883: p_money_amount => l_standard_price,
1884: p_unitary_amount => null,
1885: p_booking_deal_id => null,
1886: p_booking_deal_type => 'N',

Line 1883: p_money_amount => l_standard_price,

1879: -- p_update_finance_line => 'N',
1880: p_update_finance_line => 'Y',
1881: p_currency_code => l_event_currency_code,
1882: p_standard_amount => l_standard_price,
1883: p_money_amount => l_standard_price,
1884: p_unitary_amount => null,
1885: p_booking_deal_id => null,
1886: p_booking_deal_type => 'N',
1887: p_finance_header_id => result_finance_header_id,