[Home] [Help]
1340: l_eventid ota_events.event_id%TYPE;
1341: l_object_version_number number;
1342: l_person_details OTA_ENROLL_IN_TRAINING_SS.csr_person_to_enroll_details%ROWTYPE;
1343: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
1344: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
1345: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
1346: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
1347: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
1348: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
1355: l_business_group_id_to hr_all_organization_units.organization_id%type;
1356: l_assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE;
1357: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;
1358: l_user NUMBER;
1359: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
1360: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
1361: fapi_result VARCHAR2(40);
1362: fapi_from VARCHAR2(5);
1363: fapi_to VARCHAR2(5);
1356: l_assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE;
1357: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;
1358: l_user NUMBER;
1359: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
1360: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
1361: fapi_result VARCHAR2(40);
1362: fapi_from VARCHAR2(5);
1363: fapi_to VARCHAR2(5);
1364: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
1368: l_maximum_internal_attendees NUMBER;
1369: l_existing_internal NUMBER;
1370: l_maximum_internal_allowed NUMBER;
1371: l_automatic_transfer_gl VARCHAR2(40);
1372: result_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
1373: result_create_finance_line VARCHAR2(5) := 'Y';
1374: result_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
1375: l_offering_id ota_events.offering_id%type;
1376: l_date_booking_placed date;
1370: l_maximum_internal_allowed NUMBER;
1371: l_automatic_transfer_gl VARCHAR2(40);
1372: result_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
1373: result_create_finance_line VARCHAR2(5) := 'Y';
1374: result_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
1375: l_offering_id ota_events.offering_id%type;
1376: l_date_booking_placed date;
1377: l_current_date date;
1378: l_restricted_assignment_id PER_ASSIGNMENTS_F.assignment_id%type;
2067: p_date_booking_placed => l_date_booking_placed);
2068:
2069:
2070: IF l_automatic_transfer_gl = 'Y' AND l_finance_line_id IS NOT NULL AND l_offering_id is null THEN
2071: UPDATE ota_finance_lines SET transfer_status = 'AT'
2072: WHERE finance_line_id = l_finance_line_id;
2073: END IF;
2074:
2075:
2147:
2148:
2149: IF l_automatic_transfer_gl = 'Y' AND l_finance_line_id IS NOT NULL AND l_offering_id is null THEN
2150:
2151: UPDATE ota_finance_lines SET transfer_status = 'AT'
2152: WHERE finance_line_id = l_finance_line_id;
2153: END IF;
2154: */
2155: wf_engine.setItemAttrText (itemtype => l_item_type
2259: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
2260: l_object_version_number number;
2261: l_date_booking_placed date;
2262: l_current_date date;
2263: result_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
2264: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
2265:
2266:
2267:
2260: l_object_version_number number;
2261: l_date_booking_placed date;
2262: l_current_date date;
2263: result_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
2264: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
2265:
2266:
2267:
2268: CURSOR csr_chk_event