[Home] [Help]
PACKAGE: APPS.AHL_PRD_VISITS_PVT
Source
1 PACKAGE AHL_PRD_VISITS_PVT AS
2 /* $Header: AHLVPSVS.pls 120.0 2005/05/26 10:59:10 appldev noship $*/
3 -----------------------------------------------------------
4 -- PACKAGE
5 -- Ahl_PRD_Visits_Pvt
6 --
7 -- PURPOSE
8 -- This package specification is a Private API for managing
9 -- Execution --> Production --> VISITS
10 -- related procedures in Complex Maintenance, Repair and Overhauling(CMRO).
11 --
12 -- It defines used pl/sql records and tables datatypes
13 --
14 -- NOTES
15 --
16 --
17 -- HISTORY
18 -- 29-APR-2004 RROY 11.5.10 Created.
19 -----------------------------------------------------------
20
21 ---------------------------------------------------------------------
22 -- Define Record Types for record structures needed by the APIs --
23 ---------------------------------------------------------------------
24
25 -- Record type for visits
26 TYPE Visit_Rec_Type IS RECORD (
27 VISIT_ID NUMBER := NULL,
28 VISIT_NAME VARCHAR2(80) := NULL,
29 VISIT_NUMBER NUMBER := NULL,
30
31 OBJECT_VERSION_NUMBER NUMBER := NULL,
32 LAST_UPDATE_DATE DATE := NULL,
33 LAST_UPDATED_BY NUMBER := NULL,
34 CREATION_DATE DATE := NULL,
35 CREATED_BY NUMBER := NULL,
36 LAST_UPDATE_LOGIN NUMBER := NULL,
37
38 ORGANIZATION_ID NUMBER := NULL,
39 ORG_NAME VARCHAR2(240) := NULL,
40
41 DEPARTMENT_ID NUMBER := NULL,
42 DEPT_NAME VARCHAR2(240) := NULL,
43
44 SERVICE_REQUEST_ID NUMBER := NULL,
45 SERVICE_REQUEST_NUMBER VARCHAR2(80) := NULL,
46
47 SPACE_CATEGORY_CODE VARCHAR2(30) := NULL,
48 SPACE_CATEGORY_NAME VARCHAR2(80) := NULL,
49
50 START_DATE DATE := NULL,
51 START_HOUR NUMBER := NULL,
52
53 PLAN_END_DATE DATE := NULL,
54 PLAN_END_HOUR NUMBER := NULL,
55
56 END_DATE DATE := NULL,
57 DUE_BY_DATE DATE := NULL,
58
59 VISIT_TYPE_CODE VARCHAR2(30) := NULL,
60 VISIT_TYPE_NAME VARCHAR2(80) := NULL,
61
62 STATUS_CODE VARCHAR2(30) := NULL,
63 STATUS_NAME VARCHAR2(80) := NULL,
64
65 SIMULATION_PLAN_ID NUMBER := NULL,
66 SIMULATION_PLAN_NAME VARCHAR2(80) := NULL,
67
68 ASSO_PRIMARY_VISIT_ID NUMBER := NULL,
69
70 UNIT_NAME VARCHAR2(80) := NULL,
71 ITEM_INSTANCE_ID NUMBER := NULL,
72 SERIAL_NUMBER VARCHAR2(30) := NULL,
73
74 INVENTORY_ITEM_ID NUMBER := NULL,
75 ITEM_ORGANIZATION_ID NUMBER := NULL,
76 ITEM_NAME VARCHAR2(40) := NULL,
77
78 SIMULATION_DELETE_FLAG VARCHAR2(1) := NULL,
79 TEMPLATE_FLAG VARCHAR2(1) := NULL,
80 OUT_OF_SYNC_FLAG VARCHAR2(1) := NULL,
81
82 PROJECT_FLAG VARCHAR2(30) := NULL,
83 PROJECT_FLAG_CODE VARCHAR2(30) := NULL,
84
85 PROJECT_ID NUMBER := NULL,
86 PROJECT_NUMBER NUMBER := NULL,
87
88 DESCRIPTION VARCHAR2(4000) := NULL,
89 DURATION NUMBER := NULL,
90
91 ATTRIBUTE_CATEGORY VARCHAR2(30) := NULL,
92 ATTRIBUTE1 VARCHAR2(150) := NULL,
93 ATTRIBUTE2 VARCHAR2(150) := NULL,
94 ATTRIBUTE3 VARCHAR2(150) := NULL,
95 ATTRIBUTE4 VARCHAR2(150) := NULL,
96 ATTRIBUTE5 VARCHAR2(150) := NULL,
97 ATTRIBUTE6 VARCHAR2(150) := NULL,
98 ATTRIBUTE7 VARCHAR2(150) := NULL,
99 ATTRIBUTE8 VARCHAR2(150) := NULL,
100 ATTRIBUTE9 VARCHAR2(150) := NULL,
101 ATTRIBUTE10 VARCHAR2(150) := NULL,
102 ATTRIBUTE11 VARCHAR2(150) := NULL,
103 ATTRIBUTE12 VARCHAR2(150) := NULL,
104 ATTRIBUTE13 VARCHAR2(150) := NULL,
105 ATTRIBUTE14 VARCHAR2(150) := NULL,
106 ATTRIBUTE15 VARCHAR2(150) := NULL,
107 OPERATION_FLAG VARCHAR2(1) := NULL,
108 OUTSIDE_PARTY_FLAG VARCHAR2(1) := NULL,
109 JOB_NUMBER VARCHAR2(255) := NULL,
110
111 -- Post 11.5.10 Enhancements
112 -- Added Priority and Project Template
113 PROJ_TEMPLATE_NAME VARCHAR2(30) := NULL,
114 PROJ_TEMPLATE_ID NUMBER := NULL,
115 PRIORITY_VALUE VARCHAR2(80) := NULL,
116 PRIORITY_CODE VARCHAR2(30) := NULL
117 );
118
119
120 ---------------------------------------------
121 -- Define Table Type for Records Structures --
122 ----------------------------------------------
123
124 -- Declare Visit table type for record
125 TYPE Visit_Tbl_Type IS TABLE OF Visit_Rec_Type
126 INDEX BY BINARY_INTEGER;
127
128
129 -------------------------------------------------------------------
130 -- Declare Procedures --
131 -------------------------------------------------------------------
132
133 -- To find unit configuration name for a given item instance.
134 FUNCTION get_unitName (p_csi_item_instance_id IN NUMBER)
135 RETURN VARCHAR2;
136
137
138 ---------------------------------------------------------------------
139 -- Procedure name : Get_Visit_Details
140 -- Type : Private
141 -- Function : To get a visit details
142 -- Parameters :
143 --
144 -- Standard IN Parameters :
145 -- p_api_version IN NUMBER Required
146 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
147 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
148 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
149 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
150 -- p_module_type IN VARCHAR2 Default NULL.
151 --
152 -- Standard OUT Parameters :
153 -- x_return_status OUT VARCHAR2 Required
154 -- x_msg_count OUT NUMBER Required
155 -- x_msg_data OUT VARCHAR2 Required
156 --
157 -- Get_Visit_Details Parameters:
158 -- p_visit_id IN NUMBER Required
159 -- The visit id whose details are to be displayed
160 -- x_Visit_rec OUT AHL_VWP_VISITS_PVT.Visit_Rec_Type Required
161 -- The record of visit attributes whose details are to be displayed
162 --
163 -- Version :
164 -- Initial Version 1.0
165 -------------------------------------------------------------------
166 PROCEDURE Get_Visit_Details (
167 p_api_version IN NUMBER,
168 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
169 p_commit IN VARCHAR2 := Fnd_Api.g_false,
170 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
171 p_module_type IN VARCHAR2 := 'JSP',
172 p_visit_id IN NUMBER,
173
174 x_Visit_rec OUT NOCOPY Visit_Rec_Type,
175 x_return_status OUT NOCOPY VARCHAR2,
176 x_msg_count OUT NOCOPY NUMBER,
177 x_msg_data OUT NOCOPY VARCHAR2
178 );
179
180 END AHL_PRD_VISITS_PVT;