DBA Data[Home] [Help]

APPS.GML_BATCH_OM_UTIL dependencies on GML_BATCH_SO_ALLOC_HISTORY

Line 241: l_history_row gml_batch_so_alloc_history%rowtype;

237: , X_msg_cont OUT NOCOPY NUMBER
238: , X_msg_data OUT NOCOPY VARCHAR2
239: ) IS
240: l_alloc_rec_id NUMBER;
241: l_history_row gml_batch_so_alloc_history%rowtype;
242: l_history_rec GML_BATCH_OM_UTIL.alloc_history_rec;
243: BEGIN
244: x_return_status := FND_API.G_RET_STS_SUCCESS;
245: IF p_alloc_history_rec.alloc_rec_id is not null THEN

Line 248: from gml_batch_so_alloc_history

244: x_return_status := FND_API.G_RET_STS_SUCCESS;
245: IF p_alloc_history_rec.alloc_rec_id is not null THEN
246: Select *
247: Into l_history_row
248: from gml_batch_so_alloc_history
249: Where alloc_rec_id = p_alloc_history_rec.alloc_rec_id;
250: END IF;
251: l_history_rec.Batch_id := l_history_row.batch_id;
252: l_history_rec.Batch_line_id := l_history_row.batch_line_id;

Line 286: Insert Into gml_batch_so_alloc_history

282: GMI_RESERVATION_UTIL.println('inserting alloc history');
283: select gml_so_alloc_history_s.nextval
284: into l_alloc_rec_id
285: from dual;
286: Insert Into gml_batch_so_alloc_history
287: ( Alloc_rec_id
288: , Batch_res_id
289: , Batch_id
290: , Trans_id