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 OTA_EVENTS

Line 626: l_eventid ota_events.event_id%TYPE;

622: ,p_add_enroll_detail_data out nocopy varchar2
623: )
624: is
625:
626: l_eventid ota_events.event_id%TYPE;
627: l_activityversionid ota_events.ACTIVITY_VERSION_ID%TYPE;
628: -- l_costAlocationKeyflexId pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
629: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
630: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;

Line 627: l_activityversionid ota_events.ACTIVITY_VERSION_ID%TYPE;

623: )
624: is
625:
626: l_eventid ota_events.event_id%TYPE;
627: l_activityversionid ota_events.ACTIVITY_VERSION_ID%TYPE;
628: -- l_costAlocationKeyflexId pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
629: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
630: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
631: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;

Line 890: l_eventid ota_events.event_id%TYPE;

886: ,p_review_data out nocopy varchar2
887: )
888: is
889:
890: l_eventid ota_events.event_id%TYPE;
891: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
892: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
893: l_ccselectiontext varchar2(200);
894: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;

Line 1085: l_eventid ota_events.event_id%TYPE;

1081:
1082: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
1083: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
1084: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
1085: l_eventid ota_events.event_id%TYPE;
1086: l_object_version_number number;
1087: l_person_details OTA_EL_ENROLL_SS.csr_person_to_enroll_details%ROWTYPE;
1088: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
1089: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;

Line 1098: l_price_basis OTA_EVENTS.price_basis%TYPE;

1094: l_transaction_table hr_transaction_ss.transaction_table;
1095: l_from varchar2(15);
1096: l_cancel_boolean BOOLEAN;
1097: l_auto_create_finance VARCHAR2(40);
1098: l_price_basis OTA_EVENTS.price_basis%TYPE;
1099: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;
1100: l_business_group_id_to hr_all_organization_units.organization_id%type;
1101: l_assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE;
1102: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;

Line 1110: l_event_currency_code ota_events.currency_code%type;

1106: fapi_result VARCHAR2(40);
1107: fapi_from VARCHAR2(5);
1108: fapi_to VARCHAR2(5);
1109: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
1110: l_event_currency_code ota_events.currency_code%type;
1111: l_event_status ota_events.event_status%type;
1112: l_cost_allocation_keyflex_id VARCHAR2(1000);
1113: l_maximum_internal_attendees NUMBER;
1114: l_existing_internal NUMBER;

Line 1111: l_event_status ota_events.event_status%type;

1107: fapi_from VARCHAR2(5);
1108: fapi_to VARCHAR2(5);
1109: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
1110: l_event_currency_code ota_events.currency_code%type;
1111: l_event_status ota_events.event_status%type;
1112: l_cost_allocation_keyflex_id VARCHAR2(1000);
1113: l_maximum_internal_attendees NUMBER;
1114: l_existing_internal NUMBER;
1115: l_maximum_internal_allowed NUMBER;

Line 1120: l_offering_id ota_events.offering_id%type;

1116: l_automatic_transfer_gl VARCHAR2(40);
1117: result_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
1118: result_create_finance_line VARCHAR2(5) := 'Y';
1119: result_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
1120: l_offering_id ota_events.offering_id%type;
1121: l_date_booking_placed date;
1122: l_current_date date;
1123: l_restricted_assignment_id PER_ASSIGNMENTS_F.assignment_id%type;
1124: l_version_name ota_activity_versions.version_name%type;

Line 1126: l_owner_id ota_events.owner_id%type;

1122: l_current_date date;
1123: l_restricted_assignment_id PER_ASSIGNMENTS_F.assignment_id%type;
1124: l_version_name ota_activity_versions.version_name%type;
1125: l_owner_username fnd_user.user_name%type;
1126: l_owner_id ota_events.owner_id%type;
1127: l_activity_version_id ota_activity_versions.activity_version_id%type;
1128: l_event_title ota_events.title%type;
1129: l_course_start_date ota_events.course_start_date%type;
1130: l_course_end_date ota_events.course_end_date%type;

Line 1128: l_event_title ota_events.title%type;

1124: l_version_name ota_activity_versions.version_name%type;
1125: l_owner_username fnd_user.user_name%type;
1126: l_owner_id ota_events.owner_id%type;
1127: l_activity_version_id ota_activity_versions.activity_version_id%type;
1128: l_event_title ota_events.title%type;
1129: l_course_start_date ota_events.course_start_date%type;
1130: l_course_end_date ota_events.course_end_date%type;
1131: l_notification_text VARCHAR2(1000);
1132: l_business_group_name PER_BUSINESS_GROUPS.name%TYPE := null;

