APPS.OTA_ENROLL_REVIEW_SS dependencies on STANDARD

Line 940: l_standard_price ota_events.standard_price%type;

936: l_notification_text VARCHAR2(1000);
937: l_business_group_name PER_BUSINESS_GROUPS.name%TYPE := null;
938:
939: l_business_group_id ota_events.business_group_id%type;
940: l_standard_price ota_events.standard_price%type;
941:
942: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
943: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
944: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;

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

981: AND evt.organization_id = hao.organization_id (+); --Bug#2215026 (+) included.
982:
983:
984:
985: --Bug#2221320 hdshah standard price included.
986: Cursor Get_Event_status is
987: Select event_status, maximum_internal_attendees,nvl(price_basis,NULL),standard_price
988: from OTA_EVENTS
989: WHERE EVENT_ID = l_eventid;

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

983:
984:
985: --Bug#2221320 hdshah standard price included.
986: Cursor Get_Event_status is
987: Select event_status, maximum_internal_attendees,nvl(price_basis,NULL),standard_price
988: from OTA_EVENTS
989: WHERE EVENT_ID = l_eventid;
990:
991: CURSOR get_existing_internal IS

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

1445: l_course_end_date,
1446: l_business_group_id;
1447: CLOSE bg_to;
1448:
1449: --Bug#2221320 hdshah l_standard_price included.
1450: OPEN get_event_status;
1451: FETCH get_event_status into l_event_status, l_maximum_internal_attendees,l_price_basis,l_standard_price;
1452: CLOSE get_event_status;
1453:

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

1447: CLOSE bg_to;
1448:
1449: --Bug#2221320 hdshah l_standard_price included.
1450: OPEN get_event_status;
1451: FETCH get_event_status into l_event_status, l_maximum_internal_attendees,l_price_basis,l_standard_price;
1452: CLOSE get_event_status;
1453:
1454: OPEN get_existing_internal;
1455: FETCH get_existing_internal into l_existing_internal;

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

1594: ,avalue => l_notification_text);
1595:
1596: result_object_version_number := fapi_object_version_number;
1597: result_finance_header_id := fapi_finance_header_id;
1598: --Bug#2221320 hdshah p_currency_code, p_standard_amount, p_money_amount, p_unitary_amount, p_booking_deal_id,
1599: -- p_booking_deal_type included and p_update_finance_line parameter changed from 'N' to 'Y'.
1600: --Bug#2215026 separate update_enrollment procedure call included for successful finance creation.
1601: ota_tdb_api_upd2.update_enrollment(
1602: p_booking_id => l_booking_id,

Line 1610: p_standard_amount => l_standard_price,

1606: p_tfl_object_version_number => result_object_version_number,
1607: -- p_update_finance_line => 'N',
1608: p_update_finance_line => 'Y',
1609: p_currency_code => l_event_currency_code,
1610: p_standard_amount => l_standard_price,
1611: p_money_amount => l_standard_price,
1612: p_unitary_amount => null,
1613: p_booking_deal_id => null,
1614: p_booking_deal_type => 'N',

Line 1611: p_money_amount => l_standard_price,

1607: -- p_update_finance_line => 'N',
1608: p_update_finance_line => 'Y',
1609: p_currency_code => l_event_currency_code,
1610: p_standard_amount => l_standard_price,
1611: p_money_amount => l_standard_price,
1612: p_unitary_amount => null,
1613: p_booking_deal_id => null,
1614: p_booking_deal_type => 'N',
1615: p_finance_header_id => result_finance_header_id,

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

1674: p_date_booking_placed => l_date_booking_placed);
1675:
1676: END IF;
1677: /*Bug#2215026 Two separate update_enrollment procedure calls included for successful and unsuccessful finance creation.
1678: --Bug#2221320 hdshah p_currency_code, p_standard_amount, p_money_amount, p_unitary_amount, p_booking_deal_id, p_booking_deal_type included.
1679: -- p_update_finance_line parameter changed from 'N' to 'Y'.
1680: */
1681: wf_engine.setItemAttrText (itemtype => l_item_type
1682: ,itemkey => l_item_key