[Home] [Help]
PACKAGE: APPS.CSI_INV_TRXS_PKG
Source
1 package CSI_INV_TRXS_PKG as
2 -- $Header: csiivtxs.pls 120.4.12010000.1 2008/07/25 08:09:04 appldev 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
69 PROCEDURE RECEIPT_INVENTORY(p_transaction_id IN NUMBER,
70 p_message_id IN NUMBER,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC);
73
74 PROCEDURE MISC_RECEIPT(p_transaction_id IN NUMBER,
75 p_message_id IN NUMBER,
76 x_return_status OUT NOCOPY VARCHAR2,
77 x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC);
78
79
80 PROCEDURE MISC_ISSUE(p_transaction_id IN NUMBER,
81 p_message_id IN NUMBER,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC);
84
85 PROCEDURE PHYSICAL_INVENTORY(p_transaction_id IN NUMBER,
86 p_message_id IN NUMBER,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC);
89
90 PROCEDURE CYCLE_COUNT(p_transaction_id IN NUMBER,
91 p_message_id IN NUMBER,
92 x_return_status OUT NOCOPY VARCHAR2,
93 x_trx_error_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC);
94
95 PROCEDURE GET_TRANSACTION_RECS(p_transaction_id IN NUMBER,
96 x_mtl_item_tbl OUT NOCOPY CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_error_message OUT NOCOPY VARCHAR2);
99
100 PROCEDURE DECODE_MESSAGE (P_Msg_Header IN XNP_MESSAGE.Msg_Header_Rec_Type,
101 P_Msg_Text IN VARCHAR2,
102 X_Return_Status OUT NOCOPY VARCHAR2,
103 X_Error_Message OUT NOCOPY VARCHAR2,
104 X_MTL_TRX_REC OUT NOCOPY CSI_INV_TRXS_PKG.MTL_TRX_TYPE);
105
106 PROCEDURE Check_item_Trackable(
107 p_inventory_item_id IN NUMBER,
108 p_nl_trackable_flag OUT NOCOPY VARCHAR2);
109
110 PROCEDURE get_asset_creation_code(
111 p_inventory_item_id IN NUMBER,
112 p_asset_creation_code OUT NOCOPY VARCHAR2);
113
114 PROCEDURE check_depreciable(
115 p_inventory_item_id IN NUMBER,
116 p_depreciable OUT NOCOPY VARCHAR2);
117
118 PROCEDURE get_master_organization(p_organization_id IN NUMBER,
119 p_master_organization_id OUT NOCOPY NUMBER,
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_error_message OUT NOCOPY VARCHAR2);
122
123 PROCEDURE build_error_string (
124 p_string IN OUT NOCOPY VARCHAR2,
125 p_attribute IN VARCHAR2,
126 p_value IN VARCHAR2);
127
128 PROCEDURE get_string_value (
129 p_string IN VARCHAR2,
130 p_attribute IN VARCHAR2,
131 x_value OUT NOCOPY VARCHAR2);
132
133 FUNCTION is_csi_installed RETURN VARCHAR2;
134 --PRAGMA RESTRICT_REFERENCES(is_eib_installed, WNDS, WNPS);
135
136 FUNCTION get_neg_inv_code (p_org_id in NUMBER) RETURN NUMBER;
137
138 --PRAGMA RESTRICT_REFERENCES(get_neg_inv_code, WNDS);
139
140 FUNCTION Get_Default_Status_Id(p_transaction_id IN NUMBER) RETURN NUMBER;
141
142 --PRAGMA RESTRICT_REFERENCES(get_default_status_id, WNDS);
143
144 FUNCTION Init_Instance_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Query_Rec;
145 FUNCTION Init_Instance_Create_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Rec;
146
147 FUNCTION Init_Instance_Update_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Rec;
148
149 FUNCTION Init_Txn_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Rec;
150
151 FUNCTION Init_Txn_Error_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec;
152
153 FUNCTION Init_Party_Tbl RETURN CSI_DATASTRUCTURES_PUB.Party_Tbl;
154
155 FUNCTION Init_Account_Tbl RETURN CSI_DATASTRUCTURES_PUB.Party_Account_Tbl;
156
157 FUNCTION Init_ext_attrib_values_tbl RETURN CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
158
159 FUNCTION Init_Pricing_Attribs_Tbl RETURN CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
160
161 FUNCTION Init_Org_Assignments_Tbl RETURN CSI_DATASTRUCTURES_PUB.organization_units_tbl;
162
163 FUNCTION Init_Asset_Assignment_Tbl RETURN CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
164
165 FUNCTION Get_Dflt_Project_Location_Id RETURN NUMBER;
166
167 --PRAGMA RESTRICT_REFERENCES(Get_Dflt_Project_Location_Id, WNDS);
168
169 FUNCTION Get_Location_Type_Code(P_Location_Meaning IN VARCHAR2) RETURN VARCHAR2;
170
171 --PRAGMA RESTRICT_REFERENCES(Get_Location_Type_Code, WNDS);
172
173 FUNCTION Get_Txn_Type_Id(P_Txn_Type IN VARCHAR2, P_App_Short_Name IN VARCHAR2) RETURN NUMBER;
174
175 --PRAGMA RESTRICT_REFERENCES(Get_Txn_Type_Id, WNDS);
176
177 FUNCTION Get_Txn_Type_Code(P_Txn_Id IN NUMBER) RETURN VARCHAR2;
178
179 --PRAGMA RESTRICT_REFERENCES(Get_Txn_Type_Code, WNDS);
180
181 FUNCTION Get_Txn_Status_Code(P_Txn_Status IN VARCHAR2) RETURN VARCHAR2;
182
183 FUNCTION Get_Txn_Action_Code(P_Txn_Action IN VARCHAR2) RETURN VARCHAR2;
184
185 FUNCTION Get_Fnd_Employee_Id(P_Last_Updated IN NUMBER) RETURN NUMBER;
186
187 FUNCTION Init_Instance_Asset_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.instance_asset_Query_Rec;
188
189 FUNCTION Init_Instance_Asset_Rec RETURN CSI_DATASTRUCTURES_PUB.instance_asset_Rec;
190
191 FUNCTION Init_Party_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.Party_Query_Rec;
192
193 FUNCTION get_inv_name (p_transaction_id IN NUMBER) RETURN VARCHAR2;
194
195 PROCEDURE log_csi_error(p_trx_error_rec IN CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC);
196
197 PROCEDURE create_csi_txn(px_txn_rec IN OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_REC,
198 x_error_message OUT NOCOPY VARCHAR2,
199 x_return_status OUT NOCOPY VARCHAR2);
200
201 PROCEDURE get_redeploy_flag(
202 p_inventory_item_id IN NUMBER
203 ,p_serial_number IN VARCHAR2
204 ,p_transaction_date IN DATE
205 ,x_redeploy_flag OUT NOCOPY VARCHAR2
206 ,x_return_status OUT NOCOPY VARCHAR2
207 ,x_error_message OUT NOCOPY VARCHAR2);
208
209 FUNCTION valid_ib_txn (p_transaction_id IN NUMBER) RETURN BOOLEAN;
210
211 PROCEDURE set_item_attr_query_values(
212 l_mtl_item_tbl IN CSI_INV_TRXS_PKG.MTL_ITEM_TBL_TYPE,
213 table_index IN NUMBER,
214 p_source IN VARCHAR2,
215 x_instance_query_rec OUT NOCOPY csi_datastructures_pub.instance_query_rec,
216 x_return_status OUT NOCOPY varchar2);
217
218 END CSI_INV_TRXS_PKG;