2834: l_return_status VARCHAR2(20) := NULL;
2835: BEGIN
2836:
2837:
2838: OE_HEADER_STATUS_PUB.Get_Booked_Status
2839: (
2840: p_header_id => p_Header_Id
2841: , x_result => l_result
2842: , x_result_date => l_result_date
2849:
2850: END IF;
2851:
2852:
2853: OE_HEADER_STATUS_PUB.Get_Closed_Status
2854: (
2855: p_header_id => p_Header_Id
2856: , x_result => l_result
2857: , x_result_date => l_result_date
2867: END IF;
2868:
2869: END IF;
2870:
2871: OE_HEADER_STATUS_PUB.Get_Cancelled_Status
2872: (
2873: p_header_id => p_Header_Id
2874: , x_result => l_result
2875: , x_result_date => l_result_date