APPS.INV_MOVE_ORDER_PUB dependencies on MTL_TXN_REQUEST_LINES

Line 779: SELECT MTL_TXN_REQUEST_LINES_S.NEXTVAL

775: --Bug 7148749, moving this after the loop, so that the new move order lines table
776: --l_new_trolin_tbl gets populated only when all the lines in x_trolin_tbl are validated.
777: /* ELSE --} {
778: --print_debug('in insert',l_api_name);
779: SELECT MTL_TXN_REQUEST_LINES_S.NEXTVAL
780: INTO x_trolin_tbl(l_index).line_id
781: FROM DUAL;
782: x_trolin_tbl(l_index).status_date := SYSDATE;
783: x_trolin_tbl(l_index).creation_date := SYSDATE;

Line 970: SELECT MTL_TXN_REQUEST_LINES_S.NEXTVAL

966:
967: If l_debug = 1 THEN
968: print_debug('Creating MO Line for WDD = '||x_trolin_tbl(l_index).txn_source_line_detail_id,l_api_name);
969: End If;
970: SELECT MTL_TXN_REQUEST_LINES_S.NEXTVAL
971: INTO x_trolin_tbl(l_index).line_id
972: FROM DUAL;
973:
974: x_trolin_tbl(l_index).status_date := SYSDATE;

Line 2010: UPDATE mtl_txn_request_lines SET

2006: , p_move_order_line_tbl IN inv_move_order_pub.num_tbl_type
2007: ) IS
2008: BEGIN
2009: FORALL i in 1..p_move_order_line_tbl.count
2010: UPDATE mtl_txn_request_lines SET
2011: carton_grouping_id = p_carton_grouping_tbl(i)
2012: WHERE line_id = p_move_order_line_tbl(i);
2013: END stamp_cart_id;
2014: