[Home] [Help]
PACKAGE: APPS.CSI_INV_TRXS_PKG
Source
1 package CSI_INV_TRXS_PKG AUTHID CURRENT_USER as
2 -- $Header: csiivtxs.pls 120.5.12020000.2 2012/07/04 11:34:03 sjawaji ship $
3
4 x_csi_install VARCHAR2(1) := NULL;
5 G_IN_PROCESS CONSTANT VARCHAR2(30) := 'IN_PROCESS';
6 G_IN_INVENTORY CONSTANT VARCHAR2(30) := 'IN_INVENTORY';
7 G_IN_SERVICE CONSTANT VARCHAR2(30) := 'IN_SERVICE';
8 G_OUT_OF_SERVICE CONSTANT VARCHAR2(30) := 'OUT_OF_SERVICE';
9 G_IN_TRANSIT CONSTANT VARCHAR2(30) := 'IN_TRANSIT';
10 G_INSTALLED CONSTANT VARCHAR2(30) := 'INSTALLED';
11 G_COMPLETE CONSTANT VARCHAR2(30) := 'COMPLETE';
12 G_PENDING CONSTANT VARCHAR2(30) := 'PENDING';
13 G_IB_UPDATE CONSTANT VARCHAR2(30) := 'IB_UPDATE';
14 G_TXN_ERROR CONSTANT VARCHAR2(1) := 'E';
15 G_IN_WIP CONSTANT VARCHAR2(30) := 'IN_WIP';
16
17 TYPE MTL_ITEM_REC_TYPE IS RECORD
18 ( INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
19 ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
20 SUBINVENTORY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
21 REVISION VARCHAR2(3) := FND_API.G_MISS_CHAR,
22 TRANSACTION_QUANTITY NUMBER := FND_API.G_MISS_NUM,
23 PRIMARY_QUANTITY NUMBER := FND_API.G_MISS_NUM,
24 TRANSACTION_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
25 PRIMARY_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
26 TRANSACTION_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
27 TRANSACTION_ACTION_ID NUMBER := FND_API.G_MISS_NUM,
28 TRANSACTION_SOURCE_ID NUMBER := FND_API.G_MISS_NUM,
29 TRANSACTION_SOURCE_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
30 TRANSFER_LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
31 TRANSFER_ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
32 TRANSFER_SUBINVENTORY VARCHAR2(10) := FND_API.G_MISS_CHAR,
33 LOCATOR_ID NUMBER := FND_API.G_MISS_NUM,
34 SOURCE_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
35 SOURCE_TASK_ID NUMBER := FND_API.G_MISS_NUM,
36 FROM_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
37 FROM_TASK_ID NUMBER := FND_API.G_MISS_NUM,
38 TO_PROJECT_ID NUMBER := FND_API.G_MISS_NUM,
39 TO_TASK_ID NUMBER := FND_API.G_MISS_NUM,
40 TRANSACTION_DATE DATE := FND_API.G_MISS_DATE,
41 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
42 SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
43 LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR, --bnarayan
44 HR_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
45 PO_DISTRIBUTION_ID NUMBER := FND_API.G_MISS_NUM,
46 SUBINV_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
47 SHIPMENT_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
48 TRX_SOURCE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49 MOVE_ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
50 SERIAL_NUMBER_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
51 SHIP_TO_LOCATION_ID NUMBER := FND_API.G_MISS_NUM,
52 LOT_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
53 REVISION_QTY_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
54 COMMS_NL_TRACKABLE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
55 LOCATION_CONTROL_CODE NUMBER := FND_API.G_MISS_NUM,
56 PHYSICAL_ADJUSTMENT_ID NUMBER := FND_API.G_MISS_NUM,
57 CYCLE_COUNT_ID NUMBER := FND_API.G_MISS_NUM,
58 --R12 changes,Included to track rebuildables and asset numbers
59 EAM_ITEM_TYPE NUMBER := FND_API.G_MISS_NUM,
60 RCV_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
61 TRANSFER_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM);
62
63 TYPE MTL_ITEM_TBL_TYPE is TABLE OF MTL_ITEM_REC_TYPE INDEX BY BINARY_INTEGER;
64
65 TYPE MTL_TRX_TYPE is RECORD
66 (MTL_TRANSACTION_ID NUMBER);
67
68 PROCEDURE RECEIPT_INVENTORY(p_transaction_id IN NUMBER,
69 p_message_id IN NUMBER,
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC);
72
73 PROCEDURE MISC_RECEIPT(p_transaction_id IN NUMBER,
74 p_message_id IN NUMBER,
75 x_return_status OUT NOCOPY VARCHAR2,
76 x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC);
77
78
79 PROCEDURE MISC_ISSUE(p_transaction_id IN NUMBER,
80 p_message_id IN NUMBER,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC);
83
84 PROCEDURE PHYSICAL_INVENTORY(p_transaction_id IN NUMBER,
85 p_message_id IN NUMBER,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC);
88
89 PROCEDURE CYCLE_COUNT(p_transaction_id IN NUMBER,
90 p_message_id IN NUMBER,
91 x_return_status OUT NOCOPY VARCHAR2,
92 x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC);
93
94 PROCEDURE GET_RTV_TRANSACTION_RECS(p_transaction_id IN NUMBER,
95 x_mtl_item_tbl OUT NOCOPY CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_error_message OUT NOCOPY VARCHAR2);
98
99 PROCEDURE GET_TRANSACTION_RECS(p_transaction_id IN NUMBER,
100 x_mtl_item_tbl OUT NOCOPY CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE,
101 x_return_status OUT NOCOPY VARCHAR2,
102 x_error_message OUT NOCOPY VARCHAR2);
103
104 PROCEDURE DECODE_MESSAGE (P_Msg_Header IN XNP_MESSAGE.Msg_Header_Rec_Type,
105 P_Msg_Text IN VARCHAR2,
106 X_Return_Status OUT NOCOPY VARCHAR2,
107 X_Error_Message OUT NOCOPY VARCHAR2,
108 X_MTL_TRX_REC OUT NOCOPY CSI_INV_TRXS_PKG.MTL_TRX_TYPE);
109
110 PROCEDURE Check_item_Trackable(
111 p_inventory_item_id IN NUMBER,
112 p_nl_trackable_flag OUT NOCOPY VARCHAR2);
113
114 PROCEDURE get_asset_creation_code(
115 p_inventory_item_id IN NUMBER,
116 p_asset_creation_code OUT NOCOPY VARCHAR2,
117 p_organization_id IN NUMBER); --Added for Bug 13988660
118
119 PROCEDURE check_depreciable(
120 p_inventory_item_id IN NUMBER,
121 p_depreciable OUT NOCOPY VARCHAR2,
122 p_organization_id IN NUMBER); --Added for Bug 13988660
123
124 PROCEDURE get_master_organization(p_organization_id IN NUMBER,
125 p_master_organization_id OUT NOCOPY NUMBER,
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_error_message OUT NOCOPY VARCHAR2);
128
129 PROCEDURE build_error_string (
130 p_string IN OUT NOCOPY VARCHAR2,
131 p_attribute IN VARCHAR2,
132 p_value IN VARCHAR2);
133
134 PROCEDURE get_string_value (
135 p_string IN VARCHAR2,
136 p_attribute IN VARCHAR2,
137 x_value OUT NOCOPY VARCHAR2);
138
139 FUNCTION is_csi_installed RETURN VARCHAR2;
140 --PRAGMA RESTRICT_REFERENCES(is_eib_installed, WNDS, WNPS);
141
142 FUNCTION get_neg_inv_code (p_org_id in NUMBER) RETURN NUMBER;
143
144 --PRAGMA RESTRICT_REFERENCES(get_neg_inv_code, WNDS);
145
146 FUNCTION Get_Default_Status_Id(p_transaction_id IN NUMBER) RETURN NUMBER;
147
148 --PRAGMA RESTRICT_REFERENCES(get_default_status_id, WNDS);
149
150 FUNCTION Init_Instance_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Query_Rec;
151 FUNCTION Init_Instance_Create_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Rec;
152
153 FUNCTION Init_Instance_Update_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Rec;
154
155 FUNCTION Init_Txn_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Rec;
156
157 FUNCTION Init_Txn_Error_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec;
158
159 FUNCTION Init_Party_Tbl RETURN CSI_DATASTRUCTURES_PUB.Party_Tbl;
160
161 FUNCTION Init_Account_Tbl RETURN CSI_DATASTRUCTURES_PUB.Party_Account_Tbl;
162
163 FUNCTION Init_ext_attrib_values_tbl RETURN CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
164
165 FUNCTION Init_Pricing_Attribs_Tbl RETURN CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
166
167 FUNCTION Init_Org_Assignments_Tbl RETURN CSI_DATASTRUCTURES_PUB.organization_units_tbl;
168
169 FUNCTION Init_Asset_Assignment_Tbl RETURN CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
170
171 FUNCTION Get_Dflt_Project_Location_Id RETURN NUMBER;
172
173 --PRAGMA RESTRICT_REFERENCES(Get_Dflt_Project_Location_Id, WNDS);
174
175 FUNCTION Get_Location_Type_Code(P_Location_Meaning IN VARCHAR2) RETURN VARCHAR2;
176
177 --PRAGMA RESTRICT_REFERENCES(Get_Location_Type_Code, WNDS);
178
179 FUNCTION Get_Txn_Type_Id(P_Txn_Type IN VARCHAR2, P_App_Short_Name IN VARCHAR2) RETURN NUMBER;
180
181 --PRAGMA RESTRICT_REFERENCES(Get_Txn_Type_Id, WNDS);
182
183 FUNCTION Get_Txn_Type_Code(P_Txn_Id IN NUMBER) RETURN VARCHAR2;
184
185 --PRAGMA RESTRICT_REFERENCES(Get_Txn_Type_Code, WNDS);
186
187 FUNCTION Get_Txn_Status_Code(P_Txn_Status IN VARCHAR2) RETURN VARCHAR2;
188
189 FUNCTION Get_Txn_Action_Code(P_Txn_Action IN VARCHAR2) RETURN VARCHAR2;
190
191 FUNCTION Get_Fnd_Employee_Id(P_Last_Updated IN NUMBER) RETURN NUMBER;
192
193 FUNCTION Init_Instance_Asset_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.instance_asset_Query_Rec;
194
195 FUNCTION Init_Instance_Asset_Rec RETURN CSI_DATASTRUCTURES_PUB.instance_asset_Rec;
196
197 FUNCTION Init_Party_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.Party_Query_Rec;
198
199 FUNCTION get_inv_name (p_transaction_id IN NUMBER) RETURN VARCHAR2;
200
201 PROCEDURE log_csi_error(p_trx_error_rec IN CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC);
202
203 PROCEDURE create_csi_txn(px_txn_rec IN OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_REC,
204 x_error_message OUT NOCOPY VARCHAR2,
205 x_return_status OUT NOCOPY VARCHAR2);
206
207 PROCEDURE get_redeploy_flag(
208 p_inventory_item_id IN NUMBER
209 ,p_serial_number IN VARCHAR2
210 ,p_transaction_date IN DATE
211 ,x_redeploy_flag OUT NOCOPY VARCHAR2
212 ,x_return_status OUT NOCOPY VARCHAR2
213 ,x_error_message OUT NOCOPY VARCHAR2);
214
215 FUNCTION valid_ib_txn (p_transaction_id IN NUMBER) RETURN BOOLEAN;
216
217 PROCEDURE set_item_attr_query_values(
218 l_mtl_item_tbl IN CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE,
219 table_index IN NUMBER,
220 p_source IN VARCHAR2,
221 x_instance_query_rec OUT NOCOPY csi_datastructures_pub.instance_query_rec,
222 x_return_status OUT NOCOPY varchar2);
223
224 END CSI_INV_TRXS_PKG;