[Home] [Help]
11: -- x_transmission_id Transmission id passed to the caller
12: -- x_return_status Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
13: -- Description :This Function takes input from the txn service and passes
14: -- the item data back. The item data is passed in the form of
15: -- of collection WSH_OTM_GLOG_ITEM_TBL thats maps to
16: -- GLOG Schema ITEMMASTER
17: -----------------------------------------------------------------------------
18: FUNCTION get_EBS_item_info( p_entity_in_rec IN WSH_OTM_ENTITY_REC_TYPE,
19: x_transmission_id OUT NOCOPY NUMBER,
17: -----------------------------------------------------------------------------
18: FUNCTION get_EBS_item_info( p_entity_in_rec IN WSH_OTM_ENTITY_REC_TYPE,
19: x_transmission_id OUT NOCOPY NUMBER,
20: x_return_status OUT NOCOPY VARCHAR2
21: ) RETURN WSH_OTM_GLOG_ITEM_TBL IS
22:
23:
24: --Bug#5961151: added substrb for item description as OTM can accept only 120 characters.
25: CURSOR c_get_delivery_items(p_delivery_id NUMBER) IS
78: SELECT wsh_otm_sync_ref_data_log_s.NEXTVAL
79: FROM dual;
80:
81: --Declare are local variables of GLOG record and table types
82: l_tbl_send_item_info WSH_OTM_GLOG_ITEM_TBL;
83: l_rec_itemmaster WSH_OTM_ITEMMASTER;
84:
85: l_rec_item item_info;
86: l_tbl_item item_info_tbl;
130: IF p_entity_in_rec.entity_id_tbl.COUNT = 0 THEN
131: RAISE e_null_id_error;
132: END IF;
133:
134: l_tbl_send_item_info := WSH_OTM_GLOG_ITEM_TBL();
135: --l_my_table := glog_item_tbl();
136:
137: --Get the new transmission Id
138: OPEN c_get_transmission_id;