APPS.INV_MOVE_ORDER_PUB dependencies on MTL_TXN_REQUEST_LINES

Line 729: SELECT MTL_TXN_REQUEST_LINES_S.NEXTVAL

725: --Bug 7148749, moving this after the loop, so that the new move order lines table
726: --l_new_trolin_tbl gets populated only when all the lines in x_trolin_tbl are validated.
727: /* ELSE --} {
728: --print_debug('in insert',l_api_name);
729: SELECT MTL_TXN_REQUEST_LINES_S.NEXTVAL
730: INTO x_trolin_tbl(l_index).line_id
731: FROM DUAL;
732: x_trolin_tbl(l_index).status_date := SYSDATE;
733: x_trolin_tbl(l_index).creation_date := SYSDATE;

Line 920: SELECT MTL_TXN_REQUEST_LINES_S.NEXTVAL

916:
917: If l_debug = 1 THEN
918: print_debug('Creating MO Line for WDD = '||x_trolin_tbl(l_index).txn_source_line_detail_id,l_api_name);
919: End If;
920: SELECT MTL_TXN_REQUEST_LINES_S.NEXTVAL
921: INTO x_trolin_tbl(l_index).line_id
922: FROM DUAL;
923:
924: x_trolin_tbl(l_index).status_date := SYSDATE;

Line 1960: UPDATE mtl_txn_request_lines SET

1956: , p_move_order_line_tbl IN inv_move_order_pub.num_tbl_type
1957: ) IS
1958: BEGIN
1959: FORALL i in 1..p_move_order_line_tbl.count
1960: UPDATE mtl_txn_request_lines SET
1961: carton_grouping_id = p_carton_grouping_tbl(i)
1962: WHERE line_id = p_move_order_line_tbl(i);
1963: END stamp_cart_id;
1964: