[Home] [Help]
PACKAGE: APPS.CSD_REPAIR_ACTUALS_PVT
Source
1 PACKAGE CSD_REPAIR_ACTUALS_PVT AUTHID CURRENT_USER as
2 /* $Header: csdvacts.pls 120.2 2008/02/09 01:05:17 takwong ship $ csdvacts.pls */
3
4 -- ---------------------------------------------------------
5 -- Define global variables
6 -- ---------------------------------------------------------
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_REPAIR_ACTUALS_PVT';
8 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdvacts.pls';
9 g_debug NUMBER := csd_gen_utility_pvt.g_debug_level;
10
11 /*--------------------------------------------------------------------*/
12 /* Record name: CSD_REPAIR_ACTUALS_REC_TYPE */
13 /* Description : Record used for Create/Update Repair Actuals */
14 /* */
15 /* */
16 /* Called from : Depot Repair Actuals UI */
20 /* */
17 /* Change Hist : */
18 /* 08/11/03 travikan Initial Creation. */
19 /* */
21 /* */
22 /*--------------------------------------------------------------------*/
23 TYPE CSD_REPAIR_ACTUALS_REC_TYPE IS RECORD
24 (
25 REPAIR_ACTUAL_ID NUMBER
26 , OBJECT_VERSION_NUMBER NUMBER
27 , REPAIR_LINE_ID NUMBER
28 , CREATED_BY NUMBER
29 , CREATION_DATE DATE
30 , LAST_UPDATED_BY NUMBER
31 , LAST_UPDATE_DATE DATE
32 , LAST_UPDATE_LOGIN NUMBER
33 , ATTRIBUTE_CATEGORY VARCHAR2(30)
34 , ATTRIBUTE1 VARCHAR2(150)
35 , ATTRIBUTE2 VARCHAR2(150)
36 , ATTRIBUTE3 VARCHAR2(150)
37 , ATTRIBUTE4 VARCHAR2(150)
38 , ATTRIBUTE5 VARCHAR2(150)
39 , ATTRIBUTE6 VARCHAR2(150)
40 , ATTRIBUTE7 VARCHAR2(150)
41 , ATTRIBUTE8 VARCHAR2(150)
42 , ATTRIBUTE9 VARCHAR2(150)
43 , ATTRIBUTE10 VARCHAR2(150)
44 , ATTRIBUTE11 VARCHAR2(150)
45 , ATTRIBUTE12 VARCHAR2(150)
46 , ATTRIBUTE13 VARCHAR2(150)
47 , ATTRIBUTE14 VARCHAR2(150)
48 , ATTRIBUTE15 VARCHAR2(150)
49 , BILL_TO_ACCOUNT_ID NUMBER
50 , BILL_TO_PARTY_ID NUMBER
51 , BILL_TO_PARTY_SITE_ID NUMBER
52 );
53
54 /*--------------------------------------------------------------------*/
55 /* Type to Return the Record Type for Creating / Updating the */
56 /* */
57 /* */
58 /* Called from : Depot Repair */
59 /*--------------------------------------------------------------------*/
60 TYPE CSD_REPAIR_ACTUALS_TBL_TYP IS TABLE OF CSD_REPAIR_ACTUALS_REC_TYPE
61 INDEX BY BINARY_INTEGER;
62
63
64 /*--------------------------------------------------------------------*/
65 /* procedure name: CREATE_REPAIR_ACTUALS */
66 /* description : procedure used to Create Repair Actuals */
67 /* */
68 /* */
69 /* */
70 /* Called from : Depot Repair Actuals UI */
71 /* Input Parm : */
72 /* p_api_version NUMBER Req Api Version number */
73 /* p_init_msg_list VARCHAR2 Opt Initialize message stack */
74 /* p_commit VARCHAR2 Opt Commits in API */
75 /* p_validation_level NUMBER Opt validation steps */
76 /* px_CSD_REPAIR_ACTUALS_REC REC Req Actuals Record */
77 /* Output Parm : */
78 /* x_return_status VARCHAR2 Return status after the call. */
79 /* x_msg_count NUMBER Number of messages in stack */
80 /* x_msg_data VARCHAR2 Mesg. text if x_msg_count >= 1 */
81 /* Change Hist : */
82 /* 08/11/03 travikan Initial Creation. */
83 /* */
84 /* */
85 /* */
86 /*--------------------------------------------------------------------*/
87 PROCEDURE CREATE_REPAIR_ACTUALS(
88 P_Api_Version IN NUMBER,
89 P_Commit IN VARCHAR2,
90 P_Init_Msg_List IN VARCHAR2,
91 p_validation_level IN NUMBER,
92 px_CSD_REPAIR_ACTUALS_REC IN OUT NOCOPY CSD_REPAIR_ACTUALS_REC_TYPE,
93 X_Return_Status OUT NOCOPY VARCHAR2,
94 X_Msg_Count OUT NOCOPY NUMBER,
95 X_Msg_Data OUT NOCOPY VARCHAR2
96 );
97
98
99
100 /*--------------------------------------------------------------------*/
101 /* procedure name: UPDATE_REPAIR_ACTUALS */
102 /* description : procedure used to Update Repair Actuals */
103 /* */
104 /* */
105 /* */
106 /* Called from : Depot Repair Actuals UI */
107 /* Input Parm : */
108 /* p_api_version NUMBER Req Api Version number */
109 /* p_init_msg_list VARCHAR2 Opt Initialize message stack */
110 /* p_commit VARCHAR2 Opt Commits in API */
111 /* p_validation_level NUMBER Opt validation steps */
112 /* px_CSD_REPAIR_ACTUALS_REC REC Req Actuals Record */
113 /* Output Parm : */
114 /* x_return_status VARCHAR2 Return status after the call. */
115 /* x_msg_count NUMBER Number of messages in stack */
116 /* x_msg_data VARCHAR2 Mesg. text if x_msg_count >= 1 */
117 /* Change Hist : */
118 /* 08/11/03 travikan Initial Creation. */
119 /* */
120 /* */
121 /* */
122 /*--------------------------------------------------------------------*/
123 PROCEDURE UPDATE_REPAIR_ACTUALS(
124 P_Api_Version IN NUMBER,
125 P_Commit IN VARCHAR2,
126 P_Init_Msg_List IN VARCHAR2,
127 p_validation_level IN NUMBER,
128 px_CSD_REPAIR_ACTUALS_REC IN OUT NOCOPY CSD_REPAIR_ACTUALS_REC_TYPE,
129 X_Return_Status OUT NOCOPY VARCHAR2,
130 X_Msg_Count OUT NOCOPY NUMBER,
131 X_Msg_Data OUT NOCOPY VARCHAR2
132 );
133
134
135
136 /*--------------------------------------------------------------------*/
137 /* procedure name: DELETE_REPAIR_ACTUALS */
138 /* description : procedure used to Delete Repair Actuals */
139 /* */
140 /* */
141 /* */
142 /* Called from : Depot Repair Actuals UI */
143 /* Input Parm : */
144 /* p_api_version NUMBER Req Api Version number */
145 /* p_init_msg_list VARCHAR2 Opt Initialize message stack */
146 /* p_commit VARCHAR2 Opt Commits in API */
147 /* p_validation_level NUMBER Opt validation steps */
148 /* px_CSD_REPAIR_ACTUALS_REC REC Req Actuals Record */
149 /* Output Parm : */
150 /* x_return_status VARCHAR2 Return status after the call. */
151 /* x_msg_count NUMBER Number of messages in stack */
152 /* x_msg_data VARCHAR2 Mesg. text if x_msg_count >= 1 */
153 /* Change Hist : */
154 /* 08/11/03 travikan Initial Creation. */
155 /* */
156 /* */
157 /* */
158 /*--------------------------------------------------------------------*/
159 PROCEDURE DELETE_REPAIR_ACTUALS(
160 P_Api_Version IN NUMBER,
161 P_Commit IN VARCHAR2,
162 P_Init_Msg_List IN VARCHAR2,
163 p_validation_level IN NUMBER,
164 px_CSD_REPAIR_ACTUALS_REC IN OUT NOCOPY CSD_REPAIR_ACTUALS_REC_TYPE,
165 X_Return_Status OUT NOCOPY VARCHAR2,
166 X_Msg_Count OUT NOCOPY NUMBER,
167 X_Msg_Data OUT NOCOPY VARCHAR2
168 );
169
170
171
172 /*--------------------------------------------------------------------*/
173 /* procedure name: LOCK_REPAIR_ACTUALS */
174 /* description : procedure used to Lock Repair Actuals */
175 /* */
176 /* */
177 /* */
178 /* Called from : Depot Repair Actuals UI */
179 /* Input Parm : */
180 /* p_api_version NUMBER Req Api Version number */
181 /* p_init_msg_list VARCHAR2 Opt Initialize message stack */
182 /* p_commit VARCHAR2 Opt Commits in API */
183 /* p_validation_level NUMBER Opt validation steps */
184 /* px_CSD_REPAIR_ACTUALS_REC REC Req Actuals Record */
185 /* Output Parm : */
186 /* x_return_status VARCHAR2 Return status after the call. */
187 /* x_msg_count NUMBER Number of messages in stack */
188 /* x_msg_data VARCHAR2 Mesg. text if x_msg_count >= 1 */
189 /* Change Hist : */
190 /* 08/11/03 travikan Initial Creation. */
191 /* */
192 /* */
193 /* */
194 /*--------------------------------------------------------------------*/
195 PROCEDURE LOCK_REPAIR_ACTUALS(
196 P_Api_Version IN NUMBER,
197 P_Commit IN VARCHAR2,
198 P_Init_Msg_List IN VARCHAR2,
199 p_validation_level IN NUMBER,
200 px_CSD_REPAIR_ACTUALS_REC IN OUT NOCOPY CSD_REPAIR_ACTUALS_REC_TYPE,
201 X_Return_Status OUT NOCOPY VARCHAR2,
202 X_Msg_Count OUT NOCOPY NUMBER,
203 X_Msg_Data OUT NOCOPY VARCHAR2
204 );
205
206
207 End CSD_REPAIR_ACTUALS_PVT;