APPS.OTA_LEARNER_ENROLL_REVIEW_SS dependencies on STANDARD

Line 1022: l_standard_price ota_events.standard_price%type;

1018: l_notification_text VARCHAR2(1000);
1019: l_business_group_name PER_BUSINESS_GROUPS.name%TYPE := null;
1020:
1021: l_business_group_id ota_events.business_group_id%type;
1022: l_standard_price ota_events.standard_price%type;
1023:
1024: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
1025: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
1026: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;

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

1080: AND ctl.Category_usage_id = ofr.delivery_mode_id
1081: AND ctl.language = userenv('LANG') ;
1082:
1083:
1084: --Bug#2221320 hdshah standard price included.
1085: Cursor Get_Event_status is
1086: Select event_status, maximum_internal_attendees,nvl(price_basis,NULL),standard_price
1087: from OTA_EVENTS
1088: WHERE EVENT_ID = l_eventid;

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

1082:
1083:
1084: --Bug#2221320 hdshah standard price included.
1085: Cursor Get_Event_status is
1086: Select event_status, maximum_internal_attendees,nvl(price_basis,NULL),standard_price
1087: from OTA_EVENTS
1088: WHERE EVENT_ID = l_eventid;
1089:
1090: CURSOR get_existing_internal IS

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

1586: l_event_location,l_timezone,l_course_end_time;
1587:
1588: CLOSE bg_to;
1589:
1590: --Bug#2221320 hdshah l_standard_price included.
1591: OPEN get_event_status;
1592: FETCH get_event_status into l_event_status, l_maximum_internal_attendees,l_price_basis,l_standard_price;
1593: CLOSE get_event_status;
1594:

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

1588: CLOSE bg_to;
1589:
1590: --Bug#2221320 hdshah l_standard_price included.
1591: OPEN get_event_status;
1592: FETCH get_event_status into l_event_status, l_maximum_internal_attendees,l_price_basis,l_standard_price;
1593: CLOSE get_event_status;
1594:
1595: OPEN get_existing_internal;
1596: FETCH get_existing_internal into l_existing_internal;

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

1727: ,avalue => l_notification_text);
1728:
1729: result_object_version_number := fapi_object_version_number;
1730: result_finance_header_id := fapi_finance_header_id;
1731: --Bug#2221320 hdshah p_currency_code, p_standard_amount, p_money_amount, p_unitary_amount, p_booking_deal_id,
1732: -- p_booking_deal_type included and p_update_finance_line parameter changed from 'N' to 'Y'.
1733: --Bug#2215026 separate update_enrollment procedure call included for successful finance creation.
1734: ota_tdb_api_upd2.update_enrollment(
1735: p_booking_id => l_booking_id,

Line 1743: p_standard_amount => l_standard_price,

1739: p_tfl_object_version_number => result_object_version_number,
1740: -- p_update_finance_line => 'N',
1741: p_update_finance_line => 'Y',
1742: p_currency_code => l_event_currency_code,
1743: p_standard_amount => l_standard_price,
1744: p_money_amount => l_standard_price,
1745: p_unitary_amount => null,
1746: p_booking_deal_id => null,
1747: p_booking_deal_type => 'N',

Line 1744: p_money_amount => l_standard_price,

1740: -- p_update_finance_line => 'N',
1741: p_update_finance_line => 'Y',
1742: p_currency_code => l_event_currency_code,
1743: p_standard_amount => l_standard_price,
1744: p_money_amount => l_standard_price,
1745: p_unitary_amount => null,
1746: p_booking_deal_id => null,
1747: p_booking_deal_type => 'N',
1748: p_finance_header_id => result_finance_header_id,

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

1807: p_date_booking_placed => l_date_booking_placed);
1808:
1809: END IF;
1810: /*Bug#2215026 Two separate update_enrollment procedure calls included for successful and unsuccessful finance creation.
1811: --Bug#2221320 hdshah p_currency_code, p_standard_amount, p_money_amount, p_unitary_amount, p_booking_deal_id, p_booking_deal_type included.
1812: -- p_update_finance_line parameter changed from 'N' to 'Y'.
1813: */
1814: wf_engine.setItemAttrText (itemtype => l_item_type
1815: ,itemkey => l_item_key