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 1591: --Bug#2221320 hdshah l_standard_price included.

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

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

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

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

1736: ,avalue => l_notification_text);
1737:
1738: result_object_version_number := fapi_object_version_number;
1739: result_finance_header_id := fapi_finance_header_id;
1740: --Bug#2221320 hdshah p_currency_code, p_standard_amount, p_money_amount, p_unitary_amount, p_booking_deal_id,
1741: -- p_booking_deal_type included and p_update_finance_line parameter changed from 'N' to 'Y'.
1742: --Bug#2215026 separate update_enrollment procedure call included for successful finance creation.
1743: ota_tdb_api_upd2.update_enrollment(
1744: p_booking_id => l_booking_id,

Line 1752: p_standard_amount => l_standard_price,

1748: p_tfl_object_version_number => result_object_version_number,
1749: -- p_update_finance_line => 'N',
1750: p_update_finance_line => 'Y',
1751: p_currency_code => l_event_currency_code,
1752: p_standard_amount => l_standard_price,
1753: p_money_amount => l_standard_price,
1754: p_unitary_amount => null,
1755: p_booking_deal_id => null,
1756: p_booking_deal_type => 'N',

Line 1753: p_money_amount => l_standard_price,

1749: -- p_update_finance_line => 'N',
1750: p_update_finance_line => 'Y',
1751: p_currency_code => l_event_currency_code,
1752: p_standard_amount => l_standard_price,
1753: p_money_amount => l_standard_price,
1754: p_unitary_amount => null,
1755: p_booking_deal_id => null,
1756: p_booking_deal_type => 'N',
1757: p_finance_header_id => result_finance_header_id,

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

1816: p_date_booking_placed => l_date_booking_placed);
1817:
1818: END IF;
1819: /*Bug#2215026 Two separate update_enrollment procedure calls included for successful and unsuccessful finance creation.
1820: --Bug#2221320 hdshah p_currency_code, p_standard_amount, p_money_amount, p_unitary_amount, p_booking_deal_id, p_booking_deal_type included.
1821: -- p_update_finance_line parameter changed from 'N' to 'Y'.
1822: */
1823: wf_engine.setItemAttrText (itemtype => l_item_type
1824: ,itemkey => l_item_key