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_ENROLL_REVIEW_SS dependencies on OTA_FINANCE_LINES

Line 894: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;

890: l_eventid ota_events.event_id%TYPE;
891: l_object_version_number number;
892: l_person_details OTA_trng_enroll_SS.csr_person_to_enroll_details%ROWTYPE;
893: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
894: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
895: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
896: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
897: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
898: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;

Line 909: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;

905: l_business_group_id_to hr_all_organization_units.organization_id%type;
906: l_assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE;
907: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;
908: l_user NUMBER;
909: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
910: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
911: fapi_result VARCHAR2(40);
912: fapi_from VARCHAR2(5);
913: fapi_to VARCHAR2(5);

Line 910: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;

906: l_assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE;
907: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;
908: l_user NUMBER;
909: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
910: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
911: fapi_result VARCHAR2(40);
912: fapi_from VARCHAR2(5);
913: fapi_to VARCHAR2(5);
914: l_sponsor_organization_id hr_all_organization_units.organization_id%type;

Line 922: result_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;

918: l_maximum_internal_attendees NUMBER;
919: l_existing_internal NUMBER;
920: l_maximum_internal_allowed NUMBER;
921: l_automatic_transfer_gl VARCHAR2(40);
922: result_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
923: result_create_finance_line VARCHAR2(5) := 'Y';
924: result_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
925: l_offering_id ota_events.offering_id%type;
926: l_date_booking_placed date;

Line 924: result_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;

920: l_maximum_internal_allowed NUMBER;
921: l_automatic_transfer_gl VARCHAR2(40);
922: result_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
923: result_create_finance_line VARCHAR2(5) := 'Y';
924: result_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
925: l_offering_id ota_events.offering_id%type;
926: l_date_booking_placed date;
927: l_current_date date;
928: l_restricted_assignment_id PER_ASSIGNMENTS_F.assignment_id%type;

Line 1622: UPDATE ota_finance_lines SET transfer_status = 'AT'

1618: p_date_booking_placed => l_date_booking_placed);
1619:
1620:
1621: IF l_automatic_transfer_gl = 'Y' AND l_finance_line_id IS NOT NULL AND l_offering_id is null THEN
1622: UPDATE ota_finance_lines SET transfer_status = 'AT'
1623: WHERE finance_line_id = l_finance_line_id;
1624: END IF;
1625:
1626:

Line 1789: result_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;

1785: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
1786: l_object_version_number number;
1787: l_date_booking_placed date;
1788: l_current_date date;
1789: result_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
1790: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
1791:
1792:
1793:

Line 1790: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;

1786: l_object_version_number number;
1787: l_date_booking_placed date;
1788: l_current_date date;
1789: result_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
1790: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
1791:
1792:
1793:
1794: CURSOR csr_chk_event