1 PACKAGE BODY AHL_REPORT_FUNCTIONS_CUHK AS
2 /* $Header: AHLCRPCB.pls 120.1.12020000.2 2012/12/06 22:22:53 sareepar ship $ */
3
4
5 ------------------------------------------------------------------------------------
6 -- FUNCTION
7 -- Get_Next_Weight_Check_Due
8
9 -- Returns the due date of the most restrictive MR applicable to the selected unit
10 -- which MR Route has the Route process Aircraft Weigh and Balance assigned.
11 ------------------------------------------------------------------------------------
12 FUNCTION Get_Next_Weight_Check_Due(P_INSTANCE_ID IN NUMBER,MR_HEADER_ID IN NUMBER)
13 RETURN DATE IS
14
15 l_due_date DATE;
16
17 BEGIN
18 l_due_date := null;
19 RETURN l_due_date ;
20
21 END Get_Next_Weight_Check_Due;
22
23
24 ------------------------------------------------------------------------------------
25 -- FUNCTION
26 -- Get_Last_MR_Accomplished
27
28 -- Returns the last MR RST accomplished or initial accomplished.
29 ------------------------------------------------------------------------------------
30 FUNCTION Get_Last_MR_Accomplished(P_INSTANCE_ID IN NUMBER)
31 RETURN VARCHAR2 IS
32
33 l_mr_title VARCHAR2(80);
34
35 BEGIN
36 l_mr_title := null;
37 RETURN l_mr_title ;
38
39 END Get_Last_MR_Accomplished;
40
41
42 ------------------------------------------------------------------------------------
43 -- FUNCTION
44 -- Get_Last_MR_Accomplished_Date
45
46 -- Returns the last MR RST accomplished or initial accomplished date.
47 ------------------------------------------------------------------------------------
48 FUNCTION Get_Last_MR_Accomplished_Date(P_INSTANCE_ID IN NUMBER)
49 RETURN DATE IS
50
51 l_accomplished_date DATE;
52
53 BEGIN
54 l_accomplished_date := null;
55 RETURN l_accomplished_date ;
56
57 END Get_Last_MR_Accomplished_Date;
58
59
60 ------------------------------------------------------------------------------------
61 -- FUNCTION
62 -- Get_Forecast_Removal_Date
63
64 -- UMP search for restrictiveness MR RST for the unit or any of its OF WING Dependent components
65 -- if none ON COND
66 ------------------------------------------------------------------------------------
67 FUNCTION Get_Forecast_Removal_Date(P_INSTANCE_ID IN NUMBER)
68 RETURN DATE IS
69
70 l_removal_date DATE;
71
72 BEGIN
73 l_removal_date := null;
74 RETURN l_removal_date ;
75
76 END Get_Forecast_Removal_Date;
77
78
79 END AHL_REPORT_FUNCTIONS_CUHK;
80