[Home] [Help]
PACKAGE: APPS.AHL_VWP_VISIT_CST_PR_PVT
Source
1 PACKAGE AHL_VWP_VISIT_CST_PR_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVVCPS.pls 115.1 2003/10/23 00:03:58 yazhou noship $ */
3 ---------------------------------------------------------------------
4 -- Define Record Types for record structures needed by the APIs --
5 ---------------------------------------------------------------------
6 TYPE cost_price_rec_type IS RECORD (
7 Visit_task_id NUMBER,
8 Visit_id NUMBER,
9 Mr_id NUMBER,
10 Actual_cost NUMBER,
11 Estimated_cost NUMBER,
12 Actual_price NUMBER,
13 Estimated_price NUMBER,
14 Currency VARCHAR2(80),
15 Snapshot_Id NUMBER,
16 Object_version_number NUMBER,
17 Estimated_Profit NUMBER,
18 Actual_Profit NUMBER,
19 Outside_party_flag VARCHAR2(1),
20 Is_outside_pty_flag_updt VARCHAR2(1),
21 Is_Cst_Pr_Info_Required VARCHAR2(1),
22 Is_Cst_Struc_updated VARCHAR2(1),
23 Price_list_Id NUMBER,
24 Price_List_Name VARCHAR2(80),
25 Service_Request_Id NUMBER,
26 Customer_Id NUMBER,
27 Organization_Id NUMBER,
28 Visit_Start_Date DATE,
29 Visit_End_Date DATE,
30 MR_Start_Date DATE,
31 MR_End_Date DATE,
32 Task_Start_Date DATE,
33 Task_End_Date DATE,
34 Task_Name VARCHAR2(80),
35 Visit_Task_Number NUMBER,
36 MR_Title VARCHAR2(80),
37 MR_Description VARCHAR2(2000),
38 Billing_Item_Id NUMBER,
39 Item_Name VARCHAR2(400),
40 Item_Description VARCHAR2(240),
41 Organization_name VARCHAR2(240),
42 Workorder_Id NUMBER,
43 Master_WO_Flag VARCHAR2(1),
44 MR_Session_Id NUMBER,
45 Cost_Session_Id NUMBER,
46 CREATED_BY NUMBER,
47 CREATION_DATE DATE,
48 LAST_UPDATED_BY NUMBER,
49 LAST_UPDATE_DATE DATE,
50 LAST_UPDATE_LOGIN NUMBER,
51 ATTRIBUTE_CATEGORY VARCHAR2(30),
52 ATTRIBUTE1 VARCHAR2(150),
53 ATTRIBUTE2 VARCHAR2(150),
54 ATTRIBUTE3 VARCHAR2(150),
55 ATTRIBUTE4 VARCHAR2(150),
56 ATTRIBUTE5 VARCHAR2(150),
57 ATTRIBUTE6 VARCHAR2(150),
58 ATTRIBUTE7 VARCHAR2(150),
59 ATTRIBUTE8 VARCHAR2(150),
60 ATTRIBUTE9 VARCHAR2(150),
61 ATTRIBUTE10 VARCHAR2(150),
62 ATTRIBUTE11 VARCHAR2(150),
63 ATTRIBUTE12 VARCHAR2(150),
64 ATTRIBUTE13 VARCHAR2(150),
65 ATTRIBUTE14 VARCHAR2(150),
66 ATTRIBUTE15 VARCHAR2(150)
67 );
68
69
70 ----------------------------------------------
71 -- Define Table Type for records structures --
72 ----------------------------------------------
73 TYPE cost_price_tbl_type IS TABLE OF cost_price_rec_type INDEX BY BINARY_INTEGER;
74
75 --------------------------------------------------------------------------
76 -- Procedure to get visit cost details for a specific visit --
77 --------------------------------------------------------------------------
78 PROCEDURE get_visit_cost_details(
79 p_api_version IN NUMBER := 1.0,
80 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
81 p_commit IN VARCHAR2 := FND_API.G_FALSE,
82 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
83 p_module_type IN VARCHAR2 := 'JSP',
84 p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_msg_data OUT NOCOPY VARCHAR2);
88
89 --------------------------------------------------------------------------
90 -- Procedure to estimate visit cost for a specific visit --
91 --------------------------------------------------------------------------
92 PROCEDURE estimate_visit_cost(
93 p_api_version IN NUMBER := 1.0,
94 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
95 p_commit IN VARCHAR2 := FND_API.G_FALSE,
96 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
97 p_module_type IN VARCHAR2 := 'JSP',
98 p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2);
102
103 --------------------------------------------------------------------------
104 -- Procedure to estimate visit price for a specific visit --
105 --------------------------------------------------------------------------
106 PROCEDURE estimate_visit_price(
107 p_api_version IN NUMBER := 1.0,
108 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
109 p_commit IN VARCHAR2 := FND_API.G_FALSE,
110 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
111 p_module_type IN VARCHAR2 := 'JSP',
112 p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
113 x_return_status OUT NOCOPY VARCHAR2,
114 x_msg_count OUT NOCOPY NUMBER,
115 x_msg_data OUT NOCOPY VARCHAR2);
116
117 --------------------------------------------------------------------------
118 -- Procedure to take a price snapshot for a specific visit --
119 --------------------------------------------------------------------------
120 PROCEDURE create_price_snapshot(
121 p_api_version IN NUMBER := 1.0,
122 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123 p_commit IN VARCHAR2 := FND_API.G_FALSE,
124 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125 p_module_type IN VARCHAR2 := 'JSP',
126 p_visit_id IN NUMBER,
127 x_return_status OUT NOCOPY VARCHAR2,
128 x_msg_count OUT NOCOPY NUMBER,
129 x_msg_data OUT NOCOPY VARCHAR2);
130
131 --------------------------------------------------------------------------
132 -- Procedure to take a cost snapshot for a specific visit --
133 --------------------------------------------------------------------------
134 PROCEDURE create_cost_snapshot(
135 p_api_version IN NUMBER := 1.0,
136 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
137 p_commit IN VARCHAR2 := FND_API.G_FALSE,
138 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139 p_module_type IN VARCHAR2 := 'JSP',
140 p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
141 x_return_status OUT NOCOPY VARCHAR2,
142 x_msg_count OUT NOCOPY NUMBER,
143 x_msg_data OUT NOCOPY VARCHAR2);
144
145 --------------------------------------------------------------------------
146 -- Procedure to get visit cost details for a specific visit --
147 --------------------------------------------------------------------------
148 PROCEDURE update_visit_cost_details(
149 p_api_version IN NUMBER := 1.0,
150 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
151 p_commit IN VARCHAR2 := FND_API.G_FALSE,
152 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
153 p_module_type IN VARCHAR2 := 'JSP',
154 p_x_cost_price_rec IN OUT NOCOPY AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
155 x_return_status OUT NOCOPY VARCHAR2,
156 x_msg_count OUT NOCOPY NUMBER,
157 x_msg_data OUT NOCOPY VARCHAR2);
158
159 PROCEDURE Get_Visit_Items_no_price
160 (
161 p_api_version IN NUMBER := 1.0,
162 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
163 p_commit IN VARCHAR2 := FND_API.G_FALSE,
164 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
165 p_module_type IN VARCHAR2 :=NULL,
166 x_return_status OUT NOCOPY VARCHAR2,
167 x_msg_count OUT NOCOPY NUMBER,
168 x_msg_data OUT NOCOPY VARCHAR2,
169 p_cost_price_rec IN AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type,
170 x_cost_price_tbl OUT NOCOPY Cost_Price_Tbl_Type
171 );
172 --------------------------------------------------------------------------------
173 ------- Check various conditions and release visit if needed
174 ---------------------------------------------------------------------------------
175 PROCEDURE check_for_release_visit
176 (
177 p_visit_id IN NUMBER,
178 x_release_visit_required OUT NOCOPY VARCHAR2
179 );
180
181 END AHL_VWP_VISIT_CST_PR_PVT;