1 PACKAGE AHL_COMPLEX_MX_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVCAMS.pls 120.0.12020000.2 2012/12/14 10:50:59 shnatu noship $ */
3
4 -- BG MR API
5 -- Function name : CALC_BUILD_GOAL
6 -- Type : Public
7 -- Parameters :
8 -- CALC_BUILD_GOAL params
9 -- p_instance_id NUMBER Required
10 -- p_visit_id DATE Required
11 -- p_ue_id DATE Required
12
13 FUNCTION CALC_BUILD_GOAL(
14 p_instance_id IN NUMBER,
15 p_visit_id IN NUMBER,
16 p_ue_id IN NUMBER := NULL
17 )
18 RETURN NUMBER;
19
20 -- Changes by STHILAK starts
21 /*
22 Function Name : get_removal_nr_due
23 Type : public
24 Parameters :
25 p_instance_id IN NUMBER Required
26 */
27 FUNCTION get_removal_nr_due
28 (
29 p_instance_id IN NUMBER)
30 RETURN DATE;
31
32 /*
33 Function Name : get_assm_due
34 Type : public
35 Parameters :
36 p_instance_id IN NUMBER Required
37 */
38
39 FUNCTION get_assm_due
40 (
41 p_instance_id IN NUMBER)
42 RETURN DATE;
43
44 /*
45 Function Name : is_unit_have_RTS_visit
46 Type : public
47 Parameters :
48 p_instance_id IN NUMBER Required
49 p_from_dt IN DATE Required
50 p_to_dt IN DATE Required
51 */
52
53 FUNCTION is_unit_have_RTS_visit
54 (
55 p_instance_id IN NUMBER,
56 p_from_dt IN DATE ,
57 p_to_dt IN DATE)
58 RETURN NUMBER;
59
60 /*
61 Function Name : IS_RTS_VISIT
62 Type : public
63 Parameters :
64 p_instance_id IN NUMBER Required
65 p_visit_id IN NUMBER Required
66
67 */
68 FUNCTION IS_RTS_VISIT
69 (
70 p_instance_id IN NUMBER,
71 p_visit_id IN NUMBER)
72 RETURN NUMBER;
73
74 /*
75 Function Name : get_net_counter_reading
76 Type : public
77 Parameters :
78 p_instance_id IN NUMBER Required
79 p_ctr_template_name IN DATE Required
80 p_ctr_uom IN DATE Required
81 */
82 FUNCTION get_net_counter_reading
83 (
84 p_instance_id IN NUMBER,
85 p_ctr_template_name IN VARCHAR2,
86 p_ctr_uom IN VARCHAR2)
87 RETURN NUMBER;
88
89 /*
90 Function Name : get_earliest_assm_due
91 Type : public
92 Parameters :
93 p_instance_id IN NUMBER Required
94
95 */
96 FUNCTION get_earliest_assm_due
97 (
98 p_instance_id IN NUMBER
99 )
100 RETURN DATE;
101
102 --sukhwsin::Complex Assembly Maintenance - changes starts
103
104 /*
105 Function Name : Get_Visit_End_Date
106 Type : public
107 Parameters :
108 p_visit_id IN NUMBER Required
109 Created by sukhwsin
110 */
111 FUNCTION Get_Visit_End_Date
112 (
113 p_visit_id IN NUMBER
114 )
115 RETURN DATE;
116
117 /*
118 FUNCTION Get_Visit_Count : This function return visit count between two dates for particular item and organization.
119 This function is used in Repair Forecast Search UI to reterive Planned and Scheduled Quantity.
120 Type Public
121 Parameters:
122 Parameter Name Type Mandatory
123 p_item_id NUMBER Y
124 p_organization_id NUMBER Y
125 p_start_date DATE Y
126 p_end_date DATE Y
127 p_visit_state VARCHAR2 Y
128
129 Return Type: NUMBER
130
131 Created by sukhwsin
132 */
133 FUNCTION Get_Visit_Count
134 (p_item_id IN NUMBER,
135 p_organization_id IN NUMBER,
136 p_start_date IN DATE,
137 p_end_date IN DATE,
138 p_visit_state IN VARCHAR2)
139 RETURN NUMBER;
140
141 /*
142 FUNCTION Get_Monthly_Visit_Count : This function return monthly visit count for given date, item and organization.
143 This function is used in Repair Forecast Search UI - in inner table to reterive Monthly Visit Quantity.
144 Type Public
145 Parameters:
146 Parameter Name Type Mandatory
147 p_item_id NUMBER Y
148 p_organization_id NUMBER Y
149 p_req_date DATE Y
150
151 Return Type: NUMBER
152
153 Created by sukhwsin
154 */
155 FUNCTION Get_Monthly_Visit_Count
156 (p_item_id IN NUMBER,
157 p_organization_id IN NUMBER,
158 p_req_date IN DATE)
159 RETURN NUMBER;
160
161 /*
162 FUNCTION Is_Instance_On_Visit : This function returns flag (Y/N) based upon whether instance is on Visit Context or not.
163 Instance can be on Visit Context if it is attached to Visit Unit OR Visit Locator OR Visit job.
164 This function is used in Execution - MR Search Page
165 Type Public
166 Parameters:
167 Parameter Name Type Mandatory
168 p_visit_id NUMBER Y
169 p_instance_id NUMBER Y
170
171 Return Type: VARCHAR2 (Y or N )
172
173 Created by sukhwsin
174 */
175 FUNCTION Is_Instance_On_Visit
176 (p_visit_id NUMBER,
177 p_instance_id NUMBER)
178 RETURN VARCHAR2;
179 --sukhwsin::Complex Assembly Maintenance - changes ends
180
181 END AHL_COMPLEX_MX_PVT;
182