Line 1129: l_course_start_date ota_events.course_start_date%type;

1125: l_owner_username fnd_user.user_name%type;
1126: l_owner_id ota_events.owner_id%type;
1127: l_activity_version_id ota_activity_versions.activity_version_id%type;
1128: l_event_title ota_events.title%type;
1129: l_course_start_date ota_events.course_start_date%type;
1130: l_course_end_date ota_events.course_end_date%type;
1131: l_notification_text VARCHAR2(1000);
1132: l_business_group_name PER_BUSINESS_GROUPS.name%TYPE := null;
1133:

Line 1130: l_course_end_date ota_events.course_end_date%type;

1126: l_owner_id ota_events.owner_id%type;
1127: l_activity_version_id ota_activity_versions.activity_version_id%type;
1128: l_event_title ota_events.title%type;
1129: l_course_start_date ota_events.course_start_date%type;
1130: l_course_end_date ota_events.course_end_date%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;

Line 1134: l_business_group_id ota_events.business_group_id%type;

1130: l_course_end_date ota_events.course_end_date%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;

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 1162: CURSOR bg_to (l_event_id ota_events.event_id%TYPE) IS

1158:
1159: status_not_seeded exception;
1160:
1161:
1162: CURSOR bg_to (l_event_id ota_events.event_id%TYPE) IS
1163: SELECT hao.business_group_id,
1164: evt.organization_id,
1165: evt.currency_code,
1166: evt.offering_id,

Line 1173: FROM OTA_EVENTS evt,

1169: evttl.Title,
1170: evt.course_start_date,
1171: evt.course_end_date,
1172: evt.business_group_id bg_id -- Bug#2215026 evt.business_group_id included.
1173: FROM OTA_EVENTS evt,
1174: OTA_EVENTS_TL evttl,
1175: HR_ALL_ORGANIZATION_UNITS hao
1176: WHERE evt.event_id = l_event_id
1177: AND evt.event_id = evttl.event_id

Line 1174: OTA_EVENTS_TL evttl,

1170: evt.course_start_date,
1171: evt.course_end_date,
1172: evt.business_group_id bg_id -- Bug#2215026 evt.business_group_id included.
1173: FROM OTA_EVENTS evt,
1174: OTA_EVENTS_TL evttl,
1175: HR_ALL_ORGANIZATION_UNITS hao
1176: WHERE evt.event_id = l_event_id
1177: AND evt.event_id = evttl.event_id
1178: AND evt.organization_id = hao.organization_id (+) --Bug#2215026 (+) included.

Line 1187: from OTA_EVENTS

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
1191: SELECT count(*)

Line 2082: l_offering_id ota_events.offering_id%type;

2078: l_transfer_status ota_finance_headers.transfer_status%type;
2079: l_administrator ota_finance_headers.administrator%type;
2080: l_date_format varchar2(200);
2081:
2082: l_offering_id ota_events.offering_id%type;
2083:
2084: CURSOR THG_FROM(p_business_group_id in number)
2085: IS
2086: Select

Line 2149: OTA_EVENTS EVT

2145:
2146: CURSOR SPO IS
2147: SELECT hr.COST_ALLOCATION_KEYFLEX_ID
2148: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2149: OTA_EVENTS EVT
2150: WHERE hr.organization_id = evt.organization_id and
2151: evt.event_id = p_event_id;
2152:
2153: /* For Ilearning */

Line 2157: FROM ota_events

2153: /* For Ilearning */
2154: CURSOR csr_event
2155: IS
2156: SELECT offering_id
2157: FROM ota_events
2158: where event_id= p_event_id;
2159:
2160: Begin
2161: p_result := 'S';

Line 2316: OTA_EVENTS EVT

2312: CLOSE SPO;
2313:
2314: /* SELECT hr.COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
2315: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2316: OTA_EVENTS EVT
2317: WHERE hr.organization_id = evt.organization_id and
2318: evt.event_id = p_event_id; */
2319: l_dynamicSqlString := 'SELECT ' ||from_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2320: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;

Line 2553: OTA_EVENTS EVT

2549: CLOSE SPO;
2550:
2551: /* SELECT hr.COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
2552: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2553: OTA_EVENTS EVT
2554: WHERE hr.organization_id = evt.organization_id and
2555: evt.event_id = p_event_id; */
2556: l_dynamicSqlString := 'SELECT ' ||to_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2557: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;