[Home] [Help]
PACKAGE: APPS.AHL_COMPLEX_MX_RWSC_PVT
Source
1 PACKAGE AHL_COMPLEX_MX_RWSC_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVRWSS.pls 120.0.12020000.2 2012/12/07 14:30:08 sareepar noship $ */
3
4 /* These Image file names should be in sync with ahl/uc/et/AhlucTreeNodeData.java */
5 G_EXTRA_NODE_IMAGE CONSTANT VARCHAR2(30) := 'notapplicableind_status.gif';
6 G_MISSING_NODE_IMAGE CONSTANT VARCHAR2(30) := 'itemtobeadded_status.gif';
7 G_FILLED_NODE_IMAGE CONSTANT VARCHAR2(30) := 'okind_status.gif';
8 G_SB_RULE_VIOLATED_NODE_IMAGE CONSTANT VARCHAR2(30) := 'criticalind_status.gif';
9
10
11 -- Record Structure corresponding to GLOBAL TEMPORARY TABLE AHL_VISIT_IR_UC_DETAILS
12 -- used for storing hGrid detials on Update visit : repair workscope tab
13 TYPE visit_ir_uc_details_rec_type IS RECORD
14 (
15 VISIT_IR_UC_ID NUMBER,
16 ROOT_INSTANCE_ID NUMBER,
17 UNIT_HEADER_ID NUMBER,
18 UNIT_NAME VARCHAR2 (80),
19 PATH_POSITION_ID NUMBER,
20 RELATIONSHIP_ID NUMBER,
21 PARENT_REL_ID NUMBER,
22 CURR_ITEM_ID NUMBER,
23 CURR_INSTANCE_ID NUMBER,
24 PARENT_INSTANCE_ID NUMBER,
25 CURR_ITEM_NUMBER VARCHAR2 (240),
26 CURR_INSTANCE_NUMBER NUMBER,
27 CURR_SERIAL_NUMBER VARCHAR2 (30),
28 POSITION VARCHAR2 (240),
29 POSITION_IMAGE VARCHAR2 (30),
30 ITEM_GROUP_ID NUMBER,
31 ITEM_GROUP_NAME VARCHAR2(80),
32 RESERVED_SERIAL_NUM VARCHAR2(30),
33 AVAILABLE_PARTS VARCHAR2 (1),
34 UNIT_NHA VARCHAR2(80),
35 IS_UNIT VARCHAR2 (1),
36 IS_WARRANTY_AVAILABLE VARCHAR2 (1),
37 MR_COUNT NUMBER,
38 TASK_COUNT NUMBER,
39 IS_VISIT_AVAILABLE VARCHAR2 (1),
40 MC_HEADER_ID NUMBER,
41 IS_SB_RULE_AVAILABLE VARCHAR2 (1),
42 ROUTE_DISPOSITIONS_FLAG VARCHAR2 (1),
43 RD_REWORK_PERCENT NUMBER,
44 RD_REPLACE_PERCENT NUMBER,
45 POSITION_MATERIAL_FLAG VARCHAR2 (1),
46 BG_POSITION NUMBER,
47 BG_INSTANCE NUMBER,
48 INST_ROUTING_ID NUMBER,
49 INST_ROUTING_OVN NUMBER,
50 VISIT_ID NUMBER,
51 INST_ROUTING_CODE VARCHAR2 (30),
52 INST_ROUTING_MEANING VARCHAR2 (80),
53 INST_ROUTING_FLAG VARCHAR2 (1),
54 QTY_PER_POSITION NUMBER,
55 INSTALLED_QTY NUMBER,
56 LEAF_NODE_FLAG VARCHAR2 (1),
57 NODE_LEVEL NUMBER,
58 HGRID_NODE_PATH VARCHAR2 (80)
59 );
60
61 TYPE visit_ir_uc_details_tbl_type IS TABLE OF visit_ir_uc_details_rec_type INDEX BY BINARY_INTEGER;
62
63 ------------------------------------------------------------------------------------------------------
64 -- Start of Comments
65 -- Procedure name : Get_visit_ir_uc_details
66 -- Type : Public
67 -- Function : This procedure will update the temparory table to show data in hGrid.
68 -- Since this table is global temporary with ON COMMIT DELETE ROWS,
69 -- Always call this method with p_commit value : FND_API.G_FALSE
70 -- Pre-reqs :
71 -- Parameters :
72 --
73 -- Get_visit_ir_uc_details Parameters
74 -- p_unit_header_id IN NUMBER
75 -- p_item_instance_id IN NUMBER
76 -- p_visit_id IN NUMBER
77 --
78 -- End of Comments
79 -------------------------------------------------------------------------------------------------------
80 PROCEDURE Get_visit_ir_uc_details
81 (
82 p_api_version IN NUMBER := 1.0,
83 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
84 p_commit IN VARCHAR2 := FND_API.G_FALSE,
85 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
86 p_default IN VARCHAR2 := FND_API.G_FALSE,
87 p_module_type IN VARCHAR2 := NULL,
88 p_unit_header_id IN NUMBER,
89 p_item_instance_id IN NUMBER,
90 p_visit_id IN NUMBER,
91 x_visit_ir_uc_details_tbl OUT NOCOPY visit_ir_uc_details_tbl_type,
92 x_return_status OUT NOCOPY VARCHAR2,
93 x_msg_count OUT NOCOPY NUMBER,
94 x_msg_data OUT NOCOPY VARCHAR2
95 );
96
97 -- Record Structure corresponding to TABLE AHL_VISIT_INST_ROUTINGS
98 TYPE instance_routings_rec_type IS RECORD
99 (
100 INST_ROUTING_ID NUMBER,
101 OBJECT_VERSION_NUMBER NUMBER,
102 VISIT_ID NUMBER,
103 INSTANCE_ID NUMBER,
104 INST_ROUTING_CODE VARCHAR2 (30),
105 OLD_INST_ROUTING_CODE VARCHAR2 (30)
106 );
107
108 TYPE instance_routings_tbl_type IS TABLE OF instance_routings_rec_type INDEX BY BINARY_INTEGER;
109
110
111 ------------------------------------------------------------------------------------------------------
112 -- Start of Comments
113 -- Procedure name : Process_instance_routings
114 -- Type : Public
115 -- Function : This procedure will update the table AHL_VISIT_INST_ROUTINGS
116 -- OLD_INST_ROUTING_CODE params is old INST_ROUTING_CODE, used for update/delete case
117 -- Pre-reqs :
118 -- Parameters :
119 --
120 -- Get_visit_ir_uc_details Parameters
121 -- p_x_instance_routings_tbl IN OUT NOCOPY instance_routings_tbl_type
122 --
123 -- End of Comments
124 -------------------------------------------------------------------------------------------------------
125 PROCEDURE Process_instance_routings
126 (
127 p_api_version IN NUMBER := 1.0,
128 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
129 p_commit IN VARCHAR2 := FND_API.G_FALSE,
130 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
131 p_default IN VARCHAR2 := FND_API.G_FALSE,
132 p_module_type IN VARCHAR2 := NULL,
133 p_x_instance_routings_tbl IN OUT NOCOPY instance_routings_tbl_type,
134 x_return_status OUT NOCOPY VARCHAR2,
135 x_msg_count OUT NOCOPY NUMBER,
136 x_msg_data OUT NOCOPY VARCHAR2
137 );
138
139
140 ------------------------------------------------------------------------------------------------------
141 -- Start of Comments
142 -- Procedure name : Get_Instance_Location
143 -- Type : Public
144 -- Function : Returns details of instance in Visit;workorder; inventory;locator;OSP format
145 -- Pre-reqs :
146 -- Parameters :
147 --
148 -- Get_visit_ir_uc_details Parameters
149 -- p_visit_id IN NUMBER
150 -- p_instance_id IN NUMBER
151 --
152 -- End of Comments
153 -------------------------------------------------------------------------------------------------------
154 FUNCTION Get_Instance_Location
155 ( p_visit_id IN NUMBER,
156 p_instance_id IN NUMBER
157 )RETURN VARCHAR2;
158
159 ------------------------------------------------------------------------------------------------------
160 -- Start of Comments
161 -- Procedure name : Get_disposition_count
162 -- Type : Public
163 -- Function : Returns disposition count of work orders associated with given visit n instacne
164 -- Returns null if count is zero.
165 -- Pre-reqs :
166 -- Parameters :
167 --
168 -- Get_visit_ir_uc_details Parameters
169 -- p_x_instance_routings_tbl IN OUT NOCOPY instance_routings_tbl_type
170 --
171 -- End of Comments
172 -------------------------------------------------------------------------------------------------------
173 FUNCTION Get_disposition_count(
174 p_visit_id IN NUMBER,
175 p_instance_id IN NUMBER
176 )RETURN NUMBER;
177
178 END AHL_COMPLEX_MX_RWSC_PVT;
179