DBA Data[Home] [Help]

APPS.AHL_RA_ANALYSER_PVT dependencies on AHL_UA_FLIGHT_SCHEDULES_PUB

Line 247: l_flight_search_rec_type AHL_UA_FLIGHT_SCHEDULES_PUB.FLIGHT_SEARCH_REC_TYPE;

243: l_fs_uc_header_id_tbl NumTabType;
244: l_fs_csi_instance_id_tbl NumTabType;
245: l_fs_arrival_date_tbl DateTabType;
246: l_fs_org_code_tbl Varchar3TabType;
247: l_flight_search_rec_type AHL_UA_FLIGHT_SCHEDULES_PUB.FLIGHT_SEARCH_REC_TYPE;
248: l_flight_schedules_tbl AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULES_TBL_TYPE;
249: l_fs_index NUMBER := 1;
250:
251: -- Temp Tables used for fetching data from c_uc_node_details

Line 598: l_flight_search_rec_type.DATE_APPLY_TO_FLAG := AHL_UA_FLIGHT_SCHEDULES_PUB.G_APPLY_TO_ARRIVAL;

594: END IF;
595:
596: l_flight_search_rec_type.START_DATE := p_start_date - 1;
597: l_flight_search_rec_type.END_DATE := p_end_date + 1;
598: l_flight_search_rec_type.DATE_APPLY_TO_FLAG := AHL_UA_FLIGHT_SCHEDULES_PUB.G_APPLY_TO_ARRIVAL;
599:
600: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
601: fnd_log.string(fnd_log.level_statement,l_full_name,' START_DATE - UA API' || l_flight_search_rec_type.START_DATE);
602: fnd_log.string(fnd_log.level_statement,l_full_name,' END_DATE - UA API' || l_flight_search_rec_type.END_DATE);

Line 606: AHL_UA_FLIGHT_SCHEDULES_PUB.Get_Flight_Schedule_Details(

602: fnd_log.string(fnd_log.level_statement,l_full_name,' END_DATE - UA API' || l_flight_search_rec_type.END_DATE);
603: fnd_log.string(fnd_log.level_statement,l_full_name,' DATE_APPLY_TO_FLAG - UA API : ' || l_flight_search_rec_type.DATE_APPLY_TO_FLAG);
604: END IF;
605:
606: AHL_UA_FLIGHT_SCHEDULES_PUB.Get_Flight_Schedule_Details(
607: -- standard IN params
608: p_api_version => 1,
609: p_init_msg_list => FND_API.G_FALSE,
610: p_commit => FND_API.G_FALSE,

Line 624: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API AHL_UA_FLIGHT_SCHEDULES_PUB.Get_Flight_Schedule_Details Errored');

620: x_flight_schedules_tbl => l_flight_schedules_tbl);
621:
622: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
623: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
624: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API AHL_UA_FLIGHT_SCHEDULES_PUB.Get_Flight_Schedule_Details Errored');
625: END IF;
626: IF (p_concurrent_flag = 'Y') THEN
627: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Error in getting Flight Scedule Details --');
628: END IF;