[Home] [Help]
PACKAGE: APPS.CSI_T_TXN_LINE_DETAILS_PKG
Source
1 PACKAGE CSI_T_TXN_LINE_DETAILS_PKG as
2 /* $Header: csitttds.pls 120.1 2005/06/17 01:50:53 appldev $ */
3 -- Package name : CSI_T_TXN_LINE_DETAILS_PKG
4 -- Purpose : Table Handler for csi_t_txn_line_details
5 -- History : brmanesh created 12-MAY-2001
6 -- : brmanesh 15-AUG-2003 added the instance_status_id
7 -- : rmamidip 19-NOV-2003 added INSTALL_LOCATION_TYPE_CODE and INSTALL_LOCATION_ID
8 -- : epajaril 17-MAR-2004 added the PARENT_INSTANCE_ID
9 -- NOTE :
10
11 -- Added for CZ Integration (Begin)
12 -- Following attributes are added to various modules.
13 -- p_CONFIG_INST_HDR_ID NUMBER ,
14 -- p_CONFIG_INST_REV_NUM NUMBER ,
15 -- p_CONFIG_INST_ITEM_ID NUMBER ,
16 -- p_CONFIG_INST_BASELINE_REV_NUM NUMBER ,
17 -- p_TARGET_COMMITMENT_DATE DATE ,
18 -- p_INSTANCE_DESCRIPTION VARCHAR2 ,
19 -- Added for CZ Integration (End)
20
21 PROCEDURE Insert_Row(
22 px_TXN_LINE_DETAIL_ID IN OUT NOCOPY NUMBER,
23 p_TRANSACTION_LINE_ID NUMBER,
24 p_SUB_TYPE_ID NUMBER,
25 p_INSTANCE_EXISTS_FLAG VARCHAR2,
26 p_SOURCE_TRANSACTION_FLAG VARCHAR2,
27 p_INSTANCE_ID NUMBER,
28 p_CSI_SYSTEM_ID NUMBER,
29 p_INVENTORY_ITEM_ID NUMBER,
30 p_INV_ORGANIZATION_ID NUMBER,
31 p_INVENTORY_REVISION VARCHAR2,
32 p_INSTANCE_TYPE_CODE VARCHAR2,
33 p_ITEM_CONDITION_ID NUMBER,
34 p_QUANTITY NUMBER,
35 p_UNIT_OF_MEASURE VARCHAR2,
36 p_QTY_REMAINING NUMBER,
37 p_SERIAL_NUMBER VARCHAR2,
38 p_LOT_NUMBER VARCHAR2,
39 p_MFG_SERIAL_NUMBER_FLAG VARCHAR2,
40 p_LOCATION_TYPE_CODE VARCHAR2,
41 p_LOCATION_ID NUMBER,
42 p_INSTALLATION_DATE DATE,
43 p_IN_SERVICE_DATE DATE,
44 p_EXTERNAL_REFERENCE VARCHAR2,
45 p_VERSION_LABEL VARCHAR2,
46 p_TRANSACTION_SYSTEM_ID NUMBER,
47 p_SELLABLE_FLAG VARCHAR2,
48 p_RETURN_BY_DATE DATE,
49 p_ACTIVE_START_DATE DATE,
50 p_ACTIVE_END_DATE DATE,
51 p_PRESERVE_DETAIL_FLAG VARCHAR2,
52 p_CHANGED_INSTANCE_ID NUMBER,
53 p_REFERENCE_SOURCE_ID NUMBER,
54 p_REFERENCE_SOURCE_LINE_ID NUMBER,
55 p_REFERENCE_SOURCE_DATE DATE,
56 p_CSI_TRANSACTION_ID NUMBER,
57 p_SOURCE_TXN_LINE_DETAIL_ID NUMBER,
58 p_INV_MTL_TRANSACTION_ID NUMBER,
59 p_PROCESSING_STATUS VARCHAR2,
60 p_ERROR_CODE VARCHAR2,
61 p_ERROR_EXPLANATION VARCHAR2,
62 p_CONFIG_INST_HDR_ID NUMBER ,
63 p_CONFIG_INST_REV_NUM NUMBER ,
64 p_CONFIG_INST_ITEM_ID NUMBER ,
65 p_CONFIG_INST_BASELINE_REV_NUM NUMBER ,
66 p_TARGET_COMMITMENT_DATE DATE ,
67 p_INSTANCE_DESCRIPTION VARCHAR2 ,
68 p_INSTALL_LOCATION_TYPE_CODE VARCHAR2,
69 p_INSTALL_LOCATION_ID NUMBER,
70 p_CASCADE_OWNER_FLAG VARCHAR2,-- bug 2972082
71 p_ATTRIBUTE1 VARCHAR2,
72 p_ATTRIBUTE2 VARCHAR2,
73 p_ATTRIBUTE3 VARCHAR2,
74 p_ATTRIBUTE4 VARCHAR2,
75 p_ATTRIBUTE5 VARCHAR2,
76 p_ATTRIBUTE6 VARCHAR2,
77 p_ATTRIBUTE7 VARCHAR2,
78 p_ATTRIBUTE8 VARCHAR2,
79 p_ATTRIBUTE9 VARCHAR2,
80 p_ATTRIBUTE10 VARCHAR2,
81 p_ATTRIBUTE11 VARCHAR2,
82 p_ATTRIBUTE12 VARCHAR2,
83 p_ATTRIBUTE13 VARCHAR2,
84 p_ATTRIBUTE14 VARCHAR2,
85 p_ATTRIBUTE15 VARCHAR2,
86 p_CREATED_BY NUMBER,
87 p_CREATION_DATE DATE,
88 p_LAST_UPDATED_BY NUMBER,
89 p_LAST_UPDATE_DATE DATE,
90 p_LAST_UPDATE_LOGIN NUMBER,
91 p_OBJECT_VERSION_NUMBER NUMBER,
92 p_CONTEXT VARCHAR2,
93 p_INSTANCE_STATUS_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
94 p_PARENT_INSTANCE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
95 p_ASSC_TXN_LINE_DETAIL_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
96 p_OVERRIDING_CSI_TXN_ID NUMBER DEFAULT FND_API.G_MISS_NUM);
97
98 PROCEDURE Update_Row(
99 p_TXN_LINE_DETAIL_ID NUMBER,
100 p_TRANSACTION_LINE_ID NUMBER,
101 p_SUB_TYPE_ID NUMBER,
102 p_INSTANCE_EXISTS_FLAG VARCHAR2,
103 p_SOURCE_TRANSACTION_FLAG VARCHAR2,
104 p_INSTANCE_ID NUMBER,
105 p_CSI_SYSTEM_ID NUMBER,
106 p_INVENTORY_ITEM_ID NUMBER,
107 p_INV_ORGANIZATION_ID NUMBER,
108 p_INVENTORY_REVISION VARCHAR2,
109 p_INSTANCE_TYPE_CODE VARCHAR2,
110 p_ITEM_CONDITION_ID NUMBER,
111 p_QUANTITY NUMBER,
112 p_UNIT_OF_MEASURE VARCHAR2,
113 p_QTY_REMAINING NUMBER,
114 p_SERIAL_NUMBER VARCHAR2,
115 p_LOT_NUMBER VARCHAR2,
116 p_MFG_SERIAL_NUMBER_FLAG VARCHAR2,
117 p_LOCATION_TYPE_CODE VARCHAR2,
118 p_LOCATION_ID NUMBER,
119 p_INSTALLATION_DATE DATE,
120 p_IN_SERVICE_DATE DATE,
121 p_EXTERNAL_REFERENCE VARCHAR2,
122 p_VERSION_LABEL VARCHAR2,
123 p_TRANSACTION_SYSTEM_ID NUMBER,
124 p_SELLABLE_FLAG VARCHAR2,
125 p_RETURN_BY_DATE DATE,
126 p_ACTIVE_START_DATE DATE,
127 p_ACTIVE_END_DATE DATE,
128 p_PRESERVE_DETAIL_FLAG VARCHAR2,
129 p_CHANGED_INSTANCE_ID NUMBER,
130 p_REFERENCE_SOURCE_ID NUMBER,
131 p_REFERENCE_SOURCE_LINE_ID NUMBER,
132 p_REFERENCE_SOURCE_DATE DATE,
133 p_CSI_TRANSACTION_ID NUMBER,
134 p_SOURCE_TXN_LINE_DETAIL_ID NUMBER,
135 p_INV_MTL_TRANSACTION_ID NUMBER,
136 p_PROCESSING_STATUS VARCHAR2,
137 p_ERROR_CODE VARCHAR2,
138 p_ERROR_EXPLANATION VARCHAR2,
139 p_CONFIG_INST_HDR_ID NUMBER ,
140 p_CONFIG_INST_REV_NUM NUMBER ,
141 p_CONFIG_INST_ITEM_ID NUMBER ,
142 p_CONFIG_INST_BASELINE_REV_NUM NUMBER ,
143 p_TARGET_COMMITMENT_DATE DATE ,
144 p_INSTANCE_DESCRIPTION VARCHAR2 ,
145 p_INSTALL_LOCATION_TYPE_CODE VARCHAR2,
146 p_INSTALL_LOCATION_ID NUMBER,
147 p_CASCADE_OWNER_FLAG VARCHAR2,-- bug 2972082
148 p_ATTRIBUTE1 VARCHAR2,
149 p_ATTRIBUTE2 VARCHAR2,
150 p_ATTRIBUTE3 VARCHAR2,
151 p_ATTRIBUTE4 VARCHAR2,
152 p_ATTRIBUTE5 VARCHAR2,
153 p_ATTRIBUTE6 VARCHAR2,
154 p_ATTRIBUTE7 VARCHAR2,
155 p_ATTRIBUTE8 VARCHAR2,
156 p_ATTRIBUTE9 VARCHAR2,
157 p_ATTRIBUTE10 VARCHAR2,
158 p_ATTRIBUTE11 VARCHAR2,
159 p_ATTRIBUTE12 VARCHAR2,
160 p_ATTRIBUTE13 VARCHAR2,
161 p_ATTRIBUTE14 VARCHAR2,
162 p_ATTRIBUTE15 VARCHAR2,
163 p_CREATED_BY NUMBER,
164 p_CREATION_DATE DATE,
165 p_LAST_UPDATED_BY NUMBER,
166 p_LAST_UPDATE_DATE DATE,
167 p_LAST_UPDATE_LOGIN NUMBER,
168 p_OBJECT_VERSION_NUMBER NUMBER,
169 p_CONTEXT VARCHAR2,
170 p_INSTANCE_STATUS_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
171 p_PARENT_INSTANCE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
172 p_ASSC_TXN_LINE_DETAIL_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
173 p_OVERRIDING_CSI_TXN_ID NUMBER DEFAULT FND_API.G_MISS_NUM);
174
175 PROCEDURE Lock_Row(
176 p_TXN_LINE_DETAIL_ID NUMBER,
177 p_TRANSACTION_LINE_ID NUMBER,
178 P_SUB_TYPE_ID NUMBER,
179 p_INSTANCE_EXISTS_FLAG VARCHAR2,
180 p_SOURCE_TRANSACTION_FLAG VARCHAR2,
181 p_INSTANCE_ID NUMBER,
182 p_CSI_SYSTEM_ID NUMBER,
183 p_INVENTORY_ITEM_ID NUMBER,
184 p_INV_ORGANIZATION_ID NUMBER,
185 p_INVENTORY_REVISION VARCHAR2,
186 p_INSTANCE_TYPE_CODE VARCHAR2,
187 p_ITEM_CONDITION_ID NUMBER,
188 p_QUANTITY NUMBER,
189 p_UNIT_OF_MEASURE VARCHAR2,
190 p_QTY_REMAINING NUMBER,
191 p_SERIAL_NUMBER VARCHAR2,
192 p_LOT_NUMBER VARCHAR2,
193 p_MFG_SERIAL_NUMBER_FLAG VARCHAR2,
194 p_LOCATION_TYPE_CODE VARCHAR2,
195 p_LOCATION_ID NUMBER,
196 p_INSTALLATION_DATE DATE,
197 p_IN_SERVICE_DATE DATE,
198 p_EXTERNAL_REFERENCE VARCHAR2,
199 p_VERSION_LABEL VARCHAR2,
200 p_TRANSACTION_SYSTEM_ID NUMBER,
201 p_SELLABLE_FLAG VARCHAR2,
202 p_RETURN_BY_DATE DATE,
203 p_ACTIVE_START_DATE DATE,
204 p_ACTIVE_END_DATE DATE,
205 p_PRESERVE_DETAIL_FLAG VARCHAR2,
206 p_CHANGED_INSTANCE_ID NUMBER,
207 p_REFERENCE_SOURCE_ID NUMBER,
208 p_REFERENCE_SOURCE_LINE_ID NUMBER,
209 p_REFERENCE_SOURCE_DATE DATE,
210 p_CSI_TRANSACTION_ID NUMBER,
211 p_SOURCE_TXN_LINE_DETAIL_ID NUMBER,
212 p_INV_MTL_TRANSACTION_ID NUMBER,
213 p_PROCESSING_STATUS VARCHAR2,
214 p_ERROR_CODE VARCHAR2,
215 p_ERROR_EXPLANATION VARCHAR2,
216 p_CONFIG_INST_HDR_ID NUMBER ,
217 p_CONFIG_INST_REV_NUM NUMBER ,
218 p_CONFIG_INST_ITEM_ID NUMBER ,
219 p_CONFIG_INST_BASELINE_REV_NUM NUMBER ,
220 p_TARGET_COMMITMENT_DATE DATE ,
221 p_INSTANCE_DESCRIPTION VARCHAR2 ,
222 p_INSTALL_LOCATION_TYPE_CODE VARCHAR2,
223 p_INSTALL_LOCATION_ID NUMBER,
224 p_CASCADE_OWNER_FLAG VARCHAR2,-- bug 2972082
225 p_ATTRIBUTE1 VARCHAR2,
226 p_ATTRIBUTE2 VARCHAR2,
227 p_ATTRIBUTE3 VARCHAR2,
228 p_ATTRIBUTE4 VARCHAR2,
229 p_ATTRIBUTE5 VARCHAR2,
230 p_ATTRIBUTE6 VARCHAR2,
231 p_ATTRIBUTE7 VARCHAR2,
232 p_ATTRIBUTE8 VARCHAR2,
233 p_ATTRIBUTE9 VARCHAR2,
234 p_ATTRIBUTE10 VARCHAR2,
235 p_ATTRIBUTE11 VARCHAR2,
236 p_ATTRIBUTE12 VARCHAR2,
237 p_ATTRIBUTE13 VARCHAR2,
238 p_ATTRIBUTE14 VARCHAR2,
239 p_ATTRIBUTE15 VARCHAR2,
240 p_CREATED_BY NUMBER,
241 p_CREATION_DATE DATE,
242 p_LAST_UPDATED_BY NUMBER,
243 p_LAST_UPDATE_DATE DATE,
244 p_LAST_UPDATE_LOGIN NUMBER,
245 p_OBJECT_VERSION_NUMBER NUMBER,
246 p_CONTEXT VARCHAR2,
247 p_INSTANCE_STATUS_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
248 p_PARENT_INSTANCE_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
249 p_ASSC_TXN_LINE_DETAIL_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
250 p_OVERRIDING_CSI_TXN_ID NUMBER DEFAULT FND_API.G_MISS_NUM);
251
252 PROCEDURE Delete_Row(
253 p_TXN_LINE_DETAIL_ID NUMBER);
254 End CSI_T_TXN_LINE_DETAILS_PKG;