APPS.GMI_PICK_RELEASE_PUB dependencies on IC_TRAN_PND

Line 53: from IC_TRAN_PND

49:
50: -- HW BUG#:1941429 cross_docking
51: CURSOR FIND_QTY (l_source_line_id NUMBER)IS
52: select sum(ABS(trans_qty)), nvl(ABS(sum(trans_qty2)),0)
53: from IC_TRAN_PND
54: where line_id = l_source_line_id
55: AND completed_ind = 0
56: AND delete_mark = 0
57: AND lot_id <> 0

Line 63: from ic_tran_pnd

59:
60: -- HW BUG#:1941429
61: CURSOR get_trans_id (l_source_line_id NUMBER) IS
62: select trans_id
63: from ic_tran_pnd
64: where line_id = l_source_line_id
65: AND completed_ind = 0
66: AND delete_mark = 0
67: AND staged_ind = 0;

Line 274: -- Need to find the record in delivery_details to map it to OPM ic_tran_pnd

270: -- Need to check lines that are approved and pre-approved (status 3 and 7)
271:
272: IF ( l_mo_line.line_status <> 5 ) THEN
273: gmi_reservation_util.println('In Auto_detail GMIPPKRB move order <> 5 ');
274: -- Need to find the record in delivery_details to map it to OPM ic_tran_pnd
275: BEGIN
276: gmi_reservation_util.println('In Aut_detail Going to select line_id from shipping');
277: select source_line_id,delivery_detail_id into
278: l_source_line_id, l_delivery_detail_id

Line 290: gmi_reservation_util.println('In Auto_detail going to sum qty from ic_tran_pnd');

286: ( p_count => x_msg_count
287: , p_data => x_msg_data
288: );
289: END ;
290: gmi_reservation_util.println('In Auto_detail going to sum qty from ic_tran_pnd');
291: gmi_reservation_util.println('In Auto_detail value of l_delivery_detail_id '||l_delivery_detail_id);
292: gmi_reservation_util.println('In Auto_detail value of l_source_line_id '||l_source_line_id);
293: gmi_reservation_util.println('In Auto_detail value of l_quantity '||l_quantity);
294:

Line 317: GMI_RESERVATION_UTIL.PRINTLN('Error retrieving trans_id from ic_tran_pnd');

313: OPEN get_trans_id (l_source_line_id);
314: FETCH get_trans_id into l_trans_id;
315: IF (get_trans_id%NOTFOUND ) THEN
316: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
317: GMI_RESERVATION_UTIL.PRINTLN('Error retrieving trans_id from ic_tran_pnd');
318: RAISE NO_DATA_FOUND;
319: CLOSE get_trans_id;
320: RETURN;
321: END IF;

Line 329: GMI_RESERVATION_UTIL.PRINTLN('Error retrieving info from ic_tran_pnd');

325: OPEN FIND_QTY(l_source_line_id);
326: FETCH FIND_QTY into l_transaction_quantity, l_transaction_quantity2;
327: IF ( FIND_QTY%NOTFOUND ) THEN
328: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
329: GMI_RESERVATION_UTIL.PRINTLN('Error retrieving info from ic_tran_pnd');
330: RAISE NO_DATA_FOUND;
331: CLOSE FIND_QTY;
332: RETURN;
333: END IF;

Line 335: gmi_reservation_util.println('Done getting info from ic_tran_pnd and value of l_transaction_quantity is '||l_transaction_quantity);

331: CLOSE FIND_QTY;
332: RETURN;
333: END IF;
334:
335: gmi_reservation_util.println('Done getting info from ic_tran_pnd and value of l_transaction_quantity is '||l_transaction_quantity);
336: CLOSE FIND_QTY;
337:
338: gmi_reservation_util.println('In Auto_detail value of l_quantity '||l_quantity);
339: