13: l_return_status VARCHAR2(20) := NULL;
14:
15: BEGIN
16:
17: OE_HEADER_STATUS_PUB.Get_Booked_Status
18: (
19: p_header_id => p_Header_Id
20: , x_result => l_result
21: , x_result_date => l_result_date
28:
29: END IF;
30:
31:
32: OE_HEADER_STATUS_PUB.Get_Closed_Status
33: (
34: p_header_id => p_Header_Id
35: , x_result => l_result
36: , x_result_date => l_result_date
46: END IF;
47:
48: END IF;
49:
50: OE_HEADER_STATUS_PUB.Get_Cancelled_Status
51: (
52: p_header_id => p_Header_Id
53: , x_result => l_result
54: , x_result_date => l_result_date